aboutsummaryrefslogtreecommitdiff
path: root/sql/tools
diff options
context:
space:
mode:
authormegamage <none@none>2009-06-11 23:47:27 -0500
committermegamage <none@none>2009-06-11 23:47:27 -0500
commite826716b582e03f708e6479b5b8329504a08bd1f (patch)
tree0bd713c49a40c80838b07c4658fa2596b5f6a0dd /sql/tools
parent3d452042d8bb539cb188bd00a80f8931dd456a5d (diff)
*Add a sql to remove all destructible buildings from the world. You need this if you do not have a 31x db to prevent client crash.
--HG-- branch : trunk
Diffstat (limited to 'sql/tools')
-rw-r--r--sql/tools/world_remove_all_destructible_buildings.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/tools/world_remove_all_destructible_buildings.sql b/sql/tools/world_remove_all_destructible_buildings.sql
new file mode 100644
index 00000000000..0eba66895fe
--- /dev/null
+++ b/sql/tools/world_remove_all_destructible_buildings.sql
@@ -0,0 +1 @@
+delete from gameobject where id IN (select entry from gameobject_template where type=33); \ No newline at end of file