Wiki - Installing EQEmu-0.7.0-845 Minilogin with MySQL 5.0.24
Setting up EQEmu-0.7.0-845 Minilogin with MySQL 5.0.24
Why use MySQL 5, you might be asking. Well simple. You use it because it's newer and sleeker. Not to mention that it has a nice group of tools for it that come from the same people who made MySQL 5. So lets get down to business. What you need: ActivePerl - 5.8.7 Build 8138 EQEmu-0.7.0-8458 MySQL 5.0.x8 MySQL Tools8 Everquest Titanium (Install this now, don't patch) MSVCP71.dll8 and MSVCR71.dll8 (Do a Google Search if the links fail.) - From the same site- Minilogin 6.28 EQEmulator Map Pack8 - Database - PEQ's Luclin (Pickup Quest files too)8 - Extra Items - Some SQL Knowledge (Not required, but helpful) Notepad Wordpad (For SQL files, Trust me) Ok, now for program setup. Install ActivePerl, after setup open cmd (Command Prompt) and type ppm. Then type the following. Code:
Install DBI After that type exit. Reboot your system. (This is so the DLL's will work) After reboot install MySQL 5. Skip sign-up. Configure the server, turn off strict mode. For the love of god add bin to the path. Now you can set things up anyway you want (besides what I mentioned). After install you need to install the MySQL tools. These are nice tools that do most of what you might want to do at a faster pace. The SQL statements you have to do later on in this install guide can be done in the Query Browser. BTW, your user name is root. Your password is whatever you set it as. Ok, extract the Project EQ sql files to c:\ (I use root or C:\ because it's less typing later on) Lets begin detailed Database stuff Open cmd. Type cd\ (So your at c:\ or whatever root) and then type "mysql" and enter your password what ever it might be. Once in you have to make the basic Database were PEQ goes. Code:
create database peq; Now, the very basic database is setup. EQEmu Setup Extract EQEmu-0.7.0-845.zip to C:\EQEmu Extract EQEmulator Map Pack to C:\EQEmu\Maps Extract peq-luclin-rc1-quests.zip to C:\EQEmu\Quests Extract Minilogin.zip to C:\EQEmu (Don't overwrite opcodes.conf) Copy C:\Program Files\Sony\Everquest\spells_en.txt to C:\EQEmu Copy C:\Program Files\Sony\Everquest\spells_us.txt to C:\EQEmu copy MSVCP71.dll and MSVCR71.dll to C:\Windows\System32 File Setups Open loginserver.ini and delete all lines starting with #. This is more for cleanleness. Of course please do read it before deleting it. If you want to add notes make sure you use a # in front of them as this turns it into a comment. Code:
[LoginServer] Save, turn off the Notepad. Now open eqemu_config.xml. Code:
<?xml version="1.0"> Now the above just won't do. Lets replace it with the following. Code:
<?xml version="1.0"> And now replace "Serving Machines IP" with the serving machines IP. And "Your Password" with your databases password. Also; <shortname>whatever</shortname> <longname>This Shows Up In Server Select</longname> These two are flexable. So name them as you will. And now with the above done. Let's dive into the SQL Statements. We'll do the most nessisary first. |
Here are the commands. Use Quary browser to execute these one line at a time.
This Block of commands adds the Variables. Things like EXP rates are adjustable with these lines. Code:
INSERT INTO VARIABLES VALUES ('MOTD','Welcome to EverQuest!','Server Message of the Day',20060411132036); This line adds the IP address colum to accounts Code:
ALTER TABLE account ADD minilogin_ip VARCHAR(32) NOT NULL; This is used for spawning zones (Default is 5) Code:
INSERT INTO launcher VALUES ('zones', 5); Modify this with the IP of the computer that will be connecting to the server. Admin is the username. Code:
INSERT INTO accounts VALUES (1, 'Admin', '', 0, 'mini', 250, , 0, 0, 0, 0, 'IP of Account') Now for nessisary modifications to make the database work with EQEmu 7.0-845. Warning: Some of these may fail. Just keep executing them in the order that they appear. Code:
ALTER TABLE spawnentry DROP spawn_limit; And that should do it. You may now log into your MiniServer. If you followed this guide to the letter there is only one account. You can use the Quary Browser to add more people rather than using SQL statements. And play with the other MySQL tools. Administrator is very good. Backing your Database up (A.K.A. Saving face and rear.) While administrator has a nice function for backing data up, it takes a lot more room than a standard backup. So here's a very mini guide to database back up. Open cmd and type cd\ (C:\ should now be your root) Now, here is the command I use. At the command prompt: Code:
Mysqldump -u root -p peq > peq.sql - Turning the server on - So, now everything is setup right? Wrong. One last annoying step. To make you life easier, were going to make a batch file. Go into the EQEmu directory and make a file called start.bat. Then right click it and edit it with note pad. Put this in the file. Code:
@echo off Save the file. What will happen is the file will execute the first two commands. Then it is up to you to wait till the World is connected with the login server. Then after it is connected you can push any key to finish it. P.S. If your Server wont connect with the database you must execute the following line in Query Browser. Code:
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('newpwd'); Replace newpwd with your password. This fixes the non compatibility error. Client side Setup The above guide is designed for a mini login. So I'm adding this to explain client side hookup. Hopefully EQ Titanium is installed. First thing, there is a file named eqhost.txt. Open it and change it to look like this. Code:
[LoginServer] Of course replace "Your Servers IP" with your serving systems IP. Do not (I repeat) DO NOT put localhost even if your playing on the serving system. Save and turn notepad off. Then right click the desktop icon and change the target to look like the following. Code:
"C:\Program Files\Sony\EverQuest\eqgame.exe" patchme "C:\Program Files\Sony\EverQuest\" is actually where ever you installed EQ. If you don't have a desktop icon, make one. If you want a batch file you need the following command in it. Code:
Eqgame patchme And it must be located in the Everquest directory. You may now login. |
If I might add to this wonderful tut (great job), if you are lazy and don't want to copy and paste or, heaven forbid, type the SQL commands one by one, you can copy all of those commands posted above into notepad, then save it as a .sql file... then install Navicat front-end (for MySQL) and after setting it up to connect to your db (very easy) right click on your peq db (or ax, or whatever you named it) in the gui then, from the pop-up menu click "execute batch file" and select your .sql file from the pop-up file browser.....
Just thought that might make things a little easier to digest...:P |
Or, if you're feeling really saucy, save aforementioned .sql file into a nice place, navigate there in a command prompt, start up mysql and "source blah.sql" :)
|
umm
Is this Tutorial still up to date?
Which MySQL version works these days? The tutorial says 5.0+... Ive also heard people say 4.1 works and 5.0 doesnt... Is EQEmu build 0.7.0. 845 still the best/only version of emu that works with Titanium out of the box??? or should i be using 0.7.0?? or 0.7.0 992? Will Minilogin work with Mysql 4.1? Will it work with EQEmu builds previous to 7.0? |
Quote:
Quote:
Quote:
Quote:
|
All times are GMT -4. The time now is 08:37 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.