classes/dlg.php

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