Swap High Score with another user

I logged in the wrong account and I would like to take the current high score for one particular game and "merge" it over to the other account. Is there a way to do this?

[chatzworld]

not at the moment as far as i am aware but sounds like a good mod to have

[MattGreer]

I'm guessing that there should be a field in the database to indicate the userid of the person with the highest score. The question is, how many different places am I going to have to edit? I think there are enough "update" type queries to propogate the change to my account but I hesitate to muck with something without backing it up, of course.

Where can I find the field that corresponds to a userID for a given score on a given game?

[MrZeropage]

you should not do that, as the score itself and even gamedata ect. ahve the information stored in DB

I even can't think of any need to have two accounts, so I won't ever integrate a merge...

[MattGreer]

Well, I *CAN* think of a reason to have two accounts. Testing security is an integral part of running any forum, and I need to ensure that private forums are kept private and so forth. The "test" account allows me to double check and any forum admin who doesn't log in as a regular user should have one.

But I digress.

The procedure I have so far is as follows:

Using something like phpmyadmin:

• Go into the games_champs table and note the gid, which is the game ID number.
• Go into the users table and note the userID of the person to which you want to change to
• Go into the games_scores table and search for the high score. Edit the record and change the mid and username to the person to whom you want
• Go into the games_league table and search for the game ID and userID that corresponds to the record you want to change (might be difficult to figure this out, but I can't give much more advice than that). This fixes the Leaderboard.

Everything seems to have updated just fine except for the "king of the arcade" function. Even when you look at a profile the data is correct under "Player Details". Where is "King of the Arcade" calculated? I *hope* this is a calculation and not a hard-coded number! If I have 8 high scores then I should be the King of the Arcade with 8 scores, right? Or is the King something that is kept even if all the scores are erased? If that is the case then I imagine it should be "hard-coded".

Why in the world are you storing the username in the games tables? You should be getting the username value from the users table. The table/database is not normalized.

--------------- Added [DATE]1199400643[/DATE] at [TIME]1199400643[/TIME] ---------------

I went in and ran all the queries in the Admin panel for the Arcade. After the edits I made directly to the database, and running the update queries from the admin panel, all is well with the arcade.

BTW, despite the tone in my post I love this mod and I am very grateful for it! Thanks!!

[MrZeropage]

Originally Posted by MattGreer

Well, I *CAN* think of a reason to have two accounts. Testing security is an integral part of running any forum, and I need to ensure that private forums are kept private and so forth. The "test" account allows me to double check and any forum admin who doesn't log in as a regular user should have one.

Sure, but does that security-shadow-account needs to play any games in the arcade ? And if so, the results should be considered as a test and get deleted, and not merged to any other account

But nevermind - I just won't do any merge-function in ibProArcade


You solved your problem now ?

[MattGreer]

Yeah, but I totally pwned that game and I want my score!!!

And yes, I solved the "problem" now. Not a bug or actual problem, just an "oops I was on the wrong account" thing.

My forum is very competitive. I need to keep my awesome scores.

Thanks!!