Skip to content
User friendly web page for searching information about animals on Tarkin's Revenge
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
img
.gitingore
LICENSE
README.md
Tarkin_Creatures.sql
Tarkin_Creatures.xlsx
a01.php
a010.php
a011.php
a012.php
a02.php
a03.php
a04.php
a05.php
a06.php
a07.php
a08.php
a09.php
advsearch-input.php
advsearch-output.php
creaturepage.php
dbinfo.php
design-bottom.php
design-sidebar.php
design-top.php
functions_after.php
functions_before.php
index.php
q01.php
q010.php
q011.php
q012.php
q02.php
q03.php
q04.php
q05.php
q06.php
q07.php
q08.php
q09.php
sortbyletter.php
sortbyplanet.php
style.css

README.md

Tarkin's Revenge Creature Database

This is a SQL database driven web page that allows players to view and gather infomration about the various animals on the Tarkin's Revenge server. We felt it was neccasary to create this user friendly tool, due to the vast amount of updates and improvements that we've made to the creatures on Tarkin's Revenge.

Visit the live site here!

Development Status

May 21st, 2019
The software is functionally complete, however I have not yet finished taking pictures of all the critters. Creature images will be added in batches over time, to the maximum extent of my sanity.

Requirements

  • SQL compatible database server (such as MariaDB).
  • Web server with PHP7 and the SQL addon for PHP (php7.0-mysql package in Debian).
  • Created using Devuan Linux 2.0, Apache 2.4.25-3, PHP 7.0.33, Geany 1.33, GIMP 2.8.22

Credits

Installation Instructions

  • Install your operating system, web server, and database software. Add PHP 7 and its MYSQL addon, as noted in the requirements section.
  • Setup your database. This example is valid for 10.1.38-MariaDB for Debian Linux.

In a terminal type:

sudo mysql_secure_installation

Say "yes" to all the prompts and set the root user password. This initialized MYSQL (on a Debian-based system).

In a terminal type:

echo 'CREATE DATABASE creatures;' | sudo mysql -uroot -p123456

Where -p123456 is the password you set for the root user. This creates the database.

In a terminal type:

echo 'GRANT ALL ON . TO youLocalUserName@localhost IDENTIFIED BY "123456";' | sudo mysql -uroot -p123456

Where youLocalUserName is your Linux user account and 123456 is your password. This grants your Linux user account access to the database.

In a terminal type:

mysql -uMyName -p123456 -e source -e Tarkin_Creatures.sql

Finally, this populates the database with the creature data.

  • Create a new directory on your website where the page will be hosted, such as creaturedb. This will show to the outside world as mywebpage.com/creaturedb/

  • Download this repository, extract it to the creaturedb directory you made above, and edit the dbinfo.php file so that it contains your linux user name and your database password.

  • Extra: If you are concerned about the security of your SQL database and you're using an Apache web server, you can move the dbinfo.php file to a directory called "include", and change the path to it in all the files where it is referenced from

Advanced Search
``` If you have a look at advsearch-input.php, you will find that it has all the standard bits and bobs for an HTML form and that submitting the form points to the advsearch-output.php file. Your new setup for searching the Bio-Engineer crafting data would be built the same way, just with different form content and handling of the query variables. Otherwise, it would largely be the same as the code used for the advanced search, because at the end of the day all you are really doing is
  1. Using the form input to build an SQL query.
  2. Displaying the results of the query to the user in a human readable format.

As far as adding the Bio-Engineer crafting data to the creature's "hockey card" page, that only requires some thought as to where to place it on the page and then adding the results handling in the same manner as the other data on the page. For that page the query is already configured to grab all data columns for the given creature name, so you'd really just have to put the code in to display it (using the existing code as an example of how to do so).

Current Screenshots

Quick Questions

Quick Answer

Advanced Search

Development Screenshots

Still in development

Still in development

Still in development

You can’t perform that action at this time.