I am making an admin mod.
I am using SQL to store the players privileges.
There are 50 different privileges.
How should it work?
I have a couple column, atrib1, atrib2 …
I will have one row for each group
Each column stores a letter (a-z) to represent a privileges.
So attib1, a would be ban command, atrib2, b would be kick command.
One data entry may look like abcefhjikl for atrib1 and lamskej for atrib2.
I will use string.gfind to see if they have that permission or not.
I have 2 columns, group and atrib
I will have multiple rows for each group
Each group will have multiple entries such as (group=admin;atrib=ban)
Each group will need a new entry for each atrib
I hope you see what I mean.
So how should I slice it up; what option shall I use?