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.

[bashy]

Sorry CP, I use my portal the same as yours and i dont have any problems m8
As for the database removal? I aint sure about that i just did a reversal of the install instructions and all went well m8

Originally Posted by C_P

Hello bashy,
Thank you for the input. My biggest concern was if I remove the ibProArcade 2.5.5 if I have to remove and tables from my database, etc. to have a clean removal.
Then once I remove it, how hard is it to instal and to get games for?
See, I wrap my portal around my forum and Mr.Zeropage (who created ibProArcade 2.5.5) staates there is no support for his arcade if you use mkportal.
I just do not want to have the same thing if I remove the ibProArcade 2.5.5 and install this one.

[xspazx]

Why cant this just have a simple uninstall/install script? This whole thing is full of errors, which is usually normal for sucha big hack but still. Im not trying to be ungreatful or anything but.. what ever. im sure people are going to quote me and say "then dont use it". soooo have at it :P anyway props to the coder, ive used the hack before, but I cant now, too many errors.

[Serial Killer]

Buy GameSiteScript at www.gamesitescript.com if you want perfection. It really is the best you can get. I have it on one of my sites and it's one of my favourite scripts. There are almost 2000 games available for it.

The drawbacks? It's quite expensive...and no vBulletin integration (which is a real bummer).

[davelacey]

Originally Posted by hitmanuk2k

I have searched for this solution, and seen people ask for it 3 times in this thread, but no one has helped?



When trying to change default settings.

Make that 5 times.
Has anyone any idea?
Thanks in advance

[teyron]

i installed it and it appears all in white, and the games give blank pages

[Serial Killer]

As I said, buy GameSiteScript.

[teyron]

umm, no i dont want to buy anything, i just want this sorted

[davelacey]

Originally Posted by davelacey

Make that 5 times.
Has anyone any idea?
Thanks in advance

Oops - Harry72 came up with the answer a few pages back. Now works a treat.
[edit] And so did John much earlier on [/edit]

[furst]

I just tried to upgrade and this is what it gave me (I did click the overwrite option):

Database error in vBulletin 3.5.3:

Invalid SQL:
INSERT INTO vb_arcade_categories VALUES (7,'Puzzle',1,1),(8,'Action',2,1),(3,'Retro',3,1),(4,'Sport',4,1),(5,'Shooters',5,1),(1,'Other',100,1),(2,'Favorites',101,1);

MySQL Error  : Duplicate entry '7' for key 1
Error Number : 1062
Date         : Wednesday, April 5th 2006 @ 03:39:47 AM
Script       : http://domain.com/admincp/plugin.php
Referrer     : http://domain.com/admincp/plugin.php?do=productadd
IP Address   : ip.ip.ip.ip
Username     : admin
Classname    : vb_database

I searched the thread and found no current answers. Can anyone help me out please?

[Blue-Inc]

My last time for an attempt of avail.


I did go to the support center provided by this forum. But Il post my problem.
I get this error below trying to view the arcade (blue-inc.org/arcade.php)

Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM arcade_challenges AS arcade_challenges
LEFT JOIN user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 10;
MySQL Error : Table 'blueinc_vb.arcade_challenges' doesn't exist
Error Number : 1146
Date : Monday, April 3rd 2006 @ 11:49:26 AM
Script : http://www.blue-inc.org/arcade.php
http://www.blue-inc.org/index.php
IP Address : xxxxx :tear: not telling you this.
Username : echo_unlimited
Classname : vb_database

Also I get these errors while veiwing a thread:

Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT title,highscorerid,highscore,miniimage,gameid FROM arcade_games WHERE highscorerid IS NOT NULL AND (gamepermissions & 2);
MySQL Error : Table 'blueinc_vb.arcade_games' doesn't exist
Error Number : 1146
Date : Monday, April 3rd 2006 @ 03:39:27 PM
Script : http://www.blue-inc.org/showthread.php?p=519#post519
Referrer : http://www.blue-inc.org/index.php
IP Address : ---------
Username : echo_unlimited
Classname : vb_database

And while when I go into ACP>>Arcade>> Catagorys:

Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT * FROM arcade_categories AS arcade_categories ORDER BY displayorder ASC;
MySQL Error : Table 'blueinc_vb.arcade_categories' doesn't exist
Error Number : 1146
Date : Monday, April 3rd 2006 @ 03:40:41 PM
Script : http://www.blue-inc.org/admincp/arca...?do=categories
Referrer : http://www.blue-inc.org/admincp/index.php?do=nav
IP Address :-------------
Username : echo_unlimited
Classname : vb_database

ACP>>Arcade>>Games:

Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT COUNT(*) AS total
FROM arcade_games AS arcade_games;
MySQL Error : Table 'blueinc_vb.arcade_games' doesn't exist
Error Number : 1146
Date : Monday, April 3rd 2006 @ 03:41:23 PM
Script : http://www.blue-inc.org/admincp/arca...n.php?do=games
Referrer : http://www.blue-inc.org/admincp/index.php
IP Address : -------------
Username : echo_unlimited
Classname : vb_database

Thats all the errors I get, plus its affecting my forum


How would I fix these? I done some thing to my site and i don't know how to fix these errors.