<?
$title='Новости';
require("path.php");
require($path."system/inc_head.php");
require($path."system/noavt.php");

if (isset($_GET['start'])) {
	$start = abs(intval($_GET['start']));
} else {
	$start = 0;
} 
$ads = DB::run() -> query("SELECT * FROM news ORDER BY id DESC LIMIT $start,10;",array());
$findn = DB::run() -> query("SELECT * FROM news;",array())-> rowCount();

if($findn==0){
    comp("Новостей нет!");
}

while($news = $ads -> fetch())
{
    $usdata = DB::run() -> queryFetch("SELECT * FROM `users` WHERE `id` = ?;",array($news[avtor]));
	$avtor=$usdata[usr];
    echo'<div class="main"><red><b>'.check($news[title]).'</b></red><br/>
	'.bb(smiles(check(mtext($news[text])))).' <a href="comments.php?id='.$news[id].'">...»»»</a>
	<br/><br/>';
	$find = DB::run() -> query("SELECT * FROM news_comm WHERE nid = ?;",array($news[id]))-> rowCount();
	user($news[avtor]);
	echo' - '.times($news[time]).'<br/><a href="comments.php?id='.$news[id].'">Комментарии»</a> ('.$find.')
    </div>';
   }
pager('index.php?', '10', $start, $findn);

require($path."system/inc_foot.php");
?>