Howto : Minilogin with 5.7 Dr-4 [06.03]

[Pyrix]

Ok a little guide how to set a Server with Minilogin with Eqemu-Version 5.7 DR-4:

Part 1 : Setting up MYSQL
Part 2 : Sourcing Databases
Part 3 : Setting up the Server
Part 4 : Working in Everquest-Folder
Part 5 : Starting the Server
Part 6 : Fixing Errors
Part 7 : EQEmu with EQ-Europe

This guide will be updated with every new version released.

In a few hours i gonna release a ready-to-use Version.You only need to do 3 things



Part 1 : Setting up MYSQL

1.Download MySQL from www.mysql.com

2.Install it and set Username and Password

3.run \mysql\bin\winmysqladmin.exe and look for the green light.
If it is green everything is all right.

Part 2 : Sourcing Databases

1.Download the SQL-Package (use rightclick->Save target as)

2.Open the *.rar file (You can get winrar from www.winrar.de) and
look for "itemtablechanges.sql"

3.Copy All Files to \mysql\bin

4.Start -> Run -> CMD

5.Type

cd <drive>:\mysql\bin

Instead of drive c or d , without "<>"

6.Type

 mysql -u root mysql

This gives you the highest Access-Level (also called Admin)

7.Type

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

This Command gives you the same rights as root

8.Type

create database eq;

You create the db "eq"

9.Type

use eq;

Now you can work with this db

10.Type

 source MW_057DR2_alpha_1.sql;

You load the .sql file in the db , sourcing can take a while

11.Type

 source loot_update.sql;

Same as above

12.Type

 source npc_types_update.sql;

This may take a while (15-45 mins)

13.Type

 source itemtablechanges.sql;

Same as above

14. If Everything is done

Exit

Part 3 : Setting up the Server

1.Now you can compile the Sources or simply take my precompiled one (use rightclick->Save target as)

2.Now put "EmuShareMem.dll" , "World.exe" and "Zone.exe" in a folder called "EQEmu"

3.Now download The missing files and put them in EQEmu-Folder

4.Download The Config files and put them in EQEmu-Folder

5.Change folder to "EQEmu" and look for "db.ini"

6.Edit it like this

[Database]
host=localhost
user=Pyrix
password=*Edited by Virus, Don't post your password for everyone to see :-)
database=eq
compression=off

I gonna explain this to You

[Database]
host=The Server where ur Database is saved on (On your PC= localhost , on another PC=IP)
user=Your MySQL-Username
password=Your MySQL-Password
database=The Name of DB (If you followed the Instructions "eq")
compression=off

7.Now look for LoginServer.ini . The following Part is very important

# READ README.TXT
[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=German [Legit] Test-
worldaddress=127.0.0.1
locked=false

On Default there are 3 entries for loginserver and loginport.
You only need one.
The Defaultport is 5997 , but the Loginserverport of Minilogin is 5999.
Change it to 5999!
Do not But the phrase "Server" in worldname" !
The ip 127.0.0.1 specifies your PC , its like localhost.
You can use localhost instead of 127.0.0.1!

8.Open Boot5zones.bat (with the editor , simply rightclick and edit).

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

You can replace 127.0.0.1 with localhost!

Part 4 : Working in Everquest-Folder

1.Go to Everquest-Folder and open eqhost.txt.
Replace EVERYTHING with the following entry.

If you got EQ-Europe

[Login Servers] 
{ 
"localhost:5999" 
}

If you got normal EQ

[Login Servers]
Host=localhost:5999

2. Now rightclick on "eqgame.exe" and "create shortcut"
Rightclick on the shortcut and add in "target" after the ' " ' patchme.
It looks like :

"D:\EverQuest\eqgame.exe" patchme

Part 5 : Starting the Server

1.Go to EQEmu-Folder and start minilogin first , than world.exe and last but not least boot5zones.exe.

2.Sometimes you have to wait a bit for the zones loading into world.

3.If you got an output in World.exe Window like "#1 New Zoneserver..." run the special shortcut of everquest.

4.Login as "eqemu" with password "eqemu" .

5.If the Server is locked wait a few mins and connect to the server.

6.If you are rejected from the server , saying you should re-run update ..... and you got newest (26.05.) version of eq the username wasnt added to your db.
Got to next Part to Fix it.


Part 6 : Fixing Errors

1.Ingame Message :" Rerun your patcher...." and in World.exe-Window "Wrong password" or "Unknown Username".

Start -> Run -> Cmd
Use command from Part 1 No.6 , Part 1 No.7 and Part 1 No.10 .
Type

INSERT INTO account (id, name, charname, packencrypt, sharedplat, password, 
status, lsaccount_id, gmspeed, revoked) VALUES (1, 'eqemu', '', '', 0, 'eqemu', 250, NULL, 0, 0);

2.Minilogin doesnt loads into World.

Simply fix it by editing LoginServer.ini .
Change the Loginserverport from "5997" to "5999" .


3.The Server is locked , I can enter it and create a char.But i cant enter the world.

The Zones havent load into world.exe. Look in World.exe for Errors.
If you havent run the "itemtablechanges.sql" this may be the fault.
The most errors in world.exe are caused by wrong Database-entries or wrong *.ini settings.
Only recreate a db and reload the sql-files into it.

4.You cant attack.

I didnt figure out what it is.
But its defenetly an fault in the source (perhaps attack.cpp or opcodes.h).
The interesting thing is that your enemy loses hp.
Reason : You have no animation for attacking or the target (dunno how) attacks itself.

5.No NPC ingame.
You need to load a .sql into your db.
look part 2.



Part 7 : EQEmu with EQ-Europe

If you wanna play with EQ-Europe on Eqemu-Servers you have to do following.

1.

Patch ur Version to "English" (under Advanced , Erweitert) .

2.

Now there are some diffrents between the format of "eqhost.txt" (stored in your EQ-Folder)


USA-Version:

[Login Servers]
Host=eqemulator.net:5995

But This format isnt working with Eq-Europe

Try this

EQ-Europe:

[Login Servers]
{
"eqemulator.net:5995"
}

Last changed on 06.03.04