i removed that entry from in proarcade.php works perfect now, go figure

no i'm using IE 5.0

I keep getting this error please help.

Database error in vBulletin 2.2.7:

Invalid SQL: SELECT * FROM arcadescores WHERE game='tetris' ORDER BY score DESC LIMIT 1
mysql error: Table 'mtgshoe_mtgshoevbb.arcadescores' doesn't exist

mysql error number: 1146

Date: Friday 13th of September 2002 10:36:42 PM
Script: http://www.mtgshoebox.com/forums//fo...ay&game=tetris
Referer: http://www.mtgshoebox.com/forums/index.php?

edit: I stand corrected. Since I no longer had a fresh copy of the old proarcade.php, I used the same version that I had been testing with on somebody else's site. Apparently, that individual had modified the code and I was unaware of it. I will have to update the zip again.

Sorry for the troubles; I hadn't anticipated on having to do a re-zip of the old version, and since all of the stuff on my hard drive is now Beta 2, things got mixed up. I thought I had caught everything, but apparently not.

edit again: The zip is now updated (again). Just re-download it and replace your proarcade.php with the one from the zip. Thanks.

You must have downloaded the zipfile last night or earlier today before I fixed it. Please see this post for more info: https://vborg.vbsupport.ru/showthrea...616#post298616

Then, re-download the zipfile in the first message and replace your proarcade.php with the copy from that file.

Thanks!

I'm using IE 5.50 and the user that has the same problem is using IE 6.0.26.

you da man!

futureal...

Ok check it out, I tried playing games from another computer, and It recorded my scores fine. So it's got to be something local on my PC.

I've seen a lot of members on different sites with the same problem I'm having, so there's some kind of requirement that I don't think everyone knows about, or something...

The only think i can think of is that it's somehow related to my flash plugin. does anyone know of a way to uninstall a flash browser plugin? I'm already updated to the most recent version, but I wonder if a clean install of the plugin would work better than this....

Other than that, i'm completely stumped.

Maybe if admins could gather the user info (browser, version, etc..) for the members that are having this same problem and post it here, we could figure out what the exact problem is?

hay futureal, i have been experiencing a small bug with my Arcade, it seams aa couple of the usergroups that i added to the forum, are not getting permission to play...what i mean is my "Rgistered" users are fine but i have a "VIP Members" group, and they cant access the games...
any ideas? thanks in advanced :)

Audio,

that was fixed here

https://vborg.vbsupport.ru/showthrea...244#post294244

Find this in proarcade.php:
You have to add each usergroup here that you want to allow to use the arcade.

thanks guys that did it :)

I re-downloaded the zip and replaced the file and i get the same error, can someone send me the old proarcade.php file please?

The zip that is currently in the first post has the correct file. I just double checked it and it does not contain the line of code that you are getting an error on...

I am going through known bugs and whatnot with the Flash player to see if I can find anything, and asking around some other places on the net.

I am not sure what kind of information would be most useful to gather from people. We've already determined it's not based on the browser version or the plugin version. Do you have anything odd in terms of a net connection, like a robust firewall, internet connection sharing or anything of that sort?

edit: Also if possible, let me know what your security settings are in IE, and whether or not you are going through a proxy server. I have been reading stuff on FlashKit about anomalous behavior with Flash and IE -- those are just a couple of the possibilities.

further edit: Another idea I've had is that it might have something to do with your caching options. In IE, check the "Settings" under "Temporary Internet Files" and let me know what it says (Always check, Check when IE starts, Auto, Never). Thanks.

eckels2: I went ahead and modified one of the games (Pacman -- one of two that I have access to right now) with one of the ideas that I had.

Please upload this to your arcade dir and change the filename in the Admin CP to match pacman-beta.swf (this way we'll know for sure that you're testing the new version of the swf) and give it a shot.

My hunch (and it's only a hunch, believe me) is that this is a browser cache issue of some sort. As a result, I hardcoded the action and game into the URL that Flash is passing to the script, and then appended a randomly generated number to the URL to force the browser to think that it's a new (or rather, unique) page. The chances of this actually fixing the problem aren't that high, but it should at least give us a better idea of what we're dealing with.

The file is attached here. Thanks!

In other vbProArcade news, I got inspired tonight to make the navigation bar ($navbar) easier to use.

The end result is that there is now a hierarchal navbar much like standard vBulletin.

All pages have:

Your Forum > Arcade

Sub pages have:

Your Forum > Arcade > Game Title
Your Forum > Arcade > Game Title Scoreboard
Your Forum > Arcade > Game Title Top Score Board
etc.

And with Beta 2, there will be sub-sub-pages, such as:

Your Forum > Arcade > Game Title Scoreboard > User Name's Scores for Game Title

But the best part about this system is that it uses the vBulletin navigation system, which means the template code has been reduced to simply "$navbar" and it will incorporate any changes you make the following templates:

navbar
nav_joiner
nav_linkoff
nav_linkon

This should make life easier from an Admin point of view.

These changes WILL be in Beta 2.

do you have aim or icq or something I can talk to you on? because I am still getting this error go to http://www.mtgshoebox.com/forums/proarcade.php to see it for yourself.

Works for me dude. You might want to Enable all of your games, though :)

your kidding? I still get the same error....why? lol

It did work fine, now I just get a blank page. Odd.

can you send me the old proarcade.php file? if you have it please. my e-mail is ooshoeoo@bellsouth.net

I will PM it to you then........

I get a blank page as well.

SHoeSTeR: Hit Ctrl-F5 to force your browser to do a refresh in case something is cached.

thanks link.

Also, if you get a blank page after, make sure your templates installed properly. ;)

everything works now, thanks guys.

Your welcome :)

ok i downloaded some MINI java games...how should i install it...or does it need to be shockwave??? HELP

At this time, it only works with Flash/Shockwave games.

I hope you will include a txt file which is for upgrade and for ppl who have installed beta 1, so we don't need to uninstall and re install it again..

ok futureal, i PMmed you my security settings...

as for "Do you have anything odd in terms of a net connection, like a robust firewall, internet connection sharing or anything of that sort?"

No, no and.. no.

I've got a cable modem. nothing shared. just me :)

Cacheing options are as follows:
Every time you start Internet Explorer

250mb.

*** results of beta pacman test ***

http://www.afterblur.com/vb/proarcad...heKiller=26170

That was the url i got after i played... Sent me to the Pacman scoreboard afterwards. No comment submission screen.

Update... did a clean install of flash (i figured out how to uninstall it)... didn't work :(

Man, how frustrating is all of this. lol...

But in the end i guess this could solve the problem for all the helpless users.

I looked everything over, and my only suggestion is to try changing your cache settings to "Automatic," restarting the browser, and giving it another shot.

Other than that, everything seems to match my system perfectly.

I have a conversion script that will covert the database tables to be compatible with the new ones, but that will be it.

It will be up to users to make sure that the necessary code changes are made. Most of the changes are in the pro*.php files which can just be replaced, but there are others.

Also, the best option will be to remove the old templates and re-add the new (Beta 2) templates, since nearly every one has changed (with a few removed and a bunch added).

I will make it as painless as possible BUT it may be somewhat complicated.

:(

Still didn't work.

This is maddening...

Yea... I've got to say, I'm out of ideas. I tried setting my browser up just like yours, and it worked fine. I am behind a firewall and everything too, and it works OK for me...

/me bangs his head against the desk.

dammit.

Can the way that the flash games transmit the data be changed to a different method? Is that possible, is what i mean. If it is, i'll screw with it myself, i'd just need the fla's for the games...

This is an amazing hack and it seems to work perfect for most of my 700 users but vbulletin has been emailing me about sql errors.

Like this

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE lastactivity>1032214124 AND sessionhash='de0056fe406cbbd965a806bbd71f3dde' AND (host='198.81.26.175' OR (althash='' AND althash<>'')) AND useragent='Mozilla/4.0 (compatible; MSIE 6.0; AOL 7.0; Window'
mysql error: Unknown column 'althash' in 'where clause'

mysql error number: 1054

and

Database error in vBulletin 2.2.7:

Invalid SQL: SELECT max(score) as maxscore FROM arcade WHERE game='pacman' AND username='TL's De La Hoya'
mysql error: You have an error in your SQL syntax near 's De La Hoya'' at line 1

mysql error number: 1064

Sorry if this question has been asked ive only read 15 of the 27 pages of this thread so far.

Any help is appreciated - great hack

1st Error:

What vB Version are you using?

2nd Error:

I know what the problem is, it is the ' in the username. So, futureal.....? :)