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:

[Jolten]

highscorerid=

if there is no userid there's no highscore id to set. The problem is unregistered users playing your games.

[cr95gst]

I don't see how that is happening. You have to be registered to play in the arcade and it prompts you to log-in or register if you try. I posted the "unregistered" one that was sent to me, but it seems like it is going right down the list of users in no particular order.

[Shadow Blaze]

you're so loved for this hack ^_^ *clicks the install button*

[DWard]

Can't wait for the pro version to come out!! Handles alot of games well with the cateogry mod!

[Hubsi]

i have always the problem that the score didnt write and it stoped after play a game

the "define('DEMO_MODE', true);" FIX dont work

please help me and sorry for my bad english

[Spinball]

Can I get some help on this, please?

Originally Posted by Spinball

I upgraded to the latest version of vBarcade and I need to remove the tables used in the vB2 version.
I renamed them to
delete_arcadeconfig
delete_arcadegames
delete_arcadescoregroups
delete_arcadescores
delete_arcadetopscores

but I get the occasional database error:

Any idea why?
TIA

[Blam Forumz]

To install on a different style, make that syle a child style of the dfault one, that way any changes you make to the default one will change the child styles

[Wnerd]

Originally Posted by cr95gst

All of a sudden yesterday, I started getting this email every hour for a different user:

Database error in vBulletin 3.0.0:

Invalid SQL: UPDATE games SET highscorerid=,highscore=1004 WHERE shortname='ssl'
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=1004 WHERE shortname='ssl'' at line 1

mysql error number: 1064

Date: Thursday 21st of October 2004 01:29:24 PM
Script: http://www.escic.com/vb/cron.php?&rand=695902
Referer: http://www.escic.com/vb/?
Username: Unregistered
IP Address: 152.163.100.9

Any idea how this started?

Someone might have bookmarked a game, and not have been logged in.

[Wnerd]

I keep getting this error:

Database error in vBulletin 3.0.3:

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: Sunday 24th of October 2004 04:31:37 PM
Script: http://psychoklown.com/forum/arcade.php?do=challenges
Referer: 
Username: RabidMonkey
IP Address: 67.*.*.254

I removed the 2 IP numbers so he doesnt get disturbed.

He's not the only User who gets the error. Anyone know why?

[bigmonay2k]

help..after install the arcade..the arcade working fine. BUT I got this when check out a thread/post in my forum...

Parse error: parse error, unexpected '{' in /home/games2/public_html/test/includes/functions_showthread.php on line 27

blank page
help thanks in advance guys

[Mark Vick]

hi there,
this is a great hack and I would love to get it working

I installed is as you said, I have vb 3.0.3
Running on windows 2003 server

After the install, I get no error,
In my admin cp when I click on Arcade, I get the following.

Just a blank page as per image (Untitled-1.gif)

Then when I login and click on arcade in the top links menu, I just get Untitled-3.gif)

Any help would be much appreciated

[Mark Vick]

hi there,
this is a great hack and I would love to get it working

I installed is as you said, I have vb 3.0.3
Running on windows 2003 server

After the install, I get no error,
In my admin cp when I click on Arcade, I get the following.

Just a blank page as per image (Untitled-1.gif)

Then when I login and click on arcade in the top links menu, I just get Untitled-3.gif)

Any help would be much appreciated

[ChuanSE]

Recheck your copied code

[Farox]

Some people are having the problem that the highscores aren't updated on their forums. After some candlelight debugging via email I found the fix for that:

In Arcade.php
Find:

PHP Code:

    $DB_site->query("INSERT INTO " . TABLE_PREFIX . "gamesessions (sessionid,gamename,userid,start,sessiontype,challengeid) VALUES ('','$shortname','$bbuserinfo[userid]','$gametime',$sessiontype,$challengeSQL)");
    $lastid = mysql_insert_id(); 


Replace with:

PHP Code:

    $DB_site->query("INSERT INTO " . TABLE_PREFIX . "gamesessions (sessionid,gamename,userid,start,sessiontype,challengeid) VALUES ('','$shortname','$bbuserinfo[userid]','$gametime',$sessiontype,$challengeSQL)");
    $lastid = mysql_insert_id($DB_site->link_id); 


[Mr.Haze]

I love this hack!!!

I also have the vShop installed, can anyone tell me if there is a hack/mod so that users can win vCash by getting a top score?

I'm not talking about the Arcade Pass hack, more like the oposite, so they get paid to play, rather than have to pay to play?