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)
);
}