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.

Screenshot batch number 1. (Front end)

Screenshot batch number 2. (Front end)

I've been waiting, can't wait. Gonna install right away! Thanks!

EDIT: Crap, didn't see that either, sorry!

Screenshot batch number 3. (www.v3arcade.com Game Store integration)

Screenshot batch number 4. (www.v3arcade.com Game Store integration)

Screenshot batch number 5. (Admin CP)

Ok, here I go again:
Finally, thx man!

Woot First Install!

Edit: Oops... beaten by one guy :P

thank you

thanks alot!!! it been worth the time .. I love it keep up the good work!

At long last the wait is over. It is good to see this old hack with new life. Excellent work, John.

hey john I have purchased the branding free ages ago so i will be upgrading. Do i just ftp all the files to my server and import the product but allow ovewrite

Cheers

Yep - just check the overwrite box when you import and it should be flawless. Worked nicely on v3arcade.com earlier on today.

/me upgrades to full release.

Is it safe to use with all of O.K's 3.5.1 beta v3arcade addons still, or are they going to need rebuilding? (aimed at O.K. more than John)

I was still keeping my tables from vb3.0.x installation. Even i choosed overwrite i had the following error

I've got a feeling that most of them will be okay.

Installed :)

As per the instructions:

Thanks.. You rock john.. :)

John is there a quick query which i can get rid of all ex installations tables ?

Thanks!, Is there an importer to convert all scores and stuff from ibpro arcade to v3?

Read the instructions, it says in there.

If you're upgrading and important, you don't want to do that. But you'll need to drop that field that's causing the installation to fail - use:

ALTER TABLE usergroup DROP arcadepermissions

hey joh I get this error when I go to my arcade after upgrade

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM vb3_arcade_challenges
LEFT JOIN vb3_user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN vb3_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN vb3_arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error : Unknown table 'arcade_challenges'
Error Number : 1051
Date : Sunday, November 27th 2005 @ 02:32:05 PM
Script : http://www.harddanceaddict.net/forum/arcade.php
Referrer : http://www.harddanceaddict.net/forum/index.php
IP Address :
Username : tidy_boy
Classname : vb_database

You did overwrite the product, didn't you?

yes I did mate

Excellent, excellent, excellent!
Great update.

Wow man I was looking for 20 min on your site for the arcade.
- I gave up and found it here.

/me cries.

I'll shoot off a bunch of VBA CMPS after the install.
- Gimi few hours

That's weird. Run this:

CREATE TABLE arcade_challenges (
challengeid int(10) unsigned NOT NULL auto_increment,
fromuserid int(10) unsigned NOT NULL default '0',
touserid int(10) unsigned NOT NULL default '0',
winnerid int(10) unsigned NOT NULL default '0',
loserid int(10) unsigned NOT NULL default '0',
gameid int(10) unsigned NOT NULL default '0',
datestamp int(10) unsigned NOT NULL default '0',
fromsessionid int(10) unsigned NOT NULL default '0',
tosessionid int(10) unsigned NOT NULL default '0',
fromscore float(15,3) unsigned NOT NULL default '0.000',
toscore float(15,3) unsigned NOT NULL default '0.000',
status tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (challengeid)
)

It should have done that as part of the product upgrade, though. :/

damit nvm /;

Error:got this when updating my usergroups

I am getting this as well i have updated from a beta version

That did not work still get an error

The same error?

It worked out. Thanks for the awesome script John. I have one question. I still have all my games and i never dropped my tables. Is there any chance i can get these games working ? Because i dont have the game install scripts anymore.

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM vb3_arcade_challenges
LEFT JOIN vb3_user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN vb3_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN vb3_arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error : Unknown table 'arcade_challenges'
Error Number : 1051
Date : Sunday, November 27th 2005 @ 02:38:05 PM
Script : http://www.harddanceaddict.net/forum/arcade.php
Referrer : http://www.harddanceaddict.net/forum/index.php
IP Address :
Username : tidy_boy
Classname : vb_database

And if you try to add the table manually, using that query I posted?

This is the error i get

An error occurred while attempting to execute your query. The following information was returned.
error number: 1050
error desc: Table 'arcade_challenges' already exists

admincp/arcadeimport.php :)

Ouch, usaly in the install script has size, keys to use, directions, and the $score key to use for that game.