Run that query last. Sorry about that I had forgotten about tables with a 100% probability and a multiplier set last night. I'll also add that query to SVN.

With probability back the new system can function exactly like the old if needed. But it is my hope that over time, server ops can incorporate the new features of loot into their server as it really is a more robust much better overall system.

Yup, I ran 100% probability query last and so far the users are saying loot is back to normal.

I appreciate being able to keep old system drop rates that were intended, and I plan to use the new system the way it was meant to be used for future content.

I have an item with 1/666 chance for drop rate which required a chance of a chance, but now I can just make it 0.0015 chance. So I'll definitely be taking advantage of that float!

Thanks again

Akkadius wrote up a kick-ass script to grab the loot data from Magelo and insert it into the DB. Many NPCs have a long list of < 1% drops. I've been testing out all those NPCs and the new system is handling it perfectly. Some of the NPCs have 100+ < 1% items and you'll be lucky if one of them drops on PEQ, which is in-tune with Live. So yeah, that's my favorite part of the new system as well.

This new script and database update are still in the works, correct?

The Magelo loot/merchant dump will be in the next PEQ database for OoW and after. GoD and before are already pretty good due to manual changes by the PEQ team.

Good stuff! I grabbed the database a while ago from the BETA backend download :)

After about 1/2 day of testing, players report loot is working 99.9% as before. Really hard to find anything 'not intended' drop rates now.

Thanks eqemu team!

The PEQ DB with Magelo's loot/merchants merged in for OoW to VoA (RoF is not on Magelo yet) is now up on PEQ SVN: https://code.google.com/p/projecteqdb/downloads/list

In addition, since Derision updated EQExtractor to work with the newest patch, Robregen got collects for all the RoF zones. They are in this DB as well. Of course, they cannot be played yet as we don't have a compatible client, but the f2p Steam client is being worked on currently :)

We are missing factions and the NPCs all need a mass stat update, but realistically there is nothing stopping folks from playing in the newer zones up to what UF supports. There isn't any quests or events of course, but you can certainly run around, kill things, and collect loot now.

awyeaaaah, christmas!

New PEQ 2 days before my birthday? You guys rock, keep up the incredible work!

Is there a copy of the Magelo to DB script? or could someone upload a sql for zone (moores) all I have for drops is item (Watchtower Remains) for everyone in the zone.

Im at db rev 2294

I'm not sure how that happened, but it's fixed now in PEQ. It'll be in the next version of the DB. If I can easily get a diff, I'll post that. If not, you'll have to wait for the next revision of the DB.

I attached a diff of the fixed Moors loot. You'll either need your DB to be named PEQ, or do a search/replace for `peq` and replace it with your `database`

Thanks cavedude, yes my db is peq, but I don't have permission to download the zip file.

I uploaded it to PEQ, it'll also be in the next revision of the DB: http://www.peqtgc.com/moors_loot.zip

Thanks cavedude