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)

Natch 02-07-2004 05:15 PM

/me needs sleep it being 6:15AM the morning after a night of no sleep and a day of upgrading/rehacking to RC4 ...

Thanks all and g'night LOL

version2 02-07-2004 06:12 PM

Quote:

Originally Posted by John
Does your modifyarcade template exist?

Edit: Haha :p

John, you have done a great job. My members are loving this hack.

John 02-07-2004 06:13 PM

Quote:

Originally Posted by version2
John, you have done a great job. My members are loving this hack.

They ain't seen nothing yet. :p

version2 02-07-2004 06:20 PM

Quote:

Originally Posted by John
They ain't seen nothing yet. :p

I like to hear that! Just wait until you see the hacks I am working on privately! ;) Good work, man.

idwf 02-07-2004 08:15 PM

Quote:

Originally Posted by version2
I like to hear that! Just wait until you see the hacks I am working on privately! ;) Good work, man.

Invalid SQL:
SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM gamesessions AS gamesessions
LEFT JOIN user AS user ON user.userid = gamesessions.userid
LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
WHERE (gamename='asteroids' AND score='3660') OR (gamename='chopper' AND score='316') OR (gamename='snake' AND score='53') OR (gamename='spaceinvaders' AND score='3200') OR (gamename='tetris' AND score='383') AND sessiontype=1 ORDER BY gamesessions.gamename DESC

mysql error: Got error 28 from table handler

mysql error number: 1030



found an error! any ideas?

VodkaFish 02-07-2004 08:37 PM

Quote:

Originally Posted by John
Which settings in particular did you want to have on a game by game basis?

I was hoping I could define which games are available to which usergroups. So that basic members have 5 games available, then the next level has 10, and so forth; with me being able to define what's what. I wasn't positive this was in the works (if not, that's cool, it's a great piece of work); if so, then I was curious to where this was on your ladder of things to do. Merely a curiousity question :)

John 02-07-2004 08:46 PM

Quote:

Originally Posted by idwf
Invalid SQL:
SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM gamesessions AS gamesessions
LEFT JOIN user AS user ON user.userid = gamesessions.userid
LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
WHERE (gamename='asteroids' AND score='3660') OR (gamename='chopper' AND score='316') OR (gamename='snake' AND score='53') OR (gamename='spaceinvaders' AND score='3200') OR (gamename='tetris' AND score='383') AND sessiontype=1 ORDER BY gamesessions.gamename DESC

mysql error: Got error 28 from table handler

mysql error number: 1030



found an error! any ideas?

http://www.mysql.com/newsletter/2003...000000249.html

Error 28 isn't anything to do with the coding of the Arcade, rather the server it's running on. (And more specifically, the state of the database)

Link14716 02-07-2004 08:50 PM

Quote:

Originally Posted by John
http://www.mysql.com/newsletter/2003...000000249.html

Error 28 isn't anything to do with the coding of the Arcade, rather the server it's running on. (And more specifically, the state of the database)

I managed to get error 28s in the arcade before, it was on and off, but it eventually fixed itself.

It was odd when an error 28 poped up from SELECT but didn't pop up when adding a post.

idwf 02-07-2004 08:57 PM

[EDIT] I've contacted them, and it WAS a host error. thanks guys!:squareeyed:

svtsnake01 02-08-2004 12:21 AM

I would like to see a drag racing game, that would be awesome


All times are GMT. The time now is 03:53 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.04145 seconds
  • Memory Usage 1,745KB
  • 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
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (6)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