vb.org Archive - Major Additions - ibProArcade

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Major Additions - ibProArcade - professional Arcade System (https://vborg.vbsupport.ru/showthread.php?t=101554)

I uninstalled the system, but I'm now getting the following:

http://img466.imageshack.us/img466/5...install5gr.jpg

How can I remove this?

Don't forget to upload includes/xml/cpnav_arcade.xml and then refresh the ACP.

Quote:

Originally Posted by Deimos

I'm getting the same problem as other people when I choose the ArcadeCP and create a tournament with 2 people

mySQL query error: SELECT userid, username FROM user WHERE userid IN() ORDER BY userid

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 ') ORDER BY userid' at line 1
mySQL error code:
Date: Sunday 27th of November 2005 03:49:28 PM

Error confirmed. On my installation I get:

Quote:

mySQL query error: SELECT userid, username FROM vb3_user WHERE userid IN() ORDER BY userid

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 ') ORDER BY userid' at line 1
mySQL error code:
Date: Sunday 27th of November 2005 10:03:51 PM

But it still created the tournament! Looks like we need a fix for this please

Could someone help me remove the avatars from the Highscore-Champions table?

I could never thank you enough for this.
THANK YOU!
(clicked Install)

Quote:

Originally Posted by kewl1uk

But ... some games which are zipped are not V3Arcade games but are IBproarcade games which have to be manually installed through filling out the fields in the Add Game screen in the ACP. This happened to me. The only way to tell is to unzip it and take a look. If it contains a php file then it's most likely a V3Arcade game. But if it contains a text file then it's an IBproarcade game and instructions for installing it are in the text file.

...if you want to add the game manually wether its a v3arcade or ibproarcade game......place the .swf file in the arcade folder....then place the .gif's in the arcade/images folder......then go to add game in the admin cp and put in the name of the game.....the gname is usually the name of the game with no spaces....for example say I was adding a game called race driving....the gname would be racedriving......you can then add the width and height or leave at default then check how it looks.

If I wanted the awards to appear in the user profile instead of the postbit, how do I go about doing that?

I wonder if someone could please help me with a sql error I am getting. I had the pervious arcade when I was running 3, but I am now using 3.5

Code:

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) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))



               WHERE user.userid = 11;



MySQL Error  : Unknown column 'language.phrasegroup_arcade' in 'field list'

Thank you :)

Hi, Great hack! I haven't tried all the features yet but so far have not noticed any errors. Anyway, I was wondering how to go about pulling my AJAX Shoutbox to show on the game screens, that way I can see when ppl are active in the site, while i'm off playing the games.

Thanx again,
memorex

P.S. I'm useing the AJAX Shoutbox by Z.T.

Unexpected end of archive when I try and open the zip file.

X vBulletin 3.8.12 by vBS Debug 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 (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09076 seconds Memory Usage 1,748KB 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 (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: