Matchstatistics

[SkullCollector]

Using UTStatsDB Version 3.10

Hi there,
What is the purpose of the weapon statistics displayed on the match statistics page?

For example, the following is displayed:

Weapon Accuracy Information
Weapon Shots Fired Hits Damage Accuracy
Minigun466 221 0 0 0.0%
Minigun525 220 0 0 0.0%
Minigun561 169 0 0 0.0%
Minigun508 150 0 0 0.0%
Minigun556 150 0 0 0.0%
Minigun558 139 0 0 0.0%
Minigun491 132 0 0 0.0%
Minigun481 129 0 0 0.0%
Minigun502 127 0 0 0.0%
Minigun530 118 0 0 0.0%
Minigun469 116 0 0 0.0%
Minigun537 112 0 0 0.0%
Minigun547 108 0 0 0.0%
Minigun555 108 0 0 0.0%
Minigun489 104 0 0 0.0%

Why are so many miniguns listed here?

There's only one as far as I know. Why aren't they counted together and only displayed once? This page feels like it's miles long.
And this isn't just the case with the Minigun, but also with the Assault Rifle or Link Gun.
This is true for almost every type of weapon.

Or you could simply filter out the types where there were no hits. In my opinion, it makes no sense to list them there if no hit is make.


Is there any chance to shorten this ?

Regards
Skully

[SkullCollector]

i have looked into the ut_weapons table .

i found more than 8500 Weaponentrys there. What the heck is going wrong here ?
imho this a problem of the Logoparser and logsave. every shot or whatever , is counted as a new weapon.

That kills the database after a while.

[Panther]

That's certainly a bug, possibly an encoding error causing that. Send me one of your match logs that have this issue and I'll take a look. It's also possible that it's already been corrected in the current code, but I do have one more similar problem to fix.

[SkullCollector]

I can upload my Logs as Zip here.
Cause i don't know in which one of these are bad guys

[SkullCollector]

I can upload my Logs as Zip here.
Cause i don't know in which one of these are bad guys

Can't upload my 2mb zip here.

[Panther]

Are the duplicate weapons occuring in a single match or across multiple matches? I'd prefer if you could narrow this down to one or two matches to debug it.

[SkullCollector]

Are the duplicate weapons occuring in a single match or across multiple matches? I'd prefer if you could narrow this down to one or two matches to debug it.

Morning,
ok, i found directly 4 Files. I can't upload here 30-60kb logfiles here.
but it is in more than one Match. I think it is in all imported Matches.
If i write down the local html Stats with OLStats there a no double Weapons in there.

[SkullCollector]

Well , i wrote a sql Statement to look into it .

Code: Select all

SELECT * FROM ut_weapons WHERE wp_type REGEXP 'Minigun[0-9]+|FlakCannon[0-9]+|RocketLauncher[0-9]+|Minigun[0-9]+|AssaultRifle[0-9]+|BioRifle[0-9]+|ClassicSniperRifle[0-9]+' ORDER BY wp_num;

after that i found more 5k weapons. And i have not all in that sql statement.

i write a cleanup.php to get that deleted from the database. including the other tables like ut_pwkills and so on.

i will see how it goes

Edit :
I have now all Weapon Types for the SQL Statement :

Code: Select all

SELECT * FROM ut_weapons WHERE wp_type REGEXP 'Minigun[0-9]+|FlakCannon[0-9]+|RocketLauncher[0-9]+|AssaultRifle[0-9]+|BioRifle[0-9]+|ClassicSniperRifle[0-9]+|LinkGun[0-9]+|LightningGun[0-9]+|Minigun[0-9]+|OldShieldGunUTSnd[0-9]+|ONSGrenadeLauncher[0-9]+|ONSMineLayer[0-9]+|Painter[0-9]+|Redeemer[0-9]+|RocketLauncher[0-9]+|ShieldGun[0-9]+|ShockRifle[0-9]+|SniperRifle[0-9]+' ORDER BY wp_num;"

[Panther]

I didn't realize file uploads weren't working. We recently changed server hardware. Go ahead and try now.

[SkullCollector]

I didn't realize file uploads weren't working. We recently changed server hardware. Go ahead and try now.

Ah yo. Files now online here Thanks for fixing that.

by the way...i think i have an Old V3.10 ot utstats DB. Cause I cant use Demo Files. BEcause no settings in admin area to set them up.

But hey, i wait for SVN or websvn or a new release from you.

Regards
Skully

[Panther]

FYI, these logs parsed fine in my current version. Once you send me some demorec files (with matching log files) I'll get that added back in.

[SkullCollector]

Oki,
her a Matchlog and a demo File.

Time from the Logfile is the Starting time.
Time from the Demorec File is the Endtime of the Match.

Both files in the zip File