Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2012, 05:54 AM
pythag
Sarnak
 
Join Date: Jan 2012
Posts: 56
Default How I got there

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
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 10:22 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3