assign("MESSAGE", "Fill in the required fields."); } elseif ($_POST["password"] != $_POST["password2"]) { $tpl->assign("MESSAGE", "The passwords are not equal."); } else { $ms = quote($_POST["ms"]); $fname = quote($_POST["fname"]); $lname = quote($_POST["lname"]); $email = quote($_POST["email"]); $password = quote($_POST["password"]); $addr = quote($_POST["addr"]); $city = quote($_POST["city"]); $state = quote($_POST["state"]); $zip = quote($_POST["zip"]); $phone = quote($_POST["phone"]); $country = quote($_POST["country"]); $bmonth = quote($_POST["bmonth"]); $bday = quote($_POST["bday"]); $byear = quote($_POST["byear"]); $sec_quest = quote($_POST["sec_quest"]); $sec_answer = quote($_POST["sec_answer"]); $like_reminder = intval($_POST["like_reminder"]); $bdate = $bmonth . "/" . $bday . "/" . $byear; $sql = "SELECT 1 FROM `" . TBL_USERS . "` WHERE `email`='". $email ."' AND `active`=1 LIMIT 1;"; $data_query = mysql_query($sql); if (mysql_num_rows($data_query)) { $tpl->assign("MESSAGE", "Sorry but this login already exist"); } else { $id = mysql_query("SELECT `email` FROM `panel_users` WHERE name = 'admin'"); $adarr = mysql_fetch_array($id); $curLot = mysql_result(mysql_query("SELECT id FROM " . TBL_LOTS . " ORDER BY `sort_id` DESC"),0); $curLot = "'[".stripslashes($curLot)."]'"; $sql = "INSERT INTO `". TBL_USERS ."` ( `ms` , `first_name` , `last_name` , `email` , `password` , `addr` , `city` , `state` , `zip` , `phone` , `country` , `birth_date` , `like_reminder` , `ip` , `regdate` , `from_cat` , `sec_quest` , `sec_answer`) VALUES ('$ms' , '$fname' , '$lname' , '$email' , '$password' , '$addr' , '$city' , '$state' , '$zip' , '$phone' , '$country' , '$bdate' , $like_reminder , '${_SERVER['REMOTE_ADDR']}' , NOW() , $curLot , '$sec_quest' , '$sec_answer');"; $data_query = mysql_query($sql); if ($data_query) { $tpl->assign("MESSAGE", "Congratulations! You successfully register and you can Log In on main page."); $msg = " New user has been registered on weeklysweepstakes.com! User data: $ms $fname $lname --------- E-mail: $email Address: $addr City: $city State: $state ZIP: $zip Phone: $phone Country: $country Birth Date: $bdate IP: ${_SERVER['REMOTE_ADDR']} ------------------------- This message generated automaticaly "; mail($adarr["email"], "weeklysweepstakes.com: New user has been registered", $msg); $msg2user = " This email is to confirm your registration at weeklysweepstakes.com. Thanks for joining and good luck! Regards, Weeklysweepstakes.com "; mail($email, "weekly sweepstakes registration confirmation.", $msg2user); } } } } $tpl->define(array("page" => "form.htm")); $Y = intval(date("Y")); $addstr = ""; for ($i=$Y-100; $i<$Y-17; $i++) { $addstr .= "$i"; } $tpl->assign("ALL_YEARS", $addstr); require("banners.php"); $tpl->parse($result, "page"); $tpl->FastPrint($result); include ("footer.php"); ?>