Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4

Conflicts: src/server/game/Movement/MovementGenerators/IdleMovementGenerator.cpp src/server/scripts/EasternKingdoms/BlackrockSpire/boss_rend_blackhand.cpp src/server/scripts/EasternKingdoms/ZulAman/boss_akilzon.cpp src/server/scripts/EasternKingdoms/ZulAman/boss_halazzi.cpp src/server/scripts/EasternKingdoms/ZulAman/boss_hexlord.cpp src/server/scripts/EasternKingdoms/ZulAman/boss_janalai.cpp src/server/scripts/EasternKingdoms/ZulAman/boss_zuljin.cpp src/server/scripts/EasternKingdoms/ZulAman/zulaman.cpp src/server/scripts/EasternKingdoms/ZulGurub/boss_jeklik.cpp src/server/scripts/EasternKingdoms/ZulGurub/boss_jindo.cpp src/server/scripts/EasternKingdoms/ZulGurub/boss_mandokir.cpp src/server/scripts/EasternKingdoms/ZulGurub/boss_marli.cpp src/server/scripts/EasternKingdoms/ZulGurub/boss_thekal.cpp src/server/scripts/EasternKingdoms/zone_arathi_highlands.cpp src/server/scripts/Kalimdor/zone_azshara.cpp src/server/scripts/Kalimdor/zone_dustwallow_marsh.cpp src/server/scripts/Kalimdor/zone_silithus.cpp src/server/scripts/Kalimdor/zone_tanaris.cpp src/server/scripts/Northrend/FrozenHalls/ForgeOfSouls/boss_devourer_of_souls.cpp src/server/scripts/Northrend/IcecrownCitadel/boss_blood_queen_lana_thel.cpp src/server/scripts/Spells/spell_item.cpp
author: Vincent-Michael <Vincent_Michael@gmx.de> 2013-07-04 23:08:02 +0200
committer: Vincent-Michael <Vincent_Michael@gmx.de> 2013-07-04 23:08:02 +0200
commit: 644e75487d6eb160c940ef43d9e2047b4d419730 (patch)
tree: 115b060bc8e6523efa28afeaac27f3fca50b4627 /sql
parent: ece52c11d251593d0ee0b8c2e23e6747fb0bfbd1 (diff)
parent: b4d4e04f53b447a7b6cfba1c7161d9c987260265 (diff)
29 files changed, 1630 insertions, 6 deletions
diff --git a/sql/updates/world/2013_06_25_07_world_creature_text.sql b/sql/updates/world/2013_06_25_07_world_creature_text.sql
index ad52bbac254..dc7ec7f563e 100644
--- a/sql/updates/world/2013_06_25_07_world_creature_text.sql
+++ b/sql/updates/world/2013_06_25_07_world_creature_text.sql
@@ -1,6 +1,6 @@
 -- Text for Lord Victor Nefarius from sniff
 SET @VICTOR := 10162;
-DELETE FROM `creature_text` WHERE `entry` IN (@VICTOR,@REND);
+DELETE FROM `creature_text` WHERE `entry` IN (@VICTOR);
 INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
 -- Lord Victor Nefarius texts UBRS
 (@VICTOR,0,0,"Excellent... it would appear as if the meddlesome insects have arrived just in time to feed my legion. Welcome, mortals!",14,0,100,22,0,0,'Lord Victor Nefarius (UBRS)'),
@@ -12,9 +12,10 @@ INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`pr
 (@VICTOR,6,0,"Use the freezing breath, imbecile!",14,0,100,22,0,0,'Lord Victor Nefarius (UBRS)'),
 (@VICTOR,7,0,"THIS CANNOT BE!!! Rend, deal with these insects.",14,0,100,0,0,0,'Lord Victor Nefarius (UBRS)'),
 (@VICTOR,8,0,"The Warchief shall make quick work of you, mortals. Prepare yourselves!",14,0,100,25,0,0,'Lord Victor Nefarius (UBRS)'),
-(@VICTOR,9,0,"Your victory shall be short lived. The days of both the Alliance and Horde are coming to an end! The next time we meet shall be the last.",14,0,100,5,0,0,'Lord Victor Nefarius (UBRS)'),
-(@VICTOR,10,0,"The mortals have fallen! The new age of the Blackrock legion is at hand!",14,0,100,22,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,9,0,"Taste in my power!",14,0,100,0,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,10,0,"Your victory shall be short lived. The days of both the Alliance and Horde are coming to an end! The next time we meet shall be the last.",14,0,100,5,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,11,0,"The mortals have fallen! The new age of the Blackrock legion is at hand!",14,0,100,22,0,0,'Lord Victor Nefarius (UBRS)'),
 -- Lord Victor Nefarius texts BWL
-(@VICTOR,11,0,"In this world where time is your enemy, it is my greatest ally. This grand game of life that you think you play in fact plays you. To that I say...",14,0,100,1,0,0,'Lord Victor Nefarius SAY_GAMESBEGIN_1 (BWL)'),
-(@VICTOR,12,0,"Let the games begin!",14,0,100,22,0,8280,'Lord Victor Nefarius SAY_GAMESBEGIN_2 (BWL)'),
-(@VICTOR,13,0,"Ah, the heroes. You are persistent, aren't you. Your allied attempted to match his power against mine, and had to pay the price. Now he shall serve me, by slaughtering you. Get up, little red wyrm...and destroy them!",14,0,100,23,0,8279,'Lord Victor Nefarius SAY_VAEL_INTRO (BWL)');
+(@VICTOR,12,0,"In this world where time is your enemy, it is my greatest ally. This grand game of life that you think you play in fact plays you. To that I say...",14,0,100,1,0,0,'Lord Victor Nefarius SAY_GAMESBEGIN_1 (BWL)'),
+(@VICTOR,13,0,"Let the games begin!",14,0,100,22,0,8280,'Lord Victor Nefarius SAY_GAMESBEGIN_2 (BWL)'),
+(@VICTOR,14,0,"Ah, the heroes. You are persistent, aren't you. Your allied attempted to match his power against mine, and had to pay the price. Now he shall serve me, by slaughtering you. Get up, little red wyrm...and destroy them!",14,0,100,23,0,8279,'Lord Victor Nefarius SAY_VAEL_INTRO (BWL)');
diff --git a/sql/updates/world/2013_06_30_00_world_waypoints.sql b/sql/updates/world/2013_06_30_00_world_waypoints.sql
new file mode 100644
index 00000000000..f2a4c58fcf8
--- /dev/null
+++ b/sql/updates/world/2013_06_30_00_world_waypoints.sql
@@ -0,0 +1,42 @@
+-- Pathing for Lord Victor Nefarius Entry: 10162
+SET @PATH := 1379670;
+DELETE FROM `waypoint_data` WHERE `id` IN (@PATH,@PATH+1,@PATH+2);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,168.7847,-444.8676,121.9753,0,0,0,0,100,0),
+(@PATH,2,159.7806,-444.8137,121.9753,0,0,0,0,100,0),
+(@PATH+1,1,163.1683,-444.165,121.9753,0,0,0,0,100,0),
+(@PATH+1,2,163.2364,-443.4956,121.9753,0,0,0,0,100,0),
+(@PATH+1,3,163.3028,-442.0108,122.2531,1.570796,0,0,0,100,0),
+(@PATH+2,1,165.5801,-457.3273,121.9753,0,0,1,0,100,0),
+(@PATH+2,2,165.5504,-465.8904,116.8073,0,0,1,0,100,0),
+(@PATH+2,3,165.3594,-470.635,116.8296,0,0,1,0,100,0),
+(@PATH+2,4,168.4351,-473.7489,116.8424,0,0,1,0,100,0),
+(@PATH+2,5,179.0059,-473.894,116.8424,0,0,1,0,100,0);
+
+-- Pathing for Warchief Rend Blackhand Entry: 10429
+SET @PATH := 1379680;
+DELETE FROM `waypoint_data` WHERE `id` IN (@PATH);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,165.4778,-452.2761,121.9753,0,0,0,0,100,0),
+(@PATH,2,165.5801,-457.3273,121.9753,0,0,0,0,100,0),
+(@PATH,3,165.5504,-465.8904,116.8073,0,0,0,0,100,0),
+(@PATH,4,165.3594,-470.635,116.8296,0,0,0,0,100,0),
+(@PATH,5,168.4351,-473.7489,116.8424,0,0,0,0,100,0),
+(@PATH,6,179.0059,-473.894,116.8424,0,52000,0,0,100,0),
+(@PATH,7,216.6058,-430.4544,110.9169,0,0,0,0,100,0),
+(@PATH,8,216.5664,-412.0932,110.9822,0,0,0,0,100,0),
+(@PATH,9,217.1734,-401.2561,111.0617,0,0,0,0,100,0),
+(@PATH,10,216.5286,-397.7477,111.0883,0,0,0,0,100,0),
+(@PATH,11,214.8428,-395.8612,111.1051,0,0,0,0,100,0),
+(@PATH,12,213.5363,-395.6153,111.1093,0,0,0,0,100,0);
+
+-- Pathing for Gyth Entry: 10339
+SET @PATH := 1379681;
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,211.4939,-399.5368,111.0848,0,0,1,0,100,0),
+(@PATH,2,209.2005,-409.7201,110.9367,0,0,1,0,100,0),
+(@PATH,3,201.0632,-420.6352,110.9231,0,0,1,0,100,0),
+(@PATH,4,178.1997,-420.3415,110.4723,0,0,1,0,100,0),
+(@PATH,5,154.2494,-420.948,110.4723,0,0,1,0,100,0),
+(@PATH,6,127.872,-420.4601,110.4723,0,0,1,0,100,0);
diff --git a/sql/updates/world/2013_06_30_01_world_smart_scripts.sql b/sql/updates/world/2013_06_30_01_world_smart_scripts.sql
new file mode 100644
index 00000000000..65b4a9923fa
--- /dev/null
+++ b/sql/updates/world/2013_06_30_01_world_smart_scripts.sql
@@ -0,0 +1 @@
+UPDATE `smart_scripts` SET `event_flags`=`event_flags`&~30 WHERE `entryorguid` IN (10981,10982,10986,10987,10990,11602,11603,11605,11678,11839,12050,12051,12053,12127,13088,13089,13097,13179,13284,13316,13326,13328,13438,13442,13443,13447,13577,13797,13798,14282,14283) AND `source_type`=0;
diff --git a/sql/updates/world/2013_06_30_02_world_creature_template.sql b/sql/updates/world/2013_06_30_02_world_creature_template.sql
new file mode 100644
index 00000000000..617d49667f2
--- /dev/null
+++ b/sql/updates/world/2013_06_30_02_world_creature_template.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (37955,38434,38435,38436);
diff --git a/sql/updates/world/2013_06_30_03_world_conditions.sql b/sql/updates/world/2013_06_30_03_world_conditions.sql
new file mode 100644
index 00000000000..934a20cd025
--- /dev/null
+++ b/sql/updates/world/2013_06_30_03_world_conditions.sql
@@ -0,0 +1,3 @@
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=51469;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13, 1, 51469, 0, 0, 32, 0, 0x90, 0, 0, 0, 0, 0, '', 'Frenzyheart''s Fury - only for Players');
diff --git a/sql/updates/world/2013_06_30_04_world_sai.sql b/sql/updates/world/2013_06_30_04_world_sai.sql
new file mode 100644
index 00000000000..61ec09c9ff4
--- /dev/null
+++ b/sql/updates/world/2013_06_30_04_world_sai.sql
@@ -0,0 +1,59 @@
+-- The Black Knight's Curse (14016) quest trigger SAI by nelegalno based on C++ script by Sherriff: http://pastebin.com/1ExVqtLe
+SET @TRIGGER := 34735;
+
+UPDATE `creature_template` SET ainame='SmartAI' WHERE `entry`=@TRIGGER;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@TRIGGER AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES 
+(@TRIGGER, 0, 0, 1, 10, 0, 100, 0, 1, 5, 5000, 5000, 12, 35116, 4, 60000, 0, 0, 0, 8, 0, 0, 0, 8451.91, 459.163, 596.072, 0.80, "Link - SummonCreature Cult Saboteur"),
+(@TRIGGER, 0, 1, 0, 61, 0, 100, 0, 0, 0,    0,    0, 12, 35127, 4, 60000, 0, 0, 0, 8, 0, 0, 0, 8456.20, 458.904, 596.072, 1.55, "Link - SummonCreature Cult Assassin");
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=@TRIGGER AND `SourceId`=0;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(22,1,@TRIGGER,0,0, 9,0,14016, 0,0,0,0,'',"Execute SAI only if player is on The Black Knight's Curse quest"),
+(22,1,@TRIGGER,0,0,29,0,35127,50,0,1,0,'',"Execute SAI only if no Cult Assassin within 50y of Black Knight's Grave");
+
+-- Written by Sherriff: http://pastebin.com/gkSqDc52
+-- Add text
+DELETE FROM `creature_text` WHERE `entry`=35116;
+INSERT INTO `creature_text` VALUES 
+(35116,0,0, "What do you think you're doing?",12,0,0,1,0,0, ''),
+(35116,1,0, "You're too late to stop our plan.",12,0,0,1,0,0, ''),
+(35116,2,0, "See to it that I'm not followed.",12,0,0,1,0,0, '');
+
+DELETE FROM `creature_text` WHERE `entry`=35127;
+INSERT INTO `creature_text` VALUES 
+(35127,0,0, "Gladly",12,0,1,0,0,0, '');
+
+-- SAI
+UPDATE `creature_template` SET ainame='SmartAI' WHERE `entry`= 35116;
+UPDATE `creature_template` SET ainame='SmartAI' WHERE `entry`= 35127;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=35116;
+INSERT INTO `smart_scripts` VALUES
+-- need add (The saboteur ports out, via spell)
+(35116, 0, 0, 0, 54, 0, 100, 1, 0, 0, 0, 0, 71, 0, 0, 3334, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,''), -- Equip shovel ID: 3334 ?
+(35116, 0, 1, 0, 38, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,''),
+(35116, 0, 2, 0, 1, 1, 100, 1, 5000, 5000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'');
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=35127;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=35127*100;
+INSERT INTO `smart_scripts` VALUES
+(35127, 0, 0, 1, 54,0,100,0,0,0,0,0,80,35127*100,0,2,0,0,0,1,0,0,0,0,0,0,0,""),
+(35127, 0, 1, 0, 61,0,100,0,0,0,0,0,17,68,0,0,0,0,0,1,0,0,0,0,0,0,0,""),
+-- script
+(35127*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 2, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,''),
+(35127*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,''),
+(35127*100, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,''),
+(35127*100, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 11, 35116, 20, 0, 0, 0, 0, 0,''),
+(35127*100, 9, 4, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 11, 35116, 20, 0, 0, 0, 0, 0,''),
+(35127*100, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 11, 35116, 20, 0, 0, 0, 0, 0,''),
+(35127*100, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 0, 0, 0, 0, 0, 0, 11, 35116, 20, 0, 0, 0, 0, 0,''),
+(35127*100, 9, 7, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,''),
+(35127*100, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,''),
+(35127*100, 9, 9, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,''),
+(35127*100, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,''), -- emote 0 or roar?
+-- combat
+(35127, 0, 2, 0, 0, 0, 100, 0, 3000, 4000, 14000, 15000, 11, 60842, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,''),
+(35127, 0, 3, 0, 0, 0, 100, 0, 1000, 2000, 7000, 8000, 11, 14873, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,''),
+-- on death(quest credit)
+(35127, 0, 4, 0, 6, 0, 100, 1, 0, 0, 0, 0, 85, 66785, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0,'');
diff --git a/sql/updates/world/2013_06_30_05_world_sai.sql b/sql/updates/world/2013_06_30_05_world_sai.sql
new file mode 100644
index 00000000000..e43c840e85a
--- /dev/null
+++ b/sql/updates/world/2013_06_30_05_world_sai.sql
@@ -0,0 +1,829 @@
+SET @FOZRUK := 2611;
+SET @FEEBOZ := 4063;
+SET @ZNORT  := 2765;
+SET @SLEEBY := 2764;
+SET @GUIDFO := 14514;
+SET @GUIDFE := 14517;
+SET @GUIDZN := 14516;
+SET @GUIDSL := 14515;
+SET @PATH   := 145140;
+
+-- Creature formation for Fozruk,Feeboz,Znort and Sleeby
+DELETE FROM `creature_formations` WHERE `leaderGUID`=@GUIDFO;
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`) VALUES
+(@GUIDFO,@GUIDFO,0,0,2),
+(@GUIDFO,@GUIDFE,5,45,2),
+(@GUIDFO,@GUIDZN,5,0,2),
+(@GUIDFO,@GUIDSL,5,315,2);
+UPDATE `creature` SET `MovementType`=2,`position_x`=-799.488159,`position_y`=-3187.840820,`position_z`=81.986244,`currentwaypoint`=1 WHERE `guid` IN (@GUIDFO,@GUIDFE,@GUIDZN,@GUIDSL);
+UPDATE `creature_addon` SET `path_id`=@PATH WHERE `guid` IN (@GUIDFO,@GUIDFE,@GUIDZN,@GUIDSL);
+UPDATE `creature_template` SET `speed_walk`=0.777776,`Health_mod`=1 WHERE `entry` IN (@FEEBOZ,@ZNORT,@SLEEBY);
+UPDATE `creature` SET `curhealth`=3820 WHERE `id`=@FOZRUK;
+UPDATE `creature_template` SET `Health_mod`=2.314 WHERE `entry`=@FOZRUK;
+
+-- Adding missing SAI for Sleeby
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@SLEEBY AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES 
+(@SLEEBY,0,0,0,4,0,100,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sleeby - On Aggro - Say Line 0"),
+(@SLEEBY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,0,0,"Sleeby - At 15% HP - Flee For Assist"),
+(@SLEEBY,0,2,0,14,0,100,0,900,30,18000,21000,11,10577,0,0,0,0,0,9,0,0,30,0,0,0,0,"Sleeby - At 900 HP Deficit on friendly - Cast Heal"),
+(@SLEEBY,0,3,0,2,0,100,1,0,30,22000,28000,11,10577,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sleeby - At 30 % HP - Cast Heal");
+
+
+-- Waypoint Data for Fozruk,Feeboz,Znort and Sleeby
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-832.334,-3205.470,79.68929,0,0,0,0,100,0),
+(@PATH,2,-860.918,-3218.261,84.36646,0,0,0,0,100,0),
+(@PATH,3,-888.679,-3243.162,84.09533,0,0,0,0,100,0),
+(@PATH,4,-914.439,-3273.134,79.92033,0,0,0,0,100,0),
+(@PATH,5,-934.979,-3286.743,75.78973,0,0,0,0,100,0),
+(@PATH,6,-969.229,-3298.048,70.39626,0,0,0,0,100,0),
+(@PATH,7,-999.526,-3300.098,59.43864,0,0,0,0,100,0),
+(@PATH,8,-1024.019,-3302.781,52.57269,0,0,0,0,100,0),
+(@PATH,9,-1042.511,-3304.218,53.96111,0,0,0,0,100,0),
+(@PATH,10,-1071.519,-3303.006,53.72434,0,0,0,0,100,0),
+(@PATH,11,-1094.373,-3294.411,51.28259,0,0,0,0,100,0),
+(@PATH,12,-1116.248,-3283.376,48.46264,0,0,0,0,100,0),
+(@PATH,13,-1134.604,-3275.851,45.93983,0,0,0,0,100,0),
+(@PATH,14,-1138.166,-3253.598,37.34724,0,0,0,0,100,0),
+(@PATH,15,-1149.548,-3219.161,32.92126,0,0,0,0,100,0),
+(@PATH,16,-1154.650,-3191.667,39.82796,0,0,0,0,100,0),
+(@PATH,17,-1152.233,-3172.707,44.92081,0,0,0,0,100,0),
+(@PATH,18,-1155.257,-3148.514,43.87821,0,0,0,0,100,0),
+(@PATH,19,-1156.285,-3118.220,46.07511,0,0,0,0,100,0),
+(@PATH,20,-1158.257,-3089.038,42.32969,0,0,0,0,100,0),
+(@PATH,21,-1166.920,-3051.637,39.44429,0,0,0,0,100,0),
+(@PATH,22,-1173.630,-3018.499,41.95575,0,0,0,0,100,0),
+(@PATH,23,-1177.635,-2989.661,47.36756,0,0,0,0,100,0),
+(@PATH,24,-1184.160,-2956.073,51.06301,0,0,0,0,100,0),
+(@PATH,25,-1199.907,-2932.837,47.81623,0,0,0,0,100,0),
+(@PATH,26,-1214.661,-2909.040,42.48590,0,0,0,0,100,0),
+(@PATH,27,-1227.096,-2890.791,43.51100,0,0,0,0,100,0),
+(@PATH,28,-1238.985,-2873.565,44.54215,0,0,0,0,100,0),
+(@PATH,29,-1250.406,-2857.378,45.41686,0,0,0,0,100,0),
+(@PATH,30,-1247.514,-2836.024,46.47926,0,0,0,0,100,0),
+(@PATH,31,-1248.644,-2794.010,51.19218,0,0,0,0,100,0),
+(@PATH,32,-1255.582,-2758.492,49.47080,0,0,0,0,100,0),
+(@PATH,33,-1267.213,-2729.370,48.34093,0,0,0,0,100,0),
+(@PATH,34,-1284.019,-2714.972,48.51395,0,0,0,0,100,0),
+(@PATH,35,-1301.577,-2701.519,54.30533,0,0,0,0,100,0),
+(@PATH,36,-1318.129,-2685.284,56.57260,0,0,0,0,100,0),
+(@PATH,37,-1337.341,-2665.010,66.17728,0,0,0,0,100,0),
+(@PATH,38,-1351.957,-2651.640,73.03260,0,0,0,0,100,0),
+(@PATH,39,-1368.981,-2639.345,71.88406,0,0,0,0,100,0),
+(@PATH,40,-1386.248,-2625.411,70.91771,0,0,0,0,100,0),
+(@PATH,41,-1404.074,-2608.620,71.74998,0,0,0,0,100,0),
+(@PATH,42,-1414.762,-2591.953,70.57619,0,0,0,0,100,0),
+(@PATH,43,-1421.564,-2568.585,71.20494,0,0,0,0,100,0),
+(@PATH,44,-1424.290,-2551.299,72.80975,0,0,0,0,100,0),
+(@PATH,45,-1425.382,-2525.746,72.76966,0,0,0,0,100,0),
+(@PATH,46,-1427.621,-2500.162,66.61679,0,0,0,0,100,0),
+(@PATH,47,-1428.913,-2478.010,60.97769,0,0,0,0,100,0),
+(@PATH,48,-1430.675,-2450.066,58.70541,0,0,0,0,100,0),
+(@PATH,49,-1432.065,-2430.234,60.31319,0,0,0,0,100,0),
+(@PATH,50,-1434.051,-2407.011,61.26979,0,0,0,0,100,0),
+(@PATH,51,-1441.378,-2382.458,62.31955,0,0,0,0,100,0),
+(@PATH,52,-1455.994,-2351.987,61.89263,0,0,0,0,100,0),
+(@PATH,53,-1476.102,-2327.670,59.28052,0,0,0,0,100,0),
+(@PATH,54,-1488.910,-2303.793,51.65742,0,0,0,0,100,0),
+(@PATH,55,-1480.213,-2280.157,49.29763,0,0,0,0,100,0),
+(@PATH,56,-1481.886,-2261.885,42.77686,0,0,0,0,100,0),
+(@PATH,57,-1488.766,-2238.346,29.72172,0,0,0,0,100,0),
+(@PATH,58,-1478.716,-2221.377,24.46575,0,0,0,0,100,0),
+(@PATH,59,-1470.289,-2202.226,21.37988,0,0,0,0,100,0),
+(@PATH,60,-1463.888,-2183.480,19.25826,0,0,0,0,100,0),
+(@PATH,61,-1462.309,-2166.158,19.51268,0,0,0,0,100,0),
+(@PATH,62,-1462.641,-2139.281,17.96990,0,0,0,0,100,0),
+(@PATH,63,-1461.741,-2117.135,18.41839,0,0,0,0,100,0),
+(@PATH,64,-1462.720,-2096.159,20.99808,0,0,0,0,100,0),
+(@PATH,65,-1466.697,-2073.191,21.76600,0,0,0,0,100,0),
+(@PATH,66,-1469.742,-2051.216,22.28187,0,0,0,0,100,0),
+(@PATH,67,-1470.707,-2034.948,23.92398,0,0,0,0,100,0),
+(@PATH,68,-1467.493,-2011.868,27.70724,0,0,0,0,100,0),
+(@PATH,69,-1461.612,-1991.796,32.13912,0,0,0,0,100,0),
+(@PATH,70,-1453.868,-1976.242,41.14152,0,0,0,0,100,0),
+(@PATH,71,-1440.519,-1963.263,44.36967,0,0,0,0,100,0),
+(@PATH,72,-1427.875,-1962.643,45.06952,0,0,0,0,100,0),
+(@PATH,73,-1403.536,-1960.480,48.94749,0,0,0,0,100,0),
+(@PATH,74,-1384.386,-1955.417,53.90592,0,0,0,0,100,0),
+(@PATH,75,-1369.677,-1945.936,57.96852,0,0,0,0,100,0),
+(@PATH,76,-1350.607,-1921.860,58.38959,0,0,0,0,100,0),
+(@PATH,77,-1340.818,-1894.505,59.48376,0,0,0,0,100,0),
+(@PATH,78,-1331.473,-1868.108,61.54721,0,0,0,0,100,0),
+(@PATH,79,-1324.620,-1843.425,63.16196,0,0,0,0,100,0),
+(@PATH,80,-1314.403,-1825.211,64.58312,0,0,0,0,100,0),
+(@PATH,81,-1298.009,-1805.438,66.00177,0,0,0,0,100,0),
+(@PATH,82,-1277.380,-1794.447,66.98273,0,0,0,0,100,0),
+(@PATH,83,-1262.522,-1781.463,66.29517,0,0,0,0,100,0),
+(@PATH,84,-1257.610,-1764.678,61.17090,0,0,0,0,100,0),
+(@PATH,85,-1254.762,-1740.416,57.42629,0,0,0,0,100,0),
+(@PATH,86,-1257.197,-1714.841,55.34131,0,0,0,0,100,0),
+(@PATH,87,-1261.216,-1690.681,58.78395,0,0,0,0,100,0),
+(@PATH,88,-1270.503,-1675.867,58.18840,0,0,0,0,100,0),
+(@PATH,89,-1286.642,-1660.740,56.26418,0,0,0,0,100,0),
+(@PATH,90,-1300.361,-1645.053,56.51159,0,0,0,0,100,0),
+(@PATH,91,-1308.540,-1627.062,54.06078,0,0,0,0,100,0),
+(@PATH,92,-1311.492,-1607.599,54.04951,0,0,0,0,100,0),
+(@PATH,93,-1304.892,-1587.725,55.84180,0,0,0,0,100,0),
+(@PATH,94,-1294.446,-1572.347,57.09067,0,0,0,0,100,0),
+(@PATH,95,-1276.314,-1559.621,56.87208,0,0,0,0,100,0),
+(@PATH,96,-1258.598,-1553.953,55.82633,0,0,0,0,100,0),
+(@PATH,97,-1247.020,-1555.563,54.08138,0,0,0,0,100,0),
+(@PATH,98,-1223.989,-1559.108,53.75228,0,0,0,0,100,0),
+(@PATH,99,-1204.170,-1566.040,57.69885,0,0,0,0,100,0),
+(@PATH,100,-1181.217,-1574.416,57.90259,0,0,0,0,100,0),
+(@PATH,101,-1171.802,-1584.777,56.51091,0,0,0,0,100,0),
+(@PATH,102,-1153.563,-1592.682,51.61238,0,0,0,0,100,0),
+(@PATH,103,-1135.418,-1600.805,44.96742,0,0,0,0,100,0),
+(@PATH,104,-1118.637,-1609.030,43.56574,0,0,0,0,100,0),
+(@PATH,105,-1099.768,-1620.569,44.50407,0,0,0,0,100,0),
+(@PATH,106,-1085.969,-1629.265,42.54866,0,0,0,0,100,0),
+(@PATH,107,-1062.281,-1644.193,38.64921,0,0,0,0,100,0),
+(@PATH,108,-1042.500,-1656.657,34.32768,0,0,0,0,100,0),
+(@PATH,109,-1023.845,-1668.413,35.51415,0,0,0,0,100,0),
+(@PATH,110,-1010.461,-1679.575,37.13435,0,0,0,0,100,0),
+(@PATH,111,-994.238,-1696.314,37.03594,0,0,0,0,100,0),
+(@PATH,112,-981.290,-1709.695,39.25463,0,0,0,0,100,0),
+(@PATH,113,-965.091,-1726.436,45.73298,0,0,0,0,100,0),
+(@PATH,114,-948.947,-1743.251,50.52712,0,0,0,0,100,0),
+(@PATH,115,-942.321,-1755.448,50.78074,0,0,0,0,100,0),
+(@PATH,116,-931.257,-1775.990,49.88054,0,0,0,0,100,0),
+(@PATH,117,-923.319,-1791.586,48.12437,0,0,0,0,100,0),
+(@PATH,118,-914.847,-1808.245,49.04429,0,0,0,0,100,0),
+(@PATH,119,-916.232,-1825.690,52.98432,0,0,0,0,100,0),
+(@PATH,120,-917.954,-1844.256,60.75032,0,0,0,0,100,0),
+(@PATH,121,-926.844,-1853.560,64.75401,0,0,0,0,100,0),
+(@PATH,122,-939.206,-1860.130,66.13270,0,0,0,0,100,0),
+(@PATH,123,-953.152,-1868.587,66.25734,0,0,0,0,100,0),
+(@PATH,124,-958.630,-1878.914,66.38094,0,0,0,0,100,0),
+(@PATH,125,-970.897,-1898.712,65.08327,0,0,0,0,100,0),
+(@PATH,126,-987.406,-1916.735,65.40691,0,0,0,0,100,0),
+(@PATH,127,-1010.646,-1934.486,63.39084,0,0,0,0,100,0),
+(@PATH,128,-1031.820,-1949.485,62.46684,0,0,0,0,100,0),
+(@PATH,129,-1035.493,-1975.890,62.90833,0,0,0,0,100,0),
+(@PATH,130,-1036.420,-1995.748,64.75522,0,0,0,0,100,0),
+(@PATH,131,-1038.648,-2015.430,67.03606,0,0,0,0,100,0),
+(@PATH,132,-1040.250,-2036.301,66.30344,0,0,0,0,100,0),
+(@PATH,133,-1043.269,-2057.063,61.47777,0,0,0,0,100,0),
+(@PATH,134,-1044.613,-2074.511,55.09937,0,0,0,0,100,0),
+(@PATH,135,-1044.425,-2088.510,52.09245,0,0,0,0,100,0),
+(@PATH,136,-1044.654,-2108.304,53.02930,0,0,0,0,100,0),
+(@PATH,137,-1045.710,-2125.842,57.34435,0,0,0,0,100,0),
+(@PATH,138,-1046.985,-2143.296,60.29477,0,0,0,0,100,0),
+(@PATH,139,-1053.525,-2160.677,61.58408,0,0,0,0,100,0),
+(@PATH,140,-1062.262,-2175.840,62.20592,0,0,0,0,100,0),
+(@PATH,141,-1076.352,-2186.121,61.72998,0,0,0,0,100,0),
+(@PATH,142,-1094.847,-2193.411,60.91643,0,0,0,0,100,0),
+(@PATH,143,-1106.986,-2197.716,60.42783,0,0,0,0,100,0),
+(@PATH,144,-1120.031,-2202.598,60.33088,0,0,0,0,100,0),
+(@PATH,145,-1134.107,-2208.307,60.04767,0,0,0,0,100,0),
+(@PATH,146,-1147.799,-2215.043,59.17715,0,0,0,0,100,0),
+(@PATH,147,-1160.361,-2221.223,56.04159,0,0,0,0,100,0),
+(@PATH,148,-1171.896,-2226.954,52.36503,0,0,0,0,100,0),
+(@PATH,149,-1189.245,-2236.516,50.85875,0,0,0,0,100,0),
+(@PATH,150,-1207.634,-2239.848,53.60689,0,0,0,0,100,0),
+(@PATH,151,-1229.502,-2243.614,54.47043,0,0,0,0,100,0),
+(@PATH,152,-1244.472,-2246.192,55.41187,0,0,0,0,100,0),
+(@PATH,153,-1260.545,-2248.960,56.65786,0,0,0,0,100,0),
+(@PATH,154,-1288.028,-2258.480,63.48441,0,0,0,0,100,0),
+(@PATH,155,-1312.666,-2265.471,63.83049,0,0,0,0,100,0),
+(@PATH,156,-1329.861,-2267.820,60.97282,0,0,0,0,100,0),
+(@PATH,157,-1340.939,-2282.781,60.76001,0,0,0,0,100,0),
+(@PATH,158,-1346.826,-2306.510,63.29128,0,0,0,0,100,0),
+(@PATH,159,-1356.514,-2330.379,62.09324,0,0,0,0,100,0),
+(@PATH,160,-1364.833,-2350.875,63.27309,0,0,0,0,100,0),
+(@PATH,161,-1376.378,-2370.984,64.32507,0,0,0,0,100,0),
+(@PATH,162,-1390.003,-2386.963,64.44643,0,0,0,0,100,0),
+(@PATH,163,-1407.306,-2405.951,61.78886,0,0,0,0,100,0),
+(@PATH,164,-1420.555,-2420.490,60.09317,0,0,0,0,100,0),
+(@PATH,165,-1425.015,-2436.246,60.09718,0,0,0,0,100,0),
+(@PATH,166,-1429.392,-2451.957,58.94998,0,0,0,0,100,0),
+(@PATH,167,-1434.995,-2478.175,61.36834,0,0,0,0,100,0),
+(@PATH,168,-1440.614,-2499.642,65.68507,0,0,0,0,100,0),
+(@PATH,169,-1444.769,-2517.792,67.88286,0,0,0,0,100,0),
+(@PATH,170,-1445.699,-2534.073,69.19215,0,0,0,0,100,0),
+(@PATH,171,-1441.826,-2548.728,71.55446,0,0,0,0,100,0),
+(@PATH,172,-1434.360,-2565.785,69.52008,0,0,0,0,100,0),
+(@PATH,173,-1424.968,-2590.842,66.91249,0,0,0,0,100,0),
+(@PATH,174,-1425.667,-2614.124,63.25773,0,0,0,0,100,0),
+(@PATH,175,-1431.743,-2624.111,59.10629,0,0,0,0,100,0),
+(@PATH,176,-1442.614,-2636.355,53.52480,0,0,0,0,100,0),
+(@PATH,177,-1455.655,-2648.024,49.13583,0,0,0,0,100,0),
+(@PATH,178,-1466.469,-2658.470,45.53018,0,0,0,0,100,0),
+(@PATH,179,-1465.657,-2675.952,41.90980,0,0,0,0,100,0),
+(@PATH,180,-1460.709,-2696.355,37.18211,0,0,0,0,100,0),
+(@PATH,181,-1452.888,-2710.664,35.19919,0,0,0,0,100,0),
+(@PATH,182,-1439.530,-2733.909,36.79025,0,0,0,0,100,0),
+(@PATH,183,-1426.573,-2754.702,36.58022,0,0,0,0,100,0),
+(@PATH,184,-1414.252,-2774.490,40.43624,0,0,0,0,100,0),
+(@PATH,185,-1409.163,-2793.708,40.13807,0,0,0,0,100,0),
+(@PATH,186,-1403.955,-2814.052,38.17089,0,0,0,0,100,0),
+(@PATH,187,-1400.756,-2834.877,37.28344,0,0,0,0,100,0),
+(@PATH,188,-1392.980,-2846.435,36.52287,0,0,0,0,100,0),
+(@PATH,189,-1382.798,-2860.667,34.91384,0,0,0,0,100,0),
+(@PATH,190,-1374.264,-2877.216,32.65070,0,0,0,0,100,0),
+(@PATH,191,-1366.549,-2891.665,32.42652,0,0,0,0,100,0),
+(@PATH,192,-1354.478,-2905.827,39.13261,0,0,0,0,100,0),
+(@PATH,193,-1337.495,-2913.607,41.92314,0,0,0,0,100,0),
+(@PATH,194,-1322.413,-2942.040,38.85258,0,0,0,0,100,0),
+(@PATH,195,-1311.788,-2949.179,37.97545,0,0,0,0,100,0),
+(@PATH,196,-1293.354,-2959.238,36.04282,0,0,0,0,100,0),
+(@PATH,197,-1286.243,-2968.497,35.39156,0,0,0,0,100,0),
+(@PATH,198,-1278.272,-2985.291,35.52282,0,0,0,0,100,0),
+(@PATH,199,-1278.453,-3001.669,36.35407,0,0,0,0,100,0),
+(@PATH,200,-1276.645,-3021.391,36.00177,0,0,0,0,100,0),
+(@PATH,201,-1277.911,-3042.342,35.95967,0,0,0,0,100,0),
+(@PATH,202,-1283.244,-3057.739,35.20432,0,0,0,0,100,0),
+(@PATH,203,-1285.871,-3073.835,34.69639,0,0,0,0,100,0),
+(@PATH,204,-1285.933,-3087.835,34.16180,0,0,0,0,100,0),
+(@PATH,205,-1287.669,-3106.376,33.67950,0,0,0,0,100,0),
+(@PATH,206,-1291.360,-3123.482,34.17837,0,0,0,0,100,0),
+(@PATH,207,-1294.929,-3139.397,35.25090,0,0,0,0,100,0),
+(@PATH,208,-1299.368,-3164.641,35.11166,0,0,0,0,100,0),
+(@PATH,209,-1290.961,-3179.933,35.79531,0,0,0,0,100,0),
+(@PATH,210,-1278.226,-3195.107,35.04691,0,0,0,0,100,0),
+(@PATH,211,-1265.487,-3211.802,34.85434,0,0,0,0,100,0),
+(@PATH,212,-1254.874,-3225.805,34.67227,0,0,0,0,100,0),
+(@PATH,213,-1242.016,-3239.177,34.42041,0,0,0,0,100,0),
+(@PATH,214,-1226.995,-3250.289,32.20225,0,0,0,0,100,0),
+(@PATH,215,-1209.005,-3258.555,29.59883,0,0,0,0,100,0),
+(@PATH,216,-1190.414,-3265.396,32.87492,0,0,0,0,100,0),
+(@PATH,217,-1166.793,-3271.900,39.47464,0,0,0,0,100,0),
+(@PATH,218,-1142.090,-3278.944,45.54786,0,0,0,0,100,0),
+(@PATH,219,-1119.980,-3286.243,48.92627,0,0,0,0,100,0),
+(@PATH,220,-1095.748,-3294.774,51.35248,0,0,0,0,100,0),
+(@PATH,221,-1074.817,-3302.142,53.40496,0,0,0,0,100,0),
+(@PATH,222,-1055.146,-3305.007,54.27245,0,0,0,0,100,0),
+(@PATH,223,-1035.344,-3304.849,53.27559,0,0,0,0,100,0),
+(@PATH,224,-1014.499,-3304.045,54.20192,0,0,0,0,100,0),
+(@PATH,225,-990.851,-3298.044,63.28812,0,0,0,0,100,0),
+(@PATH,226,-970.008,-3295.534,70.09853,0,0,0,0,100,0),
+(@PATH,227,-944.635,-3291.997,74.38611,0,0,0,0,100,0),
+(@PATH,228,-932.371,-3285.322,76.28872,0,0,0,0,100,0),
+(@PATH,229,-913.366,-3271.833,80.13741,0,0,0,0,100,0),
+(@PATH,230,-897.063,-3255.075,83.12675,0,0,0,0,100,0),
+(@PATH,231,-881.291,-3241.244,84.59821,0,0,0,0,100,0),
+(@PATH,232,-867.330,-3227.198,84.76893,0,0,0,0,100,0),
+(@PATH,233,-850.828,-3216.250,83.22803,0,0,0,0,100,0),
+(@PATH,234,-833.957,-3205.938,79.70540,0,0,0,0,100,0),
+(@PATH,235,-816.334,-3196.889,81.54343,3.60,60000,0,0,100,0);
+
+-- Updating creature loot for Fozruk
+DELETE FROM `creature_loot_template` WHERE `entry`=@FOZRUK;
+INSERT INTO `creature_loot_template` VALUES 
+(@FOZRUK,4469,-100,1,0,1,1),
+(@FOZRUK,7192,30,1,0,1,2),
+(@FOZRUK,8150,20,1,0,1,1),
+(@FOZRUK,4552,12,1,0,1,1),
+(@FOZRUK,4554,4,1,0,1,1),
+(@FOZRUK,8157,1,1,0,1,1),
+(@FOZRUK,4637,1,1,0,1,1),
+(@FOZRUK,4045,0.4,1,0,1,1),
+(@FOZRUK,4002,0.3,1,0,1,1),
+(@FOZRUK,7909,0.2,1,0,1,1),
+(@FOZRUK,4024,0.2,1,0,1,1),
+(@FOZRUK,4004,0.2,1,0,1,1),
+(@FOZRUK,3963,0.2,1,0,1,1),
+(@FOZRUK,3989,0.2,1,0,1,1),
+(@FOZRUK,4026,0.2,1,0,1,1),
+(@FOZRUK,8750,0.2,1,0,1,1),
+(@FOZRUK,4025,0.2,1,0,1,1),
+(@FOZRUK,4018,0.2,1,0,1,1),
+(@FOZRUK,3962,0.2,1,0,1,1),
+(@FOZRUK,3938,0.2,1,0,1,1),
+(@FOZRUK,4022,0.2,1,0,1,1),
+(@FOZRUK,4023,0.2,1,0,1,1),
+(@FOZRUK,4020,0.2,1,0,1,1),
+(@FOZRUK,3965,0.1,1,0,1,1),
+(@FOZRUK,3939,0.1,1,0,1,1),
+(@FOZRUK,4019,0.1,1,0,1,1),
+(@FOZRUK,4007,0.1,1,0,1,1),
+(@FOZRUK,3986,0.1,1,0,1,1),
+(@FOZRUK,4017,0.1,1,0,1,1),
+(@FOZRUK,3942,0.1,1,0,1,1),
+(@FOZRUK,3966,0.1,1,0,1,1),
+(@FOZRUK,4021,0.1,1,0,1,1),
+(@FOZRUK,3937,0.1,1,0,1,1),
+(@FOZRUK,3941,0.1,1,0,1,1),
+(@FOZRUK,3943,0.1,1,0,1,1),
+(@FOZRUK,8137,0.1,1,0,1,1),
+(@FOZRUK,9285,0.1,1,0,1,1),
+(@FOZRUK,8194,0.1,1,0,1,1),
+(@FOZRUK,15251,0.1,1,0,1,1),
+(@FOZRUK,4061,0.1,1,0,1,1),
+(@FOZRUK,4736,0.1,1,0,1,1),
+(@FOZRUK,4000,0.1,1,0,1,1),
+(@FOZRUK,3964,0.1,1,0,1,1),
+(@FOZRUK,9290,0.1,1,0,1,1),
+(@FOZRUK,866,0.1,1,0,1,1),
+(@FOZRUK,8386,0.1,1,0,1,1),
+(@FOZRUK,3936,0.1,1,0,1,1),
+(@FOZRUK,4001,0.1,1,0,1,1),
+(@FOZRUK,4005,0.1,1,0,1,1),
+(@FOZRUK,3961,0.1,1,0,1,1),
+(@FOZRUK,3967,0.1,1,0,1,1),
+(@FOZRUK,3968,0.1,1,0,1,1),
+(@FOZRUK,6424,0.1,1,0,1,1),
+(@FOZRUK,9968,0.1,1,0,1,1),
+(@FOZRUK,1625,0.1,1,0,1,1),
+(@FOZRUK,6431,0.1,1,0,1,1),
+(@FOZRUK,12042,0.1,1,0,1,1),
+(@FOZRUK,1640,0.1,1,0,1,1),
+(@FOZRUK,7555,0.1,1,0,1,1),
+(@FOZRUK,9883,0.1,1,0,1,1),
+(@FOZRUK,4087,0.1,1,0,1,1),
+(@FOZRUK,3914,0.1,1,0,1,1),
+(@FOZRUK,8749,0.1,1,0,1,1),
+(@FOZRUK,4003,0.1,1,0,1,1),
+(@FOZRUK,4006,0.1,1,0,1,1),
+(@FOZRUK,13138,0.1,1,0,1,1),
+(@FOZRUK,8196,0.1,1,0,1,1),
+(@FOZRUK,5215,0.1,1,0,1,1),
+(@FOZRUK,9292,0.1,1,0,1,1),
+(@FOZRUK,4058,0.1,1,0,1,1),
+(@FOZRUK,7524,0.1,1,0,1,1),
+(@FOZRUK,8120,0.1,1,0,1,1),
+(@FOZRUK,9893,0.1,1,0,1,1),
+(@FOZRUK,4738,0.1,1,0,1,1),
+(@FOZRUK,11987,0.1,1,0,1,1),
+(@FOZRUK,9897,0.1,1,0,1,1),
+(@FOZRUK,8163,0.1,1,0,1,1),
+(@FOZRUK,4047,0.1,1,0,1,1),
+(@FOZRUK,7481,0.1,1,0,1,1),
+(@FOZRUK,7485,0.1,1,0,1,1),
+(@FOZRUK,7332,0.1,1,0,1,1),
+(@FOZRUK,7471,0.1,1,0,1,1),
+(@FOZRUK,7470,0.1,1,0,1,1),
+(@FOZRUK,9909,0.1,1,0,1,1),
+(@FOZRUK,8751,0.1,1,0,1,1),
+(@FOZRUK,867,0.1,1,0,1,1),
+(@FOZRUK,13058,0.1,1,0,1,1),
+(@FOZRUK,13034,0.1,1,0,1,1),
+(@FOZRUK,7112,0.1,1,0,1,1),
+(@FOZRUK,6415,0.1,1,0,1,1),
+(@FOZRUK,6425,0.1,1,0,1,1),
+(@FOZRUK,9927,0.1,1,0,1,1),
+(@FOZRUK,9928,0.1,1,0,1,1),
+(@FOZRUK,9930,0.1,1,0,1,1),
+(@FOZRUK,9931,0.1,1,0,1,1),
+(@FOZRUK,7486,0.1,1,0,1,1),
+(@FOZRUK,7488,0.1,1,0,1,1),
+(@FOZRUK,7487,0.1,1,0,1,1),
+(@FOZRUK,7491,0.1,1,0,1,1),
+(@FOZRUK,7494,0.1,1,0,1,1),
+(@FOZRUK,6411,0.1,1,0,1,1),
+(@FOZRUK,4068,0.1,1,0,1,1),
+(@FOZRUK,3864,0.1,1,0,1,1),
+(@FOZRUK,15287,0.1,1,0,1,1),
+(@FOZRUK,21947,0.05,1,0,1,1),
+(@FOZRUK,9966,0.05,1,0,1,1),
+(@FOZRUK,9973,0.05,1,0,1,1),
+(@FOZRUK,9972,0.05,1,0,1,1),
+(@FOZRUK,9970,0.05,1,0,1,1),
+(@FOZRUK,12011,0.05,1,0,1,1),
+(@FOZRUK,11204,0.05,1,0,1,1),
+(@FOZRUK,11225,0.05,1,0,1,1),
+(@FOZRUK,11208,0.05,1,0,1,1),
+(@FOZRUK,7522,0.05,1,0,1,1),
+(@FOZRUK,9887,0.05,1,0,1,1),
+(@FOZRUK,9894,0.05,1,0,1,1),
+(@FOZRUK,@FEEBOZ,0.05,1,0,1,1),
+(@FOZRUK,4062,0.05,1,0,1,1),
+(@FOZRUK,9903,0.05,1,0,1,1),
+(@FOZRUK,9904,0.05,1,0,1,1),
+(@FOZRUK,11998,0.05,1,0,1,1),
+(@FOZRUK,4070,0.05,1,0,1,1),
+(@FOZRUK,8162,0.05,1,0,1,1),
+(@FOZRUK,12031,0.05,1,0,1,1),
+(@FOZRUK,4735,0.05,1,0,1,1),
+(@FOZRUK,6429,0.05,1,0,1,1),
+(@FOZRUK,4300,0.05,1,0,1,1),
+(@FOZRUK,10302,0.05,1,0,1,1),
+(@FOZRUK,10300,0.05,1,0,1,1),
+(@FOZRUK,3873,0.05,1,0,1,1),
+(@FOZRUK,8029,0.05,1,0,1,1),
+(@FOZRUK,7479,0.05,1,0,1,1),
+(@FOZRUK,7482,0.05,1,0,1,1),
+(@FOZRUK,15244,0.05,1,0,1,1),
+(@FOZRUK,9298,0.05,1,0,1,1),
+(@FOZRUK,7475,0.05,1,0,1,1),
+(@FOZRUK,7473,0.05,1,0,1,1),
+(@FOZRUK,9907,0.05,1,0,1,1),
+(@FOZRUK,9908,0.05,1,0,1,1),
+(@FOZRUK,9906,0.05,1,0,1,1),
+(@FOZRUK,3187,0.05,1,0,1,1),
+(@FOZRUK,10604,0.05,1,0,1,1),
+(@FOZRUK,9881,0.05,1,0,1,1),
+(@FOZRUK,9882,0.05,1,0,1,1),
+(@FOZRUK,1613,0.05,1,0,1,1),
+(@FOZRUK,7910,0.05,1,0,1,1),
+(@FOZRUK,12023,0.05,1,0,1,1),
+(@FOZRUK,5216,0.05,1,0,1,1),
+(@FOZRUK,9959,0.05,1,0,1,1),
+(@FOZRUK,8385,0.05,1,0,1,1);
+
+-- Updating Creature loot for Feeboz
+DELETE FROM `creature_loot_template` WHERE `entry`=@FEEBOZ;
+INSERT INTO `creature_loot_template` VALUES 
+(@FEEBOZ,4306,51,1,0,1,3),
+(@FEEBOZ,4539,13,1,0,1,1),
+(@FEEBOZ,4338,9,1,0,1,1),
+(@FEEBOZ,1708,4,1,0,1,1),
+(@FEEBOZ,1710,3,1,0,1,1),
+(@FEEBOZ,3827,1.2,1,0,1,1),
+(@FEEBOZ,3805,0.5,1,0,1,1),
+(@FEEBOZ,8748,0.5,1,0,1,1),
+(@FEEBOZ,3795,0.5,1,0,1,1),
+(@FEEBOZ,3797,0.5,1,0,1,1),
+(@FEEBOZ,3782,0.5,1,0,1,1),
+(@FEEBOZ,7492,0.5,1,0,1,1),
+(@FEEBOZ,3785,0.5,1,0,1,1),
+(@FEEBOZ,3780,0.5,1,0,1,1),
+(@FEEBOZ,3817,0.5,1,0,1,1),
+(@FEEBOZ,9891,0.5,1,0,1,1),
+(@FEEBOZ,3803,0.5,1,0,1,1),
+(@FEEBOZ,3784,0.5,1,0,1,1),
+(@FEEBOZ,3787,0.5,1,0,1,1),
+(@FEEBOZ,4636,0.5,1,0,1,1),
+(@FEEBOZ,3811,0.5,1,0,1,1),
+(@FEEBOZ,3807,0.5,1,0,1,1),
+(@FEEBOZ,3779,0.5,1,0,1,1),
+(@FEEBOZ,3778,0.5,1,0,1,1),
+(@FEEBOZ,2289,0.5,1,0,1,1),
+(@FEEBOZ,3781,0.5,1,0,1,1),
+(@FEEBOZ,3801,0.5,1,0,1,1),
+(@FEEBOZ,3783,0.5,1,0,1,1),
+(@FEEBOZ,15233,0.5,1,0,1,1),
+(@FEEBOZ,3786,0.5,1,0,1,1),
+(@FEEBOZ,6432,0.5,1,0,1,1),
+(@FEEBOZ,864,0.5,1,0,1,1),
+(@FEEBOZ,3809,0.5,1,0,1,1),
+(@FEEBOZ,3802,0.5,1,0,1,1),
+(@FEEBOZ,3796,0.5,1,0,1,1),
+(@FEEBOZ,3816,0.5,1,0,1,1),
+(@FEEBOZ,4041,0.5,1,0,1,1),
+(@FEEBOZ,3864,0.5,1,0,1,1),
+(@FEEBOZ,6419,0.5,1,0,1,1),
+(@FEEBOZ,15322,0.5,1,0,1,1),
+(@FEEBOZ,15260,0.5,1,0,1,1),
+(@FEEBOZ,1465,0.5,1,0,1,1),
+(@FEEBOZ,4421,0.5,1,0,1,1),
+(@FEEBOZ,4424,0.5,1,0,1,1),
+(@FEEBOZ,3813,0.5,1,0,1,1),
+(@FEEBOZ,3804,0.5,1,0,1,1),
+(@FEEBOZ,3806,0.5,1,0,1,1),
+(@FEEBOZ,3792,0.5,1,0,1,1),
+(@FEEBOZ,3793,0.5,1,0,1,1),
+(@FEEBOZ,3798,0.5,1,0,1,1),
+(@FEEBOZ,7909,0.5,1,0,1,1),
+(@FEEBOZ,4727,0.5,1,0,1,1),
+(@FEEBOZ,6420,0.5,1,0,1,1),
+(@FEEBOZ,6422,0.5,1,0,1,1),
+(@FEEBOZ,7480,0.5,1,0,1,1),
+(@FEEBOZ,9873,0.5,1,0,1,1),
+(@FEEBOZ,3808,0.5,1,0,1,1),
+(@FEEBOZ,3810,0.5,1,0,1,1),
+(@FEEBOZ,3812,0.5,1,0,1,1),
+(@FEEBOZ,3814,0.5,1,0,1,1),
+(@FEEBOZ,8747,0.5,1,0,1,1),
+(@FEEBOZ,3794,0.5,1,0,1,1),
+(@FEEBOZ,8006,0.5,1,0,1,1),
+(@FEEBOZ,4043,0.5,1,0,1,1),
+(@FEEBOZ,4078,0.5,1,0,1,1),
+(@FEEBOZ,9890,0.5,1,0,1,1),
+(@FEEBOZ,12022,0.5,1,0,1,1),
+(@FEEBOZ,1529,0.5,1,0,1,1),
+(@FEEBOZ,9895,0.5,1,0,1,1),
+(@FEEBOZ,9896,0.5,1,0,1,1),
+(@FEEBOZ,9898,0.5,1,0,1,1),
+(@FEEBOZ,7454,0.5,1,0,1,1),
+(@FEEBOZ,15214,0.5,1,0,1,1),
+(@FEEBOZ,3874,0.5,1,0,1,1),
+(@FEEBOZ,7485,0.5,1,0,1,1),
+(@FEEBOZ,15261,0.5,1,0,1,1),
+(@FEEBOZ,9879,0.5,1,0,1,1),
+(@FEEBOZ,9876,0.5,1,0,1,1),
+(@FEEBOZ,7435,0.5,1,0,1,1),
+(@FEEBOZ,7431,0.5,1,0,1,1),
+(@FEEBOZ,1725,0.5,1,0,1,1),
+(@FEEBOZ,8746,0.5,1,0,1,1),
+(@FEEBOZ,9434,0.5,1,0,1,1),
+(@FEEBOZ,13129,0.5,1,0,1,1),
+(@FEEBOZ,9854,0.5,1,0,1,1),
+(@FEEBOZ,6416,0.5,1,0,1,1),
+(@FEEBOZ,4042,0.5,1,0,1,1),
+(@FEEBOZ,7610,0.5,1,0,1,1),
+(@FEEBOZ,7493,0.5,1,0,1,1),
+(@FEEBOZ,6411,0.5,1,0,1,1),
+(@FEEBOZ,6412,0.5,1,0,1,1),
+(@FEEBOZ,15918,0.5,1,0,1,1),
+(@FEEBOZ,1625,0.5,1,0,1,1),
+(@FEEBOZ,12040,0.5,1,0,1,1),
+(@FEEBOZ,6421,0.5,1,0,1,1),
+(@FEEBOZ,4067,0.5,1,0,1,1),
+(@FEEBOZ,4731,0.5,1,0,1,1),
+(@FEEBOZ,15234,0.5,1,0,1,1),
+(@FEEBOZ,21525,0.5,1,0,1,1),
+(@FEEBOZ,9886,0.5,1,0,1,1),
+(@FEEBOZ,9889,0.5,1,0,1,1),
+(@FEEBOZ,9893,0.5,1,0,1,1),
+(@FEEBOZ,4738,0.5,1,0,1,1),
+(@FEEBOZ,9897,0.5,1,0,1,1),
+(@FEEBOZ,9900,0.5,1,0,1,1),
+(@FEEBOZ,12030,0.5,1,0,1,1),
+(@FEEBOZ,7455,0.5,1,0,1,1),
+(@FEEBOZ,7459,0.5,1,0,1,1),
+(@FEEBOZ,1207,0.5,1,0,1,1),
+(@FEEBOZ,4300,0.5,1,0,1,1),
+(@FEEBOZ,4614,0.5,1,0,1,1),
+(@FEEBOZ,3868,0.5,1,0,1,1),
+(@FEEBOZ,3867,0.5,1,0,1,1),
+(@FEEBOZ,9293,0.5,1,0,1,1),
+(@FEEBOZ,7474,0.5,1,0,1,1),
+(@FEEBOZ,7476,0.5,1,0,1,1),
+(@FEEBOZ,7445,0.5,1,0,1,1),
+(@FEEBOZ,7440,0.5,1,0,1,1),
+(@FEEBOZ,9881,0.5,1,0,1,1),
+(@FEEBOZ,9875,0.5,1,0,1,1),
+(@FEEBOZ,11986,0.5,1,0,1,1),
+(@FEEBOZ,3800,0.5,1,0,1,1);
+
+-- Updating missing pickpocket loot temp for Feeboz
+UPDATE `creature_template` SET `pickpocketloot`=@FEEBOZ WHERE `entry`=@FEEBOZ;
+DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@FEEBOZ;
+INSERT INTO `pickpocketing_loot_template` VALUES 
+(@FEEBOZ,5429,18,1,0,1,1),
+(@FEEBOZ,3771,13,1,0,1,1),
+(@FEEBOZ,16883,11,1,0,1,1),
+(@FEEBOZ,3864,2,1,0,1,1);
+
+-- Updating creature loot for Znort
+DELETE FROM `creature_loot_template` WHERE `entry`=@ZNORT;
+INSERT INTO `creature_loot_template` VALUES 
+(@ZNORT,4306,51,1,0,1,3),
+(@ZNORT,4539,13,1,0,1,1),
+(@ZNORT,4338,9,1,0,1,1),
+(@ZNORT,1708,4,1,0,1,1),
+(@ZNORT,1710,3,1,0,1,1),
+(@ZNORT,3827,1.2,1,0,1,1),
+(@ZNORT,3805,0.5,1,0,1,1),
+(@ZNORT,8748,0.5,1,0,1,1),
+(@ZNORT,3795,0.5,1,0,1,1),
+(@ZNORT,3797,0.5,1,0,1,1),
+(@ZNORT,3782,0.5,1,0,1,1),
+(@ZNORT,7492,0.5,1,0,1,1),
+(@ZNORT,3785,0.5,1,0,1,1),
+(@ZNORT,3780,0.5,1,0,1,1),
+(@ZNORT,3817,0.5,1,0,1,1),
+(@ZNORT,9891,0.5,1,0,1,1),
+(@ZNORT,3803,0.5,1,0,1,1),
+(@ZNORT,3784,0.5,1,0,1,1),
+(@ZNORT,3787,0.5,1,0,1,1),
+(@ZNORT,4636,0.5,1,0,1,1),
+(@ZNORT,3811,0.5,1,0,1,1),
+(@ZNORT,3807,0.5,1,0,1,1),
+(@ZNORT,3779,0.5,1,0,1,1),
+(@ZNORT,3778,0.5,1,0,1,1),
+(@ZNORT,2289,0.5,1,0,1,1),
+(@ZNORT,3781,0.5,1,0,1,1),
+(@ZNORT,3801,0.5,1,0,1,1),
+(@ZNORT,3783,0.5,1,0,1,1),
+(@ZNORT,15233,0.5,1,0,1,1),
+(@ZNORT,3786,0.5,1,0,1,1),
+(@ZNORT,6432,0.5,1,0,1,1),
+(@ZNORT,864,0.5,1,0,1,1),
+(@ZNORT,3809,0.5,1,0,1,1),
+(@ZNORT,3802,0.5,1,0,1,1),
+(@ZNORT,3796,0.5,1,0,1,1),
+(@ZNORT,3816,0.5,1,0,1,1),
+(@ZNORT,4041,0.5,1,0,1,1),
+(@ZNORT,3864,0.5,1,0,1,1),
+(@ZNORT,6419,0.5,1,0,1,1),
+(@ZNORT,15322,0.5,1,0,1,1),
+(@ZNORT,15260,0.5,1,0,1,1),
+(@ZNORT,1465,0.5,1,0,1,1),
+(@ZNORT,4421,0.5,1,0,1,1),
+(@ZNORT,4424,0.5,1,0,1,1),
+(@ZNORT,3813,0.5,1,0,1,1),
+(@ZNORT,3804,0.5,1,0,1,1),
+(@ZNORT,3806,0.5,1,0,1,1),
+(@ZNORT,3792,0.5,1,0,1,1),
+(@ZNORT,3793,0.5,1,0,1,1),
+(@ZNORT,3798,0.5,1,0,1,1),
+(@ZNORT,7909,0.5,1,0,1,1),
+(@ZNORT,4727,0.5,1,0,1,1),
+(@ZNORT,6420,0.5,1,0,1,1),
+(@ZNORT,6422,0.5,1,0,1,1),
+(@ZNORT,7480,0.5,1,0,1,1),
+(@ZNORT,9873,0.5,1,0,1,1),
+(@ZNORT,3808,0.5,1,0,1,1),
+(@ZNORT,3810,0.5,1,0,1,1),
+(@ZNORT,3812,0.5,1,0,1,1),
+(@ZNORT,3814,0.5,1,0,1,1),
+(@ZNORT,8747,0.5,1,0,1,1),
+(@ZNORT,3794,0.5,1,0,1,1),
+(@ZNORT,8006,0.5,1,0,1,1),
+(@ZNORT,4043,0.5,1,0,1,1),
+(@ZNORT,4078,0.5,1,0,1,1),
+(@ZNORT,9890,0.5,1,0,1,1),
+(@ZNORT,12022,0.5,1,0,1,1),
+(@ZNORT,1529,0.5,1,0,1,1),
+(@ZNORT,9895,0.5,1,0,1,1),
+(@ZNORT,9896,0.5,1,0,1,1),
+(@ZNORT,9898,0.5,1,0,1,1),
+(@ZNORT,7454,0.5,1,0,1,1),
+(@ZNORT,15214,0.5,1,0,1,1),
+(@ZNORT,3874,0.5,1,0,1,1),
+(@ZNORT,7485,0.5,1,0,1,1),
+(@ZNORT,15261,0.5,1,0,1,1),
+(@ZNORT,9879,0.5,1,0,1,1),
+(@ZNORT,9876,0.5,1,0,1,1),
+(@ZNORT,7435,0.5,1,0,1,1),
+(@ZNORT,7431,0.5,1,0,1,1),
+(@ZNORT,1725,0.5,1,0,1,1),
+(@ZNORT,8746,0.5,1,0,1,1),
+(@ZNORT,9434,0.5,1,0,1,1),
+(@ZNORT,13129,0.5,1,0,1,1),
+(@ZNORT,9854,0.5,1,0,1,1),
+(@ZNORT,6416,0.5,1,0,1,1),
+(@ZNORT,4042,0.5,1,0,1,1),
+(@ZNORT,7610,0.5,1,0,1,1),
+(@ZNORT,7493,0.5,1,0,1,1),
+(@ZNORT,6411,0.5,1,0,1,1),
+(@ZNORT,6412,0.5,1,0,1,1),
+(@ZNORT,15918,0.5,1,0,1,1),
+(@ZNORT,1625,0.5,1,0,1,1),
+(@ZNORT,12040,0.5,1,0,1,1),
+(@ZNORT,6421,0.5,1,0,1,1),
+(@ZNORT,4067,0.5,1,0,1,1),
+(@ZNORT,4731,0.5,1,0,1,1),
+(@ZNORT,15234,0.5,1,0,1,1),
+(@ZNORT,21525,0.5,1,0,1,1),
+(@ZNORT,9886,0.5,1,0,1,1),
+(@ZNORT,9889,0.5,1,0,1,1),
+(@ZNORT,9893,0.5,1,0,1,1),
+(@ZNORT,4738,0.5,1,0,1,1),
+(@ZNORT,9897,0.5,1,0,1,1),
+(@ZNORT,9900,0.5,1,0,1,1),
+(@ZNORT,12030,0.5,1,0,1,1),
+(@ZNORT,7455,0.5,1,0,1,1),
+(@ZNORT,7459,0.5,1,0,1,1),
+(@ZNORT,1207,0.5,1,0,1,1),
+(@ZNORT,4300,0.5,1,0,1,1),
+(@ZNORT,4614,0.5,1,0,1,1),
+(@ZNORT,3868,0.5,1,0,1,1),
+(@ZNORT,3867,0.5,1,0,1,1),
+(@ZNORT,9293,0.5,1,0,1,1),
+(@ZNORT,7474,0.5,1,0,1,1),
+(@ZNORT,7476,0.5,1,0,1,1),
+(@ZNORT,7445,0.5,1,0,1,1),
+(@ZNORT,7440,0.5,1,0,1,1),
+(@ZNORT,9881,0.5,1,0,1,1),
+(@ZNORT,9875,0.5,1,0,1,1),
+(@ZNORT,11986,0.5,1,0,1,1),
+(@ZNORT,3800,0.5,1,0,1,1);
+
+-- Adding missing pickpocket loot template for Znort
+UPDATE `creature_template` SET `pickpocketloot`=@ZNORT WHERE `entry`=@ZNORT;
+DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@ZNORT;
+INSERT INTO `pickpocketing_loot_template` VALUES 
+(@ZNORT,3771,17,1,0,1,1),
+(@ZNORT,16883,17,1,0,1,1),
+(@ZNORT,5429,16,1,0,1,1),
+(@ZNORT,1710,16,1,0,1,1);
+
+-- Updating creature loot for Sleeby
+DELETE FROM `creature_loot_template` WHERE `entry`=@SLEEBY;
+INSERT INTO `creature_loot_template` VALUES 
+(@SLEEBY,4306,51,1,0,1,3),
+(@SLEEBY,4539,13,1,0,1,1),
+(@SLEEBY,4338,9,1,0,1,1),
+(@SLEEBY,1708,4,1,0,1,1),
+(@SLEEBY,1710,3,1,0,1,1),
+(@SLEEBY,3827,1.2,1,0,1,1),
+(@SLEEBY,3805,0.5,1,0,1,1),
+(@SLEEBY,8748,0.5,1,0,1,1),
+(@SLEEBY,3795,0.5,1,0,1,1),
+(@SLEEBY,3797,0.5,1,0,1,1),
+(@SLEEBY,3782,0.5,1,0,1,1),
+(@SLEEBY,7492,0.5,1,0,1,1),
+(@SLEEBY,3785,0.5,1,0,1,1),
+(@SLEEBY,3780,0.5,1,0,1,1),
+(@SLEEBY,3817,0.5,1,0,1,1),
+(@SLEEBY,9891,0.5,1,0,1,1),
+(@SLEEBY,3803,0.5,1,0,1,1),
+(@SLEEBY,3784,0.5,1,0,1,1),
+(@SLEEBY,3787,0.5,1,0,1,1),
+(@SLEEBY,4636,0.5,1,0,1,1),
+(@SLEEBY,3811,0.5,1,0,1,1),
+(@SLEEBY,3807,0.5,1,0,1,1),
+(@SLEEBY,3779,0.5,1,0,1,1),
+(@SLEEBY,3778,0.5,1,0,1,1),
+(@SLEEBY,2289,0.5,1,0,1,1),
+(@SLEEBY,3781,0.5,1,0,1,1),
+(@SLEEBY,3801,0.5,1,0,1,1),
+(@SLEEBY,3783,0.5,1,0,1,1),
+(@SLEEBY,15233,0.5,1,0,1,1),
+(@SLEEBY,3786,0.5,1,0,1,1),
+(@SLEEBY,6432,0.5,1,0,1,1),
+(@SLEEBY,864,0.5,1,0,1,1),
+(@SLEEBY,3809,0.5,1,0,1,1),
+(@SLEEBY,3802,0.5,1,0,1,1),
+(@SLEEBY,3796,0.5,1,0,1,1),
+(@SLEEBY,3816,0.5,1,0,1,1),
+(@SLEEBY,4041,0.5,1,0,1,1),
+(@SLEEBY,3864,0.5,1,0,1,1),
+(@SLEEBY,6419,0.5,1,0,1,1),
+(@SLEEBY,15322,0.5,1,0,1,1),
+(@SLEEBY,15260,0.5,1,0,1,1),
+(@SLEEBY,1465,0.5,1,0,1,1),
+(@SLEEBY,4421,0.5,1,0,1,1),
+(@SLEEBY,4424,0.5,1,0,1,1),
+(@SLEEBY,3813,0.5,1,0,1,1),
+(@SLEEBY,3804,0.5,1,0,1,1),
+(@SLEEBY,3806,0.5,1,0,1,1),
+(@SLEEBY,3792,0.5,1,0,1,1),
+(@SLEEBY,3793,0.5,1,0,1,1),
+(@SLEEBY,3798,0.5,1,0,1,1),
+(@SLEEBY,7909,0.5,1,0,1,1),
+(@SLEEBY,4727,0.5,1,0,1,1),
+(@SLEEBY,6420,0.5,1,0,1,1),
+(@SLEEBY,6422,0.5,1,0,1,1),
+(@SLEEBY,7480,0.5,1,0,1,1),
+(@SLEEBY,9873,0.5,1,0,1,1),
+(@SLEEBY,3808,0.5,1,0,1,1),
+(@SLEEBY,3810,0.5,1,0,1,1),
+(@SLEEBY,3812,0.5,1,0,1,1),
+(@SLEEBY,3814,0.5,1,0,1,1),
+(@SLEEBY,8747,0.5,1,0,1,1),
+(@SLEEBY,3794,0.5,1,0,1,1),
+(@SLEEBY,8006,0.5,1,0,1,1),
+(@SLEEBY,4043,0.5,1,0,1,1),
+(@SLEEBY,4078,0.5,1,0,1,1),
+(@SLEEBY,9890,0.5,1,0,1,1),
+(@SLEEBY,12022,0.5,1,0,1,1),
+(@SLEEBY,1529,0.5,1,0,1,1),
+(@SLEEBY,9895,0.5,1,0,1,1),
+(@SLEEBY,9896,0.5,1,0,1,1),
+(@SLEEBY,9898,0.5,1,0,1,1),
+(@SLEEBY,7454,0.5,1,0,1,1),
+(@SLEEBY,15214,0.5,1,0,1,1),
+(@SLEEBY,3874,0.5,1,0,1,1),
+(@SLEEBY,7485,0.5,1,0,1,1),
+(@SLEEBY,15261,0.5,1,0,1,1),
+(@SLEEBY,9879,0.5,1,0,1,1),
+(@SLEEBY,9876,0.5,1,0,1,1),
+(@SLEEBY,7435,0.5,1,0,1,1),
+(@SLEEBY,7431,0.5,1,0,1,1),
+(@SLEEBY,1725,0.5,1,0,1,1),
+(@SLEEBY,8746,0.5,1,0,1,1),
+(@SLEEBY,9434,0.5,1,0,1,1),
+(@SLEEBY,13129,0.5,1,0,1,1),
+(@SLEEBY,9854,0.5,1,0,1,1),
+(@SLEEBY,6416,0.5,1,0,1,1),
+(@SLEEBY,4042,0.5,1,0,1,1),
+(@SLEEBY,7610,0.5,1,0,1,1),
+(@SLEEBY,7493,0.5,1,0,1,1),
+(@SLEEBY,6411,0.5,1,0,1,1),
+(@SLEEBY,6412,0.5,1,0,1,1),
+(@SLEEBY,15918,0.5,1,0,1,1),
+(@SLEEBY,1625,0.5,1,0,1,1),
+(@SLEEBY,12040,0.5,1,0,1,1),
+(@SLEEBY,6421,0.5,1,0,1,1),
+(@SLEEBY,4067,0.5,1,0,1,1),
+(@SLEEBY,4731,0.5,1,0,1,1),
+(@SLEEBY,15234,0.5,1,0,1,1),
+(@SLEEBY,21525,0.5,1,0,1,1),
+(@SLEEBY,9886,0.5,1,0,1,1),
+(@SLEEBY,9889,0.5,1,0,1,1),
+(@SLEEBY,9893,0.5,1,0,1,1),
+(@SLEEBY,4738,0.5,1,0,1,1),
+(@SLEEBY,9897,0.5,1,0,1,1),
+(@SLEEBY,9900,0.5,1,0,1,1),
+(@SLEEBY,12030,0.5,1,0,1,1),
+(@SLEEBY,7455,0.5,1,0,1,1),
+(@SLEEBY,7459,0.5,1,0,1,1),
+(@SLEEBY,1207,0.5,1,0,1,1),
+(@SLEEBY,4300,0.5,1,0,1,1),
+(@SLEEBY,4614,0.5,1,0,1,1),
+(@SLEEBY,3868,0.5,1,0,1,1),
+(@SLEEBY,3867,0.5,1,0,1,1),
+(@SLEEBY,9293,0.5,1,0,1,1),
+(@SLEEBY,7474,0.5,1,0,1,1),
+(@SLEEBY,7476,0.5,1,0,1,1),
+(@SLEEBY,7445,0.5,1,0,1,1),
+(@SLEEBY,7440,0.5,1,0,1,1),
+(@SLEEBY,9881,0.5,1,0,1,1),
+(@SLEEBY,9875,0.5,1,0,1,1),
+(@SLEEBY,11986,0.5,1,0,1,1),
+(@SLEEBY,3800,0.5,1,0,1,1);
+
+-- Updating missing pickpocket loot for Sleeby
+UPDATE `creature_template` SET `pickpocketloot`=@SLEEBY WHERE `entry`=@SLEEBY;
+DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@SLEEBY;
+INSERT INTO `pickpocketing_loot_template` VALUES 
+(@SLEEBY,16883,53,1,0,1,1),
+(@SLEEBY,5429,10,1,0,1,1),
+(@SLEEBY,3771,6,1,0,1,1),
+(@SLEEBY,1710,5,1,0,1,1);
diff --git a/sql/updates/world/2013_06_30_06_world_sai.sql b/sql/updates/world/2013_06_30_06_world_sai.sql
new file mode 100644
index 00000000000..3eeed904df9
--- /dev/null
+++ b/sql/updates/world/2013_06_30_06_world_sai.sql
@@ -0,0 +1,9 @@
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN(24688,24689,24690);
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES 
+(24688,0,0,0,2,0,100,6,0,20,29000,39000,11,44505,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Wretched Skulker - On Less than 20% HP - Cast Drink Fel Infusion'),
+(24688,0,1,0,0,0,100,6,6200,14000,5000,12000,11,44533,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Wretched Skulker - In Combat - Cast Wretched Stab'),
+(24689,0,0,0,2,0,100,6,0,20,23000,33000,11,44505,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Wretched Bruiser - On Less than 20% HP - Cast Drink Fel Infusion'),
+(24689,0,1,0,0,0,100,6,3800,3800,6000,11000,11,44534,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Wretched Bruiser - In Combat - Cast Wretched Strike'),
+(24690,0,0,0,2,0,100,6,0,20,29000,39000,11,44505,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Wretched Husk - On Less than 20% HP - Cast Drink Fel Infusion'),
+(24690,0,1,0,0,0,50,6,5000,5000,7000,17000,11,44503,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Wretched Husk - In Combat - Cast Wretched Fireball'),
+(24690,0,2,0,0,0,50,6,6500,6500,14000,24000,11,44504,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Wretched Husk - In Combat - Cast Wretched Frostbolt');
diff --git a/sql/updates/world/2013_06_30_07_world_creature_loot_template.sql b/sql/updates/world/2013_06_30_07_world_creature_loot_template.sql
new file mode 100644
index 00000000000..402e00d685e
--- /dev/null
+++ b/sql/updates/world/2013_06_30_07_world_creature_loot_template.sql
@@ -0,0 +1,3 @@
+-- Gnomish Grenades have Very High drop chance
+-- http://eu.battle.net/wow/en/item/34772
+UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-90 WHERE `entry`=25449 and `item`=34772;
diff --git a/sql/updates/world/2013_06_30_08_world_player_factionchange_spells.sql b/sql/updates/world/2013_06_30_08_world_player_factionchange_spells.sql
new file mode 100644
index 00000000000..1d3da3eb33b
--- /dev/null
+++ b/sql/updates/world/2013_06_30_08_world_player_factionchange_spells.sql
@@ -0,0 +1,5 @@
+DELETE FROM `player_factionchange_spells` WHERE `alliance_id`=59791 AND `horde_id`=59793;
+DELETE FROM `player_factionchange_spells` WHERE `alliance_id`=60114 AND `horde_id`=60116;
+INSERT INTO `player_factionchange_spells` (`alliance_id`,`horde_id`) VALUES
+(59791, 59793), -- Wooly Mammoth
+(60114, 60116); -- Armored Brown Bear
diff --git a/sql/updates/world/2013_06_30_09_world_misc.sql b/sql/updates/world/2013_06_30_09_world_misc.sql
new file mode 100644
index 00000000000..10708ed06b3
--- /dev/null
+++ b/sql/updates/world/2013_06_30_09_world_misc.sql
@@ -0,0 +1,44 @@
+UPDATE `creature_template` SET `resistance2`=1000 WHERE `entry` IN (9816);
+UPDATE `creature_template` SET `mechanic_immune_mask`=617299803 WHERE `entry` IN (10339);
+UPDATE `creature_template` SET `spell1`=0, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry` IN (9816,10339,10429);
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=16337 AND `ConditionValue2`=10429;
+UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry` IN (10317,10318);
+
+-- Pathing for Warchief Rend Blackhand Entry: 10429
+SET @PATH := 1379680;
+DELETE FROM `waypoint_data` WHERE `id` IN (@PATH);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,165.4778,-452.2761,121.9753,0,0,1,0,100,0),
+(@PATH,2,165.5801,-457.3273,121.9753,0,0,1,0,100,0),
+(@PATH,3,165.5504,-465.8904,116.8073,0,0,1,0,100,0),
+(@PATH,4,165.3594,-470.635,116.8296,0,0,1,0,100,0),
+(@PATH,5,168.4351,-473.7489,116.8424,0,0,1,0,100,0),
+(@PATH,6,179.0059,-473.894,116.8424,0,52000,1,0,100,0),
+(@PATH,7,216.6058,-430.4544,110.9169,0,0,1,0,100,0),
+(@PATH,8,216.5664,-412.0932,110.9822,0,0,1,0,100,0),
+(@PATH,9,217.1734,-401.2561,111.0617,0,0,1,0,100,0),
+(@PATH,10,216.5286,-397.7477,111.0883,0,0,1,0,100,0),
+(@PATH,11,214.8428,-395.8612,111.1051,0,0,1,0,100,0),
+(@PATH,12,213.5363,-395.6153,111.1093,0,0,1,0,100,0);
+
+-- Text for Lord Victor Nefarius from sniff
+SET @VICTOR := 10162;
+DELETE FROM `creature_text` WHERE `entry` IN (@VICTOR);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+-- Lord Victor Nefarius texts UBRS
+(@VICTOR,0,0,"Excellent... it would appear as if the meddlesome insects have arrived just in time to feed my legion. Welcome, mortals!",14,0,100,22,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,1,0,"Let not even a drop of their blood remain upon the arena floor, my children. Feast on their souls!",14,0,100,22,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,2,0,"Foolsss... Kill the one in the dress!",14,0,100,22,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,3,0,"Inconceivable!",14,0,100,22,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,4,0,"Your efforts will prove fruitless. None shall stand in our way!",14,0,100,22,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,5,0,"Do not force my hand, children! I shall use your hides to line my boots.",14,0,100,22,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,6,0,"Use the freezing breath, imbecile!",14,0,100,22,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,7,0,"THIS CANNOT BE!!! Rend, deal with these insects.",14,0,100,0,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,8,0,"The Warchief shall make quick work of you, mortals. Prepare yourselves!",14,0,100,25,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,9,0,"Taste in my power!",14,0,100,0,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,10,0,"Your victory shall be short lived. The days of both the Alliance and Horde are coming to an end! The next time we meet shall be the last.",14,0,100,5,0,0,'Lord Victor Nefarius (UBRS)'),
+(@VICTOR,11,0,"The mortals have fallen! The new age of the Blackrock legion is at hand!",14,0,100,22,0,0,'Lord Victor Nefarius (UBRS)'),
+-- Lord Victor Nefarius texts BWL
+(@VICTOR,12,0,"In this world where time is your enemy, it is my greatest ally. This grand game of life that you think you play in fact plays you. To that I say...",14,0,100,1,0,0,'Lord Victor Nefarius SAY_GAMESBEGIN_1 (BWL)'),
+(@VICTOR,13,0,"Let the games begin!",14,0,100,22,0,8280,'Lord Victor Nefarius SAY_GAMESBEGIN_2 (BWL)'),
+(@VICTOR,14,0,"Ah, the heroes. You are persistent, aren't you. Your allied attempted to match his power against mine, and had to pay the price. Now he shall serve me, by slaughtering you. Get up, little red wyrm...and destroy them!",14,0,100,23,0,8279,'Lord Victor Nefarius SAY_VAEL_INTRO (BWL)');
diff --git a/sql/updates/world/2013_06_30_10_world_creature_addon.sql b/sql/updates/world/2013_06_30_10_world_creature_addon.sql
new file mode 100644
index 00000000000..3a38356e295
--- /dev/null
+++ b/sql/updates/world/2013_06_30_10_world_creature_addon.sql
@@ -0,0 +1 @@
+DELETE FROM `creature_addon` WHERE `guid`=121226;
diff --git a/sql/updates/world/2013_06_30_11_world_misc.sql b/sql/updates/world/2013_06_30_11_world_misc.sql
new file mode 100644
index 00000000000..81765d1657a
--- /dev/null
+++ b/sql/updates/world/2013_06_30_11_world_misc.sql
@@ -0,0 +1,18 @@
+-- Add SAI support for Silas Darkmoon
+SET @SILAS := 14823;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@SILAS;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@SILAS;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@SILAS,0,0,0,1,0,100,0,60000,60000,60000,60000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Silas Darkmoon - OOC - Say 0');
+
+-- Text for Silas Darkmoon
+DELETE FROM `creature_text` WHERE `entry` IN (@SILAS);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(@SILAS,0,0,'Everyone enjoying themselves so far?  That''s great!  Welcome to the Darkmoon Faire, the greatest show on all of Azeroth!  Make sure that you speak with Yebb and his friends here while you''re taking in Neblegear''s Darkmoon Zoo Bizarre.',12,0,100,0,0,0,'Silas Darkmoon'),
+(@SILAS,0,1,'We''re back and better than ever!  It''s the Darkmoon Faire friend, and it''s your lucky day! Sparing no expense, we''ve gathered wonders and treats from around the world for your delight.  Whether you''re young or old, rich or poor, the Darkmoon Faire has it all!  Be sure to turn in your Darkmoon Faire Prize Tickets to Gelvas Grimegate, and choose from several exotic and wondrous prizes!',12,0,100,0,0,0,'Silas Darkmoon'),
+(@SILAS,0,2,'Come one, come all.  Welcome to the Darkmoon Faire!  Don''t be shy.  Step right up to Lhara and buy yourself an exotic artifact from far off lands.  If you''re one of the lucky few who have found Darkmoon Cards, have a word with Professor Paleo.  Hungry?  Thirsty?  You''re in luck!  Refreshments are available right here from Sylannia and Stamp.  I recommend the Darkmoon Special Reserve to wash down some Red Hot Wings.  And if the future is what you seek, then run, don''t walk, to speak with Sayge.',12,0,100,0,0,0,'Silas Darkmoon'),
+(@SILAS,0,3,'Welcome one and all to the Darkmoon Faire, the greatest event in all the world!  We have it all... delicious food, strong drink, exotic artifacts, fortunes read, amazing prizes and excitement without end!  Don''t forget to turn in your Darkmoon Faire Prize Tickets to Gelvas Grimegate!  All it takes is five or more and you''re on your way to the most wondrous prizes on all of Azeroth.  Everybody is a winner!',12,0,100,0,0,0,'Silas Darkmoon');
+
+UPDATE `waypoint_data` SET `action`=0 WHERE `id`=1376660;
+DELETE FROM `db_script_string` WHERE `entry` BETWEEN 2000000004 AND 2000000007;
+DELETE FROM `waypoint_scripts` WHERE `dataint` BETWEEN 2000000004 AND 2000000007;
diff --git a/sql/updates/world/2013_06_30_12_world_misc.sql b/sql/updates/world/2013_06_30_12_world_misc.sql
new file mode 100644
index 00000000000..f3a020acfd7
--- /dev/null
+++ b/sql/updates/world/2013_06_30_12_world_misc.sql
@@ -0,0 +1,15 @@
+-- Add SAI support for Curator Thorius
+SET @THORIUS := 8256;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@THORIUS;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@THORIUS;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@THORIUS,0,0,0,1,0,100,0,120000,120000,120000,120000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Curator Thorius - OOC - Say 0');
+
+-- Text for Curator Thorius
+DELETE FROM `creature_text` WHERE `entry` IN (@THORIUS);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(@THORIUS,0,0,'Poor Dorius. If I ever get my hands on those Dark Irons, so help me...',12,0,100,0,0,0,'Curator Thorius');
+
+UPDATE `waypoint_data` SET `action`=0 WHERE `action`=2;
+DELETE FROM `db_script_string` WHERE `entry`=2000005000;
+DELETE FROM `waypoint_scripts` WHERE `dataint`=2000005000;
diff --git a/sql/updates/world/2013_06_30_13_world_misc.sql b/sql/updates/world/2013_06_30_13_world_misc.sql
new file mode 100644
index 00000000000..936c47ec132
--- /dev/null
+++ b/sql/updates/world/2013_06_30_13_world_misc.sql
@@ -0,0 +1,29 @@
+-- Opus already has SAI and text added
+UPDATE `creature` SET `MovementType`=0 WHERE `guid`=4567;
+DELETE FROM `creature_addon` WHERE `guid`=4567;
+UPDATE `waypoint_data` SET `action`=0 WHERE `action` BETWEEN 5 AND 13;
+DELETE FROM `waypoint_data` WHERE `id`=45670;
+DELETE FROM `db_script_string` WHERE `entry` BETWEEN 2000005001 AND 2000005009;
+DELETE FROM `waypoint_scripts` WHERE `dataint` BETWEEN 2000005001 AND 2000005009;
+DELETE FROM `db_script_string` WHERE `entry` BETWEEN 2000000107 AND 2000000109;
+
+-- Add SAI support for Warp-Huntress Kula
+SET @KULA := 32711;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@KULA;
+DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@KULA;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@KULA;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@KULA,0,0,0,11,0,100,0,0,0,0,0,11,61616,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Warp-Huntress Kula -  On Spawn - Summon Backbiter');
+
+-- Add SAI support for Thal'trak Proudtusk
+SET @THALTRAK := 9082;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@THALTRAK;
+DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@THALTRAK;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@THALTRAK;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@THALTRAK,0,0,0,9,0,100,0,9,10,180000,180000,1,0,0,0,0,0,0,11,9079,10,0,0,0,0,0, 'Thal''trak Proudtusk -  Range - Say 0');
+
+-- Text for Thal'trak Proudtusk
+DELETE FROM `creature_text` WHERE `entry` IN (@THALTRAK);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(@THALTRAK,0,0,'Well done, soldiers! At ease!',12,0,100,0,0,0,'Thal''trak Proudtusk');
diff --git a/sql/updates/world/2013_06_30_14_world_misc.sql b/sql/updates/world/2013_06_30_14_world_misc.sql
new file mode 100644
index 00000000000..1db707352f8
--- /dev/null
+++ b/sql/updates/world/2013_06_30_14_world_misc.sql
@@ -0,0 +1,82 @@
+-- Add SAI line to Inspector Tarem
+SET @TAREM := 23567;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@TAREM AND `id`=2;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@TAREM,0,2,0,1,0,100,0,60000,70000,60000,70000,1,0,0,0,0,0,0,11,9079,10,0,0,0,0,0, 'Inspector Tarem -  OOC - Say 0');
+
+-- Text for Inspector Tarem
+DELETE FROM `creature_text` WHERE `entry` IN (@TAREM);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(@TAREM,0,0,'Mysterious hoofprints, scorched shields, stray badges... how do we make sense of all this?',12,0,100,6,0,0,'Inspector Tarem');
+
+-- Add SAI to Krixil Slogswitch
+SET @KRIXIL := 23573;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@KRIXIL;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@KRIXIL;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@KRIXIL,0,0,0,1,0,100,0,60000,70000,170000,180000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Krixil Slogswitch -  OOC - Say 0');
+
+-- Text for Krixil Slogswitch
+DELETE FROM `creature_text` WHERE `entry` IN (@KRIXIL);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(@KRIXIL,0,0,'I don''t think Drazzit''s going to have any luck finding anyone to kill this raptor. I mean, he''s already raised the reward twice...',12,0,100,1,0,0,'Krixil Slogswitch');
+
+-- Add SAI to Axle
+SET @AXLE := 23995;
+SET @BROGG := 23579;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@AXLE;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@AXLE;
+DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@AXLE*100;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@AXLE,0,0,0,11,0,100,0,0,0,0,0,53,0,@AXLE,1,0,0,0,1,0,0,0,0,0,0,0, 'Axle -  Spawn - load waypoints'),
+(@AXLE,0,1,2,40,0,100,0,4,@AXLE,0,0,54,24000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Axle -  Reach wp 4 - Pause Path'),
+(@AXLE,0,2,0,61,0,100,0,0,0,0,0,80,@AXLE*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Axle -  Reach wp 4 - Run Script'),
+(@AXLE,0,3,4,40,0,100,0,8,@AXLE,0,0,54,140000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Axle -  Reach wp 8 - Pause Path'),
+(@AXLE,0,4,0,61,0,100,0,0,0,0,0,66,@AXLE,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Axle -  Reach wp 8 - Turn to'),
+(@AXLE*100,9,0,0,0,0,100,0,4000,4000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Axle -  Script - Say 0'),
+(@AXLE*100,9,1,0,0,0,100,0,4000,4000,0,0,1,0,0,0,0,0,0,11,@BROGG,10,0,0,0,0,0, 'Axle -  Script - brogg Say 0'),
+(@AXLE*100,9,2,0,0,0,100,0,4000,4000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Axle -  Script - Say 1'),
+(@AXLE*100,9,3,0,0,0,100,0,4000,4000,0,0,1,1,0,0,0,0,0,11,@BROGG,10,0,0,0,0,0, 'Axle -  Script - brogg Say 1'),
+(@AXLE*100,9,4,0,0,0,100,0,4000,4000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Axle -  Script - Say 2');
+
+UPDATE `creature` SET `position_x`=-4629.937,`position_y`=-3176.124,`position_z`=41.22349,`orientation`=6.263439 WHERE `id`=@AXLE;
+
+DELETE FROM `waypoints` WHERE `entry`=@AXLE;
+INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
+(@AXLE,1,-4627.793,-3176.207,41.40616, 'Axle'),
+(@AXLE,2,-4617.293,-3178.556,34.95082, 'Axle'),
+(@AXLE,3,-4615.726,-3176.381,34.81108, 'Axle'),
+(@AXLE,4,-4618.000,-3175.210,34.81240, 'Axle'),
+(@AXLE,5,-4615.726,-3176.381,34.81108, 'Axle'),
+(@AXLE,6,-4617.293,-3178.556,34.95082, 'Axle'),
+(@AXLE,7,-4627.793,-3176.207,41.40616, 'Axle'),
+(@AXLE,8,-4629.937,-3176.124,41.22349, 'Axle');
+
+-- Text for Axle
+DELETE FROM `creature_text` WHERE `entry` IN (@AXLE);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(@AXLE,0,0,'I thought we talked about this, Brogg. You can''t stay in this building. Sure, it can house you, but there''s no room for anyone else!',12,0,100,1,0,0,'Axle'),
+(@AXLE,1,0,'Yes, we said you can stay here, but this building is our headquarters! All of our manuals and blueprints are stored here!',12,0,100,1,0,0,'Axle'),
+(@AXLE,2,0,'I''m inclined to say they made ogres too big! I can see I''m not going to convince you to move now, but don''t think this is permanent!',12,0,100,1,0,0,'Axle');
+
+-- Text for Brogg
+DELETE FROM `creature_text` WHERE `entry` IN (@BROGG);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(@BROGG,0,0,'You said Brogg could stay here! You promised Brogg you'' help regain Stonemaul clan Mound!',12,0,100,1,0,0,'Brogg'),
+(@BROGG,1,0,'But this the only building that fit Brogg! Goblins make buildings too small!',12,0,100,1,0,0,'Brogg');
+
+UPDATE `creature` SET `MovementType`=0 WHERE `guid`=18594;
+DELETE FROM `creature_addon` WHERE `guid`=18594;
+DELETE FROM `waypoint_data` WHERE `id`=185940;
+UPDATE `creature` SET `MovementType`=0 WHERE `guid`=18597;
+DELETE FROM `creature_addon` WHERE `guid`=18597;
+DELETE FROM `waypoint_data` WHERE `id`=185970;
+UPDATE `creature` SET `MovementType`=0 WHERE `guid`=18598;
+DELETE FROM `creature_addon` WHERE `guid`=18598;
+DELETE FROM `waypoint_data` WHERE `id`=185980;
+UPDATE `creature` SET `MovementType`=0 WHERE `guid`=18599;
+DELETE FROM `creature_addon` WHERE `guid`=18599;
+DELETE FROM `waypoint_data` WHERE `id`=185990;
+UPDATE `waypoint_data` SET `action`=0 WHERE `action` BETWEEN 14 AND 21;
+DELETE FROM `db_script_string` WHERE `entry` BETWEEN 2000005010 AND 2000005017;
+DELETE FROM `waypoint_scripts` WHERE `dataint` BETWEEN 2000005010 AND 2000005017;
diff --git a/sql/updates/world/2013_06_30_15_world_waypoints.sql b/sql/updates/world/2013_06_30_15_world_waypoints.sql
new file mode 100644
index 00000000000..7d77c68a96c
--- /dev/null
+++ b/sql/updates/world/2013_06_30_15_world_waypoints.sql
@@ -0,0 +1,243 @@
+-- Pathing for Silverback Patriarch Entry: 1558
+SET @NPC := 749;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-13838.81,`position_y`=-41.79492,`position_z`=57.10373 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-13838.81,-41.79492,57.10373,0,0,0,0,100,0),
+(@PATH,2,-13838.5,-38.40104,57.65744,0,0,0,0,100,0),
+(@PATH,3,-13836.35,-38.66819,59.79758,0,0,0,0,100,0),
+(@PATH,4,-13832.86,-39.19607,63.04682,0,0,0,0,100,0),
+(@PATH,5,-13831.31,-36.38173,64.45819,0,0,0,0,100,0),
+(@PATH,6,-13830.13,-33.02333,65.43832,0,0,0,0,100,0),
+(@PATH,7,-13828.11,-29.58236,66.1478,0,0,0,0,100,0),
+(@PATH,8,-13824.51,-25.85015,65.75058,0,0,0,0,100,0),
+(@PATH,9,-13830.01,-34.07888,65.5036,0,0,0,0,100,0),
+(@PATH,10,-13831.8,-38.61513,63.99628,0,0,0,0,100,0),
+(@PATH,11,-13833.62,-39.39497,62.43454,0,0,0,0,100,0),
+(@PATH,12,-13836.13,-38.83323,60.02853,0,0,0,0,100,0),
+(@PATH,13,-13838.13,-38.85352,58.11642,0,0,0,0,100,0),
+(@PATH,14,-13839.39,-40.52235,56.70822,0,0,0,0,100,0),
+(@PATH,15,-13838.61,-42.74751,57.09225,0,0,0,0,100,0),
+(@PATH,16,-13836.2,-45.23134,57.99826,0,0,0,0,100,0),
+(@PATH,17,-13835.5,-48.41515,57.52194,0,0,0,0,100,0),
+(@PATH,18,-13836.58,-51.4235,56.96213,0,0,0,0,100,0),
+(@PATH,19,-13836.19,-54.46452,56.9155,0,0,0,0,100,0),
+(@PATH,20,-13833.54,-58.13335,56.65427,0,0,0,0,100,0),
+(@PATH,21,-13829.67,-61.67665,56.68818,0,0,0,0,100,0),
+(@PATH,22,-13826.99,-63.81337,56.73749,0,0,0,0,100,0),
+(@PATH,23,-13832.18,-58.75868,56.71039,0,0,0,0,100,0),
+(@PATH,24,-13835.33,-53.75391,57.13693,0,0,0,0,100,0),
+(@PATH,25,-13835.29,-48.64996,57.6257,0,0,0,0,100,0),
+(@PATH,26,-13836.21,-45.25011,57.99411,0,0,0,0,100,0);
+-- .go -13838.81 -41.79492 57.10373
+
+-- Pathing for Bloodsail Deckhand Entry: 4505
+SET @NPC := 2597;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-14943.2,`position_y`=356.997,`position_z`=12.59546 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-14943.2,356.997,12.59546,0,0,0,0,100,0),
+(@PATH,2,-14940.8,348.512,7.541732,0,0,0,0,100,0),
+(@PATH,3,-14940.6,346.788,7.541214,0,0,0,0,100,0),
+(@PATH,4,-14944.1,346.391,7.542305,0,0,0,0,100,0),
+(@PATH,5,-14949.2,345.878,7.542548,0,0,0,0,100,0),
+(@PATH,6,-14955.6,344.557,7.542547,0,0,0,0,100,0),
+(@PATH,7,-14954.4,340.313,7.542553,0,0,0,0,100,0),
+(@PATH,8,-14955.6,344.557,7.542547,0,0,0,0,100,0),
+(@PATH,9,-14949.2,345.878,7.542548,0,0,0,0,100,0),
+(@PATH,10,-14944.1,346.391,7.542305,0,0,0,0,100,0),
+(@PATH,11,-14940.6,346.788,7.541214,0,0,0,0,100,0),
+(@PATH,12,-14940.8,348.512,7.541732,0,0,0,0,100,0),
+(@PATH,13,-14942.7,355.733,12.4607,0,0,0,0,100,0),
+(@PATH,14,-14944.9,357.038,12.59546,0,0,0,0,100,0);
+-- .go -14943.2 356.997 12.59546
+
+-- Pathing for Bloodsail Deckhand Entry: 4505
+SET @NPC := 2629;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-14979.3,`position_y`=265.158,`position_z`=7.921213 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-14979.3,265.158,7.921213,0,0,0,0,100,0),
+(@PATH,2,-14974.15,264.915,7.921058,0,0,0,0,100,0),
+(@PATH,3,-14968.1,264.92,4.665063,0,0,0,0,100,0),
+(@PATH,4,-14965.3,267.002,4.658327,0,0,0,0,100,0),
+(@PATH,5,-14975.79,269.4849,0.9351397,0,0,0,0,100,0),
+(@PATH,6,-14965.2,268.908,4.658086,0,0,0,0,100,0),
+(@PATH,7,-14965,264.917,4.657606,0,0,0,0,100,0),
+(@PATH,8,-14968.2,264.917,4.665308,0,0,0,0,100,0),
+(@PATH,9,-14974.2,264.797,7.881999,0,0,0,0,100,0);
+-- .go -14979.3 265.158 7.921213
+
+-- Pathing for Bloodsail Elder Magus Entry: 1653
+SET @NPC := 2592;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-14956.4,`position_y`=353.116,`position_z`=7.54255 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-14956.4,353.116,7.54255,0,0,0,0,100,0),
+(@PATH,2,-14949.4,356.132,7.54255,0,0,0,0,100,0),
+(@PATH,3,-14944.9,357.394,7.544742,0,0,0,0,100,0),
+(@PATH,4,-14936.1,355.807,7.542393,0,0,0,0,100,0),
+(@PATH,5,-14934.4,350.286,7.54255,0,0,0,0,100,0),
+(@PATH,6,-14936.1,355.807,7.542393,0,0,0,0,100,0),
+(@PATH,7,-14944.9,357.394,7.544742,0,0,0,0,100,0),
+(@PATH,8,-14949.4,356.132,7.54255,0,0,0,0,100,0),
+(@PATH,9,-14956.4,353.116,7.54255,0,0,0,0,100,0),
+(@PATH,10,-14962.9,351.408,7.544349,0,0,0,0,100,0),
+(@PATH,11,-14971.6,347.196,7.542575,0,0,0,0,100,0),
+(@PATH,12,-14962.9,351.408,7.544349,0,0,0,0,100,0);
+-- .go -14956.4 353.116 7.54255
+
+-- Pathing for Bloodsail Sea Dog Entry: 1565
+SET @NPC := 2633;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-14998.4,`position_y`=261.767,`position_z`=7.921235 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-14998.4,261.767,7.921235,0,0,0,0,100,0),
+(@PATH,2,-14995,261.635,7.921237,0,0,0,0,100,0),
+(@PATH,3,-14993.8,266.361,6.306773,0,0,0,0,100,0),
+(@PATH,4,-14992.8,266.477,6.306773,0,0,0,0,100,0),
+(@PATH,5,-14993.18,266.3545,6.306773,0,0,0,0,100,0),
+(@PATH,6,-14993.3,261.415,7.922341,0,0,0,0,100,0),
+(@PATH,7,-14994.1,256.648,7.922004,0,0,0,0,100,0),
+(@PATH,8,-14995,261.635,7.921237,0,0,0,0,100,0),
+(@PATH,9,-14998.4,261.767,7.921235,0,0,0,0,100,0),
+(@PATH,10,-14999.5,257.26,7.921242,0,0,0,0,100,0),
+(@PATH,11,-14999.7,269.5383,7.921235,0,0,0,0,100,0),
+(@PATH,12,-14999.24,270.291,7.921232,0,0,0,0,100,0),
+(@PATH,13,-14994.7,270.899,7.921236,0,0,0,0,100,0),
+(@PATH,14,-14993.9,275.938,7.921239,0,0,0,0,100,0),
+(@PATH,15,-14992.9,271.8,7.921234,0,0,0,0,100,0),
+(@PATH,16,-14987.2,270.889,7.923097,0,0,0,0,100,0),
+(@PATH,17,-14982.9,272.309,7.921443,0,0,0,0,100,0),
+(@PATH,18,-14982.7,275.998,7.921844,0,0,0,0,100,0),
+(@PATH,19,-14982.8,272.679,7.921484,0,0,0,0,100,0),
+(@PATH,20,-14977,272.87,7.921478,0,0,0,0,100,0),
+(@PATH,21,-14976.6,275.734,7.921723,0,0,0,0,100,0),
+(@PATH,22,-14977,257.986,7.921237,0,0,0,0,100,0),
+(@PATH,23,-14977.7,261.219,7.921233,0,0,0,0,100,0),
+(@PATH,24,-14982.1,261.434,7.921239,0,0,0,0,100,0),
+(@PATH,25,-14982.8,258.325,7.92124,0,0,0,0,100,0),
+(@PATH,26,-14982.1,261.434,7.921239,0,0,0,0,100,0),
+(@PATH,27,-14979.8,261.929,7.921233,0,0,0,0,100,0),
+(@PATH,28,-14977,257.986,7.921237,0,0,0,0,100,0),
+(@PATH,29,-14977,272.87,7.921478,0,0,0,0,100,0),
+(@PATH,30,-14982.8,272.679,7.921484,0,0,0,0,100,0),
+(@PATH,31,-14982.7,275.998,7.921844,0,0,0,0,100,0),
+(@PATH,32,-14982.9,272.309,7.921443,0,0,0,0,100,0),
+(@PATH,33,-14987.2,270.889,7.923097,0,0,0,0,100,0),
+(@PATH,34,-14992.73,271.7733,7.921853,0,0,0,0,100,0),
+(@PATH,35,-14993.9,275.938,7.921239,0,0,0,0,100,0),
+(@PATH,36,-14994.7,270.899,7.921236,0,0,0,0,100,0),
+(@PATH,37,-14999.24,270.291,7.921235,0,0,0,0,100,0),
+(@PATH,38,-14999.4,275.372,7.92124,0,0,0,0,100,0),
+(@PATH,39,-14999.7,269.592,7.921232,0,0,0,0,100,0),
+(@PATH,40,-14999.5,257.26,7.921242,0,0,0,0,100,0);
+-- .go -14998.4 261.767 7.921235
+
+-- Pathing for Bloodsail Deckhand Entry: 4505
+SET @NPC := 2598;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-14960.1,`position_y`=342.326,`position_z`=7.543998 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-14960.1,342.326,7.543998,0,0,0,0,100,0),
+(@PATH,2,-14956.5,345.042,7.542546,0,0,0,0,100,0),
+(@PATH,3,-14951.4,349.271,7.542691,0,0,0,0,100,0),
+(@PATH,4,-14956.5,345.042,7.542546,0,0,0,0,100,0),
+(@PATH,5,-14960.1,342.326,7.543998,0,0,0,0,100,0),
+(@PATH,6,-14969,340.03,7.542808,0,0,0,0,100,0),
+(@PATH,7,-14974.56,345.089,7.542461,0,0,0,0,100,0),
+(@PATH,8,-14977,344.637,7.117788,0,0,0,0,100,0),
+(@PATH,9,-14982.7,343.339,4.284928,0,0,0,0,100,0),
+(@PATH,10,-14984.6,341.158,4.279126,0,0,0,0,100,0),
+(@PATH,11,-14982.7,343.339,4.284928,0,0,0,0,100,0),
+(@PATH,12,-14977,344.637,7.117788,0,0,0,0,100,0),
+(@PATH,13,-14974.6,345.128,7.542428,0,0,0,0,100,0),
+(@PATH,14,-14969,340.03,7.542808,0,0,0,0,100,0);
+-- .go -14960.1 342.326 7.543998
+
+-- Pathing for Guard Lasiter Entry: 4973
+SET @NPC := 30458;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-3772.623,`position_y`=-4533.357,`position_z`=11.58731 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-3772.623,-4533.357,11.58731,0,22000,0,0,100,0),
+(@PATH,2,-3770.078,-4531.741,11.54261,0,24000,0,0,100,0);
+-- .go -3772.623 -4533.357 11.58731
+
+-- Pathing for Privateer Entry: 23620
+SET @NPC := 31209;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4060.446,`position_y`=-4506.618,`position_z`=6.030344 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-4060.446,-4506.618,6.030344,0,0,0,0,100,0),
+(@PATH,2,-4059.9,-4511.36,6.031829,0,0,0,0,100,0),
+(@PATH,3,-4060.427,-4506.697,6.03091,0,0,0,0,100,0),
+(@PATH,4,-4066.929,-4501.822,6.031856,0,0,0,0,100,0),
+(@PATH,5,-4072.242,-4506.002,6.032337,0,0,0,0,100,0),
+(@PATH,6,-4066.929,-4501.822,6.031856,0,0,0,0,100,0);
+-- .go -4060.446 -4506.618 6.030344
+
+-- Pathing for Sergeant Amelyn Entry: 23835
+SET @NPC := 18589;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-3839.592,`position_y`=-4562.359,`position_z`=8.639986 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,4097,2402, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-3839.592,-4562.359,8.639986,0,0,0,0,100,0),
+(@PATH,2,-3834.418,-4560.115,8.764986,0,0,0,0,100,0),
+(@PATH,3,-3831.503,-4554.752,9.017159,0,0,0,0,100,0),
+(@PATH,4,-3832.31,-4547.42,9.267159,0,0,0,0,100,0),
+(@PATH,5,-3837.411,-4543.646,9.264986,0,0,0,0,100,0),
+(@PATH,6,-3843.691,-4542.708,9.139986,0,0,0,0,100,0),
+(@PATH,7,-3848.835,-4545.314,8.889986,0,0,0,0,100,0),
+(@PATH,8,-3852.152,-4551.402,8.514986,0,0,0,0,100,0),
+(@PATH,9,-3849.583,-4557.867,8.514986,0,0,0,0,100,0),
+(@PATH,10,-3846.69,-4558.219,8.514986,0,0,0,0,100,0),
+(@PATH,11,-3846.69,-4558.219,8.514986,3.892084,50000,0,0,100,0),
+(@PATH,12,-3844.929,-4561.821,8.514986,0,0,0,0,100,0);
+-- .go -3839.592 -4562.359 8.639986
+
+-- Pathing for Zanzil Zombie Entry: 1488
+SET @NPC := 2244;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-13646.8,`position_y`=-274.549,`position_z`=8.300073 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-13646.8,-274.549,8.300073,0,0,0,0,100,0),
+(@PATH,2,-13634.3,-280.575,8.300073,0,0,0,0,100,0),
+(@PATH,3,-13624.5,-285.943,8.300567,0,0,0,0,100,0),
+(@PATH,4,-13622.9,-293.137,8.425567,0,0,0,0,100,0),
+(@PATH,5,-13635.7,-313.58,8.309404,0,0,0,0,100,0),
+(@PATH,6,-13641.1,-314.866,8.184404,0,0,0,0,100,0),
+(@PATH,7,-13649.3,-309.953,8.184404,0,0,0,0,100,0),
+(@PATH,8,-13655,-302.635,8.184404,0,0,0,0,100,0),
+(@PATH,9,-13656,-290.47,8.300073,0,0,0,0,100,0);
+-- 0xF53005D300674CA0 .go -13646.8 -274.549 8.300073
diff --git a/sql/updates/world/2013_06_30_16_world_misc.sql b/sql/updates/world/2013_06_30_16_world_misc.sql
new file mode 100644
index 00000000000..7e7494e58cd
--- /dev/null
+++ b/sql/updates/world/2013_06_30_16_world_misc.sql
@@ -0,0 +1,104 @@
+-- Add SAI to Warosh
+SET @WAROSH := 10799;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@WAROSH;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@WAROSH;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@WAROSH,0,0,0,1,0,100,0,20000,20000,20000,20000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Warosh -  OOC - Say 0');
+-- Text for Warosh
+DELETE FROM `creature_text` WHERE `entry` IN (@WAROSH);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(@WAROSH,0,0,'%s cries.',16,0,100,0,0,0,'Warosh'),
+(@WAROSH,0,1,'%s snorts.',16,0,100,0,0,0,'Warosh'),
+(@WAROSH,0,2,'%s grumbles.',16,0,100,0,0,0,'Warosh');
+
+-- Add missing and path Warosh Entry: 10799
+SET @NPC := 17;
+SET @PATH := @NPC * 10;
+DELETE FROM `creature` WHERE `guid`=@NPC;
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`) VALUES
+(@NPC,10799,229,1,1,0,0,81.104,-479.903,30.86245,3.124139,7200,0,0,1,0,2);
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,81.104,-479.903,30.86245,0,0,0,0,100,0),
+(@PATH,2,73.26363,-487.8571,27.89152,0,0,0,0,100,0),
+(@PATH,3,54.61135,-489.3818,28.67157,0,0,0,0,100,0),
+(@PATH,4,44.71681,-491.037,29.5888,0,0,0,0,100,0),
+(@PATH,5,52.57936,-511.4861,29.06968,0,0,0,0,100,0),
+(@PATH,6,50.58394,-533.1805,26.7767,0,0,0,0,100,0),
+(@PATH,7,50.20008,-560.1547,30.55615,0,0,0,0,100,0),
+(@PATH,8,50.46281,-576.035,30.58308,0,0,0,0,100,0),
+(@PATH,9,39.68649,-579.5075,31.06343,0,0,0,0,100,0),
+(@PATH,10,17.70853,-578.2368,26.5612,0,0,0,0,100,0),
+(@PATH,11,-5.465746,-576.0652,29.19087,0,0,0,0,100,0),
+(@PATH,12,-27.13421,-574.506,29.19087,0,0,0,0,100,0),
+(@PATH,13,-47.66818,-572.6104,29.19087,0,0,0,0,100,0),
+(@PATH,14,-60.44478,-573.6581,29.19087,0,0,0,0,100,0),
+(@PATH,15,-43.34514,-571.0668,29.19087,0,0,0,0,100,0),
+(@PATH,16,-36.48037,-563.5282,29.19087,0,0,0,0,100,0),
+(@PATH,17,-48.5064,-537.1736,29.19087,0,0,0,0,100,0),
+(@PATH,18,-36.48037,-563.5282,29.19087,0,0,0,0,100,0),
+(@PATH,19,-43.34514,-571.0668,29.19087,0,0,0,0,100,0),
+(@PATH,20,-60.44478,-573.6581,29.19087,0,0,0,0,100,0),
+(@PATH,21,-47.66818,-572.6104,29.19087,0,0,0,0,100,0),
+(@PATH,22,-27.13421,-574.506,29.19087,0,0,0,0,100,0),
+(@PATH,23,-5.465746,-576.0652,29.19087,0,0,0,0,100,0),
+(@PATH,24,17.42213,-578.2202,26.65305,0,0,0,0,100,0),
+(@PATH,25,39.67855,-579.5101,31.09808,0,0,0,0,100,0),
+(@PATH,26,50.46281,-576.035,30.58308,0,0,0,0,100,0),
+(@PATH,27,50.20008,-560.1547,30.55615,0,0,0,0,100,0),
+(@PATH,28,50.58394,-533.1805,26.7767,0,0,0,0,100,0),
+(@PATH,29,52.60767,-511.5597,29.21094,0,0,0,0,100,0),
+(@PATH,30,44.71681,-491.037,29.5888,0,0,0,0,100,0),
+(@PATH,31,54.37603,-489.401,28.65347,0,51000,0,0,100,0),
+(@PATH,32,73.26363,-487.8571,27.89152,0,0,0,0,100,0),
+(@PATH,33,81.104,-479.903,30.86245,0,0,0,0,100,0),
+(@PATH,34,78.66329,-463.2451,35.48121,0,0,0,0,100,0),
+(@PATH,35,71.58976,-436.8153,41.41042,0,0,0,0,100,0),
+(@PATH,36,58.41603,-418.7091,45.02646,0,0,0,0,100,0),
+(@PATH,37,49.90298,-402.1319,48.80593,0,0,0,0,100,0),
+(@PATH,38,46.01845,-387.0023,48.69103,0,0,0,0,100,0),
+(@PATH,39,49.90298,-402.1319,48.80593,0,0,0,0,100,0),
+(@PATH,40,58.41603,-418.7091,45.02646,0,0,0,0,100,0),
+(@PATH,41,71.58976,-436.8153,41.41042,0,0,0,0,100,0);
+-- 0xF130002A2F01FCD8 .go 81.104 -479.903 30.86245
+
+-- Pathing for Spirestone Butcher Entry: 9219
+SET @NPC := 43523;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-36.58493,`position_y`=-441.9179,`position_z`=31.83226 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-36.58493,-441.9179,31.83226,0,0,0,0,100,0),
+(@PATH,2,-37.40374,-482.51,29.62917,0,0,0,0,100,0),
+(@PATH,3,-37.18431,-487.9846,29.38416,0,0,0,0,100,0),
+(@PATH,4,-37.40374,-482.51,29.62917,0,0,0,0,100,0),
+(@PATH,5,-36.58493,-441.9179,31.83226,0,0,0,0,100,0),
+(@PATH,6,-37.03431,-412.0911,31.57773,0,0,0,0,100,0);
+-- .go -36.58493 -441.9179 31.83226
+
+-- Pathing for Smolderthorn Mystic Entry: 9239
+SET @NPC := 43527;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2.398426,`position_y`=-461.1257,`position_z`=16.14088 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-2.398426,-461.1257,16.14088,0,0,0,0,100,0),
+(@PATH,2,2.359199,-464.0517,16.06489,0,0,0,0,100,0),
+(@PATH,3,2.3592,-464.0517,16.06489,2.216568,21000,0,0,100,0),
+(@PATH,4,1.288787,-463.5652,16.07071,0,0,0,0,100,0),
+(@PATH,5,-2.044648,-461.8262,16.13557,0,0,0,0,100,0),
+(@PATH,6,-7.927852,-461.18,16.73,0,0,0,0,100,0),
+(@PATH,7,-15.24469,-460.3805,16.55355,0,0,0,0,100,0),
+(@PATH,8,-21.31746,-455.7214,16.58231,0,0,0,0,100,0),
+(@PATH,9,-22.68492,-451.7054,16.6012,0,0,0,0,100,0),
+(@PATH,10,-22.68492,-451.7054,16.6012,0.7504916,23000,0,0,100,0),
+(@PATH,11,-19.41172,-457.9942,16.57828,0,0,0,0,100,0),
+(@PATH,12,-13.95378,-460.6527,16.58616,0,0,0,0,100,0),
+(@PATH,13,-7.328142,-460.9917,16.72944,0,0,0,0,100,0);
+-- .go -2.398426 -461.1257 16.14088
diff --git a/sql/updates/world/2013_07_01_00_world_misc.sql b/sql/updates/world/2013_07_01_00_world_misc.sql
new file mode 100644
index 00000000000..f1812ed2b49
--- /dev/null
+++ b/sql/updates/world/2013_07_01_00_world_misc.sql
@@ -0,0 +1,31 @@
+-- Text for Halycon
+DELETE FROM `creature_text` WHERE `entry` IN (10220);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(10220,0,0,'%s lets loose a guttural growl as her body collapses. A horrifying howl can be heard echoing through the halls of Blackrock Spire. Something is very, very angry.',16,0,100,0,0,0,'Halycon DEATH');
+
+-- Text for Urok Doomhowl
+DELETE FROM `creature_text` WHERE `entry` IN (10584);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(10584,0,0,'You have summoned me, fool!  Now DIE!',14,0,100,0,0,0,'Urok Doomhowl SUMMON'),
+(10584,1,0,'Me smash! You die!',12,0,100,0,0,0,'Urok Doomhowl AGGRO');
+
+DELETE FROM `creature` WHERE `guid`=44457;
+DELETE FROM `creature` WHERE `guid`=45844;
+DELETE FROM `gameobject` WHERE `id`=175584;
+DELETE FROM `creature_ai_scripts` WHERE `creature_id`=10268;
+DELETE FROM `creature_ai_scripts` WHERE `creature_id`=10584;
+UPDATE `gameobject` SET `position_x`=-14.35011,`position_y`=-395.8278,`position_z`=48.50652,`orientation`=3.141593,`rotation2`=-1,`rotation3`=0 WHERE `guid`=99791;
+
+UPDATE `creature_template` SET `AIName`= '', `ScriptName`= 'boss_gizrul_the_slavener' WHERE `entry`=10268;
+UPDATE `creature_template` SET `AIName`= '', `ScriptName`= 'boss_urok_doomhowl' WHERE `entry`=10584;
+
+-- Pathing for Gizrul the Slavener Entry: 10268
+SET @PATH := 402450;
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-166.7968,-381.5575,64.40081,0,0,1,0,100,0),
+(@PATH,2,-166.8486,-370.3099,64.40081,0,0,1,0,100,0),
+(@PATH,3,-166.4099,-356.3583,64.40081,0,0,1,0,100,0),
+(@PATH,4,-166.0918,-341.4831,64.40081,0,0,1,0,100,0),
+(@PATH,5,-168.4625,-328.9532,64.40081,0,0,1,0,100,0),
+(@PATH,6,-173.3950,-325.9816,64.40932,0,0,1,0,100,0);
diff --git a/sql/updates/world/2013_07_01_01_world_misc.sql b/sql/updates/world/2013_07_01_01_world_misc.sql
new file mode 100644
index 00000000000..0ffd041aa7c
--- /dev/null
+++ b/sql/updates/world/2013_07_01_01_world_misc.sql
@@ -0,0 +1,5 @@
+DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 16 AND 18;
+DELETE FROM `db_script_string` WHERE `entry` IN (2000000107,2000000108);
+INSERT INTO `db_script_string` (`entry`,`content_default`) VALUES
+(2000000107, 'These aren''t Shango''s tracks.'),
+(2000000108, 'These tracks must belong to Shango.');
diff --git a/sql/updates/world/2013_07_01_02_world_creature.sql b/sql/updates/world/2013_07_01_02_world_creature.sql
new file mode 100644
index 00000000000..3e8e00f9779
--- /dev/null
+++ b/sql/updates/world/2013_07_01_02_world_creature.sql
@@ -0,0 +1,6 @@
+DELETE FROM `creature` WHERE `guid` IN (44456,45095,40507,40508);
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`) VALUES
+(44456,9197,229,1,1,0,0,-40.63613,-372.2156,50.56116,0.8552113,10800,5,0,1,0,1),
+(45095,9197,229,1,1,0,0,-22.85546,-377.8695,49.04873,6.161012,10800,5,0,1,0,1),
+(40507,9216,229,1,1,0,0,-44.31393,-364.7873,52.05709,1.832596,10800,5,0,1,0,1),
+(40508,9216,229,1,1,0,0,-16.89405,-385.1013,48.95151,0.5934119,10800,5,0,1,0,1);
diff --git a/sql/updates/world/2013_07_01_03_world_creature_template.sql b/sql/updates/world/2013_07_01_03_world_creature_template.sql
new file mode 100644
index 00000000000..6813f7d5156
--- /dev/null
+++ b/sql/updates/world/2013_07_01_03_world_creature_template.sql
@@ -0,0 +1,4 @@
+UPDATE `creature_template` SET `ScriptName`='' WHERE `entry` IN (14282,10876,14389);
+UPDATE `creature_template` SET `AIName`='' WHERE `entry` IN (11946,11947,11948,11949,14762,14763,14764,14765,14772,14773,14776,14777);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (11947,11948);
+DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (14762,14763,14764,14765,14772,14773,14776,14777);
diff --git a/sql/updates/world/2013_07_01_04_world_gameobject.sql b/sql/updates/world/2013_07_01_04_world_gameobject.sql
new file mode 100644
index 00000000000..f53850871fe
--- /dev/null
+++ b/sql/updates/world/2013_07_01_04_world_gameobject.sql
@@ -0,0 +1,2 @@
+UPDATE `gameobject_template` SET `flags`=16 WHERE `entry` IN (181366,193426);
+UPDATE `gameobject` SET `position_x`=2516.595,`position_y`=-2946.82,`position_z`=245.5516,`orientation`=5.480335,`rotation2`=0,`rotation3`=0,`animprogress`=255 WHERE `id` IN (181366,193426);
diff --git a/sql/updates/world/2013_07_01_05_world_creature_text.sql b/sql/updates/world/2013_07_01_05_world_creature_text.sql
new file mode 100644
index 00000000000..808022ada14
--- /dev/null
+++ b/sql/updates/world/2013_07_01_05_world_creature_text.sql
@@ -0,0 +1,33 @@
+SET @AKAMA           := 23089;
+SET @ILLIDAN         := 22917;
+SET @FLAMEOFAZZINOTH := 22997;
+SET @MAIEV           := 23197;
+DELETE FROM `creature_text` WHERE `entry` IN (@AKAMA, @ILLIDAN, @FLAMEOFAZZINOTH, @MAIEV);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(@AKAMA,0,0, "Be wary friends, The Betrayer meditates in the court just beyond.",14,0,100,0,0,11388, 'Akama SAY_AKAMA_BEWARE'),
+(@AKAMA,1,0, "I'll deal with these mongrels. Strike now, friends! Strike at the betrayer!",14,0,100,0,0,11390, 'Akama SAY_AKAMA_LEAVE'),
+(@ILLIDAN,0,0, "Come, my minions. Deal with this traitor as he deserves!",14,0,100,0,0,11465, 'Illidan SAY_ILLIDAN_MINION'),
+(@ILLIDAN,1,0, "Who shall be next to taste my blades?!",14,0,100,0,0,11473, 'Illidan SAY_ILLIDAN_KILL'),
+(@ILLIDAN,1,1, "This is too easy!",14,0,100,0,0,11472, 'Illidan SAY_ILLIDAN_KILL'),
+(@ILLIDAN,2,0, "I will not be touched by rabble such as you!",14,0,100,0,0,11479, 'Illidan SAY_ILLIDAN_TAKEOFF'),
+(@ILLIDAN,3,0, "Behold the flames of Azzinoth!",14,0,100,0,0,11480, 'Illidan SAY_ILLIDAN_SUMMONFLAMES'),
+(@ILLIDAN,4,0, "Stare into the eyes of the Betrayer!",14,0,100,0,0,11481, 'Illidan SAY_ILLIDAN_EYE_BLAST'),
+(@ILLIDAN,5,0, "Behold the power... of the demon within!",14,0,100,0,0,11475, 'Illidan SAY_ILLIDAN_MORPH'),
+(@ILLIDAN,6,0, "You've wasted too much time mortals, now you shall fall!",14,0,100,0,0,11474, 'Illidan SAY_ILLIDAN_ENRAGE'),
+(@ILLIDAN,7,0, "I can feel your hatred.",14,0,100,0,0,11467, 'Illidan SAY_ILLIDAN_TAUNT'),
+(@ILLIDAN,7,1, "Give in to your fear!",14,0,100,0,0,11468, 'Illidan SAY_ILLIDAN_TAUNT'),
+(@ILLIDAN,7,2, "You know nothing of power!",14,0,100,0,0,11469, 'Illidan SAY_ILLIDAN_TAUNT'),
+(@ILLIDAN,7,3, "Such... arrogance!",14,0,100,0,0,11471, 'Illidan SAY_ILLIDAN_TAUNT'),
+(@FLAMEOFAZZINOTH,0,0, "%s sets its gaze on $N!",16,0,100,0,0,0, 'Flame of Azzinoth EMOTE_AZZINOTH_GAZE'),
+(@MAIEV,0,0, "That is for Naisha!",14,0,100,0,0,11493, 'Maiev Shadowsong SAY_MAIEV_SHADOWSONG_TAUNT'),
+(@MAIEV,0,1, "Bleed as I have bled!",14,0,100,0,0,11494, 'Maiev Shadowsong SAY_MAIEV_SHADOWSONG_TAUNT'),
+(@MAIEV,0,2, "There shall be no prison for you this time!",14,0,100,0,0,11495, 'Maiev Shadowsong SAY_MAIEV_SHADOWSONG_TAUNT'),
+(@MAIEV,0,3, "Meet your end, demon!",14,0,100,0,0,11500, 'Maiev Shadowsong SAY_MAIEV_SHADOWSONG_TAUNT');
+
+-- The time has come to face Illidan, $N.  Are you ready?
+UPDATE `creature_template` SET `gossip_menu_id`=8713 WHERE `entry`=23089;
+DELETE FROM `gossip_menu` WHERE `entry`=8713 AND `text_id`=10960;
+INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (8713, 10960);
+DELETE FROM `gossip_menu_option` WHERE `menu_id`=8713 AND `id`=0;
+INSERT INTO `gossip_menu_option` (`menu_id`, `id`,`option_icon`,`option_text`,`box_coded`,`box_money`,`box_text`) VALUES
+(8713, 0, 0, 'I''m ready, Akama.', 0, 0, '');
diff --git a/sql/updates/world/2013_07_01_06_world_gossip.sql b/sql/updates/world/2013_07_01_06_world_gossip.sql
new file mode 100644
index 00000000000..88dcc711c23
--- /dev/null
+++ b/sql/updates/world/2013_07_01_06_world_gossip.sql
@@ -0,0 +1,7 @@
+-- I sense you've cleared the path to my brethren.  My connection to them and to the temple is still strong.  Do you wish to delve deeper inside?
+UPDATE `creature_template` SET `gossip_menu_id`=8750 WHERE `entry`=23411;
+DELETE FROM `gossip_menu` WHERE `entry`=8750 AND `text_id`=11081;
+INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (8750, 11081);
+DELETE FROM `gossip_menu_option` WHERE (`menu_id`=8750 AND `id`=1);
+INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `box_coded`, `box_money`, `box_text`) VALUES
+(8750, 1, 0, 'Take me to the other Deathsworn, Olum.', 0, 0, '');
diff --git a/sql/updates/world/2013_07_02_00_world_gossip.sql b/sql/updates/world/2013_07_02_00_world_gossip.sql
new file mode 100644
index 00000000000..3537ddb0f82
--- /dev/null
+++ b/sql/updates/world/2013_07_02_00_world_gossip.sql
@@ -0,0 +1,15 @@
+-- I sense you've cleared the path to my brethren.  My connection to them and to the temple is still strong.  Do you wish to delve deeper inside?
+UPDATE `creature_template` SET `gossip_menu_id`=8750 WHERE `entry`=23411;
+DELETE FROM `gossip_menu` WHERE `entry`=8750 AND `text_id`=11081;
+INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (8750, 11081);
+DELETE FROM `gossip_menu_option` WHERE (`menu_id`=8750 AND `id`=1);
+INSERT INTO `gossip_menu_option` (`menu_id`, `id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`box_text`) VALUES
+(8750, 1, 0, 'Take me to the other Deathsworn, Olum.', 1, 1, '');
+
+-- The time has come to face Illidan, $N.  Are you ready?
+UPDATE `creature_template` SET `gossip_menu_id`=8713 WHERE `entry`=23089;
+DELETE FROM `gossip_menu` WHERE `entry`=8713 AND `text_id`=10960;
+INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (8713, 10960);
+DELETE FROM `gossip_menu_option` WHERE `menu_id`=8713 AND `id`=0;
+INSERT INTO `gossip_menu_option` (`menu_id`, `id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`box_text`) VALUES
+(8713, 0, 0, 'I''m ready, Akama.', 1, 1, '');
diff --git a/sql/updates/world/2013_07_04_00_world_misc.sql b/sql/updates/world/2013_07_04_00_world_misc.sql
new file mode 100644
index 00000000000..5e7d7839f5d
--- /dev/null
+++ b/sql/updates/world/2013_07_04_00_world_misc.sql
@@ -0,0 +1,2 @@
+-- Fix some startup errors.
+DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (11946,11949);
diff --git a/sql/updates/world/2013_07_04_01_world_razorfen_kraul.sql b/sql/updates/world/2013_07_04_01_world_razorfen_kraul.sql
new file mode 100644
index 00000000000..a05037d791f
--- /dev/null
+++ b/sql/updates/world/2013_07_04_01_world_razorfen_kraul.sql
@@ -0,0 +1,26 @@
+SET @GUID := 56185;
+
+DELETE FROM `gameobject` WHERE `id`=20920 OR `id`=300011;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES 
+(@GUID, 20920, 47, 1, 1, 2082.74, 1671.82, 61.2396, 3.66079, 0, 0, 0.966493, -0.256693, -43200, 100, 1),
+(@GUID+1, 20920, 47, 1, 1, 2159.43, 1687.49, 57.5433, 3.66079, 0, 0, 0.966493, -0.256693, -43200, 100, 1),
+(@GUID+2, 20920, 47, 1, 1, 2080.89, 1703.36, 56.6447, 0.553757, 0, 0, 0.273354, 0.961913, -43200, 100, 1),
+(@GUID+3, 20920, 47, 1, 1, 2055.28, 1767.7, 58.4559, 2.98378, 0, 0, 0.996889, 0.0788245, -43200, 100, 1),
+(@GUID+4, 20920, 47, 1, 1, 2196.64, 1827.96, 61.4706, 2.11277, 0, 0, 0.870583, 0.492022, -43200, 100, 1),
+(@GUID+5, 20920, 47, 1, 1, 2030.32, 1867.61, 56.2866, 5.6777, 0, 0, 0.298139, -0.954522, -43200, 100, 1),
+(@GUID+6, 20920, 47, 1, 1, 2091.33, 1861.73, 51.0341, 1.25355, 0, 0, 0.586536, 0.809923, -43200, 100, 1),
+(@GUID+7, 20920, 47, 1, 1, 2200.15, 1897.64, 71.3191, 2.6492, 0, 0, 0.969846, 0.243717, -43200, 100, 1),
+(@GUID+8, 20920, 47, 1, 1, 2075.75, 1742.04, 76.7184, 1.33994, 0, 0, 0.620962, 0.78384, -43200, 100, 1),
+(@GUID+9, 20920, 47, 1, 1, 2126, 1661.15, 82.4824, 0.0220437, 0, 0, 0.0110216, 0.999939, -43200, 100, 1),
+(@GUID+10, 20920, 47, 1, 1, 2207.92, 1596.91, 80.7375, 3.60582, 0, 0, 0.973182, -0.230035, -43200, 100, 1),
+(@GUID+11, 20920, 47, 1, 1, 2156.98, 1542.26, 72.849, 2.43086, 0, 0, 0.937519, 0.347934, -43200, 100, 1),
+(@GUID+12, 20920, 47, 1, 1, 2179.95, 1514.06, 69.0709, 0.778385, 0, 0, 0.379441, 0.925216, -43200, 100, 1),
+(@GUID+13, 20920, 47, 1, 1, 2000.85, 1533.93, 80.3971, 4.919, 0, 0, 0.630419, -0.776255, -43200, 100, 1),
+(@GUID+14, 20920, 47, 1, 1, 1991.49, 1608.53, 81.1601, 1.1004, 0, 0, 0.522858, 0.85242, -43200, 100, 1),
+(@GUID+15, 300011, 47, 1, 1, 2072.84, 1582.57, 82.14, 0, 0, 0, 0, 1, -43200, 0, 1);
+
+UPDATE `creature_template` SET `ScriptName`='npc_snufflenose_gopher' WHERE `entry`=4781;
+
+DELETE FROM `spell_script_names` WHERE `spell_id`=8283;
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(8283, 'spell_snufflenose_command');
diff --git a/sql/updates/world/2013_07_04_02_world_misc.sql b/sql/updates/world/2013_07_04_02_world_misc.sql
new file mode 100644
index 00000000000..3c6bcea5600
--- /dev/null
+++ b/sql/updates/world/2013_07_04_02_world_misc.sql
@@ -0,0 +1,4 @@
+UPDATE `creature_template` SET `ScriptName` = REPLACE(`ScriptName`, 'mob_', 'npc_') WHERE `ScriptName` LIKE 'mob\_%';
+UPDATE `creature_template` SET `ScriptName` = REPLACE(`ScriptName`, 'mobs_', 'npc_') WHERE `ScriptName` LIKE 'mobs\_%';
+UPDATE `spell_script_names` SET `ScriptName`='spell_trash_npc_glacial_strike' WHERE `ScriptName`='spell_trash_mob_glacial_strike';
+
author	Vincent-Michael <Vincent_Michael@gmx.de>	2013-07-04 23:08:02 +0200
committer	Vincent-Michael <Vincent_Michael@gmx.de>	2013-07-04 23:08:02 +0200
commit	644e75487d6eb160c940ef43d9e2047b4d419730 (patch)
tree	115b060bc8e6523efa28afeaac27f3fca50b4627 /sql
parent	ece52c11d251593d0ee0b8c2e23e6747fb0bfbd1 (diff)
parent	b4d4e04f53b447a7b6cfba1c7161d9c987260265 (diff)