Help with an SQL input

[Mortow]

If you look at the last page of this post it gives sql code to add defiant gear drops.

http://www.eqemulator.org/forums/sho...=defiant+drops

I just use these and adjust where needed for the drops I want to add to level range.

[Traul]

Originally Posted by NatedogEZ

Can do it the lazy way like I do!

Make a loottable with just that specific lootdrop and add it through perl

(they will have their normal drops + the custom stuff from this table)

global_npc.pl

sub EVENT_SPAWN {

	if ($mlevel >=1 && $mlevel <= 20) {
		$npc->AddLootTable(104967);    #whatever loottable you wanna add to them
	}

}

That's a really clever workaround, had no idea you could do something like this.

Originally Posted by Mortow

If you look at the last page of this post it gives sql code to add defiant gear drops.

http://www.eqemulator.org/forums/sho...=defiant+drops

I just use these and adjust where needed for the drops I want to add to level range.

This is exactly what I'm looking for, thanks!

[Traul]

One more question now, what query could I use in order to remove a lootdrop from a loottable if a different lootdrop exists within that loottable. As in any loottable that has lootdrop1 AND lootdrop2 would remove lootdrop1 from its loottable.