open All Channels
seplocked EVE Technology Lab
blankseplocked ratter (php+mysql) - api based ratting, missioning etc.. stat program
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: [1] 2

Author Topic

Baron Holbach
Gallente
Ammo and Tag
Posted - 2011.02.13 13:30:00 - [1]
 

Edited by: Baron Holbach on 19/06/2011 13:36:37
http://www.kassikas.net/ratter_rel01.zip

fix1-1: http://www.kassikas.net/ratter_fix_googl.zip <-- replace files inside, function.php and index.php

simple php+mysql script that download corp wallet transactions and use that data to generate stat about carebearing

* carebearing total by player
* carebearing by system
* carebearing by region
* high sec only carebearing by player
* top carebearing by day
* "fancy" rats kills
* mission rewards by player
* mission rewards by agents
* ratting by npc

most of stats can also be viewed only 1 player view (not hole corp)
one db can hold data for multiple corporatsions

system req.
* php 5
* mysql (in php side mysqli)
* cron for data fetching
* cURL or allow-fopen-url

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
Gallente
Ammo and Tag
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
Gallente
Ammo and Tag
Posted - 2011.02.15 08:24:00 - [5]
 

Edited by: Baron Holbach on 15/02/2011 09:44:23
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

atm i put up little fix for 2 problems that are coming out:

http://www.kassikas.net/ratter_fix1.zip

now work on servers where no f-url-open allowed and fixed cron api cache times calc logic

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
Gallente
Ammo and Tag
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
Please visit your user settings to re-enable images.

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
Gallente
Ammo and Tag
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
Sniggerdly
Posted - 2011.02.27 02:38:00 - [10]
 

Im not supriced that someone in NCdot made this..
Laughing

Cool project tho, say hi to Vince! Wink

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..
Laughing

Cool project tho, say hi to Vince! Wink


Haha Karbo. It existed long time before then NCdot.


Karbowiak
Sniggerdly
Posted - 2011.02.28 13:41:00 - [12]
 

Originally by: Engad Tanon
Originally by: Karbowiak
Im not supriced that someone in NCdot made this..
Laughing

Cool project tho, say hi to Vince! Wink


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 Laughing

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
Gallente
Ammo and Tag
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]
 

Edited by: White Red on 08/03/2011 15:30: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%

and 1 more - after update
Quote:
[Tue Mar 08 18:24:38 2011] [error] [client xxx] PHP Notice: Undefined property: mysqli::$affectedrows in /var/www/xxx/data/www/xxx/rat/functions.php on line 223


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
FW Scuad
E C L I P S E
Posted - 2011.03.11 16:07:00 - [20]
 

Edited by: Crassus Detlator on 11/03/2011 16:41:21
Edited by: Crassus Detlator on 11/03/2011 16:26:55
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!
------------------------------

Nevermind... found my stupid problem.

Another question now...
Do I need the api keys of the corp CEO in order to use this?
Or could I use the this with my own char api keys?
------------------------------

Ok, found the problem...

Everyone trying to use this, be warned: Character must have Accountant or Junior Accountant roles.

Dsan
Nomads
Nulli Secunda
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
Gallente
Ammo and Tag
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
Gallente
Ammo and Tag
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? Question

Baron Holbach
Gallente
Ammo and Tag
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
Nomads
Nulli Secunda
Posted - 2011.03.29 09:33:00 - [29]
 

Originally by: Project 69
Can we have some more screenshots of this please? Question


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

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only