2. PHPRunner General questions
  3. Using Dynamic Permission
This topic is locked

Using Dynamic Permission

 		4/16/2020 5:08:04 PM
PHPRunner General questions
P
 phppinoy author

I am using a Dynamic Permission security. I have 5000 users. I removed them from the group permission but they can still login but nothing to see. I also tried to filter the Admin User View but users can still login. How do I deactivate several users without deleting their account?
N
 		Nir Frumer 4/16/2020



I am using a Dynamic Permission security. I have 5000 users. I removed them from the group permission but they can still login but nothing to see. I also tried to filter the Admin User View but users can still login. How do I deactivate several users without deleting their account?


hi

for the sake of not hacking the login page

I would create a second users table and move the inactive users records.
hope it helps,
D
 		DealerModulesDevClub member 4/17/2020

You can possible add an additional field "user_status" to your user table.

On designer pages change this field to read only.

In the MySQL window, put a filter to only allow Active users to login. (user_status = "Active")

Then create a view called "SuperAdmin" (copying your user table) , that only you have permission to access where you can change the user status from Active to Inactive.
Paul
need2sleepDevClub member 4/17/2020

You can also remove their email and change the password.
What I have done is similar to the user Dealer Modules.
I have another column "active" in the 'users' table and set the field as tinyint. This makes it a checkbox.
Under the Events Page
Go to: Login Page/Before Login
Get information about what to do here: https://xlinesoft.com/phprunner/docs/before_login.htm
You can create an if active = 0 statement then don't proceed with login/display error etc.
Hope that helps