<?php

include ("header.php");
include ("connect.php");

// check if user logged in
if (isset($_SESSION['logged'])){
header("Location: home.php");
exit();
}

//$filename = "pageviewsindex.txt";
//$count= file($filename);
//$count[0]++;
//$file = fopen ($filename, "w");
//fputs($file, "$count[0]");
//fclose($file);



//include 'counter/counter.php';



$e = "";
$er = 0;


if (isset($_POST['submit'])){

echo $_GET['id'];
$username = mysql_real_escape_string($_POST['username']);
$email = mysql_real_escape_string($_POST['email']);
$youtube = mysql_real_escape_string($_POST['youtube']);
$password = mysql_real_escape_string($_POST['password']);


$e = "Closed";
$er ++;


if (!$username || !$email || !$youtube || !$password){
	$e = "<font color='red' size='2' face='sans-serif'><b>All fields are required!</b></font>";
	$er ++;
}



if ($username && $email && $youtube && $password){


   $sql = mysql_query("SELECT * FROM users WHERE username = '$username'");

   $nums = mysql_num_rows($sql);

   $sqll = mysql_query("SELECT * FROM users WHERE channel = '$youtube'");
   $count = mysql_num_rows($sqll);



if ($nums > 0 || $count > 0){
	$e = "<font color='red' size='2' face='Sans-Serif'><b>Username/Channel Already Taken</font></b>";
	$er ++;
}else{


	$ip = $_SERVER['REMOTE_ADDR'];
	$date = date("Y-m-d");

    if (isset($_GET['ref'])){
	$ref = $_GET['ref'];
	$sql = mysql_query("INSERT INTO users VALUES ('','$username','$ref','','$youtube','$youtube','0','0','$email','$password','$ip','$date','0','0')");
    }else{
	$sql = mysql_query("INSERT INTO users VALUES ('','$username','','','$youtube','$youtube','0','0','0','$email','$password','$ip','$date','0','','$date')");
    header("Location: login.php");
	}
  }
 }
}
?>
<div class="content">


<?php
if (isset($_GET['ref'])){
?>
<form action="register.php?ref=<?php echo $_GET['ref']; ?>" method="POST">
<?php
}else{
?>
<form action="register.php" method="POST">
<?php
}
?>
<br />
<table align="center">
<tr><td>
<font color="666666" face="Sans-Serif" size="4">Registration</font>
<br /><br />
</td>
</tr>
<tr><td>

		<label>Username</label>
		</td><td>
		<input class="searchbox" type="text" name="username">
		</td></tr>
		<tr><td>
		<label>Email Address</label>
		</td><td>
		<input class="searchbox" type="text" name="email">
		</td></tr>
		<tr><td>
		<label>Youtube Channel</label>
		</td><td>
		<input class="searchbox"" type="text" name="youtube">
		</td></tr>
		<tr><td>
		<label>Password</label>
		</td><td>
		<input class="searchbox" type="password" name="password">
		</td></tr>
		<tr><td>
		<br />
	<input class="searchbutton" type="submit" name="submit" value="Register Account"  />
		</td><?php
if ($er != 0){
echo "<td><br />&nbsp;".$e."</td>";
}
?></tr>
		</table>

	<hr style="width: 99%; height: 2px; border: none; background: #F3F3F3;">

</form>

</div>
<?php
include("footer.php");
?>

<style>

</style>