• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows 8.42 gm/god/cm

Pro Warbringer

Retired with developing
Joined
Sep 23, 2008
Messages
3,582
Reaction score
25
Location
Austria
Well i dont have an account manager on my War OT and i want to make an GOD/GM/CM what shall i do..? any help O.o
 
go to mysql

find your acc (in table accounts in your DB) change group ID to 3
you most have a character on the acc
go to the character (in table players) find your change group ID to 3


and if you dont have any account manager or acc page ..
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:
dbselectkk9.png

Now, in the center of the screen, you should see a tab named "SQL":
sqltabsu6.png

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:
#--- 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:
inputquerysa2.png


And then press the "Go" button:
querygobj9.png


Now, the site should refresh, and show a green bar stating that the query was successful:
queryokfu4.png


DONE !

if i help you give me rep+++
Tut made by Blue Charizard
 
Back
Top