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:

[AutomatikStudio]

EDIT: I see the problem...I removed some users who had the high score on the particular game and it's screwing things up...just gotta remove their high scores and we'll be good to go.

[Beermonster]

I havn't read the whole thread, it's too big but how would I put some stats on the home page, or who's playing what etc

[Kamex]

Could someone please help me with the problem I mentioned earlier? I got more data on it, and apparently, the user DramaQueen, played simon and got a score of 7. This was nowhere near the incredibly high score that SoftBallRawkStar already had (36), and yet the championship is now appearing for DramaQueen in the postbit, and in the arcade profile. It still shows SoftBallRawkStar as the champion in the high scores list. I really badly need to fix this because SoftBallRawkStar is very proud of her high score and feels it is very injust that DramaQueen holds the championship for it.

I have a theory on what's going on here. Perhaps no one expected anybody to get a score that high on simon. Maybe although it still shows up as 36, internally, it started at zero again at 30. This would make the internal score that determines the championships 6, which is one less than DramaQueen's 7. Is this possible?

[Dark Dragon]

I installed this hack a while back and it was working fine. I haven't touched it, and today now I get this error:

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM gamesessions AS gamesessions
LEFT JOIN user AS user ON user.userid = gamesessions.userid
LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
WHERE (gamename='alienattack' AND score='138') OR (gamename='aliens' AND score='39665') OR (gamename='asteroids' AND score='24470') OR (gamename='bloodypingu' AND score='1160') OR (gamename='breakout' AND score='17380') OR (gamename='chopper' AND score='3075') OR (gamename='copter' AND score='2017') OR (gamename='curveball' AND score='25345') OR (gamename='discoracer' AND score='10250') OR (gamename='flashpoker' AND score='4294967295') OR (gamename='funkypong' AND score='11') OR (gamename='hexxagon' AND score='38') OR (gamename='joust' AND score='4200') OR (gamename='kickups' AND score='212') OR (gamename='killkenny' AND score='64400') OR (gamename='maeda' AND score='9190') OR (gamename='marsrover' AND score='1372') OR (gamename='mcsnake' AND score='88') OR (gamename='minikickups' AND score='126') OR (gamename='monkeylander' AND score='21295') OR (gamename='pacman' AND score='25660') OR (gamename='penguin' AND score='3235') OR (gamename='pinguslap' AND score='640') OR (gamename='radialsnake' AND score='118') OR (gamename='ronnorthjewels' AND score='54050') OR (gamename='simon' AND score='20') OR (gamename='snake' AND score='2571') OR (gamename='spaceinvaders' AND score='24320') OR (gamename='target' AND score='2700') OR (gamename='tetris' AND score='94661') OR (gamename='towerball' AND score='12910') AND sessiontype=1 ORDER BY gamesessions.gamename DESC

mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Tuesday 23rd of March 2004 03:11:26 PM
Script: http://www.tmrforums.com/arcade.php?

Can somebody please help me get this fixed?

[John]

Dark Dragon, that's a damaged database error IIRC. Check the status of your database tables?

[Dark Dragon]

Table Op Msg_type Msg_text
tmrforum_TMRmySQL.gamechallenges check status OK
tmrforum_TMRmySQL.gamenews check status OK
tmrforum_TMRmySQL.games check status OK
tmrforum_TMRmySQL.gamesessions check status OK
tmrforum_TMRmySQL.user check status OK

They seem to be okay.

[Hurricane]

Originally Posted by Ogmuk

I've tested this locally and it worked then when changing my live forums I think I uploaded each file that needed to be edited but after playing a game it won't submit the score so right now it says "score 0" at each game. Any idea what I did wrong? Sorry if this has been answered. A search didn't come with anything useful.

Uploaded 47 files and only manually made another edit to functions.php to make vbadvanced work (only difference between the test and live forum), made the changes to templates, etc.

I have the same problem. I have double checked my work, but still no fix. Does anyone have any ideas? This worked fine on my test BB and it is the only hack installed.

[corsacrazy]

yetti sports seal bounce john is that avaibale for editing? as u have the 1st two

[John]

Originally Posted by Dark Dragon

Table Op Msg_type Msg_text
tmrforum_TMRmySQL.gamechallenges check status OK
tmrforum_TMRmySQL.gamenews check status OK
tmrforum_TMRmySQL.games check status OK
tmrforum_TMRmySQL.gamesessions check status OK
tmrforum_TMRmySQL.user check status OK

They seem to be okay.

http://www.threadsdev.com/forum/show...p/Number/94361

[Ogmuk]

Originally Posted by Hurricane

I have the same problem. I have double checked my work, but still no fix. Does anyone have any ideas? This worked fine on my test BB and it is the only hack installed.

If you ever find a fix I'd love to know it since it's lacking an uninstall option and the arcade is quite useless at it is right now.