Here's some LoY work for PEQ

[cavedude]

No, I plan on updating it again.

[soulshot]

Thats great news!

[Angelox]

This is an update to Gunthak in LoY, should be almost complete with all my additions - here's some thoughts on this;
-You should remove the old Gunthak CSV I posted earlier from the tables, as I changed grids, spawns and other stuff.
-It seems impossible for me to extract loot related tables from a specific zone, as there is nothing of an id attached to them. If anyone can think of a way for me to get all loot-related tables from Gunthark or any other zone, please tell me - that would make the zone "play ready" with little work to do .

GeorgeS!! Again, thank you for the SQL-Extractor program - I hope you try this and tell me if it all worked, If you have any ideas on how to extract loot-related tables, please tell me.

Download page:
http://www.nahunta.org/~angelox/

[sesmar]

For pulling loottable info for the mobs of Gunthak maybe this will point you in the right direction.

Also just a warning this query will take some time to run as it hits 7 different and rather large tables.

SELECT
  spawnentry.npcID,
  npc_types.loottable_id,
  loottable.name,
  loottable_entries.lootdrop_id,
  lootdrop.name,
  lootdrop_entries.item_id
FROM
  spawnentry
  INNER JOIN spawn2
    ON spawn2.spawngroupID = spawnentry.spawngroupID
  INNER JOIN npc_types
    ON npc_types.id = spawnentry.npcID
  INNER JOIN loottable
    ON loottable.id = npc_types.loottable_id
  INNER JOIN  loottable_entries
    ON loottable_entries.loottable_id = loottable.id
  INNER JOIN lootdrop
    ON lootdrop.id = loottable_entries.lootdrop_id
  INNER JOIN  lootdrop_entries
    ON lootdrop_entries.lootdrop_id = lootdrop.id
WHERE
  spawn2.zone='gunthak'
ORDER BY
  spawnentry.npcID,
  npc_types.loottable_id,
  loottable_entries.lootdrop_id,
  lootdrop_entries.item_id

[GeorgeS]

The sql for populating those zones worked very well. Had to first remove the previous zone, but that was not hard.

Good job

GeorgeS

[Angelox]

Thanks for all the help - Sesmar's query puts me on the proper track of thinking. The query/sort works well, but still has data spread out through the given table. What I need is, to put them in zone groups, for extraction.
I noticed in npc_types , theres a loottable_id column , and also the zone id is in npc_types.id ,as it appears the first numbers contain the zone in them - example : an entry in npc_types.id 224035 means the npc is from zone 224, and he's entry number 035. So, maybe I could use the zone data from npc_types.id , and loot data from npc_types.lootable_id to sort the other loot-related tables by zone?

[sesmar]

I am not exactly sure on how the PEQ does their numbering but I do not think an NPC can belong to a zone based on the npc_types.id because a given NPC can appear in any number of zones. Such as a Gnoll Pup can be in North Qeynos and Qeynos Hills.

In order to get Loot Table information for the mob in a particular zone you will have to start with Spawn2 to get all the Spawn Groups in that zone as any NPC that spawns in the zone will be an entry in a spawn group. Then you link to npc_types using the ID and from there to LootTable information which is spread out over multiple tables.

I used one query to display some of the information you need but my suggestion would be to write the query in stages pull out all the information from each table you need so you can reinsert the loot information with new ID's to fit your DB.