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

Database error in vBulletin 3.0.7:



Invalid SQL: SELECT gamesessions.*, user.username FROM gamesessions AS gamesessions

                                                        LEFTJOINuserAS user ON user.userid=gamesessions.userid

                                                        WHEREgamesessions.valid=1ANDgamesessions.sessiontype=1 ANDgamesessions.gamename='ablast'

                                                        ORDERBYscore

                                                        DESCLIMIT-10,10

mysql error: You have an error in your SQL syntax; check themanualthatcorresponds to your MySQL server version for the right syntaxtousenear '-10, 10' at line 5



mysql error number: 1064



Date: Monday 28th of February 2005 12:29:26 PM

Script: http://forums.m-linux.net/arcade.php...es&name=ablast

Basscat

03-01-2005 01:24 AM

I can not get the arcade to work from my vbabd_home page. When I put the pointer on "arcade" in my navbar, it shows "mysite.com/arcade.php". When I put the pointer on "arcade" in my navbar from my forum index page it shows "mysite.com/forums/arcade.php", and the arcade works? I missed something, just not sure where.

neocorteqz

03-01-2005 03:03 AM

Quote:

Originally Posted by Basscat

I can not get the arcade to work from myvbabd_homepage.When I put the pointer on "arcade" in my navbar,itshows"mysite.com/arcade.php". When I put the pointer on "arcade"inmynavbar from my forum index pageitshows"mysite.com/forums/arcade.php", and the arcade works?Imissedsomething, just not sure where.

in the vBadvanced navbar template if it has one, it should be

Code:

$vboptions[bburl]/arcade.php?$session[sessionurl]

If that doesn't work, hard code the address.

or maybe use

Code:

$vboptions/forums/arcade.php?$session[sessionurl]

neocorteqz

03-01-2005 03:06 AM

Quote:

Originally Posted by venomx

I tried to add this to the memberinfo template so it only shows if they have an award. It doesnt work. Any ideas?

Code:

<if condition="$userinfo[arcadeawards]">

<tr>

<td>

<strong>Arcade Awards</strong>:<br /> 

$arcadeawards

</td>

</tr>

</if>

that template may not be global.

neocorteqz

03-01-2005 03:07 AM

Quote:

Originally Posted by MicroLinux?

At this link:

Code:

http://forums.m-linux.net/arcade.php?do=scores&name=ablast

I get this error:

Code:

Database error in vBulletin 3.0.7:



Invalid SQL: SELECT gamesessions.*, user.username FROM gamesessions AS gamesessions

                                                        LEFTJOINuserASuser ON user.userid=gamesessions.userid

                                                        WHEREgamesessions.valid=1ANDgamesessions.sessiontype=1ANDgamesessions.gamename='ablast'

                                                        ORDERBYscore

                                                        DESCLIMIT-10,10

mysql error: You have an error in your SQL syntax; checkthemanualthatcorresponds to your MySQL server version for the rightsyntaxtousenear '-10, 10' at line 5



mysql error number: 1064



Date: Monday 28th of February 2005 12:29:26 PM

Script: http://forums.m-linux.net/arcade.php?do=scores&name=ablast

I believe you need to drop the -10 in that query, as for how. I'm not sure.

Basscat

03-01-2005 01:15 PM

Quote:

Originally Posted by neocorteqz

in the vBadvanced navbar template if it has one, it should be

Code:

$vboptions[bburl]/arcade.php?$session[sessionurl]

If that doesn't work, hard code the address.

or maybe use

Code:

$vboptions/forums/arcade.php?$session[sessionurl]

I have not been able to find a vbadvanced template:( to modify. I searched and searched before I made the post. I know that is where it needs to be changed, but I can not find it. If I change it in the navbar template, the arcade works on the home(portal) page, but does not work on the forum index page.

Nick0r

03-01-2005 06:53 PM

does anyone know if it's possible (and if so how) you can copy all your games and the sql info from one forum to another, keeping the same games, but blanking all the high scores etc. This saves me reinstalling 800 games onto my new forums.

womensden

03-02-2005 03:07 PM

Not sure if this has been discussed, but I dont want to weed through 218+ pages of posts to find out.

How can I show more games on the arcade index? I only show like 10 games and I would like to show more.

Harry72

03-02-2005 03:12 PM

u can do this in arcade.php

In arcade.php look out for

Code:

$perpage = 10;

Delete 10 and enter 15 or 20 and so on. Just how u like it. :nervous:

womensden

03-02-2005 04:00 PM

thanks!

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

Page 326 of 457

326

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05183 seconds Memory Usage 1,754KB 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 (10)bbcode_code_printable (4)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: