v3 Arcade - Games Arcade & Challenge System [vB 3.0.3]

v3 Arcade [3.0.3]
Games Arcade for vB3
Game copyrights belong to their respective owners.
v3 Arcade - Copyright ?2004 John Warwick, All Rights Reserved.
__________________________________
Arcade Verson: 1.0
vB Version: vBulletin 3.0.3
Author: John Warwick
Email: John[at]eovieinteractive.com
Site: www.v3arcade.com
??????????????????????????????????

Updates
==========================
1.0.0 - Initial release

1.0.1 - Bug fix update
? This release addressed a couple of small bugs. Information on fixing
these issues can be found in the FAQ. (Included in this zip.)

1.0.2 - Bug fixes and new features
? This release makes all games on the Arcade main page appear in the
order which they were installed, regardless of whether or not it has
been played. (With the newest games at the top.)
? It includes a
page navigation system, allowing users to browse games by page. By default, 10 games appear per page.
? There is also a new search feature, for finding games by name/description. (Accessible through the "Search" menu in the navigation bar.)
? This release should be less CPU intensive than previous versions.

1.0.3 - Bug fixes
? Security fixes

History & Hack Information
- So, what is the v3 Arcade?
The v3 Arcade is exactly what the name implies - an online games arcade that offers seamless integration with your vBulletin forum.

The v3 Arcade is the first of the new generation of vBulletin additions. Back from its roots, the v3 Arcade is the vBulletin 3 edition of my original Arcade written in late 2002 (not to be confused with futureal's 'ProArcade', which was written during the Arcade's beta phase).

v3 Arcade Features Include:
? Integrated Flash gaming for vBulletin 3
? Advanced leader board system
? FULL Mozilla/Netscape Compatibility
? Moderation abilities for Mods/Super Mods/Admins
? PM & Email notification for events
? Advanced statistics for all users
? A higher level of security
? "Arcade Challenges", 1-on-1 contests between users
? Arcade awards system
? Automated and manual score pruning tools

This installation comes loaded with the following games:
? Tetris
? Snake
? Asteroids
? Chopper Challenge
? Space Invaders

If you have the source (.FLA) for a game that you want to use in the v3 Arcade, you can send the required files to john@v3arcade.com for conversion. (Providing permission has been given by the original author.) Within a reasonable delay, I'll post the converted game and installation script on vBulletin.org.


Testing
Tested on vBulletin 3.0.3, across multiple unhacked installations.


Thanks to...
? Kura: For helping out with vB3 difficulties!
? Erwin: Whose vB2 Flash Player inspired the original hacks
? Paul Neave: For providing the source for 4 of the standard v3 Arcade games


IMPORTANT NOTES
? If you do install this hack, please click on the INSTALL button. There are going to be some updates for this which you're really not going to want to miss!
? Each Arcade page has an Eovie Interactive and Flash Player link at the bottom. This is optional, but greatly appreciated.
? You may have noticed that this release of the v3 Arcade is not fully phrased. To phrase the arcade would require well over a hundred phrases to be added, making for a lengthy installation process! Futures version of the v3 Arcade will be phrased, with a more automated installation.
? And don't forget - BACKUP BEFORE YOU INSTALL!


Regarding the "ProArcade"
There has been a lot of debate on vb.org recently about the ownership of hack "concepts". My original Arcade hack (on which the v3 Arcade is based), was a progression of the my vBTetris Leaderboard hack - both of which came about before the ProArcade. I've spoken to Erwin regarding this, and he can confirm that this has always been an independent development; hence the v3 Arcade was authorised for release.

Fixes
If you're installing the Arcade from scratch, there are no fixes or updates to be applied. Simply follow the instructions in Installation.txt.
If you've already installed the Arcade, make the changes in Updates.txt.

[Click HERE to view a list of released games and modifications!]

Demos/Add-Ons/Beta Testing
www.v3arcade.com

Download the v3 Arcade (1.0.3) here:

[morby]

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

everything is fine now !

[lifesbattles]

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]

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]

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

Anybody know where it is?

Thanks.

[YLP1]

Originally Posted by YLP1

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

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]

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]

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]

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

[dsboyce8624]

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

[: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.

[Marco van Herwaarden]

Use notepad or a decent editor instead of wordpad.

[:Judge:]

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]

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]

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]

I am getting this:

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?