EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Admin log in (https://www.eqemulator.org/forums/showthread.php?t=26591)

Ryogah 10-21-2008 10:48 AM

Admin log in
 
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 10-21-2008 10:52 AM

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 10-21-2008 02:48 PM

Woot
 
Thank you so much, you rock!

free4me 11-12-2008 02:48 PM

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

new to this to :-x

unknownhost 11-12-2008 05:29 PM

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 11-13-2008 03:05 PM

stil cant find it
 
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 :cool:

free4me 11-13-2008 03:38 PM

update i am still looking --lol--
 
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 11-13-2008 03:43 PM

Quote:

Originally Posted by free4me (Post 159931)
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 :cool:

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 11-13-2008 03:57 PM

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

free4me 11-13-2008 04:31 PM

hi me again ))
 
what one do i download the 3.2 or the 4.00

??

leslamarch 11-13-2008 04:34 PM

Quote:

Originally Posted by free4me (Post 159937)
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 11-13-2008 04:53 PM

not working
 
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

:mad:

leslamarch 11-13-2008 04:56 PM

Quote:

Originally Posted by free4me (Post 159939)
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

:mad:

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

try this
port 3306
localhost
root
mangos

free4me 11-13-2008 05:26 PM

yes at last
 
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 11-13-2008 05:40 PM

Quote:

Originally Posted by free4me (Post 159941)
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


All times are GMT -4. The time now is 11:44 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.