0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW() ";
switch($Position) {
case 1:
case 2:
case 3:
case 4:
$query .= " AND `Position` LIKE '%{$Position}%' ";
break;
default:
return '';
}
$query .= "ORDER BY RAND() LIMIT 1";
$arr = db_arr( $query );
if ( !$arr[0] )
return '';
switch ($Position) {
case 2:
$hshift = $arr['lhshift'];
$vshift = $arr['lvshift'];
break;
case 3:
$hshift = $arr['rhshift'];
$vshift = $arr['rvshift'];
break;
}
$arr['Text'] = html_entity_decode($arr['Text']);
$sLinkWrapper = $arr['Url'] ? "{$arr['Text']}
" : $arr['Text'];
if( $Position == 2 || $Position == 3 ) {
$sPosition = ($Position == 2) ? "left:" : "right:";
$out .= <<
{$sLinkWrapper}
EOF;
} else {
$out .= '' . "\n";
$out .= <<
{$sLinkWrapper}
|
EOF;
}
if ( $Track ) {
db_res("INSERT INTO `sys_banners_shows` SET `ID` = {$arr['ID']}, `Date` = '".time()."', `IP` = '". $_SERVER['REMOTE_ADDR'] ."'", 0);
}
switch($Position) {
/*case 1:
$out = '' . $out . '';
break;*/
case 2:
$out = '' . $out . '
';
break;
case 3:
$out = '' . $out . '
';
break;
/*case 4:
$out = '' . $out . '';
break;*/
}
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 `sys_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 `sys_banners` WHERE `ID` = $ID LIMIT 1");
}
if ( !$bann_arr )
return "";
if ( $Track ) {
db_res("INSERT INTO `sys_banners_shows` SET `ID` = {$bann_arr['ID']}, `Date` = '".time()."', `IP` = '". $_SERVER['REMOTE_ADDR']. "'", 0);
}
$bann_arr['Text'] = html_entity_decode($bann_arr['Text']);
$sOutputCode = $bann_arr['Url'] ? "{$bann_arr['Text']}" : $bann_arr['Text'];
return $sOutputCode;
}
?>