diff options
| author | Kudlaty <none@none> | 2009-06-15 03:31:11 +0200 |
|---|---|---|
| committer | Kudlaty <none@none> | 2009-06-15 03:31:11 +0200 |
| commit | 6f1a4247a4261d7f61f2b246e4a39f5e8a9334f7 (patch) | |
| tree | 6f9d670bfba212fa20f4e0ae6da2dc07b91ba779 /sql/updates | |
| parent | 678fffd4929766f21880530ab212fa8a8f93ac46 (diff) | |
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
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/4006_sd2.sql | 10 |
1 files changed, 10 insertions, 0 deletions
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'); |