Tremstats Slux's Mod

[slux_ITA]

this topic is about an old version of tremstats, it probably won't work with any recent game.qvm's. it's here for archival purposes -kev


Hello guys!

I have created a patch for Tremstats-0.6!  

The most important feature consist in the use of the player Qkey as "unique" ID for tjw clients... this fix the multi-nick problem as you can see here:


The statistics are more rigorous because the player now is identified by his TJW ID!

All the alias are show:


The changelog:

Code:

* Added unnamed name as parameter (for Lakitu7's patch)
* Added Qkey support (fixed the multi-nicks probem for the same TJW client)
* Added possibility to show all nicks used by a TJW client in the player page
* Extended the Database structure
* Adapted the search engine to multi-nicks

The patch:
http://www.capponcino.it/alessio/files/sviluppo/tremstats_mod/tremstats.slux.patch

As an alternative you can get the tremstats already patched by myself!
http://www.capponcino.it/alessio/files/sviluppo/tremstats_mod/Tremstats_slux-mod.tar.gz
 

[CreatureofHell]

This belongs in the Mods section but I like the fact that all the names are then combined into one person.

[slux_ITA]

This belongs in the Mods section but I like the fact that all the names are then combined into one person.

Thanks!

naturally only clients with the tjw have this feature... the others have the same handling seen in the 0.6 version  

[Rocinante]

Questions:

1) Is it as simple as adding the new row to the users table for this to work?
2) What will happen with existing nicks in the database?  Will it merge them properly, say, if I login with one name and /name to the aliases I'd used in the past?

If I'm reading it right, and I add the row to the table, then since it's blank it'll treat someone as if they're a new player since they had no GUID stored before and now have one

[slux_ITA]

1) Is it as simple as adding the new row to the users table for this to work?

as you can see, i use a `nicks` table that store all alias used by tjw clients... In this way the `players` table is normalized!

Obviously, to use this patch/mod you must re-make the database (using the scripts into sql/) and reparse all your logs, putting these into `parser/archived_logs`

2) What will happen with existing nicks in the database?  Will it merge them properly, say, if I login with one name and /name to the aliases I'd used in the past?

this mod is not compatible with the old database...
so, when a client connect for the first time, it will be added and the actual nick become the `master`. All the future nick change are added into the `nicks` table and these are related with the player through the qkey! :roll:

If I'm reading it right, and I add the row to the table, then since it's blank it'll treat someone as if they're a new player since they had no GUID stored before and now have one

:eek: what does it mean?

[Rocinante]

If I'm reading it right, and I add the row to the table, then since it's blank it'll treat someone as if they're a new player since they had no GUID stored before and now have one

:eek: what does it mean?

Nothing bad for the patch - I was just muttering aloud as I read through it :>  Basically that there's no simple way to "upgrade" from 0.6 to 0.6+patch, but like you said one must instead wipe the database and start over.

In other words, I'll install this sometime when I feel like it, not quickly when I have a moment  

[slux_ITA]

btw, the best way to pass from 0.6 to 0.6+patch is a simple --reparse  

I see how the `says` table have a lot of duplicanted rows for the same player...  :-? maybe soon i release some fixs  

[Oblivion]

I like what you did, but why cant you just make it show 1 name that they recently used, instead of searching the player it shows all of there names in the database.
You also mind telling me what I do with this patch?  Where do I place it.

[CreatureofHell]

Why would you want to only show one name? It wouldn't have much of a point then.

[slux_ITA]

I like what you did, but why cant you just make it show 1 name that they recently used, instead of searching the player it shows all of there names in the database.

mmh.. if i save only the recently used name instead of all, when i search a player maybe i don't find it because you have inserted an alias of the original player.

Example: i enter for the first time on a server and my current name is "alessio"; in this case, "alessio" is my master name related with my Qkey.

next time, i login with my real nick ("slux"), and the sistem save this alias...
Now we have people that know me as "alessio", and others know me as "slux"! so, if a player search "alessio" or "slux" he find the same player!:D

You also mind telling me what I do with this patch?  Where do I place it.

it's very simple:

0) get tremstats.slux.patch
1) get tremstats-0.6
2) Extrat: tar xfvz Tremstats-0.6.0.tar.gz
3) cd Tremstats-NightlyBuild-Rev-58/
4) cat /where/you/have/tremstats.slux.patch | patch -p1

and the output must like this:

Code:

slux@skynet[~/temp]
~> cd Tremstats-NightlyBuild-Rev-58/
slux@skynet[~/temp/Tremstats-NightlyBuild-Rev-58]
~> cat ../tremstats.slux.patch | patch -p1
patching file ChangeLog
patching file parser/config.py
patching file parser/internals/log_parse.py
patching file parser/tremstats.py
patching file sql/structure.sql
patching file web/player_details.php
patching file web/search_player.php
patching file web/skins/default/default/skin.css
patching file web/templates/default/__footer__.tpl.php
patching file web/templates/default/player_details.tpl.php
patching file web/templates/default/search_player.tpl.php

 :wink:

[Oblivion]

Hell you lost me at 3 and 4.

[slux_ITA]

Hell you lost me at 3 and 4.

mm in the point 3 just enter into the tremstats-0.6 (the original by dasprid) directory.

the 4th point just apply the patch!

» as an alternative you can get the tremstats already patched by myself!!!
»» http://www.capponcino.it/alessio/files/sviluppo/tremstats_mod/Tremstats_slux-mod.tar.gz

[DASPRiD]

Good work slux. I still came to the point, that a C-version of Tremstats wouldn't really speed things up, so I canceled development of version 0.9. If you would want to proceed with development on it, you could make a speed boost by making one big update query from all those single once, which are created in the parse loop.

If you continue, I would hand you write access to the Tremstats SVN server.

[slux_ITA]

oh thanks!

Speaking about the speed boost, i think that: make a parser with python is the beast way; c/c++ are more efficient when you do mathematical computations, but a parser like Tremstats have a big throughput. It is the disk I/O (reading line per line)... :roll:

btw, i'm happy to help you and soon i *release* the second version that resolve two important points:

Code:

   1st) `says` table is not normalized.. too duplicates
    2nd) some tremulous logs have a says like this:
            5:02 say: [A] ^1[^3XD^1]^7F^1ar^3ka^7s^1^7: ^2non ricordo^7
            5:04 sayteam: [H] ^w[^sXD^w] Lex ^RI^wT^QA^7: ^5spaccaminchia^7
          See the tags [A] and [H]. in this case the `says` table is empty =/

ps: dasprid the code is perfectly structured!  :wink:

[DASPRiD]

ps: dasprid the code is perfectly structured!  :wink:

Thank you, I always keep a good eye on my code structure.

So, are you interested in SVN access?

[slux_ITA]

So, are you interested in SVN access?

 :eek: zomg! Yes indeedy!!  

btw, my first commit will be my patch? the svn is aligned with the lase release (the 0.6)?