Admin panel problems

[IAjmscott44]

I'm running the world.exe on this computer with the 5 zones, and I try to log into my server and get 1017. I tried all the stuff and it didn't work, until finally i tried deleting my username from the Admin panel and i can get in. My question is how can I make myself a GM and update using the admin panel? All the changes i make on the admin panel don't go into the game, even when I click Commit changes. Oh - and it's Windows XP that I'm using.

Thanks.

[Magick]

Which Admin Panel are you using? The EQEmu Admin Tool? And which version? I've had some problems with 4.3, and it could be that it's not meshing with the database (although in my case it should).

What you can do is add youself to the database manually through MySQL or open a command prompt and go to your emu directory (ie., c:/eqemu/) and type:

world adduser username password 200

The 200 will give that account GM status. If your db.ini is setup correctly, this will add the account.

For MySQL:

use <db name>;
insert into account set name='yourname', password='yourpassword', status=200;

[IAjmscott44]

I've tried that - it still doesn't let me in. The only way I've found to log into my server is deleting my account using the admin tool, but then I can't get my ServerOP status back in game.

[IAjmscott44]

Well I don't know what I did but everything works fine now for me - but I'm the only person who can get on my server, no one else... What am I doing wrong?

[Roadkill]

I haven't had much luck with the Admin tool myself either.

I tried adding a spawn to the Temple of Veeshan last night. Add the spawn, I see it's x,y,z is 0,0,0 (brand new spawn after all)... so I change the coordinates to what I wanted, -2030, -489,-44... the middle of the circle entry room to the zone. All looks fine. Hit the Commit Changes to Database button, it hourglasses doing it's thing. Pop, my coordinates are back to 0,0,0. Change the coords again to -2030,-489,-44, Commit to Database, changes back to 0,0,0 on it's own again.

Arg.

Change the coords again, hit another tab in the program, come back to the Spawn tab. Coords are still the way I left them. Hit Commit to Database, this time they stick. Woops, I typoed -389 instead of -489 that last time. Change it to -489, Commit to Database, changes back to -389 on it's own. Change it again, tab to another section and tab back to Spawns (tabbing out and back worked last time), Commit to Database, changes back to -389 on it's own yet again.

Finally, I get frustrated and just go into MySQL and give it a:

update spawn2 set y=-489 where spawngroupID=178687;

and take care of the problem myself.

The admin tool arranges stuff nicely, to where I can really understand what I'm looking at... unfortunately it seems to be completely random whether it will actually successfully write the changes to the MySQL database. So I'm thinking I'll use it to start the basics of where I want a spawn, then just update the raw data on that record into MySQL myself.