public static function setView($ip, $hostname, $site, $size, $webadID)
{
$ip = Database::makeStringSafe($ip);
$hostname = Database::makeStringSafe($hostname);
$site = Database::makeStringSafe($site);
$size = Database::makeStringSafe($size);
$webadID = Database::makeStringSafe($webadID);
$view = WebAdViewDao::getView($ip, $site, $size);
if ($view) {
$query = "UPDATE " . Database::addPrefix('webadviews') . " SET webadID = '" . $webadID . "'WHERE" . " ip = '" . $ip . "' AND site = '" . $site . "' AND size = '" . $size . "'";
Database::doQuery($query);
} else {
WebAdViewDao::createView($ip, $hostname, $site, $size, $webadID);
}
}
<?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();
