Making a char an admin

[shadowdeamon01]

hi, i just got my server up and running (whoo!) but i don't have any admin commands when i log in. how would i flag my account as the server op?

and yes i know its such a noob question.

[techguy84]

From a post not to long ago about the same question,

I believe you can fire up the MySQL query browser, and select your database and enter the following command in the query box


UPDATE account
SET status='250'
WHERE name='usrname'

Where it says usrname put in the name of the account that you want to have the status set too. This works for me so give it a shot. Thers is probably a simpler solution to this, but I just pulled this out of the MySQL syntax help stuff.

[Jablambo]

this worked perfectly for me, thanks Techguy

[Angelox]

MySql Query Browser;
This still my most used tool for MySql and EqEmu - With this tool, things like a quick change to someones account will be quick and obvious. It also has a window that shows/explains Syntax (data manipulation, data definition, ect), Funtions, Parameters, I learned a lot from this alone. It's simple, straight-foward, good for the beginner and good for the expert. Best of all it's free! you can get it at the MySql site.

[Xavius]

Hi, I have setup my server now and was looking to give someone GM access (lvl 100), I'm using PEQ's database and looking in the commands table I cant see all the commands I want to assign to someone with lvl 100 - namely the command #npcspawn - its not in my list to limit to a specific GM lvl? how can I restrict a GM command to a set level if its not in the commands table?

[Xavius]

Ahh nevermind, just added the entry into the commands table and assigned min status to it, just didnt take until server rebooted.