1 Topic by scosu (edited by scosu 2008-04-30 22:59:22)

  • scosu
  • Member
  • Offline

Topic: [TOOL] StaTee "realtime" stats based on mysql-db

StaTee is a stats program. it shows the statistics of a teeworlds server for the current time. It works with a mysql-database. StaTee has two parts, a java program which parses the serverlog to the mysql database and a PHP script which constructs interactive statistics.
The program just released in version 0.1.1 and is now licensed under the GPLv3.

Some more Informations, Download and the source you can find here: http://statee.scosu.de

on this site you can see some stats: http://teeworlds.scosu.de

some changes for the next version:
- optimization of the tablestructures for faster mysql-queries of php
- banlist for names like "nameless tee" (suggestion of rancor)


please post suggestions, feedback, bugs and everything you want to post on this topic wink

2 Reply by n0nAme.c0re

  • n0nAme.c0re
  • n0nAme.c0re
  • New member
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

A little guide would be nice
What programs i need (mySQL etc.)?

The best Skins from this Forum ;D
http://rapidshare.com/files/104654846/skins.rar.html
.:[GER] Gummibärchen Land:.

3 Reply by scosu

  • scosu
  • Member
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

now i wrote something. i hope it is enough?
http://scosu.de

4 Reply by n0nAme.c0re

  • n0nAme.c0re
  • n0nAme.c0re
  • New member
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

scosu wrote:

now i wrote something. i hope it is enough?
http://scosu.de

Ok thank you ^^

The best Skins from this Forum ;D
http://rapidshare.com/files/104654846/skins.rar.html
.:[GER] Gummibärchen Land:.

5 Reply by Rancor

  • Rancor
  • Donor
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

Hi!

Thanks again for this tool. Works here without a problem... :-)

But there is only one error when i parse my 45MB logfile:

ERROR:-1
java.lang.ArrayIndexOutOfBoundsException: -1
        at Players.validate(Players.java:176)
        at Statee.main(Statee.java:293)

Do you know what this means? Thanks for your reply!

Chris

Visit us @ http://www.prielwurmjaeger.de

6 Reply by scosu

  • scosu
  • Member
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

very amazing. i looked in the code. that error would mean, that somewhere in your log a player with the id -1 killed someone. is it possible, that you compress the log and upload it somewhere?

i just found another bug: the chat on the first gamestats site will never show something...

7 Reply by dreamW

  • dreamW
  • Member
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

maybe that:

[47f49861][register]: fetching server counts
[47f49864][register]: choosen 'master2.teeworlds.com' as master, sending heartbeats
[47f49864][register]: no firewall/nat problems detected
[47f49864][register]: no firewall/nat problems detected
[47f49864][register]: server registered
[47f0c051][game]: kill killer='-1:(invalid client)' victim='0:Jared' weapon=3 special=0
[47f0ce86][game]: join player='9:///ALPINE\\\'
[47f0ce86][chat]: *** ///ALPINE\\\ entered and joined the game
[47f0ce86][game]: team_join player='9:///ALPINE\\\' team=0
[47f0ce88][game]: kill killer='4:thorn' victim='3:Lelouch' weapon=0 special=0
[47f0ce89][game]: pickup player='9:///ALPINE\\\' item=1/0
[47f0ce89][game]: pickup player='9:///ALPINE\\\' item=1/0
[47f0ce86][game]: join player='9:///ALPINE\\\'
[47f0ce86][chat]: *** ///ALPINE\\\ entered and joined the game
[47f0ce86][game]: team_join player='9:///ALPINE\\\' team=0
[47f0ce88][game]: kill killer='4:thorn' victim='3:Lelouch' weapon=0 special=0
[47f0ce89][game]: pickup player='9:///ALPINE\\\' item=1/0
[47f0ce89][game]: pickup player='9:///ALPINE\\\' item=1/0
[47f39397][game]: kill killer='9:///ALPINE\\\' victim='0:STARRANGER 98' weapon=-1 special=3

PS: in my stat i`m got this error too with same player smile (fixed, tnx merdoc for this sample logfile)

8 Reply by Rancor

  • Rancor
  • Donor
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

Mhhh, maybe an bug in teeworlds? Do you still need the compressed statslog?

Chris

Visit us @ http://www.prielwurmjaeger.de

9 Reply by scosu (edited by scosu 2008-04-04 19:40:06)

  • scosu
  • Member
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

i don't know... but thank you dreamW... just working on an update with some bugfixes and an insertion of times to the chatlog.

BTW: the people from gigaliga are playing on your server big_smile

10 Reply by scosu (edited by scosu 2008-04-30 23:00:09)

  • scosu
  • Member
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

the new version is online now... http://statee.scosu.de
i hope all known bugs are fixed with that.

11 Reply by iv_s

  • iv_s
  • New member
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

as i see in the source you start server from java in separate process and parsing its stdout?
(i'm just redirecting stdout to log file and parsing it)
i want to know, is there any protocol to query server? or information in stdout is enough?

12 Reply by scosu

  • scosu
  • Member
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

I don't know of any protocol. the program just get all the information from stdout. but i am not familiar with the teeworlds server.

13 Reply by Rancor (edited by Rancor 2008-07-24 20:30:59)

  • Rancor
  • Donor
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

Hi!

The new version works without a problem, but from time to time i get this warnings in my php logfile:

[12-Jul-2008 02:20:10] PHP Warning:  Wrong parameter count for strstr() in /var/www/twstats/index.php on line 48

Do you know what this means?

Thanks in advance for an reply.

Chris

Visit us @ http://www.prielwurmjaeger.de

14 Reply by scosu

  • scosu
  • Member
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

hi

sorry i can't help you at the moment. i won't do any bugfixes on version 0.1.2 because in some days i will release the next version 0.2.0. so please wait some more time wink

15 Reply by kosmo

  • kosmo
  • kosmo
  • Member
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

does 0.2.0 version of statee support the 0.5.1 game?

~{MS}~ ksm ~{MonkeyStyle}~ - Instagib Teeworlds Clan
VISIT US: http://www.monkeystyle.tk
Check out our IRC channel: #monkeystyle on QuakeNet || Also check out the TeeWiki: http://teewiki.info

16 Reply by scosu

  • scosu
  • Member
  • Offline

Re: [TOOL] StaTee "realtime" stats based on mysql-db

no... 0.3.0 will support 0.5.1 and i'm working on it wink...