under peqlogindb tblworldserverregistration server last ip address using real or fake ip address
under peqlogindb tblserveradminregistration registrationIp address your local network address
under peqlogindb tblloginserveraccounts lastipadress local network address
under peq database zone_server address ip
under peq database account_ip you should have your friends user # to the account and next should be there ip address
This is my eqemu_config
Code:
<?xml version="1.0">
<server>
<world>
<!-- Set the shortname to ONE word. The longname is what shows up on server list -->
<shortname>VoA</shortname>
<longname>Veil of Alaris</longname>
<!-- DO NOT EDIT ANY LINES BETWEEN HERE AND THE DATABASE SECTION -->
<address>192.168.0.10</address>
<localaddress>127.0.0.1</localaddress>
<!-- Loginserver information. DO NOT EDIT -->
<loginserver>
<host>192.168.0.10</host>
<port>5999</port>
<account>xxxxxxxxxxx</account>
<password>xxxxxxxxxx</password>
</loginserver>
<!-- Server status. Default is unlocked DO NOT EDIT RIGHT NOW -->
<!--<locked/>-->
<!-- <unlocked/> -->
<!-- Sets the ip/port for the tcp connections. DO NOT EDIT -->
<tcp ip="localhost" port="9000" telnet="disable"/>
<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>xxxxxxxxxxxxxxxxxxxxxxxxxxxxx</key>
<!-- Enable and set the port for the HTTP service. Defaults are shown -->
<http port="9080" enabled="false" mimefile="mime.types" />
</world>
<!-- Chatserver (channels) information. DO NOT EDIT -->
<chatserver>
<host>192.168.0.10</host>
<port>7778</port>
</chatserver>
<!-- Mailserver (in-game mail) information. DO NOT EDIT -->
<mailserver>
<host>192.168.0.10</host>
<port>7779</port>
</mailserver>
<zones>
<!-- The defaultstatus is what status the new toons will have on your server -->
<defaultstatus>0</defaultstatus>
<!-- Sets port range for world to use to auto configure zones DO NOT EDIT RIGHT NOW-->
<ports low="7000" high="7100"/>
</zones>
<!-- Set username to root and password is your MySQL password and db to peq -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>xxxxxxxxxxxxx</password>
<db>peq</db>
</database>
<!-- Launcher Configuration DO NOT EDIT-->
<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->
</launcher>
<!-- File locations. DO NOT EDIT -->
<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
<!-- Directory locations. DO NOT EDIT -->
<directories>
<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->
</directories>
</server>
This is my login.ini
Code:
[database]
host = localhost
port = 3306
db = peqlogindb
user = root
password = xxxxxxxxxxx
subsystem = MySQL
[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5999
local_network = 192.168.0.10
[security]
plugin = EQEmuAuthCrypto
mode = 5
[Titanium]
port = 5998
opcodes = login_opcodes.conf
[SoD]
port = 5999
opcodes = login_opcodes_sod.conf
[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType
Code:
[Debug] [02.20.12 - 15:39:27] Logging System Init.
[Debug] [02.20.12 - 15:39:27] Config System Init.
[Debug] [02.20.12 - 15:39:27] MySQL Database Init.
[Debug] [02.20.12 - 15:39:27] Encryption Initialize.
[Debug] [02.20.12 - 15:39:27] Encryption Loaded Successfully.
[Debug] [02.20.12 - 15:39:27] Server Manager Initialize.
[Network] [02.20.12 - 15:39:27] ServerManager listening on port 5999
[Debug] [02.20.12 - 15:39:27] Client Manager Initialize.
[Network] [02.20.12 - 15:39:27] ClientManager listening on Titanium stream.
[Network] [02.20.12 - 15:39:27] ClientManager listening on SoD stream.
[Debug] [02.20.12 - 15:39:27] Server Started.
[Network] [02.20.12 - 15:40:00] New world server connection from 192.168.0.10:63486
[World] [02.20.12 - 15:40:00] Server Veil of Alaris(VoA) successfully logged in.