# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Tribute Mast'
UPDATE npc_types SET lastname = 'Tribute Master', class = 63 WHERE id in ( 40005,60010,2039,98029,155094,49031,55055,10035,54079,54080,45053,40006,1036,61016,29009,8017,75112,8018,19036 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Beastlord Guildmast'
UPDATE npc_types SET lastname = 'Beastlord Guildmaster', class = 34 WHERE id in ( 40025,155073,155168,29018,49048 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Beastlord Spe'
UPDATE npc_types SET lastname = 'Beastlord Spells', merchant_id = 5151 WHERE id = 49086;
UPDATE npc_types SET lastname = 'Beastlord Spells', merchant_id = 5151 WHERE id = 29081;
UPDATE npc_types SET lastname = 'Beastlord Spells', merchant_id = 5152 WHERE id = 40018;
UPDATE npc_types SET lastname = 'Beastlord Spells', merchant_id = 5151 WHERE id = 49079;
UPDATE npc_types SET lastname = 'Beastlord Spells', merchant_id = 5151 WHERE id = 155240;
UPDATE npc_types SET lastname = 'Beastlord Spells', merchant_id = 5151 WHERE id = 40017;
UPDATE npc_types SET lastname = 'Beastlord Spells', merchant_id = 5151 WHERE id = 29075;
UPDATE npc_types SET lastname = 'Beastlord Spells', merchant_id = 5151 WHERE id = 155184;
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Cleric Guildmast'
UPDATE npc_types SET lastname = 'Cleric Guildmaster', class = 21 WHERE id in ( 98049,8029,2082,19079,1055,10096,8045,75072,75016,19067,67024,98046,75070,98048,10095,2080,55056,10097,55179,55178,61019,67022,75071,19069,45090,8035,1085,8034,45087,98045,67005,42044,19068,1135,98044,8044,98079,19111,42083,45089,8031,8030,98061,45088,2081,67023,8005,2069,1076,8046,67021,10098,98050,42045,42084,55161 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Cleric Spe'
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 2034;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 8010;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 2043;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 1050;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 2037;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 75067;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 98022;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 45060;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 55017;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 67014;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 19029;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 42031;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 8014;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 8015;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 67013;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 42030;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 61012;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 75068;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 98026;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 19026;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 55023;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 45056;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 2036;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 98028;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 45058;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 45057;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 2035;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 55018;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 61015;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 19031;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 67010;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 55031;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 67011;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 75066;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 55028;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 67012;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 55022;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 19032;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 98025;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 55032;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 61011;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 8011;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 45059;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 2038;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 19030;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 61013;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 42035;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5023 WHERE id = 67009;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 98027;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 55033;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 98023;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 55030;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 55019;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 19028;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 61010;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 42036;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 8016;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 2044;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 42034;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 55029;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 75069;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 67015;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 42032;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 98024;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 19027;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5021 WHERE id = 55020;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5024 WHERE id = 55021;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 8013;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 42033;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 8012;
UPDATE npc_types SET lastname = 'Cleric Spells', merchant_id = 5022 WHERE id = 61014;
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Enchanter Guildmast'
UPDATE npc_types SET lastname = 'Enchanter Guildmaster', class = 33 WHERE id in ( 24071,1065,10121,24032,41030,9103,62036,9041,55168,24031,1067,24072,55158,9042,55169,41049,9040,1038,41052,1066,41029,62020,1068,45083 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Enchanter Spe'
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5143 WHERE id = 41019;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5141 WHERE id = 62001;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5141 WHERE id = 62002;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5142 WHERE id = 55043;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5143 WHERE id = 1031;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5143 WHERE id = 55041;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5144 WHERE id = 98019;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5144 WHERE id = 55039;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5144 WHERE id = 1032;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5143 WHERE id = 24013;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5141 WHERE id = 62022;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5142 WHERE id = 24010;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5143 WHERE id = 9021;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5142 WHERE id = 9018;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5143 WHERE id = 42018;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5143 WHERE id = 1030;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5142 WHERE id = 24008;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5144 WHERE id = 9019;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5141 WHERE id = 1047;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5144 WHERE id = 24012;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5142 WHERE id = 41017;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5144 WHERE id = 55042;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5143 WHERE id = 9022;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5144 WHERE id = 62005;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5143 WHERE id = 24011;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5142 WHERE id = 24009;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5144 WHERE id = 9020;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5143 WHERE id = 41016;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5141 WHERE id = 62003;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5142 WHERE id = 9023;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5141 WHERE id = 55040;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5142 WHERE id = 1034;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5142 WHERE id = 41020;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5143 WHERE id = 62006;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5143 WHERE id = 62004;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5142 WHERE id = 41018;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5141 WHERE id = 55044;
UPDATE npc_types SET lastname = 'Enchanter Spells', merchant_id = 5141 WHERE id = 1033;
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Magician Guildmast'
UPDATE npc_types SET lastname = 'Magician Guildmaster', class = 32 WHERE id in ( 9050,55171,10122,55170,9104,55160,1069,55094,1130,62021,24035,9051,9049,24074,1070,45084,41051,24073,1071,41055,41054,24036,41028 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Magician Spe'
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5131 WHERE id = 98012;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5134 WHERE id = 62015;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5134 WHERE id = 1026;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5133 WHERE id = 62013;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5131 WHERE id = 62011;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5132 WHERE id = 41013;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5131 WHERE id = 24007;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5133 WHERE id = 1027;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5131 WHERE id = 55050;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5134 WHERE id = 55045;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5131 WHERE id = 24003;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5134 WHERE id = 9016;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5132 WHERE id = 41011;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5132 WHERE id = 41012;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5132 WHERE id = 62012;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5134 WHERE id = 55049;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5131 WHERE id = 41015;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5131 WHERE id = 24006;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5132 WHERE id = 24004;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5132 WHERE id = 1028;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5134 WHERE id = 9013;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5132 WHERE id = 41014;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5133 WHERE id = 9014;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5132 WHERE id = 62014;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5134 WHERE id = 9017;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5132 WHERE id = 24005;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5134 WHERE id = 55046;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5133 WHERE id = 55048;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5132 WHERE id = 9015;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5132 WHERE id = 1025;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5133 WHERE id = 1048;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5134 WHERE id = 55047;
UPDATE npc_types SET lastname = 'Magician Spells', merchant_id = 5132 WHERE id = 1029;
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Monk Guildmast'
UPDATE npc_types SET lastname = 'Monk Guildmaster', class = 26 WHERE id in ( 2066,9058,9038,9057,2079,2068,2078,9059 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Monk Spe'
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Necromancer Guildmast'
UPDATE npc_types SET lastname = 'Necromancer Guildmaster', class = 30 WHERE id in ( 55162,42064,75089,10125,10094,42042,42066,45067,45091,42065,10093,10091,10092,75090,45065,55163,75015,45066,75091 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Necromancer Spe'
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5114 WHERE id = 42027;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5111 WHERE id = 55037;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5111 WHERE id = 75085;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5111 WHERE id = 55036;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5112 WHERE id = 75086;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5111 WHERE id = 45049;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5111 WHERE id = 75084;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5112 WHERE id = 55035;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5111 WHERE id = 55185;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5114 WHERE id = 55038;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5112 WHERE id = 45078;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5111 WHERE id = 55034;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5114 WHERE id = 42026;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5111 WHERE id = 75087;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5111 WHERE id = 45051;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5111 WHERE id = 75088;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5112 WHERE id = 45052;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5111 WHERE id = 42028;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5111 WHERE id = 42029;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5114 WHERE id = 45050;
UPDATE npc_types SET lastname = 'Necromancer Spells', merchant_id = 5114 WHERE id = 42025;
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Paladin Guildmast'
UPDATE npc_types SET lastname = 'Paladin Guildmaster', class = 22 WHERE id in ( 98052,2033,8004,67004,67027,98053,8027,1018,1053,8074,8036,67028,8028,61020,98063,55187,98051,8025,1136,8026,2085,98043,67026,2048,67029,1052,2049,2094,98041,2032,98062,8075,98042,19049,1054,61018,8073 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Paladin Spe'
UPDATE npc_types SET lastname = 'Paladin Spells', merchant_id = 5032 WHERE id = 8009;
UPDATE npc_types SET lastname = 'Paladin Spells', merchant_id = 5032 WHERE id = 1020;
UPDATE npc_types SET lastname = 'Paladin Spells', merchant_id = 5031 WHERE id = 1021;
UPDATE npc_types SET lastname = 'Paladin Spells', merchant_id = 5032 WHERE id = 8008;
UPDATE npc_types SET lastname = 'Paladin Spells', merchant_id = 5031 WHERE id = 67007;
UPDATE npc_types SET lastname = 'Paladin Spells', merchant_id = 5031 WHERE id = 98021;
UPDATE npc_types SET lastname = 'Paladin Spells', merchant_id = 5031 WHERE id = 98020;
UPDATE npc_types SET lastname = 'Paladin Spells', merchant_id = 5031 WHERE id = 67008;
UPDATE npc_types SET lastname = 'Paladin Spells', merchant_id = 5032 WHERE id = 98018;
UPDATE npc_types SET lastname = 'Paladin Spells', merchant_id = 5032 WHERE id = 1051;
UPDATE npc_types SET lastname = 'Paladin Spells', merchant_id = 5032 WHERE id = 61008;
UPDATE npc_types SET lastname = 'Paladin Spells', merchant_id = 5031 WHERE id = 61009;
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Rouge Guildmast'
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Rouge Spe'
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Shadow Knight Guildmast'
UPDATE npc_types SET lastname = 'Shadow Knight Guildmaster', class = 24 WHERE id in ( 49034,75110,10102,42068,49032,45070,75109,49033,75111,10099,45069,55186,10100,49035,45092,42069,40023,45068,42067,42043,10101 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Shadow Knight Spe'
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5052 WHERE id = 42023;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5051 WHERE id = 75108;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5051 WHERE id = 42024;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5052 WHERE id = 45080;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5051 WHERE id = 10028;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5052 WHERE id = 75106;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5052 WHERE id = 10029;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5051 WHERE id = 40016;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5051 WHERE id = 49023;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5052 WHERE id = 49022;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5052 WHERE id = 49024;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5052 WHERE id = 75107;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5052 WHERE id = 45079;
UPDATE npc_types SET lastname = 'Shadow Knight Spells', merchant_id = 5051 WHERE id = 40015;
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Shaman Guildmast'
UPDATE npc_types SET lastname = 'Shaman Guildmaster', class = 29 WHERE id in ( 40026,29059,49036,49039,49037,49038,29058,29025,155167,29060,155077 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Shaman Spe'
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5101 WHERE id = 29004;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5101 WHERE id = 155188;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5103 WHERE id = 29008;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5102 WHERE id = 155189;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5101 WHERE id = 155098;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5101 WHERE id = 29005;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5104 WHERE id = 29003;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5102 WHERE id = 155190;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5104 WHERE id = 29006;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5101 WHERE id = 40021;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5101 WHERE id = 155248;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5101 WHERE id = 40020;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5102 WHERE id = 29007;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5104 WHERE id = 155186;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5104 WHERE id = 49028;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5101 WHERE id = 49025;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5103 WHERE id = 49030;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5103 WHERE id = 155185;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5101 WHERE id = 49029;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5101 WHERE id = 155187;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5102 WHERE id = 49026;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5102 WHERE id = 49027;
UPDATE npc_types SET lastname = 'Shaman Spells', merchant_id = 5102 WHERE id = 40019;
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Warrior Guildmast'
UPDATE npc_types SET lastname = 'Warrior Guildmaster', class = 20 WHERE id in ( 19060,9065,45081,41066,49040,9105,1138,2008,55172,9070,2096,60005,1072,29057,19062,60006,41065,9074,55155,49042,60009,9106,29026,54122,55157,10119,1077,60008,49043,1144,1098,19059,29056,19061,54089,54102,54103,55154,41032,60007,9068,9101,55173,9083,49041,1073,155170,41031,9066,41083,60003,29055,40024 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Warrior Spe'
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Wizard Guildmast'
UPDATE npc_types SET lastname = 'Wizard Guildmaster', class = 31 WHERE id in ( 9036,41026,55156,41050,24040,9045,10120,1063,24039,24070,55166,41027,55167,9044,24069,1064,55024,41053,62019,1062,9046,1129,45082 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Wizard Spe'
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5121 WHERE id = 24001;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5121 WHERE id = 62009;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5121 WHERE id = 9012;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5121 WHERE id = 24000;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5122 WHERE id = 42021;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5123 WHERE id = 98013;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5122 WHERE id = 1022;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5122 WHERE id = 55052;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5123 WHERE id = 1023;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5123 WHERE id = 41010;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5122 WHERE id = 42020;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5122 WHERE id = 55051;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5121 WHERE id = 98016;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5123 WHERE id = 98015;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5123 WHERE id = 24002;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5123 WHERE id = 62010;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5124 WHERE id = 41005;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5121 WHERE id = 62007;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5121 WHERE id = 9011;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5123 WHERE id = 9010;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5124 WHERE id = 41008;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5121 WHERE id = 42022;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5124 WHERE id = 55053;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5121 WHERE id = 1024;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5124 WHERE id = 41009;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5123 WHERE id = 98014;
UPDATE npc_types SET lastname = 'Wizard Spells', merchant_id = 5123 WHERE id = 62008;
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Belious_Naliedin' OR npc_types.name rlike 'Caskin_Marsheart' OR npc_types.name rlike 'Caskin_Marsheart' OR npc_types.name rlike 'Joffrey_Clay' OR npc_types.name rlike 'Jusean_Evanesque' OR npc_types.name rlike 'Marus_Kemson' OR npc_types.name rlike 'Nashia_Lanseb' OR npc_types.name rlike 'Sollari_Bekines' OR npc_types.name rlike 'Sten_Harnak' OR npc_types.name rlike 'Sylia_Windlehands'
UPDATE npc_types SET lastname = 'Bard Guildmaster', class = 27 WHERE id in ( 8064,54088,1058,8066,1059,8065,8023,1131,1133 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Briana_Treewhisper' OR npc_types.name rlike 'Gerael_Woodone' OR npc_types.name rlike 'Heartwood_Master' OR npc_types.name rlike 'Hibbs_Rootenpaw' OR npc_types.name rlike 'Reebo_Leafsway' OR npc_types.name rlike 'Salmekia_Treherth' OR npc_types.name rlike 'Te`Anara' OR npc_types.name rlike 'Uner_Gnarltrunk' OR npc_types.name rlike 'Vesteri_Nomanoi'
UPDATE npc_types SET lastname = 'Druid Guildmaster', class = 25 WHERE id in ( 19056,19057,13070,19058,54083 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Captain_Keatar' OR npc_types.name rlike 'Dill_Fireshine' OR npc_types.name rlike 'Gillarian_Naelev' OR npc_types.name rlike 'Hager_Sureshot' OR npc_types.name rlike 'Kithicor' OR npc_types.name rlike 'Larsk_Juton' OR npc_types.name rlike 'Maesyn_Trueshot' OR npc_types.name rlike 'Merona_Castekin' OR npc_types.name rlike 'Morin_Shadowbane' OR npc_types.name rlike 'Ran_Sunfire'
UPDATE npc_types SET lastname = 'Ranger Guildmaster', class = 23 WHERE id in ( 54084,54104,20081,20084,84150,54105 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Brewing Suppl'
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 98066;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 19090;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 155249;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 19092;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 19044;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 9031;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 8098;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 75095;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 61024;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 49074;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 1074;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 55188;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 40050;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 29017;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 155250;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 42059;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 42058;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 8097;
UPDATE npc_types SET lastname = 'Brewing Supplies', merchant_id = 220 WHERE id = 155209;
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Baking Suppl'
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 155078;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 75103;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 155210;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 98057;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 9062;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 61022;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 75104;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 155145;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 155231;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 19038;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 155232;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 1119;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 29023;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 155211;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 19048;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 8033;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 55180;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 29035;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 155104;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 9063;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 41088;
UPDATE npc_types SET lastname = 'Baking Supplies', merchant_id = 210 WHERE id = 1118;
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Fishing Suppl'
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 10066;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 10065;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 19085;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 155097;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 61041;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 1109;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 61040;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 55141;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 19086;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 61051;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 10067;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 61039;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 280055;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 41069;
UPDATE npc_types SET lastname = 'Fishing Supplies', merchant_id = 215 WHERE id = 29074;
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Innkeep'
UPDATE npc_types SET merchant_id = 25 WHERE id in ( 10058,13074,8084,20086,21069,50118,20079,34064,21070,10043,21064,19087,22098,10059,20076,21065,54140,47144,150216,22093,54141,47145,10042,8100,150146,22099,8099,20093,54142,22096,150255,34063,20080,54143,37047,22101,50117,37063,22074,22094,22102,20087,13073 );
# SELECT id,name FROM npc_types WHERE npc_types.name rlike 'Poison S'
UPDATE npc_types SET merchant_id = 250 WHERE id in ( 155178,9118,155230 );