FOrgot to add, you should consider writing your updates in sql format, ie:

So in the example above, you would write:

This is good for 2 reasons, the first is if you re-source an update of mine, you can simply re-source your sql and the changes are done...no need to do the work again. The second and more important feature is you can post these updates for everyone to use :)

I agree. That's a good idea. I was using the iEQ program when I did it however. :-/ Nifty little program I might add.

Very helpful
 

Pretty Cool, Used it on my server


As said above though, it also took forever to source

ill be adding the update tonight :)

Most of my querys are 0 0 too, its not changing them, i did a fresh install of the db aswell, I sourced mw055 1 then alpha 2 , then doorupdates then dumpeditems then loot update then npc types upate

About 75% of them should be 0, each mob is checked for 4 different permutations of the name as they appear in the MW database:

mob
#mob
mobXX
and #mobXX

This is done for completeness sake, and takes awhile.

It also compares each name with the zone in the spawn table, and compares it to the habitats listing from allakhazam. This is why orcs in different zones carry unique loot.

Also plat isn't dropping off mobs either.

Make sure you got the new version, and sourced it correctly. It has been dropping my server and the live test server AFAIK. I also double-checked the source to make sure plat drops are in there, and they are:

INSERT INTO loottable VALUES ('4179', 'A_Burynai_Burrower', '440', '2944', '0'); -- A_Burynai_Burrower level is 12
INSERT INTO loottable_entries VALUES ('4179', '4179', '1', '15'); -- A_Burynai_Burrower has 1 total items
INSERT INTO lootdrop VALUES ('4179', 'A_Burynai_Burrower');
INSERT INTO lootdrop_entries VALUES (4179, 5652, 1, 1, '100'); -- A_Burynai_Burrower gets Burynai Digmaster\'s Claw

shrug wierd, I sourced it like I always have with your sqls, i did a fresh database with the new update.. shrug not sure then ;/ some plat drops on some mobs but most dont drop plat.

File location has changed. New link is:

http://govtcheeze.eqemulator.net/dow...heeze_loot.rar

- and -

http://govtcheeze.eqemulator.net/dow...e_loot_log.rar

You can always browse to http://govtcheeze.eqemulator.net/download/ for a list of all files I have released.

The link is broke.. anyone have this avail?

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.

-deleted no longer maintained or compatable-

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.

update
 

Hey GOV update your sig bitch!

jk