Erwin,
I would like to remove the mini scoreboards, but I want to keep the top score, user score, etc in the main table.. How many queries can I eliminate by removing just the mini scorebaords? I'm at work right now and don't have access to any of the files or else I'd look myself.

With 16 games, if you just remove the Mini Scoreboards, you go down from 83 queries to 65 queries only. I didn't think it was enough.

This is because it takes a lot of queries to find out the user's own highscore, what rank he or she is at, how many users have played it, the overall high score, is he the high scorer etc.

Thanks Erwin. Hmm.. In that case I think I'd be better off to remove everything that you removed.

When you are down to the minimum 16 queries, no matter how many games you add, it should still stay at 16. :) Because all you're left is the 1 query to get the name and description.

Anyone done donkey kong yet?

Or how about that Kill Kenny southpark game I linked to earlier on page 25/26 or whatever it was. Can anyone do them?

Still no luck on a frogger score board either I take it, ah well....kepp up the good work guys, much appreciated

Ok, i have deleted everything Erwin says (thanks Erwin) and get 16 Querys (my proarcade.php attached). :)

Kars

Exactly, Kars. :) For those who want to do this, don't forget to edit the templates:

vbproarcade_arcade - remove the $arcadebit table
remove the table headers columns for High score etc. just leave the name and description

vbproarcade_arcadebit - remove all extra columns except name and description.

Done. :)

thanks for the querie drop :) 87 is very high lmao

now 15-16 on page.

right where can i download these flash games ???? i will try to make a good few ?? any ideas

<a href="http://www.flashkit.com/movies/Games/Full_Game_Source/" target="_blank">http://www.flashkit.com/movies/Games/Full_Game_Source/</a>

I am working on Frogger right now, but its kinda hard! :(
Everytime i have played the game it redirects me to the scoreboard but i can?t add my scores! :(

Kars