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:

[SimonHodgkiss]

Database error ???

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*, usergroup.title AS usergrouptitle,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,1,2,3,4)
ORDER BY dateline

mysql error: Unknown table 'usergroup' in field list

mysql error number: 1109

how do i fix that error ?

[owner]

Originally Posted by Intrepid

What is showing on Line 2018 of functions.php?

$debughtml .= " (<a href=\"" . htmlspecialchars_uni(SCRIPTPATH) . iif(strpos(SCRIPTPATH, '?') '?')'?')=== false, '?', '?','?','&amp;') . "tempusage=1\">Template Usage</a>) (<a href=\"" . htmlspecialchars_uni(SCRIPTPATH) . iif(strpos(SCRIPTPATH, '?') '?')'?')=== false, '?', '?','?','&amp;') . "explain=1\">Explain</a>)<br />\n";

Help plz

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

[rjordan]

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.

I thought that you said this was working now and you were seeing another problem.

[owner]

Guyz i fixed my problem .. now iam getting a blank page when i open up arcade.. help plz

[FightRice.com]

You need to update your templates

[SnowBot]

Hi guys, strange problem i hope you can help me with.

I just did a prune of all scores as i have not done it for months and now i am getting a MYsqll error

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT username FROM user WHERE 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 1

mysql error number: 1064

Date: Sunday 15th of May 2005 08:39:22 PM
Script: http://www.synergyforums.com/forum/arcade.php?
Referer: http://www.synergyforums.com/forum/?

The arcade was working fine and i have not updated any hacks or installed any new ones, all i did was prune the scores. Any help would be appreciated. Thanks

Snowy

[MissKalunji]

Originally Posted by Justdave

I followed the install instructions to a "T" and ended up with a perpetual slew of error codes specifically dealing with the now dreaded functions.php

Here's the latest beauty:


Parse error: parse error, unexpected '=', expecting ')' in /www/j/blahblahblah/htdocs/Forum/includes/functions.php on line 1627

I even went back to vB.com for another download of functions.php.

No luck. I think the gamer in me is getting a bit tired of this.


Yes, dumb me, I used Dreamweaver to edit the code. May I suggest a sticky note WARNING : Users of Dreamweaver, not to use it with any vB HACKS. How hard would this be. I did successfully add vB Chat with Dreamweaver, but that one is so easy, even a caveman can do it.

I know its not just me, but I'm beginning to think v3 Arcade is just riddled with weaknesses. I think I'd rather have a virus. At least then, typically you can just press a button to remove it.

Seriously, I'd be willing to listen to someone who has real time saving answers. I might even be willing to pay. :ermm: John, Seriously.

I just bought Namo web editor. Not user friendly at all, but also not going to automatically doctor your code.

you dont need to waiste your money on all these stuff just use note pad and read properly that would do :ermm:

[rjordan]

Crimson Editor is great to use and is free. Color codes your text and makes things a lot easier to edit than Notepad.

I know its not just me, but I'm beginning to think v3 Arcade is just riddled with weaknesses. I think I'd rather have a virus.

Nah... more likely something was missed in install or changed by your editor you did not see. Countless members installed without a problem.

[Justdave]

Mj: I'm looking for help, not criticism. Please "properly" re-read my post. Thank You.

rj: Thank You. I'm closer to resolution of this mess with your response. Should I attempt to re-install over the existing arcade program, or back track and delete all of my file edits in reverse order?