Pages: [1] 2 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Baron Holbach
Enterprise Estonia Northern Coalition.
|
Posted - 2011.02.13 13:30:00 -
[1]
http://www.kassikas.net/ratter.zip
simple php+mysql script that download corp wallet transactions and use that data to generate stat about ratting (bountys), mission done (agents, bayouts), officers, faction rats killed, ratting by syste-region, high sec only npc stats etc...
there are simple readme added to zip archive hope this help to set it up :P
|
quintus mioriticus
|
Posted - 2011.02.13 23:56:00 -
[2]
A+ service.
|
Baron Holbach
Enterprise Estonia Northern Coalition.
|
Posted - 2011.02.14 00:07:00 -
[3]
tnx for feedback about week spots in code, i try to improve those spots and put up code with those soon...
|
Solaric Tracker
|
Posted - 2011.02.14 20:49:00 -
[4]
Edited by: Solaric Tracker on 14/02/2011 20:50:23 It would be nice to add a setup.php script. It would ask you for the database, password, UserID and API KEY, etc. Then let it pull the Character ID and have you select from your choices like on EveMon setup. Hard to find your own Character ID number without writing a quick api pull script yourself.
Also after the information is all input you could have the setup.php execute all the sql statements you include to build the tables in your database. This would make setup easier for the new installer.
Thanks for the work you put into this so far and I look forward to playing with it some more.
|
Baron Holbach
Enterprise Estonia Northern Coalition.
|
Posted - 2011.02.15 08:24:00 -
[5]
Originally by: Solaric Tracker Edited by: Solaric Tracker on 14/02/2011 20:50:23 It would be nice to add a setup.php script. It would ask you for the database, password, UserID and API KEY, etc. Then let it pull the Character ID and have you select from your choices like on EveMon setup. Hard to find your own Character ID number without writing a quick api pull script yourself.
Also after the information is all input you could have the setup.php execute all the sql statements you include to build the tables in your database. This would make setup easier for the new installer.
Thanks for the work you put into this so far and I look forward to playing with it some more.
yes, working atm something like this... should be ready in few days
|
netbotix
|
Posted - 2011.02.15 15:38:00 -
[6]
This is great. I would get a hardon if it could somehow compare carebear stats and in same program pulled kills from EDK killboard or something to that extent. Good work.
|
Baron Holbach
Enterprise Estonia Northern Coalition.
|
Posted - 2011.02.15 16:48:00 -
[7]
Edited by: Baron Holbach on 15/02/2011 16:50:59 Edited by: Baron Holbach on 15/02/2011 16:49:49
Originally by: netbotix This is great. I would get a hardon if it could somehow compare carebear stats and in same program pulled kills from EDK killboard or something to that extent. Good work.
truth is that you are not dreaming so much, as i made this program about 2 years ago, this was build build into quite heavy hacked phpbb3 forum db (inside forum there was interface where users was able to select chars that belong to them) and in ratting stat interface there was in every table colum that show user kb stats (all his chars sum) in selected time spawn (not only ratting restults)
atm, i delete all that crap into that code that was related to phpbb (and kb)
i try to to get at-least kb part back into stat code in some form, but this is 2 side thing there are also needed kb mode to fetch pilot killboard activity data (i write custom killboad ext. that gives ability to feed (xml) kills by pilot over selected time - also this need extra tables int ratting db and cron script to fetch that data from db) + all that kb related thing have to be optional
example from old ratting stat page ratting 30d with kb kills
this will be back into ratting stat code, but i want to get first ready some working auto install script
|
Cyno Alt400
|
Posted - 2011.02.26 19:37:00 -
[8]
Cron.php doesn't update the stats .(ever after a week of farming)
|
Baron Holbach
Enterprise Estonia Northern Coalition.
|
Posted - 2011.02.26 19:47:00 -
[9]
Originally by: Cyno Alt400 Cron.php doesn't update the stats .(ever after a week of farming)
sry been busy latly,
http://www.kassikas.net/ratter_dataupdate_fix.zip
this patch should fix data update (replace files inside)
|
Karbowiak
|
Posted - 2011.02.27 02:38:00 -
[10]
Im not supriced that someone in NCdot made this..
Cool project tho, say hi to Vince!
Co-Owner and Creator of EVSCO |
|
Engad Tanon
Caldari Enterprise Estonia Northern Coalition.
|
Posted - 2011.02.28 10:56:00 -
[11]
Originally by: Karbowiak Im not supriced that someone in NCdot made this..
Cool project tho, say hi to Vince!
Haha Karbo. It existed long time before then NCdot.
Please re-size your signature to the maximum allowed of 400 x 120 pixels with a maximum file size of 24000 bytes. Zymurgist |
Karbowiak
|
Posted - 2011.02.28 13:41:00 -
[12]
Originally by: Engad Tanon
Originally by: Karbowiak Im not supriced that someone in NCdot made this..
Cool project tho, say hi to Vince!
Haha Karbo. It existed long time before then NCdot.
Ur such a bear Engad!.. But yeah i guess it was, but still funny to poke the issue
Co-Owner and Creator of EVSCO |
White Red
|
Posted - 2011.03.05 03:47:00 -
[13]
Quote: [Sat Mar 05 06:24:37 2011] [error] [client ***] PHP Notice: Undefined variable: print_out in /var/www/***/data/www/***/ratter/functions.php on line 273
Got this error all the time. file from ratter_dataupdate_fix.zip
|
Baron Holbach
Enterprise Estonia Northern Coalition.
|
Posted - 2011.03.08 09:30:00 -
[14]
Originally by: White Red
Quote: [Sat Mar 05 06:24:37 2011] [error] [client ***] PHP Notice: Undefined variable: print_out in /var/www/***/data/www/***/ratter/functions.php on line 273
Got this error all the time. file from ratter_dataupdate_fix.zip
tnx for reporting fixed, i update simple this patch code so download it (again) and apply to your's http://www.kassikas.net/ratter_dataupdate_fix.zip
|
White Red
|
Posted - 2011.03.08 15:19:00 -
[15]
also some times scipt counts not right. especially in alltime and 30d periods. sums are not equal to quontity of rat multiply to bounty.
one more, script dont work if tax % is not decimal. for example 0.5%
|
Project 69
|
Posted - 2011.03.09 11:21:00 -
[16]
eyo Baron,
I've a similar tool running, but there's one thing that I couldn't figure out (I guess you did).
I guess to see what rats the character has kill you're extracting the "reason" field from the API, but here's the problem I got this is one of my reason fields
Quote: 16982:2,16984:2,16995:7,17000:4,17001:2,17005:2,23984:3,23986:1,23987:1,24014:2,24017:4,24018:2,24087:3,24088:1,24096:1,24097:1,24098:1,...
if you kill a lot of different rats, the reason will get truncated (...).... what if there's some other fancy rats in those 3 little dots?
thanks for your help
|
White Red
|
Posted - 2011.03.09 16:58:00 -
[17]
Each cron.php run make 7MB error.log file with
Quote: [***] [error] [client xxx] PHP Notice: Undefined property: mysqli::$affectedrows in /var/www/xxx/data/www/xxx/rat/functions.php on line 223
plz correct that...
|
Duke Rottingham
|
Posted - 2011.03.10 22:18:00 -
[18]
Quote: [10-Mar-2011 16:16:01] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/imagick.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/imagick.so: cannot open shared object file: No such file or directory in Unknown on line 0 [10-Mar-2011 16:16:01] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/uploadprogress.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/uploadprogress.so: cannot open shared object file: No such file or directory in Unknown on line 0
Getting this error in the logs |
komcc00
|
Posted - 2011.03.11 09:26:00 -
[19]
We have received the following error for cron job:
Warning: Invalid argument supplied for foreach() in /home/xxxxxx/public_html/cron.php on line 56
Warning: min() [function.min]: Array must contain at least one element in /home/xxxxx/public_html/cron.php on line 95
Warning: max() [function.max]: Array must contain at least one element in /home/xxxx/public_html/cron.php on line 95
|
Crassus Detlator
|
Posted - 2011.03.11 16:07:00 -
[20]
Hi, I keep getting the "wrong password" msg...
is there something that needs to be changed in the config.php? if so, could you please detail that?
Thanks!
|
|
Dsan
Bedlam. Waterboard
|
Posted - 2011.03.14 11:47:00 -
[21]
Going to explore this tool or code pack when I'm about done with my new personal website. Am I correct that it should be possible to strip it down so that it just "echo" one characters total income the past 7 days or something similar ?
Also, I see a lot of fix packs and stuff, is there one file I can download so I don't have to fix and data update myself ? which is where it could go wrong :S
Best regards Dsan
|
Baron Holbach
Quam Singulari Session Changes
|
Posted - 2011.03.16 16:28:00 -
[22]
sry been busy lately i try to make new pack with all fixes + fix all bugs in next 1-3 days also if anyone is any questions how to make some "custom" query into ratter db hit my in-game when online
+ i try to add code to use kb interaction then, just want to test it little more, to avoid giving out very broken code
and about this reason field and when to many dif. rats killed, no i haven't find any good fix against that, so there may be that some fancy rats may not be counted :( i think that in api data this can't be done batter than this is currently
|
Mike Lone
|
Posted - 2011.03.16 20:47:00 -
[23]
My corp is useing the 0.1% corp tax but i think this is throwing up the error Warning: Division by zero in running the cron job.
Will there be a fix for this or do i have to have a min 1% corp tax?
Thanks for all your hard work so far :)
|
White Red
|
Posted - 2011.03.18 08:39:00 -
[24]
also ita has trouble with not clearing apicache directory.
|
Baron Holbach
Quam Singulari Session Changes
|
Posted - 2011.03.21 15:58:00 -
[25]
Edited by: Baron Holbach on 21/03/2011 16:02:07 Edited by: Baron Holbach on 21/03/2011 16:00:45 http://www.kassikas.net/ratter_rel01.zip
all bugs reported up-to-now should be fixed, no-new features atm sry :(
* fixed affectedrows error * fixed cron errors with empty result-set * fixed math with corps who tax is not integer number (like 0.1%) * added cleanup to delete all files in apicache directory older than 10 days
+ added changelog.txt
also pls-pls if anyone want to host it for isk or something please don't name yourself as author (save some info about original author(my) in page) tnx
|
White Red
|
Posted - 2011.03.23 08:38:00 -
[26]
Edited by: White Red on 23/03/2011 08:45:47
Quote: PHP Notice: Undefined variable: mission_agents in /var/www/***/data/www/***/rat/index.php on line 614
one more error in logs...
and if possible plz make apicache cleaning delay less. because for 2 days with daily cron apicache grows to 50mb. or make i can clean it manually some how without logging in to hosting panel.
|
Project 69
|
Posted - 2011.03.23 08:59:00 -
[27]
Can we have some more screenshots of this please?
|
Baron Holbach
Quam Singulari Session Changes
|
Posted - 2011.03.23 09:41:00 -
[28]
Originally by: White Red Edited by: White Red on 23/03/2011 08:45:47
Quote: PHP Notice: Undefined variable: mission_agents in /var/www/***/data/www/***/rat/index.php on line 614
one more error in logs...
and if possible plz make apicache cleaning delay less. because for 2 days with daily cron apicache grows to 50mb. or make i can clean it manually some how without logging in to hosting panel.
i will add this how many days api cache will be stored in conf in next release etc.. but 2 days should be minimum as some api data is atm saved about day before fetched again and some backup should be
|
Dsan
Bedlam.
|
Posted - 2011.03.29 09:33:00 -
[29]
Originally by: Project 69 Can we have some more screenshots of this please?
I will try and set this up for my corp before the end of the week, and If I can get it to work I'll link and create some screenshots.
If I can make it work, anyone can. I think the reason why there isn't any screenshots of the result is that this is just the code, it's not an entire site, so you have to create the page and style around it yourself, Ie. what you will see from me is my take on a design for it, and extracting the info I need/want from this :)
Www.dsan.dk www.bedlam.dsan.dk
|
Pehneis
|
Posted - 2011.04.01 18:32:00 -
[30]
Nice work m8
its really really good script.
You have to make a InstallScript with automatic DB import and a little GUI, and your Script kicks ass ;)
go for it
|
|
|
|
|
Pages: [1] 2 :: one page |
First page | Previous page | Next page | Last page |