vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   ibProArcade (https://vborg.vbsupport.ru/forumdisplay.php?f=170)
-   -   [DOWNLOAD] Converter (from v3arcade to ibProArcade) (https://vborg.vbsupport.ru/showthread.php?t=119704)

lordnex 08-26-2006 03:04 AM

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 08-26-2006 07:42 AM

you have some portal installed ?

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

TwinsForMe 09-11-2006 02:28 AM

Looks like a smooth conversion. :)

ChrisTech 09-28-2006 12:28 AM

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 10-26-2006 06:45 PM

Converted no issue.

VB3.6.1
V3arcade 1.07

Didnt blink.

Thank you

shaynehammy 11-04-2006 10:28 AM

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

MorrisMcD 12-05-2006 03:54 AM

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 12-05-2006 08:06 AM

Ok seems you really have too much scores.

Remove all with zero value ...

Dennis B 12-09-2006 08:25 PM

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

mljask 12-25-2006 11:11 PM

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 12-27-2006 12:36 PM

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

MorrisMcD 12-29-2006 08:35 AM

Quote:

Originally Posted by MrZeropage (Post 1132269)
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

Quote:

Originally Posted by MrZeropage (Post 1025380)
@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 12-30-2006 09:20 AM

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 01-03-2007 09:55 PM

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 01-06-2007 11:19 AM

simply call it :)

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

AuroraStorm 01-08-2007 11:50 PM

Quote:

Originally Posted by MrZeropage (Post 1151846)

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) 01-09-2007 05:41 AM

arcade/skins/

fly 01-09-2007 11:09 AM

Quote:

Originally Posted by AuroraStorm (Post 1154141)
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 01-12-2007 11:12 PM

VERY NICE! I LOVE IT! Thanks alot man!

carbide 01-21-2007 01:53 PM

conversion went along very smooth:)

conversion went along very smooth:)
kept all my high scores:)

Fawlty Adder 01-23-2007 07:55 AM

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 01-23-2007 10:14 AM

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

Fawlty Adder 01-23-2007 10:27 AM

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/foru...e.php?Referrer : http://theaccountancyforums.com/forums/index.php

MrZeropage 01-25-2007 07:19 AM

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 03-11-2007 08:48 AM

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.

Code:

echo ("$counter, ");

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

MrZeropage 03-20-2007 07:21 PM

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

Gizmo99 04-09-2007 12:57 PM

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 04-09-2007 06:23 PM

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

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

Gizmo99 04-10-2007 07:33 AM

1 Attachment(s)
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 04-11-2007 10:05 AM

was it v3arcade for vBulletin 3.0.x ?

Gizmo99 04-11-2007 10:37 AM

yep

But could never find a updater

Giz

MrZeropage 04-16-2007 07:34 PM

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 05-18-2007 06:09 PM

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

Dream 06-08-2007 03:21 AM

Awesome, thanks for this.

Quote:

Originally Posted by MrZeropage (Post 1019737)
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 06-09-2007 07:49 AM

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 06-09-2007 09:32 AM

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

CMGU 06-12-2007 10:09 PM

donwloading

xLYNZx 06-14-2007 06:11 PM

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

Lottis 09-04-2007 06:04 PM

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 10-17-2007 10:23 AM

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:


All times are GMT. The time now is 01:28 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01286 seconds
  • Memory Usage 1,831KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete