Index: C:/Program Files/MaNGOS/MANGOS_SVN/UDB/dev_svn/0.8.2_additions/330_updatepack_mangos.sql
===================================================================
--- C:/Program Files/MaNGOS/MANGOS_SVN/UDB/dev_svn/0.8.2_additions/330_updatepack_mangos.sql	(revision 434)
+++ C:/Program Files/MaNGOS/MANGOS_SVN/UDB/dev_svn/0.8.2_additions/330_updatepack_mangos.sql	(revision 435)
@@ -49972,24 +49972,24 @@
 INSERT  INTO `npc_vendor` (entry, item, maxcount, incrtime) VALUES (13429, 17344, 0, 0);
 INSERT  INTO `npc_vendor` (entry, item, maxcount, incrtime) VALUES (13429, 17200, 0, 0);
 INSERT  INTO `npc_vendor` (entry, item, maxcount, incrtime) VALUES (13429, 17201, 0, 0);
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = '129', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '23064';
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = '131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '23065';
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = '131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13429';
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = '131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13430';
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = '131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13435';
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = '131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13436';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = `npcflag`|'129', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '23064';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = `npcflag`|'131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '23065';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = `npcflag`|'131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13429';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = `npcflag`|'131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13430';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = `npcflag`|'131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13435';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = `npcflag`|'131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13436';
 INSERT IGNORE INTO `item_template` VALUES ('34086','4','1','-1','Winter Boots','47629','1','0','1','5','1','8','32767','-1','1','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0.0','0.0','0','0.0','0.0','0','0.0','0.0','0','0.0','0.0','0','0.0','0.0','0','0','0','0','0','0','0','0','0','0','0.0','0','0','0','0.0','-1','0','-1','0','0','0','0.0','-1','0','-1','0','0','0','0.0','-1','0','-1','0','0','0','0.0','-1','0','-1','0','0','0','0.0','-1','0','-1','0','','0','0','0','0','0','8','0','0','0','0','0','16','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0.0','','0','0','0','0');
 INSERT IGNORE INTO `item_template` VALUES ('34411','0','0','-1','Hot Apple Cider','47918','1','0','1','640','160','0','-1','-1','75','65','0','0','0','0','0','0','0','0','20','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0.0','0.0','0','0.0','0.0','0','0.0','0.0','0','0.0','0.0','0','0.0','0.0','0','0','0','0','0','0','0','0','0','0','0.0','45020','0','-1','0.0','0','59','1000','0','0','0','0.0','-1','0','-1','0','0','0','0.0','-1','0','-1','0','0','0','0.0','-1','0','-1','0','0','0','0.0','-1','0','-1','0','','0','0','0','0','0','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0.0','','0','0','0','0');
 INSERT IGNORE INTO `item_template` VALUES ('34191','15','3','-1','Handful of Snowflakes','47527','1','64','1','0','0','0','32767','-1','1','0','0','0','0','0','0','0','0','0','20','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0.0','0.0','0','0.0','0.0','0','0.0','0.0','0','0.0','0.0','0','0.0','0.0','0','0','0','0','0','0','0','0','0','0','0.0','44755','0','-1','0.0','30000','0','-1','0','0','0','0.0','-1','0','-1','0','0','0','0.0','-1','0','-1','0','0','0','0.0','-1','0','-1','0','0','0','0.0','-1','0','-1','0','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0.0','','0','0','0','0');
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = '3', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '15732';
-UPDATE `creature_template` SET `minlevel` = '40', `maxlevel` = '40', `faction_A` = '774', `faction_H` = '774', `npcflag` = '1', flags = '36864', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '15760';
-UPDATE `creature_template` SET `minlevel` = '1', `maxlevel` = '1', `faction_A` = '534', `faction_H` = '534', `npcflag` = '1', flags = '32768', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '18927';
-UPDATE `creature_template` SET `minlevel` = '1', `maxlevel` = '1', `faction_A` = '534', `faction_H` = '534', `npcflag` = '1', flags = '32768', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '19148';
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '29', `faction_H` = '29', `npcflag` = '3', flags = '768', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13445';
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = '131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13418';
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = '131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13420';
-UPDATE `creature_template` SET `minlevel` = '1', `maxlevel` = '1', `faction_A` = '714', `faction_H` = '714', `npcflag` = '1', flags = '32768', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '19178';
-UPDATE `creature_template` SET `minlevel` = '41', `maxlevel` = '41', `faction_A` = '104', `faction_H` = '104', `npcflag` = '2', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '9550';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = `npcflag`|'3', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '15732';
+UPDATE `creature_template` SET `minlevel` = '40', `maxlevel` = '40', `faction_A` = '774', `faction_H` = '774', `npcflag` = `npcflag`|'1', flags = '36864', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '15760';
+UPDATE `creature_template` SET `minlevel` = '1', `maxlevel` = '1', `faction_A` = '534', `faction_H` = '534', `npcflag` = `npcflag`|'1', flags = '32768', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '18927';
+UPDATE `creature_template` SET `minlevel` = '1', `maxlevel` = '1', `faction_A` = '534', `faction_H` = '534', `npcflag` = `npcflag`|'1', flags = '32768', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '19148';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '29', `faction_H` = '29', `npcflag` = `npcflag`|'3', flags = '768', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13445';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = `npcflag`|'131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13418';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = `npcflag`|'131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13420';
+UPDATE `creature_template` SET `minlevel` = '1', `maxlevel` = '1', `faction_A` = '714', `faction_H` = '714', `npcflag` = `npcflag`|'1', flags = '32768', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '19178';
+UPDATE `creature_template` SET `minlevel` = '41', `maxlevel` = '41', `faction_A` = '104', `faction_H` = '104', `npcflag` = `npcflag`|'2', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '9550';
 insert ignore into `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `ExtendedCost`, `RequiredArenaRank`, `RequiredDisenchantSkill`, `ArmorDamageModifier`) values('34412','0','0','-1','Sparkling Apple Cider','47919','1','0','1','1000','50','0','-1','-1','45','35','0','0','0','0','0','0','0','0','20','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','45019','0','-1','-1','0','59','1000','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','','0','0','0','0','0','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0');
 insert ignore into `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `ExtendedCost`, `RequiredArenaRank`, `RequiredDisenchantSkill`, `ArmorDamageModifier`) values('34410','0','0','-1','Honeyed Holiday Ham','47915','1','0','1','4000','200','0','32767','-1','75','65','0','0','0','0','0','0','0','0','20','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','35271','0','-1','-1','0','11','1000','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0');
 insert ignore into `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `ExtendedCost`, `RequiredArenaRank`, `RequiredDisenchantSkill`, `ArmorDamageModifier`) values('34413','9','5','-1','Recipe: Hot Apple Cider','811','1','64','1','0','0','0','-1','-1','35','0','185','325','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','45021','0','-1','-1','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0');
@@ -50094,8 +50094,8 @@
 INSERT IGNORE INTO `game_event_creature` VALUES (86182,2);
 INSERT IGNORE INTO `game_event_creature` VALUES (86180,2);
 INSERT IGNORE INTO `npc_gossip` SET `npc_guid`=86182,`textid`=6194;
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = '131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13433';
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = '131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13434';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = `npcflag`|'131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13433';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = `npcflag`|'131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13434';
 INSERT IGNORE INTO `npc_vendor` (entry, item, maxcount, incrtime) VALUES (13434, 34412, 0, 0);
 INSERT IGNORE INTO `npc_vendor` (entry, item, maxcount, incrtime) VALUES (13434, 34410, 0, 0);
 
@@ -50277,7 +50277,7 @@
 INSERT IGNORE INTO `npc_gossip` SET `npc_guid`=53620,`textid`=6194;
 INSERT IGNORE INTO `npc_gossip` SET `npc_guid`=53618,`textid`=6194;
 INSERT IGNORE INTO `npc_gossip` SET `npc_guid`=53646,`textid`=6250;
-UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = '131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13420';
+UPDATE `creature_template` SET `minlevel` = '30', `maxlevel` = '30', `faction_A` = '35', `faction_H` = '35', `npcflag` = `npcflag`|'131', flags = '4608', `baseattacktime` = '2000', `rangeattacktime` = '0', `dynamicflags` = '0' WHERE `entry` = '13420';
 UPDATE `gameobject_template` SET `size` = '1.000000', `flags` = '0', `faction` = '94' WHERE `entry` = '178609';
 UPDATE `gameobject_template` SET `type`='3', `displayId`='5333', `name`='Holiday Snow', `data0`='43', `data1`='15540', `data2`='0', `data3`='1', `data4`='0', `data5`='0', `data6`='0', `data7`='0', `data8`='0', `data9`='0', `data10`='0', `data11`='0', `data12`='0', `data13`='0', `data14`='0', `data15`='0', `data16`='0', `data17`='0', `data18`='0', `data19`='0', `data20`='0', `data21`='0', `data22`='0', `data23`='0' WHERE `entry` = '178609';
 UPDATE `creature_template` SET `modelid_A` = '13730', `modelid_H` = '13730', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Strange Snowman', `subname`='', `rank`='0', `family`='0', `type`='10', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '13636';