vB Tetris v2.5 | Leaderboard, Comments and High Score System v2.5 :)

hack removed, someone please delete this thread.

Apparently the 6 days solid I spend supporting this wasn't good enough (not to mention the 65 page total).

Thanks

[John]

Originally posted by kypdurron
If Im using Ie6, after playing for awhile, I get a "access denied" error when the game is over...why is that and how can I disable it?

vB version, tetris version?

Are you talking about the no permission page?

[Souly]

I have try to add Levels. i can not test it, because i am an admin and i have no time to play much hours ... I have never work before yesterday with flash, plz. test it on your own risk

[Changes]
*16 Levels: 11-16 are new and i think they are very hard, but i don?t play tetris, i can?t test it

3 new tetris.swf:
--> plz make a backup of all your previous tetris.swf Files before you test my new version!

1 Version:
------------
english, 16 Levels (6 new) very hard! pause is disabled

2 Version:
------------
english, 16 Levels (6 new) very hard! pause is enabled

3 Version:
------------
german, gray background, 16 Levels (6 new) very hard! pause is disabled


Here are Number ONE:
(english, 16 Levels (6 new) very hard! pause is disabled)

[INSTALL]
Download the tetris.zip File, unpack it and copy the tetris.swf File in your forum root and let test your user the 6 new level!
.................................................. .................................................. ..

[Souly]

Here are Number TWO:
english, 16 Levels (6 new) very hard! pause is enabled

[INSTALL]
Download the tetris.zip File, unpack it and copy the tetris.swf File in your forum root and let test your user the 6 new level!
.................................................. .............................. ......................

[John]

I'll look forward to hearing from people as to whether this works or not

[Souly]

Here are Number THREE:
(german, gray background, 16 Levels (6 new) very hard! pause is disabled)

[INSTALL]
Download the tetris.zip File, unpack it and copy the tetris.swf File in your forum root and let test your user the 6 new level!
.................................................. .............................. ......................

[John]

Ok, when I run

$leaderboard_q = $DB_site->query("SELECT game,userid,comment,date,max(score) as maxscore
                                    FROM arcade
                                    WHERE game='$gamename'
                                    GROUP BY userid
                                    ORDER BY maxscore DESC
                                    LIMIT $top_number");

in place of the standard leaderboard_q code, I get no records returned.

[Ninth Dimension]

I played the second tetris game and got to level 2, good huh??

[Castel]

Originally posted by Souly
Here are Number TWO:
english, 16 Levels (6 new) very hard! pause is enabled

[INSTALL]
Download the tetris.zip File, unpack it and copy the tetris.swf File in your forum root and let test your user the 6 new level!
.................................................. .................................................. ..

Would you mind including the fla files for these in the zip so we can adjust colors to fit site design.

[futureal]

Originally posted by john.eovie
Ok, when I run

...snip...

in place of the standard leaderboard_q code, I get no records returned.

Dang, I dunno what the problem could be. Aside from a few different variable names, that is the exact query I am using, and it works well. Could you post the ensuing while loop to go along with it that you are trying? Maybe something is going wonky there...?

The only other thing I can think of is to try it with hardcoded variables that you know exist in your database. Like, use 'tetris' instead of $gamename and "10" instead of $top_number and so on. Just to eliminate all possible problems.

edit: Actually, just try entering the query directly into mysql on your site and see what it returns. That is usually the best way to try things out... let me know if it is returning something weird.

[John]

Of course, the variables were the first things I checked. All working fine. When I run the code in the database, I get a result back. But I'm not changing anything else, so it doesn't make sense...