Log in

View Full Version : Help please


Dragonfire1357
01-07-2003, 01:16 AM
When i goto flag and add a user it does nothing i goto C:\eqemu in dos and type world.exe adduser user password 200 and all it does it load up the server as if i just typed world.exe could any one please help me why is it doing this im running on windows xp.

Trumpcard
01-07-2003, 02:32 AM
The commandline option is currently broken (we'll fix it in the next verison)

Do this.

Go into mysql (instructions in readme)

type;
use eq;
update account set status=200 where username='your account username';


you can change the 200 to anything you want, the max is 255.

mwilson828
01-07-2003, 04:52 AM
I followed Trumpcard's instructions and got the following error:

ERROR 1054: Unknown column 'username' in 'where clause'

So the flag command didn't work. Any ideas?

Trumpcard
01-07-2003, 06:08 AM
I cant remember the exact column name, im sitting here at work...

type describe accounts; after use eq; and use the right column names...

mwilson828
01-07-2003, 06:37 AM
:D

Trumpcard - THANK YOU!

Worked perfect. You rock man!

kabalah
01-07-2003, 06:52 AM
hey trumphcard, the fix was pretty easy. i just moved the test for disablecommandline out of the giant if then elseif statement. also i changed the database to not consider ls_accountid as unique...

alter table account drop index ls_accountid;
alter table accout add index lsa (ls_accountid);

then it worked fine...

kabalah