Here's some LoY work for PEQ

[GeorgeS]

I have added 'zonename_loottable_id' to the loottable.name in my editor. It uses that convention as default now, and allows you to change the default under tools menu.

As Sesmar mentioned, npc_id's are reused in many zones, so that convention in the tables is strictly for the datatable developers and may not apply to everyone. Also in the db, I see so many types of level 1 skeleton's it makes you understand why loottables and npc_id's should be shared. Although I do think Angelox's system of unique npc_id's for each specific zone is also a good idea to tracking and managing specific zone's mobs. I use both methods.


GeorgeS

[fathernitwit]

PEQ makes all NPCs start with zoneID*1000 (and I hope cavedude did this as well). So it makes finding some things easier. if a npc is in multiple zones, we have multiple copies of the NPC... mainly a side effect of packet collects. Anyhow, this is an established rule and can be used. Unfortunately, we did not make such a rule on any of the other tables... although an ambitious perl/php/python person could write a script to re-number all the loot tables and spawn tables base on some rules, which would make it a lot easier to dump entire zones in the future.

[cavedude]

Yep, I did the same thing with my NPCs. zoneID *1000

[tallerin]

I know that you can pull dumps from cavedudes database and source them into PEQ with out changing things and get no errors. I just spent yesterday and this morning dumping npc_types spawn2 spawn entry and spawngroup from cavedudes DB. Removed all spawns that were already in PEQ from cavedudes DB and sourced them into PEQ DB. Now i have PEQ DB upto luclin and all the other zones after luclin that are in cavedudes DB So best of both DBs combined now. Now just to do faction tables and loot tables for the newly added zones.

If the SQL files that i have dumped from cavedudes DB and weeded out all entries Of luclin and before will help you out let me know i'll find a place to upload them for you. Would make it easier on you then all you have to do is loot tables and faction for the zones.

[Angelox]

Originally Posted by tallerin

I know that you can pull dumps from cavedudes database and source them into PEQ with out changing things and get no errors. I just spent yesterday and this morning dumping npc_types spawn2 spawn entry and spawngroup from cavedudes DB. Removed all spawns that were already in PEQ from cavedudes DB and sourced them into PEQ DB. Now i have PEQ DB upto luclin and all the other zones after luclin that are in cavedudes DB So best of both DBs combined now. Now just to do faction tables and loot tables for the newly added zones.

If the SQL files that i have dumped from cavedudes DB and weeded out all entries Of luclin and before will help you out let me know i'll find a place to upload them for you. Would make it easier on you then all you have to do is loot tables and faction for the zones.

Actually, anything that Cavedude did can be transfered to PEQ, simply because they both use NPCs. zoneID *1000 format (as long as the zone is unpoplated).
I've been "future" thinking about all this, and what you should do , and is what I am doing ; dump whatever zone you know well, finish up what it needs, then post the complete zone. But do it in this manner;
Put zone name and zone id's in everwhere you can, and use high numbers - example:
Dulak's "#an_enraged_soulstealer" is 225248, lootable.name starts with Dulak, Lootable ID is 22521130 , Lootdrop id is 22582050 - all 225's are the zonenumber. When you go to dump the data, you will be fetching only new Dulak data and the new loot data will add on to what cavedude already has in the PEQ database.

[Angelox]

This one should be more complete than the last Gunthark one, as I was able to place ID on everthing I did.

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

Still have Nadox, Torgiran, and Hatesfury to go.

[Angelox]

This zone is different from the other zones I've worked with - There are no named-mob static spawns anywhere in the zone. About half of the named can pop from death of another mob, and the other half spawn off an assortment of mobs in a given area. You need to also install the nadox perl quest scripts included with the download, if you want the "pop from death" named mobs. I think it's pretty close to live, and if you see anything that needs to be fixed, please post it.

you can download it from here;
http://www.nahunta.org/~angelox/index.shtml