Admin log in

[Ryogah]

Im really new to this, i have my server up and running and everything seems find but when i try to log in using the admin button at top right it always says Error-A time out has occered. Also i need a list of all item ids and more general gm commands or a program that has some kind of interface to help with gm commands, thnx in advance.

[So_1337]

Don't use the Admin button to log in. Go to the accounts table of your database, find your account, and set the status to 255. From the on, that account is your GM account and will have access to all GM commands.

To view the list of commands, type "#help" in game. For help with a specific command, such as #summon, type "#help summon".

Also, if you're after item IDs, just check out Lucy. The item IDs there match the ones in the database. Or, use "#finditem Blade of Carnage" in game to find items.

[Ryogah]

Thank you so much, you rock!

[free4me]

where do you find accounts table file so i can play as a GM please

new to this to

[unknownhost]

open up your mysql editor and find your database(if you used the selfinstaller it'll most likely be "peq"), then just look for "account" and dbl click to open =)

[free4me]

sorry not sure where to look

i am useing the AXClassic Server and in there a file EQEmu.. looked in there and still cant see what you are trying to tell me

please help more info please --me a very very noob to all of this

ty alan

[free4me]

ok i did find this in local\mysql\data\ax_classic in here are 3 files --account.frm and account.MYD and account.MYI---

i take its not them ?? sos help me

[leslamarch]

Originally Posted by free4me

sorry not sure where to look

i am useing the AXClassic Server and in there a file EQEmu.. looked in there and still cant see what you are trying to tell me

please help more info please --me a very very noob to all of this

ty alan

This is not the only way but its the easiest way, google "mysql GUI" and in the top 10 you will see something called "heidiSQL". Download this tool, its used to access your database. Once its installed make a connection to local host and use your username and pass for the mysql user to connect.

Now that your connected to your database, account table will be toward the top and will see what unknownhost was talking about.

[leslamarch]

One other thing i forgot to note, always backup your database before doing anything.

[free4me]

what one do i download the 3.2 or the 4.00

??

[leslamarch]

Originally Posted by free4me

what one do i download the 3.2 or the 4.00

??

Both work but i use 4.0... once you get the table you want, make sure the data tab up top is clicked....

hope this helps
leslamarch

[free4me]

ok sorry to go on but my luck is runing out

i put in my ip

then user name

and password

pot in port 5999

it hangs 4 a long time

on the server client its saying new server connection and after that i get timeout

then mysql saying sql error lost connection to mysql server during query

not sure what to do next sorry

[leslamarch]

Originally Posted by free4me

ok sorry to go on but my luck is runing out

i put in my ip

then user name

and password

pot in port 5999

it hangs 4 a long time

on the server client its saying new server connection and after that i get timeout

then mysql saying sql error lost connection to mysql server during query

not sure what to do next sorry

Did you use the username of your EQ account
or the mysql?

try this
port 3306
localhost
root
mangos

[free4me]

yes that worked dont no how but it did

i've only got1 char on server at mo how do i make him a gm

[leslamarch]

Originally Posted by free4me

yes that worked dont no how but it did

i've only got1 char on server at mo how do i make him a gm

you need to go to the account table and under status make sure it says 255.
thats all you need to do then, Gm commands can be found on the forum if you need them

list of some of them here