* July 25, 2014, 11:03:10 PM
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Come Chat with us live! Learn how HERE!
 
   Home   Help Search Login Register  
Pages: 1 2 [All]   Go Down
  Print  
Author Topic: [Today] Tremstats Version 0.5  (Read 19122 times)
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« on: November 24, 2006, 10:24:00 AM »

Heyas,

I know, my plans were different, but there were many little nasty bugs in the parser, which couldn't wait 3 more weeks. So this evening (say, 21 UTC), you will get the newest version of Tremstats.

Here's a list of all improvements:

  • Fixed bug #1
     
  • Fixed bug #2
     
  • Fixed bug #3
     
  • Player search moved to top of the page
  • All columns in the output are sortable now
  • Integrated game-time factor for total efficiency


I think with this you'll get really nice stats now, which are also all right. The update from 0.4.* requires an entire re-parsing of the logfiles. Also, the database structure has changed a little, so you have to rebuild it.

If you find any bugs in it, please don't make the mistake to post them in the comments. Better use the Bugtracker for this, you can find it on http://bugzilla.dasprids.de. There you may also state feature request.

The demo of Tremstats 0.5 can be seen on http://tremstats.dasprids.de/

Download it here:
http://dev.dasprids.de/programs/tremstats/download/
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
Lava Croft
Guest
« Reply #1 on: November 24, 2006, 12:32:07 PM »

*Lava Croft huggles DASPRID
Logged
cp blast


Turrets: +0/-0
Posts: 156


« Reply #2 on: November 24, 2006, 01:34:40 PM »

Nice work! Nice Nice! lol


But you should exclude all "UnnamedPlayer"s...
Quote
Most Active Player     UnnamedPlayer (Games: 252)


...

But like i said, NICE! Smiley
Logged

I'm a Mexican who likes eating tacos and nachos. Are you?
rasz_pl
Guest
« Reply #3 on: November 24, 2006, 03:46:27 PM »

thank you, I can farm my stats again! at last it counts everything Smiley
the only thing to make my a super happy panda now is tremstats on Aliens Wrath Smiley
Logged
Arch_Enemy


Turrets: +0/-0
Posts: 30


« Reply #4 on: November 24, 2006, 03:55:45 PM »

would be cool if u could make the trem stats world- wide for all servers? lol
Logged
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #5 on: November 24, 2006, 04:32:00 PM »

Quote from: "Arch_Enemy"
would be cool if u could make the trem stats world- wide for all servers? lol


I can't.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #6 on: November 24, 2006, 06:02:36 PM »

It's done, get it while it's hot!
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
David
Spam Killer
*
*
*

Turrets: +249/-273
Posts: 3543

David


« Reply #7 on: November 24, 2006, 06:07:11 PM »

Quote from: "DASPRiD"
Quote from: "Arch_Enemy"
would be cool if u could make the trem stats world- wide for all servers? lol


I can't.


but someone else could start a thing, If all the server admins gave them access to the logs....
Logged

Any maps not in the MG repo?  Email me or come to irc.freenode.net/#mg.
--
My words are mine and mine alone.  I can't speak for anyone else, and there is no one who can speak for me.  If I ever make a post that gives the opinions or positions of other users or groups, then they will be clearly labeled as such.
I'm disappointed that people's past actions have forced me to state what should be obvious.
I am not a dev.  Nothing I say counts for anything.
stalefries


Turrets: +2/-0
Posts: 169


WWW
« Reply #8 on: November 24, 2006, 06:12:56 PM »

Wow, TremStats got a nice visual overhaul since I last looked at it. Very nice!
Logged

color=green]:[/color]nac:stalefries
My boring website that you hate | GRAAAAGHH!
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #9 on: November 24, 2006, 06:22:11 PM »

Quote from: "David"
Quote from: "DASPRiD"
Quote from: "Arch_Enemy"
would be cool if u could make the trem stats world- wide for all servers? lol


I can't.


but someone else could start a thing, If all the server admins gave them access to the logs....


What admins would never do ;>
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
David
Spam Killer
*
*
*

Turrets: +249/-273
Posts: 3543

David


« Reply #10 on: November 24, 2006, 06:30:14 PM »

Quote from: "DASPRiD"
Quote from: "David"
Quote from: "DASPRiD"
Quote from: "Arch_Enemy"
would be cool if u could make the trem stats world- wide for all servers? lol


I can't.


but someone else could start a thing, If all the server admins gave them access to the logs....


What admins would never do ;>


why? what is there in a log that is so secretive?
all it would need is a daily cron job to upload the script to some server somewhere.
Logged

Any maps not in the MG repo?  Email me or come to irc.freenode.net/#mg.
--
My words are mine and mine alone.  I can't speak for anyone else, and there is no one who can speak for me.  If I ever make a post that gives the opinions or positions of other users or groups, then they will be clearly labeled as such.
I'm disappointed that people's past actions have forced me to state what should be obvious.
I am not a dev.  Nothing I say counts for anything.
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #11 on: November 26, 2006, 11:32:51 PM »

Important note for all server admins:

To get propper results, you have to turn of unbuffered logging. So add the following line to your server.cfg:

Code:

set g_logsync 0
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #12 on: November 26, 2006, 11:56:57 PM »

Uhm, just found another bad bug with the parser and copying the logfiles. I will write a patched version tomorrow.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #13 on: November 27, 2006, 10:34:14 PM »

Tremstats 0.5.1 out.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
rasz_pl
Guest
« Reply #14 on: November 27, 2006, 10:38:42 PM »

still http://tremstats.dasprids.de/player_details.php?player_id=77 shows peak kill count in the 40s, and Im sure you remember yesterdays game where I had 80 kills
Logged
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #15 on: November 28, 2006, 07:56:08 AM »

Sure, but the logs of that are corrupted thanks to the bug. So I can't count them anymore, sorry.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
Greudin

*

Turrets: +1/-1
Posts: 131

8R33k020ph7^^


WWW
« Reply #16 on: December 01, 2006, 09:15:15 PM »

Quote from: "David"
Quote from: "DASPRiD"
Quote from: "David"
Quote from: "DASPRiD"
Quote from: "Arch_Enemy"
would be cool if u could make the trem stats world- wide for all servers? lol


I can't.


but someone else could start a thing, If all the server admins gave them access to the logs....


What admins would never do ;>


why? what is there in a log that is so secretive?
all it would need is a daily cron job to upload the script to some server somewhere.


For that big server logs parser, I can provide about 150 MB of logs, filled with insults, tking but nice things also :8)
Logged

url=http://tremulous.bricosoft.com][/url]
rasz_pl
Guest
« Reply #17 on: December 03, 2006, 02:01:59 AM »

am I stupid or do you have a nice field called `building_icon`containing file name in buildings table, and then in maps table you retarted'ly (Tongue) store a FOKIN PNG image inside a database?Huh?? btw my mysql just  throws out on that part and refuses to import.
Logged
Greudin

*

Turrets: +1/-1
Posts: 131

8R33k020ph7^^


WWW
« Reply #18 on: December 03, 2006, 11:49:00 AM »

Quote from: "rasz_pl"
... btw my mysql just  throws out on that part and refuses to import.


Got the same pb, remove INSERT into maps lines to import data.sql without errors.

Perform a ./tremstats.py --pk3only to refill the maps table.

Ty DASPRiD for this new version and for help to upgrade it Smiley

http://tremx.bricosoft.com
Logged

url=http://tremulous.bricosoft.com][/url]
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #19 on: December 03, 2006, 01:52:52 PM »

Quote from: "rasz_pl"
am I stupid or do you have a nice field called `building_icon`containing file name in buildings table, and then in maps table you retarted'ly (Tongue) store a FOKIN PNG image inside a database?Huh?? btw my mysql just  throws out on that part and refuses to import.


Thats because the levelshots have to be getable without having parser and webserver on the same server.

Btw, the SQL-bug is fixed in SVN version.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
squishy


Turrets: +1/-0
Posts: 91


« Reply #20 on: December 04, 2006, 02:38:32 PM »

Any one have stats on this parser - How long does it take to parse a large log file (>100Mb)?

Just curious if it's worth using at this point.
Logged

--df
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #21 on: December 04, 2006, 04:12:56 PM »

This depends on your machine. Parsing a 300 MB logfiles takes my server 5 minutes.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
squishy


Turrets: +1/-0
Posts: 91


« Reply #22 on: December 04, 2006, 05:09:31 PM »

Running into some errors testing the tool. I haven't looked at your code, but I assume you are trying to move the original file instead of just copying it? To my knowledge, this won't work on Windows unless the server is shutdown.

Quote
Renaming original logfile ...
Traceback (most recent call last):
  File "D:\temp\trem\logger\tremstats.py", line 142, in <module>
    app.Main()
  File "D:\temp\trem\logger\tremstats.py", line 63, in Main
    parser.Main(self.dbc, self.Check_map_in_database, self.games_log, self.stati
c_log)
  File "D:\temp\trem\logger\internals\log_parse.py", line 49, in Main
    self.Log_read()
  File "D:\temp\trem\logger\internals\log_parse.py", line 106, in Log_read
    os.rename(self.games_log, source)
WindowsError: [Error 13] The process cannot access the file because it is being
used by another process
Logged

--df
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #23 on: December 04, 2006, 05:23:21 PM »

True, I'm renaming it, because the pointer of the application should move with to a temporary position. But who is really running a dedicated server with windows os?
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
squishy


Turrets: +1/-0
Posts: 91


« Reply #24 on: December 04, 2006, 05:24:38 PM »

Just found your static variable. Might be worth putting that in your config file with a bit of instruction.

//nevermind. this still doesn't fix the issue.
Logged

--df
squishy


Turrets: +1/-0
Posts: 91


« Reply #25 on: December 04, 2006, 05:25:28 PM »

Quote
But who is really running a dedicated server with windows os?


To my knowledge, quite a few of us!
Logged

--df
squishy


Turrets: +1/-0
Posts: 91


« Reply #26 on: December 04, 2006, 08:29:57 PM »

Made a quick mod to your code to get things working. Instead of moving/copying the log all over the place, I just set things to copy the log to an archive directory. The code then sifts through the "last version" and compares it with the current copy. This ensures that we don't process the same data twice. Once done, it turns the current copy into the "last version".

This is the only solution I can think of for a Windows setup - without shutting down the Trem server to release the log that is.

This is how my current stats solution works, and I figured it'd work here while I'm testing your stats tool.
Logged

--df
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #27 on: December 04, 2006, 08:45:38 PM »

Well, and how do you ensure, that the parser gets only logfiles beginning with an "init" and ending with a "shutdown"? Or how do you ensure, that you don't copy the file while Tremulous is writing to it?
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
squishy


Turrets: +1/-0
Posts: 91


« Reply #28 on: December 04, 2006, 08:57:42 PM »

I'm not sure I see your solution for such issues. Unless I'm overlooking it.
Logged

--df
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #29 on: December 04, 2006, 09:15:14 PM »

The renaming is the solution Wink. Because on Linux the file-pointer is moved. Read the 3rd news on dev.dasprids.de for explanition.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
squishy


Turrets: +1/-0
Posts: 91


« Reply #30 on: December 04, 2006, 09:27:46 PM »

Thanks, DASPRiD. That's helpful, but let me see if I get this straight.

You are renaming the games.log to games.log.tremstats.tmp. Tremulous will continue to write to this TMP file until a game completes. Tremulous then creates a new games.log. Now TremStats will process the tmp file?

I assume this is a non-Windows tremded feature.

The only option I could work out in Windows would be to add a check for the last instance of ShutdownGame, and ignore the rest until next time around.
Logged

--df
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #31 on: December 04, 2006, 09:56:18 PM »

You got it, that's the way I work Smiley

By the way, if you got a running workaround for windows, I may implement it in the svn-version. Just send me the patch.

If you do so, please checkout the latest version from SVN:

http://svn.dasprids.de/repos/tremstats/trunk/
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
squishy


Turrets: +1/-0
Posts: 91


« Reply #32 on: December 05, 2006, 01:20:32 PM »

Finally got things working. First I copy the log to the archive directory. Then I strip unwanted ending lines from the log (everything after the last ShutdownGame) - this removes unfinished games. Then we compare the file with the "last version" and process new games.

I'll try to work my method into the latest SVN and post for your review.

May need to create a variable in config for the user to tell whether they are using a Windows server or not.
Logged

--df
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #33 on: December 05, 2006, 07:53:10 PM »

No need to:

Code:

import sys

if sys.platform == 'win32':
  print "I am windoze."
else:
  print "I am some good OS."


And btw, wht exacly do you do with the stripped line? Do you drop them?
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
squishy


Turrets: +1/-0
Posts: 91


« Reply #34 on: December 05, 2006, 08:07:50 PM »

They are dropped. They would get picked up the next time around.
Logged

--df
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #35 on: December 05, 2006, 08:15:16 PM »

Ah ok, then it's fine.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
squishy


Turrets: +1/-0
Posts: 91


« Reply #36 on: December 05, 2006, 09:39:47 PM »

Just pulled down the SVN and input my changes. Here is a ZIP file including the changes and a small changelog noting the lines I updated.

Feel free to contact me via ICQ or PM to discuss...

//**URL REMOVED**//

//I also added a tally of "says" for the players table, so I could display Most Talkative on my stats page. This change is represented in structure.sql and data_calc.py
Logged

--df
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #37 on: December 05, 2006, 10:40:41 PM »

Alright, I'm going to contact you per ICQ.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
rasz_pl
Guest
« Reply #38 on: December 12, 2006, 04:36:04 PM »

I think that "time factor" is wrong and should be abandoned. Its a buggy patch over a bug. It makes average server campers look better than good players with real life Tongue.

 Better way is to sort ppl according to the kill effeciency, and then (multiply kill effeciency of ppl player killed[or number from the sort above] x times he killed them)/ total kills, and then sort on this number. ppl with 2-5 games played usually have low chance to meet good players, and if they do they dont make >10 kill effeciency Smiley, and if they DO then they are really good (they managed 10 kill effeciency against other good players).

That would factor out the time spend on the server, and really compare players against each other. Killing feeder n00bs would lose importance.
Of course it would be even better if the parser would store class of killed player (now it only stores class/weapon of the attacker), then we could also factor tyrrant pwning naked rifles and dretch killing BSes. Imo it should be in the next version.

PS1:
and just to back up with a strong argument Tongue look at

29   5555555555555555555555555]
Game-time factor   0.01
Kills   20
Total Deaths   2
Kill Efficiency   6.67

34   Xonya[FI]
Game-time factor   0.04
Kills   395
Total Deaths   228
Kill Efficiency   2.47

I mean LOL, Xonya is a good player, she kills me a lot, and there we have some lamer who happened to play twice pwning n00bs left and right (maybe he joined at S3 and ran arround with camped pulse/lucy after dretches?) 5 places higher than her ... cmon, the main table MUST be relative, each player compared with every other equally. Its not fair to just factor time spend on a server and act like its all good in the hood.

PS2: and no, im not ranting because Oli is about to take first place because he camped bigger time factor than me Tongue :] hehe. Actually I didnt even tried my formula yet on the dataset you send me and dont know where I will end up :/
Logged
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #39 on: December 12, 2006, 06:28:23 PM »

So you want a player with one 1 game played and 100 kills / 0 death against noobs to be on first place? :roll:
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
David
Spam Killer
*
*
*

Turrets: +249/-273
Posts: 3543

David


« Reply #40 on: December 12, 2006, 06:34:09 PM »

Make it (kills-deaths)/time or whatever, and then do <25 games = not on the list.
Logged

Any maps not in the MG repo?  Email me or come to irc.freenode.net/#mg.
--
My words are mine and mine alone.  I can't speak for anyone else, and there is no one who can speak for me.  If I ever make a post that gives the opinions or positions of other users or groups, then they will be clearly labeled as such.
I'm disappointed that people's past actions have forced me to state what should be obvious.
I am not a dev.  Nothing I say counts for anything.
squishy


Turrets: +1/-0
Posts: 91


« Reply #41 on: December 12, 2006, 06:36:46 PM »

//NEVERMIND!
Logged

--df
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #42 on: December 12, 2006, 06:38:56 PM »

Quote from: "digifad"
One negative I've found is that player_games_played includes spec-only connections.


It doesn't. If you spec, you get no kills/deaths/teamkills. If you have zero of them overal, you don't get plus one player_games_played.

Quote from: "David"
Make it (kills-deaths)/time or whatever, and then do <25 games = not on the list.


Thats nearly the way I do it, but it's more complex.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
squishy


Turrets: +1/-0
Posts: 91


« Reply #43 on: December 12, 2006, 06:39:41 PM »

I just saw the line in the source. Sorry!
Logged

--df
rasz_pl
Guest
« Reply #44 on: December 12, 2006, 07:38:17 PM »

Quote from: "DASPRiD"
So you want a player with one 1 game played and 100 kills / 0 death against noobs to be on first place? :roll:


OH F... I wrote A4 poem about it and fokin browser refreshed the page, oh CRAP !!!
anyway

(multiply kill effeciency of ppl player killed x times he killed them)/ total kills

so for your player, lets say he killed 100 times this n00b (sorry Tric Tongue)
http://tremstats.dasprids.de/player_details.php?player_id=2161

0.86 x 100/100 = 0.86, he is as "good" as the ppl he killed. Now I see that my equation is missing the second part

(multiply kill effeciency of ppl that killed player x times they killed him)/ total deaths

so we have to ignore ppl with ~<10 deaths to not skew the statistic, or ~<10 deaths and above 100 kills.

then we can do (multiply Destruction Efficiency of ppl player killed x times he killed them)/ total kills * player Destruction Efficiency .. or not Tongue

 first both numbers are better while bigger, we could multiply them with each other or do some other fancy stuff with them, but essentially I want THOSE numbers to decide, not some artificial "I play here every day so I pwn" factor Smiley

Its kinda hard to avoid killing noobs, so its highly unlikly that someone will thrive selectively killing only good players Smiley, on the other hand avoiding getting killed is a skill no matter who tries to kill you Smiley

hmmm hmm, ok,  good players playing only with good players, this can be a problem. It will make ppl playing with n00bs look bad. There must be something smart, that has nothing to do with how much you camped the server Smiley

hmmm maybe we should compute kill efficiency individually for every map played, and THAT number would multiply against
(multiply kill effeciency of ppl player killed x times he killed them)/ total kills on that particular map

 Oh cmon, work with me, throw me a bone here.


ps: one PAINFULL thing is lack of parsing into the database the class/weapon of the player that died (I know it needs patching to have that info). Its one thing to dretch a BS and die 3 times in the process, its the other to tyrr 30 naked rifles. Same goes the other way arround, one thing to die by the tyrr, the other one to get dretched while armored/hatted/shotgunned/and nade loaded Smiley
Logged
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #45 on: December 12, 2006, 07:58:55 PM »

Btw, you totaly forgot the destruction efficiency. Tremulous is not about just killing everyone. Anyway, the game time factor has just another effect: If you stop playing on the server, your efficiency gets down and you get out of the top-stats.

But we could modify the algorithm so regular players don't see a big difference in their gtf.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
rasz_pl
Guest
« Reply #46 on: December 12, 2006, 08:18:09 PM »

Quote from: "DASPRiD"
Btw, you totaly forgot the destruction efficiency. Tremulous is not about just killing everyone.


no I didnt Tongue
>then we can do (multiply Destruction Efficiency of ppl player killed x
>times he killed them)/ total kills * player Destruction Efficiency .. or not

Quote from: "DASPRiD"
But we could modify the algorithm so regular players don't see a big difference in their gtf.


Could you at least make those
(multiply kill effeciency of ppl player killed x times he killed them)/ total kills
(multiply kill effeciency of ppl that killed player x times they killed him)/ total deaths

a part of the equation? Tongue
Logged
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #47 on: December 12, 2006, 08:22:27 PM »

ah, to compare them with eachother... hmmm, sounds like a good addition, i'll test it if i find some time. btw, let's not use the forum as chat, contact me over icq, jabber or irc.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
rasz_pl
Guest
« Reply #48 on: December 14, 2006, 06:41:43 AM »

soo wazzup with Tremstats v0.6.0?
what is a Games paused?

anyway I like it (since Oli is no longer a threat Tongue)
Logged
vcxzet
Guest
« Reply #49 on: December 14, 2006, 08:14:18 AM »

does it list how many tyrants you killed?
Logged
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #50 on: December 14, 2006, 11:38:01 AM »

rasz_pl:

Games paused is how many games you have paused. There are 2 treshold variables in the config now: games_played and games_paused. The first indicates, with how many games min played you get in the list. The standard for this is 25. the games_paused treshold means, how many games you can max have paused before you get out of the list, standard is 500. If you start playing again, you get immediently back in the list with your old stats.

Also, I found a good use for the Game-time factor: It's used for the most active players, instead of just the games played.

vcxzet:
It's not listed yet, what exacly you killed how often, but this will follow.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
rasz_pl
Guest
« Reply #51 on: December 15, 2006, 05:20:47 AM »

Quote from: "DASPRiD"
rasz_pl:

Games paused is how many games you have paused. There are 2 treshold variables in the config now: games_played and games_paused. The first indicates, with how many games min played you get in the list. The standard for this is 25. the games_paused treshold means, how many games you can max have paused before you get out of the list, standard is 500. If you start playing again, you get immediently back in the list with your old stats.

Also, I found a good use for the Game-time factor: It's used for the most active players, instead of just the games played.

vcxzet:
It's not listed yet, what exacly you killed how often, but this will follow.


1 so if i pause for >xx games i get dropped back? sounds ok
2 Queen of scotland landed higher than me, so we need to tweak the algo once again :]

>ps: one PAINFULL thing is lack of parsing into the database the class/
>weapon of the player that died (I know it needs patching to have that >info). Its one thing to dretch a BS and die 3 times in the process, its the
>other to tyrr 30 naked rifles. Same goes the other way arround, one
>thing to die by the tyrr, the other one to get dretched while armored/
>hatted/shotgunned/and nade loaded

MDing poor dretches with 500-600 credits worth of equipment should not be equal to dretching 500-600 cred humans Smiley

if we could only parse the info about class/equipment of the killer and the killed person, we could come up with some weight system. For example the percentage ratio between alien class HP and dps vs human hp * armory class(can be tricky, different armory areas/hit zones) and weapon dps.
Logged
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #52 on: December 15, 2006, 08:12:18 AM »

And can't repeat often enough, there are no hp's logged, and I can't base the entire kill efficiency on something non-standard. Only with the Client_TeamClassPatch I firstly always know, who's playing which class. Before, I only know, whom you killed with which weapon.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
rasz_pl
Guest
« Reply #53 on: December 15, 2006, 09:39:06 AM »

Quote from: "DASPRiD"
And can't repeat often enough, there are no hp's logged


>I know it needs patching to have that info
Logged
DASPRiD
Administrator

*

Turrets: +21/-2
Posts: 549



WWW
« Reply #54 on: December 15, 2006, 12:48:29 PM »

Right, and not everyone want's to patch his server, so I can't base the calculation on this.
Logged

url=https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mail%40dasprids%2ede&item_name=DASPRiD%27s&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=DE&bn=PP%2dDonationsBF&charset=UTF%2d8][/url]
rasz_pl
Guest
« Reply #55 on: December 15, 2006, 01:28:36 PM »

Quote from: "DASPRiD"
Right, and not everyone want's to patch his server, so I can't base the calculation on this.


that could be an option for anal numbern00bs like me Smiley just add 3 more fields to the KILL table and let admins use normal logs (ignoring those fields) or pathed (using them)
or not, just throwing ideas out loud

edit: actually you can partially kinda almost guess what was the class/weapon of the killed person, just make the parser ass_ume that after the last person the killed one killed he didnt evo/buy, and write to the database his last known evo/weapon Smiley
Logged
Pages: 1 2 [All]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC
TremPlus theme by Ingar, based on AF316 theme by Fedhog
Valid XHTML 1.0! Valid CSS!