X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Ftagger.php;h=dd859e61cd04bb1767483880e8a259ba113d6744;hb=b07d47b0f78c93543b742b04446a923a474e25fc;hp=fa8dc35301f017898a15808171d8bc3c17c5b416;hpb=0134fa31d1ee3fb093d0979f01a300957e1b7871;p=friendica.git diff --git a/mod/tagger.php b/mod/tagger.php index fa8dc35301..dd859e61cd 100644 --- a/mod/tagger.php +++ b/mod/tagger.php @@ -5,12 +5,13 @@ use Friendica\App; use Friendica\Core\Addon; use Friendica\Core\L10n; +use Friendica\Core\Logger; use Friendica\Core\System; use Friendica\Core\Worker; -use Friendica\Database\DBM; +use Friendica\Database\DBA; use Friendica\Model\Item; +use Friendica\Util\XML; -require_once 'include/security.php'; require_once 'include/items.php'; function tagger_content(App $a) { @@ -29,13 +30,13 @@ function tagger_content(App $a) { $item_id = (($a->argc > 1) ? notags(trim($a->argv[1])) : 0); - logger('tagger: tag ' . $term . ' item ' . $item_id); + Logger::log('tagger: tag ' . $term . ' item ' . $item_id); - $item = Item::selectFirst(local_user(), [], ['id' => $item_id]); + $item = Item::selectFirst([], ['id' => $item_id]); - if (!$item_id || !DBM::is_result($item)) { - logger('tagger: no item ' . $item_id); + if (!$item_id || !DBA::isResult($item)) { + Logger::log('tagger: no item ' . $item_id); return; } @@ -46,7 +47,7 @@ function tagger_content(App $a) { $r = q("select `nickname`,`blocktags` from user where uid = %d limit 1", intval($owner_uid) ); - if (DBM::is_result($r)) { + if (DBA::isResult($r)) { $owner_nick = $r[0]['nickname']; $blocktags = $r[0]['blocktags']; } @@ -58,15 +59,15 @@ function tagger_content(App $a) { $r = q("select * from contact where self = 1 and uid = %d limit 1", intval(local_user()) ); - if (DBM::is_result($r)) { + if (DBA::isResult($r)) { $contact = $r[0]; } else { - logger('tagger: no contact_id'); + Logger::log('tagger: no contact_id'); return; } - $uri = item_new_uri($a->get_hostname(),$owner_uid); - $xterm = xmlify($term); + $uri = Item::newURI($owner_uid); + $xterm = XML::escape($term); $post_type = (($item['resource-id']) ? L10n::t('photo') : L10n::t('status')); $targettype = (($item['resource-id']) ? ACTIVITY_OBJ_IMAGE : ACTIVITY_OBJ_NOTE ); @@ -76,9 +77,9 @@ function tagger_content(App $a) { $href = System::baseUrl() . '/display/' . $item['guid']; } - $link = xmlify('' . "\n") ; + $link = XML::escape('' . "\n") ; - $body = xmlify($item['body']); + $body = XML::escape($item['body']); $target = <<< EOT @@ -115,11 +116,10 @@ EOT; $arr = []; - $arr['guid'] = get_guid(32); + $arr['guid'] = System::createUUID(); $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']; @@ -160,7 +160,7 @@ EOT; $t = q("SELECT count(tid) as tcount FROM term WHERE oid=%d AND term='%s'", intval($item['id']), - dbesc($term) + DBA::escape($term) ); if (!$blocktags && $t[0]['tcount'] == 0) { @@ -168,34 +168,30 @@ EOT; intval($item['id']), $term_objtype, TERM_HASHTAG, - dbesc($term), - dbesc(System::baseUrl() . '/search?tag=' . $term), + DBA::escape($term), + DBA::escape(System::baseUrl() . '/search?tag=' . $term), intval($owner_uid) ); } // 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)) { + $original_item = Item::selectFirst(['tag', 'id', 'uid'], ['origin' => true, 'uri' => $item['uri']]); + if (DBA::isResult($original_item)) { $x = q("SELECT `blocktags` FROM `user` WHERE `uid`=%d LIMIT 1", - intval($r[0]['uid']) + intval($original_item['uid']) ); $t = q("SELECT COUNT(`tid`) AS `tcount` FROM `term` WHERE `oid`=%d AND `term`='%s'", - intval($r[0]['id']), - dbesc($term) + intval($original_item['id']), + DBA::escape($term) ); - if (DBM::is_result($x) && !$x[0]['blocktags'] && $t[0]['tcount'] == 0){ + if (DBA::isResult($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']), + intval($original_item['id']), $term_objtype, TERM_HASHTAG, - dbesc($term), - dbesc(System::baseUrl() . '/search?tag=' . $term), + DBA::escape($term), + DBA::escape(System::baseUrl() . '/search?tag=' . $term), intval($owner_uid) ); }