DB/SQL: Fix SQL errors

5 files changed, 5 insertions, 4 deletions

diff --git a/sql/updates/world/2011_02_20_2_world_instance_icecrown_citadel.sql b/sql/updates/world/2011_02_20_2_world_instance_icecrown_citadel.sql
index 1db8c50eae7..b41ab10d6f5 100644
--- a/sql/updates/world/2011_02_20_2_world_instance_icecrown_citadel.sql
+++ b/sql/updates/world/2011_02_20_2_world_instance_icecrown_citadel.sql
@@ -39,7 +39,7 @@ INSERT INTO `linked_respawn` (`guid`,`linkedGuid`,`linkType`) VALUES
 (151767,@GUID+07,0); -- Crok Scourgebane
 
 SET @EQUIP := 2423;
-DELETE FROM `creature_equip_template` WHERE `entry`=@EQUIP;
+DELETE FROM `creature_equip_template` WHERE `entry` BETWEEN @EQUIP AND @EQUIP+3;
 INSERT INTO `creature_equip_template` (`entry`,`equipentry1`,`equipentry2`,`equipentry3`) VALUES
 (@EQUIP+0,45128,0,0),
 (@EQUIP+1,47519,0,0),
diff --git a/sql/updates/world/2011_02_27_2_world_npc_spellclick_spells.sql b/sql/updates/world/2011_02_27_2_world_npc_spellclick_spells.sql
index 7e03126fdb5..dd08b5c1821 100644
--- a/sql/updates/world/2011_02_27_2_world_npc_spellclick_spells.sql
+++ b/sql/updates/world/2011_02_27_2_world_npc_spellclick_spells.sql
@@ -1,4 +1,4 @@
-DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN(28781,27894,32627,32629,28366,28312,28319,28366,28094,27881);
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN(28781,27894,32627,32629,28366,28312,28319,28094,27881);
 INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`quest_end`,`cast_flags`,`aura_required`,`aura_forbidden`,`user_type`) VALUES
 (28781,60683,0,0,0,1,0,0,0),  -- Battleground Demolisher
 (27894,60682,0,0,0,1,0,0,0),  -- Antipersonnel Cannon
@@ -7,6 +7,5 @@ INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest
 (28366,60962,0,0,0,1,0,0,0),  -- Wintergrasp Tower Cannon
 (28312,46598,0,0,0,1,0,0,0),  -- Wintergrasp Siege Engine
 (28319,46598,0,0,0,1,0,0,0),  -- Wintergrasp Siege Turret
-(28366,60962,0,0,0,1,0,0,0),  -- Wintergrasp Tower Cannon
 (28094,60968,0,0,0,1,0,0,0),  -- Wintergrasp Demolisher
 (27881,60968,0,0,0,1,0,0,0);  -- Wintergrasp Catapult
diff --git a/sql/updates/world/2011_02_38_5_world_vehicles.sql b/sql/updates/world/2011_02_38_5_world_vehicles.sql
index 7611f9c19e6..9ef6e21cb3b 100644
--- a/sql/updates/world/2011_02_38_5_world_vehicles.sql
+++ b/sql/updates/world/2011_02_38_5_world_vehicles.sql
@@ -1,5 +1,5 @@
 -- Argent Tournament mounts implementation
-SET @GUID = 200000;
+SET @GUID = 151783;
 UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216,`speed_run`=1.5714285714286 WHERE `entry`=33870; -- Stabled Argent Warhorse
 UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216,`speed_run`=1.5714285714286 WHERE `entry`=33790; -- Stabled Exodar Elekk
 UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216,`speed_run`=1.5714285714286 WHERE `entry`=33791; -- Stabled Silvermoon Hawkstrider
diff --git a/sql/updates/world/2011_02_38_6_world_gameobject.sql b/sql/updates/world/2011_02_38_6_world_gameobject.sql
new file mode 100644
index 00000000000..37fddc83ce6
--- /dev/null
+++ b/sql/updates/world/2011_02_38_6_world_gameobject.sql
@@ -0,0 +1 @@
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 200000 AND 200000+6 AND `id`=300008; -- Wrong GUIDs for Tournament Stables
diff --git a/sql/updates/world/2011_02_38_7_world_creature_template.sql b/sql/updates/world/2011_02_38_7_world_creature_template.sql
new file mode 100644
index 00000000000..03d89220052
--- /dev/null
+++ b/sql/updates/world/2011_02_38_7_world_creature_template.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216 WHERE `entry` IN (31748,32795,32796,34045); -- Dificully entries