diff options
| author | Andrew Dolgov <[email protected]> | 2005-12-02 09:33:03 +0100 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2005-12-02 09:33:03 +0100 |
| commit | fa16f30b87d97ba5f1b7658ebcd95248d601f57b (patch) | |
| tree | e9ba1036db2dfa027493bd0d7176f34e9833db5a /xml-export.php | |
| parent | 8fb9aceee28f33592104ae7305ff1d2775889813 (diff) | |
further updates to xml import ui
Diffstat (limited to 'xml-export.php')
| -rw-r--r-- | xml-export.php | 14 |
1 files changed, 8 insertions, 6 deletions
diff --git a/xml-export.php b/xml-export.php index 446d315a0..df497aa8a 100644 --- a/xml-export.php +++ b/xml-export.php @@ -93,15 +93,16 @@ updated, guid, link, - date_entered, - last_read, + SUBSTRING(date_entered,1,16) AS date_entered, + SUBSTRING(last_read,1,16) AS last_read, comments, ttrss_feeds.feed_url AS feed_url, ttrss_feeds.title AS feed_title FROM ttrss_entries,ttrss_feeds WHERE - feed_id = ttrss_feeds.id $marked_qpart $unread_qpart"); + feed_id = ttrss_feeds.id $marked_qpart $unread_qpart + ORDER BY ttrss_entries.id"); } else if ($schema_version == 2) { @@ -113,8 +114,8 @@ updated, guid, link, - date_entered, - last_read, + SUBSTRING(date_entered,1,16) AS date_entered, + SUBSTRING(last_read,1,16) AS last_read, comments, ttrss_feeds.feed_url AS feed_url, ttrss_feeds.title AS feed_title @@ -123,7 +124,8 @@ WHERE ttrss_user_entries.owner_uid = '$owner_uid' AND ref_id = ttrss_entries.id AND - feed_id = ttrss_feeds.id $marked_qpart $unread_qpart"); + feed_id = ttrss_feeds.id $marked_qpart $unread_qpart + ORDER BY ttrss_entries.id"); } else { |