aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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;