This repository has been archived by the owner on Jan 28, 2018. It is now read-only.
/
all_ajax.php
122 lines (114 loc) · 3.86 KB
/
all_ajax.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
<?php
require_once 'includes/dbconnect.php';
if ($user_id) {
require_once 'includes/functions.php';
$lasttimestamp = mysql_query("SELECT
`timestamp`
FROM
`feeds_entries`
WHERE
".(
(!isset($_GET['show']) || $_GET['show'] == 'unread') ?
"0 = (SELECT
COUNT(`article_id`)
FROM
`feeds_read`
WHERE
`user_id` = ". $user_id. "
AND
`feeds_read`.`article_id` = `feeds_entries`.`article_id`
)
AND"
: '')."
1 = (SELECT
COUNT(`feedid`)
FROM
`feeds_subscription`
WHERE
`userid` =". $user_id. "
AND
`feeds_subscription`.`feedid` = `feeds_entries`.`feed_id`
)
AND timestamp < ".intval($_GET['lasttimestamp'])."
ORDER by
timestamp DESC
LIMIT 30");
while($r = mysql_fetch_object($lasttimestamp)) {$last = $r;}
$lasttimestamp = $last->timestamp;
$all_qry = mysql_query("SELECT
`feed_id`,
IF(
((SELECT alias FROM feeds_subscription WHERE `userid` = ".$user_id." AND `feeds_subscription`.`feedid` = `feeds_entries`.`feed_id`) != ''),
(SELECT alias FROM feeds_subscription WHERE `userid` = ".$user_id." AND `feeds_subscription`.`feedid` = `feeds_entries`.`feed_id`),
`name`
) as `feedtitle`,
`feeds`.`url` as `feedurl`,
`article_id`,
`title`,
`guid`,
`timestamp`,
(SELECT COUNT(*) FROM sticky s WHERE user_id = ".$user_id." AND s.article_id = `feeds_entries`.article_id) as `sticky`,
`summary`,
`article_id`,
`feeds_entries`.`url` as `articleurl`,
(
SELECT
COUNT(`article_id`)
FROM
`feeds_read`
WHERE
`user_id` = ". $user_id. "
AND
`feeds_read`.`article_id` = `feeds_entries`.`article_id`
) as `read_status`
FROM
`feeds_entries`
INNER JOIN
`feeds`
ON `feeds`.`id` = `feeds_entries`.`feed_id`
WHERE
".(
(!isset($_GET['show']) || $_GET['show'] == 'unread') ?
"0 = (SELECT
COUNT(`article_id`)
FROM
`feeds_read`
WHERE
`user_id` = ". $user_id. "
AND
`feeds_read`.`article_id` = `feeds_entries`.`article_id`
)
AND"
: '')."
1 = (SELECT
COUNT(`feedid`)
FROM
`feeds_subscription`
WHERE
`userid` =". $user_id. "
AND
`feeds_subscription`.`feedid` = `feeds_entries`.`feed_id`
)
AND timestamp < ".intval($_GET['lasttimestamp'])."
AND timestamp >= ".intval($lasttimestamp)."
ORDER by
`timestamp` desc");
if($lasttimestamp < 1) $lasttimestamp = 0;
echo '<script type="text/javascript">
lasttimestamp = '.$lasttimestamp.';
</script>';
if(mysql_num_rows($all_qry) == 0) die('<!-- NOTHING MORE -->');
while ($row = mysql_fetch_assoc($all_qry)) {
echo '<div id="article_'.$row["article_id"].'"'.($row["read_status"] == 0 ? ' class="unreadarticle"' : ' class="readarticle'.(($row["sticky"] == 1) ? ' sticky' : '').'"').'>';
echo '<a '. (isset($_GET['mobile']) ? 'onclick="togglearticle('.$row["article_id"].')" href="javascript:void(0);' : 'target="_blank" href="'. $row["articleurl"]). '" class="titlelink">';
echo utf_correct($row["title"]). '</a>';
echo (isset($_GET['mobile']) ? '' : '<br />').'<em>'. date(_("d.m.Y - H:i"), $row["timestamp"]). ': '. utf_correct($row["feedtitle"]). '</em>';
if($row["sticky"] == 1) echo ' · <a href="javascript:unsticky('.$row["article_id"].');" class="stickylink">'._('nicht merken').'</a>';
else echo ' · <a href="javascript:sticky('.$row["article_id"].');" class="stickylink">'._('merken').'</a>';
echo '<br />';
echo '<div class="sum"'.(isset($_GET['mobile']) ? ' style="display:none"><a href="'.$row["articleurl"].'" target="_blank">'._('zum Originalbeitrag').'</a><br />' : '>' ). utf_correct(gzuncompress($row["summary"])). '</div><div class="clear"></div></div>';
}
} else {
echo json_encode(array('error' => _('not logged in')));
exit;
}