Новости
#####решаем проблему с кодировкой
$SetChars = "set names cp1251;";
$Chars = mysql_query($SetChars);
##################################
$postpref="_1";
if (!isset($_GET['data']) and !isset($_GET['id'])){
$linedate=date("Y-n-j",time());
$result = mysql_query("select * from ".$table_news." order by `news_id` desc limit 0, $am_news",$connect);
$num_rows = mysql_num_rows($result);
$resultall = mysql_query("select * from ".$table_news."",$connect);
$num_rows_all = mysql_num_rows($resultall);
if($num_rows =="0"){$result = mysql_query("select * from ".$table_news." order by `news_id` desc limit 0, 5",$connect);
$num_rows = mysql_num_rows($result);}
for($i=0;$i < $num_rows;$i++)
{
$row=mysql_fetch_array($result);
$img=$row['news_stamp'];
$news_exp=$row['news_exp'];
?>
if ($p_time == 1) {print $row['news_time'] . " ";}
if ($p_date == 1){$news_date = explode("-", $row['news_date']);print ''.$news_date[2].'.'.$news_date[1].'.'.$news_date[0].'';}
print " $row[news_title]";?> |
";
}?>
$LengthC=strlen($row['news_content']);
$name = substr($row['news_content'], 0, $PreLengthC);
print "".$name." | ";
print " ";
}
}
elseif (isset($_GET['data'])){
$linedate=$_GET['data'];
$result = mysql_query("select * from ".$table_news." order by `news_id` desc",$connect);
$num_rows = mysql_num_rows($result);
if($num_rows =="0"){$result = mysql_query("select * from ".$table_news." order by `news_id` desc limit 0,$am_news",$connect);$num_rows = mysql_num_rows($result);}
for($i=0;$i < $num_rows;$i++)
{
$row=mysql_fetch_array($result);
$img=$row['news_stamp'];
$news_exp=$row['news_exp'];
?>
if ($p_time == 1) {print $row['news_time'] . " ";}
if ($p_date == 1){$news_date = explode("-", $row['news_date']);
print $news_date[2].'.'.$news_date[1].'.'.$news_date[0];
}
print " $row[news_title]";?>
|
";}?>
";}
$LengthC=strlen($row['news_content']);
$name = substr($row['news_content'], 0, $PreLengthC)." .... Подробнее >>>";
print "".$name." | ";
if ($row['news_img'] == "r"){print " | ";}
print " ";
}
}
elseif
(isset($_GET['id'])){
$id=intval($_GET['id']);
$result = mysql_query("select * from ".$table_news." where news_id = $id",$connect);
$row=mysql_fetch_array($result) or die (print "");
$img=$row['news_stamp'];
$news_exp=$row['news_exp'];
print "
";
if ($p_time == 1) {print $row['news_time'] . " ";}
if ($p_date == 1){$news_date = explode("-", $row['news_date']);
print $news_date[2].'.'.$news_date[1].'.'.$news_date[0];} print " ".$row['news_title']." |
";
if ($row['news_img'] == "l")
{print " ";}
if ($row['news_img'] == "n"){print " | ";}
if ($row['news_img'] == "r"){print " | ";}
print " $row[news_content] | ";
}
else {print "брр";};
?>
5){?>Архив новостей}?>
|
virtual("/cgi-bin/top.cgi") ?>
|