MySQL How to create a GM/GOD in 3 simple steps

[tyngaste]

Thanks Dude! Great work ^^ :huh:<_<

helped me alot, and worked at first try thanks
ill rep

Wow that was easy! Thanks for the tutorail! And i'll add reputation for ya

Cya later!!

Thanks it works fine for me

why not share it with us if you managed to fix it for newer revisions? and if you did not nvm

 

[Ravauvial]

omg ppl u need to fing help ppl like bad it not funny if u no plz reply or ill bug u not like a virus like ill message u on all ur post forums and ya i have da power bwa ha ha ha

 

[Dede]

nice tutorial

 

[KnightmareZ]

I dont find the "Tibia" on step nr 2.

 

[LordXavy]

I dont find the "Tibia" on step nr 2.

Ah it is of him detabase name. Everyone can have other name of it detabase.

 

[Michael Havoc]

In order to change the commands someone can issue or the abilities of a GOD or Tutor you use flags, there is a website where you select what you want them to do hit enter and it gives you the right flag, I cannot remember the site and I'm trying to find it but that is how you really make an accurate and stable GM / God (It pertains to creating groups as well)


EDIT:
For the flags the website is: http://hem.bredband.net/johannesrosen/playerflags.html

 

[Daan]

Hey, nice nice worked..
but can you also can create tutors.. ?
do you need to change your acces then?
And 1 normal player?
2 Tutor?
3 senior tutor?
4 cm?
5 gm?
5 God ?

 

[Daan]

In order to change the commands someone can issue or the abilities of a GOD or Tutor you use flags, there is a website where you select what you want them to do hit enter and it gives you the right flag, I cannot remember the site and I'm trying to find it but that is how you really make an accurate and stable GM / God (It pertains to creating groups as well)


EDIT:
For the flags the website is: Player flags

where do you need to put the flags? :blink:

 

[Nasholito]

Its a bug , i cant do that

 

[Delirium]

Nice tutorial but one question; Why do you write "GOD" instead of "God"? I mean why in capitals? It's not any abbreviation

 

[kerker]

not working... Fel
SQL-fråga:

#---------------------------------------------------
INSERT INTO accounts( `id` , `password` , `type` , `group_id` )
VALUES (

@acc , @pass , 5, (

SELECT `id`
FROM groups
WHERE `name` = 'a god'
)
);



MySQL sa:

#1062 - Duplicate entry '112233' for key 1

 

[Daan]

Heyo if you got,

"PASSWORD"
do you need to delete the ""
ore not?

 

[Sizaro]

Just make a new char and change it to id 6? -.-

 

[Winnerandy]

Just make a new char and change it to id 6? -.-

Exactly!

Why making things much harder?

Btw, nice tutorial. (With pictures, and nice explained)

 

[Krypt]

hmmm ive done this BUT no matter what, no commands are working, btw where the hell IS commands.XML.... isn't it ment to be in the data/XML/ folder????

EDIT: I am using TFS Version: 0.3.4 (Crying Damson) Patch Level 2

 

[Pro Warbringer]

Fehler

SQL-Befehl: Dokumentation

INSERT INTO accounts( `id` , `password` , `type` , `group_id` )
VALUES (
@acc , @pass , 5, (

SELECT `id`
FROM groups
WHERE `name` = 'a god'
)
);

MySQL meldet: Dokumentation
#1146 - Table 'war server.groups' doesn't exist

 

[zyirc]

Just change on accounts: Group id (3) and Type: (5) and goto Players: Group id 3.

You Are Done.

 

[korre12]

Error
SQL-question:

#---------------------------------------------------
INSERT INTO accounts( `id` , `password` , `type` , `group_id` )
VALUES (

@acc , @pass , 5, (

SELECT `id`
FROM groups
WHERE `name` = 'a god'
)
);



MySQL sa:

#1146 - Table 'tfs.groups' doesn't exist

 

[4545307]

In Charzard We DontTrust

 

[Silas]

I need to know I eat q to make to create a normal player of this skill, plx help.