$Qnob = mysql_query("select `value` from `settings` where `setting` = 'right_column_shown'");
$nob_tmp = mysql_fetch_assoc($Qnob);
$nob = $nob_tmp['value'];
$Qr_banner = mysql_query("select * from `banners` where `position` = '2' and `shown` = '1' and `tick` = '0' order by rand() limit ".$nob);
if(mysql_num_rows($Qr_banner) == 0){
$Qr_bannero = mysql_query("select * from `banners` where `position` = '2' and `shown` = '1' and `tick` = '1' order by rand() limit ".$nob);
if(mysql_num_rows($Qr_bannero) != 0){
while($r_banner = mysql_fetch_assoc($Qr_bannero)){
echo str_replace("&", "&", $r_banner['code']);
echo "
";
$tshown = $r_banner['times_shown'] + 1;
$QUticks = mysql_query("update `banners` set `tick` = '0' where `position` = '1' and `shown` = '1'");
$Utick = mysql_query("update `banners` set `tick` = '1', `times_shown` = '".$tshown."' where `id` = '".$r_banner['id']."'");
}
}
}else{
while($r_banner = mysql_fetch_assoc($Qr_banner)){
echo str_replace("&", "&", $r_banner['code']);
echo "
";
$tshown = $r_banner['times_shown'] + 1;
$Utick = mysql_query("update `banners` set `tick` = '1', `times_shown` = '".$tshown."' where `id` = '".$r_banner['id']."'");
}
}
?>