stats blew up again
- captainsnarf
- Posts: 2714
- Joined: Tue Jul 06, 2021 1:51 pm
- Location: Washington
- Server Sponsor: Yes
- Server Admin: Yes
- Contact:
Re: stats blew up again
still busted
- pooty
- Posts: 4537
- Joined: Sat Apr 03, 2021 10:22 am
- Location: Michigan
- Server Sponsor: Yes
- Server Admin: Yes
Re: stats blew up again
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.
Problem is its showing error on the read, but there's a write failing somewhere with no error. Stats code is pretty crappy IMO.
- pooty
- Posts: 4537
- Joined: Sat Apr 03, 2021 10:22 am
- Location: Michigan
- Server Sponsor: Yes
- Server Admin: Yes
Re: stats blew up again
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
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
- Super Sanka
- Posts: 265
- Joined: Mon Jan 10, 2022 7:12 pm
- Location: Orlando
- Contact:
Re: stats blew up again
-leon-happy
- pooty
- Posts: 4537
- Joined: Sat Apr 03, 2021 10:22 am
- Location: Michigan
- Server Sponsor: Yes
- Server Admin: Yes
Re: stats blew up again
Its working!
- captainsnarf
- Posts: 2714
- Joined: Tue Jul 06, 2021 1:51 pm
- Location: Washington
- Server Sponsor: Yes
- Server Admin: Yes
- Contact:
Re: stats blew up again
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.
- Super Sanka
- Posts: 265
- Joined: Mon Jan 10, 2022 7:12 pm
- Location: Orlando
- Contact:
Re: stats blew up again
Damn it I wanted to see how many times I killed snarf with Draco
- pooty
- Posts: 4537
- Joined: Sat Apr 03, 2021 10:22 am
- Location: Michigan
- Server Sponsor: Yes
- Server Admin: Yes
Re: stats blew up again
Yep. Damn UTStats.
- pooty
- Posts: 4537
- Joined: Sat Apr 03, 2021 10:22 am
- Location: Michigan
- Server Sponsor: Yes
- Server Admin: Yes
Re: stats blew up again
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.
Not sure why it doesn't work now, I don't think those stats are driven off any tables I changed but who knows.
- McLovin
- Posts: 1194
- Joined: Sat Apr 03, 2021 12:54 pm
- Location: Salt Lake City, Utah
- Server Sponsor: Yes
- Server Admin: Yes
Re: stats blew up again
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
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