just thought i should add that while that query will remove defiant drops, theres many more pieces of defiant type gear that still drops, as well as augments, tradeskill items, etc.

Just a warning for those looking to get rid of all out of era stuff like defiant out of their database

shouldent this be 'SET peq.lootdrop_entries.probability = 0' rather than 'SET peq.loottable_entries.probability = 0' ?

Depends. If the defiant is always on its own loot drop you can. Otherwise setting the specific entry to zero makes just that item in the loot drop not get rolled.

This sql will remove all defiant from lootdrops. It also includes the combatant and adept stuff which is pretty much defiant for other slots.

With some of the new DB Fields / Updates the code doesn't match the column count. For anyone having trouble try this structure.

See the 2 highlighted values. This will match up the column count.