aboutsummaryrefslogtreecommitdiffstats
path: root/include
diff options
context:
space:
mode:
authorMario <mario@mariovavti.com>2025-06-13 09:42:09 +0000
committerMario <mario@mariovavti.com>2025-06-13 09:42:09 +0000
commit767eeee6fe7cc31a1aeb24b664034a157ac483fd (patch)
tree9542b3ddf4a6f58f7927667731ce20fa4dcda86c /include
parentabd864a762caf2abf0d0fd8ca96fb8393a0c98e0 (diff)
downloadvolse-hubzilla-767eeee6fe7cc31a1aeb24b664034a157ac483fd.tar.gz
volse-hubzilla-767eeee6fe7cc31a1aeb24b664034a157ac483fd.tar.bz2
volse-hubzilla-767eeee6fe7cc31a1aeb24b664034a157ac483fd.zip
invert the verb query part
Diffstat (limited to 'include')
-rw-r--r--include/items.php8
1 files changed, 4 insertions, 4 deletions
diff --git a/include/items.php b/include/items.php
index 4eda9a221..9e448e39a 100644
--- a/include/items.php
+++ b/include/items.php
@@ -5390,7 +5390,7 @@ function item_by_item_id(int $id, int $parent): array
WHERE
item.id = %d
AND item.uid = %d
- AND item.verb NOT IN ('Like', 'Dislike', 'Announce', 'Accept', 'Reject', 'TentativeAccept', 'Add', 'Remove', 'Follow', 'Ignore')
+ AND item.verb IN ('Create', 'Update', 'EmojiReact')
$item_normal_sql",
intval($id),
intval(local_channel())
@@ -5474,7 +5474,7 @@ function items_by_parent_ids(array $parents, null|array $thr_parents = null, str
ROW_NUMBER() OVER (PARTITION BY item.parent ORDER BY item.created DESC) AS rn
FROM item
WHERE item.parent IN ($ids)
- AND item.verb NOT IN ('Like', 'Dislike', 'Announce', 'Accept', 'Reject', 'TentativeAccept', 'Add', 'Remove', 'Follow', 'Ignore')
+ AND item.verb IN ('Create', 'Update', 'EmojiReact')
AND item.item_thread_top = 0
$thr_parent_sql
$permission_sql
@@ -5626,7 +5626,7 @@ function items_by_thr_parent(string $mid, int $parent, int|null $offset = null):
WHERE
item.thr_parent = '%s'
AND item.uid = %d
- AND item.verb NOT IN ('Like', 'Dislike', 'Announce', 'Accept', 'Reject', 'TentativeAccept', 'Add', 'Remove', 'Follow', 'Ignore')
+ AND item.verb IN ('Create', 'Update', 'EmojiReact')
AND item.item_thread_top = 0
$item_normal_sql
$order_sql",
@@ -5653,7 +5653,7 @@ function items_by_thr_parent(string $mid, int $parent, int|null $offset = null):
WHERE
item.thr_parent = '%s'
AND item.uid = %d
- AND item.verb NOT IN ('Like', 'Dislike', 'Announce', 'Accept', 'Reject', 'TentativeAccept', 'Add', 'Remove', 'Follow', 'Ignore')
+ AND item.verb IN ('Create', 'Update', 'EmojiReact')
AND item.item_thread_top = 0
$permission_sql
$item_normal_sql