This topic is locked
[SOLVED]

Custom Online Add User

4/16/2026 20:19:22
PHPRunner General questions
A
AlphaBase author

I want for my client to be able to add users from the web app online. I do not want to enable dynamic permissions since that would be too confusing for the client and they would be tempted tovmake changes and screw things up. It seems to me you would need to know the encryption key used by PHPRunner during the login and code it. But even then would you use AES_ENCRYPT() or DES_ENCRYPT()? Presumably the former?

Is there a way to do this?

Sergey Kornilov admin 4/16/2026

I'm not quite sure I understand what kind of problem you want to solve by having the access to encryption key. You need to provide more info. Are you sure you are not confusing data encryption with password hashing?

A
AlphaBase author 4/17/2026

To be clear, I'm not trying to encrypt table data.

But I do have Encryption and Bcrypt checked for passwords.

I want my client to be able to add and edit users of the database.

But I don't want him to be able to change the security groups or the permission structure for the various tables that I set up. If I simply enable dynamic permissions and make him an admin he can (and possibly will) mess with the permission structure, causing unintended side-effects. In order to add a new user or to change a user's password we would need to know the default PHPRunner encryption method and key (I guess).

So the question is: how can I give him partial admin rights in effect, limited to adding and editing users/passwords?

Is there a way?

A
AlphaBase author 4/17/2026

Okay figured it out. It was in here: https://xlinesoft.com/phprunner/docs/secapi_password_hashing.htm

I needed to add that code for both the Add & Edit form. Pretty simple. But it took a while to digest the following sentences:

Let's say that you want to provide an admin with direct access to the Login table. To do so, add the following code to the BeforeAdd event of the Login table:

"Login table" threw me off.

We're good now.
Thanks