From e85e4c386b76e345cf615c743a3268408d72bffb Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Fri, 8 May 2009 18:47:27 -0500
Subject: [7796] Implement .lookup taxinode and .go taxinode commands. Author:
 VladimirMangos

--HG--
branch : trunk
---
 sql/updates/7782_01_mangos_spell_proc_event.sql.obs | 4 ++++
 sql/updates/7796_01_mangos_command.sql              | 7 +++++++
 sql/updates/7796_02_mangos_mangos_string.sql        | 8 ++++++++
 3 files changed, 19 insertions(+)
 create mode 100644 sql/updates/7782_01_mangos_spell_proc_event.sql.obs
 create mode 100644 sql/updates/7796_01_mangos_command.sql
 create mode 100644 sql/updates/7796_02_mangos_mangos_string.sql

(limited to 'sql/updates')

diff --git a/sql/updates/7782_01_mangos_spell_proc_event.sql.obs b/sql/updates/7782_01_mangos_spell_proc_event.sql.obs
new file mode 100644
index 00000000000..8efa5573b3c
--- /dev/null
+++ b/sql/updates/7782_01_mangos_spell_proc_event.sql.obs
@@ -0,0 +1,4 @@
+ALTER TABLE db_version CHANGE COLUMN required_7777_01_mangos_spell_proc_event required_7782_01_mangos_spell_proc_event bit;
+
+DELETE FROM spell_proc_event WHERE entry = 34074;
+INSERT INTO spell_proc_event VALUES (34074, 0, 9, 522819, 8917121, 513, 0, 0, 0, 0, 0);
\ No newline at end of file
diff --git a/sql/updates/7796_01_mangos_command.sql b/sql/updates/7796_01_mangos_command.sql
new file mode 100644
index 00000000000..0a5c7c34221
--- /dev/null
+++ b/sql/updates/7796_01_mangos_command.sql
@@ -0,0 +1,7 @@
+ALTER TABLE db_version CHANGE COLUMN required_7782_01_mangos_spell_proc_event required_7796_01_mangos_command bit;
+
+DELETE FROM `command` WHERE `name` IN ('go taxinode','lookup taxinode');
+
+INSERT INTO `command` VALUES
+('go taxinode',1,'Syntax: .go taxinode #taxinode\r\n\r\nTeleport player to taxinode coordinates. You can look up zone using .lookup taxinode $namepart'),
+('lookup taxinode',3,'Syntax: .lookup taxinode $substring\r\n\r\nSearch and output all taxinodes with provide $substring in name.');
diff --git a/sql/updates/7796_02_mangos_mangos_string.sql b/sql/updates/7796_02_mangos_mangos_string.sql
new file mode 100644
index 00000000000..ae47b9803a5
--- /dev/null
+++ b/sql/updates/7796_02_mangos_mangos_string.sql
@@ -0,0 +1,8 @@
+ALTER TABLE db_version CHANGE COLUMN required_7796_01_mangos_command required_7796_02_mangos_mangos_string bit;
+
+DELETE FROM mangos_string WHERE entry IN(347,466,1128,1129);
+INSERT INTO mangos_string VALUES
+(347,'TaxiNode ID %u not found!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(466,'No taxinodes found!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(1128,'%d - |cffffffff|Htaxinode:%u|h[%s %s]|h|r (Map:%u X:%f Y:%f Z:%f)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(1129,'%d - %s %s (Map:%u X:%f Y:%f Z:%f)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
-- 
cgit v1.2.3