Thanks to MMan from Aegis boards, how to make yourself GM!

[hellprowler]

Yea, this was finally achieved, but Let me state this, THIS IS NOT FOR NEWBIES WHO DON'T KNOW ANYTHING. You really need to know what the heck you are doing, otherwise it will make no sense to you at ALL. Until there is an easier way to do this (such as modifying account table), this is the only way to go:

Ok... I had time to look at aglaia server...

GM characters have GM_ at begining of their names. Client doesn't allow you to make such character so we need to use query analyzer for it.

first we make character that has GN_ at begining... Like "GN_MMan"

Then close server becose servers cache data.

Then we query our character data from db.
Note: my accounts name was MMan and character was in first slot... change char1 and Character1 to match yout characters slot.

SELECT char1 FROM Character1 WHERE id = 'MMan'

Returned me this:

0x0003481001003219474E5F4D4D616E000000000000000000ADB7A4A7AEC8A448000000000000000040420F00000000000000000040420F00000000000000000000030100140505050500000300010400AF00440082008E0081000000030000000000000000000000000000000000000000000000000000000000000000000000

Part we art interested is:

0x0003481001003219474E5F4D4D616E0000000000...

47 4E 5F 4D 4D 61 6E = GN_MMan

now we need to change it to GM_MMan

47 4D 5F 4D 4D 61 6E = GM_MMan

so our update query looks like this:

UPDATE Character1 SET char1 = 0x0003481001003219474D5F4D4D616E000000000000000000ADB7A4A7AEC8A448000000000000000040420F00000000000000000040420F00000000000000000000030100140505050500000300010400AF00440082008E0081000000030000000000000000000000000000000000000000000000000000000000000000000000 WHERE id = 'MMan'

Be careful with UPDATE query... it is easy to change other than your own character by accedent if you leave WHERE part off.

Edit: Update query looks horrible becose character data is so long... Note that it ends to:

...000 WHERE id = 'MMan'




There, like I said, if you know what you are doing, no sweat, if not, you are going to be very very confused. I haven't tried it myself yet, but in theory, that does look like it works.

 

[lucipher]

Yea, this was finally achieved, but Let me state this, THIS IS NOT FOR NEWBIES WHO DON'T KNOW ANYTHING. You really need to know what the heck you are doing, otherwise it will make no sense to you at ALL. Until there is an easier way to do this (such as modifying account table), this is the only way to go:

Ok... I had time to look at aglaia server...

GM characters have GM_ at begining of their names. Client doesn't allow you to make such character so we need to use query analyzer for it.

first we make character that has GN_ at begining... Like "GN_MMan"

Then close server becose servers cache data.

Then we query our character data from db.
Note: my accounts name was MMan and character was in first slot... change char1 and Character1 to match yout characters slot.

SELECT char1 FROM Character1 WHERE id = 'MMan'

Returned me this: