<?
// fix for fix pay
// 21-04-2001 promo banners fix
// 02-01-2001 version | countries patch + host alias

require ("db_cfg.php3");
require ("banned_cfg.php3");

////////////////////////////////////////
// functions
////////////////////////////////////////

function no_banner($msg='')
{
   global $DefaultURLs,$t;
   if (empty($DefaultURLs[$t])) $t='ban1';
   // print "sdfsdf"; exit();

   header("Location: ".$DefaultURLs[$t]);
   exit();
}

function promo_banner() {

       global $n, $HTTP_COOKIE_VARS, $rawip, $dns,$refer,$country;

       $bid=$HTTP_COOKIE_VARS["AD${n}BID"];
       $pid=$HTTP_COOKIE_VARS["AD${n}PID"];

       if (empty($bid)) {
  
           no_banner();
    
       };


       if (in_array($GLOBALS['h'],$GLOBALS['banned_hosts'])) {

 	    Header("Location: ".$GLOBALS['banned_click']."\n\n");
	    exit();

       };


       $res = @mysql_db_query($GLOBALS['DataBase'],"
         SELECT bid,url,image
         FROM   promobanners
         WHERE  bid='$bid'
         ");

       if (!(list($bid,$url,$image)=@mysql_fetch_array($res)))
          no_banner();

         // update banner for promos

        $res = @mysql_db_query($GLOBALS['DataBase'],"UPDATE promobanners SET tc=tc+1,mc=mc+1,dayc=dayc+1 WHERE bid='$bid'");

        // insert stats for promo banners

         $res = @mysql_db_query($GLOBALS['DataBase'],"
	  REPLACE INTO promobanners_clicks (bid,ip,ref,ct,dt,dns)
 	  VALUES ('$bid','$rawip','$refer','$country',NOW(),'$dns')
          ");


         setcookie("PRAD${n}${bid}${pid}",'DONE!',$Cdata,$Cpath);

         $url=parse_macro($url);

	 header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");             // Date in the past
	 header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
	 header("Cache-Control: no-cache, must-revalidate");         // HTTP/1.1
	 header("Pragma: no-cache");                                 // HTTP/1.0
	 header("Location: $url");
	 exit();

};

///////////////////////////////////////////////////////
// main code
////////////////////////////////////////

      // get IP logging data

      $dns = isset($REMOTE_HOST) ? $REMOTE_HOST : @gethostbyaddr($REMOTE_ADDR);
      if ($dns == $REMOTE_ADDR) $dns='unknown';
      $dnslist = preg_split("/\./", $dns);
      $country = $dnslist[count($dnslist)-1];
      $countryid = isset($countries["$country"]) ?  $countries["$country"] : $countries["xz"];
      $country  = isset($countriestext["$country"]) ? $country : 'xz';

      $ippart = preg_split("/\./", $REMOTE_ADDR);
      $rawip  = pack("C4",$ippart[0],$ippart[1],$ippart[2],$ippart[3]);
      $rawip  = addslashes($rawip);
      $refer  = isset($HTTP_REFERER) ? $HTTP_REFERER : 'unknown';

      // referer pass through iFRAME - 13-02-01

      $iframeref="r".$GLOBALS['REMOTE_ADDR'];
      $iframeref=preg_replace("/\./", "_", $iframeref);
      $iframeref=${$iframeref};

      if (!empty($iframeref)) 
         $refer=base64_decode($iframeref);
 

      //////////////////////////////////////////////////////////////
      // connect to mysql

      $link = mysql_pconnect($GLOBALS['DBhost'], $GLOBALS['DBuser'],$GLOBALS['DBpwd']) or mysql_die();

      // check for valid hostname

      if(!isset($h)) {
        promo_banner();
      }

      // get user details

      $res = mysql_db_query($GLOBALS['DataBase'],"SELECT hid,refhost,allowcpm,allowcpc,allowpopup,cat1 FROM hosts WHERE login='$h' AND status='active'") or mysql_die();

      if(mysql_num_rows($res) == 0) {

          promo_banner();
    
      } else {

        list($hid,$refhost,$allowcpm,$allowcpc,$allowpopup,$category) = mysql_fetch_array($res);
        if (strlen($refhost)<1) $refhost='';
      };


     if ($allowcpm==0 && $allowcpc==0 && $allowpopup==0)
        $program='';


   // checking CPM/CPC types

   if (!empty($program)) {

       // allowcpm patch
       if ($allowcpm==0 && $allowpopup==0) $program='click';

       // get pid and bid from client cookie

       $bid=$HTTP_COOKIE_VARS["AD${n}BID"];
       $pid=$HTTP_COOKIE_VARS["AD${n}PID"];

       if (empty($bid) || empty($pid)) {
  
           promo_banner();
    
       };

       // checking for Promotion banners entry
     
       if ($HTTP_COOKIE_VARS["PRAD${n}${bid}${pid}"]=='yes') {

            promo_banner();

       };


    // running CPM program - just log click without ip saving

    if ($program=='cpm') {


      //  print "HERE we are!";

      // just logging non-unique IPs

         $res = mysql_db_query($GLOBALS['DataBase'],"
         SELECT bid,url,image
         FROM   banners
         WHERE  bid='$bid' AND pid='$pid'
         ");

         if (!(list($bid,$url,$image)=mysql_fetch_array($res)))
             promo_banner();


         // all ok - update offers
         $res = mysql_db_query($GLOBALS['DataBase'],"UPDATE offers SET tc=tc+1,mc=mc+1,dayc=dayc+1 WHERE pid='$pid'");

         // update banner
         $res = mysql_db_query($GLOBALS['DataBase'],"UPDATE banners SET tc=tc+1,mc=mc+1,dayc=dayc+1 WHERE pid='$pid' AND bid='$bid'");

         // try to update host stats in applydb 
         $res = mysql_db_query($GLOBALS['DataBase'],"UPDATE applydb SET tc=tc+1,mc=mc+1,dayc=dayc+1 WHERE hid='$hid' AND pid='$pid'");

         setcookie("PRAD${n}${bid}${pid}",'no',$Cdata,$Cpath);


	 $url=parse_macro($url);

	 header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");             // Date in the past
	 header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
	 header("Cache-Control: no-cache, must-revalidate");         // HTTP/1.1
	 header("Pragma: no-cache");                                 // HTTP/1.0
	 header("Location: $url");
	 exit();

      // CPM program finished 


      } else if ($program=='click') {


       $res = mysql_db_query($GLOBALS['DataBase'],"
       SELECT bid,advid,pid,url,image
       FROM   banners
       WHERE  bid='$bid' AND pid='$pid'
       ");

       if (!(list($bid,$advid,$pid,$url,$image)=mysql_fetch_array($res)))
           promo_banner();
           
       // check banner for UNIQUEness (based on uniquess for the whole offer)

       $res = mysql_db_query($GLOBALS['DataBase'],"
	SELECT ip
	FROM   clickdb
	WHERE  bid = '$pid' AND ip = '$rawip'	
       ");


       if(mysql_num_rows($res) > 0)    {

          // skip any view saving
          // disable this update?

          $res = mysql_db_query($GLOBALS['DataBase'],"
	  UPDATE clickdb SET count=count+1 
 	  WHERE  bid='$pid' AND ip='$rawip' AND hid='$hid'
          ");

          // print "double!";


       } else {

          // have fun here :) 
 
          $res = mysql_db_query($GLOBALS['DataBase'],"
	  REPLACE INTO clickdb (bid,ip,hid,ref,ct,dt,count,dns)
 	  VALUES ('$pid','$rawip','$hid','$refer', '$country',NOW(),'1','$dns')
          ");

         // get host price from offer (for one click - it will be the same for all hosts)

         $res = mysql_db_query($GLOBALS['DataBase'],"SELECT hprice FROM offers WHERE pid = '$pid' AND status='active'");

         if (!(list($hprice)=mysql_fetch_array($res)))
            promo_banner();

         // all ok - update offers
         $res = mysql_db_query($GLOBALS['DataBase'],"UPDATE offers SET tc=tc+1,mc=mc+1,dayc=dayc+1,monthspent=monthspent+price WHERE pid='$pid'");

         // update banner
         $res = mysql_db_query($GLOBALS['DataBase'],"UPDATE banners SET tc=tc+1,mc=mc+1,dayc=dayc+1 WHERE pid='$pid' AND bid='$bid'");

         // try to update host stats in applydb  - it has to exist!!!

         $res = mysql_db_query($GLOBALS['DataBase'],"UPDATE applydb SET tc=tc+1,mc=mc+1,dayc=dayc+1,monthrevenue=monthrevenue+price WHERE hid='$hid' AND pid='$pid'");

	 // update refdb for referrals 
	 if (!empty($refhost)) {
             $res = mysql_db_query($GLOBALS['DataBase'],"UPDATE refdb SET amount=amount+'$hprice' WHERE refer='$refhost' AND referred='$h'");
         }; 

      }; // if unique

 
         setcookie("PRAD${n}${bid}${pid}",'no',$Cdata,$Cpath);


	 $url=parse_macro($url);

	 header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");             // Date in the past
	 header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
	 header("Cache-Control: no-cache, must-revalidate");         // HTTP/1.1
	 header("Pragma: no-cache");                                 // HTTP/1.0
	 header("Location: $url");
	 exit();

     }; // CPC end

   };  // if !empty(program) CPC/CPM programs ended


   // CPL/CPS offers: we get pid & bid for URL

   $res = mysql_db_query($GLOBALS['DataBase'],"
SELECT bid,advid,pid,url,image,ptype
FROM   banners
WHERE  status='active' AND bid='$bid' AND pid='$pid'
     ");


   if (!(list($bid,$advid,$pid,$url,$image,$ptype1)=mysql_fetch_array($res)))
           promo_banner();

    // fix active offer status

   $res = mysql_db_query($GLOBALS['DataBase'],"
SELECT pid
FROM   offers
WHERE  pid='$pid' AND status='active'
     ");

      if(mysql_num_rows($res) <= 0)    {
          promo_banner();
      };        

    // get host details for selected offer

    $res = mysql_db_query($GLOBALS['DataBase'],"
           SELECT price,ptype
	   FROM   applydb
	   WHERE  hid='$hid' AND pid='$pid' AND status='active'
           ");

    if(mysql_num_rows($res) > 0)    {
       list($price,$ptype) = mysql_fetch_array($res);
    } else {
       promo_banner();
    };        

   // check for unique click in database ( 1 unique IP for offer )

    if ($ptype=='lead' || $ptype=='res1') {

   $res = mysql_db_query($GLOBALS['DataBase'],"
SELECT bid,ip,hid
FROM   leaddb
WHERE  bid = '$pid' AND ip = '$rawip' AND hid='$hid'	
     ");

    } else if ($ptype=='sale') {

   $res = mysql_db_query($GLOBALS['DataBase'],"
SELECT bid,ip,hid
FROM   salesdb
WHERE  bid = '$pid' AND ip = '$rawip' AND hid='$hid'	
     ");

   };

   if(mysql_num_rows($res) > 0)    {
 
          if ($ptype=='lead' || $ptype=='res1') {
             $res = mysql_db_query($GLOBALS['DataBase'],"
   	     UPDATE leaddb SET count=count+1 
   	     WHERE bid='$pid'  AND ip='$rawip' AND hid='$hid'
             ");
          } else if ($ptype=='sale') {
             $res = mysql_db_query($GLOBALS['DataBase'],"
   	     UPDATE salesdb SET count=count+1 
   	     WHERE bid='$pid' AND ip='$rawip' AND hid='$hid'
             ");
          };

     } else {

          // have fun here :) 
 
	 if ($ptype=='lead' || $ptype=='res1') {

            $res = mysql_db_query($GLOBALS['DataBase'],"
	    REPLACE INTO leaddb (bid,advid,hid,ip,status,ctime,ltime,ref,ct,count,dns,ldata)
   	    VALUES ('$pid','$advid','$hid','$rawip','click',NOW(),NULL,'$refer','$country','1','$dns',' ')
            ");

        } else if ($ptype=='sale') {

            $res = mysql_db_query($GLOBALS['DataBase'],"
	    REPLACE INTO salesdb (bid,advid,hid,ip,status,ctime,ltime,ref,ct,count,dns,ldata,amount)
   	    VALUES ('$pid','$advid','$hid','$rawip','click',NOW(),NULL,'$refer','$country','1','$dns',' ',0)
            ");

         } else {
            echo "Unknown offer type!";
            exit(); 

         }; 
          // update offer
         $res = mysql_db_query($GLOBALS['DataBase'],"UPDATE offers SET tc=tc+1,mc=mc+1,dayc=dayc+1 WHERE pid='$pid'");

         // update banner
         $res = mysql_db_query($GLOBALS['DataBase'],"UPDATE banners SET tc=tc+1,mc=mc+1,dayc=dayc+1 WHERE pid='$pid' AND bid='$bid'");

         // update host stats in applydb 
         $res = mysql_db_query($GLOBALS['DataBase'],"UPDATE applydb SET tc=tc+1,mc=mc+1,dayc=dayc+1 WHERE hid='$hid' AND pid='$pid'");
          
   }; // if unique entry


   setcookie("rIP$n",$HTTP_X_FORWARDED_FOR,$Cdata,$Cpath);
   setcookie("CGoP${pid}H",$h,$Cdata,$Cpath);
   setcookie("CGoP${pid}Ban",$bid,$Cdata,$Cpath);

   header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");             // Date in the past
   header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
   header("Cache-Control: no-cache, must-revalidate");         // HTTP/1.1
   header("Pragma: no-cache");                                 // HTTP/1.0


   $url=parse_macro($url);

   header("Location: $url");
   exit();
?>