Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: Importing from vanilla


scooter7978
Member

@scooter7978

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.

Skip to toolbar