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 Heineken77
No news on why my screen is stuck on loading...?

http://nba2k3.net/forum/tetris.php

Unless you're on a non IE browser, you've probably installed it incorrectly.

[futureal]

Originally posted by john.eovie
I'll post the main issue here, so everyone can have a go.

Basically, I need a SQL query that will select the highest score each userid has, and output the records.

So:
1. There's only one record per userid value
2. And the score value that corresponds to the userid is the highest one.

This only needs a single query. Try this:

PHP Code:

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


That should give you what you need.

I am making a new scoreboard right now that does just this. I'll post a link when it's done.

[John]

I've tried that before, for some reason it returned no records (and yes, there were records in the db)

[Lanigironu]

Maybe your syntax was wrong?

[futureal]

That same query works just fine for me. What kind of error is it giving you?

Here it is in action:
http://www.shadowsofnamek.com/forum/...pscoreboard&s=

I am having way too much fun messing with this leaderboard. I am going to go play a round of frisbee golf, and when I get back I have some more ideas to mess with.

[Schorsch]

Originally posted by futureal
That same query works just fine for me. What kind of error is it giving you?

Here it is in action:
http://www.shadowsofnamek.com/forum/...pscoreboard&s=

I am having way too much fun messing with this leaderboard. I am going to go play a round of frisbee golf, and when I get back I have some more ideas to mess with.

I need that urgently!!! how can I do that ?

[John]

Originally posted by futureal
That same query works just fine for me. What kind of error is it giving you?

Here it is in action:
http://www.shadowsofnamek.com/forum/...pscoreboard&s=

I am having way too much fun messing with this leaderboard. I am going to go play a round of frisbee golf, and when I get back I have some more ideas to mess with.

Looking good, given me some ideas for the Arcade hack leaderboards

[JJR512]

There are two issues with the actual Flash game (Tetris) I'd like to bring up. One is a suggestion, the other is a possible bug.

1. Suggestion: On the introduction screen (after the Loading), there could be a way to bypass it and go straight to the game. I know it only lasts a few seconds, but when you're on a roll, trying to get the next high score, it's seconds of agony waiting for the game to hurry up and frickin' start.

2. Problem: I don't know the level number, but it's the one that starts with a single line going all the way across the screen, closer to the top, with a two-block-wide hole near the middle. If you get a zig-zag-shaped piece right away, and fill in the hole in that line, the line does not disappear right away. The line does not disappear until you drop the next piece. It doesn't matter where you drop the next piece, and obviously, you can't make a solid line with it, but as soon as you drop it, the line you made with the first piece then disappears. I hope you can understand what I'm saying.

[Ninth Dimension]

Re what JJr512 said, I'd noticed this as well, but I think it's designed that way.

[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?