Details:
ArcadeBB Theme V4 is a free WordPress Arcade Theme. You can use it to power your arcade site using WordPress by feeding games from MochiMedia and GamesFeed.
ArcadeBB Trade V4 is a free WordPress Arcade Trade Plugin that is ATS Plug compatible. Together with Free GeoLite database created by MaxMind, ArcadeBB Trade V4 is also capable of GEO Traffic Trading. 4 Tiers of traffic (Tier 0, Tier 1, Tier 2 and Tier 3) and hosted play can be defined by user. Default is as follows:
Tier 0 - US
Tier 1 - Australia,Canada,Germany,Ireland,New Zealand,Norway,Switzerland,South Africa,United Kingdom
Tier 2 - Austria,Belgium,Denmark,France,Greece,Iceland,Italy,Liechtenstein,Luxembourg,Netherlands,Portugal,Singapore,Spain,Sweden
Tier 3 will be the those countries not in Tier 0,1,2.
Features:
- Display Games that are feeded from MochiMedia and GamesFeed
- Easy Google Adsense Setup
- Tableless, Fast Loading (only 1 background image - 1x150px)
- 9 sidebars
- More than 27 possible layout.
- Ads Friendly 728x90, 468x60, 160x600, 300x250, 125x125, 100x100
- Pop-under code included.
- Allow/disallow users to resize game width
- Add games in SWF, DCR, iFrame format.
- Limits text characters under thumbnail.
- One page control over 100 theme settings.
- Enable/Disable traffic trading
- Able to set Max Trade Ratio for each trade partner
- GEO Traffic Trading (must install MaxMind's GEOLite Database. More info here
- ATS Plug Helper compatible.
- Hotlink/CDN Domain for thumbnail, swf, dcr. 1 upload shared by multi arcade sites.
- All the files are 100% unencrypted.
- and many more features...
Plugins Required
- MochiAds Arcade Plugin for WordPress
- WP-PageNavi
- WP-PostRatings
- WP-PostViews
- WP-DBManager or Portable PMA
Plugins Recommended
- All in one SEO
- Google XML Sitemaps
- W3 Total Cache
- Akismet
- Configurable Tag Cloud
Installation
1. Upgrade your WordPress to 3.0.0 or higher.
2. Unzip and upload all the files
3. Chmod all files except *.jpg in the ArcadeBB3 folder to 666.
4. Install and activate all the required plugins mentioned above
5. Goto Settings>Permalink>Custom Structure, enter
Quote:/games/%postname%
in the box and click on the "save changes" button.
6. Goto MochiAds>Setup to setup the mochi database.
7. Goto MochiAds>Feed Games to get all your games.
8. Goto MochiAds>Manage Games and publish games that you want on your site.
9. Goto Appearance/Themes and activate ArcadeBB V3 WordPress Arcade.
10. Goto ArcadeBB>Theme Setup and edit the setting.
11. Goto ArcadeBB>Trade Setup and enter the trade stats reset password.
12. Setup Cronjob as follows:
Replace xx with another number between 0 to 23, yourdomain.com with your arcade domain and xxxxx to the password you set earlier in step 11.
14. For V3 to V4 upgrade, goto Database>Run SQL Query, paste and run the following queries:
Quote:ALTER TABLE `trade_sites` ADD `websitetier` INT( 11 ) NOT NULL DEFAULT '1' AFTER `websitestatus` ;
ALTER TABLE `trade_sites` ADD `maxdayout` INT( 11 ) NOT NULL DEFAULT '1' AFTER `mindayout` ;
ALTER TABLE `trade_sites` ADD `qualityratio` INT( 11 ) NOT NULL DEFAULT '100' AFTER `maxtraderatio` ;
ALTER TABLE `trade_ipaddress` ADD `playcount` INT( 11 ) NOT NULL DEFAULT '0' AFTER `io` ;
ALTER TABLE `trade_ipaddress` CHANGE `ipaddress` `ipaddress` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
ALTER TABLE `trade_ipaddress` ADD `country` VARCHAR( 255 ) NOT NULL AFTER `ipaddress` ;
ALTER TABLE `trade_ipaddress` ADD `country_code` VARCHAR( 255 ) NOT NULL AFTER `country` ;
ALTER TABLE `trade_sites` ADD `tier0credit` INT( 11 ) NOT NULL DEFAULT '0' AFTER `totalout` ;
ALTER TABLE `trade_sites` ADD `tier1credit` INT( 11 ) NOT NULL DEFAULT '0' AFTER `tier0credit` ;
ALTER TABLE `trade_sites` ADD `tier2credit` INT( 11 ) NOT NULL DEFAULT '0' AFTER `tier1credit` ;
ALTER TABLE `trade_sites` ADD `tier3credit` INT( 11 ) NOT NULL DEFAULT '0' AFTER `tier2credit` ;
15. For V4 new installation, goto Database>Run SQL Query, paste and run the following queries:
Quote:CREATE TABLE IF NOT EXISTS `trade_ipaddress` (`ipaddress` varchar(15) NOT NULL default '', `websiteurl` text NOT NULL, `post_id` int(11) NOT NULL default '0', `io` int(1) NOT NULL default '0', `time` int(11) NOT NULL default '0', PRIMARY KEY (`ipaddress`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `trade_plugs` (`plugid` int(10) unsigned NOT NULL auto_increment, `post_id` int(10) NOT NULL default '0', `websiteid` int(10) NOT NULL default '0', `plugurl` text NOT NULL, `plugstatus` int(1) NOT NULL default '0', `plugdayout` int(10) NOT NULL default '0', `plugtotalout` int(10) NOT NULL default '0', `plugnote` text NOT NULL, PRIMARY KEY (`plugid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `trade_banners` (`bannerid` int(11) unsigned NOT NULL auto_increment, `bannertype` varchar(255) NOT NULL, `websiteid` int(11) NOT NULL default '0', `bannerurl` varchar(255) NOT NULL, `bannerstatus` int(1) NOT NULL default '0', `bannerdayout` int(11) NOT NULL default '0', `bannertotalout` int(11) NOT NULL default '0', `bannernote` varchar(255) NOT NULL, PRIMARY KEY (`bannerid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `trade_links` (`linkid` int(11) unsigned NOT NULL auto_increment, `linktype` varchar(255) NOT NULL, `websiteid` int(11) NOT NULL default '0', `linkurl` varchar(255) NOT NULL, `linkstatus` int(1) NOT NULL default '0', `linkdayout` int(11) NOT NULL default '0', `linktotalout` int(11) NOT NULL default '0', `linknote` varchar(255) NOT NULL, PRIMARY KEY (`linkid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `trade_sites` (`websiteid` int(10) unsigned NOT NULL auto_increment, `websitename` text NOT NULL, `websiteurl` text NOT NULL, `emailaddress` text NOT NULL, `dayin` int(10) unsigned NOT NULL default '0', `totalin` int(10) unsigned NOT NULL default '0', `description` mediumtext NOT NULL, `alwayslisted` int(11) NOT NULL default '0', `websitestatus` int(11) NOT NULL default '0', `mindayout` int(11) NOT NULL default '0', `dayout` int(11) NOT NULL default '0', `totalout` int(11) NOT NULL default '0', `websitepassword` text NOT NULL, PRIMARY KEY (`websiteid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
ALTER TABLE `trade_ipaddress` ADD `ipid` INT( 10 ) NOT NULL FIRST ;
ALTER TABLE `trade_ipaddress` DROP PRIMARY KEY ;
ALTER TABLE `trade_ipaddress` ADD INDEX ( `ipid` ) ;
ALTER TABLE `trade_ipaddress` CHANGE `ipid` `ipid` INT( 10 ) NOT NULL AUTO_INCREMENT ;
ALTER TABLE `trade_ipaddress` ADD PRIMARY KEY ( `ipid` ) ;
ALTER TABLE `trade_ipaddress` DROP INDEX `ipid` ;
ALTER TABLE `trade_ipaddress` ADD `fullurl` VARCHAR( 255 ) NOT NULL AFTER `websiteurl` ;
ALTER TABLE `trade_sites` ADD `maxtraderatio` INT( 11 ) NOT NULL DEFAULT '120' AFTER `totalout` ;
ALTER TABLE `trade_sites` ADD `websitetier` INT( 11 ) NOT NULL DEFAULT '1' AFTER `websitestatus` ;
ALTER TABLE `trade_sites` ADD `maxdayout` INT( 11 ) NOT NULL DEFAULT '1' AFTER `mindayout` ;
ALTER TABLE `trade_sites` ADD `qualityratio` INT( 11 ) NOT NULL DEFAULT '100' AFTER `maxtraderatio` ;
ALTER TABLE `trade_ipaddress` ADD `playcount` INT( 11 ) NOT NULL DEFAULT '0' AFTER `io` ;
ALTER TABLE `trade_ipaddress` CHANGE `ipaddress` `ipaddress` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;
ALTER TABLE `trade_ipaddress` ADD `country` VARCHAR( 255 ) NOT NULL AFTER `ipaddress` ;
ALTER TABLE `trade_ipaddress` ADD `country_code` VARCHAR( 255 ) NOT NULL AFTER `country` ;
ALTER TABLE `trade_sites` ADD `tier0credit` INT( 11 ) NOT NULL DEFAULT '0' AFTER `totalout` ;
ALTER TABLE `trade_sites` ADD `tier1credit` INT( 11 ) NOT NULL DEFAULT '0' AFTER `tier0credit` ;
ALTER TABLE `trade_sites` ADD `tier2credit` INT( 11 ) NOT NULL DEFAULT '0' AFTER `tier1credit` ;
ALTER TABLE `trade_sites` ADD `tier3credit` INT( 11 ) NOT NULL DEFAULT '0' AFTER `tier2credit` ;
W3 Total Cache
We recommend using W3 Total Cache
1) Disable "Page Cache".
2) Enable all other Cache.
3) For CDN, I recommend MaxCDN.
3) Save changes, verify and Empty all caches.
Add Page
You may or may not need to create the following pages using Pages>Add New.
1) Popular Games or Most Played Games
2) Top Rated Games or Best Games
3) Random Games
4) New Games or Latest Games
5) Most Rated Games
6) Trade Stats
7) Trade Traffic
8) Contact
9) Privacy Policy
Traffic Trading
To trade with other arcade site,
1) Goto yourdomain.com/trade-traffic and enter the information as required.
2) Goto Dashboard>ArcadeBB>Trade Stats>
a) Click on "FE" (Full Edit) and change status to 1 to approve site for trading.
ATS Plug Helper
1) Goto Dashboard>ArcadeBB>Trade Stats>, click on "MP" (Manage Plug) of your partner.
2) Click on "ATS-Plug-Helper" if your partner is ATS compatible.
3) A list of links will appear depending on the games your partner has.
POP-Under
1) Open and edit pop-under.js under your root folder
2) Find and replace "www.addictinggames88.com" with your domain name.
4) Find and replace "addictinggames88dotcompopunder" with your own cookies name, can be anything.
5) Save and upload the file.
Background Gradient Image
1) Create your own background image, upload and note down the url to the image. (or Goto http://tools.dynamicdrive.com/gradient/ to create a background gradient image, set width to 1, height to 150, top color, bottom color, image format to PNG. Click on "Get Full Image", save it and upload to your server. Note down the url to the image)
2) Goto Dashboard/Appearance/Editor/white-style.css, find and replace all http://img1.addictinggames88.com/bg/3333...-1x150.png
with your own background image url.
(12-25-2010 03:31 PM)freakygames Wrote: Hi, is available to apply the Arcade Trade Plugin to another themes? Thanks,
It is possible, however there are some trade related codes you need to paste on your theme.
What theme are you using?
Hi, Arcadebb,
Thank you very much for sharing the ArcadeBB Theme V4.
However, I bump upon some errors as follows:
After following the theme installation steps, I installed the ip2c table (for GEO trading) and add your SQL query to run it (for new V4 installation; the website address is http://www.topcoolgame.com):
Quote:Error
SQL query:
ALTER TABLE `trade_sites` CHANGE `linkstatus` `websitestatus` INT( 11 ) NOT NULL DEFAULT '0';
MySQL said: Documentation
#1054 - Unknown column 'linkstatus' in 'trade_sites'
On the site there is this message:
Quote: Unknown column 'fullurl' in 'field list'
So what is wrong in this? What did I do wrong? Thank you very much for your support.
Posts: 683
Joined: Dec 2009
Reputation: 0 Points: 1096
RE: ArcadeBB Theme V4 + ArcadeBB Trade V4
Hi gameezfun,
For new installation, remove the following sql query.
Quote:ALTER TABLE `trade_sites` CHANGE `linkstatus` `websitestatus` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `trade_sites` DROP `linkdifference`, DROP `banner88status`, DROP `banner88`, DROP `banner100status`, DROP `banner100`;
ALTER TABLE `trade_sites` CHANGE `linkpassword` `websitepassword` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;
I will update the first post.
iBannerX.com Arcade Banner Click Exchange Sign up now and get 80,000 free credits!!! http://ibannerx.com
I manage to run the SQL queries you provided in the first post; however, I removed all the portions of the queries that deliver errors. And here is what I actually inputted:
Quote:CREATE TABLE IF NOT EXISTS `trade_ipaddress` (`ipaddress` varchar(15) NOT NULL default '', `websiteurl` text NOT NULL, `post_id` int(11) NOT NULL default '0', `io` int(1) NOT NULL default '0', `time` int(11) NOT NULL default '0', PRIMARY KEY (`ipaddress`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `trade_plugs` (`plugid` int(10) unsigned NOT NULL auto_increment, `post_id` int(10) NOT NULL default '0', `websiteid` int(10) NOT NULL default '0', `plugurl` text NOT NULL, `plugstatus` int(1) NOT NULL default '0', `plugdayout` int(10) NOT NULL default '0', `plugtotalout` int(10) NOT NULL default '0', `plugnote` text NOT NULL, PRIMARY KEY (`plugid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `trade_banners` (`bannerid` int(11) unsigned NOT NULL auto_increment, `bannertype` varchar(255) NOT NULL, `websiteid` int(11) NOT NULL default '0', `bannerurl` varchar(255) NOT NULL, `bannerstatus` int(1) NOT NULL default '0', `bannerdayout` int(11) NOT NULL default '0', `bannertotalout` int(11) NOT NULL default '0', `bannernote` varchar(255) NOT NULL, PRIMARY KEY (`bannerid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `trade_links` (`linkid` int(11) unsigned NOT NULL auto_increment, `linktype` varchar(255) NOT NULL, `websiteid` int(11) NOT NULL default '0', `linkurl` varchar(255) NOT NULL, `linkstatus` int(1) NOT NULL default '0', `linkdayout` int(11) NOT NULL default '0', `linktotalout` int(11) NOT NULL default '0', `linknote` varchar(255) NOT NULL, PRIMARY KEY (`linkid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `trade_sites` (`websiteid` int(10) unsigned NOT NULL auto_increment, `websitename` text NOT NULL, `websiteurl` text NOT NULL, `emailaddress` text NOT NULL, `dayin` int(10) unsigned NOT NULL default '0', `totalin` int(10) unsigned NOT NULL default '0', `description` mediumtext NOT NULL, `alwayslisted` int(11) NOT NULL default '0', `websitestatus` int(11) NOT NULL default '0', `mindayout` int(11) NOT NULL default '0', `dayout` int(11) NOT NULL default '0', `totalout` int(11) NOT NULL default '0', `websitepassword` text NOT NULL, PRIMARY KEY (`websiteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `trade_ipaddress` ADD INDEX ( `ipid` ) ;
ALTER TABLE `trade_ipaddress` CHANGE `ipid` `ipid` INT( 10 ) NOT NULL AUTO_INCREMENT ;
ALTER TABLE `trade_ipaddress` DROP INDEX `ipid` ;
ALTER TABLE `trade_ipaddress` CHANGE `ipaddress` `ipaddress` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
In doing this, I believe that I removed the GEO Trading features as well.
So please update the first post with the full correct SQL queries. In my case, I had installed the MaxMind's ip2c table in the database (i.e. importing the ip2country files and the GeoIPCountryWhois.CSV file).
Arcade Forum
ArcadeBB Theme V4 + ArcadeBB Trade V4
![[Image: arcadebb4-640-480.jpg]](http://www.arcadebb.com/images/arcadebb4-640-480.jpg)
RE: ArcadeBB Theme V4 + ArcadeBB Trade V4 
