Page 1 of 2

GM Privs .. easier way

Posted: Mon Oct 12, 2009 7:26 pm
by TryIt
Okay this is awfully .. i want to make it like the old way when i didnt had to look up 392 commands and fit my needs for GM Privs in a god damn database table...... why you guys are so sadistically to your members :shock: this flexibility is really getting on my nerves... at least make it to chose to use table privs or gm-commands.properties ot whatever you want make it file with 25 simplest commands damn it...

Re: GM Privs .. easier way

Posted: Mon Oct 12, 2009 7:32 pm
by janiii
it would be the same if it would be in a file. same number of commands to set. there are more commands, because there are more chances to set things on l2j for admins. it is only admins narrowness that he cannot set the command privileges for his gm.

Re: GM Privs .. easier way

Posted: Mon Oct 12, 2009 7:57 pm
by TryIt
Have you heard of laziness? Its the most dangerous disease in humans life.

You can lock the topic.

And no i was talking for a file sample of the GMAccess.properties file which was in L2J C4 and still in L2JFree. :evil:

Re: GM Privs .. easier way

Posted: Mon Oct 12, 2009 8:05 pm
by janiii
TryIt wrote:And no i was talking for a file sample of the GMAccess.properties file which was in L2J C4 and still in L2JFree. :evil:
i know which file you are talking about. but the admin commands system changed for a reason.
you can browse in some (much) older revisions for that file if you only want that file for some reason. but if you want to change the privileges, you have to do it in the database now (there are some nice tutorials here on forum or on wiki how to do it, or read the sql file for some info about the system).

Re: GM Privs .. easier way

Posted: Mon Oct 12, 2009 8:22 pm
by TryIt
Dude look.. ill tell you it in another way. We all have personal life's, I'm not a noob which doesn't get a sh*t of SQL .. i just dont have a god damn 3 hours to make those privs for 4 different rangs. Do you get my point? I know how to make it change it and etc ... but i wanted it in the short way... :)

Re: GM Privs .. easier way

Posted: Mon Oct 12, 2009 8:25 pm
by Evilus
TryIt wrote:Dude look.. ill tell you it in another way. We all have personal life's, I'm not a noob which doesn't get a sh*t of SQL .. i just dont have a god damn 3 hours to make those privs for 4 different rangs. Do you get my point? I know how to make it change it and etc ... but i wanted it in the short way... :)
If you don't have 3 hours to spend to fix that maybe you shouldn't be running a l2j server =)

Re: GM Privs .. easier way

Posted: Mon Oct 12, 2009 8:37 pm
by TryIt
Evilus i have already started changing them its whatever now. But everybody have their own system of running a server controlling their staff and finding time for it. Im feeling comfortable with my managing system and this doesnt means that ive shouldnt run it only because some peoples are a bit busier. You may see someday what i mean :wink:

P.S. Please lock the topic

Re: GM Privs .. easier way

Posted: Mon Oct 12, 2009 8:46 pm
by JMD
The bad thing with the SQL Access level is that there are a lot of duplicates and similar commands, its hard for someone that doesn't know to configure them.

Re: GM Privs .. easier way

Posted: Mon Oct 12, 2009 9:12 pm
by janiii
JMD wrote:The bad thing with the SQL Access level is that there are a lot of duplicates and similar commands, its hard for someone that doesn't know to configure them.

still dont understand what the problem is. in a file it would be the same. the same similar and many commands.

Re: GM Privs .. easier way

Posted: Mon Oct 12, 2009 9:53 pm
by TryIt
The problem is that we look up over a bunch of useless commands.. will be better if theres just a system which can make separated GM Rangs and add commands to them whatever you want.. cuz if i want to make developer gm rang for eg i have to make it only with dev commands with access 9 but he will have everything else below 9.. and we cant make it higher than 9 because the admin (owner) is higher than 9 than what comes up? He will have also admin commands.. get it?

I made quite strange system for me but it suites my needs.. and lol i made it for 15 min.. :lol: good for me that i knew 95% of the commands..... the newbies dont know which command what does and they will get totally confused .. they wont finish their privs editing soon... :twisted:

But the most simpler and easiest way is just make 20 commands:
GMAccessLevel = 100
GMMinLevel = 100
GMCanAltG = 100
GMCanAnnounce = 100
GMCanBan = 100
GMCanBanChat = 100
GMCanShop = 100
GMCanBuyFree = 100
GMCanDelete = 100
GMCanKick = 100
GMCanJail = 100
GMCamera = 100
GMMenu = 100
GMGodMode = 100
GMCanEditChar = 100
GMCanEditCharOther = 100
GMCanViewChar = 100
GMCanEditNPC = 100
GMCanViewNPC = 100
GMViewCharacterInfo = 100
GMViewItemList = 100
GMViewClanInfo = 100
GMViewQuestList = 100
GMViewSkillInfo = 100
GMViewWarehouseWithdrawList = 100
GMCanTeleport = 100
GMCanTeleportOther = 100
GMCanRestart = 100
GMMonsterRace = 100
GMRider = 100
GMFastUnstuck = 100
GMResurectFixed = 100
GMEnchant = 100
GMDoor = 100
GMRes = 100
GMPeaceAttack = 100
GMHeal = 100
GMIRC = 100
GMUnblock = 100
GMCache = 100
GMTalkBlock = 100
GMTest = 100
GMFunEngine = 100
GMCreateNodes = 100
See? The most needed commands are here.. you dont need to mod the rest!

Re: GM Privs .. easier way

Posted: Mon Oct 12, 2009 10:43 pm
by MELERIX
old way is not secure.

the new way is much better and allow ranges, and you can edit the new ranges easily with a simple SQL query :P

Re: GM Privs .. easier way

Posted: Tue Oct 13, 2009 12:46 pm
by lishawj
Totally in agreement with above statement. If a person, like myself with NO MySQL experience learned how to set privileges in half an hour of reading, then it's plain laziness when a person with MORE experience complains about setting it in 3 hours. I work full time, play with the kids, the wife needs her fair share of time, I go out to smell the roses every day and I don't recall setting up privileges to take 3 hours.

Loaded up the server, read the access_level.sql file, looked at the command_access file, found the GM command list and executed them one by one to determine what they did. Running through the commands took 10 minutes and another 20 to set it for 10 tiers of privileges. All from a person with no previous MySQL knowledge...when I first started running a server.

Don't assume and make excuses because you are simply too lazy. Noobs can figure this out by themself and probably less then 3 hours.

Good lord.

Re: GM Privs .. easier way

Posted: Tue Oct 13, 2009 6:13 pm
by TryIt
Ive already said that the laziness is the biggest human disease! :P

I was shocked in the first moment because i havent used any SQL browser software like Navicat for example. phpmyadmin rulz! :roll:
Besides with the browser it took mi about 20 min for 4 rangs and the 393 commands. Having knowledge in some sphere of language doesnt always mean you have to know all their software's dont sue me :lol:

Okay i agree it easy and fast, cant say anything else! 8)

But one question to MELERIX .. how it wasnt secured as it was a local file as all other configs? They cant manipulate it in any way.

Re: GM Privs .. easier way

Posted: Tue Oct 13, 2009 11:37 pm
by MELERIX

Re: GM Privs .. easier way

Posted: Sun Oct 18, 2009 10:21 pm
by ZaKaX
The current implementation is way better. It allows you to create different access levels and give them whatever command you want them to use. It's much more flexible then the old one. Updating a row on the database isn't that hard.. even my cat could do it.

Let's say you want to create a new "group" for your Great Monkeys:

Code: Select all

INSERT INTO `jeejee_db`.`access_levels` (`accessLevel`, `name`, `nameColor`, `titleColor`, `childAccess`, `isGm`, `allowPeaceAttack`, `allowFixedRes`, `allowTransaction`, `allowAltg`, `giveDamage`, `takeAggro`, `gainExp`) VALUES ('11', 'Great Monkeys', 'FFFFFF', 'FFFFFF', '', '1', '0', '0', '0', '0', '0', '0', '0');
Damn you're uber. You just created a new group. Now let's give them access to some commands:

Code: Select all

UPDATE `jeejee_db`.`admin_command_access_rights` SET `accessLevels` = '11' WHERE `admin_command_access_rights`.`adminCommand` = 'admin_kick';UPDATE `jeejee_db`.`admin_command_access_rights` SET `accessLevels` = '11' WHERE `admin_command_access_rights`.`adminCommand` = 'admin_open';UPDATE `jeejee_db`.`admin_command_access_rights` SET `accessLevels` = '11' WHERE `admin_command_access_rights`.`adminCommand` = 'admin_close';
Congratulations! Your great monkeys are now able to kick, and open/close doors.

Since you feel uber, you want to do a new group. The uber great monkeys. You want them to have the same right as the great monkey with few more commands. We'll create the uber great monkeys group.

Code: Select all

INSERT INTO `jeejee_db`.`access_levels` (`accessLevel`, `name`, `nameColor`, `titleColor`, `childAccess`, `isGm`, `allowPeaceAttack`, `allowFixedRes`, `allowTransaction`, `allowAltg`, `giveDamage`, `takeAggro`, `gainExp`) VALUES ('10', 'Uber Great Monkeys', 'FFFFFF', 'FFFFFF', '10', '1', '0', '0', '0', '0', '0', '0', '0');
As you can see, we've set the child access of UGM's to 11. (11 is the access level of the Great Monkeys). This means our UGM's will have the same right as the GM's with, in addition, the commands assigned to their level. You want to give them access to the ban command in addition:

Code: Select all

UPDATE `jeejee_db`.`admin_command_access_rights` SET `accessLevels` = '10' WHERE `admin_command_access_rights`.`adminCommand` = 'admin_ban';
You're done. That's all you needed to manage your team rights completely. Just a several querys! See... wasn't so hard.