@greeting[]
Новости
^connect[$connect_string]{
$type[^table::sql{select id, name from race_type where id<>0}]
^if(def $type){
^if(def $form:type){все виды }
^type.menu{
| $news.date1 $type[^table::sql{select id, name from race_type where id=$news.race_type}] ^if($type.id ne 0){$type.name} |
|
|
| ^untaint{$news.text} |
Другие новости:
} } } $page(^if(def $form:page){$form:page}{1}) ^connect[$connect_string]{ $totmsg[^table::sql{select id from news ^if(def $form:type){where race_type=$form:type}}] $total(^totmsg.count[]) ^rem{кол-во записей в таблице} $perpage[15] ^rem{кол-во записей на страницу} $pages[^math:trunc(^eval($total/$perpage))] ^rem{кол-во страниц} ^if(^math:frac(^eval($total/$perpage)) ne 0){$pages($pages+1)} ^rem{если есть дробь, то +1} } ^connect[$connect_string]{ $news[^table::sql{select id, DATE_FORMAT(date, '%d.%m.%Y') as date1, head, text, race_type from news ^if(def $form:type){where race_type=$form:type} order by date desc limit ^eval(($page-1)*$perpage), $perpage}] ^if(def $news){| $news.date1 ^if(def $form:type){}{ $type[^table::sql{select id, name from race_type where id=$news.race_type}] ^if($type.id ne 0){$type.name} } |
|
|
| ^untaint{$news.text} |
|   |
| $news.date1 ^if(def $form:type){}{ $type[^table::sql{select id, name from race_type where id=$news.race_type}] ^if($type.id ne 0){$type.name} } |