<?php
if(@$_POST['user']){
//Get Posts
$protocal=$_POST['protocal'];
$domain=$_POST['domain'];
$directory=$_POST['directory'];
$dbname=$_POST['dbname'];
$dblocation=$_POST['dblocation'];
$dbuname=$_POST['dbuname'];
$dbpassword=$_POST['dbpassword'];
$name=$_POST['name'];
$user=$_POST['user'];
$email=$_POST['email'];
$password=$_POST['password'];
$gender=$_POST['gender'];
$birthday=$_POST['month']. '/'. $_POST['day']. '/'. $_POST['year'];
$date=date("m.d.y"); 
$time=date('h:i:s A');
setcookie("username", $user, time()+530500);

//create config file
$config=fopen('../config.php','w');
fwrite($config, "<?php $". "db='". $dbname. "';
$". "dbuser='". $dbuname. "';
$". "dbloc='". $dblocation. "';
$". "dbpass='". $dbpassword. "';
$". "site='". $protocal. $domain. "/". $directory. "/';
?>
");

mysql_connect($dblocation, $dbuname, $dbpassword);
mysql_select_db($dbname);

////////////////Create video Categories
//Create Category list
mysql_query("CREATE TABLE allgenres( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), userid VARCHAR(200), vname VARCHAR(200), description VARCHAR(300), date VARCHAR(100), privacy VARCHAR(100), fname VARCHAR(200), downloads VARCHAR(100), likes VARCHAR(100), image CHAR(50), duration CHAR(50), category CHAR(50))"); 
mysql_query("CREATE TABLE categories( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(200), videos VARCHAR(200), date VARCHAR(300), ctn VARCHAR(300))"); 
//Start Inserting Categories into categories Table and create the Category Table for video insers
$userdbname='categories';
$result = mysql_query("SHOW TABLE STATUS LIKE '$userdbname'");
$rowbb = mysql_fetch_array($result);
$categories = 'categories'. $rowbb['Auto_increment'];
mysql_query("INSERT INTO categories(name, videos, date, ctn) VALUES('Action', '0', '$date', '$categories')"); 
mysql_query("CREATE TABLE action( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), userid VARCHAR(200), vname VARCHAR(200), description VARCHAR(300), date VARCHAR(100), privacy VARCHAR(100), fname VARCHAR(200), downloads VARCHAR(100), likes VARCHAR(100), image CHAR(50), duration CHAR(50), nextid CHAR(50))"); 
//User Database
mysql_query("CREATE TABLE users( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(300), user VARCHAR(100), password VARCHAR(60), date VARCHAR(100), time VARCHAR(100), gender VARCHAR(100), birthday VARCHAR(100), email VARCHAR(100), pictureid VARCHAR(100), usertype VARCHAR(100))"); 
mysql_query("INSERT INTO users(name, user, password, date, time, gender, birthday, email, pictureid, usertype) VALUES('$name', '$user', '$password', '$date', '$time', '$gender', '$birthday', '$email', 'nophoto.bmp','User')"); 
//////////////Create Favorites Playlist
//Create Table with List of Playlists
$userdbname=$user.'playlist';

//Create Favorites Table
mysql_query("CREATE TABLE $userdbname( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), userid VARCHAR(100), title VARCHAR(100), date VARCHAR(100), views VARCHAR(100), nextid VARCHAR(100))"); 
//Get allgenres id
$result = mysql_query("SHOW TABLE STATUS LIKE '$userdbname'");
$row = mysql_fetch_array($result);
$nextid = $row['Auto_increment']; 
$userfavorites=$_COOKIE['username'].$nextid;
mysql_query("INSERT INTO $userdbname(userid, title, date, views, nextid) VALUES('admin', 'Favorites', 'September 29 2014', '0', '$nextid')"); 
mysql_query("CREATE TABLE $userfavorites( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), userid VARCHAR(100), allgenreid VARCHAR(100))"); 
header("Location:". $protocal. $domain. "/". $directory. "/index.php");
}
?>
<centeR>
<a href="http://software.melerovideo.com"><img src="http://www.meleronews.com/video/logo.png" alt="Melero video" title="Melero Video"></a><P>
<b>Welcome to the MV Video Sharing Software Installation Wizard!</b><P>

For installation help and support visit our website at <a href="http://www.melerovideo.com/software">www.melerovideo.com/software</a>
<P>
Please enter the following information to get started:<P>
<P><table align=center bgcolor=white cellpadding=0 cellspacing=0 border=1 bordercolor=blue>
<tr>
<td width=90% align=center bgcolor=white>
<table width=100% align=center><form action="index.php" METHOD="post"><b>Website Details
<tr><td width=65% align=center><input type=text size=38 placeholder="Protocal (Ex: http://)" name=protocal></td></tr>
<tr><td width=65% align=center><input type=text size=38 placeholder="Domain (Ex: melerovideo.com)" name=domain></td></tr>
<tr><td width=65% align=center><input type=text size=38 placeholder="Directory (Ex: directory/)" name=directory></td></tr>
</td></tr></table>

<table width=100% align=center><b>Database Details (Please create a database first and enter the DB below.)
<tr><td width=65% align=center><input type=text size=38 size=30 placeholder="Database Name (Ex: MVDB)" name=dbname></td></tr>
<tr><td width=65% align=center><input type=text size=38 placeholder="Database Location (Ex: localhost)" name=dblocation></td></tr>
<tr><td width=65% align=center><input type=text size=38 placeholder="Database User Name (Ex: root)" name=dbuname></td></tr>
<tr><td width=65% align=center><input type=text size=38 placeholder="Database Password (Ex: password123" name=dbpassword></td></tr>
</td></tr></table>

<table width=100% align=center>
<b>Admin Details</b>
<tr><td width=65% align=center><input type=text placeholder="First & Last Name" name=name></td></tr>
<tr><td width=65% align=center><input type=hidden name=user value="admin"></td></tr>
<tr><td width=65% align=center><input type=text placeholder="Email" name=email></td></tr>
<tr><td width=65% align=center><input type=text placeholder="Password" name=password></td></tr>
<tr><td width=65% align=center>Gender: <select name=gender><option value="Female">Female</option><option value="Male">Male</option></select></td></tr>
<tr><td width=65% align=center><select name=month>
<option value="January">January</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
<option value="June">June</option>
<option value="July">July</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="October">October</option>
<option value="November">November</option>
<option value="December">December</option>
</select>
<select name=day>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name=year>
<option value="2007">2007</option>
	<option value="2006">2006</option>
	<option value="2005">2005</option>
	<option value="2004">2004</option>
	<option value="2003">2003</option>
	<option value="2002">2002</option>
	<option value="2001">2001</option>
	<option value="2000">2000</option>
	<option value="1999">1999</option>
	<option value="1998">1998</option>
	<option value="1997">1997</option>
	<option value="1996">1996</option>
	<option value="1995">1995</option>
	<option value="1994">1994</option>
	<option value="1993">1993</option>
	<option value="1992">1992</option>
	<option value="1991">1991</option>
	<option value="1990">1990</option>
	<option value="1989">1989</option>
	<option value="1988">1988</option>
	<option value="1987">1987</option>
	<option value="1986">1986</option>
	<option value="1985">1985</option>
	<option value="1984">1984</option>
	<option value="1983">1983</option>
	<option value="1982">1982</option>
	<option value="1981">1981</option>
	<option value="1980">1980</option>
	<option value="1979">1979</option>
	<option value="1978">1978</option>
	<option value="1977">1977</option>
	<option value="1976">1976</option>
	<option value="1975">1975</option>
	<option value="1974">1974</option>
	<option value="1973">1973</option>
	<option value="1972">1972</option>
	<option value="1971">1971</option>
	<option value="1970">1970</option>
	<option value="1969">1969</option>
	<option value="1968">1968</option>
	<option value="1967">1967</option>
	<option value="1966">1966</option>
	<option value="1965">1965</option>
	<option value="1964">1964</option>
	<option value="1963">1963</option>
	<option value="1962">1962</option>
	<option value="1961">1961</option>
	<option value="1960">1960</option>
	<option value="1959">1959</option>
	<option value="1958">1958</option>
	<option value="1957">1957</option>
	<option value="1956">1956</option>
	<option value="1955">1955</option>
	<option value="1954">1954</option>
	<option value="1953">1953</option>
	<option value="1952">1952</option>
	<option value="1951">1951</option>
	<option value="1950">1950</option>
	<option value="1949">1949</option>
	<option value="1948">1948</option>
	<option value="1947">1947</option>
	<option value="1946">1946</option>
	<option value="1945">1945</option>
	<option value="1944">1944</option>
	<option value="1943">1943</option>
	<option value="1942">1942</option>
	<option value="1941">1941</option>
	<option value="1940">1940</option>
	<option value="1939">1939</option>
	<option value="1938">1938</option>
	<option value="1937">1937</option>
	<option value="1936">1936</option>
	<option value="1935">1935</option>
	<option value="1934">1934</option>
	<option value="1933">1933</option>
	<option value="1932">1932</option>
	<option value="1931">1931</option>
	<option value="1930">1930</option>
	<option value="1929">1929</option>
	<option value="1928">1928</option>
	<option value="1927">1927</option>
	<option value="1926">1926</option>
	<option value="1925">1925</option>
	<option value="1924">1924</option>
	<option value="1923">1923</option>
	<option value="1922">1922</option>
	<option value="1921">1921</option>
	<option value="1920">1920</option>
	<option value="1919">1919</option>
	<option value="1918">1918</option>
	<option value="1917">1917</option>
	<option value="1916">1916</option>
	<option value="1915">1915</option>
	<option value="1914">1914</option>
	<option value="1913">1913</option>
	<option value="1912">1912</option>
	<option value="1911">1911</option>
	<option value="1910">1910</option>
	<option value="1909">1909</option>
	<option value="1908">1908</option>
	<option value="1907">1907</option>
	<option value="1906">1906</option>
	<option value="1905">1905</option>
	<option value="1904">1904</option>
	<option value="1903">1903</option>
	<option value="1902">1902</option>
	<option value="1901">1901</option>
	<option value="1900">1900</option>
</select>
</td></tr><tr><td width=65% align=center><input type=submit value="Install"></td></tr></form></table>
</td></table>
<?php include("../headerbottom.php"); ?>

