Reset scores

View attachment 114

It would be nice if there was a feature where the either the system would automatically reset scores after X many days or if there was an options for the staff to do it.

When someone gets something as high as this (see screen shot)... It can put people off from trying in the long run.
 

Attachments

  • Capture.PNG
    Capture.PNG
    45.1 KB · Views: 137
Right now the only way to do so would be in your SQL database and I have NO idea how that would affect things.

For example, you could 0 out all the scores there, but unless you totally removed the scores from both the xf_arcade_game and xf_arcade_game_play records, I think it would cause issues.

Hopefully the devs have a better idea than me!
 
Right now the only way to do so would be in your SQL database and I have NO idea how that would affect things.

For example, you could 0 out all the scores there, but unless you totally removed the scores from both the xf_arcade_game and xf_arcade_game_play records, I think it would cause issues.

Hopefully the devs have a better idea than me!


I found the solution. This is a 2 step process.

Empty (not drop) the following

xf_arcade_vote
xf_arcade_session
xf_arcade_game_play

Now comes the more time consuming step (cause I personally didn't know a command that could do this).

Inside xf_arcade_game you'll need to edit each game (in phpMyAdmin it is 1 line per game install) and clear out the following

highscore
highscore_user_id
highscore_username
highscore_date
play_count
vote_up
vote_down

This re-sets everything back to default as if the game has been freshly installed.

FYI: Next version update REALLY... Do not ignore this.... REALLY needs to either self empty xf_arcade_session and xf_arcade_game_play or restrict how much data is kept.

Those tables were larger than life and I only have 23 games installed. Which isn't really many except that the arcade keeps records of EVERY game played for all time So if X user played Y games Z many times, it kept that record forever. Multiply it by X users who use the arcade and you'll have just an idea how BIG that part of the database can get.

My site is now running FASTER having cleared things.
 
Since there's so many entries I'd like to be able to have cron job that clears so many scores after a certain amount of time. This thread is pretty dang close to what i want as well. For now I have to manually delete.
 
Back
Top