EQEmulator Forums - Help with an SQL input

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Help with an SQL input (https://www.eqemulator.org/forums/showthread.php?t=37855)

Traul

02-13-2014 08:31 PM

Help with an SQL input

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

02-13-2014 08:53 PM

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

Code:

sub EVENT_SPAWN {



        if ($mlevel >=1 && $mlevel <= 20) {

                $npc->AddLootTable(104967);    #whatever loottable you wanna add to them

        }



}

Mortow

02-13-2014 10:29 PM

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

02-16-2014 01:59 PM

Quote:

Originally Posted by NatedogEZ (Post 228283)

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

Code:

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.

Quote:

Originally Posted by Mortow (Post 228284)

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

Traul

02-16-2014 02:13 PM

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.

All times are GMT -4. The time now is 02:55 AM.