I solved first problem with running a query like this:

But my second problem remains intact, every item of page is loading but when I try to play a game, Flash section of page is only white.

I'm getting the following mysql error when I run arcadeimport.php:

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE arcade_games AS arcade_games SET sessioncount=11626, highscorerid=12556, highscore='133337.000' WHERE gameid=1;

MySQL Error : You have an error in your SQL syntax near 'AS arcade_games SET sessioncount=11626, highscorerid=12556, highscore='133337.00' at line 1
Error Number : 1064

Anyone know what's wrong and how I cure it?

Cheers,

Chris

I have an optimisation question.

When I check the amount of queries, I see this.

Page generated in 0,74908 seconds with 19 queries (1 queries for uncached templates) [Server Loads: 8.68 4.09 : 2.73]
Uncached templates: arcade_award_bit (35)
How can I prevent that ?

Temporary fix here

When I click on the username it doesn't take me to their profile. It goes to the top of the page. Anyone could help me about that?

I believe there's a small bug here, the "news&events" timing is getting its info from the server time, not accounting for DST corrections inside vB...
DST is in effect where I live and my boards show the correct time, but the news&events time is one hour behind...

where do i find USERCP_SHELL or POSTBIT... Help

Go in admincp
select styles and templates
click on "search on templates"
in the box write usercp_shell and click on find button

do the same thing for postbit

Great hack, I installed it succesfully and converted the games and scores from ibProArcade (that I used on my vB 3.0.x forum).

I've posted this on the v3 Arcade forum's and didn't get a reply so I'm hoping I'll have a better chance here.

I'm trying to add more games to the arcade and no matter what I do I keep getting this error:

Fatal error: Call to a member function on a non-object in /home/rcnitro/public_html/forum/rootcp/arcadeadmin.php on line 592

Does anyone know of a fix for this?

-Michael