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 :-)
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.