vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   v3 Arcade - Games Arcade & Challenge System [vB 3.0.3] (https://vborg.vbsupport.ru/showthread.php?t=60377)

sarge0087 07-18-2004 06:07 AM

Ok, try this. Go to my forum http://www.nextdictator.com/forum/index.php and login as:

Username: Testarcade
Password: test

Try and play a game in my arcade and you will see the problem.

Intex 07-18-2004 06:14 AM

OK, this is typically caused by the usergroup not having permission to access the arcade. Go to AdminCP | Usergroups, then select the usergroup that the user your testing belongs to, scroll down to the 'Arcade Permissions' setting and check to make sure that:

Can View the Arcade?
Allows usergroup to play arcade games

Are both set to YES.

sarge0087 07-18-2004 06:23 AM

Hmm... even on my admin account I can't play. Everything is set to yes for everyone too... I'm not sure what's going on.

Intex 07-18-2004 06:30 AM

What version of vB are you using? I believe there are known issues with 3.0.2 including this paticular problem, but I'm not 100%.

sarge0087 07-18-2004 06:33 AM

3.0.3

I saw someone else with 3.0.3 saying it worked fine with him. Maybe it's just me?

Intex 07-18-2004 06:42 AM

OK, then I don't really know. The only other thing I can think off is to check the location of your games and make sure their in the same location as originally specified.

sarge0087 07-18-2004 07:02 AM

Hmmm, I think I know the problem. I remember a while ago trying to install this arcade but I failed horribly. When I try to make the database changes during the installation I get the following error:

"Database error in vBulletin 3.0.3:

Invalid SQL:
CREATE TABLE gamechallenges (
challengeid int(10) unsigned NOT NULL auto_increment,
type tinyint(1) unsigned NOT NULL default '0',
challengerid int(10) unsigned NOT NULL default '0',
challengedid int(10) unsigned NOT NULL default '0',
game varchar(30) NOT NULL default '',
status tinyint(1) unsigned NOT NULL default '0',
datestamp int(13) unsigned NOT NULL default '0',
challengersession int(20) unsigned NOT NULL default '0',
challengedsession int(20) unsigned NOT NULL default '0',
PRIMARY KEY (challengeid)
) TYPE=MyISAM

mysql error: Table 'gamechallenges' already exists

mysql error number: 1050"

I know what this means, so how do I delete those old databases?

Intex 07-18-2004 07:06 AM

Use phpmyadmin or similar program to access your database and delete the table (backup your database first!). Alternatively if you know your SQL, then simply run the query from the vBulletin AdminCP | Import & Maintenance | Execute SQL Query.

sarge0087 07-18-2004 07:13 AM

I don't know much about SQL. When I try to Execute SQL Query it tells me I am not authorized. I used to have phpmyadmin but I had no idea what to do with it.

sarge0087 07-18-2004 07:17 AM

Do you think the SQL thing is even the problem?


All times are GMT. The time now is 03:56 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.03291 seconds
  • Memory Usage 1,735KB
  • 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)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