svnno****@sourc*****
svnno****@sourc*****
2008年 2月 1日 (金) 21:57:59 JST
Revision: 345
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=bbs2ch&view=rev&rev=345
Author: flyson
Date: 2008-02-01 21:57:59 +0900 (Fri, 01 Feb 2008)
Log Message:
-----------
sql の誤字修正
Modified Paths:
--------------
trunk/bbs2chreader/chrome/content/bbs2chreader/board/items.js
-------------- next part --------------
Modified: trunk/bbs2chreader/chrome/content/bbs2chreader/board/items.js
===================================================================
--- trunk/bbs2chreader/chrome/content/bbs2chreader/board/items.js 2008-01-30 12:48:25 UTC (rev 344)
+++ trunk/bbs2chreader/chrome/content/bbs2chreader/board/items.js 2008-02-01 12:57:59 UTC (rev 345)
@@ -218,7 +218,7 @@
var subscribedOnly = "";
if(aFilterLimit==0){
aFilterLimit = 2000;
- subscribedOnly = "AND sd.line_count > 1";
+ subscribedOnly = "AND td.line_count > 1";
}
var database = b2rStorageService.database;
@@ -228,11 +228,11 @@
bs.dat_id AS dat_id,
bs.title AS title,
bs.line_count AS line_count,
- IFNULL(sd.line_count, 0) AS read,
- MAX(IFNULL(bs.line_count - sd.line_count, 0), 0) AS unread,
+ IFNULL(td.line_count, 0) AS read,
+ MAX(IFNULL(bs.line_count - td.line_count, 0), 0) AS unread,
STRFTIME(?1, bs.dat_id, 'unixepoch', 'localtime') AS make_date
- FROM board_subject AS bs LEFT OUTER JOIN thread_data AS sd
- ON bs.board_id=sd.board_id AND bs.dat_id=sd.dat_id
+ FROM board_subject AS bs LEFT OUTER JOIN thread_data AS td
+ ON bs.board_id=td.board_id AND bs.dat_id=td.dat_id
WHERE bs.board_id=?2 {subscribedOnly}
LIMIT ?3;
</>.toString().replace(/\t/g, "");