File: /var/www/html/tmpr/../tmpr/../tmpr/../tmpr/../tmpr/../v/register.php
<?php require("../const.inc.php");
include('../Connections/videoondemand.php');
$p = $_GET['p'];
$AppNo = $_GET['AppNo'];
if(!empty($AppNo)){ $AppNo = $_GET['AppNo'];}
if($_POST['doRegister'] == 'Join Now')
{
$p = $_GET['p'];
function filter($arr) {
global $link;
return array_map(array($link, 'real_escape_string'), $arr);
}
$_POST = filter($_POST);
session_start();
$number = $_POST['txtNumber'];
if (md5($number) == $_SESSION['image_random_value']) {
}
else
{
$err4 = urlencode("The security code you entered is incorrect");
header("Location: register.php?msg=$err4");
exit();
}
$user_ip = $_SERVER['REMOTE_ADDR'];
$md5pass = md5($_POST['pwd']);
$host = $_SERVER['HTTP_HOST'];
$host_upper = strtoupper($host);
$path = rtrim(dirname($_SERVER['PHP_SELF']), '/\\');
$activ_code = rand(1000,9999);
$user_name = mysqli_real_escape_string($link,$_POST['user_name']);
$slug = mysqli_real_escape_string($link,$_POST['user_name']);
$slug = preg_replace( '/[��""!?,.!@�$%^&*{};:()]+/', '', $slug);
$slug = strtolower($slug);
$slug=preg_replace('/[^A-Za-z0-9-]+/', '-', $slug);
$user_name = mysqli_real_escape_string($link,$_POST['user_name']);
$tel = mysqli_real_escape_string($link,$_POST['tel']);
$rs_duplicate2 = mysqli_query("select count(*) as total from users where tel='$tel'") or die(mysql_error());
list($total2) = mysql_fetch_row($rs_duplicate2);
if ($total2 > 0)
{
$err = urlencode("The phone or email already exists. Please try again with different passcode.");
header("Location: register.php?msg=$err");
exit();
}
echo $sql = "INSERT into `users` (`catalogname`,`catalogid`,`date`,`users_ip`,`activation_code`,`user_name`,`user_email`,`admin`,`gender`,`approved`,`slug`)
VALUES ('$catalogname','$catalogid',now(),'$user_ip','$activ_code','$username','$user_email','1','$gender','1','$user_name')";
mysqli_query($sql,$link) ;
echo $sql_insert = "INSERT into `users`
(`catalogname`,`user_name`,`pwd`,`tel`,`date`,`users_ip`,`activation_code`,`slug`
)
VALUES
('$_POST[user_name]','$_POST[user_name]','$md5pass','$tel',now(),'$user_ip','$activ_code'','$slug'
)
";
mysqli_query($sql_insert,$link) or die("Insertion Failed:" . mysql_error());
$user_id = mysql_insert_id($link);
$md5_id = md5($user_id);
mysqli_query("update users set md5_id='$md5_id' where catalogid='$user_id'");
// echo "<h3>Thank You</h3> We received your submission.";
/*
$sql_insert = "insert into catalog (catalogname,description,slug,parentid,picture) values ('$catalogname','$catalogname','$slug','$user_id','$user_id'";
mysqli_query($sql_insert,$link) or die("Insertion Failed:" . mysql_error());
*/
$message =
"
Hi $catalogname \n
Welcome to Eziki. \n Thank you for registering with our exciting website. \n You will need to confirm your
email address by clicking on the link provided below: \n
http://$host$path/activate.php?user=$md5_id&activ_code=$activ_code \n
Your Details \n
Username : $user_name \n
Password : $_POST[pwd] \n
Activation code: $activ_code \n
Thank You \n
Eziki Team
$host_upper
";
$usr_email2 = "info@eziki.tv";
mail($usr_email, "Welcome to Eziki", $message,
"From: \"Welcome to Eziki\" <auto-reply@$host>\r\n" .
"X-Mailer: PHP/" . phpversion());
if (!empty($p)){
header("Location: thankyou.php?p=$p&c=$c");
}
else
{
header("Location: thankyou.php");
}
exit();
}
?>
<html>
<title>Join</title>
<script type="text/javascript" src="../../videos/js/jquery.js"></script>
<script>
$(document).ready(function(){
$('#user_name').keyup(user_name_check);
});
$(document).ready(function(){
$('#catalogname').keyup(channel_check);
});
$(document).ready(function(){
$('#slug').keyup(slug_check);
});
/*----------------------------------------------------------------------------
*/
function slug_check(){
var slug = $('#slug').val();
if(slug == "" || slug.length < 4){
/*$('#user_name').css('border', '3px #CCC solid');*/
$('#okay-slug').hide();
}else{
jQuery.ajax({
type: "POST",
url: "check.php",
data: 'slug='+ slug,
cache: false,
success: function(response){
if(response == 1){
/*$('#user_name').css('border', '3px #C33 solid');*/
$('#okay-slug').hide();
$('#no-slug').fadeIn();
}else{
/*$('#user_name').css('border', '3px #090 solid');*/
$('#no-slug').hide();
$('#okay-slug').fadeIn();
}
}
});
}
}
/*----------------------------------------------------------------------------
*/
function channel_check(){
var catalogname = $('#catalogname').val();
if(catalogname == "" || catalogname.length < 4){
/*$('#user_name').css('border', '3px #CCC solid');*/
$('#okay-channel').hide();
}else{
jQuery.ajax({
type: "POST",
url: "check.php",
data: 'catalogname='+ catalogname,
cache: false,
success: function(response){
if(response == 1){
/*$('#user_name').css('border', '3px #C33 solid');*/
$('#okay-channel').hide();
$('#no-channel').fadeIn();
}else{
/*$('#user_name').css('border', '3px #090 solid');*/
$('#no-channel').hide();
$('#okay-channel').fadeIn();
}
}
});
}
}
/*----------------------------------------------------------------------------
*/
function user_name_check(){
var user_name = $('#user_name').val();
if(user_name == "" || user_name.length < 4){
/*$('#user_name').css('border', '3px #CCC solid');*/
$('#okay').hide();
}else{
jQuery.ajax({
type: "POST",
url: "check.php",
data: 'user_name='+ user_name,
cache: false,
success: function(response){
if(response == 1){
/*$('#user_name').css('border', '3px #C33 solid');*/
$('#okay').hide();
$('#no').fadeIn();
}else{
/*$('#user_name').css('border', '3px #090 solid');*/
$('#no').hide();
$('#okay').fadeIn();
}
}
});
}
}
</script>
<style>
/*#user_name{
padding:3px;
font-size:18px;
border:3px #CCC solid;
}*/
#okay{display:none}
#no{display:none}
#okay-channel{display:none}
#no-channel{display:none}
#okay-slug{display:none}
#no-slug{display:none}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<script language="JavaScript" type="text/javascript" src="js/jquery.validate.js"></script>
<!--<script type="text/javascript" src="js/jquery.validate.password.js"></script>-->
<script>
$(document).ready(function(){
$.validator.addMethod("username", function(value, element) {
return this.optional(element) || /^[a-z0-9\_]+$/i.test(value);
}, "Username must contain only letters, numbers, or underscore.");
$.validator.addMethod("slug", function(value, element) {
return this.optional(element) || /^[a-z0-9\_-]+$/i.test(value);
}, "Username must contain only letters, numbers, or underscore.");
$("#regForm").validate();
});
</script>
<style type="text/css">
<!--
.style6 {font-size: 12px}
-->
</style>
<link rel="stylesheet" href="../css/flexi-background.css" type="text/css" media="screen" />
<link rel="stylesheet" href="../css/styles.css" type="text/css" media="screen" />
</head>
<style type="text/css">
<!--
.style1 {font-size: 14px}
.style2 {font-size: 13px}
.style3 {font-weight: bold}
.centa {
text-align: center;
}
-->
</style><link href="<?php echo $siteaddress; ?>system/css/eziki.css" rel="stylesheet" type="text/css" />
<body style="background-image:url(a.jpg); background-position:center">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" height="100%" valign="top" >
<div id="box3" style="margin-top:100px" >
<table align="center" style="margin-left:80px;" width="504" border="0">
<tr>
<td style=" padding-top:80px; padding-right:20px">
<span id="heading" style=" color:#FFF;margin-bottom:15px">Join Now</span><br> <?php include("header.php"); ?>
<form action="register.php?p=<?php echo $p; ?>" method="post" name="regForm" id="regForm" >
<input type="text" onClick="this.value='';" onFocus="this.select()" onBlur="this.value=!this.value?'Choose Username':this.value;" value="Choose Username" name="user_name" class="required" /> <input type="text" onClick="this.value='';" onFocus="this.select()" onBlur="this.value=!this.value?'Your Phone':this.value;" value="Phone" name="tel" class="required" />
<input name="pwd" type="password" class="required" onclick="this.value='';" onFocus="this.select()" onBlur="this.value=!this.value?'Password':this.value;" value="Password">
<table width="100%" border="0">
<tr>
<td width="220"><input name="txtNumber" type="text" style="width:220px" id="txtNumber" onclick="this.value='';" onFocus="this.select()" onBlur="this.value=!this.value?'Enter Security This Code':this.value;" value="Enter Security Code" > </td>
<td valign="top" style="padding-top:3px"> <img src="randomImage.php" height="50" class="mypicha" style="margin-left:10px; -moz-border-radius : 3px 3px 3px 3px; -webkit-border-radius : 3px 3px 3px 3px; border-radius : 3px 3px 3px 3px; " ></td>
</tr>
</table>
<p style="font-size:10px; color:#FFF"><strong>By signing up, you agree to the <a href="terms.html">Terms </a> and <a href="terms.html">Privacy</a></strong></p>
<input name="doRegister" type="submit" style="margin-top:10px" value="Join Now" />
</form>
</td>
</tr>
</table>
<br>
<br>
<br>
<br><br>
<br>
<center style="font-size:12px"><a href="login.php" class="ezbutton">Sign in here</a></center>
</div>
</td></tr></table>
</body>
</html>