Help with an SQL input

[Traul]

My SQL skills aren't the best so I was hoping someone might be able to help me out with this.

Essentially, I want to add a specific lootdrop to loot tables that belong to NPCs within a certain level range. What would be the necessary SQL input to do this?

Thanks :)

[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
}

}

[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/showthread.php?t=33764&highlight=defiant+drops

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

[Traul]

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.

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

http://www.eqemulator.org/forums/showthread.php?t=33764&highlight=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.