Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

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

Joined
Nov 30, 2003
Messages
503
Reaction score
1
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:

Code:
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.
 
Initiate Mage
Joined
Oct 21, 2004
Messages
12
Reaction score
1
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:
 
Back
Top