<?php
/**
- * @copyright Copyright (C) 2010-2021, the Friendica project
+ * @copyright Copyright (C) 2010-2022, the Friendica project
*
* @license GNU AGPL version 3 or any later version
*
"deleted" => ["post-user", "deleted"],
"origin" => ["post-user", "origin"],
"parent-origin" => ["post-thread-user", "origin"],
- "forum_mode" => ["post-thread-user", "forum_mode"],
"mention" => ["post-thread-user", "mention"],
"global" => ["post-user", "global"],
"network" => ["post-user", "network"],
"title" => ["post-content", "title"],
"content-warning" => ["post-content", "content-warning"],
"raw-body" => ["post-content", "raw-body"],
- "body" => ["post-content", "body"],
+ "body" => "IFNULL (`post-content`.`body`, '')",
"rendered-hash" => ["post-content", "rendered-hash"],
"rendered-html" => ["post-content", "rendered-html"],
"language" => ["post-content", "language"],
"parent-author-id" => ["parent-post", "author-id"],
"parent-author-link" => ["parent-post-author", "url"],
"parent-author-name" => ["parent-post-author", "name"],
+ "parent-author-nick" => ["parent-post-author", "nick"],
"parent-author-network" => ["parent-post-author", "network"],
"parent-author-blocked" => ["parent-post-author", "blocked"],
"parent-author-hidden" => ["parent-post-author", "hidden"],
"unseen" => ["post-thread-user", "unseen"],
"deleted" => ["post-user", "deleted"],
"origin" => ["post-thread-user", "origin"],
- "forum_mode" => ["post-thread-user", "forum_mode"],
"mention" => ["post-thread-user", "mention"],
"global" => ["post-user", "global"],
"network" => ["post-thread-user", "network"],
INNER JOIN `workerqueue` ON `workerqueue`.`pid` = `process`.`pid`
WHERE NOT `workerqueue`.`done`"
],
+ "profile_field-view" => [
+ "fields" => [
+ "id" => ["profile_field", "id"],
+ "uid" => ["profile_field", "uid"],
+ "label" => ["profile_field", "label"],
+ "value" => ["profile_field", "value"],
+ "order" => ["profile_field", "order"],
+ "psid"=> ["profile_field", "psid"],
+ "allow_cid" => ["permissionset", "allow_cid"],
+ "allow_gid" => ["permissionset", "allow_gid"],
+ "deny_cid" => ["permissionset", "deny_cid"],
+ "deny_gid" => ["permissionset", "deny_gid"],
+ "created" => ["profile_field", "created"],
+ "edited" => ["profile_field", "edited"],
+ ],
+ "query" => "FROM `profile_field`
+ INNER JOIN `permissionset` ON `permissionset`.`id` = `profile_field`.`psid`"
+ ],
];