Updated messages.po

[friendica.git] / static / dbview.config.php

diff --git a/static/dbview.config.php b/static/dbview.config.php
index 63215968b66e1eecd0681171d93616a9b9f77289..014973de2640b95a928d67d5842751756596f534 100644 (file)
--- 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"],
@@ -193,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"],
@@ -249,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"],
@@ -825,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"],
@@ -895,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"                      
@@ -907,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"],
@@ -991,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'"
        ],
@@ -1043,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`"
+       ],
 ];