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:

[Dejavu]

Originally Posted by dstruct2k

I don't think the installer made my gamesessions table.

Database error in vBulletin 3.0.0:
 
Invalid SQL: 
		SELECT COUNT(*) AS plays, SUM(finish-start) as time
		FROM gamesessions
		WHERE valid=1
 
mysql error: Table 'db87385808.gamesessions' doesn't exist
 
mysql error number: 1146

That doesn't look right though... "db87385808" is my database, not a table name...


[edit]Checked in phpmyadmin... the table is "vb3__gamesessions" so something's not working right.

[edit 2]Found the bug in arcade.php.... Most of you aren't using table prefixes, otherwise you'd have this bug too.
FIX:
Find:

$stats = $DB_site->query_first("
SELECT COUNT(*) AS plays, SUM(finish-start) as time
FROM gamesessions
WHERE valid=1
");

Replace with:

$stats = $DB_site->query_first("
SELECT COUNT(*) AS plays, SUM(finish-start) as time
FROM " . TABLE_PREFIX . "gamesessions
WHERE valid=1
");

I found the same problem with the mini-stats addon included with the release, didn't have a clue what was going on until i opened the file, and sure enough it didn't have the TABLE_PREFIX or whatever it is in its place

[JamesFrost]

John,

you mentioned previously a new version slated to appear after Gold came out. Do you have a current timescale and features list of what will be in it?

[John]

Originally Posted by JamesFrost

John,

you mentioned previously a new version slated to appear after Gold came out. Do you have a current timescale and features list of what will be in it?

Check the "Site Survey" thread on v3arcade.com

[maverick1236]

is there a way to manually or automatically delete all high scores weekly?

i have one user hogging all the trophies-and it discourages everyone else...

[Okiewan]

Originally Posted by maverick1236

is there a way to manually or automatically delete all high scores weekly?

i have one user hogging all the trophies-and it discourages everyone else...

In the admin cp.

[jamie]

Originally Posted by Giveit2u43

I'll be releasing the hack to do this next week once I have time to actually work out all the changes I made

cool, sounds good

[Oblivion Knight]

Any word on when the HTL release is coming?

Congrats on v3 Arcade's success John

[John]

Kura should be working on it, apparently. (The HTL installer.)

[Oblivion Knight]

I believe Kura has a few personal problems at the moment, so it could be quite a wait..

For now, if anyone wants to add the Arcade AdminCP options to the Hack Menu, they can do this:

In admincp/index.php, find the 2nd instance of:

		build_hacknavs();

Add below:

	construct_nav_option("General Settings", 'arcadeadmin.php?do=general', '<br />');
	construct_nav_option("Game Settings", 'arcadeadmin.php?do=games', '<br />');
	construct_nav_option("Score Settings", 'arcadeadmin.php?do=scores', '<br />');
	construct_nav_option("Challenges", 'arcadeadmin.php?do=challenges', '<br />');
	construct_nav_group("Arcade", '<hr />');

All done

[SK]

Im having a problem where Latest Arcade Score isnt showing?

[BarHopper]

I've got my Arcade finally working. But, its added the templates, to one of my styles. But not the other two. What do you suggest? As i dont fancy copying them all over by hand really.

EDIT: Fixed it, i had to change the other styles to default, then run the install.

[ConqSoft]

Originally Posted by BarHopper

I've got my Arcade finally working. But, its added the templates, to one of my styles. But not the other two. What do you suggest? As i dont fancy copying them all over by hand really.

Set your default style to your main Parent Style, then run the installer. Then the templates will trickle down to all Child styles.

[BarHopper]

^ lol. Just edited my post. Thanks though

[BarHopper]

<a href="http://www.game-realms.net/vb/member.php?userid=8" target="_blank">http://www.game-realms.net/vb/member.php?userid=8</a>

Seems, i've made an error in the file edit. How do i fix this? I'm no good at coding

[ConqSoft]

Originally Posted by BarHopper

http://www.game-realms.net/vb/member.php?userid=8

Seems, i've made an error in the file edit. How do i fix this? I'm no good at coding

Just go back through and carefully check all the changes you made...