vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   v3 Arcade - Games Arcade & Challenge System [vB 3.0.3] (https://vborg.vbsupport.ru/showthread.php?t=60377)

Big Jim 01-23-2004 01:07 PM

I never got a response to this John:

https://vborg.vbsupport.ru/showpost....&postcount=593

Slappy Nutz 01-23-2004 01:09 PM

This is such a kick ass hack! Good job. I am only having 1 slight problem. See screenshot, youll get it then

Nam 01-23-2004 01:51 PM

I'm wondering that when I clicked the "High Scores" link under the game, it shows 10 pages of "no comment", I know I can delete it, but it seems that the hack will hold as many as the database can hold, for the game such as helicopter, in which you crash frequently, it is pointless to record that kind of game.

Instead of listing pointless and unlimited scores, why just display top 10 scores or 100 scores, anything more than that will be ignored and will not be recorded. Unless I'm missing something here.

Smirks 01-23-2004 02:04 PM

Quote:

Originally Posted by Nam
I'm wondering that when I clicked the "High Scores" link under the game, it shows 10 pages of "no comment", I know I can delete it, but it seems that the hack will hold as many as the database can hold, for the game such as helicopter, in which you crash frequently, it is pointless to record that kind of game.

Instead of listing pointless and unlimited scores, why just display top 10 scores or 100 scores, anything more than that will be ignored and will not be recorded. Unless I'm missing something here.

I agree. A great feature would be to limit the number of high scores, and make it setable in the admin area. I for example would probably like to limit the # of scores in the table to say 200, and if you'r not in the top 200 you just don't get listed.

John 01-23-2004 02:36 PM

Quote:

Originally Posted by Big Jim
I never got a response to this John:

https://vborg.vbsupport.ru/showpost....&postcount=593

This is basic HTML, try checking out w3's HTML school here.

John 01-23-2004 02:39 PM

Smirks and Nam, you can rest assured that most of the features people suggest here have already been thought over a long time before I even started coding this hack - but there comes a point where you have to release it, and leave the other features for future updates. :)

CampusCrawler 01-23-2004 02:42 PM

Quote:

Originally Posted by CampusCrawler
Heya, I am having this error emailed to me. But everything seems to work fine on the front end.

Invalid SQL:
SELECT user.userid AS userid, gamesessions.score AS score, games.shortname AS shortname FROM vb3_gamesessions
LEFT JOIN vb3_user AS user ON user.userid = gamesessions.userid
LEFT JOIN vb3_games AS games ON gamesessions.gamename = games.shortname
WHERE (gamename='breakout' AND score='9750') OR (gamename='chopper' AND score='444') OR (gamename='simon' AND score='8') OR (gamename='snake' AND score='160') OR (gamename='spaceinvaders' AND score='6830') OR (gamename='target' AND score='390') OR (gamename='tetris' AND score='2055') AND sessiontype=1 ORDER BY gamesessions.gamename DESC

mysql error: Unknown table 'gamesessions' in field list

mysql error number: 1109


Any Ideas



-ADistantBox


I dont think there is an error similar on this thread. Everything seems to work fine though. This error is verry confusing.

ADistantBox

Smirks 01-23-2004 02:50 PM

Quote:

Originally Posted by John
Smirks and Nam, you can rest assured that most of the features people suggest here have already been thought over a long time before I even started coding this hack - but there comes a point where you have to release it, and leave the other features for future updates. :)

Completely understood. I'm not saying it's crucial, I'm just saying it'd be nice for a future release.... even if it's years away. :)

John 01-23-2004 03:45 PM

Quote:

Originally Posted by CampusCrawler
I dont think there is an error similar on this thread. Everything seems to work fine though. This error is verry confusing.

ADistantBox


Yeah, I've seen this error before. Are you using the latest arcade.php?

Alien 01-23-2004 04:25 PM

That's odd, since I've been keeping an eye on every time you updated the file in the first post. ;)

Only alteration I've made was the one in the extras folder called mini-stats or whatever... Can that be the source of the bug coming back? I haven't installed the mini-stats again yet and NOW it's working fine. I'd be afraid to re-install it lol...

Quote:

Originally Posted by John
'fraid not, I think this one came up about 7 pages ago! ;)



All times are GMT. The time now is 09:25 PM.

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.02573 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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