Database Question

[trevius]

The lootable doesn't actually have any items directly tied to it. It is there to hold 1 or more lootdrop tables, which can make creating complete lootables much easier. The way it works is you create a loot table for an NPC, then you can create lootdrop tables of that loot table. The loot drop tables are the ones that actually have loot tied directly to them. The reason for this is so you can have multiple lootables in a zone so that all mobs have different loot on them, but if you wanted to add 1 group of items (maybe quest drops) for all mobs in the zone to have, you only need to make 1 loot drop table for that and add that table to all of the loot tables in the zone. It makes it really easy to set certain drops for certain mobs without having to build each loot table completely from scratch.

If you try out GeorgeS' NPC Loot Editor, you will see exactly how it works and it should be much easier to understand.

For the NPC Types, and other spawn related IDs, it is probably good to have the option to either use the next available, or to set a range of IDs to use or to start at. The range of IDs should make it easier to keep custom content separate from other databases.

As far as I know, I think NPC_Types auto increments, but you would need to look at how the ID field is built to find out for sure.

[HurtinuDaily]

I think you both missed my question, what does the the lootdrop table with only 2 columns do?? i.e.

ID Name
0 1_A_Decaying_Skeliton_Wear
1 1_A_Decaying_Skeliton_Trade

as far as NPC_Types ID, I tried it myself and figured it out. Thanks

[Bulle]

It does not do much per se, in that it does not add any useful information for the server program. It is there to list the lootdrop IDs that exist, and provide some nice comment for each lootdrop. I guess if you replace the name by anything (like the name of your dog) it would work the same. Still the lootdrop entry for each lootdrop ID has to be there or the server will fail.

So if you need to add a new lootdrop ID, insert a row there and put whatever name you feel like. If you abide by this rule your tool should work fine.

[HurtinuDaily]

Originally Posted by Bulle

It does not do much per se, in that it does not add any useful information for the server program. It is there to list the lootdrop IDs that exist, and provide some nice comment for each lootdrop. I guess if you replace the name by anything (like the name of your dog) it would work the same. Still the lootdrop entry for each lootdrop ID has to be there or the server will fail.

So if you need to add a new lootdrop ID, insert a row there and put whatever name you feel like. If you abide by this rule your tool should work fine.

Thanks, that answers my question exactly.