From: Kristian K. <kr...@ko...> - 2002-12-24 22:31:16
|
mod-user_pages.php does list all pages for which the current user is the = last=20 editor. The modules does cut off the listing after a limit of lines. The=20 module is fed by get_user_pages from tikilib. The query in get_user_pages does not define a listing order. I believe it= is=20 desireable to have a descending order by lastModif in this box, because i= f=20 the listing is being cut off you would want the newest of your pages to b= e=20 listed. The following patch against the current CVS does implement this. I sleep now, =09Kristian Index: lib/tikilib.php =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D RCS file: /cvsroot/tikiwiki/tiki/lib/tikilib.php,v retrieving revision 1.24 diff -u -r1.24 tikilib.php --- lib/tikilib.php 24 Dec 2002 20:37:05 -0000 1.24 +++ lib/tikilib.php 24 Dec 2002 22:28:25 -0000 @@ -8617,7 +8617,7 @@ function get_user_pages($user,$max) { - $query =3D "select pageName from tiki_pages where user=3D'$user' lim= it=20 0,$max"; + $query =3D "select pageName from tiki_pages where user=3D'$user' ord= er by=20 lastModif desc limit 0,$max"; $result =3D $this->db->query($query); if(DB::isError($result)) $this->sql_error($query,$result); $ret=3DArray(); @@ -9365,4 +9365,4 @@ return $rv; } -?> \ No newline at end of file +?> --=20 http://www.amazon.de/exec/obidos/wishlist/18E5SVQ5HJZXG |