Файл: public_html/rotator.php
Строк: 17
<?
require('config.php');
include('remban.php');
$sql="select * from tb_advban";
$res=mysql_query($sql);
$kol=mysql_num_rows($res);
$poisk=0;
if ($kol>0)
{
for ($i=1;$i<=$kol;$i++)
{
$row=mysql_fetch_assoc($res);
$idpred=$row["id"];
$curpred=$row["curview"];
if ($curpred=="1")
{
$sql="update tb_advban set curview=0 where id='$idpred'";
mysql_query($sql);
if ($i<$kol)
{
$row=mysql_fetch_assoc($res);
$id=$row["id"];
$urlsite=$row["urlsite"];
$urlpic=$row["urlpic"];
}else{
$sql="select * from tb_advban";
$res=mysql_query($sql);
$row=mysql_fetch_assoc($res);
$id=$row["id"];
$urlsite=$row["urlsite"];
$urlpic=$row["urlpic"];
}
$poisk=1;
}
}
if ($poisk==0)
{
$sql="select * from tb_advban";
$res=mysql_query($sql);
$row=mysql_fetch_assoc($res);
$id=$row["id"];
$urlsite=$row["urlsite"];
$urlpic=$row["urlpic"];
}
$sql="update tb_advban set curview=1 where id='$id'";
mysql_query($sql);
mysql_close($con);
?>
<a href="<? echo $urlsite; ?>" target="_blank"><img src="<? echo $urlpic; ?>" width="468" height="60"></a>
<?
}else{
?>
<a href="addbanner.php"><img src="/images/nobanner.jpg" width="468" height="60"></a>
<?
}
?>