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)

morby 05-31-2005 06:41 PM

oops, i figured it out.
my ftp did a boo boo.

everything is fine now !

lifesbattles 05-31-2005 10:26 PM

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(*) + 1 AS position
FROM gamesessions AS gamesessions
WHERE score > AND valid=1 AND gamesessions.gamename=''

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND valid=1 AND gamesessions.gamename=''' at line 3

mysql error number: 1064

Date: Tuesday 31st of May 2005 07:10:04 PM
Script: http://www.lifesbattles.com/forums/arcade.php
Referer: http://www.lifesbattles.com/forums/a...play&gameid=16

- Show quoted text -


ANY IDEAS?

Exitilus 06-02-2005 03:37 AM

Quote:

Originally Posted by Exitilus
I've been looking through this thread for hours. Basically my scores are not submitting. Once you hit submit nothing happens. If it auto-submits it just stays on the game screen. If you exit out. You have a score of 0.

This is a fresh install on my test site.

Anyone?

dsboyce8624 06-02-2005 03:16 PM

I'm looking for the add on that puts multiple colums of games on each page.

Anybody know where it is?

Thanks.

YLP1 06-03-2005 02:52 AM

Quote:

Originally Posted by YLP1
SimonHodgkis, I have an error very similar to yours which I can't fix. I wonder if these are related.

Code:

Database error in vBulletin 3.0.7:
 
Invalid SQL:
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
FROM vb3_user AS user
LEFT JOIN vb3_avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN vb3_customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid =
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5
 
mysql error number: 1064

Any advise on fixing this is greatly appreciated it's been driving me nuts for over a week now.

Hi RJordon.....I got the other error fixed but this one is still hanging around and is intermittent.

I have tried all of the code mods over again and still can't get rid of this.

Any ideas?

rjordan 06-03-2005 09:41 AM

I am not sure. What I gave to you to fix this problem fixed the exact same problem on my site. I will try to look more, but I do not know what else to give you at this point.

Wachtmeister 06-03-2005 04:11 PM

Hello,

some of my users cannot challenge anymore and some scores where not set to 0, when resetting the scores last month. (as described here: http://www.v3arcadegames.com/forums/...ead.php?p=3648)

Does someone has an idea, what went wrong and what can be the problem, that some users cannot challenge anymore? Does anyone know the sql command to reset all scores to 0 and does anyone how to reset all other relevant tables in the user record?

Best wishes, Wachtmeister

jesus likes pie 06-03-2005 05:24 PM

mmmm....i have a bunch of swf games but how do i add them other than uploading them to the games folder?

dsboyce8624 06-03-2005 06:40 PM

<a href="https://vborg.vbsupport.ru/showthread.php?t=60666&highlight=v3arcade" target="_blank">https://vborg.vbsupport.ru/showt...light=v3arcade</a>

:Judge: 06-04-2005 06:22 AM

Okay I have searched through the whole thread and only people I see with an issue anything like mine was using Dreamweaver, I am not and have not used anything other then wordpad to get this error at the top of my pages.....
Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3006

Also now when I try to access a forum I get this..
Unable to add cookies, header already sent.
File: /home/******/public_html/forums/includes/init.php
Line: 27


I went and uploaded the files as they was before I started and I am still getting these errors after so. The site is down I have no clue as to what happened or how to fix it. Could someone please give me some type of diriction please.

Marco van Herwaarden 06-04-2005 07:06 AM

Use notepad or a decent editor instead of wordpad.

:Judge: 06-04-2005 04:00 PM

Quote:

Originally Posted by :Judge:
Okay I have searched through the whole thread and only people I see with an issue anything like mine was using Dreamweaver, I am not and have not used anything other then wordpad to get this error at the top of my pages.....
Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3006

Also now when I try to access a forum I get this..
Unable to add cookies, header already sent.
File: /home/******/public_html/forums/includes/init.php
Line: 27


I went and uploaded the files as they was before I started and I am still getting these errors after so. The site is down I have no clue as to what happened or how to fix it. Could someone please give me some type of diriction please.

Again I had these errors mentioned above after the file edits W/WordPad, I reuploaded the files as they was before the edits and the errors stayed.

Today I just went back in and edited the files again with NotePad and I have the same exact errors still, nothing changed. I would think that I must have removed something a comma who knows but I am not understanding why after I uploaded the files as they was before I started the Aracde mods I get the same errors.

Today is my kids birthday party and I really would like to have this corrected ASAP. Willing to pay a fee for the Tech help here on this issue so that we can have our community back up and running again.
Link to Paid Request here:
https://vborg.vbsupport.ru/showthrea...188#post662188

sabret00the 06-04-2005 07:59 PM

Quote:

Originally Posted by :Judge:
Again I had these errors mentioned above after the file edits W/WordPad, I reuploaded the files as they was before the edits and the errors stayed.

Today I just went back in and edited the files again with NotePad and I have the same exact errors still, nothing changed. I would think that I must have removed something a comma who knows but I am not understanding why after I uploaded the files as they was before I started the Aracde mods I get the same errors.

Today is my kids birthday party and I really would like to have this corrected ASAP. Willing to pay a fee for the Tech help here on this issue so that we can have our community back up and running again.
Link to Paid Request here:
https://vborg.vbsupport.ru/showthrea...188#post662188

Dreamweaver ++++s up your functions.php you have to rehack that file from scratch reinstalling all your hacks again.

bainsy 06-07-2005 08:35 PM

Quote:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(*) AS plays, SUM(finish-start) as time
FROM gamesessions
WHERE valid=1

mysql error: Table 'bainsy_vbul1.gamesessions' doesn't exist

mysql error number: 1146

Date: Tuesday 07th of June 2005 04:34:17 PM
Script: http://www.psofantasy.co.uk/forum/arcade.php?
Referer: http://www.psofantasy.co.uk/forum/
i am getting a databse problem and dont have a clue how to sort out

Mijae 06-09-2005 02:42 AM

I am getting this:

Code:

Database error in vBulletin 3.0.7:

Invalid SQL:
                SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS
hascustom, customavatar.dateline
                FROM user AS user
                LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
                LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
                WHERE user.userid =
mysql error: You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at line
5

mysql error number: 1064

Date: Wednesday 08th of June 2005 11:33:59 PM
Script: http://xxx/forum/arcade.php?do=stats&userid=7482
Referer:

I have no idea whats wrong?

Gary King 06-10-2005 11:46 PM

Let's see a 3.5 port for this :)

MissKalunji 06-11-2005 12:41 AM

Quote:

Originally Posted by Gary King
Let's see a 3.5 port for this :)

it came out already?

venomx 06-11-2005 12:47 AM

Yeah Beta 1

John 06-11-2005 12:47 AM

Quote:

Originally Posted by Gary King
Let's see a 3.5 port for this :)

I'm on it now. :)

iSpanish 06-11-2005 06:28 AM

Welcome Back John

it's nice to see you again

Xtremist 06-11-2005 11:17 AM

I have installed the v3 Arcade v1[1].0.3 MOD and having some problems.

my problem is that i have 2 templates on the forum the default style and another style i installed the arcade works fine on the vb default style but on my other style when i click the arcade link it takes me to the arcade.php file but its just a blank white page

i have done all the template edits and rum the install file it works fine on the default vb template but on my style called applied it just white screens it.?

KTBleeding 06-11-2005 01:26 PM

Quote:

Originally Posted by Xtremist
I have installed the v3 Arcade v1[1].0.3 MOD and having some problems.

my problem is that i have 2 templates on the forum the default style and another style i installed the arcade works fine on the vb default style but on my other style when i click the arcade link it takes me to the arcade.php file but its just a blank white page

i have done all the template edits and rum the install file it works fine on the default vb template but on my style called applied it just white screens it.?

You have to do the template modifications for each style on your forums.

Mijae 06-11-2005 09:03 PM

How can I remove all scores from people I have deleted? I just deleted around 5000 members and I am being mailbombed with database errors :(

MissKalunji 06-12-2005 03:03 AM

Quote:

Originally Posted by Mijae
How can I remove all scores from people I have deleted? I just deleted around 5000 members and I am being mailbombed with database errors :(


there is a hack wich you can delete the game reinstal it and you start from fresh for that game that is.....

bainsy 06-12-2005 11:51 AM

Quote:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(*) AS plays, SUM(finish-start) as time
FROM gamesessions
WHERE valid=1

mysql error: Table 'bainsy_vbul1.gamesessions' doesn't exist

mysql error number: 1146
How do I solve this database problem it says it doesnt excist but it does.

Marco van Herwaarden 06-12-2005 03:07 PM

If it say that it doesn't exist, then it doesn't exist. How you verified it exists?

dsboyce8624 06-12-2005 03:08 PM

Quote:

Originally Posted by bainsy
How do I solve this database problem it says it doesnt excist but it does.

Are you sure the prefix is right?

PowowVN 06-12-2005 03:17 PM

I install vbb3.0.7 and arcade in my site. I login with administrator account and members but When I click link http://mydomain.com/forum/arcade.php -> appear error:

Quote:

Powow, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation
Please tell me - How to fix it?

Skaterscafe.com 06-12-2005 05:41 PM

I have the same problem. I had the problem before and reinstalled it and that did the trick, this time I can't get it to go away.

I'm also open for suggestions.

KTBleeding 06-12-2005 08:16 PM

Set the permissions in the admincp.

bainsy 06-12-2005 08:42 PM

Quote:

Originally Posted by MarcoH64
If it say that it doesn't exist, then it doesn't exist. How you verified it exists?

I know because it appears in the database table as vbul1_gamesessions

Marco van Herwaarden 06-13-2005 05:07 AM

Then the table gamesessions does not exist, but the table vbul1_gamesessions does exist. There must be missing a table prefix in the source. I think the answer will already be somewhere in this thread.

PowowVN 06-13-2005 09:29 AM

I have create 2 tables same structure is gamesessions and vbb_gamesessions but still apear error above

Why's 2 tables empty?

Can you help me find the answer for this question?

Marco van Herwaarden 06-13-2005 10:17 AM

Please post the full error message including the scriptname that generates the error.

d19113 06-13-2005 10:26 AM

Just installed last night. Nice hack. Thx.

Niceboy 06-13-2005 12:31 PM

Quote:

Originally Posted by d19113
Just installed last night. Nice hack. Thx.

Just read that he come back and know i'am Removing IBproArcade and installing v3arcade:D

Mijae 06-13-2005 01:33 PM

I've reuploaded all my files, and cleared all scores from the database, and now I get cron update errors!

Code:

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE games SET highscorerid=,highscore=512 WHERE shortname='sobersanta'
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'highscore=512 WHERE shortname='sobersanta'' at line 1

mysql error number: 1064

Date: Monday 13th of June 2005 10:29:16 AM
Script: http://xxx/forum/admincp/cronadmin.php?do=runcron&cronid=13
Referer: http://xxx/forum/admincp/index.php?
Username: Mijae
IP Address: xx


tidy_boy 06-13-2005 03:50 PM

Hey guys great job with the arcade but how can I get it to do this please

I know that the forum in the link is a phpbb and not a vbulletin but I would really like to have my arcade show up like this on the forum home page.


http://www.4clubbers.net/modules.php?name=Forums


Andy ideas on how to do this :lick:

Marco van Herwaarden 06-13-2005 06:15 PM

Sorry this hack integrates with vB, not phpBB. Maybe you can ask at phpBB forums if a version for phpBB exist.

tidy_boy 06-13-2005 06:27 PM

Quote:

Originally Posted by MarcoH64
Sorry this hack integrates with vB, not phpBB. Maybe you can ask at phpBB forums if a version for phpBB exist.


Yeah I know that this hack is for vbulletin I have installed it on mine

What I want is the arcade section on the forum homepage like the link I provided.

http://www.4clubbers.net/modules.php?name=Forums

Is there a hack for this for vbulletin


All times are GMT. The time now is 10:53 AM.

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.05246 seconds
  • Memory Usage 1,841KB
  • 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
  • (15)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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