summaryrefslogtreecommitdiff
path: root/mobile
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2006-08-16 14:13:33 +0100
committerAndrew Dolgov <[email protected]>2006-08-16 14:13:33 +0100
commit318260cc8a4b09403678a1a953fc7d646d3c268d (patch)
tree55754ecd6510353f3e28ef704b1a2385acf90ff3 /mobile
parent3831db41c4b24050ad0ef2d0b58a5a042d4313bb (diff)
move outputFeedList to getFeedUnread, misc. hidden-related fixes
Diffstat (limited to 'mobile')
-rw-r--r--mobile/functions.php18
1 files changed, 3 insertions, 15 deletions
diff --git a/mobile/functions.php b/mobile/functions.php
index 29db101ca..d35e6e237 100644
--- a/mobile/functions.php
+++ b/mobile/functions.php
@@ -32,12 +32,7 @@
print "<li class=\"feedCatHolder\"><ul class=\"feedCatList\">";
}
- $result = db_query($link, "SELECT count(id) as num_starred
- FROM ttrss_entries,ttrss_user_entries
- WHERE marked = true AND
- ttrss_user_entries.ref_id = ttrss_entries.id AND
- unread = true AND owner_uid = '$owner_uid'");
- $num_starred = db_fetch_result($result, 0, "num_starred");
+ $num_starred = getFeedUnread($link, -1);
$class = "virt";
@@ -52,7 +47,7 @@
if (GLOBAL_ENABLE_LABELS && get_pref($link, 'ENABLE_LABELS')) {
- $result = db_query($link, "SELECT id,sql_exp,description FROM
+ $result = db_query($link, "SELECT id,description FROM
ttrss_labels WHERE owner_uid = '$owner_uid' ORDER by description");
if (db_num_rows($result) > 0) {
@@ -68,14 +63,7 @@
error_reporting (0);
- $tmp_result = db_query($link, "SELECT count(ttrss_entries.id) as count
- FROM ttrss_entries,ttrss_user_entries,ttrss_feeds
- WHERE (" . $line["sql_exp"] . ") AND unread = true AND
- ttrss_user_entries.ref_id = ttrss_entries.id AND
- ttrss_user_entries.feed_id = ttrss_feeds.id
- AND ttrss_user_entries.owner_uid = '$owner_uid'");
-
- $count = db_fetch_result($tmp_result, 0, "count");
+ $count = getFeedUnread($link, -$line["id"]-11);
$class = "label";