Swap High Score with another user

[MattGreer]

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 1199400643 at 1199400643 ---------------

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]

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 :p

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!!