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
|
|
Dsan
Bedlam.
|
Posted - 2011.04.04 12:24:00 -
[31]
Okay, installed it on my own website now. It currentlyholds no data because my corp has been running without taxes for a while.
But I took a screenshot of how it looks without any modifications to it.
it's over at: www.dsan.dk/dev/eve/screen.jpg
|
Baron Holbach
Quam Singulari Session Changes
|
Posted - 2011.04.04 21:31:00 -
[32]
if anyone want to help, and is good for html/css etc...
take ratter, make it so this feels and seems nice (just one static html page that seems as ratter) and send this html to my (or post here) so i can integrate it to next version....
|
No07
|
Posted - 2011.04.12 07:20:00 -
[33]
Very nice work.
I like that it is very fast with no loadtimes for mysql fetches even on my low-end server.
Are you still working on it? Any more features planned?
|
Dsan
Bedlam.
|
Posted - 2011.04.14 12:51:00 -
[34]
I have been working a bit on styling it a bit, on and off from time to time.
This is what it looks like now: www.dsan.dk/dev/eve
And use "password" as password.
The biggest workload is in styling the content, just stripping all the italic, underline and bold tags out off the code was a bit of a hassle. I'm not sure as to how or what I'm going to do to optimize it. I want to make functions out of it so that you can actually choose and pick the order and which "modules" you want or need to show.
but it's not my code and I have to spend somewhat time on untangeling it and seing where everything flows first :P
Please come with feedback on my "style" and if you are interrested I can post it up somewhere for you.
Best regards Dsan
|
Menekmarti
tDM Drunken Monkeys NUNQUAM RETRO
|
Posted - 2011.04.17 21:37:00 -
[35]
Edited by: Menekmarti on 17/04/2011 21:39:03 Thx for that great script!
Its now looking like that: Linkage
keep up that project! very nice!
|
Baron Holbach
Enterprise Estonia Northern Coalition.
|
Posted - 2011.04.20 09:46:00 -
[36]
Dsan - Menekmarti ... very nice visual modifications can you share you changes so i can add those?
|
Menekmarti
tDM Drunken Monkeys NUNQUAM RETRO
|
Posted - 2011.04.20 12:15:00 -
[37]
Its for my Alli only, but i can make a new one. For everyone!
|
MJ Maverick
IronPig Sev3rance
|
Posted - 2011.04.20 22:20:00 -
[38]
Yeah if you could make a similar one as a template for everyone it would be awesome! :D
------------------ CCP are not perfect. :)
|
Psyrelle
Caldari Saphyron Industrial Division OmniTech Initiative
|
Posted - 2011.04.27 12:22:00 -
[39]
will pay 150m isk for someone to make this work for me
sounds interesting just don't know how to do it.
have own domain for use
and by making it that include simple design or advanced make it work as in work add it to my homepage
|
Menekmarti
tDM Drunken Monkeys NUNQUAM RETRO
|
Posted - 2011.04.29 17:22:00 -
[40]
One more template
|
|
Baron Holbach
Enterprise Estonia Northern Coalition.
|
Posted - 2011.05.06 13:59:00 -
[41]
Originally by: Menekmarti One more template
if you see my online ingame please hit - i would but one of your templates as default for ratter, tnx!
|
Baron Holbach
Ammo and Tag Ninja Unicorns with Huge Horns
|
Posted - 2011.06.19 12:35:00 -
[42]
Edited by: Baron Holbach on 19/06/2011 12:35:40 some improvemtns made, now with google charts
http://www.kassikas.net/ratter_fix_googl.zip <-- replace files inside, function.php and index.php
|
Salli Nerval
|
Posted - 2011.07.22 11:20:00 -
[43]
the fetch is working right my database have all needed values, but on the index.php i see no data. only the corp name anything else....
NO DATA WITH CURRENT FILTER!
|
Baron Holbach
Ammo and Tag Ninja Unicorns with Huge Horns
|
Posted - 2011.07.26 09:57:00 -
[44]
Originally by: Salli Nerval the fetch is working right my database have all needed values, but on the index.php i see no data. only the corp name anything else....
NO DATA WITH CURRENT FILTER!
hard to say like that what my by wrong, but if i'm online you can always convo my ingame (and i'm online quite a lot) |
Fire Beard
Gallente Animosity.
|
Posted - 2011.07.30 22:10:00 -
[45]
Feature requests:
Have a login that lets you view all corps Hide the password from the URL
But its coming along nicely, good job!
Chuck Norris on FIRE!!! |
Erelaszun
No Right Choice
|
Posted - 2011.08.04 18:01:00 -
[46]
Using this now as well... and it works nicely.
Would like to see this turned into a template system, where you can write your own html for the layout, and use tags to place the elements where you want them.
|
Zheng Guo
Community against Justice Shadow of xXDEATHXx
|
Posted - 2011.08.05 21:10:00 -
[47]
i installed it and chronjob works but what is the password i get always
wrong password
corp Id as password dont works what is the Problemp please help
|
Erelaszun
No Right Choice
|
Posted - 2011.08.16 10:57:00 -
[48]
Any word on additional development of this?
|
Krist Jakuard
|
Posted - 2011.09.09 07:30:00 -
[49]
Found Error on Last30Days & Alltime:
Quote: Notice: Undefined index: _kb_kills_30days in \somedir\someplace\ratter\index.php on line 423
Line affected is:
Quote: 423: '_kb_kills_30days' => $current['_kb_kills_30days'],
Found other Error on Last24:
Quote: Warning: number_format() expects parameter 1 to be double, array given in \somedir\someplace\ratter\functions.php on line 254
This repeats 2 times on 24h page. Line affected is:
Quote: 254: return number_format($number,0, ',', '.');
Novice in php myselves so i cant figure it out.
|
|
|
|
Pages: 1 2 :: [one page] |