get_num_rows("SELECT * FROM dpg_affiliates WHERE username='".$user."'") >= 1){ array_push($errors,"USERNAME_EXISTS"); } if($msock->get_num_rows("SELECT * FROM dpg_affiliates WHERE email='".$email."'") >= 1){ array_push($errors,"EMAIL_EXISTS"); } if(count($errors) == 0){ $referrer = isset($_SESSION['affid']) ? $_SESSION['affid'] : -1; $notes = md5($username.$email.time()); if($msock->get_num_affected("INSERT INTO dpg_affiliates VALUES(null,'".$user."',PASSWORD('".$pass."'),'".$email."','".$paypal_email."',0,'".$first_name."','".$last_name."',null,'".$country."','".$city."',null,'".$notes."',".$referrer.",0,0)") == 1){ $registerOK = true; $affid = $msock->get_table_value("SELECT LAST_INSERT_ID() FROM dpg_affiliates"); //send him an email $confirmationUrl = getUrlAdress("activate.php?email=".urlencode($email)."&"."notes=".urlencode($notes)); sendRegistrationEmail($email,$confirmationUrl,$affid); //add to autoresponder addToAutoResponder($email,$first_name." ".$last_name,getValue("affiliates_autoresponder")); } else{ array_push($errors,"ERROR_OCCURED"); } } } $smarty = new Smarty; $smarty->compile_check = true; $smarty->debugging = false; $smarty->assign("lang",$_LANG); $smarty->assign("errors",translate($errors)); $smarty->assign("loggedin",$_APP['loggedin']); //populate already submitted values $smarty->assign("user",$user); $smarty->assign("pass",$pass); $smarty->assign("pass2",$pass2); $smarty->assign("email",$email); $smarty->assign("paypal_email",$paypal_email); $smarty->assign("adress",$adress); $smarty->assign("city",$city); $smarty->assign("first_name",$first_name); $smarty->assign("last_name",$last_name); $smarty->assign("registerOK",$registerOK); $smarty->display("register.tpl"); include_once('footer.inc.php'); ?>