<% ERuby.import('init.txt') ERuby.import('head.txt') %> <% result = $db.query("SELECT * FROM forum_forums ORDER BY in_order ASC") result.each_hash do |row| topics = $db.query("SELECT COUNT(*) FROM forum_topics WHERE forum_id=#{row['id']}").fetch_row[0].to_i posts = $db.query("SELECT COUNT(*) FROM forum_posts WHERE forum_id=#{row['id']}").fetch_row[0].to_i %> <% if topics == 0 %> <% else subrow = $db.query("SELECT * FROM forum_topics WHERE forum_id=#{row['id']} ORDER BY date_modified DESC LIMIT 1").fetch_hash %> <% end %> <% end %>
Topic Topics Posts Latest Topic
<%=row['name']%>
<%=row['description']%>
<%=topics%> <%=posts%>none <%=subrow['title']%>
<%=Time.at(subrow['date_create'].to_i).strftime('Updated at %H:%M on %B %d')%>
<% ERuby.import('foot.txt') %>