UTStatsDB Forums

This version now supports Deathmatch, Team Deathmatch, CTF, VCTF, and Warfare.
The issue with log files not getting closed until the server is shut down has also been addressed.
Still only Windows support due to what appears to be a bug with the UT3 Linux version. The current development version of UTStatsDB can be retrieved via the SVN repository. I've only updated the MySQL tables so far. Also keep in mind that this is just a test and upgrading from test versions is not supported.

To run the stat logger, place the .u file with your other third party mods and include "?AccessControl=UT3Stats.UT3Stats" on your server startup line.

I've uploaded some new logs to the test site:
http://www.utstatsdb.com/ut3test/index. ... ts=matches

As a way to get stats working under Linux I implemented OverloadUT's stat uploading functions via El Muerte's LibHTTP. However, while this is working under Windows it segfaults in Linux.

I have used UTStatsDB for local stats logging since UT2003 and I'm really excited that you're implementing it for UT3. If I want to use the test version you have right now where exactly do I extract it to? And where will it store the log files that it creates? Right now I have it extracted to my documents/my games/unreal tournament 3/UT game. When I do this it does not show up in the list of mutators. Have I done something wrong?

Thanks for all your work on this.

Jeff

UT3 is very flexible in how the paths work, but normally you would have it in such a place as:
My Documents\My Games\Unreal Tournament 3\UTGame\Published\CookedPC\UT3Stats\

Then add the following to your startup line:
?AccessControl=UT3Stats.UT3Stats

Sorry for being kinda clueless....but how do I add that to my statup line.
Also should it show up as a mutator?

Thanks,

Jeff

No, it won't show up as a mutator.

...The issue with log files not getting closed until the server is shut down has also been addressed...

Thanks for fixing that!

Is it possible to parse log files from Test 1 with Test 2?

...but how do I add that to my statup line.
Also should it show up as a mutator?

Are you running a dedicated server (using the dedicated server install from Epic)? Based on your questions it sounds as though you're "hosting" a game from your retail version... I'm pretty sure at this stage in the development this mutator is only compatible with the dedicated server install (Panther can correct me if I'm wrong )...

Yes, this is just for dedicated servers, but it can be a dedicated server instance run from a retail install. As for parsing logs - you should be able to parse Deathmatch logs from the test 1 version with the more updated version of UTStatsDB. There were probably some features not yet supported by the logger though.

As a way to get stats working under Linux I implemented OverloadUT's stat uploading functions via El Muerte's LibHTTP. However, while this is working under Windows it segfaults in Linux.

Does this work like it did for UT2004 where it would upload the file to the web server, then call the parse log page? Is this available now, or just something you've been experimenting with?

Does this work like it did for UT2004 where it would upload the file to the web server, then call the parse log page? Is this available now, or just something you've been experimenting with?

That's exactly what it does, but this is a version that I've not released yet. I'm trying to figure out the problems with LibHTTP crashing UT3 Linux servers.

oh boy!! Patrick you are the friggin man, I am happy as hell to see your doin this man.

As usual I got a question of course.

1. are players going to be downloading this or is it server side only?
(only for redirection purposes)

2.I am currently using V3.2 and I am wondering if it works with 3.2?

3. do you think I should set up a seperate db for it as I already have two 2k4 servers reporting stats to this and some 12000 + games on it since nov9? or will it not be a problem?

thanks, thanks, thanks, thanks, thanks... I owe you some donations for sure...

Tonight I had this weird thing happen... I played 6 matches but the stats only show the I played 3. At the end of match 3 (during the voting period) another player joined (Oskerblooser). The next 3 matches it looks as though my stats (St@rbuck) were combined with the player that joined at the end of match 3. When I was browsing the chat logs I took notice to it (cause there were things I knew I had typed, but they showed up as Oskerblooser, along with what he typed)... then I confirmed it for each match stats.

Hopefully the logs will tell you the story (attached)... If it helps my stats page is here: http://ut3stats.dirrtyclan.com/ (don't mind the styles, I've been messing around a bit). Thanks.

1. are players going to be downloading this or is it server side only?

So far the client does download the mod, even though it really shouldn't be needed. I'm open to any input as to what to change to make this unnecessary.

2.I am currently using V3.2 and I am wondering if it works with 3.2?

Nope, it won't work with UTStatsDB 3.02, however, once everything's complete there will be another release of UTStatsDB which will upgrade existing 3.xx versions.

3. do you think I should set up a seperate db for it as I already have two 2k4 servers reporting stats to this and some 12000 + games on it since nov9? or will it not be a problem?

Personally, I set up separate databases (separate tables) for each version of UT that I run ('99, 2004, UT3), but that's just a matter of preference (by just changing the prefix you can use the same database file as another instance). There's no problem running everything from one database / table set if you prefer.

I'm still hoping that someone with come out with something better than what I'm writing. I've never really dealt with UnrealScript before and am just fumbling around. I would be happy though if I can just get it working with Linux, but so far it looks like the problems might all have to do with the Linux build of UT3.

Tonight I had this weird thing happen... I played 6 matches but the stats only show the I played 3. At the end of match 3 (during the voting period) another player joined (Oskerblooser). The next 3 matches it looks as though my stats (St@rbuck) were combined with the player that joined at the end of match 3. When I was browsing the chat logs I took notice to it (cause there were things I knew I had typed, but they showed up as Oskerblooser, along with what he typed)... then I confirmed it for each match stats.

I will check it out as soon as I have time (might not be until after the weekend). Perhaps some variables aren't getting reinitialized properly when a new match starts. Thanks for the report!

which version of Utstatsdb must be installed if not the v3.02?

I installed the 3.02 and got a database error when I tried this

Open a web brower and enter the following URL:
http://voids.clanservers.com/utstatsdb/admin.php

I have only remote access via Cpanel so I copied the utstatsdb to the WWW folder of my website. Is that correct?

Update:
Stats are being created but they end up in Logs folder on the server. These files cannot be downloaded while server is running looks like the files are locked.

I'm still hoping that someone with come out with something better than what I'm writing. I've never really dealt with UnrealScript before and am just fumbling around. I would be happy though if I can just get it working with Linux, but so far it looks like the problems might all have to do with the Linux build of UT3.

might be that until they get a better grip on Linux your going to have issue after issue, sorta hard to make something run on a system that is in need of so much. They are working on it and every patch gets closer, I have my suspicions that when they either make 1.2 officially a public patch or they call it 1.3 because of how fast it got out most of the stuff that seems to not work will begin to work correctly. I am running my ut3 server on server 2003 because of the issues with Linux atm which no doubt is a far superior server. but the software has to work with it in order for that to be really true so.

Far as the code I would like your consent to decompile it and have a look at it. I have made a lot of weapons but haven't looked at what or how the stats get generated. I have some friends whom may be able to help also. Anyway thanks for the quick response, I absolutely cannot wait to set it up. The way the current game is a lot of people would appreciate it, especially if they see it semi 2k3/4 ish looking rather then what they see at enemydown.

in 2k4 there was a way to run server actors, I haven't looked at that area of ut3 but I would think there would as I haven't been noticing anyone saying anything about it's non - existence.

at the very least I can definitely help some on researching things some, my weapons are in alpha form and i need a break from the photoshop crap anyways after skinning ten weapons. I will dig some and see what I can find out for the ServerActor stuff.

which version of Utstatsdb must be installed if not the v3.02?

I installed the 3.02 and got a database error when I tried this

Open a web brower and enter the following URL:
http://voids.clanservers.com/utstatsdb/admin.php

I have only remote access via Cpanel so I copied the utstatsdb to the WWW folder of my website. Is that correct?

Update:
Stats are being created but they end up in Logs folder on the server. These files cannot be downloaded while server is running looks like the files are locked.

actually this is for ut3 stats voidy, if that is what your inquiring about then you like me will need to wait until Panther releases a new updated version of UTstatsDB. What he was telling me was it is not out yet and it would not work on v3.2 .

if you are working with ut3 and the logs are building up in your logs folder that is not a bad thing IMHO, because when he releases a php program for it you will be able to parse your logs at that point.

I will check it out as soon as I have time (might not be until after the weekend). Perhaps some variables aren't getting reinitialized properly when a new match starts. Thanks for the report!

Played a round of VCTF with a couple buddies tonight, and noticed the same issue I had with TDM... Just wanted to add a a VCTF log file in case it helps. There were 3 players, but only 1 is shown - and I believe the other 2 players were combined into 1 bot (based on the chat log).

Far as the code I would like your consent to decompile it and have a look at it. I have made a lot of weapons but haven't looked at what or how the stats get generated. I have some friends whom may be able to help also. Anyway thanks for the quick response, I absolutely cannot wait to set it up. The way the current game is a lot of people would appreciate it, especially if they see it semi 2k3/4 ish looking rather then what they see at enemydown.

in 2k4 there was a way to run server actors, I haven't looked at that area of ut3 but I would think there would as I haven't been noticing anyone saying anything about it's non - existence.

You're certainly welcome to do whatever you can with the logging code. As I said, I'm just fumbling my way through this. The 1.2 patch has been official for over a month now. It does seem that even the 1.2 version on Linux needs some work yet. I haven't found a way to run server actors like you could before. This method of overriding the AccessControl class is about the best I have at the moment.

Played a round of VCTF with a couple buddies tonight, and noticed the same issue I had with TDM... Just wanted to add a a VCTF log file in case it helps. There were 3 players, but only 1 is shown - and I believe the other 2 players were combined into 1 bot (based on the chat log).

This is strange - most of your player connections have bBot set to true, even though they're obviously humans connecting. Do you have any mutators or anything special running?

Base install, 1.2 patch, WebAdmin 1.0 on Windows 2003. UT3Stats is the only customization

Base install, 1.2 patch, WebAdmin 1.0 on Windows 2003. UT3Stats is the only customization

Then we obviously can't rely on that method of determining whether or not someone's a bot. I'll have to go by their IP address or something instead. I wish Epic had at least left the logging functions in that they had in UT2003.

How are you guys dirtyclan and Pathera able to use the logs and display them in utstats DB?

How are you guys dirtyclan and Pathera able to use the logs and display them in utstats DB?

Read the first post in this thread.

I guess to do something like that would require PHP skills..which I have very little of..so wait for a user friendly setup to come out..

Panthera, are u going to be creating and releasing that?

I was also having trouble pulling the UT3 serverstats files off of websvn. What is the easiest way to get the files?

I was also having trouble pulling the UT3 serverstats files off of websvn. What is the easiest way to get the files?

I went with Panther's Subversion client recommendation of TortoiseSVN (http://tortoisesvn.net)... works great.

Thanks for the help, I got everything working now.

I have noticed a few problems with UT3Stats. First, on my vctf server players health no longer went down once the server went into overtime. Second, on my warfare server vehicles that should not be locked are now locked. Has anyone else had these problems after installing UT3Stats?

Also, I have no custom maps or mods on either of these servers.