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");
?>
