HOW TO: Setup the EqEmu 5.7DR4 databases (06/14/04)

[vrated]

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:


mysql -f -s --no-beep --tee=mysqlout.txt
SOURCE createdb.sql;


createdb.sql should be a text file with the following copied and pasted:


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/viewtopic.php?p=86554#86554

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

[ryetsu]

Links to those files would be helpful.

And do you have the latest build available for download?

Thanks!

[sodayan]

where I can download the mw_zonepatch.sql ?
actually I get rest of all already

thx a lot

[govtcheeze]

UPDATE loottable_entries SET probability = '##';

Change ## to your desired drop rate chance. 15 gives a lot of items, 8 gives hardly any...so somewhere in the middle seems to work good for live servers.