Database ( Commands )

[_Marco_]

Hello, how can I save all the commands in the database and grant access to each one?

Edited January 4, 2021 by _Marco_

[_Marco_]

@Patrick

[Patrick]

Hi. I don't understand exactly what do you want to do.

A "role system" where you can set allowed admin commands for each role?

Edited January 7, 2021 by Patrick

[_Marco_]

Hi Yes
I want a management system that can give each command separately to each player and store it in the database

/givepermission [PlayerName] [Command To Give]

Save To Mysql

[Patrick]

There are plenty of options.
But if you want to allow commands to specific player, you have to save SERIAL - COMMANDNAME pairs to database.
And load them to a table on resource start.
Then make your own functions to allow, disallow commands, and a function to check is player can use the command or not.

I don't do it instead of you, try it for yourself and if you have any further questions feel free to ask.

Functions and events what you need:
- getPlayerSerial
- dbConnect, dbQuery, dbExec
- maybe setElementData, getElementData
- onResourceStart, onPlayerCommand
- addCommandHandler

Edited January 7, 2021 by Patrick

[_Marco_]

Tnx