<?

/* $ID: click.php3,v 1.2 1999/02/02 18:43:19 tobias Exp $ */
require("config.php3");

if(isset($bannerNum) && !empty($bannerNum)) $bannerID = $bannerNum;
if(isset($n) && is_array($banID)) $bannerID = $banID[$n];

$res = mysql_db_query($phpAds_db, "
       SELECT
         url
       FROM
         $phpAds_tbl_banners
       WHERE
         bannerID = $bannerID
       ") or mysql_die();
$url = mysql_result($res,0 ,0);

if($phpAds_log_adclicks)
  {
// Decrement clicks
	$getclientID=mysql_db_query($GLOBALS["phpAds_db"], "SELECT clientID FROM $phpAds_tbl_banners WHERE bannerID='$bannerID'");
	if($gotclientID=mysql_fetch_array($getclientID)){
		$clientID=$gotclientID["clientID"];
		}
	$currentclick=mysql_db_query($GLOBALS["phpAds_db"], "SELECT * FROM $phpAds_tbl_clients WHERE clientID='$clientID'");
	if($clickcount=mysql_fetch_array($currentclick)){
		$clickcount["clicks"]=$clickcount["clicks"]-1;
// Mail warnning preset is reached
		if($clickcount["clicks"]==$phpAds_warn_limit){
			warn_mail($clickcount);
		}

		if($clickcount["clicks"]>'-1'){
			mysql_db_query($GLOBALS["phpAds_db"], "UPDATE $phpAds_tbl_clients SET clicks='$clickcount[clicks]' WHERE clientID='$clientID'");
		}
// Check click count and de-activate banner if needed
		if($clickcount["views"]<='0' AND $clickcount["clicks"]<='0'){
			mysql_db_query($GLOBALS["phpAds_db"], "UPDATE $phpAds_tbl_banners SET active='false' WHERE clientID='$clientID'");
		}
	}

  if($phpAds_reverse_lookup)
  {
      $host = isset($REMOTE_HOST) ? $REMOTE_HOST : @gethostbyaddr($REMOTE_ADDR);
  }
  else
  {
     $host = $REMOTE_ADDR;
  }

 // Check if host is on list of hosts to ignore

 $found=0;
 while (($found == 0) && (list ($key, $ignore_host)=each($phpAds_ignore_hosts)))
   if (eregi($ignore_host, $host)) { // host found in ignore list
     $found=1;
   }

  if ($found == 0) {
  $res = @mysql_db_query($phpAds_db, sprintf("
       INSERT %s
         INTO $phpAds_tbl_adclicks
       VALUES
         (
         '$bannerID',
         null,
         '$host'
         )
         ", $phpAds_insert_delayed ? "DELAYED": ""));
   }
  }
Header("Location: $url");
?>