Changeset 1524 for branches/multiuser

Timestamp:

08/05/06 11:53:58 (2 years ago)

Author:

mbonetti

Message:

first mu checkin

Location:

branches/multiuser

Files:

• ajax.php (modified) (1 diff)
• cls/channels.php (modified) (3 diffs)
• cls/items.php (modified) (7 diffs)
• cls/update.php (modified) (4 diffs)
• cls/user.php (modified) (1 diff)
• cls/wrappers/user.php (modified) (1 diff)
• constants.php (modified) (1 diff)
• feed.php (modified) (11 diffs)
• index.php (modified) (4 diffs)
• schema.php (modified) (5 diffs)
• util.php (modified) (4 diffs)

branches/multiuser/ajax.php

@@ -78 +78 @@
     $readItems = new ItemList();
 
-    $readItems -> populate(" not(i.unread & ". RSS_MODE_UNREAD_STATE  .") and i.cid= $cid", "", 0, 2, ITEM_SORT_HINT_READ);
+    $readItems -> populate(" i2u.flgunread=0 and i.cid= $cid", "", 0, 2, ITEM_SORT_HINT_READ);
     $readItems -> setTitle(LBL_H2_RECENT_ITEMS);
     $readItems -> setRenderOptions(IL_TITLE_NO_ESCAPE);

branches/multiuser/cls/channels.php

@@ -170 +170 @@
         _pf(' ... totalCount');     
         $sql = 
-        "select count(*) from ".getTable("item") . "i , " . getTable('channels') . " c "
+        "select count(*) from ".getTable("item2user") . "i , " . getTable('channels') . " c "
             
-            ." where i.cid=c.id and not(i.unread & ".RSS_MODE_DELETED_STATE.") "
+            ." where i.fkcid=c.id and i.flgdeleted=0 "
             ." and not (c.mode & " .RSS_MODE_DELETED_STATE.")"
-            . (hidePrivate()? " and not(unread & ".RSS_MODE_PRIVATE_STATE.")":"");
+            . (hidePrivate()? " and i.flgprivate=0":"");
             
             //echo $sql;
@@ -219 +219 @@
             $sql = "select f.id, f.name, count(*) as cnt "
             ." from "
-            .getTable('item') ." i, "
+            .getTable('item2user') ." i2u, "
             .getTable('channels') . " c, "
             .getTable('folders') ." f "
-            ." where i.unread & ". RSS_MODE_UNREAD_STATE
-            ." and not(i.unread & ". RSS_MODE_DELETED_STATE .")";
+            ." where i2u.flgunread =1 "
+            ." and i2u.flgdeleted=0 ";
             if (hidePrivate()) {
-                $sql .=" and not(unread & " . RSS_MODE_PRIVATE_STATE .") ";
+                $sql .=" and i2u.flgprivate =0 ";
             }
             $sql .= " and not(c.mode & " . RSS_MODE_DELETED_STATE .") ";
-            $sql .= " and i.cid=c.id and c.parent=f.id "
+            $sql .= " and i2u.fkcid=c.id and c.parent=f.id "
             ." group by f.id"; 
             _pf('query');
@@ -266 +266 @@
         $this -> feedCount = rss_num_rows($res);
         
-        $ucres = rss_query ("select cid, count(*) from " .getTable("item")
-        ." where unread & "  . RSS_MODE_UNREAD_STATE
-        . " and not(unread & " . RSS_MODE_DELETED_STATE .") group by cid");
+        $ucres = rss_query ("select fkcid, count(*) from " .getTable("item2user")
+        ." i2u where i2u.flgunread=1 and i2u.flgdeleted=0 and i2u.fkuid=" .rss_user_id() ." group by i2u.fkcid");
         $uc = array();
         while (list($uccid,$ucuc) = rss_fetch_row($ucres)) {

branches/multiuser/cls/items.php

@@ -60 +60 @@
      * ctor
      */
-    function Item($id, $title, $url, $enclosure, $parent, $author, $description, $date, $isPubDate, $unread, $rating) {
+    function Item($id, $title, $url, $enclosure, $parent, $author, $description, $date, $isPubDate, $unread,$private, $sticky, $flagged) {
         $this->rss = &$GLOBALS['rss'];
         $this->id = $id;
-        $this->flags = $unread;
+        //$this->flags = $unread;
         if ($title) {
             $this->title = $title;
@@ -87 +87 @@
         $this -> tags=array();
         $this -> rating = $rating;
-        $this ->isUnread    = $unread & RSS_MODE_UNREAD_STATE;
-        $this ->isPrivate   = $unread & RSS_MODE_PRIVATE_STATE;
-        $this ->isDeleted   = $unread & RSS_MODE_DELETED_STATE;
-        $this ->isSticky    = $unread & RSS_MODE_STICKY_STATE;
-    $this ->isFlag    = $unread & RSS_MODE_FLAG_STATE;
+        $this ->isUnread    = $unread;
+        $this ->isPrivate   = $private;
+        $this ->isDeleted   = $deleted;
+        $this ->isSticky    = $sticky;
+        $this ->isFlag      = $flagged;
         //$this -> key = md5(rand(0,10000));
         
@@ -193 +193 @@
         $this->items[] = $item;
         
-        if ((!$this -> hasUnreadItems) && $item->flags & RSS_MODE_UNREAD_STATE) {
+        if ((!$this -> hasUnreadItems) && $item->isUnread) {
             $this -> hasUnreadItems = true;
         }
@@ -260 +260 @@
         
         // Predefined alternate ordering
-        $this -> ORDER_BY_UNREAD_FIRST = " order by i.unread & " . RSS_MODE_UNREAD_STATE . " desc, ";
+        $this -> ORDER_BY_UNREAD_FIRST = " order by i2u.flgunread desc, ";
         if (getConfig('rss.config.absoluteordering')) {
             $this -> ORDER_BY_UNREAD_FIRST .= " f.position asc, c.position asc";
@@ -283 +283 @@
 
       _pf('ItemList::populate()');
-        $this -> _sqlActualWhat = " i.title,  c.title, c.id, i.unread, "
+        $this -> _sqlActualWhat = " i.title,  c.title, c.id, "
+        ."i2u.flgunread, i2u.flgprivate, i2u.flgsticky, i2u.flgdeleted, i2u.flgflagged,"
             ."i.url, i.enclosure, i.author, i.description, c.icon, "
             ." unix_timestamp(ifnull(i.pubdate,i.added)) as ts, "
-            ." i.pubdate is not null as ispubdate, i.id, r.rating  ";
-        $this -> _sqlActualFrom =   getTable("item") ." i "
-            ." left join "
-            . getTable("rating") ." r on (i.id = r.iid), "
-            .getTable("channels")." c, "
-            .getTable("folders") ." f ";
-
-        $this -> _sqlActualWhere = " i.cid = c.id and "
-            ." f.id=c.parent and ". (false == $includeDeprecated ? " not(c.mode & ".RSS_MODE_DELETED_STATE.") and " : "")
-            ." not(i.unread & ".RSS_MODE_DELETED_STATE.") and ";
-            
-
-
+            ." i.pubdate is not null as ispubdate, i.id "
+            //.", r.rating  "
+            ;
+            
+        $this -> _sqlActualFrom =   ""
+            .getTable('item2user') . " i2u "
+            ." left join "
+            .getTable("item") ." i "
+            ." on (i2u.fkiid = i.id) left join "
+            //." left join "
+            //. getTable("rating") ." r on (i.id = r.iid), "
+            .getTable("channels")." c on (i.cid=c.id) left join "
+            .getTable("folders") ." f on (c.parent=f.id) ";
+
+
+        $this -> _sqlActualWhere = " i2u.fkuid= " . $GLOBALS['rssuser']->getUserId() . " ";
         if (hidePrivate()) {
-            $this -> _sqlActualWhere .= " not(i.unread & ".RSS_MODE_PRIVATE_STATE.") and ";
-        }
+            $this -> _sqlActualWhere .= " and i2u.flgprivate=0 ";
+        }
+        
+        $this -> _sqlActualWhere .= " and "
+            . (false == $includeDeprecated ? " not(c.mode & ".RSS_MODE_DELETED_STATE.") and " : "")
+            ." i2u.flgdeleted=0 and ";
+            
+
+
+
 
         if ($this -> _sqlActualWhere) {
@@ -347 +359 @@
         $this -> _sqlActualLimit = " $startItem, $itemCount";
 
-        $sql = "select "
+        $sql = "\nselect\n\t "
             .$this -> _sqlActualWhat
-            . " from "
+            . " \nfrom\n\t "
             .$this -> _sqlActualFrom
-            . " where "
+            . " \nwhere\n\t "
             . $this -> _sqlActualWhere
-            . " order by "
+            . " \norder by\n\t "
             . $this -> _sqlActualOrder
-            . " limit "
+            . " \nlimit "
             . $this -> _sqlActualLimit;
             
-        //echo $sql;        
+        //die( $sql );
         $this -> iids = array();
-        $res = $GLOBALS['rss_db']->rss_query($sql);
+        $res = rss_query($sql);
         $this -> rowCount = $GLOBALS['rss_db']->rss_num_rows($res);
         $prevCid = -1;
         $curIdx = 0;
         $f=null;
-        while (list ($ititle_, $ctitle_, $cid_, $iunread_, $iurl_, $ienclosure_, $iauthor_, $idescr_, $cicon_, $its_, $iispubdate_, $iid_, $rrating_) = $GLOBALS['rss_db']->rss_fetch_row($res)) {
+        while (list ($ititle_, $ctitle_, $cid_, $iunread_, $iprivate_, $isticky_, $ideleted_, $iflagged_, $iurl_, $ienclosure_, $iauthor_, $idescr_, $cicon_, $its_, $iispubdate_, $iid_) = $GLOBALS['rss_db']->rss_fetch_row($res)) {
             
             // Built a new Item
-            $i = new Item($iid_, $ititle_, $iurl_, $ienclosure_, $cid_, $iauthor_, $idescr_, $its_, $iispubdate_, $iunread_, $rrating_);
+            $i = new Item($iid_, $ititle_, $iurl_, $ienclosure_, $cid_, $iauthor_, $idescr_, $its_, $iispubdate_, $iunread_, $iprivate_, $isticky_, $iflagged_);
             
             // no dupes, please
@@ -400 +412 @@
             // Some stats...
             $this -> itemCount++;           
-            if ($iunread_ & RSS_MODE_UNREAD_STATE) {
+            if ($iunread_) {
                 $this -> unreadCount++; 
                 $this -> unreadIids[] = $iid_;

branches/multiuser/cls/update.php

@@ -100 +100 @@
         if (!hidePrivate() || $ignorePrivate) {
             if (count($newIds) > 0 && getConfig('rss.config.markreadonupdate')) {
-                rss_query("update ".getTable("item")." set unread = unread & "
-                          .SET_MODE_READ_STATE." where unread & ".RSS_MODE_UNREAD_STATE
-                          ." and id not in (".implode(",", $newIds).")");
+                rss_query("update ".getTable("item2user")." i2u set i2u.flgunread=0 where i2u.flgunread=1"
+                          ." and i2u.fkiid not in (".implode(",", $newIds).")");
             }
         }
@@ -413 +412 @@
     ."<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">\n"
     ."<html>\n"."<head>\n"."<title>Redirecting...</title>\n"
-    ."<meta http-equiv=\"refresh\" content=\"0;url=index.php\"/>\n"
+    ."<meta http-equiv=\"refresh\" content=\"0;url=index.php\"/>\n"
     ."</head>\n"."<body/>\n"."</html>";
 
@@ -475 +474 @@
 
         var ids = new Array();
-        kids = document.getElementById('updatetable').getElementsByTagName("tr");
+        var kids = document.getElementById('updatetable').getElementsByTagName("tr");
         var i=0;
         var added = 0;
@@ -572 +571 @@
 
     function ajaxUpdate(batch) {
-        sBatch='';
+        var sBatch='';
         //alert(batch.length);
         for(var i=0;i<batch.length;i++) {

branches/multiuser/cls/user.php

@@ -224 +224 @@
         return $this -> _level;
     }
+    
+    function getUserId() {
+        return $this -> _uid;
+    }
 }
 

branches/multiuser/cls/wrappers/user.php

@@ -34 +34 @@
 }
 
+function rss_user_id() {
+    return $GLOBALS['rssuser'] -> getUserId();
+}
+
 function rss_user_logout() {
     $GLOBALS['rssuser'] -> logout();

branches/multiuser/constants.php

@@ -177 +177 @@
 // Profiling 
 //  - The profiling information is "html commented out" at the end of every html page
-//define('PROFILING', 1);
-//define('PROFILING_DB', 1);
+define('PROFILING', 1);
+define('PROFILING_DB', 1);
 
 ?>

branches/multiuser/feed.php

@@ -317 +317 @@
         /* Redirect! If this feed has more unread items, self-redirect */
 
-        $sql = "select count(*) from " .getTable("item") . " i "
-               ." where i.unread & " .RSS_MODE_UNREAD_STATE
-               ." and i.cid=$cid"
-               ." and not(i.unread & " . RSS_MODE_DELETED_STATE  .") "
+        $sql = "select count(*) from " .getTable("item2user") . " i2u "
+               ." where i2u.flgunread=1 "
+               ." and i2u.fkcid=$cid"
+               ." and i2u.flgdeleted=0 "
                ;
         if (hidePrivate()) {
-            $sql .=" and not(i.unread & " . RSS_MODE_PRIVATE_STATE .") ";
+            $sql .=" and i2u.flgprivate =0";
         }
         list($hasMoreUnreads) = rss_fetch_row(rss_query($sql));
@@ -363 +363 @@
 
             // 2: Get the unread count for each feed:
-            $sql = "select cid, count(*) from " .getTable('item')
-                   ." where (unread & ".RSS_MODE_UNREAD_STATE . ") "
-                   ." and not (unread & " .RSS_MODE_DELETED_STATE . ") ";
+            $sql = "select fkcid, count(*) from " .getTable('item2user')
+                   ." i2u where i2u.flgunread=1 "
+                   ." and i2u.flgdeletd=0";
             if (hidePrivate()) {
-                $sql .= " and not (i.unread & " . RSS_MODE_PRIVATE_STATE . ") ";
-            }
-            $sql .= " group by cid";
+                $sql .= " and i2u.flgprivate=0 ";
+            }
+            $sql .= " group by i2u.fkcid";
             $res = rss_query($sql);
             while (list($cid__,$uc__) = rss_fetch_row($res)) {
@@ -424 +424 @@
         
         
-        $sql = "update " .getTable('item')
-               . " set unread = unread & ".SET_MODE_READ_STATE
-               . " where cid  in (" .implode(',', $cids_) . ") ";
+        $sql = "update " .getTable('item2user')
+               . " set unread = 0 "
+               . " where fkcid  in (" .implode(',', $cids_) . ") ";
           unset($cids_);
         if (count($IdsToMarkAsRead)) {
-            $sql .= " and id in (" . implode(',',$IdsToMarkAsRead) .")";
+            $sql .= " and fkiid in (" . implode(',',$IdsToMarkAsRead) .")";
         }
 
@@ -450 +450 @@
             if( $found || !$first_fid ) {
                 $sql = "select count(*) from "
-                       .getTable('item') ." i, "
+                       .getTable('item2user') ." i2u, "
                        .getTable('channels') ." c "
-                       ." where i.unread & " .RSS_MODE_UNREAD_STATE ." and i.cid = c.id and c.parent = $fid__";
+                       ." where i2u.flgunread=1 and i2u.fkcid = c.id and c.parent = $fid__"
+                       ." and i2u.fkuid=" . rss_user_id();
                 if (hidePrivate()) {
-                    $sql .= " and not(i.unread & " . RSS_MODE_PRIVATE_STATE . ")";
+                    $sql .= " and i2u.flgprivate=0 ";
                 }
     
@@ -498 +499 @@
         }
         
-        $sql = "update " .getTable('item') 
-      . " set unread = unread & ".SET_MODE_READ_STATE
-      . " where cid in (" .implode(',',$fids_). ")";
+        $sql = "update " .getTable('item2user') 
+      . " set unread = 0 "
+      . " where fkcid in (" .implode(',',$fids_). ")"
+      . " and fkuid=". rss_user_id();
+      
 
         if (count($IdsToMarkAsRead)) {
-            $sql .= " and id in (" . implode(',',$IdsToMarkAsRead) .")";
+            $sql .= " and fkiid in (" . implode(',',$IdsToMarkAsRead) .")";
         }
 
@@ -521 +524 @@
             if( $found || !$first_vfid ) {
                 // check for unread items in next virtual folder
-                $sql = "select count(distinct(i.id)) as cnt from "
+                $sql = "select count(distinct(i.fkiid)) as cnt from "
                        .getTable('metatag') ." left join "
-                       .getTable('item') . "i on (i.cid=fid) "
+                       .getTable('item2user') . "i2u on (i2u.fkcid=fid) "
                        ."where tid = $tid__ and ttype = 'channel' "
-                       ." and (i.unread & ".RSS_MODE_UNREAD_STATE.") "
-                       ."and not(i.unread & ".RSS_MODE_DELETED_STATE.")";
+                       ." and i2u.flgunread=1 "
+                       ." and i2u.fkuid=" .rss_user_id()
+                       ." and i2u.flgdeleted=0 ";
                 if (hidePrivate()) {
-                    $sql .= " and not(i.unread & " . RSS_MODE_PRIVATE_STATE . ")";
+                    $sql .= " and i2u.flgprivate=0 ";
                 }
                 list($c) = rss_fetch_row(rss_query($sql));
@@ -682 +686 @@
     // "item mode"
     $res = rss_query ("select c.title, c.icon, i.title from " . getTable("channels") ." c, "
-                      .getTable("item") ." i where c.id = $cid and i.cid=c.id and i.id=$iid"
-                      ." and not(i.unread & " . RSS_MODE_DELETED_STATE  .") "
+                      .getTable("item") ." i, "
+                      .getTable('item2user') ." i2u where i2u.fkiid=i.id and "
+                      ." c.id = $cid and i.cid=c.id and i.id=$iid"
+                      ." and i2u.flgdeleted=0 "
                      );
 
@@ -726 +732 @@
         } else {
             // archives, folders, channels
-            $sql = "select count(*) from " . getTable('item') . " where"
-                   ." (unread & " . RSS_MODE_UNREAD_STATE .")"
-                   ." and not(unread & " . RSS_MODE_DELETED_STATE  .") ";
+            $sql = "select count(*) from " . getTable('item2user') 
+                . " i2u left join ".getTable('item')." i on (i2u.fkiid=i.id) where"
+                   ."  i2u.flgunread=1 and i2u.flgdeleted=0";
 
             //archive?
@@ -739 +745 @@
             }
             if ($cids && count($cids)) {
-                $sql .= " and cid in (".implode(',',$cids).")";
+                $sql .= " and i.cid in (".implode(',',$cids).")";
             }
             list($unreadCount) = rss_fetch_row(rss_query($sql));
@@ -760 +766 @@
         $hint = ITEM_SORT_HINT_MIXED;
         if  ($do_show == SHOW_UNREAD_ONLY) {
-            $sqlWhere .= " and (i.unread & " . RSS_MODE_UNREAD_STATE .") ";
+            $sqlWhere .= " and i2u.flgunread=1 ";
             $hint = ITEM_SORT_HINT_UNREAD;
         }
@@ -787 +793 @@
                 $sqlWhere = "i.cid = $cid";
                 if  ($do_show == SHOW_UNREAD_ONLY) {
-                    $sqlWhere .= " and (i.unread & " . RSS_MODE_UNREAD_STATE .") ";
+                    $sqlWhere .= " and i2u.flgunread=1 ";
                     $hint = ITEM_SORT_HINT_UNREAD;
                 }

branches/multiuser/index.php

@@ -47 +47 @@
     && !hidePrivate()) {
     
-    $sql = "update " .getTable("item") . " set unread=unread & "
-     .SET_MODE_READ_STATE ." where unread  & " . RSS_MODE_UNREAD_STATE;
+    $sql = "update " .getTable("item2user") . " i2u set i2u.flgunread=0 where i2u.flgunread=1 and i2u.fkuid=" .rss_user_id();
+    
+    
      
    if (hidePrivate()) {
-        $sql .= " and not(unread & " . RSS_MODE_PRIVATE_STATE . ")";
+        $sql .= " and i2u.flgprivate=0 ";
      }
 
     if (array_key_exists('markreadids',$_POST)) {
-        $sql .= " and id in (" . rss_real_escape_string($_POST['markreadids']) .")";
+        $sql .= " and i2u.fkiid in (" . rss_real_escape_string($_POST['markreadids']) .")";
     }
      rss_query( $sql );
@@ -122 +123 @@
     $numItems = getConfig('rss.output.frontpage.numitems');
     
-    /*
-    $hiddenIds = getHiddenChannelIds();
-    if (count($hiddenIds)) {
-        $sqlWhereHidden = " and c.id not in (" . implode(',',$hiddenIds) . ") ";
-    } else {
-        $sqlWhereHidden = "";
-    }
-    */
-    $sqlWhereHidden = "";
-    
-    $unreadItems -> populate("i.unread & " . RSS_MODE_UNREAD_STATE . $sqlWhereHidden, "", 0, $numItems,ITEM_SORT_HINT_UNREAD);
-    
+    
+    $unreadItems -> populate(" i2u.flgunread=1 ", "", 0, $numItems,ITEM_SORT_HINT_UNREAD);
+    //var_dump($unreadItems);
     _pf('end populate unread items');
     if ($unreadItems ->unreadCount) {
@@ -187 +179 @@
         $res1=rss_query($sql);
         while ($readItems->itemCount < $limit && (list($cid) = rss_fetch_row($res1))) {
-            $sqlWhere  = " not(i.unread & ". RSS_MODE_UNREAD_STATE  .") and i.cid= $cid";
+            $sqlWhere  = " i2u.flgunread=0 and i.cid= $cid";
             $sqlWhere .= " and i.pubdate <= now() ";
             
@@ -200 +192 @@
             return;
         }
-        $sqlWhere  = " not(i.unread & ". RSS_MODE_UNREAD_STATE  .")  ";
+        $sqlWhere  = " i2u.flgunread=0  ";
         $sqlWhere .= " and i.pubdate <= now() ";
     //  $sqlWhere .= $sqlWhereHidden;

branches/multiuser/schema.php

@@ -50 +50 @@
         "dashboard" => trim(getTable("dashboard")),
         "properties" => trim(getTable("properties")),
+        "item2user" => trim(getTable("item2user")),
 
     );
@@ -64 +65 @@
         }
     }
-    
     $updated  = 0;
     if (count($missing_tables) > 0) {
@@ -258 +258 @@
             // guid of an item - added in 0.5.3
             rss_query('alter table ' . getTable('item') . ' add column guid text null');
-            rss_query('alter table ' . getTable('item') . ' add index `guid` (`guid`(10))');
+            rss_query('alter table ' . getTable('item') . " add index 'guid' ('guid'(10))");
             if (rss_is_sql_error(RSS_SQL_ERROR_NO_ERROR)) {
                 $updated++;
@@ -681 +681 @@
 }
 
+
+///////////////////////////////////////////////////////////////////////////////
+
+function _init_item2user() {
+    $table = getTable('item2user');
+    rss_query_wrapper ('DROP TABLE IF EXISTS ' . $table, true, true);
+    $sql_create = str_replace('__table__',$table, <<< _SQL_
+        CREATE TABLE __table__ (
+          fkiid bigint(16) NOT NULL,
+          fkuid bigint(16) NOT NULL,
+          fkcid bigint(11) NOT NULL,
+          flgunread tinyint(1) NOT NULL default '1',
+          flgsticky tinyint(1) NOT NULL default '0',
+          flgprivate tinyint(1) NOT NULL default '0',
+          flgdeleted tinyint(1) NOT NULL default '0',
+          flgflagged tinyint(1) NOT NULL default '0',
+          KEY flgunread (flgunread),
+          KEY flgsticky (flgsticky),
+          KEY flgprivate (flgprivate),
+          KEY flgdeleted (flgdeleted),
+          KEY flgflagged (flgflagged),
+          KEY fkuid (fkuid),
+          KEY iids (fkiid)
+        ) ENGINE=MyISAM;        
+_SQL_
+);
+
+    rss_query_wrapper($sql_create, false, true);
+
+    if (!rss_is_sql_error(RSS_SQL_ERROR_NO_ERROR)) {
+        rss_error('The ' . $table . 'table doesn\'t exist and I couldn\'t create it! Please create it manually.', RSS_ERROR_ERROR);
+        return 0;
+    } else {
+        $fillSql = "insert into $table (fkiid,fkuid,fkcid,flgunread,flgsticky,flgprivate,flgdeleted,flgflagged) "
+        ."select id, " . rss_user_id() . ", cid, "
+        ." unread & ".RSS_MODE_UNREAD_STATE." = ".RSS_MODE_UNREAD_STATE.", "
+        ." unread & ".RSS_MODE_STICKY_STATE." = ".RSS_MODE_STICKY_STATE.", "
+        ." unread & ".RSS_MODE_PRIVATE_STATE." = ".RSS_MODE_PRIVATE_STATE.", "
+        ." unread & ".RSS_MODE_DELETED_STATE." = ".RSS_MODE_DELETED_STATE.", "
+        ." unread & ".RSS_MODE_FLAG_STATE." = ".RSS_MODE_FLAG_STATE." from " .getTable('item');
+        rss_query_wrapper($fillSql, false, true);
+
+        return rss_is_sql_error(RSS_SQL_ERROR_NO_ERROR);
+    }
+}
+
+
+
 ///////////////////////////////////////////////////////////////////////////////