here's the view.inc.php3 code:
[PHP]
<?
/* $Id: view.inc.php3,v 1.9 1999/09/13 18:27:25 tobias Exp $ */
// Get a banner
function get_banner($what,$clientID)
{
global $phpAds_db, $REMOTE_HOST, $phpAds_tbl_banners;
if(is_string($what) AND !ereg("[0-9]x[0-9]",$what))
{
switch ($what)
{
// Get all HTML banners
case "html":
$select_html = "SELECT
bannerID,
banner,
format,
url
FROM
$phpAds_tbl_banners
WHERE
format = 'html'
AND
active = 'true'";
if ($clientID!=0)
$select_html .= " AND clientID = ".$clientID;
$res = mysql_db_query($phpAds_db,$select_html) or mysql_die();
//Not any of the special words (i.e. 'html'), So, must be a keyword
default:
$what_array = explode(",",$what);
$select_html = "SELECT
bannerID,
banner,
format,
width,
height,
alt,
bannertext,
url
FROM $phpAds_tbl_banners
WHERE (";
for($k=0;$k<count($what_array);$k++)
$select_html .= "keyword LIKE '%".trim($what_array[$k])."%' OR ";
$select_html .= "keyword = 'global') AND active = 'true'";
/*
The special 'global' keyword allows you to define a banner as global and
show up under all keywords. I put this in so that if I didn't have any banners
for a particular keyword, instead of being blank, it would show one of the global
banners - Weston Bustraan <weston@infinityteldata.net>
*/
if ($clientID!=0)
$select_html .= " AND clientID = ".$clientID;
$res = mysql_db_query($phpAds_db,$select_html) or mysql_die();
} //swtich($what)
}
elseif (is_int( $what))
{
$select_int = "SELECT
bannerID,
banner,
format,
alt,
width,
height,
bannertext,
url
FROM
$phpAds_tbl_banners
WHERE
bannerID = ".$what."
AND active = 'true'";
if ($clientID!=0)
$select_int .= " AND clientID = ".$clientID;
$res = mysql_db_query($phpAds_db,$select_int) or die(mysql_error());
}
else
{
list($width, $height) = explode("x", $what);
// Get all banners with the specified width/height
$select_x = "SELECT
bannerID,
banner,
format,
alt,
width,
height,
bannertext
FROM
$phpAds_tbl_banners
WHERE
width = ".$width."
AND height = ".$height."
AND active = 'true'";
if ($clientID!=0)
$select_x .= " AND clientID = ".$clientID;
$res = mysql_db_query($phpAds_db,$select_x) or die(mysql_error());
}
$count = mysql_num_rows($res);
// Select a random bannerID
srand((double)microtime()*1000000);
// Funny... rand() accepts a range n..m as parameter, when n is 0 then range goes
// from 0 to m-1 instead of 0..m (as it does when n is eg 1). Is this the correct
// behavious or am I missing something?
if (mysql_num_rows($res)>1)
{
$rand = rand(1, mysql_num_rows($res));
mysql_data_seek($res, $rand-1);
}
$row = mysql_fetch_array($res);
return($row);
}
// Log an adview for the banner with $bannerID
function log_adview($bannerID)
{
global $phpAds_log_adviews;
if (!$phpAds_log_adviews)
return(false);
global $row, $phpAds_tbl_adviews;
if (isset($GLOBALS["REMOTE_HOST"]) && !empty($GLOBALS["REMOTE_HOST"]))
$host = $GLOBALS["REMOTE_HOST"];
else
if (isset($GLOBALS["REMOTE_ADDR"]) && !empty($GLOBALS["REMOTE_ADDR"]))
$host = gethostbyaddr($GLOBALS["REMOTE_ADDR"]);
$res = mysql_db_query($GLOBALS["phpAds_db"], "
INSERT
INTO $phpAds_tbl_adviews
VALUES
(
'$bannerID',
null,
'$host'
)
") or die(mysql_error());
}
// view a banner
// $what can currently have one of the following formats:
// - [INTEGER]: Display the banner with this bannerID
// - "[WIDTH]x[HEIGHT]": Display a randomly selected banner with this width/height
// - "html": Display a randomly selected HTML-banner
function view($what, $clientID=0, $target = "", $withtext=0)
{
if (!is_int($clientID))
{
$target = $clientID;
$clientID = 0;
}
global $phpAds_db, $REMOTE_HOST;
mysql_pconnect($GLOBALS["phpAds_hostname"], $GLOBALS["phpAds_mysqluser"], $GLOBALS["phpAds_mysqlpassword"]);
$row = get_banner($what,$clientID);
if (!empty($row["bannerID"]))
{
if ($row["format"] == "html")
{
if(!empty($row["url"]))
echo "<a href=\"$GLOBALS[phpAds_url_prefix]/click.php3?bannerID=$row[bannerID]\"$target>";
echo $row["banner"];
if(!empty($row["url"]))
echo "</a>";
}
else
{
if (!empty($target))
$target = " target=\"$target\"";
echo "<a href=\"$GLOBALS[phpAds_url_prefix]/click.php3?bannerID=$row[bannerID]\"$target><img src=\"$GLOBALS[phpAds_url_prefix]/viewbanner.php3?bannerID=$row[bannerID]\" width=$row[width] height=$row[height] alt=\"$row[alt]\" border=0></a>";
if (($withtext) && (! $row["bannertext"] == ""))
echo "<BR>\n<a href=\"$GLOBALS[phpAds_url_prefix]/click.php3?bannerID=$row[bannerID]\"$target>".$row["bannertext"]."</a>";
}
log_adview($row["bannerID"]);
}
else
{
return(false);
}
return(true);
}
function view_t($what, $target = "")
{
view ($what, $target, 1);
}
?>