vb.org Archive

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)

Ryangel 08-26-2002 07:57 AM

Quote:

Originally posted by futureal


This can be done. Here's an example:

http://www.shadowsofnamek.com/forum/...game=tetris&s=

Or another, from a different game:

http://www.shadowsofnamek.com/forum/...me=breakout&s=

Only each user's best score is shown. To accomplish this, you need to alter the query used in tetris.php for the "leaderboard" action.

From the original tetris.php file, you will want to replace this:

PHP Code:

$leaderboard_q $DB_site->query("SELECT * FROM arcade WHERE game='tetris' ORDER BY score DESC LIMIT 10"); 

with 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 10"
); 

That should achieve the result you're looking for.

I think there might be some error to this. I tried it but the comments didnt go to where they were suppose to.

Courage 08-26-2002 08:40 AM

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?

My users are complaining about the same thing. They are playing for a long time and when thy finish... Acces Denied :(

PHP Version v4.2.1
MySQL Version v3.23.51-log
Tteris 2.5



Please Help.
My users are playng for 3-4 hours and the score cannot be registered :(

Ryangel 08-26-2002 09:16 AM

Quote:

Originally posted by Courage
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?

My users are complaining about the same thing. They are playing for a long time and when thy finish... Acces Denied :(

PHP Version v4.2.1
MySQL Version v3.23.51-log
Tteris 2.5



Please Help.
My users are playng for 3-4 hours and the score cannot be registered :(

Not all your users right? I have soem users having this problem too. I can never recreate it myself though. This is a toughie .

John 08-26-2002 10:35 AM

I've just got a couple of things to fix in the beta, then I'm releasing! (In a manner of speaking ;)) There's already an option in the arcade hack to view the top scorers only, I had to add a lot of code to do it.

John 08-26-2002 10:36 AM

Quote:

Originally posted by Ryangel


Not all your users right? I have soem users having this problem too. I can never recreate it myself though. This is a toughie .

Increase timeout ?? (vB options)

kmfdm_kid2000 08-26-2002 11:41 AM

Quote:

Originally posted by john.eovie


Increase timeout ?? (vB options)

I have the same exact problem myself, some users get no permission when they get high scores, could you be a bit more specific?? If you're talking about cookie time out, I believe mine is set to 900, now what do you suggest to remedy the problem??

John 08-26-2002 11:43 AM

Quote:

Originally posted by kmfdm_kid2000


I have the same exact problem myself, some users get no permission when they get high scores, could you be a bit more specific?? If you're talking about cookie time out, I believe mine is set to 900, now what do you suggest to remedy the problem??

Cookie Timeout - bump it up to 1800, and see if the problem stops. If so I'll try and find a more permanent soilution.

Schorsch 08-26-2002 01:40 PM

Quote:

Originally posted by kmfdm_kid2000


I have the same exact problem myself, some users get no permission when they get high scores, could you be a bit more specific?? If you're talking about cookie time out, I believe mine is set to 900, now what do you suggest to remedy the problem??

exact problem here, my users told me that the "no permission" page only appears when you get more than 1,000,000 points.

John 08-26-2002 01:43 PM

Quote:

Originally posted by Schorsch


exact problem here, my users told me that the "no permission" page only appears when you get more than 1,000,000 points.

I think it's more of a time thing rather than a score this :\

Arcade hack finished!

Schorsch 08-26-2002 01:56 PM

Quote:

Originally posted by john.eovie
Arcade hack finished!
:) :banana: :banana: :banana: :banana: :banana: :banana: :)


All times are GMT. The time now is 12:05 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02446 seconds
  • Memory Usage 1,749KB
  • 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
  • (2)bbcode_php_printable
  • (8)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