diff options
| author | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-09-21 13:47:57 +0200 |
|---|---|---|
| committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-09-21 13:47:57 +0200 |
| commit | e592a7bdbbcab5c82ddae49619cbe32bebb5278f (patch) | |
| tree | 1ab03c8e7e967812d33c851801b796afce2cddf1 /sql/old/4.3.4 | |
| parent | 267e95dfe6c85d3191dbc874c9198be68df64553 (diff) | |
TDB 434.08 - 2014/09/21
Diffstat (limited to 'sql/old/4.3.4')
5 files changed, 16 insertions, 0 deletions
diff --git a/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_08_29_00_world_trinity_string_434.sql b/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_08_29_00_world_trinity_string_434.sql new file mode 100644 index 00000000000..547cca013bd --- /dev/null +++ b/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_08_29_00_world_trinity_string_434.sql @@ -0,0 +1,4 @@ +-- .guild info command strings +DELETE FROM `trinity_string` WHERE `entry`=1184; +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES +(1184, '| Guild Level: %u'); diff --git a/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_09_10_00_world_creature_template_434.sql b/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_09_10_00_world_creature_template_434.sql new file mode 100644 index 00000000000..05600243180 --- /dev/null +++ b/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_09_10_00_world_creature_template_434.sql @@ -0,0 +1 @@ +ALTER TABLE `creature_template` ADD COLUMN `HealthModifierExtra` FLOAT DEFAULT 1 NOT NULL AFTER `HealthModifier`; diff --git a/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_09_12_00_world_spell_script_names_434.sql b/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_09_12_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..1d467ed75a4 --- /dev/null +++ b/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_09_12_00_world_spell_script_names_434.sql @@ -0,0 +1,8 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=88665; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (88665, 'spell_ruumbos_silly_dance'); + +DELETE FROM `spell_script_names` WHERE `spell_id`=88254; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (88254, 'spell_swipe_honey'); + +DELETE FROM `spell_script_names` WHERE `spell_id` = 94064; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (94064, 'spell_beesbees'); diff --git a/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_09_14_03_world_creature_scriptname_434.sql b/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_09_14_03_world_creature_scriptname_434.sql new file mode 100644 index 00000000000..098cb81e36c --- /dev/null +++ b/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_09_14_03_world_creature_scriptname_434.sql @@ -0,0 +1,2 @@ +-- Whisperwind Lasher Scriptname +UPDATE `creature_template` SET `AIName`="", `ScriptName`="npc_whisperwind_lasher" WHERE `entry`=47747; diff --git a/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_09_21_00_world_spell_dbc_434.sql b/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_09_21_00_world_spell_dbc_434.sql new file mode 100644 index 00000000000..62199ab05b9 --- /dev/null +++ b/sql/old/4.3.4/TDB7_to_TDB8_updates/world/2014_09_21_00_world_spell_dbc_434.sql @@ -0,0 +1 @@ +ALTER TABLE `spelleffect_dbc` ADD `EffectItemType` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectDieSides`; |