Step 1.
First of all, log in on your PHPMyAdmin. Obviously since you have set up the database, you know how to do this, so this will not be explained.
Now, make sure you select the database that you use for your server, the most commonly used name would be "otserv".
You simply do this by clicking on the link in the leftmost part of the browser, as illustrated on this image:
Now, in the center of the screen, you should see a tab named "SQL":
Click on it.
Now, you should be in the part where you execute queries, and are now ready to proceed to step 2.
Step 2.
Okay, first of all, select the code in the codebox below, and copy it:
Code:
#--- Account Number of the GM/GOD Account ---
SET @acc = 123456;
#--------------------------------------------
#------ Password of the GM/GOD Account ------
SET @pass = "PASSWORD";
#--------------------------------------------
#------- Name of the GM/GOD Character -------
SET @name = "GM CHARACTER NAME";
#--------------------------------------------
# --- Coordinates where the character will spawn ---
SET @posx = 1000;
SET @posy = 1000;
SET @posz = 7;
#---------------------------------------------------
INSERT INTO accounts (`id`,`password`,`type`,`group_id`) VALUES (@acc,@pass,5,(SELECT `id` FROM groups WHERE `name` = 'a god'));
INSERT INTO players (`name`,`group_id`,`account_id`,`looktype`,`town_id`,`posx`,`posy`,`posz`,`save`) VALUES (@name,(SELECT `id` FROM groups WHERE `name` = 'a god'),@acc,75,1,@posx,@posy,@posz,1);
Now paste it into a texteditor of your choice, notepad works excellently.
And now we edit the variables....
#--- Account Number of the GM/GOD Account ---
SET @acc = 123456;
#--------------------------------------------
This is the account number for your GM/GOD character's account, change the number to whatever account number you want the character to have.
#------ Password of the GM/GOD Account ------
SET @pass = "PASSWORD";
#--------------------------------------------
This is the password for the GM/GOD character's account, change the text inside of the double quotes (" ") to whatever password you want.
#------- Name of the GM/GOD Character -------
SET @name = "GM CHARACTER NAME";
#--------------------------------------------
This is the GM/GOD characters name, change the text inside of the double quotes (" ") to whatever name you want on the character.
# --- Coordinates where the character will spawn ---
SET @posx = 1000;
SET @posy = 1000;
SET @posz = 7;
#---------------------------------------------------
This is the coordinates at which your GM/GOD character will spawn when you first log in. It is suggested that you change it to your temple position, so that you can log in on it.
And now we are done with the hard part, and can proceed to step 3.
Step 3.
As the final step, make sure you copy the text in your text editor by pressing CTRL + A to select it all, and then iether rightclick on it and choose "Copy" from the menu, or press CTRL + C.
Now, go to the PHPMyAdmin, and paste the text into the textbox, like this:
And then press the "Go" button:
Now, the site should refresh, and show a green bar stating that the query was successful:
Congratulations, you have now created a GM/GOD character on your server!
I hope you found this guide helpful, if you have any questions, comments or requests, feel free to post them here.