Log in

View Full Version : PEQ loot tables


hayward6
09-04-2008, 01:03 PM
I need to get working on loot tables in the zones that haven't been finished in the PEQ database... Has anyone gotten any of it done and willing to share before I get started? I'll be posting them zone by zone if anyone wants them.

Thank you,

AndMetal
09-04-2008, 09:26 PM
I was adding some general drops, with no balancing, for named in Txevu, Tacvi, Riftseekers, Qvic, and Anguish, but didn't get finished. This is what I have so far:

npc_types (http://www.eqemulator.net/wiki/wikka.php?wakka=EQEmuDBSchemanpctypes) (all commented out right now)

-- Txevu
/* High Priest Nkosi Bakari () */
/* Ikaav Nysf Lleiv (296090) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '296090';
/* Ukun Bloodfeaster (296082) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '296082';
/* Zun`Muram Tkarish Zyk (296150) */
# UPDATE npc_types SET loottable_id = '10779' WHERE id = '296150';


-- Tacvi
/* Pixtt Kretv Krakxt (297035) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '297035';
/* Pixtt Riel Tavas (297032) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '297032';
/* Pixtt Xxeric Kex (297039, 297058) */
# UPDATE npc_types SET loottable_id = '' WHERE id IN ('297039', '297058');
/* Tunat`Muram Cuu Vauax (297054) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '297054';
/* Zun`Muram Kvxe Pirik (297029) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '297029';
/* Zun`Muram Mordl Delt (297020, 297050, 297051, 297052, 297053) */
# UPDATE npc_types SET loottable_id = '' WHERE id IN ('297020', '297050', '297051', '297052', '297053');
/* Zun`Muram Shaldn Boc (297018, 297057) */
# UPDATE npc_types SET loottable_id = '' WHERE id IN ('297018', '297057');


-- Riftseekers
/* Chailak (334014) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Craftmaster Tieranu (334087) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Discordling Shardmender (334083) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Feratha (334102) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* King Gelaqua (334041) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Queen Pyrilonis (334049) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';


-- Qvic
/* Cynosure Kvanjji () */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Dvoin M`sha (298087) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Iqthinxa Karnkvi (298130) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Mnat M`sha (298001) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Ptav M`sha (298134) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';


-- Anguish
/* Administrator Charial (317077) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Damlin Lingering Charge (317106) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* First Lieutenant Minas (317078) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Grenlok the Converter (317094) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Keldovan the Harrier (317005) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Overlord Mata Muram (317000) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Ture (317003) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Vilria the Keeper (317105) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Warden Hanvar (317002) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';
/* Jelvan (317004) */
# UPDATE npc_types SET loottable_id = '' WHERE id = '';

loottable (http://www.eqemulator.net/wiki/wikka.php?wakka=EQEmuDBSchemaloottable) (nothing too useful)

-- Txevu
INSERT INTO loottable (id, name) VALUES
/* High Priest Nkosi Bakari () */
(, ''),
/* Ikaav Nysf Lleiv (296090) */
(, ''),
/* Ukun Bloodfeaster (296082) */
(, ''),
/* Zun`Muram Tkarish Zyk (296150) */
/* (10779, ''), */
/* Wand Harness from raid encounters*/
(, ''),
/* Tongue of the Zun'Muram, random drops from Zun's */
(, '');


-- Tacvi
INSERT INTO loottable (id, name) VALUES
/* Pixtt Kretv Krakxt (297035) */
(, ''),
/* Pixtt Riel Tavas (297032) */
(, ''),
/* Pixtt Xxeric Kex (297039, 297058) */
(, ''),
/* Tunat`Muram Cuu Vauax (297054) */
(, ''),
/* Zun`Muram Kvxe Pirik (297029) */
(, ''),
/* Zun`Muram Mordl Delt (297020, 297050, 297051, 297052, 297053) */
(, ''),
/* Zun`Muram Shaldn Boc (297018, 297057) */
(, '');


-- Riftseekers
INSERT INTO loottable (id, name) VALUES
/* Chailak (334014) */
(, ''),
/* Craftmaster Tieranu (334087) */
(, ''),
/* Discordling Shardmender (334083) */
(, ''),
/* Feratha (334102) */
(, ''),
/* King Gelaqua (334041) */
(, ''),
/* Queen Pyrilonis (334049) */
(, '');


-- Qvic
INSERT INTO loottable (id, name) VALUES
/* Cynosure Kvanjji () */
(, ''),
/* Dvoin M`sha (298087) */
(, ''),
/* Iqthinxa Karnkvi (298130) */
(, ''),
/* Mnat M`sha (298001) */
(, ''),
/* Ptav M`sha (298134) */
(, '');


-- Anguish
INSERT INTO loottable (id, name) VALUES
/* Administrator Charial (317077) */
(, ''),
/* Damlin Lingering Charge (317106) */
(, ''),
/* First Lieutenant Minas (317078) */
(, ''),
/* Grenlok the Converter (317094) */
(, ''),
/* Keldovan the Harrier (317005) */
(, ''),
/* Overlord Mata Muram (317000) */
(, ''),
/* Ture (317003) */
(, ''),
/* Vilria the Keeper (317105) */
(, ''),
/* Warden Hanvar (317002) */
(, ''),
/* Jelvan (317004) */
(, '');


loottable_entries (http://www.eqemulator.net/wiki/wikka.php?wakka=EQEmuDBSchemaloottableentries) (not much here either)

-- Txevu
INSERT INTO loottable_entries (loottable_id, lootdrop_id, multiplier, probability) VALUES
/* High Priest Nkosi Bakari () */
(, , , ),
/* Ikaav Nysf Lleiv (296090) */
(, , , ),
/* Ukun Bloodfeaster (296082) */
(, , , ),
/* Zun`Muram Tkarish Zyk (296150) */
(, , , ),
/* Wand Harness from raid encounters*/
(, , , ),
/* Tongue of the Zun'Muram, random drops from Zun's */
(, , , );


-- Tacvi
INSERT INTO loottable_entries (loottable_id, lootdrop_id, multiplier, probability) VALUES
/* Pixtt Kretv Krakxt (297035) */
(, , , ),
/* Pixtt Riel Tavas (297032) */
(, , , ),
/* Pixtt Xxeric Kex (297039, 297058) */
(, , , ),
/* Tunat`Muram Cuu Vauax (297054) */
(, , , ),
/* Zun`Muram Kvxe Pirik (297029) */
(, , , ),
/* Zun`Muram Mordl Delt (297020, 297050, 297051, 297052, 297053) */
(, , , ),
/* Zun`Muram Shaldn Boc (297018, 297057) */
(, , , );


-- Riftseekers
INSERT INTO loottable_entries (loottable_id, lootdrop_id, multiplier, probability) VALUES
/* Chailak (334014) */
(, , , ),
/* Craftmaster Tieranu (334087) */
(, , , ),
/* Discordling Shardmender (334083) */
(, , , ),
/* Feratha (334102) */
(, , , ),
/* King Gelaqua (334041) */
(, , , ),
/* Queen Pyrilonis (334049) */
(, , , );


-- Qvic
INSERT INTO loottable_entries (loottable_id, lootdrop_id, multiplier, probability) VALUES
/* Cynosure Kvanjji () */
(, , , ),
/* Dvoin M`sha (298087) */
(, , , ),
/* Iqthinxa Karnkvi (298130) */
(, , , ),
/* Mnat M`sha (298001) */
(, , , ),
/* Ptav M`sha (298134) */
(, , , );


-- Anguish
INSERT INTO loottable_entries (loottable_id, lootdrop_id, multiplier, probability) VALUES
/* Administrator Charial (317077) */
(, , , ),
/* Damlin Lingering Charge (317106) */
(, , , ),
/* First Lieutenant Minas (317078) */
(, , , ),
/* Grenlok the Converter (317094) */
(, , , ),
/* Keldovan the Harrier (317005) */
(, , , ),
/* Overlord Mata Muram (317000) */
(, , , ),
/* Ture (317003) */
(, , , ),
/* Vilria the Keeper (317105) */
(, , , ),
/* Warden Hanvar (317002) */
(, , , ),
/* Jelvan (317004) */
(, , , );


lootdrop (http://www.eqemulator.net/wiki/wikka.php?wakka=EQEmuDBSchemalootdrop)

-- Txevu
INSERT INTO lootdrop (id, name) VALUES
/* High Priest Nkosi Bakari () */
(30003, 'High Priest Nkosi Bakari'),
(30036, 'Jade Inlaid Key'),
/* Ikaav Nysf Lleiv (296090) */
(30000, 'Ikaav Nysf Lleiv'),
/* Ukun Bloodfeaster (296082) */
(30001, 'Ukun Bloodfeaster'),
/* Zun`Muram Tkarish Zyk (296150) */
(30002, 'Zun`Muram Tkarish Zyk'),
(30034, "Zun'Muram's Signet of Command"),
(30035, 'Shard of Dark Matter'),
/* Wand Harness from raid encounters*/
(30004, 'Wand Harness'),
/* Tongue of the Zun'Muram, random drops from Zun's */
(30005, "Tongue of the Zun'Muram");

-- Tacvi
INSERT INTO lootdrop (id, name) VALUES
/* Pixtt Kretv Krakxt (297035) */
(30006, 'Pixtt Kretv Krakxt'),
/* Pixtt Riel Tavas (297032) */
(30007, 'Pixtt Riel Tavas'),
/* Pixtt Xxeric Kex (297039, 297058) */
(30008, 'Pixtt Xxeric Kex'),
/* Tunat`Muram Cuu Vauax (297054) */
(30009, 'Tunat`Muram Cuu Vauax'),
/* Zun`Muram Kvxe Pirik (297029) */
(30010, 'Zun`Muram Kvxe Pirik'),
/* Zun`Muram Mordl Delt (297020, 297050, 297051, 297052, 297053) */
(30011, 'Zun`Muram Mordl Delt'),
/* Zun`Muram Shaldn Boc (297018, 297057) */
(30012, 'Zun`Muram Shaldn Boc');


-- Riftseekers
INSERT INTO lootdrop (id, name) VALUES
/* Chailak (334014) */
(30013, 'Chailak'),
/* Craftmaster Tieranu (334087) */
(30014, 'Craftmaster Tieranu'),
/* Discordling Shardmender (334083) */
(30015, 'Discordling Shardmender'),
/* Feratha (334102) */
(30016, 'Feratha'),
/* King Gelaqua (334041) */
(30017, 'King Gelaqua'),
/* Queen Pyrilonis (334049) */
(30018, 'Queen Pyrilonis');


-- Qvic
INSERT INTO lootdrop (id, name) VALUES
/* Cynosure Kvanjji () */
(30019, 'Cynosure Kvanjji'),
/* Dvoin M`sha (298087) */
(30020, 'Dvoin M`sha'),
/* Iqthinxa Karnkvi (298130) */
(30021, 'Iqthinxa Karnkvi'),
/* Mnat M`sha (298001) */
(30022, 'Mnat M`sha'),
/* Ptav M`sha (298134) */
(30023, 'Ptav M`sha');


-- Anguish
INSERT INTO lootdrop (id, name) VALUES
/* Administrator Charial (317077) */
(30024, 'Administrator Charial'),
/* Damlin Lingering Charge (317106) */
(30025, 'Damlin Lingering Charge'),
/* First Lieutenant Minas (317078) */
(30026, 'First Lieutenant Minas'),
/* Grenlok the Converter (317094) */
(30027, 'Grenlok the Converter'),
/* Keldovan the Harrier (317005) */
(30028, 'Keldovan the Harrier'),
/* Overlord Mata Muram (317000) */
(30029, 'Overlord Mata Muram'),
/* Ture (317003) */
(30030, 'Ture'),
/* Vilria the Keeper (317105) */
(30031, 'Vilria the Keeper'),
/* Warden Hanvar (317002) */
(30032, 'Warden Hanvar'),
/* Jelvan (317004) */
(30033, 'Jelvan');


lootdrop_entries (http://www.eqemulator.net/wiki/wikka.php?wakka=EQEmuDBSchemalootdropentries)

-- Txevu
INSERT INTO lootdrop_entries (lootdrop_id, item_id, item_charges, equip_item, chance) VALUES
/* Ancient Cragbeast Matriarch (296056) */
(17655, 69071, 1, 0, 100),
(17655, 69077, 1, 0, 100),
(17655, 69046, 1, 0, 100),
(17655, 69088, 1, 0, 100),
(17655, 69154, 1, 0, 100),
(17655, 69073, 1, 0, 100),
(17655, 69086, 1, 0, 100),
/* Aneuk Nyrt Ymosa (296025) */
(19330, 69097, 1, 0, 100),
(19330, 69096, 1, 0, 100),
(19330, 68226, 1, 0, 100),
(19330, 69093, 1, 0, 100),
/* Aneuk Rilst Uskst (296023) */
(17558, 69097, 1, 0, 100),
(17558, 69096, 1, 0, 100),
(17558, 69098, 1, 0, 100),
(17558, 68225, 1, 0, 100),
/* High Priest Nkosi Bakari () */
(30003, 69050, 1, 0, 100),
(30003, 69054, 1, 0, 100),
(30003, 69049, 1, 0, 100),
(30003, 69047, 1, 0, 100),
(30003, 69055, 1, 0, 100),
(30003, 69045, 1, 0, 100),
(30003, 69074, 1, 0, 100),
(30003, 69060, 1, 0, 100),
(30003, 69057, 1, 0, 100),
(30003, 69042, 1, 0, 100),
/* Jade Inlaid Key */
(30036, 17288, 1, 0, 100),
/* Ikaav Nysf Lleiv (296090) */
(30000, 69080, 1, 0, 100),
(30000, 69091, 1, 0, 100),
(30000, 69087, 1, 0, 100),
(30000, 69062, 1, 0, 100),
(30000, 69056, 1, 0, 100),
(30000, 69078, 1, 0, 100),
(30000, 69044, 1, 0, 100),
(30000, 69085, 1, 0, 100),
/* Ukun Bloodfeaster (296082) */
(30001, 69083, 1, 0, 100),
(30001, 69072, 1, 0, 100),
(30001, 69068, 1, 0, 100),
(30001, 69041, 1, 0, 100),
(30001, 69090, 1, 0, 100),
(30001, 69081, 1, 0, 100),
(30001, 69076, 1, 0, 100),
/* Zun`Muram Tkarish Zyk (296150) */
(30002, 69048, 1, 0, 100),
(30002, 69070, 1, 0, 100),
(30002, 69051, 1, 0, 100),
(30002, 69065, 1, 0, 100),
(30002, 69040, 1, 0, 100),
(30002, 69061, 1, 0, 100),
(30002, 69106, 1, 0, 100),
(30002, 69064, 1, 0, 100),
(30002, 69053, 1, 0, 100),
(30002, 69100, 1, 0, 100),
(30002, 69066, 1, 0, 100),
(30002, 69052, 1, 0, 100),
(30002, 69099, 1, 0, 100),
/* Zun'Muram's Signet of Command */
(30034, 64034, 1, 0, 100),
/* Shard of Dark Matter */
(30035, 67564, 1, 0, 100),
/* Wand Harness from raid encounters*/
(30004, 52450, 1, 0, 100),
/* Tongue of the Zun'Muram, random drops from Zun's */
(30005, 67592, 1, 0, 25);

/* Looks like this doesn't work anymore
UPDATE lootdrop_entries SET chance = (100 / (SELECT COUNT(item_id) FROM lootdrop_entries WHERE lootdrop_id = '17655' )) WHERE lootdrop_id = '17655';
UPDATE lootdrop_entries SET chance = (100 / (SELECT COUNT(item_id) FROM lootdrop_entries WHERE lootdrop_id = '19330' )) WHERE lootdrop_id = '19330';
UPDATE lootdrop_entries SET chance = (100 / (SELECT COUNT(item_id) FROM lootdrop_entries WHERE lootdrop_id = '17558' )) WHERE lootdrop_id = '17558';
UPDATE lootdrop_entries SET chance = (100 / (SELECT COUNT(item_id) FROM lootdrop_entries WHERE lootdrop_id = '30003' )) WHERE lootdrop_id = '30003';
UPDATE lootdrop_entries SET chance = (100 / (SELECT COUNT(item_id) FROM lootdrop_entries WHERE lootdrop_id = '30000' )) WHERE lootdrop_id = '30000';
UPDATE lootdrop_entries SET chance = (100 / (SELECT COUNT(item_id) FROM lootdrop_entries WHERE lootdrop_id = '30001' )) WHERE lootdrop_id = '30001';
*/


-- Tacvi
INSERT INTO lootdrop_entries (lootdrop_id, item_id, item_charges, equip_item, chance) VALUES
/* Pixtt Kretv Krakxt (297035) */
/* Pixtt Riel Tavas (297032) */
/* Pixtt Xxeric Kex (297039, 297058) */
/* Tunat`Muram Cuu Vauax (297054) */
/* Zun`Muram Kvxe Pirik (297029) */
/* Zun`Muram Mordl Delt (297020, 297050, 297051, 297052, 297053) */
/* Zun`Muram Shaldn Boc (297018, 297057) */
/* Zun`Muram Yihst Vor (297023) */
(19620, 69178, 1, 0, 100),
(19620, 69123, 1, 0, 100),
(19620, 69113, 1, 0, 100),
(19620, 69115, 1, 0, 100),
(19620, 69254, 1, 0, 100),
(19620, 69135, 1, 0, 100),
(19620, 69114, 1, 0, 100),
(19620, 69132, 1, 0, 100);

UPDATE lootdrop_entries SET chance = (100 / (SELECT COUNT(item_id) FROM lootdrop_entries WHERE lootdrop_id = '19620' )) WHERE lootdrop_id = '19620';


-- Riftseekers
# INSERT INTO lootdrop_entries (lootdrop_id, item_id, item_charges, equip_item, chance) VALUES
/* Chailak (334014) */
/* Craftmaster Tieranu (334087) */
/* Discordling Shardmender (334083) */
/* Feratha (334102) */
/* King Gelaqua (334041) */
/* Queen Pyrilonis (334049) */


-- Qvic
# INSERT INTO lootdrop_entries (lootdrop_id, item_id, item_charges, equip_item, chance) VALUES
/* Cynosure Kvanjji () */
/* Dvoin M`sha (298087) */
/* Iqthinxa Karnkvi (298130) */
/* Mnat M`sha (298001) */
/* Ptav M`sha (298134) */


-- Anguish
# INSERT INTO lootdrop_entries (lootdrop_id, item_id, item_charges, equip_item, chance) VALUES
/* Administrator Charial (317077) */
/* Damlin Lingering Charge (317106) */
/* First Lieutenant Minas (317078) */
/* Grenlok the Converter (317094) */
/* Keldovan the Harrier (317005) */
/* Overlord Mata Muram (317000) */
/* Ture (317003) */
/* Vilria the Keeper (317105) */
/* Warden Hanvar (317002) */
/* Jelvan (317004) */


And here's the base info I was using that a user on my forums, Cptlanier, put together for me:
Anguish (http://docs.google.com/Doc?id=dgds5nf2_12c5dr67dn)
Qvic (http://docs.google.com/Doc?id=dgds5nf2_11drcd59ck)
Riftseeker's (http://docs.google.com/Doc?id=dgds5nf2_10ftf94gcc)
Tacvi (http://docs.google.com/Doc?id=dgds5nf2_9gbch93cs)
Txevu (http://docs.google.com/Doc?id=dgds5nf2_8hbxt2mdx)

Hopefully someone can use this to pick up where I left off :-)

Andrew80k
09-04-2008, 11:29 PM
You could probably mine Allah's for all this info if you were really serious about getting this all in there. I've considered it myself since I've mined it for stuff before. Unfortunately, I'd have to rewrite the code since it got lost in a hard-drive crash about a year ago. I might look into it and see what I can come up with.

hayward6
09-05-2008, 08:08 AM
You could probably mine Allah's for all this info if you were really serious about getting this all in there. I've considered it myself since I've mined it for stuff before. Unfortunately, I'd have to rewrite the code since it got lost in a hard-drive crash about a year ago. I might look into it and see what I can come up with.

Thats my plan, but it looks like much of it is missing on that site as well. Either that or stuff is blocked if you don't have a premium account.

Angelox
09-05-2008, 08:27 AM
Thats my plan, but it looks like much of it is missing on that site as well. Either that or stuff is blocked if you don't have a premium account.

There's most of what you need in the site, but if you search the wrong way, you get the 'premium-only' messages
start here;
http://eqbeastiary.allakhazam.com/zonelist.html

then choose the zone an mob , you shouldn't get blocked. same goes with quests an all. They have a mild way of getting you to pay, but at the end, you can get access.

I don't know if you noticed, but some of the PEQ zones in Omens are 'overspawned' and need pruning. I have a few Omens zones I built, with named, loots and all, only needs to be ported over to PEQ.
The over spawned zones are not so in what I have.

hayward6
09-05-2008, 11:23 AM
How's the process to move it to PEQ? I have to say, I have always liked your database more than PEQ... but the added complexity, and the fact that it doesn't meld well with what most people are using makes it difficult to adapt to. It's hands down more complete and accurate, you can see that in just the simple size of the database... but few have adopted it.

There's most of what you need in the site, but if you search the wrong way, you get the 'premium-only' messages
start here;
http://eqbeastiary.allakhazam.com/zonelist.html

then choose the zone an mob , you shouldn't get blocked. same goes with quests an all. They have a mild way of getting you to pay, but at the end, you can get access.

I don't know if you noticed, but some of the PEQ zones in Omens are 'overspawned' and need pruning. I have a few Omens zones I built, with named, loots and all, only needs to be ported over to PEQ.
The over spawned zones are not so in what I have.

cavedude
09-05-2008, 12:27 PM
Yeah, anything past GoD is way over grown because they were populated with several logs. It's much easier to destroy than to create is the theory behind that. Some of the GoD zones too, but most of them are cleaned up on my local copy of the DB. The Elementals are done enough that aside from finishing off the hell that is potimeb (EVERY NPC in that zone is scripted), I have begun privately working on GoD so I can put zones up and let the PEQ team sink their teeth in.

LDoN needs to be skipped obviously. Without instancing, some zones in GoD/OoW will be problematic as well (Yes, Perl can be used to instance but I do not want to do that), so it looks like GoD and OoW will be done at the same time so at least combined we'll be getting a whole new expansion. I didn't want to make any official statement until after the PoP/LoY final was released, but there is no harm in doing so now. After the scripting that went in PoP, both expansions will be cake. PEQ currently has almost 80% of the quests up to LoY complete, with many of the GoD quests in, and the only real quests OoW offer are the new epics. So we could quickly find ourselves in very good shape. The scary bit is after OoW we only have DoN and DoD and then we're done with what our client can support.

It would be cool if we all started working together, as it seems we all have similar goals at this point. Really, PEQ is open game for anything OoW and below at this point.

Angelox
09-05-2008, 01:37 PM
There are a few zones (Omens) that were properly spawned before they got replaced, and is what I used - If we could bring all those back, I would have a good start for you (may not be perfect, but I think a lot easier). I had given up on Omens and PEQ, since it seemed the players there did not want it, and the older policy was there would be no Omens.
What I had originally done was start at Bloodfields (starting point), and work my way out.
I really don't think Omens was that big of a deal, or any 'super-loots' were available, but then again, I never raided so I don't know that aspect. What was a lot of fun was things like camping the Auguments, then converting them Via skill crafts to something better. Also the way things dropped there was pretty cool to.
Cavedude, if you want what I have, I'll port it over for you- have everyone else hold on a few days tell I get it all ported, then they can take it from there.

hayward6
09-05-2008, 02:00 PM
This is awesome! I'll hang on and see what you two can cook up, since my stumbling around would only get me into trouble anyways. If there's anything I can do to help, please let me know. I can try and get some data from live by going to these zones if that would help.

What I have seen so far in data mining at ahlakazam is that they don't do much loot listing, and with my inexperience with adding it, I don't think I would do it justice for chances anyways.

Angelox
09-08-2008, 09:55 AM
Well, I guess i did more than I thought I did to PEQ and Omens zones - I must be a candidate for Alzheimer's, as I can clearly remember everything i did when I was young, but recent suff, just blows away and gets fragmented.
Anyways, everything I had is already added to the zones, and I will send some quests to Cavedude that will enable travel to those zones, and I think I have one or two more someone made for me.
Here's an outline of what I did
harbingers was my first, I played/camped in there so much, I had the place wired. alls that what was needed there seemed to be the spells, and i fixed them up this morning.
draniksscar pretty much detailed with drops, named etc.
bloodfields playable also with drops (don't remember how much I did).
causeway same as bloodfields.
Cavedude, you can probably start with the above four zones, I think they are playable - we must have already ported everything there.
The rest are spawned, have aggro, gridwork, but need much work in loots, and what not.

I had made some very detailed lists of tradeskill drops there which later on I renamed and used all around other Omens zones;
'flow stones'(mudflow stones, starflow stones, waterflow stones, etc, I think drop throughout Omens, but I only added them to where I was sure. here's a few more that i can remember;
slugworms (vital for shamans working on flowstones)
Magnetized gear (used for making some real nice armor)

Here's the 'big picture' on what I understand drops work in Omens; named mobs always drop something; they have a rare drop and a common drop ( i set rare to 10% and common to 90%, and that's debatable) there is also a third set of ultra rare drop (3%?) that is zone wide among all the named.
for example Harbingers is
Cloak of Discordling Skin
Sash of Discordling Flesh
Bracer of the Beaconguard
I camped there for months and managed to land one: Sash of Discordling Flesh
now people will argue over who drops what ultra rare, but this is the way I think it works.
then there are things like slugworms (ultra rare), 'flows tones (pretty rare), that can drop anywhere in a number (if not all) Omens zones.

I would suggest you all start with the first four zones, there still are details that need ironing out; In Harbingers, theres a quest at the top of the spire that involves raiding, and a few more. all the others I'm sure could use more details.
What I did was start at Draniksscar and work my way out (Draniksscar is the entry point to Omens), you probably should do the same ( that way you will have 'attached zones' players can zone into).

Also, if you want to make 'official stuff' for PEQ, you need to stay in touch with Cavedude, things like the ids and numbers in PEQ DB change all the time.
PEQ is a team effort , so you can't cross with other peoples work.
You should present Cavedude with an 'sql update' of what you have to add.
I used GeorgeS Sql Browser (and wordpad, and kwrite!) for most every 'sql update' I made for Cavedude - I like it because it is simple and straight-forward.
Also the 'Peq Database Editor' makes a log that has Sqls of work you have done. You can give those to Cavedude

Angelox
09-08-2008, 11:01 AM
^Add to above^

Actually, it's omens-wide Dragorns that drop Magnetized and 'Flow stones - slugworms can be any npc.