Hi all
New post can be found here: http://wotlankor.com/?p=572
All below is outdated…
In my posts I use killboards a lot to depict battles and other observations. Often to underline a statement or go give an idea of an engagement. The killboard has its errors and do not always depict the battles and especially a situation correctly, but they are still a valuable tool. However U’K does not allow for a public killboard which really is a shame as the performance is so much better than most alliances. I understand that a lot of information can be taken from a killboard such as fittings, areas of operation and much more.
In the following I will try to set up a killboard and link it so only my own kills get syndicated. Before embarking do note that I take no responsability for any damages that may incur using any of the programs or instructions in the following. I assume some basic knowledge about uploading and hosting. If you have questions the make a comment and ill try to elaborate as needed. I have not tried this before so the post is typed as I go along and may be updated over a few days depending on my success and failures.
Im not quite sure yet if this will turn into a small collection of guides for out of game use or simply a stand alone post but in any circumstance lets get the show on the road.
First to find a killboard can be hard as the EvE-Dev team that hosts and keep it updated has moved hosts and domains recently and their own Wiki is not of much use. I have now updated the page with a download header and a link now shows. Secondly they dont do a very good job when it comes to the novice. Very confusing if you dont know PHP, MySQL and SVN imports. Why in EvE is there not a link to this information in the “About” page on every Killboard ?
IF THE FOLLOWING IS OF ANY USE PLEASE LEAVE A COMMENT AS IT WILL DETERMIN IF I WILL MAKE ADDITIONAL TUTORIALS OR GO BACK TO REGULAR POSTS.
After a good deal of searching I found the actual post on their forum where the killboard link is located.
Get the killboard
http://eve-id.net/forum/viewtopic.php?f=503&t=13634
http://svn.nsbit.dk/itemfetch/killboard.tar.gz.php
Download that file to your desktop.
What we end up with is a so called tar.gz file format also called a tarball that can’t be opened straight out of the box.
We need a decompressor.
There are several options and WinZip is the most commonly used. Ive downloaded that trial version a number of times but now I want a more parmanent solution that dont cost me a buck.
I went to http://www.gzip.org and downloaded the powarc61.exe and installed it
Next create a folder on your desktop and named it “kb”.
Run the installation and your tar.gz file now get a nice little icon and you can extract it by double clicking the file and choosing Extract. Choose your desktop and the folder kb to be target destination and click extract in the far right.
In the kb folder you will find the read me text.
This is the EDK – EVE Development Network Killboard v1.4 – Trinity Edition
Requirements:
- Webserver (apache)
- PHP 4.0.9+
- Mysql 3.23.+
- GD 2 or higher
Setup:
- Upload the whole package to a webhost
- Point your webbrowser to /install inside the EDK-Directory
- Follow the instructions
- Don’t forget to delete the install folder after installation or restrict the access to it!
- Have fun 
So we need to upload the kb folder to our webhost
I use the plug-in ftp in Firefox called FireFTP but by all means use any ftp program you like or feel comfortable with.
The kb folder is 34 MB large so depending on your connection it will take some time…
Chop, chop lads, go get a nice cup of tea…
Now we should be ready to install but no, trial and error has taught me that we need an updated database as the current version dont take the killmails.
Therefore go here and download the QR package
http://eve-id.net/forum/viewtopic.php?f=503&t=13427&start=0
http://eve-files.com/dl/182688
Go your kb directory on your web host
In the folder called Packages (found at yourdomain.com/kb/packages) is a folder called database.
Delete the folder “database”.
Upload the QR package to the folder packages.
A new folder should now be there called database. (yes it has same name as the one we just deleted, but that is what makes it all work)
Ready ?, Well let’s proceed then.
Do not open any webbrowser ! Use Internet Explorer as I have found that to work.
After two days of messing about I switched browser (Im a dedicated FF fan) and everything loaded perfectly.
Go to the url http://www.yoursite.com/yoursubdomain/install
Click Next step
Ohh ohh some file is missing
I copied the file name created a new file with that name and put it in the kb directory and refreshed the browser window.
It even compliments me !!
Click Next Step
Supply the missing info.
You should be able to get that from your ISP or webhost.
Click test
YAY ! That program really likes me !
Click Next Step
Ill be damned some database tables aint created…
Well click the Creating Tables link
There the love stopped ! FAIL FAIL FAIL !!!
But then again not quite. I opted to go for the Importing data (im sure I will need anything I can get my hands on so Ive imported everything). After some trial and error ivefound it is paramount to import. One of them will fail but you will get rid of a lot of the errors I had to begin with.
If you opt to import the data be aware it takes time. Get a new cup of tea.
Now is the time to type in the corp info from your current corporation.
I have typed in Mirkur Draug’Tyr
Im not sure if that is correct but here we go. It is not found in the database but I just create it then.
Next is the general settings for the killboard.
All done and on to the next step !
Next it shows a php scribt which it tells me is perfect. (it likes me again).
HOME SAFE !
Click the “your new killboard link” and go delete the install folder in your /kb directory.
And there we have it !
A brand new killboard is up for me to play with.
Hope you enjoyed this small trip / tutorial. If I get time and feel like it I will make a post about how to syndicate stuff with other killboards and so on. Never tried that either but one simply has to plunge into it all.
See you in space
Wotlankor
Thank you SO much! You’ve no idea how useful this is….I deleted my old KB ( I have a backup of the DB) as I could not figure out how to update it. Your step there about the updating seems to have done the trick.
lol if only I could make it work myself
Yea well now I am having trouble importing old kills….One question…and forgive the idiot way of asking but how do I update the DB? I am not a SQL guy and such I was wondering if there was an easier way. Seeing as I do not know too much about SQL…the only change i made to your directions was deleting the database files+ putting the edk on them BEFORE I uploaded ( saved on bandwidth) I am getting a stupid error message ( i saw your posting as well) so we are kinda in the same boat i’d imagine.
aye
Just PMed ya on the board
Hot fix
Go to http://eve-id.net/forum/viewtopic.php?f=503&t=13919
Download the new database
Unpack it
Open PHPMyAdmin
Delete the tables that are show in the new database update (tick them off and choose delete at the bottom)
Import the new tables fromhe import option in the top
Now the only problem is that dropped items does not show but I will solve that tonight I hope. Maybe…
I have same problem as you…. both dropped and destroyed cause an error. Thanks for the tips too bro they helped. My kills are actually posted but the errors seem troublesome.
Fixed it.
download the EDK_QR_Install packages_v1.5
Open the PHPMySQL and import eh table into the DB…( i didn’t have the table Item_locations )
Copy the Class parser.php fried has in his signature to your content/includes folder edit the file in three places to replace “Cargo” with the integer ’4′
Should be good to go then!
You use Firefox right ?
I used IE and it just worked, no problems.
With IE it creates the database perfectly and populates it.
I know the whole point of this was to setup a public killboard, but they do give away a lot of info… how would you go about making one of these private?
I am not sure but the FireFTP can set restictions on certain folders.
That would be one way to go about it.
Else you would have to run some sort of permission and that would be easiest to do with a forum but I am clueless as to how.
Ill look into it though and see if I can find a solution.
Definitely enjoyed and I’m very much looking forward to the syndication info. I have my own KB as well that I’ve set up and I got this far, but not sure where to go next with it.
I keep getting errors that look like the following on my killboard
Warning: error with destroyed item. in www/cw/killboard/common/includes/class.kill.php on line 848
object(DestroyedItem)#63 (3) { ["item_"]=> object(Item)#42 (1) { ["id_"]=> string(3) “206″ } ["quantity_"]=> string(5) ” 1327″ ["location_"]=> string(5) “Cargo” }
Any clue on where to start looking to fix that?
Yes the problem is your database.
I believe the location to be (4) “Cargo”
So you need to update the database.
Hmm, trying to set up a killboard but I’m a total newbie when it comes to mySQL, PHP and these things.
I managed to get the installer up and going, with the same errors as you. However it never directed me to the site, instead just to my root with a message from my host saying I didn’t have an index.html file.
So I deleted the mysql database, user and whatnot. Dabbled with alot of things, I then realised that it probably would’ve worked if I just had added index.php to the root url. But now I just get an error message along the lines of,
Warning: require_once(kbconfig.php) [function.require-once]: failed to open stream: No such file or directory in /home2/sajt/public_html/common/index.php on line 24
If I try to reinstall it I just get back to the last page of the installer, I’m not sure how I reset the installer.
Have you got any pointers for me?
Hi Psir
The Index file should be created just fine.
Let me know if that problem still persist.
Before you run the installation you create the file called kbconfig.php and make sure it is writable (it should be pr default). Then when you run the installer it can write to the config file and the installment should be good to go.
Let me know if it works for you.
I remember creating the kbconfig file during the installation, it didn’t work for me at that time however. Since then I’ve deleted the files multiple times, I remade the kbconfig.php and now it does seem to direct me to the killboard.
However it can’t connect to the MySQL database now, probably because I’ve been removing the files and the MySQL killboard database in the process of troubleshooting.
I believe this may all be fixed if I could just get the installer going again, however, nomatter what I seem to do I’m only be redirected to the last page of the installer (step
if I browse into the /installer folder. How can I reset it?
Try to clear your cache or simply use another browser and reinstall it all one more time.
The database will most likely get it wrong but dont just delete away in it.
You can update each table seperately.
Resetting the browser cache worked (didn’t think it was saved client side).
The installer run pretty much like the last time but now the index file works. However the killboard still won’t work for whatever reason, likely it has to do with my MySQL settings or something.
You should be able to see the error message below,
http://psir.nxserve.net/
Resetting the browser cache worked (didn’t think it was saved client side).
The installer run pretty much like the last time but now the index file works. However the killboard still won’t work for whatever reason, likely it has to do with my MySQL settings or something.
You should be able to see the error message below,
http://psir.nxserve.net/
- Thanks for the help, it’s really appriciated. This is a new area to explore for me so it’s all very interesting.
Query failed. Table ‘sajt_Killboard.kb3_ship_classes’ doesn’t exist
its your database ship_classes that is wrong
All you need to do is update that table.
Use PhP my admin and make an import
See my previous comment:
Hot fix
Go to http://eve-id.net/forum/viewtopic.php?f=503&t=13919
Download the new database
Unpack it
Open PHPMyAdmin
Delete the tables that are show in the new database update (tick them off and choose delete at the bottom)
Import the new tables fromhe import option in the top
Hey, there’s definitive improvement! It’s still pretty borked though. Some parts of the killboard are now visible but something’s not right with the class.db.php file.
Browsed around eve-id.net forums but couldn’t find anything conclusive.
- In the end I got it up and running!
Thanks for all the help!
Hi,
I follow your great tuto (
) ) and unfortunately, i have those issues :
Warning: preg_match() [function.preg-match]: Compilation failed: repeated subpattern is too long at offset 18454 in /home/www/f4a1540aaea003a6d14d2351c1129ec4/web/killboard/common/smarty/Smarty_Compiler.class.php on line 454
Fatal error: Smarty error: [in killlisttable.tpl line 1]: syntax error: unrecognized tag: section name=day loop=$killlist (Smarty_Compiler.class.php, line 455) in /home/www/f4a1540aaea003a6d14d2351c1129ec4/web/killboard/common/smarty/Smarty.class.php on line 1092
Can you help me please ?
Thank you very much.
Regards
Hi Sasha
It looks to me like the compiler it self has installed incorrectly.
Also the url seems unexplainable long.
I would redownload the files and reinstall.
Maybe install on the very domain first to test before installing on a subdomain.
But I must admit I am out of my water on the issue.
Let me know how it works out.
Hi
I re-dl the files as you advice me, i replace the two files incriminated, and it works now
Thank you for your time.
PS : Great tuto really.
No problem.
Hi nice giude but….
i have no exp with web pages so thought i would give it a go. I uploaded everything fine to my “virgin media site ” [blueyonder] and when i try to use the url is just fails with a 403 error. Can the kb be put on virgin media sites?
how can i setup users i get thos error
User – Registration
Error
Registration has been disabled.
Hi David
I have been really slack when it came to my killboard and have not updated it since UK has finaly made their KB public.
I will make a new post (I hope) where I go over all the new stuff including a new walkthrough of installing.
Thanks a ton for the help. The only problem I’m having now is not being able to sync with the “http://sync.eve-dev.net/?a=sync_server” is this just down or do i have to set something up?
I am stuck at Step 2, the config part. I have uploaded the “kbconfig.php” file and changed permissions to 777 with FileZilla. Cleared my cache and still getting the same message “Please create the file ‘kbconfig.php’ and make it writeable by the webserver.” I did this several times to no avail. Was changing the kbconfig file permissions correct?
try permission 644 should work
Didn’t work. Should the kbconfig.php file be empty and in the kb directory?
[...] of all they have really gotten their act together since my last visit to their wiki and first thing I am promted with is a “install instruction” that tell me to go [...]