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:

[Bumblefeet]

Im having trouble with it (v3 arcade). It works fine but none of the posts ae showing up. I get this error:

Parse error: parse error, unexpected $ in /home/bumblefe/public_html/v3/includes/functions_showthread.php on line 736

Now I have checked that line numerous times; there is no '$' anywhere there.
A few lines above, a $ is displayed though.

Any help is greatly welcomed!

**EDiT**
I fixed it..
Took the original and redid it.

[Reverend]

Originally Posted by nintendo

To kill the arcade using phpMyAdmin...

MAKE A BACK-UP FIRST!!!

DELETE FROM `datastore` WHERE `title` = `arcadesettings` LIMIT 1,
ALTER TABLE `user` DROP `arcadesettings`,
ALTER TABLE `usergroup` DROP `arcadepermissions`,
DROP TABLE `games`,
DROP TABLE `gamechallenges`,
DROP TABLE `gamesessions`,
DROP TABLE `gamenews`
DELETE FROM `datastore` WHERE `title` = `arcadesettings` LIMIT 1,
DELETE FROM `datastore` WHERE `title` = `scoresettings` LIMIT 1,

Anyone ??

#1064 - 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 '

[Marco van Herwaarden]

Originally Posted by Reverend

Anyone ??

#1064 - 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 '

Replace the comma (,) on the end of each line by a semicolon (. Just remove all the backticks (`).
Then run each line seperate using your favourite SQL Software.

[Marco van Herwaarden]

[sql]DELETE FROM datastore WHERE title = 'arcadesettings' LIMIT 1;
ALTER TABLE user DROP arcadesettings;
ALTER TABLE usergroup DROP arcadepermissions;
DROP TABLE games;
DROP TABLE gamechallenges;
DROP TABLE gamesessions;
DROP TABLE gamenews;
DELETE FROM datastore WHERE title = 'arcadesettings' LIMIT 1;
DELETE FROM datastore WHERE title = 'scoresettings' LIMIT 1;[/sql]

[Reverend]

Originally Posted by MarcoH64

[sql]DELETE FROM datastore WHERE title = 'arcadesettings' LIMIT 1;
ALTER TABLE user DROP arcadesettings;
ALTER TABLE usergroup DROP arcadepermissions;
DROP TABLE games;
DROP TABLE gamechallenges;
DROP TABLE gamesessions;
DROP TABLE gamenews;
DELETE FROM datastore WHERE title = 'arcadesettings' LIMIT 1;
DELETE FROM datastore WHERE title = 'scoresettings' LIMIT 1;[/sql]

Thanks.

[Jock_33]

I have a slight problem with Arcade.

I have it installed and works ok apart from it doesn't keep/update the scores. All scores stay @ zero.

Please help... thanks in advance

[Brandon Sheley]

Originally Posted by MissKalunji

it says it in the install read me :ermm:

you add the install php game file into your admincp the games games and the pictures into images/arcades...

then type www.domain.com/forum/admincp/gamefile.php

n install

i do not see this gamefile.php file ? also i didn't see it in the install read me :ermm:

[hugh_]

Could someone tell me how to replace the postbit icon and text for game champions with just text? Also how do I remove the search box addition to the navbar?

Thanks, top hack!

hugh

[Brandon Sheley]

Originally Posted by Oblivion Knight

The same as you would any other game..

Upload the .swf files to your /games directory.
Upload the .gif files to your /images/arcade directory.
Upload the .game.php file to your /admincp directory.

Then run the .game.php file in your browser via http://www.yoursite.com/forums/admincp/x.game.php, replacing x with the gamename. For example: pacman.game.php

Thnak u so much for this, i searched alot of threads looking for the answer i guess i misunderstood in the others :banana:

[lowcarbscoop]

I just installed a new theme and re-ran the first step of the install over again and ARCADE is not showing on the navbar. Can someone help me add this? I tried adding the code manually to the navbar template, but when I do, it shows an ARCADE link but when you click it, you just get a blank page.

TIA

[Mayers]

Okay it seem that after upgrading to 3.0.7 the arcade gives a no have permission message. I've edited all the files, what could be wrong with it?

[jamiepryer@hotm]

my arcade has stopped working
when i go to the admin CP and click yes for "is the arcade active"
it says settings have been saved, but when i get reverted back, its all been set back to "no"

thanks in advance

[jamiepryer@hotm]

fixed it now

[Jenta]

is there a list somewhere of which games are ok to use?
don't want to violate any copyrights

[rjordan]

v3arcade deleted user avatar fix(?)

After you delete a user, I have found that if you (or more importantly, a search spider) tries to access the stats link for that deleted user, you likely will get something like 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

There does not seem to be a check built-in to see if a user is actually a valid user. I have hopefully found a fix for this with the following:

Find:

PHP Code:

 $activitycount = $DB_site->query("
         SELECT gamesessions.*, games.title FROM " . TABLE_PREFIX . "gamesessions AS gamesessions
         LEFT JOIN " . TABLE_PREFIX . "games AS games ON gamesessions.gamename = games.shortname
         WHERE userid=$userid AND valid=1 AND $sessionclause GROUP BY sessionid ORDER BY finish DESC"); 


and above this add:

PHP Code:

 if ($user['username']=="") {
$idname = $vbphrase['user'];
eval(print_standard_error('error_invalidid'));
} 


I suspect that the scores for the deleted user might still be there after the user is deleted. If this is correct and vBulletin allows someone else to get this user ID, they might by default get all of the high scores for the games by the previous ID owner. Looking into that.

EDIT: It looks like vB does not recycle user IDs. This SHOULD work to eliminate the error.