Here's some LoY work for PEQ

[Angelox]

Originally Posted by mplostcause

iam still not too good at the whole database workings =P will this work with the cavedudes database? and if not do most people recommend the peq database over it?

This is an extract taken from Cavedude's database - Cavedude has a lot of impressive work done in a lot more zones, but he quit working on it. PEQ's work is done mostly up to Kunark era, and is more complete to that point - but there has been no updates. Neither one of them are posting updates to their database: regardless which one you choose, if you want to see more work or more zones, you have to figure out how to do it yourself.
What you're probably wondering, is what I was wondering when I first started with the emulator: "Which one will be more playable if I made my own server"? The answer is, "none". You can play a little with either of the database, but still theres enough "loose ends" in them as to where they won't be much fun. This is a gigantic project, with many details, and is still young.
If you want to mount a server of your own, you are better off mounting the PEQ database as it is more "playable", and there's a "glimmer of hope" they might update it one day. In my case, when I tried Cavedudes'. I found my self working in the Pre-Kunark zones alot, so i went "PEQ" , which gave me a better start. And now that I'm starting to see how it all works, it's not that hard extracting some data from Cavedudes and inserting into PEQ, thus bringing the best of two worlds together.
The bottom line is, if you want to make your own server, you have to be ready to learn, and do A LOT of work into making some playable zones. You have to comb the Waki's , FAQ's and these forums for answers to your questions. Don't embarrass yourself by posting questions that have answers already posted here many times over.
If you don't want to do all of this and just want to play, there's already some real nice working servers up, with some very nice "individual" work done to them, and are very playable.

[cavedude]

I didn't quit, I've just had no time lately

[Angelox]

Originally Posted by cavedude

I didn't quit, I've just had no time lately

I guess "quit" was an over-statement , sorry about that. I thought I saw a post somewhere where you said you wouldn't be updating your database anymore, that's what i meant. Hopefully, I'm wrong.

[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