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

[Taggerung01]

Very nice.

[Wolfman]

This is a very cool idea. However, I noticed when comparing your tables to allakhazam's that the first item listed on allakhzam's seems to be missing on a majority (didn't check them all) of the entries in the lootdrop_entries table. I don't know if its a problem with your script or something. For example:

Xegony Drops-

INSERT into lootdrop_entries values (11399, 16373, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Elemental Greaves Mold
INSERT into lootdrop_entries values (11399, 16381, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Elemental Leather Pant Pattern
INSERT into lootdrop_entries values (11399, 16388, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Elemental Silk Pant Pattern
INSERT into lootdrop_entries values (11399, 13672, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Exquisite Phoenix Feather Mantle
INSERT into lootdrop_entries values (11399, 26737, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Exquisite Puresteel Wraps
INSERT into lootdrop_entries values (11399, 10234, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Simple Ring of Purity
INSERT into lootdrop_entries values (11399, 14747, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Vest of Phoenix Feathers
INSERT into lootdrop_entries values (11399, 26788, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Xephyrus, Wand of the Flowing Wind

When Allakhazam lists:

Elemental Chain Pant Pattern
Elemental Greaves Mold
Elemental Leather Pant Pattern
Elemental Silk Pant Pattern
Essence of Wind (PoP)
Exquisite Phoenix Feather Mantle
Exquisite Puresteel Wraps
Simple Ring of Purity
Vest of Phoenix Feathers
Xephyrus, Wand of the Flowing Wind

as all the loot.

The table your script created is missing the Elemental Chain Pant Pattern which happens to be first on allakhzam's list. The same thing occured when I checked the Avatars of dust,wind,smoke, and mist. I just wanted to point that out in case you hadn't noticed. And thanks for writing a pretty useful and cool script.

[RexChaos]

I for one can NOT wait to try this out when I get home. (crossing fingers)

[Jezebell]

Thanks alot, this sounds awesome, i will try it out when I get home.

[sandy]

hello =)
you said u used a script to get all the loot tables
the script get infos directly from allakhazam's site and create directly the sql files ?

I was thinking about how to improve my looteditor for the next version, and was thinking about something like that
so i'm interested about you and your script if it does that
=)

[Klasfide]

this update works great, hope to see more, some mobs loot tables/loot still missing, I hope to see more loot-update.sql files for this addon GOOD WORK

[Klasfide]

Need to get a sql update patch to add plat drops to all of the mobs aswell

[govtcheeze]

Wolfman...thanks for the bug report. I found it only affected mobs not spawned in the MW_055 DB, and the code has been updated. I will post the new SQL ASAP.

Sandy: not a problem, let me get the kinks worked out and we can talk

[jris]

wow this looks really awesome im gonna try this as soon as i get hom!

[SiliconeClone]

The link is broke.. anyone have this avail?

[Calabeth]

Ok Q for ye Mr Cheeze.

In your updates and such are the Rathe Mtns Hill Giants supposed to be poor bastages now? The server I am playing on has a DB what supposedly has your Loot and Faction DB added in with it. But the Giants are like 3pp at most so far.

If they are supposed to be alot richer then that I'll let the server admin know so they can resource your loot DB into there instead.

PS clicking on your links results in 404 Not Found.

[sdabbs65]

-deleted no longer maintained or compatable-

[govtcheeze]

Its been 6 months since this was maintained, but I am pretty sure coin was based on the level of the mob. I had some formula based on average mob coin values from live and applied it generally to the script since prior to this, mobs didnt drop any coin.

[Jezebell]

One thing I have noticed is that most of the Plane of Timeb gods are missing from the lootdrop table, and also the gods in Plane of Timeb that have loot are carrying their old loot from their previous zone. For instance Terris Thule has the loot from Plane of Nightmareb. Didn't know if you were aware of this or working on it so thought I would mention it, thanks alot for this update!