From: <sy...@us...> - 2009-04-08 15:15:05
|
Revision: 17857 http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=17857&view=rev Author: sylvieg Date: 2009-04-08 15:14:50 +0000 (Wed, 08 Apr 2009) Log Message: ----------- [FIX]forum: was not anymore possible to sort on date, the type of the posts was first considered Modified Paths: -------------- branches/3.0/lib/commentslib.php Modified: branches/3.0/lib/commentslib.php =================================================================== --- branches/3.0/lib/commentslib.php 2009-04-08 15:11:49 UTC (rev 17856) +++ branches/3.0/lib/commentslib.php 2009-04-08 15:14:50 UTC (rev 17857) @@ -700,7 +700,7 @@ a.`summary`,a.`smiley`,a.`message_id`,a.`in_reply_to`,a.`comment_rating`,a.`locked`, ". $this->ifNull("a.`archived`", "'n'")." as `archived`,". $this->ifNull("max(b.`commentDate`)","a.`commentDate`")." as `lastPost`,". - $this->ifNull("a.`type`", "'s'")." as `sticky`, + $this->ifNull("a.`type`='s'", 'false')." as `sticky`, count(b.`threadId`) as `replies` from `tiki_comments` a left join `tiki_comments` b on b.`parentId`=a.`threadId` This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |