Creating the Database

Please ensure you have read Killboard Installation Tutorial Part 1 before proceeding with this article.

At this stage you should be confident your website is capable and ready to install the Killboard.

The first thing to do is unzip the Killboard file you downloaded and save the unzipped or untarred files into a directory on your PC. It doesn't matter what you call this directory but it is simpler if you name it KBXXX or KBverxxx where xxx is the version number to distinguish from future release versions. So long as you note what you have used it is entirely up to you. For this tutorial procedure we will use EDK315 as the directory name.

Now connect to your web space with your FTP package and locate the directory where you have stored the unzipped Killboard files on your PC. Similarly navigate to the directory on your web space where you intend to store the Killboard files. This will likely be at the root of your web site e.g. var/www/html/

With FileZilla you can simply drag the directory from the local PC over to the destination directory on your web space and the upload will begin. Alternatively, right click on the directory in your local PC and select 'upload'.

There are a lot of files to upload (over 12000) so this will take a few minutes depending on the speed of your connection - you will see the upload status at the bottom of the FileZilla screen.

In our case we are uploading to the var/www/html directory.

Wait until the upload is complete and then open your web browser and start the online installation using: http://www.example.com/EDK315/install/

Within the install directory is a file named index.php which will be automatically loaded into the browser and it is this file which will start the installation process. There is no need to specify the index.php file as the web browser will detect it automatically and load it.

This screen shot shows you the first installation screen:

Install Step 1

Here you will see the Welcome screen which details the requirements needed for the installation. Click on the 'Next Step' link and the software will begin a verification process to test if all these requirements are met.

Install Step 2

This page is divided into 4 sections which detail the results of this test. The Graphics section confirms if you have GD available. The Directory Structure section confirms the permissions and installation of certain files and directories. The connectivity section confirms that the option 'ON' is set for allow_url_fopen.

Install Step 2 - Setting kbconfig.php permissions

Finally the Config section now asks you to create the file kbconfig.php and set the permissions to writeable. Open FileZilla (or whatever FTP package you use) and connect to your web space. You should find a file (called blank_kbconfig.php) was uploaded to the root directory of your Killboard when you copied all the files to your web space and you can now rename this to kbconfig.php - simply right click and select rename.

In FileZilla right click again on the kbconfig.php file in your web space directory and select 'File Permissions'. Normally you won't have to modify these but if you do then set to the screen example.

The file kbconfig.php now exists in your web space and the permissions are now set. Go back to your web browser and refresh the page - usually a 'Refresh' or 'Reload' option button is available in the browser.

Install Step 2 - File found and writeable

The screen should update and the Config section should now confirm the kbconfig.php file has been found and it is writeable. Click on the 'Next Step' link

Install Step 3

This section deals with the configuration of your database and is where you now need the database name and your login details.

MySQL Host: can be set to 'localhost' or 127.0.0.1 - we recommend 127.0.0.1 but check with your web host service
User: Your user name which you set when creating the database
Password: Your password which you set when creating the database
Databases: The name you applied to your database when creating it.
Engine: Two options here are 'InnoDB' and 'MyIsam'. We set our option to 'MyIsam' but you can see what applies to your database in your database control panel your web host provides - they may provide you with a utility such MyPHPAdmin and in there you can see what is the preferred database engine. Generally MyIsam will not cause you any issues so you can set to this and click on the 'Test' button of the Killboard install to see the results.

Click on 'test' and all being well the installation will report back that it has successfully connected to the database and will also display the MySQL version you are using.

Click on the 'Next Step' link

Install Step 4

At this stage the installation procedure is creating the tables within the database and you will see them listed as in the screenshot below. The final line may say 'some table structures have to be added. Please create them'. Click on the 'create them' link to proceed to the next stage.

Install Step 4 - Failed tables

This screen shot shows you that some of the tables have 'Failed' as the program has still to complete the import of optional data and this will be presented to you in the next stage. Click on the 'Importing Data' link at the top of the screen to proceed

Install Step 4 - Optional SQL data

This screen shot shows the prompt to import the data. Although it states 'optional' there really isn't a choice here.. Click on OK

Install Step 4 - Data import

If you are using the Firefox browser it is possible it will block the automatic reloading of the screen as each file is imported. Click on 'Allow' for each request

Install Step 4 - Import complete

This screen shot shows the import has completed successfully. Click on 'next step'

Install Step 5 - Corporation/Alliance setup

The next stage is to search for your Corporation or Alliance. It is very important you use the exact spelling of your Corporation or Alliance. If you don't have a corporation or alliance then pick a name and click on Search. This will then start a routine to create a new name if it doesn't already exist - if it does exist then you have picked a name for an existing corp/alliance so try again.

Install Step 6 - Site Settings

At this stage you are now configuring the Killboard settings and usually it will only be the first three settings you need to modify or supply. The urls are generally correct but you may wish to change them - there needs to be a good reason to change so be careful here. Click on 'Save' when you are ready

Adminpassword: Set a password to use. This should be different from the database password you used earlier.
Title: Generally you would use the name of your Corporation or Alliance here.
Site: This is an identifier within the site and your corporation 'ticker' could be used here.

Install Step 7 - Final report

This is now the contents of the kbconfig.php file and you will see it contains the database details such as login and and password. Also at the top of this screen you will see the permissions have been changed - this file is no longer writeable.

Install Step 8 - Installation Complete

It is VERY important that you now delete the 'install' folder from your web space or at the very least you should rename the folder or change its permissions to restrict access. This can be done from FileZilla.

View your Killboard

Click on the 'your new Killboard' link to view the Killboard for the first time. This screen shot shows you the new Killboard installation. The kills will be blank as you have not input any data yet but the Killboard has installed successfully and is waiting for data.

Now you have details of your Killboard configuration and a list of 'Options' available - its Playtime :)

Go through all the options to discover what they do. There is no need to change anything until you are confident on their purpose but you can familiarise yourself with what each option does.

In due course you will need to make changes here so now is the time to do a little research. The actual setup of your Killboard site is beyond the scope of this article but most of the options shown are pretty self explanatory. If you are not sure then there are help forums available such as the Eve-Dev Forum

Have fun with your site and now you need to go on a killing fest to fill up your Killboard - good luck!

• Add New
• Search
• RSS

Comments (1)

• 2011-07-19 18:28:42 | | Come Play Eve  - Excellent tutorial

  Great tutorial, KB's made easy!

  Thanks for the info!

  • 0
  • 0

  ReplyQuote

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Website:

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.

Joomla components by Compojoom