From dbacf82a95e5863b05ec2ed547335e26d6693795 Mon Sep 17 00:00:00 2001
From: Supabad <none@none>
Date: Mon, 26 Jul 2010 11:08:44 +0200
Subject: Update Zul Farrak, add pyramid event. thanks to totoro requires db
 support

--HG--
branch : trunk
---
 sql/updates/9026_world_script_texts.sql | 7 +++++++
 sql/updates/9026_world_scriptname.sql   | 2 ++
 2 files changed, 9 insertions(+)
 create mode 100644 sql/updates/9026_world_script_texts.sql
 create mode 100644 sql/updates/9026_world_scriptname.sql

(limited to 'sql/updates')

diff --git a/sql/updates/9026_world_script_texts.sql b/sql/updates/9026_world_script_texts.sql
new file mode 100644
index 00000000000..bb73438c3a3
--- /dev/null
+++ b/sql/updates/9026_world_script_texts.sql
@@ -0,0 +1,7 @@
+-- script texts
+delete from script_texts where npc_entry in (7607,7604);
+insert into `script_texts` (`npc_entry`, `entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) values
+('7607','-1209000','Oh no! Here they come!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','1','0','Weegli Blastfuse SAY_WEEGLI_OHNO'),
+('7607','-1209001','OK. Here I go.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','1','0','Weegli Blastfuse SAY_WEEGLI_OK_I_GO'),
+('7604','-1209002','Placeholder 1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','1','0','Sergeant Bly SAY_1'),
+('7604','-1209003','Placeholder 2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','1','0','Sergeant Bly SAY_2');
diff --git a/sql/updates/9026_world_scriptname.sql b/sql/updates/9026_world_scriptname.sql
new file mode 100644
index 00000000000..2f1be0f46da
--- /dev/null
+++ b/sql/updates/9026_world_scriptname.sql
@@ -0,0 +1,2 @@
+-- script names
+update gameobject_template set scriptName = 'go_troll_cage' where entry >= 141070 and entry < 141075;
-- 
cgit v1.2.3