vb.org Archive - v3 Arcade - Games Arcade & Challenge System [vB 3.0.3]

I wonder if there is some modification to make Arcade main page game listing in two columns. Most of the people do not actually notice page navigation down there and thinking that the first page is all we have.

Cheers!

jpt62089

08-07-2004 09:40 AM

just installed on my fresh VB... I dont have permission to access the arcade... I checked the group settings and they are go...

Please be easy on my :p this is my first VB mod! :ninja:

trackpads

08-07-2004 09:59 AM

Quote:

Originally Posted by armkbdotcom

That is a great idea! I like this better than the category mod. Shouldnt be more than a template edit right?

lierduh

08-08-2004 05:29 AM

Quote:

Originally Posted by trackpads

That is a great idea! I like this better than the category mod. Shouldnt be more than a template edit right?

Herhaps adding a navigation bar at the top of the game list can be more effecitve.

Just modify "arcade_main" template.

Add these two lines before the block of code below:

<span class="smallfont"><br></span>
$pagenav

PHP Code:


		
			
<!-- small space --> 

<span class="smallfont"><br> 

</span> 

<!-- /small space --> 

<!-- games  --> 

<table cellpadding="$stylevar[outerborderwidth]" cellspacing="0"

jpt62089

08-08-2004 06:57 AM

Quote:

Originally Posted by jpt62089

just installed on my fresh VB... I dont have permission to access the arcade... I checked the group settings and they are go...

Please be easy on my :p this is my first VB mod! :ninja:

Bump :)

armkbdotcom

08-08-2004 07:04 AM

Quote:

Originally Posted by lierduh

PHP Code:


		
			
<!-- small space --> 

<span class="smallfont"><br> 

</span> 

<!-- /small space --> 

<!-- games  --> 

<table cellpadding="$stylevar[outerborderwidth]" cellspacing="0"

Still not what we wanted. Lot of space from the right is wasted.

Spinball

08-08-2004 10:16 AM

Hi Folks,
I have just upgraded from vbulletin 3.0.1 to 3.0.3.
Having previously had 1.0.0 of this hack installed, I am slightly confused as to what I need to do to bring it up to 1.0.2.
I have gone through and put all the code changes in.
All the templates seem to be the same so I haven't changed any of those.
But I'm worried about running forumroot/admincp/install_arcade.php incase it overwrites any database information allready there.
Can you please confirm whether I need to run this again or not?

Also I have several tables in the database from the vB2 installation :

arcadeconfig, arcadegames, arcadescoregroups, arcadescores and arcadetopscores

am I right in assuming these are no longer used and I can delete all of them?
Thanks

dethfire

08-08-2004 03:06 PM

this hack worked great for a few months , now suddendly I get this error everytime members visit the arcade:

Code:



Database error in vBulletin 3.0.1:



Invalid SQL: 

                                        SELECT games.title, games.gameid AS gameid, gamesessions.*,user.username FROM gamesessions AS gamesessions

                                        LEFT JOIN user AS user ON gamesessions.userid = user.userid

                                        LEFT JOIN games AS games ON gamesessions.gamename = games.shortname

                                        WHERE gamesessions.valid=1 AND gamesessions.sessiontype=1 ORDER BY gamesessions.finish DESC

                                

mysql error: Got error 127 from table handler



mysql error number: 1030



Script: http://www.cool-teens.com/forum/arcade.php?

Pseudomizer

08-08-2004 03:09 PM

Quote:

Originally Posted by dethfire

this hack worked great for a few months , now suddendly I get this error everytime members visit the arcade:

Code:



Database error in vBulletin 3.0.1:



Invalid SQL: 

                                        SELECT games.title, games.gameid AS gameid, gamesessions.*,user.username FROM gamesessions AS gamesessions

                                        LEFT JOIN user AS user ON gamesessions.userid = user.userid

                                        LEFT JOIN games AS games ON gamesessions.gamename = games.shortname

                                        WHERE gamesessions.valid=1 AND gamesessions.sessiontype=1 ORDER BY gamesessions.finish DESC

                                

mysql error: Got error 127 from table handler



mysql error number: 1030



Script: http://www.cool-teens.com/forum/arcade.php?

Perhaps your table has been corrupted. Try to repair the table and it should work again.

Cheers,

evilTone

08-10-2004 08:56 PM

Code:

Database error in vBulletin 3.0.3:



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='7210') AND sessiontype=1 ORDER BY gamesessions.gamename DESC

        

mysql error: Column: 'score' in where clause is ambiguous



mysql error number: 1052

any ideas ?
if i clear the table 'gamesessions', then it works for a short time, around 2-3 games then this error comes back.
error also goes away if i 'reset public scores'

i tried the "repair table" option mentioned above also :/

All times are GMT. The time now is 10:28 PM.

Page 263 of 457

263

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04958 seconds Memory Usage 1,764KB 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_code_printable (2)bbcode_php_printable (5)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
Messages: