Hi guys, Are you tired of seeing the Gravatar’s default image? Are your members to lazy to upload their profile pic? Spice up your website by generating a different default user image upon registration. Image generated is different from each users because the algorithm is based on the email address. If you are interested, you […]
Read More
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. […]
Read More