Hi, I'm using this hack for quite a time now but I suddenly have some kind of strange problem. Everyting is working perfect, I as admin can play all the games but my members are getting this error:

You do not have permission to access this page. This could be due to one of several reasons:
You do not have permission to access the page that you were trying to. Are you trying to edit someone else's post or trying to access administrative features? Check that you are allowed to perform this action in the Forum Rules.
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

How can I solve this problem. Thanks in advance.

Look two-three pages back in this thread and you'll see your solution :)

Regards

- miSt

Working excellently in my forums, except for one thing: people whose usernames have an apostrophe in their names seem to be causing some database errors...

For example, if I had a user named "Thor's Hammer", I will get the following errors:

---------------------------------
Invalid SQL: INSERT INTO arcade (game,date,time,userid,username,score)
VALUES ('pacman','2002-11-10','20:10:28','14','Thor's Hammer','5040')
mysql error: You have an error in your SQL syntax near 's Hammer','5040')' at line 2

mysql error number: 1064
---------------------------------

and

---------------------------------
Invalid SQL: SELECT max(score) as maxscore FROM arcade WHERE game='breakout' AND username='Thor's Hammer'
mysql error: You have an error in your SQL syntax near 's Hammer'' at line 1

mysql error number: 1064
---------------------------------




Just a heads up ;) Excellent hack...

I would add this to your main download thingy, cuz there is just to many freaking temaptels to do lol, so I made ya this, I hope its ok (must have TBS insatlled, if you do, you know what this is for alerady lol)

I am getting this when trying to run allgames.sql

Error: 1064 - 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 'username=$username&s=$session[sessionhash]&highscore=$highscore

I am running mysql version 4.0.4

help! :P

I have a problem where champion titles arent showing up. I see it mentioned a couple times. Ive checked and rechecked all my php edits and sql queries, are there any ways I can cheat and make this damn thing show titles? maybe a nifty $champinfo in a template or something of that nature?

If not I'm thinking of geting rid o some of them "if" dillies in the php hacks.... eek!

great hack btw! aside from small buggies, its a lot of fun! my hat's off to ya!

When should we explect the new version you think?

I just installed this hack (my users are already loving it!)

I do have 2 questions though.

1) What was the code on the /forum/index.php for? I am not seeing anything displayed on the index.php page? Am I supposed to see something?

2) I am not seeing the champ for each game listed as champ in their postbit. I have gone through everything twice and can not get this working.

It's not a big deal but I thought i would ask these questions. :)

Dupe Deleted

Will there be any new games soon? People at my FOrums (www.cscentral.com/forums) love the arcade, but they ask for more games ;) Are you planing on adding any new features soon? Or is it basically final?

kind regards,
Sebastian

I need to know what this means, This happens when I run allgame.sql

"Error: 1064 - 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 'username=$username&s=$session[sessionhash]&highscore=$highscore"

mysql v4.0.4 pro

Game is Active
Inactive games can only be seen by Admins Yes No

i have tried updating this option a million times but its the same :(

its doesn't change to yes

anyone know why ??

thanks

I still cant get the Champion Function working, I have the Champion system turned to on as well as turned on in the games themselves.

Anyone have any ideas?

Dear Mr. Vbproarcade, could we get a little support here? :P

yes plz .. i've been waiting for last 3 days now i think ::D

my members are about to hang me ...

only i can play the game LOL

cya soon ..

Not everyone is here everyday you know :rolleyes:

And if you install the hack correctly then everything will work fine.

Have you tried reading though the posts on this thread? Other people had the same problem you're having and I'll bet that, with a little investigating, you can find out how to fix it yourself.

Hi guys,

I apologize for not being around as much. I am really getting hammered on this CMS thing I am working on, it needs to be done ASAP and based on the feature-set that was requested, it grew much larger than I thought. Anyway, I think I am coming close to being done with it, and then I can get back to the Arcade.

Regarding the seperate thread: I want to make a separate thread because the Flash games & Flash development really have nothing to do with the hack itself, they are a separate entitity. Also, I would like to keep a list of all the games that people have modified to make work with the arcade.

I will get to some of these support questions to the best of my ability as time allows.

I have never heard of this problem before. I can only assume that something was installed incorrectly. You say the Options don't get updated.. what happens? Are any messages displayed?

You need to check three things:

- the arcade itself must be active (from General Options)
- each game must be active (from the Modify Game Data)
- your users' groups must be listed in the switch statement quoted above. there are numerous posts in this thread addressing that issue

If all of those have been checked, and you are still having a problem, I confess that I am at a loss.

The new version already has a MUCH nicer access control system in it.

The code on /forum/index.php is to display a list of the active games. If it is not appearing, then you likely haven't modified your forumhome template to include it. If I remember correctly, the instructions on how to do this are included in the install file.

On the Champion system, it is known to me that there are problems with this. It has been redone for the next version, and all I can really tell people is to hang on and bear with me. It will work better, I promise! :)

I am unsure why this could be happening. When I run allgames.sql on either of my servers, it installs perfectly. You can get around this error by adding the games manually to the CP; I know it's a pain, but it definitely works.

I am trying to simplify the game setup system for the next version. It should be, at the very least, a little bit better.

There needs to be an addslashes(...) in the query; I found that bug, actually, and corrected it for the next version.

Thanks!

All I can say is, it will be out when it's ready, and not before.

I will be posting the .FLA files soon. Just have to package them up in some meaningful way along with basic instructions.

As far as the next version goes, I need to do a few major things. Mainly a conversion script from the old version (to preserve the data) along with better instructions for certain aspects of the hack. Maybe even a mini-FAQ for it to get around some of the commonly asked questions.

I hope I got to everybody's questions, I'm sure I missed one or two in there though. I should be around more often to provide a bit better support. I apologize again for the delays!

And for those who have sent me PMs, I really would prefer to handle support in this thread. I will try to get to the PMs as time allows.

Thanks.

Thanks futureal, I used phpmyadmin and it seem to work now.. :)

Little problem with the game icons, in the admin cp for each game I upload the icon and nothing gets displayed, It just refreshes the page but doesn't actually upload the icon. any other way of adding icons to each games?

Also, what would cause the game not to load? It stays at "opening page" in the browser stats bar, like it's trying to load the flash game but never loads it.

thanks for support.

excellent work futureal :) thank you very much !

i have installed this hack on a 2.2.6 vbulletin, with no problem !
(but with the manual method, the vbhacker method doesnt work on my host site, but only on my local testing board)

only a bug for the moment in the games inself, a problem with 22th level of the breakout, the bullet passes through the top bricks, and ..game over :confused:

i'll be willing to check out the flash issue with netscape.
i cant see anything, because netscape7 jumps to a nonexistent url. some other bug in the movies. need the fla files, someone can post them here? if the problem with the post method makes trouble (haven't heard yet of this issues myself) i could think of a another method for making the sending via get secure. i.e. check the referer or just allow this for localhost or stuff like that. should be nop prob.

on my forum www.milkmycow.com/forum/proarcade.php the game files never load once you goto them, they just stay @ a black screen. any ideas?

my games are in forum/games/ dir and in the admin its set to all games from /games/

aim - retardkeith please im me

Damn nice hack, all I need now is a way to add more games. Cant wait for more :P

ok guys .. my appology.. but i really needed to fix this hack cause my forum members were eating my brains off ...

well as suggested i've checked everything .... all the games work fine for admins only ...

but when i try to activate the game... i just doesn't do it ..:(

i have checked the code over and over again ... but its all as in the install text ....

cheers

make sure you activate EACH game in the game options. that's the only thing that will be checked in the code for your issue. use phpmyadmin and look in the table and set the corrosponding field manually to 1, if you cant get it to work.

@milkmycow:
sounds like the flashmovies arent found. i couldnt check your forum, didnt want to register. look in the sourcecode of your html-page with the flashmovie and check what path is set therer for the movie.

I am getting a blank page as well, the page loads but not the game... the flash hangs and never loads.

how can we fix it? :(

like i said, check what url is in the flash object-tag. you have to enter the right directory in the global options (for testing leave this blank and put all your movies in the /forum dir). if you cant get it to work, pm me the url to your forum and a login i can use and ill take a look.

btw. i fixed a little bug with the querystring, the querystring to the movie has to be urlencoded, because there are specialchars in it (/) which can't be transfered in the url. some versions of internet explorer fix this itself, but netscape dont.

in the flash object tag for netscape, the querystring was missing, so that was probably the problem why the scoreboard etc. didint work in netscape.

with that 2 fixes, i was able to get all working with netscape7. no problem with the scoreboard and posting, runs fine. i dont know if there are problems with other netscape versions. if so, post the the netscape version and error message here, ill take a look.

here are the 2 fixes:

in proarcade.php find this:

replace it with:


in template vbproarcade_playgame_flashcode

replace
with

thats it... have fun.

and thx to futurereal for this nice hack...

if any1 got some more flashgames, go ahead and post the fla.files here...

Milkmycow, (that sounds funny) .. I figured out the problem, in admin cp click on vbproarcade general options and change the path to games from /games/ to games/

Anyone having trouble uploading the images for each game? I upload the images but it doens't get displayed on the arcade index .. odd, I was able to upload the score board and crown images without a problem.

first i have to say, that this is a great hack :)

but now i have a question i think was often there: "Is there a way to get more games for this hack?" ;)

futureal, can you explain how come I am getting 3 extra queries on forum home? There isn't anything vbproarcade related on forum home, how come an increase in queries on main page? How do I at least turn 3 queries into 1?

im not futureal, but here you go: all i can say is rtfm.... read da ++++ing manual.

in index.php there's code inserted so that you can put some links to the games on your forumhomepage template . that's explained in the manual.txt. just revert your index.php to your orignal code if you dont need it.

in proarcade.php I replace the default permissions with:

How can I make a user with no requierments go to a new template with the text saying Y"ou need 2 posts to play in the arcade"?