HOWTO: Setup an EQEmu server as of 06/01/2004

Jezebell · #1 03-08-2004, 01:55 PM

This guide assumes you are using Microsoft Windows and have basic knowledge of computers and Windows and how to create batch/text files. Nothing I post here is supported, but I will try to answer any questions. I am not a programmer and my knowledge of the MySQL databases is very limited but I am learning as I go along. Just a fyi, DR stands for Developers Release, which means it is not official. You will need WinRAR to open some of the files. If you have a router look here Router Guide, if you have a firewall it needs to be configured to allow access to the ports.

I highly recommend downloading MySQL-Front to manage your database.

Other third-party programs I recommend for managing your database such as items, loot, merchants, factions, etc.

Sandy's Loot Editor 1.2

Mangoo's Item Editor 1.9.1

capusr5's IEQ

FIRST STEP:

1. Download MySQL 4.0.18 , after that install the downloaded file

2. click 5.7-DR3

3. click EQEMu 5.6 Config and download EQEmu-0.5.6-Configuration.zip

4. Extract everything to C:\EQEmu

5. Download ProjectEQ.com Alpha 1 database

Download
Govtcheeze loot updates

Extract them to C:\mysql\bin

SECOND STEP:

1. Browse to C:\mysql\bin and run winmysqladmin.exe, enter a username and password.

2. Right-click the desktop, go to New > Text file, name it MySQL.bat, edit it to include this and then save it.

Code:

cd\mysql\bin 
mysql -b -u root mysql

anytime you need to enter something in the MySQL command line just run MySQL.bat.

3. Run MySQL.bat and type:

Code:

grant all privileges on *.* to username@localhost identified by 'password' with grant option;

(replace username/password with your winmysqladmin username//password)

Press Enter....type:

Code:

create database eq;

Press Enter....type:

Code:

use eq;

Press Enter....type:

Code:

source MW_057DR2_alpha_1.sql;

Press Enter.

Lots of stuff should fly by with no errors. Type:

Code:

source loot_update.sql;

Press Enter.

Lots of stuff should fly by with no errors. Type:

Code:

source npc_types_update.sql;

Press Enter.

Lots of stuff should fly by with no errors. Type:

Code:

quit

Press Enter.

THIRD STEP:

1. Open db.ini and make sure it looks like this:

Code:

[Database]
host=127.0.0.1
user=YourMysqlUsername
password=YourMysqlPassword
database=eq
compression=off

2. Open LoginServer.ini and make sure it looks like this:

Code:

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=Yourservername
worldaddress=YourexternalIPAddress
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

[ChatChannelServer]
ChatChannelServer=YourInternalIPAddress

Make sure there are NO SPACES at the end of any of the lines!!

You can find your External IP by going to http://www.whatismyip.com and your Internal IP by running the command prompt and typing IPCONFIG

3. Edit boot5zones.bat and make sure it looks like this:

Code:

REM: ****Read this first!!!**** 

REM: This file requires your real IP in the place of "YourIP" when you are connecting 
REM: To the EQEmu Loginserver. 

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1 

REM: If you still get errors try using localhost instead of 127.0.0.1 

REM:--------------Start----------------------- 
@echo off 

if NOT exist spells_us.txt goto NOSPELL 

start zone . YourExternalIP 7995 YourInternalIP 
start zone . YourExternalIP 7996 YourInternalIP 
start zone . YourExternalIP 7997 YourInternalIP 
start zone . YourExternalIP 7998 YourInternalIP 
start zone . YourExternalIP 7999 YourInternalIP 
exit 
cls 

:NOSPELL 
echo You did not copy the spells_en.txt from your everquest directory to this one.  Please do so or zones will crash on startup. 
PAUSE 

REM:---------------END------------------------

4. Copy spells_en.txt and spells_us.txt from your EverQuest directory to C:\EQEmu

5. Close Everything, Browse to C:\EQEmu and run World.exe, after it is done, run boot5zones.bat and you are ready to go.