Page 1 of 2
zzzzsys_setup.set_denied set to 1 on Update
Posted: Mon Dec 07, 2020 2:23 pm
by apmuthu
1. When a fresh install is done and a couple o tables are added and their forms created, logout, and a sql backup of the DB is done.
2. Then login in afresh and navigate to Setup => Builder => Update. Logout and a fresh sql backup of the DB is done.
When we compare the two backups, we find that the field zzzzsys_setup.set_denied is set from 0 to 1.
What does this connote and when does it get reset to 0 if at all?
Also, on a fresh login, the cursor does not blink in the Username field though the focus is there and entry can be done.
Re: zzzzsys_setup.set_denied set to 1 on Update
Posted: Mon Dec 07, 2020 2:56 pm
by kev1n
Hi,
zzzzsys_setup.set_denied should probably be set to 1 initially.
If it is set to 0,
You can access all the Form Properties and code used behind the system Forms like the Objects Form.
Source:
https://forums.nubuilder.cloud/viewtopic. ... 171#p15140
Re: zzzzsys_setup.set_denied set to 1 on Update
Posted: Mon Dec 07, 2020 3:07 pm
by kev1n
apmuthu wrote:
Also, on a fresh login, the cursor does not blink in the Username field though the focus is there and entry can be done.
I don't see this behaviour here (tested with chrome, firefox, edge)
Re: zzzzsys_setup.set_denied set to 1 on Update
Posted: Mon Dec 07, 2020 5:25 pm
by apmuthu
The login behaviour is not visible in FireFox ESR 52.9 - tested on XP sP3. However, it is present in
Basilisk of the same FF build.
Re: zzzzsys_setup.set_denied set to 1 on Update
Posted: Mon Dec 07, 2020 7:23 pm
by kev1n
I downloaded this build, run basilisk.exe and opened nuBuilder. I don't see a focus issue either.
https://o.rthost.win/basilisk/basilisk5 ... 7-xpmod.7z
Re: zzzzsys_setup.set_denied set to 1 on Update
Posted: Tue Dec 08, 2020 6:25 am
by apmuthu
I used the 32bit version on WinXP SP3 and it does not work.
https://o.rthost.win/basilisk/basilisk5 ... 7-xpmod.7z
Re: zzzzsys_setup.set_denied set to 1 on Update
Posted: Wed Dec 09, 2020 8:57 am
by apmuthu
Any mod to set the "set_denied" to 1 from the GUI? A nice feature indeed instead of tinkering with the DB Client each time.
Re: zzzzsys_setup.set_denied set to 1 on Update
Posted: Wed Dec 09, 2020 8:58 am
by kev1n
You could create a (PHP) Procedure to do that.
Re: zzzzsys_setup.set_denied set to 1 on Update
Posted: Wed Dec 09, 2020 9:04 am
by kev1n
Like this:
(or even specify a Launch from Form where you can set it to either 0 or 1)
Re: zzzzsys_setup.set_denied set to 1 on Update
Posted: Wed Dec 09, 2020 12:45 pm
by apmuthu
It would be nice to read the current status and have a button to state it and on clicking to change the button to toggled status:
Code: Select all
read set_denied
show denied status on button
on clicking it, toggle status and display it.
This button can be on the setup tab itself
Also we can make this code as part of the main
nubuilder4.sql itself.