Latest postings vs Latest answered threads (Features)
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