Miscellany

UPDATE `items` SET `entry` = '91001', `class` = '2', `subclass` = '15', `field4` = '-1', `name1` = 'Silent Tempest', `name2` = '', `name3` = '', `name4` = '', `displayid` = '47733', `quality` = '6', `flags` = '0', `buyprice` = '1000000', `sellprice` = '0', `inventorytype` = '13', `allowableclass` = '-1', `allowablerace` = '-1', `itemlevel` = '75', `requiredlevel` = '70', `RequiredSkill` = '0', `RequiredSkillRank` = '0', `RequiredSkillSubRank` = '0', `RequiredPlayerRank1` = '0', `RequiredPlayerRank2` = '0', `RequiredFaction` = '0', `RequiredFactionStanding` = '0', `Unique` = '2', `maxcount` = '1', `ContainerSlots` = '0', `stat_type1` = '7', `stat_value1` = '30', `stat_type2` = '3', `stat_value2` = '25', `stat_type3` = '19', `stat_value3` = '10', `stat_type4` = '31', `stat_value4` = '10', `stat_type5` = '0', `stat_value5` = '0', `stat_type6` = '0', `stat_value6` = '0', `stat_type7` = '0', `stat_value7` = '0', `stat_type8` = '0', `stat_value8` = '0', `stat_type9` = '0', `stat_value9` = '0', `stat_type10` = '0', `stat_value10` = '0', `dmg_min1` = '126', `dmg_max1` = '243', `dmg_type1` = '0', `dmg_min2` = '0', `dmg_max2` = '0', `dmg_type2` = '0', `dmg_min3` = '0', `dmg_max3` = '0', `dmg_type3` = '0', `dmg_min4` = '0', `dmg_max4` = '0', `dmg_type4` = '0', `dmg_min5` = '0', `dmg_max5` = '0', `dmg_type5` = '0', `armor` = '0', `holy_res` = '0', `fire_res` = '0', `nature_res` = '0', `frost_res` = '0', `shadow_res` = '0', `arcane_res` = '0', `delay` = '1800', `ammo_type` = '0', `range` = '0', `spellid_1` = '40688', `spelltrigger_1` = '1', `spellcharges_1` = '0', `spellcooldown_1` = '0', `spellcategory_1` = '0', `spellcategorycooldown_1` = '0', `spellid_2` = '0', `spelltrigger_2` = '0', `spellcharges_2` = '0', `spellcooldown_2` = '0', `spellcategory_2` = '0', `spellcategorycooldown_2` = '0', `spellid_3` = '0', `spelltrigger_3` = '0', `spellcharges_3` = '0', `spellcooldown_3` = '0', `spellcategory_3` = '0', `spellcategorycooldown_3` = '0', `spellid_4` = '0', `spelltrigger_4` = '0', `spellcharges_4` = '0', `spellcooldown_4` = '0', `spellcategory_4` = '0', `spellcategorycooldown_4` = '0', `spellid_5` = '0', `spelltrigger_5` = '0', `spellcharges_5` = '0', `spellcooldown_5` = '0', `spellcategory_5` = '0', `spellcategorycooldown_5` = '0', `bonding` = '1', `description` = 'Ally style, no substance.', `page_id` = '0', `page_language` = '0', `page_material` = '0', `quest_id` = '0', `lock_id` = '0', `lock_material` = '0', `sheathID` = '3', `randomprop` = '0', `unk203_1` = '0', `block` = '0', `itemset` = '0', `MaxDurability` = '150', `ZoneNameID` = '0', `mapid` = NULL, `bagfamily` = '0', `TotemCategory` = NULL, `socket_color_1` = '4', `unk201_3` = '0', `socket_color_2` = '8', `unk201_5` = '0', `socket_color_3` = '2', `unk201_7` = '0', `socket_bonus` = '75', `GemProperties` = NULL, `ItemExtendedCost` = NULL, `ArenaRankRequirement` = '0', `ReqDisenchantSkill` = '-1', `unk2` = '0' WHERE `entry` = 91001 LIMIT 1;
DELETE FROM `creature_quest_starter` WHERE `quest` = 6571;
DELETE FROM `creature_quest_finisher` WHERE `quest` = 6571;
DELETE FROM `gameobject_quest_starter` WHERE `quest` = 6571;
DELETE FROM `gameobject_quest_finisher` WHERE `quest` = 6571;
UPDATE `items` SET `quest_id` = 0 WHERE `quest_id` = '6571';
INSERT INTO `creature_quest_starter` (`id`, `quest`) VALUES ('11820', '6571');
INSERT INTO `creature_quest_starter` (`id`, `quest`) VALUES ('12724', '6571');
INSERT INTO `creature_quest_finisher` (`id`, `quest`) VALUES ('11820', '6571');
INSERT INTO `creature_quest_finisher` (`id`, `quest`) VALUES ('12724', '6571');
DELETE FROM `creature_quest_starter` WHERE `id` = 12724;
DELETE FROM `creature_quest_finisher` WHERE `id` = 12724;
INSERT INTO `creature_quest_starter` (`id`, `quest`) VALUES ('12724', '6441');
INSERT INTO `creature_quest_starter` (`id`, `quest`) VALUES ('12724', '6571');
INSERT INTO `creature_quest_finisher` (`id`, `quest`) VALUES ('12724', '6441');
INSERT INTO `creature_quest_finisher` (`id`, `quest`) VALUES ('12724', '6571');
DELETE FROM `vendors` WHERE `entry` = 12724;
UPDATE `creature_names` SET `entry` = '1317', `name` = 'Lucan Cordell', `subname` = 'Enchanting Trainer', `info_str` = '', `Flags1` = '0', `type` = '7', `family` = '0', `rank` = '0', `unk4` = '0', `spelldataid` = '0', `male_displayid` = '1492', `female_displayid` = '0', `male_displayid2` = '0', `female_displayid2` = '0', `unknown_float1` = '1.1', `unknown_float2` = '1', `civilian` = '1', `leader` = '0' WHERE `entry` = 1317 LIMIT 1;
UPDATE `creature_proto` SET `entry` = '1317', `minlevel` = '35', `maxlevel` = '3