nuBuilder Forum

Posted: **Wed Dec 09, 2020 1:05 pm**

This could be added in Setup->Header

Posted: **Wed Dec 09, 2020 4:35 pm**

The login username focus issue is there only when the NuBuilder4 URL shortcut is dragged and dropped into the Basilisk browser and not if it is double-clicked or a bookmark clicked!

Posted: **Wed Dec 09, 2020 4:44 pm**

Why would you want do that? I do not consider this an important issue...

Posted: **Wed Dec 09, 2020 5:25 pm**

The login issue is certainly not important - just exploring and informing the extent of JS interactions and found that clicking a bookmark works okay. Thanks for the effort in checking it out.

Posted: **Thu Dec 17, 2020 11:38 pm**

Placing the set_denied setting in the setup tab provides for managing it within the Nubuilder User Interface.

This is achieved by the following SQL statements that can be run on an existing installation of nubuilder4:

Code: Select all

UPDATE `zzzzsys_form` SET `sfo_javascript` = '$(\'#set_header\').addClass(\'html\');\n  \n$(\'.html\').dblclick(function() {\n	nuOpenAce(\'HTML\', this.id);\n});\n\nnuHide(\'nuDeleteButton\');\nnuHide(\'nuCloneButton\');\n\nnuSetToolTip(\'set_denied\',\'Allow access to core forms of nuBuilder.\', true);\n' WHERE `zzzzsys_form_id` = 'nusetup';

INSERT INTO `zzzzsys_object` (`zzzzsys_object_id`,`sob_all_zzzzsys_form_id`,`sob_all_table`,`sob_all_type`,`sob_all_id`,`sob_all_label`,`sob_all_zzzzsys_tab_id`,`sob_all_order`,`sob_all_top`,`sob_all_left`,`sob_all_width`,`sob_all_height`,`sob_all_cloneable`,`sob_all_align`,`sob_all_validate`,`sob_all_access`,`sob_calc_formula`,`sob_calc_format`,`sob_run_zzzzsys_form_id`,`sob_run_filter`,`sob_run_method`,`sob_run_id`,`sob_display_sql`,`sob_select_multiple`,`sob_select_sql`,`sob_lookup_code`,`sob_lookup_description`,`sob_lookup_description_width`,`sob_lookup_autocomplete`,`sob_lookup_zzzzsys_form_id`,`sob_lookup_javascript`,`sob_lookup_php`,`sob_lookup_table`,`sob_subform_zzzzsys_form_id`,`sob_subform_foreign_key`,`sob_subform_add`,`sob_subform_delete`,`sob_subform_type`,`sob_subform_table`,`sob_input_count`,`sob_input_format`,`sob_input_type`,`sob_input_javascript`,`sob_html_code`,`sob_html_chart_type`,`sob_html_javascript`,`sob_html_title`,`sob_html_vertical_label`,`sob_html_horizontal_label`,`sob_image_zzzzsys_file_id`) VALUES
('5fdba6246ffc449','nusetup','zzzzsys_setup','input','set_denied','Access denied','nu5bad6cb36d97acd',40,157,217,20,18,'1','left','0','0','','','','','','','','','','stz_timezone','stz_timezone','0',NULL,'nutimezone','',NULL,'zzzzsys_timezone','','','','','','',0,'','checkbox','','','','','','','','');

What this does is that a form display setting display is made for the new setting in the first statement and the second statement populates the checkbox setting object.

These statements can be appended to the nubuilder4.sql so that any DB Update will allow it to persist. This is so till it gets into the main repo which @admin can take in.

A label to indicate that "This setting allows to hide the system forms and objects" can be placed to the right of the checkbox for clarity.

Credits: @kev1n

Posted: **Fri Dec 18, 2020 7:47 am**

Committed in my repo.

Posted: **Sat Jan 02, 2021 10:46 am**

My repo has the changes committed:
* SQL commit
* Code commit

nuBuilder Forum

zzzzsys_setup.set_denied set to 1 on Update

Re: zzzzsys_setup.set_denied set to 1 on Update

Re: zzzzsys_setup.set_denied set to 1 on Update

Re: zzzzsys_setup.set_denied set to 1 on Update

Re: zzzzsys_setup.set_denied set to 1 on Update

Re: zzzzsys_setup.set_denied set to 1 on Update

Re: zzzzsys_setup.set_denied set to 1 on Update

Re: zzzzsys_setup.set_denied set to 1 on Update