Mass assigning loot by name or zone, not by level.

[Burningsoul]

I'd like to mass-assign loot to npcs, based on the zone they reside in, or by a crafty name wildcard, like "name NOT like 'a_%'".

Problem is, I rely on GeorgeS' d2loot tool for any lootdrop modifications, but I can only assign lootdrops based on level range with that tool, I need a bit more customization in the search and assigning.

I can comfortably mass-edit the items table by hand to change stats/reqlevels/augslots and the like, so I know this should just be a simple query that can then be adapted to fit my needs, I'm just not sure the best way to go about this.

Anyone have any insight? I've been banging my head against the keyboard for a few days now looking for a correlation in any field from spawn2. npc_types, spawngroup, and spawnentry. I (roughly) see how they're linked, but I can't figure out the proper syntax for a query that uses more than one table. Any help as always, is greatly appreciated.