Archive for the ‘Vanilla Forum Tips & Tricks’ Category

Last Comment In DiscussionExcerpt2

 

NOTE: BACKUP FIRST BEFORE YOU EDIT or OVERWRITE FILES! 1. go to /applications/vanilla/models/class.discussionmodel.php inside the method public function DiscussionSummaryQuery($AdditionalFields = array()) { Add the bold one // Buid main query $this->SQL ->Select(‘d.InsertUserID’, ”, ‘FirstUserID’) ->Select(‘lc.Body’,”,’LastUserComment’) … add also ->Join(‘User lcu’, ‘d.LastCommentUserID = lcu.UserID’, ‘left’) // Last comment user ->Join(‘Comment lc’, ‘d.LastCommentID = lc.CommentID’, ‘left’) 2. […]

 Page 2 of 2 « 1  2 

Google Ads