Installed programs
Mysql
Perl 5.1
Tortoisesvn
Heidisql
Navigated to c:\mysql\bin – right click use
http://projecteqdb.googlecode.com/svn/trunk - downloads peqdatabase into bin folder.
Find c:\mysql\bin\peqdatabase\peqdb_Rev2100.sql.gz file and extract it to same folder so you have c:\mysql\bin\peqdatabase\peqdb_rev2100.sql file available.
Start\run\command
Cd msysql\bin\peqdatabase to locate directory
Problem – unable to cd to peqdatabase as name to long so renamed to peqdb, Cd msysql\bin\peqdb
Once at correct point type mysql –u root –p, then enter password.
Then create database peq;
Use peq;
source peqdb_rev2100.sql;
source load_player.sql;
source load_bots.sql;
Create a folder called c:\eqemufiles for storage.
Create a folder called c:\eqemuserver – to place extracted server files
Download eqemuloginserver.rar to c:\eqemufiles – then extract all of that to c:\eqemuserver
Create subfolder c:\eqemufiles\server files, then right click and svn
http://projecteqemu.googlecode.com/svn
Navigate to folder c:\eqemufiles\server files\trunk\EQEmuServer\EQEmuLoginServer\login_uti l.
Copy eqemulogin.ini, login_opcodes.conf to c:\eqemuserver folder
Problem eqemulogin.ini doesn’t exist however forums says use login.ini also several opcodes
Navigate further to …login_utl\ms\debug.
Copy EQEmuAuthCrypto.dll to c:\eqemuserver folder
Using Heidi create new database peqlogin – then highlight it
Import sql, navigate to c:\eqemufiles\server files\trunk\EQEmuServer\EQEmuLoginServer\login_uti l
Choose file EQEmuLoginServerDBInstall.sql then F9 to execute
Create two text files ending in .sql using format all files with:
File1- Insert into tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) values ('myaccout', sha('mypassword'), 'admin@somewhere.com', now(), '127.0.0.1');
File2 - INSERT INTO `tblworldserverregistration` (`ServerID`, `ServerLongName`, `ServerTagDescription`, `ServerShortName`, `ServerListTypeID`, `ServerLastLoginDate`, `ServerLastIPAddr`, `ServerAdminID`, `Note`) VALUES ('1', 'MYLAND', 'MINE', 'LAND', '2', NULL, NULL, '1', NULL);
Back to Heidi with peqlogin selected – import file1, f9 to execute – import file2, f9 to execute – exit heidi
Find eqemu_config.xml within c:\eqemuserver and edit.
Problem it is not there – copied it from a previous version I found??
<world>
<shortname>MINE</shortname>
<longname>MYLAND</longname>
<!-- Only specify these two if you really think you need to. (read: You don't) -->
<address>localhost</address>
<localaddress>localhost</localaddress>
<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>localhost</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver> <!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>mysqlPassword</password>
<db>peq</db>
</database>
Create bat file
@echo off
start EQEmuLoginServer.exe
start world
echo waiting for the world to finish before starting zone...
sleep 10
For now left maps and quests out as also in the server folder the directories do not exist but can copy/paste later