[DOWNLOAD] Converter (from v3arcade to ibProArcade)

[MrZeropage]

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


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 (https://vborg.vbsupport.ru/showthread.php?t=101554) 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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=uninstallhack&threadid=114012) 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]

Please do me a favour and post something here in this thread if you used the converter, just information if everything worked well and how you like your new Arcade ;)

Thx!

[lanc3lot]

Sorry i havent posted earlier, but Vb.org was down:P

Everything went smoothly, IbproArcade is on the house:D

Ps

The only thing u must add imho in your directions, is that after u uninstall V3Arcade via the Converter, u must also uninstall any related addons u may installed. It may sounds like a common sense, but i didnt do it till my site went down (i had an error) and vb.org was also down and i was little freaked out:P But after i got my senses back, everything went smoothly:D

[---MAD---]

Sorry i havent posted earlier, but Vb.org was down:P

Everything went smoothly, IbproArcade is on the house:D

Ps

The only thing u must add imho in your directions, is that after u uninstall V3Arcade via the Converter, u must also uninstall any related addons u may installed. It may sounds like a common sense, but i didnt do it till my site went down (i had an error) and vb.org was also down and i was little freaked out:P But after i got my senses back, everything went smoothly:D
good point.

[---MAD---]

I have just tested this with 3.6.x beta 3.

It worked sucessfully without a flaw!

It also took about..30 seconds to convert.

I have some suggestions though:


Make the converter look like the vbulletin forum upgrade pages
Link to the ibpro arcade download page when it says the ibpro arcade is not found (So that people can download it).
Add a page to tell people where the v3arcade files are so that they can remove them (ones in admincp, includes, images etc).Thats about it :) Great stuff!

Also: This converter works with ibpro arcade 2.5.4+ (when moving data from v3arcade to 2.5.4+) as I did that on vbulletin 3.5.x (I forgot I had 2.5.4 not 2.5.6 :p)

[MrZeropage]

Add a page to tell people where the v3arcade files are so that they can remove them (ones in admincp, includes, images etc).That already is included, just start the converter and click "remove v3arcade" ...

It will tell you all steps that need to be done :)



I will set the Link to download ibProArcade, good idea !

[---MAD---]

;). Germany Won Btw!!

[tuanluu]

It look fine for me until I go to arcade page... I can see you the game score but not the images. Do I have to manualy move the image or this script will automatic take care me. thnks

[MrZeropage]

Yes, if you are in step 3 of the converter it tells you how to move which files :)

Not much to do:
move all .swf-Files from /games to /arcade
move all .gif-Files from /images/arcade to /arcade/images

That's all :)

[---MAD---]

It look fine for me until I go to arcade page... I can see you the game score but not the images. Do I have to manualy move the image or this script will automatic take care me. thnks
Yeah its not hard, just move the pictures and swf files and youll be happy once its all sorted :)

[tuanluu]

thnks for the quick the relply It work like a charme now

[---MAD---]

great stuff.

What vb version and arcade version where you using?

[icemanic]

HOLY CRAP, THIS ARCADE ROX.
THIS CONVERTER IS SUPER NICE TOO (its pretty much a v3 arcade uninstaller as well)
i wish i knew about this arcade first since i installed v3arcade, but having this convert reallllly helped me out in the uninstall process for v3arcade and really a cinch to install this one.......and much nicer looking

[---MAD---]

HOLY CRAP, THIS ARCADE ROX.
THIS CONVERTER IS SUPER NICE TOO (its pretty much a v3 arcade uninstaller as well)
i wish i knew about this arcade first since i installed v3arcade, but having this convert reallllly helped me out in the uninstall process for v3arcade and really a cinch to install this one.......and much nicer looking
Welcome to the real world ;)

[fly]

I was lucky enough to be one of MrZero's test bunnies on this. As usual, excellent work.

[---MAD---]

I was lucky enough to be one of MrZero's test bunnies on this. As usual, excellent work.
Great :)

[altdelete47]

Today I made the change to Ibproarcade. Out with the old, in with the new.

I used the converter to bring over all the scores from V3 arcade, but there is one problem. It brought over every score ever set, even though I only want members highest scores to show. I have the ACP set to "only save users top score", and that seems to be working just fine now, but how do I go back and update the leaderboards to delete every score except the highest for each user? I have ran all of the updates in score tools, and none of them had an effect.

I dont have too many users so I could just go through and prune each users scores individually, but if there is an easier way to do this, please do tell.

Thanks!

[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.

[jilly]

thank you for such a fabulous mod, and the great converter - worked wonrderfully to do the conversion, and the removal of v3 - everything was very clear and easy to do! I was so thrillede to be able to include the old games and old high scores so easily.
wonderful job!
jilly

[zooki]

It worked, but the other Games that come with Ibpro .. like Pacman etc are missing, even though they were their before i did the Conversion.

[MrZeropage]

Yes, because of unique GameIDs all Games are pruned before converting the existing Games, and I did not implement to re-add them after all games from v3arcade are converter to avoid double-games, as most of standard-games are the same in v3arcade.

Feel free to add them manually ;)

[loonytune15]

worked well but i deleted all my scores afterwardsand it still shows a member saying "got 109 times
the High Score of all time "

Any ideas on what went wrong?

[MrZeropage]

you deleted the scores afterwards and thus the best results remain as being independent from pruning ect.

ibProArcade v2.5.7+ will come along with a feature to delete some/all best results, until then you have to wait or run the following queries:

UPDATE games_list SET bestscore=0
UPDATE games_list SET bestmid=0

[loonytune15]

Thank you. Worked a charm :D

[trackpads]

Is it possible to run both the old Arcade and the new converted one simultaneously? For example one as a private and one as a public?

[MrZeropage]

Not really, as the games submit their score to /arcade.php
Beside it would not really make sense as you would have two score-tables ect.

[trackpads]

I was thinking because of some of the adult games I would want to keep them seperate. Np, I appreciate you response! I think I will give this a try!

-Jason

[MrZeropage]

You can keep Games separate this way with ibProArcade:

put the adult games in a category ("adult" or something like that) and adapt the permissions that only one specific usergroup can access this category.

Then you can easily manage who can access those games and who not :)

[afthl]

main:
vBulletin 3.0.8
v3arcade 1.0.2

what should I do to upgrade?

[MrZeropage]

the Converter only works for the new v3arcade done for vBulletin 3.5.x

so you could uninstall your v3arcade and start over with a fresh ibProArcade
this ibProArcade v2.5.6+ is compatible to vBulletin 3.x.x

[afthl]

thank you for your reply

I don't know how to uninstall it?
should I only remove the old files ?
what about the tables for the old version in my DB?

please what should I do to uninstall it?

thanking you

[MrZeropage]

there never was real uninstall-function for v3arcade, sorry, even not for those who paid for "premium support" ;)

If you want I can manually do the uninstallation and install ibProArcade on your site, I just need full AdminCP+FTP Access and myphpadmin, send me all access-data via PM.

If you place a little donation via PayPal for that work I would be happy :)

[epsol]

One thing I noticed is it did not transfer over the categories from v3.. Is this something not implimented in the converter, or did I miss something?

[MrZeropage]

this is not implemented, if I will do another version I will look for that, but my current focus is set on ibProArcade v2.5.7+ :)

[Cagonni]

thanks for this man :D
i cant find any games for V3 Arcade but ibProArcade games everywhere :D

i want to said "installed" for this :D

bu its not a mod :D

[MrZeropage]

click "installed" on ibProArcade itself ;)

[Cagonni]

be sure :D

[Tasoli]

I did as you said now v3 games work and yours do not.

[stud]

why I ever stuck with v3arcade - i don't know. Your arcade is great! Thanks!

[YLP1]

I must admit being fairly new to PHP & vB that I was scared to death to move from vb3arcade to IBproArcade.

This installed effortlessly and without flaw!

Awesome Job on this mod ... kudos!!!

[lordnex]

ok, i'm kinda stuck. i just upgraded VB from 3.5 to 3.6 and then installed IPB from v3. Games can play just fine but scores are not being recorded. Ideas or suggestions? it's exiting and going back to the arcade title page but nothing is being shown (except the game counter for number of times played goes up),

[MrZeropage]

you have some portal installed ?

please open a thread for your problem in the support-forum ...

[TwinsForMe]

Looks like a smooth conversion. :)

[ChrisTech]

Converted using Converter from V3 1.06 to OBPro 2.5.6+ - So far no issues...will post if any come up.


Looks like I might have to do something to make it work with vbplaza correctly. Almost the 100% smooth there...almost...hehe

Edit - Found the problem and fixed it. I still had the V3 stuff installed for vbplaza/bux. Removed those and the plugin, and installed the IBPro addon for VBPlaza/Bux and all is well.

Hope this helps someone else in the future. :)

[flindersredclaw]

Converted no issue.

VB3.6.1
V3arcade 1.07

Didnt blink.

Thank you

[shaynehammy]

Pure genius. No idea why i ever stayed with V3. MrZeroPage is a legend.

[MorrisMcD]

I am having issues with step 2.. Moving the scores.. I know I have a lot of sessions to move due to a lot of games, but I was looking in the database and I see LOTS of sessions with the score of 0.. Would it help to remove these? I know there is an option to remove all 0 scores in the admincp for v3arcade, but I really dont think its doing anything other that keeping it from being seen in the highscores templates.. If I should remove these from the database, what would the query be?

DELETE FROM `arcade_sessions` WHERE `score` = 0
???????

Is that safe?

The error I get when performing step 2 is

Welcome to the ibProArcade-Converter v1.0
=========================================
Converting SCORES

Please wait...
Fatal error: Maximum execution time of 30 seconds exceeded in *websitepath*\includes\class_core.php on line 363

So I am guessing its just too much.. Is there somewhere I can increase that time out period??

Any suggestions.. I see the results of step 1, and I am very excited to finish this off.... PLEASE HELP!!!

:)

[MrZeropage]

Ok seems you really have too much scores.

Remove all with zero value ...

[Dennis B]

This converter (and the arcade of course) are just great stuff.
Thanks!

[mljask]

do we lost gameid number when we convert or will they stay the same ... coz i have a lot links on other sites which point to an game and i dont wanna lose them

[MrZeropage]

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

[MorrisMcD]

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

@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:
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]

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]

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/showthread.php?t=101554&highlight=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:)

[Fawlty Adder]

Hi

I just installed this... i.e. I installed ibproarcade first, then I ran the converter .. everything went smoothly ..

then I uninstalled v3arcade and deleted its associated files and directories ..

I also removed v3 arcade from navbar and postbit/postbit legacy ..

however now i'm getting a database error when I try and access the arcade

(under www.theaccountancyforums.com/forums)

please advise

thanks!

something gives me the feeling the error is because I deleted v3Arcade's files :(

ok I deleted all the v3arcade files showing under 'games list' in my admincp/arcade .. ( i.e. ones who had gifs missing and no valid link to them)

now the only games showing under my admincp/arcade are the ones with gifs displaying

I've also re-installed ibproarcade

still getting the database error :(

[MrZeropage]

I need more details about the SQL-Error itself... anything in the logs?

[Fawlty Adder]

Database error in vBulletin 3.6.4: Invalid SQL: SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_arcade AS phrasegroup_arcade, language.phrasegroup_global AS phrasegroup_global, language.options AS lang_options, language.languagecode AS lang_code, language.charset AS lang_charset, language.locale AS lang_locale, language.imagesoverride AS lang_imagesoverride, language.dateoverride AS lang_dateoverride, language.timeoverride AS lang_timeoverride, language.registereddateoverride AS lang_registereddateoverride, language.calformat1override AS lang_calformat1override, language.calformat2override AS lang_calformat2override, language.logdateoverride AS lang_logdateoverride, language.decimalsep AS lang_decimalsep, language.thousandsep AS lang_thousandsep FROM user AS user LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) WHERE user.userid = 1; MySQL Error : Unknown column 'language.phrasegroup_arcade' in 'field list'Error Number : 1054Date : Tuesday, January 23rd 2007 @ 05:52:03 AMScript : http://theaccountancyforums.com/forums/arcade.php?Referrer : http://theaccountancyforums.com/forums/index.php

[MrZeropage]

seems like you have the /arcade.php from another arcade but not ibProArcade :)

Please download the archive again and upload and overwrite the arcade.php

[o0 Ryan 0o]

I was wondering what else I can do about the time out error I'm getting:

Fatal error: Maximum execution time of 30 seconds exceeded...

I've tried running the query to delete the scores with 0 (10553 rows were deleted), but I'm still having the same issue. I've also tried adding the code below to the file and this didn't work either.

echo ("$counter, ");


I'd love to be able to save our scores, so any help is greatly appreciated.

[MrZeropage]

contact me via PM please, so I can try to help directly

[Gizmo99]

Hellllllooooooo

Just migrated from V3arcade 1.0.4 !!!! re wrote the import script and buggered around with the old table sorted !!!!

Just a quicky can I update the Time Played counters, as they are all 0

I have searched around and have not found the question or the answer :)

Giz

[MrZeropage]

What was the problem with the importer, what did you adapt/rewrote ?

"time played" is not getting imported, sorry...

[Gizmo99]

I had an old version of VB Arcade 1.0.2

The tables where called:

games
gamenews
gamesessions
gamechallenges

gamesessions was missing the field gameid, so had to create it/populate it :) :up:

UPDATE gamesessions SET gameid='1' WHERE gamename='snake'
and so on

Have attached the php TO READ ONLY DONT USE !!! :eek: :erm:

Giz

[MrZeropage]

was it v3arcade for vBulletin 3.0.x ?

[Gizmo99]

yep

But could never find a updater

Giz

[MrZeropage]

Well, this really is not supported, I surely could do a converter, but this takes time (which I have few) and I think there are not enough people still using v3arcade for vBulletin 3.0.x

Think about a fresh install of ibProArcade after upgrading to vBulletin 3.6.x ;)

[Greg2004]

The converter does work on the 1.0.7 of v3 arcade. :) Thanks alot for the script.

[Dream]

Awesome, thanks for this.

Yes, if you are in step 3 of the converter it tells you how to move which files :)

Not much to do:
move all .swf-Files from /games to /arcade
move all .gif-Files from /images/arcade to /arcade/images

That's all :)

This notice doesn't appear if you choose to not import the old scores. Thanks again.

[cooldude714]

The arcade option in my admin cp has disappeared :S

http://img178.imageshack.us/img178/1046/admincpzz1.jpg is my admin cp and there is no category called Arcade (there was before I followed the instructions to uninstall v3arcade)

http://img246.imageshack.us/img246/4908/productsey7.jpg proves that I have the product installed.

I can still play on the arcade ok but I cannot administer it (I have re-imported it numerous occasions, and it still doesn't appear.

[MrZeropage]

re-upload everything from /includes directory from archive to your forum...

[CMGU]

donwloading

[xLYNZx]

EDIT: sorted it, just re-uploaded all the files again!!

[Lottis]

I have converted, and it went smooth, Thank you very mutch, Sir.
I hade version 3.6.8 in vBulletin and the latest Arcade.

[cunder]

I Hef current v3arcade-Installation to ibProArcade v2.5.6+ with the ibProArcade-Converter v1.0 but I'm getting this error:

Wen I Submit The Score:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 11520 bytes) in /var/www/html/forum/includes/class_bbcode.php(181) : eval()'d code on line 46

En wen I click on show High Scores of a game I'M getting this error code:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 737280 bytes) in /var/www/html/forum/arcade/functions/functions.php(1261) : eval()'d code on line 299

En Wen I click on Arcade ModCP I'M getting also this error code:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 737280 bytes) in /var/www/html/forum/arcade/functions/functions.php(1261) : eval()'d code on line 299

Please Help Me :erm:

[todd742]

In the install part it wants. functions_showthread.php which i do not have?

can anybody help me on this matter ?

[peterpigman]

I have some v3 games i would like to add to my ibproarcade, how do you do that?

[MrZeropage]

if you have the ZIP files, just use the included auto-installer ...

[Neilll]

OK im new to all this can someone please tell me how do i run the converter?

[putergirl]

Neilll, see post #55 for your answer.

.......

To anyone, I installed ibPro arcade and followed the installation instructions included in the zip file, then I ran the converter and it went well, but the arcade won't open. I should say though, that the converter did tell me to see if the arcade would open and let me play a game first, and it wouldn't, but I thought it was because both arcades were there. It just says not found, it's a generic message, not an error with information that I can post here.

I also ended up with two links to the arcade in the navbar, and both took me to v3 before I uninstalled v3, now it gives me the not found message. Then I took the install instructions to the v3 arcade installation and reversed it - taking out and changing back the code that I changed when I installed it... and it still won't open.

I do have high scores scrolling over the persons details in posts, but there are two identical rows scrolling the same information.

I would have just removed v3 before installing ibPro, but I wanted to save the scores if I could. I should also say, I tried to install ibPro when I first opened my site a two years ago and I couldn't get it installed then either, which is why I went with v3.

I am running the newest vBulletin and my sql5.

Any suggestions? I could sure use some help. Thanks.

[MrZeropage]

did you upload all files ? is arcade.php in your forum's root ?

[putergirl]

Oh thanks for the reminder.. it looked like it was there, but when I upped it from the cp instead of the ftp proggy, the arcade showed up.. I've been having probs uploading lately so that was the trick. Thanks so much!

Oh, one more thing.. I still have the double scrolling high scores.. where do I look to get rid of that code?

[MrZeropage]

check your postbit-template, I guess there is something doubled in there

[Bounce]

Just converted from v3 to ibp

Went very well indeed....

Brilliant work :up:

[Queball_Beast]

I have V3 arcade product plugin still on my site, when I tried to uninstaled it , it wont allow me to do.

The converter does not find any data for V3acade in my database.

I am currently running Ibproarcade 2.66+

the v3arcade product is v3 Arcade 1.05 , any ideas on how to remove the v3 Arcade product ?

[MrZeropage]

run converter and click "uninstall v3arcade" there are instructions about which files to remove ect

[Queball_Beast]

hmmm, the converter aborts the uninstalling.

The only thing installed from v3arcade is the product which I cant remove

I remember having v3arcade installed on my site for about 1 or 2 weeks, then I found ibProArcade, I installed it and never looked back.

I think I might have removed the files for v3arcade without actually uninstalling but I cant remember since it has been so long ago.

[russbo]

Install and converter work perfectly.

But it did not convert over the categories. I realize that it's not part of the converter process yet, but does anyone have any code or something I can use to move the categories over? I hate to go through six hundred plus games all over again...

Mr Z, awesome job. good luck with the new addtion!

[alyster4k]

I am running 3.6 with V3A wanting to convert to IPB and VB3.7. I'm wondering if I should do the IPB conversion before doing a 3.7 upgrade. Any comments?

[MrZeropage]

do it the way you want, both are fine ...

I personally would first upgrade vBulletin, but just personal taste

[NAZIA]

Is there any converter by using which we can converter our flash games for Vb

[Strat]

Running 3.5.3, but thinking of switching to 3.72 soon. Would this tool work to convert v3 to ibProArcade on the 3.72 platform or this strictly for 3.5/3.6?

Or would the move from v3 to ibProArcade be recommended while I'm on the 3.5.3 version of vBulletin *after* which I could upgrade to 3.72 and not encounter an issue?

[MrZeropage]

The converter works for all versions of vBulletin, so no matter what you do first

[JoeWho]

Hi

(v3 Arcade 1.07)
(VB 3.7.2)

I also get time out error, so I added "echo ("$counter, ");" and I still get the error.

Has anyone found a fix for it?

Thanks

I was wondering what else I can do about the time out error I'm getting:

Fatal error: Maximum execution time of 30 seconds exceeded...

I've tried running the query to delete the scores with 0 (10553 rows were deleted), but I'm still having the same issue. I've also tried adding the code below to the file and this didn't work either.

echo ("$counter, ");


I'd love to be able to save our scores, so any help is greatly appreciated.

[wcheezer]

Please do me a favour and post something here in this thread if you used the converter, just information if everything worked well and how you like your new Arcade ;)

Thx!

I used the converter, but when getting to the final removal of v3 arcade I get the message that I am unauthorized for that thread.

[Infopro]

Used the converter here as well. Worked for me.

Thanks.

[ArcadeKing]

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


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 (https://vborg.vbsupport.ru/showthread.php?t=101554) 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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=uninstallhack&threadid=114012) 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 :)hi there, i,m having problems with arcade, all the games aren,t submitting scores, can any one help me please, as i can,t reopen website til its fixed thanks ArcadeKing

[MrZeropage]

send admincp+ftp access via PM and I will check this ...

[alfaowner]

Really helpful for my 3.6.4 - Thanks worked a treat.

[kaderith]

The converter worked great! Thanks for all the hard work to create it.

[nyunyu]

Just want to confirm, is this converter still works with vb 3.8.2?

[MrZeropage]

yes, converter works fine :)

[sonictremila]

Hi,
I had v3arcade 3.0.9 and vbulletin 3.8.2, I used the converter and the conversion worked good but i have a problem.....it doesn't save the score..When I click on "Submit Score" it returns in arcade hompage...how can i fix this?

EDIT:

It saves 1 games and don't save 8 games....the only game is Chopper Challenge

It saves score games integrated, the score of the game which was in v3arcade it doesn't save

PS: Sorry for my english

I solved deleting v3arcade.

[Doom Stone]

I installed the arcade and checked that it was working, it was, I then ran the converter and uninstalled v3arcade. I then deleted the v3arcade files.

I now get this error when accessing the arcade:
Note: User 1824 was the current arcade champion.


mySQL query error: SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, customavatar.filename, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM (SELECT * FROM dbuser WHERE userid=1824) AS user LEFT JOIN dbavatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN dbcustomavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=1824 OR user.userid=1824

mySQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM dbuser WHERE userid=1824) AS user LEFT JOIN dbava
mySQL error code:
Date: Friday 26th of June 2009 01:25:08 PM


Update:
I wasn't able to find a workaround for this unfortunately, so I have uninstalled everything and started over.
Installed v3, installed v3 games, installed ibpro, converted games to ibpro.
Being no scores, there was no issue this time.

However there is now the same error when scores are added, not sure where i've gone wrong here.

Vbulletin 3.8.0
V3arcade 1.1.1

[bing11]

when submit Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 311296 bytes) in /home/chineseu/public_html/bbs/includes/class_bbcode.php(172) : eval()'d code on line 400

[oldlock]

Converted games from v3arcade suffer from the 'Score not saved problem' but newly uploaded ones from .tar files are fine. Any suggestions as to a fix ?

[rootsxrocks]

Converter does not find v3 arcade, It also says that I will lose scores and trophys

[mtlcore]

Hi, I have ibProArcade installed since 1 year now and when I uninstalled v3arcade back in the day it didn't fully uninstall... the error it gives me is this:

Invalid SQL:
ALTER TABLE usergroup DROP arcadepermissions;

MySQL Error : Can't DROP 'arcadepermissions'; check that column/key exists
Error Number : 1091

[MrZeropage]

sorry, but I can not give support to v3arcade and its uninstallation... as I don't use v3arcade ;)

[idoL1]

2 questions #1 does this not uninstall v3 arcade?...i have v3 arcade 2.0 n there game selection is so weak.....im looking to go to ibproarcade but if it doesnt uninstall v3 arcade im kind of confused on how the converter works......all i want to be able to do is add games that i have the folders for....

#2 i have vbull 3.8.4 and v3 arcade 2.0...if i run this it will turn v3 arcade into ibproarcade without losing games and scores?

[idoL1]

PROBLEM DETECTED ! Can't fine the v3arcade-Data in your Database !

Conversion aborted.

i made sure that my ibp was off and that followed all directions....imma just uninstall v3 totally hope i can get the games back i had - dont care about the high scores - but still get this error thru ibp that i posted in the other 3 sections and no one has a fix for :(

whenever i enable the xml file in the plugins n products i get this error

Invalid SQL:

SELECT t.champion, u.userid FROM vb_tournaments AS t
LEFT JOIN vb_user AS u ON (t.champion = u.username)
WHERE champion<>'';

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267


when i disable it it goes away...any help? website is www.360icons.com if that helps?

[Speysider]

#2 i have vbull 3.8.4 and v3 arcade 2.0...if i run this it will turn v3 arcade into ibproarcade without losing games and scores?
v3arcade 2.0.0 has not been released. As far as I know, it's still in Beta.

[shahryar_neo]

PROBLEM DETECTED ! Can't fine the v3arcade-Data in your Database !

I got this error while i', sure there is not problem v3arcade data in my database .

?

[angeljs]

PROBLEM DETECTED ! Can't fine the v3arcade-Data in your Database !

I got this error while i', sure there is not problem v3arcade data in my database .

?
I'm receiving the same error :(

--------------- Added 1288355384 at 1288355384 ---------------

Ok, I've managed to tweak converter.php and it seems to have worked, but before I post it here I just have one question...when the converter finished, I was told:

Now you have to do the following steps in your AdminCP (Arcade -> Score Tools):
1) run Update Highscores
2) run Update the Best Results
3) run Update League

Is there a way to run these in my browser?

[angeljs]

Ok, managed to find the link, but have no idea why it's not in my admin cp...something I'll probably figure out at some point. :rolleyes:

Anyway, I've attached my converter.php, but please, please, please backup your database before using it as I'm not a programer and know very little about...well, anything really! :erm:

[LichtMann]

Hi MrZeropage!

Fixed!

[carmine3838]

hello i have a vbulletin 3.8.3 and ibProArcade v2.6.8 + I installed the product IbproArcade 2.5.7-Top 25 player list and scores of works, how it resets the scores from the ranking Top 25 player?

[CK]

Will this converter run with 4.1.3?

[Hippy]

it should

[CK]

*should* hehe that's a bit of a gamble

[ArcadeSyndicate]

works with ibproarcade for vb4.1.3 and v3arcade 2.0.2.

confirmed here http://www.vbulletin-germany.org/showthread.php?709-ibProArcade-professionelle-Spielhalle-f%FCr-Flashgames&p=73731#post73731

[troyuncucom]

Edit:

i have a problem for converter.

Welcome to the ibProArcade-Converter v1.0
=========================================
This will convert your current v3arcade-Installation to ibProArcade v2.5.6+

IMPORTANT
By starting this Script you will lose all Games and Scores in your ibProArcade !
This will convert all your v3arcade-Games stored in Database to fit the ibProArcade-Database.

Before starting the Converter ensure that:
1) ibProArcade is uploaded and installed correctly (you can enter it and play default Games)
2) Your ibProArcade is switched off while this Converter is running


PROBLEM DETECTED ! Can't fine the v3arcade-Data in your Database !

Conversion aborted.

vb: 2.8.4
v3 arcade: 2.0.3

[Skyrider]

Same issue above, doesn't work on the new v3arcade.

[Skyrider]

Any help? Almost a month now.

[Glockie]

Hi all,

I am trying to migrate to ibProarcade and shortly after the upload, I start the converter.php and come across this error;

Welcome to the ibProArcade-Converter v1.0
=========================================
This will convert your current v3arcade-Installation to ibProArcade v2.5.6+

IMPORTANT
By starting this Script you will lose all Games and Scores in your ibProArcade !
This will convert all your v3arcade-Games stored in Database to fit the ibProArcade-Database.

Before starting the Converter ensure that:
1) ibProArcade is uploaded and installed correctly (you can enter it and play default Games)
2) Your ibProArcade is switched off while this Converter is running

PROBLEM DETECTED ! Can't fine the v3arcade-Data in your Database !

Conversion aborted.

This is on the latest release of ibProArcade, can you hep at all?

If I uninstall ibPro and enable V3 there's no problem with the db as everyone's scores and ratings are there.

I hope you can assist, I'd be most grateful..

Thank you

[Skyrider]

Hi all,

I am trying to migrate to ibProarcade and shortly after the upload, I start the converter.php and come across this error;

Welcome to the ibProArcade-Converter v1.0
=========================================
This will convert your current v3arcade-Installation to ibProArcade v2.5.6+

IMPORTANT
By starting this Script you will lose all Games and Scores in your ibProArcade !
This will convert all your v3arcade-Games stored in Database to fit the ibProArcade-Database.

Before starting the Converter ensure that:
1) ibProArcade is uploaded and installed correctly (you can enter it and play default Games)
2) Your ibProArcade is switched off while this Converter is running


PROBLEM DETECTED ! Can't fine the v3arcade-Data in your Database !

Conversion aborted.


This is on the latest release of ibProArcade, can you hep at all?

If I uninstall ibPro and enable V3 there's no problem with the db as everyone's scores and ratings are there.

I hope you can assist, I'd be most grateful..

Thank you
This converter is out-dated, and no one seems to care (speaking towards the dev of this plugin) as it won't work on the latest v3 of the Arcade system. Already replied here saying it won't work + PM'd the developer. He's recently active, but ignoring nor replying to my PM.

[Hippy]

all you need to do I think is figure out what v3arcade-Data was changed to edit the converter file and you should be golden..
stangger5 would know best he used both arcades at the same time..

[stangger5]

If you Convert from the newest v3Arcade to ibProarcade..

Looks like you need to add v3,,to two different tables in the converter.php file..

Two places change:
arcade_games
to
v3arcade_games

Then six places change:
arcade_sessions
to
v3arcade_sessions

[rednekcowboy]

Any update on this? Not working again, even with the changes suggested.