vb.org Archive
Page 24 of 27 « First 142223 24 2526 Last »
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)

trilOByte 08-26-2002 04:40 PM
...showing *only* thier high score.

I think I've worked it out myself. This should list users in order ofg their high dcore on the leaderboard, but list them only once, allowing lower scoring users a foot on the leaderboard....

find *both* instances of...

PHP Code:
$leaderboard_q = $DB_site->query("SELECT * FROM arcade WHERE game='tetris' ORDER BY score DESC LIMIT 10"); 
and replace them *both* with.....

PHP Code:
$leaderboard_q = $DB_site->query("SELECT game,userid,comment,max(score) as score FROM arcade WHERE game='tetris' GROUP BY userid ORDER BY score DESC LIMIT 30"); 
Oh yeah, this also increases the displayed users from 10 to 30.

Thanks.

trilOByte 08-26-2002 04:56 PM
BTW - how can I reset the leaderboard?

I'd like to run regular "races" and periodically zero all the scores. I assume I'll need to run a query, anyone know what it is?

Thanks.

Ian 08-26-2002 05:02 PM
Quote:
Originally posted by trilOByte
BTW - how can I reset the leaderboard?

I'd like to run regular "races" and periodically zero all the scores. I assume I'll need to run a query, anyone know what it is?
You could just go in phpMyAdmin and empty the 'arcade' table.

portion 08-26-2002 05:09 PM
can you tell us what the query is to do so if we cannot or choose not to use the phpmyadmin?

trilOByte 08-26-2002 05:10 PM
I'm one of 2 admins on the board, unfortunately, I dont have access to PHPMyAdmin I just run the query's through scripts usually.

futureal 08-26-2002 06:42 PM
Quote:
Originally posted by john.eovie
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.
I'm telling you guys, all you need is that one query to get the top scorers only to work. No one should have to "add a lot of code" to do it. If it isn't working for you (trilObyte?) give me the error and I'll help you out.

trilOByte 08-26-2002 06:47 PM
Quote:
Originally posted by futureal


I'm telling you guys, all you need is that one query to get the top scorers only to work. No one should have to "add a lot of code" to do it. If it isn't working for you (trilObyte?) give me the error and I'll help you out.
Yeah, I got it to work, but had to change it slightly, see about 4 posts further up the thread.

Thanks for the code ;)

futureal 08-26-2002 06:51 PM
Quote:
Originally posted by trilOByte
BTW - how can I reset the leaderboard?

I'd like to run regular "races" and periodically zero all the scores. I assume I'll need to run a query, anyone know what it is?
Run this query:

PHP Code:
$DB_site->query("DELETE FROM arcade WHERE game='tetris'"); 
But be careful! :D

My arcade hack has that option (Reset Scoreboard) in the Admin Panel.

Martin64 08-26-2002 07:02 PM
Will you release it, futureal?

Link14716 08-26-2002 08:52 PM
Quote:
Originally posted by john.eovie
:\ it seems to work fine, but I can't find anyone else to beta test it. my three beta testers have disappeared!
I think I'd be good enough. But wait, it's finished. DAMN, now how am I supposed to get it? I haven't seen a dime in about 3 months.....

NuclioN 08-26-2002 09:00 PM
I've seen realy fantastic slots in swf. If you could connect the score output right into lesane's store hack, win or lose...it would be awesome. ;)

Ninth Dimension 08-26-2002 09:01 PM
*cough* http://gamevine.co.uk/arcade.php *cough*

futureal 08-26-2002 09:38 PM
Quote:
Originally posted by Martin64
Will you release it, futureal?
The best I can say is "maybe" ...

It is completely working, but I have many other ideas to explore before I call it complete, and if I do release it, I'd like to do it in its complete form.

Specifically, the main thing I am working on is a less cumbersome security system, and hopefully a more secure one.

John 08-26-2002 09:39 PM
Quote:
Originally posted by futureal


The best I can say is "maybe" ...

It is completely working, but I have many other ideas to explore before I call it complete, and if I do release it, I'd like to do it in its complete form.

Specifically, the main thing I am working on is a less cumbersome security system, and hopefully a more secure one.
SEND ME BREAKOUT! :'(

futureal 08-26-2002 09:42 PM
I could get you the swf right now but I don't have the fla for it, and I don't think it would work for your arcade without some minor modification. The guy who modded it for me has not given me the fla yet. If and when I get it, I will send it...

Martin64 08-26-2002 09:50 PM
Quote:
Originally posted by Ninth Dimension
*cough* http://gamevine.co.uk/arcade.php *cough*
Cool, I just signed up. Check the Pacman leaderboard (one try. *proud*)

:D

BTW, is that john.eovie's arcade hack?

John 08-26-2002 09:52 PM
Quote:
Originally posted by Martin64



BTW, is that john.eovie's arcade hack?
Yes.

Yes it is.

Ninth Dimension 08-26-2002 09:58 PM
Quote:
Originally posted by Martin64


Cool, I just signed up. Check the Pacman leaderboard (one try. *proud*)

:D

BTW, is that john.eovie's arcade hack?
You beat my score

HOW DARE YOU!!!!!!! :)

and yes it is johns hack, but i changed it for my own needs.

Martin64 08-26-2002 10:02 PM
Well, it's looking sweet indeed. Well done both of you. :D

Now I'll go beat the Snake high score :p

Ninth Dimension 08-26-2002 10:06 PM
Pacman's more my game, don't worry, i'll get the highscore back ;)

[high]* Ninth Dimension goes to edit database[/high]

Zombie 08-26-2002 10:42 PM
deleted

John 08-26-2002 10:44 PM
Quote:
Originally posted by Zombie
Here's look at the arcade hack on my site
(registration required)
Looks awesome - well done!

Ninth Dimension 08-26-2002 10:49 PM
Quote:
Originally posted by Zombie
Here's look at the arcade hack on my site
(registration required)
I saw that earlier, it's looking good fella :)

Martin64 08-26-2002 11:11 PM
Quote:
Originally posted by Ninth Dimension
Pacman's more my game, don't worry, i'll get the highscore back ;)

* Ninth Dimension goes to edit database
Hrm, that's weak. :eek:

John 08-26-2002 11:14 PM
Hope you don't mind me posting this :):

http://www.eovie.co.uk/pics/20.gif

Ninth Dimension 08-26-2002 11:18 PM
Quote:
Originally posted by Martin64
Hrm, that's weak. :eek:
as it said, i'm DAMAN :)

anyway, I did beat your score, by one dot, without cheating, I just wanted to prove i could LOL :)

Martin64 08-26-2002 11:25 PM
I don't believe you, but who cares? It's not my board.
Anyway, that screenshot is looking great, john :)

John 08-26-2002 11:27 PM
Zombie did the graphics - it's just the arcade hack part I did!

Ninth Dimension 08-26-2002 11:32 PM
Quote:
Originally posted by Martin64
I don't believe you, but who cares? It's not my board.
LOL

Link14716 08-26-2002 11:37 PM
I say good job, I would have been more happy if you released it publicly figuring I have absolutley nothing.

/me runs off to make his own arcade hack.

John 08-26-2002 11:44 PM
Quote:
Originally posted by Link14716
I say good job, I would have been more happy if you released it publicly figuring I have absolutley nothing.

* Link14716 runs off to make his own arcade hack.
Don't worry, I will release this - eventually. :|

Schorsch 08-26-2002 11:46 PM
Quote:
Originally posted by LightBringer
John, I installed the new arcade hack and I'm now experiencing issues with not being able to reach the comment section after a game is played.

*this was with tetris...trying the other games now*
I'm coming up with a request to login/permission denied.

http://www.brainphreeze.com/forums/arcade.php

Ok, tested all games and this is what I come up after finishing any of the games.
I just installed it, and now I have the same error. John can you send me the modified file ?

Thanks,
Schorsch :)
bimberla@gmx.de

John 08-26-2002 11:49 PM
Sent - check you PM inbox :)

NuclioN 08-26-2002 11:55 PM
John:

"Don't worry, I will release this - eventually. :|"

Man, you had to know how we were trying to donate on that (*^&^(* paypal system. We would realy beta test this untill the smoke comes out of our forum. Can't you accedently PM a copy here and there to make some people sleep well tonight? :p

John 08-26-2002 11:59 PM
I'd love to, but as soon as I do that I'll get non stop attacks from others!

Link14716 08-27-2002 12:02 AM
People need to wait patiently, donate, or make it themselves, or wait until he releases it publicly damnit. I am gonna resort to trying to make one myself, which will be the biggest challenge I have ever done. All I can say is wish me luck.

Or tell me how a 14 year old can get some damned money :)

Schorsch 08-27-2002 12:05 AM
I have some bad colors after adding a comment (look attachment). Where and how can I change that ?

cu
Schorsch

Link14716 08-27-2002 12:07 AM
Templates. Look for hard-coded colors in any tetris_ template.

John 08-27-2002 12:07 AM
In arcade.php, search for the text that's the wrong colour - you'll see all of the html there :)

John 08-27-2002 12:08 AM
Quote:
Originally posted by Link14716
People need to wait patiently, donate, or make it themselves, or wait until he releases it publicly damnit. I am gonna resort to trying to make one myself, which will be the biggest challenge I have ever done. All I can say is wish me luck.

Or tell me how a 14 year old can get some damned money :)
Don't worry, very soon I'm going to try and come up with a non-money alternative :)


All times are GMT. The time now is 08:16 AM.
Page 24 of 27 « First 142223 24 2526 Last »
Show 40 post(s) from this thread on one page

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.02149 seconds
  • Memory Usage 1,829KB
  • 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
  • (3)bbcode_php_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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