stats blew up again

General Comments, Questions about all things OmnipotentS that don't go in other topics/forums
User avatar
captainsnarf
Posts: 2632
Joined: Tue Jul 06, 2021 1:51 pm
Location: Washington
Server Sponsor: Yes
Server Admin: Yes
Contact:

Re: stats blew up again

Post by captainsnarf »

still busted :cry: :cry: :cry:
User avatar
pooty
Posts: 4358
Joined: Sat Apr 03, 2021 10:22 am
Location: Michigan
Server Sponsor: Yes
Server Admin: Yes

Re: stats blew up again

Post by pooty »

Yep. There something else with leon, his player record looks fine, but doesn't update. https://www.omnipotents.com/utstats/pla ... p?player=3

Problem is its showing error on the read, but there's a write failing somewhere with no error. Stats code is pretty crappy IMO.
User avatar
pooty
Posts: 4358
Joined: Sat Apr 03, 2021 10:22 am
Location: Michigan
Server Sponsor: Yes
Server Admin: Yes

Re: stats blew up again

Post by pooty »

Ok I think I may have fixed it. Whew. I need those 3 hours back..

The players table has these three fields
plr_nodeconstructed mediumint(8) unsigned NOT NULL default 0,
plr_nodedestroyed mediumint(8) unsigned NOT NULL default 0,
plr_nodeconstdestroyed mediumint(8) unsigned NOT NULL default 0,

Never really used anywhere in the stats UI, but updated, and they are too high to be accurate (damage maybe?)
Leon Values 16,135,933 16,764,174 11,305,003
Max Value for MediumInt(8) unsigned is: 16,777,215

So very likely the plr_nodedstoryed was failing, and then it fails the rest, to add him to the matches.
Enyo isn't far behind
6,728,524 11,299,559 7,164,702

So I updated the table

plr_nodeconstructed int(10) unsigned NOT NULL default 0,
plr_nodedestroyed int(10) unsigned NOT NULL default 0,
plr_nodeconstdestroyed int(10) unsigned NOT NULL default 0,

Max value now is 4,294,967,295 so hopefully safe for a while ;)

So these values are NOT the nodes values shown in the https://www.omnipotents.com/utstats/onsrankings.php
Those come from a different table. So I don't know what the above numbers are, I think it might be damage?

Who the fuck knows, and no real comments/data model documentation.
And that save a whole 3 bytes per record (times 825 records) = ~2K whoopie fucking do. Just dumb.

Again its not going to fix the matches that were broken, there's no mechanism to replace the match (and the ~20 data tables) in one fell swoop.
Hopefully tonight when leon plays it will get recorded fine.

Leon feel free to play a solo match and test it
User avatar
Super Sanka
Posts: 255
Joined: Mon Jan 10, 2022 7:12 pm
Location: Orlando
Contact:

Re: stats blew up again

Post by Super Sanka »

-leon-happy
User avatar
pooty
Posts: 4358
Joined: Sat Apr 03, 2021 10:22 am
Location: Michigan
Server Sponsor: Yes
Server Admin: Yes

Re: stats blew up again

Post by pooty »

Its working!
User avatar
captainsnarf
Posts: 2632
Joined: Tue Jul 06, 2021 1:51 pm
Location: Washington
Server Sponsor: Yes
Server Admin: Yes
Contact:

Re: stats blew up again

Post by captainsnarf »

:cry:

It's not crashing now, but some things are not working. None of the line graphs are working and the kills matchup is empty also.

At least it's not PHP errors now.
User avatar
Super Sanka
Posts: 255
Joined: Mon Jan 10, 2022 7:12 pm
Location: Orlando
Contact:

Re: stats blew up again

Post by Super Sanka »

Damn it I wanted to see how many times I killed snarf with Draco :(
User avatar
pooty
Posts: 4358
Joined: Sat Apr 03, 2021 10:22 am
Location: Michigan
Server Sponsor: Yes
Server Admin: Yes

Re: stats blew up again

Post by pooty »

Yep. Damn UTStats.
User avatar
pooty
Posts: 4358
Joined: Sat Apr 03, 2021 10:22 am
Location: Michigan
Server Sponsor: Yes
Server Admin: Yes

Re: stats blew up again

Post by pooty »

Its going to be a while before I will likely have time to look at it again. I will be slammed at work T/W, and then going out of town Th-Sunday. So it will be at least a week.

Not sure why it doesn't work now, I don't think those stats are driven off any tables I changed but who knows.
User avatar
McLovin
Posts: 1165
Joined: Sat Apr 03, 2021 12:54 pm
Location: Salt Lake City, Utah
Server Sponsor: Yes
Server Admin: Yes

Re: stats blew up again

Post by McLovin »

It's F'd up again. Different than before, but still F'd up. Take a look at tonight's games.

Sun, Jun 04 2023, 11:38:24 PM Omnip)o(tentS 2.0 Onslaught Onslaught ONS-Nevermore-TMU-2015-V6 14 40m 32s
Sun, Jun 04 2023, 11:21:51 PM Omnip)o(tentS 2.0 Onslaught Onslaught ONS-RedPlanet-DjAyT-2014-V2 18 14m 00s
Sun, Jun 04 2023, 10:50:48 PM Omnip)o(tentS 2.0 Onslaught Onslaught ONS-Icarus-)o(-MantaMadnessGravi 25 28m 33s
Sun, Jun 04 2023, 10:17:02 PM Omnip)o(tentS 2.0 Onslaught Onslaught ONS-Dria-TankMeUp-Boring-V6 31 31m 10s
Sun, Jun 04 2023, 9:56:54 PM Omnip)o(tentS 2.0 Onslaught Onslaught ONS-Tyrant-)o(-Renovation-V2 28 17m 34s
Sun, Jun 04 2023, 9:41:06 PM Omnip)o(tentS 2.0 Onslaught Onslaught ONS-DesertJunkYard-TMU-Randomize 31 13m 16s
Sun, Jun 04 2023, 9:22:02 PM Omnip)o(tentS 2.0 Onslaught Onslaught ONS-MasterBath-Renovation-v4 28 16m 25s
Sun, Jun 04 2023, 8:58:00 PM Omnip)o(tentS 2.0 Onslaught Onslaught ONS-Minus-KitchenSink-Randomizer 28 21m 32s
Sun, Jun 04 2023, 8:36:35 PM Omnip)o(tentS 2.0 Onslaught Onslaught ONS-Pistola 10 18m 46s
Sun, Jun 04 2023, 8:06:48 PM Omnip)o(tentS 2.0 Onslaught Onslaught ONS-ArcticJunkYard-)o(-Randomize 7 27m 15s

Worked right up until leon joined during Pistola, then it went bonkers until after he left, RedPlanet. The stats page doesn't like leon. LOL
Post Reply