From: <tib...@us...> - 2007-08-06 21:58:26
|
Update of /cvsroot/tikiwiki/tiki/lib/rankings In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv3591/lib/rankings Modified Files: ranklib.php Log Message: limiting a rank query the limiting is not ok jet (not database proof!) Index: ranklib.php =================================================================== RCS file: /cvsroot/tikiwiki/tiki/lib/rankings/ranklib.php,v retrieving revision 1.20 retrieving revision 1.21 diff -u -d -r1.20 -r1.21 --- ranklib.php 16 Jun 2007 16:01:54 -0000 1.20 +++ ranklib.php 6 Aug 2007 21:58:28 -0000 1.21 @@ -118,7 +118,9 @@ $query = "select * from `tiki_comments`,`tiki_forums` where `object`=".$this->sql_cast("`forumId`","string")." and `objectType` = 'forum' - order by `commentDate` desc"; + order by `commentDate` desc + limit ".$limit; + //todo(tibi needs help): make this database proof!! $result = $this->query($query,array()); $ret = array(); |