X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=static%2Fdbview.config.php;h=014973de2640b95a928d67d5842751756596f534;hb=a0b6bdc8de47e4d0add21b36c18b07b3738a40cd;hp=5b3e8b5826b9e6aadfd5ec3077d6328f5f332068;hpb=a2532ad7554602d631d9caabb5c74564328d1fff;p=friendica.git

diff --git a/static/dbview.config.php b/static/dbview.config.php
index 5b3e8b5826..014973de26 100644
--- a/static/dbview.config.php
+++ b/static/dbview.config.php
@@ -1,6 +1,6 @@
 <?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
  *
@@ -91,7 +91,6 @@
 			"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"],
@@ -101,7 +100,7 @@
 			"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"],
@@ -186,7 +185,6 @@
 			"event-location" => ["event", "location"],
 			"event-type" => ["event", "type"],
 			"event-nofinish" => ["event", "nofinish"],
-			"event-adjust" => ["event", "adjust"],
 			"event-ignore" => ["event", "ignore"],
 			"signed_text" => ["diaspora-interaction", "interaction"],
 			"parent-guid" => ["parent-item-uri", "guid"],
@@ -194,6 +192,7 @@
 			"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"],
@@ -250,7 +249,6 @@
 			"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"],
@@ -345,7 +343,6 @@
 			"event-location" => ["event", "location"],
 			"event-type" => ["event", "type"],
 			"event-nofinish" => ["event", "nofinish"],
-			"event-adjust" => ["event", "adjust"],
 			"event-ignore" => ["event", "ignore"],
 			"signed_text" => ["diaspora-interaction", "interaction"],
 			"parent-guid" => ["parent-item-uri", "guid"],
@@ -827,6 +824,7 @@
 			"url" => ["contact", "url"],
 			"nurl" => ["contact", "nurl"],
 			"uri-id" => ["contact", "uri-id"],
+			"guid" => ["item-uri", "guid"],
 			"addr" => ["contact", "addr"],
 			"alias" => ["contact", "alias"],
 			"name" => ["contact", "name"],
@@ -897,6 +895,7 @@
 			"ap-statuses_count" => ["apcontact", "statuses_count"],
 		],
 		"query" => "FROM `contact`
+			LEFT JOIN `item-uri` ON `item-uri`.`id` = `contact`.`uri-id`
 			LEFT JOIN `apcontact` ON `apcontact`.`uri-id` = `contact`.`uri-id`
 			LEFT JOIN `fcontact` ON `fcontact`.`uri-id` = contact.`uri-id`
 			WHERE `contact`.`uid` = 0"			
@@ -909,6 +908,7 @@
 			"url" => ["contact", "url"],
 			"nurl" => ["contact", "nurl"],
 			"uri-id" => ["contact", "uri-id"],
+			"guid" => ["item-uri", "guid"],
 			"addr" => ["contact", "addr"],
 			"alias" => ["contact", "alias"],
 			"name" => ["contact", "name"],
@@ -993,6 +993,7 @@
 		],
 		"query" => "FROM `contact` AS `ucontact`
 			INNER JOIN `contact` ON `contact`.`uri-id` = `ucontact`.`uri-id` AND `contact`.`uid` = 0
+			LEFT JOIN `item-uri` ON `item-uri`.`id` = `ucontact`.`uri-id`
 			LEFT JOIN `apcontact` ON `apcontact`.`uri-id` = `ucontact`.`uri-id`
 			LEFT JOIN `fcontact` ON `fcontact`.`uri-id` = `ucontact`.`uri-id` AND `fcontact`.`network` = 'dspr'"
 	],
@@ -1045,5 +1046,23 @@
 			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`"
+	],
 ];