]> git.wh0rd.org - tt-rss.git/blame - functions.php
git.wh0rd.org / tt-rss.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
disable flash disabling in sanitize_rss
[tt-rss.git] / functions.php
CommitLineData
1d3a17c7 1<?php
f1a80dae 2
894ebcf5 3/* if ($_GET["debug"]) {
cce28758
AD		 4 define('DEFAULT_ERROR_LEVEL', E_ALL);
5 } else {
6 define('DEFAULT_ERROR_LEVEL', E_ERROR | E_WARNING | E_PARSE);
894ebcf5 7 } */
cce28758 8
40d13c28 9 require_once 'config.php';
b619ff15 10 require_once 'db-prefs.php';
5bc0bd27 11 require_once 'compat.php';
af106b0e 12 require_once 'errors.php';
8911ac8b 13 require_once 'version.php';
40d13c28 14
7c5a308d 15 if (RSS_BACKEND_TYPE == "magpie") {
ed891a51 16 require_once "magpierss/rss_fetch.inc";
7c5a308d
AD		 17 require_once 'magpierss/rss_utils.inc';
18 } else if (RSS_BACKEND_TYPE == "simplepie") {
19 require_once 'simplepie/simplepie.inc';
20 }
387234f3 21
a3ee2a38
AD		 22 define('MAGPIE_OUTPUT_ENCODING', 'UTF-8');
23
ad507f85
AD		 24 function purge_feed($link, $feed_id, $purge_interval, $debug = false) {
25
26 $rows = -1;
4c193675 27
fefa6ca3 28 if (DB_TYPE == "pgsql") {
44e241cb 29/* $result = db_query($link, "DELETE FROM ttrss_user_entries WHERE
fefa6ca3 30 marked = false AND feed_id = '$feed_id' AND
35d8cf43 31 (SELECT date_entered FROM ttrss_entries WHERE
44e241cb
AD		 32 id = ref_id) < NOW() - INTERVAL '$purge_interval days'"); */
33
6e7f8d26
AD		 34 $pg_version = get_pgsql_version($link);
35
36 if (preg_match("/^7\./", $pg_version) || preg_match("/^8\.0/", $pg_version)) {
1e59ae35
AD		 37
38 $result = db_query($link, "DELETE FROM ttrss_user_entries WHERE
39 ttrss_entries.id = ref_id AND
40 marked = false AND
41 feed_id = '$feed_id' AND
42 ttrss_entries.date_entered < NOW() - INTERVAL '$purge_interval days'");
43
44 } else {
45
46 $result = db_query($link, "DELETE FROM ttrss_user_entries
47 USING ttrss_entries
48 WHERE ttrss_entries.id = ref_id AND
49 marked = false AND
50 feed_id = '$feed_id' AND
fc774155 51 ttrss_entries.date_entered < NOW() - INTERVAL '$purge_interval days'");
1e59ae35 52 }
ad507f85
AD		 53
54 $rows = pg_affected_rows($result);
55
fefa6ca3 56 } else {
1e59ae35 57
30f1746f 58/* $result = db_query($link, "DELETE FROM ttrss_user_entries WHERE
fefa6ca3 59 marked = false AND feed_id = '$feed_id' AND
35d8cf43 60 (SELECT date_entered FROM ttrss_entries WHERE
30f1746f
AD		 61 id = ref_id) < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)"); */
62
63 $result = db_query($link, "DELETE FROM ttrss_user_entries
64 USING ttrss_user_entries, ttrss_entries
65 WHERE ttrss_entries.id = ref_id AND
66 marked = false AND
67 feed_id = '$feed_id' AND
68 ttrss_entries.date_entered < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)");
69
ad507f85
AD		 70 $rows = mysql_affected_rows($link);
71
72 }
73
74 if ($debug) {
75 print "Purged feed $feed_id ($purge_interval): deleted $rows articles\n";
fefa6ca3
AD		 76 }
77 }
78
44e241cb
AD		 79 function global_purge_old_posts($link, $do_output = false, $limit = false) {
80
894ebcf5 81 $random_qpart = sql_random_function();
fefa6ca3 82
44e241cb
AD		 83 if ($limit) {
84 $limit_qpart = "LIMIT $limit";
85 } else {
86 $limit_qpart = "";
87 }
88
fefa6ca3 89 $result = db_query($link,
44e241cb
AD		 90 "SELECT id,purge_interval,owner_uid FROM ttrss_feeds
91 ORDER BY $random_qpart $limit_qpart");
fefa6ca3
AD		 92
93 while ($line = db_fetch_assoc($result)) {
94
95 $feed_id = $line["id"];
96 $purge_interval = $line["purge_interval"];
97 $owner_uid = $line["owner_uid"];
98
99 if ($purge_interval == 0) {
100
101 $tmp_result = db_query($link,
102 "SELECT value FROM ttrss_user_prefs WHERE
103 pref_name = 'PURGE_OLD_DAYS' AND owner_uid = '$owner_uid'");
104
105 if (db_num_rows($tmp_result) != 0) {
106 $purge_interval = db_fetch_result($tmp_result, 0, "value");
107 }
108 }
109
110 if ($do_output) {
ad507f85 111// print "Feed $feed_id: purge interval = $purge_interval\n";
fefa6ca3
AD		 112 }
113
114 if ($purge_interval > 0) {
ad507f85 115 purge_feed($link, $feed_id, $purge_interval, $do_output);
fefa6ca3
AD		 116 }
117 }
118
71604ca4
AD		 119 // purge orphaned posts in main content table
120 db_query($link, "DELETE FROM ttrss_entries WHERE
121 (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0");
122
fefa6ca3
AD		 123 }
124
b6eefba5 125 function purge_old_posts($link) {
5d73494a 126
f1a80dae
AD		 127 $user_id = $_SESSION["uid"];
128
129 $result = db_query($link, "SELECT id,purge_interval FROM ttrss_feeds
130 WHERE owner_uid = '$user_id'");
5d73494a
AD		 131
132 while ($line = db_fetch_assoc($result)) {
133
134 $feed_id = $line["id"];
135 $purge_interval = $line["purge_interval"];
136
b619ff15 137 if ($purge_interval == 0) $purge_interval = get_pref($link, 'PURGE_OLD_DAYS');
5d73494a 138
140aae81 139 if ($purge_interval > 0) {
fefa6ca3 140 purge_feed($link, $feed_id, $purge_interval);
5d73494a
AD		 141 }
142 }
71604ca4
AD		 143
144 // purge orphaned posts in main content table
145 db_query($link, "DELETE FROM ttrss_entries WHERE
146 (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0");
c3a8d71a
AD		 147 }
148
1f2b01ed 149 function update_all_feeds($link, $fetch, $user_id = false, $force_daemon = false) {
40d13c28 150
4769ddaf 151 if (WEB_DEMO_MODE) return;
b0b4abcf 152
a2770077
AD		 153 if (!$user_id) {
154 $user_id = $_SESSION["uid"];
155 purge_old_posts($link);
156 }
157
25af8dad 158// db_query($link, "BEGIN");
b82af8c3 159
cbd8650d
AD		 160 if (MAX_UPDATE_TIME > 0) {
161 if (DB_TYPE == "mysql") {
162 $q_order = "RAND()";
163 } else {
164 $q_order = "RANDOM()";
165 }
166 } else {
167 $q_order = "last_updated DESC";
168 }
169
d148926e 170 $result = db_query($link, "SELECT feed_url,id,
798f722b 171 SUBSTRING(last_updated,1,19) AS last_updated,
5c563acd 172 update_interval FROM ttrss_feeds WHERE owner_uid = '$user_id'
cbd8650d
AD		 173 ORDER BY $q_order");
174
175 $upd_start = time();
40d13c28 176
b6eefba5 177 while ($line = db_fetch_assoc($result)) {
d148926e
AD		 178 $upd_intl = $line["update_interval"];
179
b619ff15 180 if (!$upd_intl || $upd_intl == 0) {
a2770077 181 $upd_intl = get_pref($link, 'DEFAULT_UPDATE_INTERVAL', $user_id);
b619ff15 182 }
d148926e 183
c1e202b7
AD		 184 if ($upd_intl < 0) {
185 // Updates for this feed are disabled
186 continue;
187 }
188
93d40f50
AD		 189 if ($fetch || (!$line["last_updated"] ||
190 time() - strtotime($line["last_updated"]) > ($upd_intl * 60))) {
c5142cca 191
cbd8650d
AD		 192// print "<!-- feed: ".$line["feed_url"]." -->";
193
1f2b01ed 194 update_rss_feed($link, $line["feed_url"], $line["id"], $force_daemon);
cbd8650d
AD		 195
196 $upd_elapsed = time() - $upd_start;
197
198 if (MAX_UPDATE_TIME > 0 && $upd_elapsed > MAX_UPDATE_TIME) {
199 return;
200 }
d148926e 201 }
40d13c28
AD		 202 }
203
25af8dad 204// db_query($link, "COMMIT");
b82af8c3 205
40d13c28
AD		 206 }
207
4065b60b
AD		 208 function fetch_file_contents($url) {
209 if (USE_CURL_FOR_ICONS) {
210 $tmpfile = tempnam(TMP_DIRECTORY, "ttrss-tmp");
211
212 $ch = curl_init($url);
213 $fp = fopen($tmpfile, "w");
214
215 if ($fp) {
216 curl_setopt($ch, CURLOPT_FILE, $fp);
217 curl_exec($ch);
218 curl_close($ch);
219 fclose($fp);
220 }
221
222 $contents = file_get_contents($tmpfile);
223 unlink($tmpfile);
224
225 return $contents;
226
227 } else {
228 return file_get_contents($url);
229 }
230
231 }
78800912 232
4065b60b
AD		 233 // adapted from wordpress favicon plugin by Jeff Minard (http://thecodepro.com/)
234 // http://dev.wp-plugins.org/file/favatars/trunk/favatars.php
78800912 235
4065b60b 236 function get_favicon_url($url) {
99331724 237
4065b60b 238 if ($html = @fetch_file_contents($url)) {
78800912 239
4065b60b
AD		 240 if ( preg_match('/<link[^>]+rel="(?:shortcut )?icon"[^>]+?href="([^"]+?)"/si', $html, $matches)) {
241 // Attempt to grab a favicon link from their webpage url
242 $linkUrl = html_entity_decode($matches[1]);
c798704b 243
4065b60b
AD		 244 if (substr($linkUrl, 0, 1) == '/') {
245 $urlParts = parse_url($url);
246 $faviconURL = $urlParts['scheme'].'://'.$urlParts['host'].$linkUrl;
247 } else if (substr($linkUrl, 0, 7) == 'http://') {
248 $faviconURL = $linkUrl;
249 } else if (substr($url, -1, 1) == '/') {
250 $faviconURL = $url.$linkUrl;
251 } else {
252 $faviconURL = $url.'/'.$linkUrl;
e695fdc8 253 }
717f5e64 254
c798704b 255 } else {
4065b60b
AD		 256 // If unsuccessful, attempt to "guess" the favicon location
257 $urlParts = parse_url($url);
258 $faviconURL = $urlParts['scheme'].'://'.$urlParts['host'].'/favicon.ico';
259 }
260 }
c798704b 261
4065b60b
AD		 262 // Run a test to see if what we have attempted to get actually exists.
263 if(USE_CURL_FOR_ICONS || url_validate($faviconURL)) {
264 return $faviconURL;
265 } else {
266 return false;
267 }
268 }
269
270 function url_validate($link) {
271
272 $url_parts = @parse_url($link);
273
274 if ( empty( $url_parts["host"] ) )
275 return false;
276
277 if ( !empty( $url_parts["path"] ) ) {
278 $documentpath = $url_parts["path"];
279 } else {
280 $documentpath = "/";
281 }
282
283 if ( !empty( $url_parts["query"] ) )
284 $documentpath .= "?" . $url_parts["query"];
285
286 $host = $url_parts["host"];
287 $port = $url_parts["port"];
288
289 if ( empty($port) )
290 $port = "80";
291
292 $socket = @fsockopen( $host, $port, $errno, $errstr, 30 );
293
294 if ( !$socket )
295 return false;
c798704b 296
4065b60b
AD		 297 fwrite ($socket, "HEAD ".$documentpath." HTTP/1.0\r\nHost: $host\r\n\r\n");
298
299 $http_response = fgets( $socket, 22 );
300
301 $responses = "/(200 OK)|(30[0-9] Moved)/";
302 if ( preg_match($responses, $http_response) ) {
303 fclose($socket);
304 return true;
305 } else {
306 return false;
307 }
308
309 }
310
311 function check_feed_favicon($site_url, $feed, $link) {
312 $favicon_url = get_favicon_url($site_url);
313
314# print "FAVICON [$site_url]: $favicon_url\n";
315
316 error_reporting(0);
317
318 $icon_file = ICONS_DIR . "/$feed.ico";
319
320 if ($favicon_url && !file_exists($icon_file)) {
321 $contents = fetch_file_contents($favicon_url);
322
323 $fp = fopen($icon_file, "w");
78800912 324
4065b60b
AD		 325 if ($fp) {
326 fwrite($fp, $contents);
327 fclose($fp);
328 chmod($icon_file, 0644);
329 }
78800912 330 }
4065b60b
AD		 331
332 error_reporting(DEFAULT_ERROR_LEVEL);
333
78800912
AD		 334 }
335
ddb68b81 336 function update_rss_feed($link, $feed_url, $feed, $ignore_daemon = false) {
40d13c28 337
4769ddaf 338 if (WEB_DEMO_MODE) return;
b0b4abcf 339
ddb68b81 340 if (DAEMON_REFRESH_ONLY && !$_GET["daemon"] && !$ignore_daemon) {
21cfcdf2
AD		 341 return;
342 }
343
47c6c988 344 $result = db_query($link, "SELECT update_interval,auth_login,auth_pass
a88c1f36
AD		 345 FROM ttrss_feeds WHERE id = '$feed'");
346
ff25e639
AD		 347 $auth_login = db_unescape_string(db_fetch_result($result, 0, "auth_login"));
348 $auth_pass = db_unescape_string(db_fetch_result($result, 0, "auth_pass"));
47c6c988 349
a88c1f36
AD		 350 $update_interval = db_fetch_result($result, 0, "update_interval");
351
352 if ($update_interval < 0) { return; }
353
ab3d0b99
AD		 354 $feed = db_escape_string($feed);
355
47c6c988
AD		 356 $fetch_url = $feed_url;
357
358 if ($auth_login && $auth_pass) {
359 $url_parts = array();
360 preg_match("/(^[^:]*):\/\/(.*)/", $fetch_url, $url_parts);
361
362 if ($url_parts[1] && $url_parts[2]) {
363 $fetch_url = $url_parts[1] . "://$auth_login:$auth_pass@" . $url_parts[2];
364 }
365
366 }
ab3d0b99 367
7c5a308d
AD		 368 if (RSS_BACKEND_TYPE == "magpie") {
369 error_reporting(0);
370 $rss = fetch_rss($fetch_url);
371 error_reporting (DEFAULT_ERROR_LEVEL);
372 } else if (RSS_BACKEND_TYPE == "simplepie") {
373
374 if (!file_exists(SIMPLEPIE_CACHE_DIR)) {
375 mkdir(SIMPLEPIE_CACHE_DIR);
376 }
76798ff3 377
7c5a308d
AD		 378 $rss = new SimplePie();
379 $rss->feed_url($fetch_url);
380 $rss->cache_location(SIMPLEPIE_CACHE_DIR);
381 $rss->init();
382 }
383
b6eefba5 384 $feed = db_escape_string($feed);
dcee8f61 385
7c5a308d 386 $rss_check = $rss;
b82af8c3 387
7c5a308d
AD		 388 if (RSS_BACKEND_TYPE == "simplepie") {
389 $rss_check = $rss->data;
390 }
391
392 if ($rss_check) {
393
44e241cb 394// db_query($link, "BEGIN");
dd8c76a9 395
a88c1f36 396 $result = db_query($link, "SELECT title,icon_url,site_url,owner_uid
f324892e 397 FROM ttrss_feeds WHERE id = '$feed'");
331900c6 398
b6eefba5
AD		 399 $registered_title = db_fetch_result($result, 0, "title");
400 $orig_icon_url = db_fetch_result($result, 0, "icon_url");
f324892e 401 $orig_site_url = db_fetch_result($result, 0, "site_url");
331900c6 402
7fed1940
AD		 403 $owner_uid = db_fetch_result($result, 0, "owner_uid");
404
8d0ec6fd 405 if (get_pref($link, 'ENABLE_FEED_ICONS', $owner_uid, false)) {
4065b60b 406 check_feed_favicon($rss->channel["link"], $feed, $link);
a2770077
AD		 407 }
408
746b249f 409 if (!$registered_title || $registered_title == "[Unknown]") {
7c5a308d
AD		 410
411 if (RSS_BACKEND_TYPE == "magpie") {
412 $feed_title = db_escape_string($rss->channel["title"]);
413 } else {
414 $feed_title = $rss->get_feed_title();
415 }
416
f324892e
AD		 417 db_query($link, "UPDATE ttrss_feeds SET
418 title = '$feed_title' WHERE id = '$feed'");
419 }
420
7c5a308d
AD		 421 if (RSS_BACKEND_TYPE == "magpie") {
422 $site_url = $rss->channel["link"];
423 // weird, weird Magpie
424 if (!$site_url) $site_url = db_escape_string($rss->channel["link_"]);
425 } else {
426 $site_url = $rss->get_feed_link();
427 }
147f7691
AD		 428
429 if ($site_url && $orig_site_url != db_escape_string($site_url)) {
f324892e
AD		 430 db_query($link, "UPDATE ttrss_feeds SET
431 site_url = '$site_url' WHERE id = '$feed'");
331900c6 432 }
40d13c28 433
b7f4bda2
AD		 434// print "I: " . $rss->channel["image"]["url"];
435
7c5a308d
AD		 436 if (RSS_BACKEND_TYPE == "magpie") {
437 $icon_url = $rss->image["url"];
438 } else {
439 $icon_url = $rss->get_image_url(); # FIXME
440 }
b7f4bda2 441
147f7691 442 if ($icon_url && !$orig_icon_url != db_escape_string($icon_url)) {
b6eefba5
AD		 443 $icon_url = db_escape_string($icon_url);
444 db_query($link, "UPDATE ttrss_feeds SET icon_url = '$icon_url' WHERE id = '$feed'");
b7f4bda2
AD		 445 }
446
e6155a06
AD		 447
448 $filters = array();
449
4b3dff6e 450 $result = db_query($link, "SELECT reg_exp,
db42b934 451 ttrss_filter_types.name AS name,
52db9978 452 ttrss_filter_actions.name AS action
db42b934 453 FROM ttrss_filters,ttrss_filter_types,ttrss_filter_actions WHERE
e8b79d16 454 enabled = true AND
db42b934
AD		 455 owner_uid = $owner_uid AND
456 ttrss_filter_types.id = filter_type AND
457 ttrss_filter_actions.id = action_id AND
ead60402 458 (feed_id IS NULL OR feed_id = '$feed')");
e6155a06 459
b6eefba5 460 while ($line = db_fetch_assoc($result)) {
e6155a06 461 if (!$filters[$line["name"]]) $filters[$line["name"]] = array();
19c9cb11
AD		 462
463 $filter["reg_exp"] = $line["reg_exp"];
464 $filter["action"] = $line["action"];
465
466 array_push($filters[$line["name"]], $filter);
e6155a06
AD		 467 }
468
7c5a308d
AD		 469 if (RSS_BACKEND_TYPE == "magpie") {
470 $iterator = $rss->items;
ddb68b81 471
7c5a308d
AD		 472 if (!$iterator || !is_array($iterator)) $iterator = $rss->entries;
473 if (!$iterator || !is_array($iterator)) $iterator = $rss;
474
475 } else {
476 $iterator = $rss->get_items();
477 }
c22789da
AD		 478
479 if (!is_array($iterator)) {
39541e74 480 /* db_query($link, "UPDATE ttrss_feeds
75bd0669 481 SET last_error = 'Parse error: can\'t find any articles.'
39541e74 482 WHERE id = '$feed'"); */
c22789da
AD		 483 return; // WTF?
484 }
ddb68b81
AD		 485
486 foreach ($iterator as $item) {
7c5a308d
AD		 487
488 if (RSS_BACKEND_TYPE == "magpie") {
489
490 $entry_guid = $item["id"];
491
492 if (!$entry_guid) $entry_guid = $item["guid"];
493 if (!$entry_guid) $entry_guid = $item["link"];
1f64b1be
AD		 494 if (!$entry_guid) $entry_guid = make_guid_from_title($item["title"]);
495
7c5a308d 496 if (!$entry_guid) continue;
40d13c28 497
7c5a308d
AD		 498 $entry_timestamp = "";
499
500 $rss_2_date = $item['pubdate'];
501 $rss_1_date = $item['dc']['date'];
502 $atom_date = $item['issued'];
503 if (!$atom_date) $atom_date = $item['updated'];
b82af8c3 504
7c5a308d
AD		 505 if ($atom_date != "") $entry_timestamp = parse_w3cdtf($atom_date);
506 if ($rss_1_date != "") $entry_timestamp = parse_w3cdtf($rss_1_date);
507 if ($rss_2_date != "") $entry_timestamp = strtotime($rss_2_date);
508
509 if ($entry_timestamp == "") {
510 $entry_timestamp = time();
511 $no_orig_date = 'true';
512 } else {
513 $no_orig_date = 'false';
514 }
515
516 $entry_timestamp_fmt = strftime("%Y/%m/%d %H:%M:%S", $entry_timestamp);
517
7d3ab0dd 518 $entry_title = trim(strip_tags($item["title"]));
7c5a308d
AD		 519
520 // strange Magpie workaround
521 $entry_link = $item["link_"];
522 if (!$entry_link) $entry_link = $item["link"];
523
524 if (!$entry_title) continue;
1f64b1be 525# if (!$entry_link) continue;
7d3ab0dd
AD		 526
527 $entry_link = strip_tags($entry_link);
528
7c5a308d
AD		 529 $entry_content = $item["content:escaped"];
530
531 if (!$entry_content) $entry_content = $item["content:encoded"];
532 if (!$entry_content) $entry_content = $item["content"];
79b5d2d2 533 if (!$entry_content) $entry_content = $item["atom_content"];
7c5a308d
AD		 534 if (!$entry_content) $entry_content = $item["summary"];
535 if (!$entry_content) $entry_content = $item["description"];
536
537 // if (!$entry_content) continue;
538
539 // WTF
540 if (is_array($entry_content)) {
541 $entry_content = $entry_content["encoded"];
542 if (!$entry_content) $entry_content = $entry_content["escaped"];
543 }
544
545 // print_r($item);
546 // print_r(htmlspecialchars($entry_content));
547 // print "<br>";
548
549 $entry_content_unescaped = $entry_content;
550 $content_hash = "SHA1:" . sha1(strip_tags($entry_content));
551
7d3ab0dd 552 $entry_comments = strip_tags($item["comments"]);
7c5a308d 553
7d3ab0dd
AD		 554 $entry_author = db_escape_string(strip_tags($item['dc']['creator']));
555 $entry_guid = db_escape_string(strip_tags($entry_guid));
7c5a308d
AD		 556
557 $result = db_query($link, "SELECT id FROM ttrss_entries
558 WHERE guid = '$entry_guid'");
559
560 $entry_content = db_escape_string($entry_content);
561 $entry_title = db_escape_string($entry_title);
562 $entry_link = db_escape_string($entry_link);
563 $entry_comments = db_escape_string($entry_comments);
564
565 $num_comments = db_escape_string($item["slash"]["comments"]);
566
567 if (!$num_comments) $num_comments = 0;
8add756a
AD		 568 }
569
d48d160c 570 # sanitize content
183ad07b
AD		 571
572 $entry_content = sanitize_rss($entry_content);
d48d160c 573
44e241cb
AD		 574 db_query($link, "BEGIN");
575
4c193675
AD		 576 if (db_num_rows($result) == 0) {
577
578 // base post entry does not exist, create it
579
4c193675
AD		 580 $result = db_query($link,
581 "INSERT INTO ttrss_entries
582 (title,
583 guid,
584 link,
585 updated,
586 content,
587 content_hash,
588 no_orig_date,
589 date_entered,
11b0dce2 590 comments,
b6104dee
AD		 591 num_comments,
592 author)
4c193675
AD		 593 VALUES
594 ('$entry_title',
595 '$entry_guid',
596 '$entry_link',
597 '$entry_timestamp_fmt',
598 '$entry_content',
599 '$content_hash',
600 $no_orig_date,
601 NOW(),
11b0dce2 602 '$entry_comments',
b6104dee
AD		 603 '$num_comments',
604 '$entry_author')");
8926aab8
AD		 605 } else {
606 // we keep encountering the entry in feeds, so we need to
607 // update date_entered column so that we don't get horrible
608 // dupes when the entry gets purged and reinserted again e.g.
609 // in the case of SLOW SLOW OMG SLOW updating feeds
610
611 $base_entry_id = db_fetch_result($result, 0, "id");
612
613 db_query($link, "UPDATE ttrss_entries SET date_entered = NOW()
614 WHERE id = '$base_entry_id'");
4c193675
AD		 615 }
616
617 // now it should exist, if not - bad luck then
618
6385315d
AD		 619 $result = db_query($link, "SELECT
620 id,content_hash,no_orig_date,title,
8926aab8 621 substring(date_entered,1,19) as date_entered,
11b0dce2
AD		 622 substring(updated,1,19) as updated,
623 num_comments
6385315d
AD		 624 FROM
625 ttrss_entries
626 WHERE guid = '$entry_guid'");
4c193675
AD		 627
628 if (db_num_rows($result) == 1) {
629
11b0dce2
AD		 630 // this will be used below in update handler
631 $orig_content_hash = db_fetch_result($result, 0, "content_hash");
632 $orig_title = db_fetch_result($result, 0, "title");
633 $orig_num_comments = db_fetch_result($result, 0, "num_comments");
8926aab8
AD		 634 $orig_date_entered = strtotime(db_fetch_result($result,
635 0, "date_entered"));
6385315d 636
11b0dce2 637 $ref_id = db_fetch_result($result, 0, "id");
4c193675 638
11b0dce2 639 // check for user post link to main table
4c193675 640
11b0dce2 641 // do we allow duplicate posts with same GUID in different feeds?
8d0ec6fd 642 if (get_pref($link, "ALLOW_DUPLICATE_POSTS", $owner_uid, false)) {
11b0dce2
AD		 643 $dupcheck_qpart = "AND feed_id = '$feed'";
644 } else {
645 $dupcheck_qpart = "";
646 }
71604ca4 647
11b0dce2 648// error_reporting(0);
19c9cb11 649
11b0dce2
AD		 650 $filter_name = get_filter_name($entry_title, $entry_content,
651 $entry_link, $filters);
19c9cb11 652
11b0dce2
AD		 653 if ($filter_name == "filter") {
654 continue;
655 }
19c9cb11 656
11b0dce2 657// error_reporting (DEFAULT_ERROR_LEVEL);
3a933f22 658
11b0dce2
AD		 659 $result = db_query($link,
660 "SELECT ref_id FROM ttrss_user_entries WHERE
661 ref_id = '$ref_id' AND owner_uid = '$owner_uid'
662 $dupcheck_qpart");
663
664 // okay it doesn't exist - create user entry
665 if (db_num_rows($result) == 0) {
666
667 if ($filter_name != 'catchup') {
668 $unread = 'true';
669 $last_read_qpart = 'NULL';
670 } else {
671 $unread = 'false';
672 $last_read_qpart = 'NOW()';
673 }
dd7d3187
AD		 674
675 if ($filter_name == 'mark') {
676 $marked = 'true';
677 } else {
678 $marked = 'false';
679 }
19c9cb11 680
11b0dce2
AD		 681 $result = db_query($link,
682 "INSERT INTO ttrss_user_entries
dd7d3187 683 (ref_id, owner_uid, feed_id, unread, last_read, marked)
11b0dce2 684 VALUES ('$ref_id', '$owner_uid', '$feed', $unread,
dd7d3187 685 $last_read_qpart, $marked)");
11b0dce2
AD		 686 }
687
6385315d
AD		 688 $post_needs_update = false;
689
8d0ec6fd 690 if (get_pref($link, "UPDATE_POST_ON_CHECKSUM_CHANGE", $owner_uid, false) &&
6385315d
AD		 691 ($content_hash != $orig_content_hash)) {
692 $post_needs_update = true;
693 }
694
695 if ($orig_title != $entry_title) {
696 $post_needs_update = true;
697 }
698
11b0dce2
AD		 699 if ($orig_num_comments != $num_comments) {
700 $post_needs_update = true;
701 }
702
6385315d
AD		 703// this doesn't seem to be very reliable
704//
705// if ($orig_timestamp != $entry_timestamp && !$orig_no_orig_date) {
706// $post_needs_update = true;
707// }
708
709 // if post needs update, update it and mark all user entries
1c73bc0c 710 // linking to this post as updated
6385315d
AD		 711 if ($post_needs_update) {
712
713// print "<!-- post $orig_title needs update : $post_needs_update -->";
714
6385315d 715 db_query($link, "UPDATE ttrss_entries
11b0dce2
AD		 716 SET title = '$entry_title', content = '$entry_content',
717 num_comments = '$num_comments'
6385315d
AD		 718 WHERE id = '$ref_id'");
719
8d0ec6fd 720 if (get_pref($link, "MARK_UNREAD_ON_UPDATE", $owner_uid, false)) {
4919fb42
AD		 721 db_query($link, "UPDATE ttrss_user_entries
722 SET last_read = null, unread = true WHERE ref_id = '$ref_id'");
723 } else {
724 db_query($link, "UPDATE ttrss_user_entries
725 SET last_read = null WHERE ref_id = '$ref_id' AND unread = false");
726 }
6385315d
AD		 727
728 }
4c193675
AD		 729 }
730
44e241cb
AD		 731 db_query($link, "COMMIT");
732
eb36b4eb
AD		 733 /* taaaags */
734 // <a href="http://technorati.com/tag/Xorg" rel="tag">Xorg</a>, //
735
05732aa0 736 $entry_tags = null;
eb36b4eb 737
372ced8b 738 preg_match_all("/<a.*?href=.http:\/\/.*?technorati.com\/tag\/([^\"\'>]+)/i",
ee2c3050
AD		 739 $entry_content_unescaped, $entry_tags);
740
741// print "<br>$entry_title : $entry_content_unescaped<br>";
742// print_r($entry_tags);
372ced8b 743// print "<br>";
eb36b4eb
AD		 744
745 $entry_tags = $entry_tags[1];
746
747 if (count($entry_tags) > 0) {
748
44e241cb
AD		 749 db_query($link, "BEGIN");
750
05732aa0
AD		 751 $result = db_query($link, "SELECT id,int_id
752 FROM ttrss_entries,ttrss_user_entries
25da6909 753 WHERE guid = '$entry_guid'
05732aa0 754 AND feed_id = '$feed' AND ref_id = id
7fed1940 755 AND owner_uid = '$owner_uid'");
eb36b4eb 756
fe99ab12 757 if (db_num_rows($result) == 1) {
eb36b4eb 758
fe99ab12
AD		 759 $entry_id = db_fetch_result($result, 0, "id");
760 $entry_int_id = db_fetch_result($result, 0, "int_id");
761
762 foreach ($entry_tags as $tag) {
763 $tag = db_escape_string(strtolower($tag));
31483fc1
AD		 764
765 $tag = str_replace("+", " ", $tag);
fe99ab12
AD		 766 $tag = str_replace("technorati tag: ", "", $tag);
767
768 $result = db_query($link, "SELECT id FROM ttrss_tags
769 WHERE tag_name = '$tag' AND post_int_id = '$entry_int_id' AND
770 owner_uid = '$owner_uid' LIMIT 1");
771
772 // print db_fetch_result($result, 0, "id");
773
774 if ($result && db_num_rows($result) == 0) {
775
776 // print "tagging $entry_id as $tag<br>";
777
778 db_query($link, "INSERT INTO ttrss_tags
779 (owner_uid,tag_name,post_int_id)
780 VALUES ('$owner_uid','$tag', '$entry_int_id')");
781 }
782 }
eb36b4eb 783 }
44e241cb 784 db_query($link, "COMMIT");
05732aa0 785 }
4c193675 786 }
40d13c28 787
ab3d0b99
AD		 788 db_query($link, "UPDATE ttrss_feeds
789 SET last_updated = NOW(), last_error = '' WHERE id = '$feed'");
eb36b4eb 790
44e241cb 791// db_query($link, "COMMIT");
dd8c76a9 792
ab3d0b99
AD		 793 } else {
794 $error_msg = db_escape_string(magpie_error());
795 db_query($link,
aa5f9f5f
AD		 796 "UPDATE ttrss_feeds SET last_error = '$error_msg',
797 last_updated = NOW() WHERE id = '$feed'");
40d13c28
AD		 798 }
799
800 }
801
f175937c 802 function print_select($id, $default, $values, $attributes = "") {
79f3553b 803 print "<select name=\"$id\" id=\"$id\" $attributes>";
a0d53889
AD		 804 foreach ($values as $v) {
805 if ($v == $default)
806 $sel = " selected";
807 else
808 $sel = "";
809
810 print "<option$sel>$v</option>";
811 }
812 print "</select>";
813 }
40d13c28 814
79f3553b
AD		 815 function print_select_hash($id, $default, $values, $attributes = "") {
816 print "<select name=\"$id\" id='$id' $attributes>";
673d54ca
AD		 817 foreach (array_keys($values) as $v) {
818 if ($v == $default)
819 $sel = "selected";
820 else
821 $sel = "";
822
823 print "<option $sel value=\"$v\">".$values[$v]."</option>";
824 }
825
826 print "</select>";
827 }
828
19c9cb11 829 function get_filter_name($title, $content, $link, $filters) {
e6155a06
AD		 830
831 if ($filters["title"]) {
19c9cb11
AD		 832 foreach ($filters["title"] as $filter) {
833 $reg_exp = $filter["reg_exp"];
834 if (preg_match("/$reg_exp/i", $title)) {
835 return $filter["action"];
836 }
e6155a06
AD		 837 }
838 }
839
840 if ($filters["content"]) {
19c9cb11
AD		 841 foreach ($filters["content"] as $filter) {
842 $reg_exp = $filter["reg_exp"];
843 if (preg_match("/$reg_exp/i", $content)) {
844 return $filter["action"];
845 }
e6155a06
AD		 846 }
847 }
848
849 if ($filters["both"]) {
850 foreach ($filters["both"] as $filter) {
19c9cb11
AD		 851 $reg_exp = $filter["reg_exp"];
852 if (preg_match("/$reg_exp/i", $title) ||
853 preg_match("/$reg_exp/i", $content)) {
854 return $filter["action"];
855 }
e6155a06
AD		 856 }
857 }
858
3a933f22 859 if ($filters["link"]) {
19c9cb11
AD		 860 $reg_exp = $filter["reg_exp"];
861 foreach ($filters["link"] as $filter) {
862 $reg_exp = $filter["reg_exp"];
863 if (preg_match("/$reg_exp/i", $link)) {
864 return $filter["action"];
865 }
3a933f22
AD		 866 }
867 }
868
e6155a06
AD		 869 return false;
870 }
871
9323147e 872 function printFeedEntry($feed_id, $class, $feed_title, $unread, $icon_file, $link,
fb1fb4ab 873 $rtl_content = false, $last_updated = false, $last_error = false) {
254e0e4b
AD		 874
875 if (file_exists($icon_file) && filesize($icon_file) > 0) {
023fe037 876 $feed_icon = "<img id=\"FIMG-$feed_id\" src=\"$icon_file\">";
254e0e4b 877 } else {
023fe037 878 $feed_icon = "<img id=\"FIMG-$feed_id\" src=\"images/blank_icon.gif\">";
254e0e4b
AD		 879 }
880
9323147e
AD		 881 if ($rtl_content) {
882 $rtl_tag = "dir=\"rtl\"";
883 } else {
884 $rtl_tag = "dir=\"ltr\"";
885 }
886
78d5212c
AD		 887 $error_notify_msg = "";
888
fb1fb4ab
AD		 889 if ($last_error) {
890 $link_title = "Error: $last_error ($last_updated)";
78d5212c 891 $error_notify_msg = "(Error)";
ad780e9c 892 } else if ($last_updated) {
fb1fb4ab
AD		 893 $link_title = "Updated: $last_updated";
894 }
895
767e2486 896 $feed = "<a title=\"$link_title\" id=\"FEEDL-$feed_id\" href=\"javascript:viewfeed('$feed_id', '', false);\">$feed_title</a>";
254e0e4b
AD		 897
898 print "<li id=\"FEEDR-$feed_id\" class=\"$class\">";
b619ff15 899 if (get_pref($link, 'ENABLE_FEED_ICONS')) {
254e0e4b
AD		 900 print "$feed_icon";
901 }
902
9323147e 903 print "<span $rtl_tag id=\"FEEDN-$feed_id\">$feed</span>";
254e0e4b
AD		 904
905 if ($unread != 0) {
906 $fctr_class = "";
907 } else {
908 $fctr_class = "class=\"invisible\"";
909 }
910
9323147e 911 print " <span $rtl_tag $fctr_class id=\"FEEDCTR-$feed_id\">
254e0e4b 912 (<span id=\"FEEDU-$feed_id\">$unread</span>)</span>";
78d5212c
AD		 913
914 if (get_pref($link, "EXTENDED_FEEDLIST")) {
915 print "<div class=\"feedExtInfo\">
916 <span id=\"FLUPD-$feed_id\">$last_updated $error_notify_msg</span></div>";
917 }
918
254e0e4b
AD		 919 print "</li>";
920
921 }
922
406d9489
AD		 923 function getmicrotime() {
924 list($usec, $sec) = explode(" ",microtime());
925 return ((float)$usec + (float)$sec);
926 }
927
77e96719
AD		 928 function print_radio($id, $default, $values, $attributes = "") {
929 foreach ($values as $v) {
930
931 if ($v == $default)
5da169d9 932 $sel = "checked";
77e96719 933 else
5da169d9
AD		 934 $sel = "";
935
936 if ($v == "Yes") {
937 $sel .= " value=\"1\"";
938 } else {
939 $sel .= " value=\"0\"";
940 }
77e96719 941
69654950
AD		 942 print "<input class=\"noborder\"
943 type=\"radio\" $sel $attributes name=\"$id\">&nbsp;$v&nbsp;";
77e96719
AD		 944
945 }
946 }
947
ff485f1d
AD		 948 function initialize_user_prefs($link, $uid) {
949
950 $uid = db_escape_string($uid);
951
952 db_query($link, "BEGIN");
953
954 $result = db_query($link, "SELECT pref_name,def_value FROM ttrss_prefs");
955
956 $u_result = db_query($link, "SELECT pref_name
957 FROM ttrss_user_prefs WHERE owner_uid = '$uid'");
958
959 $active_prefs = array();
960
961 while ($line = db_fetch_assoc($u_result)) {
962 array_push($active_prefs, $line["pref_name"]);
963 }
964
965 while ($line = db_fetch_assoc($result)) {
966 if (array_search($line["pref_name"], $active_prefs) === FALSE) {
967// print "adding " . $line["pref_name"] . "<br>";
968
969 db_query($link, "INSERT INTO ttrss_user_prefs
970 (owner_uid,pref_name,value) VALUES
971 ('$uid', '".$line["pref_name"]."','".$line["def_value"]."')");
972
973 }
974 }
975
976 db_query($link, "COMMIT");
977
978 }
956c7629
AD		 979
980 function lookup_user_id($link, $user) {
981
982 $result = db_query($link, "SELECT id FROM ttrss_users WHERE
983 login = '$login'");
984
985 if (db_num_rows($result) == 1) {
986 return db_fetch_result($result, 0, "id");
987 } else {
988 return false;
989 }
990 }
991
18664970
AD		 992 function http_authenticate_user($link) {
993
994 if (!$_SERVER["PHP_AUTH_USER"]) {
995
996 header('WWW-Authenticate: Basic realm="Tiny Tiny RSS RSSGen"');
997 header('HTTP/1.0 401 Unauthorized');
998 exit;
999
1000 } else {
1001 $auth_result = authenticate_user($link,
1002 $_SERVER["PHP_AUTH_USER"], $_SERVER["PHP_AUTH_PW"]);
1003
1004 if (!$auth_result) {
1005 header('WWW-Authenticate: Basic realm="Tiny Tiny RSS RSSGen"');
1006 header('HTTP/1.0 401 Unauthorized');
1007 exit;
1008 }
1009 }
1010
1011 return true;
1012 }
1013
c8437f35
AD		 1014 function authenticate_user($link, $login, $password) {
1015
131b01b3 1016 if (!SINGLE_USER_MODE) {
c8437f35 1017
131b01b3
AD		 1018 $pwd_hash = 'SHA1:' . sha1($password);
1019
1020 $result = db_query($link, "SELECT id,login,access_level FROM ttrss_users WHERE
1021 login = '$login' AND pwd_hash = '$pwd_hash'");
1022
1023 if (db_num_rows($result) == 1) {
1024 $_SESSION["uid"] = db_fetch_result($result, 0, "id");
1025 $_SESSION["name"] = db_fetch_result($result, 0, "login");
1026 $_SESSION["access_level"] = db_fetch_result($result, 0, "access_level");
1027
1028 db_query($link, "UPDATE ttrss_users SET last_login = NOW() WHERE id = " .
1029 $_SESSION["uid"]);
1030
1031 $user_theme = get_user_theme_path($link);
1032
1033 $_SESSION["theme"] = $user_theme;
1034 $_SESSION["ip_address"] = $_SERVER["REMOTE_ADDR"];
1035
1036 initialize_user_prefs($link, $_SESSION["uid"]);
1037
1038 return true;
1039 }
1040
1041 return false;
503eb349 1042
131b01b3 1043 } else {
503eb349 1044
131b01b3
AD		 1045 $_SESSION["uid"] = 1;
1046 $_SESSION["name"] = "admin";
f557cd78 1047
0bbba72d
AD		 1048 $user_theme = get_user_theme_path($link);
1049
1050 $_SESSION["theme"] = $user_theme;
1051 $_SESSION["ip_address"] = $_SERVER["REMOTE_ADDR"];
1052
1053 initialize_user_prefs($link, $_SESSION["uid"]);
1054
c8437f35
AD		 1055 return true;
1056 }
c8437f35
AD		 1057 }
1058
e6cb77a0
AD		 1059 function make_password($length = 8) {
1060
1061 $password = "";
798f722b
AD		 1062 $possible = "0123456789abcdfghjkmnpqrstvwxyzABCDFGHJKMNPQRSTVWXYZ";
1063
1064 $i = 0;
e6cb77a0
AD		 1065
1066 while ($i < $length) {
1067 $char = substr($possible, mt_rand(0, strlen($possible)-1), 1);
1068
1069 if (!strstr($password, $char)) {
1070 $password .= $char;
1071 $i++;
1072 }
1073 }
1074 return $password;
1075 }
1076
1077 // this is called after user is created to initialize default feeds, labels
1078 // or whatever else
1079
1080 // user preferences are checked on every login, not here
1081
1082 function initialize_user($link, $uid) {
1083
1084 db_query($link, "insert into ttrss_labels (owner_uid,sql_exp,description)
1085 values ('$uid','unread = true', 'Unread articles')");
1086
1087 db_query($link, "insert into ttrss_labels (owner_uid,sql_exp,description)
1088 values ('$uid','last_read is null and unread = false', 'Updated articles')");
1089
1090 db_query($link, "insert into ttrss_feeds (owner_uid,title,feed_url)
74bff337 1091 values ('$uid', 'Tiny Tiny RSS: New Releases',
628fcd2c 1092 'http://tt-rss.spb.ru/releases.rss')");
3b0feb9b
AD		 1093
1094 }
e6cb77a0 1095
b8aa49bc 1096 function logout_user() {
5ccc1cf5
AD		 1097 session_destroy();
1098 if (isset($_COOKIE[session_name()])) {
1099 setcookie(session_name(), '', time()-42000, '/');
1100 }
b8aa49bc
AD		 1101 }
1102
75836f33 1103 function get_script_urlpath() {
87a79fa4 1104 return preg_replace('/\/[^\/]*$/', "", $_SERVER["REQUEST_URI"]);
75836f33
AD		 1105 }
1106
1107 function get_login_redirect() {
1108 $server = $_SERVER["SERVER_NAME"];
1109
1110 if (ENABLE_LOGIN_SSL) {
1111 $protocol = "https";
1112 } else {
1113 $protocol = "http";
1114 }
1115
1116 $url_path = get_script_urlpath();
1117
1118 $redirect_uri = "$protocol://$server$url_path/login.php";
1119
1120 return $redirect_uri;
1121 }
1122
916f788a 1123 function validate_session($link) {
a2e9b457 1124 if (SESSION_CHECK_ADDRESS && $_SESSION["uid"]) {
916f788a
AD		 1125 if ($_SESSION["ip_address"]) {
1126 if ($_SESSION["ip_address"] != $_SERVER["REMOTE_ADDR"]) {
1127 return false;
1128 }
1129 }
1130 }
1131 return true;
1132 }
1133
7ae65adf
AD		 1134 function basic_nosid_redirect_check() {
1135 if (!SINGLE_USER_MODE) {
3dd46f19 1136 if (!$_COOKIE[get_session_cookie_name()]) {
7ae65adf
AD		 1137 $redirect_uri = get_login_redirect();
1138 $return_to = preg_replace('/.*?\//', '', $_SERVER["REQUEST_URI"]);
1139 header("Location: $redirect_uri?rt=$return_to");
1140 exit;
1141 }
1142 }
1143 }
1144
b8aa49bc
AD		 1145 function login_sequence($link) {
1146 if (!SINGLE_USER_MODE) {
75836f33 1147
916f788a
AD		 1148 if (!validate_session($link)) {
1149 logout_user();
1150 $redirect_uri = get_login_redirect();
1151 $return_to = preg_replace('/.*?\//', '', $_SERVER["REQUEST_URI"]);
1152 header("Location: $redirect_uri?rt=$return_to");
1153 exit;
1154 }
1155
b8aa49bc
AD		 1156 if (!USE_HTTP_AUTH) {
1157 if (!$_SESSION["uid"]) {
75836f33 1158 $redirect_uri = get_login_redirect();
e31dca14
AD		 1159 $return_to = preg_replace('/.*?\//', '', $_SERVER["REQUEST_URI"]);
1160 header("Location: $redirect_uri?rt=$return_to");
b8aa49bc
AD		 1161 exit;
1162 }
1163 } else {
f557cd78
AD		 1164 if (!$_SESSION["uid"]) {
1165 if (!$_SERVER["PHP_AUTH_USER"]) {
1166
1167 header('WWW-Authenticate: Basic realm="Tiny Tiny RSS"');
1168 header('HTTP/1.0 401 Unauthorized');
1169 exit;
1170
1171 } else {
1172 $auth_result = authenticate_user($link,
1173 $_SERVER["PHP_AUTH_USER"], $_SERVER["PHP_AUTH_PW"]);
1174
1175 if (!$auth_result) {
1176 header('WWW-Authenticate: Basic realm="Tiny Tiny RSS"');
1177 header('HTTP/1.0 401 Unauthorized');
1178 exit;
1179 }
1180 }
1181 }
b8aa49bc
AD		 1182 }
1183 } else {
0bbba72d 1184 return authenticate_user($link, "admin", null);
b8aa49bc
AD		 1185 }
1186 }
3547842a
AD		 1187
1188 function truncate_string($str, $max_len) {
12db369c
AD		 1189 if (mb_strlen($str, "utf-8") > $max_len - 3) {
1190 return mb_substr($str, 0, $max_len, "utf-8") . "...";
3547842a
AD		 1191 } else {
1192 return $str;
1193 }
1194 }
54a60e1a
AD		 1195
1196 function get_user_theme_path($link) {
798f722b
AD		 1197 $result = db_query($link, "SELECT theme_path
1198 FROM
1199 ttrss_themes,ttrss_users
1200 WHERE ttrss_themes.id = theme_id AND ttrss_users.id = " . $_SESSION["uid"]);
54a60e1a
AD		 1201 if (db_num_rows($result) != 0) {
1202 return db_fetch_result($result, 0, "theme_path");
1203 } else {
1204 return null;
1205 }
1206 }
be773442
AD		 1207
1208 function smart_date_time($timestamp) {
1209 if (date("Y.m.d", $timestamp) == date("Y.m.d")) {
1210 return date("G:i", $timestamp);
f26450f1 1211 } else if (date("Y", $timestamp) == date("Y")) {
be773442
AD		 1212 return date("M d, G:i", $timestamp);
1213 } else {
b02111c2 1214 return date("Y/m/d G:i", $timestamp);
be773442
AD		 1215 }
1216 }
1217
1218 function smart_date($timestamp) {
1219 if (date("Y.m.d", $timestamp) == date("Y.m.d")) {
1220 return "Today";
f26450f1 1221 } else if (date("Y", $timestamp) == date("Y")) {
be773442
AD		 1222 return date("D m", $timestamp);
1223 } else {
b02111c2 1224 return date("Y/m/d", $timestamp);
be773442
AD		 1225 }
1226 }
a654a595
AD		 1227
1228 function sql_bool_to_string($s) {
1229 if ($s == "t" || $s == "1") {
1230 return "true";
1231 } else {
1232 return "false";
1233 }
1234 }
e3c99f3b
AD		 1235
1236 function sql_bool_to_bool($s) {
1237 if ($s == "t" || $s == "1") {
1238 return true;
1239 } else {
1240 return false;
1241 }
1242 }
0ea4fb50 1243
e3c99f3b 1244
0ea4fb50
AD		 1245 function toggleEvenOdd($a) {
1246 if ($a == "even")
1247 return "odd";
1248 else
1249 return "even";
1250 }
6043fb7e
AD		 1251
1252 function sanity_check($link) {
9cbca41f 1253
aec3ce39
AD		 1254 error_reporting(0);
1255
6043fb7e
AD		 1256 $error_code = 0;
1257 $result = db_query($link, "SELECT schema_version FROM ttrss_version");
1258 $schema_version = db_fetch_result($result, 0, "schema_version");
1259
1260 if ($schema_version != SCHEMA_VERSION) {
1261 $error_code = 5;
1262 }
1263
aec3ce39
AD		 1264 if (DB_TYPE == "mysql") {
1265 $result = db_query($link, "SELECT true", false);
1266 if (db_num_rows($result) != 1) {
1267 $error_code = 10;
1268 }
1269 }
1270
1271 error_reporting (DEFAULT_ERROR_LEVEL);
1272
6043fb7e 1273 if ($error_code != 0) {
aec3ce39 1274 print_error_xml($error_code);
6043fb7e
AD		 1275 return false;
1276 } else {
1277 return true;
9cbca41f 1278 }
6043fb7e
AD		 1279 }
1280
27981ca3
AD		 1281 function file_is_locked($filename) {
1282 error_reporting(0);
1283 $fp = fopen($filename, "r");
1284 error_reporting(DEFAULT_ERROR_LEVEL);
1285 if ($fp) {
1286 if (flock($fp, LOCK_EX | LOCK_NB)) {
1287 flock($fp, LOCK_UN);
1288 fclose($fp);
1289 return false;
1290 }
1291 fclose($fp);
1292 return true;
1293 }
1294 return false;
1295 }
1296
fcb4c0c9
AD		 1297 function make_lockfile($filename) {
1298 $fp = fopen($filename, "w");
1299
1300 if (flock($fp, LOCK_EX | LOCK_NB)) {
1301 return $fp;
1302 } else {
1303 return false;
1304 }
1305 }
1306
894ebcf5
AD		 1307 function sql_random_function() {
1308 if (DB_TYPE == "mysql") {
1309 return "RAND()";
1310 } else {
1311 return "RANDOM()";
1312 }
1313 }
1314
23aa0d16 1315 function catchup_feed($link, $feed, $cat_view) {
88040f57
AD		 1316
1317 if (preg_match("/^-?[0-9][0-9]*$/", $feed) != false) {
23aa0d16
AD		 1318
1319 if ($cat_view) {
1320
1321 if ($feed > 0) {
1322 $cat_qpart = "cat_id = '$feed'";
1323 } else {
1324 $cat_qpart = "cat_id IS NULL";
1325 }
1326
1327 $tmp_result = db_query($link, "SELECT id
1328 FROM ttrss_feeds WHERE $cat_qpart AND owner_uid = " .
1329 $_SESSION["uid"]);
1330
1331 while ($tmp_line = db_fetch_assoc($tmp_result)) {
1332
1333 $tmp_feed = $tmp_line["id"];
1334
1335 db_query($link, "UPDATE ttrss_user_entries
1336 SET unread = false,last_read = NOW()
1337 WHERE feed_id = '$tmp_feed' AND owner_uid = " . $_SESSION["uid"]);
1338 }
1339
1340 } else if ($feed > 0) {
1341
1342 $tmp_result = db_query($link, "SELECT id
1343 FROM ttrss_feeds WHERE parent_feed = '$feed'
1344 ORDER BY cat_id,title");
1345
1346 $parent_ids = array();
1347
1348 if (db_num_rows($tmp_result) > 0) {
1349 while ($p = db_fetch_assoc($tmp_result)) {
1350 array_push($parent_ids, "feed_id = " . $p["id"]);
1351 }
1352
1353 $children_qpart = implode(" OR ", $parent_ids);
1354
1355 db_query($link, "UPDATE ttrss_user_entries
1356 SET unread = false,last_read = NOW()
1357 WHERE (feed_id = '$feed' OR $children_qpart)
1358 AND owner_uid = " . $_SESSION["uid"]);
1359
1360 } else {
1361 db_query($link, "UPDATE ttrss_user_entries
1362 SET unread = false,last_read = NOW()
1363 WHERE feed_id = '$feed' AND owner_uid = " . $_SESSION["uid"]);
1364 }
1365
1366 } else if ($feed < 0 && $feed > -10) { // special, like starred
1367
1368 if ($feed == -1) {
1369 db_query($link, "UPDATE ttrss_user_entries
1370 SET unread = false,last_read = NOW()
1371 WHERE marked = true AND owner_uid = ".$_SESSION["uid"]);
1372 }
1373
1374 } else if ($feed < -10) { // label
1375
1376 // TODO make this more efficient
1377
1378 $label_id = -$feed - 11;
1379
1380 $tmp_result = db_query($link, "SELECT sql_exp FROM ttrss_labels
1381 WHERE id = '$label_id'");
1382
1383 if ($tmp_result) {
1384 $sql_exp = db_fetch_result($tmp_result, 0, "sql_exp");
1385
1386 db_query($link, "BEGIN");
1387
1388 $tmp2_result = db_query($link,
1389 "SELECT
1390 int_id
1391 FROM
88040f57 1392 ttrss_user_entries,ttrss_entries,ttrss_feeds
23aa0d16 1393 WHERE
88040f57
AD		 1394 ref_id = ttrss_entries.id AND
1395 ttrss_user_entries.feed_id = ttrss_feeds.id AND
23aa0d16 1396 $sql_exp AND
88040f57 1397 ttrss_user_entries.owner_uid = " . $_SESSION["uid"]);
23aa0d16
AD		 1398
1399 while ($tmp_line = db_fetch_assoc($tmp2_result)) {
1400 db_query($link, "UPDATE
1401 ttrss_user_entries
1402 SET
1403 unread = false, last_read = NOW()
1404 WHERE
1405 int_id = " . $tmp_line["int_id"]);
1406 }
1407
1408 db_query($link, "COMMIT");
1409
1410/* db_query($link, "UPDATE ttrss_user_entries,ttrss_entries
1411 SET unread = false,last_read = NOW()
1412 WHERE $sql_exp
1413 AND ref_id = id
1414 AND owner_uid = ".$_SESSION["uid"]); */
1415 }
1416 }
1417 } else { // tag
1418 db_query($link, "BEGIN");
1419
1420 $tag_name = db_escape_string($feed);
1421
1422 $result = db_query($link, "SELECT post_int_id FROM ttrss_tags
1423 WHERE tag_name = '$tag_name' AND owner_uid = " . $_SESSION["uid"]);
1424
1425 while ($line = db_fetch_assoc($result)) {
1426 db_query($link, "UPDATE ttrss_user_entries SET
1427 unread = false, last_read = NOW()
1428 WHERE int_id = " . $line["post_int_id"]);
1429 }
1430 db_query($link, "COMMIT");
1431 }
1432 }
1433
1434 function update_generic_feed($link, $feed, $cat_view) {
1435 if ($cat_view) {
1436
1437 if ($feed > 0) {
1438 $cat_qpart = "cat_id = '$feed'";
1439 } else {
1440 $cat_qpart = "cat_id IS NULL";
1441 }
1442
1443 $tmp_result = db_query($link, "SELECT feed_url FROM ttrss_feeds
1444 WHERE $cat_qpart AND owner_uid = " . $_SESSION["uid"]);
1445
1446 while ($tmp_line = db_fetch_assoc($tmp_result)) {
1447 $feed_url = $tmp_line["feed_url"];
1448 update_rss_feed($link, $feed_url, $feed, ENABLE_UPDATE_DAEMON);
1449 }
1450
1451 } else {
1452 $tmp_result = db_query($link, "SELECT feed_url FROM ttrss_feeds
1453 WHERE id = '$feed'");
1454 $feed_url = db_fetch_result($tmp_result, 0, "feed_url");
1455 update_rss_feed($link, $feed_url, $feed, ENABLE_UPDATE_DAEMON);
1456 }
1457 }
a9cb1f83
AD		 1458
1459 function getAllCounters($link) {
1460 getLabelCounters($link);
1461 getFeedCounters($link);
1462 getTagCounters($link);
1463 getGlobalCounters($link);
1464 if (get_pref($link, 'ENABLE_FEED_CATS')) {
1465 getCategoryCounters($link);
1466 }
1467 }
1468
1469 function getCategoryCounters($link) {
1470 $result = db_query($link, "SELECT cat_id,SUM((SELECT COUNT(int_id)
1471 FROM ttrss_user_entries WHERE feed_id = ttrss_feeds.id
1472 AND unread = true)) AS unread FROM ttrss_feeds
1473 WHERE
cfb02131 1474 hidden = false AND owner_uid = ".$_SESSION["uid"]." GROUP BY cat_id");
a9cb1f83
AD		 1475
1476 while ($line = db_fetch_assoc($result)) {
1477 $line["cat_id"] = sprintf("%d", $line["cat_id"]);
1478 print "<counter type=\"category\" id=\"".$line["cat_id"]."\" counter=\"".
1479 $line["unread"]."\"/>";
1480 }
1481 }
1482
f295c368
AD		 1483 function getCategoryUnread($link, $cat) {
1484
18664970
AD		 1485 if ($cat != 0) {
1486 $cat_query = "cat_id = '$cat'";
1487 } else {
1488 $cat_query = "cat_id IS NULL";
1489 }
1490
1491 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE $cat_query
cfb02131 1492 AND hidden = false
f295c368
AD		 1493 AND owner_uid = " . $_SESSION["uid"]);
1494
1495 $cat_feeds = array();
1496 while ($line = db_fetch_assoc($result)) {
1497 array_push($cat_feeds, "feed_id = " . $line["id"]);
1498 }
1499
18664970
AD		 1500 if (count($cat_feeds) == 0) return 0;
1501
f295c368
AD		 1502 $match_part = implode(" OR ", $cat_feeds);
1503
1504 $result = db_query($link, "SELECT COUNT(int_id) AS unread
1505 FROM ttrss_user_entries
4919fb42 1506 WHERE unread = true AND ($match_part) AND owner_uid = " . $_SESSION["uid"]);
f295c368
AD		 1507
1508 $unread = 0;
1509
1510 # this needs to be rewritten
1511 while ($line = db_fetch_assoc($result)) {
1512 $unread += $line["unread"];
1513 }
1514
1515 return $unread;
1516
1517 }
1518
1519 function getFeedUnread($link, $feed, $is_cat = false) {
a9cb1f83 1520 $n_feed = sprintf("%d", $feed);
f295c368
AD		 1521
1522 if ($is_cat) {
831ff047 1523 return getCategoryUnread($link, $n_feed);
f295c368 1524 } else if ($n_feed == -1) {
a9cb1f83 1525 $match_part = "marked = true";
4919fb42 1526 } else if ($n_feed > 0) {
831ff047 1527
4919fb42 1528 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE parent_feed = '$n_feed'
318260cc 1529 AND hidden = false
4919fb42 1530 AND owner_uid = " . $_SESSION["uid"]);
831ff047
AD		 1531
1532 if (db_num_rows($result) > 0) {
4919fb42 1533
831ff047
AD		 1534 $linked_feeds = array();
1535 while ($line = db_fetch_assoc($result)) {
1536 array_push($linked_feeds, "feed_id = " . $line["id"]);
1537 }
1538
1539 $match_part = implode(" OR ", $linked_feeds);
1540
4919fb42 1541 $result = db_query($link, "SELECT COUNT(int_id) AS unread
318260cc 1542 FROM ttrss_user_entries
4919fb42
AD		 1543 WHERE unread = true AND ($match_part) AND owner_uid = " . $_SESSION["uid"]);
1544
1545 $unread = 0;
1546
1547 # this needs to be rewritten
1548 while ($line = db_fetch_assoc($result)) {
1549 $unread += $line["unread"];
1550 }
1551
1552 return $unread;
1553
831ff047
AD		 1554 } else {
1555 $match_part = "feed_id = '$n_feed'";
1556 }
a9cb1f83 1557 } else if ($feed < -10) {
318260cc 1558
a9cb1f83
AD		 1559 $label_id = -$feed - 11;
1560
1561 $result = db_query($link, "SELECT sql_exp FROM ttrss_labels WHERE
1562 id = '$label_id' AND owner_uid = " . $_SESSION["uid"]);
1563
1564 $match_part = db_fetch_result($result, 0, "sql_exp");
1565 }
1566
1567 if ($match_part) {
1568
1569 $result = db_query($link, "SELECT count(int_id) AS unread
88040f57
AD		 1570 FROM ttrss_user_entries,ttrss_feeds,ttrss_entries WHERE
1571 ttrss_user_entries.feed_id = ttrss_feeds.id AND
1572 ttrss_user_entries.ref_id = ttrss_entries.id AND
cfb02131 1573 ttrss_feeds.hidden = false AND
88040f57 1574 unread = true AND ($match_part) AND ttrss_user_entries.owner_uid = " . $_SESSION["uid"]);
a9cb1f83
AD		 1575
1576 } else {
1577
1578 $result = db_query($link, "SELECT COUNT(post_int_id) AS unread
1579 FROM ttrss_tags,ttrss_user_entries
1580 WHERE tag_name = '$feed' AND post_int_id = int_id AND unread = true AND
1581 ttrss_tags.owner_uid = " . $_SESSION["uid"]);
1582 }
1583
1584 $unread = db_fetch_result($result, 0, "unread");
cfb02131 1585
a9cb1f83
AD		 1586 return $unread;
1587 }
1588
1589 /* FIXME this needs reworking */
1590
f3acc32e
AD		 1591 function getGlobalUnread($link, $user_id = false) {
1592
1593 if (!$user_id) {
1594 $user_id = $_SESSION["uid"];
1595 }
1596
3831db41 1597 $result = db_query($link, "SELECT count(ttrss_entries.id) as c_id FROM ttrss_entries,ttrss_user_entries,ttrss_feeds
a9cb1f83 1598 WHERE unread = true AND
3831db41 1599 ttrss_user_entries.feed_id = ttrss_feeds.id AND
a9cb1f83 1600 ttrss_user_entries.ref_id = ttrss_entries.id AND
3831db41 1601 hidden = false AND
f3acc32e 1602 ttrss_user_entries.owner_uid = '$user_id'");
a9cb1f83
AD		 1603 $c_id = db_fetch_result($result, 0, "c_id");
1604 return $c_id;
1605 }
1606
1607 function getGlobalCounters($link, $global_unread = -1) {
1608 if ($global_unread == -1) {
1609 $global_unread = getGlobalUnread($link);
1610 }
7bf7e4d3
AD		 1611 print "<counter type=\"global\" id='global-unread'
1612 counter='$global_unread'/>";
1613
1614 $result = db_query($link, "SELECT COUNT(id) AS fn FROM
1615 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
1616
1617 $subscribed_feeds = db_fetch_result($result, 0, "fn");
1618
1619 print "<counter type=\"global\" id='subscribed-feeds'
1620 counter='$subscribed_feeds'/>";
1621
a9cb1f83
AD		 1622 }
1623
1624 function getTagCounters($link, $smart_mode = SMART_RPC_COUNTERS) {
1625
1626 if ($smart_mode) {
1627 if (!$_SESSION["tctr_last_value"]) {
1628 $_SESSION["tctr_last_value"] = array();
1629 }
1630 }
1631
1632 $old_counters = $_SESSION["tctr_last_value"];
1633
1634 $tctrs_modified = false;
1635
1636/* $result = db_query($link, "SELECT tag_name,count(ttrss_entries.id) AS count
1637 FROM ttrss_tags,ttrss_entries,ttrss_user_entries WHERE
1638 ttrss_user_entries.ref_id = ttrss_entries.id AND
1639 ttrss_tags.owner_uid = ".$_SESSION["uid"]." AND
1640 post_int_id = ttrss_user_entries.int_id AND unread = true GROUP BY tag_name
1641 UNION
1642 select tag_name,0 as count FROM ttrss_tags
1643 WHERE ttrss_tags.owner_uid = ".$_SESSION["uid"]); */
1644
1645 $result = db_query($link, "SELECT tag_name,SUM((SELECT COUNT(int_id)
1646 FROM ttrss_user_entries WHERE int_id = post_int_id
1647 AND unread = true)) AS count FROM ttrss_tags
1648 WHERE owner_uid = 2 GROUP BY tag_name ORDER BY tag_name");
1649
1650 $tags = array();
1651
1652 while ($line = db_fetch_assoc($result)) {
1653 $tags[$line["tag_name"]] += $line["count"];
1654 }
1655
1656 foreach (array_keys($tags) as $tag) {
1657 $unread = $tags[$tag];
1658
1659 $tag = htmlspecialchars($tag);
1660
1661 if (!$smart_mode || $old_counters[$tag] != $unread) {
1662 $old_counters[$tag] = $unread;
1663 $tctrs_modified = true;
1664 print "<counter type=\"tag\" id=\"$tag\" counter=\"$unread\"/>";
1665 }
1666
1667 }
1668
1669 if ($smart_mode && $tctrs_modified) {
1670 $_SESSION["tctr_last_value"] = $old_counters;
1671 }
1672
1673 }
1674
ef393de7 1675 function getLabelCounters($link, $smart_mode = SMART_RPC_COUNTERS, $ret_mode = false) {
a9cb1f83
AD		 1676
1677 if ($smart_mode) {
1678 if (!$_SESSION["lctr_last_value"]) {
1679 $_SESSION["lctr_last_value"] = array();
1680 }
1681 }
1682
ef393de7
AD		 1683 $ret_arr = array();
1684
a9cb1f83
AD		 1685 $old_counters = $_SESSION["lctr_last_value"];
1686 $lctrs_modified = false;
1687
88040f57 1688 $result = db_query($link, "SELECT count(ttrss_entries.id) as count FROM ttrss_entries,ttrss_user_entries,ttrss_feeds
a9cb1f83 1689 WHERE marked = true AND ttrss_user_entries.ref_id = ttrss_entries.id AND
88040f57
AD		 1690 ttrss_user_entries.feed_id = ttrss_feeds.id AND
1691 unread = true AND ttrss_user_entries.owner_uid = ".$_SESSION["uid"]);
a9cb1f83
AD		 1692
1693 $count = db_fetch_result($result, 0, "count");
1694
ef393de7
AD		 1695 if (!$ret_mode) {
1696 print "<counter type=\"label\" id=\"-1\" counter=\"$count\"/>";
1697 } else {
1698 $ret_arr["-1"]["counter"] = $count;
1699 $ret_arr["-1"]["description"] = "Starred";
1700 }
a9cb1f83
AD		 1701
1702 $result = db_query($link, "SELECT owner_uid,id,sql_exp,description FROM
1703 ttrss_labels WHERE owner_uid = ".$_SESSION["uid"]." ORDER by description");
1704
1705 while ($line = db_fetch_assoc($result)) {
1706
1707 $id = -$line["id"] - 11;
1708
ef393de7
AD		 1709 $label_name = $line["description"];
1710
a9cb1f83
AD		 1711 error_reporting (0);
1712
88040f57 1713 $tmp_result = db_query($link, "SELECT count(ttrss_entries.id) as count FROM ttrss_user_entries,ttrss_entries,ttrss_feeds
a9cb1f83 1714 WHERE (" . $line["sql_exp"] . ") AND unread = true AND
cfb02131 1715 ttrss_feeds.hidden = false AND
88040f57 1716 ttrss_user_entries.feed_id = ttrss_feeds.id AND
a9cb1f83 1717 ttrss_user_entries.ref_id = ttrss_entries.id AND
88040f57 1718 ttrss_user_entries.owner_uid = ".$_SESSION["uid"]);
a9cb1f83
AD		 1719
1720 $count = db_fetch_result($tmp_result, 0, "count");
1721
1722 if (!$smart_mode || $old_counters[$id] != $count) {
1723 $old_counters[$id] = $count;
1724 $lctrs_modified = true;
ef393de7
AD		 1725 if (!$ret_mode) {
1726 print "<counter type=\"label\" id=\"$id\" counter=\"$count\"/>";
1727 } else {
1728 $ret_arr[$id]["counter"] = $count;
1729 $ret_arr[$id]["description"] = $label_name;
1730 }
a9cb1f83
AD		 1731 }
1732
1733 error_reporting (DEFAULT_ERROR_LEVEL);
1734 }
1735
1736 if ($smart_mode && $lctrs_modified) {
1737 $_SESSION["lctr_last_value"] = $old_counters;
1738 }
ef393de7
AD		 1739
1740 return $ret_arr;
a9cb1f83
AD		 1741 }
1742
1743/* function getFeedCounter($link, $id) {
1744
1745 $result = db_query($link, "SELECT
1746 count(id) as count,last_error
1747 FROM ttrss_entries,ttrss_user_entries,ttrss_feeds
1748 WHERE feed_id = '$id' AND unread = true
1749 AND ttrss_user_entries.feed_id = ttrss_feeds.id
1750 AND ttrss_user_entries.ref_id = ttrss_entries.id");
1751
1752 $count = db_fetch_result($result, 0, "count");
1753 $last_error = htmlspecialchars(db_fetch_result($result, 0, "last_error"));
1754
1755 print "<counter type=\"feed\" id=\"$id\" counter=\"$count\" error=\"$last_error\"/>";
1756 } */
1757
1758 function getFeedCounters($link, $smart_mode = SMART_RPC_COUNTERS) {
1759
1760 if ($smart_mode) {
1761 if (!$_SESSION["fctr_last_value"]) {
1762 $_SESSION["fctr_last_value"] = array();
1763 }
1764 }
1765
1766 $old_counters = $_SESSION["fctr_last_value"];
1767
1768 $result = db_query($link, "SELECT id,last_error,parent_feed,
fb1fb4ab 1769 SUBSTRING(last_updated,1,19) AS last_updated,
a9cb1f83
AD		 1770 (SELECT count(id)
1771 FROM ttrss_entries,ttrss_user_entries
1772 WHERE feed_id = ttrss_feeds.id AND
1773 ttrss_user_entries.ref_id = ttrss_entries.id
1774 AND unread = true AND owner_uid = ".$_SESSION["uid"].") as count
1775 FROM ttrss_feeds WHERE owner_uid = ".$_SESSION["uid"] . "
1776 AND parent_feed IS NULL");
1777
1778 $fctrs_modified = false;
1779
fb1fb4ab
AD		 1780 $short_date = get_pref($link, 'SHORT_DATE_FORMAT');
1781
a9cb1f83
AD		 1782 while ($line = db_fetch_assoc($result)) {
1783
1784 $id = $line["id"];
1785 $count = $line["count"];
1786 $last_error = htmlspecialchars($line["last_error"]);
fb1fb4ab
AD		 1787
1788 if (get_pref($link, 'HEADLINES_SMART_DATE')) {
1789 $last_updated = smart_date_time(strtotime($line["last_updated"]));
1790 } else {
1791 $last_updated = date($short_date, strtotime($line["last_updated"]));
1792 }
1793
a9cb1f83
AD		 1794 $has_img = is_file(ICONS_DIR . "/$id.ico");
1795
1796 $tmp_result = db_query($link,
1797 "SELECT id,COUNT(unread) AS unread
1798 FROM ttrss_feeds LEFT JOIN ttrss_user_entries
1799 ON (ttrss_feeds.id = ttrss_user_entries.feed_id)
1800 WHERE parent_feed = '$id' AND unread = true GROUP BY ttrss_feeds.id");
1801
1802 if (db_num_rows($tmp_result) > 0) {
1803 while ($l = db_fetch_assoc($tmp_result)) {
1804 $count += $l["unread"];
1805 }
1806 }
1807
1808 if (!$smart_mode || $old_counters[$id] != $count) {
1809 $old_counters[$id] = $count;
1810 $fctrs_modified = true;
1811
1812 if ($last_error) {
1813 $error_part = "error=\"$last_error\"";
1814 } else {
1815 $error_part = "";
1816 }
1817
1818 if ($has_img) {
1819 $has_img_part = "hi=\"$has_img\"";
1820 } else {
1821 $has_img_part = "";
1822 }
1823
fb1fb4ab 1824 print "<counter type=\"feed\" id=\"$id\" counter=\"$count\" $has_img_part $error_part updated=\"$last_updated\"/>";
a9cb1f83
AD		 1825 }
1826 }
1827
1828 if ($smart_mode && $fctrs_modified) {
1829 $_SESSION["fctr_last_value"] = $old_counters;
1830 }
1831 }
1832
1b758780
AD		 1833 function get_script_dt_add() {
1834 if (strpos(VERSION, "99") === false) {
1835 return VERSION;
1836 } else {
1837 return time();
1838 }
1839 }
1840
6e7f8d26
AD		 1841 function get_pgsql_version($link) {
1842 $result = db_query($link, "SELECT version() AS version");
1843 $version = split(" ", db_fetch_result($result, 0, "version"));
1844 return $version[1];
1845 }
1846
af106b0e
AD		 1847 function print_error_xml($code, $add_msg = "") {
1848 global $ERRORS;
1849
1850 $error_msg = $ERRORS[$code];
1851
1852 if ($add_msg) {
1853 $error_msg = "$error_msg; $add_msg";
1854 }
1855
4c2abbc1 1856 print "<rpc-reply>";
af106b0e 1857 print "<error error-code=\"$code\" error-msg=\"$error_msg\"/>";
4c2abbc1 1858 print "</rpc-reply>";
af106b0e 1859 }
956c7629
AD		 1860
1861 function subscribe_to_feed($link, $feed_link, $cat_id = 0) {
bb0f29a4 1862
39ddbaa1 1863 $feed_link = preg_replace("/^feed:/", "", $feed_link);
bb0f29a4 1864
956c7629
AD		 1865 if ($cat_id == "0" || !$cat_id) {
1866 $cat_qpart = "NULL";
1867 } else {
1868 $cat_qpart = "'$cat_id'";
1869 }
1870
1871 $result = db_query($link,
1872 "SELECT id FROM ttrss_feeds
1873 WHERE feed_url = '$feed_link' AND owner_uid = ".$_SESSION["uid"]);
1874
1875 if (db_num_rows($result) == 0) {
1876
1877 $result = db_query($link,
1878 "INSERT INTO ttrss_feeds (owner_uid,feed_url,title,cat_id)
1879 VALUES ('".$_SESSION["uid"]."', '$feed_link',
1880 '[Unknown]', $cat_qpart)");
1881
1882 $result = db_query($link,
1883 "SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_link'
1884 AND owner_uid = " . $_SESSION["uid"]);
1885
1886 $feed_id = db_fetch_result($result, 0, "id");
1887
1888 if ($feed_id) {
1889 update_rss_feed($link, $feed_link, $feed_id, true);
1890 }
1891
1892 return true;
1893 } else {
1894 return false;
1895 }
1896 }
1897
673d54ca
AD		 1898 function print_feed_select($link, $id, $default_id = "",
1899 $attributes = "", $include_all_feeds = true) {
1900
79f3553b 1901 print "<select id=\"$id\" name=\"$id\" $attributes>";
673d54ca 1902 if ($include_all_feeds) {
79f3553b 1903 print "<option value=\"0\">All feeds</option>";
673d54ca
AD		 1904 }
1905
1906 $result = db_query($link, "SELECT id,title FROM ttrss_feeds
1907 WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
1908
1909 if (db_num_rows($result) > 0 && $include_all_feeds) {
1910 print "<option disabled>--------</option>";
1911 }
1912
1913 while ($line = db_fetch_assoc($result)) {
1914 if ($line["id"] == $default_id) {
1915 $is_selected = "selected";
1916 } else {
1917 $is_selected = "";
1918 }
79f3553b 1919 printf("<option $is_selected value='%d'>%s</option>",
07164479 1920 $line["id"], htmlspecialchars(db_unescape_string($line["title"])));
673d54ca
AD		 1921 }
1922
1923 print "</select>";
1924 }
1925
1926 function print_feed_cat_select($link, $id, $default_id = "",
1927 $attributes = "", $include_all_cats = true) {
1928
79f3553b 1929 print "<select id=\"$id\" name=\"$id\" $attributes>";
673d54ca
AD		 1930
1931 if ($include_all_cats) {
14f69488 1932 print "<option value=\"0\">Uncategorized</option>";
673d54ca
AD		 1933 }
1934
1935 $result = db_query($link, "SELECT id,title FROM ttrss_feed_categories
1936 WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
1937
1938 if (db_num_rows($result) > 0 && $include_all_cats) {
1939 print "<option disabled>--------</option>";
1940 }
1941
1942 while ($line = db_fetch_assoc($result)) {
1943 if ($line["id"] == $default_id) {
1944 $is_selected = "selected";
1945 } else {
1946 $is_selected = "";
1947 }
14f69488 1948 printf("<option $is_selected value='%d'>%s</option>",
07164479 1949 $line["id"], htmlspecialchars(db_unescape_string($line["title"])));
673d54ca
AD		 1950 }
1951
1952 print "</select>";
1953 }
1954
14f69488
AD		 1955 function checkbox_to_sql_bool($val) {
1956 return ($val == "on") ? "true" : "false";
1957 }
86b682ce
AD		 1958
1959 function getFeedCatTitle($link, $id) {
1960 if ($id == -1) {
1961 return "Special";
1962 } else if ($id < -10) {
1963 return "Labels";
1964 } else if ($id > 0) {
1965 $result = db_query($link, "SELECT ttrss_feed_categories.title
1966 FROM ttrss_feeds, ttrss_feed_categories WHERE ttrss_feeds.id = '$id' AND
1967 cat_id = ttrss_feed_categories.id");
1968 if (db_num_rows($result) == 1) {
1969 return db_fetch_result($result, 0, "title");
1970 } else {
eb4311d0 1971 return "Uncategorized";
86b682ce
AD		 1972 }
1973 } else {
1974 return "getFeedCatTitle($id) failed";
1975 }
1976
1977 }
1978
1979 function getFeedTitle($link, $id) {
1980 if ($id == -1) {
1981 return "Starred articles";
1982 } else if ($id < -10) {
1983 $label_id = -10 - $id;
1984 $result = db_query($link, "SELECT description FROM ttrss_labels WHERE id = '$label_id'");
1985 if (db_num_rows($result) == 1) {
1986 return db_fetch_result($result, 0, "description");
1987 } else {
1988 return "Unknown label ($label_id)";
1989 }
1990
1991 } else if ($id > 0) {
1992 $result = db_query($link, "SELECT title FROM ttrss_feeds WHERE id = '$id'");
1993 if (db_num_rows($result) == 1) {
1994 return db_fetch_result($result, 0, "title");
1995 } else {
1996 return "Unknown feed ($id)";
1997 }
1998 } else {
1999 return "getFeedTitle($id) failed";
2000 }
2001
2002 }
3dd46f19
AD		 2003
2004 function get_session_cookie_name() {
2005 return ((!defined('TTRSS_SESSION_NAME')) ? "ttrss_sid" : TTRSS_SESSION_NAME);
2006 }
3ac2b520
AD		 2007
2008 function print_init_params($link) {
2009 print "<init-params>";
2010 if ($_SESSION["stored-params"]) {
2011 foreach (array_keys($_SESSION["stored-params"]) as $key) {
5f57b06d
AD		 2012 if ($key) {
2013 $value = htmlspecialchars($_SESSION["stored-params"][$key]);
2014 print "<param key=\"$key\" value=\"$value\"/>";
2015 }
3ac2b520
AD		 2016 }
2017 }
2018
2019 print "<param key=\"daemon_enabled\" value=\"" . ENABLE_UPDATE_DAEMON . "\"/>";
2020 print "<param key=\"feeds_frame_refresh\" value=\"" . FEEDS_FRAME_REFRESH . "\"/>";
0d51e25d 2021 print "<param key=\"daemon_refresh_only\" value=\"" . DAEMON_REFRESH_ONLY . "\"/>";
3ac2b520
AD		 2022
2023 print "<param key=\"on_catchup_show_next_feed\" value=\"" .
2024 get_pref($link, "ON_CATCHUP_SHOW_NEXT_FEED") . "\"/>";
2025
e8bd0da9
AD		 2026 print "<param key=\"hide_read_feeds\" value=\"" .
2027 sprintf("%d", get_pref($link, "HIDE_READ_FEEDS")) . "\"/>";
2028
c9268ed5
AD		 2029 print "<param key=\"feeds_sort_by_unread\" value=\"" .
2030 sprintf("%d", get_pref($link, "FEEDS_SORT_BY_UNREAD")) . "\"/>";
2031
f6d6e22f
AD		 2032 print "<param key=\"confirm_feed_catchup\" value=\"" .
2033 sprintf("%d", get_pref($link, "CONFIRM_FEED_CATCHUP")) . "\"/>";
2034
3ac2b520
AD		 2035 print "</init-params>";
2036 }
f54f515f
AD		 2037
2038 function print_runtime_info($link) {
2039 print "<runtime-info>";
71ad883b
AD		 2040 if (ENABLE_UPDATE_DAEMON) {
2041 print "<param key=\"daemon_is_running\" value=\"".
2042 sprintf("%d", file_is_locked("update_daemon.lock")) . "\"/>";
2043 }
f54f515f
AD		 2044 print "</runtime-info>";
2045 }
ef393de7 2046
88040f57 2047 function getSearchSql($search, $match_on) {
ef393de7 2048
88040f57 2049 $search_query_part = "";
e20c9d88 2050
88040f57
AD		 2051 $keywords = split(" ", $search);
2052 $query_keywords = array();
e20c9d88 2053
88040f57 2054 if ($match_on == "both") {
e20c9d88 2055
88040f57
AD		 2056 foreach ($keywords as $k) {
2057 array_push($query_keywords, "(UPPER(ttrss_entries.title) LIKE UPPER('%$k%')
2058 OR UPPER(ttrss_entries.content) LIKE UPPER('%$k%'))");
2059 }
e20c9d88 2060
88040f57 2061 $search_query_part = implode("AND", $query_keywords) . " AND ";
e20c9d88 2062
88040f57 2063 } else if ($match_on == "title") {
e20c9d88 2064
88040f57
AD		 2065 foreach ($keywords as $k) {
2066 array_push($query_keywords, "(UPPER(ttrss_entries.title) LIKE UPPER('%$k%'))");
2067 }
e20c9d88 2068
88040f57 2069 $search_query_part = implode("AND", $query_keywords) . " AND ";
e20c9d88 2070
88040f57
AD		 2071 } else if ($match_on == "content") {
2072
2073 foreach ($keywords as $k) {
2074 array_push($query_keywords, "(UPPER(ttrss_entries.content) LIKE UPPER('%$k%'))");
2075 }
2076 }
2077
2078 $search_query_part = implode("AND", $query_keywords);
2079
2080 return $search_query_part;
2081 }
2082
2083 function queryFeedHeadlines($link, $feed, $limit, $view_mode, $cat_view, $search, $search_mode, $match_on, $override_order = false) {
88040f57
AD		 2084 if ($search) {
2085
2086 $search_query_part = getSearchSql($search, $match_on);
2087 $search_query_part .= " AND ";
e20c9d88 2088
ef393de7
AD		 2089 } else {
2090 $search_query_part = "";
2091 }
2092
2093 $view_query_part = "";
2094
2095 if ($view_mode == "adaptive") {
2096 if ($search) {
2097 $view_query_part = " ";
2098 } else if ($feed != -1) {
f295c368 2099 $unread = getFeedUnread($link, $feed, $cat_view);
ef393de7
AD		 2100 if ($unread > 0) {
2101 $view_query_part = " unread = true AND ";
2102 }
2103 }
2104 }
2105
2106 if ($view_mode == "marked") {
2107 $view_query_part = " marked = true AND ";
2108 }
2109
2110 if ($view_mode == "unread") {
2111 $view_query_part = " unread = true AND ";
2112 }
2113
2114 if ($limit > 0) {
2115 $limit_query_part = "LIMIT " . $limit;
2116 }
2117
2118 $vfeed_query_part = "";
2119
2120 // override query strategy and enable feed display when searching globally
2121 if ($search && $search_mode == "all_feeds") {
2122 $query_strategy_part = "ttrss_entries.id > 0";
2123 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2124 } else if (preg_match("/^-?[0-9][0-9]*$/", $feed) == false) {
2125 $query_strategy_part = "ttrss_entries.id > 0";
2126 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
2127 id = feed_id) as feed_title,";
2128 } else if ($feed >= 0 && $search && $search_mode == "this_cat") {
2129
2130 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
0a6c4846
AD		 2131
2132 $tmp_result = false;
2133
2134 if ($cat_view) {
2135 $tmp_result = db_query($link, "SELECT id
2136 FROM ttrss_feeds WHERE cat_id = '$feed'");
2137 } else {
2138 $tmp_result = db_query($link, "SELECT id
2139 FROM ttrss_feeds WHERE cat_id = (SELECT cat_id FROM ttrss_feeds
2140 WHERE id = '$feed') AND id != '$feed'");
2141 }
ef393de7
AD		 2142
2143 $cat_siblings = array();
2144
2145 if (db_num_rows($tmp_result) > 0) {
2146 while ($p = db_fetch_assoc($tmp_result)) {
2147 array_push($cat_siblings, "feed_id = " . $p["id"]);
2148 }
2149
2150 $query_strategy_part = sprintf("(feed_id = %d OR %s)",
2151 $feed, implode(" OR ", $cat_siblings));
2152
2153 } else {
2154 $query_strategy_part = "ttrss_entries.id > 0";
2155 }
2156
2157 } else if ($feed >= 0) {
2158
2159 if ($cat_view) {
5c365f60 2160
ef393de7
AD		 2161 if ($feed > 0) {
2162 $query_strategy_part = "cat_id = '$feed'";
2163 } else {
2164 $query_strategy_part = "cat_id IS NULL";
2165 }
2166
2167 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
5c365f60 2168
ef393de7
AD		 2169 } else {
2170 $tmp_result = db_query($link, "SELECT id
2171 FROM ttrss_feeds WHERE parent_feed = '$feed'
2172 ORDER BY cat_id,title");
2173
2174 $parent_ids = array();
2175
2176 if (db_num_rows($tmp_result) > 0) {
2177 while ($p = db_fetch_assoc($tmp_result)) {
2178 array_push($parent_ids, "feed_id = " . $p["id"]);
2179 }
2180
2181 $query_strategy_part = sprintf("(feed_id = %d OR %s)",
2182 $feed, implode(" OR ", $parent_ids));
2183
2184 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2185 } else {
2186 $query_strategy_part = "feed_id = '$feed'";
2187 }
2188 }
2189 } else if ($feed == -1) { // starred virtual feed
2190 $query_strategy_part = "marked = true";
2191 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2192 } else if ($feed <= -10) { // labels
2193 $label_id = -$feed - 11;
2194
2195 $tmp_result = db_query($link, "SELECT sql_exp FROM ttrss_labels
2196 WHERE id = '$label_id'");
2197
2198 $query_strategy_part = db_fetch_result($tmp_result, 0, "sql_exp");
2199
2200 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2201 } else {
2202 $query_strategy_part = "id > 0"; // dumb
2203 }
d6e5706d
AD		 2204
2205 if (get_pref($link, 'REVERSE_HEADLINES')) {
2206 $order_by = "updated";
2207 } else {
2208 $order_by = "updated DESC";
2209 }
e939722a
AD		 2210
2211 if ($override_order) {
2212 $order_by = $override_order;
2213 }
ef393de7
AD		 2214
2215 $feed_title = "";
2216
2217 if ($search && $search_mode == "all_feeds") {
2218 $feed_title = "Global search results ($search)";
2219 } else if ($search && preg_match('/^-?[0-9][0-9]*$/', $feed) == false) {
e1eb2147 2220 $feed_title = "Tag search results ($search, $feed)";
ef393de7
AD		 2221 } else if (preg_match('/^-?[0-9][0-9]*$/', $feed) == false) {
2222 $feed_title = $feed;
2223 } else if (preg_match('/^-?[0-9][0-9]*$/', $feed) != false && $feed >= 0) {
2224
2225 if ($cat_view) {
5c365f60 2226
ef393de7
AD		 2227 if ($feed != 0) {
2228 $result = db_query($link, "SELECT title FROM ttrss_feed_categories
2229 WHERE id = '$feed' AND owner_uid = " . $_SESSION["uid"]);
2230 $feed_title = db_fetch_result($result, 0, "title");
2231 } else {
2232 $feed_title = "Uncategorized";
2233 }
e1eb2147
AD		 2234
2235 if ($search) {
2236 $feed_title = "Category search results ($search, $feed_title)";
2237 }
2238
ef393de7
AD		 2239 } else {
2240
2241 $result = db_query($link, "SELECT title,site_url,last_error FROM ttrss_feeds
2242 WHERE id = '$feed' AND owner_uid = " . $_SESSION["uid"]);
2243
2244 $feed_title = db_fetch_result($result, 0, "title");
2245 $feed_site_url = db_fetch_result($result, 0, "site_url");
2246 $last_error = db_fetch_result($result, 0, "last_error");
e1eb2147
AD		 2247
2248 if ($search) {
2249 $feed_title = "Feed search results ($search, $feed_title)";
2250 }
ef393de7
AD		 2251 }
2252
2253 } else if ($feed == -1) {
2254 $feed_title = "Starred articles";
2255 } else if ($feed < -10) {
2256 $label_id = -$feed - 11;
2257 $result = db_query($link, "SELECT description FROM ttrss_labels
2258 WHERE id = '$label_id'");
2259 $feed_title = db_fetch_result($result, 0, "description");
88040f57
AD		 2260
2261 if ($search) {
2262 $feed_title = "Label search results ($search, $feed_title)";
2263 }
ef393de7
AD		 2264 } else {
2265 $feed_title = "?";
2266 }
2267
2268 $feed_title = db_unescape_string($feed_title);
2269
2270 if ($feed < -10) error_reporting (0);
2271
2272 if (preg_match("/^-?[0-9][0-9]*$/", $feed) != false) {
2273
2274 if ($feed >= 0) {
2275 $feed_kind = "Feeds";
2276 } else {
2277 $feed_kind = "Labels";
2278 }
2279
2280 $content_query_part = "content as content_preview,";
2281
2282 $query = "SELECT
1f64b1be 2283 guid,
ef393de7
AD		 2284 ttrss_entries.id,ttrss_entries.title,
2285 SUBSTRING(updated,1,16) as updated,
2286 unread,feed_id,marked,link,last_read,
2287 SUBSTRING(last_read,1,19) as last_read_noms,
2288 $vfeed_query_part
2289 $content_query_part
2290 SUBSTRING(updated,1,19) as updated_noms
2291 FROM
2292 ttrss_entries,ttrss_user_entries,ttrss_feeds
2293 WHERE
cfb02131 2294 ttrss_feeds.hidden = false AND
ef393de7
AD		 2295 ttrss_user_entries.feed_id = ttrss_feeds.id AND
2296 ttrss_user_entries.ref_id = ttrss_entries.id AND
2297 ttrss_user_entries.owner_uid = '".$_SESSION["uid"]."' AND
2298 $search_query_part
2299 $view_query_part
2300 $query_strategy_part ORDER BY $order_by
2301 $limit_query_part";
2302
2303 $result = db_query($link, $query);
2304
2305 if ($_GET["debug"]) print $query;
2306
2307 } else {
2308 // browsing by tag
2309
2310 $feed_kind = "Tags";
2311
2312 $result = db_query($link, "SELECT
1f64b1be 2313 guid,
ef393de7
AD		 2314 ttrss_entries.id as id,title,
2315 SUBSTRING(updated,1,16) as updated,
2316 unread,feed_id,
2317 marked,link,last_read,
2318 SUBSTRING(last_read,1,19) as last_read_noms,
2319 $vfeed_query_part
2320 $content_query_part
2321 SUBSTRING(updated,1,19) as updated_noms
2322 FROM
2323 ttrss_entries,ttrss_user_entries,ttrss_tags
2324 WHERE
2325 ref_id = ttrss_entries.id AND
2326 ttrss_user_entries.owner_uid = '".$_SESSION["uid"]."' AND
2327 post_int_id = int_id AND tag_name = '$feed' AND
2328 $view_query_part
2329 $search_query_part
2330 $query_strategy_part ORDER BY $order_by
2331 $limit_query_part");
2332 }
2333
c7188969 2334 return array($result, $feed_title, $feed_site_url, $last_error);
ef393de7
AD		 2335
2336 }
2337
e1eb2147
AD		 2338 function generate_syndicated_feed($link, $feed, $is_cat,
2339 $search, $search_mode, $match_on) {
18664970
AD		 2340
2341 $qfh_ret = queryFeedHeadlines($link, $feed,
e939722a 2342 30, false, $is_cat, $search, $search_mode, $match_on, "updated DESC");
18664970
AD		 2343
2344 $result = $qfh_ret[0];
59e2aab4 2345 $feed_title = htmlspecialchars($qfh_ret[1]);
18664970
AD		 2346 $feed_site_url = $qfh_ret[2];
2347 $last_error = $qfh_ret[3];
2348
2349 print "<rss version=\"2.0\">
2350 <channel>
2351 <title>$feed_title</title>
2352 <link>$feed_site_url</link>
2353 <generator>Tiny Tiny RSS v".VERSION."</generator>";
2354
2355 while ($line = db_fetch_assoc($result)) {
2356 print "<item>";
1f64b1be 2357 print "<id>" . htmlspecialchars($line["guid"]) . "</id>";
18664970
AD		 2358 print "<link>" . htmlspecialchars($line["link"]) . "</link>";
2359
2360 $rfc822_date = date('r', strtotime($line["updated"]));
2361
2362 print "<pubDate>$rfc822_date</pubDate>";
2363
2364 print "<title>" .
2365 htmlspecialchars($line["title"]) . "</title>";
2366
2367 print "<description>" .
2368 htmlspecialchars($line["content_preview"]) . "</description>";
2369
2370 print "</item>";
2371 }
2372
2373 print "</channel></rss>";
2374
2375 }
2376
0a6c4846
AD		 2377 function getCategoryTitle($link, $cat_id) {
2378
2379 $result = db_query($link, "SELECT title FROM ttrss_feed_categories WHERE
2380 id = '$cat_id'");
2381
2382 if (db_num_rows($result) == 1) {
2383 return db_fetch_result($result, 0, "title");
2384 } else {
2385 return "Uncategorized";
2386 }
2387 }
2388
183ad07b 2389 function sanitize_rss($str) {
60452879 2390 $res = $str;
183ad07b
AD		 2391
2392 $res = preg_replace('/<script.*?>/i',
60452879 2393 "<p class=\"scriptWarn\">Disabled script: ", $res);
183ad07b 2394
60452879
AD		 2395 $res = preg_replace('/<\/script.*?>/i', "</p>", $res);
2396
8511f62f 2397/* $res = preg_replace('/<embed.*?>/i', "", $res);
183ad07b 2398
a262b161
AD		 2399 $res = preg_replace('/<object.*?>.*?<\/object>/i',
2400 "<p class=\"objectWarn\">(Disabled html object
8511f62f 2401 - flash or other embedded content)</p>", $res); */
a262b161 2402
183ad07b
AD		 2403 return $res;
2404 }
b72c3ef8 2405
9cd7c995
AD		 2406 function send_headlines_digests($link, $limit = 100) {
2407
1ddba275
AD		 2408 if (!DIGEST_ENABLE) return false;
2409
9cd7c995
AD		 2410 $user_limit = DIGEST_EMAIL_LIMIT;
2411 $days = DIGEST_DAYS_BACK;
2412
2413 print "Sending digests, batch of max $user_limit users, days = $days, headline limit = $limit\n\n";
2414
2415 if (DB_TYPE == "pgsql") {
2416 $interval_query = "last_digest_sent < NOW() - INTERVAL '$days days'";
2417 } else if (DB_TYPE == "mysql") {
2418 $interval_query = "last_digest_sent < DATE_SUB(NOW(), INTERVAL $days DAY)";
2419 }
2420
2421 $result = db_query($link, "SELECT id,email FROM ttrss_users
2422 WHERE email != '' AND (last_digest_sent IS NULL OR $interval_query)");
2423
2424 while ($line = db_fetch_assoc($result)) {
2425 if (get_pref($link, 'DIGEST_ENABLE', $line['id'], false)) {
2426 print "Sending digest for UID:" . $line['id'] . " - " . $line["email"] . " ... ";
2427
2428 $tuple = prepare_headlines_digest($link, $line["id"], $days, $limit);
2429 $digest = $tuple[0];
2430 $headlines_count = $tuple[1];
2431
2432 if ($headlines_count > 0) {
2433 $rc = mail($line["login"] . " <" . $line["email"] . ">",
2434 "[tt-rss] New headlines for last 24 hours", $digest,
3ab3c1f0
AD		 2435 "From: " . MAIL_FROM . "\n".
2436 "Content-Type: text/plain; charset=\"utf-8\"\n".
2437 "Content-Transfer-Encoding: 8bit\n");
9cd7c995
AD		 2438 print "RC=$rc\n";
2439 db_query($link, "UPDATE ttrss_users SET last_digest_sent = NOW()
2440 WHERE id = " . $line["id"]);
2441 } else {
2442 print "No headlines\n";
2443 }
2444 }
2445 }
2446
2447// $digest = prepare_headlines_digest($link, $user_id, $days, $limit);
2448
2449 }
2450
7e3634d9
AD		 2451 function prepare_headlines_digest($link, $user_id, $days = 1, $limit = 100) {
2452 $tmp = "New headlines for last 24 hours, as of " . date("Y/m/d H:m") . "\n";
2453 $tmp .= "=======================================================\n\n";
2454
2455 if (DB_TYPE == "pgsql") {
9cd7c995 2456 $interval_query = "ttrss_entries.date_entered > NOW() - INTERVAL '$days days'";
7e3634d9
AD		 2457 } else if (DB_TYPE == "mysql") {
2458 $interval_query = "ttrss_entries.date_entered > DATE_SUB(NOW(), INTERVAL $days DAY)";
2459 }
2460
2461 $result = db_query($link, "SELECT ttrss_entries.title,
2462 ttrss_feeds.title AS feed_title,
2463 date_entered,
2464 link,
2465 SUBSTRING(last_updated,1,19) AS last_updated
2466 FROM
2467 ttrss_user_entries,ttrss_entries,ttrss_feeds
2468 WHERE
2469 ref_id = ttrss_entries.id AND feed_id = ttrss_feeds.id
3dd9183c 2470 AND include_in_digest = true
7e3634d9 2471 AND $interval_query
448b0abd 2472 AND ttrss_user_entries.owner_uid = $user_id
7e3634d9
AD		 2473 AND unread = true ORDER BY ttrss_feeds.title, date_entered DESC
2474 LIMIT $limit");
2475
2476 $cur_feed_title = "";
2477
9cd7c995
AD		 2478 $headlines_count = db_num_rows($result);
2479
7e3634d9
AD		 2480 while ($line = db_fetch_assoc($result)) {
2481 $updated = smart_date_time(strtotime($line["last_updated"]));
2482 $feed_title = $line["feed_title"];
2483
2484 if ($cur_feed_title != $feed_title) {
2485 $cur_feed_title = $feed_title;
2486
2487 $tmp .= "$feed_title\n\n";
2488 }
2489
2490 $tmp .= " * " . trim($line["title"]) . " - $updated\n";
2491 $tmp .= " " . trim($line["link"]) . "\n";
2492 $tmp .= "\n";
2493 }
2494
2495 $tmp .= "--- \n";
dfe6f833
AD		 2496 $tmp .= "You have been sent this email because you have enabled daily digests in Tiny Tiny RSS at " .
2497 DIGEST_HOSTNAME . "\n".
2498 "To unsubscribe, visit your configuration options or contact instance owner.\n";
7e3634d9
AD		 2499
2500
9cd7c995 2501 return array($tmp, $headlines_count);
7e3634d9
AD		 2502 }
2503
b72c3ef8
AD		 2504 function check_for_update($link) {
2505 $releases_feed = "http://tt-rss.spb.ru/releases.rss";
2506
2507 if (!CHECK_FOR_NEW_VERSION || $_SESSION["access_level"] < 10) {
2508 return;
2509 }
2510
2511 error_reporting(0);
2512 $rss = fetch_rss($releases_feed);
2513 error_reporting (DEFAULT_ERROR_LEVEL);
2514
2515 if ($rss) {
2516
2517 $items = $rss->items;
2518
2519 if (!$items || !is_array($items)) $items = $rss->entries;
2520 if (!$items || !is_array($items)) $items = $rss;
2521
da412ad3 2522 if (!is_array($items) || count($items) == 0) {
b72c3ef8 2523 return;
da412ad3 2524 }
b72c3ef8 2525
a41d2c65 2526 $latest_item = $items[0];
b72c3ef8 2527
a41d2c65 2528 $latest_version = trim(preg_replace("/(Milestone)|(completed)/", "", $latest_item["title"]));
b72c3ef8 2529
48e1a342
AD		 2530 $release_url = sanitize_rss($latest_item["link"]);
2531 $content = sanitize_rss($latest_item["description"]);
2532
a41d2c65 2533 if (version_compare(VERSION, $latest_version) == -1) {
8a797376 2534 return "<div class=\"notice\"><a href=\"javascript:showBlockElement('milestoneDetails')\">
a41d2c65 2535 New version of Tiny-Tiny RSS ($latest_version) is available (click for details)</a>
8a797376 2536 <div id=\"milestoneDetails\">$content</div></div>";
da412ad3 2537 }
b72c3ef8
AD		 2538 }
2539 }
472782e8 2540
18eddb2c
AD		 2541 function markArticlesById($link, $ids, $cmode) {
2542
2543 $tmp_ids = array();
2544
2545 foreach ($ids as $id) {
2546 array_push($tmp_ids, "ref_id = '$id'");
2547 }
2548
2549 $ids_qpart = join(" OR ", $tmp_ids);
2550
2551 if ($cmode == 0) {
2552 db_query($link, "UPDATE ttrss_user_entries SET
2553 marked = false,last_read = NOW()
2554 WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
2555 } else if ($cmode == 1) {
2556 db_query($link, "UPDATE ttrss_user_entries SET
2557 marked = true
2558 WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
2559 } else {
2560 db_query($link, "UPDATE ttrss_user_entries SET
2561 marked = NOT marked,last_read = NOW()
2562 WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
2563 }
2564 }
2565
472782e8
AD		 2566 function catchupArticlesById($link, $ids, $cmode) {
2567
2568 $tmp_ids = array();
2569
2570 foreach ($ids as $id) {
2571 array_push($tmp_ids, "ref_id = '$id'");
2572 }
2573
2574 $ids_qpart = join(" OR ", $tmp_ids);
2575
2576 if ($cmode == 0) {
2577 db_query($link, "UPDATE ttrss_user_entries SET
2578 unread = false,last_read = NOW()
2579 WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
2580 } else if ($cmode == 1) {
2581 db_query($link, "UPDATE ttrss_user_entries SET
2582 unread = true
2583 WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
2584 } else {
2585 db_query($link, "UPDATE ttrss_user_entries SET
2586 unread = NOT unread,last_read = NOW()
2587 WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
2588 }
2589 }
2590
a262b161
AD		 2591 function escape_for_form($s) {
2592 return htmlspecialchars(db_unescape_string($s));
2593 }
2594
1f64b1be
AD		 2595 function make_guid_from_title($title) {
2596 return preg_replace("/[ \"\',.:;]/", "-",
2597 mb_strtolower(strip_tags($title)));
2598 }
2599
40d13c28 2600?>
web-based news feed (RSS/Atom) reader and aggregator; see https://tt-rss.org/