]>
Commit | Line | Data |
---|---|---|
ef8be8ea | 1 | <?php |
d20f3544 | 2 | |
ef8be8ea AD |
3 | function module_pref_feeds($link) { |
4 | ||
d20f3544 AD |
5 | global $update_intervals; |
6 | global $purge_intervals; | |
7 | ||
ef8be8ea AD |
8 | $subop = $_REQUEST["subop"]; |
9 | $quiet = $_REQUEST["quiet"]; | |
10 | ||
11 | if ($subop == "massSubscribe") { | |
12 | $ids = split(",", db_escape_string($_GET["ids"])); | |
13 | ||
14 | $subscribed = array(); | |
15 | ||
16 | foreach ($ids as $id) { | |
17 | $result = db_query($link, "SELECT feed_url,title FROM ttrss_feeds | |
18 | WHERE id = '$id'"); | |
19 | ||
20 | $feed_url = db_escape_string(db_fetch_result($result, 0, "feed_url")); | |
21 | $title = db_escape_string(db_fetch_result($result, 0, "title")); | |
22 | ||
23 | $title_orig = db_fetch_result($result, 0, "title"); | |
24 | ||
25 | $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE | |
26 | feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]); | |
27 | ||
28 | if (db_num_rows($result) == 0) { | |
29 | $result = db_query($link, | |
30 | "INSERT INTO ttrss_feeds (owner_uid,feed_url,title,cat_id) | |
31 | VALUES ('".$_SESSION["uid"]."', '$feed_url', '$title', NULL)"); | |
32 | ||
33 | array_push($subscribed, $title_orig); | |
34 | } | |
35 | } | |
36 | ||
37 | if (count($subscribed) > 0) { | |
38 | print "<div class=\"notice\">"; | |
39 | print "<b>Subscribed to feeds:</b>"; | |
40 | print "<ul class=\"nomarks\">"; | |
41 | foreach ($subscribed as $title) { | |
42 | print "<li>$title</li>"; | |
43 | } | |
44 | print "</ul>"; | |
45 | print "</div>"; | |
46 | } | |
47 | } | |
48 | ||
49 | if ($subop == "browse") { | |
50 | ||
51 | if (!ENABLE_FEED_BROWSER) { | |
52 | print "Feed browser is administratively disabled."; | |
53 | return; | |
54 | } | |
55 | ||
56 | print "<div id=\"infoBoxTitle\">Other feeds: Top 25</div>"; | |
57 | ||
58 | print "<div class=\"infoBoxContents\">"; | |
59 | ||
60 | print "<p>Showing top 25 registered feeds, sorted by popularity:</p>"; | |
61 | ||
62 | # $result = db_query($link, "SELECT feed_url,count(id) AS subscribers | |
63 | # FROM ttrss_feeds | |
64 | # WHERE auth_login = '' AND auth_pass = '' AND private = false | |
65 | # GROUP BY feed_url ORDER BY subscribers DESC LIMIT 25"); | |
66 | ||
67 | $owner_uid = $_SESSION["uid"]; | |
68 | ||
69 | $result = db_query($link, "SELECT feed_url,COUNT(id) AS subscribers | |
70 | FROM ttrss_feeds WHERE (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf | |
71 | WHERE tf.feed_url = ttrss_feeds.feed_url | |
72 | AND owner_uid = '$owner_uid') GROUP BY feed_url | |
73 | ORDER BY subscribers DESC LIMIT 25"); | |
74 | ||
75 | print "<ul class='browseFeedList' id='browseFeedList'>"; | |
76 | ||
77 | $feedctr = 0; | |
78 | ||
79 | while ($line = db_fetch_assoc($result)) { | |
80 | $feed_url = $line["feed_url"]; | |
81 | $subscribers = $line["subscribers"]; | |
82 | ||
83 | $det_result = db_query($link, "SELECT site_url,title,id | |
84 | FROM ttrss_feeds WHERE feed_url = '$feed_url' LIMIT 1"); | |
85 | ||
86 | $details = db_fetch_assoc($det_result); | |
87 | ||
88 | $icon_file = ICONS_DIR . "/" . $details["id"] . ".ico"; | |
89 | ||
90 | if (file_exists($icon_file) && filesize($icon_file) > 0) { | |
91 | $feed_icon = "<img class=\"tinyFeedIcon\" src=\"" . ICONS_URL . | |
92 | "/".$details["id"].".ico\">"; | |
93 | } else { | |
94 | $feed_icon = "<img class=\"tinyFeedIcon\" src=\"images/blank_icon.gif\">"; | |
95 | } | |
96 | ||
97 | $check_box = "<input onclick='toggleSelectListRow(this)' class='feedBrowseCB' | |
98 | type=\"checkbox\" id=\"FBCHK-" . $details["id"] . "\">"; | |
99 | ||
100 | $class = ($feedctr % 2) ? "even" : "odd"; | |
101 | ||
102 | print "<li class='$class' id=\"FBROW-".$details["id"]."\">$check_box". | |
103 | "$feed_icon " . db_unescape_string($details["title"]) . | |
104 | " <span class='subscribers'>($subscribers)</span></li>"; | |
105 | ||
106 | ++$feedctr; | |
107 | } | |
108 | ||
109 | if ($feedctr == 0) { | |
110 | print "<li>No feeds found to subscribe.</li>"; | |
111 | } | |
112 | ||
113 | print "</ul>"; | |
114 | ||
115 | print "<div align='center'> | |
116 | <input type=\"submit\" class=\"button\" | |
117 | onclick=\"feedBrowserSubscribe()\" value=\"Subscribe\"> | |
118 | <input type='submit' class='button' | |
119 | onclick=\"closeInfoBox()\" value=\"Cancel\"></div>"; | |
120 | ||
121 | print "</div>"; | |
122 | return; | |
123 | } | |
124 | ||
125 | if ($subop == "editfeed") { | |
126 | $feed_id = db_escape_string($_REQUEST["id"]); | |
127 | ||
128 | $result = db_query($link, | |
129 | "SELECT * FROM ttrss_feeds WHERE id = '$feed_id' AND | |
130 | owner_uid = " . $_SESSION["uid"]); | |
131 | ||
132 | $title = htmlspecialchars(db_unescape_string(db_fetch_result($result, | |
133 | 0, "title"))); | |
134 | ||
135 | $icon_file = ICONS_DIR . "/$feed_id.ico"; | |
136 | ||
137 | if (file_exists($icon_file) && filesize($icon_file) > 0) { | |
138 | $feed_icon = "<img width=\"16\" height=\"16\" | |
139 | src=\"" . ICONS_URL . "/$feed_id.ico\">"; | |
140 | } else { | |
141 | $feed_icon = ""; | |
142 | } | |
143 | ||
144 | print "<div id=\"infoBoxTitle\">Feed editor</div>"; | |
145 | ||
146 | print "<div class=\"infoBoxContents\">"; | |
147 | ||
148 | print "<form id=\"edit_feed_form\">"; | |
149 | ||
150 | print "<input type=\"hidden\" name=\"id\" value=\"$feed_id\">"; | |
151 | print "<input type=\"hidden\" name=\"op\" value=\"pref-feeds\">"; | |
152 | print "<input type=\"hidden\" name=\"subop\" value=\"editSave\">"; | |
153 | ||
154 | print "<table width='100%'>"; | |
155 | ||
156 | print "<tr><td>Title:</td>"; | |
157 | print "<td><input class=\"iedit\" onkeypress=\"return filterCR(event, feedEditSave)\" | |
158 | name=\"title\" value=\"$title\"></td></tr>"; | |
159 | ||
160 | $feed_url = db_fetch_result($result, 0, "feed_url"); | |
161 | $feed_url = htmlspecialchars(db_unescape_string(db_fetch_result($result, | |
162 | 0, "feed_url"))); | |
163 | ||
164 | print "<tr><td>Feed URL:</td>"; | |
165 | print "<td><input class=\"iedit\" onkeypress=\"return filterCR(event, feedEditSave)\" | |
166 | name=\"feed_url\" value=\"$feed_url\"></td></tr>"; | |
167 | ||
168 | if (get_pref($link, 'ENABLE_FEED_CATS')) { | |
169 | ||
170 | $cat_id = db_fetch_result($result, 0, "cat_id"); | |
171 | ||
172 | print "<tr><td>Category:</td>"; | |
173 | print "<td>"; | |
174 | ||
175 | $parent_feed = db_fetch_result($result, 0, "parent_feed"); | |
176 | ||
177 | if (sprintf("%d", $parent_feed) > 0) { | |
178 | $disabled = "disabled"; | |
179 | } else { | |
180 | $disabled = ""; | |
181 | } | |
182 | ||
183 | print_feed_cat_select($link, "cat_id", $cat_id, "class=\"iedit\" $disabled"); | |
184 | ||
185 | print "</td>"; | |
186 | print "</td></tr>"; | |
187 | ||
188 | } | |
189 | ||
190 | $update_interval = db_fetch_result($result, 0, "update_interval"); | |
191 | ||
192 | print "<tr><td>Update Interval:</td>"; | |
193 | ||
194 | print "<td>"; | |
195 | ||
196 | print_select_hash("update_interval", $update_interval, $update_intervals, | |
197 | "class=\"iedit\""); | |
198 | ||
199 | print "</td>"; | |
200 | ||
201 | print "<tr><td>Link to:</td><td>"; | |
202 | ||
203 | $tmp_result = db_query($link, "SELECT COUNT(id) AS count | |
204 | FROM ttrss_feeds WHERE parent_feed = '$feed_id'"); | |
205 | ||
206 | $linked_count = db_fetch_result($tmp_result, 0, "count"); | |
207 | ||
208 | $parent_feed = db_fetch_result($result, 0, "parent_feed"); | |
209 | ||
210 | if ($linked_count > 0) { | |
211 | $disabled = "disabled"; | |
212 | } else { | |
213 | $disabled = ""; | |
214 | } | |
215 | ||
216 | print "<select class=\"iedit\" $disabled name=\"parent_feed\">"; | |
217 | ||
218 | print "<option value=\"0\">Not linked</option>"; | |
219 | ||
220 | if (get_pref($link, 'ENABLE_FEED_CATS')) { | |
221 | if ($cat_id) { | |
222 | $cat_qpart = "AND cat_id = '$cat_id'"; | |
223 | } else { | |
224 | $cat_qpart = "AND cat_id IS NULL"; | |
225 | } | |
226 | } | |
227 | ||
228 | $tmp_result = db_query($link, "SELECT id,title FROM ttrss_feeds | |
229 | WHERE id != '$feed_id' AND owner_uid = ".$_SESSION["uid"]." AND | |
230 | (SELECT COUNT(id) FROM ttrss_feeds AS T2 WHERE T2.id = ttrss_feeds.parent_feed) = 0 | |
231 | $cat_qpart ORDER BY title"); | |
232 | ||
233 | if (db_num_rows($tmp_result) > 0) { | |
234 | print "<option disabled>--------</option>"; | |
235 | } | |
236 | ||
237 | while ($tmp_line = db_fetch_assoc($tmp_result)) { | |
238 | if ($tmp_line["id"] == $parent_feed) { | |
239 | $is_selected = "selected"; | |
240 | } else { | |
241 | $is_selected = ""; | |
242 | } | |
243 | printf("<option $is_selected value='%d'>%s</option>", | |
244 | $tmp_line["id"], $tmp_line["title"]); | |
245 | } | |
246 | ||
247 | print "</select>"; | |
248 | print "</td></tr>"; | |
249 | ||
250 | $purge_interval = db_fetch_result($result, 0, "purge_interval"); | |
251 | ||
252 | print "<tr><td>Article purging:</td>"; | |
253 | ||
254 | print "<td>"; | |
255 | ||
256 | print_select_hash("purge_interval", $purge_interval, $purge_intervals, | |
257 | "class=\"iedit\""); | |
258 | ||
259 | print "</td>"; | |
260 | ||
261 | $auth_login = escape_for_form(db_fetch_result($result, 0, "auth_login")); | |
262 | ||
263 | print "<tr><td>Login:</td>"; | |
264 | print "<td><input class=\"iedit\" onkeypress=\"return filterCR(event, feedEditSave)\" | |
265 | name=\"auth_login\" value=\"$auth_login\"></td></tr>"; | |
266 | ||
267 | $auth_pass = escape_for_form(db_fetch_result($result, 0, "auth_pass")); | |
268 | ||
269 | print "<tr><td>Password:</td>"; | |
270 | print "<td><input class=\"iedit\" type=\"password\" name=\"auth_pass\" | |
271 | onkeypress=\"return filterCR(event, feedEditSave)\" | |
272 | value=\"$auth_pass\"></td></tr>"; | |
273 | ||
274 | $private = sql_bool_to_bool(db_fetch_result($result, 0, "private")); | |
275 | ||
276 | if ($private) { | |
277 | $checked = "checked"; | |
278 | } else { | |
279 | $checked = ""; | |
280 | } | |
281 | ||
282 | print "<tr><td valign='top'>Options:</td>"; | |
283 | print "<td><input type=\"checkbox\" name=\"private\" id=\"private\" | |
284 | $checked><label for=\"private\">Hide from \"Other Feeds\"</label>"; | |
285 | ||
286 | $rtl_content = sql_bool_to_bool(db_fetch_result($result, 0, "rtl_content")); | |
287 | ||
288 | if ($rtl_content) { | |
289 | $checked = "checked"; | |
290 | } else { | |
291 | $checked = ""; | |
292 | } | |
293 | ||
294 | print "<br><input type=\"checkbox\" id=\"rtl_content\" name=\"rtl_content\" | |
295 | $checked><label for=\"rtl_content\">Right-to-left content</label>"; | |
296 | ||
297 | $hidden = sql_bool_to_bool(db_fetch_result($result, 0, "hidden")); | |
298 | ||
299 | if ($hidden) { | |
300 | $checked = "checked"; | |
301 | } else { | |
302 | $checked = ""; | |
303 | } | |
304 | ||
305 | print "<br><input type=\"checkbox\" id=\"hidden\" name=\"hidden\" | |
306 | $checked><label for=\"hidden\">Hide from my feed list</label>"; | |
307 | ||
308 | $include_in_digest = sql_bool_to_bool(db_fetch_result($result, 0, "include_in_digest")); | |
309 | ||
310 | if ($include_in_digest) { | |
311 | $checked = "checked"; | |
312 | } else { | |
313 | $checked = ""; | |
314 | } | |
315 | ||
316 | print "<br><input type=\"checkbox\" id=\"include_in_digest\" | |
317 | name=\"include_in_digest\" | |
318 | $checked><label for=\"include_in_digest\">Include in e-mail digest</label>"; | |
319 | ||
320 | print "</td></tr>"; | |
321 | ||
322 | print "</table>"; | |
323 | ||
324 | print "</form>"; | |
325 | ||
326 | print "<div align='right'> | |
327 | <input type=\"submit\" class=\"button\" | |
328 | onclick=\"return feedEditSave()\" value=\"Save\"> | |
329 | <input type='submit' class='button' | |
330 | onclick=\"return feedEditCancel()\" value=\"Cancel\"></div>"; | |
331 | ||
332 | print "</div>"; | |
333 | ||
334 | return; | |
335 | } | |
336 | ||
337 | if ($subop == "editSave") { | |
338 | ||
339 | $feed_title = db_escape_string(trim($_POST["title"])); | |
340 | $feed_link = db_escape_string(trim($_POST["feed_url"])); | |
341 | $upd_intl = db_escape_string($_POST["update_interval"]); | |
342 | $purge_intl = db_escape_string($_POST["purge_interval"]); | |
343 | $feed_id = db_escape_string($_POST["id"]); | |
344 | $cat_id = db_escape_string($_POST["cat_id"]); | |
345 | $auth_login = db_escape_string(trim($_POST["auth_login"])); | |
346 | $auth_pass = db_escape_string(trim($_POST["auth_pass"])); | |
347 | $parent_feed = db_escape_string($_POST["parent_feed"]); | |
348 | $private = checkbox_to_sql_bool(db_escape_string($_POST["private"])); | |
349 | $rtl_content = checkbox_to_sql_bool(db_escape_string($_POST["rtl_content"])); | |
350 | $hidden = checkbox_to_sql_bool(db_escape_string($_POST["hidden"])); | |
351 | $include_in_digest = checkbox_to_sql_bool( | |
352 | db_escape_string($_POST["include_in_digest"])); | |
353 | ||
354 | if (get_pref($link, 'ENABLE_FEED_CATS')) { | |
355 | if ($cat_id && $cat_id != 0) { | |
356 | $category_qpart = "cat_id = '$cat_id',"; | |
357 | $category_qpart_nocomma = "cat_id = '$cat_id'"; | |
358 | } else { | |
359 | $category_qpart = 'cat_id = NULL,'; | |
360 | $category_qpart_nocomma = 'cat_id = NULL'; | |
361 | } | |
362 | } else { | |
363 | $category_qpart = ""; | |
364 | $category_qpart_nocomma = ""; | |
365 | } | |
366 | ||
367 | if ($parent_feed && $parent_feed != 0) { | |
368 | $parent_qpart = "parent_feed = '$parent_feed'"; | |
369 | } else { | |
370 | $parent_qpart = 'parent_feed = NULL'; | |
371 | } | |
372 | ||
373 | $result = db_query($link, "UPDATE ttrss_feeds SET | |
374 | $category_qpart $parent_qpart, | |
375 | title = '$feed_title', feed_url = '$feed_link', | |
376 | update_interval = '$upd_intl', | |
377 | purge_interval = '$purge_intl', | |
378 | auth_login = '$auth_login', | |
379 | auth_pass = '$auth_pass', | |
380 | private = $private, | |
381 | rtl_content = $rtl_content, | |
382 | hidden = $hidden, | |
383 | include_in_digest = $include_in_digest | |
384 | WHERE id = '$feed_id' AND owner_uid = " . $_SESSION["uid"]); | |
385 | ||
386 | if (get_pref($link, 'ENABLE_FEED_CATS')) { | |
387 | # update linked feed categories | |
388 | $result = db_query($link, "UPDATE ttrss_feeds SET | |
389 | $category_qpart_nocomma WHERE parent_feed = '$feed_id' AND | |
390 | owner_uid = " . $_SESSION["uid"]); | |
391 | } | |
392 | } | |
393 | ||
ef8be8ea AD |
394 | if ($subop == "remove") { |
395 | ||
396 | if (!WEB_DEMO_MODE) { | |
397 | ||
398 | $ids = split(",", db_escape_string($_GET["ids"])); | |
399 | ||
400 | foreach ($ids as $id) { | |
401 | ||
402 | if ($id > 0) { | |
403 | ||
404 | db_query($link, "DELETE FROM ttrss_feeds | |
405 | WHERE id = '$id' AND owner_uid = " . $_SESSION["uid"]); | |
406 | ||
407 | $icons_dir = ICONS_DIR; | |
408 | ||
409 | if (file_exists($icons_dir . "/$id.ico")) { | |
410 | unlink($icons_dir . "/$id.ico"); | |
411 | } | |
412 | } else if ($id < -10) { | |
413 | ||
414 | $label_id = -$id - 11; | |
415 | ||
416 | db_query($link, "DELETE FROM ttrss_labels | |
417 | WHERE id = '$label_id' AND owner_uid = " . $_SESSION["uid"]); | |
418 | } | |
419 | } | |
420 | } | |
421 | } | |
422 | ||
423 | if ($subop == "add") { | |
424 | ||
425 | if (!WEB_DEMO_MODE) { | |
426 | ||
427 | $feed_url = db_escape_string(trim($_GET["feed_url"])); | |
428 | $cat_id = db_escape_string($_GET["cat_id"]); | |
aa2122d4 AD |
429 | $p_from = db_escape_string($_GET["from"]); |
430 | ||
e513a74a | 431 | if ($p_from != 'tt-rss') { |
aa2122d4 AD |
432 | print "<html> |
433 | <head> | |
434 | <title>Tiny Tiny RSS - Subscribe to feed...</title> | |
435 | <link rel=\"stylesheet\" type=\"text/css\" href=\"quicksub.css\"> | |
436 | </head> | |
437 | <body> | |
438 | <img class=\"logo\" src=\"images/ttrss_logo.png\" | |
439 | alt=\"Tiny Tiny RSS\"/> | |
e513a74a AD |
440 | <h1>Subscribe to feed...</h1> |
441 | <div class=\"content\">"; | |
aa2122d4 | 442 | } |
ef8be8ea AD |
443 | |
444 | if (subscribe_to_feed($link, $feed_url, $cat_id)) { | |
e513a74a | 445 | print "Subscribed to <b>$feed_url</b>."; |
ef8be8ea AD |
446 | } else { |
447 | print "<div class=\"warning\"> | |
e513a74a | 448 | Already subscribed to <b>$feed_url</b>. |
ef8be8ea AD |
449 | </div>"; |
450 | } | |
aa2122d4 | 451 | |
e513a74a | 452 | if ($p_from != 'tt-rss') { |
aa2122d4 AD |
453 | $tt_uri = 'http://' . $_SERVER['SERVER_NAME'] . |
454 | preg_replace('/backend\.php.*$/', | |
455 | 'tt-rss.php', $_SERVER["REQUEST_URI"]); | |
456 | ||
e513a74a AD |
457 | $tp_uri = 'http://' . $_SERVER['SERVER_NAME'] . |
458 | preg_replace('/backend\.php.*$/', | |
459 | 'prefs.php', $_SERVER["REQUEST_URI"]); | |
460 | ||
461 | print "<p><a href='$tt_uri'>Return to Tiny Tiny RSS</a> |"; | |
462 | ||
463 | $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE | |
464 | feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]); | |
465 | ||
466 | $feed_id = db_fetch_result($result, 0, "id"); | |
467 | ||
468 | if ($feed_id) { | |
469 | print "<a href='$tp_uri?tab=feedConfig&subop=editFeed:$feed_id'> | |
470 | Edit subscription options</a> | "; | |
471 | } | |
472 | ||
473 | print "<a href='javascript:window.close()'>Close this window</a>.</p>"; | |
aa2122d4 | 474 | |
e513a74a | 475 | print "</div></body></html>"; |
aa2122d4 AD |
476 | return; |
477 | } | |
ef8be8ea AD |
478 | } |
479 | } | |
480 | ||
ef8be8ea AD |
481 | if ($subop == "categorize") { |
482 | ||
483 | if (!WEB_DEMO_MODE) { | |
484 | ||
485 | $ids = split(",", db_escape_string($_GET["ids"])); | |
486 | ||
487 | $cat_id = db_escape_string($_GET["cat_id"]); | |
488 | ||
489 | if ($cat_id == 0) { | |
490 | $cat_id_qpart = 'NULL'; | |
491 | } else { | |
492 | $cat_id_qpart = "'$cat_id'"; | |
493 | } | |
494 | ||
495 | db_query($link, "BEGIN"); | |
496 | ||
497 | foreach ($ids as $id) { | |
498 | ||
499 | db_query($link, "UPDATE ttrss_feeds SET cat_id = $cat_id_qpart | |
500 | WHERE id = '$id' AND parent_feed IS NULL | |
501 | AND owner_uid = " . $_SESSION["uid"]); | |
502 | ||
503 | # update linked feed categories | |
504 | db_query($link, "UPDATE ttrss_feeds SET | |
505 | cat_id = $cat_id_qpart WHERE parent_feed = '$id' AND | |
506 | owner_uid = " . $_SESSION["uid"]); | |
507 | ||
508 | } | |
509 | ||
510 | db_query($link, "COMMIT"); | |
511 | } | |
512 | ||
513 | } | |
514 | ||
9c483746 AD |
515 | if ($subop == "editCats") { |
516 | ||
517 | print "<div id=\"infoBoxTitle\">Category editor</div>"; | |
518 | ||
519 | print "<div class=\"infoBoxContents\">"; | |
520 | ||
521 | $action = $_REQUEST["action"]; | |
522 | ||
523 | if ($action == "save") { | |
524 | ||
525 | $cat_title = db_escape_string(trim($_GET["title"])); | |
526 | $cat_id = db_escape_string($_GET["id"]); | |
527 | ||
528 | $result = db_query($link, "UPDATE ttrss_feed_categories SET | |
529 | title = '$cat_title' WHERE id = '$cat_id' AND owner_uid = ".$_SESSION["uid"]); | |
530 | ||
531 | } | |
532 | ||
533 | if ($action == "add") { | |
534 | ||
535 | if (!WEB_DEMO_MODE) { | |
536 | ||
537 | $feed_cat = db_escape_string(trim($_GET["cat"])); | |
538 | ||
539 | $result = db_query($link, | |
540 | "SELECT id FROM ttrss_feed_categories | |
541 | WHERE title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]); | |
542 | ||
543 | if (db_num_rows($result) == 0) { | |
544 | ||
545 | $result = db_query($link, | |
546 | "INSERT INTO ttrss_feed_categories (owner_uid,title) | |
547 | VALUES ('".$_SESSION["uid"]."', '$feed_cat')"); | |
548 | ||
549 | } else { | |
550 | ||
551 | print "<div class=\"warning\"> | |
552 | Category <b>$feed_cat</b> already exists in the database. | |
553 | </div>"; | |
554 | } | |
555 | ||
556 | } | |
557 | } | |
558 | ||
559 | if ($action == "remove") { | |
560 | ||
561 | if (!WEB_DEMO_MODE) { | |
562 | ||
563 | $ids = split(",", db_escape_string($_GET["ids"])); | |
564 | ||
565 | foreach ($ids as $id) { | |
566 | ||
567 | db_query($link, "BEGIN"); | |
568 | ||
569 | $result = db_query($link, | |
570 | "SELECT count(id) as num_feeds FROM ttrss_feeds | |
571 | WHERE cat_id = '$id'"); | |
572 | ||
573 | $num_feeds = db_fetch_result($result, 0, "num_feeds"); | |
574 | ||
575 | if ($num_feeds == 0) { | |
576 | db_query($link, "DELETE FROM ttrss_feed_categories | |
577 | WHERE id = '$id' AND owner_uid = " . $_SESSION["uid"]); | |
578 | } else { | |
579 | ||
580 | print "<div class=\"warning\"> | |
581 | Unable to delete non empty feed categories.</div>"; | |
582 | ||
583 | } | |
584 | ||
585 | db_query($link, "COMMIT"); | |
586 | } | |
587 | } | |
588 | } | |
589 | ||
590 | print "<div class=\"prefGenericAddBox\"> | |
591 | <input id=\"fadd_cat\" | |
1043a8c3 | 592 | onkeypress=\"return filterCR(event, addFeedCat)\" |
9c483746 AD |
593 | onkeyup=\"toggleSubmitNotEmpty(this, 'catadd_submit_btn')\" |
594 | size=\"40\"> | |
595 | <input | |
596 | type=\"submit\" class=\"button\" disabled=\"true\" id=\"catadd_submit_btn\" | |
597 | onclick=\"javascript:addFeedCat()\" value=\"Create category\"></div>"; | |
598 | ||
599 | $result = db_query($link, "SELECT title,id FROM ttrss_feed_categories | |
600 | WHERE owner_uid = ".$_SESSION["uid"]." | |
601 | ORDER BY title"); | |
602 | ||
603 | print "<p>"; | |
604 | ||
605 | if (db_num_rows($result) != 0) { | |
606 | ||
607 | print "<table width=\"100%\" class=\"prefFeedCatList\" | |
608 | cellspacing=\"0\">"; | |
609 | ||
610 | print "<tr><td class=\"selectPrompt\" colspan=\"8\"> | |
611 | Select: | |
612 | <a href=\"javascript:selectPrefRows('fcat', true)\">All</a>, | |
613 | <a href=\"javascript:selectPrefRows('fcat', false)\">None</a> | |
614 | </td></tr>"; | |
615 | ||
616 | print "</table>"; | |
617 | ||
618 | print "<div class=\"prefFeedCatHolder\">"; | |
619 | ||
620 | print "<form id=\"feed_cat_edit_form\">"; | |
621 | ||
622 | print "<table width=\"100%\" class=\"prefFeedCatList\" | |
623 | cellspacing=\"0\" id=\"prefFeedCatList\">"; | |
624 | ||
625 | /* print "<tr class=\"title\"> | |
626 | <td width=\"5%\"> </td><td width=\"80%\">Title</td> | |
627 | </tr>"; */ | |
628 | ||
629 | $lnum = 0; | |
630 | ||
631 | while ($line = db_fetch_assoc($result)) { | |
632 | ||
633 | $class = ($lnum % 2) ? "even" : "odd"; | |
634 | ||
635 | $cat_id = $line["id"]; | |
636 | ||
637 | $edit_cat_id = $_GET["id"]; | |
81780e8f AD |
638 | |
639 | if ($action == "edit" && $cat_id == $edit_cat_id) { | |
640 | $class .= "Selected"; | |
641 | $this_row_id = ""; | |
642 | } else if ($action == "edit" && $cat_id != $edit_cat_id) { | |
643 | $class .= "Grayed"; | |
644 | $this_row_id = ""; | |
9c483746 AD |
645 | } else { |
646 | $this_row_id = "id=\"FCATR-$cat_id\""; | |
647 | } | |
648 | ||
649 | print "<tr class=\"$class\" $this_row_id>"; | |
650 | ||
651 | $edit_title = htmlspecialchars(db_unescape_string($line["title"])); | |
652 | ||
653 | if (!$edit_cat_id || $action != "edit") { | |
654 | ||
655 | print "<td width='5%' align='center'><input onclick='toggleSelectPrefRow(this, \"fcat\");' | |
656 | type=\"checkbox\" id=\"FCCHK-".$line["id"]."\"></td>"; | |
657 | ||
658 | print "<td><a href=\"javascript:editFeedCat($cat_id);\">" . | |
659 | $edit_title . "</a></td>"; | |
660 | ||
661 | } else if ($cat_id != $edit_cat_id) { | |
662 | ||
663 | print "<td width='5%' align='center'><input disabled=\"true\" type=\"checkbox\" | |
664 | id=\"FRCHK-".$line["id"]."\"></td>"; | |
665 | ||
666 | print "<td>$edit_title</td>"; | |
667 | ||
668 | } else { | |
669 | ||
670 | print "<td width='5%' align='center'><input disabled=\"true\" type=\"checkbox\" checked>"; | |
671 | ||
672 | print "<input type=\"hidden\" name=\"id\" value=\"$cat_id\">"; | |
673 | print "<input type=\"hidden\" name=\"op\" value=\"pref-feeds\">"; | |
674 | print "<input type=\"hidden\" name=\"subop\" value=\"editCats\">"; | |
675 | print "<input type=\"hidden\" name=\"action\" value=\"save\">"; | |
676 | ||
677 | print "</td>"; | |
678 | ||
1043a8c3 | 679 | print "<td><input onkeypress=\"return filterCR(event, feedCatEditSave)\" |
9c483746 AD |
680 | name=\"title\" size=\"40\" value=\"$edit_title\"></td>"; |
681 | ||
682 | } | |
683 | ||
684 | print "</tr>"; | |
685 | ||
686 | ++$lnum; | |
687 | } | |
688 | ||
689 | print "</table>"; | |
690 | ||
691 | print "</form>"; | |
692 | ||
693 | print "</div>"; | |
694 | ||
6f5b1e04 AD |
695 | } else { |
696 | print "<p>No feed categories defined.</p>"; | |
697 | } | |
9c483746 | 698 | |
6f5b1e04 AD |
699 | print "<div style='float : right'> |
700 | <input type='submit' class='button' | |
cbb9982e | 701 | onclick=\"selectTab('feedConfig')\" value=\"Close this window\"></div>"; |
9c483746 | 702 | |
6f5b1e04 | 703 | print "<div id=\"catOpToolbar\">"; |
9c483746 | 704 | |
6f5b1e04 AD |
705 | if ($action == "edit") { |
706 | print "<input type=\"submit\" class=\"button\" | |
707 | onclick=\"return feedCatEditSave()\" value=\"Save\"> | |
708 | <input type=\"submit\" class=\"button\" | |
709 | onclick=\"return feedCatEditCancel()\" value=\"Cancel\">"; | |
9c483746 | 710 | } else { |
6f5b1e04 AD |
711 | |
712 | print " | |
713 | <input type=\"submit\" class=\"button\" disabled=\"true\" | |
714 | onclick=\"return editSelectedFeedCat()\" value=\"Edit\"> | |
715 | <input type=\"submit\" class=\"button\" disabled=\"true\" | |
716 | onclick=\"return removeSelectedFeedCats()\" value=\"Remove\">"; | |
9c483746 AD |
717 | } |
718 | ||
719 | print "</div>"; | |
720 | ||
6f5b1e04 AD |
721 | print "</div>"; |
722 | ||
9c483746 AD |
723 | return; |
724 | ||
725 | } | |
726 | ||
ef8be8ea AD |
727 | if ($quiet) return; |
728 | ||
a3656a41 | 729 | $result = db_query($link, "SELECT COUNT(id) AS num_errors |
ef8be8ea AD |
730 | FROM ttrss_feeds WHERE last_error != '' AND owner_uid = ".$_SESSION["uid"]); |
731 | ||
a3656a41 | 732 | $num_errors = db_fetch_result($result, 0, "num_errors"); |
ef8be8ea | 733 | |
a3656a41 | 734 | if ($num_errors > 0) { |
ef8be8ea | 735 | |
a3656a41 AD |
736 | print "<a href=\"javascript:showFeedsWithErrors()\" |
737 | class=\"feedUpdErrLink\">Some feeds have update errors (click | |
738 | for details)</a>"; | |
ef8be8ea AD |
739 | } |
740 | ||
741 | $feed_search = db_escape_string($_GET["search"]); | |
742 | ||
743 | if (array_key_exists("search", $_GET)) { | |
744 | $_SESSION["prefs_feed_search"] = $feed_search; | |
745 | } else { | |
746 | $feed_search = $_SESSION["prefs_feed_search"]; | |
747 | } | |
748 | ||
749 | print "<div class=\"feedEditSearch\"> | |
750 | <input id=\"feed_search\" size=\"20\" | |
751 | onchange=\"javascript:updateFeedList()\" value=\"$feed_search\"> | |
752 | <input type=\"submit\" class=\"button\" | |
753 | onclick=\"javascript:updateFeedList()\" value=\"Search\"> | |
754 | </div>"; | |
755 | ||
756 | print "<div class=\"prefGenericAddBox\"> | |
757 | <input id=\"fadd_link\" | |
758 | onkeyup=\"toggleSubmitNotEmpty(this, 'fadd_submit_btn')\" | |
759 | size=\"40\"> | |
760 | <input type=\"submit\" class=\"button\" | |
761 | disabled=\"true\" id=\"fadd_submit_btn\" | |
762 | onclick=\"addFeed()\" value=\"Subscribe\">"; | |
763 | ||
764 | if (ENABLE_FEED_BROWSER && !SINGLE_USER_MODE) { | |
765 | print " <input type=\"submit\" class=\"button\" | |
766 | onclick=\"javascript:browseFeeds()\" value=\"Top 25\">"; | |
767 | } | |
768 | ||
769 | print "</div>"; | |
770 | ||
771 | $feeds_sort = db_escape_string($_GET["sort"]); | |
772 | ||
773 | if (!$feeds_sort || $feeds_sort == "undefined") { | |
774 | $feeds_sort = $_SESSION["pref_sort_feeds"]; | |
775 | if (!$feeds_sort) $feeds_sort = "title"; | |
776 | } | |
777 | ||
778 | $_SESSION["pref_sort_feeds"] = $feeds_sort; | |
779 | ||
780 | if ($feed_search) { | |
781 | $search_qpart = "(UPPER(F1.title) LIKE UPPER('%$feed_search%') OR | |
782 | UPPER(F1.feed_url) LIKE UPPER('%$feed_search%')) AND"; | |
783 | } else { | |
784 | $search_qpart = ""; | |
785 | } | |
786 | ||
787 | if (get_pref($link, 'ENABLE_FEED_CATS')) { | |
788 | $order_by_qpart = "category,$feeds_sort,title"; | |
789 | } else { | |
790 | $order_by_qpart = "$feeds_sort,title"; | |
791 | } | |
792 | ||
793 | $result = db_query($link, "SELECT | |
794 | F1.id, | |
795 | F1.title, | |
796 | F1.feed_url, | |
797 | substring(F1.last_updated,1,16) AS last_updated, | |
798 | F1.parent_feed, | |
799 | F1.update_interval, | |
800 | F1.purge_interval, | |
801 | F1.cat_id, | |
802 | F2.title AS parent_title, | |
803 | C1.title AS category, | |
804 | F1.hidden, | |
805 | F1.include_in_digest, | |
806 | (SELECT SUBSTRING(MAX(updated),1,16) FROM ttrss_user_entries, | |
807 | ttrss_entries WHERE ref_id = ttrss_entries.id | |
808 | AND feed_id = F1.id) AS last_article | |
809 | FROM | |
810 | ttrss_feeds AS F1 | |
811 | LEFT JOIN ttrss_feeds AS F2 | |
812 | ON (F1.parent_feed = F2.id) | |
813 | LEFT JOIN ttrss_feed_categories AS C1 | |
814 | ON (F1.cat_id = C1.id) | |
815 | WHERE | |
816 | $search_qpart F1.owner_uid = '".$_SESSION["uid"]."' | |
817 | ORDER by $order_by_qpart"); | |
818 | ||
819 | if (db_num_rows($result) != 0) { | |
820 | ||
821 | // print "<div id=\"infoBoxShadow\"><div id=\"infoBox\">PLACEHOLDER</div></div>"; | |
822 | ||
823 | print "<p><table width=\"100%\" cellspacing=\"0\" | |
824 | class=\"prefFeedList\" id=\"prefFeedList\">"; | |
825 | print "<tr><td class=\"selectPrompt\" colspan=\"8\"> | |
826 | Select: | |
827 | <a href=\"javascript:selectPrefRows('feed', true)\">All</a>, | |
828 | <a href=\"javascript:selectPrefRows('feed', false)\">None</a> | |
829 | </td</tr>"; | |
830 | ||
831 | if (!get_pref($link, 'ENABLE_FEED_CATS')) { | |
832 | print "<tr class=\"title\"> | |
833 | <td width='5%' align='center'> </td>"; | |
834 | ||
835 | if (get_pref($link, 'ENABLE_FEED_ICONS')) { | |
836 | print "<td width='3%'> </td>"; | |
837 | } | |
838 | ||
839 | print " | |
840 | <td width='35%'><a href=\"javascript:updateFeedList('title')\">Title</a></td> | |
841 | <td width='35%'><a href=\"javascript:updateFeedList('feed_url')\">Feed</a></td> | |
842 | <td width='15%'><a href=\"javascript:updateFeedList('last_article')\">Last Article</a></td> | |
843 | <td width='15%' align='right'><a href=\"javascript:updateFeedList('last_updated')\">Updated</a></td>"; | |
844 | } | |
845 | ||
846 | $lnum = 0; | |
847 | ||
848 | $cur_cat_id = -1; | |
849 | ||
850 | while ($line = db_fetch_assoc($result)) { | |
851 | ||
852 | $feed_id = $line["id"]; | |
853 | $cat_id = $line["cat_id"]; | |
854 | ||
855 | $edit_title = htmlspecialchars(db_unescape_string($line["title"])); | |
856 | $edit_link = htmlspecialchars(db_unescape_string($line["feed_url"])); | |
857 | $edit_cat = htmlspecialchars(db_unescape_string($line["category"])); | |
858 | ||
859 | $hidden = sql_bool_to_bool($line["hidden"]); | |
860 | ||
861 | if (!$edit_cat) $edit_cat = "Uncategorized"; | |
862 | ||
863 | $last_updated = $line["last_updated"]; | |
864 | ||
865 | if (get_pref($link, 'HEADLINES_SMART_DATE')) { | |
866 | $last_updated = smart_date_time(strtotime($last_updated)); | |
867 | } else { | |
868 | $short_date = get_pref($link, 'SHORT_DATE_FORMAT'); | |
869 | $last_updated = date($short_date, strtotime($last_updated)); | |
870 | } | |
871 | ||
872 | $last_article = $line["last_article"]; | |
873 | ||
874 | if (get_pref($link, 'HEADLINES_SMART_DATE')) { | |
875 | $last_article = smart_date_time(strtotime($last_article)); | |
876 | } else { | |
877 | $short_date = get_pref($link, 'SHORT_DATE_FORMAT'); | |
878 | $last_article = date($short_date, strtotime($last_article)); | |
879 | } | |
880 | ||
881 | if (get_pref($link, 'ENABLE_FEED_CATS') && $cur_cat_id != $cat_id) { | |
882 | $lnum = 0; | |
883 | ||
884 | print "<tr><td colspan=\"6\" class=\"feedEditCat\">$edit_cat</td></tr>"; | |
885 | ||
886 | print "<tr class=\"title\"> | |
887 | <td width='5%'> </td>"; | |
888 | ||
889 | if (get_pref($link, 'ENABLE_FEED_ICONS')) { | |
890 | print "<td width='3%'> </td>"; | |
891 | } | |
892 | ||
893 | print "<td width='35%'><a href=\"javascript:updateFeedList('title')\">Title</a></td> | |
894 | <td width='35%'><a href=\"javascript:updateFeedList('feed_url')\">Feed</a></td> | |
895 | <td width='15%'><a href=\"javascript:updateFeedList('last_article')\">Last Article</a></td> | |
896 | <td width='15%' align='right'><a href=\"javascript:updateFeedList('last_updated')\">Updated</a></td>"; | |
897 | ||
898 | $cur_cat_id = $cat_id; | |
899 | } | |
900 | ||
901 | $class = ($lnum % 2) ? "even" : "odd"; | |
902 | $this_row_id = "id=\"FEEDR-$feed_id\""; | |
903 | ||
904 | print "<tr class=\"$class\" $this_row_id>"; | |
905 | ||
906 | $icon_file = ICONS_DIR . "/$feed_id.ico"; | |
907 | ||
908 | if (file_exists($icon_file) && filesize($icon_file) > 0) { | |
909 | $feed_icon = "<img class=\"tinyFeedIcon\" src=\"" . ICONS_URL . "/$feed_id.ico\">"; | |
910 | } else { | |
911 | $feed_icon = "<img class=\"tinyFeedIcon\" src=\"images/blank_icon.gif\">"; | |
912 | } | |
913 | ||
914 | print "<td class='feedSelect'><input onclick='toggleSelectPrefRow(this, \"feed\");' | |
915 | type=\"checkbox\" id=\"FRCHK-".$line["id"]."\"></td>"; | |
916 | ||
917 | if (get_pref($link, 'ENABLE_FEED_ICONS')) { | |
918 | print "<td class='feedIcon'>$feed_icon</td>"; | |
919 | } | |
920 | ||
921 | $edit_title = truncate_string($edit_title, 40); | |
922 | $edit_link = truncate_string($edit_link, 60); | |
923 | ||
924 | if ($hidden) { | |
925 | $edit_title = "<span class=\"insensitive\">$edit_title (Hidden)</span>"; | |
926 | $edit_link = "<span class=\"insensitive\">$edit_link</span>"; | |
927 | $last_updated = "<span class=\"insensitive\">$last_updated</span>"; | |
928 | $last_article = "<span class=\"insensitive\">$last_article</span>"; | |
929 | } | |
930 | ||
931 | $parent_title = $line["parent_title"]; | |
932 | if ($parent_title) { | |
933 | $parent_title = "<span class='groupPrompt'>(linked to | |
934 | $parent_title)</span>"; | |
935 | } | |
936 | ||
937 | print "<td><a href=\"javascript:editFeed($feed_id);\">" . | |
938 | "$edit_title $parent_title" . "</a></td>"; | |
939 | ||
940 | print "<td><a href=\"javascript:editFeed($feed_id);\">" . | |
941 | $edit_link . "</a></td>"; | |
942 | ||
943 | print "<td><a href=\"javascript:editFeed($feed_id);\">" . | |
944 | "$last_article</a></td>"; | |
945 | ||
946 | print "<td align='right'><a href=\"javascript:editFeed($feed_id);\">" . | |
947 | "$last_updated</a></td>"; | |
948 | ||
949 | print "</tr>"; | |
950 | ||
951 | ++$lnum; | |
952 | } | |
953 | ||
954 | print "</table>"; | |
955 | ||
956 | print "<p><span id=\"feedOpToolbar\">"; | |
957 | ||
958 | if ($subop == "edit") { | |
959 | print "Edit feed: | |
960 | <input type=\"submit\" class=\"button\" | |
961 | onclick=\"javascript:feedEditCancel()\" value=\"Cancel\"> | |
962 | <input type=\"submit\" class=\"button\" | |
963 | onclick=\"javascript:feedEditSave()\" value=\"Save\">"; | |
964 | } else { | |
965 | ||
966 | print " | |
967 | Selection: | |
968 | <input type=\"submit\" class=\"button\" disabled=\"true\" | |
969 | onclick=\"javascript:editSelectedFeed()\" value=\"Edit\"> | |
970 | <input type=\"submit\" class=\"button\" disabled=\"true\" | |
971 | onclick=\"javascript:removeSelectedFeeds()\" value=\"Unsubscribe\">"; | |
972 | ||
973 | if (get_pref($link, 'ENABLE_FEED_CATS')) { | |
974 | ||
975 | print " | "; | |
976 | ||
977 | print_feed_cat_select($link, "sfeed_set_fcat", "", "disabled"); | |
978 | ||
979 | print " <input type=\"submit\" class=\"button\" disabled=\"true\" | |
980 | onclick=\"javascript:categorizeSelectedFeeds()\" value=\"Recategorize\">"; | |
981 | ||
982 | } | |
983 | ||
9c483746 AD |
984 | print "</span>"; |
985 | ||
986 | if (get_pref($link, 'ENABLE_FEED_CATS')) { | |
987 | ||
988 | print " <input type=\"submit\" class=\"button\" | |
989 | onclick=\"javascript:editFeedCats()\" value=\"Edit categories\">"; | |
990 | ||
94a4ba88 | 991 | # print " | "; |
9c483746 AD |
992 | |
993 | } | |
994 | ||
ef8be8ea AD |
995 | } |
996 | } else { | |
997 | ||
6f5b1e04 | 998 | // print "<p>No feeds defined.</p>"; |
ef8be8ea AD |
999 | |
1000 | } | |
1001 | ||
94a4ba88 AD |
1002 | print "<h3>OPML</h3> |
1003 | ||
1004 | <div style='float : left'> | |
ef8be8ea AD |
1005 | <form enctype=\"multipart/form-data\" method=\"POST\" action=\"opml.php\"> |
1006 | File: <input id=\"opml_file\" name=\"opml_file\" type=\"file\"> | |
1007 | <input class=\"button\" name=\"op\" onclick=\"return validateOpmlImport();\" | |
1008 | type=\"submit\" value=\"Import\"> | |
94a4ba88 AD |
1009 | </form></div>"; |
1010 | ||
1011 | print " | "; | |
1012 | ||
1013 | print "<input type=\"submit\" | |
1014 | class=\"button\" onclick=\"gotoExportOpml()\" | |
1015 | value=\"Export\">"; | |
1016 | ||
ef8be8ea AD |
1017 | } |
1018 | ?> |