if($adctype == 'banner') {
if($numcrows != 0) {
$fetchurl = mysql_fetch_array($checkforads);
$url = $fetchurl['url'];
$imageurl = $fetchurl['imageurl'];
$adid = $fetchurl['id'];
$querycheck = mysql_query("SELECT * FROM ipcheck WHERE url='$code' AND ip='$uip'");
$rowip = mysql_num_rows($querycheck);
if ($rowip == 0) {
$adowner = $fetchurl['owner'];
$updateads = mysql_query("UPDATE advertisers SET date7=date7 + '1' WHERE username='$adowner'");
$updateadc = mysql_query("UPDATE ads SET credits = credits - '1' WHERE id='$adid'");
$qstats = mysql_query("UPDATE stats SET svlinks7=svlinks7 + '1' WHERE id='1'");
$qstatss = mysql_query("UPDATE stats SET tsvlinks=tsvlinks + '1' WHERE id='1'");
$ipadd = mysql_query("INSERT INTO ipcheck (url,ip) VALUES ('$code','$uip')");
$ipadd2 = mysql_query("INSERT INTO totalip (url,ip,username) VALUES ('$code','$uip','$session_username')");
$addin = mysql_query("UPDATE members SET balance=balance + $ppvbvalue WHERE username='$itemuser'");
$referalcheck = mysql_query("SELECT * FROM members WHERE username='$itemuser'");
$referalfetch = mysql_fetch_array($referalcheck);
$referalname = $referalfetch['refid'];
if ($referalname != "") {
$settings = mysql_query("SELECT * FROM settings WHERE id='1'");
$sa = mysql_fetch_array($settings);
$ppr = $ppvbvalue * $sa['ppvr'];
$addbalref = mysql_query("UPDATE members SET balance=balance + $ppr WHERE username='$referalname'");
$addupearnings = mysql_query("UPDATE members SET uplineearnings=uplineearnings + $ppr WHERE username='itemuser'");
$graphupp = mysql_query("UPDATE members SET rdate7=rdate7+1 WHERE username='$referalname'");
$hitupdatee = mysql_query("UPDATE members SET tstats=tstats+1 WHERE username='$referalname'");
$viewsupdatee = mysql_query("UPDATE items SET views=views + 1 WHERE code='$code'");
$earningsupdatee = mysql_query("UPDATE items SET mearned=mearned + $ppr WHERE code='$code'");
}
$graphup = mysql_query("UPDATE members SET date7=date7+1 WHERE username='$itemuser'");
$hitupdate = mysql_query("UPDATE members SET tstats=tstats+1 WHERE username='$itemuser'");
$viewsupdate = mysql_query("UPDATE items SET views=views + 1 WHERE code='$code'");
$earningsupdatee = mysql_query("UPDATE items SET mearned=mearned + $ppvbvalue WHERE code='$code'");
}
}
else
{
$url = $fetchurl['url'];
$imageurl = $fetchurl['imageurl'];
$adid = $fetchurl['id'];
$querycheck = mysql_query("SELECT * FROM ipcheck WHERE url='$code' AND ip='$uip'");
$rowip = mysql_num_rows($querycheck);
if ($rowip == 0) {
$adowner = $fetchurl['owner'];
$updateads = mysql_query("UPDATE advertisers SET date7=date7 + '1' WHERE username='$adowner'");
$updateadc = mysql_query("UPDATE ads SET credits = credits - '1' WHERE id='$adid'");
$qstats = mysql_query("UPDATE stats SET svlinks7=svlinks7 + '1' WHERE id='1'");
$qstatss = mysql_query("UPDATE stats SET tsvlinks=tsvlinks + '1' WHERE id='1'");
$ipadd = mysql_query("INSERT INTO ipcheck (url,ip) VALUES ('$code','$uip')");
$ipadd2 = mysql_query("INSERT INTO totalip (url,ip,username) VALUES ('$code','$uip','$session_username')");
$addin = mysql_query("UPDATE members SET balance=balance + $ppvbvalue WHERE username='$itemuser'");
$referalcheck = mysql_query("SELECT * FROM members WHERE username='$itemuser'");
$referalfetch = mysql_fetch_array($referalcheck);
$referalname = $referalfetch['refid'];
if ($referalname != "") {
$settings = mysql_query("SELECT * FROM settings WHERE id='1'");
$sa = mysql_fetch_array($settings);
$ppr = $ppvbvalue * $sa['ppvr'];
$addbalref = mysql_query("UPDATE members SET balance=balance + $ppr WHERE username='$referalname'");
$addupearnings = mysql_query("UPDATE members SET uplineearnings=uplineearnings + $ppr WHERE username='itemuser'");
$graphupp = mysql_query("UPDATE members SET rdate7=rdate7+1 WHERE username='$referalname'");
$hitupdatee = mysql_query("UPDATE members SET tstats=tstats+1 WHERE username='$referalname'");
$viewsupdatee = mysql_query("UPDATE items SET views=views + 1 WHERE code='$code'");
$earningsupdatee = mysql_query("UPDATE items SET mearned=mearned + $ppr WHERE code='$code'");
}
$graphup = mysql_query("UPDATE members SET date7=date7+1 WHERE username='$itemuser'");
$hitupdate = mysql_query("UPDATE members SET tstats=tstats+1 WHERE username='$itemuser'");
$viewsupdate = mysql_query("UPDATE items SET views=views + 1 WHERE code='$code'");
$earningsupdatee = mysql_query("UPDATE items SET mearned=mearned + $ppvbvalue WHERE code='$code'");
}
}