| Referrers List
|
Help
Add Referrer
[DEL] will remove Referrer from this list. Contact Remains.
|
Log-in to Edit this list.");
}
?>
Error retrieving data from Referrers List.
" . "Error: ". mysql_error(). " |
");
}
$num_rows = mysql_num_rows($listem);
if($num_rows < 1){
echo("
| No Referrers in Data Base |
");
}else{
$list_act = @mysql_query("SELECT * FROM refcon WHERE status='Active'");
if (!$list_act) {
die("
Error retrieving Active Referrers.
" . "Error: ". mysql_error(). " |
");
}
$num_rowsa = mysql_num_rows($list_act);
if($num_rowsa < 1){
echo("
| No Active Referrers in Data Base |
");
}else{
echo("
");
while ($row = mysql_fetch_array($list_act)) {
$ID = $row['ID'];
$name_1 = $row['name_1'];
$name_2 = $row['name_2'];
$name = $name_1." ".$name_2;
$namestrlen = strlen($name);
$address = $row['address'];
$Company = $row['Company'];
$city = $row['city'];
$state = $row['state'];
$Country = $row['Country'];
if(in_array($state, $chcnt)){
$countryfried = "";
}else{
$countryfried = $Country;
}
$ZipCode = $row['ZipCode'];
$phone = $row['phone'];
$email = $row['email'];
$Link = $row['Link'];
$trak = $row['track'];
if($trak == "Yes"){
$linkmess = "
Web Ref: ".$Link."";
mysql_select_db('ecosmar_website', $dbcnx);
$getcount = mysql_query("SELECT count FROM webtrack WHERE RID='$ID'");
if(!$getcount){
$visits = "
Trak Error";
echo mysql_error();
}else{//got count
$rowc = mysql_fetch_array($getcount);
$visits = "
Visits: ".$rowc[0];
}//got count
}//trak is yes
else{//trak is no
$linkmess = "URL: ".$Link;
$visits = "";
}//trak is no
$pay = $row['pay'];
$rate = $row['rate'];
if($pay == 'no'){
$payto = 'No';
}elseif($pay == 'Per cent of Sale'){
$payto = $rate." Percent of Sale";
}elseif($pay == 'Per cent of Profit'){
$payto = $rate." Percent of Profit";
}elseif($pay == 'Flat Fee'){
$payto = "Flat Rate: \$".$rate;
}
$product = $row['product'];
$req_by = $row['req_by'];
$dtnum = $row['dtnum'];
$chunk_dtnum = chunk_split($dtnum, 2, ':');
$chunk_arr = explode(":", $chunk_dtnum);
$datus = $chunk_arr[2].'-'.$chunk_arr[3].'-'.$chunk_arr[0].$chunk_arr[1];
if($wh == 1){
echo("
" .
"[ Edit ]" .
" [ DEL ]" .
"
Rep: $req_by" .
"
Pay: $payto" .
"
Product: $product" .
" | ");
if($namestrlen > 2){
echo("$name_1 $name_2
");
}
echo("$Company
Ref ID: $ID" .
" | $address
$city
$state $countryfried $ZipCode" .
" | Phone: $phone
Email: $email
$linkmess $visits" .
" |
");
}else{
echo("
" .
"" .
"
Rep: $req_by" .
"
Product: $product" .
" | ");
if($namestrlen > 2){
echo("$name_1 $name_2
");
}
echo("$Company
Ref ID: $ID" .
" | $address
$city
$state $countryfried $ZipCode" .
" | Phone: $phone
Email: $email
$linkmess $visits" .
" |
");
}
}
}
mysql_select_db('ecosmar_contacts', $dbcnx);
$list_hld = @mysql_query("SELECT * FROM refcon WHERE status='Hold'");
if (!$list_hld) {
die("
Error retrieving Held Referrers.
" . "Error: ". mysql_error(). " |
");
}
$num_rowsh = mysql_num_rows($list_hld);
if($num_rowsh < 1){
echo("
| No Referrers on Hold in Data Base |
");
}else{
echo("
");
while ($row = mysql_fetch_array($list_hld)) {
$ID = $row['ID'];
$name_1 = $row['name_1'];
$name_2 = $row['name_2'];
$address = $row['address'];
$Company = $row['Company'];
$city = $row['city'];
$state = $row['state'];
$Country = $row['Country'];
if(in_array($state, $chcnt)){
$countryfried = "";
}else{
$countryfried = $Country;
}
$ZipCode = $row['ZipCode'];
$phone = $row['phone'];
$email = $row['email'];
$Link = $row['Link'];
$trak = $row['track'];
if($trak == "Yes"){
$linkmess = "
Web Ref: ".$Link."";
}else{
$linkmess = "URL: ".$link;
}
$pay = $row['pay'];
$rate = $row['rate'];
if($pay == 'no'){
$payto = 'No';
}elseif($pay == 'Per cent of Sale'){
$payto = $rate." Percent of Sale";
}elseif($pay == 'Per cent of Profit'){
$payto = $rate." Percent of Profit";
}elseif($pay == 'Flat Fee'){
$payto = "Flat Rate: \$".$rate;
}
$product = $row['product'];
$req_by = $row['req_by'];
$dtnum = $row['dtnum'];
$chunk_dtnum = chunk_split($dtnum, 2, ':');
$chunk_arr = explode(":", $chunk_dtnum);
$datus = $chunk_arr[2].'-'.$chunk_arr[3].'-'.$chunk_arr[0].$chunk_arr[1];
if($wh == 1){
echo("
" .
"[ Edit ]" .
" [ DEL ]" .
"
Rep: $req_by" .
"
Pay: $payto" .
"
Product: $product" .
" | ");
if($namestrlen > 2){
echo("$name_1 $name_2
");
}
echo("$Company
Ref ID: $ID" .
" | $address
$city
$state $countryfried $ZipCode" .
" | Phone: $phone
Email: $email
$linkmess" .
" |
");
}else{
echo("
" .
"" .
"
Rep: $req_by" .
"
Product: $product" .
" | ");
if($namestrlen > 2){
echo("$name_1 $name_2
");
}
echo("$Company
Ref ID: $ID" .
" | $address
$city
$state $countryfried $ZipCode" .
" | Phone: $phone
Email: $email
$linkmess" .
" |
");
}
}
}
}
$list_in = @mysql_query("SELECT * FROM refcon WHERE status='Inactive'");
if (!$list_in) {
die("
Error retrieving Inactive Referrers.
" . "Error: ". mysql_error(). " |
");
}
$num_rowsi = mysql_num_rows($list_in);
if($num_rowsi < 1){
echo("
| No Inactive Referrers in Data Base |
");
}else{
echo("
");
while ($row = mysql_fetch_array($list_in)) {
$ID = $row['ID'];
$name_1 = $row['name_1'];
$name_2 = $row['name_2'];
$address = $row['address'];
$Company = $row['Company'];
$city = $row['city'];
$state = $row['state'];
$Country = $row['Country'];
if(in_array($state, $chcnt)){
$countryfried = "";
}else{
$countryfried = $Country;
}
$ZipCode = $row['ZipCode'];
$phone = $row['phone'];
$email = $row['email'];
$Link = $row['Link'];
$trak = $row['track'];
if($trak == "Yes"){
$linkmess = "
Web Ref: ".$link."";
}else{
$linkmess = "URL: ".$link;
}
$pay = $row['pay'];
$rate = $row['rate'];
if($pay == 'no'){
$payto = 'No';
}elseif($pay == 'Per cent of Sale'){
$payto = $rate." Percent of Sale";
}elseif($pay == 'Per cent of Profit'){
$payto = $rate." Percent of Profit";
}elseif($pay == 'Flat Fee'){
$payto = "Flat Rate: \$".$rate;
}
$product = $row['product'];
$req_by = $row['req_by'];
$dtnum = $row['dtnum'];
$chunk_dtnum = chunk_split($dtnum, 2, ':');
$chunk_arr = explode(":", $chunk_dtnum);
$datus = $chunk_arr[2].'-'.$chunk_arr[3].'-'.$chunk_arr[0].$chunk_arr[1];
if($wh == 1){
echo("
" .
"[ Edit ]" .
" [ DEL ]" .
"
Rep: $req_by" .
"
Pay: $payto" .
"
Product: $product" .
" | ");
if($namestrlen > 2){
echo("$name_1 $name_2
");
}
echo("$Company
Ref ID: $ID" .
" | $address
$city
$state $countryfried $ZipCode" .
" | Phone: $phone
Email: $email
$linkmess" .
" |
");
}else{
echo("
" .
"" .
"
Rep: $req_by" .
"
Pay: $payto" .
"
Product: $product" .
" | ");
if($namestrlen > 2){
echo("$name_1 $name_2
");
}
echo("$Company
Ref ID: $ID" .
" | $address
$city
$state $countryfried $ZipCode" .
" | Phone: $phone
Email: $email
$linkmess" .
" |
");
}
}
}
?>
" .
"
" .
"