[DOWNLOAD] Converter (from v3arcade to ibProArcade)

Anybody who has v3arcade running on his site and wants to migrate to ibProArcade... Here is the solution


This will automatically convert your installed games and, if you want to, even all the scores from v3arcade to ibProArcade.
The converter is designed to be used on a fresh ibProArcade-installation as you will lose all installed games and scores in your ibProArcade.


The Converter is compatible to:

• vBulletin 3.5.x / 3.6.x
• ibProArcade v2.5.9+ and later
• v3arcade 1.0.6 (for vBulletin 3.5.x)
  usage with <1.0.6 are untested yet, please let me know if/how this works

Just follow those steps to migrate:

1) don't touch your v3arcade-installation yet, just close the arcade
2) download ibProArcade and install it
3) upload the attached converter to your forum's root-directory and run it

That's all, the converter is interactive and will tell you what to do ect.


Don't forget to remove the converter.php after everything is done !


The converter will let you choose if you want to remove v3arcade after conversion or not.

After you successfully converted, feel free to click UNINSTALL for v3arcade


Note to the sceptics
If you want to take a look on ibProArcade first while not losing your v3arcade, make sure you rename your /arcade.php to /v3arcade.php before you install ibProArcade. Then, after conversion is done, do not remove v3arcade at this time and test ibProArcade.
If you feel comfortable with it, remove v3arcade later via vBulletin's Product-Manager or (and that is what I point you to) run the converter again, it will provide a link for uninstallation on the first page and then guide you through the complete uninstallation (will even tell you which files and folders to remove, which the Product-uninstaller does not!). Remember to remove the renamed /v3arcade.php too
If you dislike ibProArcade, please let me know the reason and uninstall ibProArcade via the Product-Manager, then rename your /v3arcade.php to /arcade.php and you can use your v3arcade again.



If you find any bugs, if you have any improvements, ideas ect. please let me know

[MrZeropage]

gameid is stable, but the link maybe somehow different ...

[MorrisMcD]

Originally Posted by MrZeropage

Ok seems you really have too much scores.

Remove all with zero value ...

DELETE FROM `arcade_sessions` WHERE `score` = 0
worked by the way.. I never posted since.. But all went well after i ran that query.. I have tripled the amount of games we have due to converting.. Thanks

Originally Posted by MrZeropage

@altdelete47:
Thanks for using ibProArcade
That is a thing I thought of to integrate in AdminCP for next v2.5.7+: prune all lower scores of a user per game if setting is changed to "save only users top score", or just provide a function in "Score Tools" for that.
By now there is no option to do that automatically, sorry.

Is this an option yet? I like the leaderboard, but many players have 1st, 2nd,3rd, 4th, 6th, 7th, whatever... From the old system and the leftover scores... Just curious how to do this if possible.. Basically just removing all but the highest score of each user in each game...

Thanks again

[Spinball]

Got some feedback on this for you. With 150,000 users, the converter script always timed out on step 2.
So I put in a line of code:

PHP Code:

        while ($score = $vbulletin->db->fetch_array($scores))
        {
            $vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "games_scores    (s_id, gid, name, mid, datescored, comment, score)
                                            VALUES 
                                            ('$score[sessionid]', $score[gameid], '".addslashes($score[username])."', $score[userid], $score[finish], '".cleanstring($score['comment'])."', $score[score])");
            $counter++;
            echo ("$counter, ");
        } 


Inserting the echo ("$counter, ");

After which it ran just fine.

[Evil Dave]

Excuse me for being a newbie, but how exactly do you start the converter? I uploaded it to the root but how do I make it run?

Thanks

[MrZeropage]

simply call it

http://www.yourforum.com/converter.php

[AuroraStorm]

Originally Posted by MrZeropage

simply call it

http://www.yourforum.com/converter.php

Dude, I don't mean to be a pain in the butt about this but I've been all over this board trying to find the template modifications for the ibProArcade. I uploaded some styles on my board and for some of them I've had to go back into the Edit Templates to update the vbPlaza which is working fine, but I need to do this for the Arcade to show up on the new styles and I've searched this site until my fingers hurt without much luck. It's not in the Readme file or else I wouldn't be here. Please can you provide the hacks for me to update the Edit Template...I'd really appreciate it...I'll even bookmark it...

[Feckie (Roger)]

arcade/skins/

[fly]

Originally Posted by AuroraStorm

Dude, I don't mean to be a pain in the butt about this but I've been all over this board trying to find the template modifications for the ibProArcade. I uploaded some styles on my board and for some of them I've had to go back into the Edit Templates to update the vbPlaza which is working fine, but I need to do this for the Arcade to show up on the new styles and I've searched this site until my fingers hurt without much luck. It's not in the Readme file or else I wouldn't be here. Please can you provide the hacks for me to update the Edit Template...I'd really appreciate it...I'll even bookmark it...

You're in the wrong thread. You can re-download the correct hack here: https://vborg.vbsupport.ru/showthrea...ht=ibproarcade

[ezekiel97]

VERY NICE! I LOVE IT! Thanks alot man!

[carbide]

conversion went along very smooth

conversion went along very smooth
kept all my high scores