search

Drek282 / PsychoStats

This is an update to Stormtrooper's PsychoStats to fix obsolete and deprecated code as well as fix as many issues as possible and add support for games that interest me.
GNU General Public License v3.0
24 stars 10 forks source link

All players are ranked #1 #85

Closed bobl61 closed 8 months ago

bobl61 commented 1 year ago

Yeah...it's me again. Okay, so I completely deleted ALL the PS files. I reinstalled PS with the latest files (I see the cookie issue has been addressed for non https sites). I parsed the logs last night. I saw that all the players were ranked #1. The stats ran again this morning at 9 AM. All the players are still ranked #1.

2023-06-13_101840

2023-06-13_101936

Drek282 commented 1 year ago

That's a weird one. Going to run some tests, I'll get back to you shortly.

bobl61 commented 1 year ago

That's a weird one. Going to run some tests, I'll get back to you shortly.

Okay, thanks.

Drek282 commented 1 year ago

Ok, I reinstalled PS from scratch, with the cstrikes module, ran stats.pl on the logs you sent me, through sftp. This is what I got. demo

Drek282 commented 1 year ago

One thing I noticed pretty quickly from that error log you posted, it took three seconds to parse the logs. Unless you only had one log file in that folder, that's impossibly fast. Did you enter the correct source? Do you actually have the game logs you are trying to parse in that folder?

Drek282 commented 1 year ago

I know back in the day there was "log cleaner" software, which would remove all the irrelevant entries from logs to make them parse faster, but they can cause problems, especially if they aren't functioning properly. You wouldn't happen to be using some software like that would you?

Drek282 commented 1 year ago

Ok, I think I may know what's going on. You need to delete all the stats, using that option in the Manage page of the Admin CP, then run stats.pl again. If that doesn't work, you need to reinstall PS from scratch and drop and recreate the database. Something is wrong with your database. That "Optimizing database tables ..." entry in your logs is an error that indicates you are trying to run stats.pl when you've manually deleted data from your database, not using the Admin CP functionality.

It's typically a bad idea to go into the database and try to edit it, or delete data/truncate tables, unless you really, really know what you are doing.

bobl61 commented 1 year ago

It must have been a database issue. When I first did the reinstall, I didn't drop the database, I just dropped all the tables. I tried deleting all the stats via Admin, running stats.pl again, but got the same result. I dropped the database, created a new one, reinstalled, ran the stats again, and it looks okay now.

Drek282 commented 1 year ago

I'm going to take a look at those database options on install. I'm glad it's working for you again.

bobl61 commented 1 year ago

The Google map is now working. Great job!

2023-06-13_132539

Drek282 commented 1 year ago

Hey, you got that working! Congratulate yourself! I found getting that Google Maps API key a little confusing and frightening...

Drek282 commented 1 year ago

But yes, that Google Maps functionality is actually pretty cool, and it was a challenge to sort it out. Nice to see it being used.

Drek282 commented 1 year ago

Going to keep this open at least until I get a chance to look at the database options during the install.

Drek282 commented 8 months ago

Closing.