Ragnarok
05-28-2003, 05:22 AM
Hello,
the eqemu Team helped me to set up my LAN so i will help to support you with a Newbie Guide to setup a LAN Connection for 200 clients. To the smart and celver guys here, im a Newbie and i know you surly have easier ways to do it. But i explain it how i did it. Im sure its easy to understand for other new people here in this great project. So please avoid beeing a smartass.
Prepartion:
Operation System: Windows XP Professional
( Old Version no Service Pack no Updates )
Make sure you patched Everquest LIVE on the latest. Then download EQEMU Patcher and install it INTO the EQ directory. Do not install it somewhere else. Then start pacthing again with EQEMU Patcher.
Backup your Everquest before you patch with EQEMU Patcher.
ALWAYS use the backup for fooling arround with eqemu.
Download EQ Windows ( eqw.zip. )
Put your screen colors in display options to 16 BIT max.
Everqest will not run with 32BIT colors under EQW.
Prepare your computer Network IP's. The IP's are teh key to get this correctly to run. Give the HOST, your machine the static IP 192.168.0.1.
Give the other computer the IP 192.168.0.2 etc. etc
You can create up to 200 Accounts.
Install the fully patched EQ Version ( also patched with EQEMU patcher ) on all machines.
Starting:
1. Download mySQL: mysql-3.23.56-win.zip
Do not use the latest mySQL Version like Version 4. It makes problems at least for me.
- Install it. Usually drive c. Do it in this folder because its easier to help you if you still have problems.
- Run it and choose a Login and Username for your database storage. Don't forget it.
2. Download the latest EQEMU like: EQEMu-0.4.3-Win32.zip
- Extract it to a folder of your choice.
In any case you need a Databank to start EQEMU. The Databank is most important and contains all Informations like accounts, zones, spawns etc.
EQEMU always comes with a clear databank called db.sql.
Clear means no Data on it just the table structure where you can update another database later t fill the clear one.
Some people working on db's for the Emulator, i do as well but it takes some time. So you have to choose what databank you want to take.
Many people take Drawdes database, wich you can find on the World Create board.
3. Download FQAdmin Version: 4.6 it is our powerful tool to edit everything in the database.
4. Open C:\mysql\bin\mysql.exe
First you create your everquest databank wich helds every single data. Do it by typing:
create database eq;
Now the database is created. Next command is to select wich mysql databnk you want to use for updates now. So use the following command to choose the database of Everquest:
use eq;
Now you have to fill in all data to make your world lively. Files wich can contain world informations can be called txt or sql you cna extract both kind of objects. First step is extract the db.sql that came with eqemu. Do it by:
source db.sql
Now you have a clear database and a clear world without anything at all. So you have to find a good database now. If you take Drawdes, and i advise you do., then you just have to take the latest version and do the same command with his database.sql:
source drawdesdatabasename.sql;
If you do this make sure you read Drawdes Posting. You also should source Database Files like items.sql and doors.sql. Those came froma different designer and you have to source this as well to have doors and more Items. If you do not download a items.sql you cannot summon any Items.
World is filled now. Now the difficult thing, where many people have problems with. Creating a LAN Account. Lets say we want to create an Account called: Test with the Password: 123 on the Host machine wich has the IP: 192.168.0.1
Now type:
INSERT INTO account SET name='Test', password='123', status=200;
GRANT ALL PRIVILEGES ON *.* TO 'Test'@192.168.0.1 IDENTIFIED BY '123' WITH GRANT OPTION;
As you can see you have to insert your username and password in different lines. Also your Ip is important.
Now you created a GM Account. The 200 means Status of account. You are serverop with 200 and if you insert 0 on the next account he will have no Admin commands, just a normal player.
So if you want to create a secon Account for the second PC with the IP 192.168.0.2 use the same commands:
INSERT INTO account SET name='Test2', password='123456', status=0;
GRANT ALL PRIVILEGES ON *.* TO 'Test2'@192.168.0.2 IDENTIFIED BY '123456' WITH GRANT OPTION;
This account is only loginable on the CPU with the IP 192.168.0.2 and it has no admin commands due to you set his Flag to 0 and not 200. This decision is up to you.
You can go on with as many accounts you want to create, just be sure that the IPs will match.
Never forget: You can onyl acces the created account on the Computer wich you gave the IP of the Account. You cannot enter Account IP 192.168.0.2 on your Host neither can he enter your Host account from his machine.
I think this si very important and was never really mentioned deeply here.
5. Setup EQHOST.txt in all Everquest directories on your computer sin the LAN. They always have to target to the HOST Machine.
IP 127.0.0.1 will not work not even for the Host if you want to play in a big LAN. So use 192.168.0.1.
Your EQHOST.txt should look like this:
[Registration Servers]
{
"192.168.0.1:5999"
}
[Login Servers]
{
"192.168.0.1:5999"
}
After you changed the eqhost.txt on every machine to this IP you go back into the eqemu folder and change some ini's and the
boot5zone.bat.
Rightclick on boot5zone.bat and edit it.
Chnage values to host IP:
start zone . 192.168.0.1 7995 192.168.0.1
start zone . 192.168.0.1 7996 192.168.0.1
start zone . 192.168.0.1 7997 192.168.0.1
start zone . 192.168.0.1 7998 192.168.0.1
start zone . 192.168.0.1 7999 192.168.0.1
exit
cls
Save and exit.
Open or create if you do not have a MiniLoginAccounts.ini File.
In this file you have to enter the Account informations:
example:
# Max 200 lines total (including comments and blank lines)
# Blank lines may mess up the line # reported in error messages
192.168.0.1 Test 123
192.168.0.2 Test2 123456
This is how your MiniLoginAccounts.ini should look like.
Then open LoginServer.ini and change it like that:
[LoginServer]
loginserver=192.168.0.1
loginserver2=192.168.0.1
loginport=5999
loginport2=5999
worldname=Your Server Name ( Do not us the word Server )
locked=false
account=
password=
worldaddress=192.168.0.1
Open db.ini
[Database]
host=localhost
user=Your mySQL Login
password=Your mySQL Password
database=eq
compression=off
So, that should it be. Maybe i forgot something but try out if you are new here.
I want to thank the whole eqmu team for putting work into this project also drawde for the great databases.
I just wish that poeple in in IRC #eqemu are more friendly. Not that people dont get answeres, it seems to be more attractive to fool arround on Newbies making jokes about not so clever and uber people like you all the time etc. Thats the only week point on this whole project in my eyes.
Anyway, keep up the good work.
the eqemu Team helped me to set up my LAN so i will help to support you with a Newbie Guide to setup a LAN Connection for 200 clients. To the smart and celver guys here, im a Newbie and i know you surly have easier ways to do it. But i explain it how i did it. Im sure its easy to understand for other new people here in this great project. So please avoid beeing a smartass.
Prepartion:
Operation System: Windows XP Professional
( Old Version no Service Pack no Updates )
Make sure you patched Everquest LIVE on the latest. Then download EQEMU Patcher and install it INTO the EQ directory. Do not install it somewhere else. Then start pacthing again with EQEMU Patcher.
Backup your Everquest before you patch with EQEMU Patcher.
ALWAYS use the backup for fooling arround with eqemu.
Download EQ Windows ( eqw.zip. )
Put your screen colors in display options to 16 BIT max.
Everqest will not run with 32BIT colors under EQW.
Prepare your computer Network IP's. The IP's are teh key to get this correctly to run. Give the HOST, your machine the static IP 192.168.0.1.
Give the other computer the IP 192.168.0.2 etc. etc
You can create up to 200 Accounts.
Install the fully patched EQ Version ( also patched with EQEMU patcher ) on all machines.
Starting:
1. Download mySQL: mysql-3.23.56-win.zip
Do not use the latest mySQL Version like Version 4. It makes problems at least for me.
- Install it. Usually drive c. Do it in this folder because its easier to help you if you still have problems.
- Run it and choose a Login and Username for your database storage. Don't forget it.
2. Download the latest EQEMU like: EQEMu-0.4.3-Win32.zip
- Extract it to a folder of your choice.
In any case you need a Databank to start EQEMU. The Databank is most important and contains all Informations like accounts, zones, spawns etc.
EQEMU always comes with a clear databank called db.sql.
Clear means no Data on it just the table structure where you can update another database later t fill the clear one.
Some people working on db's for the Emulator, i do as well but it takes some time. So you have to choose what databank you want to take.
Many people take Drawdes database, wich you can find on the World Create board.
3. Download FQAdmin Version: 4.6 it is our powerful tool to edit everything in the database.
4. Open C:\mysql\bin\mysql.exe
First you create your everquest databank wich helds every single data. Do it by typing:
create database eq;
Now the database is created. Next command is to select wich mysql databnk you want to use for updates now. So use the following command to choose the database of Everquest:
use eq;
Now you have to fill in all data to make your world lively. Files wich can contain world informations can be called txt or sql you cna extract both kind of objects. First step is extract the db.sql that came with eqemu. Do it by:
source db.sql
Now you have a clear database and a clear world without anything at all. So you have to find a good database now. If you take Drawdes, and i advise you do., then you just have to take the latest version and do the same command with his database.sql:
source drawdesdatabasename.sql;
If you do this make sure you read Drawdes Posting. You also should source Database Files like items.sql and doors.sql. Those came froma different designer and you have to source this as well to have doors and more Items. If you do not download a items.sql you cannot summon any Items.
World is filled now. Now the difficult thing, where many people have problems with. Creating a LAN Account. Lets say we want to create an Account called: Test with the Password: 123 on the Host machine wich has the IP: 192.168.0.1
Now type:
INSERT INTO account SET name='Test', password='123', status=200;
GRANT ALL PRIVILEGES ON *.* TO 'Test'@192.168.0.1 IDENTIFIED BY '123' WITH GRANT OPTION;
As you can see you have to insert your username and password in different lines. Also your Ip is important.
Now you created a GM Account. The 200 means Status of account. You are serverop with 200 and if you insert 0 on the next account he will have no Admin commands, just a normal player.
So if you want to create a secon Account for the second PC with the IP 192.168.0.2 use the same commands:
INSERT INTO account SET name='Test2', password='123456', status=0;
GRANT ALL PRIVILEGES ON *.* TO 'Test2'@192.168.0.2 IDENTIFIED BY '123456' WITH GRANT OPTION;
This account is only loginable on the CPU with the IP 192.168.0.2 and it has no admin commands due to you set his Flag to 0 and not 200. This decision is up to you.
You can go on with as many accounts you want to create, just be sure that the IPs will match.
Never forget: You can onyl acces the created account on the Computer wich you gave the IP of the Account. You cannot enter Account IP 192.168.0.2 on your Host neither can he enter your Host account from his machine.
I think this si very important and was never really mentioned deeply here.
5. Setup EQHOST.txt in all Everquest directories on your computer sin the LAN. They always have to target to the HOST Machine.
IP 127.0.0.1 will not work not even for the Host if you want to play in a big LAN. So use 192.168.0.1.
Your EQHOST.txt should look like this:
[Registration Servers]
{
"192.168.0.1:5999"
}
[Login Servers]
{
"192.168.0.1:5999"
}
After you changed the eqhost.txt on every machine to this IP you go back into the eqemu folder and change some ini's and the
boot5zone.bat.
Rightclick on boot5zone.bat and edit it.
Chnage values to host IP:
start zone . 192.168.0.1 7995 192.168.0.1
start zone . 192.168.0.1 7996 192.168.0.1
start zone . 192.168.0.1 7997 192.168.0.1
start zone . 192.168.0.1 7998 192.168.0.1
start zone . 192.168.0.1 7999 192.168.0.1
exit
cls
Save and exit.
Open or create if you do not have a MiniLoginAccounts.ini File.
In this file you have to enter the Account informations:
example:
# Max 200 lines total (including comments and blank lines)
# Blank lines may mess up the line # reported in error messages
192.168.0.1 Test 123
192.168.0.2 Test2 123456
This is how your MiniLoginAccounts.ini should look like.
Then open LoginServer.ini and change it like that:
[LoginServer]
loginserver=192.168.0.1
loginserver2=192.168.0.1
loginport=5999
loginport2=5999
worldname=Your Server Name ( Do not us the word Server )
locked=false
account=
password=
worldaddress=192.168.0.1
Open db.ini
[Database]
host=localhost
user=Your mySQL Login
password=Your mySQL Password
database=eq
compression=off
So, that should it be. Maybe i forgot something but try out if you are new here.
I want to thank the whole eqmu team for putting work into this project also drawde for the great databases.
I just wish that poeple in in IRC #eqemu are more friendly. Not that people dont get answeres, it seems to be more attractive to fool arround on Newbies making jokes about not so clever and uber people like you all the time etc. Thats the only week point on this whole project in my eyes.
Anyway, keep up the good work.