if ($user_id) { if (empty($_GET["feedid"])) { header('Location: m_all.php?mobile=true'); exit; } require_once 'includes/functions.php'; require 'includes/mobile_header.php'; if (!empty($_GET["feedid"])) { $is_sub = mysql_query("SELECT `feeds`.`name`, alias FROM `feeds_subscription` INNER JOIN `feeds` ON `feeds`.`id` = `feeds_subscription`.`feedid` WHERE `feedid` = " . intval($_GET["feedid"]) . " AND `userid` =" . $user_id); if (mysql_num_rows($is_sub) == 1) { $feed = mysql_fetch_assoc($is_sub); ?> <div id="wrap"> <div id="topbar"> <a href="m_all.php"><img src="images/gfr.gif" alt="geek's factory reader" /></a> <?php selarea(utf_correct($feed['alias'] ? $feed['alias'] : $feed['name'])); ?> </div> <p id="subnav"> <?php if (!isset($_GET['show']) || $_GET['show'] == 'unread') { echo '<strong>' . _('Ungelesene Einträge') . '</strong> · '; } else { echo '<a href="?feedid=' . intval($_GET['feedid']) . '&show=unread">' . _('Ungelesene Einträge') . '</a> · '; } if (isset($_GET['show']) && $_GET['show'] == 'all') { echo '<strong>' . _('Alle Einträge') . '</strong>'; } else { echo '<a href="?feedid=' . intval($_GET['feedid']) . '&show=all">' . _('Alle Einträge') . '</a>'; } ?>
<?php define('IS_MOBILE', true); require_once 'includes/dbconnect.php'; if ($user_id) { require_once 'includes/functions.php'; require 'includes/mobile_header.php'; ?> <div id="wrap"> <div id="topbar"> <a href="m_all.php"><img src="images/gfr.gif" alt="geek's factory reader" /></a> <?php selarea(_("Gemerkte Artikel")); ?> </div> <p id="subnav"> <a href="sticky_ajax.php?unsticky=all&mobile=true"><?php echo _("Alle entfernen"); ?> </a> </p> <?php $all_qry = mysql_query("SELECT\n\t\t\t\t`feed_id`,\n\t\t\t\tIF(\n\t\t\t\t\t((SELECT alias FROM feeds_subscription WHERE `userid` = " . $user_id . " AND `feeds_subscription`.`feedid` = `feeds_entries`.`feed_id`) != ''),\n\t\t\t\t\t(SELECT alias FROM feeds_subscription WHERE `userid` = " . $user_id . " AND `feeds_subscription`.`feedid` = `feeds_entries`.`feed_id`),\n\t\t\t\t\t`name`\n\t\t\t\t) as `feedtitle`,\n\t\t\t\t`feeds`.`url` as `feedurl`,\n\t\t\t\t`article_id`,\n\t\t\t\t`title`,\n\t\t\t\t`guid`,\n\t\t\t\t`timestamp`,\n\t\t\t\t`article_id`,\n\t\t\t\t`summary`,\n\t\t\t\t`feeds_entries`.`url` as `articleurl`,\n\t\t\t\t(\n\t\t\t\t\tSELECT\n\t\t\t\t\t\tCOUNT(`article_id`)\n\t\t\t\t\tFROM\n\t\t\t\t\t\t`feeds_read`\n\t\t\t\t\tWHERE\n\t\t\t\t\t\t`user_id` = " . $user_id . "\n\t\t\t\t\tAND\n\t\t\t\t\t\t`feeds_read`.`article_id` = `feeds_entries`.`article_id`\n\t\t\t\t) as `read_status`\n\t\t\t\tFROM\n\t\t\t\t\t`feeds_entries`\n\t\t\t\tINNER JOIN\n\t\t\t\t\t`feeds`\n\t\t\t\t\tON\n\t\t\t\t\t\t`feeds`.`id` = `feeds_entries`.`feed_id`\n\t\t\t\tWHERE\n\t\t\t\t\t1 = (SELECT\n\t\t\t\t\t\t\tCOUNT(`article_id`)\n\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t`sticky`\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t`user_id` = " . $user_id . "\n\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t`sticky`.`article_id` = `feeds_entries`.`article_id`\n\t\t\t\t\t)\n\t\t\t\t\tAND\n\t\t\t\t\t1 = (SELECT\n\t\t\t\t\t\t\tCOUNT(`feedid`)\n\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t`feeds_subscription`\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t`userid` =" . $user_id . "\n\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t`feeds_subscription`.`feedid` = `feeds_entries`.`feed_id`\n\t\t\t\t\t)\n\t\t\t\tORDER by \n\t\t\t\t\t`timestamp` desc"); if (mysql_num_rows($all_qry) == 0) { echo '<p class="info"> ' . _('Du hast dir keine Einträge gemerkt!') . ' </p>'; } while ($row = mysql_fetch_assoc($all_qry)) { echo '<div id="article_' . $row["article_id"] . '" class="sticky">'; echo '<a href="javascript:void(0);" class="titlelink" onclick="togglearticle(' . $row["article_id"] . ')">' . utf_correct($row["title"]) . '</a>'; echo '<em>' . date(_("d.m.Y - H:i"), $row["timestamp"]) . ': ' . utf_correct($row["feedtitle"]) . '</em>';
<?php define('IS_MOBILE', true); require_once 'includes/dbconnect.php'; if ($user_id) { require_once 'includes/functions.php'; require 'includes/mobile_header.php'; ?> <div id="wrap"> <div id="topbar"> <a href="m_all.php"><img src="images/gfr.gif" alt="geek's factory reader" /></a> <?php selarea(_("Alle Feeds")); ?> </div> <p id="subnav"> <?php if (!isset($_GET['show']) || $_GET['show'] == 'unread') { echo '<strong>' . 'Ungelesene Einträge' . '</strong> · '; } else { echo '<a href="?show=unread">' . _('Ungelesene Einträge') . '</a> · '; } if (isset($_GET['show']) && $_GET['show'] == 'all') { echo '<strong>' . 'Alle Einträge' . '</strong>'; } else { echo '<a href="?show=all">' . _('Alle Einträge') . '</a>'; } ?> <br /> <a href="markasread.php?feedid=all&mobile=true"><?php echo _("Alles als gelesen markieren"); ?>