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.

[bold]

workin fine for me

[Lionel]

yes I do use prefixes

[fringehead]

I uploaded the files, then chowned them to the proper website permissions...

Why am I getting no access from the admin? and why do I not see games? Do I need to download games?

[lanc3lot]

Originally Posted by John

If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run admincp.php?do=fixdb.

It should solve any problems you've been having.

It will solve also the prob i have when i alter the settings?

When u say install again, u mean repaste the files u have inside or just upload the new xml? I did upload only the xml and everything went ok, though, when i try alter the settings i have the same error

Also, when u say run admincp.php?do=fixdb, what do u mean?

[John]

Originally Posted by lanc3lot

It will solve also the prob i have when i alter the settings?

When u say install again, u mean repaste the files u have inside or just upload the new xml? I did upload only the xml and everything went ok, though, when i try alter the settings i have the same error

Also, when u say run admincp.php?do=fixdb, what do u mean?

It was a big typo. Should be:

If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run arcadetools.php?do=fixdb.

It should solve any problems you've been having.

[Moparx]

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

I am also getting this... I originally uninstalled the product earlier today and just tried to reinstall since 1.0.1 supports posts per day now.

I have tried manually dropping the vb3_arcade_* tables to no avail


running arcadetools.php?do=fixdb gives me this:

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_cpuser AS phrasegroup_cpuser,
language.phrasegroup_arcade AS phrasegroup_arcade,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM vb3_user AS user
LEFT JOIN vb3_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vb3_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN
vb3_administrator AS administrator ON (administrator.userid = user.userid) INNER JOIN vb3_language AS language ON
(language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 1;

MySQL Error : Unknown column 'language.phrasegroup_arcade' in 'field list'
Error Number : 1054
Date : Tuesday, November 29th 2005 @ 08:06:06 PM
Script : http://www.virtualinfusion.net/<admincp>/arcadetools.php?do=fixdb

[Lionel]

I do get errors running that tools also. All phrases disappeared too.

[lanc3lot]

When i do this john (i mean without the typo:P) i have:

Database error in vBulletin 3.5.0:

Invalid SQL:
CREATE TABLE vb3new_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 'vb3new_arcade_categories' already exists
Error Number : 1050
Date         : Wednesday, November 30th 2005 @ 03:13:32 AM
Script       : http://www.gamers.gr/forums/admincp/arcadetools.php?do=fixdb
Referrer     : 
IP Address   : 212.54.217.231
Username     : lancelot
Classname    : vb_database

[TsirhCitna]

Originally Posted by John

If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run arcadetools.php?do=fixdb.

It should solve any problems you've been having.

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 @ 08:14:04 PM
Script	   : http://www.tenstones.net/forums/admincp/arcadetools.php?do=fixdb
Referrer	 :

[John]

Originally Posted by TsirhCitna

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 @ 08:14:04 PM
Script	   : http://www.tenstones.net/forums/admincp/arcadetools.php?do=fixdb
Referrer	 :

Download the zip again.

If fixdb doesn't help, try uninstalling and reinstalling.