Sonya* Posted November 1, 2020 Posted November 1, 2020 (edited) This app allows creating club features based on the Pages databases. E. g. if you have an Articles database, the app will allow the clubs‘ owners to create articles within the club. Any database that exists in Pages can be added to the club. The permission for databases is defined in the the clubs permissions for each user group. Only databases that use categories can be used in clubs. Visit a demo club to see how it looks like. Features: Set per group permission for every database in the group settings Database category permissions are replaced by club permissions Club header is added to category index and record Club owner can change the category name and description Show records in the club overview tab Clubs use database templates for Category List, Record, and Record Form set in the database settings NOTE: Pages must be installed and enabled to use this app. Edited November 2, 2020 by Sonya* WP V0RT3X and Jalal arefen 2
PrettyPixels Posted November 10, 2020 Posted November 10, 2020 This is an amazing idea! 🙂 I have a couple of pre-sale questions: 1) Is it possible to limit adding records to only the club leaders and moderators? Is this adjustable on a per-database basis? 2) If I have custom fields defined for my clubs, is it possible to have certain databases only show up in clubs that have a certain value selected? For example, I have a custom club field where the user can select their club category and can choose from either discussion or books. If I have a database for chapters, is it possible the option to use that database is only available is the user selected the books category? I suspect this may require custom coding. If so, are you available for custom work? Jalal arefen 1
Sonya* Posted November 11, 2020 Author Posted November 11, 2020 15 hours ago, PrettyPixels said: 1) Is it possible to limit adding records to only the club leaders and moderators? Is this adjustable on a per-database basis? Not right now. The permission for the club category are overloaded with club permission. If the club is public, then everybody can create records. If open - only club members. If closed or private, the records are not shown anywhere else except of in the club. Restricting add permission to club owner only can be done in the future version. 15 hours ago, PrettyPixels said: 2) If I have custom fields defined for my clubs, is it possible to have certain databases only show up in clubs that have a certain value selected? For example, I have a custom club field where the user can select their club category and can choose from either discussion or books. If I have a database for chapters, is it possible the option to use that database is only available is the user selected the books category? No, the permission to add a club feature is (like for any other feature) set on the group permission. It does not depend on club type or certain club values. This can be done as custom solution. 15 hours ago, PrettyPixels said: I suspect this may require custom coding. If so, are you available for custom work? Generally yes. But I am not able to make any urgent work right now due to pandemic measurements that are unpredictable. I depend entirely on kindergarten child care. If it is suddenly not available, then I am not available either. Unfortunately. Jalal arefen and PrettyPixels 1 1
Colombia Humana Posted January 16, 2021 Posted January 16, 2021 Hi there, I'd like to understand a bit better how it works. When a record is added to the Database through a Club, it is then is it visible for all clubs with access to the same Database/Category, and Pages displaying the same Database? Or each record added by the club is "isolated" and accesible through the Club page. Also, related to the same concern: what happens to the Database entries when the Club requires users to join to display the contents? Kind regards.
Sonya* Posted January 16, 2021 Author Posted January 16, 2021 (edited) 7 minutes ago, Daniel B. said: When a record is added to the Database through a Club, it is then is it visible for all clubs with access to the same Database/Category, and Pages displaying the same Database? Or each record added by the club is "isolated" and accesible through the Club page. Technically, it is a category in Pages database that is assigned to this club only. It behaves the same way other club nodes do, like forums, blogs, galleries and so on. 7 minutes ago, Daniel B. said: what happens to the Database entries when the Club requires users to join to display the contents? The same as above. Database categories within clubs inherit club permissions and ignores permission set for the whole database in ACP. So, yes, if it is a private club, one has to join to see the content stored in this database category. If it is a public club, it is visible to any user, like any other node within public club. Edited January 16, 2021 by Sonya* Jalal arefen 1
Colombia Humana Posted June 10, 2021 Posted June 10, 2021 @Sonya* I wonder if you have plans on making this app compatible with v4.6? Kind regards.
Sonya* Posted June 13, 2021 Author Posted June 13, 2021 On 6/10/2021 at 6:40 PM, DanielFb said: @Sonya* I wonder if you have plans on making this app compatible with v4.6? Kind regards. Yes. I will look into it next week when German translation is ready.
Sonya* Posted June 29, 2021 Author Posted June 29, 2021 The application is updated and is waiting for approval. No changes are required, though. You can update your community to 4.6 and use the 4.5 version of this app without issues.
Daniel F Posted October 12, 2021 Posted October 12, 2021 This application isn't handling the category deletion correct because it's leaving the mapped club data in the database, which results in following error: Class 'IPS\cms\Categories12' not found #0 /system/Member/Club/Club.php(1882): IPS\Member\_Club->nodes() #1 /system/Member/Club/Club.php(2020): IPS\Member\_Club->tabs() #2 /applications/core/modules/front/clubs/view.php(130): IPS\Member\_Club->firstTab() #3 /system/Dispatcher/Controller.php(101): IPS\core\modules\front\clubs\_view->manage() #4 /applications/core/modules/front/clubs/view.php(120): IPS\Dispatcher\_Controller->execute() #5 /system/Dispatcher/Dispatcher.php(153): IPS\core\modules\front\clubs\_view->execute() #6 /index.php(13): IPS\_Dispatcher->run() #7 {main} Sonya* and Haagimus 1 1
Ioannis D Posted October 28, 2021 Posted October 28, 2021 (edited) Hi, I have an issue when I try to edit the club database from ACP. I can't edit or delete any added database from anywhere else in Clubs. SELECT * FROM `cms_database_categories` WHERE category_club_id=1 ORDER BY category_position IPS\Db\Exception: Unknown column 'category_club_id' in 'where clause' (1054) #0 /system/Db/Select.php(388): IPS\_Db->preparedQuery() #1 /system/Db/Select.php(286): IPS\Db\_Select->runQuery() #2 /system/Node/Model.php(224): IPS\Db\_Select->setKeyField() #3 /init.php(902) : eval()'d code(251): IPS\Node\_Model::nodesWithPermission() #4 /system/Node/Model.php(180): IPS\cms\clubdbs_hook_categories::nodesWithPermission() #5 /applications/cms/sources/Categories/Categories.php(273): IPS\Node\_Model::roots() #6 /applications/core/modules/admin/clubs/clubs.php(567): IPS\cms\_Categories::roots() #7 /system/Helpers/Tree/Tree.php(130): IPS\core\modules\admin\clubs\_clubs->_getNodeRows() #8 /system/Theme/Theme.php(860) : eval()'d code(3927): IPS\Helpers\Tree\_Tree->__toString() #9 /system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_admin_global->tabs() #10 /applications/core/modules/admin/clubs/clubs.php(280): IPS\Theme\_SandboxedTemplate->__call() #11 /system/Dispatcher/Controller.php(90): IPS\core\modules\admin\clubs\_clubs->edit() #12 /applications/core/modules/admin/clubs/clubs.php(38): IPS\Dispatcher\_Controller->execute() #13 /system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\clubs\_clubs->execute() #14 /admin/index.php(13): IPS\_Dispatcher->run() #15 {main} And from the System Logs. Type: uncaught_exception SELECT * FROM `cms_database_categories` WHERE category_club_id=1 ORDER BY category_position IPS\Db\Exception: Unknown column 'category_club_id' in 'where clause' (1054) #0 /system/Db/Select.php(388): IPS\_Db->preparedQuery() #1 /system/Db/Select.php(286): IPS\Db\_Select->runQuery() #2 /system/Node/Model.php(224): IPS\Db\_Select->setKeyField() #3 /init.php(902) : eval()'d code(251): IPS\Node\_Model::nodesWithPermission() #4 /system/Node/Model.php(180): IPS\cms\clubdbs_hook_categories::nodesWithPermission() #5 /applications/cms/sources/Categories/Categories.php(273): IPS\Node\_Model::roots() #6 /applications/core/modules/admin/clubs/clubs.php(567): IPS\cms\_Categories::roots() #7 /system/Helpers/Tree/Tree.php(130): IPS\core\modules\admin\clubs\_clubs->_getNodeRows() #8 /system/Theme/Theme.php(860) : eval()'d code(3927): IPS\Helpers\Tree\_Tree->__toString() #9 /system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_admin_global->tabs() #10 /applications/core/modules/admin/clubs/clubs.php(280): IPS\Theme\_SandboxedTemplate->__call() #11 /system/Dispatcher/Controller.php(90): IPS\core\modules\admin\clubs\_clubs->edit() #12 /applications/core/modules/admin/clubs/clubs.php(38): IPS\Dispatcher\_Controller->execute() #13 /system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\clubs\_clubs->execute() #14 /admin/index.php(13): IPS\_Dispatcher->run() #15 {main} BACKTRACE #0 /public/init.php(1004): IPS\_Log::log() #1 /system/Helpers/Tree/Tree.php(166): IPS\IPS::exceptionHandler() #2 /system/Theme/Theme.php(860) : eval()'d code(3927): IPS\Helpers\Tree\_Tree->__toString() #3 /system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_admin_global->tabs() #4 /applications/core/modules/admin/clubs/clubs.php(280): IPS\Theme\_SandboxedTemplate->__call() #5 /system/Dispatcher/Controller.php(90): IPS\core\modules\admin\clubs\_clubs->edit() #6 /applications/core/modules/admin/clubs/clubs.php(38): IPS\Dispatcher\_Controller->execute() #7 /system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\clubs\_clubs->execute() #8 /admin/index.php(13): IPS\_Dispatcher->run() #9 {main} Edited October 28, 2021 by Ioannis D
Sonya* Posted October 29, 2021 Author Posted October 29, 2021 (edited) @Ioannis D, thanks for your report. I will submit a fix today @Daniel has reported before. I am not sure, if it is the same issue, you have. Can you please provide the steps in ACP to reproduce the error? Thank you! Edit: I could reproduce the error and make a fix asap. Edited October 29, 2021 by Sonya* Ioannis D 1
Sonya* Posted October 29, 2021 Author Posted October 29, 2021 Fix is submitted, waiting for approval... Ioannis D 1
Ioannis D Posted November 2, 2021 Posted November 2, 2021 @Sonya*, Thank you! The issue has been fixed. Sonya* 1
Ioannis D Posted November 3, 2021 Posted November 3, 2021 With this update I can't add any new database in Clubs. Each new database doesn't appear in "Allowed content areas in clubs" Group settings and I can't see it in "Add Club Feature" Also, with the "Show Club Content Areas: Only within Clubs" setting, every new database category (to an existing database) in Clubs, appears in database categories. Is it a bug or I missing something?
Sonya* Posted November 3, 2021 Author Posted November 3, 2021 5 minutes ago, Ioannis D said: With this update I can't add any new database in Clubs. Each new database doesn't appear in "Allowed content areas in clubs" Group settings and I can't see it in "Add Club Feature" No changes, it works. Please ensure that new database is assigned to a page. If it is not, it is not displayed in Allowed content areas. 10 minutes ago, Ioannis D said: Also, with the "Show Club Content Areas: Only within Clubs" setting, every new database category (to an existing database) in Clubs, appears in database categories. Confirmed. Ioannis D 1
Ioannis D Posted November 3, 2021 Posted November 3, 2021 9 minutes ago, Sonya* said: No changes, it works. Please ensure that new database is assigned to a page. If it is not, it is not displayed in Allowed content areas. Can I assigned 2 databases to a page? I can't see in left area the database block in order to drag and drop it to the page that is also another database.
Sonya* Posted November 3, 2021 Author Posted November 3, 2021 8 hours ago, Ioannis D said: Can I assigned 2 databases to a page? No, you cannot. In IPS each database needs own page, otherwise the database cannot be used in frontend. Ioannis D 1
Manuel Molina Posted March 30, 2022 Posted March 30, 2022 Hi @Sonya*, quick question, if database is wiki style, can club members collaborate on documents created in DB?
Sonya* Posted March 31, 2022 Author Posted March 31, 2022 14 hours ago, Manuel Molina said: Hi @Sonya*, quick question, if database is wiki style, can club members collaborate on documents created in DB? I have not tried it yet. I suppose it will not respect the wiki permissions, as wiki permissions will be overloaded with club permissions. Generally, club permissions are very limited and are incompatible with member groups permissions. This is IPS, not my app. BTW, There will also be display issues when you try to add categories block to the database page. I am aware of this, but I have not found any simple solution for it. This app is quite limited to just CRUD of database records inside one category using default display and listing template. Nothing more 😞 Manuel Molina 1
Manuel Molina Posted March 31, 2022 Posted March 31, 2022 3 hours ago, Sonya* said: I have not tried it yet. I suppose it will not respect the wiki permissions, as wiki permissions will be overloaded with club permissions. Generally, club permissions are very limited and are incompatible with member groups permissions. This is IPS, not my app. BTW, There will also be display issues when you try to add categories block to the database page. I am aware of this, but I have not found any simple solution for it. This app is quite limited to just CRUD of database records inside one category using default display and listing template. Nothing more 😞 Thank you Sonya.
Sonya* Posted July 17, 2022 Author Posted July 17, 2022 I am updating other apps right now. This one will be the last.
Colombia Humana Posted October 25, 2022 Posted October 25, 2022 How can I renew this app in order to upgrade it?
Randy Calvert Posted October 25, 2022 Posted October 25, 2022 https://invisioncommunity.com/clients/purchases/ Find the purchase and there should be a Renew Now button towards the right of the page next to it.
Recommended Posts