aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authormegamage <none@none>2009-09-02 15:42:40 -0500
committermegamage <none@none>2009-09-02 15:42:40 -0500
commit0c0a7b6b0ee55aa1c58a82b2afdc48614f3342bc (patch)
tree38b20ab7a9ef0dd38dd7f572c8f4dee165ad1f7f /sql/updates
parentf49754447b51f6b25b61e3067a2b40508dd60116 (diff)
[8444] Prevent spawn gameobjects with invalid displayid by command. Author: VladimirMangos
Also fix mangos string for not existed gameobejct entry. --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/5552_8444_world_trinity_string.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/5552_8444_world_trinity_string.sql b/sql/updates/5552_8444_world_trinity_string.sql
new file mode 100644
index 00000000000..0d41fadfbae
--- /dev/null
+++ b/sql/updates/5552_8444_world_trinity_string.sql
@@ -0,0 +1,6 @@
+-- ALTER TABLE db_version CHANGE COLUMN required_8416_01_mangos_spell_learn_spell required_8444_01_mangos_mangos_string bit;
+
+DELETE FROM trinity_string WHERE entry IN(348,522);
+INSERT INTO trinity_string VALUES
+(348,'Game Object (Entry: %u) have invalid data and can\'t be spawned',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(522,'Game Object (Entry: %u) not found',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);