View Single Post
  #1  
Old 04-24-2011, 10:37 AM
Uthgaard Uthgaard is offline
VIP / Contributor

Uthgaard's Avatar

Join Date: Aug 2010
Posts: 5,451
Default

Quote:
Originally Posted by Darian [You must be logged in to view images. Log in or Register.]
Will there be more or fewer gems dropping now? Or were they not dropping the right kinds?
About a month ago I went through the DB and consolidated a lot of unnecessary duplicate records in almost all of the content tables (lootdrops, loottables, lootdrop entries, loottable entries, npc faction tables and entries, spawngroups, grids, etc). Shaved about 13 mb off of the db, but some minor details got hit in the process.

Full ranges of trash drops, research drops, etc., applied by pattern. Previously, many npc loot tables were clones of whatever the allakhazam moderators tacked onto their pages to reflect coments, populated into the peq db by a webcrawler. In many cases, that was a small fraction of the true potential list of drops for a given mob, and put the chance that certain things would drop at opposition with unrelated drops. In the process, seafuries got bumped down to a 15% chance to drop a gem from the gem table of that pattern. So I fixed it back up to the rate it was before.

Overall, more things should be accurate, certain drops won't be so hard to find, and the server is slightly more efficient from the content end.