vb.org Archive - vB Tetris v2.5 | Leaderboard, Comments and High Score System v2.5 :)

Page 75 of 106

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - vB Tetris v2.5 | Leaderboard, Comments and High Score System v2.5 :) (https://vborg.vbsupport.ru/showthread.php?t=42293)

John	08-23-2002 06:37 PM

Quote:

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

08-23-2002 07:57 PM

Quote:

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	08-23-2002 08:02 PM

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

Lanigironu

08-23-2002 08:18 PM

Maybe your syntax was wrong?

futureal

08-23-2002 08:27 PM

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. :D

Schorsch

08-23-2002 08:33 PM

Quote:

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. :D

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

John	08-23-2002 09:04 PM

Quote:

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

JJR512

08-23-2002 09:16 PM

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

08-23-2002 09:42 PM

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

kypdurron

08-23-2002 10:17 PM

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?

All times are GMT. The time now is 09:58 AM.

Page 75 of 106

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02090 seconds Memory Usage 1,746KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: