Merge pull request #2932 from Hypolite/issue/missing-private-image-src

[friendica.git] / mod / notes.php

diff --git a/mod/notes.php b/mod/notes.php
index afaa60f7016623c91d36432cd303c5b0fcd6140b..a25d090ed701faad32ab49fb2dbc7012b13d8e2f 100644 (file)
--- a/mod/notes.php
+++ b/mod/notes.php
@@ -9,6 +9,8 @@ function notes_init(&$a) {
 
        $which = $a->user['nickname'];
 
+       nav_set_selected('home');
+
 //     profile_load($a,$which,$profile);
 
 }
@@ -46,45 +48,36 @@ function notes_content(&$a,$update = false) {
                $commpage = false;
                $commvisitor = false;
 
-               $celeb = false;
-
-
-
                $x = array(
                        'is_owner' => $is_owner,
-                       'allow_location' => (($a->user['allow_location']) ? true : false),
-               'default_location' => $a->user['default-location'],
-           'nickname' => $a->user['nickname'],
-               'lockstate' => 'lock',
-               'acl' => '',
-           'bang' => '',
-               'visitor' => 'block',
-                   'profile_uid' => local_user(),
-                       'button' => t('Save')
-
-       );
-
-       $o .= status_editor($a,$x,$a->contact['id']);
+                       'allow_location' => (($a->user['allow_location']) ? true : false),
+                       'default_location' => $a->user['default-location'],
+                       'nickname' => $a->user['nickname'],
+                       'lockstate' => 'lock',
+                       'acl' => '',
+                       'bang' => '',
+                       'visitor' => 'block',
+                       'profile_uid' => local_user(),
+                       'button' => t('Save'),
+                       'acl_data' => '',
+               );
 
-               $o .= '<div id="live-notes"></div>' . "\r\n";
-               $o .= "<script> var profile_uid = " . local_user() 
-                       . "; var netargs = '/?f='; var profile_page = " . $a->pager['page'] . "; </script>\r\n";
+               $o .= status_editor($a,$x,$a->contact['id']);
 
        }
 
        // Construct permissions
 
        // default permissions - anonymous user
-       
+
        $sql_extra = " AND `allow_cid` = '<" . $a->contact['id'] . ">' ";
 
        $r = q("SELECT COUNT(*) AS `total`
-               FROM `item` LEFT JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
-               WHERE `item`.`uid` = %d AND `item`.`visible` = 1 and `item`.`moderated` = 0 
-               AND `item`.`deleted` = 0 AND `item`.`type` = 'note'
-               AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0 AND `contact`.`self` = 1
-               AND `item`.`id` = `item`.`parent` AND `item`.`wall` = 0
+               FROM `item` %s
+               WHERE %s AND `item`.`uid` = %d AND `item`.`type` = 'note'
+               AND `contact`.`self` AND `item`.`id` = `item`.`parent` AND NOT `item`.`wall`
                $sql_extra ",
+               item_joins(), item_condition(),
                intval(local_user())
 
        );
@@ -94,14 +87,12 @@ function notes_content(&$a,$update = false) {
                $a->set_pager_itemspage(40);
        }
 
-       $r = q("SELECT `item`.`id` AS `item_id`, `contact`.`uid` AS `contact-uid`
-               FROM `item` LEFT JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
-               WHERE `item`.`uid` = %d AND `item`.`visible` = 1 AND `item`.`deleted` = 0 
-               and `item`.`moderated` = 0 AND `item`.`type` = 'note'
-               AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0 AND `contact`.`self` = 1
-               AND `item`.`id` = `item`.`parent` AND `item`.`wall` = 0
+       $r = q("SELECT `item`.`id` AS `item_id` FROM `item` %s
+               WHERE %s AND `item`.`uid` = %d AND `item`.`type` = 'note'
+               AND `item`.`id` = `item`.`parent` AND NOT `item`.`wall`
                $sql_extra
                ORDER BY `item`.`created` DESC LIMIT %d ,%d ",
+               item_joins(), item_condition(),
                intval(local_user()),
                intval($a->pager['start']),
                intval($a->pager['itemspage'])
@@ -115,17 +106,12 @@ function notes_content(&$a,$update = false) {
                foreach($r as $rr)
                        $parents_arr[] = $rr['item_id'];
                $parents_str = implode(', ', $parents_arr);
- 
-               $r = q("SELECT `item`.*, `item`.`id` AS `item_id`, 
-                       `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`alias`, `contact`.`network`, `contact`.`rel`, 
-                       `contact`.`thumb`, `contact`.`self`, `contact`.`writable`, 
-                       `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
-                       FROM `item` LEFT JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
-                       WHERE `item`.`uid` = %d AND `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
-                       AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
-                       AND `item`.`parent` IN ( %s )
+
+               $r = q("SELECT %s FROM `item` %s
+                       WHERE %s AND `item`.`uid` = %d AND `item`.`parent` IN (%s)
                        $sql_extra
                        ORDER BY `parent` DESC, `gravity` ASC, `item`.`id` ASC ",
+                       item_fieldlists(), item_joins(), item_condition(),
                        intval(local_user()),
                        dbesc($parents_str)
                );