modules/popup-dialog.php

   1 <?php
   2         function module_popup_dialog($link) {
   3                 $id = $_REQUEST["id"];
   4                 $param = db_escape_string($_REQUEST["param"]);
   5
   6                 print "<dlg id=\"$id\">";
   7
   8                 if ($id == "importOpml") {
   9                         print "<div class=\"prefFeedOPMLHolder\">";
  10                         header("Content-Type: text/html"); # required for iframe
  11
  12                         $owner_uid = $_SESSION["uid"];
  13
  14                         db_query($link, "BEGIN");
  15
  16                         /* create Imported feeds category just in case */
  17
  18                         $result = db_query($link, "SELECT id FROM
  19                                 ttrss_feed_categories WHERE title = 'Imported feeds' AND
  20                                 owner_uid = '$owner_uid' LIMIT 1");
  21
  22                         if (db_num_rows($result) == 0) {
  23                                 db_query($link, "INSERT INTO ttrss_feed_categories
  24                                         (title,owner_uid)
  25                                                 VALUES ('Imported feeds', '$owner_uid')");
  26                         }
  27
  28                         db_query($link, "COMMIT");
  29
  30                         /* Handle OPML import by DOMXML/DOMDocument */
  31
  32                         if (function_exists('domxml_open_file')) {
  33                                 print "<ul class='nomarks'>";
  34                                 print "<li>".__("Importing using DOMXML.")."</li>";
  35                                 require_once "opml_domxml.php";
  36                                 opml_import_domxml($link, $owner_uid);
  37                                 print "</ul>";
  38                         } else if (PHP_VERSION >= 5) {
  39                                 print "<ul class='nomarks'>";
  40                                 print "<li>".__("Importing using DOMDocument.")."</li>";
  41                                 require_once "opml_domdoc.php";
  42                                 opml_import_domdoc($link, $owner_uid);
  43                                 print "</ul>";
  44                         } else {
  45                                 print_error(__("DOMXML extension is not found. It is required for PHP versions below 5."));
  46                         }
  47
  48                         print "</div>";
  49
  50                         print "<div align='center'>";
  51                         print "<button dojoType=\"dijit.form.Button\"
  52                                 onclick=\"dijit.byId('opmlImportDlg').hide()\">".
  53                                 __('Close this window')."</button>";
  54                         print "</div>";
  55
  56                         print "</div>";
  57
  58                         //return;
  59                 }
  60
  61                 if ($id == "editPrefProfiles") {
  62
  63                         print "<div dojoType=\"dijit.Toolbar\">";
  64
  65 #                       TODO: depends on selectTableRows() being broken for this list
  66 #                       print "<div dojoType=\"dijit.form.DropDownButton\">".
  67 #                               "<span>" . __('Select')."</span>";
  68 #                       print "<div dojoType=\"dijit.Menu\" style=\"display: none;\">";
  69 #                       print "<div onclick=\"selectTableRows('prefFeedProfileList', 'all')\"
  70 #                               dojoType=\"dijit.MenuItem\">".__('All')."</div>";
  71 #                       print "<div onclick=\"selectTableRows('prefFeedProfileList', 'none')\"
  72 #                               dojoType=\"dijit.MenuItem\">".__('None')."</div>";
  73 #                       print "</div></div>";
  74
  75 #                       print "<div style='float : right'>";
  76                         print "<input name=\"newprofile\" dojoType=\"dijit.form.ValidationTextBox\"
  77                                         required=\"1\">
  78                                 <button dojoType=\"dijit.form.Button\"
  79                                 onclick=\"dijit.byId('profileEditDlg').addProfile()\">".
  80                                         __('Create profile')."</button></div>";
  81
  82 #                       print "</div>";
  83
  84
  85                         $result = db_query($link, "SELECT title,id FROM ttrss_settings_profiles
  86                                 WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
  87
  88                         print "<div class=\"prefFeedCatHolder\">";
  89
  90                         print "<form id=\"profile_edit_form\" onsubmit=\"return false\">";
  91
  92                         print "<table width=\"100%\" class=\"prefFeedProfileList\"
  93                                 cellspacing=\"0\" id=\"prefFeedProfileList\">";
  94
  95                         print "<tr class=\"\" id=\"FCATR-0\">"; #odd
  96
  97                         print "<td width='5%' align='center'><input
  98                                 onclick='toggleSelectRow2(this);'
  99                                 dojoType=\"dijit.form.CheckBox\"
 100                                 type=\"checkbox\"></td>";
 101
 102                         if (!$_SESSION["profile"]) {
 103                                 $is_active = __("(active)");
 104                         } else {
 105                                 $is_active = "";
 106                         }
 107
 108                         print "<td><span>" .
 109                                 __("Default profile") . " $is_active</span></td>";
 110
 111                         print "</tr>";
 112
 113                         $lnum = 1;
 114
 115                         while ($line = db_fetch_assoc($result)) {
 116
 117                                 $class = ($lnum % 2) ? "even" : "odd";
 118
 119                                 $profile_id = $line["id"];
 120                                 $this_row_id = "id=\"FCATR-$profile_id\"";
 121
 122                                 print "<tr class=\"\" $this_row_id>";
 123
 124                                 $edit_title = htmlspecialchars($line["title"]);
 125
 126                                 print "<td width='5%' align='center'><input
 127                                         onclick='toggleSelectRow2(this);'
 128                                         dojoType=\"dijit.form.CheckBox\"
 129                                         type=\"checkbox\"></td>";
 130
 131                                 if ($_SESSION["profile"] == $line["id"]) {
 132                                         $is_active = __("(active)");
 133                                 } else {
 134                                         $is_active = "";
 135                                 }
 136
 137                                 print "<td><span dojoType=\"dijit.InlineEditBox\"
 138                                         width=\"300px\" autoSave=\"false\"
 139                                         profile-id=\"$profile_id\">" . $edit_title .
 140                                         "<script type=\"dojo/method\" event=\"onChange\" args=\"item\">
 141                                                 var elem = this;
 142                                                 dojo.xhrPost({
 143                                                         url: 'backend.php',
 144                                                         content: {op: 'rpc', subop: 'saveprofile',
 145                                                                 value: this.value,
 146                                                                 id: this.srcNodeRef.getAttribute('profile-id')},
 147                                                                 load: function(response) {
 148                                                                         elem.attr('value', response);
 149                                                         }
 150                                                 });
 151                                         </script>
 152                                 </span> $is_active</td>";
 153
 154                                 print "</tr>";
 155
 156                                 ++$lnum;
 157                         }
 158
 159                         print "</table>";
 160                         print "</form>";
 161                         print "</div>";
 162
 163                         print "<div class='dlgButtons'>
 164                                 <div style='float : left'>
 165                                 <button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('profileEditDlg').removeSelected()\">".
 166                                 __('Remove selected profiles')."</button>
 167                                 <button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('profileEditDlg').activateProfile()\">".
 168                                 __('Activate profile')."</button>
 169                                 </div>";
 170
 171                         print "<button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('profileEditDlg').hide()\">".
 172                                 __('Close this window')."</button>";
 173                         print "</div>";
 174
 175                 }
 176
 177                 if ($id == "pubOPMLUrl") {
 178
 179                         print "<title>".__('Public OPML URL')."</title>";
 180                         print "<content><![CDATA[";
 181
 182                         $url_path = opml_publish_url($link);
 183
 184                         print __("Your Public OPML URL is:");
 185
 186                         print "<div class=\"tagCloudContainer\">";
 187                         print "<a id='pub_opml_url' href='$url_path' target='_blank'>$url_path</a>";
 188                         print "</div>";
 189
 190                         print "<div align='center'>";
 191
 192                         print "<button dojoType=\"dijit.form.Button\" onclick=\"return opmlRegenKey()\">".
 193                                 __('Generate new URL')."</button> ";
 194
 195                         print "<button dojoType=\"dijit.form.Button\" onclick=\"return closeInfoBox()\">".
 196                                 __('Close this window')."</button>";
 197
 198                         print "</div>";
 199                         print "]]></content>";
 200
 201                         //return;
 202                 }
 203
 204                 if ($id == "explainError") {
 205
 206                         print "<title>".__('Notice')."</title>";
 207                         print "<content><![CDATA[";
 208
 209                         print "<div class=\"errorExplained\">";
 210
 211                         if ($param == 1) {
 212                                 print __("Update daemon is enabled in configuration, but daemon process is not running, which prevents all feeds from updating. Please start the daemon process or contact instance owner.");
 213
 214                                 $stamp = (int) file_get_contents(LOCK_DIRECTORY . "/update_daemon.stamp");
 215
 216                                 print "<p>" . __("Last update:") . " " . date("Y.m.d, G:i", $stamp);
 217
 218                         }
 219
 220                         if ($param == 3) {
 221                                 print __("Update daemon is taking too long to perform a feed update. This could indicate a problem like crash or a hang. Please check the daemon process or contact instance owner.");
 222
 223                                 $stamp = (int) file_get_contents(LOCK_DIRECTORY . "/update_daemon.stamp");
 224
 225                                 print "<p>" . __("Last update:") . " " . date("Y.m.d, G:i", $stamp);
 226
 227                         }
 228
 229                         print "</div>";
 230
 231                         print "<div align='center'>";
 232
 233                         print "<button onclick=\"return closeInfoBox()\">".
 234                                 __('Close this window')."</button>";
 235
 236                         print "</div>";
 237                         print "]]></content>";
 238
 239                         //return;
 240                 }
 241
 242                 if ($id == "quickAddFeed") {
 243
 244                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"op\" value=\"rpc\">";
 245                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"subop\" value=\"addfeed\">";
 246
 247                         print "<div class=\"dlgSec\">".__("Feed")."</div>";
 248                         print "<div class=\"dlgSecCont\">";
 249
 250                         print "<input style=\"font-size : 16px; width : 20em;\"
 251                                 placeHolder=\"".__("Feed URL")."\"
 252                                 dojoType=\"dijit.form.ValidationTextBox\" required=\"1\" name=\"feed\" id=\"feedDlg_feedUrl\">";
 253
 254                         print "<hr/>";
 255
 256                         if (get_pref($link, 'ENABLE_FEED_CATS')) {
 257                                 print __('Place in category:') . " ";
 258                                 print_feed_cat_select($link, "cat", false, 'dojoType="dijit.form.Select"');
 259                         }
 260
 261                         print "</div>";
 262
 263                         print '<div id="feedDlg_feedsContainer" style="display : none">
 264
 265                                         <div class="dlgSec">' . __('Available feeds') . '</div>
 266                                         <div class="dlgSecCont">'.
 267                                         '<select id="feedDlg_feedContainerSelect"
 268                                                 dojoType="dijit.form.Select" size="3">
 269                                                 <script type="dojo/method" event="onChange" args="value">
 270                                                         dijit.byId("feedDlg_feedUrl").attr("value", value);
 271                                                 </script>
 272                                         </select>'.
 273                                         '</div></div>';
 274
 275                         print "<div id='feedDlg_loginContainer' style='display : none'>
 276
 277                                         <div class=\"dlgSec\">".__("Authentication")."</div>
 278                                         <div class=\"dlgSecCont\">".
 279
 280                                         " <input dojoType=\"dijit.form.TextBox\" name='login'\"
 281                                                 placeHolder=\"".__("Login")."\"
 282                                                 style=\"width : 10em;\"> ".
 283                                         " <input
 284                                                 placeHolder=\"".__("Password")."\"
 285                                                 dojoType=\"dijit.form.TextBox\" type='password'
 286                                                 style=\"width : 10em;\" name='pass'\">
 287                                 </div></div>";
 288
 289
 290                         print "<div style=\"clear : both\">
 291                                 <input type=\"checkbox\" dojoType=\"dijit.form.CheckBox\" id=\"feedDlg_loginCheck\"
 292                                                 onclick='checkboxToggleElement(this, \"feedDlg_loginContainer\")'>
 293                                         <label for=\"feedDlg_loginCheck\">".
 294                                         __('This feed requires authentication.')."</div>";
 295
 296                         print "</form>";
 297
 298                         print "<div class=\"dlgButtons\">
 299                                 <button dojoType=\"dijit.form.Button\" onclick=\"return dijit.byId('feedAddDlg').execute()\">".__('Subscribe')."</button>
 300                                 <button dojoType=\"dijit.form.Button\" onclick=\"return feedBrowser()\">".__('More feeds')."</button>
 301                                 <button dojoType=\"dijit.form.Button\" onclick=\"return dijit.byId('feedAddDlg').hide()\">".__('Cancel')."</button>
 302                                 </div>";
 303
 304                         //return;
 305                 }
 306
 307                 if ($id == "feedBrowser") {
 308
 309                         $browser_search = db_escape_string($_REQUEST["search"]);
 310
 311 #                       print "<form onsubmit='return false;' display='inline'
 312 #                               name='feed_browser' id='feed_browser'>";
 313
 314                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"op\" value=\"rpc\">";
 315                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"subop\" value=\"updateFeedBrowser\">";
 316
 317                         print "<div dojoType=\"dijit.Toolbar\">
 318                                 <div style='float : right'>
 319                                 <img style='display : none'
 320                                         id='feed_browser_spinner' src='".
 321                                         theme_image($link, 'images/indicator_white.gif')."'>
 322                                 <input name=\"search\" dojoType=\"dijit.form.TextBox\" size=\"20\" type=\"search\"
 323                                         onchange=\"dijit.byId('feedBrowserDlg').update()\" value=\"$browser_search\">
 324                                 <button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('feedBrowserDlg').update()\">".__('Search')."</button>
 325                         </div>";
 326
 327                         print " <select name=\"mode\" dojoType=\"dijit.form.Select\" onchange=\"dijit.byId('feedBrowserDlg').update()\">
 328                                 <option value='1'>" . __('Popular feeds') . "</option>
 329                                 <option value='2'>" . __('Feed archive') . "</option>
 330                                 </select> ";
 331
 332                         print __("limit:");
 333
 334                         print " <select dojoType=\"dijit.form.Select\" name=\"limit\" onchange=\"dijit.byId('feedBrowserDlg').update()\">";
 335
 336                         foreach (array(25, 50, 100, 200) as $l) {
 337                                 $issel = ($l == $limit) ? "selected=\"1\"" : "";
 338                                 print "<option $issel value=\"$l\">$l</option>";
 339                         }
 340
 341                         print "</select> ";
 342
 343                         print "</div>";
 344
 345                         $owner_uid = $_SESSION["uid"];
 346
 347                         print "<ul class='browseFeedList' id='browseFeedList'>";
 348                         print make_feed_browser($link, $search, 25);
 349                         print "</ul>";
 350
 351                         print "<div align='center'>
 352                                 <button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('feedBrowserDlg').execute()\">".__('Subscribe')."</button>
 353                                 <button dojoType=\"dijit.form.Button\" style='display : none' id='feed_archive_remove' onclick=\"dijit.byId('feedBrowserDlg').removeFromArchive()\">".__('Remove')."</button>
 354                                 <button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('feedBrowserDlg').hide()\" >".__('Cancel')."</button></div>";
 355
 356                 }
 357
 358                 if ($id == "search") {
 359
 360                         $params = explode(":", db_escape_string($_REQUEST["param"]), 2);
 361
 362                         $active_feed_id = sprintf("%d", $params[0]);
 363                         $is_cat = $params[1] != "false";
 364
 365                         print "<div class=\"dlgSec\">".__('Look for')."</div>";
 366
 367                         print "<div class=\"dlgSecCont\">";
 368
 369                         if (!SPHINX_ENABLED) {
 370
 371                                 print "<input dojoType=\"dijit.form.ValidationTextBox\"
 372                                         style=\"font-size : 16px; width : 12em;\"
 373                                         required=\"1\" name=\"query\" type=\"search\" value=''>";
 374
 375                                 print " " . __('match on')." ";
 376
 377                                 $search_fields = array(
 378                                         "title" => __("Title"),
 379                                                 "content" => __("Content"),
 380                                         "both" => __("Title or content"));
 381
 382                                 print_select_hash("match_on", 3, $search_fields,
 383                                         'dojoType="dijit.form.Select"');
 384                         } else {
 385                                 print "<input dojoType=\"dijit.form.ValidationTextBox\"
 386                                         style=\"font-size : 16px; width : 20em;\"
 387                                         required=\"1\" name=\"query\" type=\"search\" value=''>";
 388                         }
 389
 390
 391                         print "<hr/>".__('Limit search to:')." ";
 392
 393                         print "<select name=\"search_mode\" dojoType=\"dijit.form.Select\">
 394                                 <option value=\"all_feeds\">".__('All feeds')."</option>";
 395
 396                         $feed_title = getFeedTitle($link, $active_feed_id);
 397
 398                         if (!$is_cat) {
 399                                 $feed_cat_title = getFeedCatTitle($link, $active_feed_id);
 400                         } else {
 401                                 $feed_cat_title = getCategoryTitle($link, $active_feed_id);
 402                         }
 403
 404                         if ($active_feed_id && !$is_cat) {
 405                                 print "<option selected=\"1\" value=\"this_feed\">$feed_title</option>";
 406                         } else {
 407                                 print "<option disabled=\"1\" value=\"false\">".__('This feed')."</option>";
 408                         }
 409
 410                         if ($is_cat) {
 411                                 $cat_preselected = "selected=\"1\"";
 412                         }
 413
 414                         if (get_pref($link, 'ENABLE_FEED_CATS') && ($active_feed_id > 0 || $is_cat)) {
 415                                 print "<option $cat_preselected value=\"this_cat\">$feed_cat_title</option>";
 416                         } else {
 417                                 //print "<option disabled>".__('This category')."</option>";
 418                         }
 419
 420                         print "</select>";
 421
 422                         print "</div>";
 423
 424                         print "<div class=\"dlgButtons\">";
 425
 426                         if (!SPHINX_ENABLED) {
 427                                 print "<div style=\"float : left\">
 428                                         <a class=\"visibleLink\" target=\"_blank\" href=\"http://tt-rss.org/redmine/wiki/tt-rss/SearchSyntax\">Search syntax</a>
 429                                         </div>";
 430                         }
 431
 432                         print "<button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('searchDlg').execute()\">".__('Search')."</button>
 433                         <button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('searchDlg').hide()\">".__('Cancel')."</button>
 434                         </div>";
 435                 }
 436
 437                 if ($id == "quickAddFilter") {
 438
 439                         $active_feed_id = db_escape_string($_REQUEST["param"]);
 440
 441                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"op\" value=\"pref-filters\">";
 442                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"quiet\" value=\"1\">";
 443                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"subop\" value=\"add\">";
 444
 445                         $result = db_query($link, "SELECT id,description
 446                                 FROM ttrss_filter_types ORDER BY description");
 447
 448                         $filter_types = array();
 449
 450                         while ($line = db_fetch_assoc($result)) {
 451                                 //array_push($filter_types, $line["description"]);
 452                                 $filter_types[$line["id"]] = __($line["description"]);
 453                         }
 454
 455                         print "<div class=\"dlgSec\">".__("Match")."</div>";
 456
 457                         print "<div class=\"dlgSecCont\">";
 458
 459                         print "<span id=\"filterDlg_dateModBox\" style=\"display : none\">";
 460
 461                         $filter_params = array(
 462                                 "before" => __("before"),
 463                                 "after" => __("after"));
 464
 465                         print_select_hash("filter_date_modifier", "before",
 466                                 $filter_params, 'dojoType="dijit.form.Select"');
 467
 468                         print "&nbsp;</span>";
 469
 470                         print "<input dojoType=\"dijit.form.ValidationTextBox\"
 471                                  required=\"true\" id=\"filterDlg_regExp\"
 472                                  style=\"font-size : 16px\"
 473                                  name=\"reg_exp\" value=\"$reg_exp\"/>";
 474
 475                         print "<span id=\"filterDlg_dateChkBox\" style=\"display : none\">";
 476                         print "&nbsp;<button dojoType=\"dijit.form.Button\"
 477                                 onclick=\"return filterDlgCheckDate()\">".
 478                                 __('Check it')."</button>";
 479                         print "</span>";
 480
 481                         print "<hr/>" .  __("on field") . " ";
 482                         print_select_hash("filter_type", 1, $filter_types,
 483                                 'onchange="filterDlgCheckType(this)" dojoType="dijit.form.Select"');
 484
 485                         print "<hr/>";
 486
 487                         print __("in") . " ";
 488                         print_feed_select($link, "feed_id", $active_feed_id,
 489                                 'dojoType="dijit.form.FilteringSelect"');
 490
 491                         print "</div>";
 492
 493                         print "<div class=\"dlgSec\">".__("Perform Action")."</div>";
 494
 495                         print "<div class=\"dlgSecCont\">";
 496
 497                         print "<select name=\"action_id\" dojoType=\"dijit.form.Select\"
 498                                 onchange=\"filterDlgCheckAction(this)\">";
 499
 500                         $result = db_query($link, "SELECT id,description FROM ttrss_filter_actions
 501                                 ORDER BY name");
 502
 503                         while ($line = db_fetch_assoc($result)) {
 504                                 printf("<option value='%d'>%s</option>", $line["id"], __($line["description"]));
 505                         }
 506
 507                         print "</select>";
 508
 509                         print "<span id=\"filterDlg_paramBox\" style=\"display : none\">";
 510                         print " " . __("with parameters:") . " ";
 511                         print "<input dojoType=\"dijit.form.TextBox\"
 512                                 id=\"filterDlg_actionParam\"
 513                                 name=\"action_param\">";
 514
 515                         print_label_select($link, "action_param_label", $action_param,
 516                          'id="filterDlg_actionParamLabel" dojoType="dijit.form.Select"');
 517
 518                         print "</span>";
 519
 520                         print "&nbsp;"; // tiny layout hack
 521
 522                         print "</div>";
 523
 524                         print "<div class=\"dlgSec\">".__("Options")."</div>";
 525                         print "<div class=\"dlgSecCont\">";
 526
 527                         print "<input dojoType=\"dijit.form.CheckBox\" type=\"checkbox\" name=\"enabled\" id=\"enabled\" checked=\"1\">
 528                                         <label for=\"enabled\">".__('Enabled')."</label><hr/>";
 529
 530                         print "<input dojoType=\"dijit.form.CheckBox\" type=\"checkbox\" name=\"inverse\" id=\"inverse\">
 531                                 <label for=\"inverse\">".__('Inverse match')."</label>";
 532
 533                         print "</div>";
 534
 535                         print "<div class=\"dlgButtons\">";
 536
 537                         print "<button dojoType=\"dijit.form.Button\" onclick=\"return dijit.byId('filterEditDlg').test()\">".
 538                                 __('Test')."</button> ";
 539
 540                         print "<button dojoType=\"dijit.form.Button\" onclick=\"return dijit.byId('filterEditDlg').execute()\">".
 541                                 __('Create')."</button> ";
 542
 543                         print "<button dojoType=\"dijit.form.Button\" onclick=\"return dijit.byId('filterEditDlg').hide()\">".
 544                                 __('Cancel')."</button>";
 545
 546                         print "</div>";
 547
 548                         //return;
 549                 }
 550
 551                 if ($id == "inactiveFeeds") {
 552
 553                         if (DB_TYPE == "pgsql") {
 554                                 $interval_qpart = "NOW() - INTERVAL '3 months'";
 555                         } else {
 556                                 $interval_qpart = "DATE_SUB(NOW(), INTERVAL 3 MONTH)";
 557                         }
 558
 559                         $result = db_query($link, "SELECT ttrss_feeds.title, ttrss_feeds.site_url,
 560                                         ttrss_feeds.feed_url, ttrss_feeds.id, MAX(updated) AS last_article
 561                                 FROM ttrss_feeds, ttrss_entries, ttrss_user_entries WHERE
 562                                         (SELECT MAX(updated) FROM ttrss_entries, ttrss_user_entries WHERE
 563                                                 ttrss_entries.id = ref_id AND
 564                                                         ttrss_user_entries.feed_id = ttrss_feeds.id) < $interval_qpart
 565                                 AND ttrss_feeds.owner_uid = ".$_SESSION["uid"]." AND
 566                                         ttrss_user_entries.feed_id = ttrss_feeds.id AND
 567                                         ttrss_entries.id = ref_id
 568                                 GROUP BY ttrss_feeds.title, ttrss_feeds.id, ttrss_feeds.site_url, ttrss_feeds.feed_url
 569                                 ORDER BY last_article");
 570
 571                         print __("These feeds have not been updated with new content for 3 months (oldest first):");
 572
 573                         print "<div class=\"inactiveFeedHolder\">";
 574
 575                         print "<table width=\"100%\" cellspacing=\"0\" id=\"prefInactiveFeedList\">";
 576
 577                         $lnum = 1;
 578
 579                         while ($line = db_fetch_assoc($result)) {
 580
 581                                 $class = ($lnum % 2) ? "even" : "odd";
 582                                 $feed_id = $line["id"];
 583                                 $this_row_id = "id=\"FUPDD-$feed_id\"";
 584
 585                                 print "<tr class=\"\" $this_row_id>";
 586
 587                                 $edit_title = htmlspecialchars($line["title"]);
 588
 589                                 print "<td width='5%' align='center'><input
 590                                         onclick='toggleSelectRow2(this);' dojoType=\"dijit.form.CheckBox\"
 591                                         type=\"checkbox\"></td>";
 592                                 print "<td>";
 593
 594                                 print "<a class=\"visibleLink\" href=\"#\" ".
 595                                         "title=\"".__("Click to edit feed")."\" ".
 596                                         "onclick=\"editFeed(".$line["id"].")\">".
 597                                         htmlspecialchars($line["title"])."</a>";
 598
 599                                 print "</td><td class=\"insensitive\" align='right'>";
 600                                 print make_local_datetime($link, $line['last_article'], false);
 601                                 print "</td>";
 602                                 print "</tr>";
 603
 604                                 ++$lnum;
 605                         }
 606
 607                         print "</table>";
 608                         print "</div>";
 609
 610                         print "<div class='dlgButtons'>";
 611                         print "<div style='float : left'>";
 612                         print "<button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('inactiveFeedsDlg').removeSelected()\">"
 613                                 .__('Unsubscribe from selected feeds')."</button> ";
 614                         print "</div>";
 615
 616                         print "<button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('inactiveFeedsDlg').hide()\">".
 617                                 __('Close this window')."</button>";
 618
 619                         print "</div>";
 620
 621                 }
 622
 623                 if ($id == "feedsWithErrors") {
 624
 625 #                       print "<title>".__('Feeds with update errors')."</title>";
 626 #                       print "<content><![CDATA[";
 627
 628                         print __("These feeds have not been updated because of errors:");
 629
 630                         $result = db_query($link, "SELECT id,title,feed_url,last_error,site_url
 631                         FROM ttrss_feeds WHERE last_error != '' AND owner_uid = ".$_SESSION["uid"]);
 632
 633                         print "<div class=\"inactiveFeedHolder\">";
 634
 635                         print "<table width=\"100%\" cellspacing=\"0\" id=\"prefErrorFeedList\">";
 636
 637                         $lnum = 1;
 638
 639                         while ($line = db_fetch_assoc($result)) {
 640
 641                                 $class = ($lnum % 2) ? "even" : "odd";
 642                                 $feed_id = $line["id"];
 643                                 $this_row_id = "id=\"FUPDD-$feed_id\"";
 644
 645                                 print "<tr class=\"\" $this_row_id>";
 646
 647                                 $edit_title = htmlspecialchars($line["title"]);
 648
 649                                 print "<td width='5%' align='center'><input
 650                                         onclick='toggleSelectRow2(this);' dojoType=\"dijit.form.CheckBox\"
 651                                         type=\"checkbox\"></td>";
 652                                 print "<td>";
 653
 654                                 print "<a class=\"visibleLink\" href=\"#\" ".
 655                                         "title=\"".__("Click to edit feed")."\" ".
 656                                         "onclick=\"editFeed(".$line["id"].")\">".
 657                                         htmlspecialchars($line["title"])."</a>: ";
 658
 659                                 print "<span class=\"insensitive\">";
 660                                 print htmlspecialchars($line["last_error"]);
 661                                 print "</span>";
 662
 663                                 print "</td>";
 664                                 print "</tr>";
 665
 666                                 ++$lnum;
 667                         }
 668
 669                         print "</table>";
 670                         print "</div>";
 671
 672                         print "<div class='dlgButtons'>";
 673                         print "<div style='float : left'>";
 674                         print "<button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('errorFeedsDlg').removeSelected()\">"
 675                                 .__('Unsubscribe from selected feeds')."</button> ";
 676                         print "</div>";
 677
 678                         print "<button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('errorFeedsDlg').hide()\">".
 679                                 __('Close this window')."</button>";
 680
 681                         print "</div>";
 682                 }
 683
 684                 if ($id == "editArticleTags") {
 685
 686 #                       print "<form id=\"tag_edit_form\" onsubmit='return false'>";
 687
 688                         print __("Tags for this article (separated by commas):")."<br>";
 689
 690                         $tags = get_article_tags($link, $param);
 691
 692                         $tags_str = join(", ", $tags);
 693
 694                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"id\" value=\"$param\">";
 695                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"op\" value=\"rpc\">";
 696                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"subop\" value=\"setArticleTags\">";
 697
 698                         print "<table width='100%'><tr><td>";
 699
 700                         print "<textarea dojoType=\"dijit.form.SimpleTextarea\" rows='4'
 701                                 style='font-size : 12px; width : 100%' id=\"tags_str\"
 702                                 name='tags_str'>$tags_str</textarea>
 703                         <div class=\"autocomplete\" id=\"tags_choices\"
 704                                         style=\"display:none\"></div>";
 705
 706                         print "</td></tr></table>";
 707
 708 #                       print "</form>";
 709
 710                         print "<div class='dlgButtons'>";
 711
 712                         print "<button dojoType=\"dijit.form.Button\"
 713                                 onclick=\"dijit.byId('editTagsDlg').execute()\">".__('Save')."</button> ";
 714                         print "<button dojoType=\"dijit.form.Button\"
 715                                 onclick=\"dijit.byId('editTagsDlg').hide()\">".__('Cancel')."</button>";
 716                         print "</div>";
 717
 718                 }
 719
 720                 if ($id == "printTagCloud") {
 721                         print "<title>".__('Tag Cloud')."</title>";
 722                         print "<content><![CDATA[";
 723
 724 #                       print __("Showing most popular tags ")." (<a
 725 #                       href='javascript:toggleTags(true)'>".__('more tags')."</a>):<br/>";
 726
 727                         print "<div class=\"tagCloudContainer\">";
 728
 729                         printTagCloud($link);
 730
 731                         print "</div>";
 732
 733                         print "<div align='center'>";
 734                         print "<button dojoType=\"dijit.form.Button\"
 735                                 onclick=\"return closeInfoBox()\">".
 736                                 __('Close this window')."</button>";
 737                         print "</div>";
 738
 739                         print "]]></content>";
 740
 741                         //return;
 742                 }
 743
 744                 if ($id == "emailArticle") {
 745
 746                         $secretkey = sha1(uniqid(rand(), true));
 747
 748                         $_SESSION['email_secretkey'] = $secretkey;
 749
 750                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"secretkey\" value=\"$secretkey\">";
 751                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"op\" value=\"rpc\">";
 752                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"subop\" value=\"sendEmail\">";
 753
 754                         $result = db_query($link, "SELECT email, full_name FROM ttrss_users WHERE
 755                                 id = " . $_SESSION["uid"]);
 756
 757                         $user_email = htmlspecialchars(db_fetch_result($result, 0, "email"));
 758                         $user_name = htmlspecialchars(db_fetch_result($result, 0, "full_name"));
 759
 760                         if (!$user_name) $user_name = $_SESSION['name'];
 761
 762                         $_SESSION['email_replyto'] = $user_email;
 763                         $_SESSION['email_fromname'] = $user_name;
 764
 765                         require_once "lib/MiniTemplator.class.php";
 766
 767                         $tpl = new MiniTemplator;
 768                         $tpl_t = new MiniTemplator;
 769
 770                         $tpl->readTemplateFromFile("templates/email_article_template.txt");
 771
 772                         $tpl->setVariable('USER_NAME', $_SESSION["name"]);
 773                         $tpl->setVariable('USER_EMAIL', $user_email);
 774                         $tpl->setVariable('TTRSS_HOST', $_SERVER["HTTP_HOST"]);
 775
 776 //                      $tpl->addBlock('header');
 777
 778                         $result = db_query($link, "SELECT link, content, title
 779                                 FROM ttrss_user_entries, ttrss_entries WHERE id = ref_id AND
 780                                 id IN ($param) AND owner_uid = " . $_SESSION["uid"]);
 781
 782                         if (db_num_rows($result) > 1) {
 783                                 $subject = __("[Forwarded]") . " " . __("Multiple articles");
 784                         }
 785
 786                         while ($line = db_fetch_assoc($result)) {
 787
 788                                 if (!$subject)
 789                                         $subject = __("[Forwarded]") . " " . htmlspecialchars($line["title"]);
 790
 791                                 $tpl->setVariable('ARTICLE_TITLE', strip_tags($line["title"]));
 792                                 $tpl->setVariable('ARTICLE_URL', strip_tags($line["link"]));
 793
 794                                 $tpl->addBlock('article');
 795                         }
 796
 797                         $tpl->addBlock('email');
 798
 799                         $content = "";
 800                         $tpl->generateOutputToString($content);
 801
 802                         print "<table width='100%'><tr><td>";
 803
 804                         print __('From:');
 805
 806                         print "</td><td>";
 807
 808                         print "<input dojoType=\"dijit.form.TextBox\" disabled=\"1\" style=\"width : 30em;\"
 809                                         value=\"$user_name <$user_email>\">";
 810
 811                         print "</td></tr><tr><td>";
 812
 813                         print __('To:');
 814
 815                         print "</td><td>";
 816
 817                         print "<input dojoType=\"dijit.form.ValidationTextBox\" required=\"true\"
 818                                         style=\"width : 30em;\"
 819                                         name=\"destination\" id=\"emailArticleDlg_destination\">";
 820
 821                         print "<div class=\"autocomplete\" id=\"emailArticleDlg_dst_choices\"
 822                                         style=\"z-index: 30; display : none\"></div>";
 823
 824                         print "</td></tr><tr><td>";
 825
 826                         print __('Subject:');
 827
 828                         print "</td><td>";
 829
 830                         print "<input dojoType=\"dijit.form.ValidationTextBox\" required=\"true\"
 831                                         style=\"width : 30em;\"
 832                                         name=\"subject\" value=\"$subject\" id=\"subject\">";
 833
 834                         print "</td></tr>";
 835
 836                         print "<tr><td colspan='2'><textarea dojoType=\"dijit.form.SimpleTextarea\" style='font-size : 12px; width : 100%' rows=\"20\"
 837                                 name='content'>$content</textarea>";
 838
 839                         print "</td></tr></table>";
 840
 841                         print "<div class='dlgButtons'>";
 842                         print "<button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('emailArticleDlg').execute()\">".__('Send e-mail')."</button> ";
 843                         print "<button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('emailArticleDlg').hide()\">".__('Cancel')."</button>";
 844                         print "</div>";
 845
 846                         //return;
 847                 }
 848
 849                 if ($id == "generatedFeed") {
 850
 851                         print "<title>".__('View as RSS')."</title>";
 852                         print "<content><![CDATA[";
 853
 854                         $params = explode(":", $param, 3);
 855                         $feed_id = db_escape_string($params[0]);
 856                         $is_cat = (bool) $params[1];
 857
 858                         $key = get_feed_access_key($link, $feed_id, $is_cat);
 859
 860                         $url_path = htmlspecialchars($params[2]) . "&key=" . $key;
 861
 862                         print __("You can view this feed as RSS using the following URL:");
 863
 864                         print "<div class=\"tagCloudContainer\">";
 865                         print "<a id='gen_feed_url' href='$url_path' target='_blank'>$url_path</a>";
 866                         print "</div>";
 867
 868                         print "<div align='center'>";
 869
 870                         print "<button dojoType=\"dijit.form.Button\" onclick=\"return genUrlChangeKey('$feed_id', '$is_cat')\">".
 871                                 __('Generate new URL')."</button> ";
 872
 873                         print "<button dojoType=\"dijit.form.Button\" onclick=\"return closeInfoBox()\">".
 874                                 __('Close this window')."</button>";
 875
 876                         print "</div>";
 877                         print "]]></content>";
 878
 879                         //return;
 880                 }
 881
 882                 if ($id == "newVersion") {
 883                         $version_data = check_for_update($link);
 884                         $version = $version_data['version'];
 885                         $id = $version_data['version_id'];
 886
 887                         print "<div class='tagCloudContainer'>";
 888
 889                         print T_sprintf("New version of Tiny Tiny RSS is available (%s).",
 890                                 "<b>$version</b>");
 891
 892                         print "</div>";
 893
 894                         $details = "http://tt-rss.org/redmine/versions/show/$id";
 895                         $download = "http://tt-rss.org/#Download";
 896
 897                         print "<div style='text-align : center'>";
 898                         print "<button dojoType=\"dijit.form.Button\"
 899                                 onclick=\"return window.open('$details')\">".__("Details")."</button>";
 900                         print "<button dojoType=\"dijit.form.Button\"
 901                                 onclick=\"return window.open('$download')\">".__("Download")."</button>";
 902                         print "<button dojoType=\"dijit.form.Button\"
 903                                 onclick=\"return dijit.byId('newVersionDlg').hide()\">".
 904                                 __('Close this window')."</button>";
 905                         print "</div>";
 906
 907                 }
 908
 909                 if ($id == "customizeCSS") {
 910
 911                         $value = get_pref($link, "USER_STYLESHEET");
 912
 913                         $value = str_replace("<br/>", "\n", $value);
 914
 915                         print T_sprintf("You can override colors, fonts and layout of your currently selected theme with custom CSS declarations here. <a target=\"_blank\" class=\"visibleLink\" href=\"%s\">This file</a> can be used as a baseline.", "tt-rss.css");
 916
 917                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"op\" value=\"rpc\">";
 918                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"subop\" value=\"setpref\">";
 919                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"key\" value=\"USER_STYLESHEET\">";
 920
 921                         print "<table width='100%'><tr><td>";
 922                         print "<textarea dojoType=\"dijit.form.SimpleTextarea\"
 923                                 style='font-size : 12px; width : 100%; height: 200px;'
 924                                 placeHolder='body#ttrssMain { font-size : 14px; };'
 925                                 name='value'>$value</textarea>";
 926                         print "</td></tr></table>";
 927
 928                         print "<div class='dlgButtons'>";
 929                         print "<button dojoType=\"dijit.form.Button\"
 930                                 onclick=\"dijit.byId('cssEditDlg').execute()\">".__('Save')."</button> ";
 931                         print "<button dojoType=\"dijit.form.Button\"
 932                                 onclick=\"dijit.byId('cssEditDlg').hide()\">".__('Cancel')."</button>";
 933                         print "</div>";
 934
 935                 }
 936
 937                 if ($id == "editArticleNote") {
 938
 939                         $result = db_query($link, "SELECT note FROM ttrss_user_entries WHERE
 940                                 ref_id = '$param' AND owner_uid = " . $_SESSION['uid']);
 941
 942                         $note = db_fetch_result($result, 0, "note");
 943
 944                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"id\" value=\"$param\">";
 945                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"op\" value=\"rpc\">";
 946                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"subop\" value=\"setNote\">";
 947
 948                         print "<table width='100%'><tr><td>";
 949                         print "<textarea dojoType=\"dijit.form.SimpleTextarea\"
 950                                 style='font-size : 12px; width : 100%; height: 100px;'
 951                                 placeHolder='body#ttrssMain { font-size : 14px; };'
 952                                 name='note'>$note</textarea>";
 953                         print "</td></tr></table>";
 954
 955                         print "<div class='dlgButtons'>";
 956                         print "<button dojoType=\"dijit.form.Button\"
 957                                 onclick=\"dijit.byId('editNoteDlg').execute()\">".__('Save')."</button> ";
 958                         print "<button dojoType=\"dijit.form.Button\"
 959                                 onclick=\"dijit.byId('editNoteDlg').hide()\">".__('Cancel')."</button>";
 960                         print "</div>";
 961
 962                 }
 963
 964                 if ($id == "about") {
 965                         print "<table width='100%'><tr><td align='center'>";
 966                         print "<img src=\"images/logo_big.png\">";
 967                         print "</td>";
 968                         print "<td width='70%'>";
 969
 970                         print "<h1>Tiny Riny RSS</h1>
 971                                 <strong>Version ".VERSION."</strong>
 972                                 <p>Copyright &copy; 2005-".date('Y')."
 973                                 <a target=\"_blank\" class=\"visibleLink\"
 974                                 href=\"http://fakecake.org/\">Andrew Dolgov</a>
 975                                 and other contributors.</p>
 976                                 <p class=\"insensitive\">Licensed under GNU GPL version 2.</p>";
 977
 978                         print "<p class=\"insensitive\">
 979                                 <a class=\"visibleLink\" target=\"_blank\"
 980                                         href=\"http://tt-rss.org/\">Official site</a> &mdash;
 981                                 <a href=\"http://tt-rss.org/redmine/wiki/tt-rss/Donate\"
 982                                 target=\"_blank\" class=\"visibleLink\">
 983                                 Support the project.</a></p>";
 984
 985                         print "</td></tr>";
 986                         print "</table>";
 987
 988                         print "<div align='center'>";
 989                         print "<button dojoType=\"dijit.form.Button\"
 990                                 type=\"submit\">".
 991                                 __('Close this window')."</button>";
 992                         print "</div>";
 993                 }
 994
 995                 if ($id == "addInstance") {
 996
 997                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\"  name=\"op\" value=\"pref-instances\">";
 998                         print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\"  name=\"subop\" value=\"add\">";
 999
1000                         print "<div class=\"dlgSec\">".__("Instance")."</div>";
1001
1002                         print "<div class=\"dlgSecCont\">";
1003
1004                         /* URL */
1005
1006                         print __("URL:") . " ";
1007
1008                         print "<input dojoType=\"dijit.form.ValidationTextBox\" required=\"1\"
1009                                 placeHolder=\"".__("Instance URL")."\"
1010                                 regExp='^(http|https)://.*'
1011                                 style=\"font-size : 16px; width: 20em\" name=\"access_url\">";
1012
1013                         print "<hr/>";
1014
1015                         $access_key = sha1(uniqid(rand(), true));
1016
1017                         /* Access key */
1018
1019                         print __("Access key:") . " ";
1020
1021                         print "<input dojoType=\"dijit.form.ValidationTextBox\" required=\"1\"
1022                                 placeHolder=\"".__("Access key")."\"
1023                                 style=\"width: 20em\" name=\"access_key\" id=\"instance_add_key\"
1024                                 value=\"$access_key\">";
1025
1026                         print "</div>";
1027
1028                         print "<div class=\"dlgButtons\">
1029                                 <div style='float : left'>
1030                                         <button dojoType=\"dijit.form.Button\"
1031                                                 onclick=\"return dijit.byId('instanceAddDlg').regenKey()\">".
1032                                                 __('Generate new key')."</button>
1033                                 </div>
1034                                 <button dojoType=\"dijit.form.Button\"
1035                                         onclick=\"return dijit.byId('instanceAddDlg').execute()\">".
1036                                         __('Create link')."</button>
1037                                 <button dojoType=\"dijit.form.Button\"
1038                                         onclick=\"return dijit.byId('instanceAddDlg').hide()\"\">".
1039                                         __('Cancel')."</button></div>";
1040
1041                         return;
1042
1043
1044
1045
1046                 }
1047
1048                 print "</dlg>";
1049         }
1050 ?>