Total Views, replies and threads in forumdisplay_threadlist
Would it be possible to show Total Views, replies and threads in forumdisplay_threadlist? Since there is a totalviews template hack and a simalar hack for showthread.
If its not possible I will try at vbulletin.org when they are done with servermove.
It can be done by phpinclude. Here's a query that should do it:
Code:
mysql> select f.threadcount,f.replycount,sum(t.views) from forum f, thread t where t.forumid = 16 and f.forumid=16 group
by t.forumid;
+-------------+------------+--------------+
| threadcount | replycount | sum(t.views) |
+-------------+------------+--------------+
| 36 | 278 | 2405 |
+-------------+------------+--------------+
1 row in set (0.04 sec)
I'm a bit too busy to release a mod but if somebody else wants to (using PAPI naturally ) that query seems to work nicely. Just remember to add AS clauses everywhere.
02-20-2003, 06:26 PM
Total Views, replies and threads in forumdisplay_threadlist
) that query seems to work nicely. Just remember to add AS clauses everywhere.
Linear Mode
