Location: PHPKode > scripts > The Host Core (THC) > the-host-core-thc/thc_full_installer/thc_installer.php
<?
if($_POST[step]==2 && ($_POST[password]=="" || $_POST[password]!=$_POST[password2])){
echo"<center>Password Error</center>";
}
	if($_POST[step]==2 && $_POST[password]!="" && $_POST[password]==$_POST[password2]){
		
		include"thc_config.php";
		include"thc_i_conn.php";
		
		
$q1 = "CREATE TABLE IF NOT EXISTS `dl_areas` (
  `id` int(255) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `dl_cats` (
  `id` int(255) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `name` varchar(50) NOT NULL,
  `area` int(255) NOT NULL,
  PRIMARY KEY  (`id`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `dl_dl` (
  `id` int(255) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `name` varchar(150) NOT NULL,
  `publisher` varchar(250) NOT NULL,
  `type` int(2) NOT NULL,
  `auth` int(1) NOT NULL,
  `area` int(255) NOT NULL,
  `cat` int(255) NOT NULL,
  `subcat` int(255) NOT NULL,
  `uid` int(255) NOT NULL,
  `local` varchar(255) NOT NULL,
  `sdescript` varchar(250) NOT NULL,
  `descript` text NOT NULL,
  `dls` int(11) NOT NULL,
  `lastdl` int(255) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `dl_settings` (
  `dlopen` int(1) NOT NULL,
  `max` int(255) NOT NULL,
  `menulinks` int(255) NOT NULL,
  `side` int(1) NOT NULL,
  `mydlname` varchar(50) NOT NULL,
  `dlhistname` varchar(50) NOT NULL,
  `sidedlcolor` varchar(25) NOT NULL,
  `weblocal` int(255) NOT NULL
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `dl_subcats` (
  `id` int(255) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `name` varchar(50) NOT NULL,
  `area` int(255) NOT NULL,
  `cat` int(255) NOT NULL,
  PRIMARY KEY  (`id`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `dl_users` (
  `id` int(255) NOT NULL auto_increment,
  `uid` int(255) NOT NULL,
  `dlid` int(255) NOT NULL,
  `dls` int(255) NOT NULL,
  `lastdl` int(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `host_accounts` (
  `id` int(250) NOT NULL auto_increment,
  `uid` int(250) NOT NULL,
  `username` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
  `domain` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
  `whmname` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
  `server` int(250) NOT NULL,
  `ItemName` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
  `due` int(50) NOT NULL,
  `renewsat` float NOT NULL,
  `renewdays` int(250) NOT NULL,
  `comments` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `status` int(2) NOT NULL,
  `free` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `host_servers` (
  `id` int(11) NOT NULL auto_increment,
  `host` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
  `user` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
  `rak` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `status` int(1) NOT NULL,
  `ns1` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
  `ns2` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
  `ns1ip` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
  `ns2ip` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `host_settings` (
  `h2h` int(1) NOT NULL,
  `autos` int(1) NOT NULL,
  `autosdays` int(250) NOT NULL,
  `autosremind` int(1) NOT NULL,
  `autosremind1` int(250) NOT NULL,
  `autosremind2` int(250) NOT NULL,
  `autosremind3` int(250) NOT NULL,
  `autod` int(1) NOT NULL,
  `autoddays` int(250) NOT NULL,
  `autodremind` int(1) NOT NULL,
  `autodremind1` int(250) NOT NULL,
  `autodremind2` int(250) NOT NULL,
  `autodremind3` int(250) NOT NULL,
  `fhost` int(1) NOT NULL,
  `fhostcount` int(250) NOT NULL,
  `fhostserver` int(250) NOT NULL,
  `fhostwhmname` varchar(250) NOT NULL,
  `susreactive` float NOT NULL,
  `id` int(250) NOT NULL,
  `autolastran` int(250) NOT NULL
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `host_transfer` (
  `id` int(250) NOT NULL auto_increment,
  `fromm` int(250) NOT NULL,
  `tom` int(250) NOT NULL,
  `akey` varchar(25) NOT NULL,
  `account` int(250) NOT NULL,
  `tdate` int(50) NOT NULL,
  `status` int(1) NOT NULL,
  `tfinish` int(50) NOT NULL,
  `cancel` int(250) NOT NULL,
  `reason` text NOT NULL,
  PRIMARY KEY  (`id`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `members_info` (
  `ID` int(255) NOT NULL default '0',
  `firstname` varchar(50) NOT NULL default '',
  `lastname` varchar(50) NOT NULL default '',
  `address` varchar(250) NOT NULL default '',
  `address2` varchar(250) NOT NULL default '',
  `city` varchar(50) NOT NULL default '',
  `state` varchar(50) NOT NULL default '',
  `zip` int(15) NOT NULL default '0',
  `country` varchar(50) NOT NULL default '',
  `phoneH` varchar(25) NOT NULL default '0',
  `phoneW` varchar(25) NOT NULL default '0',
  `phoneC` varchar(25) NOT NULL default '0',
  `fax` varchar(25) NOT NULL default '0',
  `regdate` int(50) NOT NULL default '0',
  `regip` varchar(25) NOT NULL default '',
  `avitar` varchar(255) NOT NULL default '',
  `credits` float(20,10) NOT NULL default '0.0000000000',
  `ppi` float NOT NULL,
  `ptsu` float NOT NULL,
  `ptb` float NOT NULL,
  `ptbb` float NOT NULL,
  PRIMARY KEY  (`ID`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `ref_banners` (
  `id` int(250) NOT NULL auto_increment,
  `banner` varchar(250) NOT NULL,
  `weblocal` int(255) NOT NULL,
  PRIMARY KEY  (`id`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `ref_ip` (
  `id` int(250) NOT NULL auto_increment,
  `ip` varchar(20) NOT NULL,
  `visited` int(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `ref_payouts` (
  `id` int(250) NOT NULL auto_increment,
  `uid` int(250) NOT NULL,
  `amount` float NOT NULL,
  `withpp` int(1) NOT NULL,
  `whereem` text NOT NULL,
  `whenstart` int(250) NOT NULL,
  `whenend` int(250) NOT NULL,
  `status` int(1) NOT NULL,
  `comments` text NOT NULL,
  PRIMARY KEY  (`id`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `ref_settings` (
  `weblocal` int(255) NOT NULL,
  `ppi` float NOT NULL,
  `ippi` int(250) NOT NULL,
  `ptsu` float NOT NULL,
  `ptb` float NOT NULL,
  `ptbb` float NOT NULL,
  `ptbbt` int(2) NOT NULL,
  `payout` int(1) NOT NULL,
  `payoutmin` float NOT NULL,
  `paypal` int(1) NOT NULL,
  `alertpay` int(1) NOT NULL,
  `sendcheck` int(1) NOT NULL
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `ref_stats` (
  `id` int(250) NOT NULL,
  `i` int(250) NOT NULL,
  `ia` float NOT NULL,
  `su` int(250) NOT NULL,
  `sua` float NOT NULL,
  `b` int(250) NOT NULL,
  `ba` float NOT NULL,
  `bb` int(250) NOT NULL,
  `bba` float NOT NULL,
  UNIQUE KEY `id` (`id`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `reg_settings` (
  `weblocal` int(255) NOT NULL auto_increment,
  `pass` int(1) NOT NULL,
  `firstn` int(1) NOT NULL,
  `lastn` int(1) NOT NULL,
  `address` int(1) NOT NULL,
  `city` int(1) NOT NULL,
  `state` int(1) NOT NULL,
  `zip` int(1) NOT NULL,
  `country` int(1) NOT NULL,
  `phone1` int(1) NOT NULL,
  `phone2` int(1) NOT NULL,
  `phone3` int(1) NOT NULL,
  `fax` int(1) NOT NULL,
  `refer` int(1) NOT NULL,
  `captcha` int(1) NOT NULL,
  PRIMARY KEY  (`weblocal`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `site_contact` (
  `weblocal` int(255) NOT NULL,
  `CUID` int(11) NOT NULL auto_increment,
  `location` varchar(100) NOT NULL default '',
  `bgcolor` varchar(7) NOT NULL default '#ffffff',
  `image` varchar(250) NOT NULL default '',
  `image2` varchar(250) NOT NULL default '',
  `descript` text NOT NULL,
  `descript2` text NOT NULL,
  `descript3` text NOT NULL,
  `a` varchar(250) NOT NULL default '',
  `b` varchar(250) NOT NULL default '',
  `c` varchar(250) NOT NULL default '',
  `d` varchar(250) NOT NULL default '',
  `e` varchar(250) NOT NULL default '',
  `f` varchar(250) NOT NULL default '',
  `g` varchar(250) NOT NULL default '',
  `h` varchar(250) NOT NULL default '',
  `i` varchar(250) NOT NULL default '',
  `j` varchar(250) NOT NULL default '',
  `z` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`CUID`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `site_content` (
  `weblocal` int(255) NOT NULL auto_increment,
  `home` text NOT NULL,
  `terms` text NOT NULL,
  `terms_date` varchar(255) NOT NULL,
  `landing` text NOT NULL,
  `shome` text NOT NULL,
  `sterms` text NOT NULL,
  `slanding` text NOT NULL,
  `sdefualt` text NOT NULL,
  `nopage` text NOT NULL,
  `scontactus` text NOT NULL,
  `rhome` text NOT NULL,
  `rterms` text NOT NULL,
  `rlanding` text NOT NULL,
  `rdefualt` text NOT NULL,
  `rcontactus` text NOT NULL,
  `sfaq` text NOT NULL,
  `rfaq` text NOT NULL,
  `cfaq` text NOT NULL,
  `gfaq` text NOT NULL,
  `mfaq` text NOT NULL,
  `host` text NOT NULL,
  `shost` text NOT NULL,
  `rhost` text NOT NULL,
  `lstore` text NOT NULL,
  `rstore` text NOT NULL,
  `ldl` text NOT NULL,
  `rdl` text NOT NULL,
  `lx1` text NOT NULL,
  `mx1` text NOT NULL,
  `rx1` text NOT NULL,
  `ax1` int(1) NOT NULL,
  `lx2` text NOT NULL,
  `mx2` text NOT NULL,
  `rx2` text NOT NULL,
  `ax2` int(1) NOT NULL,
  `lx3` text NOT NULL,
  `mx3` text NOT NULL,
  `rx3` text NOT NULL,
  `ax3` int(1) NOT NULL,
  `lx4` text NOT NULL,
  `mx4` text NOT NULL,
  `rx4` text NOT NULL,
  `ax4` int(1) NOT NULL,
  `lx5` text NOT NULL,
  `mx5` text NOT NULL,
  `rx5` text NOT NULL,
  `ax5` int(1) NOT NULL,
  `ltour` text NOT NULL,
  `tour` text NOT NULL,
  `rtour` text NOT NULL,
  PRIMARY KEY  (`weblocal`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `site_countries` (
  `id` int(250) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `cname` varchar(250) NOT NULL,
  `usec` int(1) NOT NULL,
  `shipto` int(1) NOT NULL,
  `shipfee` float NOT NULL,
  PRIMARY KEY  (`id`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `site_faq` (
  `faqid` int(10) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `question` varchar(250) NOT NULL default '',
  `answer` text NOT NULL,
  `cat` int(10) NOT NULL default '0',
  `sort` int(10) NOT NULL default '0',
  `mempriv` int(1) NOT NULL default '0',
  PRIMARY KEY  (`faqid`)
)  ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `site_faqcat` (
  `faqcatid` int(10) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `cat` varchar(250) NOT NULL default '',
  `sort` int(11) NOT NULL default '0',
  `mempriv` int(1) NOT NULL default '0',
  PRIMARY KEY  (`faqcatid`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `site_flog` (
  `FlogID` int(10) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `username` varchar(25) NOT NULL default '',
  `ip` varchar(25) NOT NULL default '',
  `ftime` varchar(50) NOT NULL default '',
  `phpsID` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`FlogID`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `site_members` (
  `id` int(255) NOT NULL auto_increment,
  `username` varchar(25) NOT NULL default '',
  `password` varchar(100) NOT NULL default '',
  `salt` varchar(250) NOT NULL default '',
  `email` varchar(250) NOT NULL default '',
  `active` int(1) NOT NULL default '0',
  `logged` int(1) NOT NULL default '0',
  `clearance` int(1) NOT NULL default '1',
  `management` int(1) NOT NULL default '0',
  `location` int(255) NOT NULL default '0',
  `newsletter` int(1) NOT NULL default '0',
  `status` int(2) NOT NULL,
  `ref` int(250) NOT NULL,
  `optin` varchar(255) NOT NULL,
  `optstat` int(1) NOT NULL,
  `invite` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`salt`),
  UNIQUE KEY `username` (`username`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `site_menu` (
  `id` int(255) NOT NULL auto_increment,
  `menu` int(2) NOT NULL,
  `weblocal` int(255) NOT NULL,
  `l1` varchar(255) NOT NULL,
  `l2` varchar(255) NOT NULL,
  `l3` varchar(255) NOT NULL,
  `l4` varchar(255) NOT NULL,
  `l5` varchar(255) NOT NULL,
  `l6` varchar(255) NOT NULL,
  `l7` varchar(255) NOT NULL,
  `l8` varchar(255) NOT NULL,
  `l9` varchar(255) NOT NULL,
  `l10` varchar(255) NOT NULL,
  `l11` varchar(255) NOT NULL,
  `l12` varchar(255) NOT NULL,
  `l13` varchar(255) NOT NULL,
  `l14` varchar(255) NOT NULL,
  `l15` varchar(255) NOT NULL,
  `l16` varchar(255) NOT NULL,
  `l17` varchar(255) NOT NULL,
  `l18` varchar(255) NOT NULL,
  `l19` varchar(255) NOT NULL,
  `l20` varchar(255) NOT NULL,
  `l21` varchar(255) NOT NULL,
  `l22` varchar(255) NOT NULL,
  `l23` varchar(255) NOT NULL,
  `l24` varchar(255) NOT NULL,
  `l25` varchar(255) NOT NULL,
  `l26` varchar(255) NOT NULL,
  `l27` varchar(255) NOT NULL,
  `l28` varchar(255) NOT NULL,
  `l29` varchar(255) NOT NULL,
  `l30` varchar(255) NOT NULL,
  `l31` varchar(255) NOT NULL,
  `l32` varchar(255) NOT NULL,
  `l33` varchar(255) NOT NULL,
  `l34` varchar(255) NOT NULL,
  `l35` varchar(255) NOT NULL,
  `l36` varchar(255) NOT NULL,
  `l37` varchar(255) NOT NULL,
  `l38` varchar(255) NOT NULL,
  `l39` varchar(255) NOT NULL,
  `l40` varchar(255) NOT NULL,
  `l41` varchar(255) NOT NULL,
  `l42` varchar(255) NOT NULL,
  `m1` int(2) NOT NULL default '1',
  `m2` int(2) NOT NULL default '1',
  `m3` int(2) NOT NULL default '1',
  `m4` int(2) NOT NULL default '1',
  `m5` int(2) NOT NULL default '1',
  `m6` int(2) NOT NULL default '1',
  `m7` int(2) NOT NULL default '1',
  `m8` int(2) NOT NULL default '1',
  `m9` int(2) NOT NULL default '1',
  `m10` int(2) NOT NULL default '1',
  `m11` int(2) NOT NULL default '1',
  `m12` int(2) NOT NULL default '1',
  `m13` int(2) NOT NULL default '1',
  `m14` int(2) NOT NULL default '1',
  `m15` int(2) NOT NULL default '1',
  `m16` int(2) NOT NULL default '1',
  `m17` int(2) NOT NULL default '0',
  `m18` int(2) NOT NULL default '0',
  `m19` int(2) NOT NULL default '0',
  `m20` int(2) NOT NULL default '0',
  `m21` int(2) NOT NULL default '0',
  `m22` int(2) NOT NULL default '0',
  `m23` int(2) NOT NULL default '0',
  `m24` int(2) NOT NULL default '0',
  `m25` int(2) NOT NULL default '0',
  `m26` int(2) NOT NULL default '0',
  `m27` int(2) NOT NULL default '0',
  `m28` int(2) NOT NULL default '0',
  `m29` int(2) NOT NULL default '0',
  `m30` int(2) NOT NULL default '0',
  `m31` int(2) NOT NULL default '0',
  `m32` int(2) NOT NULL default '0',
  `m33` int(2) NOT NULL default '0',
  `m34` int(2) NOT NULL default '0',
  `m35` int(2) NOT NULL default '0',
  `m36` int(2) NOT NULL default '0',
  `m37` int(2) NOT NULL default '0',
  `m38` int(2) NOT NULL default '0',
  `m39` int(2) NOT NULL default '0',
  `m40` int(2) NOT NULL default '0',
  `m41` int(2) NOT NULL default '0',
  `m42` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `site_settings` (
  `id` int(1) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `name` text NOT NULL,
  `email` varchar(255) NOT NULL default '',
  `copywrite` varchar(255) NOT NULL default '',
  `bgcolor` varchar(25) NOT NULL default '',
  `ffcolor` varchar(25) NOT NULL default '',
  `mlcolor` varchar(25) NOT NULL default '',
  `nlcolor` varchar(25) NOT NULL default '',
  `alcolor` varchar(25) NOT NULL,
  `lhfcolor` varchar(25) NOT NULL default '',
  `lhbgcolor` varchar(25) NOT NULL default '',
  `Rcolor1` varchar(50) NOT NULL default '',
  `Rcolor2` varchar(50) NOT NULL default '',
  `Rcolor3` varchar(50) NOT NULL,
  `Rcolor4` varchar(50) NOT NULL,
  `bordert` int(2) NOT NULL default '0',
  `borders` int(2) NOT NULL default '0',
  `borderh` int(2) NOT NULL default '0',
  `borderf` int(2) NOT NULL default '0',
  `borderc` int(2) NOT NULL default '0',
  `borderm` int(2) NOT NULL,
  `noreg` int(1) NOT NULL default '0',
  `lsidecont` int(1) NOT NULL default '0',
  `rsidecont` int(1) NOT NULL,
  `Apadding` int(2) NOT NULL default '0',
  `Spadding` int(2) NOT NULL default '0',
  `seperate` int(2) NOT NULL default '0',
  `sitewidth` int(4) NOT NULL default '0',
  `pixper` int(1) NOT NULL,
  `lsidewidth` int(4) NOT NULL default '0',
  `rsidewidth` int(4) NOT NULL,
  `hl1color` varchar(25) NOT NULL,
  `hl2color` varchar(25) NOT NULL,
  `sscolor` varchar(25) NOT NULL,
  `ssccolor` varchar(25) NOT NULL,
  `mcacolor` varchar(25) NOT NULL,
  `ptcolor` varchar(25) NOT NULL,
  `mcccolor` varchar(25) NOT NULL,
  `fl1color` varchar(25) NOT NULL,
  `fl2color` varchar(25) NOT NULL,
  `nlfcolor` varchar(25) NOT NULL,
  `nlbcolor` varchar(25) NOT NULL,
  `ml1color` varchar(25) NOT NULL,
  `ml2color` varchar(25) NOT NULL,
  `sbcolor` varchar(25) NOT NULL,
  `smbcolor` varchar(25) NOT NULL,
  `smfcolor` varchar(25) NOT NULL,
  `rscolor` varchar(25) NOT NULL,
  `rsccolor` varchar(25) NOT NULL,
  `logga` int(25) NOT NULL default '86400',
  `logge` int(25) NOT NULL,
  `loggcam` int(25) NOT NULL,
  `nameinhead` int(1) NOT NULL,
  `nameface` int(3) NOT NULL,
  `namecolor` varchar(25) NOT NULL,
  `namesize` int(3) NOT NULL,
  `nameweight` varchar(25) NOT NULL,
  `meta1` varchar(255) NOT NULL,
  `meta2` varchar(255) NOT NULL,
  `headplace` int(1) NOT NULL,
  `headimage1` varchar(255) NOT NULL,
  `headimage2` varchar(255) NOT NULL,
  `headerheight` int(3) NOT NULL,
  `namefromtop` int(3) NOT NULL,
  `namefromleft` int(3) NOT NULL,
  `footerheight` int(3) NOT NULL,
  `footimage1` varchar(255) NOT NULL,
  `footimage2` varchar(255) NOT NULL,
  `usetoken` int(1) NOT NULL,
  `usesbalance` int(1) NOT NULL,
  `usesusername` int(1) NOT NULL,
  `flog1` int(255) NOT NULL,
  `flog2` int(255) NOT NULL,
  `flogmax` int(255) NOT NULL,
  `captcha` int(255) NOT NULL default '0',
  `ppemail` varchar(250) NOT NULL,
  `apemail` varchar(250) NOT NULL,
  `minicart` int(1) NOT NULL,
  `sidesale` int(1) NOT NULL,
  `sidesalelist` int(250) NOT NULL,
  `storemenu` int(1) NOT NULL,
  `scartbgc` varchar(50) NOT NULL,
  `scartmenubgc` varchar(50) NOT NULL,
  `testmode` int(3) NOT NULL,
  `fbgcolor` varchar(25) NOT NULL,
  `lhcolor` varchar(25) NOT NULL,
  `chcolor` varchar(25) NOT NULL,
  `listseperate` int(3) NOT NULL,
  `qnavcolor` varchar(25) NOT NULL,
  `samlpr` int(2) NOT NULL default '1',
  `minisearch` int(1) NOT NULL,
  `minisearchbgc` varchar(25) NOT NULL,
  `nav1` varchar(255) NOT NULL,
  `nav2` varchar(255) NOT NULL,
  `nav3` varchar(255) NOT NULL,
  `nav4` varchar(255) NOT NULL,
  `nav5` varchar(255) NOT NULL,
  `nav6` varchar(255) NOT NULL,
  `nav7` varchar(255) NOT NULL,
  `nav8` varchar(255) NOT NULL,
  `nav9` varchar(255) NOT NULL,
  `nav10` varchar(255) NOT NULL,
  `nav11` varchar(255) NOT NULL,
  `nav12` varchar(255) NOT NULL,
  `nav13` varchar(255) NOT NULL,
  `nav14` varchar(255) NOT NULL,
  `nav15` varchar(255) NOT NULL,
  `nav16` varchar(255) NOT NULL,
  `nav17` varchar(255) NOT NULL,
  `linkseper` varchar(255) NOT NULL default '&nbsp;|&nbsp;',
  `error1f` varchar(25) NOT NULL,
  `error1b` varchar(25) NOT NULL,
  `error2f` varchar(25) NOT NULL,
  `error2b` varchar(25) NOT NULL,
  `minilog` int(1) NOT NULL,
  `minilogbgc` varchar(25) NOT NULL,
  `m3_5width` int(5) NOT NULL,
  `tourswitch` int(2) NOT NULL,
  `tusedescript` text NOT NULL,
  `tusetitle` varchar(255) NOT NULL,
  `tcolor1` varchar(25) NOT NULL,
  `tcolor2` varchar(25) NOT NULL,
  `tcolor3` varchar(25) NOT NULL,
  `tcolor4` varchar(25) NOT NULL,
  `tborder` int(2) NOT NULL,
  `tmpl` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `site_tour` (
  `id` int(255) NOT NULL auto_increment,
  `sortorder` int(5) NOT NULL,
  `weblocal` int(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `descript` varchar(255) NOT NULL,
  `idefault` int(1) NOT NULL,
  `title` varchar(75) NOT NULL,
  `type` int(1) NOT NULL,
  `gid` int(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `site_tour_gallery` (
  `id` int(255) NOT NULL auto_increment,
  `sortorder` int(5) NOT NULL,
  `name` varchar(255) NOT NULL,
  `descript` text NOT NULL,
  `status` int(1) NOT NULL,
  `uid` int(255) NOT NULL,
  `weblocal` int(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `site_weblocal` (
  `id` int(255) NOT NULL,
  `name` varchar(255) NOT NULL
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `store_discounts` (
  `DiscountID` int(50) NOT NULL auto_increment,
  `disctype` varchar(10) NOT NULL default '',
  `discamount` float(10,2) NOT NULL default '0.00',
  `discat` float(10,2) NOT NULL default '0.00',
  `discto` float(10,2) NOT NULL default '0.00',
  `discper` varchar(20) NOT NULL default '',
  `discwhen` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`DiscountID`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `store_item_Areas` (
  `CategoryID` int(20) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `AreaName` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`CategoryID`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `store_item_categories` (
  `CategoryID` int(255) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `CategoryName` varchar(150) NOT NULL default '',
  `AreaNum` int(255) NOT NULL,
  PRIMARY KEY  (`CategoryID`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `store_item_subcategories` (
  `AreaID` int(250) NOT NULL,
  `weblocal` int(255) NOT NULL,
  `CategoryID` int(250) NOT NULL default '0',
  `SubcategoryID` int(250) NOT NULL auto_increment,
  `SubcategoryName` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`SubcategoryID`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `store_options` (
  `id` int(255) NOT NULL auto_increment,
  `name` varchar(125) NOT NULL,
  `cost` float(255,2) NOT NULL,
  `pid` int(255) NOT NULL,
  `oid` int(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `store_orders` (
  `OrderID` int(50) NOT NULL auto_increment,
  `memID` int(255) NOT NULL,
  `SubTotal` float NOT NULL default '0',
  `ShippingPrice` float NOT NULL default '0',
  `OrderTotal` float NOT NULL default '0',
  `OrderDiscount` float NOT NULL,
  `OrderStatus` varchar(20) NOT NULL,
  `OrderDate` int(15) NOT NULL default '0',
  `OrderTime` int(15) NOT NULL,
  `name` varchar(250) NOT NULL,
  `address` varchar(250) NOT NULL,
  `address2` varchar(250) NOT NULL,
  `city` varchar(250) NOT NULL,
  `state` varchar(250) NOT NULL,
  `country` varchar(250) NOT NULL,
  `zip` varchar(25) NOT NULL,
  `extraship` float NOT NULL,
  `tax` float NOT NULL,
  `paykey` varchar(250) NOT NULL,
  PRIMARY KEY  (`OrderID`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `store_orders_content` (
  `OrderID` varchar(32) NOT NULL default '',
  `OrderNum` int(255) NOT NULL,
  `ItemID` int(255) NOT NULL default '0',
  `ItemQty` int(1) NOT NULL default '0',
  `ItemNum` int(250) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `price` float(255,2) NOT NULL,
  `shipped` int(1) NOT NULL,
  `download` int(1) NOT NULL,
  `hosting` int(1) NOT NULL,
  `timedate` varchar(250) NOT NULL default '',
  `user` varchar(250) NOT NULL default '',
  `status` varchar(50) NOT NULL,
  `tracking` varchar(250) NOT NULL,
  `domain` varchar(250) NOT NULL,
  `howlong` int(255) NOT NULL,
  `renewprice` float NOT NULL,
  `hoststatus` int(2) NOT NULL,
  `renewid` int(250) NOT NULL,
  `dltype` int(2) NOT NULL,
  `o1` varchar(255) NOT NULL,
  `o2` varchar(255) NOT NULL,
  `o3` varchar(255) NOT NULL,
  `o4` varchar(255) NOT NULL,
  `o5` varchar(255) NOT NULL,
  `o6` varchar(255) NOT NULL,
  `o7` varchar(255) NOT NULL,
  `o8` varchar(255) NOT NULL,
  `o9` varchar(255) NOT NULL,
  `o10` varchar(255) NOT NULL,
  `oc1` float(255,2) NOT NULL,
  `oc2` float(255,2) NOT NULL,
  `oc3` float(255,2) NOT NULL,
  `oc4` float(255,2) NOT NULL,
  `oc5` float(255,2) NOT NULL,
  `oc6` float(255,2) NOT NULL,
  `oc7` float(255,2) NOT NULL,
  `oc8` float(255,2) NOT NULL,
  `oc9` float(255,2) NOT NULL,
  `oc10` float(255,2) NOT NULL,
  PRIMARY KEY  (`ItemNum`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `store_products` (
  `ItemID` int(255) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `status` int(1) NOT NULL,
  `stock` int(255) NOT NULL,
  `stocktype` int(1) NOT NULL,
  `shipped` int(1) NOT NULL,
  `hosting` int(1) NOT NULL,
  `download` int(1) NOT NULL,
  `ItemName` varchar(200) NOT NULL default '',
  `ItemArea` int(10) NOT NULL default '0',
  `ItemCategory` int(20) NOT NULL default '0',
  `ItemSubcategory` int(30) NOT NULL default '0',
  `ItemDescription` text NOT NULL,
  `sdescript` varchar(255) NOT NULL,
  `ItemPrice` float NOT NULL default '0',
  `ItemShipping` float NOT NULL default '0',
  `AddDate` int(255) NOT NULL default '0',
  `SalePrice` float NOT NULL default '0',
  `ListPrice` float NOT NULL default '0',
  `WSPrice` float NOT NULL default '0',
  `Shipper` varchar(250) NOT NULL default '',
  `ItemSID` varchar(250) NOT NULL default '',
  `sale` varchar(4) NOT NULL default 'NO',
  `featured` varchar(4) NOT NULL default 'NO',
  `howlong` int(250) NOT NULL,
  `whmname` varchar(250) NOT NULL,
  `server` int(250) NOT NULL,
  `renewprice` float NOT NULL,
  `dlname` varchar(255) NOT NULL,
  `demolink` varchar(250) NOT NULL,
  `demotype` varchar(1) NOT NULL,
  `dllink` varchar(250) NOT NULL,
  `dltype` varchar(1) NOT NULL,
  `delivmess` text NOT NULL,
  `dlpublisher` varchar(255) NOT NULL,
  `dlsdescript` varchar(255) NOT NULL,
  `dlDescription` text NOT NULL,
  `c1` varchar(255) NOT NULL,
  `c2` varchar(255) NOT NULL,
  `c3` varchar(255) NOT NULL,
  `c4` varchar(255) NOT NULL,
  `c5` varchar(255) NOT NULL,
  `c6` varchar(255) NOT NULL,
  `c7` varchar(255) NOT NULL,
  `c8` varchar(255) NOT NULL,
  `c9` varchar(255) NOT NULL,
  `c10` varchar(255) NOT NULL,
  `ct1` int(1) NOT NULL,
  `ct2` int(1) NOT NULL,
  `ct3` int(1) NOT NULL,
  `ct4` int(1) NOT NULL,
  `ct5` int(1) NOT NULL,
  `ct6` int(1) NOT NULL,
  `ct7` int(1) NOT NULL,
  `ct8` int(1) NOT NULL,
  `ct9` int(1) NOT NULL,
  `ct10` int(1) NOT NULL,
  `plimit` int(255) NOT NULL,
  PRIMARY KEY  (`ItemID`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `store_product_options` (
  `id` int(255) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `cost` float(255,2) NOT NULL,
  `pid` varchar(255) NOT NULL,
  `oid` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `store_taxes` (
  `taxid` int(250) NOT NULL auto_increment,
  `tax` float NOT NULL,
  `state` varchar(250) NOT NULL,
  `country` varchar(250) NOT NULL,
  PRIMARY KEY  (`taxid`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `tickets_categories` (
  `id` int(250) NOT NULL auto_increment,
  `cat` varchar(250) NOT NULL,
  `weblocal` int(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "INSERT INTO `tickets_categories` (`id`, `cat`, `weblocal`) VALUES
(1, 'Hosting Account Issues', 0),
(2, 'Shopping Cart Issues', 0),
(3, 'General Support Issues', 0),
(4, 'Billing Issues', 0)";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `tickets_reply` (
  `id` int(250) NOT NULL auto_increment,
  `replyby` int(250) NOT NULL,
  `tid` int(250) NOT NULL,
  `body` text NOT NULL,
  `replydate` int(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "CREATE TABLE IF NOT EXISTS `tickets_tickets` (
  `id` int(250) NOT NULL auto_increment,
  `weblocal` int(255) NOT NULL,
  `type` int(250) NOT NULL,
  `subject` text NOT NULL,
  `body` text NOT NULL,
  `status` int(1) NOT NULL,
  `startdate` int(250) NOT NULL,
  `enddate` int(250) NOT NULL,
  `priority` int(1) NOT NULL,
  `uid` int(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

 
echo"Creating MySQL tables complete. <br />";
echo"Populating MySql defualts. <br />";


$q1 = "INSERT INTO `dl_settings` (`dlopen`, `max`, `menulinks`, `side`, `mydlname`, `dlhistname`, `sidedlcolor`, `weblocal`) VALUES
(1, 0, 6, 1, 'My Downloads', 'Download History', '#dddddd', 0)";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "INSERT INTO `reg_settings` (`weblocal`, `pass`, `firstn`, `lastn`, `address`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax`, `refer`, `captcha`) VALUES
(1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "INSERT INTO `site_countries` (`id`, `weblocal`, `cname`, `usec`, `shipto`, `shipfee`) VALUES
(1, 0, 'United States', 0, 0, 100),
(2, 0, 'United Kingdom', 0, 1, 0),
(3, 0, 'Canada', 0, 0, 0),
(4, 0, 'Afghanistan', 0, 1, 0),
(5, 0, 'Albania', 0, 1, 0),
(6, 0, 'American Samoa', 0, 1, 0),
(7, 0, 'Andorra', 0, 1, 0),
(8, 0, 'Antigua', 0, 1, 0),
(9, 0, 'Argentina', 0, 1, 0),
(10, 0, 'Armenia', 0, 1, 0),
(11, 0, 'Australia', 0, 1, 0),
(12, 0, 'Austria', 0, 1, 0),
(13, 0, 'Azerbaijan', 0, 1, 0),
(14, 0, 'Bahrain', 0, 1, 0),
(15, 0, 'Bangladesh', 0, 1, 0),
(16, 0, 'Barbados', 0, 1, 0),
(17, 0, 'Belarus', 0, 1, 0),
(18, 0, 'Belgium', 0, 1, 0),
(19, 0, 'Belize', 0, 1, 0),
(20, 0, 'Belarus', 0, 1, 0),
(21, 0, 'Belgium', 0, 1, 0),
(22, 0, 'Belize', 0, 1, 0),
(23, 0, 'Bolivia', 0, 1, 0),
(24, 0, 'Bosnia-Herzegovina', 0, 1, 0),
(25, 0, 'Brazil', 0, 1, 0),
(26, 0, 'Brunei Darussalam', 0, 1, 0),
(27, 0, 'Bulgaria', 0, 1, 0),
(28, 0, 'Cambodia', 0, 1, 0),
(29, 0, 'Chile', 0, 1, 0),
(30, 0, 'China', 0, 1, 0),
(31, 0, 'Colombia', 0, 1, 0),
(32, 0, 'Costa Rica', 0, 1, 0),
(33, 0, 'Croatia', 0, 1, 0),
(34, 0, 'Cuba', 0, 1, 0),
(35, 0, 'Cyprus', 0, 1, 0),
(36, 0, 'Czech Republic', 0, 1, 0),
(37, 0, 'Denmark', 0, 1, 0),
(38, 0, 'Ecuador', 0, 1, 0),
(39, 0, 'Egypt', 0, 1, 0),
(40, 0, 'El Salvador', 0, 1, 0),
(41, 0, 'Estonia', 0, 1, 0),
(42, 0, 'Falkland Islands', 0, 1, 0),
(43, 0, 'Fiji', 0, 1, 0),
(44, 0, 'Finland', 0, 1, 0),
(45, 0, 'France', 0, 1, 0),
(46, 0, 'French Guyana', 0, 1, 0),
(47, 0, 'Georgia', 0, 1, 0),
(48, 0, 'Germany', 0, 1, 0),
(49, 0, 'Gibraltar', 0, 1, 0),
(50, 0, 'Greece', 0, 1, 0),
(51, 0, 'Greenland', 0, 1, 0),
(52, 0, 'Grenada', 0, 1, 0),
(53, 0, 'Guatemala', 0, 1, 0),
(54, 0, 'Honduras', 0, 1, 0),
(55, 0, 'Hong Kong', 0, 1, 0),
(56, 0, 'Hungary', 0, 1, 0),
(57, 0, 'Iceland', 0, 1, 0),
(58, 0, 'India', 0, 1, 0),
(59, 0, 'Indonesia', 0, 1, 0),
(60, 0, 'Iran', 0, 1, 0),
(61, 0, 'Iraq', 0, 1, 0),
(62, 0, 'Ireland', 0, 1, 0),
(63, 0, 'Israel', 0, 1, 0),
(64, 0, 'Italy', 0, 1, 0),
(65, 0, 'Japan', 0, 1, 0),
(66, 0, 'Jordan', 0, 1, 0),
(67, 0, 'Kazakhstan', 0, 1, 0),
(68, 0, 'Kenya', 0, 1, 0),
(69, 0, 'Kuwait', 0, 1, 0),
(70, 0, 'Kyrgyzstan', 0, 1, 0),
(71, 0, 'Laos', 0, 1, 0),
(72, 0, 'Latvia', 0, 1, 0),
(73, 0, 'Lebanon', 0, 1, 0),
(74, 0, 'Libya', 0, 1, 0),
(75, 0, 'Liechtenstein', 0, 1, 0),
(76, 0, 'Lithuania', 0, 1, 0),
(77, 0, 'Luxembourg', 0, 1, 0),
(78, 0, 'Malaysia', 0, 1, 0),
(79, 0, 'Maldives', 0, 1, 0),
(80, 0, 'Malta', 0, 1, 0),
(81, 0, 'Mauritius', 0, 1, 0),
(82, 0, 'Mexico', 0, 0, 0),
(83, 0, 'Mongolia', 0, 1, 0),
(84, 0, 'Morocco', 0, 1, 0),
(85, 0, 'Nepal', 0, 1, 0),
(86, 0, 'Netherlands', 0, 1, 0),
(87, 0, 'New Zealand', 0, 1, 0),
(88, 0, 'Nicaragua', 0, 1, 0),
(89, 0, 'North Korea', 0, 1, 0),
(90, 0, 'Norway', 0, 1, 0),
(91, 0, 'Oman', 0, 1, 0),
(92, 0, 'Pakistan', 0, 1, 0),
(93, 0, 'Panama', 0, 1, 0),
(94, 0, 'Paraguay', 0, 1, 0),
(95, 0, 'Peru', 0, 1, 0),
(96, 0, 'Philippines', 0, 1, 0),
(97, 0, 'Poland', 0, 1, 0),
(98, 0, 'Portugal', 0, 1, 0),
(99, 0, 'Puerto Rico', 0, 1, 0),
(100, 0, 'Qatar', 0, 1, 0),
(101, 0, 'Romania', 0, 1, 0),
(102, 0, 'Russian Federation', 0, 1, 0),
(103, 0, 'Saudi Arabia', 0, 1, 0),
(104, 0, 'Singapore', 0, 1, 0),
(105, 0, 'Slovak Republic', 0, 1, 0),
(106, 0, 'Slovenia', 0, 1, 0),
(107, 0, 'South Africa', 0, 1, 0),
(108, 0, 'South Korea', 0, 1, 0),
(109, 0, 'Spain', 0, 1, 0),
(110, 0, 'Sri Lanka', 0, 1, 0),
(111, 0, 'Sweden', 0, 1, 0),
(112, 0, 'Switzerland', 0, 1, 0),
(113, 0, 'Syria', 0, 1, 0),
(114, 0, 'Taiwan', 0, 1, 0),
(115, 0, 'Thailand', 0, 1, 0),
(116, 0, 'Tunisia', 0, 1, 0),
(117, 0, 'Turkey', 0, 1, 0),
(118, 0, 'Turkmenistan', 0, 1, 0),
(119, 0, 'Ukraine', 0, 1, 0),
(120, 0, 'United Arab Emirates', 0, 1, 0),
(121, 0, 'Uruguay', 0, 1, 0),
(122, 0, 'Uzbekistan', 0, 1, 0),
(123, 0, 'Venezuela', 0, 1, 0),
(124, 0, 'Vietnam', 0, 1, 0),
(125, 0, 'Yemen', 0, 1, 0),
(126, 0, 'Yugoslavia', 0, 1, 0),
(132, 0, 'Zimbabwe', 0, 1, 0) ";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "INSERT INTO `site_menu` (`id`, `menu`, `weblocal`, `l1`, `l2`, `l3`, `l4`, `l5`, `l6`, `l7`, `l8`, `l9`, `l10`, `l11`, `l12`, `l13`, `l14`, `l15`, `l16`, `l17`, `l18`, `l19`, `l20`, `l21`, `l22`, `l23`, `l24`, `l25`, `l26`, `l27`, `l28`, `l29`, `l30`, `l31`, `l32`, `l33`, `l34`, `l35`, `l36`, `l37`, `l38`, `l39`, `l40`, `l41`, `l42`, `m1`, `m2`, `m3`, `m4`, `m5`, `m6`, `m7`, `m8`, `m9`, `m10`, `m11`, `m12`, `m13`, `m14`, `m15`, `m16`, `m17`, `m18`, `m19`, `m20`, `m21`, `m22`, `m23`, `m24`, `m25`, `m26`, `m27`, `m28`, `m29`, `m30`, `m31`, `m32`, `m33`, `m34`, `m35`, `m36`, `m37`, `m38`, `m39`, `m40`, `m41`, `m42`) VALUES
(1, 0, 0, 'Home', 'Profile', 'Host', 'Shopping', 'Downloads', 'Referral Center', 'THC Features', 'What''s Comming', 'Affiliate', 'THC Video', '', 'Register', 'FAQ''s', 'Support', 'Contact Us', 'Terms of Use', 'Login', 'Logout', 'Downloads History', 'My Downloads', 'View Cart', 'Store History', 'My Profile', 'Update Profile', 'Ways To Earn', 'Referral Tools', 'My Stats', 'Payout', 'Create New Ticket', 'Open Tickets', 'Closed Tickets', 'General FAQ', '', 'Screen Shots', '', '', '', '', '', '', '', '', 9, 9, 0, 9, 9, 9, 9, 9, 14, 9, 0, 9, 14, 14, 14, 14, 9, 9, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 9, 0, 0, 0, 0, 0, 0, 0, 0)";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "INSERT INTO `site_settings` (`id`, `weblocal`, `name`, `email`, `copywrite`, `bgcolor`, `ffcolor`, `mlcolor`, `nlcolor`, `alcolor`, `lhfcolor`, `lhbgcolor`, `Rcolor1`, `Rcolor2`, `Rcolor3`, `Rcolor4`, `bordert`, `borders`, `borderh`, `borderf`, `borderc`, `borderm`, `noreg`, `lsidecont`, `rsidecont`, `Apadding`, `Spadding`, `seperate`, `sitewidth`, `pixper`, `lsidewidth`, `rsidewidth`, `hl1color`, `hl2color`, `sscolor`, `ssccolor`, `mcacolor`, `ptcolor`, `mcccolor`, `fl1color`, `fl2color`, `nlfcolor`, `nlbcolor`, `ml1color`, `ml2color`, `sbcolor`, `smbcolor`, `smfcolor`, `rscolor`, `rsccolor`, `logga`, `logge`, `loggcam`, `nameinhead`, `nameface`, `namecolor`, `namesize`, `nameweight`, `meta1`, `meta2`, `headplace`, `headimage1`, `headimage2`, `headerheight`, `namefromtop`, `namefromleft`, `footerheight`, `footimage1`, `footimage2`, `usetoken`, `usesbalance`, `usesusername`, `flog1`, `flog2`, `flogmax`, `captcha`, `ppemail`, `apemail`, `minicart`, `sidesale`, `sidesalelist`, `storemenu`, `scartbgc`, `scartmenubgc`, `testmode`, `fbgcolor`, `lhcolor`, `chcolor`, `listseperate`, `qnavcolor`, `samlpr`, `minisearch`, `minisearchbgc`, `nav1`, `nav2`, `nav3`, `nav4`, `nav5`, `nav6`, `nav7`, `nav8`, `nav9`, `nav10`, `nav11`, `nav12`, `nav13`, `nav14`, `nav15`, `nav16`, `nav17`, `linkseper`, `error1f`, `error1b`, `error2f`, `error2b`, `minilog`, `minilogbgc`, `m3_5width`, `tourswitch`, `tusedescript`, `tusetitle`, `tcolor1`, `tcolor2`, `tcolor3`, `tcolor4`, `tborder`, `tmpl`) VALUES
(1, 0, 'The Host Core', 'hide@address.com', '© Ethan Greer 2008-2009 All Rights Reserved', '#f5f5f5', '#BCED91', '#336633', '#009900', '#0066ff', '#0099ff', '#00cc66', '#ADC29A', '#B5CE9E', '#ADC29A', '#B5CE9E', 0, 0, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 1000, 0, 170, 170, '', '#D9E6BB', '', '#CECEC3', '', '#A5B893', '#CECEC3', '', '#D9E6BB', '', '', '', '#dddddd', '', '', '', '', '#CECEC3', 86400, 43200, 7200, 0, 3, '#oooooo', 28, '900', '', 'hosting, domains, hosting script, hosting business, scripts for sale, ethan is cool, domain business, hosting reseller, hosting account', 0, '', '', 0, 0, 10, 0, '', '', 1, 0, 0, 420, 600, 5, 1, 'hide@address.com', '', 0, 0, 3, 0, '#dddddd', '#dddddd', 1, '#CCD7C1', '#C2E1A5', '#93CC5F', 2, '#dddddd', 6, 0, '#dddddd', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ' | ', '#009900', '#FFFF66', '#FFFF00', '#FF3030', 0, '', 0, 1, '', '', '', '', '', '', 0, 0)";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);



 
require_once("./thc_i_fun.php");

 $t=time();
 $newsalt = Randkey();
 $ip=$_SERVER['REMOTE_ADDR'];

$newpassword1 = "$adminpass1$newsalt$sitesalt";
$newpassword = md5($newpassword1);
	$q1r = "insert into site_members set 
						username = '$adminuser',
						password = '$newpassword',
						clearance = '4',
						salt = '$newsalt',
						active = '1' ";



	mysql_query($q1r);
	$q1r = "insert into members_info set 
 	                   ID='1',
						regdate = '$t',
						regip = '$ip'
						 ";
	mysql_query($q1r);
	
	
	

	$q1r = "insert into ref_stats set 
 	                   id='1'
 	                   
						 ";
	mysql_query($q1r);
unlink("./thc_installer.php");
echo"Install is finished <a href=\"http://$siteurl/$index\">Click here to continue.</a>";
}else{ ?>

<br /><br />
<center><form method="post">Admin Username: <input type="text" name="username" value="<?=$_POST[username]?>"/><br />Admin Password: <input type="password" name="password"/><br /> Password: <input type="password" name="password2"/><br /><input type="hidden" name="step" value="2"/><input type="submit" value="Start Install"/></form></center>
<?	
}
?>











Return current item: The Host Core (THC)