\n";
}
if ( $Track )
{
db_res("INSERT INTO `BannersShows` SET `ID` = {$arr['ID']}, `Date` = NOW(), `IP` = '". $_SERVER['REMOTE_ADDR'] ."'", 0);
}
return $out;
}
function banner_put($ID = 0, $Track = 1)
{
global $bann_click_url;
if ( !$ID )
{
// Get only banners that are active and for which promotion period has not expired.
$bann_arr = db_arr("SELECT `ID`, `Url`, `Text` FROM `Banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW() ORDER BY RAND() LIMIT 1");
}
else
{
$bann_arr = db_arr("SELECT `ID`, `Url`, `Text` FROM `Banners` WHERE `ID` = $ID LIMIT 1");
}
if ( !$bann_arr )
return "";
if ( $Track )
{
db_res("INSERT INTO `BannersShows` SET `ID` = {$bann_arr['ID']}, `Date` = NOW(), `IP` = '". $_SERVER['REMOTE_ADDR']. "'", 0);
}
return "{$bann_arr['Text']}";
}
?>