X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Ftagger.php;h=400c7787f65949807611f3950794868e808ea5f5;hb=f828350ba215e7ba724b0310f76f50885b111778;hp=90fd2414b8af9bbd5a951f4a4a38bb0db2b3a062;hpb=26b335ef3d8b1ec4e1b4e22cd7d3c34e66d2549d;p=friendica.git
diff --git a/mod/tagger.php b/mod/tagger.php
index 90fd2414b8..400c7787f6 100644
--- a/mod/tagger.php
+++ b/mod/tagger.php
@@ -1,17 +1,21 @@
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,9 +105,9 @@ 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;
}
@@ -139,35 +148,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,
@@ -180,47 +176,39 @@ 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",
+ $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",
+ $x = q("SELECT `blocktags` FROM `user` WHERE `uid`=%d LIMIT 1",
intval($r[0]['uid'])
);
- $t = q("SELECT count(tid) as tcount FROM term WHERE oid=%d AND term='%s'",
+ $t = q("SELECT COUNT(`tid`) AS `tcount` FROM `term` WHERE `oid`=%d AND `term`='%s'",
intval($r[0]['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($r[0]['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);
killme();
return; // NOTREACHED
-
-
}