MySQL How to make a GameMaster!

[Zimny]

Access still controls command usage, but almost nothing else.
To find out what you want your gm's playerflags set to, use this generator: http://hem.bredband.net/johannesrosen/playerflags.html

XML users
To set a player's playerflags, you need to add:
Code:

groupflags="number generated above"

to the <player> tag.

SQL users
To set a player's playerflags, you need to create a new 'player group' by inserting a new row into the "player_groups" table, then set the player's groupid to the id specified when you insterted that row.

CREATE TABLE `groups` (
`id` int(11) NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`flags` bigint(11) NOT NULL default '0',
`access` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `groups` VALUES (3, 'God', 134788128760, 3);
INSERT INTO `groups` VALUES (2, 'Tutor', 68736352768, 2);
INSERT INTO `groups` VALUES (1, 'Player', 0, 0);

 

[Triggah]

many of us know this but i guess it helps noob

so good job

 

[Jonhow]

now that i've seen this it's more easy!!!

 

[Royalkux]

Nice enough would help the noobs (Like me XD)

 

[GangsteR]

It's very nice

 

[4Play]

Good Job
<Too Short>

 

[Yony]

Nice tutorial I was looking for it

 

[Guiminha]

Where should I put this flag?

 

[Memoxelo]

good job :=)

 

[Lithium]

nice tutorial for beginners

 

[fokuleh]

yes, that do a gm but can not execute commands, how to do it?

hey plz i am gm, i have the outfit, i am invincible, but i can not execute commands!, help plz!

 

[Peebles]

were do i put this table groups?

 

[Thimpey]

idd, same. I'm a GM but can't teleport, ban etc "you can not execute this command" :/ I've tested to change ID and Group_ID but it doesn't work really ;/

 

[SowaQ_GMofTytania]

i have problem too ....

I am GM but i can't tp, ban, summon, etc.

Please help me

 

[Nandu]

go to your acc put type 5 and in player id 3, try this

 

[coronal]

What the heck are you talking about?
(I'm no noob, just new on Otland so don't call me noob cuz of my posts ;>)

Well why don't you go in data/players in your OTserver and find the player u want to make into gm. Just open the character.xml file with notepad. Look for access="0" change access to the GM access (Gm access = 5),
so like access="5".


access 0 = player
access 1 = 100% player/50% tutor
access 2 = tutor
access 3 = senior tutor
access 4 = senior tutor
access 5 = GM
access 10 = GOD (usually the hoster of the ot)

 

[Saj]

This is a great tutorial, simple and easy, thanks and good job!

 

[Mr Evil]

Thanks ;D i think im starting to understand sql <:

 

[Easy154]

thanks for this Thread

 

[Morty]

What the heck are you talking about?
(I'm no noob, just new on Otland so don't call me noob cuz of my posts ;>)

Well why don't you go in data/players in your OTserver and find the player u want to make into gm. Just open the character.xml file with notepad. Look for access="0" change access to the GM access (Gm access = 5),
so like access="5".


access 0 = player
access 1 = 100% player/50% tutor
access 2 = tutor
access 3 = senior tutor
access 4 = senior tutor
access 5 = GM
access 10 = GOD (usually the hoster of the ot)

Because that's wrong in about 10 ways.