]>
Commit | Line | Data |
---|---|---|
40d13c28 | 1 | <? |
f1a80dae | 2 | |
cce28758 AD |
3 | if ($_GET["debug"]) { |
4 | define('DEFAULT_ERROR_LEVEL', E_ALL); | |
5 | } else { | |
6 | define('DEFAULT_ERROR_LEVEL', E_ERROR | E_WARNING | E_PARSE); | |
7 | } | |
8 | ||
40d13c28 | 9 | require_once 'config.php'; |
b619ff15 | 10 | require_once 'db-prefs.php'; |
5bc0bd27 | 11 | require_once 'compat.php'; |
40d13c28 | 12 | |
387234f3 AD |
13 | require_once 'magpierss/rss_utils.inc'; |
14 | ||
a3ee2a38 AD |
15 | define('MAGPIE_OUTPUT_ENCODING', 'UTF-8'); |
16 | ||
ad507f85 AD |
17 | function purge_feed($link, $feed_id, $purge_interval, $debug = false) { |
18 | ||
19 | $rows = -1; | |
4c193675 | 20 | |
fefa6ca3 | 21 | if (DB_TYPE == "pgsql") { |
ad507f85 | 22 | $result = db_query($link, "DELETE FROM ttrss_user_entries WHERE |
fefa6ca3 | 23 | marked = false AND feed_id = '$feed_id' AND |
35d8cf43 AD |
24 | (SELECT date_entered FROM ttrss_entries WHERE |
25 | id = ref_id) < NOW() - INTERVAL '$purge_interval days'"); | |
ad507f85 AD |
26 | |
27 | $rows = pg_affected_rows($result); | |
28 | ||
fefa6ca3 | 29 | } else { |
ad507f85 | 30 | $result = db_query($link, "DELETE FROM ttrss_user_entries WHERE |
fefa6ca3 | 31 | marked = false AND feed_id = '$feed_id' AND |
35d8cf43 AD |
32 | (SELECT date_entered FROM ttrss_entries WHERE |
33 | id = ref_id) < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)"); | |
ad507f85 AD |
34 | $rows = mysql_affected_rows($link); |
35 | ||
36 | } | |
37 | ||
38 | if ($debug) { | |
39 | print "Purged feed $feed_id ($purge_interval): deleted $rows articles\n"; | |
fefa6ca3 AD |
40 | } |
41 | } | |
42 | ||
43 | function global_purge_old_posts($link, $do_output = false) { | |
44 | ||
45 | $result = db_query($link, | |
ad507f85 | 46 | "SELECT id,purge_interval,owner_uid FROM ttrss_feeds ORDER BY id"); |
fefa6ca3 AD |
47 | |
48 | while ($line = db_fetch_assoc($result)) { | |
49 | ||
50 | $feed_id = $line["id"]; | |
51 | $purge_interval = $line["purge_interval"]; | |
52 | $owner_uid = $line["owner_uid"]; | |
53 | ||
54 | if ($purge_interval == 0) { | |
55 | ||
56 | $tmp_result = db_query($link, | |
57 | "SELECT value FROM ttrss_user_prefs WHERE | |
58 | pref_name = 'PURGE_OLD_DAYS' AND owner_uid = '$owner_uid'"); | |
59 | ||
60 | if (db_num_rows($tmp_result) != 0) { | |
61 | $purge_interval = db_fetch_result($tmp_result, 0, "value"); | |
62 | } | |
63 | } | |
64 | ||
65 | if ($do_output) { | |
ad507f85 | 66 | // print "Feed $feed_id: purge interval = $purge_interval\n"; |
fefa6ca3 AD |
67 | } |
68 | ||
69 | if ($purge_interval > 0) { | |
ad507f85 | 70 | purge_feed($link, $feed_id, $purge_interval, $do_output); |
fefa6ca3 AD |
71 | } |
72 | } | |
73 | ||
71604ca4 AD |
74 | // purge orphaned posts in main content table |
75 | db_query($link, "DELETE FROM ttrss_entries WHERE | |
76 | (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0"); | |
77 | ||
fefa6ca3 AD |
78 | } |
79 | ||
b6eefba5 | 80 | function purge_old_posts($link) { |
5d73494a | 81 | |
f1a80dae AD |
82 | $user_id = $_SESSION["uid"]; |
83 | ||
84 | $result = db_query($link, "SELECT id,purge_interval FROM ttrss_feeds | |
85 | WHERE owner_uid = '$user_id'"); | |
5d73494a AD |
86 | |
87 | while ($line = db_fetch_assoc($result)) { | |
88 | ||
89 | $feed_id = $line["id"]; | |
90 | $purge_interval = $line["purge_interval"]; | |
91 | ||
b619ff15 | 92 | if ($purge_interval == 0) $purge_interval = get_pref($link, 'PURGE_OLD_DAYS'); |
5d73494a | 93 | |
140aae81 | 94 | if ($purge_interval > 0) { |
fefa6ca3 | 95 | purge_feed($link, $feed_id, $purge_interval); |
5d73494a AD |
96 | } |
97 | } | |
71604ca4 AD |
98 | |
99 | // purge orphaned posts in main content table | |
100 | db_query($link, "DELETE FROM ttrss_entries WHERE | |
101 | (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0"); | |
c3a8d71a AD |
102 | } |
103 | ||
1f2b01ed | 104 | function update_all_feeds($link, $fetch, $user_id = false, $force_daemon = false) { |
40d13c28 | 105 | |
4769ddaf | 106 | if (WEB_DEMO_MODE) return; |
b0b4abcf | 107 | |
a2770077 AD |
108 | if (!$user_id) { |
109 | $user_id = $_SESSION["uid"]; | |
110 | purge_old_posts($link); | |
111 | } | |
112 | ||
25af8dad | 113 | // db_query($link, "BEGIN"); |
b82af8c3 | 114 | |
cbd8650d AD |
115 | if (MAX_UPDATE_TIME > 0) { |
116 | if (DB_TYPE == "mysql") { | |
117 | $q_order = "RAND()"; | |
118 | } else { | |
119 | $q_order = "RANDOM()"; | |
120 | } | |
121 | } else { | |
122 | $q_order = "last_updated DESC"; | |
123 | } | |
124 | ||
d148926e | 125 | $result = db_query($link, "SELECT feed_url,id, |
798f722b | 126 | SUBSTRING(last_updated,1,19) AS last_updated, |
5c563acd | 127 | update_interval FROM ttrss_feeds WHERE owner_uid = '$user_id' |
cbd8650d AD |
128 | ORDER BY $q_order"); |
129 | ||
130 | $upd_start = time(); | |
40d13c28 | 131 | |
b6eefba5 | 132 | while ($line = db_fetch_assoc($result)) { |
d148926e AD |
133 | $upd_intl = $line["update_interval"]; |
134 | ||
b619ff15 | 135 | if (!$upd_intl || $upd_intl == 0) { |
a2770077 | 136 | $upd_intl = get_pref($link, 'DEFAULT_UPDATE_INTERVAL', $user_id); |
b619ff15 | 137 | } |
d148926e | 138 | |
c1e202b7 AD |
139 | if ($upd_intl < 0) { |
140 | // Updates for this feed are disabled | |
141 | continue; | |
142 | } | |
143 | ||
93d40f50 AD |
144 | if ($fetch || (!$line["last_updated"] || |
145 | time() - strtotime($line["last_updated"]) > ($upd_intl * 60))) { | |
c5142cca | 146 | |
cbd8650d AD |
147 | // print "<!-- feed: ".$line["feed_url"]." -->"; |
148 | ||
1f2b01ed | 149 | update_rss_feed($link, $line["feed_url"], $line["id"], $force_daemon); |
cbd8650d AD |
150 | |
151 | $upd_elapsed = time() - $upd_start; | |
152 | ||
153 | if (MAX_UPDATE_TIME > 0 && $upd_elapsed > MAX_UPDATE_TIME) { | |
154 | return; | |
155 | } | |
d148926e | 156 | } |
40d13c28 AD |
157 | } |
158 | ||
25af8dad | 159 | // db_query($link, "COMMIT"); |
b82af8c3 | 160 | |
40d13c28 AD |
161 | } |
162 | ||
9e997874 | 163 | function check_feed_favicon($feed_url, $feed, $link) { |
78800912 AD |
164 | $feed_url = str_replace("http://", "", $feed_url); |
165 | $feed_url = preg_replace("/\/.*$/", "", $feed_url); | |
166 | ||
167 | $icon_url = "http://$feed_url/favicon.ico"; | |
273a2f6b | 168 | $icon_file = ICONS_DIR . "/$feed.ico"; |
78800912 AD |
169 | |
170 | if (!file_exists($icon_file)) { | |
e695fdc8 | 171 | |
78800912 AD |
172 | error_reporting(0); |
173 | $r = fopen($icon_url, "r"); | |
cce28758 | 174 | error_reporting (DEFAULT_ERROR_LEVEL); |
78800912 AD |
175 | |
176 | if ($r) { | |
7d7cbaf5 | 177 | $tmpfname = tempnam(TMP_DIRECTORY, "ttrssicon"); |
78800912 AD |
178 | |
179 | $t = fopen($tmpfname, "w"); | |
180 | ||
181 | while (!feof($r)) { | |
182 | $buf = fread($r, 16384); | |
183 | fwrite($t, $buf); | |
184 | } | |
185 | ||
186 | fclose($r); | |
187 | fclose($t); | |
188 | ||
e695fdc8 AD |
189 | error_reporting(0); |
190 | if (!rename($tmpfname, $icon_file)) { | |
191 | unlink($tmpfname); | |
192 | } | |
717f5e64 AD |
193 | |
194 | chmod($icon_file, 0644); | |
195 | ||
cce28758 | 196 | error_reporting (DEFAULT_ERROR_LEVEL); |
78800912 AD |
197 | |
198 | } | |
199 | } | |
200 | } | |
201 | ||
ddb68b81 | 202 | function update_rss_feed($link, $feed_url, $feed, $ignore_daemon = false) { |
40d13c28 | 203 | |
4769ddaf | 204 | if (WEB_DEMO_MODE) return; |
b0b4abcf | 205 | |
ddb68b81 | 206 | if (DAEMON_REFRESH_ONLY && !$_GET["daemon"] && !$ignore_daemon) { |
21cfcdf2 AD |
207 | return; |
208 | } | |
209 | ||
47c6c988 | 210 | $result = db_query($link, "SELECT update_interval,auth_login,auth_pass |
a88c1f36 AD |
211 | FROM ttrss_feeds WHERE id = '$feed'"); |
212 | ||
47c6c988 AD |
213 | $auth_login = db_fetch_result($result, 0, "auth_login"); |
214 | $auth_pass = db_fetch_result($result, 0, "auth_pass"); | |
215 | ||
a88c1f36 AD |
216 | $update_interval = db_fetch_result($result, 0, "update_interval"); |
217 | ||
218 | if ($update_interval < 0) { return; } | |
219 | ||
ab3d0b99 AD |
220 | $feed = db_escape_string($feed); |
221 | ||
47c6c988 AD |
222 | $fetch_url = $feed_url; |
223 | ||
224 | if ($auth_login && $auth_pass) { | |
225 | $url_parts = array(); | |
226 | preg_match("/(^[^:]*):\/\/(.*)/", $fetch_url, $url_parts); | |
227 | ||
228 | if ($url_parts[1] && $url_parts[2]) { | |
229 | $fetch_url = $url_parts[1] . "://$auth_login:$auth_pass@" . $url_parts[2]; | |
230 | } | |
231 | ||
232 | } | |
3ad5aa85 | 233 | error_reporting(0); |
47c6c988 | 234 | $rss = fetch_rss($fetch_url); |
ab3d0b99 | 235 | |
cce28758 | 236 | error_reporting (DEFAULT_ERROR_LEVEL); |
76798ff3 | 237 | |
b6eefba5 | 238 | $feed = db_escape_string($feed); |
dcee8f61 | 239 | |
40d13c28 | 240 | if ($rss) { |
b82af8c3 | 241 | |
dd8c76a9 AD |
242 | db_query($link, "BEGIN"); |
243 | ||
a88c1f36 | 244 | $result = db_query($link, "SELECT title,icon_url,site_url,owner_uid |
f324892e | 245 | FROM ttrss_feeds WHERE id = '$feed'"); |
331900c6 | 246 | |
b6eefba5 AD |
247 | $registered_title = db_fetch_result($result, 0, "title"); |
248 | $orig_icon_url = db_fetch_result($result, 0, "icon_url"); | |
f324892e | 249 | $orig_site_url = db_fetch_result($result, 0, "site_url"); |
331900c6 | 250 | |
7fed1940 AD |
251 | $owner_uid = db_fetch_result($result, 0, "owner_uid"); |
252 | ||
a2770077 AD |
253 | if (get_pref($link, 'ENABLE_FEED_ICONS', $owner_uid)) { |
254 | check_feed_favicon($feed_url, $feed, $link); | |
255 | } | |
256 | ||
746b249f | 257 | if (!$registered_title || $registered_title == "[Unknown]") { |
e1305a97 | 258 | $feed_title = db_escape_string($rss->channel["title"]); |
f324892e AD |
259 | db_query($link, "UPDATE ttrss_feeds SET |
260 | title = '$feed_title' WHERE id = '$feed'"); | |
261 | } | |
262 | ||
147f7691 | 263 | $site_url = $rss->channel["link"]; |
832b7bfc AD |
264 | // weird, weird Magpie |
265 | if (!$site_url) $site_url = db_escape_string($rss->channel["link_"]); | |
147f7691 AD |
266 | |
267 | if ($site_url && $orig_site_url != db_escape_string($site_url)) { | |
f324892e AD |
268 | db_query($link, "UPDATE ttrss_feeds SET |
269 | site_url = '$site_url' WHERE id = '$feed'"); | |
331900c6 | 270 | } |
40d13c28 | 271 | |
b7f4bda2 AD |
272 | // print "I: " . $rss->channel["image"]["url"]; |
273 | ||
274 | $icon_url = $rss->image["url"]; | |
275 | ||
147f7691 | 276 | if ($icon_url && !$orig_icon_url != db_escape_string($icon_url)) { |
b6eefba5 AD |
277 | $icon_url = db_escape_string($icon_url); |
278 | db_query($link, "UPDATE ttrss_feeds SET icon_url = '$icon_url' WHERE id = '$feed'"); | |
b7f4bda2 AD |
279 | } |
280 | ||
e6155a06 AD |
281 | |
282 | $filters = array(); | |
283 | ||
4b3dff6e | 284 | $result = db_query($link, "SELECT reg_exp, |
db42b934 AD |
285 | ttrss_filter_types.name AS name, |
286 | ttrss_filter_actions.name AS action | |
287 | FROM ttrss_filters,ttrss_filter_types,ttrss_filter_actions WHERE | |
288 | owner_uid = $owner_uid AND | |
289 | ttrss_filter_types.id = filter_type AND | |
290 | ttrss_filter_actions.id = action_id AND | |
ead60402 | 291 | (feed_id IS NULL OR feed_id = '$feed')"); |
e6155a06 | 292 | |
b6eefba5 | 293 | while ($line = db_fetch_assoc($result)) { |
e6155a06 | 294 | if (!$filters[$line["name"]]) $filters[$line["name"]] = array(); |
19c9cb11 AD |
295 | |
296 | $filter["reg_exp"] = $line["reg_exp"]; | |
297 | $filter["action"] = $line["action"]; | |
298 | ||
299 | array_push($filters[$line["name"]], $filter); | |
e6155a06 AD |
300 | } |
301 | ||
ddb68b81 AD |
302 | $iterator = $rss->items; |
303 | ||
304 | if (!$iterator) $iterator = $rss->entries; | |
305 | if (!$iterator) $iterator = $rss; | |
306 | ||
307 | foreach ($iterator as $item) { | |
40d13c28 AD |
308 | |
309 | $entry_guid = $item["id"]; | |
310 | ||
311 | if (!$entry_guid) $entry_guid = $item["guid"]; | |
312 | if (!$entry_guid) $entry_guid = $item["link"]; | |
466001c4 AD |
313 | |
314 | if (!$entry_guid) continue; | |
a116f569 | 315 | |
9c9c7e6b | 316 | $entry_timestamp = ""; |
b82af8c3 | 317 | |
9c9c7e6b AD |
318 | $rss_2_date = $item['pubdate']; |
319 | $rss_1_date = $item['dc']['date']; | |
320 | $atom_date = $item['issued']; | |
59ba2c75 | 321 | if (!$atom_date) $atom_date = $item['updated']; |
b197f117 | 322 | |
9c9c7e6b AD |
323 | if ($atom_date != "") $entry_timestamp = parse_w3cdtf($atom_date); |
324 | if ($rss_1_date != "") $entry_timestamp = parse_w3cdtf($rss_1_date); | |
325 | if ($rss_2_date != "") $entry_timestamp = strtotime($rss_2_date); | |
b82af8c3 AD |
326 | |
327 | if ($entry_timestamp == "") { | |
328 | $entry_timestamp = time(); | |
329 | $no_orig_date = 'true'; | |
466001c4 AD |
330 | } else { |
331 | $no_orig_date = 'false'; | |
b82af8c3 | 332 | } |
b197f117 | 333 | |
466001c4 | 334 | $entry_timestamp_fmt = strftime("%Y/%m/%d %H:%M:%S", $entry_timestamp); |
71ad3959 | 335 | |
40d13c28 | 336 | $entry_title = $item["title"]; |
ddb68b81 AD |
337 | |
338 | // strange Magpie workaround | |
339 | $entry_link = $item["link_"]; | |
340 | if (!$entry_link) $entry_link = $item["link"]; | |
71ad3959 AD |
341 | |
342 | if (!$entry_title) continue; | |
343 | if (!$entry_link) continue; | |
344 | ||
1696229f AD |
345 | $entry_content = $item["content:escaped"]; |
346 | ||
347 | if (!$entry_content) $entry_content = $item["content:encoded"]; | |
40d13c28 | 348 | if (!$entry_content) $entry_content = $item["content"]; |
372ced8b | 349 | if (!$entry_content) $entry_content = $item["summary"]; |
1696229f | 350 | if (!$entry_content) $entry_content = $item["description"]; |
a2015351 | 351 | |
a116f569 | 352 | // if (!$entry_content) continue; |
a2015351 | 353 | |
8add756a AD |
354 | // WTF |
355 | if (is_array($entry_content)) { | |
356 | $entry_content = $entry_content["encoded"]; | |
1696229f | 357 | if (!$entry_content) $entry_content = $entry_content["escaped"]; |
8add756a AD |
358 | } |
359 | ||
1696229f | 360 | // print_r($item); |
372ced8b AD |
361 | // print_r(htmlspecialchars($entry_content)); |
362 | // print "<br>"; | |
1696229f | 363 | |
372ced8b | 364 | $entry_content_unescaped = $entry_content; |
466001c4 | 365 | $content_hash = "SHA1:" . sha1(strip_tags($entry_content)); |
cb0bd8bd | 366 | |
a1ea1e12 AD |
367 | $entry_comments = $item["comments"]; |
368 | ||
b6104dee AD |
369 | $entry_author = db_escape_string($item['dc']['creator']); |
370 | ||
b6eefba5 | 371 | $entry_guid = db_escape_string($entry_guid); |
2651fc4f | 372 | |
05732aa0 AD |
373 | $result = db_query($link, "SELECT id FROM ttrss_entries |
374 | WHERE guid = '$entry_guid'"); | |
4c193675 | 375 | |
b17fcb1a AD |
376 | $entry_content = db_escape_string($entry_content); |
377 | $entry_title = db_escape_string($entry_title); | |
378 | $entry_link = db_escape_string($entry_link); | |
379 | $entry_comments = db_escape_string($entry_comments); | |
380 | ||
27f089dc | 381 | $num_comments = db_escape_string($item["slash"]["comments"]); |
11b0dce2 | 382 | |
e31073bd AD |
383 | if (!$num_comments) $num_comments = 0; |
384 | ||
4c193675 AD |
385 | if (db_num_rows($result) == 0) { |
386 | ||
387 | // base post entry does not exist, create it | |
388 | ||
4c193675 AD |
389 | $result = db_query($link, |
390 | "INSERT INTO ttrss_entries | |
391 | (title, | |
392 | guid, | |
393 | link, | |
394 | updated, | |
395 | content, | |
396 | content_hash, | |
397 | no_orig_date, | |
398 | date_entered, | |
11b0dce2 | 399 | comments, |
b6104dee AD |
400 | num_comments, |
401 | author) | |
4c193675 AD |
402 | VALUES |
403 | ('$entry_title', | |
404 | '$entry_guid', | |
405 | '$entry_link', | |
406 | '$entry_timestamp_fmt', | |
407 | '$entry_content', | |
408 | '$content_hash', | |
409 | $no_orig_date, | |
410 | NOW(), | |
11b0dce2 | 411 | '$entry_comments', |
b6104dee AD |
412 | '$num_comments', |
413 | '$entry_author')"); | |
8926aab8 AD |
414 | } else { |
415 | // we keep encountering the entry in feeds, so we need to | |
416 | // update date_entered column so that we don't get horrible | |
417 | // dupes when the entry gets purged and reinserted again e.g. | |
418 | // in the case of SLOW SLOW OMG SLOW updating feeds | |
419 | ||
420 | $base_entry_id = db_fetch_result($result, 0, "id"); | |
421 | ||
422 | db_query($link, "UPDATE ttrss_entries SET date_entered = NOW() | |
423 | WHERE id = '$base_entry_id'"); | |
4c193675 AD |
424 | } |
425 | ||
426 | // now it should exist, if not - bad luck then | |
427 | ||
6385315d AD |
428 | $result = db_query($link, "SELECT |
429 | id,content_hash,no_orig_date,title, | |
8926aab8 | 430 | substring(date_entered,1,19) as date_entered, |
11b0dce2 AD |
431 | substring(updated,1,19) as updated, |
432 | num_comments | |
6385315d AD |
433 | FROM |
434 | ttrss_entries | |
435 | WHERE guid = '$entry_guid'"); | |
4c193675 AD |
436 | |
437 | if (db_num_rows($result) == 1) { | |
438 | ||
11b0dce2 AD |
439 | // this will be used below in update handler |
440 | $orig_content_hash = db_fetch_result($result, 0, "content_hash"); | |
441 | $orig_title = db_fetch_result($result, 0, "title"); | |
442 | $orig_num_comments = db_fetch_result($result, 0, "num_comments"); | |
8926aab8 AD |
443 | $orig_date_entered = strtotime(db_fetch_result($result, |
444 | 0, "date_entered")); | |
6385315d | 445 | |
11b0dce2 | 446 | $ref_id = db_fetch_result($result, 0, "id"); |
4c193675 | 447 | |
11b0dce2 | 448 | // check for user post link to main table |
4c193675 | 449 | |
11b0dce2 AD |
450 | // do we allow duplicate posts with same GUID in different feeds? |
451 | if (get_pref($link, "ALLOW_DUPLICATE_POSTS", $owner_uid)) { | |
452 | $dupcheck_qpart = "AND feed_id = '$feed'"; | |
453 | } else { | |
454 | $dupcheck_qpart = ""; | |
455 | } | |
71604ca4 | 456 | |
11b0dce2 | 457 | // error_reporting(0); |
19c9cb11 | 458 | |
11b0dce2 AD |
459 | $filter_name = get_filter_name($entry_title, $entry_content, |
460 | $entry_link, $filters); | |
19c9cb11 | 461 | |
11b0dce2 AD |
462 | if ($filter_name == "filter") { |
463 | continue; | |
464 | } | |
19c9cb11 | 465 | |
11b0dce2 | 466 | // error_reporting (DEFAULT_ERROR_LEVEL); |
3a933f22 | 467 | |
11b0dce2 AD |
468 | $result = db_query($link, |
469 | "SELECT ref_id FROM ttrss_user_entries WHERE | |
470 | ref_id = '$ref_id' AND owner_uid = '$owner_uid' | |
471 | $dupcheck_qpart"); | |
472 | ||
473 | // okay it doesn't exist - create user entry | |
474 | if (db_num_rows($result) == 0) { | |
475 | ||
476 | if ($filter_name != 'catchup') { | |
477 | $unread = 'true'; | |
478 | $last_read_qpart = 'NULL'; | |
479 | } else { | |
480 | $unread = 'false'; | |
481 | $last_read_qpart = 'NOW()'; | |
482 | } | |
19c9cb11 | 483 | |
11b0dce2 AD |
484 | $result = db_query($link, |
485 | "INSERT INTO ttrss_user_entries | |
486 | (ref_id, owner_uid, feed_id, unread, last_read) | |
487 | VALUES ('$ref_id', '$owner_uid', '$feed', $unread, | |
488 | $last_read_qpart)"); | |
489 | } | |
490 | ||
6385315d AD |
491 | $post_needs_update = false; |
492 | ||
a2770077 | 493 | if (get_pref($link, "UPDATE_POST_ON_CHECKSUM_CHANGE", $owner_uid) && |
6385315d AD |
494 | ($content_hash != $orig_content_hash)) { |
495 | $post_needs_update = true; | |
496 | } | |
497 | ||
498 | if ($orig_title != $entry_title) { | |
499 | $post_needs_update = true; | |
500 | } | |
501 | ||
11b0dce2 AD |
502 | if ($orig_num_comments != $num_comments) { |
503 | $post_needs_update = true; | |
504 | } | |
505 | ||
6385315d AD |
506 | // this doesn't seem to be very reliable |
507 | // | |
508 | // if ($orig_timestamp != $entry_timestamp && !$orig_no_orig_date) { | |
509 | // $post_needs_update = true; | |
510 | // } | |
511 | ||
512 | // if post needs update, update it and mark all user entries | |
1c73bc0c | 513 | // linking to this post as updated |
6385315d AD |
514 | if ($post_needs_update) { |
515 | ||
516 | // print "<!-- post $orig_title needs update : $post_needs_update -->"; | |
517 | ||
6385315d | 518 | db_query($link, "UPDATE ttrss_entries |
11b0dce2 AD |
519 | SET title = '$entry_title', content = '$entry_content', |
520 | num_comments = '$num_comments' | |
6385315d AD |
521 | WHERE id = '$ref_id'"); |
522 | ||
523 | db_query($link, "UPDATE ttrss_user_entries | |
524 | SET last_read = null WHERE ref_id = '$ref_id' AND unread = false"); | |
525 | ||
526 | } | |
4c193675 AD |
527 | } |
528 | ||
eb36b4eb AD |
529 | /* taaaags */ |
530 | // <a href="http://technorati.com/tag/Xorg" rel="tag">Xorg</a>, // | |
531 | ||
05732aa0 | 532 | $entry_tags = null; |
eb36b4eb | 533 | |
372ced8b | 534 | preg_match_all("/<a.*?href=.http:\/\/.*?technorati.com\/tag\/([^\"\'>]+)/i", |
ee2c3050 AD |
535 | $entry_content_unescaped, $entry_tags); |
536 | ||
537 | // print "<br>$entry_title : $entry_content_unescaped<br>"; | |
538 | // print_r($entry_tags); | |
372ced8b | 539 | // print "<br>"; |
eb36b4eb AD |
540 | |
541 | $entry_tags = $entry_tags[1]; | |
542 | ||
543 | if (count($entry_tags) > 0) { | |
544 | ||
05732aa0 AD |
545 | $result = db_query($link, "SELECT id,int_id |
546 | FROM ttrss_entries,ttrss_user_entries | |
25da6909 | 547 | WHERE guid = '$entry_guid' |
05732aa0 | 548 | AND feed_id = '$feed' AND ref_id = id |
7fed1940 | 549 | AND owner_uid = '$owner_uid'"); |
eb36b4eb | 550 | |
fe99ab12 | 551 | if (db_num_rows($result) == 1) { |
eb36b4eb | 552 | |
fe99ab12 AD |
553 | $entry_id = db_fetch_result($result, 0, "id"); |
554 | $entry_int_id = db_fetch_result($result, 0, "int_id"); | |
555 | ||
556 | foreach ($entry_tags as $tag) { | |
557 | $tag = db_escape_string(strtolower($tag)); | |
31483fc1 AD |
558 | |
559 | $tag = str_replace("+", " ", $tag); | |
fe99ab12 AD |
560 | $tag = str_replace("technorati tag: ", "", $tag); |
561 | ||
562 | $result = db_query($link, "SELECT id FROM ttrss_tags | |
563 | WHERE tag_name = '$tag' AND post_int_id = '$entry_int_id' AND | |
564 | owner_uid = '$owner_uid' LIMIT 1"); | |
565 | ||
566 | // print db_fetch_result($result, 0, "id"); | |
567 | ||
568 | if ($result && db_num_rows($result) == 0) { | |
569 | ||
570 | // print "tagging $entry_id as $tag<br>"; | |
571 | ||
572 | db_query($link, "INSERT INTO ttrss_tags | |
573 | (owner_uid,tag_name,post_int_id) | |
574 | VALUES ('$owner_uid','$tag', '$entry_int_id')"); | |
575 | } | |
576 | } | |
eb36b4eb | 577 | } |
05732aa0 | 578 | } |
4c193675 | 579 | } |
40d13c28 | 580 | |
ab3d0b99 AD |
581 | db_query($link, "UPDATE ttrss_feeds |
582 | SET last_updated = NOW(), last_error = '' WHERE id = '$feed'"); | |
eb36b4eb | 583 | |
dd8c76a9 AD |
584 | db_query($link, "COMMIT"); |
585 | ||
ab3d0b99 AD |
586 | } else { |
587 | $error_msg = db_escape_string(magpie_error()); | |
588 | db_query($link, | |
aa5f9f5f AD |
589 | "UPDATE ttrss_feeds SET last_error = '$error_msg', |
590 | last_updated = NOW() WHERE id = '$feed'"); | |
40d13c28 AD |
591 | } |
592 | ||
593 | } | |
594 | ||
f175937c AD |
595 | function print_select($id, $default, $values, $attributes = "") { |
596 | print "<select id=\"$id\" $attributes>"; | |
a0d53889 AD |
597 | foreach ($values as $v) { |
598 | if ($v == $default) | |
599 | $sel = " selected"; | |
600 | else | |
601 | $sel = ""; | |
602 | ||
603 | print "<option$sel>$v</option>"; | |
604 | } | |
605 | print "</select>"; | |
606 | } | |
40d13c28 | 607 | |
19c9cb11 | 608 | function get_filter_name($title, $content, $link, $filters) { |
e6155a06 AD |
609 | |
610 | if ($filters["title"]) { | |
19c9cb11 AD |
611 | foreach ($filters["title"] as $filter) { |
612 | $reg_exp = $filter["reg_exp"]; | |
613 | if (preg_match("/$reg_exp/i", $title)) { | |
614 | return $filter["action"]; | |
615 | } | |
e6155a06 AD |
616 | } |
617 | } | |
618 | ||
619 | if ($filters["content"]) { | |
19c9cb11 AD |
620 | foreach ($filters["content"] as $filter) { |
621 | $reg_exp = $filter["reg_exp"]; | |
622 | if (preg_match("/$reg_exp/i", $content)) { | |
623 | return $filter["action"]; | |
624 | } | |
e6155a06 AD |
625 | } |
626 | } | |
627 | ||
628 | if ($filters["both"]) { | |
629 | foreach ($filters["both"] as $filter) { | |
19c9cb11 AD |
630 | $reg_exp = $filter["reg_exp"]; |
631 | if (preg_match("/$reg_exp/i", $title) || | |
632 | preg_match("/$reg_exp/i", $content)) { | |
633 | return $filter["action"]; | |
634 | } | |
e6155a06 AD |
635 | } |
636 | } | |
637 | ||
3a933f22 | 638 | if ($filters["link"]) { |
19c9cb11 AD |
639 | $reg_exp = $filter["reg_exp"]; |
640 | foreach ($filters["link"] as $filter) { | |
641 | $reg_exp = $filter["reg_exp"]; | |
642 | if (preg_match("/$reg_exp/i", $link)) { | |
643 | return $filter["action"]; | |
644 | } | |
3a933f22 AD |
645 | } |
646 | } | |
647 | ||
e6155a06 AD |
648 | return false; |
649 | } | |
650 | ||
4668523d | 651 | function printFeedEntry($feed_id, $class, $feed_title, $unread, $icon_file, $link) { |
254e0e4b AD |
652 | |
653 | if (file_exists($icon_file) && filesize($icon_file) > 0) { | |
023fe037 | 654 | $feed_icon = "<img id=\"FIMG-$feed_id\" src=\"$icon_file\">"; |
254e0e4b | 655 | } else { |
023fe037 | 656 | $feed_icon = "<img id=\"FIMG-$feed_id\" src=\"images/blank_icon.gif\">"; |
254e0e4b AD |
657 | } |
658 | ||
8143ae1f | 659 | $feed = "<a href=\"javascript:viewfeed('$feed_id', 0);\">$feed_title</a>"; |
254e0e4b AD |
660 | |
661 | print "<li id=\"FEEDR-$feed_id\" class=\"$class\">"; | |
b619ff15 | 662 | if (get_pref($link, 'ENABLE_FEED_ICONS')) { |
254e0e4b AD |
663 | print "$feed_icon"; |
664 | } | |
665 | ||
666 | print "<span id=\"FEEDN-$feed_id\">$feed</span>"; | |
667 | ||
668 | if ($unread != 0) { | |
669 | $fctr_class = ""; | |
670 | } else { | |
671 | $fctr_class = "class=\"invisible\""; | |
672 | } | |
673 | ||
674 | print "<span $fctr_class id=\"FEEDCTR-$feed_id\"> | |
675 | (<span id=\"FEEDU-$feed_id\">$unread</span>)</span>"; | |
676 | ||
677 | print "</li>"; | |
678 | ||
679 | } | |
680 | ||
406d9489 AD |
681 | function getmicrotime() { |
682 | list($usec, $sec) = explode(" ",microtime()); | |
683 | return ((float)$usec + (float)$sec); | |
684 | } | |
685 | ||
77e96719 AD |
686 | function print_radio($id, $default, $values, $attributes = "") { |
687 | foreach ($values as $v) { | |
688 | ||
689 | if ($v == $default) | |
5da169d9 | 690 | $sel = "checked"; |
77e96719 | 691 | else |
5da169d9 AD |
692 | $sel = ""; |
693 | ||
694 | if ($v == "Yes") { | |
695 | $sel .= " value=\"1\""; | |
696 | } else { | |
697 | $sel .= " value=\"0\""; | |
698 | } | |
77e96719 | 699 | |
69654950 AD |
700 | print "<input class=\"noborder\" |
701 | type=\"radio\" $sel $attributes name=\"$id\"> $v "; | |
77e96719 AD |
702 | |
703 | } | |
704 | } | |
705 | ||
ff485f1d AD |
706 | function initialize_user_prefs($link, $uid) { |
707 | ||
708 | $uid = db_escape_string($uid); | |
709 | ||
710 | db_query($link, "BEGIN"); | |
711 | ||
712 | $result = db_query($link, "SELECT pref_name,def_value FROM ttrss_prefs"); | |
713 | ||
714 | $u_result = db_query($link, "SELECT pref_name | |
715 | FROM ttrss_user_prefs WHERE owner_uid = '$uid'"); | |
716 | ||
717 | $active_prefs = array(); | |
718 | ||
719 | while ($line = db_fetch_assoc($u_result)) { | |
720 | array_push($active_prefs, $line["pref_name"]); | |
721 | } | |
722 | ||
723 | while ($line = db_fetch_assoc($result)) { | |
724 | if (array_search($line["pref_name"], $active_prefs) === FALSE) { | |
725 | // print "adding " . $line["pref_name"] . "<br>"; | |
726 | ||
727 | db_query($link, "INSERT INTO ttrss_user_prefs | |
728 | (owner_uid,pref_name,value) VALUES | |
729 | ('$uid', '".$line["pref_name"]."','".$line["def_value"]."')"); | |
730 | ||
731 | } | |
732 | } | |
733 | ||
734 | db_query($link, "COMMIT"); | |
735 | ||
736 | } | |
c8437f35 AD |
737 | |
738 | function authenticate_user($link, $login, $password) { | |
739 | ||
740 | $pwd_hash = 'SHA1:' . sha1($password); | |
741 | ||
203b6d25 | 742 | $result = db_query($link, "SELECT id,login,access_level FROM ttrss_users WHERE |
09829e2a AD |
743 | login = '$login' AND ((pwd_hash = '$password' AND '$password' = 'password') |
744 | OR pwd_hash = '$pwd_hash')"); | |
c8437f35 AD |
745 | |
746 | if (db_num_rows($result) == 1) { | |
747 | $_SESSION["uid"] = db_fetch_result($result, 0, "id"); | |
748 | $_SESSION["name"] = db_fetch_result($result, 0, "login"); | |
203b6d25 | 749 | $_SESSION["access_level"] = db_fetch_result($result, 0, "access_level"); |
c8437f35 | 750 | |
f6f32198 AD |
751 | db_query($link, "UPDATE ttrss_users SET last_login = NOW() WHERE id = " . |
752 | $_SESSION["uid"]); | |
753 | ||
503eb349 AD |
754 | $user_theme = get_user_theme_path($link); |
755 | ||
756 | $_SESSION["theme"] = $user_theme; | |
757 | ||
f557cd78 AD |
758 | initialize_user_prefs($link, $_SESSION["uid"]); |
759 | ||
c8437f35 AD |
760 | return true; |
761 | } | |
ff485f1d | 762 | |
c8437f35 AD |
763 | return false; |
764 | ||
765 | } | |
766 | ||
e6cb77a0 AD |
767 | function make_password($length = 8) { |
768 | ||
769 | $password = ""; | |
798f722b AD |
770 | $possible = "0123456789abcdfghjkmnpqrstvwxyzABCDFGHJKMNPQRSTVWXYZ"; |
771 | ||
772 | $i = 0; | |
e6cb77a0 AD |
773 | |
774 | while ($i < $length) { | |
775 | $char = substr($possible, mt_rand(0, strlen($possible)-1), 1); | |
776 | ||
777 | if (!strstr($password, $char)) { | |
778 | $password .= $char; | |
779 | $i++; | |
780 | } | |
781 | } | |
782 | return $password; | |
783 | } | |
784 | ||
785 | // this is called after user is created to initialize default feeds, labels | |
786 | // or whatever else | |
787 | ||
788 | // user preferences are checked on every login, not here | |
789 | ||
790 | function initialize_user($link, $uid) { | |
791 | ||
792 | db_query($link, "insert into ttrss_labels (owner_uid,sql_exp,description) | |
793 | values ('$uid','unread = true', 'Unread articles')"); | |
794 | ||
795 | db_query($link, "insert into ttrss_labels (owner_uid,sql_exp,description) | |
796 | values ('$uid','last_read is null and unread = false', 'Updated articles')"); | |
797 | ||
798 | db_query($link, "insert into ttrss_feeds (owner_uid,title,feed_url) | |
74bff337 | 799 | values ('$uid', 'Tiny Tiny RSS: New Releases', |
628fcd2c | 800 | 'http://tt-rss.spb.ru/releases.rss')"); |
3b0feb9b AD |
801 | |
802 | } | |
e6cb77a0 | 803 | |
b8aa49bc | 804 | function logout_user() { |
f557cd78 | 805 | session_destroy(); |
b8aa49bc AD |
806 | } |
807 | ||
75836f33 | 808 | function get_script_urlpath() { |
87a79fa4 | 809 | return preg_replace('/\/[^\/]*$/', "", $_SERVER["REQUEST_URI"]); |
75836f33 AD |
810 | } |
811 | ||
812 | function get_login_redirect() { | |
813 | $server = $_SERVER["SERVER_NAME"]; | |
814 | ||
815 | if (ENABLE_LOGIN_SSL) { | |
816 | $protocol = "https"; | |
817 | } else { | |
818 | $protocol = "http"; | |
819 | } | |
820 | ||
821 | $url_path = get_script_urlpath(); | |
822 | ||
823 | $redirect_uri = "$protocol://$server$url_path/login.php"; | |
824 | ||
825 | return $redirect_uri; | |
826 | } | |
827 | ||
b8aa49bc AD |
828 | function login_sequence($link) { |
829 | if (!SINGLE_USER_MODE) { | |
75836f33 | 830 | |
b8aa49bc AD |
831 | if (!USE_HTTP_AUTH) { |
832 | if (!$_SESSION["uid"]) { | |
75836f33 | 833 | $redirect_uri = get_login_redirect(); |
e31dca14 AD |
834 | $return_to = preg_replace('/.*?\//', '', $_SERVER["REQUEST_URI"]); |
835 | header("Location: $redirect_uri?rt=$return_to"); | |
b8aa49bc AD |
836 | exit; |
837 | } | |
838 | } else { | |
f557cd78 AD |
839 | if (!$_SESSION["uid"]) { |
840 | if (!$_SERVER["PHP_AUTH_USER"]) { | |
841 | ||
842 | header('WWW-Authenticate: Basic realm="Tiny Tiny RSS"'); | |
843 | header('HTTP/1.0 401 Unauthorized'); | |
844 | exit; | |
845 | ||
846 | } else { | |
847 | $auth_result = authenticate_user($link, | |
848 | $_SERVER["PHP_AUTH_USER"], $_SERVER["PHP_AUTH_PW"]); | |
849 | ||
850 | if (!$auth_result) { | |
851 | header('WWW-Authenticate: Basic realm="Tiny Tiny RSS"'); | |
852 | header('HTTP/1.0 401 Unauthorized'); | |
853 | exit; | |
854 | } | |
855 | } | |
856 | } | |
b8aa49bc AD |
857 | } |
858 | } else { | |
859 | $_SESSION["uid"] = 1; | |
860 | $_SESSION["name"] = "admin"; | |
c7a03b7a | 861 | initialize_user_prefs($link, 1); |
b8aa49bc AD |
862 | } |
863 | } | |
3547842a AD |
864 | |
865 | function truncate_string($str, $max_len) { | |
12db369c AD |
866 | if (mb_strlen($str, "utf-8") > $max_len - 3) { |
867 | return mb_substr($str, 0, $max_len, "utf-8") . "..."; | |
3547842a AD |
868 | } else { |
869 | return $str; | |
870 | } | |
871 | } | |
54a60e1a AD |
872 | |
873 | function get_user_theme_path($link) { | |
798f722b AD |
874 | $result = db_query($link, "SELECT theme_path |
875 | FROM | |
876 | ttrss_themes,ttrss_users | |
877 | WHERE ttrss_themes.id = theme_id AND ttrss_users.id = " . $_SESSION["uid"]); | |
54a60e1a AD |
878 | if (db_num_rows($result) != 0) { |
879 | return db_fetch_result($result, 0, "theme_path"); | |
880 | } else { | |
881 | return null; | |
882 | } | |
883 | } | |
be773442 AD |
884 | |
885 | function smart_date_time($timestamp) { | |
886 | if (date("Y.m.d", $timestamp) == date("Y.m.d")) { | |
887 | return date("G:i", $timestamp); | |
f26450f1 | 888 | } else if (date("Y", $timestamp) == date("Y")) { |
be773442 AD |
889 | return date("M d, G:i", $timestamp); |
890 | } else { | |
b02111c2 | 891 | return date("Y/m/d G:i", $timestamp); |
be773442 AD |
892 | } |
893 | } | |
894 | ||
895 | function smart_date($timestamp) { | |
896 | if (date("Y.m.d", $timestamp) == date("Y.m.d")) { | |
897 | return "Today"; | |
f26450f1 | 898 | } else if (date("Y", $timestamp) == date("Y")) { |
be773442 AD |
899 | return date("D m", $timestamp); |
900 | } else { | |
b02111c2 | 901 | return date("Y/m/d", $timestamp); |
be773442 AD |
902 | } |
903 | } | |
a654a595 AD |
904 | |
905 | function sql_bool_to_string($s) { | |
906 | if ($s == "t" || $s == "1") { | |
907 | return "true"; | |
908 | } else { | |
909 | return "false"; | |
910 | } | |
911 | } | |
e3c99f3b AD |
912 | |
913 | function sql_bool_to_bool($s) { | |
914 | if ($s == "t" || $s == "1") { | |
915 | return true; | |
916 | } else { | |
917 | return false; | |
918 | } | |
919 | } | |
0ea4fb50 | 920 | |
e3c99f3b | 921 | |
0ea4fb50 AD |
922 | function toggleEvenOdd($a) { |
923 | if ($a == "even") | |
924 | return "odd"; | |
925 | else | |
926 | return "even"; | |
927 | } | |
6043fb7e AD |
928 | |
929 | function sanity_check($link) { | |
9cbca41f | 930 | |
6043fb7e AD |
931 | $error_code = 0; |
932 | $result = db_query($link, "SELECT schema_version FROM ttrss_version"); | |
933 | $schema_version = db_fetch_result($result, 0, "schema_version"); | |
934 | ||
935 | if ($schema_version != SCHEMA_VERSION) { | |
936 | $error_code = 5; | |
937 | } | |
938 | ||
6043fb7e | 939 | if ($error_code != 0) { |
9cbca41f | 940 | print "<error error-code='$error_code'/>"; |
6043fb7e AD |
941 | return false; |
942 | } else { | |
943 | return true; | |
9cbca41f | 944 | } |
6043fb7e AD |
945 | } |
946 | ||
27981ca3 AD |
947 | function file_is_locked($filename) { |
948 | error_reporting(0); | |
949 | $fp = fopen($filename, "r"); | |
950 | error_reporting(DEFAULT_ERROR_LEVEL); | |
951 | if ($fp) { | |
952 | if (flock($fp, LOCK_EX | LOCK_NB)) { | |
953 | flock($fp, LOCK_UN); | |
954 | fclose($fp); | |
955 | return false; | |
956 | } | |
957 | fclose($fp); | |
958 | return true; | |
959 | } | |
960 | return false; | |
961 | } | |
962 | ||
fcb4c0c9 AD |
963 | function make_lockfile($filename) { |
964 | $fp = fopen($filename, "w"); | |
965 | ||
966 | if (flock($fp, LOCK_EX | LOCK_NB)) { | |
967 | return $fp; | |
968 | } else { | |
969 | return false; | |
970 | } | |
971 | } | |
972 | ||
40d13c28 | 973 | ?> |