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:
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:
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.