Execute("SELECT $column[clickurl] FROM $pntable[banner] WHERE $column[bid]=".pnVarPrepForStore($bid).""); list($clickurl) = $bresult->fields; $bresult->Close(); $dbconn->Execute("UPDATE $pntable[banner] SET $column[clicks]=$column[clicks]+1 WHERE $column[bid]=".pnVarPrepForStore($bid).""); Header("Location: $clickurl"); } /* All of the crap below needs to be moved to a user module */ function clientlogin() { include 'header.php'; OpenTable(); echo"" .""._BAN_ADVSTATS."

" .""; CloseTable(); include 'footer.php'; } /** * Function to display the banners stats for * each client */ function bannerstats() { list($login, $pass) = pnVarCleanFromInput('login', 'pass'); list($dbconn) = pnDBGetConn(); $pntable = pnDBGetTables(); $sitename = pnConfigGetVar('sitename'); $column = &$pntable['bannerclient_column']; $result = $dbconn->Execute("SELECT $column[cid], $column[name], $column[passwd] FROM $pntable[bannerclient] WHERE $column[login]='".pnVarPrepForStore($login)."'"); list($cid, $name, $passwd) = $result->fields; $result->Close(); if ($login == "" AND $pass == "" OR $pass == "") { include 'header.php'; echo "
"._BAN_LOGININCORR."

"._BAN_BACK.""; include 'footer.php'; } else { if ($pass==$passwd) { include 'header.php'; OpenTable(); echo "" ."" .""._BAN_CURRACTIVE." ".pnVarPrepForDisplay($name)."." ."" ."
" ."" ."" ."" ."" ."" ."" ."" ."" .""; $column = &$pntable['banner_column']; $result = $dbconn->Execute("SELECT $column[bid], $column[imptotal], $column[impmade], $column[clicks], $column[date] FROM $pntable[banner] WHERE $column[cid]=".pnVarPrepForStore($cid).""); // Change for Oracle compatibility // while(list($bid, $imptotal, $impmade, $clicks, $date) = $result->fields) { while(!$result->EOF){ list($bid, $imptotal, $impmade, $clicks, $date) = $result->fields; $result->MoveNext(); if($impmade == 0) { $percent = 0; } else { $percent = substr(100 * $clicks / $impmade, 0, 5); } if($imptotal==0) { $left = _BAN_UNLIMITED; } else { $left = $imptotal-$impmade; } echo "" ."" ."" ."" ."" ."" .""; } echo "

"._BAN_ID."	"._BAN_IMP_MADE."	"._BAN_IMP_TOTAL."	"._BAN_IMP_LEFT."	"._BAN_CLICKS."	"._BAN_PERCENTCLICKS."	"._BAN_FUNCTIONS."
".pnVarPrepForDisplay($bid)."	".pnVarPrepForDisplay($impmade)."	".pnVarPrepForDisplay($imptotal)."	".pnVarPrepForDisplay($left)."	".pnVarPrepForDisplay($clicks)."	".pnVarPrepForDisplay($percent)."%	"._BAN_EMAIL_STATS."

"; CloseTable(); OpenTable(); echo '' .'

' .''._BAN_ONYOURSITE.'' .' '.pnVarPrepForDisplay($sitename).'

'; $column = &$pntable['banner_column']; $result = $dbconn->Execute ("SELECT $column[bid], $column[imageurl], $column[clickurl] FROM $pntable[banner] WHERE $column[cid]=".pnVarPrepForStore($cid).""); $foundrecs = !$result->EOF; // Change for Oracle compatibility // while(list($bid, $imageurl, $clickurl) = $result->fields) { while(!$result->EOF){ list($bid, $imageurl, $clickurl) = $result->fields; if ($foundrecs) { echo "

"; } echo "

" .""._BAN_ID.": ".pnVarPrepForDisplay($bid)."
" .""._BAN_SEND." "._BAN_EMAIL_STATS." "._BAN_FORTHIS."
" ." "._BAN_THISURL."
" .""; $result->MoveNext(); } CloseTable(); /* Finnished Banners */ /* Not working so good OpenTable(); echo "" ."" ."Banners Finished for ".pnVarPrepForDisplay($name)."" ."" ."
" ."" ."" ."" ."" ."" ."" ."" .""; $column = &$pntable['bannerfinish_column']; $result = $dbconn->Execute("SELECT $column[bid], $column[impressions], $column[clicks], $column[datestart], $column[dateend] FROM $pntable[bannerfinish] WHERE $column[cid]=".pnVarPrepForStore($cid).""); while(list($bid, $impressions, $clicks, $datestart, $dateend) = $result->fields) { $result->MoveNext(); $percent = substr(100 * $clicks / $impressions, 0, 5); echo "" ."" ."" ."" ."" ."" ."

ID	Impressions	Clicks	% Clicks	Start Date	End Date
".pnVarPrepForDisplay($bid)."	".pnVarPrepForDisplay($impressions)."	".pnVarPrepForDisplay($clicks)."	".pnVarPrepForDisplay($percent)."%	".pnVarPrepForDisplay($datestart)."	".pnVarPrepForDisplay($dateend)."

"; } CloseTable(); */ include 'footer.php'; } else { include 'header.php'; echo "" ."
"._BAN_LOGININCORR."

"._BAN_BACK."" .""; include 'footer.php'; } } } /** * Let the client email his * banner statistics */ function EmailStats() { list($login, $cid, $bid, $pass) = pnVarCleanFromInput('login', 'cid', 'bid', 'pass'); $cid = intval($cid); $bid = intval($bid); list($dbconn) = pnDBGetConn(); $pntable = pnDBGetTables(); $column = &$pntable['bannerclient_column']; $result2 = $dbconn->Execute($s="SELECT $column[name], $column[email] FROM $pntable[bannerclient] WHERE $column[cid]=".pnVarPrepForStore($cid).""); list($name, $email) = $result2->fields; if ($email == "") { include 'header.php'; OpenTable(); echo ""._BAN_STATSFORBAN." ".pnVarPrepForDisplay($bid); echo " "._BAN_CANTSEND." ".pnVarPrepForDisplay($name)."
" .""._BAN_CONTACTADMIN."

" .""._BAN_BACK.""; CloseTable(); include 'footer.php'; } else { $column = &$pntable['banner_column']; $result = $dbconn->Execute("SELECT $column[bid], $column[imptotal], $column[impmade], $column[clicks], $column[imageurl], $column[clickurl], $column[date] FROM $pntable[banner] WHERE $column[bid]='".pnVarPrepForStore($bid)."' AND $column[cid]='".pnVarPrepForStore($cid)."'"); list($bid, $imptotal, $impmade, $clicks, $imageurl, $clickurl, $date) = $result->fields; if ($impmade == 0) { $percent = 0; } else { $percent = substr(100 * $clicks / $impmade, 0, 5); } if ($imptotal == 0) { $left =_BAN_UNLIMITED; $imptotal = _BAN_UNLIMITED; } else { $left = $imptotal-$impmade; } $sitename = pnConfigGetVar('sitename'); $fecha = date("F jS Y, h:iA."); $subject = ""._BAN_YOURSTATS." $sitename"; $message = ""._BAN_FORMAIL." $sitename:\n\n\n"._BAN_CLIENTNAME.": $name\n"._BAN_ID.": $bid\n"._BAN_IMAGE.": $imageurl\n"._BAN_URL.": $clickurl\n\n"._BAN_IMPPURCHASED.": $imptotal\n"._BAN_IMP_MADE.": $impmade\n"._BAN_IMP_LEFT.": $left\n"._BAN_CLICKS.": $clicks\n"._BAN_PERCENTCLICKS.": $percent%\n\n\n"._BAN_REPORTMADEON.": $fecha"; $from = "$sitename"; pnMail($email, $subject, $message, ""._BAN_FROM.": $from\nX-Mailer: PHP/" . phpversion()); include 'header.php'; OpenTable(); echo ""._BAN_STATSFORBAN." ".pnVarPrepForDisplay($bid)." "._BAN_SENTTO."
" ."".pnVarPrepForDisplay($email)." for ".pnVarPrepForDisplay($name)."

" .""._BAN_BACK.""; CloseTable(); } } /** * Let the client to change the * url for his banner */ function change_banner_url_by_client() { list($login, $pass, $cid, $bid, $url) = pnVarCleanFromInput('login', 'pass', 'cid', 'bid', 'url'); $cid = intval($cid); $bid = intval($bid); list($dbconn) = pnDBGetConn(); $pntable = pnDBGetTables(); $column = &$pntable['bannerclient_column']; $result = $dbconn->Execute("SELECT $column[passwd] FROM $pntable[bannerclient] WHERE $column[cid]='".pnVarPrepForStore($cid)."'"); list($passwd) = $result->fields; $result->Close(); if (!empty($pass) && !empty($login) && $pass == $passwd) { $column = &$pntable['banner_column']; $dbconn->Execute("UPDATE $pntable[banner] SET $column[clickurl]='".pnVarPrepForStore($url)."' WHERE $column[bid]='".pnVarPrepForStore($bid)."'"); include 'header.php'; OpenTable(); echo "
"._BAN_URLCHANGED."

".BAN_BACK.""; CloseTable(); include 'footer.php'; } else { include 'header.php'; OpenTable(); echo "
"._BAN_BADLOGINPASS."

"._BAN_PLEASE.""._BAN_LOGINAGAIN."."; CloseTable(); include 'footer.php'; } } if(!isset($op)) $op = ''; switch($op) { case "click": clickbanner(); break; case "login": clientlogin(); break; case "Ok": bannerstats(); break; case "Change": change_banner_url_by_client(); break; case "EmailStats": EmailStats(); break; default: clientlogin(); break; } ?>