codes****@googl*****
codes****@googl*****
2009年 3月 31日 (火) 22:55:36 JST
Author: mystralkk Date: Tue Mar 31 06:19:51 2009 New Revision: 1365 Modified: trunk/geeklog-1-jp-extended/plugins/filemgmt/functions.inc Log: Issue #64に対応しました。 Modified: trunk/geeklog-1-jp-extended/plugins/filemgmt/functions.inc ============================================================================== --- trunk/geeklog-1-jp-extended/plugins/filemgmt/functions.inc (original) +++ trunk/geeklog-1-jp-extended/plugins/filemgmt/functions.inc Tue Mar 31 06:19:51 2009 @@ -655,7 +655,7 @@ $result = DB_query ("SELECT topic,limits FROM {$_TABLES['syndication']} WHERE fid = $feed"); $F = DB_fetchArray ($result); - $sql = "SELECT lid,title,submitter,date FROM {$_FM_TABLES['filemgmt_filedetail']}" . filemgmt_buildSql ($F['topic'], $F['limits']); + $sql = "SELECT lid,title,submitter,date FROM {$_FM_TABLES['filemgmt_filedetail']} ORDER BY date DESC " . filemgmt_buildSql ($F['topic'], $F['limits']); $result = DB_query ($sql); $num = DB_numRows ($result); for ($i = 0; $i < $num; $i++) {