UTStatsDB Forums

Posted: **Sun Oct 12, 2008 11:51 pm**

Please do not post regarding test versions of UT3Stats from before 1.00. Numerous changes were made before the 1.00 release.

Posted: **Mon Oct 13, 2008 12:30 am**

I'm loving the ability to use this on a non-dedicated server =] Thanks alot!

Posted: **Mon Oct 13, 2008 9:00 am**

Good work. I love you!

But... I wrote add utcomp ping correction weapon types

For example:

Code: Select all

INSERT INTO `ut_items` VALUES (230, 'ZP_utcomp3v3b4_Flak', 'Flak Cannon', 20);
INSERT INTO `ut_items` VALUES (231, 'ZP_utcomp3v3b4_Stinger', 'Stinger Minigun', 15);
INSERT INTO `ut_items` VALUES (232, 'ZP_utcomp3v3b4_Shock', 'Shock Rifle', 33);
INSERT INTO `ut_items` VALUES (233, 'ZP_utcomp3v3b4_RocketLauncher', 'Rocket Launcher', 31);
INSERT INTO `ut_items` VALUES (234, 'ZP_utcomp3v3b4_LinkGun', 'Link Gun', 18);
INSERT INTO `ut_items` VALUES (235, 'ZP_utcomp3v3b4_SniperRifle', 'Sniper Rifle', 12);
INSERT INTO `ut_items` VALUES (236, 'ZP_utcomp3v3b4_Enforcer', 'Enforcer', 1);

Oops, he names '*utcomp3v3b4*' this is bad. I notify utcomp developer.

Stats work good, but:
1. Match stats views bots

((((((((((((((( I hate it!
2. Mutators field is empty, but in stats log mutators exists.
3. Chat log don't work. (I chatting match, but messages not found in logged match). I use ChatLogger in WebAdmin, and it works fine.
4. In player stats different weapon types - dublicated. May be try group it, as match log?
5. Not found table "Player Netspeed and Ping Time" in match log, but ping exists of player match (Avg ping).
6. My server name is big, this good for server browser. In stats server view not pretty

My be add to INI option bUseShortServerName, if true -> logs write Short Server name, if false - use default server name?

Logged match:
http://stats.unreal-club.com/matchstats.php?match=11440 (log in attachment)
I use ALL latest version for UT3Stats and UTStatsDB and Linux binaries.

Posted: **Mon Oct 13, 2008 10:13 am**

Oops, he names '*utcomp3v3b4*' this is bad. I notify utcomp developer.
1. Match stats views bots ((((((((((((((( I hate it!
2. Mutators field is empty, but in stats log mutators exists.
3. Chat log don't work. (I chatting match, but messages not found in logged match). I use ChatLogger in WebAdmin, and it works fine.
4. In player stats different weapon types - dublicated. May be try group it, as match log?
5. Not found table "Player Netspeed and Ping Time" in match log, but ping exists of player match (Avg ping).
6. My server name is big, this good for server browser. In stats server view not pretty My be add to INI option bUseShortServerName, if true -> logs write Short Server name, if false - use default server name?

Yes, he uses version names in the weapon names. You can always add the descriptions to the database yourself. Just use phpMyAdmin to edit the weapon descriptions.
1. You can't have the bots not show up in the actual match stats, otherwise it looks pretty strange people dying for no reason. You can only disable them from showing up in the player lists, rankings, and the highs.
2. Confirmed - will be fixed in either the next version of UT3Stats or UTStatsDB, I'm not certain which yet.
3. Chat log works great for me. I pointed out that one of your other mutators prevents UT3Stats from logging chat. There's nothing I can do about that - have the author fix the mutator.
4. I don't know what duplicates you're referring to. If you mean with the UTComp weapons, simply add the appropriate descriptions to the database, as noted above.
5. UT3Stats does not report netspeed, though I can see if this can be added. If so, I can then enable that table (it currently only displays when using OLStats).
6. UTStatsDB has never used the short server name, but it's a possible option in the future.

Posted: **Mon Oct 13, 2008 11:05 am**

Anybody else have the problem that UTStats is not sending to http?
Settings are the same like with 0.99

bUploadLogs = True
UploadURL = http://www.xxx/xxx/OLSendLog.php
UploadPass = xxx
bParseLogs = True
ParserURL = http://www.xxx/xxx/logs.php
ParserPass = xxx

Posted: **Mon Oct 13, 2008 11:29 am**

Anybody else have the problem that UTStats is not sending to http?

The upload feature has not proven reliable so far. This seems like it may be a problem with LibHTTP, as the connects are initiated but not completed. I am still looking into this.

Posted: **Mon Oct 13, 2008 3:29 pm**

Yes, he uses version names in the weapon names. You can always add the descriptions to the database yourself. Just use phpMyAdmin to edit the weapon descriptions.

Yep, I add it manually.

1. You can't have the bots not show up in the actual match stats, otherwise it looks pretty strange people dying for no reason. You can only disable them from showing up in the player lists, rankings, and the highs.

Yep, this works for UT2004 stats, and bots not showing, but ut3 loggs shows bots anyway!

2. Confirmed - will be fixed in either the next version of UT3Stats or UTStatsDB, I'm not certain which yet.

Thanks!

3. Chat log works great for me. I pointed out that one of your other mutators prevents UT3Stats from logging chat. There's nothing I can do about that - have the author fix the mutator.

What mutator have bug? Disable WebAdmin Chat Logger?

4. I don't know what duplicates you're referring to. If you mean with the UTComp weapons, simply add the appropriate descriptions to the database, as noted above.

Yep, but... For example, my stats. See table "Total Items Collected". It exists dublicated items: "Enforcer", "Link Gun", "Sniper Rifle", etc...

6. UTStatsDB has never used the short server name, but it's a possible option in the future.

Ok, will be nice.

And BIG THANKS FOR YOU WORK AND SUPPORT! Sorry my english, but you amazing! Thanks a lot!!!

Posted: **Mon Oct 13, 2008 3:33 pm**

Anybody else have the problem that UTStats is not sending to http?
The upload feature has not proven reliable so far. This seems like it may be a problem with LibHTTP, as the connects are initiated but not completed. I am still looking into this.

Lattest LibHTTP here.

For support or questions mail to elmuerte[#]drunksnipers.com

Posted: **Mon Oct 13, 2008 6:51 pm**

Yep, this works for UT2004 stats, and bots not showing, but ut3 loggs shows bots anyway!

That's because the bots didn't even get logged at all, so UTStatsDB had to assume deaths were suicides. This wasn't by design.

What mutator have bug? Disable WebAdmin Chat Logger?

I don't remember which mutator, but no, not WebAdmin. Some custom mutator you're running. Look in a previous response from me in another thread.

Yep, but... For example, my stats. See table "Total Items Collected". It exists dublicated items: "Enforcer", "Link Gun", "Sniper Rifle", etc...

You simply said weapons before, you didn't say items. I see that on your site, but I don't know the cause. Did you edit any custom entries in the items table?

I am already using the most recent version of LibHTTP from the SVN (last updated about 260 days ago).

Posted: **Mon Oct 13, 2008 11:21 pm**

I will be releasing UTStatsDB version 3.05 soon, which so far includes the following changes:

Moved AutoParse variable to main config in database.
Added support for netspeed and packetloss info included with ping times (UT3Stats).
Modified 'use short name' option to also display server short name on web pages.
Corrected case on server short name.

Posted: **Tue Oct 14, 2008 9:31 am**

Bevore you release a new UTStatsdb, maybe you can show BattleTeamArena in ServerQuery as Teamgame and spiltt them to team red and team blue.
Also when you click on a match that the graph for TeamScore is working, because in TeamSummary you show it correct.
Example: http://www.phoenix-4ever.de/utstats/mat ... p?match=18

Thx for your hard and nice work!

Posted: **Tue Oct 14, 2008 12:37 pm**

Anybody else have the problem that UTStats is not sending to http?
The upload feature has not proven reliable so far. This seems like it may be a problem with LibHTTP, as the connects are initiated but not completed. I am still looking into this.

But why it works in versions before?

Posted: **Tue Oct 14, 2008 3:49 pm**

Probably with smaller log files. As I worked on UT3Stats, the log files grew in size since more data was being logged.

Posted: **Tue Oct 14, 2008 4:14 pm**

Probably with smaller log files. As I worked on UT3Stats, the log files grew in size since more data was being logged.

But than it should upload the small ones, but its uploading nothing.

Posted: **Wed Oct 15, 2008 3:59 am**

Yep, but... For example, my stats. See table "Total Items Collected". It exists dublicated items: "Enforcer", "Link Gun", "Sniper Rifle", etc...
You simply said weapons before, you didn't say items. I see that on your site, but I don't know the cause. Did you edit any custom entries in the items table?

End part of my items table:

Code: Select all

INSERT INTO `ut_items` VALUES (184, 'PhysicsSuperShield', 'PhysicsSuperShield', 1);
INSERT INTO `ut_items` VALUES (185, 'UTWeap_SniperRifle', 'Sniper Rifle', 81);
INSERT INTO `ut_items` VALUES (186, 'UTWeap_ShockRifle', 'Shock Rifle', 177);
INSERT INTO `ut_items` VALUES (187, 'UTAmmo_SniperRifle', 'Sniper Rifle Ammo', 112);
INSERT INTO `ut_items` VALUES (188, 'UTAmmo_Stinger', 'Stinger Minigun Ammo', 26);
INSERT INTO `ut_items` VALUES (189, 'UTWeap_Stinger', 'Stinger Minigun', 27);
INSERT INTO `ut_items` VALUES (190, 'UTAmmo_ShockRifle', 'Shock Rifle Ammo', 262);
INSERT INTO `ut_items` VALUES (191, 'HealthVial', 'Health Vial', 585);
INSERT INTO `ut_items` VALUES (192, 'UTWeap_RocketLauncher', 'Rocket Launcher', 115);
INSERT INTO `ut_items` VALUES (193, 'UTWeap_FlakCannon', 'Flak Cannon', 102);
INSERT INTO `ut_items` VALUES (194, 'UTAmmo_FlakCannon', 'Flak Cannon Ammo', 129);
INSERT INTO `ut_items` VALUES (195, 'MediumHealth', 'Medium Health Pack', 245);
INSERT INTO `ut_items` VALUES (196, 'UTWeap_LinkGun', 'Link Gun', 27);
INSERT INTO `ut_items` VALUES (197, 'UTAmmo_LinkGun', 'Link Gun Ammo', 38);
INSERT INTO `ut_items` VALUES (198, 'UTArmorPickup_Vest', 'Armor Vest', 78);
INSERT INTO `ut_items` VALUES (199, 'UTWeap_BioRifle_Content', 'Bio Rifle', 60);
INSERT INTO `ut_items` VALUES (200, 'UTAmmo_BioRifle_Content', 'Bio Rifle Ammo', 103);
INSERT INTO `ut_items` VALUES (201, 'UTAmmo_RocketLauncher', 'Rocket Launcher Ammo', 120);
INSERT INTO `ut_items` VALUES (202, 'UTArmorPickup_ShieldBelt', 'Shield Belt', 51);
INSERT INTO `ut_items` VALUES (209, 'UTWeap_InstagibRifle', 'InstaGib Rifle', 0);
INSERT INTO `ut_items` VALUES (208, 'UTWeap_Enforcer', 'Enforcer', 17);
INSERT INTO `ut_items` VALUES (203, 'UTJumpBoots', 'Jump Boots', 76);
INSERT INTO `ut_items` VALUES (204, 'UTArmorPickup_Thighpads', 'Armor Thigh Pads', 62);
INSERT INTO `ut_items` VALUES (207, 'UTWeap_BioRifle', 'Bio Rifle', 0);
INSERT INTO `ut_items` VALUES (206, 'UTWeap_ImpactHammer', 'Impack Hammer', 0);
INSERT INTO `ut_items` VALUES (210, 'UTWeap_Redeemer', 'Redeemer', 0);
INSERT INTO `ut_items` VALUES (211, 'UTWeap_Translocator', 'Translocator', 0);
INSERT INTO `ut_items` VALUES (212, 'UTWeap_Avril', 'AVRiL', 0);
INSERT INTO `ut_items` VALUES (213, 'UTAmmo_Enforcer', 'Enforcer Ammo', 18);
INSERT INTO `ut_items` VALUES (214, 'UTAmmo_BioRifle', 'Bio Rifle Ammo', 0);
INSERT INTO `ut_items` VALUES (215, 'SuperHealth', 'Super Health Pack', 0);
INSERT INTO `ut_items` VALUES (216, 'UTDroppedShieldBelt', 'Used Shield Belt', 0);
INSERT INTO `ut_items` VALUES (217, 'UTUDamage', 'Damage Amplifier', 37);
INSERT INTO `ut_items` VALUES (218, 'UTWeap_Physicsgun', 'Physics Gun', 0);
INSERT INTO `ut_items` VALUES (219, 'UTWeaponLocker_Content', 'Weapon Locker', 0);
INSERT INTO `ut_items` VALUES (220, 'UTWeap_Redeemer_Content', 'Redeemer', 0);
INSERT INTO `ut_items` VALUES (221, 'UTWeap_Translocator_Content', 'Translocator', 0);
INSERT INTO `ut_items` VALUES (222, 'UTWeap_Avril_Content', 'AVRiL', 0);
INSERT INTO `ut_items` VALUES (223, 'UTAmmo_AVRiL', 'AVRiL Ammo', 0);
INSERT INTO `ut_items` VALUES (224, 'UTDeployableShapedCharge', 'Shaped Charge', 0);
INSERT INTO `ut_items` VALUES (225, 'UTWeap_RipperLite', 'Ripper', 0);
INSERT INTO `ut_items` VALUES (226, 'UTArmorPickup_Helmet', 'Helmet', 0);
INSERT INTO `ut_items` VALUES (227, 'UTBerserk', 'Berzerk', 0);
INSERT INTO `ut_items` VALUES (228, 'UTInvisibility', 'Invisibility', 0);
INSERT INTO `ut_items` VALUES (229, 'ZP_utcomp3v3b4_BioRifle', 'Bio Rifle', 12);
INSERT INTO `ut_items` VALUES (230, 'ZP_utcomp3v3b4_Flak', 'Flak Cannon', 20);
INSERT INTO `ut_items` VALUES (231, 'ZP_utcomp3v3b4_Stinger', 'Stinger Minigun', 15);
INSERT INTO `ut_items` VALUES (232, 'ZP_utcomp3v3b4_Shock', 'Shock Rifle', 33);
INSERT INTO `ut_items` VALUES (233, 'ZP_utcomp3v3b4_RocketLauncher', 'Rocket Launcher', 31);
INSERT INTO `ut_items` VALUES (234, 'ZP_utcomp3v3b4_LinkGun', 'Link Gun', 18);
INSERT INTO `ut_items` VALUES (235, 'ZP_utcomp3v3b4_SniperRifle', 'Sniper Rifle', 12);
INSERT INTO `ut_items` VALUES (236, 'ZP_utcomp3v3b4_Enforcer', 'Enforcer', 1);

Totals have dublicates too. How fix this? May be try add function to UTStatsDB -> group by names in totals tables?

Thanks for add short name support. But, if I enabled it - all server have lowercase names. Why you use strtolower function for save short server names in db?

And chat logger. WebAdmin works good with all mutator. My be try change functions as webadmin?

Code: Select all

class ChatLog extends MessagingSpectator config (WebAdmin);

without you

Code: Select all

class UT3ChatLogger extends BroadcastHandler;

Posted: **Wed Oct 15, 2008 10:31 am**

Thanks for add short name support. But, if I enabled it - all server have lowercase names. Why you use strtolower function for save short server names in db?

As posted previously in this thread:

Corrected case on server short name.

As for why, it is because the server short name was previously used only as a means of identifying a server, not for display.

Posted: **Wed Oct 15, 2008 11:46 am**

I've rewritten the server query routines for UT3. Multiple packets are now properly joined at the correct positions and available data correctly displayed. This will be included with UTStatsDB 3.05.

Posted: **Wed Oct 15, 2008 11:56 am**

Thanks for add short name support. But, if I enabled it - all server have lowercase names. Why you use strtolower function for save short server names in db?
As posted previously in this thread:
Corrected case on server short name.
As for why, it is because the server short name was previously used only as a means of identifying a server, not for display.

This means that it is impossible to put in a normal form of names?

Posted: **Wed Oct 15, 2008 12:00 pm**

This means that it is impossible to put in a normal form of names?

It means that the case problem is fixed in version 3.05.

Posted: **Wed Oct 15, 2008 1:42 pm**

WOW! Very nice.
Answer on other questions please: chat and dublicated items.

Posted: **Wed Oct 15, 2008 6:43 pm**

WOW! Very nice.
Answer on other questions please: chat and dublicated items.

The chat I'm not going to do anything with unless it's a general problem with other mutators, which does not seem to be the case so far. The method I use is the same as used with the stats on older versions of UT and has been working well with UT3.

The item lists I've taken care of for the next version.

Posted: **Thu Oct 16, 2008 12:09 pm**

UT3Stats is sending again the logs with the new version

Thx Panther

Posted: **Fri Oct 17, 2008 12:42 pm**

Installed lates UT3Stats and UTStatsDB, play TDM match 4x4, and when map changin log:

Code: Select all

ScriptLog: UT3Stats: Restart game.
ScriptLog: UT3Stats: Closing log file.
ScriptLog: UT3Stats: Sending log to web server.
ScriptLog: UT3Stats: Sending log parse command to web server.
ScriptLog: ProcessServerTravel: DM-Deck
Log: SeamlessTravel to: DM-Deck
Log: Resolved www.ut.od.ua (62.16.9.20:0)
Log: CheckConnectionAttempt: Connection attempt has not yet completed.
Log: Resolved www.ut.od.ua (62.16.9.20:0)
Log: CheckConnectionAttempt: Connection attempt has not yet completed.
Log: CheckConnectionAttempt: Connection attempt has not yet completed.
Log: CheckConnectionAttempt: Connection attempt has not yet completed.
Log: ClearAllAnimSetLinkupCaches - Took 11.20ms
ScriptLog: GetSeamlessTravelActorList

Results: Log exists on game server, but it don't upload on web server.

Posted: **Fri Oct 17, 2008 1:25 pm**

This match:
http://stats.unreal-club.com/matchstats.php?match=11451
UTStatsDB 3.05 and UT3Stats 1.02!

1. Bot "Reaper" don't kill or death any! BUT him exists in match stat player list

((

2. First Blood is empty again
3. Chat logger still don't work (how i fix it, but I must use UTComp mutator for cups matches and play anytime)
4. Dublicated chat system messages as:

Code: Select all

-6.37  	SadRobo  	Team Change to Red Team
-6.37 	SadRobo 	Team Change to Red Team

5. In "Mutators" field possible use "FriendlyName"? It get from Ini of mutator, for example:

Code: Select all

[UTMutator_utcomp3v3b4 UTUIDataProvider_Mutator]
ClassName=utcomp3v3b4.UTMutator_utcomp3v3b4
FriendlyName=UTCompIII v3 beta4
Description=A mutator adding extra customization options, press f5 to configure in-game.
GroupNames=utcomp

You use "UTMutator_utcomp3v3b4" (ClassName), but use "UTCompIII v3 beta4" (FriendlyName) will be pretty

Posted: **Fri Oct 17, 2008 5:09 pm**

1. Bot "Reaper" don't kill or death any! BUT him exists in match stat player list ((
2. First Blood is empty again
3. Chat logger still don't work (how i fix it, but I must use UTComp mutator for cups matches and play anytime)
4. Dublicated chat system messages as:
5. In "Mutators" field possible use "FriendlyName"?

1. Once a player connects they will be listed as a part of that match, regardless of how long they were in or whether they killed anyone.
2. It didn't get logged again - refer back to the discussions about your other mutators.
3. See #2.
4. Yes, the connect and team change messages apparently need looking into.
5. Not a bad idea, but not something I plan on working on in the immediate future. Feel free to add it!

Posted: **Fri Oct 17, 2008 5:48 pm**

Panther you found why UT3.exe (bug from ut3stats) will be bigger and bigger in memory? Atm i need restart every 1-2 days server, because git goes over 1.2GB.

Posted: **Fri Oct 17, 2008 10:27 pm**

Panther you found why UT3.exe (bug from ut3stats) will be bigger and bigger in memory? Atm i need restart every 1-2 days server, because git goes over 1.2GB.

No, this hadn't been reported since a few revisions back when I made changes to how some portions are removed, so I thought it was fixed.

Posted: **Sat Oct 18, 2008 4:13 am**

No it´s not fixed...i thought you still working on it, because you never wrote in the release something about it so i didnt report again.

Posted: **Sat Oct 18, 2008 4:19 am**

Also when you go http://www.phoenix-4ever.de/utstats/rankings.php and click BattleTeamArena you see the first 30 Players and it shows page 1 from xxx when you go to next or last, the ranks are empty.

Posted: **Sat Oct 18, 2008 11:53 am**

Also when you go http://www.phoenix-4ever.de/utstats/rankings.php and click BattleTeamArena you see the first 30 Players and it shows page 1 from xxx when you go to next or last, the ranks are empty.

You know, you're supposed to mention these things before a big release...
Actually, this must have been a problem for all versions. I'm finding some other things to fix while I'm at it.

UTStatsDB Forums

UT3Stats

UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats

Re: UT3Stats