Avatar

Latest postings vs Latest answered threads (Features)

by Micha ⌂, Friday, April 20, 2007, 15:01 (6188 days ago)

Hi,

I have on my site a small script which list the last answered threads (for example: see the 2th headline Forenbeiträge)

The sql-query is

 
$sql = "select `id`, UNIX_TIMESTAMP(time), `subject`, `name`, `category` from (select `tid`, `time`, `id`, `subject`, `name`, `category` from `".$db_settings['forum_table']."` order by `time` desc) g1 group by `tid` order by `time` desc limit 0,5";

this one works with "mein kleines Forum" version 1.7. I think it's better to see the aktive threads than the last postings.

Micha

--
applied-geodesy.org - OpenSource Least-Squares Adjustment Software for Geodetic Sciences

locked
5669 views

Complete thread:

 RSS Feed of thread