session_start(); if(($_SESSION['security_code'] == $_POST['security_code']) && (!empty($_SESSION['security_code'])) ) { $firstname = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$firstname); $lastname = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$lastname); $company = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$company); $address1 = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$address1); $address2 = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$address2); $citystatezip = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$citystatezip); $country = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$country); $phone = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$phone); $email = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$email); $email1 = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$email1); $password = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$password); $password1 = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$password1); $itpro = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$itpro); $itshop = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$itshop); $boss = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$boss); $partner = preg_replace("%[^-=_., 0-9A-Za-z@]%","",$partner); $joinip = $REMOTE_ADDR; $joindate = date("D, M j, Y"); $title = "SBS Show Fan Club"; include('header.asp'); mysql_connect("localhost","sbsshowmemberdb","32gA9qVm1SZ6dkG") or die("Temporary Maintenance - Please check back later."); mysql_select_db("memberssbsshowcom") or die("Unable to select database"); # No dupes, fill. $addMember = mysql_query(" insert into members (firstname,lastname,company,address1,address2,citystatezip,country,phone,email,password,itpro,itshop,boss,partner,joindate,joinip) values ('$firstname','$lastname','$company','$address1','$address2','$citystatezip','$country','$phone','$email','$password','$itpro','$itshop','$boss','$partner','$joindate','$joinip') ") or die (mysql_error()); ?>
Welcome to the SBS Show Club!
The next time we release an episode or publish a newsletter you will be getting an email from us. Thank you for taking the time to join us.
| First Name: | =$firstname ?> |
| Last Name: | =$lastname ?> |
| Company: | =$company ?> |
| Address (Line 1): | =$address1 ?> |
| Address (Line 2): | =$address2 ?> |
| City/State/etc..: | =$citystatezip ?> |
| Country: | =$country ?> |
| Phone: | =$phone ?> |
| Email: | =$email ?> |
| Password: | =$password ?> |