[Spike]

HOST A 6.0-DR2 SERVER! + MINILOGIN! (WIN32)

You have to follow these steps in order, no skipping around!


BEFORE BEGINNING, DOWNLOAD THE SERVER HOSTING FILES! <-- CLICK HERE
(MAKE A FOLDER CALLED EQEMU, AND PUT THESE IN THERE. ALONG WITH ALL THE OTHER FILES YOU DOWNLOAD IN THIS TUTORIAL!) (put this folder wherever you want)

1) MAKE SURE YOU HAVE ALREADY FOLLOWED THE TUTORIAL ON HOW TO PLAY EQEMU BEFORE LEARNING HOW TO HOST ONE!

- ORIGINAL THREAD HERE!


2) Download MYSQL! CLICK HERE

- Install MYSQL, then run WinMySQLAdmin.exe , and youll be asked to type in a username and password, write this down or keep it in mind.


3) To grant priveleges to your database... click START (in left toolbar of your computer), click RUN, click BROWSE..., look for your mysql.exe file, and at the end of the command type in -u root

- EXAMPLE: c:/mysql/bin/mysql.exe -u root (CLICK ENTER)



4) Download the following databases: CLICK HERE | DOWNLOAD THIS TOO | THIS TOO | DON'T FORGET THIS!

- After downloading them, put them into your mysq/bin folder (unzip the .zip file and put the .sql files into your bin folder)

- NOTE: If you wanna play EQEMU single player by urself on ur computer without hosting on the server, download minilogin... HERE

5) Now lets make a new database. Leave the mysql.exe -u root up, and type in..

create database eq;

use eq;

source (.sql FILE NAME HERE);

- For source, type in....
---> WARNING: IN THIS ORDER OR ELSE! <---

source PEQ_Kunark_RC1.sql;
source PEQ_Kunark_RC1_keep_accts.sql;
source merchantlist_temp.sql;
source doors_update.sql;
source zonepoints.sql;
source tl.sql;
source tributes.sql;


- Type in this command to make NPC's actually work (in mysql -u root) (I know I was scared to notice the NPC's didnt work just because of this one line of code :shock: )

ALTER TABLE npc_types ADD npc_aggro TINYINT NOT NULL DEFAULT '0';

- If you plan on playing EQEMU single player (minilogin) type this in...

INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server :)'); 

alter table account add minilogin_ip varchar(32) not null;

- If you get error 1017 when trying to use minilogin, make a new account and type this in for the account. Replace USERNAME_HERE for your login username.

insert into account (name,status, minilogin_ip) values('USERNAME_HERE',250,'127.0.0.1');

If you are still getting error 1017, edit the MiniLoginAccounts.ini to say this...

# Max 200 lines total (including comments and blank lines)
# Blank lines may mess up the line # reported in error messages
127.0.0.1 USERNAME_HERE PASSWORD_HERE

NOTE: replace USERNAME_HERE for your account username, and replace PASSWORD HERE for your account password (not your mysql one!)(PUT 1 SPACE AFTER!!!)


6) Copy and paste this

GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;

REPLACE...
Username = your mysql username
Password = your mysql username

Originally Posted by EXAMPLE

GRANT ALL PRIVILEGES ON *.* TO MYMYSQLUSERNAME@localhost IDENTIFIED BY 'MYMYSQLPASSWORD' WITH GRANT OPTION;

WARNING: If using minilogin on LAN, "single player", then you may use *.* in the above command, however if hosting a server for public use, correct to... EQDATASEHERE.*

Originally Posted by EXAMPLE

GRANT ALL PRIVILEGES ON EQDATABASEHERE.* TO MYMYSQLUSERNAME@localhost IDENTIFIED BY 'MYMYSQLPASSWORD' WITH GRANT OPTION;

NOTE- If you followed my tutorial perfectly, change EQDATABASEHERE.* to eq.*

EQDATABASEHERE.*

should be replaced for

eq.*

7) Change these files...

LoginServer.ini
db.ini
Boot5zones.bat


(NOTE: If your running minilogin and playing by urself, replace IP_ADDRESS_HERE for 127.0.0.1)
LOGINPORT
change to 5994 = host server for eqemu
change to 5999 = minilogin, eqemu single player by yourself
If your not running minilogin, delete
[LoginConfig]
ServerMode=MiniLogin
ServerPort=5999

LoginServer.ini

[LoginServer]
loginserver=IP_ADDRESS_HERE
loginport=5999
worldname=SERVER_NAME_HERE
worldaddress=IP_ADDRESS_HERE
locked=false
account=
password=


[WorldServer]
Defaultstatus=20
Unavailzone=

[ChatChannelServer] 
worldshortname= Jakeees
chataddress= 
chatport= 

[LoginConfig] 
ServerMode=MiniLogin 
ServerPort=5999

NOTE: IF YOU DONT WANT TO USE MINILOGIN, AND YOU WANNA HOST A PUBLIC SERVER DO THE FOLLOWING...

DELETE:
[LoginConfig]
ServerMode=MiniLogin
ServerPort=5999

REPLACE:
loginport=5999 -----> loginport=5994

REPLACE:
loginserver=IP_ADDRESS_HERE ----> loginserver=newlogin1.eqemulator.net


NOTE: If hosting on minilogin (eqemu single player) change YOUR_IP_ADDRESS_HERE to 127.0.0.1
NOTE: You gotta right click on boot5zones.bat and click EDIT.

Boot5zones.bat

start zone . YOUR_IP_ADDRESS_HERE 8780 YOUR_IP_ADDRESS_HERE
start zone . YOUR_IP_ADDRESS_HERE 8781 YOUR_IP_ADDRESS_HERE
exit
cls

NOTE: If you followed the tutorial perfectly, then database=eq

db.ini

[Database]
host=localhost
user=YOUR_MYSQL_USERNAME_HERE
password=YOUR_MYSQL_PASSWORD_HERE
database=YOUR_EQ_DATABASE_HERE

8) Go into your Everquest directory, and copy your spells_en.txt and spells_us.txt files and put them into your EQEMU folder.

9) (ONLY DO THIS IF YOU HAVE TROUBLE ZONING)
Download the .map files! CLICK HERE

- Create a new folder inside your EQEMU folder called maps, put the maps into that folder.

10) RUNNING THE PROGRAM!

- Click on MiniLogin.exe (ONLY DO THIS IF YOU PLAN ON PLAYING EQEMU SINGLE PLAYER BY YOURSELF AND WITH NO ONE ELSE EXCEPT PEOPLE ON AN LAN WITH YOU!)

- Click on World.exe

- Click on Boot5zones.bat

(leave all these programs up, DON'T CLOSE ANY OF THEM FOR ANY REASON OR ELSE BYE BYE SERVER!)

POOF YOUR SERVER IS UP!

IMPORTANT NOTE: IF YOUR USING MINILOGIN CHANGE YOUR EQHOST TO THIS! CLICK HERE!

REMEMBER TO MAKE THE EQHOST.TXT FILE READ ONLY!!!!
(right click on eqhost.txt, click properties, click the READ-ONLY check box)