<% ERuby.import('init.txt') forum_row = $db.query("SELECT * FROM forum_forums WHERE id=#{$cgi['id']}").fetch_hash $navigation.add(forum_row['name'], "forum") ERuby.import('head.txt') %> Start a new topic

<% result = $db.query("SELECT * FROM forum_topics WHERE forum_id=#{$cgi['id']} ORDER BY date_modified DESC") result.each_hash do |row| replies = $db.query("SELECT COUNT(*) AS c FROM forum_posts WHERE topic_id=#{row['id']}").fetch_hash['c'].to_i - 1 %> <% if replies == 0 %> <% else subrow = $db.query("SELECT * FROM forum_posts WHERE topic_id=#{row['id']} ORDER BY date_create DESC LIMIT 1").fetch_hash %> <% end %> <% end %>
Topic Replies Last Reply
<%=row['title']%>
<%=replies%>none<%=Time.at(subrow['date_create'].to_i).strftime('Posted at %H:%M on %B %d')%>

Start a new topic
<% ERuby.import('foot.txt') %>