^connect[$connect_string]{
$news[^table::sql{select id, DATE_FORMAT(date, '%d.%m.%Y') as date, head, race_type from news order by DATE_FORMAT(date, '%y.%m.%d, %T') desc limit 5}]
^if(def $news){
| НОВОСТИ |
^news.menu{
$news.date
$type[^table::sql{select id, name from race_type where id=$news.race_type}]
^if($type.id ne 0){$type.name}
^untaint{$news.head}
|
}
}
}
|
^connect[$connect_string]{
$show[^table::sql{select id, name, tumb from project order by id desc limit 2}]
^if(def $show){
}
}
|
|
^connect[$connect_string]{
$show[^table::sql{select DATE_FORMAT(date, '%d.%m.%Y') as date, calendar.name, race_type.name as race_name from calendar, race_type where calendar.date >= now() and calendar.race_type = race_type.id order by DATE_FORMAT(date, '%y.%m.%d') limit 5}]
^if(def $show){
| БЛИЖАЙШИЕ СОБЫТИЯ |
^show.menu{
$show.date : $show.race_name
^untaint{$show.name}
|
}
}
}
|
^connect[$connect_string]{
$show[^table::sql{select text.id, text.name, calendar.date, calendar.race_type, calendar.name as racename, text.race_id from text, calendar where text.race_id=calendar.id order by id desc, id limit 3}]
^if(def $show){
| НЕДАВНИЕ ОБЗОРЫ И СТАТЬИ |
^show.menu{
^if($show.date ne "0000-00-00"){$show.date :}
$race[^table::sql{select name from race_type where id=$show.race_type}]
$race.name
^untaint{$show.name}
$show.racename
|
}
}
}
|
|
