diff options
author | Andrew Dolgov <[email protected]> | 2005-09-08 04:49:53 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-09-08 04:49:53 +0100 |
commit | c05a19f39615bb9f8acadabcb0c572253a51a035 (patch) | |
tree | 97d94be12cac905451bc1772a376f78b3de34c9b /backend.php | |
parent | c43f77f5923def16dda1b45c75b63671e539526c (diff) |
fix UPD marking on mysql
Diffstat (limited to 'backend.php')
-rw-r--r-- | backend.php | 20 |
1 files changed, 5 insertions, 15 deletions
diff --git a/backend.php b/backend.php index 329f2783d..e74310831 100644 --- a/backend.php +++ b/backend.php @@ -344,7 +344,9 @@ } $result = db_query($link, "SELECT - id,title,updated,unread,feed_id,marked,link,last_read + id,title,updated,unread,feed_id,marked,link,last_read, + SUBSTRING(last_read,1,19) as last_read_noms, + SUBSTRING(updated,1,19) as updated_noms FROM ttrss_entries WHERE @@ -364,25 +366,13 @@ $id = $line["id"]; $feed_id = $line["feed_id"]; -/* if ($line["last_read"] && $line["updated"] && - strtotime($line["last_read"]) < strtotime($line["updated"]) && - ($line["unread"] == "f" || $line["unread"] == "0")) { - - $update_pic = "<img id='FUPDPIC-$id' src=\"images/updated.png\" - alt=\"Updated\">"; - ++$num_unread; - } else { - $update_pic = "<img id='FUPDPIC-$id' src=\"images/blank_icon.png\" - alt=\"Updated\">"; - } */ - // printf("L %d (%s) > U %d (%s) = %d<br>", -// strtotime($line["last_read"]), $line["last_read"], +// strtotime($line["last_read_noms"]), $line["last_read_noms"], // strtotime($line["updated"]), $line["updated"], // strtotime($line["last_read"]) >= strtotime($line["updated"])); if ($line["last_read"] != "" && $line["updated"] != "" && - strtotime($line["last_read"]) < strtotime($line["updated"])) { + strtotime($line["last_read_noms"]) < strtotime($line["updated_noms"])) { $update_pic = "<img id='FUPDPIC-$id' src=\"images/updated.png\" alt=\"Updated\">"; |