aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorzxbiohazardzx <zxbiohazardzx@gmail.com>2011-11-20 16:55:43 +0100
committerZxBiohazardZx <zxbiohazardzx@gmail.com>2011-11-20 16:55:43 +0100
commit85c44aa1d533951f789240224a7d38c325dd3095 (patch)
treef865eb321a87e59f8226a91b54427b283e1753c1
parent7d1bfb5dbdbdf3f8eff747b64078d72eddf84941 (diff)
DB/Commit: Revert 2011_11_20_11_world_sai.sql
-rw-r--r--sql/updates/world/2011_11_20_14_world_revert.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2011_11_20_14_world_revert.sql b/sql/updates/world/2011_11_20_14_world_revert.sql
new file mode 100644
index 00000000000..067c750b694
--- /dev/null
+++ b/sql/updates/world/2011_11_20_14_world_revert.sql
@@ -0,0 +1,4 @@
+-- revert 2011_11_20_11_world_sai.sql
+SET @ENTRY := 26503;
+UPDATE `creature_template` SET `AIName`='',`npcflag`=`npcflag`&~1,`IconName`='' WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`= @ENTRY AND `source_type`=0;