Re: Importing from vanilla
I’ve refined it a bit further so that it grabs the last post ID of each of the topics so that the ‘freshness’ links work fine for old posts…
I replaced the SQL to get the topics:
(SELECT 0) as LastPostID
to:
(SELECT MAX(CommentID) FROM LUM_Comment WHERE DiscussionID=LUM_Discussion.DiscussionID) AS LastPostID
I can’t edit my original post so if you use the above SQL, make sure you add this bit in.