[HELP] How to make GA or EM account

11/07/2016 02:01 vzsro#1
How I can create account with restricted console
EXAMPLE: An account for only do events (not being able to obtain items)

:confused::confused:
11/07/2016 03:01 B1Q#2
use this query
Code:
UPDATE TB_User set sec_content='10',sec_primary='10' where StrUserID='username'
07/06/2021 18:10 $Dollar#3
I have the same question. I ran your query but they are able to make items. please help.
07/06/2021 20:50 Judgelemental#4
Quote:
Originally Posted by $Dollar View Post
I have the same question. I ran your query but they are able to make items. please help.
Don't necro.

On-topic:

1 is game developer;
2 content administrator;
3 content user;
4 content marketer;
5 is content monitor;
6 is content GM;
7 is GM Leader.

Just don't add SR_GM_Lvl3 and SR_GM_Lvl5.

SMC -> Security -> Remove one of the security rights, and add only SR_GM_Lvl2 (3 would take away many rights).
07/07/2021 01:21 andzia098#5
The above comments gave a kinda brief explanation about it, however, if you wanna get more 'in-depth' about it, this could either be done from the database (where you could do everything related to a server) or from the SMC like the above comment stated, if you wanna do it through the database, first lemme give you a brief explanation about the Security Groups in sro, the sro security groups start from number 1 to number 7 by default (if no custom groups were made), descending from server developer (the most powerful security group) at sec_content of 1 and going down all the way to 'Content GM Leader' at the sec_content of 7, this image actually shows what i was talking about and it could be found at the _SecurityDescription table of the account database :
[Only registered and activated users can see links. Click Here To Register...]

moving up to what is the privileges of each of the security groups, that's where we need a "privilege" to assign, and this can be easily found in the _SecurityDescriptionGroup in the account database, usually there are 34 privileges, starting from ID 1 to 34, where you can literally control what the account can do, from SMC activities *viewing some functions and not the others* all the way to ingame privileges, this picture should provide some visual aid to ya regarding this :

[Only registered and activated users can see links. Click Here To Register...]

and now, to assign these privileges to each category of the security groups, you need to just head to the _SecurityDescriptionGroupAssign table in your account db, there you'll find 2 columns, one with the groupID and one with the description (or the privilege) ID, where you insert the number of the group you wanna edit, insert what privileges you want this group to just have, and that's it, and to disable ingame item creation, just assign SR_GM_Lvl1 and SR_GM_Lvl2 i guess (not sure about that though cuz i forgot which is which, but the above comment said SR_GM_Lvl2 was enough so its okay), however, you should have a background knowledge of the situation now. Good luck, and last but not least, here's a screen of the assign table :

[Only registered and activated users can see links. Click Here To Register...]

good luck.
07/10/2021 10:36 okulyolu#6
what is this ??
[Only registered and activated users can see links. Click Here To Register...]
07/10/2021 17:54 Devsome#7
Guess anything is told for GA or EM account. Thanks to @[Only registered and activated users can see links. Click Here To Register...] & @[Only registered and activated users can see links. Click Here To Register...].
@[Only registered and activated users can see links. Click Here To Register...] , I would prefer creating a new thread in the right section, because that's a whole separated question .

#closed