Speedz
10-23-2004, 03:58 AM
Just a warning here first:
I am by no means an expert at this, it took me quite a while to get it going, but I will do my best with my example of what I have for a setup,, for those who struggle with it.
Threads of importance (please read before/during/in addition to this ).
minilogin main thread:
http://www.eqemulator.net/forums/viewtopic.php?t=17843
For those with routers:
http://www.eqemulator.net/forums/viewtopic.php?t=17370&highlight=nat&sid=ff7e0f4c31 ade1ae29f44b1901e6eea7
I will assume that you have the files needed, or know where to get em.
If you don't know please search before asking, everything to get you going is on the forums here. Getting the files needed is the easy part.
I am just going to show you my config/ini files etc...for the examples.
Boot5Zones.bat
REM: ****Read this first!!!****
REM: This file requires your real IP in the place of "EXTERNAL_IP_HERE" 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 . EXTERNAL_IP_HERE 7995 127.0.0.1
start zone . EXTERNAL_IP_HERE 7996 127.0.0.1
start zone . EXTERNAL_IP_HERE 7997 127.0.0.1
start zone . EXTERNAL_IP_HERE 7998 127.0.0.1
start zone . EXTERNAL_IP_HERE 7999 127.0.0.1
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------------------------
LoginServer.ini
### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.
### --- Public Login is un-supported as is LAN playing. CPE-65-31-95-165.wi.rr.com We reccomend using the EQEmu.net Loginserver ALWAYS.
### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.
# READ README.TXT
[LoginServer]
loginserver=EXTERNAL_IP_HERE
loginserver2=EXTERNAL_IP_HERE
loginport=5999
loginport2=5999
worldname=Your_World_Name_Here
worldaddress=EXTERNAL_IP_HERE
locked=FALSE
account=
password=
[WorldServer]
Defaultstatus=5
Unavailzone=
[ChatChannelServer]
worldshortname=
chataddress=
chatport=
[LoginConfig]
ServerMode=MiniLogin
ServerPort=5999
eqhost.txt
[LoginServer]
Host=EXTERNAL_IP_HERE:5999
Now with all that in mind, if you don't know how to get your external ip, try this:
www.whatismyip.com
But I did not use what this told me. To get the type of address or whatever I use:
Go into IRC. do a whois on your nick. you will see something like this:
somenick is somenick@blah-blah-blah.cable.mindspring.com * somenamehere
somenick on #eqemu
somenick using Stewie.EQEmulator.net Victory is Mine! EQEmulator IRC Server
somenick has been idle 28secs, signed on Sat Oct 23 09:00:58
somenick End of /WHOIS list.
somenick is what ever your nick is in IRC
the blah-blah-blah etc...... is the part you will need (it won't say blah-blah but you will see what you need)
You want everything after the @ sign up to the .com or .net whichever your isp designates.
So this example would have an EXTERNAL_IP_HERE of
blah-blah-blah.cable.mindspring.com
Yes you want the dashes and all.
So anyway, if this is a noob thing to do and the experts don't agree or whatever heh be gentile I'ma bleeder. :-P This is just what I did and it works :-)
Anyway back to the story:
Ok that is the connection end of it, now is where it gets tricky (or did for me)
I have minilogin in the eqemu directory root, so put it there.
In your database make sure you follow the directions in the first link I gave you.
My examples as follows: (to get these examples in your database sql entries to follow as were listed on the thread of my first link)
Account.sql
DROP TABLE IF EXISTS account;
CREATE TABLE account (
id int(11) NOT NULL auto_increment,
name varchar(30) NOT NULL default '',
charname varchar(64) NOT NULL default '',
packencrypt blob NOT NULL,
sharedplat int(11) NOT NULL default '0',
password varchar(50) NOT NULL default '',
status int(5) NOT NULL default '0',
lsaccount_id int(11) unsigned default NULL,
gmspeed tinyint(3) unsigned NOT NULL default '0',
revoked tinyint(3) unsigned NOT NULL default '0',
minilogin_ip varchar(32) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY name (name),
UNIQUE KEY lsaccount_id (lsaccount_id)
minilogin_ip varchar(32) NOT NULL;
) TYPE=MyISAM;
INSERT INTO account VALUES (1,'ACCOUNT_NAME_USED_TO_START_HERE','','',0,'PASS WORD_USED_TO_START_EQ',250,62266,1,0,'192.168.2.xx x');
NOTE:
This line here will kill all accounts in your database:
DROP TABLE IF EXISTS account;
Now if you only want to add an account to this database you only need :
alter table account add minilogin_ip varchar(32) not null;
INSERT INTO account VALUES (1,'ACCOUNT_NAME_USED_TO_START_HERE','','',0,'PASS WORD_USED_TO_START_EQ',250,62266,1,0,'192.168.2.xx x');
EDIT: Where it says 192.168.2.xxx.....You need to enter your internal network ip, if ya don't already get that :-)
Next up is variables.sql. you don't need to replace this table so just add this line:
INSERT INTO variables VALUES ('LoginType','Minilogin','Set this to Minilogin to login using a minilogin server :)','20041023025830');
IF you get connected but bumped off when trying to go past the login screen and get some corpse error (forgot exactly what it says)
Source this:
Player_corpses.sql
DROP TABLE IF EXISTS `player_corpses`;
CREATE TABLE `player_corpses` (
`id` int(11) unsigned NOT NULL auto_increment,
`charid` int(11) unsigned NOT NULL default '0',
`charname` varchar(64) NOT NULL default '',
`zoneid` smallint(5) NOT NULL default '0',
`x` float NOT NULL default '0',
`y` float NOT NULL default '0',
`z` float NOT NULL default '0',
`heading` float NOT NULL default '0',
`data` blob NOT NULL,
`timeofdeath` datetime NOT NULL default '0000-00-00 00:00:00',
`rezzed` tinyint(3) unsigned default '0',
PRIMARY KEY (`id`),
KEY `zoneid` (`zoneid`)
) TYPE=MyISAM;
99% of this was a result of Edgar1898's guide in the link up top. Thank you much Edgar for giving this to us. :-)
I wrote this while hyped up on coffee and not having any sleep for many hours. So if I missed anything please add to it, or I will if I catch it.
After you follow this to a "T" if you still get errors or whatever, try this:
Check all your versions of files. Make sure you are running up to date stuff.
Re-read the router link and double check it with your setup (as this hung me up long ago).
I am by no means an expert at this, it took me quite a while to get it going, but I will do my best with my example of what I have for a setup,, for those who struggle with it.
Threads of importance (please read before/during/in addition to this ).
minilogin main thread:
http://www.eqemulator.net/forums/viewtopic.php?t=17843
For those with routers:
http://www.eqemulator.net/forums/viewtopic.php?t=17370&highlight=nat&sid=ff7e0f4c31 ade1ae29f44b1901e6eea7
I will assume that you have the files needed, or know where to get em.
If you don't know please search before asking, everything to get you going is on the forums here. Getting the files needed is the easy part.
I am just going to show you my config/ini files etc...for the examples.
Boot5Zones.bat
REM: ****Read this first!!!****
REM: This file requires your real IP in the place of "EXTERNAL_IP_HERE" 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 . EXTERNAL_IP_HERE 7995 127.0.0.1
start zone . EXTERNAL_IP_HERE 7996 127.0.0.1
start zone . EXTERNAL_IP_HERE 7997 127.0.0.1
start zone . EXTERNAL_IP_HERE 7998 127.0.0.1
start zone . EXTERNAL_IP_HERE 7999 127.0.0.1
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------------------------
LoginServer.ini
### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.
### --- Public Login is un-supported as is LAN playing. CPE-65-31-95-165.wi.rr.com We reccomend using the EQEmu.net Loginserver ALWAYS.
### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.
# READ README.TXT
[LoginServer]
loginserver=EXTERNAL_IP_HERE
loginserver2=EXTERNAL_IP_HERE
loginport=5999
loginport2=5999
worldname=Your_World_Name_Here
worldaddress=EXTERNAL_IP_HERE
locked=FALSE
account=
password=
[WorldServer]
Defaultstatus=5
Unavailzone=
[ChatChannelServer]
worldshortname=
chataddress=
chatport=
[LoginConfig]
ServerMode=MiniLogin
ServerPort=5999
eqhost.txt
[LoginServer]
Host=EXTERNAL_IP_HERE:5999
Now with all that in mind, if you don't know how to get your external ip, try this:
www.whatismyip.com
But I did not use what this told me. To get the type of address or whatever I use:
Go into IRC. do a whois on your nick. you will see something like this:
somenick is somenick@blah-blah-blah.cable.mindspring.com * somenamehere
somenick on #eqemu
somenick using Stewie.EQEmulator.net Victory is Mine! EQEmulator IRC Server
somenick has been idle 28secs, signed on Sat Oct 23 09:00:58
somenick End of /WHOIS list.
somenick is what ever your nick is in IRC
the blah-blah-blah etc...... is the part you will need (it won't say blah-blah but you will see what you need)
You want everything after the @ sign up to the .com or .net whichever your isp designates.
So this example would have an EXTERNAL_IP_HERE of
blah-blah-blah.cable.mindspring.com
Yes you want the dashes and all.
So anyway, if this is a noob thing to do and the experts don't agree or whatever heh be gentile I'ma bleeder. :-P This is just what I did and it works :-)
Anyway back to the story:
Ok that is the connection end of it, now is where it gets tricky (or did for me)
I have minilogin in the eqemu directory root, so put it there.
In your database make sure you follow the directions in the first link I gave you.
My examples as follows: (to get these examples in your database sql entries to follow as were listed on the thread of my first link)
Account.sql
DROP TABLE IF EXISTS account;
CREATE TABLE account (
id int(11) NOT NULL auto_increment,
name varchar(30) NOT NULL default '',
charname varchar(64) NOT NULL default '',
packencrypt blob NOT NULL,
sharedplat int(11) NOT NULL default '0',
password varchar(50) NOT NULL default '',
status int(5) NOT NULL default '0',
lsaccount_id int(11) unsigned default NULL,
gmspeed tinyint(3) unsigned NOT NULL default '0',
revoked tinyint(3) unsigned NOT NULL default '0',
minilogin_ip varchar(32) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY name (name),
UNIQUE KEY lsaccount_id (lsaccount_id)
minilogin_ip varchar(32) NOT NULL;
) TYPE=MyISAM;
INSERT INTO account VALUES (1,'ACCOUNT_NAME_USED_TO_START_HERE','','',0,'PASS WORD_USED_TO_START_EQ',250,62266,1,0,'192.168.2.xx x');
NOTE:
This line here will kill all accounts in your database:
DROP TABLE IF EXISTS account;
Now if you only want to add an account to this database you only need :
alter table account add minilogin_ip varchar(32) not null;
INSERT INTO account VALUES (1,'ACCOUNT_NAME_USED_TO_START_HERE','','',0,'PASS WORD_USED_TO_START_EQ',250,62266,1,0,'192.168.2.xx x');
EDIT: Where it says 192.168.2.xxx.....You need to enter your internal network ip, if ya don't already get that :-)
Next up is variables.sql. you don't need to replace this table so just add this line:
INSERT INTO variables VALUES ('LoginType','Minilogin','Set this to Minilogin to login using a minilogin server :)','20041023025830');
IF you get connected but bumped off when trying to go past the login screen and get some corpse error (forgot exactly what it says)
Source this:
Player_corpses.sql
DROP TABLE IF EXISTS `player_corpses`;
CREATE TABLE `player_corpses` (
`id` int(11) unsigned NOT NULL auto_increment,
`charid` int(11) unsigned NOT NULL default '0',
`charname` varchar(64) NOT NULL default '',
`zoneid` smallint(5) NOT NULL default '0',
`x` float NOT NULL default '0',
`y` float NOT NULL default '0',
`z` float NOT NULL default '0',
`heading` float NOT NULL default '0',
`data` blob NOT NULL,
`timeofdeath` datetime NOT NULL default '0000-00-00 00:00:00',
`rezzed` tinyint(3) unsigned default '0',
PRIMARY KEY (`id`),
KEY `zoneid` (`zoneid`)
) TYPE=MyISAM;
99% of this was a result of Edgar1898's guide in the link up top. Thank you much Edgar for giving this to us. :-)
I wrote this while hyped up on coffee and not having any sleep for many hours. So if I missed anything please add to it, or I will if I catch it.
After you follow this to a "T" if you still get errors or whatever, try this:
Check all your versions of files. Make sure you are running up to date stuff.
Re-read the router link and double check it with your setup (as this hung me up long ago).