use Friendica\Core\Worker;
use Friendica\Model\Term;
+use Friendica\Model\Contact;
+use Friendica\Database\DBM;
use dba;
require_once 'include/tags.php';
require_once 'include/threads.php';
+require_once 'include/items.php';
class Item
{
return $rows;
}
+
+ /**
+ * @brief Delete an item and notify others about it - if it was ours
+ *
+ * @param integer $item_id Item ID that should be delete
+ *
+ * @return $boolean success
+ */
+ public static function delete($item_id, $priority = PRIORITY_HIGH)
+ {
+ // locate item to be deleted
+ $fields = ['id', 'uid', 'parent', 'parent-uri', 'origin', 'deleted', 'file', 'resource-id', 'event-id', 'attach'];
+ $item = dba::selectFirst('item', $fields, ['id' => $item_id]);
+ if (!DBM::is_result($item)) {
+ return false;
+ }
+
+ if ($item['deleted']) {
+ return false;
+ }
+
+ $parent = dba::selectFirst('item', ['origin'], ['id' => $item['parent']]);
+ if (!DBM::is_result($parent)) {
+ $parent = ['origin' => false];
+ }
+
+ logger('delete item: ' . $item['id'], LOGGER_DEBUG);
+
+ // clean up categories and tags so they don't end up as orphans
+
+ $matches = false;
+ $cnt = preg_match_all('/<(.*?)>/', $item['file'], $matches, PREG_SET_ORDER);
+ if ($cnt) {
+ foreach ($matches as $mtch) {
+ file_tag_unsave_file($item['uid'], $item['id'], $mtch[1],true);
+ }
+ }
+
+ $matches = false;
+
+ $cnt = preg_match_all('/\[(.*?)\]/', $item['file'], $matches, PREG_SET_ORDER);
+ if ($cnt) {
+ foreach ($matches as $mtch) {
+ file_tag_unsave_file($item['uid'], $item['id'], $mtch[1],false);
+ }
+ }
+
+ /*
+ * If item is a link to a photo resource, nuke all the associated photos
+ * (visitors will not have photo resources)
+ * This only applies to photos uploaded from the photos page. Photos inserted into a post do not
+ * generate a resource-id and therefore aren't intimately linked to the item.
+ */
+ if (strlen($item['resource-id'])) {
+ dba::delete('photo', ['resource-id' => $item['resource-id'], 'uid' => $item['uid']]);
+ }
+
+ // If item is a link to an event, nuke the event record.
+ if (intval($item['event-id'])) {
+ dba::delete('event', ['id' => $item['event-id'], 'uid' => $item['uid']]);
+ }
+
+ // If item has attachments, drop them
+ foreach (explode(", ", $item['attach']) as $attach) {
+ preg_match("|attach/(\d+)|", $attach, $matches);
+ dba::delete('attach', ['id' => $matches[1], 'uid' => $item['uid']]);
+ }
+
+ // When it is our item we don't delete it here, since we have to send delete messages
+ if ($item['origin'] || $parent['origin']) {
+ // Set the item to "deleted"
+ dba::update('item', ['deleted' => true, 'title' => '', 'body' => '',
+ 'edited' => datetime_convert(), 'changed' => datetime_convert()],
+ ['id' => $item['id']]);
+
+ create_tags_from_item($item['id']);
+ Term::createFromItem($item['id']);
+ delete_thread($item['id'], $item['parent-uri']);
+
+ // If it's the parent of a comment thread, kill all the kids
+ if ($item['id'] == $item['parent']) {
+ $items = dba::select('item', ['id'], ['parent' => $item['parent']]);
+ while ($row = dba::fetch($items)) {
+ self::delete($row['id'], $priority);
+ }
+ }
+
+ // send the notification upstream/downstream
+ Worker::add(['priority' => $priority, 'dont_fork' => true], "Notifier", "drop", intval($item['id']));
+ } else {
+ // delete it immediately. All related children will be deleted as well.
+ dba::delete('item', ['id' => $item['id']]);
+ }
+
+ return true;
+ }
+
+ /**
+ * @brief Add a shadow entry for a given item id that is a thread starter
+ *
+ * We store every public item entry additionally with the user id "0".
+ * This is used for the community page and for the search.
+ * It is planned that in the future we will store public item entries only once.
+ *
+ * @param integer $itemid Item ID that should be added
+ */
+ public static function addShadow($itemid)
+ {
+ $fields = ['uid', 'wall', 'private', 'moderated', 'visible', 'contact-id', 'deleted', 'network', 'author-id', 'owner-id'];
+ $condition = ["`id` = ? AND (`parent` = ? OR `parent` = 0)", $itemid, $itemid];
+ $item = dba::selectFirst('item', $fields, $condition);
+
+ if (!DBM::is_result($item)) {
+ return;
+ }
+
+ // is it already a copy?
+ if (($itemid == 0) || ($item['uid'] == 0)) {
+ return;
+ }
+
+ // Is it a visible public post?
+ if (!$item["visible"] || $item["deleted"] || $item["moderated"] || $item["private"]) {
+ return;
+ }
+
+ // is it an entry from a connector? Only add an entry for natively connected networks
+ if (!in_array($item["network"], [NETWORK_DFRN, NETWORK_DIASPORA, NETWORK_OSTATUS, ""])) {
+ return;
+ }
+
+ // Is the public contact configured as hidden?
+ if (Contact::isHidden($item["owner-id"]) || Contact::isHidden($item["author-id"])) {
+ return;
+ }
+
+ // Only do these checks if the post isn't a wall post
+ if (!$item["wall"]) {
+ // Check, if hide-friends is activated - then don't do a shadow entry
+ if (dba::exists('profile', ['is-default' => true, 'uid' => $item['uid'], 'hide-friends' => true])) {
+ return;
+ }
+
+ // Check if the contact is hidden or blocked
+ if (!dba::exists('contact', ['hidden' => false, 'blocked' => false, 'id' => $item['contact-id']])) {
+ return;
+ }
+ }
+
+ // Only add a shadow, if the profile isn't hidden
+ if (dba::exists('user', ['uid' => $item['uid'], 'hidewall' => true])) {
+ return;
+ }
+
+ $item = dba::selectFirst('item', [], ['id' => $itemid]);
+
+ if (DBM::is_result($item) && ($item["allow_cid"] == '') && ($item["allow_gid"] == '') &&
+ ($item["deny_cid"] == '') && ($item["deny_gid"] == '')) {
+
+ if (!dba::exists('item', ['uri' => $item['uri'], 'uid' => 0])) {
+ // Preparing public shadow (removing user specific data)
+ unset($item['id']);
+ $item['uid'] = 0;
+ $item['origin'] = 0;
+ $item['wall'] = 0;
+ $item['contact-id'] = Contact::getIdForURL($item['author-link'], 0);
+
+ if (in_array($item['type'], ["net-comment", "wall-comment"])) {
+ $item['type'] = 'remote-comment';
+ } elseif ($item['type'] == 'wall') {
+ $item['type'] = 'remote';
+ }
+
+ $public_shadow = item_store($item, false, false, true);
+
+ logger("Stored public shadow for thread ".$itemid." under id ".$public_shadow, LOGGER_DEBUG);
+ }
+ }
+ }
+
+ /**
+ * @brief Add a shadow entry for a given item id that is a comment
+ *
+ * This function does the same like the function above - but for comments
+ *
+ * @param integer $itemid Item ID that should be added
+ */
+ public static function addShadowPost($itemid)
+ {
+ $item = dba::selectFirst('item', [], ['id' => $itemid]);
+ if (!DBM::is_result($item)) {
+ return;
+ }
+
+ // Is it a toplevel post?
+ if ($item['id'] == $item['parent']) {
+ self::addShadow($itemid);
+ return;
+ }
+
+ // Is this a shadow entry?
+ if ($item['uid'] == 0)
+ return;
+
+ // Is there a shadow parent?
+ if (!dba::exists('item', ['uri' => $item['parent-uri'], 'uid' => 0])) {
+ return;
+ }
+
+ // Is there already a shadow entry?
+ if (dba::exists('item', ['uri' => $item['uri'], 'uid' => 0])) {
+ return;
+ }
+
+ // Preparing public shadow (removing user specific data)
+ unset($item['id']);
+ $item['uid'] = 0;
+ $item['origin'] = 0;
+ $item['wall'] = 0;
+ $item['contact-id'] = Contact::getIdForURL($item['author-link'], 0);
+
+ if (in_array($item['type'], ["net-comment", "wall-comment"])) {
+ $item['type'] = 'remote-comment';
+ } elseif ($item['type'] == 'wall') {
+ $item['type'] = 'remote';
+ }
+
+ $public_shadow = item_store($item, false, false, true);
+
+ logger("Stored public shadow for comment ".$item['uri']." under id ".$public_shadow, LOGGER_DEBUG);
+ }
}