@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[] $now[^date::now[]] статьи  календарь  результаты  галерея  документы видео @infa[] ^if($form:id>0){ ^connect[$connect_string]{ $cls[^table::sql{select id, class from results where race_id=$form:id group by class}] $cat[^table::sql{select DATE_FORMAT(date, '%d.%m.%Y') as date, race_type, name from calendar where id=$form:id}] $cat.date : $race[^table::sql{select name from race_type where id=$cat.race_type}] $race.name

$cat.name


^cls.menu{ $show[^table::sql{select place, name, time, remark from results where class='$cls.class' && race_id=$form:id order by place}] ^show.menu{ } }
место
имя/команда
 время/очки
примечания
класс: $cls.class
$show.place ^untaint{$show.name} ^untaint{$show.time} ^untaint{$show.remark} 
} }{ ^connect[$connect_string]{ $show[^table::sql{select race_id from results, calendar where calendar.id=results.race_id ^if(def $form:type){&& calendar.race_type=$form:type} group by race_id order by calendar.date desc}] ^if(def $show){ ^show.menu{ }
$cat[^table::sql{select DATE_FORMAT(date, '%d.%m.%Y') as date, race_type, name from calendar where id=$show.race_id}] $cat.date ^if(def $form:type){}{ $race[^table::sql{select name from race_type where id=$cat.race_type}] : $race.name }
$cat.name
} } }