Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Tutorials/Howto's

Archive::Tutorials/Howto's Archive area for Tutorials/Howto's posts that were moved here after an inactivity period of 90 days.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-17-2004, 04:43 AM
vrated
Fire Beetle
 
Join Date: May 2004
Posts: 15
Default HOW TO: Setup the EqEmu 5.7DR4 databases (06/14/04)

After spending hours trying to compile all the necessary items to build a proper database, I documented it and decided to post what I have compiled so far.

The following will create the EqEmu database in its most complete form as of 06/14/04, running on EqEmu 5.7DR4 - 6-14-04 release.

The following files are needed:
1. MW_057DR2_alpha_1.sql
2. itemtablechanges.sql
3. MW_ZONEPATCH.sql
4. loot_update.sql
5. npc_types_update.sql
6. newFactionList.sql
7. add_factions.sql
8. npc_faction_update.sql

I recommend copying and pasting the following code into a file that you can call for example createdb.sql. You can then source createdb.sql and it will run the entire code, which takes about 4-6 hours. Good idea to do it overnight. There may be some errors caused by the govtcheese faction updates, but for the rest of the sql should run smoothly.

I recommend using the following line to actually run the sql:

Code:
mysql -f -s --no-beep --tee=mysqlout.txt
SOURCE createdb.sql;
createdb.sql should be a text file with the following copied and pasted:

Code:
CREATE DATABASE eqdb;
USE eqdb;
SOURCE MW_057DR2_alpha_1.sql;
SOURCE itemtablechanges.sql;
SOURCE MW_ZONEPATCH.sql;
SOURCE loot_update.sql;
SOURCE npc_types_update.sql;
UPDATE loottable_entries SET probability = '##';
SOURCE newFactionList.sql;
SOURCE add_factions.sql;
SOURCE npc_faction_update.sql;
ALTER TABLE `npc_types` ADD `AC` smallint(5) not null default 0
UPDATE variables SET value=0 WHERE varname='PersistentZoneState';
UPDATE variables SET value=0 WHERE varname='MerchantsKeepItems';
UPDATE variables SET value=0 WHERE varname='holdzones';
I created the following thread to add some customization and difficulty to the EqEmu. Some if is actually more in-line with Eq-Live.

http://www.eqemulator.net/forums/vie...?p=86554#86554

Until I get the links in, please use the SEARCH function to find the files.
Reply With Quote
 


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:45 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