X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Ftagger.php;h=717c0947769d47b9fb30bd6101332e4a90c22e47;hb=80a4e6263fd53f83a710d2a2e6c57baae38cb14b;hp=400c7787f65949807611f3950794868e808ea5f5;hpb=f828350ba215e7ba724b0310f76f50885b111778;p=friendica.git diff --git a/mod/tagger.php b/mod/tagger.php index 400c7787f6..717c094776 100644 --- a/mod/tagger.php +++ b/mod/tagger.php @@ -175,23 +175,19 @@ 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)) { + $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($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']), + intval($original_item['id']), dbesc($term) ); 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($r[0]['id']), + intval($original_item['id']), $term_objtype, TERM_HASHTAG, dbesc($term),