"How do I make myself a GM?"
Posted: Tue Nov 27, 2012 9:11 pm
Hopefully this is a cure-all for that question that's been asked so many times. I doubt it, but I figured I'd try it anyway. I created a SQL file that should automate the task of looking through the database to configure a character to be a GM.
There are a few things to keep in mind-
This will ONLY work if:
1. It's your first character you've created.
2. You've logged in and created the character with success.
3. You have all of the tables setup already in the database.
4. The database is actually running.
5. You have a program that will execute SQL files.
4a. HeidiSQL is a free one
4b. Navicat is another
If you'd like to make a different character in the database a GM,
you need to find out what the charid is in the database.
To do this, open HeidiSQL, or Navicat, and navigate through the database tables.
You should find 'account', under which holds the information for each account. Next, find the 'chars' tables and locate the account that corresponds, and figure out which character you want to have Senior GM privs. Take note of the number, then open a text editor (notepad++ or Windows text editor) and open SQL file. Change the number 21828 to the number you found in the database for your character.
Edit: Helps if I add the file....
Edit: Removed all spells, because for some reason the value you get when you have all spells doesn't work if it's copied/pasted. And if it's copied/pasted, and one were to use the @addallspells GM command to correct this problem, the client crashes.
There are a few things to keep in mind-
This will ONLY work if:
1. It's your first character you've created.
2. You've logged in and created the character with success.
3. You have all of the tables setup already in the database.
4. The database is actually running.
5. You have a program that will execute SQL files.
4a. HeidiSQL is a free one
4b. Navicat is another
If you'd like to make a different character in the database a GM,
you need to find out what the charid is in the database.
To do this, open HeidiSQL, or Navicat, and navigate through the database tables.
You should find 'account', under which holds the information for each account. Next, find the 'chars' tables and locate the account that corresponds, and figure out which character you want to have Senior GM privs. Take note of the number, then open a text editor (notepad++ or Windows text editor) and open SQL file. Change the number 21828 to the number you found in the database for your character.
Edit: Helps if I add the file....
Edit: Removed all spells, because for some reason the value you get when you have all spells doesn't work if it's copied/pasted. And if it's copied/pasted, and one were to use the @addallspells GM command to correct this problem, the client crashes.
