From 6f1a4247a4261d7f61f2b246e4a39f5e8a9334f7 Mon Sep 17 00:00:00 2001 From: Kudlaty Date: Mon, 15 Jun 2009 03:31:11 +0200 Subject: Merge [SD2] r1010 Removed script for general marcus (can be done with eventAI) r1011 Fix typos. Should not assign value. Expected equal-to operator. r1012 Added support for quest 5561 r1013 Remove redundant directory path, already in include path - Skip. r1014 Remove old tables in SD2 database no longer used. Remove ScriptName for script 'mob_eventai' that does no longer exist - Skip r1015 Added PostgreSQL database create structure - Skip --HG-- branch : trunk --- sql/updates/4006_sd2.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/4006_sd2.sql (limited to 'sql/updates') diff --git a/sql/updates/4006_sd2.sql b/sql/updates/4006_sd2.sql new file mode 100644 index 00000000000..8ac01de7acf --- /dev/null +++ b/sql/updates/4006_sd2.sql @@ -0,0 +1,10 @@ +UPDATE creature_template SET ScriptName='' WHERE entry=466; +UPDATE script_texts SET content_default='UNUSED', language=0, comment='REUSE ME' WHERE entry=-1000005; + +UPDATE creature_template SET ScriptName='npc_aged_dying_ancient_kodo' WHERE entry IN (4700, 4701, 4702, 11627); + +DELETE FROM script_texts WHERE entry BETWEEN -1000430 AND -1000428; +INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES +(-1000428, 'Ah...the wondrous sound of kodos. I love the way they make the ground shake... inspect the beast for me.',0,0,0,0,'kodo round SAY_SMEED_HOME_1'), +(-1000429, 'Hey, look out with that kodo! You had better inspect that beast before i give you credit!',0,0,0,0,'kodo round SAY_SMEED_HOME_2'), +(-1000430, 'That kodo sure is a beauty. Wait a minute, where are my bifocals? Perhaps you should inspect the beast for me.',0,0,0,0,'kodo round SAY_SMEED_HOME_3'); -- cgit v1.2.3