Add-On Releases - v3 Arcade - Games Arcade System for 3.6.0

Staff note: Requesting or posting links to sites for massive game downloads is considered posting links to Warez and is not allowed. Also see: Posting/requesting (links to) Game Downloads
=================================
v3 Arcade
for vBulletin 3.6.1
=================================

"v3 Arcade" is the third Arcade system I've written for vBulletin. It's coded from scratch, not a port of an older version - and because it was coded specifically for vBulletin 3.6 it uses the product system for code modifications, and utilizes AJAX technology throughout. Here's a brief rundown of the features in this version of v3 Arcade.

- Supports both v3 Arcade and iB games.
- Download *legal* free, premium and multiplayer games directly from v3arcade.com to your Arcade installation.
- Import script to convert your old v3 Arcade installation. (A script to import games, scores and news from old IBPro installations is available here, thanks to Tigga: http:www.v3arcade.com/forums/showthread.php?t=324)
- AJAX based instant ratings, for simple to use game ratings.
- AJAX based inline score moderation.
- AJAX based instant game searching.
- Tabbed, customizable categories.
- Challenge system for one-on-one contests.
- User-permission based settings for email/PM notification, challenge settings.
- Streamlined viewing modes for users with lower resolutions.
- AJAX based quick stats, for viewing statistics by passing the cursor over a username.
- Mass import tools for importing games in bulk.
- Reverse and decimal based scoring.
- Arcade-only closure with customizable message.
- Per game criteria, allows you to control access to games by reputation, posts, registration length.
- Postbit based awards.
- Personalized recommendations for other games users might like, based on what they?re playing.
- Quick stats, letting a user know how many other scores are above and below theirs.
- Score ranking.
- Admin customizable ?score feedback?, displays a message based on how well as user has done.
- Numerous Admin CP settings to control things like popup opacity, maximum comment length, hover delay length, and numerous other behaviors.
- Full admin control over the types of content allowed in comments (BB code, HTML, smilies, etc.)
- Usergroup based access permissions.
- Fully phrased, for each translation into other languages.
- An ever growing collection of third party add-ons, thanks to Oblivion Knight.
- A slick, professional layout.

=================================
Change Log
=================================

1.0.0 - First public release.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

1.0.1 - Bug fixes and feature release.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- More visible postbit award presence.
- Reverse scoring option added to games.
- Data dictionary implementation, makes sure the Arcade database changes are correctly made.
- Template grouping.
- "Posts in the last 24 hours" criteria added to games.

1.0.5 - Bug fixes and feature release.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Added search on/off toggle function in Admin CP.
- Opera compatibility fixed.
- Welcome message now an Admin CP option.
- Use "Miniature Mode" By Default option added to the Admin CP.
- New AJAX based favorites system.
- Hooks in place for vbBux integration (coming soon from CMX_CMGSCCC)
- Per-category on/off settings.
- Default user settings for challenges and notifications.
- Database error when pruning a user?s scores with table prefix.
- Database error when viewing distinct high scores when the table is empty.
- Notification bug fixes, users should now be notified based on their Arcade settings.
- Timestamp bug fixed for news and events.

1.0.6 - Bug fixes.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Fixed a bug where unregistered users could challenge people in the Arcade.
- "Wipe All Scores" tool added.
- "arcade_award_bit" template is now cached correctly.

1.0.7 - Features and Bug fixes.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Guests can now play games, but their scores aren't recorded. If a guest plays a game, they're asked to register if they want their score recorded afterwards.
- Admins can now wipe all scores through the Admin CP.
- Admins now have a tool to enable challenges by default for all users.
- Usergroup requirements for games are now in place.
- Admins can now choose to flip the columns and have the smaller panel on the left, with the larger content area on the right.
- News & Events - now entries contain links to games.
- Numerous bug fixes.
- Mass category changer for altering game categories en masse.
- High score rebuilder in the Admin CP.


=================================
Branding Free
=================================

All v3 Arcade installations carry and require a small "v3 Arcade" logo in the footer, as well as the text "Powered by v3 Arcade" which links to http:www.v3arcade.com. For information on legally removing the branding, please visit www.v3arcade.com.


=================================
www.v3arcade.com
=================================

If you're looking for more games, add-ons, support, tutorials, or anything Arcade related - www.v3arcade.com is the place to go.

Bug tracking: http://www.v3arcade.com/forums/vbugs.php

You can contact me directly at john@v3arcade.com for support.


=================================
Many thanks to...
=================================

- All branding-free customers and donors, for supporting the project.
- Oblivion Knight, for his work on the forums and great add-ons.
- Snowy, for his work on the forums.
- Andreas a.k.a. KirbyDE, for his vB 3.5 tutorials.


=================================
Copyright
=================================

All code in distributed in this zip is Copyright ?2005 John Warwick, with the following exceptions:
class_tar.php - Credits within.
All Actionscript code within the included .swf files, unless otherwise noted.

[lanc3lot]

A question: To enable challenges, we have to "enable" it to every single member in his options or can we mass enable it?
The same question, if we can mass enable other options u have in the usercp, like pm report when someone beats the record, etc

[John]

Originally Posted by lanc3lot

A question: To enable challenges, we have to "enable" it to every single member in his options or can we mass enable it?

Run

UPDATE user SET arcadeoptions=arcadeoptions+1 WHERE !(arcadeoptions & 1)

Mass editing will come shortly.

[lanc3lot]

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'tech_forumup.user' doesn't exist

[John]

Originally Posted by lanc3lot

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'tech_forumup.user' doesn't exist

If you're using a table prefix, you need to edit the query accordingly.

[TsirhCitna]

So I tried to upgrade from 1.0.0 to 1.0.1 and this is what I get when I try to import the new product. I selected overwrite.

Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;

MySQL Error  : Duplicate column name 'categoryid'
Error Number : 1060
Date		 : Tuesday, November 29th 2005 @ 06:59:57 PM
Script	   : http://www.tenstones.net/forums/admincp/plugin.php
Referrer	 : http://www.tenstones.net/forums/admincp/plugin.php?do=productadd
IP Address   : 4.229.225.84
Username	 : Bob
Classname	: vB_Database

[Lionel]

Originally Posted by TsirhCitna

So I tried to upgrade from 1.0.0 to 1.0.1 and this is what I get when I try to import the new product. I selected overwrite.

Database error in vBulletin 3.5.1:
 
Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;
 
MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060
Date		 : Tuesday, November 29th 2005 @ 06:59:57 PM
Script	 : http://www.tenstones.net/forums/admincp/plugin.php
Referrer	 : http://www.tenstones.net/forums/admincp/plugin.php?do=productadd
IP Address : 4.229.225.84
Username	 : Bob
Classname	: vB_Database

got the same problem too. From 1.0 to 1.01

Database error in vBulletin 3.5.1:

Invalid SQL:
CREATE TABLE vb3_arcade_categories (categoryid int(10) unsigned NOT NULL auto_increment, catname varchar(250) NOT NULL, displayorder int(10) unsigned NOT NULL, PRIMARY KEY (categoryid));

MySQL Error : Table 'vb3_arcade_categories' already exists
Error Number : 1050

[john1744]

Am I missing something? I do not see anywhere to install games or to turn on games. Shouldn't there be a panel on the left of the ACP for my Arcade? I'm not seeing it.

[lanc3lot]

John there is also another bug.

I tried to change the settings in one of the games and see the outcome:

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE vb3new_arcade_games SET
	title='Asteroids',
	description='Η εποχή των 80s επιστρέφει, με ένα ακόμα παιχνίδι της Retro κατηγορίας του gamers.gr',
	width='500',
	height='375',
	gamepermissions='7',
	minpoststotal='1',
	minpostsperday='0',
	minpoststhisday='0',
	minreglength='0',
	minrep='0',
	categoryid='3',
	isreverse='0'
	WHERE gameid=7;

MySQL Error  : Unknown column 'minpoststhisday' in 'field list'
Error Number : 1054
Date         : Wednesday, November 30th 2005 @ 02:16:42 AM
Script       : http://www.gamers.gr/forums/admincp/arcadeadmin.php
Referrer     : http://www.gamers.gr/forums/admincp/arcadeadmin.php?do=editgame&gameid=7&s=
IP Address   : 212.54.217.231
Username     : lancelot
Classname    : vb_database

[Lionel]

After I got that error, went in admincp to investigate how to uninstall and reinstall from scratch, PRODUCT DISAPPEARED.

[John]

Fixing now.