Spell Merchant lastnames

Huppy · #1 09-08-2019, 11:31 AM

For anyone who is using the spell merchants in PoK with recent/current PEQ database, the following query will update the lastnames to show the merchant spell levels in their lastnames, as it was on EQ live at some point or another in the past. (Not sure if live still does that.)
CAUTION: This is based on NPC ID's in the current PEQ database, (as of Sept/2019). If you are using an old/custom database, compare the ID's of the merchants before running this query. (I have an older db myself and ID's have changed since then).

Code:

UPDATE `npc_types` SET `lastname` = 'Wizard Spells 1-25' WHERE `id` = 202174;
UPDATE `npc_types` SET `lastname` = 'Wizard Spells 71-80' WHERE `id` = 202175;
UPDATE `npc_types` SET `lastname` = 'Wizard Spells 61-70' WHERE `id` = 202176;
UPDATE `npc_types` SET `lastname` = 'Wizard Spells 51-60' WHERE `id` = 202177;
UPDATE `npc_types` SET `lastname` = 'Wizard Spells 26-50' WHERE `id` = 202178;

UPDATE `npc_types` SET `lastname` = 'Shaman Spells 1-25' WHERE `id` = 202179;
UPDATE `npc_types` SET `lastname` = 'Shaman Spells 71-80' WHERE `id` = 202180;
UPDATE `npc_types` SET `lastname` = 'Shaman Spells 61-70' WHERE `id` = 202181;
UPDATE `npc_types` SET `lastname` = 'Shaman Spells 51-60' WHERE `id` = 202182;
UPDATE `npc_types` SET `lastname` = 'Shaman Spells 26-50' WHERE `id` = 202183;

UPDATE `npc_types` SET `lastname` = 'Shadow Knight Spells 1-25' WHERE `id` = 202184;
UPDATE `npc_types` SET `lastname` = 'Shadow Knight Spells 71-80' WHERE `id` = 202185;
UPDATE `npc_types` SET `lastname` = 'Shadow Knight Spells 61-70' WHERE `id` = 202186;
UPDATE `npc_types` SET `lastname` = 'Shadow Knight Spells 51-60' WHERE `id` = 202187;
UPDATE `npc_types` SET `lastname` = 'Shadow Knight Spells 26-50' WHERE `id` = 202188;

UPDATE `npc_types` SET `lastname` = 'Ranger Spells 1-25' WHERE `id` = 202189;
UPDATE `npc_types` SET `lastname` = 'Ranger Spells 71-80' WHERE `id` = 202190;
UPDATE `npc_types` SET `lastname` = 'Ranger Spells 61-70' WHERE `id` = 202191;
UPDATE `npc_types` SET `lastname` = 'Ranger Spells 51-60' WHERE `id` = 202192;
UPDATE `npc_types` SET `lastname` = 'Ranger Spells 26-50' WHERE `id` = 202193;

UPDATE `npc_types` SET `lastname` = 'Paladin Spells 1-25' WHERE `id` = 202194;
UPDATE `npc_types` SET `lastname` = 'Paladin Spells 71-80' WHERE `id` = 202195;
UPDATE `npc_types` SET `lastname` = 'Paladin Spells 61-70' WHERE `id` = 202196;
UPDATE `npc_types` SET `lastname` = 'Paladin Spells 51-60' WHERE `id` = 202197;
UPDATE `npc_types` SET `lastname` = 'Paladin Spells 26-50' WHERE `id` = 202198;

UPDATE `npc_types` SET `lastname` = 'Necromancer Spells 1-25' WHERE `id` = 202199;
UPDATE `npc_types` SET `lastname` = 'Necromancer Spells 71-80' WHERE `id` = 202200;
UPDATE `npc_types` SET `lastname` = 'Necromancer Spells 61-70' WHERE `id` = 202201;
UPDATE `npc_types` SET `lastname` = 'Necromancer Spells 51-60' WHERE `id` = 202202;
UPDATE `npc_types` SET `lastname` = 'Necromancer Spells 26-50' WHERE `id` = 202203;

UPDATE `npc_types` SET `lastname` = 'Magician Spells 1-25' WHERE `id` = 202204;
UPDATE `npc_types` SET `lastname` = 'Magician Spells 71-80' WHERE `id` = 202205;
UPDATE `npc_types` SET `lastname` = 'Magician Spells 61-70' WHERE `id` = 202206;
UPDATE `npc_types` SET `lastname` = 'Magician Spells 51-60' WHERE `id` = 202207;
UPDATE `npc_types` SET `lastname` = 'Magician Spells 26-50' WHERE `id` = 202208;

UPDATE `npc_types` SET `lastname` = 'Enchanter Spells 1-25' WHERE `id` = 202209;
UPDATE `npc_types` SET `lastname` = 'Enchanter Spells 71-80' WHERE `id` = 202210;
UPDATE `npc_types` SET `lastname` = 'Enchanter Spells 61-70' WHERE `id` = 202211;
UPDATE `npc_types` SET `lastname` = 'Enchanter Spells 51-60' WHERE `id` = 202212;
UPDATE `npc_types` SET `lastname` = 'Enchanter Spells 26-50' WHERE `id` = 202213;

UPDATE `npc_types` SET `lastname` = 'Druid Spells 1-25' WHERE `id` = 202214;
UPDATE `npc_types` SET `lastname` = 'Druid Spells 71-80' WHERE `id` = 202215;
UPDATE `npc_types` SET `lastname` = 'Druid Spells 61-70' WHERE `id` = 202216;
UPDATE `npc_types` SET `lastname` = 'Druid Spells 51-60' WHERE `id` = 202217;
UPDATE `npc_types` SET `lastname` = 'Druid Spells 26-50' WHERE `id` = 202218;

UPDATE `npc_types` SET `lastname` = 'Cleric Spells 1-25' WHERE `id` = 202219;
UPDATE `npc_types` SET `lastname` = 'Cleric Spells 71-80' WHERE `id` = 202220;
UPDATE `npc_types` SET `lastname` = 'Cleric Spells 61-70' WHERE `id` = 202221;
UPDATE `npc_types` SET `lastname` = 'Cleric Spells 51-60' WHERE `id` = 202222;
UPDATE `npc_types` SET `lastname` = 'Cleric Spells 26-50' WHERE `id` = 202223;

UPDATE `npc_types` SET `lastname` = 'Beastlord Spells 1-25' WHERE `id` = 202224;
UPDATE `npc_types` SET `lastname` = 'Beastlord Spells 71-80' WHERE `id` = 202225;
UPDATE `npc_types` SET `lastname` = 'Beastlord Spells 61-70' WHERE `id` = 202226;
UPDATE `npc_types` SET `lastname` = 'Beastlord Spells 51-60' WHERE `id` = 202227;
UPDATE `npc_types` SET `lastname` = 'Beastlord Spells 26-50' WHERE `id` = 202228;

UPDATE `npc_types` SET `lastname` = 'Bard Songs 1-25' WHERE `id` = 202229;
UPDATE `npc_types` SET `lastname` = 'Bard Songs 71-80' WHERE `id` = 202230;
UPDATE `npc_types` SET `lastname` = 'Bard Songs 61-70' WHERE `id` = 202231;
UPDATE `npc_types` SET `lastname` = 'Bard Songs 51-60' WHERE `id` = 202232;
UPDATE `npc_types` SET `lastname` = 'Bard Songs 26-50' WHERE `id` = 202233;

Dhaymion · #2 09-08-2019, 12:14 PM

Very handy! Thank you for sharing!

Huppy · #3 09-08-2019, 12:55 PM

Quote:

Originally Posted by Dhaymion

Very handy! Thank you for sharing!

That's what I thought too, lol It makes it easier on the "find" list as well.