got 0.70 working barely by guessing whats needed in conjunction with my mysql skills

[CrabClaw]

If you are going to play on the same maching as your server is running and have freinds log in too. This is a copy of my eqemu_config.xml. Notice where I put my server computers local LAN IP, 192.168.1.51.

<?xml version="1.0">
<server>
<world>
<shortname>minilogin</shortname>
<longname>Happy Fun Server</longname>

<!-- Only specify these two if you really think you need to. -->
<address>192.168.1.51</address>
<localaddress>127.0.0.1</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>192.168.1.51</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

<!-- Enable and set the port for the HTTP service. -->
<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<!-- Database configuration, replaces db.ini. -->
<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>eq</db>
</database>
</server>

This is my Logingserver.ini:

###Your current configuration is as follows:

loginserver.ini:
[LoginServer]
loginserver=192.168.1.51
loginport=5999
worldname=Happy Fun Server
worldaddress=192.168.1.51
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=
[ChatChannelServer]

worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=Minilogin
ServerPort=5999

This is my db.ini:

###Your current database configuration is as follows:
##db.ini:

[Database]
host=127.0.0.1
user=eq
password=eq
database=eq

This is my ehost.txt in the client directory:

[LoginServer]
Host=192.168.1.51:5999

You can find you LAN IP by doing a ipcong at the command line. This setup allows me on the host machine and everyone else on the network play.

The last step is to change your list of users in your database. Make sure no one has 127.0.0.1 as thier log in IP in the accounts table in the database.

So if the first account is on the local machine it would look like this in the 'accounts' table in the database. This is assuming you made the LAN IP on all the machines sequential. When in doubt do a IPCONFIG on each machine to make sure the IP is correct:

First user login IP> 192.168.1.51
Second user login IP> 192.168.1.52
Third user login IP> 192.168.1.53

and so on....

Cool tools that are a must to get are the MySQL Administrator, Query Browser off the http://dev.mysql.com/ site. They will save you a lot of time and errors, they also can do backups or manage timed backups too.

I hope this helps