6 use Friendica\Content\Nav;
7 use Friendica\Core\L10n;
8 use Friendica\Database\DBM;
9 use Friendica\Model\Profile;
11 function notes_init(App $a) {
19 $which = $a->user['nickname'];
21 Nav::setSelected('home');
23 //Profile::load($a, $which, $profile);
28 function notes_content(App $a, $update = false) {
31 notice(L10n::t('Permission denied.') . EOL);
35 require_once("include/bbcode.php");
36 require_once('include/security.php');
37 require_once('include/conversation.php');
38 require_once('include/acl_selectors.php');
44 $remote_contact = false;
46 $contact_id = $_SESSION['cid'];
47 $contact = $a->contact;
52 $o .= Profile::getTabs($a, true);
55 $o .= '<h3>' . t('Personal Notes') . '</h3>';
61 'is_owner' => $is_owner,
62 'allow_location' => (($a->user['allow_location']) ? true : false),
63 'default_location' => $a->user['default-location'],
64 'nickname' => $a->user['nickname'],
65 'lockstate' => 'lock',
69 'profile_uid' => local_user(),
70 'button' => t('Save'),
74 $o .= status_editor($a,$x,$a->contact['id']);
78 // Construct permissions
80 // default permissions - anonymous user
82 $sql_extra = " AND `item`.`allow_cid` = '<" . $a->contact['id'] . ">' ";
84 $r = q("SELECT COUNT(*) AS `total`
86 WHERE %s AND `item`.`uid` = %d AND `item`.`type` = 'note'
87 AND `contact`.`self` AND `item`.`id` = `item`.`parent` AND NOT `item`.`wall`
89 item_joins(), item_condition(),
94 if (DBM::is_result($r)) {
95 $a->set_pager_total($r[0]['total']);
96 $a->set_pager_itemspage(40);
99 $r = q("SELECT `item`.`id` AS `item_id` FROM `item` %s
100 WHERE %s AND `item`.`uid` = %d AND `item`.`type` = 'note'
101 AND `item`.`id` = `item`.`parent` AND NOT `item`.`wall`
103 ORDER BY `item`.`created` DESC LIMIT %d ,%d ",
104 item_joins(), item_condition(),
105 intval(local_user()),
106 intval($a->pager['start']),
107 intval($a->pager['itemspage'])
114 if (DBM::is_result($r)) {
116 $parents_arr[] = $rr['item_id'];
117 $parents_str = implode(', ', $parents_arr);
119 $r = q("SELECT %s FROM `item` %s
120 WHERE %s AND `item`.`uid` = %d AND `item`.`parent` IN (%s)
122 ORDER BY `parent` DESC, `gravity` ASC, `item`.`id` ASC ",
123 item_fieldlists(), item_joins(), item_condition(),
124 intval(local_user()),
128 if (DBM::is_result($r)) {
129 $items = conv_sort($r,"`commented`");
131 $o .= conversation($a,$items,'notes',$update);