MySQL Easy make a GOD on your server

[Shawak]

Hello all,
here a very very easy tutorial how to create a GOD on your server :thumbup:.

1. Select your databse and click at the top on "SQL".

2. Paste this query:

#-- Account / Password -----------------#
#-- If you make more GODs,
#-- change the id to 10000002 and so on...

SET @id = 10000001;

SET @name = "GOD TEST";
SET @acc = "ACCOUNT";
SET @pass = "PASSWORD";


#--- Coordinates where the
#-- character will spawn
SET @posx = 1000;
SET @posy = 1000;
SET @posz = 7;
#---------------------------------------#


INSERT INTO `accounts` (`id`,`password`,`group_id`,`name`) VALUES (@id,@pass,6,@acc);
INSERT INTO `players` (`id`,`name`,`group_id`,`account_id`,`looktype`,`town_id`,`posx`,`posy`,`posz`,`save`) VALUES (@id,@name,6,@id,302,1,@posx,@posy,@posz,1);

3. Click on "OK".

4. Be happy with your new GOD :thumbup:.
I tested this with TFS 0.3.5.

Rep++?

Regards,
Shawak

 

[wlj]

nice but do other for noobz like tutor,gm,god,cm,

 

[Shawak]

nice but do other for noobz like tutor,gm,god,cm,

Omg, first answer, thanks ^_^.

 

[Shawak]

Bump!

 

[Znote]

Is the sql query the same for Mystic Spirit 0.2 and Crying Damson 0.3? Which one have you tested this with? Please write so in the post and thread name.

Popular ots have much more accounts than 1000 and if using this script then, will overwrite a user's account.

Also, you should make an easy setup for temple position of the god. ^^

Else than that, very good.

 

[Shawak]

I testet it with tfs 0.3.5,
and you can change the id to whatever you want :thumbup:.

 

[Fragdonut]

Good tutorial!