@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{ ^if($form:type ne $type.id){$type.name}{$type.name}  } } } @submenu[] @infa[] ^if(def $form:id && !def $form:page){ ^connect[$connect_string]{ $news[^table::sql{select id, DATE_FORMAT(date, '%d.%m.%Y') as date1, head, text, race_type from news where id=$form:id}] ^if(def $news){
$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.head}
  • ^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.menu{ ^if($news.id == $form:id && def $form:page){ }{ } }
    $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.head}
  • ^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} }
  • ^untaint{$news.head}
  • } } #если страниц больше 1, то выводим линки на страницы. Текущая страница болдовенькая и без линка
    ^if($pages>1){ страница: ^for[i](1;$pages){ ^if($i eq $page){ $i  }{ $i  } } }