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.

[Snoop-It]

^^ that hasnt made a difference for my board, its wiped off my champion hack though.. and still seeing this error...

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

what to do...??!?!

[Retell]

Mine seems to be working fine after upgrade, seems exactly the same as before. I did have to do ALOT of SQL editing on my part before, but I have to admit John, you did a great job on 1.0.1 let me know if you need any thing from me

[Lionel]

Yes.

PHP Code:

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 @ 09:05:13 PM 


[Moparx]

Originally Posted by Lionel

Yes.

PHP Code:

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 @ 09:05:13 PM 


I am also still getting this when trying to import the product file

[Retell]

Originally Posted by dholaholic

^^ that hasnt made a difference for my board, its wiped off my champion hack though.. and still seeing this error...

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


what to do...??!?!

try going into phpmyadmin and deleteing everything that has to do with arcade, all databases and the stuff in usergroup and user. Then go into the product, edit the uninstaller, by deleting all the SQL uninstall steps. Then uninstall V3. Upload the XML again and it should work. Hope That Helps :P

[Snoop-It]

Originally Posted by Retell

try going into phpmyadmin and deleteing everything that has to do with arcade, all databases and the stuff in usergroup and user. Then go into the product, edit the uninstaller, by deleting all the SQL uninstall steps. Then uninstall V3. Upload the XML again and it should work. Hope That Helps :P

yeh i know that, im trying to avoid all of that as i spent a lot of time adding stuff on the arcade... iv already lost all previous data from 3.0.x then tried members to play games again, comment etc.. and now i think thats wiped off as well.. isn't there 1 code line or something i can add or is this long way the only option i have??

[lanc3lot]

Originally Posted by John

Anyone having problems.

Damn

I hoped that as it not a major problem, and only a prob that u maybe can find a fix, it could be solved like this...and not to have uninstall everything, loose the scores and the games

Damnnnnnnnnn

[Lionel]

I uninstalled many times. But why on a fresh re install every one is having that Duplicate column name 'categoryid'

[TsirhCitna]

Originally Posted by John

Uninstall the product.

Run each of these queries one by one.

ALTER TABLE usergroup DROP arcadepermissions
ALTER TABLE user DROP arcadeoptions
ALTER TABLE arcade_games DROP isreverse
ALTER TABLE user DROP challengecache
DROP TABLE IF EXISTS arcade_challenges
DROP TABLE IF EXISTS arcade_categories
DROP TABLE IF EXISTS arcade_games
DROP TABLE IF EXISTS arcade_news
DROP TABLE IF EXISTS arcade_sessions
DROP TABLE IF EXISTS arcade_ratings

So far, all of the errors I've seen here were solved on my table prefix installation by the latest installation. Because I can't replicate this problem it's very difficult for me to fix it.

Isn't that going to drop all of the current scores? To duplicate the problem everyone seems to be having just try to upgrade from 1.0.0 to 1.0.1. That's all I have done.

[John]

The reason this is so damn frustrating is that all the errors you guys are posting here are bugs that I've already fixed, because I was experiencing them on my prefixed test forums.

I've just installed, uninstalled, and reinstalled on my prefix forums about ten times without problems. If you're having problems, email me your class_database_analyse.php file to john {at} eovie.com.