<?php
include("header.htm");
set_time_limit(120);

echo '<p>Connectiong to MySQL server <br>';
$dbName = $db;    //database name
$userName = $dbuser;   //User name
$password = $dbpass;   //Password
$localHost = $dbhost;      //Server

//Connecting to MySQL
if (!mysql_connect($localHost, $userName, $password))
{
   echo '<p>Error while trying to connect to MySQL'.mysql_error ; 
   exit ;
}
echo '<p>Connected !'; 
// selecting the database 
if (mysql_select_db($dbName))
{
   echo '<p>Database exists';
}
else
{
   //Creating the database
   echo '<p>Creating Database ..... '; 
   if ( !mySQL_query('Create Database if not exists '. $dbName))
   {
       echo 'Error creating the Databse'; 
       exit ;
   }
   mysql_close();       //closing the connection
   if (!mysql_connect($localHost, $userName, $password))  //connecting again in order to refresh the server with new database if created
   {
       echo '<p>Error while trying to connect to MySQL '.mysql_error ;
       exit ;
   }
   mysql_select_db($dbName);
}
 echo '<p>Creating tables............';


 echo '<p>Creating table `control_panel`';
if(!mysql_query("CREATE TABLE `control_panel` (
  `adminname` varchar(50) NOT NULL,
  `adminemail` varchar(100) NOT NULL,
  `adminpass` varchar(50) default NULL,
  `timezone` int(4) default NULL,
  `language_pack` varchar(10) default NULL,
  `email_method` varchar(10) default NULL,
  `smtp_host` varchar(50) default NULL,
  `smtp_port` int(5) default NULL,
  `js_detection` int(2) default NULL,
  `display_warning` int(2) default NULL,
  `autodel_files` int(2) default NULL,
  `autodel_info` int(2) default NULL,
  `autodel_dir` int(2) default NULL,
  `subdir` varchar(10) default NULL,
  `subdir_field` varchar(10) default NULL,
  `existing` varchar(10) default NULL,
  `thankyoumsg` text,
  `redirecturl` varchar(255) default NULL,
  `moreuploads` varchar(10) default NULL,
  `sendconfirmation` char(10) default NULL,
  `confirmtitle` varchar(255) default NULL,
  `confirmmsg` text,
  `confirmfrom` varchar(255) default NULL,
  `notification` char(10) default NULL,
  `includelinks` varchar(10) default NULL,
  `attachments` varchar(10) default NULL,
  `attachmaxsize` varchar(20) default NULL,
  `notifyemails` varchar(255) default NULL,
  `formprotect` varchar(10) default NULL,
  `formpass` varchar(255) default NULL,
  `takeip` varchar(10) default NULL,
  `banned_ips` text,
  `phpcode` text,
  `header` text,
  `footer` text,
  `fieldsize` varchar(10) default NULL,
  `displayinfo` varchar(25) default NULL,
  `showrequired` varchar(10) default NULL,
  `fonttype` varchar(50) default NULL,
  `fontsizel` varchar(10) default NULL,
  `fontsizes` varchar(10) default NULL,
  `extmode` varchar(10) default NULL,
  `extensions` text,
  `limitsize` varchar(10) default NULL,
  `sizemin` int(10) default NULL,
  `sizemax` int(10) default NULL,
  `limitdim` varchar(10) default NULL,
  `widthmin` int(10) default NULL,
  `widthmax` int(10) default NULL,
  `heightmin` int(10) default NULL,
  `heightmax` int(10) default NULL,
  `uploademail` varchar(255) default NULL,
  `uploadname` varchar(255) default NULL,
  `euname` varchar(50) default NULL,
  `epass` varchar(50) default NULL,
  `upload_dir` varchar(255) NOT NULL,
  `sty` varchar(255) default NULL,
  `form_name` varchar(255) default NULL,
  `location` varchar(255) default NULL,
  `progress` varchar(255) default NULL,
  `weather` varchar(255) default NULL,
  `uformprotect` varchar(255) default NULL,
  `allowed_domains` text,
  `public_reg` char(1) default NULL,
  `site_name` varchar(255) default NULL,
  `base_folder` varchar(255) default NULL,
  `bk_dir` varchar(255) default NULL,
  `last_bk_date` varchar(20) default NULL,
  `bk_scheduler` char(1) default NULL)")){
  
	echo  "<br> ".mysql_error();}
else{
		echo  "<br> done";
	}

 echo '<p>inserting recordts into `control_panel` table';

$sql1 = "insert  into control_panel values 
('".$adminuser."', '".$adminemail."', '".$adminpass."', 7, '', 'smtp', '127.0.0.1', 25, 1, 0, 2, 1, 1, 'none', '-1', 'addnumber', '<P>&nbsp;</P>\r\n<P align=center><STRONG><FONT color=#000066 size=5>Thank you for Your Submission.</FONT></STRONG></P>', '', '', '', 'Form Submission Confirmation', 'Thank you for your submission', '', '1', '1', 'only', '27', '', '', '12345', '1', '127.0.0.1', 'upload_form.php', '<P align=center><IMG style=\"WIDTH: 766px; HEIGHT: 139px\" alt=\"\" hspace=0 src=\"images/banner.jpg\" align=baseline border=1></P>', '<P align=center>Powered By <A href=\"http://www.phpscriptz.net/\">EasyUploader</A></P>', '20', 'description', '0', 'Verdana, Arial, Helvetica, sans-serif', '13px', '10px', 'only', '', '1', 0, 300000, '1', 0, 1000, 0, 1000, '', '-1', 'smtpuser', 'smtpp', 'files', 'Professional', 'Please fill the following form', '', '4', '', '', '', '', '".$sitetitle."', '".$basefolder."', 'backup', '02-Apr-2008', 'y');";



if(!mysql_query("$sql1"))
{
echo "<br>" . mysql_error();
}
else
{echo  "<br> done";}



echo '<p>Creating table `fields`';
$sql2 = "CREATE TABLE `fields` (
  `fid` int(10) NOT NULL auto_increment,
  `seq` int(10) ,
  `name` varchar(255) NOT NULL ,
  `fdesc` varchar(255) ,
  `type` varchar(255) ,
  `req` tinyint(1) ,
  `value` text,
  `dvalue` varchar(255) ,
  `min` varchar(255) ,
  `max` varchar(255) ,
  PRIMARY KEY  (`fid`)
) ";
if(!mysql_query($sql2))
{echo  mysql_error();}
else
{echo  "<br> done";}


  echo '<p>Creating table `uploads`';
  $sql3 = " CREATE TABLE `uploads` (
  `id` int(10) NOT NULL auto_increment,
  `upload_id` int(10) NOT NULL ,
  `name` varchar(255) ,
  `value` text NOT NULL,
  `type` varchar(255) NOT NULL ,
  `dt` datetime NOT NULL ,
  `path` varchar(255) ,
  `size` varchar(255) ,
  `desc` varchar(255) ,
  PRIMARY KEY  (`id`)
)";
if(!mysql_query($sql3))
{echo  mysql_error();}
{echo  "<br> done";}

$sql4 = "CREATE TABLE `uploads_master` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `email` varchar(255) ,
  `dt` datetime NOT NULL ,
  `desc` varchar(255) NOT NULL ,
  PRIMARY KEY  (`id`)
)";
 echo '<p>Creating table `uploads_master`';
if(!mysql_query($sql4))
{echo  mysql_error();}
 else
{echo  "<br> done";}

$sql5 = "CREATE TABLE `users` (
  `uid` int(10) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `pass1` varchar(255) NOT NULL default '',
  `fname` varchar(255) default NULL,
  `lname` varchar(255) default NULL,
  `code` varchar(255) default NULL,
  `status` int(11) default NULL,
  PRIMARY KEY  (`uid`)
) ";
 echo '<p>Creating table users';
if(!mysql_query($sql5))
{echo  mysql_error();}
else
{echo  "<br> done";}
 echo '<p>inserting recordts into `users` table';

mysql_query("INSERT INTO `users` VALUES (10,'".$adminuser."',  '".$adminemail."','".$adminpass."','Admin','Admin',0,1)");

$sql6 = "create table if not exists  `uploadtousers` (UserName varchar(255) NOT NULL, UMId int(11) NOT NULL)" ;
 echo '<p>Creating table uploadtousers';
if(!mysql_query($sql6))
{echo  mysql_error();}
else
{echo  "<br> done";}