View Single Post
  #1  
Old 01-20-2003, 04:13 PM
MOHAA
Fire Beetle
 
Join Date: Jan 2003
Posts: 17
Default Your best Local lan setup i can make. It does work

Setting up a local lan! Please understand im useing only 2 pc already setup with a network.
Im useing winME, and useing windows networking, no firewall.
-----------------------------------------------------------------------------------------

Now i have tried just about everyway to do this. So i find this setup the best way to utlize most of both machines.
I have the world,zones,mysql on the client machine which i will call pc 2. The host machine is pc 1.
The pc 1 will run the internet if i want, since i use a dialup. It will also run minilogin and the EQWs.

First thing you need to do is get the right Files / Tools.

You will install the EQEMU,MYSQL on PC 2.

1. Current EQEmu version (check the site http://www.eqemu.net)
2. MySQL (We will be using MySQL 3.23 in this readme http://www.mysql.com/downloads/mysql-3.23.html)
Important: Make sure you download the correct version of MySQL for your Operating System (i.e. If your on windows, download the windows zip file).
3. A Semi Working Brain

Now we will be splitting up the Installation process into 3 Parts.

Part 1 ( Extracting EQEmu ):

1. Unzip EQEmu to a directory of choice ( we will be using C:\EQEmu\ in this example | http://www.winzip.com )

2. Copy "spells_en.txt" from your EverQuest directory to C:\EQEmu\ ( or wherever you uncompressed EQEmu too)

Part 2 ( Installing MySQL ):

1. Install MySQL ( not difficult like installing any program )
Reboot may be required

2. Copy db.sql (found in C:\EQEmu ) to your MySQL bin directory ( C:\mysql\bin by default )

3. From the MySQL bin directory run/open "Winmysqladmin.exe"
It will ask you for a username / password ( Choose a username / password that you will be able to remember)
Do not give the password out to anyone for any reason because with this,
anyone can log into your mySQL database and change your data.

NOTE: If it does not ask you to enter a username/password or you wish to change it,
delete the file c:\windows\my.ini and re-run Winmysqladmin.exe.

4. Now from "Winmysqladmin.exe" select the Database tab and right click the area for Databases and click Create Database.
Type in "eq" as the database name (without the quotes) and click Create database.

NOTE: You may close Winmysqladmin.exe now or you can hide it
Though some users may be required to leave this running to work.

4a. If u can not select the create database tab, this will solve your problem.
4b. Run "mysql.exe" from C:\mysql\bin directory
Type in "create database eq" without quote, and press enter
Type in "use eq" without quote, and press Enter
Type in "source db.sql" without quotes, and press Enter
A bunch of lines should pass by (that is normal).
If you get an error at this point then you didn?t copy db.sql into the MySQL/bin folder.

6. You may close mysql.exe now (type "exit" and press enter)

Part 3 ( Setting up EQEmu ):

1. Open db.ini ( found in the folder where you unzipped EQEmu C:\EQEmu )
You should see something that looks like

[Database]
host=localhost
user=YourMysqlUsername
password=YourMysqlPassword
database=eq

In the fields where it says "YourMysqlUsername" and "YourMysqlPassword"
put in the username / password you made in Part 2:(MySQL Install)

i.e

[Database]
host=localhost
user=joe
password=blow
database=eq

Save the file after you finish editing it.

NOTE: This file tells the zone servers / world server where to look / access the eq database
make sure you get these right or else it won't work

2. Now open LoginServer.ini ( found in same place as db.ini )
The file should look like this.

[LoginServer]
loginserver=put your IP address of the pc running MINILOGIN, pc 1 will be running it. u may find it by selecting start/run/type winipcfg/hit ente
loginport=5999
loginport2=5999
worldname=Name of server here
locked=false
account=
password=
worldaddress=Your IP Address here, for the pc running the world.exe, this will be pc 2.

Fill in the "worldname" and "worldaddress" fields with Name of your Server and IP of the computer
which will be running world.exe
Account / Password should be left blank (this is used for Servers with the Green Name)

i.e

[LoginServer]
loginserver=192.168.0.1
loginport=5999
loginport2=5999
worldname=Joe Blow's
locked=false
account=
password=
worldaddress=192.168.0.2

NOTE: All servers will have the word "Server" added to server name. So the server would say "Joe Blow's Server"
Do not put the word Server in the world name


3. Right click Boot5Zones.bat and click EDIT (This should open up the file in a notepad)

The file should contain these lines or something similar

start zone . YourIP 7995 YourIP

The first YourIP is the IP Address of the current machine
The second YourIP is the IP Address of the machine running world.exe.
For this example, the IP address is 123.157.127.153. Your IP address will be differant.

start zone . 123.157.127.153 7995 123.157.127.153
start zone . 123.157.127.153 7996 123.157.127.153
start zone . 123.157.127.153 7997 123.157.127.153
start zone . 123.157.127.153 7998 123.157.127.153
start zone . 123.157.127.153 7999 123.157.127.153

u may also put in "localhost" for the IP addresses if the world and zones, are on the same machine.

To find your IP Address follow these steps:

If you are on Windows2000/XP then go to Start, Run and type CMD to open a dos window.
Now type "ipconfig" without the quotes and hit enter.
Your IP Address should be listed under "IP Address"

If you are on Windows 98/ME go to Start, Run and type "winipcfg" without the quotes
and hit enter. Your IP Address should be listed under "IP Address"

Part 4 ( setting up minilogin)

1. ok now on to the pc 1. u will need to make a folder in c:\my documents\minilogin
i use this, because very ezy to find.
2. u will need to extract your minilogin to this folder, make sure it is the update minlogin.
3. Now u will need to make a copy of the loginserver.txt file thats in the c:\Eqemu folder

[LoginServer]
loginserver=192.168.0.1
loginport=5999
loginport2=5999
worldname=YOUR SERVER NAME HERE
locked=false
account=
password=
worldaddress=192.168.0.2

U will need to replace the loginserver address with the IP address of the machine running Minilogin, that is pc 1
U also will need to replace the worldaddress with the IP address of the machine running World.exe, that is pc 2

4. Now go to the machine that has c:\mysql\bin file and run the mysql.exe window.
Type in "use eq" without quote, and press Enter
type in "INSERT INTO account" without quote, and press Enter
Type in "SET name='eqemu', password='eqemu', status=200;" without quote, and press ENTER
type in "exit" without quote, and press enter

5. Now is the moment of truth (time to run it and see if it works!)

6. make sure the little stop light is up and running(mysql)
Run MiniLogin.exe on pc 1
Then Run World.exe on pc 2
Then Run Boot5Zones.bat on pc 2

5. Load up EverQuest via EQW or "patchme"
Login using

eqemu as the username and password

NOTE: eqemu account should be flagged 200 *Server Op* status if not

If you want to flag the eqemu account, click Start, Run and type "command" without the quotes and hit enter.
Type "cd c:\eqemu" without the quotes and hit enter.
Type "world.exe flag eqemu 200" without the quotes and hit enter.
this will flag the eqemu account as a ServerOP (all commands).

Status Listing: 0= Normal, 10= PU, 80= Quest Troupe, 100= GM, 101= GM-Events, 150= LGM, 200= Serverop (All commands)



In the EQEmu Directory run "world.exe"
A window should pop up saying :


Using database 'eq' at localhost
EQEMu 0.4.2-DR1
Loading zone names & items...
EMuShareMem.dll loaded.
Loading items from database...
...done.
LoginServer.ini read.
Loading guild ranks...done.
Loading EQ time of day...Reading time file failed, bytes read: 0
failed.
HELP I WORK IN THE EQEMU SWEATSHOP YOUR MY ONLY HOPE
World server listening on: port 9000
Connected to LoginServer: 192.168.0.1:5999


the Boot5zones should look like this:


D:\EQEMU>REM: ****Read this first!!!****

D:\EQEMU>
D:\EQEMU>REM: This file requires your real IP in the place of "YourIP" when you
are connecting

D:\EQEMU>REM: To the EQEmu Loginserver.

D:\EQEMU>
D:\EQEMU>REM: When you are using minilogin, Replace all IP Addresses to say 127.
0.0.1

D:\EQEMU>
D:\EQEMU>REM: If you still get errors try using localhost instead of 127.0.0.1

D:\EQEMU>
D:\EQEMU>REM:--------------Start-----------------------



Using database 'eq' at localhost
EQEMu 0.4.2-DR1
Loading zone names, items & NPCs...
EMuShareMem.dll loaded.
Loading NPCTypes from database...
...done.
done.
If this is the last message you see, you forgot to move spells_en.txt from your
EQ dir to this dir.
Spells loaded.
Loading guild ranks...done.
Loading faction data...done.
Connected to worldserver: 192.168.0.2:9000
Entering sleep mode

the other zones should look like that


now runn your EQW. and play


if u get a 1017 error after selecting the server. u need to flag the database by.

If you want to flag the eqemu account, click Start, Run and type "command" without the quotes and hit enter.
Type "cd c:\eqemu" without the quotes and hit enter.
Type "world.exe flag eqemu 200" without the quotes and hit enter.
this will flag the eqemu account as a ServerOP (all commands).

Status Listing: 0= Normal, 10= PU, 80= Quest Troupe, 100= GM, 101= GM-Events, 150= LGM, 200= Serverop (All commands)

leave that window open and select the first world.exe. window and close it. and then retry the server.


well i hope i didnt leave any thing out.

this set up does work and as i can tell there is no other in the forms like it.

good luck!