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:

[jrofosho]

I've searched this forum, and gone back over the code multiple times. I still get this error after installation.

Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 2997

The arcade link is on the menu, but it leads to an error.

[pk698]

will this work for 3.0.7?

[Oblivion Knight]

Originally Posted by jrofosho

I've searched this forum, and gone back over the code multiple times. I still get this error after installation.



The arcade link is on the menu, but it leads to an error.

Make sure that you have modified your includes/init.php file correctly.

Originally Posted by pk698

will this work for 3.0.7?

Yes, it works fine with 3.0.7

[SpaceStar]

Waaao excellent hack - installed on my forum. Although installation went without any error and three out of five games can start, Tetris and Snake are not working. Tetris came to point where it load, LOADING...... hangs, and Snake just shows a black square.... (other games are working fine)

Do anyone have any clue????

Thanks in advance

[jrofosho]

okay. Thanks Oblivion. It was the init.

Now the images aren't being directed to the correct path. they are going to jrofosho.com/imageexample.gif

they should go to jrofosho.com/forum/images/

[dwillb]

Hey everybody. I have something of an odd problem. I just upgraded my forum to 3.0.7 and reinstalled the arcade hack. I have only one problem. When you click on any of the games in the arcade menu, you get an incorrect link. With Tetris, for example, you get this link:
index.php?act=Arcade&do=play&gameid=4

Instead of this:
arcade.php?act=Arcade&do=play&gameid=4

I'm not sure where the problem lies - I've checked over the installation steps and it appears as if I've done everything correctly. I did this with both 3.0.5 and 3.0.6 and it worked fine, so I'm pretty sure I'm not making any really stupid mistakes. Or maybe I am. Any ideas?

[Roxie]

Originally Posted by Mijae

Wanted games? Here they are!

Now you can get games for FREE from my site, no registration and NO FEES to pay.

Just go to http://www.anotherforum.net/files/v3games and download :)
Now, don't go around spreading the URL or my bandwidth will go to hell ;)

I know that probably not all games are there, but its still a lot of 'em :P

If you have zip files with games that are not here, and want to help the community by sharing them, PM me.

for those that missed it.

[Oblivion Knight]

Originally Posted by jrofosho

okay. Thanks Oblivion. It was the init.

Now the images aren't being directed to the correct path. they are going to jrofosho.com/imageexample.gif

they should go to jrofosho.com/forum/images/

No problem.!

Re-edit your includes/functions.php file.. Make sure the path to the arcade images is set correctly.

Originally Posted by dwillb

Hey everybody. I have something of an odd problem. I just upgraded my forum to 3.0.7 and reinstalled the arcade hack. I have only one problem. When you click on any of the games in the arcade menu, you get an incorrect link. With Tetris, for example, you get this link:
index.php?act=Arcade&do=play&gameid=4

Instead of this:
arcade.php?act=Arcade&do=play&gameid=4

I'm not sure where the problem lies - I've checked over the installation steps and it appears as if I've done everything correctly. I did this with both 3.0.5 and 3.0.6 and it worked fine, so I'm pretty sure I'm not making any really stupid mistakes. Or maybe I am. Any ideas?

Looks like you're trying to install ibProArcade to me.. Wrong thread bud.!

[Wachtmeister]

OMG, i hope, that someone finds my post (237 pages...)

I have the arcade with 300+ games installed on vb 3.0.1

I've upgraded vb to 3.0.7 today and the arcade did not work after upgrade.

How can i get the arcade to run with all games again?

Do i need to reinstall the arcade? (will the currently installed games still be there, after installing?)

I do have to edit all the files after each upgrade right? (so if vb 3.0.8 is out, i have to re-edit the files again?)

Has someone successful upgraded from 3.0.1 to 3.0.7 with transferring his arcade?

Some help would be very fine.

Regards, Wachtmeister

[rjordan]

Originally Posted by Wachtmeister

OMG, i hope, that someone finds my post (237 pages...)

I have the arcade with 300+ games installed on vb 3.0.1

I've upgraded vb to 3.0.7 today and the arcade did not work after upgrade.

How can i get the arcade to run with all games again?

Do i need to reinstall the arcade? (will the currently installed games still be there, after installing?)

I do have to edit all the files after each upgrade right? (so if vb 3.0.8 is out, i have to re-edit the files again?)

Has someone successful upgraded from 3.0.1 to 3.0.7 with transferring his arcade?

Some help would be very fine.

Regards, Wachtmeister

Yes, you will have to reinstall just as you would most other hacks.

[Wachtmeister]

Originally Posted by rjordan

Yes, you will have to reinstall just as you would most other hacks.

and my currently installed games?

[rjordan]

They will remain as will all scores, play counters, etc.

Only do the file edits, though.

[Brandon Sheley]

i ran into the blank page problem, but i had made a test site, and just added each arcade_ template,, acording to the isntall it did instlal them, but in the styles& templates, they didn't show up ?? any ideas why that happen ? i've isntalled this ona few skins and a few test sites and never ran into this problem,, and looking though this thread i seen other ppl withthat problem, anyways, to fix it i just added each templates manually, and all works great,, maybe you can include a file that a user who runsinto this can look at to transfer the templete files over,,hope soem of this makes sinse, its getting alittle late for me, and i've had a few drinks :-"..lol anyways thx for the mods, its awsome and the add-ons are sweet

[illusions]

How do i install new games? .. where would i place the game php file?

[YLP1]

Originally Posted by 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.

I applied the fix for this error but this is the error my arcade.php returns:

PHP Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in 
myISP\LPSForum\arcade.php on line 1664

I need this fix because this is the error that my members are getting:


This one:

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 =

and This one:

Invalid SQL: 
SELECT gamesessions.*,user.username FROM vb3_gamesessions AS gamesessions
LEFT JOIN vb3_user AS user ON gamesessions.userid = user.userid
WHERE vb3_gamesessions.valid=1 AND gamesessions.sessiontype IN (1,2) ORDER BY gamesessions.finish DESC LIMIT 0,1

mysql error: Unknown table 'vb3_gamesessions' in where clause

mysql error number: 1109

I am fairly new to PHP and VB and am quite lost on how to fix these two errors.

Any help is greatly appreicated.
Robin