| Pages: [1] 2 3 4 :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Kale Kold
Caldari
Mortis Angelus
The Church.
   |
Posted - 2009.04.10 00:23:00 -
[1]
Edited by: Kale Kold on 10/04/2009 00:25:08
Pirate Ledger v1.0b (Pirate killboard)
Requirements:
MySQL 5+
PHP 5+ (with GD extension loaded)
Reason:
When leading a pirate corporation its always a major pain in the ass to figure out who killed what and how much loot everyone is entitled to. The main idea behind this ledger is that ALL captured loot from ALL kills is put into a loot hangar in the corporations hangar. Then the loot is tracked via the ledger. At the end of a week/day or a particulaly good few hours you can then collect the loot from the hangar and sell it on. Then use the ledger as a guide to decide how much ISK everyone is to be paid out. Once the payments are made the balances can be wiped from the ledger. All prices on the ledger can be updated to reflect current market values. There is an inbuilt corporation tax added in the admin section to offset loot 'mislaid' or not recovered from a kill. There is also the option of adding pilots to kills that do not appear on the killmail. This is to be fair to scouts or squad members that missed a juicy target.
Features:
1). Tracks the price of all EVE Online items.
2). Tracks the price of all dropped loot/items and splits it amongst the kill squad.
3). Offers a convenient way of tracking how much needs to be paid to each killer.
4). Tracks all members' kills and losses.
5). Uses EVE Central to get updated prices for items.
6). Provides ranking statistics.
7). Shows a daily performance graph.
8). Add pilots to records who do not appear on killmails.
9). Three access levels, Admin, User and Guest.
Installation:
1). Create a database on your MySQL server and import the 'tables.sql.zip' file to it to create the tables.
2). Edit the 'includes/class.database.php' file and alter the member variables to reflect your server address, name, username and password. There are also variables for which control the display if there is a server error such as site name and admin email to recieve error messages.
Usage:
1). Log in as user: admin password: admin
2). Go to the administration section by clicking the link on the navigation bar.
3). Click on the 'Edit Corporations' link and add the corporation to be tracked and specifiy a tax amount. Roughly 20% is sufficient.
4). Go to the main page and click the 'Add Killmail' link to expose the input field.
5). Paste in the killmail and click 'Add'.
6). Add more users in the administration section to allow other people to use the board.
Notes:
1). All portraits have to be added manually and must be in jpeg format. These must be put in the 'images\portraits\32' and 'images\portraits\128' folders in 32 and 128 pixel square resolutions respectively.
2). The 'Update Database' link in the 'Administration' section is used to re-create the database indexes and increase the query speed of the database. This may have to be done from time to time to keep the database snappy.
3). The 'Backup Database' link in the 'Administration' section is an absolute link to an install of phpMyBackupPro available from here: http://www.phpmybackuppro.net/
Todo:
This release does not contain Apocrypha database details.
It could do with a bit of SQL query optimisation.
Maybe an automagic way of adding portraits could be added.
Demo:
http://www.kalekold.net/eve/brutal/killboard/
Download:
http://www.kalekold.net/eve/Ledger.zip (37Mb)
This project is pretty much abandoned at the minute and no further development is being undertaken by me so i've released this as open source under the GPL. See License.txt for details. Although it is unfinished, this killboard is fully working and was used for a pirate corp successfully for months (see the above demo link.) This thread the main contact point regarding this project.
|
Spectre3353
Gallente
The Python Cartel.
The Gurlstas Associates
|
Posted - 2009.04.10 12:07:00 -
[2]
Looks pretty good but I was really hoping to see ransoms integrated into the KB.
-----
The Python Cartel Is Recruiting! - My Pirate Blog |
Hoggs
Heretic Army
Heretic Nation
|
Posted - 2009.04.10 12:17:00 -
[3]
Downloading now, looks damn nice. Did you develop this all yourself?
|
Kale Kold
Caldari
Mortis Angelus
The Church.
|
Posted - 2009.04.10 13:37:00 -
[4]
Yep i developed the lot. Infact i developed as a way of learning MySQL. 
To answer the other question, I was actually considering adding ransoms but while planning it became clear it was too open for abuse. For example i could enter that i had recieved 1 billion ISK ransom when i really hadn't but who's to know otherwise, no-one can see my wallet. So that feature was left out.
|
Hoggs
Heretic Army
Heretic Nation
|
Posted - 2009.04.10 16:58:00 -
[5]
 Originally by: Kale Kold
Yep i developed the lot. Infact i developed as a way of learning MySQL.
To answer the other question, I was actually considering adding ransoms but while planning it became clear it was too open for abuse. For example i could enter that i had recieved 1 billion ISK ransom when i really hadn't but who's to know otherwise, no-one can see my wallet. So that feature was left out.
Agreed, hence why I'm avoiding the corp's requests to mod one onto the EDK. :\
|
Arous Drephius
Perkone
|
Posted - 2009.04.10 17:58:00 -
[6]
You could always require people to enter their API key (full), and then display any player donations from the victim.
|
Kale Kold
Caldari
Mortis Angelus
The Church.
|
Posted - 2009.04.10 19:07:00 -
[7]
Originally by: Arous Drephius
You could always require people to enter their API key (full), and then display any player donations from the victim.
Who's to say it's not an alt. 
|
Nur AlHuda
Amarr
Callide Vulpis
|
Posted - 2009.04.17 11:45:00 -
[8]
What about some rule for example: minimum one month old character, must be in corp, with t2 or faction setup verified with full api. So realy only the most valuable and rare ransoms would be shown on the top and not just some faked shuttle trial kills.
Of course this still could be beaten but who would create create each two months characters, train them then delete them and create new ones to make place. This would be too obvious.
|
Kale Kold
Caldari
Mortis Angelus
The Church.
|
Posted - 2009.04.18 17:45:00 -
[9]
Edited by: Kale Kold on 18/04/2009 17:50:06
Nice idea but could be faked too easily and/or you would have to put in a lot of work to do all the API checks, and i mean a lot of work. Also you would need the API key of the victim, which is not going to happen.
|
Daius Stryker
|
Posted - 2009.05.11 11:04:00 -
[10]
Kale, I love the look of that kill board and the features are pretty sweet too. I was wondering if I might be able to convince you to pick up the project again. If compensation would be needed I would find a way to make that happen.
I'm uneducated when it comes to working with this kind of information and with APIs as well. My corporation could use something like this and we aren't the kind that need to worry about people entering false information |
|
|
Kale Kold
Caldari
Deep Core Mining Inc.
|
Posted - 2009.05.11 18:11:00 -
[11]
Edited by: Kale Kold on 11/05/2009 18:11:57
Originally by: Daius Stryker
Kale, I love the look of that kill board and the features are pretty sweet too. I was wondering if I might be able to convince you to pick up the project again. If compensation would be needed I would find a way to make that happen.
I'm uneducated when it comes to working with this kind of information and with APIs as well. My corporation could use something like this and we aren't the kind that need to worry about people entering false information
I'm actually giving it a bit of an update at this very minute, EVE mail me if you wanna talk about it.
|
Daius Stryker
|
Posted - 2009.05.15 10:17:00 -
[12]
I shot you off an EvEMail a few days ago but I'm not sure if you got it. My active character is Nexus Reign if you didn't get the mail you can try to fire one off to me.
|
goakiller900
|
Posted - 2009.05.16 11:48:00 -
[13]
He Kale Kold do you guys olso have in your MYsql database no user template ??
|
Kale Kold
Caldari
Deep Core Mining Inc.
|
Posted - 2009.05.16 14:08:00 -
[14]
Originally by: goakiller900
He Kale Kold do you guys olso have in your MYsql database no user template ??
Have you tried logging in as user:admin pass:admin ?
|
Kale Kold
Caldari
Deep Core Mining Inc.
|
Posted - 2009.05.18 21:37:00 -
[15]
Edited by: Kale Kold on 18/05/2009 21:42:26
For those who are interested i've given the board a little update. See this thread's first post.
1. Now fully supports Apocrypha and Tech3 items/ships.
2. Added new flashes on all graphics for tech2, tech3, faction, deadspace and officer items/ships.
3. Reordered the images folder as 11,000+ graphics in one folder was causing problems.
4. Lots of tweakes and polish.
Please post any bugs or wierdness here. I had some reports of some errors appearing in the PHP code due to uninitialised variables. These should be fixed now even though they don't effect the board, they just look bad. Let me know if there are any more.
To upgrade an existing board, replace all the web content with the contents of the Ledger.zip and import the updated.sql.gz tables over the the existing database. Before you do that though, BACK UP YOUR DATABASE just in case!
NOTE: I can't give you any support for MySQL and PHP, if you wanna try this board out you're gonna have to buy a book on these subjects or pass it on to someone who knows how to set up a database and webserver. 
Have fun.
|
Kurt Meyer
Infusion.
|
Posted - 2009.05.19 12:47:00 -
[16]
looking good :)
Are there any plans to get this to feed km's from api?
|
Kale Kold
Caldari
Deep Core Mining Inc.
|
Posted - 2009.05.19 19:07:00 -
[17]
Originally by: Kurt Meyer
looking good :)
Are there any plans to get this to feed km's from api?
I might look into that. The trouble is that for each kill the 'loot is placed in hangar' checkbox needs to be accurately toggled to record what happened to the loot. Otherwise the payment system gets out of whack. 
|
Kale Kold
Caldari
Deep Core Mining Inc.
|
Posted - 2009.06.06 20:44:00 -
[18]
Edited by: Kale Kold on 06/06/2009 20:44:47
Updated ledger to version 1.2b
See the first post in this thread for the complete feature listings and downloads.
Main Changes:
- Added ability to add and track ransoms.
- Added ransoms to the rankings page and ransom graphics to the 24 hour activity report.
- Added perfomance graph to the individual pirate pages to check loss/profit, etc.
- Added ransom history to the pirate pages.
- Added ability to add accounts and portraits from the ingame browser using 'adduseraccount.php' page.
- Changed the default killboard banner.
- Optimised the CSS files into one file (cuts down on lag/requests, etc).
- Optimised SQL queries for speed.
- Lots of tweaks and polish here and there.
Bug reports welcome!
Enjoy. 
|
VoiceInTheDesert
Zebra Corp
Circle-Of-Two
|
Posted - 2009.06.08 19:57:00 -
[19]
Originally by: Kale Kold
Edited by: Kale Kold on 18/04/2009 17:50:06
Nice idea but could be faked too easily and/or you would have to put in a lot of work to do all the API checks, and i mean a lot of work. Also you would need the API key of the victim, which is not going to happen.
Killmails can and are faked all the time. This kind of board is no more susceptible to it than the rest.
To the OP: Very nice work. I will be pointing everyone I know at this. Very fresh and a much better reflection/analysis of each kill/ransom. |
Kale Kold
Caldari
Deep Core Mining Inc.
|
Posted - 2009.06.08 22:18:00 -
[20]
Originally by: VoiceInTheDesert
To the OP: Very nice work. I will be pointing everyone I know at this. Very fresh and a much better reflection/analysis of each kill/ransom.
Thanks.
Yeah it could get abused, but pirate corps do seem to be quite close knit and loyal to each other, so i don't think it should be a big problem with a board like this. But, who knows. The main reason i created this board was to sort loot payments out for my corp members, of which it worked like a dream and everybody loved that. |
|
|
Pimp Pickel
Misfitz Brigade
Red Dwarf Alliance
|
Posted - 2009.06.09 04:56:00 -
[21]
I actually use this board even though my corp isnt a Pirate corp... The smaller corps should actually enjoy these cause the loot splitting is a great feature alone.
Thanks for the work Kale.
I'll actually try to be a little more active and give you some bug reports as corp gets to being more active in PvP  |
Pimp Pickel
Misfitz Brigade
Red Dwarf Alliance
|
Posted - 2009.06.09 05:49:00 -
[22]
Heres one for ya... On the password change...
Warning: Cannot modify header information - headers already sent by (output started at /home/content/e/r/i/.../.../.../updatepassword.php:3) in /home/content/e/r/i/.../.../.../updatepassword.php on line 33
|
Kale Kold
Caldari
Deep Core Mining Inc.
|
Posted - 2009.06.09 07:21:00 -
[23]
Edited by: Kale Kold on 09/06/2009 07:22:08
Originally by: Pimp Pickel
Heres one for ya... On the password change...
Warning: Cannot modify header information - headers already sent by (output started at /home/content/e/r/i/.../.../.../updatepassword.php:3) in /home/content/e/r/i/.../.../.../updatepassword.php on line 33
This one is because i use two methods to redirect the page once loaded. One i try a simple location header then i write a little javascript redirect. If you have page caching off you will see this error for a second while the page redirects. It doesn't effect anything though. I will use the error suppression operator on this call and you shouldn't see it again m8, i'll update it later.
I'm assuming it does actually work and updates your passwords it just flashes this on screen afterwards for a few seconds?
|
Kappas.
Galaxy Punks
|
Posted - 2009.06.09 12:41:00 -
[24]
Awesome job.
Would love an API feed though (dont know how far back kills in api go back but we'd need some way of importing kills before we could move fully to this) |
Pimp Pickel
Misfitz Brigade
Red Dwarf Alliance
|
Posted - 2009.06.09 13:31:00 -
[25]
Originally by: Kale Kold
I'm assuming it does actually work and updates your passwords it just flashes this on screen afterwards for a few seconds?
Yup you correct it does accept the changes but the page doesnt refresh stay on the error message. Could Just my browser that second part.
|
Kale Kold
Caldari
Deep Core Mining Inc.
|
Posted - 2009.06.09 17:59:00 -
[26]
Edited by: Kale Kold on 09/06/2009 18:03:26
Originally by: Kappas.
I cant log in as a guest nor update a registered users privelleges to admin. Guest loging just brings you back to the login page.
That's because a Guest account wasn't setup in the old 'tables.sql.gz' file i linked to. I've corrected that now, just redownload the above 'tables.sql.gz' file and reapply to your DB. If you want to create one yourself, log in as user: 'admin' (without the quotes) and use password 'admin' and go to the administration section. Create an account called 'Guest' and leave the password field blank. Give the account 'guest' permissions and click 'Add Account'. Done!
Originally by: Kappas.
Would love an API feed though, kind of make or break rather than having to post in 600 days worth of killmails 
Which killboard do you currently use?
|
Kale Kold
Caldari
Deep Core Mining Inc.
|
Posted - 2009.06.09 18:00:00 -
[27]
Originally by: Pimp Pickel
Originally by: Kale Kold
I'm assuming it does actually work and updates your passwords it just flashes this on screen afterwards for a few seconds?
Yup you correct it does accept the changes but the page doesnt refresh stay on the error message. Could Just my browser that second part.
Download the new 'Ledger.zip' above and replace all the *.php files with the ones from the newly downloaded zip file. This should cure your problem.
|
Kappas.
Galaxy Punks
|
Posted - 2009.06.09 23:58:00 -
[28]
Originally by: Kale Kold
Which killboard do you currently use?
Griefwatch, unfortunately. So no feed syndication since they are tight and want 1bn for it Also got banned from battleclinic for asking them about it. Nice guys eh  |
Random Excess
|
Posted - 2009.06.10 06:22:00 -
[29]
Great work on the board.
One possible problem I've noticed is that the URI is not always encoded correctly. For example, when viewing a pilot's details, the space remains in the URI string instead of being substituted with whatever code is supposed to go there. A space isn't a problem with most browsers but names with odd characters may cause problems.
Thanks! |
Random Excess
|
Posted - 2009.06.10 06:42:00 -
[30]
Some other feedback as I play about with it.
When you search for a pilot, it simply lists all their losses and the links take you to each of those losses. There is no way to get to the pilot's info page from there, nor does it list their kills which is available from the info page.
It would be handy if the search page also showed kills they were involved in. I've also made a change to line 821 of kill.php so that the victim's name is a link to their killer page. It now looks like this in case you wanted it: -
Print("<td class=\"Value\"><span class=\"Name\"><a href=\"killer.php?Name=".$Row_Victim["Victim"]."\">".$Row_Victim["Victim"]."</a></span></td>");
I've not tried to do anything with the search function as yet.
|
|
|
|
|
| |
|
| Pages: [1] 2 3 4 :: one page |
| First page | Previous page | Next page | Last page |