Difference between revisions of "Make My Character a GM"

From DSP Wiki
Jump to: navigation, search
(Created page with "'''This guide is a quick reference to help people make their character on their own test server into a GM''' == Starting Out == Create a character and login to your character...")
 
Line 36: Line 36:
 
at the prompt type in:
 
at the prompt type in:
  
<pre>SELECT charid, charname FROM dspdb.chars;</pre>
+
<pre>
 +
USE dspdb;
 +
SELECT charid, charname FROM dspdb.chars;
 +
</pre>
  
 
to get a list of character names and ID.
 
to get a list of character names and ID.
Line 42: Line 45:
 
Next, for a female character, replace 21828 below with the charid of the character you want to modify and use the query:
 
Next, for a female character, replace 21828 below with the charid of the character you want to modify and use the query:
 
<pre>
 
<pre>
USE dspdb;
 
 
UPDATE char_stats
 
UPDATE char_stats
 
   SET nameflags = '83886080'
 
   SET nameflags = '83886080'
Line 52: Line 54:
 
For a male character, replace 21828 below with the charid of the character you want to modify and use the query:
 
For a male character, replace 21828 below with the charid of the character you want to modify and use the query:
 
<pre>
 
<pre>
USE dspdb;
 
 
UPDATE char_stats
 
UPDATE char_stats
 
   SET nameflags = '83918848'
 
   SET nameflags = '83918848'

Revision as of 06:03, 31 March 2012

This guide is a quick reference to help people make their character on their own test server into a GM

Starting Out

Create a character and login to your character for the first time. After you have logged in successfully, log out (or /shutdown).

Now you can continue either using Navicat or the mysql command-line tool.


Using Navicat

Open navicat and connect to your database (if you don't know how to do that, head back over to the Building the Server page to refamiliarize yourself)

Go to Tables

Go to char_stats table and open it (double-click)

Find your character's id (You can find your character id by opening the "chars" table, and viewing the id column by the name of your character, but if this is your first and only character the id will be 21828)

Change the name_flags field from 0 (or 32768) to 83886080 if you are a female character, or 83918848 if you are a male character.

After you set the value, press the down arrow to go to the next line (this will save the table) or click the checkmark at the bottom of the tables window.

Re-open the table to ensure the value has been set.

Log into the game and check that the GM icon is in place and that your name is red.


Using mysql

Open a command prompt (Win+R->cmd)

type in

mysql -u root -ppassword

where password is the password you set in the Building the Server tutorial.


at the prompt type in:

USE dspdb;
SELECT charid, charname FROM dspdb.chars;

to get a list of character names and ID.

Next, for a female character, replace 21828 below with the charid of the character you want to modify and use the query:

UPDATE char_stats
   SET nameflags = '83886080'
   WHERE charid = 21828;


For a male character, replace 21828 below with the charid of the character you want to modify and use the query:

UPDATE char_stats
   SET nameflags = '83918848'
   WHERE charid = 21828;


Log into the game and check that the GM icon is in place and that your name is red.