Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2019, 11:31 AM
Huppy's Avatar
Huppy
Dragon
 
Join Date: Oct 2010
Location: Canada
Posts: 845
Default Spell Merchant lastnames

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;
__________________

Discord - https://discord.gg/R34jK6h
Reply With Quote
  #2  
Old 09-08-2019, 12:14 PM
Dhaymion
Fire Beetle
 
Join Date: Apr 2018
Location: NC
Posts: 5
Default

Very handy! Thank you for sharing!
Reply With Quote
  #3  
Old 09-08-2019, 12:55 PM
Huppy's Avatar
Huppy
Dragon
 
Join Date: Oct 2010
Location: Canada
Posts: 845
Default

Quote:
Originally Posted by Dhaymion View Post
Very handy! Thank you for sharing!
That's what I thought too, lol It makes it easier on the "find" list as well.
__________________

Discord - https://discord.gg/R34jK6h
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:52 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3