diff options
| author | megamage <none@none> | 2009-01-12 11:02:18 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2009-01-12 11:02:18 -0600 |
| commit | 90f30abd86b77c304f71b81476a9b86e948b190f (patch) | |
| tree | ae6d2c1374976204ca82451e67254c2c5edabce8 /sql/updates | |
| parent | 6daa23e39c28e13f366ce4e8a765d565a26bcca5 (diff) | |
| parent | 61b2ce7856924bcaa4fda4fe124cd2a019493dd3 (diff) | |
*Update to Trinity 843.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/741_characters.sql | 3 | ||||
| -rw-r--r-- | sql/updates/822_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/826_world_scripts.sql | 1 | ||||
| -rw-r--r-- | sql/updates/832_characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/833_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/834_world_scripts.sql | 1 | ||||
| -rw-r--r-- | sql/updates/837_world_scripts.sql | 1 | ||||
| -rw-r--r-- | sql/updates/838_world_scripts.sql | 3 | ||||
| -rw-r--r-- | sql/updates/839_world_scripts.sql | 1 | ||||
| -rw-r--r-- | sql/updates/840_world_scripts.sql | 1 | ||||
| -rw-r--r-- | sql/updates/841_world_scripts.sql | 1 | ||||
| -rw-r--r-- | sql/updates/842_world.sql | 5 |
12 files changed, 20 insertions, 2 deletions
diff --git a/sql/updates/741_characters.sql b/sql/updates/741_characters.sql index aeba6f8c9ac..4ce094e3e5f 100644 --- a/sql/updates/741_characters.sql +++ b/sql/updates/741_characters.sql @@ -1,4 +1,3 @@ -ALTER TABLE `gm_tickets` CHANGE `closed` `closed` tinyint(1) NOT NULL default '0'; -ALTER TABLE `gm_tickets` ADD `closed` bit(1) NOT NULL AFTER `timestamp`; +ALTER TABLE `gm_tickets` ADD `closed` tinyint(1) NOT NULL default '0' AFTER `timestamp`; ALTER TABLE `gm_tickets` ADD `assignedto` int(10) NOT NULL default '0' AFTER `timestamp`; diff --git a/sql/updates/822_world_scripts.sql b/sql/updates/822_world_scripts.sql new file mode 100644 index 00000000000..0102336e31f --- /dev/null +++ b/sql/updates/822_world_scripts.sql @@ -0,0 +1,2 @@ +update creature_template set scriptname='npc_kayra_longmane' where entry=17969; +delete from creature_template_addon where entry=17969;
\ No newline at end of file diff --git a/sql/updates/826_world_scripts.sql b/sql/updates/826_world_scripts.sql new file mode 100644 index 00000000000..b125225744f --- /dev/null +++ b/sql/updates/826_world_scripts.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName` = 'npc_ruul_snowhoof' WHERE `entry` = 12818;
\ No newline at end of file diff --git a/sql/updates/832_characters.sql b/sql/updates/832_characters.sql new file mode 100644 index 00000000000..1330aef891e --- /dev/null +++ b/sql/updates/832_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `gm_tickets` CHANGE `closed` `closed` tinyint(1) NOT NULL default '0';
\ No newline at end of file diff --git a/sql/updates/833_world_scripts.sql b/sql/updates/833_world_scripts.sql new file mode 100644 index 00000000000..ad68e7a1da0 --- /dev/null +++ b/sql/updates/833_world_scripts.sql @@ -0,0 +1,2 @@ +update creature_template set scriptname='npc_dirty_larry', unit_flags=0, flags_extra=0 where entry=19720; +update creature_template set unit_flags=0, flags_extra=0 where entry in (19726, 19725);
\ No newline at end of file diff --git a/sql/updates/834_world_scripts.sql b/sql/updates/834_world_scripts.sql new file mode 100644 index 00000000000..14b3d74340e --- /dev/null +++ b/sql/updates/834_world_scripts.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_ishanah' WHERE `entry`=18538;
\ No newline at end of file diff --git a/sql/updates/837_world_scripts.sql b/sql/updates/837_world_scripts.sql new file mode 100644 index 00000000000..9146566cf18 --- /dev/null +++ b/sql/updates/837_world_scripts.sql @@ -0,0 +1 @@ +update creature_template set scriptname='npc_khadgar' where entry=18166;
\ No newline at end of file diff --git a/sql/updates/838_world_scripts.sql b/sql/updates/838_world_scripts.sql new file mode 100644 index 00000000000..ef963ffb168 --- /dev/null +++ b/sql/updates/838_world_scripts.sql @@ -0,0 +1,3 @@ +insert into `spell_script_target` values +('42222','1','23616'); +update `creature_template` set `scriptname`='npc_kyle_frenzied' where `entry`='23616';
\ No newline at end of file diff --git a/sql/updates/839_world_scripts.sql b/sql/updates/839_world_scripts.sql new file mode 100644 index 00000000000..722737ea3b0 --- /dev/null +++ b/sql/updates/839_world_scripts.sql @@ -0,0 +1 @@ +update creature_template set scriptname='npc_wizzlecrank_shredder' where entry=3439;
\ No newline at end of file diff --git a/sql/updates/840_world_scripts.sql b/sql/updates/840_world_scripts.sql new file mode 100644 index 00000000000..8b0140b6dbb --- /dev/null +++ b/sql/updates/840_world_scripts.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `spell1` = 0, `flags_extra` = 0, `ScriptName` = 'npc_volcano' WHERE `entry` = 23085;
\ No newline at end of file diff --git a/sql/updates/841_world_scripts.sql b/sql/updates/841_world_scripts.sql new file mode 100644 index 00000000000..f23cb8f8cc8 --- /dev/null +++ b/sql/updates/841_world_scripts.sql @@ -0,0 +1 @@ +update creature_template set scriptname='npc_greengill_slave' where entry=25084;
\ No newline at end of file diff --git a/sql/updates/842_world.sql b/sql/updates/842_world.sql new file mode 100644 index 00000000000..953dff584a0 --- /dev/null +++ b/sql/updates/842_world.sql @@ -0,0 +1,5 @@ +ALTER TABLE `areatrigger_teleport` +ADD `heroic_required_quest_done` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0 AFTER `heroic_key2`, +ADD `heroic_required_failed_quest_text` TEXT NULL DEFAULT NULL AFTER `heroic_required_quest_done`; + +UPDATE `areatrigger_teleport` SET `heroic_required_quest_done` = 11492, `heroic_required_failed_quest_text` = 'Heroic Difficulty requires completion of the "Hard to Kill" quest.' WHERE `id` = 4887;
\ No newline at end of file |