CREATE TABLE IF NOT EXISTS `users` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`first_name` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
`last_name` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
`address` VARCHAR(60) COLLATE utf8_unicode_ci NOT NULL,
`city` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL,
`state` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL,
`zip_code` INT(10) NOT NULL,
`birth_month` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
`birth_day` VARCHAR(2) COLLATE utf8_unicode_ci NOT NULL,
`birth_year` VARCHAR(4) COLLATE utf8_unicode_ci NOT NULL,
`phone` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
`email` VARCHAR(75) COLLATE utf8_unicode_ci NOT NULL,
`username` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
`password` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
`security_question` VARCHAR(60) COLLATE utf8_unicode_ci NOT NULL,
`security_answer` VARCHAR(60) COLLATE utf8_unicode_ci NOT NULL,
`stage_name` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL,
`ad_phone` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
`ad_phone2` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
`gender` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
`sexuality` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL,
`age` INT(3) NOT NULL,
`height` VARCHAR(5) COLLATE utf8_unicode_ci NOT NULL,
`weight` VARCHAR(8) COLLATE utf8_unicode_ci NOT NULL,
`hair` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
`eye` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
`ethnicity` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL,
`available` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL,
`ad_location` VARCHAR(60) COLLATE utf8_unicode_ci NOT NULL,
`ad_type` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
`call_type` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
`website` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
`introduction` LONGTEXT COLLATE utf8_unicode_ci NOT NULL,
`comments` LONGTEXT COLLATE utf8_unicode_ci NOT NULL,
`DATE` DATE NOT NULL,
`random` INT(20) NOT NULL,
`activated` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

<?php
echo "<h1>Register</h1>";
 
$submit = $_POST['submit'];
 
//form data
$firstname = strip_tags($_POST['first_name']);
$lastname = strip_tags($_POST['last_name']);
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$zipcode = $_POST['zip_code'];
$birthmonth = $_POST['birth_month'];
$birthday = $_POST['birth_day'];
$birthyear = $_POST['birth_year'];
$phone = $_POST['phone'];
$email = $_POST['email'];
$username = strtolower(strip_tags($_POST['username']));
$password = strip_tags($_POST['password']);
$repeatpassword = strip_tags($_POST['repeatpassword']);
$securityquestion = $_POST['security_question'];
$securityanswer = $_POST['security_answer'];
$stagename = strip_tags($_POST['stage_name']);
$adphone = $_POST['ad_phone'];
$adphone2 = $_POST['ad_phone2'];
$gender = $_POST['gender'];
$sexuality = $_POST['sexuality'];
$age = $_POST['age'];
$height = $_POST['height'];
$weight = $_POST['weight'];
$hair = $_POST['hair'];
$eye = $_POST['eye'];
$ethnicity = $_POST['ethnicity'];
$available = $_POST['available'];
$adlocation = $_POST['ad_location'];
$adtype = $_POST['ad_type'];
$calltype = $_POST['call_type'];
$website = $_POST['website'];
$introduction = strip_tags($_POST['introduction']);
$comments = strip_tags($_POST['comments']);
$date = date("Y-m-d");
 
if ($submit)
{
 
//open database
$connect = mysql_connect("localhost","un","pass");
mysql_select_db("db"); //select database
 
$namecheck = mysql_query("SELECT username FROM users WHERE username='$username'");
$count = mysql_num_rows($namecheck);
 
if ($count!=0)
{
die("Username already taken!");
}
 
//check for existance
if ($firstname&&$lastname&&$address&&$city&&$state&&$zip_code&&$birthmonth&&
$birthday&&$birthyear&&$phone&&$email&&$username&&$password&&$repeatpassword&&
$securityquestion&&$security_answer&&$stagename&&$adphone&&$adphone2&&$gender&&
$sexuality&&$age&&$height&&$weight&&$hair&&$eye&&$ethnicity&&$available&&
$adlocation&&$adtype&&$calltype&&$website&&$introduction)
{
 
if ($password==$repeatpassword)
{
 
//check char length of username
if (strlen($username)>25)
{
echo "Length of username is too long!";
}
else
{
 
//check password length
if (strlen($password)>25¦¦strlen($password)<6)
{
echo "Password must be between 6 and 25 characters";
}
else
{
//register the user!
 
// encrypt password
$password = md5($password);
$repeatpassword = md5($repeatpassword);
 
//generate random number for activation process
$random = rand(23456789,98765432);
 
$queryreg = mysql_query("INSERT INTO users VALUES ('','$firstname','$lastname','$address','$city','$state','$zipcode','$birthmonth',
'$birthday','$birthyear','$phone','$email','$username','$password',
'$securityquestion','$securityanswer','$stagename','$adphone','$adphone2',
'$gender','$sexuality','$age','$height','$weight','$hair','$eye','$ethnicity',
'$available','$adlocation','$adtype','$calltype','$website','$introduction',
'$comments','$date','$random','0')");
 
$lastid = mysql_insert_id();
 
//send activation email
$to = $email;
$subject = "Activate your account!";
$headers = "From: [email]support@mysite.net[/email]";
$server = "mail.mysite.net";
 
ini_set("SMTP",$server);
 
$body = "
 
Hello $first_name $last_name,\n\n
 
You need to activate your account with the link below:
http://www.mysite.net/register/activate.php?id=$lastid&code=$random\n\n
 
Thanks!
 
";
 
//function to send email
mail($to, $subject, $body, $headers);
 
die("You have been registered! Check your email to activate your account!");
 
}
 
}
 
}
else
echo "Your passwords do not match!";
 
}
else
echo "Please fill in <b>all</b> fields!";
 
}
 
?>

<?php
 
$connect = mysql_connect("localhost","un","pass") or die("Couldn't connect!");
mysql_select_db("db") or die("Couldn't find db");
 
$id = $_GET['id'];
$code = $_GET['code'];
 
if ($id&&$code)
{
 
$check = mysql_query("SELECT * FROM users WHERE id='$id' AND random='$code'");
$checknum = mysql_num_rows($check);
 
if ($checknum==1)
{
 
//run a query to activate the account
$acti = mysql_query("UPDATE users SET activated='1' WHERE id='$id'");
die("Your account is activated. You may now log in.");
 
}
else
die("Invalid ID or Activation code.");
 
}
else
die("Data missing!");
 
?>

mysql_query($sql) or die("Query failed: ".mysql_error());

insert into cfair_deals (deal_affid, deal_storeid, deal_catid, subcat_id, deal_type, deal_title, deal_url,   	 deal_coupon_code,deal_coupon_file,deal_start_date,deal_expire_date,deal_promotion,deal_expire,deal_barcode,deal_price,deal_oldprice,deal_discount, deal_pricecurrency,deal_oldcurrency,deal_image, deal_shortdesc,deal_fulldesc,deal_topcoupon,deal_hotweek,deal_status,added_on) VALUES (
'$aff_id', '$store_id', '$cat_id', '$categoryname', '$deal_type', '$deal_title', '$deal_url', '$coupon_code','$couponfilename','$sdate', '$edate','$promotion','$expdate','$bar_code','$price','$old_price','$discount','$price_currency','$oldprice_currency','$filename','$short_desc', '$long_desc','$top_coupon','$hot_coupon', '$status',now())