complete live-like loot tables version 2.0!

[govtcheeze]

VERSION 2.0

(note: this does not add mobs to the game, it simply adds the loot tables for (almost) every mob that is spawned)

AS ALWAYS BACK UP YOUR DATABASE FIRST:

mysqldump -u(username) -p (database) > backup.sql

where (username) = mySQL username and (database) = your eqemu database

A HUGE benefit of this package is I have already added the loot tables for ALL mobs in the game (that have data associated with them). If you decide to place spawns in say Plane of Storms, simply re-source the lootNpcUpdate.sql (to add the proper loot tables to the npc_types database) and your mobs will now have their loot tables done. To take advantage of this feature, it is vital to use the exact mob name from allakhazam and/or eqcollector.com. If you are only adding a few new mobs, just find their lootdrop IDs in my sql code comments, and add it to your spawn statement.

NEW IN THIS RELEASE:
Loot is now divided into 4 tables: wearable, tradeskill, spell/song, and misc. All tables have different odds to drop things, like only 1 wearable, many tradeskill, etc. This produces very live-like drop tables and is what PEQ uses to produce such sexy drops. You will need to update the loot tables and percentages for ubers if you want to guarentee items to drop.

Also new in this release is all future updates will perserve your loot tables, so no more fear of losing changes you make. You should still always back up your DB, but it was re-designed with this in mind.

Current bugs with this release:
None reported yet

Advisory:
All updates for the time being will come as new sql files, and the current tables below will need to be deleted. For this reason, it is not advisable to make updates to your loot tables if you plan to use my updates. Or, save your changes as sql "update" commands so you can source them after sourcing in my sql files.

WARNING:
Please note, by following these steps you WILL LOSE ANY LOOT TABLES YOU HAVE SET UP!. Please make a backup of your data (loottable, loottable_entries, lootdrop, lootdrop_entires, and npc_types specifically) before proceeding.

DO NOT RUN THIS IF YOU ARE USING THE PEQ DATABASE! We have already added (and MUCH improved) the loot updates found here to that release.

Steps to install:

1) download my files from here
2) extract the rar file into your sql\bin directory
3) step 3 no longer applies, ignore it
4) open a dos window and browse to your mysql\bin folder
5) type in the following command, assuming eq is the name of your database:

mysql -f eq<lootTablesUpdate.sql

and wait for it to finish, should be fairly fast
6) before you leave for work/school or go to bed, type in the following command:

mysql -f eq<lootNpcUpdate.sql

and wait many, many hours.
7) enjoy phat lewts from most every mob spawned

Change log:
v0.1 - 2004.03.21
- initial release

v0.2 - 2004.03.23
- fixed a bug reported by wolfman, where mobs not in the MW_055_alpha2 database were missing the first item from their loot table
- this also fixed the incorrect probabilities the rest of their loot table items were receiving

v0.3 - 2004.04.12
- PLAT DROPS (thanks sandy!)
- loots are now zone specific, so fayder/antonica orcs get the right drops, same with PoP/potimeb mobs, etc.
- added a lot of items by hand
- log file can be found here

v0.4 - 2004.05.13
- Updated to work with the new .57 DB release of MW, adding plat to mobs not in the last DB and new items
- Added all Velious quest armor drops
- log file can be found here

v1.0 - 2004.09.17
- completely re-done, hella accurate

v2.0 - 2004.11..05
- divided loot into 4 types of tables, thanks to PEQ team for making me write this update and their input