X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Ftagger.php;h=0c515f9c8bbe1bdfd38937c2007118625f0945e4;hb=5c63de1692c5be4ca457e03fc037683909a44348;hp=c91fb4abaa82a8d3703072f37941946a4032b9ea;hpb=2ad162f991fdd32122b029398b9ab9e8801c0462;p=friendica.git diff --git a/mod/tagger.php b/mod/tagger.php index c91fb4abaa..0c515f9c8b 100644 --- a/mod/tagger.php +++ b/mod/tagger.php @@ -1,44 +1,47 @@ argc > 1) ? notags(trim($a->argv[1])) : 0); logger('tagger: tag ' . $term . ' item ' . $item_id); - $r = q("SELECT * FROM `item` WHERE `id` = '%s' LIMIT 1", - dbesc($item_id) - ); + $item = Item::selectFirst([], ['id' => $item_id]); - if(! $item_id || (! DBM::is_result($r))) { + if (!$item_id || !DBM::is_result($item)) { logger('tagger: no item ' . $item_id); return; } - $item = $r[0]; - $owner_uid = $item['uid']; + $owner_nick = ''; + $blocktags = 0; $r = q("select `nickname`,`blocktags` from user where uid = %d limit 1", intval($owner_uid) @@ -48,26 +51,32 @@ function tagger_content(App $a) { $blocktags = $r[0]['blocktags']; } - if(local_user() != $owner_uid) + if (local_user() != $owner_uid) { return; + } $r = q("select * from contact where self = 1 and uid = %d limit 1", intval(local_user()) ); - if (DBM::is_result($r)) + if (DBM::is_result($r)) { $contact = $r[0]; - else { + } else { logger('tagger: no contact_id'); return; } - $uri = item_new_uri($a->get_hostname(),$owner_uid); + $uri = Item::newURI($owner_uid); $xterm = xmlify($term); - $post_type = (($item['resource-id']) ? t('photo') : t('status')); + $post_type = (($item['resource-id']) ? L10n::t('photo') : L10n::t('status')); $targettype = (($item['resource-id']) ? ACTIVITY_OBJ_IMAGE : ACTIVITY_OBJ_NOTE ); - $link = xmlify('' . "\n") ; + if ($owner_nick) { + $href = System::baseUrl() . '/display/' . $owner_nick . '/' . $item['id']; + } else { + $href = System::baseUrl() . '/display/' . $item['guid']; + } + + $link = xmlify('' . "\n") ; $body = xmlify($item['body']); @@ -96,21 +105,20 @@ EOT; EOT; - $bodyverb = t('%1$s tagged %2$s\'s %3$s with %4$s'); + $bodyverb = L10n::t('%1$s tagged %2$s\'s %3$s with %4$s'); - if (! isset($bodyverb)) { + if (!isset($bodyverb)) { return; } $termlink = html_entity_decode('⌗') . '[url=' . System::baseUrl() . '/search?tag=' . urlencode($term) . ']'. $term . '[/url]'; - $arr = array(); + $arr = []; - $arr['guid'] = get_guid(32); + $arr['guid'] = System::createGUID(32); $arr['uri'] = $uri; $arr['uid'] = $owner_uid; $arr['contact-id'] = $contact['id']; - $arr['type'] = 'activity'; $arr['wall'] = $item['wall']; $arr['gravity'] = GRAVITY_COMMENT; $arr['parent'] = $item['id']; @@ -139,35 +147,22 @@ EOT; $arr['deny_gid'] = $item['deny_gid']; $arr['visible'] = 1; $arr['unseen'] = 1; - $arr['last-child'] = 1; $arr['origin'] = 1; - $post_id = item_store($arr); - -// q("UPDATE `item` set plink = '%s' where id = %d", -// dbesc(System::baseUrl() . '/display/' . $owner_nick . '/' . $post_id), -// intval($post_id) -// ); + $post_id = Item::insert($arr); - - if(! $item['visible']) { - $r = q("UPDATE `item` SET `visible` = 1 WHERE `id` = %d AND `uid` = %d", - intval($item['id']), - intval($owner_uid) - ); + if (!$item['visible']) { + Item::update(['visible' => true], ['id' => $item['id']]); } - $term_objtype = (($item['resource-id']) ? TERM_OBJ_PHOTO : TERM_OBJ_POST ); - $t = q("SELECT count(tid) as tcount FROM term WHERE oid=%d AND term='%s'", - intval($item['id']), - dbesc($term) - ); - if((! $blocktags) && $t[0]['tcount']==0 ) { - /*q("update item set tag = '%s' where id = %d", - dbesc($item['tag'] . (strlen($item['tag']) ? ',' : '') . '#[url=' . System::baseUrl() . '/search?tag=' . $term . ']'. $term . '[/url]'), - intval($item['id']) - );*/ + $term_objtype = ($item['resource-id'] ? TERM_OBJ_PHOTO : TERM_OBJ_POST); + $t = q("SELECT count(tid) as tcount FROM term WHERE oid=%d AND term='%s'", + intval($item['id']), + dbesc($term) + ); + + if (!$blocktags && $t[0]['tcount'] == 0) { q("INSERT INTO term (oid, otype, type, term, url, uid) VALUE (%d, %d, %d, '%s', '%s', %d)", intval($item['id']), $term_objtype, @@ -179,48 +174,36 @@ EOT; } // if the original post is on this site, update it. - - $r = q("select `tag`,`id`,`uid` from item where `origin` = 1 AND `uri` = '%s' LIMIT 1", - dbesc($item['uri']) - ); - if (DBM::is_result($r)) { - $x = q("SELECT `blocktags` FROM `user` WHERE `uid` = %d limit 1", - intval($r[0]['uid']) + $original_item = Item::selectFirst(['tag', 'id', 'uid'], ['origin' => true, 'uri' => $item['uri']]); + if (DBM::is_result($original_item)) { + $x = q("SELECT `blocktags` FROM `user` WHERE `uid`=%d LIMIT 1", + intval($original_item['uid']) ); - $t = q("SELECT count(tid) as tcount FROM term WHERE oid=%d AND term='%s'", - intval($r[0]['id']), + $t = q("SELECT COUNT(`tid`) AS `tcount` FROM `term` WHERE `oid`=%d AND `term`='%s'", + intval($original_item['id']), dbesc($term) ); - if(count($x) && !$x[0]['blocktags'] && $t[0]['tcount']==0){ - q("INSERT INTO term (oid, otype, type, term, url, uid) VALUE (%d, %d, %d, '%s', '%s', %d)", - intval($r[0]['id']), - $term_objtype, - TERM_HASHTAG, - dbesc($term), - dbesc(System::baseUrl() . '/search?tag=' . $term), - intval($owner_uid) - ); - } - /*if(count($x) && !$x[0]['blocktags'] && (! stristr($r[0]['tag'], ']' . $term . '['))) { - q("update item set tag = '%s' where id = %d", - dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . '#[url=' . System::baseUrl() . '/search?tag=' . $term . ']'. $term . '[/url]'), - intval($r[0]['id']) + if (DBM::is_result($x) && !$x[0]['blocktags'] && $t[0]['tcount'] == 0){ + q("INSERT INTO term (`oid`, `otype`, `type`, `term`, `url`, `uid`) VALUE (%d, %d, %d, '%s', '%s', %d)", + intval($original_item['id']), + $term_objtype, + TERM_HASHTAG, + dbesc($term), + dbesc(System::baseUrl() . '/search?tag=' . $term), + intval($owner_uid) ); - }*/ - + } } $arr['id'] = $post_id; - call_hooks('post_local_end', $arr); + Addon::callHooks('post_local_end', $arr); - Worker::add(PRIORITY_HIGH, "notifier", "tag", $post_id); + Worker::add(PRIORITY_HIGH, "Notifier", "tag", $post_id); killme(); return; // NOTREACHED - - }