*/
use Friendica\App;
+use Friendica\Content\Text\BBCode;
+use Friendica\Content\Text\HTML;
+use Friendica\Core\ACL;
use Friendica\Core\Config;
use Friendica\Core\L10n;
use Friendica\Core\Protocol;
use Friendica\Database\DBM;
use Friendica\Model\Contact;
use Friendica\Model\Group;
+use Friendica\Model\Item;
use Friendica\Model\Profile;
use Friendica\Protocol\DFRN;
// Does the local user have this item?
if (local_user()) {
- $r = dba::fetch_first("SELECT `id`, `parent`, `author-name`, `author-link`,
- `author-avatar`, `network`, `body`, `uid`, `owner-link`
+ $r = dba::fetch_first("SELECT `id`, `parent`, `author-id`, `body`, `uid`
FROM `item` WHERE `visible` AND NOT `deleted` AND NOT `moderated`
AND `guid` = ? AND `uid` = ? LIMIT 1", $a->argv[1], local_user());
if (DBM::is_result($r)) {
// Is it an item with uid=0?
if (!DBM::is_result($r)) {
- $r = dba::fetch_first("SELECT `id`, `parent`, `author-name`, `author-link`,
- `author-avatar`, `network`, `body`, `uid`, `owner-link`
+ $r = dba::fetch_first("SELECT `id`, `parent`, `author-id`, `body`, `uid`
FROM `item` WHERE `visible` AND NOT `deleted` AND NOT `moderated`
AND NOT `private` AND `uid` = 0
AND `guid` = ? LIMIT 1", $a->argv[1]);
return;
}
} elseif (($a->argc == 3) && ($nick == 'feed-item')) {
- $r = dba::fetch_first("SELECT `id`, `parent`, `author-name`, `author-link`,
- `author-avatar`, `network`, `body`, `uid`, `owner-link`
+ $r = dba::fetch_first("SELECT `id`, `parent`, `author-id`, `body`, `uid`
FROM `item` WHERE `visible` AND NOT `deleted` AND NOT `moderated`
AND NOT `private` AND `uid` = 0
AND `id` = ? LIMIT 1", $a->argv[2]);
}
if ($r["id"] != $r["parent"]) {
- $r = dba::fetch_first("SELECT `id`, `author-name`, `author-link`, `author-avatar`, `network`, `body`, `uid`, `owner-link` FROM `item`
+ $r = dba::fetch_first("SELECT `id`, `author-id`, `body`, `uid` FROM `item`
WHERE `item`.`visible` AND NOT `item`.`deleted` AND NOT `item`.`moderated`
AND `id` = ?", $r["parent"]);
}
}
function display_fetchauthor($a, $item) {
+ $author = dba::selectFirst('contact', ['name', 'nick', 'photo', 'network', 'url'], ['id' => $item['author-id']]);
+
$profiledata = [];
- $profiledata["uid"] = -1;
- $profiledata["nickname"] = $item["author-name"];
- $profiledata["name"] = $item["author-name"];
- $profiledata["picdate"] = "";
- $profiledata["photo"] = $item["author-avatar"];
- $profiledata["url"] = $item["author-link"];
- $profiledata["network"] = $item["network"];
+ $profiledata['uid'] = -1;
+ $profiledata['nickname'] = $author['nick'];
+ $profiledata['name'] = $author['name'];
+ $profiledata['picdate'] = '';
+ $profiledata['photo'] = $author['photo'];
+ $profiledata['url'] = $author['url'];
+ $profiledata['network'] = $author['network'];
// Check for a repeated message
$skip = false;
require_once 'include/security.php';
require_once 'include/conversation.php';
- require_once 'include/acl_selectors.php';
$o = '';
if ($update) {
$item_id = $_REQUEST['item_id'];
- $item = dba::selectFirst('item', ['uid', 'parent'], ['id' => $item_id]);
- $a->profile = ['uid' => intval($item['uid']), 'profile_uid' => intval($item['uid'])];
+ $item = dba::selectFirst('item', ['uid', 'parent', 'parent-uri'], ['id' => $item_id]);
+ if ($item['uid'] != 0) {
+ $a->profile = ['uid' => intval($item['uid']), 'profile_uid' => intval($item['uid'])];
+ } else {
+ $a->profile = ['uid' => intval($update_uid), 'profile_uid' => intval($update_uid)];
+ }
$item_parent = $item['parent'];
+ $item_parent_uri = $item['parent-uri'];
} else {
$item_id = (($a->argc > 2) ? $a->argv[2] : 0);
$item_parent = 0;
if (local_user()) {
- $r = dba::fetch_first("SELECT `id`, `parent` FROM `item`
+ $r = dba::fetch_first("SELECT `id`, `parent`, `parent-uri` FROM `item`
WHERE `item`.`visible` AND NOT `item`.`deleted` AND NOT `item`.`moderated`
AND `guid` = ? AND `uid` = ?", $a->argv[1], local_user());
if (DBM::is_result($r)) {
$item_id = $r["id"];
$item_parent = $r["parent"];
+ $item_parent_uri = $r['parent-uri'];
}
}
if ($item_parent == 0) {
- $r = dba::fetch_first("SELECT `item`.`id`, `item`.`parent` FROM `item`
+ $r = dba::fetch_first("SELECT `item`.`id`, `item`.`parent`, `item`.`parent-uri` FROM `item`
WHERE `item`.`visible` AND NOT `item`.`deleted` AND NOT `item`.`moderated`
AND NOT `item`.`private` AND `item`.`uid` = 0
AND `item`.`guid` = ?", $a->argv[1]);
if (DBM::is_result($r)) {
$item_id = $r["id"];
$item_parent = $r["parent"];
+ $item_parent_uri = $r['parent-uri'];
}
}
}
'default_location' => $a->user['default-location'],
'nickname' => $a->user['nickname'],
'lockstate' => (is_array($a->user) && (strlen($a->user['allow_cid']) || strlen($a->user['allow_gid']) || strlen($a->user['deny_cid']) || strlen($a->user['deny_gid'])) ? 'lock' : 'unlock'),
- 'acl' => populate_acl($a->user, true),
+ 'acl' => ACL::getFullSelectorHTML($a->user, true),
'bang' => '',
'visitor' => 'block',
'profile_uid' => local_user(),
$sql_extra = item_permissions_sql($a->profile['uid'], $remote_contact, $groups);
- if ($update) {
- $r = dba::p("SELECT `id` FROM `item` WHERE
- `item`.`parent` = (SELECT `parent` FROM `item` WHERE `id` = ?)
- $sql_extra AND `unseen`",
- $item_id
- );
+ if (local_user() && (local_user() == $a->profile['uid'])) {
+ $condition = ['parent-uri' => $item_parent_uri, 'uid' => local_user(), 'unseen' => true];
+ $unseen = dba::exists('item', $condition);
+ } else {
+ $unseen = false;
+ }
- if (dba::num_rows($r) == 0) {
- return '';
- }
+ if ($update && !$unseen) {
+ return '';
}
- $r = dba::p(item_query()."AND `item`.`parent` = (SELECT `parent` FROM `item` WHERE `id` = ?)
- $sql_extra
- ORDER BY `parent` DESC, `gravity` ASC, `id` ASC",
- $item_id
- );
+ $condition = ["`item`.`parent-uri` = (SELECT `parent-uri` FROM `item` WHERE `id` = ?)
+ AND `item`.`uid` IN (0, ?) " . $sql_extra, $item_id, local_user()];
+ $params = ['order' => ['uid', 'parent' => true, 'gravity', 'id']];
+ $r = Item::selectForUser(local_user(), [], $condition, $params);
if (!DBM::is_result($r)) {
notice(L10n::t('Item not found.') . EOL);
$s = dba::inArray($r);
- if (local_user() && (local_user() == $a->profile['uid'])) {
- $unseen = dba::selectFirst('item', ['id'], ['parent' => $s[0]['parent'], 'unseen' => true]);
- if (DBM::is_result($unseen)) {
- dba::update('item', ['unseen' => false], ['parent' => $s[0]['parent'], 'unseen' => true]);
- }
+ if ($unseen) {
+ $condition = ['parent-uri' => $item_parent_uri, 'uid' => local_user(), 'unseen' => true];
+ dba::update('item', ['unseen' => false], $condition);
}
$items = conv_sort($s, "`commented`");
if (!$update) {
$o .= "<script> var netargs = '?f=&item_id=" . $item_id . "'; </script>";
}
- $o .= conversation($a, $items, 'display', $update_uid);
+ $o .= conversation($a, $items, 'display', $update_uid, false, 'commented', local_user());
// Preparing the meta header
- require_once 'include/bbcode.php';
- require_once 'include/html2plain.php';
- $description = trim(html2plain(bbcode($s[0]["body"], false, false), 0, true));
- $title = trim(html2plain(bbcode($s[0]["title"], false, false), 0, true));
+ $description = trim(HTML::toPlaintext(BBCode::convert($s[0]["body"], false), 0, true));
+ $title = trim(HTML::toPlaintext(BBCode::convert($s[0]["title"], false), 0, true));
$author_name = $s[0]["author-name"];
$image = $a->remove_baseurl($s[0]["author-thumb"]);