? include("common.php"); $link = mysql_connect($dbhost, $dbuser, $dbpassword) or die("Could not connect: " . mysql_error()); mysql_select_db($dbname); $sSQL="select s_URL, n_UserID, n_ExpireViews, n_ExpireClicks, b_Paid from t_Banners where n_ID=".stripjunk($targetid); $results=mysql_query($sSQL); list($s_URL, $n_UserID, $n_ExpireViews, $n_ExpireClicks, $b_Paid)=mysql_fetch_row($results); if($b_Paid==1 && $n_ExpireClicks>0 && $n_ExpireViews==0) { $sSQL="update t_Banners set n_ExpireClicks=n_ExpireClicks-1 where n_ID=".stripjunk($targetid); mysql_query($sSQL); if ($n_ExpireClicks==1) { $sSQL="select * from t_Banners where n_UserID=".stripjunk($n_UserID)." and (b_Authorised>0 and b_Paid<>1) or (b_Paid=1 and (n_ExpireViews>0 or n_ExpireClicks>0))"; $results=mysql_query($sSQL); if(mysql_num_rows($results)==0) { $sSQL="update t_Users set b_Authedban=0 where n_ID=".stripjunk($n_UserID); mysql_query($sSQL); } } } $sSQL="update t_Banners set n_Clicks=n_Clicks+1 where n_ID=".stripjunk($targetid); mysql_query($sSQL); $sSQL="update t_Users set n_Clicks=n_Clicks+1 where n_ID=".stripjunk($hostid); mysql_query($sSQL); mysql_close(); header("Location: ".stripjunk($s_URL)); ?>