Version: , by MattGreer
Developer Last Online: Nov 2013
Version: Unknown
Rating:
Released: 01-03-2008
Last Update: Never
Installs: 0
No support by the author.
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?
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
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?
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!!
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