Make My Character a GM - Revision history

Whasf: GM command update

2018-05-19T04:25:03Z

GM command update

Whasf: Changed to HeidiSQL

2018-05-19T04:18:27Z

Changed to HeidiSQL

Whasf: Changed to HeidiSQL

2018-05-19T04:16:29Z

Changed to HeidiSQL

Whasf: change @ to ! for gm commands

2017-09-16T21:57:32Z

change @ to ! for gm commands

Lotus: /* Using Navicat */

2014-05-20T23:36:24Z

‎Using Navicat

Zedingo: /* GM Levels Explanation */

2013-07-05T09:04:10Z

‎GM Levels Explanation

Zedingo at 09:02, 5 July 2013

2013-07-05T09:02:24Z

Lotus: /* Using mysql */

2013-07-03T16:57:18Z

‎Using mysql

Lotus at 16:56, 3 July 2013

2013-07-03T16:56:47Z

Diatanato at 07:07, 31 March 2012

2012-03-31T07:07:10Z

@@ Line 19: / Line 19: @@
 Re-open the table to ensure the value has been set.
-Log into the game and use @togglegm, then check that the GM icon is in place and that your name is red.
+Log into the game and use !togglegm, then check that the GM icon is in place and that your name is red.
 == Using mysql ==

@@ Line 4: / Line 4: @@
 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.
+Now you can continue either using HeidiSQL or the mysql command-line tool.
-−
 == Using HeidiSQL ==

@@ Line 7: / Line 7: @@
-== Using Navicat ==
+== Using HeidiSQL ==
-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)
+Open HeidiSQL 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
+Expand out the database
 Go to char table and open it (double-click)

@@ Line 14: / Line 14: @@
 Go to char table and open it (double-click)
-Find your character's entry, and change the gmlevel field from 0 to 5 or more for owners. @togglegm can be used in-game to turn your GM icon on/off.
+Find your character's entry, and change the gmlevel field from 0 to 5 or more for owners. !togglegm can be used in-game to turn your GM icon on/off.
 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.
@@ Line 58: / Line 58: @@
 MINLVL_GM_PRODUCER = 4;
 </pre>
-These levels correspond to the gmlevel field in the chars table for the appropriate character. gmlevel and these options will determine which GM icon you will receive when using @togglegm
+These levels correspond to the gmlevel field in the chars table for the appropriate character. gmlevel and these options will determine which GM icon you will receive when using !togglegm
-I recommend that the owner (perhaps you) has a gmlevel of 5 or greater, or at least the highest level of a non-owner GM +1. This will ensure that the owner can use @promote to promote anyone to a new GM level without needing to modify the SQL manually.
+I recommend that the owner (perhaps you) has a gmlevel of 5 or greater, or at least the highest level of a non-owner GM +1. This will ensure that the owner can use !promote to promote anyone to a new GM level without needing to modify the SQL manually.

@@ Line 12: / Line 12: @@
 Go to Tables
-Go to char_stats table and open it (double-click)
+Go to char 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)
+Find your character's entry, and change the gmlevel field from 0 to 5 or more for owners. @togglegm can be used in-game to turn your GM icon on/off.
-−
-Change the gmlevel field from 0 to 5 or more for owners. @togglegm can be used in-game to turn your GM icon on/off.
 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.
@@ Line 23: / Line 21: @@
 Log into the game and use @togglegm, then check that the GM icon is in place and that your name is red.
 == Using mysql ==

@@ Line 16: / Line 16: @@
 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 to 83886080
+Change the gmlevel field from 0 to 5 or more for owners. @togglegm can be used in-game to turn your GM icon on/off.
 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.
@@ Line 22: / Line 22: @@
 Re-open the table to ensure the value has been set.
-Additionally, it is now required to also open the "chars" table, and set the gmlevel field to something other than zero.  GM Levels range from zero (no permissions) to 4 (all commands available).
+Log into the game and use @togglegm, then check that the GM icon is in place and that your name is red.
-−
 Log into the game and check that the GM icon is in place and that your name is red.
@@ Line 46: / Line 44: @@
 Replace 21828 below with the charid of the character you want to modify and use these queries:
 <pre>
@@ Line 60: / Line 53: @@
 Log into the game and check that the GM icon is in place and that your name is red.
-== Alternative Values ==
+== GM Levels Explanation ==
-These are all of the possible GM level values. Replace the nameflags value with one of these to get a different GM level.
+In the file scripts/commands/togglegm.lua there are 4 configurable options:
-{|
+<pre>
-|Flag|| GM Level
+MINLVL_GM          = 1; -- For "whitelisting" players to have some commands, but not GM tier commands.
-|-
+MINLVL_GM_SENIOR   = 2; -- These are configurable so that commands may be restricted
-|67108864||GM
+MINLVL_GM_LEAD     = 3; -- between different levels of GM's with the same icon.
-|-
+MINLVL_GM_PRODUCER = 4;
-|83886080||GM Senior
+</pre>
-|-
-|100663296||GM Leader
-|-
+I recommend that the owner (perhaps you) has a gmlevel of 5 or greater, or at least the highest level of a non-owner GM +1. This will ensure that the owner can use @promote to promote anyone to a new GM level without needing to modify the SQL manually.
-|117440512||SE Producer

@@ Line 54: / Line 54: @@
 <pre>
 UPDATE chars
-    SET gmlevel= 4
+    SET gmlevel = 4
     WHERE charid = 21828;
 </pre>

@@ Line 21: / Line 21: @@
 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.
@@ Line 43: / Line 45: @@
 to get a list of character names and ID.
-Replace 21828 below with the charid of the character you want to modify and use the query:
+Replace 21828 below with the charid of the character you want to modify and use these queries:
 <pre>
 UPDATE char_stats
@@ Line 50: / Line 52: @@
 </pre>
+<pre>
 Log into the game and check that the GM icon is in place and that your name is red.