EQEmulator Forums - Prollem with EQAdmin

that mean you have to click on preferences button and set all config.

---[this is from FQADMIN.INI file]---

DBNAME=eq
DBHOST=localhost
DBUSERNAME=<username>
DBPASSWORD=<password you setted in your mysql>
EQPATH=c:\program files\everquest (or path or your eq directory)
MAPSPATH=H:\EQEMu\eqemu-admin-tool-4.0\ (or path where you put all your .map)

that mean you installed mysql before .....
;)

you can also read the README.txt ;)

Quote:

First, make a folder (e.g. FQAdmin) and unzip everything into that folder. This assumes you have your mysql database installed and working with the AGX emulator v.1.4. Then, edit the FQADMIN.INI file to put in your username and password for the mysql database (*NOT* the FQ account username and password; the admin tool needs the username and password you use to muck around with the database). For example, I use "monty" and "some_pass" as my username and password, which are defaults which come with mysql. This already assumes that you have used the "GRANT" command to grant whatever username you use for full access to the eq database. Check out www.mysql.com for details on the "GRANT" command.

Once you've set up the FQADMIN.INI file, you're all set to run FQAdmin.exe. It shows a series of tabs at the top, each one corresponding to a separate table in the database. Each tab pane displays some attributes you can look at and edit. IMPORTANT: changing from one RECORD to another RECORD in the SAME table WILL AUTOMATICALLY SAVE ANY CHANGES YOU MADE TO THAT RECORD. Changing from one TABLE to another TABLE might not. Hence, the "Commit Changes" button at the bottom of the screen. It's there to save everything in the event you are adding records or aren't sure if your changes were saved. Basically, it isn't needed 90% of the time, but it IS needed for the remaining 10%.

I'm sure there is much more to be eventually added. This is just a quick hack that I put together in a few days. There is absolutely no guarantee that it will work with future versions of the emualtor, as it depends on the database name remaining "eq", and the table and field names staying the same. If these are changed in future emulator versions, this tool will probably have to be modified and recompiled. All source code is being included for that eventuality. As I have several other programming projects going on concurrently in my spare time, I can't guarantee timely updates, so open source is the only way to go. For those who want to recompile and/or mess with the program, it requires the ZEOS library for talking to the mysql database. You can get it at www.zeoslib.org. They claim it is compatible with all versions of Delphi and Kylix. This tool was originally written in Delphi 6.0. Delphi 6 supposedly comes with native MySQL support, but I couldn't keep their drivers from crashing. The ZEOS stuff works great.