]> git.mxchange.org Git - friendica.git/blobdiff - src/Content/ForumManager.php
Move mod/toggle_mobile to src/Module/ToggleMobile
[friendica.git] / src / Content / ForumManager.php
index b23a9e6924eb89e2c492c40953be7b444563b8dc..af2c3725c40700f6a3d068d6f348fb4a3c72de1f 100644 (file)
@@ -196,18 +196,18 @@ class ForumManager
         */
        public static function countUnseenItems()
        {
-               $r = DBA::p(
+               $stmtContacts = DBA::p(
                        "SELECT `contact`.`id`, `contact`.`name`, COUNT(*) AS `count` FROM `item`
                                INNER JOIN `contact` ON `item`.`contact-id` = `contact`.`id`
-                               WHERE `item`.`uid` = %d AND `item`.`visible` AND NOT `item`.`deleted` AND `item`.`unseen`
+                               WHERE `item`.`uid` = ? AND `item`.`visible` AND NOT `item`.`deleted` AND `item`.`unseen`
                                AND `contact`.`network`= 'dfrn' AND (`contact`.`forum` OR `contact`.`prv`)
                                AND NOT `contact`.`blocked` AND NOT `contact`.`hidden`
                                AND NOT `contact`.`pending` AND NOT `contact`.`archive`
                                AND `contact`.`success_update` > `failure_update`
                                GROUP BY `contact`.`id` ",
-                       intval(local_user())
+                       local_user()
                );
 
-               return DBA::toArray($r);
+               return DBA::toArray($stmtContacts);
        }
 }