X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=static%2Fdbview.config.php;h=5d1231d5a6efca28d7e8a9f10bb9a0b3c74adc1c;hb=d362f8f28290b067817ae1e204ad68eba8446b74;hp=4d7eadc283cfcd30f7127b63d04e72cb9b18aad1;hpb=3d4ace7a9d8541c6e5977bc43eedc02da7257089;p=friendica.git diff --git a/static/dbview.config.php b/static/dbview.config.php old mode 100755 new mode 100644 index 4d7eadc283..5d1231d5a6 --- a/static/dbview.config.php +++ b/static/dbview.config.php @@ -36,7 +36,314 @@ * */ -return [ + return [ + "post-view" => [ + "fields" => [ + "id" => ["item", "id"], + "item_id" => ["item", "id"], + "post-user-id" => ["post-user", "id"], + "uid" => ["item", "uid"], + "parent" => ["item", "parent"], + "uri" => ["item", "uri"], + "uri-id" => ["item", "uri-id"], + "parent-uri" => ["item", "parent-uri"], + "parent-uri-id" => ["item", "parent-uri-id"], + "thr-parent" => ["item", "thr-parent"], + "thr-parent-id" => ["item", "thr-parent-id"], + "guid" => ["item", "guid"], + "type" => ["item", "type"], + "wall" => ["item", "wall"], + "gravity" => ["item", "gravity"], + "extid" => ["item", "extid"], + "created" => ["item", "created"], + "edited" => ["item", "edited"], + "commented" => ["item", "commented"], + "received" => ["item", "received"], + "changed" => ["item", "changed"], + "resource-id" => ["item", "resource-id"], + "post-type" => ["item", "post-type"], + "private" => ["item", "private"], + "pubmail" => ["item", "pubmail"], + "moderated" => ["item", "moderated"], + "visible" => ["item", "visible"], + "starred" => ["item", "starred"], + "bookmark" => ["item", "bookmark"], + "unseen" => ["item", "unseen"], + "deleted" => ["item", "deleted"], + "origin" => ["item", "origin"], + "forum_mode" => ["item", "forum_mode"], + "mention" => ["item", "mention"], + "global" => ["item", "global"], + "network" => ["item", "network"], + "vid" => ["item", "vid"], + "psid" => ["item", "psid"], + "verb" => "IF (`item`.`vid` IS NULL, '', `verb`.`name`)", + "title" => ["item-content", "title"], + "content-warning" => ["item-content", "content-warning"], + "raw-body" => ["item-content", "raw-body"], + "body" => ["item-content", "body"], + "rendered-hash" => ["item-content", "rendered-hash"], + "rendered-html" => ["item-content", "rendered-html"], + "language" => ["item-content", "language"], + "plink" => ["item-content", "plink"], + "location" => ["item-content", "location"], + "coord" => ["item-content", "coord"], + "app" => ["item-content", "app"], + "object-type" => ["item-content", "object-type"], + "object" => ["item-content", "object"], + "target-type" => ["item-content", "target-type"], + "target" => ["item-content", "target"], + "contact-id" => ["item", "contact-id"], + "contact-link" => ["contact", "url"], + "contact-addr" => ["contact", "addr"], + "contact-name" => ["contact", "name"], + "contact-nick" => ["contact", "nick"], + "contact-avatar" => ["contact", "thumb"], + "contact-network" => ["contact", "network"], + "contact-blocked" => ["contact", "blocked"], + "contact-hidden" => ["contact", "hidden"], + "contact-readonly" => ["contact", "readonly"], + "contact-archive" => ["contact", "archive"], + "contact-pending" => ["contact", "pending"], + "contact-rel" => ["contact", "rel"], + "contact-uid" => ["contact", "uid"], + "contact-contact-type" => ["contact", "contact-type"], + "writable" => "IF (`item`.`network` IN ('apub', 'dfrn', 'dspr', 'stat'), true, `contact`.`writable`)", + "self" => ["contact", "self"], + "cid" => ["contact", "id"], + "alias" => ["contact", "alias"], + "photo" => ["contact", "photo"], + "name-date" => ["contact", "name-date"], + "uri-date" => ["contact", "uri-date"], + "avatar-date" => ["contact", "avatar-date"], + "thumb" => ["contact", "thumb"], + "dfrn-id" => ["contact", "dfrn-id"], + "author-id" => ["item", "author-id"], + "author-link" => ["author", "url"], + "author-addr" => ["author", "addr"], + "author-name" => "IF (`contact`.`url` = `author`.`url` AND `contact`.`name` != '', `contact`.`name`, `author`.`name`)", + "author-nick" => ["author", "nick"], + "author-avatar" => "IF (`contact`.`url` = `author`.`url` AND `contact`.`thumb` != '', `contact`.`thumb`, `author`.`thumb`)", + "author-network" => ["author", "network"], + "author-blocked" => ["author", "blocked"], + "author-hidden" => ["author", "hidden"], + "owner-id" => ["item", "owner-id"], + "owner-link" => ["owner", "url"], + "owner-addr" => ["owner", "addr"], + "owner-name" => "IF (`contact`.`url` = `owner`.`url` AND `contact`.`name` != '', `contact`.`name`, `owner`.`name`)", + "owner-nick" => ["owner", "nick"], + "owner-avatar" => "IF (`contact`.`url` = `owner`.`url` AND `contact`.`thumb` != '', `contact`.`thumb`, `owner`.`thumb`)", + "owner-network" => ["owner", "network"], + "owner-blocked" => ["owner", "blocked"], + "owner-hidden" => ["owner", "hidden"], + "causer-id" => ["item", "causer-id"], + "causer-link" => ["causer", "url"], + "causer-addr" => ["causer", "addr"], + "causer-name" => ["causer", "name"], + "causer-nick" => ["causer", "nick"], + "causer-avatar" => ["causer", "thumb"], + "causer-network" => ["causer", "network"], + "causer-blocked" => ["causer", "blocked"], + "causer-hidden" => ["causer", "hidden"], + "causer-contact-type" => ["causer", "contact-type"], + "postopts" => ["post-delivery-data", "postopts"], + "inform" => ["post-delivery-data", "inform"], + "delivery_queue_count" => ["post-delivery-data", "queue_count"], + "delivery_queue_done" => ["post-delivery-data", "queue_done"], + "delivery_queue_failed" => ["post-delivery-data", "queue_failed"], + "allow_cid" => "IF (`item`.`psid` IS NULL, '', `permissionset`.`allow_cid`)", + "allow_gid" => "IF (`item`.`psid` IS NULL, '', `permissionset`.`allow_gid`)", + "deny_cid" => "IF (`item`.`psid` IS NULL, '', `permissionset`.`deny_cid`)", + "deny_gid" => "IF (`item`.`psid` IS NULL, '', `permissionset`.`deny_gid`)", + "event-id" => ["item", "event-id"], + "event-created" => ["event", "created"], + "event-edited" => ["event", "edited"], + "event-start" => ["event", "start"], + "event-finish" => ["event", "finish"], + "event-summary" => ["event", "summary"], + "event-desc" => ["event", "desc"], + "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", "guid"], + "parent-network" => ["parent-item", "network"], + "parent-author-id" => ["parent-item", "author-id"], + "parent-author-link" => ["parent-item-author", "url"], + "parent-author-name" => ["parent-item-author", "name"], + "parent-author-network" => ["parent-item-author", "network"], + ], + "query" => "FROM `item` + LEFT JOIN `post-user` ON `post-user`.`uri-id` = `item`.`uri-id` AND `post-user`.`uid` = `item`.`uid` + STRAIGHT_JOIN `contact` ON `contact`.`id` = `item`.`contact-id` + STRAIGHT_JOIN `contact` AS `author` ON `author`.`id` = `item`.`author-id` + STRAIGHT_JOIN `contact` AS `owner` ON `owner`.`id` = `item`.`owner-id` + STRAIGHT_JOIN `contact` AS `causer` ON `causer`.`id` = `item`.`causer-id` + LEFT JOIN `verb` ON `verb`.`id` = `item`.`vid` + LEFT JOIN `event` ON `event`.`id` = `item`.`event-id` + LEFT JOIN `diaspora-interaction` ON `diaspora-interaction`.`uri-id` = `item`.`uri-id` + LEFT JOIN `item-content` ON `item-content`.`uri-id` = `item`.`uri-id` + LEFT JOIN `post-delivery-data` ON `post-delivery-data`.`uri-id` = `item`.`uri-id` AND `item`.`origin` + LEFT JOIN `permissionset` ON `permissionset`.`id` = `item`.`psid` + STRAIGHT_JOIN `item` AS `parent-item` ON `parent-item`.`uri-id` = `item`.`parent-uri-id` AND `parent-item`.`uid` = `item`.`uid` + STRAIGHT_JOIN `contact` AS `parent-item-author` ON `parent-item-author`.`id` = `parent-item`.`author-id`" + ], + "post-thread-view" => [ + "fields" => [ + "id" => ["item", "id"], + "iid" => ["thread", "iid"], + "item_id" => ["item", "id"], + "uid" => ["thread", "uid"], + "parent" => ["item", "parent"], + "uri" => ["item", "uri"], + "uri-id" => ["item", "uri-id"], + "parent-uri" => ["item", "parent-uri"], + "parent-uri-id" => ["item", "parent-uri-id"], + "thr-parent" => ["item", "thr-parent"], + "thr-parent-id" => ["item", "thr-parent-id"], + "guid" => ["item", "guid"], + "type" => ["item", "type"], + "wall" => ["thread", "wall"], + "gravity" => ["item", "gravity"], + "extid" => ["item", "extid"], + "created" => ["thread", "created"], + "edited" => ["item", "edited"], + "commented" => ["thread", "commented"], + "received" => ["thread", "received"], + "changed" => ["thread", "changed"], + "resource-id" => ["item", "resource-id"], + "post-type" => ["thread", "post-type"], + "private" => ["thread", "private"], + "pubmail" => ["thread", "pubmail"], + "moderated" => ["thread", "moderated"], + "ignored" => ["thread", "ignored"], + "visible" => ["thread", "visible"], + "starred" => ["thread", "starred"], + "bookmark" => ["item", "bookmark"], + "unseen" => ["item", "unseen"], + "deleted" => ["thread", "deleted"], + "origin" => ["thread", "origin"], + "forum_mode" => ["thread", "forum_mode"], + "mention" => ["thread", "mention"], + "global" => ["item", "global"], + "network" => ["thread", "network"], + "vid" => ["item", "vid"], + "psid" => ["item", "psid"], + "verb" => "IF (`item`.`vid` IS NULL, '', `verb`.`name`)", + "title" => ["item-content", "title"], + "content-warning" => ["item-content", "content-warning"], + "raw-body" => ["item-content", "raw-body"], + "body" => ["item-content", "body"], + "rendered-hash" => ["item-content", "rendered-hash"], + "rendered-html" => ["item-content", "rendered-html"], + "language" => ["item-content", "language"], + "plink" => ["item-content", "plink"], + "location" => ["item-content", "location"], + "coord" => ["item-content", "coord"], + "app" => ["item-content", "app"], + "object-type" => ["item-content", "object-type"], + "object" => ["item-content", "object"], + "target-type" => ["item-content", "target-type"], + "target" => ["item-content", "target"], + "contact-id" => ["thread", "contact-id"], + "contact-link" => ["contact", "url"], + "contact-addr" => ["contact", "addr"], + "contact-name" => ["contact", "name"], + "contact-nick" => ["contact", "nick"], + "contact-avatar" => ["contact", "thumb"], + "contact-network" => ["contact", "network"], + "contact-blocked" => ["contact", "blocked"], + "contact-hidden" => ["contact", "hidden"], + "contact-readonly" => ["contact", "readonly"], + "contact-archive" => ["contact", "archive"], + "contact-pending" => ["contact", "pending"], + "contact-rel" => ["contact", "rel"], + "contact-uid" => ["contact", "uid"], + "contact-contact-type" => ["contact", "contact-type"], + "writable" => "IF (`item`.`network` IN ('apub', 'dfrn', 'dspr', 'stat'), true, `contact`.`writable`)", + "self" => ["contact", "self"], + "cid" => ["contact", "id"], + "alias" => ["contact", "alias"], + "photo" => ["contact", "photo"], + "name-date" => ["contact", "name-date"], + "uri-date" => ["contact", "uri-date"], + "avatar-date" => ["contact", "avatar-date"], + "thumb" => ["contact", "thumb"], + "dfrn-id" => ["contact", "dfrn-id"], + "author-id" => ["thread", "author-id"], + "author-link" => ["author", "url"], + "author-addr" => ["author", "addr"], + "author-name" => "IF (`contact`.`url` = `author`.`url` AND `contact`.`name` != '', `contact`.`name`, `author`.`name`)", + "author-nick" => ["author", "nick"], + "author-avatar" => "IF (`contact`.`url` = `author`.`url` AND `contact`.`thumb` != '', `contact`.`thumb`, `author`.`thumb`)", + "author-network" => ["author", "network"], + "author-blocked" => ["author", "blocked"], + "author-hidden" => ["author", "hidden"], + "owner-id" => ["thread", "owner-id"], + "owner-link" => ["owner", "url"], + "owner-addr" => ["owner", "addr"], + "owner-name" => "IF (`contact`.`url` = `owner`.`url` AND `contact`.`name` != '', `contact`.`name`, `owner`.`name`)", + "owner-nick" => ["owner", "nick"], + "owner-avatar" => "IF (`contact`.`url` = `owner`.`url` AND `contact`.`thumb` != '', `contact`.`thumb`, `owner`.`thumb`)", + "owner-network" => ["owner", "network"], + "owner-blocked" => ["owner", "blocked"], + "owner-hidden" => ["owner", "hidden"], + "causer-id" => ["item", "causer-id"], + "causer-link" => ["causer", "url"], + "causer-addr" => ["causer", "addr"], + "causer-name" => ["causer", "name"], + "causer-nick" => ["causer", "nick"], + "causer-avatar" => ["causer", "thumb"], + "causer-network" => ["causer", "network"], + "causer-blocked" => ["causer", "blocked"], + "causer-hidden" => ["causer", "hidden"], + "causer-contact-type" => ["causer", "contact-type"], + "postopts" => ["post-delivery-data", "postopts"], + "inform" => ["post-delivery-data", "inform"], + "delivery_queue_count" => ["post-delivery-data", "queue_count"], + "delivery_queue_done" => ["post-delivery-data", "queue_done"], + "delivery_queue_failed" => ["post-delivery-data", "queue_failed"], + "allow_cid" => "IF (`item`.`psid` IS NULL, '', `permissionset`.`allow_cid`)", + "allow_gid" => "IF (`item`.`psid` IS NULL, '', `permissionset`.`allow_gid`)", + "deny_cid" => "IF (`item`.`psid` IS NULL, '', `permissionset`.`deny_cid`)", + "deny_gid" => "IF (`item`.`psid` IS NULL, '', `permissionset`.`deny_gid`)", + "event-id" => ["item", "event-id"], + "event-created" => ["event", "created"], + "event-edited" => ["event", "edited"], + "event-start" => ["event", "start"], + "event-finish" => ["event", "finish"], + "event-summary" => ["event", "summary"], + "event-desc" => ["event", "desc"], + "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", "guid"], + "parent-network" => ["parent-item", "network"], + "parent-author-id" => ["parent-item", "author-id"], + "parent-author-link" => ["parent-item-author", "url"], + "parent-author-name" => ["parent-item-author", "name"], + "parent-author-network" => ["parent-item-author", "network"], + ], + "query" => "FROM `thread` + STRAIGHT_JOIN `item` ON `item`.`id` = `thread`.`iid` + STRAIGHT_JOIN `contact` ON `contact`.`id` = `thread`.`contact-id` + STRAIGHT_JOIN `contact` AS `author` ON `author`.`id` = `thread`.`author-id` + STRAIGHT_JOIN `contact` AS `owner` ON `owner`.`id` = `thread`.`owner-id` + STRAIGHT_JOIN `contact` AS `causer` ON `causer`.`id` = `item`.`causer-id` + LEFT JOIN `verb` ON `verb`.`id` = `item`.`vid` + LEFT JOIN `event` ON `event`.`id` = `item`.`event-id` + LEFT JOIN `diaspora-interaction` ON `diaspora-interaction`.`uri-id` = `thread`.`uri-id` + LEFT JOIN `item-content` ON `item-content`.`uri-id` = `thread`.`uri-id` + LEFT JOIN `post-delivery-data` ON `post-delivery-data`.`uri-id` = `thread`.`uri-id` AND `thread`.`origin` + LEFT JOIN `permissionset` ON `permissionset`.`id` = `item`.`psid` + STRAIGHT_JOIN `item` AS `parent-item` ON `parent-item`.`id` = `item`.`parent` + STRAIGHT_JOIN `contact` AS `parent-item-author` ON `parent-item-author`.`id` = `parent-item`.`author-id`" + ], "category-view" => [ "fields" => [ "uri-id" => ["post-category", "uri-id"], @@ -68,6 +375,65 @@ return [ LEFT JOIN `tag` ON `post-tag`.`tid` = `tag`.`id` LEFT JOIN `contact` ON `post-tag`.`cid` = `contact`.`id`" ], + "network-item-view" => [ + "fields" => [ + "uri-id" => ["item", "parent-uri-id"], + "uri" => ["item", "parent-uri"], + "parent" => ["item", "parent"], + "received" => ["item", "received"], + "commented" => ["item", "commented"], + "created" => ["item", "created"], + "uid" => ["item", "uid"], + "starred" => ["item", "starred"], + "mention" => ["item", "mention"], + "network" => ["item", "network"], + "unseen" => ["item", "unseen"], + "gravity" => ["item", "gravity"], + "contact-id" => ["item", "contact-id"], + "contact-type" => ["ownercontact", "contact-type"], + ], + "query" => "FROM `item` + INNER JOIN `thread` ON `thread`.`iid` = `item`.`parent` + STRAIGHT_JOIN `contact` ON `contact`.`id` = `thread`.`contact-id` + LEFT JOIN `user-item` ON `user-item`.`iid` = `item`.`id` AND `user-item`.`uid` = `thread`.`uid` + LEFT JOIN `user-contact` AS `author` ON `author`.`uid` = `thread`.`uid` AND `author`.`cid` = `thread`.`author-id` + LEFT JOIN `user-contact` AS `owner` ON `owner`.`uid` = `thread`.`uid` AND `owner`.`cid` = `thread`.`owner-id` + LEFT JOIN `contact` AS `ownercontact` ON `ownercontact`.`id` = `thread`.`owner-id` + WHERE `thread`.`visible` AND NOT `thread`.`deleted` AND NOT `thread`.`moderated` + AND (NOT `contact`.`readonly` AND NOT `contact`.`blocked` AND NOT `contact`.`pending`) + AND (`user-item`.`hidden` IS NULL OR NOT `user-item`.`hidden`) + AND (`author`.`blocked` IS NULL OR NOT `author`.`blocked`) + AND (`owner`.`blocked` IS NULL OR NOT `owner`.`blocked`)" + ], + "network-thread-view" => [ + "fields" => [ + "uri-id" => ["item", "uri-id"], + "uri" => ["item", "uri"], + "parent-uri-id" => ["item", "parent-uri-id"], + "parent" => ["thread", "iid"], + "received" => ["thread", "received"], + "commented" => ["thread", "commented"], + "created" => ["thread", "created"], + "uid" => ["thread", "uid"], + "starred" => ["thread", "starred"], + "mention" => ["thread", "mention"], + "network" => ["thread", "network"], + "contact-id" => ["thread", "contact-id"], + "contact-type" => ["ownercontact", "contact-type"], + ], + "query" => "FROM `thread` + STRAIGHT_JOIN `contact` ON `contact`.`id` = `thread`.`contact-id` + STRAIGHT_JOIN `item` ON `item`.`id` = `thread`.`iid` + LEFT JOIN `user-item` ON `user-item`.`iid` = `item`.`id` AND `user-item`.`uid` = `thread`.`uid` + LEFT JOIN `user-contact` AS `author` ON `author`.`uid` = `thread`.`uid` AND `author`.`cid` = `thread`.`author-id` + LEFT JOIN `user-contact` AS `owner` ON `owner`.`uid` = `thread`.`uid` AND `owner`.`cid` = `thread`.`owner-id` + LEFT JOIN `contact` AS `ownercontact` ON `ownercontact`.`id` = `thread`.`owner-id` + WHERE `thread`.`visible` AND NOT `thread`.`deleted` AND NOT `thread`.`moderated` + AND (NOT `contact`.`readonly` AND NOT `contact`.`blocked` AND NOT `contact`.`pending`) + AND (`user-item`.`hidden` IS NULL OR NOT `user-item`.`hidden`) + AND (`author`.`blocked` IS NULL OR NOT `author`.`blocked`) + AND (`owner`.`blocked` IS NULL OR NOT `owner`.`blocked`)" + ], "owner-view" => [ "fields" => [ "id" => ["contact", "id"], @@ -122,18 +488,18 @@ return [ "term-date" => ["contact", "term-date"], "last-item" => ["contact", "last-item"], "priority" => ["contact", "priority"], - "blocked" => ["contact", "blocked"], /// @todo Check if "blocked" from contact or from the users table + "blocked" => ["user", "blocked"], "block_reason" => ["contact", "block_reason"], "readonly" => ["contact", "readonly"], "writable" => ["contact", "writable"], "forum" => ["contact", "forum"], "prv" => ["contact", "prv"], "contact-type" => ["contact", "contact-type"], + "manually-approve" => ["contact", "manually-approve"], "hidden" => ["contact", "hidden"], "archive" => ["contact", "archive"], "pending" => ["contact", "pending"], "deleted" => ["contact", "deleted"], - "rating" => ["contact", "rating"], "unsearchable" => ["contact", "unsearchable"], "sensitive" => ["contact", "sensitive"], "baseurl" => ["contact", "baseurl"], @@ -145,7 +511,7 @@ return [ "bd" => ["contact", "bd"], "notify_new_posts" => ["contact", "notify_new_posts"], "fetch_further_information" => ["contact", "fetch_further_information"], - "ffi_keyword_blacklist" => ["contact", "ffi_keyword_blacklist"], + "ffi_keyword_denylist" => ["contact", "ffi_keyword_denylist"], "parent-uid" => ["user", "parent-uid"], "guid" => ["user", "guid"], "nickname" => ["user", "nickname"], /// @todo Replaces all uses of "nickname" with "nick" @@ -177,7 +543,7 @@ return [ "account_removed" => ["user", "account_removed"], "account_expired" => ["user", "account_expired"], "account_expires_on" => ["user", "account_expires_on"], - "expire_notification_sent" => ["user", "expire_notification_sent"], + "expire_notification_sent" => ["user", "expire_notification_sent"], "def_gid" => ["user", "def_gid"], "allow_cid" => ["user", "allow_cid"], "allow_gid" => ["user", "allow_gid"],