From 0d3adafe15b21dde08c89fea8f016d31662fedf9 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 27 Mar 2006 03:47:07 +0100 Subject: more mobile work (add missing files) --- mobile/functions.php | 239 +++++++++++++++++++++++++++++++++++++++++++++++++++ mobile/login.php | 93 ++++++++++++++++++++ mobile/mobile.css | 79 +++++++++++++++++ 3 files changed, 411 insertions(+) create mode 100644 mobile/functions.php create mode 100644 mobile/login.php create mode 100644 mobile/mobile.css diff --git a/mobile/functions.php b/mobile/functions.php new file mode 100644 index 000000000..0cfad9792 --- /dev/null +++ b/mobile/functions.php @@ -0,0 +1,239 @@ +"; + + $owner_uid = $_SESSION["uid"]; + + if (!$tags) { + + /* virtual feeds */ + + if (get_pref($link, 'ENABLE_FEED_CATS')) { + print "
  • Special
  • "; + print "
  • "; + } + + if (GLOBAL_ENABLE_LABELS && get_pref($link, 'ENABLE_LABELS')) { + + $result = db_query($link, "SELECT id,sql_exp,description FROM + ttrss_labels WHERE owner_uid = '$owner_uid' ORDER by description"); + + if (db_num_rows($result) > 0) { + if (get_pref($link, 'ENABLE_FEED_CATS')) { + print "
  • Labels
  • "; + print "
  • "; + } + } + + } + +// if (!get_pref($link, 'ENABLE_FEED_CATS')) { + print "

  • "; +// } + + if (get_pref($link, 'ENABLE_FEED_CATS')) { + $order_by_qpart = "category,title"; + } else { + $order_by_qpart = "title"; + } + + $result = db_query($link, "SELECT ttrss_feeds.*, + (SELECT COUNT(id) FROM ttrss_entries,ttrss_user_entries + WHERE feed_id = ttrss_feeds.id AND + ttrss_user_entries.ref_id = ttrss_entries.id AND + owner_uid = '$owner_uid') AS total, + (SELECT COUNT(id) FROM ttrss_entries,ttrss_user_entries + WHERE feed_id = ttrss_feeds.id AND unread = true + AND ttrss_user_entries.ref_id = ttrss_entries.id + AND owner_uid = '$owner_uid') as unread, + cat_id,last_error, + ttrss_feed_categories.title AS category, + ttrss_feed_categories.collapsed + FROM ttrss_feeds LEFT JOIN ttrss_feed_categories + ON (ttrss_feed_categories.id = cat_id) + WHERE + ttrss_feeds.owner_uid = '$owner_uid' AND parent_feed IS NULL + ORDER BY $order_by_qpart"); + + $actid = $_GET["actid"]; + + /* real feeds */ + + $lnum = 0; + + $total_unread = 0; + + $category = ""; + + while ($line = db_fetch_assoc($result)) { + + $feed = db_unescape_string($line["title"]); + $feed_id = $line["id"]; + + $subop = $_GET["subop"]; + + $total = $line["total"]; + $unread = $line["unread"]; + + $rtl_content = sql_bool_to_bool($line["rtl_content"]); + + if ($rtl_content) { + $rtl_tag = "dir=\"RTL\""; + } else { + $rtl_tag = ""; + } + + $tmp_result = db_query($link, + "SELECT id,COUNT(unread) AS unread + FROM ttrss_feeds LEFT JOIN ttrss_user_entries + ON (ttrss_feeds.id = ttrss_user_entries.feed_id) + WHERE parent_feed = '$feed_id' AND unread = true + GROUP BY ttrss_feeds.id"); + + if (db_num_rows($tmp_result) > 0) { + while ($l = db_fetch_assoc($tmp_result)) { + $unread += $l["unread"]; + } + } + + $cat_id = $line["cat_id"]; + + $tmp_category = $line["category"]; + + if (!$tmp_category) { + $tmp_category = "Uncategorized"; + } + + // $class = ($lnum % 2) ? "even" : "odd"; + + if ($line["last_error"]) { + $class = "error"; + } else { + $class = "feed"; + } + + if ($unread > 0) $class .= "Unread"; + + if ($actid == $feed_id) { + $class .= "Selected"; + } + + $total_unread += $unread; + + if ($category != $tmp_category && get_pref($link, 'ENABLE_FEED_CATS')) { + + if ($category) { + print ""; + } + + $category = $tmp_category; + + $collapsed = $line["collapsed"]; + + // workaround for NULL category + if ($category == "Uncategorized") { + if ($_COOKIE["ttrss_vf_uclps"] == 1) { + $collapsed = "t"; + } + } + + if ($collapsed == "t" || $collapsed == "1") { + $holder_class = "invisible"; + $ellipsis = "..."; + } else { + $holder_class = ""; + $ellipsis = ""; + } + + if ($cat_id) { + $cat_id_qpart = "cat_id = '$cat_id'"; + } else { + $cat_id_qpart = "cat_id IS NULL"; + } + + $tmp_result = db_query($link, "SELECT count(int_id) AS unread + FROM ttrss_user_entries,ttrss_feeds WHERE + unread = true AND + feed_id = ttrss_feeds.id AND $cat_id_qpart AND + ttrss_user_entries.owner_uid = " . $_SESSION["uid"]); + + $cat_unread = db_fetch_result($tmp_result, 0, "unread"); + + $cat_id = sprintf("%d", $cat_id); + + print "
  • + $tmp_category + + ($cat_unread unread)$ellipsis
  • "; + + // !!! NO SPACE before keyboard navigation, etc. + print "
    • "; + } + + printFeedEntry($feed_id, $class, $feed, $unread, + "icons/$feed_id.ico", $link, $rtl_content); + + ++$lnum; + } + + + } else { + print "Function not implemented."; + } + } + +?> diff --git a/mobile/login.php b/mobile/login.php new file mode 100644 index 000000000..0e2d0c8b4 --- /dev/null +++ b/mobile/login.php @@ -0,0 +1,93 @@ + + + + Tiny Tiny RSS : Login + + + + + + +
      + +

      Tiny Tiny RSS

      + +
      + + Login:
      + Password:
      + + +
      + + + + +
      + +
      + + + + + diff --git a/mobile/mobile.css b/mobile/mobile.css new file mode 100644 index 000000000..796bf2395 --- /dev/null +++ b/mobile/mobile.css @@ -0,0 +1,79 @@ +body { + padding : 0px; + margin : 0px; +} + +input { + border : 1px solid #a0a0a0; +} + +.button { + border : 1px solid #d0d0d0; + background-image : url("../images/button.png"); + background-position : top; + background-repeat : repeat-x; + background-color : white; + color : black; +} + +.button:hover { + background : white; + text-decoration : none; + color : black; +} + +td.heading { + font-weight : bold; +} + +td.content { + background-image : url("../images/vgrad_light_rev.png"); + background-position : top left; + background-repeat : repeat-x; + border-width : 1px 0px 0px 0px; + border-style : solid; + border-color : #c0c0c0; +} + +form { + padding : 0px; + margin : 0px; +} + +ul.feedList { + list-style-type : none; + margin : 5px; + padding : 0px 0px 0px 10px; +} + +ul.feedList li.feedCat { + margin : 0px; + padding : 3px 0px 3px 0px; + color : #707070; + font-size : x-small; +} + +ul.feedList li.feedCat a { + color : #707070; +} + +ul.feedList li.feedCat a:hover { + color : #5050aa; +} + +ul.feedCatList { + list-style-type : none; + margin : 0px 0px 0px 20px; + padding : 0px; +} + +ul.feedCatList li { + margin : 0px; + padding : 0px 0px 0px 0px; + color : black; +} + +ul.feedList li { + margin : 0px; +} + -- cgit v1.2.3