offline.js

   1 var SCHEMA_VERSION = 9;
   2
   3 var offline_mode = false;
   4 var store = false;
   5 var localServer = false;
   6 var db = false;
   7
   8 function view_offline(id, feed_id) {
   9         try {
  10
  11                 enableHotkeys();
  12                 showArticleInHeadlines(id);
  13
  14                 db.execute("UPDATE articles SET unread = 0 WHERE id = ?", [id]);
  15
  16                 var rs = db.execute("SELECT * FROM articles WHERE id = ?", [id]);
  17
  18                 if (rs.isValidRow()) {
  19
  20                         var tmp = "<div class=\"postReply\">";
  21
  22                         tmp += "<div class=\"postHeader\" onmouseover=\"enable_resize(true)\" "+
  23                                 "onmouseout=\"enable_resize(false)\">";
  24
  25                         tmp += "<div class=\"postDate\">"+rs.fieldByName("updated")+"</div>";
  26
  27                         if (rs.fieldByName("link") != "") {
  28                                 tmp += "<div clear='both'><a target=\"_blank\" "+
  29                                         "href=\"" + rs.fieldByName("link") + "\">" +
  30                                         rs.fieldByName("title") + "</a></div>";
  31                         } else {
  32                                 tmp += "<div clear='both'>" + rs.fieldByName("title") + "</div>";
  33                         }
  34
  35 /*                      tmp += "<div style='float : right'> "+
  36                                 "<img src='images/tag.png' class='tagsPic' alt='Tags' title='Tags'>";
  37                         tmp += rs.fieldByName("tags");
  38                         tmp += "</div>"; */
  39
  40 /*                      tmp += "<div clear='both'>"+
  41                                 "<a target=\"_blank\" "+
  42                                         "href=\"" + rs.fieldByName("comments") + "\">" +
  43                                         __("comments") + "</a></div>"; */
  44
  45                         tmp += "</div>";
  46
  47                         tmp += "<div class=\"postContent\">"
  48                         tmp += rs.fieldByName("content");
  49                         tmp += "</div>";
  50
  51                         tmp += "</div>";
  52
  53                         render_article(tmp);
  54                         update_local_feedlist_counters();
  55                 }
  56
  57                 rs.close();
  58
  59                 return false;
  60
  61         } catch (e) {
  62                 exception_error("view_offline", e);
  63         }
  64 }
  65
  66 function viewfeed_offline(feed_id, subop, is_cat, subop_param, skip_history, offset) {
  67         try {
  68                 notify('');
  69
  70                 if (!offset) offset = 0;
  71
  72                 if (offset > 0) {
  73                         _feed_cur_page = parseInt(offset);
  74                         if (_infscroll_request_sent) {
  75                                 return;
  76                         }
  77                 } else {
  78                         _feed_cur_page = 0;
  79                         _infscroll_disable = 0;
  80                 }
  81
  82                 if (getActiveFeedId() != feed_id) {
  83                         _feed_cur_page = 0;
  84                         active_post_id = 0;
  85                         _infscroll_disable = 0;
  86                 }
  87
  88                 loading_set_progress(100);
  89
  90                 clean_feed_selections();
  91
  92                 setActiveFeedId(feed_id, is_cat);
  93
  94                 if (!is_cat) {
  95                         var feedr = document.getElementById("FEEDR-" + feed_id);
  96                         if (feedr && !feedr.className.match("Selected")) {
  97                                 feedr.className = feedr.className + "Selected";
  98                         }
  99                 } else {
 100                         var feedr = document.getElementById("FCAT-" + feed_id);
 101                         if (feedr && !feedr.className.match("Selected")) {
 102                                 feedr.className = feedr.className + "Selected";
 103                         }
 104                 }
 105
 106                 disableContainerChildren("headlinesToolbar", false);
 107                 Form.enable("main_toolbar_form");
 108
 109                 var f = document.getElementById("headlines-frame");
 110                 try {
 111                         if (reply.offset == 0) {
 112                                 debug("resetting headlines scrollTop");
 113                                 f.scrollTop = 0;
 114                         }
 115                 } catch (e) { };
 116
 117
 118                 var tmp = "";
 119
 120                 var feed_title = get_local_feed_title(feed_id);
 121
 122                 if (feed_title) {
 123
 124                         if (offset == 0) {
 125                                 tmp += "<div id=\"headlinesContainer\">";
 126
 127                                 tmp += "<div class=\"headlinesSubToolbar\">";
 128                                 tmp += "<div id=\"subtoolbar_ftitle\">";
 129                                 tmp += feed_title;
 130                                 tmp += "</div>";
 131
 132                                 var sel_all_link;
 133                                 var sel_unread_link;
 134                                 var sel_none_link;
 135                                 var sel_inv_link;
 136
 137                                 if (document.getElementById("content-frame")) {
 138                                         sel_all_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, '', true)";
 139                                         sel_unread_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, 'Unread', true)";
 140                                         sel_none_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', false)";
 141                                         sel_inv_link = "javascript:invertHeadlineSelection()";
 142                                 } else {
 143                                         sel_all_link = "javascript:cdmSelectArticles('all')";
 144                                         sel_unread_link = "javascript:cdmSelectArticles('unread')";
 145                                         sel_none_link = "javascript:cdmSelectArticles('none')";
 146                                         sel_inv_link = "javascript:invertHeadlineSelection()";
 147                                 }
 148
 149                                 tmp += __('Select:')+
 150                                         " <a href=\""+sel_all_link+"\">"+__('All')+"</a>, "+
 151                                         "<a href=\""+sel_unread_link+"\">"+__('Unread')+"</a>, "+
 152                                         "<a href=\""+sel_inv_link+"\">"+__('Invert')+"</a>, "+
 153                                         "<a href=\""+sel_none_link+"\">"+__('None')+"</a>";
 154
 155                                 tmp += "&nbsp;&nbsp;";
 156
 157                                 tmp += "</div>";
 158
 159                                 tmp += "<div id=\"headlinesInnerContainer\" onscroll=\"headlines_scroll_handler()\">";
 160                                 if (document.getElementById("content-frame")) {
 161                                         tmp += "<table class=\"headlinesList\" id=\"headlinesList\" cellspacing=\"0\">";
 162                                 }
 163
 164                         }
 165
 166                         var limit = 30;
 167
 168                         var toolbar_form = document.forms["main_toolbar_form"];
 169
 170                         var limit = toolbar_form.limit[toolbar_form.limit.selectedIndex].value;
 171                         var view_mode = toolbar_form.view_mode[toolbar_form.view_mode.selectedIndex].value;
 172
 173                         var limit_qpart = "";
 174                         var strategy_qpart = "";
 175                         var mode_qpart = "";
 176                         var offset_qpart = "";
 177
 178                         if (limit != 0) {
 179                                 limit_qpart = "LIMIT " + limit;
 180                         }
 181
 182                         if (view_mode == "all_articles") {
 183                                 mode_qpart = "1";
 184                         } else if (view_mode == "adaptive") {
 185                                 if (get_local_feed_unread(feed_id) > 0) {
 186                                         mode_qpart = "unread = 1";
 187                                 } else {
 188                                         mode_qpart = "1";
 189                                 }
 190                         } else if (view_mode == "marked") {
 191                                 mode_qpart = "marked = 1";
 192                         } else if (view_mode == "unread") {
 193                                 mode_qpart = "unread = 1";
 194                         } else {
 195                                 mode_qpart = "1";
 196                         }
 197
 198                         var ext_tables_qpart = "";
 199
 200                         if (feed_id > 0) {
 201                                 strategy_qpart = "feed_id = " + feed_id;
 202                         } else if (feed_id == -1) {
 203                                 strategy_qpart = "marked = 1";
 204                         } else if (feed_id == -4) {
 205                                 strategy_qpart = "1";
 206                         } else if (feed_id < -10) {
 207                                 var label_id = -11 - feed_id;
 208                                 strategy_qpart = "article_labels.id = articles.id AND label_id = " + label_id;
 209                                 ext_tables_qpart = ",article_labels";
 210                         }
 211
 212                         if (offset > 0) {
 213                                 offset_qpart = "OFFSET " + (offset*30);
 214                         } else {
 215                                 offset_qpart = "";
 216                         }
 217
 218                         var query = "SELECT *,feeds.title AS feed_title "+
 219                                 "FROM articles,feeds"+ext_tables_qpart+" "+
 220                                 "WHERE " +
 221                                 "feed_id = feeds.id AND " +
 222                                 strategy_qpart +
 223                                 " AND " + mode_qpart +
 224                                 " ORDER BY updated DESC "+
 225                                 limit_qpart + " " +
 226                                 offset_qpart;
 227
 228                         var rs = db.execute(query);
 229
 230                         var line_num = offset*30;
 231
 232                         var real_feed_id = feed_id;
 233
 234                         while (rs.isValidRow()) {
 235
 236                                 var id = rs.fieldByName("id");
 237                                 var feed_id = rs.fieldByName("feed_id");
 238
 239                                 var entry_feed_title = false;
 240
 241                                 if (real_feed_id < 0) {
 242                                         entry_feed_title = rs.fieldByName("feed_title");
 243                                 }
 244
 245                                 var marked_pic;
 246
 247                                 var row_class = (line_num % 2) ? "even" : "odd";
 248
 249                                 if (rs.fieldByName("unread") == "1") {
 250                                         row_class += "Unread";
 251                                 }
 252
 253                                 var labels = get_local_article_labels(id);
 254
 255                                 debug(labels);
 256
 257                                 var labels_str = "<span id=\"HLLCTR-"+id+"\">";
 258                                 labels_str += format_article_labels(labels, id);
 259                                 labels_str += "</span>";
 260
 261                                 if (rs.fieldByName("marked") == "1") {
 262                                         marked_pic = "<img id=\"FMPIC-"+id+"\" "+
 263                                                 "src=\"images/mark_set.png\" class=\"markedPic\""+
 264                                                 "alt=\"Unstar article\" onclick='javascript:tMark("+id+")'>";
 265                                 } else {
 266                                         marked_pic = "<img id=\"FMPIC-"+id+"\" "+
 267                                                 "src=\"images/mark_unset.png\" class=\"markedPic\""+
 268                                                 "alt=\"Star article\" onclick='javascript:tMark("+id+")'>";
 269                                 }
 270
 271                                 var mouseover_attrs = "onmouseover='postMouseIn($id)' "+
 272                                         "onmouseout='postMouseOut($id)'";
 273
 274                                 var content_preview = truncate_string(strip_tags(rs.fieldByName("content")),
 275                                                 100);
 276
 277                                 if (document.getElementById("content-frame")) {
 278
 279                                         tmp += "<tr class='"+row_class+"' id='RROW-"+id+"' "+mouseover_attrs+">";
 280
 281                                         tmp += "<td class='hlUpdPic'> </td>";
 282
 283                                         tmp += "<td class='hlSelectRow'>"+
 284                                                 "<input type=\"checkbox\" onclick=\"tSR(this)\" id=\"RCHK-"+id+"\"></td>";
 285
 286                                         tmp += "<td class='hlMarkedPic'>"+marked_pic+"</td>";
 287
 288                                         tmp += "<td onclick='view("+id+","+feed_id+")' "+
 289                                                 "class='hlContent' valign='middle'>";
 290
 291                                         tmp += "<a target=\"_blank\" id=\"RTITLE-"+id+"\" href=\"" +
 292                                                 rs.fieldByName("link") + "\"" +
 293                                                 "onclick=\"return view("+id+","+feed_id+");\">"+
 294                                                 rs.fieldByName("title");
 295
 296                                         tmp += "<span class=\"contentPreview\"> - "+content_preview+"</span>";
 297
 298                                         tmp += "</a>";
 299
 300                                         tmp += labels_str;
 301
 302                                         if (entry_feed_title) {
 303                                                 tmp += " <span class=\"hlFeed\">"+
 304                                                         "(<a href='javascript:viewfeed("+feed_id+
 305                                                         ")'>"+entry_feed_title+"</a>)</span>";
 306                                         }
 307
 308                                         tmp += "</td>";
 309
 310                                         tmp += "<td class=\"hlUpdated\" onclick='view("+id+","+feed_id+")'>"+
 311                                                 "<nobr>"+rs.fieldByName("updated").substring(0,16)+
 312                                                 "</nobr></td>";
 313
 314                                         tmp += "</tr>";
 315                                 } else {
 316
 317                                         var add_class = "";
 318
 319                                         if (rs.fieldByName("unread") == "1") {
 320                                                 add_class = "Unread";
 321                                         }
 322
 323                                         tmp += "<div class=\"cdmArticle"+add_class+"\" id=\"RROW-"+id+"\" "+
 324                                                 mouseover_attrs+"'>";
 325
 326                                         feed_icon_img = "<img class=\"tinyFeedIcon\" src=\""+
 327                                                 getInitParam("icons_url")+"/"+feed_id+".ico\" alt=\"\">";
 328                                         cdm_feed_icon = "<span style=\"cursor : pointer\" "+
 329                                                 "onclick=\"viewfeed("+feed_id+")\">"+feed_icon_img+"</span>";
 330
 331                                         tmp += "<div class=\"cdmHeader\">";
 332                                         tmp += "<div class=\"articleUpdated\">"+
 333                                                 rs.fieldByName("updated").substring(0,16)+
 334                                                 " "+cdm_feed_icon+"</div>";
 335
 336                                         tmp += "<span id=\"RTITLE-"+id+"\" class=\"titleWrap\">"+
 337                                                 "<a class=\"title\" onclick=\"javascript:toggleUnread("+id+", 0)\""+
 338                                                 "target=\"_blank\" href=\""+rs.fieldByName("link")+
 339                                                 "\">"+rs.fieldByName("title")+"</a>";
 340
 341                                         tmp += labels_str;
 342
 343                                         if (entry_feed_title) {
 344                                                 tmp += "&nbsp;(<a href='javascript:viewfeed("+feed_id+
 345                                                         ")'>"+entry_feed_title+"</a>)";
 346                                         }
 347
 348                                         tmp += "</span></div>";
 349
 350                                         tmp += "<div class=\"cdmContent\" onclick=\"cdmClicked("+id+")\""+
 351                                                 "id=\"CICD-"+id+"\">";
 352                                         tmp += rs.fieldByName("content");
 353                                         tmp += "<br clear='both'>"
 354                                         tmp += "</div>";
 355
 356                                         tmp += "<div class=\"cdmFooter\"><span class='s0'>";
 357                                         tmp += __("Select:")+
 358                                                 " <input type=\"checkbox\" "+
 359                                                 "onclick=\"toggleSelectRowById(this, 'RROW-"+id+"')\" "+
 360                                                 "class=\"feedCheckBox\" id=\"RCHK-"+id+"\">";
 361
 362                                         tmp += "</span><span class='s1'>"+marked_pic+"</span> ";
 363
 364 /*                                      tmp += "<span class='s1'>"+
 365                                                 "<img class='tagsPic' src='images/tag.png' alt='Tags' title='Tags'>"+
 366                                                 "<span id=\"ATSTR-"+id+"\">"+rs.fieldByName("tags")+"</span>"+
 367                                                 "</span>"; */
 368
 369                                         tmp += "<span class='s2'>Toggle: <a class=\"cdmToggleLink\""+
 370                                                 "href=\"javascript:toggleUnread("+id+")\">"+
 371                                                 "Unread</a></span>";
 372                                         tmp += "</div>";
 373
 374                                         tmp += "</div>";
 375                                 }
 376
 377                                 rs.next();
 378                                 line_num++;
 379                         }
 380
 381                         if (line_num - offset*30 < 30) {
 382                                 _infscroll_disable = 1;
 383                         }
 384
 385                         rs.close();
 386
 387                         if (offset == 0) {
 388                                 tmp += "</table>";
 389
 390                                 if (line_num - offset*30 == 0) {
 391                                         tmp += "<div class='whiteBox'>" +
 392                                                 __("No articles found to display.") +
 393                                                 "</div>";
 394                                 }
 395                                 tmp += "</div></div>";
 396                         }
 397
 398                         if (offset == 0) {
 399                                 var container = document.getElementById("headlines-frame");
 400                                 container.innerHTML = tmp;
 401                         } else {
 402                                 var ids = getSelectedArticleIds2();
 403
 404                                 var container = document.getElementById("headlinesList");
 405                                 container.innerHTML = container.innerHTML + tmp;
 406
 407                                 for (var i = 0; i < ids.length; i++) {
 408                                         markHeadline(ids[i]);
 409                                 }
 410                         }
 411                 }
 412
 413                 remove_splash();
 414
 415                 _infscroll_request_sent = 0;
 416
 417         } catch (e) {
 418                 exception_error("viewfeed_offline", e);
 419         }
 420 }
 421
 422 function render_offline_feedlist() {
 423         try {
 424                 var cats_enabled = getInitParam("enable_feed_cats") == "1";
 425
 426                 var tmp = "<ul class=\"feedList\" id=\"feedList\">";
 427
 428                 var unread = get_local_feed_unread(-4);
 429
 430                 global_unread = unread;
 431                 updateTitle();
 432
 433                 if (cats_enabled) {
 434                         tmp += printCategoryHeader(-1, is_local_cat_collapsed(-1), false);
 435                 }
 436
 437                 tmp += printFeedEntry(-4, __("All articles"), "feed", unread,
 438                         "images/tag.png");
 439
 440                 var unread = get_local_feed_unread(-1);
 441
 442                 tmp += printFeedEntry(-1, __("Starred articles"), "feed", unread,
 443                         "images/mark_set.png");
 444
 445                 if (cats_enabled) {
 446                         tmp += "</ul></li>";
 447                 } else {
 448                         tmp += "<li><hr/></li>";
 449                 }
 450
 451                 if (cats_enabled) {
 452                         tmp += printCategoryHeader(-2, is_local_cat_collapsed(-2), false);
 453                 }
 454
 455                 var rs = db.execute("SELECT id,caption "+
 456                         "FROM labels "+
 457                         "ORDER BY caption");
 458
 459                 while (rs.isValidRow()) {
 460                         var id = -11 - parseInt(rs.field(0));
 461                         var caption = rs.field(1);
 462                         var unread = get_local_feed_unread(id);
 463
 464                         tmp += printFeedEntry(id, caption, "feed", unread,
 465                                 "images/label.png");
 466
 467                         rs.next();
 468                 }
 469
 470                 rs.close();
 471
 472                 if (cats_enabled) {
 473                         tmp += "</ul></li>";
 474                 } else {
 475                         tmp += "<li><hr/></li>";
 476                 }
 477
 478 /*              var rs = db.execute("SELECT feeds.id,feeds.title,has_icon,COUNT(articles.id) "+
 479                         "FROM feeds LEFT JOIN articles ON (feed_id = feeds.id) "+
 480                         "WHERE unread = 1 OR unread IS NULL GROUP BY feeds.id "+
 481                         "ORDER BY feeds.title"); */
 482
 483                 var order_by = "feeds.title";
 484
 485                 if (cats_enabled) order_by = "categories.title," + order_by;
 486
 487                 var rs = db.execute("SELECT "+
 488                         "feeds.id,feeds.title,has_icon,cat_id,collapsed "+
 489                         "FROM feeds,categories WHERE cat_id = categories.id "+
 490                         "ORDER BY "+order_by);
 491
 492                 var tmp_cat_id = -1;
 493
 494                 while (rs.isValidRow()) {
 495
 496                         var id = rs.field(0);
 497                         var title = rs.field(1);
 498                         var has_icon = rs.field(2);
 499                         var unread = get_local_feed_unread(id);
 500                         var cat_id = rs.field(3);
 501                         var cat_hidden = rs.field(4);
 502
 503                         if (cat_id != tmp_cat_id && cats_enabled) {
 504                                 if (tmp_cat_id != -1) {
 505                                         tmp += "</ul></li>";
 506                                 }
 507                                 tmp += printCategoryHeader(cat_id, cat_hidden, false);
 508                                 tmp_cat_id = cat_id;
 509                         }
 510
 511                         var icon = "";
 512
 513                         if (has_icon) {
 514                                 icon = "icons/" + id + ".ico";
 515                         }
 516
 517                         var feed_icon = "";
 518
 519                         var row_class = "feed";
 520
 521                         if (unread > 0) {
 522                                 row_class += "Unread";
 523                                 fctr_class = "feedCtrHasUnread";
 524                         } else {
 525                                 fctr_class = "feedCtrNoUnread";
 526                         }
 527
 528                         tmp += printFeedEntry(id, title, "feed", unread, icon);
 529
 530                         rs.next();
 531                 }
 532
 533                 rs.close();
 534
 535                 if (cats_enabled) {
 536                         tmp += "</ul>";
 537                 }
 538
 539                 tmp += "</ul>";
 540
 541                 render_feedlist(tmp);
 542         } catch (e) {
 543                 exception_error("render_offline_feedlist", e);
 544         }
 545 }
 546
 547 function init_offline() {
 548         try {
 549                 offline_mode = true;
 550
 551                 Element.hide("dispSwitchPrompt");
 552                 Element.hide("feedBrowserPrompt");
 553
 554                 Element.hide("topLinksOnline");
 555                 Element.show("topLinksOffline");
 556
 557                 var tb_form = document.getElementById("main_toolbar_form");
 558                 Element.hide(tb_form.update);
 559
 560                 var chooser = document.getElementById("quickMenuChooser");
 561                 chooser.disabled = true;
 562
 563                 var rs = db.execute("SELECT key, value FROM init_params");
 564
 565                 while (rs.isValidRow()) {
 566                         init_params[rs.field(0)] = rs.field(1);
 567                         rs.next();
 568                 }
 569
 570                 rs.close();
 571
 572                 var rs = db.execute("SELECT COUNT(*) FROM feeds");
 573
 574                 var num_feeds = 0;
 575
 576                 if (rs.isValidRow()) {
 577                         num_feeds = rs.field(0);
 578                 }
 579
 580                 rs.close();
 581
 582                 if (num_feeds == 0) {
 583                         remove_splash();
 584                         return fatalError(0,
 585                                 __("Data for offline browsing has not been downloaded yet."));
 586                 }
 587
 588                 render_offline_feedlist();
 589                 init_second_stage();
 590                 window.setTimeout("viewfeed(-4)", 50);
 591
 592         } catch (e) {
 593                 exception_error("init_offline", e);
 594         }
 595 }
 596
 597 function offline_download_parse(stage, transport) {
 598         try {
 599                 if (transport.responseXML) {
 600
 601                         if (stage == 0) {
 602
 603                                 var feeds = transport.responseXML.getElementsByTagName("feed");
 604
 605                                 if (feeds.length > 0) {
 606                                         db.execute("DELETE FROM feeds");
 607                                 }
 608
 609                                 for (var i = 0; i < feeds.length; i++) {
 610                                         var id = feeds[i].getAttribute("id");
 611                                         var has_icon = feeds[i].getAttribute("has_icon");
 612                                         var title = feeds[i].firstChild.nodeValue;
 613                                         var cat_id = feeds[i].getAttribute("cat_id");
 614
 615                                         db.execute("INSERT INTO feeds (id,title,has_icon,cat_id)"+
 616                                                 "VALUES (?,?,?,?)",
 617                                                 [id, title, has_icon, cat_id]);
 618                                 }
 619
 620                                 var cats = transport.responseXML.getElementsByTagName("category");
 621
 622                                 if (feeds.length > 0) {
 623                                         db.execute("DELETE FROM categories");
 624                                 }
 625
 626                                 for (var i = 0; i < cats.length; i++) {
 627                                         var id = cats[i].getAttribute("id");
 628                                         var collapsed = cats[i].getAttribute("collapsed");
 629                                         var title = cats[i].firstChild.nodeValue;
 630
 631                                         db.execute("INSERT INTO categories (id,title,collapsed)"+
 632                                                 "VALUES (?,?,?)",
 633                                                 [id, title, collapsed]);
 634                                 }
 635
 636                                 var labels = transport.responseXML.getElementsByTagName("label");
 637
 638                                 if (labels.length > 0) {
 639                                         db.execute("DELETE FROM labels");
 640                                 }
 641
 642                                 for (var i = 0; i < labels.length; i++) {
 643                                         var id = labels[i].getAttribute("id");
 644                                         var fg_color = labels[i].getAttribute("fg_color");
 645                                         var bg_color = labels[i].getAttribute("bg_color");
 646                                         var caption = labels[i].firstChild.nodeValue;
 647
 648                                         db.execute("INSERT INTO labels (id,caption,fg_color,bg_color)"+
 649                                                 "VALUES (?,?,?,?)",
 650                                                 [id, caption, fg_color, bg_color]);
 651                                 }
 652
 653                                 window.setTimeout("update_offline_data("+(stage+1)+")", 10*1000);
 654                         } else {
 655
 656                                 var articles = transport.responseXML.getElementsByTagName("article");
 657
 658                                 var limit = transport.responseXML.getElementsByTagName("limit")[0];
 659
 660                                 if (limit) {
 661                                         limit = limit.getAttribute("value");
 662                                 } else {
 663                                         limit = 0;
 664                                 }
 665
 666                                 var articles_found = 0;
 667
 668                                 for (var i = 0; i < articles.length; i++) {
 669                                         var a = eval("("+articles[i].firstChild.nodeValue+")");
 670                                         articles_found++;
 671                                         if (a) {
 672
 673                                                 db.execute("DELETE FROM articles WHERE id = ?", [a.id]);
 674
 675                                                 db.execute("INSERT INTO articles "+
 676                                                 "(id, feed_id, title, link, guid, updated, content, "+
 677                                                         "unread, marked, tags, comments) "+
 678                                                 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
 679                                                         [a.id, a.feed_id, a.title, a.link, a.guid, a.updated,
 680                                                                 a.content, a.unread, a.marked, a.tags,
 681                                                                 a.comments]);
 682
 683                                                 if (a.labels.length > 0) {
 684                                                         for (var j = 0; j < a.labels.length; j++) {
 685                                                                 label_local_add_article(a.id, a.labels[j][0]);
 686                                                         }
 687                                                 }
 688
 689                                         }
 690                                 }
 691
 692                                 debug("downloaded articles: " + articles_found + " limit: " + limit);
 693
 694                                 if (articles_found >= limit) {
 695                                         window.setTimeout("update_offline_data("+(stage+1)+")", 10*1000);
 696                                         debug("update_offline_data: done " + stage);
 697                                 } else {
 698                                         window.setTimeout("update_offline_data(0)", 1800*1000);
 699                                         debug("update_offline_data: finished");
 700
 701                                         db.execute("DELETE FROM articles WHERE "+
 702                                                 "updated < DATETIME('NOW', 'localtime', '-31 days')");
 703
 704                                 }
 705
 706                                 update_local_sync_data();
 707                         }
 708
 709 //                      notify('');
 710
 711                 }
 712         } catch (e) {
 713                 exception_error("offline_download_parse", e);
 714         }
 715 }
 716
 717 function update_offline_data(stage) {
 718         try {
 719
 720                 if (!stage) stage = 0;
 721                 if (offline_mode) return;
 722
 723                 debug("update_offline_data: stage " + stage);
 724
 725 //              notify_progress("Updating offline data... (" + stage +")", true);
 726
 727                 var query = "backend.php?op=rpc&subop=download&stage=" + stage;
 728
 729                 var rs = db.execute("SELECT MAX(id), MIN(id) FROM articles");
 730
 731                 if (rs.isValidRow() && rs.field(0)) {
 732                         var offline_dl_max_id = rs.field(0);
 733                         var offline_dl_min_id = rs.field(1);
 734
 735                         query = query + "&cidt=" + offline_dl_max_id;
 736                         query = query + "&cidb=" + offline_dl_min_id;
 737                 }
 738
 739                 rs.close();
 740
 741                 new Ajax.Request(query, {
 742                         onComplete: function(transport) {
 743                                 offline_download_parse(stage, transport);
 744                         } });
 745
 746         } catch (e) {
 747                 exception_error("initiate_offline_download", e);
 748         }
 749 }
 750
 751 function set_feedlist_counter(id, ctr, is_cat) {
 752         try {
 753
 754                 var feedctr = document.getElementById("FEEDCTR-" + id);
 755                 var feedu = document.getElementById("FEEDU-" + id);
 756                 var feedr = document.getElementById("FEEDR-" + id);
 757
 758                 if (is_cat) {
 759                         var catctr = document.getElementById("FCATCTR-" + id);
 760                         if (catctr) {
 761                                 catctr.innerHTML = "(" + ctr + ")";
 762                                 if (ctr > 0) {
 763                                         catctr.className = "catCtrHasUnread";
 764                                 } else {
 765                                         catctr.className = "catCtrNoUnread";
 766                                 }
 767                         }
 768                 } else if (feedctr && feedu && feedr) {
 769
 770                         var row_needs_hl = (ctr > 0 && ctr > parseInt(feedu.innerHTML));
 771
 772                         feedu.innerHTML = ctr;
 773
 774                         if (ctr > 0) {
 775                                 feedctr.className = "feedCtrHasUnread";
 776                                 if (!feedr.className.match("Unread")) {
 777                                         var is_selected = feedr.className.match("Selected");
 778
 779                                         feedr.className = feedr.className.replace("Selected", "");
 780                                         feedr.className = feedr.className.replace("Unread", "");
 781
 782                                         feedr.className = feedr.className + "Unread";
 783
 784                                         if (is_selected) {
 785                                                 feedr.className = feedr.className + "Selected";
 786                                         }
 787
 788                                 }
 789
 790                                 if (row_needs_hl) {
 791                                         new Effect.Highlight(feedr, {duration: 1, startcolor: "#fff7d5",
 792                                                 queue: { position:'end', scope: 'EFQ-' + id, limit: 1 } } );
 793                                 }
 794                         } else {
 795                                 feedctr.className = "feedCtrNoUnread";
 796                                 feedr.className = feedr.className.replace("Unread", "");
 797                         }
 798                 }
 799
 800         } catch (e) {
 801                 exception_error("set_feedlist_counter", e);
 802         }
 803 }
 804
 805 function update_local_feedlist_counters() {
 806         try {
 807                 if (!offline_mode) return;
 808
 809 /*              var rs = db.execute("SELECT feeds.id,COUNT(articles.id) "+
 810                         "FROM feeds LEFT JOIN articles ON (feed_id = feeds.id) "+
 811                         "WHERE unread = 1 OR unread IS NULL GROUP BY feeds.id "+
 812                         "ORDER BY feeds.title"); */
 813
 814                 var rs = db.execute("SELECT id FROM feeds "+
 815                         "ORDER BY title");
 816
 817                 while (rs.isValidRow()) {
 818                         var id = rs.field(0);
 819                         var ctr = get_local_feed_unread(id);
 820                         set_feedlist_counter(id, ctr, false);
 821                         rs.next();
 822                 }
 823
 824                 rs.close();
 825
 826                 var rs = db.execute("SELECT cat_id,SUM(unread) "+
 827                         "FROM articles, feeds WHERE feeds.id = feed_id GROUP BY cat_id");
 828
 829                 while (rs.isValidRow()) {
 830                         var id = rs.field(0);
 831                         var ctr = rs.field(1);
 832                         set_feedlist_counter(id, ctr, true);
 833                         rs.next();
 834                 }
 835
 836                 rs.close();
 837
 838                 set_feedlist_counter(-2, get_local_category_unread(-2), true);
 839
 840                 set_feedlist_counter(-4, get_local_feed_unread(-4));
 841                 set_feedlist_counter(-1, get_local_feed_unread(-1));
 842
 843                 var rs = db.execute("SELECT id FROM labels");
 844
 845                 while (rs.isValidRow()) {
 846                         var id = -11 - rs.field(0);
 847                         var ctr = get_local_feed_unread(id);
 848                         set_feedlist_counter(id, ctr, false);
 849                         rs.next();
 850                 }
 851
 852                 rs.close();
 853
 854                 hideOrShowFeeds(getInitParam("hide_read_feeds") == 1);
 855
 856                 global_unread = get_local_feed_unread(-4);
 857                 updateTitle();
 858
 859         } catch (e) {
 860                 exception_error("update_local_feedlist_counters", e);
 861         }
 862 }
 863
 864 function get_local_feed_unread(id) {
 865         try {
 866                 var rs;
 867
 868                 if (id == -4) {
 869                         rs = db.execute("SELECT SUM(unread) FROM articles");
 870                 } else if (id == -1) {
 871                         rs = db.execute("SELECT SUM(unread) FROM articles WHERE marked = 1");
 872                 } else if (id > 0) {
 873                         rs = db.execute("SELECT SUM(unread) FROM articles WHERE feed_id = ?", [id]);
 874                 } else if (id < -10) {
 875                         var label_id = -11 - id;
 876                         rs = db.execute("SELECT SUM(unread) FROM articles,article_labels "+
 877                                 "WHERE article_labels.id = articles.id AND label_id = ?", [label_id]);
 878                 }
 879
 880                 var a = false;
 881
 882                 if (rs.isValidRow()) {
 883                         a = rs.field(0);
 884                 } else {
 885                         a = 0;
 886                 }
 887
 888                 rs.close();
 889
 890                 return a;
 891
 892         } catch (e) {
 893                 exception_error("get_local_feed_unread", e);
 894         }
 895 }
 896
 897 function init_gears() {
 898         try {
 899
 900                 if (window.google && google.gears) {
 901                         localServer = google.gears.factory.create("beta.localserver");
 902                         store = localServer.createManagedStore("tt-rss");
 903                         db = google.gears.factory.create('beta.database');
 904                         db.open('tt-rss');
 905
 906                         db.execute("CREATE TABLE IF NOT EXISTS version (schema_version text)");
 907
 908                         var rs = db.execute("SELECT schema_version FROM version");
 909
 910                         var version = "";
 911
 912                         if (rs.isValidRow()) {
 913                                 version = rs.field(0);
 914                         }
 915
 916                         rs.close();
 917
 918                         if (version != SCHEMA_VERSION) {
 919                                 db.execute("DROP TABLE IF EXISTS init_params");
 920                                 db.execute("DROP TABLE IF EXISTS cache");
 921                                 db.execute("DROP TABLE IF EXISTS feeds");
 922                                 db.execute("DROP TABLE IF EXISTS categories");
 923                                 db.execute("DROP TABLE IF EXISTS labels");
 924                                 db.execute("DROP TABLE IF EXISTS article_labels");
 925                                 db.execute("DROP TABLE IF EXISTS articles");
 926                                 db.execute("DROP INDEX IF EXISTS article_labels_label_id_idx");
 927                                 db.execute("DROP INDEX IF EXISTS articles_unread_idx");
 928                                 db.execute("DROP INDEX IF EXISTS articles_feed_id_idx");
 929                                 db.execute("DROP TABLE IF EXISTS version");
 930                                 db.execute("DROP TRIGGER IF EXISTS articles_update_unread");
 931                                 db.execute("DROP TRIGGER IF EXISTS articles_update_marked");
 932                                 db.execute("DROP TRIGGER IF EXISTS articles_remove_labelrefs");
 933                                 db.execute("CREATE TABLE IF NOT EXISTS version (schema_version text)");
 934                                 db.execute("DROP TABLE IF EXISTS syncdata");
 935                                 db.execute("INSERT INTO version (schema_version) VALUES (?)",
 936                                         [SCHEMA_VERSION]);
 937                         }
 938
 939                         db.execute("CREATE TABLE IF NOT EXISTS init_params (key text PRIMARY KEY, value text)");
 940
 941                         db.execute("CREATE TABLE IF NOT EXISTS cache (id PRIMARY KEY, article text, param text, added text)");
 942                         db.execute("CREATE TABLE IF NOT EXISTS feeds (id PRIMARY KEY, title text, has_icon integer, cat_id integer)");
 943                         db.execute("CREATE TABLE IF NOT EXISTS categories (id PRIMARY KEY, title text, collapsed integer)");
 944                         db.execute("CREATE TABLE IF NOT EXISTS labels (id PRIMARY KEY, caption text, fg_color text, bg_color text)");
 945                         db.execute("CREATE TABLE IF NOT EXISTS article_labels (id integer, label_id integer)");
 946                         db.execute("CREATE TABLE IF NOT EXISTS articles (id integer, feed_id integer, title text, link text, guid text, updated timestamp, content text, tags text, unread integer, marked integer, added text, modified timestamp, comments text)");
 947
 948                         db.execute("CREATE INDEX IF NOT EXISTS articles_unread_idx ON articles(unread)");
 949                         db.execute("CREATE INDEX IF NOT EXISTS article_labels_label_id_idx ON article_labels(label_id)");
 950                         db.execute("CREATE INDEX IF NOT EXISTS articles_feed_id_idx ON articles(feed_id)");
 951
 952                         db.execute("CREATE TABLE IF NOT EXISTS syncdata (key PRIMARY KEY, value text)");
 953
 954                         db.execute("DELETE FROM cache WHERE id LIKE 'F:%' OR id LIKE 'C:%'");
 955
 956                         db.execute("CREATE TRIGGER IF NOT EXISTS articles_update_unread "+
 957                                 "UPDATE OF unread ON articles "+
 958                                 "BEGIN "+
 959                                 "UPDATE articles SET modified = DATETIME('NOW', 'localtime') "+
 960                                 "WHERE id = OLD.id AND "+
 961                                 "OLD.unread != NEW.unread;"+
 962                                 "END;");
 963
 964                         db.execute("CREATE TRIGGER IF NOT EXISTS articles_update_marked "+
 965                                 "UPDATE OF marked ON articles "+
 966                                 "BEGIN "+
 967                                 "UPDATE articles SET modified = DATETIME('NOW', 'localtime') "+
 968                                 "WHERE id = OLD.id;"+
 969                                 "END;");
 970
 971                         db.execute("CREATE TRIGGER IF NOT EXISTS articles_remove_labelrefs "+
 972                                 "DELETE ON articles "+
 973                                 "BEGIN "+
 974                                 "DELETE FROM article_labels WHERE id = OLD.id; "+
 975                                 "END; ");
 976
 977                         init_local_sync_data();
 978
 979                         Element.show("restartOfflinePic");
 980
 981                 }
 982
 983                 cache_expire();
 984
 985         } catch (e) {
 986                 exception_error("init_gears", e);
 987         }
 988 }
 989
 990 function gotoOffline() {
 991         window.location.href = "tt-rss.php?offline=1";
 992 }
 993
 994 function gotoOnline() {
 995         window.location.href = "tt-rss.php";
 996 }
 997
 998 function local_collapse_cat(id) {
 999         try {
1000                 if (db) {
1001                         db.execute("UPDATE categories SET collapsed = NOT collapsed WHERE id = ?",
1002                                 [id]);
1003                 }
1004         } catch (e) {
1005                 exception_error("local_collapse_cat", e);
1006         }
1007 }
1008
1009 function get_local_category_title(id) {
1010         try {
1011                 var rs = db.execute("SELECT title FROM categories WHERE id = ?", [id]);
1012                 var tmp = "";
1013
1014                 if (rs.isValidRow()) {
1015                         tmp = rs.field(0);
1016                 }
1017
1018                 rs.close();
1019
1020                 return tmp;
1021
1022         } catch (e) {
1023                 exception_error("get_local_category_title", e);
1024         }
1025 }
1026
1027 function get_local_category_unread(id) {
1028         try {
1029                 var rs = false;
1030
1031                 if (id >= 0) {
1032                         rs = db.execute("SELECT SUM(unread) FROM articles, feeds "+
1033                                 "WHERE feeds.id = feed_id AND cat_id = ?", [id]);
1034                 } else if (id == -2) {
1035                         rs = db.execute("SELECT SUM(unread) FROM article_labels, articles "+
1036                                 "where article_labels.id = articles.id");
1037                 } else {
1038                         return 0;
1039                 }
1040
1041                 var tmp = 0;
1042
1043                 if (rs.isValidRow()) {
1044                         tmp = rs.field(0);
1045                 }
1046
1047                 rs.close();
1048
1049                 return tmp;
1050
1051         } catch (e) {
1052                 exception_error("get_local_category_unread", e);
1053         }
1054 }
1055
1056 function printCategoryHeader(cat_id, hidden, can_browse) {
1057         try {
1058                 if (hidden == undefined) hidden = false;
1059                 if (can_browse == undefined) can_browse = false;
1060
1061                         var tmp_category = get_local_category_title(cat_id);
1062                         var tmp = "";
1063
1064                         var cat_unread = get_local_category_unread(cat_id);
1065
1066                         var holder_style = "";
1067                         var ellipsis = "";
1068
1069                         if (hidden) {
1070                                 holder_style = "display:none;";
1071                                 ellipsis = "…";
1072                         }
1073
1074                         var catctr_class = (cat_unread > 0) ? "catCtrHasUnread" : "catCtrNoUnread";
1075
1076                         var browse_cat_link = "";
1077                         var inner_title_class = "catTitleNL";
1078
1079                         if (can_browse) {
1080                                 browse_cat_link = "onclick=\"javascript:viewCategory($cat_id)\"";
1081                                 inner_title_class = "catTitle";
1082                         }
1083
1084                         var cat_class = "feedCat";
1085
1086                         tmp += "<li class=\""+cat_class+"\" id=\"FCAT-"+cat_id+"\">"+
1087                                 "<img onclick=\"toggleCollapseCat("+cat_id+")\" class=\"catCollapse\""+
1088                                         " title=\""+__('Click to collapse category')+"\""+
1089                                         " src=\"images/cat-collapse.png\"><span class=\""+inner_title_class+"\" "+
1090                                         " id=\"FCATN-"+cat_id+"\" "+browse_cat_link+
1091                                 "\">"+tmp_category+"</span>";
1092
1093                         tmp += "<span id=\"FCAP-"+cat_id+"\">";
1094
1095                         tmp += " <span id=\"FCATCTR-"+cat_id+"\" "+
1096                                 "class=\""+catctr_class+"\">("+cat_unread+")</span> "+ellipsis;
1097
1098                         tmp += "</span>";
1099
1100                         tmp += "<ul class=\"feedCatList\" id=\"FCATLIST-"+cat_id+"\" "+
1101                                 "style='"+holder_style+"'>";
1102
1103                         return tmp;
1104         } catch (e) {
1105                 exception_error("printCategoryHeader", e);
1106         }
1107 }
1108
1109 function is_local_cat_collapsed(id) {
1110         try {
1111
1112                 var rs = db.execute("SELECT collapsed FROM categories WHERE id = ?", [id]);
1113                 var cat_hidden = 0;
1114
1115                 if (rs.isValidRow()) {
1116                         cat_hidden = rs.field(0);
1117                 }
1118
1119                 rs.close();
1120
1121                 return cat_hidden == "1";
1122
1123         } catch (e) {
1124                 exception_error("is_local_cat_collapsed", e);
1125         }
1126 }
1127
1128 function get_local_article_labels(id) {
1129         try {
1130                 var rs = db.execute("SELECT DISTINCT label_id,caption,fg_color,bg_color "+
1131                         "FROM labels, article_labels "+
1132                         "WHERE labels.id = label_id AND article_labels.id = ?", [id]);
1133
1134                 var tmp = new Array();
1135
1136                 while (rs.isValidRow()) {
1137                         var e = new Array();
1138
1139                         e[0] = rs.field(0);
1140                         e[1] = rs.field(1);
1141                         e[2] = rs.field(2);
1142                         e[3] = rs.field(3);
1143
1144                         tmp.push(e);
1145
1146                         rs.next();
1147                 }
1148
1149                 return tmp;
1150
1151         } catch (e) {
1152                 exception_error("get_local_article_labels", e);
1153         }
1154 }
1155
1156 function label_local_add_article(id, label_id) {
1157         try {
1158                 //debug("label_local_add_article " + id + " => " + label_id);
1159
1160                 var rs = db.execute("SELECT COUNT(id) FROM article_labels WHERE "+
1161                         "id = ? AND label_id = ?", [id, label_id]);
1162                 var check = rs.field(0);
1163
1164                 if (rs.isValidRow()) {
1165                         var check = rs.field(0);
1166                 }
1167                 rs.close();
1168
1169                 if (check == 0) {
1170                         db.execute("INSERT INTO article_labels (id, label_id) VALUES "+
1171                                 "(?,?)", [id, label_id]);
1172                 }
1173
1174         } catch (e) {
1175                 exception_error("label_local_add_article", e);
1176         }
1177 }
1178
1179 function get_local_feed_title(id) {
1180         try {
1181
1182                 var feed_title = "Unknown feed: " + id;
1183
1184                 if (id > 0) {
1185                         var rs = db.execute("SELECT title FROM feeds WHERE id = ?", [id]);
1186
1187                         if (rs.isValidRow()) {
1188                                 feed_title = rs.field(0);
1189                         }
1190
1191                         rs.close();
1192                 } else if (id == -1) {
1193                         feed_title = __("Starred articles");
1194                 } else if (id == -4) {
1195                         feed_title = __("All articles");
1196                 } else if (id < -10) {
1197
1198                         var label_id = -11 - id;
1199
1200                         var rs = db.execute("SELECT caption FROM labels WHERE id = ?", [label_id]);
1201
1202                         if (rs.isValidRow()) {
1203                                 feed_title = rs.field(0);
1204                         }
1205
1206                         rs.close();
1207                 }
1208
1209                 return feed_title;
1210
1211         } catch (e) {
1212                 exception_error("get_local_feed_title", e);
1213         }
1214 }
1215
1216 function format_article_labels(labels, id) {
1217         try {
1218
1219                 var labels_str = "";
1220
1221                 if (!labels) return "";
1222
1223                 for (var i = 0; i < labels.length; i++) {
1224                         var l = labels[i];
1225
1226                         labels_str += "<span class='hlLabelRef' "+
1227                                 "style='color : "+l[2]+"; background-color : "+l[3]+"'>"+l[1]+"</span>";
1228                 }
1229
1230                 return labels_str;
1231
1232         } catch (e) {
1233                 exception_error("format_article_labels", e);
1234         }
1235 }
1236
1237 function init_local_sync_data() {
1238         try {
1239                 var rs = db.execute("SELECT COUNT(*) FROM syncdata WHERE key = 'last_online'");
1240                 var has_last_online = 0;
1241
1242                 if (rs.isValidRow()) {
1243                         has_last_online = rs.field(0);
1244                 }
1245
1246                 rs.close();
1247
1248                 if (!has_last_online) {
1249                         db.execute("INSERT INTO syncdata (key, value) VALUES ('last_online', '')");
1250                 }
1251
1252         } catch (e) {
1253                 exception_error("init_local_sync_data", e);
1254
1255         }
1256 }
1257
1258 function update_local_sync_data() {
1259         try {
1260                 if (db && !offline_mode) {
1261                         db.execute("UPDATE syncdata SET value = DATETIME('NOW', 'localtime') "+
1262                                 "WHERE key = 'last_online'");
1263
1264                 }
1265         } catch (e) {
1266                 exception_error("update_local_sync_data", e);
1267         }
1268 }