Error checking for Duplicate Referrers. 2
" . "Error: ". mysql_error(). "");
}
$num_rowsfn = mysql_num_rows($checkref_new);
if($num_rowsfn >= 1 or $num_rowsfn != ""){
$ref_mssg = 'New Referrer List';
$ref_warn = "On";
}
$checkref = @mysql_query("SELECT ID FROM refcon WHERE name_1='$name_1' AND name_2='$name_2' AND email='$email'");
if (!$checkref) {
echo("
Error checking for Duplicate Referrers. 3
" . "Error: ". mysql_error(). "
");
}
$num_rowsf = mysql_num_rows($checkref);
if($num_rowsf >= 1 or $num_rowsf != ""){
$ref_mssg = 'Referrer List';
$ref_warn = "On";
}
if($ref_warn == "On"){
echo("
" .
"| Contact cannot be added as a Referrer. |
" .
"
" .
"| $name_1 $name_2 is currently on the $ref_mssg. |
" .
"| If you believe this is an error, please contact Eco-$mart Administration. |
" .
"| Return |
" .
"
");
exit();
}
if($ref_warn == "Off"){
$in = @mysql_query("INSERT INTO refcon_new SET name_1='$name_1',name_2='$name_2',address='$address',city='$city',state='$state',Country='$Country',ZipCode='$ZipCode',phone='$Phone',email='$email',req_by='$req_by',level='$level',Link='$Link',track='$track',dtnum='$dtnum'");
if (!$in){
echo("
Error adding to New Referrer List. 2
" . "Error: ". mysql_error(). "
");
}else{
$recipient = "info@ecosmartinc.com";
$subject = "Request for New Eco-\$mart Referrer";
$message = "FROM: $req_by" .
"\n" .
"EMAIL: $usremail" .
"\n" .
"\n" .
"Requesting Referrer Status for:" .
"\n" .
"NAME: $name_1 $name_2" .
"\n" .
"EMAIL: $email" .
"\n" .
"DOMAIN: $Link" .
"\n" .
"\n" .
"To View Details, Confirm or Deny this Request:" .
"\n" .
"Go to http://www.ecosmartinc.com/ecos/contacts/refcon.php" .
"\n";
if(@mail($recipient, $subject, $message)){
echo("
Notice of Request Sent to Administration
");
$Notes = "Requested Referrer Status";
$makenote = mysql_query("INSERT INTO con_notes SET CID='$CID',Notes='$Notes',usrn='$usrn',dtnum='$dtnum'");
if(!$makenote){
echo("
Could not add event to contact notes.
Error: " . mysql_error() . '
');
}
}else{
echo ("
Error Sending Notice of Request!
");
}
}
}
?>
