Pages: 1 2 3 4 5 6 7 :: [one page] |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
rig0r
0utbreak
|
Posted - 2006.09.10 10:37:00 -
[1]
Greetings EVE citizens,
After 2.5 years of playing I've decided enough is enough. Most important reason is the huge amount of time this addicting game consumes, others are boredom and frustration about CCP not caring to fix things that have been broken for so long. I will miss the friends I found in EVE, and particularly my friends from Arcane Industries, Battle Angels and finally Outbreak. You know who you are. It has been a fun ride.
My goodbye gift to the EVE community is the release of the eve-killboard sourcecode, which can be obtained here. It is a slightly modified version, meaning the code related to killboard rental has been removed mostly, to make it easier to setup a single killboard for a corp or alliance. People with some knowledge of apache, mysql and php should have no trouble setting it up. A readme is included. Note that I will not give any support on it, as I am not ingame anymore. Put some time in it and figure it out yourself basicly The database dump included does not contain any kill data.
Do with it as you like, learn from it, improve it, bugfix it, have fun with it.
eve-killboard.net will be shutting down on November 1st, 2006. I will release the full database dump shortly after.
Fly safe.
rig0r o/
Eve rocks on Linux |
joefishy
S.A.S
|
Posted - 2006.09.10 10:42:00 -
[2]
love you rig0r :)
hope all go's well
best of wish's from all of us in SAS
SAS - The un-official isk sink of the game.
|
ParMizaN
Body Count Inc. Mercenary Coalition
|
Posted - 2006.09.10 10:42:00 -
[3]
Thank you, goodbye, and good luck!
sig edited for lack of pink really PINK -eris Pink is overrated, yellow is the new pink - Xorus XORUS!!1 HEATHEN KILLKILLKILLKILLKILL - Immy |
wierchas noobhunter
Caldari The Collective Against ALL Authorities
|
Posted - 2006.09.10 10:44:00 -
[4]
noooooooo
Hey i get paid to be ebil - Xorus So how much you want for the ebil goat??-Tirg I don't - Imz0r |
superscarface
0utbreak
|
Posted - 2006.09.10 10:45:00 -
[5]
*sniffle*
|
ElCoCo
Gallente KIA Corp
|
Posted - 2006.09.10 10:45:00 -
[6]
Aw c'mon, you know you're gonna be back
|
Krugerrand
0utbreak
|
Posted - 2006.09.10 10:45:00 -
[7]
sad to see you go mate
Been great fun flying with you, best of luck in the future.
Ps - whos getting that vindi?
|
Kronn Blackthorne
0utbreak
|
Posted - 2006.09.10 10:48:00 -
[8]
u can t leave us alone man , sad to see u go , wish u the best in ur futur
|
|
Wispy
Forum Moderator Interstellar Services Department
|
Posted - 2006.09.10 10:56:00 -
[9]
Moved to OOPE from CAOD.
__
forum rules | [email protected] |
|
Hans Roaming
Body Count Inc. Mercenary Coalition
|
Posted - 2006.09.10 10:56:00 -
[10]
Sad to see you go m8.
|
|
welsh wizard
Celestial Apocalypse
|
Posted - 2006.09.10 11:04:00 -
[11]
All the best rigs, its been a blast!
|
Kaell Meynn
|
Posted - 2006.09.10 11:06:00 -
[12]
Edited by: Kaell Meynn on 10/09/2006 11:07:48 Very kind parting gift. Thank you. And good luck with where-ever you go next. It can be addicting, and sometimes it's good to quit or take a break.
I do recommend keeping your account and chars for yourself even if you do cancel, I've seen many people leave, get rid of all their stuff, and come back and wish they had their char still. There are aspects of this game which you can enjoy without playing it 'hard-core', and it can be a much more enjoyable game. Just do small stuff and not alliance stuff.
Finally.... SOMEONE has to say it.....
Can I have your stuff? >< (besides your source code which itself is quite valueable and you've already given me... and ty btw :P)
|
SwindonBadger
0utbreak
|
Posted - 2006.09.10 11:11:00 -
[13]
Nooooooooooooooooooooooooooooooooooooo.......
and repeet. Noooooooooooooooooooooooooooooooooooooooo
Im gonna miss u lots, thanks for all the hard work and all the fun times, wishing u all the best !
furry one
|
Grimslaw
Minmatar Obsidian Asylum Pure.
|
Posted - 2006.09.10 11:19:00 -
[14]
All the best rigOr
was fun flying alongside you briefly Hope to see ya back ingame at some point in the future
|
Brazzahrn Stroh
0utbreak
|
Posted - 2006.09.10 11:19:00 -
[15]
Damn, you will be missed rig0r. Hopefully you'll be back.
|
Xantor
0utbreak
|
Posted - 2006.09.10 11:27:00 -
[16]
*sniff*
|
Kujin
0utbreak
|
Posted - 2006.09.10 11:36:00 -
[17]
all the best for your future m8...
sad to see you go
|
jamesw
Omniscient Order
|
Posted - 2006.09.10 12:37:00 -
[18]
Sad to see you go, and a HUGE thanks for the generosity of releasing your killboard source.
Many thanks. --
NEW Vid: Domi For the Win! |
Mariarchi Desperado
No Quarter. Axiom Empire
|
Posted - 2006.09.10 13:27:00 -
[19]
Was fun fighting you when you were in Triad. Sorry to see you go...
|
Leilani Solaris
Gallente 0utbreak
|
Posted - 2006.09.10 14:01:00 -
[20]
Good luck rig0r, lub you
|
|
HuDDy
Reikoku Band of Brothers
|
Posted - 2006.09.10 14:02:00 -
[21]
Sad to see ya go rig0r gl in the future
|
John McCreedy
Caldari Eve Defence Force Ascendant Frontier
|
Posted - 2006.09.10 15:07:00 -
[22]
Sad to see yet another vet leave. When will CCP wake up and start fixing the things that are driving them away.
Anyway, Rig0r, sorry to see you go and thank you for the killboard on behalf of all who used it.
Make a Difference
|
boulette
0utbreak
|
Posted - 2006.09.10 15:51:00 -
[23]
MOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOooooooooooooooooooooooo0000000000000000000000000000000000000!!!!!!!!!!!!!!!!!!!!!!!!!!11111111111111111111111
the cow is sad
|
Joseph Mnemonic
0utbreak
|
Posted - 2006.09.10 15:59:00 -
[24]
♥
|
Marko Debreault
0utbreak
|
Posted - 2006.09.10 16:15:00 -
[25]
You're a ninja, rig0r.
Heckuva nice gift.
|
Adam C
0utbreak
|
Posted - 2006.09.10 16:31:00 -
[26]
i feel your pain, brother.
/me slaps rig0r poster next to meh bed and prey
|
Trinity Faetal
Gallente 0utbreak
|
Posted - 2006.09.10 16:39:00 -
[27]
|
Loyal Servant
Caldari Cornhole Inc. The SUdden Death Squad
|
Posted - 2006.09.10 17:56:00 -
[28]
As a TSDS Member with an uber killboard... I thank you for running it, and even more for releasing the source.
I have heard many stores of people returning to eve, consider keeping your items, isk, etc.
At least you won't start anew if you do come back :)
Cornhole, Inc. - Cornholeing eve one system at a time. Member, The Sudden Death Squad [TSDS]
|
Crayathan
Gallente Hidden Agenda
|
Posted - 2006.09.10 19:06:00 -
[29]
The best kb i've ever seen, always tried to make mine as good and failed.
Fly safe Rig
Even though I walk through the valley of the shadow of death, I fear no evil |
jarack
Generals Of Destruction Syndicate Axiom Empire
|
Posted - 2006.09.10 20:46:00 -
[30]
man its sad to see you go, flown with you before, fly safe dude....
|
|
Kheo Sen
Beagle Corp
|
Posted - 2006.09.10 21:06:00 -
[31]
Can i petition this ?
I thank you for the KB.
Sad to see u go, good luck and have fun mate, o/ .......
|
Das Yad
0utbreak
|
Posted - 2006.09.10 21:19:00 -
[32]
Originally by: Marko Debreault You're a ninja, rig0r.
Heckuva nice gift.
QFT ♥ rig0r
|
RacerX1
0utbreak
|
Posted - 2006.09.10 21:47:00 -
[33]
nothing to say really but, respect.
you honestly deserve it.
|
Pehova Mindtriq
Celestial Apocalypse
|
Posted - 2006.09.10 21:56:00 -
[34]
rig0r > ninja pirates
Good luck mate
Celes/Toxin vs BOB |
Bloodst0ne
The Priory
|
Posted - 2006.09.10 22:19:00 -
[35]
Originally by: rig0r frustration about CCP not caring to fix things that have been broken for so long.
QFT
Sorry to see you go m8.. Take care.
-blood
I have the "I Win Button" of eve. |
Mad Mackem
E X O D U S Imperial Republic Of the North
|
Posted - 2006.09.10 22:26:00 -
[36]
I dont know you mate but i feel your pain, your killboard is awesome.
Good Luck
|
Roxanna Kell
Holy Jihad
|
Posted - 2006.09.10 23:26:00 -
[37]
Good luck dude, so what you playing next?
Please resize image to a maximum of 400 x 120, not exceeding 24000 bytes, ty - Cortes |
Crzycnck2
|
Posted - 2006.09.10 23:48:00 -
[38]
This really Blows!!!
Will miss you rigor!!! take care mate and best of luck in real life.
I'm a trained bomb disposal expert... if you see me running, try to keep up! |
Chewan Mesa
Beagle Corp
|
Posted - 2006.09.11 00:51:00 -
[39]
Thanks for an awesome KB. And good luck wherever you're off to...
|
Aeaus
Tharsis Security
|
Posted - 2006.09.11 01:16:00 -
[40]
Sorry to see you go. I've always envyed your killboard and now I'm setting one up for my corp (Many thanks). I have a quick question regarding that.
I setup everything per instruction and set up an post password, but when I try to post a killmail it doesn't work, tells me I'm not authorized, any insight?
Join Tharsis! - Get Sexy Sigs |
|
Pericles Maranhao
Caldari
|
Posted - 2006.09.11 01:59:00 -
[41]
See you around man.
|
JimChuD
Gallente Forsaken Empire
|
Posted - 2006.09.11 07:55:00 -
[42]
appreciated :) fly safe :) Compromise - Let's agree to respect each others views, no matter how wrong yours may be |
Turiya Flesharrower
Beagle Corp
|
Posted - 2006.09.11 10:34:00 -
[43]
Thank you for all of the work you obviously put into your killboard and for then giving it away for nothing; that was a fantastic thing to do
I hope you'll return to Eve someday; don't give away all of your stuff just yet. -----
|
Morris Falter
133rd Ghost Wing R i s e
|
Posted - 2006.09.11 10:46:00 -
[44]
/me feels safer already
Thanks for releasing the KB code - great great present to leave people on leaving..
Best for the future. http://www.oth4.com/mo-2.gif
signature removed (max dimensions 120px * 400px) - please email us if you want to know why - Pirlouit([email protected]) |
Nimir
g guild
|
Posted - 2006.09.11 20:19:00 -
[45]
i didn't know you dude, but i have seen you're work, and i liked it. sad to see a good web programmer leave eve . thanks for the code, it will be put to good use. fly safe in RL.
Peace! Nimir
Only trough worthy opponents can I ascend beyond this. |
Tobias Sjodin
Caldari Ore Mongers Pirate Coalition
|
Posted - 2006.09.12 14:52:00 -
[46]
Sad to see you go rig0r. =/
Can I ask, how I get it to generate proper portraits? Currently it only displays "!" for everyone (yes, even the ones that have portraits on the forums).
[ore mongers, recruiting] |
EvEhate
|
Posted - 2006.09.12 23:47:00 -
[47]
Originally by: Aeaus Edited by: Aeaus on 11/09/2006 05:20:40 Sorry to see you go. I've always envyed your killboard and now I'm setting one up for my corp (Many thanks). I have a quick question regarding that.
I setup everything per instruction and set up an post password, but when I try to post a killmail it doesn't work, tells me I'm not authorized, any insight?
Edit : Got it.
P.S. You didn't clear everything out.
How did u fixed the Problem?
|
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.13 08:49:00 -
[48]
its sad to see a player like this go, but i understand your reasons 101%, especially the they dont fix stuff issue.
i dont know you at all but, rig0r, youre a pretty cool guy towards the eve community.
|
Sedukan Denaan
Caldari DRUCKWELLE
|
Posted - 2006.09.13 18:20:00 -
[49]
Originally by: EvEhate
Originally by: Aeaus Edited by: Aeaus on 11/09/2006 05:20:40 Sorry to see you go. I've always envyed your killboard and now I'm setting one up for my corp (Many thanks). I have a quick question regarding that.
I setup everything per instruction and set up an post password, but when I try to post a killmail it doesn't work, tells me I'm not authorized, any insight?
Edit : Got it.
P.S. You didn't clear everything out.
How did u fixed the Problem?
First you got to find out your CorpID from Table kb3_corps. If you are not yet in the corp table, add your corp with the proper Alliance ID in crp_all_id (14 = None).
Now check your config.php at line 8/9, replace the IDs with your Corp/Alliance ID. The Post page will then accept Mails from your Corp/Alliance Members.
rig0r: Great work by the way, easy to understand and very clean code. Sad to see someone like you leaving the game
|
dellie
Euphoria Released Euphoria Unleashed
|
Posted - 2006.09.13 20:54:00 -
[50]
very clean code indeed.. setup was easypeasy.. but im bumping against one problem.. our corp has a flash (.swf) banner.. jpg is no problem but if i adapt it to .swf it doesnt work tried a big load of option.. none worked anybody that can help me out? <3
'The first condition for immortality is death' |
|
Pah Triac
Wreckless Abandon
|
Posted - 2006.09.13 23:24:00 -
[51]
your going ??? damn not goood.....
hou je haaks je veel plijzier verder met wat je ook gaat doen
*** People are stupid. They will believe anything they want to be true or fear to be true. *** |
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.14 02:38:00 -
[52]
does the map rendering work for you or are just my cache settings screwed?
|
dellie
Euphoria Released Euphoria Unleashed
|
Posted - 2006.09.14 06:13:00 -
[53]
Originally by: liquidism does the map rendering work for you or are just my cache settings screwed?
you have to give the database user read/write rights on the cache map :)
'The first condition for immortality is death' |
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.14 07:50:00 -
[54]
Originally by: dellie
Originally by: liquidism does the map rendering work for you or are just my cache settings screwed?
you have to give the database user read/write rights on the cache map :)
hmm im having the cache/map folder at chmod 777.. portrait rendering works fine but map's wont.
if i want to show just the map-img i get a nice
Quote:
Warning: Division by zero in /common/class.map.php on line 192
Fatal error: Call to undefined function: imagegif() in /common/class.map.php on line 307
is there a server-side image rendering lib im missing?
|
oodin
Euphoria Released
|
Posted - 2006.09.14 08:10:00 -
[55]
*salutes a great warrior and does a frank sinatra on CCPs head
|
rig0r
|
Posted - 2006.09.14 08:28:00 -
[56]
Originally by: liquidism
Originally by: dellie
Originally by: liquidism does the map rendering work for you or are just my cache settings screwed?
you have to give the database user read/write rights on the cache map :)
hmm im having the cache/map folder at chmod 777.. portrait rendering works fine but map's wont.
if i want to show just the map-img i get a nice
Quote:
Warning: Division by zero in /common/class.map.php on line 192
Fatal error: Call to undefined function: imagegif() in /common/class.map.php on line 307
is there a server-side image rendering lib im missing?
You seem to be lacking GD GIF support in your PHP installation.
-- Retired. |
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.14 10:32:00 -
[57]
i changed the the createGIF function to createPNG as i noticed my gdlib got no proper gif support. the png functions are exactly the same and i get an image now (example: http://tomx.org/eve-kb/?a=mapview&sys_id=868&mode=map&size=145 ) but besides the region name it wont render anything, also the const. and system maps wont show up at all
any ideas?
|
EvEhate
|
Posted - 2006.09.14 11:46:00 -
[58]
Code:
Database error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and shp.shp_class = scl.scl_id' at line 4 SQL: select * from kb3_ships shp, kb3_ship_classes scl where shp_id = and shp.shp_class = scl.scl_id
Code:
Database error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and kll_fb_plt_id = 27828' at line 10 SQL: select kll_id from kb3_kills where kll_timestamp <= date_add( '2006.08.31 20:12', INTERVAL '15:0' MINUTE_SECOND ) and kll_timestamp >= date_sub( '2006.08.31 20:12', INTERVAL '15:0' MINUTE_SECOND ) and kll_victim_id = 41727 and kll_ship_id = 17 and kll_system_id = and kll_fb_plt_id = 27828
I get this Errors when i will post 2 killmails All others worked fine.Maybe someone understands more mysql then me and can help to Fix the Problem?
|
Great Artista
Earthbound Inc.
|
Posted - 2006.09.14 11:48:00 -
[59]
He'll come back. Nobody can quit eve.
////////////////////////////////// Killing GOON's is kinda fun. ////////////////////////////////// |
Lufio II
Amarr Dark Seraph Verisum Family
|
Posted - 2006.09.14 16:58:00 -
[60]
Originally by: EvEhate Code:
Database error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and shp.shp_class = scl.scl_id' at line 4 SQL: select * from kb3_ships shp, kb3_ship_classes scl where shp_id = here's no value and shp.shp_class = scl.scl_id
Code:
Database error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and kll_fb_plt_id = 27828' at line 10 SQL: select kll_id from kb3_kills where kll_timestamp <= date_add( '2006.08.31 20:12', INTERVAL '15:0' MINUTE_SECOND ) and kll_timestamp >= date_sub( '2006.08.31 20:12', INTERVAL '15:0' MINUTE_SECOND ) and kll_victim_id = 41727 and kll_ship_id = 17 and kll_system_id = here's no value as well and kll_fb_plt_id = 27828
I get this Errors when i will post 2 killmails All others worked fine.Maybe someone understands more mysql then me and can help to Fix the Problem?
(bold added by me)
Find out where in the code those SQL-Statements are hidden and check why the variables that should have values don't have any. As I'm not having the code in front of me or know more circumstances, I can just wish you fun in debugging. The bolded positions are the reason why the statements fail (Unkown ship and unknown System it seems).
|
|
Nimir
g guild
|
Posted - 2006.09.14 21:40:00 -
[61]
Edited by: Nimir on 14/09/2006 21:40:34 Edited by: Nimir on 14/09/2006 21:40:04 i have two problems... the first is with portrait rendering. in portrait.php the first if instruction is not executed. can anyone tell me why and what i can do about it?
i'm running the killboard on apache 2, php 4 and mysql 5... which brings me to my second problem: is there anyone who can tell me why it won't work on php 5? it just shows me a blank page.
|
Von Dread
The Sofa Kings
|
Posted - 2006.09.15 04:45:00 -
[62]
You'll be missed Rig0r. Thank for releasing the source code, it's a great killboard. One question for anyone that might be able to help. We've been using the Falcon KMS killboardt and I'd like to import all the killmails into this new board. Has anyone come up with a program that would be able to do this or point me in the right direction. Thanks for your help. |
rig0r
|
Posted - 2006.09.15 09:03:00 -
[63]
Originally by: Nimir Edited by: Nimir on 14/09/2006 21:40:34 Edited by: Nimir on 14/09/2006 21:40:04 i have two problems... the first is with portrait rendering. in portrait.php the first if instruction is not executed. can anyone tell me why and what i can do about it?
i'm running the killboard on apache 2, php 4 and mysql 5... which brings me to my second problem: is there anyone who can tell me why it won't work on php 5? it just shows me a blank page.
Check if you have GD support in your PHP installation. Also it should work on PHP5 as that's the version the kb has been developed on.
-- Retired. |
rig0r
|
Posted - 2006.09.15 09:11:00 -
[64]
Originally by: Von Dread You'll be missed Rig0r. Thank for releasing the source code, it's a great killboard. One question for anyone that might be able to help. We've been using the Falcon KMS killboardt and I'd like to import all the killmails into this new board. Has anyone come up with a program that would be able to do this or point me in the right direction. Thanks for your help.
Have a look at the Parser class. What I usually did is getting the raw mails into a temporary database table, looping through them and feeding the raw mails to Parser->parse().
e.g.: (untested, may have to tweak paths and stuff)
require_once( "common/db.php" ); require_once( "common/class.parser.php" );
$qry = new DBQuery(); $qry->execute( "select raw_mail from mails_to_import" );
while ( $row = $qry->getRow() ) { $mail = $row['raw_mail']; $parser = new Parser( $mail ); $id = $parser->parse( false ); if ( $id == 0 ) { file_put_contents ( 'failedmails.txt', $mail."\n\n", FILE_APPEND ); $failedcount++; } $total++; }
echo "Total: ".$total."\n"; echo "Failed: ".$failedcount."\n";
-- Retired. |
Scorched Evil
Dark Knights S H I F T
|
Posted - 2006.09.15 09:24:00 -
[65]
hey mate, if you would like i can host an image on our 100mbit servers so service doesnt go down to the people that use it. I sent you a note on the outbreak forums.
Ready for the Dark Side? Join DKFS! Be polite. Be professional. But have a plan to kill everyone you meet. |
Franky B
Mentally Unstable Enterprises
|
Posted - 2006.09.15 14:11:00 -
[66]
hey, bit of a noob here but be gentle :P (btw, dont go :()
I've setup this database on my webhost using Cpanel to and phpadmin to create a database and also a username and password. the config file is configured correctly but whenever I finish running the config.php, I get this message
Database error: No database selected SQL: select scl_id, scl_class from kb3_ship_classes where scl_class not in ( 'Drone', 'Unknown' ) order by scl_class
any ideas?
|
Nimir
g guild
|
Posted - 2006.09.15 15:18:00 -
[67]
ok, i managed to enable gd and portrait rendering works now... the damn thing wouldn't work with spaces in the path to extension dir thanks for the help
the problem with php 5 however seems to be general, i can't run any php code on it, it just shows me a white page, even when i try to run phpinfo(). maybe it's my configuration or something... anyway, it works on php 4 so i'm happy.
now i just have to find a way to bypass my host's lack of URL file access to get to the portraits.
Peace! Nimir
|
rig0r
|
Posted - 2006.09.15 19:18:00 -
[68]
Originally by: Franky B Edited by: Franky B on 15/09/2006 15:13:43 hey, bit of a noob here but be gentle :P (btw, dont go :()
I've setup this database on my webhost using Cpanel to and phpadmin to create a database and also a username and password. the config file is configured correctly but whenever I finish running the config.php, I get this message
Database error: No database selected SQL: select scl_id, scl_class from kb3_ship_classes where scl_class not in ( 'Drone', 'Unknown' ) order by scl_class
any ideas?
PS: ive noticed your style sheets are using absolute paths to reference specific URL's for banner images etc... these point to your img.eve-killboard.net address. so those who've got it working may want to change this.
Must be a configuration issue, check you have the proper databasename filled in the config.php.
Right about the hardlink in the stylesheets, some things I did quick & dirty
-- Retired. |
rig0r
|
Posted - 2006.09.15 19:20:00 -
[69]
Originally by: Nimir Edited by: Nimir on 15/09/2006 15:28:27 ok, i managed to enable gd and portrait rendering works now... the damn thing wouldn't work with spaces in the path to extension dir thanks for the help
i also did a little optimization to your portrait rendering code. you can get the image with the needed size directly from eve's server, you just have to ask for it, so i removed the resizing code. now it asks for the image with the required size.
If I remember correctly I grab a big (128x128) portrait from img.eve.is and resize it manually, because of the crappy image quality you get when grabbing smaller sizes directly. Try it out and see Also img.eve.is tends to be unavailable every now and then.
-- Retired. |
Nimir
g guild
|
Posted - 2006.09.15 23:33:00 -
[70]
Edited by: Nimir on 15/09/2006 23:35:27
Originally by: rig0r If I remember correctly I grab a big (128x128) portrait from img.eve.is and resize it manually, because of the crappy image quality you get when grabbing smaller sizes directly. Try it out and see Also img.eve.is tends to be unavailable every now and then.
you do remember corectly, and yes, there are minor differences between the two images. anyway, normally i would use your code as you wrote it, and i do on my own computer, but my host has disabled URL file access, so i can't use imagecreatefromjpeg() directly. i tried using cURL to fix this, but then i got an error because imagecreatefromjpeg() was getting only the first 4 bits of the image, so it seemed i couldn't use imagecreatefromjpeg() at all. finally, a few minutes before writing this i found a way to make the code work. just set the headers and use echo() to display the image that cURL grabs from img.eve.is.
i hope this helps everyone that might have the same problems i had .
Peace! Nimir
|
|
Franky B
Mentally Unstable Enterprises
|
Posted - 2006.09.15 23:37:00 -
[71]
fixed my problem (god I feel stupid). didnt actually ADD the user on the database accesslist server side :p
|
Mordocik
Penetrate
|
Posted - 2006.09.16 00:45:00 -
[72]
Just wanted to chip in with a thank you for releasing the source code, also as a gentoo dev it's nice to see your using Gentoo ;) Best of luck with all your new found free time.
Just wanted to let people know that I'll be taking up from where you left off and running a eve-killboard.net style of setup. If anyone needs there killboard hosted let me know (evemail or convo in game).
|
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.16 01:16:00 -
[73]
hey rig0r, thank you so much again for releasing the code. after digging through almost every class now i cant say anything besides awesome work!!
but one thing still bothers me, its the map rendering thingy.. i just can not get it to work (tried on 3 diff. servers with various GD-libs installed and ready).
it renders an image with the system/region name on top (so i know caching and img rendering works on the server) but it wont draw the jump lines nor system dots at all. i checked twice and i think i got all the sql data from kb3_constellations, kb3_regions, kb3_systems and kb3_systemjumps right with no import errors. so, does anyone else is able to draw the maps without problems? am i missing something here? plz help :)
|
Tareen Kashaar
eXin Alliance
|
Posted - 2006.09.16 04:05:00 -
[74]
Installed and it's working \o/ Very kind of you to share it with the community! And yeah, no one can quit eve ;)
So... I'm wondering, is anyone else missing the T2 ship images from that package in the OP? I might also be missing the odd lib or two, but my beloved server adminess is residing in the land of fluffy dreams atm... --- WTS: Forum Signatures, 30mil a piece. Evemail me!
|
Franky B
Mentally Unstable Enterprises
|
Posted - 2006.09.16 10:17:00 -
[75]
again, its great of you to release this. now onto the fixing >:)
all killmails posted using either ingame or outgame php scripts are being sent and recieved by the eve-killboard.net mail servers, so again, you'll want to set your servers up for mailing and change accordingly.
|
Nimir
g guild
|
Posted - 2006.09.16 11:04:00 -
[76]
two more bugs... i may not know how to code php pro, but this is getting annoying...
first, all the mails i post the include two or more involved parties appear bugged. there is an "unknown" party shown between all the parties involved. when i look and the raw killmail there is a "Name: / " line between all the involved parties... why is that? and why are the killmails posted by a corp mate working fine?
second, when i want to see details about a killmail the map is not rendered, just the region and constellation.
i looked through the code and saw nothing that might cause any of these bugs. then again, my knowledge of php is very limited for now (but i'm learning as i go ), so any help is greatly appreciated.
Peace! Nimir
|
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.16 23:34:00 -
[77]
Originally by: Nimir
when i want to see details about a killmail the map is not rendered, just the region and constellation.
i got the exact same bug, but only on ONE of my servers(!!!) they both got the exact same setup, sql data and killboard files.
its pretty weird and i cant figure out why tbh, but it simply wont draw the system dots on the 'map' image but if you look into the mapview.php and set $view->showLines( true ) for case "map" then you can at least see the drawing of the universe but no coloring of the target-region no matter what.
rig0r, i ran out of ideas, please can you give us a clue?
|
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.17 03:10:00 -
[78]
i think i found a really serious bug.
if you add a killmail without someone having the final blow, because the final blower got truncated (lots of involved players), corrupted information gets into the database.
|
Termy
Caldari Omniscient Order
|
Posted - 2006.09.18 02:04:00 -
[79]
oww.. ;/ your killboard will be greatly missed rig0r. It was great to use because of the shared database and a simple link. Alot of corps/alliances would use the same killboard, and its easy to find someone's KB.
Now it would be all different links, different DBs and a whole lotta mess i predict. Will be alot harder to find someones KB most probably.
Maybe you could pass ownership of the website to someone else? Is that an avalable/possible option? ----------- Not Blue = Shoot It
|
Franky B
Mentally Unstable Enterprises
|
Posted - 2006.09.18 04:58:00 -
[80]
another change I made for convenience was to remove the password protection for killmail posting for the ingame submissions site. its already checking your character against the killmail data, so the password ends up being an innessecary step (takes up time).
coolies though :p
|
|
Emmerich Steiner
Vogon Deconstruction Fleet Ratel Alliance
|
Posted - 2006.09.20 02:27:00 -
[81]
Check this site out..
http://bughunters.addix.net/igbtest/IGB-commands.html (Scroll down to the special functions section)
What you are going to want to do is have the user set yout site to trusted and grab some evedata through the built in IGB functions...
Like the players char_ID...
|
Emmerich Steiner
Vogon Deconstruction Fleet Ratel Alliance
|
Posted - 2006.09.20 02:32:00 -
[82]
Edited by: Emmerich Steiner on 20/09/2006 02:33:23 $_SERVER['HTTP_USER_AGENT']
Might return some info specific to the IGB, but I haven't tried it.
oh and rig0r thanks for the source, I am building a killboard/dataminer from scratch, and this will save me a ton of time :D
|
Emmerich Steiner
Vogon Deconstruction Fleet Ratel Alliance
|
Posted - 2006.09.20 02:48:00 -
[83]
Originally by: Franky B Edited by: Franky B on 15/09/2006 15:13:43 hey, bit of a noob here but be gentle :P (btw, dont go :()
I've setup this database on my webhost using Cpanel to and phpadmin to create a database and also a username and password. the config file is configured correctly but whenever I finish running the config.php, I get this message
Database error: No database selected SQL: select scl_id, scl_class from kb3_ship_classes where scl_class not in ( 'Drone', 'Unknown' ) order by scl_class
any ideas?
PS: ive noticed your style sheets are using absolute paths to reference specific URL's for banner images etc... these point to your img.eve-killboard.net address. so those who've got it working may want to change this.
If you are using a shared hosting account did you define DB_NAME as 'youraccountname_kb', instead of 'kb'?
|
Franky B
Mentally Unstable Enterprises
|
Posted - 2006.09.20 04:59:00 -
[84]
both questions were answered :p thanks though
|
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.20 05:06:00 -
[85]
the function for killpoint calculation is COMPLETLY bugged guys!
it just takes the victims ship value and multiplies it by the number of involved players where it should get the involved players ship value and add it to the other inv. players values.
replace the calc function in class.kill.php
Quote:
function calculateKillPoints() { $ship = $this->getVictimShip(); $shipclass= $ship->getClass(); $vicpoints = $shipclass->getPoints(); $maxpoints = round( $vicpoints * 1.2 ); foreach ( $this->involvedparties_ as $inv ) { $ship = $inv->getShip(); $invpoints += $shipclass->getPoints(); /*here it only takes the victims shipvalue and add its by the count of inv. players where it should take each players own shipvalue*/ } $gankfactor = $vicpoints / ( $vicpoints + $invpoints ); $points = ceil( $vicpoints * ( $gankfactor / 0.6 ) );
if ( $points > $maxpoints ) $points = $maxpoints; $points = round( $points, 0 ); //echo "invpoints:".$invpoints."<br>"; //echo "vicpoints:".$vicpoints."<br>"; //echo "gankfactor:".$gankfactor."<br>"; //echo "points:".$points; //exit; return $points; }
with
Quote:
function calculateKillPoints() { $ship = $this->getVictimShip(); $shipclass= $ship->getClass(); $vicpoints = $shipclass->getPoints(); $maxpoints = round( $vicpoints * 1.2 ); foreach ( $this->involvedparties_ as $inv ) { $shipinv = $inv->getShip(); $shipclassinv= $shipinv->getClass(); $invpoints += $shipclassinv->getPoints(); } $gankfactor = $vicpoints / ( $vicpoints + $invpoints ); $points = ceil( $vicpoints * ( $gankfactor / 0.75 ) );
if ( $points > $maxpoints ) $points = $maxpoints; $points = round( $points, 0 ); return $points; }
you might want to tune the shipclasses point values in the database by yourself as i find them not matching actual combat criteria
//liq
|
cRaNbErRy MuFfInMaN
mUfFiN fAcToRy
|
Posted - 2006.09.20 07:53:00 -
[86]
Id like to start a forums dedicated to that killboard, Help with questions mods, updates etc for people who want to work together to improve it. perhaps liquidism and franky youd be interested?
|
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.20 08:10:00 -
[87]
Originally by: cRaNbErRy MuFfInMaN Id like to start a forums dedicated to that killboard, Help with questions mods, updates etc for people who want to work together to improve it. perhaps liquidism and franky youd be interested?
hmm ive spent the last 5-6 nights coding and modding the board and i cant see any more php code for now. tbh i rather want to kill stuff then work on a board that tracks stuff others killed
i basically did a new board for our alliance as the old board was shut down without notice by some greedy **** called ex-member. we were developing a completly new board and in the middle of it rig0r released his exellent sourcecode so i took on it and modded it for our alliance's needs (eg. daily stats instead of weekly's, a kill comment system, isk value is now tracked by ship killed and not only by ship class, admin sql backup util, parser bugfixes, minor rendering bugfixes, made auditing work again, some new stats, etc..) and once it is finished (it almost is - v1.99) ill do something else, namely, kill stuff again.
but id be happy to post code-snippets of imporant stuff i fixed or changed, be it here or in a seperate forum for it. so heh.. just go for it m8.
btw: you can check the actual version of the board @ http://kb.eve-d2.com if youre intersted
//liq
|
NQRott
Gallente Netquarter
|
Posted - 2006.09.20 10:13:00 -
[88]
great job rig0r!!!!
i also setup this killboard on my server, it runs fine i can post killmails ingame, pilots and corps were added the map and the portraits are renderd. but no new portraits will appear in the cache dir. anyone an idea?
|
krims0n
|
Posted - 2006.09.20 10:46:00 -
[89]
Originally by: liquidism Edited by: liquidism on 20/09/2006 08:24:29
Originally by: cRaNbErRy MuFfInMaN Id like to start a forums dedicated to that killboard, Help with questions mods, updates etc for people who want to work together to improve it. perhaps liquidism and franky youd be interested?
hmm ive spent the last 5-6 nights coding and modding the board and i cant see any more php code for now. tbh i rather want to kill stuff then work on a board that tracks stuff others killed
i basically did a new board for our alliance as the old board was shut down without notice by some greedy **** called ex-member. we were developing a completly new board and in the middle of it rig0r released his exellent sourcecode so i took on it and modded it for our alliance's needs (eg. daily stats instead of weekly's, a kill comment system, isk value is now tracked by ship killed and not only by ship class, admin sql backup util, parser bugfixes, minor rendering bugfixes, made auditing work again, some new stats, etc..) and once it is finished (it almost is - v1.99) ill do something else, namely, kill stuff again.
but id be happy to post code-snippets of imporant stuff i fixed or changed, be it here or in a seperate forum for it. so heh.. just go for it m8.
btw: you can check the actual version of my board @ http://kb.eve-d2.com if youre intersted
//liq
That's the best eve-killboard modification I've seen sofar. Nice looks and improvements Good job. Would be cool if someone put up the source somewhere and added some forums. Sourceforge comes into mind, but is slow as hell and has crappy forums. I could host it myself but tbh I can't be arsed to maintain it, so that would just be silly.
This is rig0r btw, my main account is suspended already =) This one has a month or 2 left
|
krims0n
|
Posted - 2006.09.20 10:48:00 -
[90]
Originally by: NQRott great job rig0r!!!!
i also setup this killboard on my server, it runs fine i can post killmails ingame, pilots and corps were added the map and the portraits are renderd. but no new portraits will appear in the cache dir. anyone an idea?
Check the permissions on the cache directory and more importantly its subdirs. It is safe to set them to 777.
|
|
NQRott
Gallente Netquarter
|
Posted - 2006.09.20 12:56:00 -
[91]
all permission are set right other scripts on my server can wirte
but showd in the caputre_portrai.php there will only the old files in the cache dir delete. i also showed in the used classes, can't find anything in the code which will write the portrais in the cache dir
|
Tehyarec
|
Posted - 2006.09.20 13:41:00 -
[92]
I just installed the killboard. Admin section works etc, but even when using the correct password, I get "You are not authorized to post this killmail" when trying to post a killmail?
|
Joder
Empire Assault Corp
|
Posted - 2006.09.20 13:43:00 -
[93]
nice KB
Been a total noob at stuff like this im having major problems getting this to work Dont wanna spam this forum with all my problems so I would like to offer iskies for help getting this working Contact me ingame on via here!
Thanks
Please resize image to a maximum of 400 x 120, not exceeding 24000 bytes, ty - Cortes |
NQRott
Gallente Netquarter
|
Posted - 2006.09.20 16:17:00 -
[94]
Edited by: NQRott on 20/09/2006 16:19:08 ok i found the bug with my portraits http://img.eve.is/serv.asp looks still down and this is the source for the creation.
@joder go in you database find your corp an check if it the right corp_id go ingame and update your portrait this will also made a new id for the corp if they not exist. if all failed delete your corp in the db and reupdate you char portrait ingame search the ne corp id and update your config.php
p.s. the corp in the killmail have to be the same as yours in the killboard you can't post older killmails if you have changed corp
|
Camaro
Gallente WKK Inc.
|
Posted - 2006.09.20 19:29:00 -
[95]
Edited by: Camaro on 20/09/2006 19:30:29 A kinda dumb reply maybe: I have been trying for hours now, to get the sql7install.sql to work, im not sure what i do wrong.
My site use phpmyadmin
Also, i get the same message as someone else: Database error: Table 'secret_net_-_kb.kb3_ship_classes' doesn't exist SQL: select scl_id, scl_class from kb3_ship_classes where scl_class not in ( 'Drone', 'Unknown' ) order by scl_class
Kindly regards
Camaro
|
Grez
Minmatar The Raven Warriors
|
Posted - 2006.09.20 19:42:00 -
[96]
Something fishy is going on with mine I've tried everything. CHMOD'ing things to 777, changing things around, all to no avail.
For some reason it just doesn't want to access the images (any form of hotlink prevention is disabled).
www.ravenwarriors.com/kb -
Corp: www.ravenwarriors.com Cache Clearer
Still waiting for a Wrangler-edit! |
deanmrd
|
Posted - 2006.09.21 02:27:00 -
[97]
Edited by: deanmrd on 21/09/2006 02:32:16 Edited by: deanmrd on 21/09/2006 02:28:15
Originally by: Joder Edited by: Joder on 20/09/2006 15:35:42
nice KB
edit: Got the killboard up and running...
I just keep getting the problem message of "you are not authorized to post this killmail"
I have entered the corp id (3367) in the config file (alliance is set to 0) and set the PW to post killmail but still no luck.....any ideas?
// corporation or alliance id define( CORP_ID, 3367 ); define( ALLIANCE_ID, 0 );
Thanks
Hi anyone did anyone find the fix to this to this problem?.also get the same message also no portares are showing. also I get on the rental page this : Database error: Table 'cskillz_kb.kb3_rental' doesn't exist SQL: select * from kb3_rental where rtl_site = 'yourkb'
How Do I fine my corp Id?
Regards
Deanmrd
|
deanmrd
|
Posted - 2006.09.21 02:57:00 -
[98]
Edited by: deanmrd on 21/09/2006 02:58:29
Originally by: Sedukan Denaan
Originally by: EvEhate
Originally by: Aeaus Edited by: Aeaus on 11/09/2006 05:20:40 Sorry to see you go. I've always envyed your killboard and now I'm setting one up for my corp (Many thanks). I have a quick question regarding that.
I setup everything per instruction and set up an post password, but when I try to post a killmail it doesn't work, tells me I'm not authorized, any insight?
Edit : Got it.
P.S. You didn't clear everything out.
How did u fixed the Problem?
First you got to find out your CorpID from Table kb3_corps. If you are not yet in the corp table, add your corp with the proper Alliance ID in crp_all_id (14 = None).
Now check your config.php at line 8/9, replace the IDs with your Corp/Alliance ID. The Post page will then accept Mails from your Corp/Alliance Members.
rig0r: Great work by the way, easy to understand and very clean code. Sad to see someone like you leaving the game
Hi there
Need help
Went to my database kb3_corps. went into it could not see a corp id where I do Start by make a table with proper Alliance ID in crp_all_id (14 = None). I am not in a alliance help
Regards
Deanmrd
|
Captain Thunk
Explode. Now. Please.
|
Posted - 2006.09.21 11:02:00 -
[99]
This is a killboard with awesome features, not only that the code is written to a very high standard.
I do have one request, would you be willing to release at least a modified superadmin.php rig0r? I appreciate the full version may have payment features and so on that you may not wish to give out publicly. It would be nice to have access to the deletekill features and so on.
Didn't know you ingame dude, but considering the value of your parting gift, it's only in the end that we realise what we've lost.
CAPTAIN THUNK
If you have a problem, if no one else can help, and if you can find them, maybe you can hire...The ENP-Team. |
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.21 15:10:00 -
[100]
kill_delete.php
Quote:
<? require_once( "db.php" ); require_once( "class.page.php" ); require_once( "class.kill.php" ); $page = new Page( "Administration - Deletion of Kill ID \"".$_GET['kll_id']."\"" ); $page->setAdmin(); $dbconn = new DBConnection(); $kll_id = $_GET['kll_id'];
if ( $_GET['confirm'] ) { $kill = new Kill( $kll_id ); $kill->remove(); $html .= "Kill ID \"".$_GET['kll_id']."\" deleted!"; $html .= "<br><br><a href=\"javascript:window.history.go(-3);\">[go back]</a>"; } else { $html .= "Confirm deletion of Kill ID \"".$_GET['kll_id']."\": "; $html .= "<button onClick=\"window.location.href='?a=kill_delete&confirm=yes&kll_id=".$_GET['kll_id']."'\">Yes</button> "; $html .= "<button onClick=\"window.history.back();\">No</button>"; } $page->setContent( $html ); $page->generate(); ?>
|
|
Captain Thunk
Explode. Now. Please.
|
Posted - 2006.09.21 15:29:00 -
[101]
That's not good enough dude!!!
THE THUNK WANTS TO BE THE SUPER ADMIN!!!
Only joshing with ya dude , no seriously - much appreciated you've taken the time to point me in the right direction.
CAPTAIN THUNK
If you have a problem, if no one else can help, and if you can find them, maybe you can hire...The ENP-Team. |
Tehyarec
|
Posted - 2006.09.21 16:03:00 -
[102]
One thing I can't figure out - sometimes perfectly valid killmails are rejected as being "malformed". These are generally ones that are forwarded or such. They look EXACTLY like the ones that work, but just don't work. I don't get it. There's no reason for this. Eventually the only way they work is to basically take a working killmail and type the correct info over the old one and then post. Copy-pasting some parts onto working killmails works sometimes too, but sometimes also the Destroyed Items get messed up into Involved Parties, ending up with a lot of "Unknowns" in Involved Parties.
Anyone experienced similar issues, and/or know how to fix it? Happens often enough to be quite annoying (with 5 mails out of 48 having done this so far).
Another side effect from this is that now some Statistics are wrong, as I had to delete the malformed attempts many times over by hand from database (didn't notice kill_delete.php - didn't find a way to remove killmails from the killboard itself), and while the kills were deleted, it seems the statistics staid. So for example now I have 16 kills with Catalyst in statistics, should be 4. How to fix that too?
These issues aside, it's certainly a very nice killboard!
|
Captain Thunk
Explode. Now. Please.
|
Posted - 2006.09.21 16:36:00 -
[103]
If it's a forwarded evemail it will have two not one timestamp - the timestamp from the forward and the timestamp from the original mail which the board uses for date of kill. I'd guess this is what's causing you the problem.
CAPTAIN THUNK
If you have a problem, if no one else can help, and if you can find them, maybe you can hire...The ENP-Team. |
Grez
Minmatar The Raven Warriors
|
Posted - 2006.09.21 19:26:00 -
[104]
Anyone know of a way to optimize the way the ! portraits are grabbed/drawn? Sometimes it takes up to 4-6 seconds for them to be drawn/grabbed, which is rather slow. -
Corp: www.ravenwarriors.com Cache Clearer
Still waiting for a Wrangler-edit! |
Tehyarec
|
Posted - 2006.09.21 20:45:00 -
[105]
Originally by: Captain Thunk If it's a forwarded evemail it will have two not one timestamp - the timestamp from the forward and the timestamp from the original mail which the board uses for date of kill. I'd guess this is what's causing you the problem.
If only it were that simple. Like I said, in every single way the non-working mail looks like a working mail, only difference being it doesn't work. For no reason whatsoever. Can be same letter by letter, number by number, line by line, but one works, one doesn't. It's beyond bizarre if you ask me
|
Grez
Minmatar The Raven Warriors
|
Posted - 2006.09.21 21:15:00 -
[106]
Edited by: Grez on 21/09/2006 21:16:37 Due to the state img.eve.is is in at the moment, it takes forever for it to find out that no one has an id of 0, and so it returns a "!" portrait. I decided to edit the way the portraits are grabbed, so that if the id is 0, then it won't look for at img.eve.is for a solution, and take forever if the server is under load.
In common/portrait.php, below the line "$portrait = "cache/portraits/".$id."_".$size.".jpg";", paste the following:
if ($id == "0") { $img = @imagecreatefromjpeg( $portrait ); imagejpeg( $img ); imagedestroy( $img ); exit; } else {
Remember to add a } at the bottom of the code (before it exits the PHP), and you should find loading a lot faster. -
Corp: www.ravenwarriors.com Cache Clearer
Still waiting for a Wrangler-edit! |
cRaNbErRy MuFfInMaN
mUfFiN fAcToRy
|
Posted - 2006.09.21 21:31:00 -
[107]
liquid can you post the code for the ability to post comments and make it so they need a password to also?
Also would it be hard for someone to add in a easy import and export of killmails option? So if members from a corp leave but want there data you could extract and give it to them and they could host the same killboard.net on their own and plug it in?
|
Loyal Servant
Caldari Cornhole Inc. The SUdden Death Squad
|
Posted - 2006.09.22 05:22:00 -
[108]
Since we have all the gurus watching this thread....... I put this killboard up for our corp and got it all working no prob, EXCEPT..... The maps.
There are 3 maps, region, constellation and the last one that shows the system in question as well as the surrounding areas.
2 of the maps draw, the region does not draw... It draws an empty image basically.
Our board is at: http://www.cornholeinc.com
If anyone has an idea, I would appreciate it.
Cornhole, Inc. - Cornholeing eve one system at a time. Member, The Sudden Death Squad [TSDS]
|
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.22 11:08:00 -
[109]
Originally by: cRaNbErRy MuFfInMaN liquid can you post the code for the ability to post comments and make it so they need a password to also?
sorry, but no. besides i think its cooler if even the enemy can comment on kills.
Originally by: cRaNbErRy MuFfInMaN Also would it be hard for someone to add in a easy import and export of killmails option? So if members from a corp leave but want there data you could extract and give it to them and they could host the same killboard.net on their own and plug it in?
wouldnt be too hard. look at pilot_detail.php and just sqldump the output to file.
|
krims0n
|
Posted - 2006.09.22 12:59:00 -
[110]
Originally by: Tehyarec One thing I can't figure out - sometimes perfectly valid killmails are rejected as being "malformed". These are generally ones that are forwarded or such. They look EXACTLY like the ones that work, but just don't work. I don't get it. There's no reason for this. Eventually the only way they work is to basically take a working killmail and type the correct info over the old one and then post. Copy-pasting some parts onto working killmails works sometimes too, but sometimes also the Destroyed Items get messed up into Involved Parties, ending up with a lot of "Unknowns" in Involved Parties.
Anyone experienced similar issues, and/or know how to fix it? Happens often enough to be quite annoying (with 5 mails out of 48 having done this so far).
Another side effect from this is that now some Statistics are wrong, as I had to delete the malformed attempts many times over by hand from database (didn't notice kill_delete.php - didn't find a way to remove killmails from the killboard itself), and while the kills were deleted, it seems the statistics staid. So for example now I have 16 kills with Catalyst in statistics, should be 4. How to fix that too?
These issues aside, it's certainly a very nice killboard!
This could be related to weird characters in the mail like \r\n or tabs. Those are characters you don't see yet they are there and cause screwups (usually only with mails coming from other killboards) The Parser needs some more checks and filters to circumvent this problem.
btw, superadmin.php only had killmail deletion functionality, the Dusk and Dawn version that was posted here does exactly the same, so just use that
(rig0r)
|
|
Grez
Minmatar The Raven Warriors
|
Posted - 2006.09.22 16:27:00 -
[111]
Edited by: Grez on 22/09/2006 16:28:39 I've written a little kill deletion script of my own, I hated having to add the ID into the URL to delete the killmail so, I added a little to liquid's. I'm a PHP novice, so I'm sure this can be optimized, but it works.
[ edit ] Unfortunatly, if I post it, it screws up the entire forum :D, so grab the code here!
You can also add this to admin_menu.php to add "Delete kill" to the admin menu.
$menubox->addOption( "Delete kill", "?a=kill_delete" ); ---
Cache Clearer
Still waiting for a Wrangler-edit! |
TylerJames
Team Americas Black Reign Syndicate
|
Posted - 2006.09.23 02:30:00 -
[112]
does anyone know where you would change the number of pilots shown in the top killers and top scorers on frist page?
|
Ynno
Hunters Agency Firmus Ixion
|
Posted - 2006.09.23 04:07:00 -
[113]
Edited by: Ynno on 23/09/2006 04:08:43
Originally by: TylerJames does anyone know where you would change the number of pilots shown in the top killers and top scorers on frist page?
I haven't tested it, but it looks like lines 89 and 110 in class.box.php
|
Ynno
Hunters Agency Firmus Ixion
|
Posted - 2006.09.23 04:16:00 -
[114]
Edited by: Ynno on 23/09/2006 04:16:20 I was having problems with portraits because allow_url_fopen is false, fortunately we have cURL so I wrote a small workaround which solved it for me and may help others:
I replaced the following in portrait.php: $img = imagecreatefromjpeg( "http://img.eve.is/serv.asp?s=512&c=".$id );
With: $ch = curl_init ( "http://img.eve.is/serv.asp?s=512&c=".$id ); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $image_data = curl_exec ( $ch ); curl_close ( $ch ); $tmpfname = tempnam ( '/tmp', 'eve_fix' ); $fp = fopen ( $tmpfname, 'w' ); fwrite ( $fp, $image_data ); fclose ( $fp ); $img = imagecreatefromjpeg ( $tmpfname ); unlink ( $tmpfname );
|
Scorched Evil
Dark Knights S H I F T
|
Posted - 2006.09.23 10:17:00 -
[115]
I'm having a problem where if I set it to alliance stats and load it up, it seems to be adding any corp in the involved listings of the killmail as though they were part of the alliance. I have 23 corps showing up but only 5 corps in the alliance and I'm curious if this is a problem with my config file or a code thing?
Ive set the corp id to 0, and the alliance id to the proper one in the database. None of the corps in the actual database themselves show up with this alliance so I dont understand why they're being shown on the top corp killers / points for month and all time.
Also how would I remove a corp from the stats if they were to leave the alliance at some point?
Ready for the Dark Side? Join DKFS! Be polite. Be professional. But have a plan to kill everyone you meet. |
TylerJames
Team Americas Black Reign Syndicate
|
Posted - 2006.09.23 13:27:00 -
[116]
Originally by: Ynno Edited by: Ynno on 23/09/2006 04:08:43
Originally by: TylerJames does anyone know where you would change the number of pilots shown in the top killers and top scorers on frist page?
I haven't tested it, but it looks like lines 89 and 110 in class.box.php
this is line 89: for ( $i = 1; $i < 4; $i++ ) {
I messed around with that and had no success...any other ideas?
|
Leilani Solaris
Gallente 0utbreak
|
Posted - 2006.09.23 13:34:00 -
[117]
This thread has now sent my brain spiralling...
|
Ynno
Hunters Agency Firmus Ixion
|
Posted - 2006.09.23 15:18:00 -
[118]
Originally by: TylerJames
Originally by: Ynno Edited by: Ynno on 23/09/2006 04:08:43
Originally by: TylerJames does anyone know where you would change the number of pilots shown in the top killers and top scorers on frist page?
I haven't tested it, but it looks like lines 89 and 110 in class.box.php
this is line 89: for ( $i = 1; $i < 4; $i++ ) {
I messed around with that and had no success...any other ideas?
Yep, that's correct. I have tested it and I was right, but from your post it sounds like you only editied line 89 and not 110 which also needs to be changed.
|
Vito Parabellum
Shiva Morsus Mihi
|
Posted - 2006.09.23 15:22:00 -
[119]
Originally by: liquidism Edited by: liquidism on 17/09/2006 06:25:21 i found a really serious bug.
if you add a killmail without someone having the final blow, because the final blower got truncated (lots of involved players), corrupted information gets into the database (a kill with several NULL fields that cant be read afterwards).
How did you fix this?
|
TylerJames
Team Americas Black Reign Syndicate
|
Posted - 2006.09.23 17:20:00 -
[120]
disregard...got it thanks
|
|
Krhe Khar
Amarr 20th Legion
|
Posted - 2006.09.24 08:35:00 -
[121]
Didnt know u in game rig0r, but its always sad when people leave. Thanks a lot for releasing your code. Just set it up and it seems to work like a charm.
|
Grez
Minmatar The Raven Warriors
|
Posted - 2006.09.24 20:11:00 -
[122]
If anyone has the requirements for this killboard, I don't mind setting them up on a webserver for you (I setup RISE's killboard earlier). Just give me a shout ingame, and I'll do what I can to help. ---
Cache Clearer
Still waiting for a Wrangler-edit! |
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.25 22:18:00 -
[123]
reqs are: php 4, mysql db, some webspace
|
Keldire
|
Posted - 2006.09.26 06:03:00 -
[124]
Originally by: Loyal Servant Since we have all the gurus watching this thread....... I put this killboard up for our corp and got it all working no prob, EXCEPT..... The maps.
There are 3 maps, region, constellation and the last one that shows the system in question as well as the surrounding areas.
2 of the maps draw, the region does not draw... It draws an empty image basically.
Our board is at: http://www.cornholeinc.com
If anyone has an idea, I would appreciate it.
Has anyone found a fix for this yet?
|
Ghen
White Wolves Defence league
|
Posted - 2006.09.26 11:35:00 -
[125]
Originally by: Keldire
Originally by: Loyal Servant Since we have all the gurus watching this thread....... I put this killboard up for our corp and got it all working no prob, EXCEPT..... The maps.
There are 3 maps, region, constellation and the last one that shows the system in question as well as the surrounding areas.
2 of the maps draw, the region does not draw... It draws an empty image basically.
Our board is at: http://www.cornholeinc.com
If anyone has an idea, I would appreciate it.
Has anyone found a fix for this yet?
I assume the cache/map/ directory is writable, do the region images appear blank there? Try removing them and see if they get displayed properly afterwards.
You could also try commenting out lines 111 and 112 in common/class.map.php which fixes a warning and might help:
Quote:
111: Header( "Content-type: image/gif" ); 112: imagegif( $img );
|
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.26 12:37:00 -
[126]
the one with the world_map not rendering drove me nearly insane. i fixed it tho :)
it worked on one of my servers w/o any problems but did not work on the other one.
i can really pinpoint why but it seemed that the dots were not drawn on the first map if the picture was too small.
just take the picture and manually play around with the size parameter.. (eg: /?a=mapview&sys_id=100&mode=map&size=1500) and you will notice the dots stop rendering when going below a certain size. i think it was about 213px with my server but can be diff. with yours.
so here's the solution: open class.map.php and screw around with the ly_ value ( $this->ly_ = 0.4 / 1000000000000000; , line 13) till the dots get rendered with the default 145px big picture. in my case it was this 0.4 (think the orig. value was 0.75 but not sure) the smaller you make this value, the bigger the dots get. so play around till you have a compromise between dots being there and dots being not too big to blob the whole map. also the ($ed = $xscale * 0.75;) thing in line 283 was of some importance, so go and play with the values till you got it.
//liq
|
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.26 12:40:00 -
[127]
to demonstrate what i meant above compare those two links by yourself:
1. http://killboard.eve-d2.com/?a=mapview&sys_id=1932&mode=map&size=122
2. http://killboard.eve-d2.com/?a=mapview&sys_id=1932&mode=map&size=121
only one px difference but the whole map dont gets rendered...
//liq
|
TigCobra
Battlestars Imperium Alliance
|
Posted - 2006.09.27 00:04:00 -
[128]
my images arent showing up any suggestions?
http://eve-battlestars.net
|
Vito Parabellum
Shiva Morsus Mihi
|
Posted - 2006.09.27 02:10:00 -
[129]
found another bug me thinks
When a killmail contains a container (giant sec etc), the container variable is set to 1 and never resets, so everything after it ends up in the "cargo".
fix is to set
$container = false;
below or around (~line 250) $location = ""; in class.parser.php
Did you fix that truncated bug liquidism?
Thanks rig0r for an excellent board and I hope you come back to the game someday! Actually I know you will :P
|
Grez
Minmatar The Raven Warriors
|
Posted - 2006.09.27 16:04:00 -
[130]
Originally by: TigCobra my images arent showing up any suggestions?
http://eve-battlestars.net
Get rid of .htaccess in the main folder, for some reason it borks up on some machines.
Also, anyone else know how to make the class.toplist.php file display ONLY the corps in the alliance in the top corps list? I've been looking at the SQL query in there, and it's beyond my level of PHP. Liquid, perhaps you might know? ---
Cache Clearer
Still waiting for a Wrangler-edit! |
|
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.09.28 00:16:00 -
[131]
Edited by: liquidism on 28/09/2006 00:21:14 Edited by: liquidism on 28/09/2006 00:17:14
Originally by: Vito Parabellum
Did you fix that truncated bug liquidism?
uhm, kinda.. i edited the parser.php so it gives an errormsg like "there is no final blow, please fake one"
|
Ranko
Total Warehouse Logistics Dusk and Dawn
|
Posted - 2006.09.28 00:21:00 -
[132]
I was wondering if anyone can help me, I would like the killboard to not display in weekly, but monthly...
I tried to look at and edit the source code, but to be honest I have no idea what I should be changing and where.
So if anyone can help me out, I would be greatful. ---
|
HyperBeanie
|
Posted - 2006.09.29 06:27:00 -
[133]
Edited by: HyperBeanie on 29/09/2006 06:27:37 The portrait and map is due to cache/* (portraits/maps) not being chmod 777
Just do that form your favorite ftp browser.
If you have a killboard.co.uk system and want to move, i have made a little system to do that: http://ipod.nsbit.dk/tools/
Have fun
/HyperBeanie
|
Idaeus
Gallente Earned In Blood
|
Posted - 2006.09.29 18:51:00 -
[134]
Someone wouldn't happen to have a clean sql dump, with no record of everything except the basics? My webserver keeps choking on the import. :/
+IOI? |
Admentus Cor'vion
Black Avatar Firmus Ixion
|
Posted - 2006.09.30 05:36:00 -
[135]
I think it's great, Rig0r leaves a gift, and they all wanna call him back for tech support. :)
GL. _______________________________________________
Black Avatar - One of the oldest corps in Eve.
"The end and the beginning."
|
Ranko
Total Warehouse Logistics
|
Posted - 2006.09.30 12:06:00 -
[136]
Edited by: Ranko on 30/09/2006 12:11:06
Originally by: Idaeus Someone wouldn't happen to have a clean sql dump, with no record of everything except the basics? My webserver keeps choking on the import. :/
How are you trying to do a server import? via a ssh screen? or via the phpmyadmin system?
If your doing it via SSH, it should work just fine just type in:
mysql -uUSERNAME -p NEWDBNAME < /PATH/TO/INSTALL.SQL
If you are using phpmyadmin, it has a limit if 2meg file import, so give this file a try, its just the normal install.sql file thats been 'bzipped' so it should work just fine.
http://www.sanjiyan.com/files/install.sql.bz
Say if it works or not. ---
|
Grez
Minmatar The Raven Warriors
|
Posted - 2006.09.30 20:48:00 -
[137]
Originally by: Ranko Edited by: Ranko on 30/09/2006 12:11:06
Originally by: Idaeus Someone wouldn't happen to have a clean sql dump, with no record of everything except the basics? My webserver keeps choking on the import. :/
How are you trying to do a server import? via a ssh screen? or via the phpmyadmin system?
If your doing it via SSH, it should work just fine just type in:
mysql -uUSERNAME -p NEWDBNAME < /PATH/TO/INSTALL.SQL
If you are using phpmyadmin, it has a limit if 2meg file import, so give this file a try, its just the normal install.sql file thats been 'bzipped' so it should work just fine.
http://www.sanjiyan.com/files/install.sql.bz
Say if it works or not.
It depends on your server host. Mine has a 51MB limit to SQL database imports. ---
Cache Clearer
Still waiting for a Wrangler-edit! |
Cacia Source
Gallente The Source INC
|
Posted - 2006.10.01 03:02:00 -
[138]
First of all thank you for this parting gift. Sad to see veteran players leave eve, though the reasons are understandable. Secondly, and to the point, how do I change the code to make the board public, so that anyone can post given that they have the correct password. My understanding of it, this code is designed to limit posts by either an alliance or a corporation. I want to be able to host this wonderful board for the general public, who may not have the isk to pay for a nice board and/or those who just dont have sites to host the board.
Anyone can help me out with this? Thanks. |
Pepperami
Art of War Cult of War
|
Posted - 2006.10.01 03:41:00 -
[139]
Sad to leave about you leaving rig0r. Takecare and many very generous of you to provide your excellent killboard for download.
|
Packet Loss
Minmatar Rampage Eternal
|
Posted - 2006.10.01 12:26:00 -
[140]
Originally by: Vito Parabellum
Originally by: liquidism Edited by: liquidism on 17/09/2006 06:25:21 i found a really serious bug.
if you add a killmail without someone having the final blow, because the final blower got truncated (lots of involved players), corrupted information gets into the database (a kill with several NULL fields that cant be read afterwards).
How did you fix this?
I discovered the affects of this bug yesterday (thank you for the delete function in the killmail class )
I've also had killmails which aren't truncated yet still lack the 'laid the final blow' statement in them and thus broke the parser.
I've made some quick modifications that should resolve the issue for others too:
Edit: common/class.parser.php
Add lines in bold to your "Parser" function:
if ( strpos( $this->killmail_, "**** Truncated - mail is too large ****" ) > 0 ) { $this->killmail_ = str_replace( "**** Truncated - mail is too large ****", "", $this->killmail_ ); }
if ( strpos( $this->killmail_, "laid the final blow") < 1 ) { $this->needs_final_blow_ = 1; }
Then add the following bold lines to the "parser" function:
preg_match( "/(.*) \(laid the final blow\)/", $ipname, $matches ); if ( $matches[1] ) { $ipname = $matches[1]; $finalblow = 1; } else $finalblow = 0;
if ( $this->needs_final_blow_ ) { $finalblow = 1; $this->needs_final_blow_ = 0; }
I detect if the killmail contains the required phrase when the class is initialized and set a flag for the instance of the class. Then when running through the involved parties while loop it simply picks the first party (i.e. the highest damage do'er) and assigns them the honor of the final blow :)
I hope its useful :)
|
|
Vito Parabellum
Shiva Morsus Mihi
|
Posted - 2006.10.01 19:00:00 -
[141]
Originally by: Cacia Source ... My understanding of it, this code is designed to limit posts by either an alliance or a corporation. I want to be able to host this wonderful board for the general public, who may not have the isk to pay for a nice board and/or those who just dont have sites to host the board.
Anyone can help me out with this? Thanks.
Board is not made for that purpose so you will have to modify stuff anyway, but to allow everyone to post you can just comment the auth check in class.parser.php at around line 65 and make sure that $authorized always is true. Then in config.php you put alliance and corp ids to 0, this will show all killmails. Everywhere, as kills and losses have lost it's meaning on a public killboard.
Originally by: Packet Loss code
Nice solution, I'll try that, thx :)
|
Mirida
Amarr German Space Corp. G.U.A.R.D.
|
Posted - 2006.10.02 00:54:00 -
[142]
First, a big thanks to rig0r for letting the code go and giving the EVE-Community such a great killboard.
Originally by: liquidism
Originally by: cRaNbErRy MuFfInMaN liquid can you post the code for the ability to post comments and make it so they need a password to also?
sorry, but no.
Too bad that you didn't put it under the GPL rig0r... anyway, i'm currently playing with the it. Some things are wonderful other pretty ugly, currently i'm preparing it for beeing encapsuled by joomla (thats really hard stuff, i don't like it at all) and many other things (config system, portrait handling, security stuff, stuff posted here etc). Once ready i want to release all modifications within the terms of the GPL and set up a svn server for interested people. Current working adress: http://exi.ath.cx/eve/?a=kill_detail&kll_id=2 Stil collecting suggestions so there isn't much done yet.
BTW liquidism, i tracked down your bug with the regionmap (had that one, too hehe): I'ts an issue with GDLIB. Looks like imagefilledellipse() doesnt paint anything if the ellipse is too small on some systems (1px = nothing). Line is 292 on class.map.php but i reordered the whole code so it might be some lines off, just replace the imagefilledellipse() line with that stuff:
Quote:
// bug compat: imagefilledellipse doesnt draw ellipses with 1px size // on some installations if ($ed < 1) { imagesetpixel($img, $px, $py, $color); } else { imagefilledellipse($img, $px, $py, $ed, $ed, $color); }
|
Culmen
Caldari Celestial Horizon Corp. Ascendant Frontier
|
Posted - 2006.10.02 03:57:00 -
[143]
Edited by: Culmen on 02/10/2006 03:57:18
--------------------- Carebear, Until i get my missile skill training done |
Packet Loss
Minmatar Rampage Eternal
|
Posted - 2006.10.02 05:52:00 -
[144]
Originally by: Mirida First, a big thanks to rig0r for letting the code go and giving the EVE-Community such a great killboard.
Originally by: liquidism
Originally by: cRaNbErRy MuFfInMaN liquid can you post the code for the ability to post comments and make it so they need a password to also?
sorry, but no.
Too bad that you didn't put it under the GPL rig0r... anyway, i'm currently playing with the it. Some things are wonderful other pretty ugly, currently i'm preparing it for beeing encapsuled by joomla (thats really hard stuff, i don't like it at all) and many other things (config system, portrait handling, security stuff, stuff posted here etc). Once ready i want to release all modifications within the terms of the GPL and set up a svn server for interested people. Current working adress: http://exi.ath.cx/eve/?a=kill_detail&kll_id=2 Stil collecting suggestions so there isn't much done yet.
BTW liquidism, i tracked down your bug with the regionmap (had that one, too hehe): I'ts an issue with GDLIB. Looks like imagefilledellipse() doesnt paint anything if the ellipse is too small on some systems (1px = nothing). Line is 292 on class.map.php but i reordered the whole code so it might be some lines off, just replace the imagefilledellipse() line with that stuff:
Quote:
// bug compat: imagefilledellipse doesnt draw ellipses with 1px size // on some installations if ($ed < 1) { imagesetpixel($img, $px, $py, $color); } else { imagefilledellipse($img, $px, $py, $ed, $ed, $color); }
I was considering doing the same thing although had intended to try and get hold of Rig0r first.
If Rig0r and/or the community supports it I would like to assist on such a project.
|
HyperBeanie
|
Posted - 2006.10.02 08:01:00 -
[145]
Would be very nice to have a common killboard project going. Get all the nice features implemented ;)
I'm ready to help as much as i can :D
|
M3ta
Amarr
|
Posted - 2006.10.03 12:18:00 -
[146]
It's not gonna happen. Some will implement their own features and use them for themselves while gloating about it (*1), thinking (wrongly) that it will embarass other programmers (yeah right), some others will just rent the KBs for isk.
*1 - forgetting they got the source code for free ------------------------------ loose != lose you're != your it's != its (CCP, fix Moa description) they're != there != their
|
Earthan
Gallente GREY COUNCIL
|
Posted - 2006.10.04 12:08:00 -
[147]
Hello everybody,
Im a programmer but not really into internet stuff and php, so plz dont lauph if its stupid mistake:)
Have set it up , eveyrthing works but "stats" tab
the error i get after clicking it " Database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?a=alliance_detail' at line 3 SQL: select * from kb3_corps where crp_id = 903?a=alliance_detail"
Anyone bumped into it? - A knight in space,war veteran,Grey Council military officer. Grey Council webpage
|
Earthan
Gallente GREY COUNCIL
|
Posted - 2006.10.04 12:20:00 -
[148]
hmm something with alliance identicfication line, commented it left only corp and it works...
still must know whats worng with this alliance line:) - A knight in space,war veteran,Grey Council military officer. Grey Council webpage
|
Earthan
Gallente GREY COUNCIL
|
Posted - 2006.10.04 12:58:00 -
[149]
solved:) - A knight in space,war veteran,Grey Council military officer. Grey Council webpage
|
cRaNbErRy MuFfInMaN
mUfFiN fAcToRy Pirate Coalition
|
Posted - 2006.10.04 23:59:00 -
[150]
150mill for the person who makes an easy import export option for individual characters killmails and provides it for the public or me.
|
|
Laudicia
|
Posted - 2006.10.05 16:50:00 -
[151]
|
Garia666
Amarr adeptus gattacus Lotka Volterra
|
Posted - 2006.10.05 16:51:00 -
[152]
I am a fraid thats this will be a more common sight. its to bad to see ya leave buddy.
Thank you for sharing your data its veyr much apreciated..
GL in your real life..
->My Vids<- |
El Fugelado
|
Posted - 2006.10.05 21:02:00 -
[153]
Awesome share rig0r, i managed to get it workign all but the portraits, im missing in one step of the instalation "- Enable URL file access in your PHP configuration" as i cant manage to find where i have to enable it, if anyone could give me a hand of finding it i'd greately apreciate it.
|
Andrew Gunn
Frontline Defense Force Maelstrom Alliance
|
Posted - 2006.10.06 06:04:00 -
[154]
Edited by: Andrew Gunn on 06/10/2006 06:03:48 Maybe we should setup a forums for the purpose of discussing and adding on to this wonderful piece of software. I've got loads of webspace available and could get one running in a few minutes.
If anyone is interested, grab me ingame. --
Capital Ship Build Info |
krims0n
|
Posted - 2006.10.06 07:55:00 -
[155]
Err well it's not copyrighted or anything. I donated it to the EVE community so don't see the problem.
Setup a forum and a central repository for it and everybody's happy.
- rig0r
(main account disabled)
|
LandoMar
|
Posted - 2006.10.06 21:21:00 -
[156]
Originally by: cRaNbErRy MuFfInMaN 150mill for the person who makes an easy import export option for individual characters killmails and provides it for the public or me.
thats a slighty vague request.
|
Mirida
Amarr German Space Corp. G.U.A.R.D.
|
Posted - 2006.10.07 12:40:00 -
[157]
I'd bet that he wants to export all Killmails belonging to a specific being with options for single or all participated kills and for victim kills.
But thats really vague ;)
Without a bounding license you're legally clear to do everything with it, that's a public release. So you can also take it, add the rental stuff back in and sell killboard slots for interested people.
|
midge Mo'yb
|
Posted - 2006.10.08 01:12:00 -
[158]
Originally by: Lufio II
Originally by: EvEhate Code:
Database error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and shp.shp_class = scl.scl_id' at line 4 SQL: select * from kb3_ships shp, kb3_ship_classes scl where shp_id = here's no value and shp.shp_class = scl.scl_id
Code:
Database error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and kll_fb_plt_id = 27828' at line 10 SQL: select kll_id from kb3_kills where kll_timestamp <= date_add( '2006.08.31 20:12', INTERVAL '15:0' MINUTE_SECOND ) and kll_timestamp >= date_sub( '2006.08.31 20:12', INTERVAL '15:0' MINUTE_SECOND ) and kll_victim_id = 41727 and kll_ship_id = 17 and kll_system_id = here's no value as well and kll_fb_plt_id = 27828
I get this Errors when i will post 2 killmails All others worked fine.Maybe someone understands more mysql then me and can help to Fix the Problem?
(bold added by me)
Find out where in the code those SQL-Statements are hidden and check why the variables that should have values don't have any. As I'm not having the code in front of me or know more circumstances, I can just wish you fun in debugging. The bolded positions are the reason why the statements fail (Unkown ship and unknown System it seems).
i had this, seemed i didnt wait long enough for the querys to run just run the file in phpmyadmin and wait it out, that fixed me anyhow
|
HyperBeanie
|
Posted - 2006.10.08 16:25:00 -
[159]
Originally by: cRaNbErRy MuFfInMaN 150mill for the person who makes an easy import export option for individual characters killmails and provides it for the public or me.
Do you want the killmails exported? Or just some non-humanreadable-but-importable format?
Think the last option is the only one really makeable ;)
|
cRaNbErRy MuFfInMaN
mUfFiN fAcToRy Pirate Coalition
|
Posted - 2006.10.08 22:25:00 -
[160]
Edited by: cRaNbErRy MuFfInMaN on 08/10/2006 22:29:02 looking for a easy import and export option for all killmails involing certain pilots. Like say a guy named Jimmy killed 15 people solo and 15 people in gang. Well thats 30mails, say jimmy leaves corp and startes his own killboard and wants his data. Well i would like to simpley find his character data and select extract and it extracts all kills in a folder which i give to him and he plugs into his eve-net killboard source. fast and easy without haveing to copy and paste each kill text from 1 kb to another.
chilipepper made it so all killmails posted are stored to text files. in a folder on the ftp server.
dunno if that helps
Check out http://dl1.eve-files.com/media/0608/new.jpg |
|
HyperBeanie
Phantom Squad iPOD Alliance
|
Posted - 2006.10.09 18:37:00 -
[161]
Originally by: cRaNbErRy MuFfInMaN Edited by: cRaNbErRy MuFfInMaN on 08/10/2006 22:29:02 looking for a easy import and export option for all killmails involing certain pilots. Like say a guy named Jimmy killed 15 people solo and 15 people in gang. Well thats 30mails, say jimmy leaves corp and startes his own killboard and wants his data. Well i would like to simpley find his character data and select extract and it extracts all kills in a folder which i give to him and he plugs into his eve-net killboard source. fast and easy without haveing to copy and paste each kill text from 1 kb to another.
chilipepper made it so all killmails posted are stored to text files. in a folder on the ftp server.
dunno if that helps
Fixed: For all your import/export needs ________________________________________________
|
cRaNbErRy MuFfInMaN
mUfFiN fAcToRy Pirate Coalition
|
Posted - 2006.10.09 19:26:00 -
[162]
sweet if it works when i try it ill sen u the isk
Check out http://dl1.eve-files.com/media/0608/new.jpg |
HyperBeanie
Phantom Squad iPOD Alliance
|
Posted - 2006.10.11 07:23:00 -
[163]
Got the isk, thanks :D ________________________________________________
|
Gruzar
|
Posted - 2006.10.11 23:14:00 -
[164]
Hi
In the "Pilot Statistics" - "Top Scorers", a player with 100 points when clicked appears with 100 + x points in the "Kill Points". Why does this append? Where does this x points come from? |
TylerJames
Team Americas Black Reign Syndicate
|
Posted - 2006.10.11 23:20:00 -
[165]
Edited by: TylerJames on 11/10/2006 23:20:52 what does the killmail cc function in admin do? does this just send the killmail to an email or will it post the kill to another board?
|
Mining bill
|
Posted - 2006.10.11 23:26:00 -
[166]
Edited by: Mining bill on 11/10/2006 23:25:46
|
pApAYa MuFFinMaN
|
Posted - 2006.10.11 23:27:00 -
[167]
kinda,
but anybody could make it possible to be able to post pre rmr mails? [img="http://www.muffin-factory.com/signatures/papaya.jpg"][/img] |
Andrew Gunn
Frontline Defense Force Maelstrom Alliance
|
Posted - 2006.10.12 03:33:00 -
[168]
I've setup a website to help people in the community get hosting space and forums. It's no where near complete (or even really all that setup), but I've created a forums for the future development of killboards based on the EVE-Killboard.net source code.
Currently it just running some basic phpBB forums, but if I can get some people to help out with the site more stuff should follow.
The website's name is the EVE-Development Network, online at www.eve-dev.net. Contact me ingame if you want to help out with the site or get hosted (alot of times for free). --
Capital Ship Build Info |
HyperBeanie
Phantom Squad iPOD Alliance
|
Posted - 2006.10.12 13:07:00 -
[169]
Do you have access to an SVN server? Would be damn nice to have it online with some version checking!
Contact me ingame if you want to talk/need help. We are some who want to help :D ________________________________________________
|
0rlin
|
Posted - 2006.10.13 15:42:00 -
[170]
I have set the map/portraits folders with needed permittions. I checked the php.ini file for allow_url_fopen = on But I can not seem to get the damn images.
|
|
Andrew Gunn
Frontline Defense Force Maelstrom Alliance
|
Posted - 2006.10.14 03:14:00 -
[171]
SVN server is up and running on the EVE-Dev site, I'll be posting the EVE-Killboard.net source in there. If anyone would like access sign up on the forums or bug me ingame. --
Capital Ship Build Info |
krims0n
|
Posted - 2006.10.16 11:13:00 -
[172]
Edited by: krims0n on 16/10/2006 11:13:35 Nice work. I'll make a link to your site once I shut down eve-killboard.net on november 1st. Would it be possible for you to host the database dump I will provide ? The dump will be pretty big, like around 10-20M compressed.
I also registered on your forum
- rig0r
|
Drracen
Gallente Zanjitsu
|
Posted - 2006.10.17 21:00:00 -
[173]
Great that you released the source code rig0r :-)
I have been trying to get it running on IIS version 6, and everything seems ok, but i have some problems getting the portraits and maps to work.
access rights and all should be in place. running php 4.4.0.0 and MySQL version 4.0.26
Anyone else tried to get it up and running on IIS ?
|
Mirida
Amarr German Space Corp. G.U.A.R.D.
|
Posted - 2006.10.18 23:00:00 -
[174]
Originally by: pApAYa MuFFinMaN Edited by: pApAYa MuFFinMaN on 11/10/2006 23:28:10 but anybody could make it possible to be able to post pre rmr mails?
Perhaps you could convert them ? Never seen pre-rmr stuff so you'd need to supply some of those ;)
|
KIAEddZ
Caldari KIA Corp
|
Posted - 2006.10.24 11:27:00 -
[175]
Lo boys n girls.
KIA are using this kb, Enigma has got it up and running beautifully. But I have a slight problem with it.
Currently it calculates the points scored based upon the type of ship the killer/s is in, and how many they are and the type of ship they kill.
This encourages solo combat, which is not the aim for KIA.
Ideally I would like it to calculate much simpler.
Awarding a number of points depending on the ship class killed (eg 100 for interceptor 500 for Battleship etc) but rewarding the same number of points to each and every pilot on the killmail, irrelevant of how many pilots there are and what ship those pilots are in.
Can anyone shed any light on how the points scoring system works and can be changed?
KIA EVE Home
|
Seleene
Body Count Inc. Mercenary Coalition
|
Posted - 2006.10.24 12:20:00 -
[176]
Originally by: KIAEddZ Can anyone shed any light on how the points scoring system works and can be changed?
Eddz, MC's programming nerds are hard at work on this one. We're still tweaking it to meet our needs but I do know that we've figured out the forumla to this and a lot of other things.
Hit me up on MSN later and let's get our nerds talking to each other. -
Movie: 9UY - Got Fighters? |
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.10.24 15:58:00 -
[177]
Edited by: liquidism on 24/10/2006 16:01:04 whats eddz wants is pretty easy.. here you go
class.kill.php
Quote: function calculateKillPoints() { $ship = $this->getVictimShip(); $shipclass = $ship->getClass(); $points = $shipclass->getPoints();
return $points; }
btw: the scores are always rewared to every pilot on the killmail. eg. a jamming scorp gets the same points as the top damagedealer/final blower
|
AgentDD
Gallente GALAXIAN Rule of Three
|
Posted - 2006.10.25 18:55:00 -
[178]
Edited by: AgentDD on 25/10/2006 19:02:05 Edited by: AgentDD on 25/10/2006 19:01:42 Alright.. I am at a loss on how add my alliance to the DB.. i have myPHP admin running.. can someone give me a hand in adding my Allaince to the DB so i can get it Running Right.. or unless i missed it in the sql import what ever number the Rule Of Three Alliance Is
|
liquidism
Asgard Schiffswerften Dusk and Dawn
|
Posted - 2006.10.26 07:32:00 -
[179]
just look at how the other alliances are setup in the db.. then just copy a row and enter your own data. get the id and enter it in config.php.
pretty straight forward..
|
Mraky
School of Applied Knowledge
|
Posted - 2006.10.26 10:30:00 -
[180]
Database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?a=alliance_detail' at line 3 SQL: select * from kb3_corps where crp_id = xxxx?a=alliance_detail
any1 find what is causing this ? i checked DB ... all thingz are there in config.php i have defined corp ID and ALi ID
any idea how to fix that
|
|
Hotaru Nakayoshi
Amarr United Space Corp with Honorable Intersts G.U.A.R.D.
|
Posted - 2006.10.26 12:21:00 -
[181]
You should not define both ids... if your corp is in an alliance, use the alliance id, else set the corp id.
|
AgentDD
Gallente GALAXIAN Rule of Three
|
Posted - 2006.10.26 19:15:00 -
[182]
i wwas asking for help adding to the DB notthe config.php file.. i know how to do that.. i DON"T know how to use myphpadmin to add to the database.. can anyone help
|
krims0n
|
Posted - 2006.10.28 10:24:00 -
[183]
Edited by: krims0n on 28/10/2006 10:24:03 I have made a database dump today @ 09:15UTC, this is mainly for the current eve-killboard.net customers for importing to their new boards. I have split the dump into several files, to make importing with phpmyadmin a little less painful. Remember, it is one big dump, so you'll have to do some magic to filter out your own corps/alliances mails only. My advise would be to import everything, and afterwards run some sql that removes all irrelevant mails.
eve-killboard-db.zip
- rig0r
|
AgentDD
Gallente GALAXIAN Rule of Three
|
Posted - 2006.10.28 18:03:00 -
[184]
yarrr.. ummmmmmm tahts a hell of an import.. sooo anyway u can help a newbie OUT.. i just need to know how add my allaince to my db.. thats all...
|
ceaon
Gallente Porandor
|
Posted - 2006.10.28 18:16:00 -
[185]
Originally by: Sedukan Denaan
Originally by: EvEhate
Originally by: Aeaus Edited by: Aeaus on 11/09/2006 05:20:40 Sorry to see you go. I've always envyed your killboard and now I'm setting one up for my corp (Many thanks). I have a quick question regarding that.
I setup everything per instruction and set up an post password, but when I try to post a killmail it doesn't work, tells me I'm not authorized, any insight?
Edit : Got it.
P.S. You didn't clear everything out.
How did u fixed the Problem?
First you got to find out your CorpID from Table kb3_corps. If you are not yet in the corp table, add your corp with the proper Alliance ID in crp_all_id (14 = None).
Now check your config.php at line 8/9, replace the IDs with your Corp/Alliance ID. The Post page will then accept Mails from your Corp/Alliance Members.
rig0r: Great work by the way, easy to understand and very clean code. Sad to see someone like you leaving the game
eeeek can u explain 4 n00bs ? i get that but no idea how to fix it
eve news TV |
rig0r
|
Posted - 2006.10.28 22:53:00 -
[186]
Originally by: AgentDD i wwas asking for help adding to the DB notthe config.php file.. i know how to do that.. i DON"T know how to use myphpadmin to add to the database.. can anyone help
insert a new record into the kb3_alliances table. Then stick the all_id that was inserted into your config.php.
|
AgentDD
Gallente GALAXIAN Rule of Three
|
Posted - 2006.10.29 13:06:00 -
[187]
alright.. as i failed to make my self clear to everyone.. i had to get help from a friend.. and we added my alliance to DB using this command. UPDATE kb3_alliances SET all_name='Rule of Three' WHERE all_name='none' then i set the alliance id to 14 in my config.php file.. and all works.. except for that kills arn't being registered unless u search for a players name.. deahts by alliance memebers are being registered under stats and on the front page but not kills.. so i am at a loss as to why this is not functioning correctly any help would be appricated
|
rig0r
|
Posted - 2006.10.29 14:53:00 -
[188]
Originally by: AgentDD alright.. as i failed to make my self clear to everyone.. i had to get help from a friend.. and we added my alliance to DB using this command. UPDATE kb3_alliances SET all_name='Rule of Three' WHERE all_name='none' then i set the alliance id to 14 in my config.php file.. and all works.. except for that kills arn't being registered unless u search for a players name.. deahts by alliance memebers are being registered under stats and on the front page but not kills.. so i am at a loss as to why this is not functioning correctly any help would be appricated
That's not right. Do this to fix it:
update kb3_alliances set all_name = 'None' where all_name = 'Rule of Three'; insert into kb3_alliances values ( NULL, 'Rule of Three', '' ); select all_id from kb3_alliances where all_name = 'Rule of Three';
insert the id you get into your config.php.
|
AgentDD
Gallente GALAXIAN Rule of Three
|
Posted - 2006.10.29 18:09:00 -
[189]
umm i did that it whiped my killboard... and i can't repost old kills that are already posted.. how do i fix that without a reinstall of the Sql file???? argggg
|
rig0r
|
Posted - 2006.10.30 11:36:00 -
[190]
Suggest you all go here for help, discussion & development. Thanks to Andrew
|
|
Jayd Ro
|
Posted - 2006.11.25 22:40:00 -
[191]
someone need to change this nice kb for Kali
|
Andrew Gunn
Frontline Defense Force Maelstrom Alliance
|
Posted - 2006.11.26 20:59:00 -
[192]
Originally by: Jayd Ro someone need to change this nice kb for Kali
Check out the EVE-Development Network, we've made significant upgrades to the killboard software, and on Tuesday when Revelations gets released, Exi will be posting our first stable release, version 1.2. --
EVE-Development Network - Home of the EDK, which is a free, open-source killboard software. |
Jayd Ro
|
Posted - 2006.11.26 21:01:00 -
[193]
you are my Hero¦s
|
|
|
|
Pages: 1 2 3 4 5 6 7 :: [one page] |