$dnum = date(Ymd)*4;
$from = $_GET['fr'];
if($from == ""){
$from = $_POST['fr'];
}
if($from != $dnum){
echo("<<<<Restricted Area>>>>" .
"
Sorry, you must Log In to view this Page
");
exit();
}
$usrn = $_GET['usrn'];
if($usrn == ""){
$usrn = $_POST['usrn'];
}
if($usrn == ""){
echo("<<<<Restricted Area>>>>" .
"
Problem with your username. Please Log In again.
");
exit();
}
$first_Name = stripslashes($_POST['first_Name']);
$Name = stripslashes($_POST['Name']);
$Title = stripslashes($_POST['Title']);
$Company = stripslashes($_POST['Company']);
$biztype = $_POST['biztype'];
$Phone = $_POST['Phone'];
$Address = stripslashes($_POST['Address']);
$FAX = $_POST['FAX'];
$City = stripslashes($_POST['City']);
$email = $_POST['email'];
$price_level = $_POST['price_level'];
if($price_level == "Wholesale"){
$price_level_name = "Consumer";
}else{
$price_level_name = "Contractor/Dealer";
}
$referred_by = $_POST['referred_by'];
$referee = explode(':', $referred_by);
$referrer = $referee[1];
$ref_name = $referee[2];
$refer = $_POST['refer'];
$mkt = $_POST['mkt'];
$State = $_POST['State'];
$Country = $_POST['Country'];
$ZipCode = $_POST['ZipCode'];
$alt_con = $_POST['alt_con'];
$alt_title = $_POST['alt_title'];
$alt_email = $_POST['alt_email'];
$Link = $_POST['Link'];
$act_month = $_POST['act_month'];
$act_day = $_POST['act_day'];
$act_year = $_POST['act_year'];
$contact_type = $_POST['contact_type'];
$act_respond = $_POST['act_respond'];
$react_month = $_POST['react_month'];
$react_day = $_POST['react_day'];
$react_year = $_POST['react_year'];
$Notes = stripslashes($_POST['Notes']);
$dtnum = $_POST['dtnum'];
$dtup = $_POST['dtup'];
$pswcon = $_POST['pswcon'];
$usremail = $_POST['usremail'];
$repname1 = $_POST['repname1'];
$repname2 = $_POST['repname2'];
$namer = $repname1.' '.$repname2;
$today = date("F j, Y");
$year = date(Y);
$dtnum = date(Ymd);
$y1 = $year + 1;
$y2 = $year + 2;
$y3 = $year + 3;
if($mkt != 1){
$mkt = 0;
$mktw = 'No';
}else{
$mktw = 'Yes';
}
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_contacts', $dbcnx);
$listem = @mysql_query("SELECT ID,usrn FROM con_main WHERE email='$email' AND Address='$Address'");
if (!$listem) {
die('Error checking for duplicates.
Error: '. mysql_error(). '
');
}
$num_rows = mysql_num_rows($listem);
$dupe = mysql_fetch_array($listem);
$dupeID = $dupe[0];
$dupeusrn = $dupe[1];
?>
|
Eco-$mart, Inc. On-line Administration
|
if($num_rows >= 1 or $num_rows != ""){
echo("" .
"This is a Duplicate Contact |
" .
"
" .
"A Contact at that address is currently registered to $dupeusrn. |
" .
"If you believe this is an error, please contact Eco-\$mart Administration. |
" .
"Return |
" .
"
");
exit();
}
?>
©2007 - Data Base Interface - Custom Built at:
|