[Aseco 2.x] Graphical Reporting/Stats Plugin - TMUSER 0.8

This forum is dedicated to the Aseco/Rasp 2 server records and control script by Flo and Assembler Maniac. Announcements and issues can be discussed in this forum.

Moderators: Flo, f*ckfish, Assembler Maniac, TM-Patrol

Post Reply
TMnM
cyclist
cyclist
Posts: 32
Joined: 14 Jun 2007 03:14
Owned TM-games: TM +O +S +N(F) +U(F)

[Aseco 2.x] Graphical Reporting/Stats Plugin - TMUSER 0.8

Post by TMnM » 04 Jul 2008 04:45

TMUSER - TrackMania United Server Extension: Reporting

For the past few weeks I have been working on this project and it is now ready to share! TMUSER is an Aseco plugin that works silently while your dedicated server runs, logging various information about players, tracks, and the server. This information is persisted to a database, whose contents is in turn displayed in lists and charts by the Report Viewer. With this simple plugin you can visually see a lot of cool statistics like player demographics, which group of player ranks (high, medium, low) has spent the most time on your server, or even basic tables of your data. This plugin isn't totally finished yet seeing as there are still a number of individual reports that need to be made, but the foundation is there and is pretty neat to play with. Here are some screenshots:

Report Selector
Image

Player Rank Statistics
Image

Table View
Image

Player Demographic Statistics
Image

If all this looks pretty tempting, you'll be happy to know that that's just the beginning :) TMUSER's current release is 0.8, so it's not quite done yet, but I would really appreciate it if you could download and test the plugin across various server environments. The Report Viewer is Windows-only and requires the Microsoft .NET Framework 3.5 (if the Report Viewer won't start at all, it's likely you don't have this installed). There are setup instructions for TMUSER included, but they're only five quick steps. Thank you very much for testing, and enjoy! Any comments, questions, or suggestions are welcome and appreciated.

>>Download TMUSER 0.8 Now!<<
Last edited by TMnM on 17 Jul 2008 01:46, edited 1 time in total.

User avatar
BLaHiTiS
lord of the roads
lord of the roads
Posts: 3331
Joined: 12 Aug 2005 15:46
Owned TM-games: tmu tmo tms tmn
Manialink(s): muxitis
Location: Hasselt, Limburg, Belgium
Contact:

Re: [Aseco 2.x] Graphical Reporting/Statistics Plugin

Post by BLaHiTiS » 10 Jul 2008 15:25

it's not exactly clear to me how you use this on a website?
Image

  • MB:Asus P8 H61
  • CPU:Intel i5 2400
  • RAM:8 Gb
  • GFX:Asus GTX-580 (1500mb DDR5) - Forceware 75.33
  • DirectX: June 2011
  • SND:Realtek HD on mobo
  • OS:Windows 7 SP1- Home Premium
[/size]

User avatar
J-S
happy cruiser
happy cruiser
Posts: 149
Joined: 24 Apr 2008 18:20
Owned TM-games: TMN,TMUF,TMO,TMS
Manialink(s): shark
Location: Grenoble - France
Contact:

Re: [Aseco 2.x] Graphical Reporting/Statistics Plugin

Post by J-S » 11 Jul 2008 18:37

Hey !!!

Great Job, it's very good But when i active the TMUSER, he provokes a bug on Aseco. When i enable your plugin, the first recs of the server disapears when the server notify it :
Image

I have one question on the configuration of the Apply. I dont understand how we must configure the db user and db password ?

Code: Select all

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="ReportSources.Properties.Settings.tm_serverConnectionString"
            connectionString="Driver={MySQL ODBC 3.51 Driver};database=tm_server;option=0;port=3306;server=localhost;uid=root"
            providerName="System.Data.Odbc" />
    </connectionStrings>
</configuration>

TMnM
cyclist
cyclist
Posts: 32
Joined: 14 Jun 2007 03:14
Owned TM-games: TM +O +S +N(F) +U(F)

Re: [Aseco 2.x] Graphical Reporting/Statistics Plugin

Post by TMnM » 17 Jul 2008 01:44

@BLaHiTiS: Sorry, there currently isn't a way to put TMUSER reports on a website. But I will put this in the 0.9 release, okay? :) Could be a week or so until that comes out... I have a few other things that unfortunately have priority over this :(



@J-S: Well, I'll answer the simple question first. You see this part of the configuration file?:

Code: Select all

connectionString="Driver={MySQL ODBC 3.51 Driver};database=tm_server;option=0;port=3306;server=localhost;uid=root"
This page will tell you all about what to put in there - that is the only section you need to worry about changing: http://www.devarticles.com/c/a/ASP/Usin ... Via-ASP/3/. For example, if my database was called "testdb", my username was "admin", and my password was "blue" (and the other settings were default), then that one snippet of code would look like this:

Code: Select all

connectionString="Driver={MySQL ODBC 3.51 Driver};database=testdb;option=0;port=3306;server=localhost;uid=admin;Pwd=blue"
Read over that page and if you're still having trouble I'll be happy to help! :D



As for the record-username display problem, I am not an Aseco expert and, unfortunately, don't know what is wrong. Could you please tell me all the plugins you are using, or even just send me a zip/rar of your Aseco installation? Then I can try to recreate the problem on my own computer.


Hey, great news guys! I would like to deeply thank everyone that voted for my little project in the Telerik Reporting contest, because guess what - TMUSER tied for first place!!! This is really huge for me, and it should be huge for you guys too - just another example of how strong the TM community. Thank you so much and I promise to keep this project going! :D

User avatar
J-S
happy cruiser
happy cruiser
Posts: 149
Joined: 24 Apr 2008 18:20
Owned TM-games: TMN,TMUF,TMO,TMS
Manialink(s): shark
Location: Grenoble - France
Contact:

Re: [Aseco 2.x] Graphical Reporting/Stats Plugin - TMUSER 0.8

Post by J-S » 17 Jul 2008 19:05

Ok, i complete the file with correct information but it's not work ! The program crashes (WinDemo has stopped Working ...)

Code: Select all

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="ReportSources.Properties.Settings.tm_serverConnectionString"
            connectionString="Driver={MySQL ODBC 3.51 Driver};database=tm_server;option=0;port=3306;server=*13.***.61.**8;uid=***;Pwd=***"
            providerName="System.Data.Odbc" />
    </connectionStrings>
</configuration>
My Database is on distant server but i put the IP...
Have you got any ideas ?

I use these plugins :

Code: Select all

[Load Plugin] [plugin.localdb.php] [Name:LocalDb] [Ver:1.1]
[Load Plugin] [plugin.about.php] [Name:About] [Ver:1]
[Load Plugin] [plugin.statusbar.php] [Name:Statusbar] [Ver:1]
[Load Plugin] [plugin.stats.php] [Name:Stats] [Ver:1]
[Load Plugin] [plugin.records.php] [Name:Records] [Ver:1]
[Load Plugin] [plugin.score.php] [Name:Score] [Ver:1]
[Load Plugin] [plugin.help.php] [Name:Help] [Ver:1]
[Load Plugin] [plugin.emotics.php] [Name:Emotics] [Ver:1]
[Load Plugin] [plugin.admin.php] [Name:Admin] [Ver:1]
[Load Plugin] [plugin.plugins.php] [Name:Plugins] [Ver:1]
[Load Plugin] [rasp/plugin.matchsave2.php] [Name:MatchSave2] [Ver:2.2]
[Load Plugin] [rasp/plugin.rasp.php] [Name:Rasp] [Ver:2.3]
[Load Plugin] [rasp/plugin.rasp_jukeboxv2.php] [Name:JukeBox] [Ver:1.71]
[Load Plugin] [rasp/plugin.rasp_karma.php] [Name:RaspKarma] [Ver:1]
[Load Plugin] [rasp/plugin.rasp_chat.php] [Name:ChatCommands] [Ver:1.1]
[Load Plugin] [rasp/plugin.rasp_players.php] [Name:RaspPlayerAdmin] [Ver:1]
[Load Plugin] [rasp/plugin.rasp_cptimes.php] [Name:RaspCPTimes] [Ver:1]
[Load Plugin] [rasp/plugin.rasp_adminmsg.php] [Name:AdminMsgs] [Ver:1]
[Load Plugin] [rasp/plugin.rasp_chatbot.php] [Name:ChatBot] [Ver:1]
[Load Plugin] [rasp/plugin.rasp_shownext.php] [Name:RaspShowNext] [Ver:1]
[Load Plugin] [rasp/plugin.rasp_ms.php] [Name:RaspMatchSettings] [Ver:1]
[Load Plugin] [jokebot/plugin.jokebot.php] [Name:JokeBot] [Ver:1]
[Load Plugin] [TMXinfo/plugin.tmxinfo.php] [Name:TMX_info] [Ver:1.31]
[Load Plugin] [oliverde8.Hud/oliverde8.Hud.menu.php] [Name:oliverde8_Hud_menu] [Ver:1.31]
[Load Plugin] [ForceMods/plugin.forcemods.php] [Name:ForceMod] [Ver:1]

User avatar
J-S
happy cruiser
happy cruiser
Posts: 149
Joined: 24 Apr 2008 18:20
Owned TM-games: TMN,TMUF,TMO,TMS
Manialink(s): shark
Location: Grenoble - France
Contact:

Re: [Aseco 2.x] Graphical Reporting/Stats Plugin - TMUSER 0.8

Post by J-S » 17 Jul 2008 19:31

I think it's because you put the latin encodage in the db ! When i active your plugin, he impacts Aseco and other plugins who use UTF8 encodage in the Aseco DB.

EDIT : This problem impact the nickname which contain special characters ...

TMnM
cyclist
cyclist
Posts: 32
Joined: 14 Jun 2007 03:14
Owned TM-games: TM +O +S +N(F) +U(F)

Re: [Aseco 2.x] Graphical Reporting/Stats Plugin - TMUSER 0.8

Post by TMnM » 18 Jul 2008 17:00

It looks like you configured everything right. I could be wrong, but it looks like you don't have the Microsoft .NET Framework 3.5 installed. Try downloading it from http://www.microsoft.com/downloads/deta ... layLang=en. Let me know what happens!

As for the weird Aseco issue, you could be right about the encoding :) You seem to be knowledgeable enough to know about that kind of stuff, so do you think you could change it from latin to UTF-8? If so, let me know if that fixes your problem. I will also try to find a solution to this issue, but I think you've got it.

User avatar
J-S
happy cruiser
happy cruiser
Posts: 149
Joined: 24 Apr 2008 18:20
Owned TM-games: TMN,TMUF,TMO,TMS
Manialink(s): shark
Location: Grenoble - France
Contact:

Re: [Aseco 2.x] Graphical Reporting/Stats Plugin - TMUSER 0.8

Post by J-S » 18 Jul 2008 17:23

I already run with the .Net framework 3.5 :? (i have installed it to study :lol: )

nocturne
solid chaser
solid chaser
Posts: 1390
Joined: 08 Jun 2007 18:48
Owned TM-games: all
Contact:

Re: [Aseco 2.x] Graphical Reporting/Stats Plugin - TMUSER 0.8

Post by nocturne » 02 Nov 2008 20:32

This still available, or anybody got a copy..?

sRaH
pedestrian
pedestrian
Posts: 5
Joined: 31 Jul 2009 10:00
Owned TM-games: TMUF

Re: [Aseco 2.x] Graphical Reporting/Stats Plugin - TMUSER 0.8

Post by sRaH » 31 Jul 2009 10:05

Download link Broken please Reupload THX :roll:

Post Reply