Can any one help me to install arcadebb 4 theme

[dinesh]

I Install arcadebb 4 theme but i dont know how to create msql table .

Can any one help.

[4ks]

(02-14-2011 12:24 AM)dinesh Wrote:  I Install arcadebb 4 theme but i dont know how to create msql table .

Can any one help.

First of all you must install plugin DB Manager (and also all required plugins) and then, as wrote ArcadeBB here, 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` ;

Please, read carefully first post ArcadeBB.
Good luck