Sandy's Loot Editor

[sandy]

with the last version
you have to delete all sets and to set the monster to not drop any coins to make the looteditor delete completly the loottable
and then if you add a set or make him to drop coins the looteditor will create a new loottable with a new loottable_id
when it deletes completly a loottable it already changes the loottable_id of the npc to 0
if it doesn't work there is then really a bug =) can you give sql examples of when it appears ?

if you want to delete manually a loottable, don't forget to:
- set the loottable_id in npc_types table to 0
- delete the entry in loottable with the id equal to loottable_id in npc_types
- delete all entries in loottable_entries with the loottable_id

some database have loottable ids equal to npc ids
others have no id rules

the goal of this looteditor is really to make the sql loottable structures abstract for the user, so I won't implement any id management for now

but maybe if eqemu would decide to make some id rules to be standard it would be easier for us and I'll implement it in this looteditor =)

for drag and drop idea to make loottables on the fly and then to assign loottables on monsters already filled with items, I already thought about that, but i decided to make it this way so everything is centered on a little window
maybe if it was on a greater project like for example a complete editor where you have a 3D view of the zone, where you can put NPCs by the 3DView, it would be then better that you would be able to create the loottable before to assign it to the monsters, but for just a looteditor I think it's enough =)