svnno****@sourc*****
svnno****@sourc*****
2009年 2月 6日 (金) 19:18:15 JST
SRADRevision: 993
http://svn.sourceforge.jp/view?root=slashdotjp&view=rev&rev=993
Author: tach
Date: 2009-02-06 19:18:15 +0900 (Fri, 06 Feb 2009)
Log Message:
-----------
revert r992
Modified Paths:
--------------
slashjp/trunk/plugins/Journal/journal_update_slashbox.pl
-------------- next part --------------
Modified: slashjp/trunk/plugins/Journal/journal_update_slashbox.pl
===================================================================
--- slashjp/trunk/plugins/Journal/journal_update_slashbox.pl 2009-02-06 09:27:46 UTC (rev 992)
+++ slashjp/trunk/plugins/Journal/journal_update_slashbox.pl 2009-02-06 10:18:15 UTC (rev 993)
@@ -39,10 +39,10 @@
slashdLog("Start updating block \"$name\"") if (verbosity() >= 3);
my $result = $slashdb->sqlSelectAllHashrefArray(
- 'nickname AS author,MAX(id) AS jid,description AS title',
- 'journals JOIN users USING (uid)',
+ 'nickname AS author,jid,description AS title',
+ 'users_journal JOIN users USING (uid) JOIN journals on (users_journal.jid=journals.id)',
$where,
- "GROUP BY uid ORDER BY jid DESC LIMIT $limit",
+ "ORDER BY users_journal.date DESC LIMIT $limit",
);
map { $_->{'link'} = "$constants->{absolutedir}/~" . strip_paramattr($_->{author}) . "/journal/". $_->{jid} } @$result;