I'm getting a message stating that I'm not able to view or play the arcade.

This is the message:Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

What could be the problem? Sorry, I'm pretty new to vb!

John, as soon as I had upgraded to gold and tried to install this hack, whenever I modify includes/functions.php - it causes loads of parse errors and a fatal error in global.php.

Know the cure at all?

(I'm prepping a clean DB to do test install)

working fine in gold :D:D

Can anyone please zip up all games in one file?

Did you use Dreamweaver to make the changes?

Same as always, not installed properly.

*Double check your file changes.*

(Especially in global.php and init.php)

Database error in vBulletin 3.0.0:

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'm getting that error. Game challenges?

If you're upgrading, you don't run the installation script again.

I'm not upgrading.. Installing for the first time

So why do you already have a table in your database called "gamechallenges"?

I have no idea where that is.. I didn't do anything twice, atleast i don't think so.

The first time i ran the install_arcade.php it did the templates, and then i got a 404. So i refreshed and tried to do it again. I couldn't get past the template additions.

Mine is working fine, although it used to work for mozilla (Firebird .7) now it's not showing the Games, other than that. it worrks great after updating the files.

theres your problem, it got as far as creating that then died.


is there a script that reverses all the DB modifications i need to fix my arcade, reinstall seems essential

Yeah, thats what i thought the problem was.

So i tried to undo the templates and all the changes, but i couldn't find them.

What does the first step do? Can i do undo it?

So, the steps to upgrade:

1) Upload all Gold files and upgrade vb.
2) Edit all files again following installation.txt instructions, and upload.
3) Add the arcade templates to styles.

Is that it? Sorry im a little lost. Theres an arcadeoptions column in the 'users' table, wont that affect the upgrade?

i just upgraded to Gold, and my arcade works and looks just great!! thanks so much John!!

http://www.macshrine.com/forums/arcade.php ;)

Thanks for the cool hack!! Ive installed it on my boards and it works great :)

http://www.globalboards.com/arcade.php?

no but you can do a sql query.

should look something like this.
[sql]
DELETE FROM template WHERE title like LCASE('arcade%')
[/sql]

I may be wrong. As per the usual, back up your DB before doing any modifications. :)

I am having the exact same problem. Everything else was fine and now I am getting this error.

You used Dreamweaver to edit the functions.php . Don't do that.

Use Notepad or the normal texteditor o change the functions.php . Make the Changes again with this tools.

Dreamweaver damaged the functions.php

Greets yabba

Wonder why it does that.

I ran it, got this Affected Rows: 25

Then i tried to install it again. Same error.

stonecold1203, do the same thing again - and remove all of the arcade tables in the database. (Anything beginning with game)

Thanks. John for the cool hack. My members love it! BTW- I got the problem fixed.
-Bigwrenn

Arcade tables? You mean in the templates? I don't see anything starting with game

:rolleyes:

I have two Questions:
1- How do you Add the "ARCADE Templates" to a Style
you installed AFTER installing v3 Arcade?
2- Is there any V3 Arcade's option to create championships? (how)

It is working again...thank you for all the help within this thread :)

Not sure what I've done wrong:

http://www.soccer24-7.com/vb3test/arcade.php

you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Have checked through the changes again and everything seems fine. Any ideas where my problem could be?

what is the error message you are getting when you try again?

I just wanna say that I upgraded from rc4 to gold. I didn't even uninstall the arcade (don't know how), and all I had to do to get it running again was rehack the php files. The arcade runs every bit as good as it did before, and I got to keep my scores too. :D

Could ya zip the files that need editing (if you don't mind) so I can see if I can get this to work?

Installed on my board with vB3 Gold without issue, and it's slick as hell. Great job, John! :)

i have just spent about 2h upgrading to vb3 GOLD and installing the hacks again and i have to say re-installing the arcade was EASY :) great instructions John.

As with everyone else who's had the same problem, you've made a file modification error. Check again. (global.php and init.php)

Database error in vBulletin 3.0.0:

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

Once again, it's because you're not removing the game tables from the database.

Many apologies if this error has already been posted... but theres a lot of pages to through which Im not gonna do.

Warning: Invalid argument supplied for foreach() in /home2/*******/************/includes/functions.php on line 2878

any ideas? this comes up on all the arcade and main forum pages

problem solved, init file had been incorrectly modified

How do i do that?