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' AND product='$product'");
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 for this level or product. |
" .
"| If you believe this is an error, please contact Eco-\$mart Administration. |
" .
"| Return |
" .
"
");
exit();
}
if($ref_warn == "Off" AND $level == "10" OR $level == "flat" OR $level == "product"){
$in = @mysql_query("INSERT INTO refcon_new SET name_1='$name_1',name_2='$name_2',Company='$Company',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" .
"COMPANY: $Company" .
"\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!
".
'Error:' . mysql_error() . '
');
}
}
}elseif($ref_warn == "Off" AND $level == "1"){
$in = @mysql_query("INSERT INTO refcon SET name_1='$name_1',name_2='$name_2',Company='$Company',address='$address',city='$city',state='$state',Country='$Country',ZipCode='$ZipCode',phone='$Phone',email='$email',req_by='$req_by',status='Active',pay='Per cent of Sale',rate='1.00',Link='$Link',track='$track',dtnum='$dtnum'");
if (!$in){
echo("
Error Registering Referrer. 2
" . "Error: ". mysql_error(). "
");
}else{
$riddick = mysql_insert_id();
$updy = mysql_query("UPDATE con_main SET ref_RID='$riddick' WHERE ID='$CID' LIMIT 1");
if(!$updy){
echo("
Could not assign Referrer Number.
Error: ".mysql_error()."
");
}else{
echo("
Sucessful Assignment of Referring ID: $riddick
");
}
$recipient = "info@ecosmartinc.com".","."kent@kwgrubbs.com";
$subject = "New Eco-\$mart Referrer Registration";
$message = "FROM: $req_by" .
"\n" .
"EMAIL: $usremail" .
"\n" .
"\n" .
"Referrer Status Registered for:" .
"\n" .
"NAME: $name_1 $name_2" .
"\n" .
"COMPANY: $Company" .
"\n" .
"EMAIL: $email" .
"\n" .
"DOMAIN: $Link" .
"\n" .
"\n" .
"To View Details or Edit this Registration:" .
"\n" .
"Go to http://www.ecosmartinc.com/ecos/contacts/refcon.php" .
"\n";
if(@mail($recipient, $subject, $message)){
echo("
Notice of Registration Sent to Administration
");
$Notes = "Registered for 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("
Successful Registration of Referrer
");
if($track == "Yes" AND $Link != ""){
mysql_select_db('ecosmar_website', $dbcnx);
$intrack = mysql_query("INSERT INTO webtrack SET RID='$RID',name_1='$name_1',name_2='$name_2',Company='$Company',email='$email',dom='$Link',count='0',dtup='$dtnum',dtnum='$dtnum'");
if(!$intrack){
echo("
Problem Starting Web Tracker
" .
"Error:" . mysql_error() . "
");
}else{
echo("
Web Tracker Started
");
}
}
}
}else{
echo ("
Error Sending Notice of Request!
".
'Error:' . mysql_error() . '
');
}
}
}else{
echo("
ERROR:
Could not Send Request or Register New Referral.
Not enough data.
Please contact Eco-\$mart Administration.
");
}
?>
