Bad news, the lead
developer of this feature just quit and for very sound reasons:
Code:
Giving up , I have take a look
at this, but I can't really figure out a "fast" way to select the information
this was the SQL used on the
index page
[code]$sql = "SELECT t.forum_id, t.topic_id, p.post_time
FROM " . TOPICS_TABLE . "
t, " . POSTS_TABLE . " p,
" . TOPIC_VIEW_TABLE . " tv
WHERE p.post_id = t.topic_last_post_id
AND p.post_time > tv.view_time
AND tv.user_id = ".$userdata['user_id']."
AND
t.topic_moved_id = 0"; [/code]
(require the user view count mod)
I have removed the mod
from the index, since it was slowing down the main page (load 2.5 sec), so there is no demo availble anymore... I
guess there is too mutch info to search among
I think I'd have to rewrite a lot of stuff to get
this working. I am going to suggest a non database solution to them right now but if that doesn't work it's a no go.