UPDATE `creature_template_addon` SET `auras`='' WHERE (`entry`='36578');
UPDATE `creature_template_addon` SET `auras`='' WHERE (`entry`='36681');
UPDATE `creature_template_addon` SET `auras`='' WHERE (`entry`='38515');
UPDATE `creature_template_addon` SET `auras`='' WHERE (`entry`='38518');
UPDATE `creature_template_addon` SET `auras`='' WHERE (`entry`='42473');
UPDATE `creature_template_addon` SET `auras`='' WHERE (`entry`='38574');
UPDATE `creature_template_addon` SET `auras`='' WHERE (`entry`='30');
UPDATE `creature_template_addon` SET `auras`='' WHERE (`entry`='41146');
DELETE FROM `command` WHERE (`name`='guildhouse');
DELETE FROM `command` WHERE (`name`='guildhouse add');
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`probability`,`BroadcastTextId`,`comment`) VALUES ('23622','2','0','%s thanks you with a special dance.','16','100','22070','kyle EMOTE_DANCE');
DELETE FROM `creature_text` WHERE (`entry`='23616') AND (`groupid`='2') AND (`id`='0');
DELETE FROM `creature_text` WHERE (`entry`='23622') AND (`groupid`='0') AND (`id`='0');
UPDATE `smart_scripts` SET `action_param2`='0' WHERE (`entryorguid`='23622') AND (`source_type`='0') AND (`id`='0') AND (`link`='0');
UPDATE `event_scripts` SET `datalong`='2911' WHERE (`id`='467') AND (`delay`='0') AND (`command`='9') AND (`datalong`='46425') AND (`datalong2`='0') AND (`dataint`='0') AND (`x`='0') AND (`y`='0') AND (`z`='0') AND (`o`='0') LIMIT 1;
DELETE FROM `smart_scripts` WHERE (`entryorguid`='38282') AND (`id`='0');
UPDATE `smart_scripts` SET `target_type`='19',`target_param2`='25' WHERE (`entryorguid`='38282') AND (`source_type`='0') AND (`id`='1') AND (`link`='0');
UPDATE `smart_scripts` SET `event_param1`='0',`event_param2`='0',`event_param3`='2000',`event_param4`='2000' WHERE (`entryorguid`='38282') AND (`source_type`='0') AND (`id`='1') AND (`link`='0');
UPDATE `npc_text` SET `text0_0`='How may I help you?',`text0_1`='How may I help you?' WHERE (`ID`='14126');
UPDATE `creature_text` SET `type`='14' WHERE (`entry`='36161') AND (`groupid`='1');
UPDATE `page_text` SET `text`='Below is the list of students who obtained a Platinum Star grade at Gremlock''s School of Caterers, earning them an Honorary Chef''s Cleaver:\r\n\r\nMelia Stoneshaker\r\nBardin Ironband\r\nUmi Togglevolt\r\nRumi Togglevolt\r\nVorel Steelspire' WHERE (`entry`='2514');
UPDATE `smart_scripts` SET `id`='16' WHERE (`entryorguid`='4157800') AND (`source_type`='9') AND (`id`='9');
UPDATE `smart_scripts` SET `id`='15' WHERE (`entryorguid`='4157800') AND (`source_type`='9') AND (`id`='8');
UPDATE `smart_scripts` SET `id`='14' WHERE (`entryorguid`='4157800') AND (`source_type`='9') AND (`id`='7');
UPDATE `smart_scripts` SET `id`='13' WHERE (`entryorguid`='4157800') AND (`source_type`='9') AND (`id`='6');
UPDATE `smart_scripts` SET `id`='12' WHERE (`entryorguid`='4157800') AND (`source_type`='9') AND (`id`='5');
UPDATE `smart_scripts` SET `id`='11' WHERE (`entryorguid`='4157800') AND (`source_type`='9') AND (`id`='4');
UPDATE `smart_scripts` SET `id`='10' WHERE (`entryorguid`='4157800') AND (`source_type`='9') AND (`id`='3');
UPDATE `smart_scripts` SET `id`='9' WHERE (`entryorguid`='4157800') AND (`source_type`='9') AND (`id`='2');
UPDATE `smart_scripts` SET `id`='8' WHERE (`entryorguid`='4157800') AND (`source_type`='9') AND (`id`='1');
UPDATE `smart_scripts` SET `id`='7' WHERE (`entryorguid`='4157800') AND (`source_type`='9') AND (`id`='0');
INSERT INTO `smart_scripts` VALUES ('4157800','9','0','0','0','0','100','0','0','0','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','On Quest Accept - Say Line 1');
INSERT INTO `smart_scripts` VALUES ('4157800','9','1','0','52','0','100','0','0','41578','0','0','0','1','0','0','0','0','0','0','10','25569','0','0','0','0','0','0','0','On Quest Accept - Say Line 2');
INSERT INTO `smart_scripts` VALUES ('4157800','9','2','0','52','0','100','0','0','25569','0','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','0','On Quest Accept - Say Line 3');
INSERT INTO `smart_scripts` VALUES ('4157800','9','3','0','52','0','100','0','0','41578','1','0','0','1','1','0','0','0','0','0','10','25569','0','0','0','0','0','0','0','On Quest Accept - Say Line 4');
INSERT INTO `smart_scripts` VALUES ('4157800','9','4','0','52','0','100','0','0','25569','1','0','0','1','3','0','0','0','0','0','1','0','0','0','0','0','0','0','0','On Quest Accept - Say Line 5');
INSERT INTO `smart_scripts` VALUES ('4157800','9','5','0','52','0','100','0','0','41578','3','0','0','1','2','0','0','0','0','0','10','25569','0','0','0','0','0','0','0','On Quest Accept - Say Line 6');
INSERT INTO `smart_scripts` VALUES ('4157800','9','6','0','52','0','100','0','0','25569','2','0','0','1','3','0','0','0','0','0','10','25569','0','0','0','0','0','0','0','On Quest Accept - Say Line 7');
INSERT INTO `game_event_gameobject` (`eventEntry`,`guid`) VALUES ('2','255062');
UPDATE `page_text` SET `text`='Nyoma,\r\n\r\nYou can''t imagine how surprised I was to receive the recipe book! Everything you included is just as I remember from home. I can''t wait to try out the new recipes.\r\n\r\nWhen you have some time, you should come visit me in Darnassus. I''ll even cook for you!\r\n\r\nYour friend,\r\nAquinne' WHERE (`entry`='2513');
DELETE FROM `creature_questender` WHERE (`id`='16554') AND (`quest`='9314');
DELETE FROM `creature` WHERE (`guid`='111830');
DELETE FROM `creature` WHERE (`guid`='111831');
UPDATE `broadcast_text` SET `MaleText`='You do not mess with my kitty you son of a mongrel!' WHERE (`ID`='36421');
DELETE FROM `smart_scripts` WHERE (`entryorguid` = '36461') AND (`id` = '8');
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`action_type`,`comment`) VALUES ('36461','0','8','0','54','1','Lucius the Cruel - On Spawn - Say Line');
UPDATE `creature_addon` SET `mount`='0',`bytes2`='0' WHERE (`guid`='159730');