<?php

include '../inc/sqlinf.php';

mysql_query ("
CREATE TABLE `CLIENTS` (
  `ID` int(11) NOT NULL auto_increment,
  `PAYER_EMAIL` varchar(255) NOT NULL,
  `PACKAGE` varchar(255) NOT NULL,
  `SIGNUPDATE` varchar(50) default NULL,
  `IG` varchar(255) NOT NULL,
  `CPW` varchar(50) NOT NULL,
  `LASTPAYMENT` varchar(50) default NULL,
  `STATUS` varchar(50) NOT NULL,
  `NEXTPAYMENT` varchar(50) NOT NULL,
  `USERNAME` varchar(255) NOT NULL,
  `DOMAIN` varchar(255) NOT NULL,
  `UNI` varchar(10) NOT NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;
")  or die (mysql_error());
#
# Dumping data for table `CLIENTS`
#


# --------------------------------------------------------

#
# Table structure for table `FREEHOSTING`
#
mysql_query ("
CREATE TABLE `FREEHOSTING` (
  `ID` int(11) NOT NULL auto_increment,
  `FREE` varchar(50) NOT NULL default 'NO',
  `SYN` varchar(50) NOT NULL default 'NO',
  `SUB` varchar(255) NOT NULL default 'yourdomain.com',
  `NAME` varchar(255) NOT NULL,
  `WHMNAME` varchar(255) NOT NULL,
  `FROOM` varchar(255) NOT NULL,
  `SUBJECT` varchar(255) NOT NULL,
  `MESSAGE` text NOT NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
")  or die (mysql_error());
#
# Dumping data for table `FREEHOSTING`
#

$sql = "INSERT INTO `FREEHOSTING` VALUES (1, 'NO', 'NO', '', '', '', '', '', '')";
$query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());
# --------------------------------------------------------

#
# Table structure for table `HOSTINGPACKAGES`
#
mysql_query ("
CREATE TABLE `HOSTINGPACKAGES` (
  `ID` int(11) NOT NULL auto_increment,
  `NAME` varchar(255) NOT NULL,
  `WHMNAME` varchar(255) NOT NULL,
  `MONTHLY` varchar(50) NOT NULL,
  `QUARTERLY` varchar(50) NOT NULL,
  `SEMIANNUALLY` varchar(50) NOT NULL,
  `ANNUALLY` varchar(50) NOT NULL,
  `2YEARS` varchar(50) NOT NULL,
  `FREETRIAL` varchar(50) NOT NULL,
  `YY` varchar(50) NOT NULL,
  `NN` varchar(50) NOT NULL,
  `FROOM` varchar(255) NOT NULL,
  `SUBJECT` varchar(255) NOT NULL,
  `MESSAGE` text NOT NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;
")  or die (mysql_error());
#
# Dumping data for table `HOSTINGPACKAGES`
#


# --------------------------------------------------------

#
# Table structure for table `MAILINGLIST`
#
mysql_query ("
CREATE TABLE `MAILINGLIST` (
  `ID` int(11) NOT NULL auto_increment,
  `PAYER_EMAIL` varchar(255) NOT NULL,
  `PRODUCT` varchar(255) NOT NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
")  or die (mysql_error());
#
# Dumping data for table `MAILINGLIST`
#


# --------------------------------------------------------

#
# Table structure for table `SETTINGS`
#
mysql_query ("
CREATE TABLE `SETTINGS` (
  `USERNAME` varchar(255) NOT NULL,
  `PASSWORD` varchar(255) NOT NULL,
  `URL` varchar(255) NOT NULL,
  `PATH` varchar(255) NOT NULL,
  `ADMINIP` varchar(255) NOT NULL,
  `ID` int(11) NOT NULL auto_increment,
  `HOST` varchar(255) NOT NULL default 'localhost',
  `RAK` text NOT NULL,
  `USER` varchar(255) NOT NULL,
  `RECEIVER_EMAIL` varchar(255) NOT NULL,
  `CURRENCY` varchar(255) NOT NULL,
  `LOGO_URL` varchar(255) NOT NULL,
  `SUCCESS_URL` varchar(255) NOT NULL,
  `CANCEL_URL` varchar(255) NOT NULL,
  `WSU` varchar(255) NOT NULL,
  `SUBDOMAIN` varchar(255) NOT NULL,
  `DNR` varchar(255) NOT NULL,
  `S_SIGNUP` text NOT NULL,
  `S_CANCEL` text NOT NULL,
  `S_MODIFY` text NOT NULL,
  `S_FAILURE` text NOT NULL,
  `S_PAYMENT` text NOT NULL,
  `S_EOT` text NOT NULL,
  `AUTOTERM` varchar(50) NOT NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
")  or die (mysql_error());
#
# Dumping data for table `SETTINGS`
#

$sql = "INSERT INTO `SETTINGS` VALUES
(
'$aun',
'$apw',
'$ip',
'',
'',
1,
'localhost',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'NO')
";
$query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());

?>

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
<!--
function MM_goToURL() { //v3.0
  var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}
//-->
</script>
</head>

<body bgcolor="#FFFFFF" text="#000000" onLoad="MM_goToURL('parent','../admin/');return document.MM_returnValue">
</body>
</html>

