public static function getRandomAdBySizeAndDate($size, $date, $incrementImpression)
{
$query = "SELECT * FROM " . Database::addPrefix('webads') . " WHERE Size = '" . $size . "' AND StartingMonday = '" . DateUtil::findPreviousMonday($date) . "'";
$result = Database::doQuery($query);
$webads = array();
while ($row = mysql_fetch_assoc($result)) {
$webads[] = WebAdDao::makeAd($row);
}
if (mysql_num_rows($result) > 0) {
$webad = $webads[array_rand($webads)];
if ($incrementImpression) {
WebAdDao::incrementImpression($webad);
}
return $webad;
} else {
return WebAd::getDefaultAd($size, $date);
}
}
<?php
require_once './config.php';
require_once './lib/DB/Database.php';
require_once './lib/DB/WebAd.php';
require_once './lib/DB/WebAdDao.php';
require_once './lib/DB/WebAdView.php';
require_once './lib/DB/WebAdViewDao.php';
require_once './lib/Util/DateUtil.php';
require_once './lib/Util/SimpleImage.php';
require_once './lib/Util/SessionUtil.php';
Database::Open();
SessionUtil::start();
if (isset($_GET['size'])) {
$view = WebAdViewDao::getView($_SERVER['REMOTE_ADDR'], $_GET['site'], $_GET['size']);
if ($view) {
$webad = WebAdDao::getWebAdByID($view->webadID);
} else {
$webad = WebAd::getDefaultAd($_GET['size'], null);
}
if ($webad) {
WebAdDao::incrementClicks($webad);
header("Location: " . $webad->getRedirectUrl());
} else {
header("Location: " . WebAd::getDefaultAd($_GET['size'])->getRedirectUrl());
}
}
Database::Close();
