sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_banner WHERE type='0' AND active='1'")); /* Get a random banner if exist any. */ /* More efficient random stuff, thanks to Cristian Arroyo from http://www.planetalinux.com.ar */ if ($numrows>1) { $numrows = $numrows-1; mt_srand((double)microtime()*1000000); $bannum = mt_rand(0, $numrows); } else { $bannum = 0; } $sql = "SELECT bid, impmade, imageurl, clickurl, alttext FROM ".$prefix."_banner WHERE type='0' AND active='1' LIMIT $bannum,1"; $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $bid = $row[bid]; $imageurl = $row[imageurl]; $clickurl = $row[clickurl]; $alttext = $row[alttext]; if (!is_admin($admin)) { $db->sql_query("UPDATE ".$prefix."_banner SET impmade=impmade+1 WHERE bid='$bid'"); } if($numrows>0) { $sql2 = "SELECT cid, imptotal, impmade, clicks, date FROM ".$prefix."_banner WHERE bid='$bid'"; $result2 = $db->sql_query($sql2); $row2 = $db->sql_fetchrow($result2); $cid = $row2[cid]; $imptotal = $row2[imptotal]; $imptotal = intval($imptotal); $impmade = $row2[impmade]; $impmade = intval($impmade); $clicks = $row2[clicks]; $clicks = intval($clicks); $date = $row2[date]; /* Check if this impression is the last one and print the banner */ if (($imptotal <= $impmade) AND ($imptotal != 0)) { $db->sql_query("UPDATE ".$prefix."_banner SET active='0' WHERE bid='$bid'"); $sql3 = "SELECT name, contact, email FROM ".$prefix."_bannerclient WHERE cid='$cid'"; $result3 = $db->sql_query($sql3); $row3 = $db->sql_fetchrow($result3); $c_name = $row3[name]; $c_contact = $row3[contact]; $c_email = $row3[email]; if ($c_email != "") { $from = "$sitename <$adminmail>"; $to = "$c_contact <$c_email>"; $message = ""._HELLO." $c_contact:\n\n"; $message .= ""._THISISAUTOMATED."\n\n"; $message .= ""._THERESULTS."\n\n"; $message .= ""._TOTALIMPRESSIONS." $imptotal\n"; $message .= ""._CLICKSRECEIVED." $clicks\n"; $message .= ""._IMAGEURL." $imageurl\n"; $message .= ""._CLICKURL." $clickurl\n"; $message .= ""._ALTERNATETEXT." $alttext\n\n"; $message .= ""._HOPEYOULIKED."\n\n"; $message .= ""._THANKSUPPORT."\n\n"; $message .= "- $sitename "._TEAM."\n"; $message .= "$nukeurl"; $subject = "$sitename: "._BANNERSFINNISHED.""; mail($to, $subject, $message, "From: $from\nX-Mailer: PHP/" . phpversion()); } } echo""; } } /********************************************/ /* Function to redirect the clicks to the */ /* correct url and add 1 click */ /********************************************/ function clickbanner($bid) { global $prefix, $db; $sql = "SELECT clickurl FROM ".$prefix."_banner WHERE bid='$bid'"; $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $db->sql_query("UPDATE ".$prefix."_banner SET clicks=clicks+1 WHERE bid='$bid'"); update_points(21); Header("Location: $row[clickurl]"); } /********************************************/ /* Function to let your client login to see */ /* the stats */ /********************************************/ function clientlogin() { echo"

Advertising Statistics Login: Password: Please type your client information

"; } /*********************************************/ /* Function to display the banners stats for */ /* each client */ /*********************************************/ function bannerstats($login, $pass) { global $prefix, $db, $sitename; $sql = "SELECT cid, name, passwd FROM ".$prefix."_bannerclient WHERE login='$login'"; $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $cid = $row[cid]; $cid = intval($cid); $name = $row[name]; $passwd = $row[passwd]; if($login=="" AND $pass=="" OR $pass=="") { echo "
Login Incorrect!!!

Back to Login Screen"; } else { if ($pass==$passwd) { echo"

Current Active Banners for $name "; $sql = "SELECT bid, imptotal, impmade, clicks, date FROM ".$prefix."_banner WHERE cid='$cid' AND active='1'"; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { $bid = $row[bid]; $bid = intval($bid); $imptotal = $row[imptotal]; $imptotal = intval($imptotal); $impmade = $row[impmade]; $impmade = intval($impmade); $clicks = $row[clicks]; $clicks = intval($clicks); $date = $row[date]; if($impmade==0) { $percent = 0; } else { $percent = substr(100 * $clicks / $impmade, 0, 5); } if($imptotal==0) { $left = "Unlimited"; } else { $left = $imptotal-$impmade; } echo " "; } echo " ID Imp. Made Imp. Total Imp. Left Clicks % Clicks Functions $bid $impmade $imptotal $left $clicks $percent% E-mail Stats Following are your running Banners in $sitename "; $sql = "SELECT bid, imageurl, clickurl, alttext FROM ".$prefix."_banner WHERE cid='$cid' AND active='1'"; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { $bid = $row[bid]; $bid = intval($bid); $imageurl = $row[imageurl]; $clickurl = $row[clickurl]; $alttext = $row[alttext]; $numrows = $db->sql_numrows($result); if ($numrows>1) { echo " "; } echo " Banner ID: $bid Send E-Mail Stats for this Banner This Banners points to this URL Change URL: Change Text: "; } echo "

"; /* Finnished Banners */ echo "

Banners Finished for $name "; $sql = "SELECT bid, impmade, clicks, imageurl, date, dateend FROM ".$prefix."_banner WHERE cid='$cid' AND active='0'"; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { $bid = $row[bid]; $bid = intval($bid); $impmade = $row[impmade]; $impmade = intval($impmade); $clicks = $row[clicks]; $clicks = intval($clicks); $imageurl = $row[imageurl]; $date = $row[date]; $dateend = $row[dateend]; $percent = substr(100 * $clicks / $impmade, 0, 5); echo " "; } echo " ID Impressions Clicks % Clicks Start Date End Date Functions $bid $impmade $clicks $percent% $date $dateend View Banner

"; } else { echo "
Login Incorrect!!!

Back to Login Screen"; } } } /*********************************************/ /* Function to let the client E-mail his */ /* banner Stats */ /*********************************************/ function EmailStats($login, $cid, $bid, $pass) { global $prefix, $db; $sql = "SELECT name, email FROM ".$prefix."_bannerclient WHERE cid='$cid'"; $rsult = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $name = $row[name]; $email = $row[email]; if ($email=="") { echo "


Statistics for Banner No. $bid can't be send because
there isn't an email associated with client $name
Please contact the Administrator

Back to Banners Stats "; } else { $sql2 = "SELECT bid, imptotal, impmade, clicks, imageurl, clickurl, date FROM ".$prefix."_banner WHERE bid='$bid' AND cid='$cid'"; $result2 = $db->sql_query($sql2); $row2 = $db->sql_fetchrow($result2); $bid = $row2[bid]; $bid = intval($bid); $imptotal = $row2[imptotal]; $imptotal = intval($imptotal); $impmade = $row2[impmade]; $impmade = intval($impmade); $clicks = $row2[clicks]; $clicks = intval($clicks); $imageurl = $row2[imageurl]; $clickurl = $row2[clickurl]; $date = $row2[date]; if($impmade==0) { $percent = 0; } else { $percent = substr(100 * $clicks / $impmade, 0, 5); } if($imptotal==0) { $left = "Unlimited"; $imptotal = "Unlimited"; } else { $left = $imptotal-$impmade; } $fecha = date("F jS Y, h:iA."); $subject = "Your Banner Statistics at $sitename"; $message = "Following are the complete stats for your advertising investment at $sitename:\n\n\nClient Name: $name\nBanner ID: $bid\nBanner Image: $imageurl\nBanner URL: $clickurl\n\nImpressions Purchased: $imptotal\nImpressions Made: $impmade\nImpressions Left: $left\nClicks Received: $clicks\nClicks Percent: $percent%\n\n\nReport Generated on: $fecha"; $from = "$sitename"; mail($email, $subject, $message, "From: $from\nX-Mailer: PHP/" . phpversion()); echo "


Statistics for Banner No. $bid has been send to
$email of $name

Back to Banners Stats "; } } /*********************************************/ /* Function to let the client to change the */ /* url for his banner */ /*********************************************/ function change_banner_url_by_client($login, $pass, $cid, $bid, $url, $alttext) { global $prefix, $db; $sql = "SELECT passwd FROM ".$prefix."_bannerclient WHERE cid='$cid'"; $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $passwd = $row[passwd]; if (!empty($pass) AND $pass==$passwd) { $alttext = ereg_replace("\"", "", $alttext); $alttext = ereg_replace("'", "", $alttext); $db->sql_query("UPDATE ".$prefix."_banner SET clickurl='$url', alttext='$alttext' WHERE bid='$bid'"); echo "
"; if ($url != "") { echo "You changed the URL
"; } if ($alttext != "") { echo "You changed the Alternate Text"; } echo "

Back to Stats Page"; } else { echo "
Your login/password doesn't match.

Please login again"; } } switch($op) { case "click": clickbanner($bid); break; case "login": clientlogin(); break; case "Ok": bannerstats($login, $pass); break; case "Change": change_banner_url_by_client($login, $pass, $cid, $bid, $url, $alttext); break; case "EmailStats": EmailStats($login, $cid, $bid, $pass); break; default: viewbanner(); break; } ?>