Hi Community,

after a long period of testing, i've finaly released Zitro-Stats. The documentation realy sucks, but with some skills in PHP, database and web server it should be no problem.

http://zitrostats.sourceforge.net/

What does it exactly do?

It's all written on the web site:

"Zitro-Stats is a web based tool providing various statistics from Soldat servers' or clients' log files." ...

nice oLaf!

MercyM see it here: http://soldat.inkompetent.org/snstats/

Wow..this is something like U13SSS. But the player signature's size is againsting the forum rule.
I'll test it anyway.

can't say he doesn't own!

<3 olaf!!!

Mmm, ill dl and test it...

EDIT: Awesome PHP Skills, great script, 10/10

I was going to make one similar to this, that shows kills with respect to time for stuff, but that requires using a table for the stats that is one row per kill.... which is FAR too slow for a server with a large amount of kills. I wrote my own set of scripts which do work like this, but just for fun. On a server with a large number of kills and players (mine currently has about 2.5 million kills, 24,000 players or so), each pageload would take way too long except on the fastest of webservers.

nice work though, I came across this a while back. I originally made mine with the intent of having it work, not look pretty (I have no image skills.... observe my site :P)

nice work overall


edit: plus you got around to adding features that I haven't had the time to code, but have wanted to, mainly the FTP thing. very good

All Stats also have problems with large database, but who cares about things happend one month ago? So Zitro-Stats all information have a limited age after witch they expire. Our clan server also comes along with 250,000 kills per month, but when serving just the last month it's not too slow.
There are only some problems with different MySQL version that need 25 times longer to answer same query. Next week i want to release some fixed versions and still have to write a better documentation :)

EDIT: Still to do are CTF stats. But i don't have an idea which is good enough to work with soldat's asynchronous kill and console log :(

Stats sux!

it's really not necessary, it's just for show, it sux a lot!
pathetic >.<

quote:Originally posted by oLafAll Stats also have problems with large database, but who cares about things happend one month ago? So Zitro-Stats all information have a limited age after witch they expire. Our clan server also comes along with 250,000 kills per month, but when serving just the last month it's not too slow.
There are only some problems with different MySQL version that need 25 times longer to answer same query. Next week i want to release some fixed versions and still have to write a better documentation :)

EDIT: Still to do are CTF stats. But i don't have an idea which is good enough to work with soldat's asynchronous kill and console log :(

And remake the signature so that we can use on this forum.

olaf AIM/MSN me, or meet me on IRC or something, im sure i can help you fix whatever logistical issues you have yet to overcome.
AIM FliesLikeABrick
MSN flieslikeabrick_AT_hotmail_DOT_com
IRC #soldat.forums on quakenet

FLiesLikeABrcik the hero has come to the rescue!
Suggestion: Make more than one stat img, smaller.

er, yeah... and what is with the whole "orange" thing... is fruit somehow associated with soldat, death, and war now?


edit: also, what do you do about logs that contain the soldat log error bug thing (where it skips lines for names beginning with ^ or * )

I was wondering the same...Flies, will you allow me to rip part of your code in statsupdate.php?

gr8 job on the script m8 looks really nice, one quick quastion though are you able to use it to update stats while the server is running because flies' got a prob. with that might have to switch if it does :O lol

quote:Originally posted by FelixStats sux!

it's really not necessary, it's just for show, it sux a lot!
pathetic >.<

...My God... Keep comments like that to yourself, you ungrateful, free-loading.. Never mind...

Anyway, looks great. Very nice job.

I've just released a updated version, which contains some bug fixes which make it easier to install. Signature image is not resized yet, but i'm still working on it :)

http://sourceforge.net/project/showfiles.php?group_id=133660&package_id=146795&release_id=316696

BTW: there's so much 'orange' cause this is the color of lemons. Zitro is the abbr. for Zitroneneis, which simply means lemon ice. This is the hostname of my router, which hosted stats first and where i developed them.

ah, i see the reason for the name now.

but my other questions still stands: what do you do about logs which have the line skipping bug for nicknames which start with * or ^ ?

Ahhh sorry. Forgot to answer. I've written some regular expressions, which walk through the log files:
[code]
--- ((\d{2,4}[\-\/](?:0[1-9]|1[0-2])[\-\/](?:0[1-9]|[1-2][0-9]|3[0-1])) ((?:[0-1][0-9]|2[0-3])):(?:[0-5][0-9]):(?:[0-5][0-9]))\r?\n
((?!--- \d{2,4}[\-\/]\d{2}[\-\/]\d{2} \d{2}:\d{2}:\d{2})(?U)[^\r\n]{1,24})(?:(?<!\s)\([1-9][0-9]*\))?\r?\n
((?!--- \d{2,4}[\-\/]\d{2}[\-\/]\d{2} \d{2}:\d{2}:\d{2})(?U)[^\r\n]{1,24})(?:(?<!\s)\([1-9][0-9]*\))?\r?\n
([\dA-Za-z \-]{1,14})?\r?\n
[/code]

^-- this is finding lines, stating with "---" and a date, followed by two lines with each 1 to 24 chars for the names, followed by a line with 1 to 14 alphanum letters for the weapon. With this RegEx nothing has been wrong interpreted - yet! :)

New Version ist out with some bugfixes again and a rewritten signature, which can be used now in this forum.

very nice oLaf. always liked your stats!! <3<3<3

Can you please help me ? Whenever I try to run "update.php" the browser is trying to download the file instead of executing. The server supports php since I run other php files there with no problems. When I open the file I see this "ERROR: chdir failed!".

I love this! thank you

I have a Problem with Updateing :/

[URL]

Great work dude!!

quote:Originally posted by oLafHi Community,

after a long period of testing, i've finaly released Zitro-Stats. The documentation realy sucks, but with some skills in PHP, database and web server it should be no problem.

http://zitrostats.sourceforge.net/





this looks awesome. we'll try it out!

There is a bug I think. Whenever there is a clan or a player with tags which contain "<sometinghere>" the status gives an error.

tsk tsk, he probably forgot to use htmlentities() before displaying usernames

How I fix that ? I must tell that it ONLY comes with an error if there are the "<>" signs.

can you link me to the page that has the error? i've never used his scripts and i could probably help you out if you show me where the problem is. i browsed your stats pages a bit but couldnt find a page with the problem

Here are 2 examples, thanks:

http://www.soldat-lra.net/?inc=clan&name=%3C%5BWSG%5D%3E
http://www.soldat-lra.net/?inc=clan&name=%3C%7Brsk%7D%3E

I get a MYSQL error when I update: [code] insert newerror mysql_query('REPLACE INTO `weapons`<br />
(`weapon`,`kills`,`last`,`type`)<br />
VALUES ('Grenade',3,'2005-08-22 08:18:14',),('FN Minimi',10,'2005-08-22 08:17:59',),('Ak-74',15,'2005-08-22 08:18:00',),('Spas-12',1,'2005-08-22 08:16:30',),('HK MP5',5,'2005-08-22 08:17:48',),('Steyr AUG',12,'2005-08-22 08:18:04',),('Ruger 77',8,'2005-08-22 08:18:24',),('Desert Eagles',3,'2005-08-22 08:18:09',),('Hands',2,'2005-08-22 08:18:14',),('Barret M82A1',2,'2005-08-22 08:18:21',),('LAW',1,'2005-08-22 08:18:13',)')<br />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 '),('FN Minimi',10,'2005-08-22 08:17:59',),('Ak-74',15,'2005-08-22 08:18:00',),('' at line 3[/code]
Anyone knows how to fix that ?
*Edit: nvm, fixed it.

I'm afraid this isn't working with PHP 4.4.0 + Apache 1.3.33 + MySQL 3.23.56..

Giving error "error mysql_query('DROP TABLE IF EXISTS `clans`;<br />
')<br />You have an error in your SQL syntax near ';
' at line 1" on install.php..

that is a pretty old version of mysql. are you sure that you don't have a newer mysql, and that version number is actually the version of the client libraries that are installed?

well, i think i relly should upgrade to newer, but the never ones i have tried before, havent been working so well, if i remember right your scripts gave me some error when updaring stats with never version... but i still try other version.

what i'm saying, is that i don't think that is the mysql version you are running. That is the version of the client libraries you have installed. I'm guessing you are running mysql version 4.0, which should be fine.


Claw, find that line in the php file, and take the semi-colon out of end of the query. That is the problem

oh, sorry my misunderstanding :)

Oh, i saw it does not work in that way. :/

Hmm, is that 3.xx.xx ONLY WORKING release of MySQL for windows?

Any 4.xx.xx just tells me that it can not connect to MySQL database, and there isn't actually executable file to start it.

okay. this is awesome, but I can't get it to work, in the documentary, I think I might of failed in B02, so maybe some more help.. I'm not sure what to add to there, so I went on to next step, when I try to install it I get this error:
error mysql_pconnect('localhost','ethal','omg1')

and the webhost is (I think) in apache and is php compatible and have mysql..

Edit: nvm problem solved, thank you oLaf, this is so NICE!

error mysql_query('INSERT IGNORE INTO `${PREFIX}clans` etcetcetc...(too long error message)

where excactly I do insert ignore? I'm new in php and mysql...

E: Forgot to tell, this happens when i run the install.php

Hi, can u help with Player Rankings... i want to change ranking from point ranking to K/D ranking... cause points are [CENSORED]ty =)So, how can i do it?

new error:
ERROR: touch for killlog-1.txt failed!
wtf is this ? how to fix ?

How the F*&% is this meant to work? do I drop it in a folder in soldat directory or what?