diff options
author | hunteee <none@none> | 2009-06-18 19:24:22 +0200 |
---|---|---|
committer | hunteee <none@none> | 2009-06-18 19:24:22 +0200 |
commit | c790caec69ecf1992e4b0098e1da08abe903d328 (patch) | |
tree | 87ad69d00aa31004a9922182424336d8577006a5 | |
parent | 38261d19673c820a5a4565e0a6b859692357dc37 (diff) |
*Add new line to end of sql files.
--HG--
branch : trunk
54 files changed, 54 insertions, 54 deletions
diff --git a/sql/tools/world_remove_all_destructible_buildings.sql b/sql/tools/world_remove_all_destructible_buildings.sql index 0eba66895fe..f877502ac3a 100644 --- a/sql/tools/world_remove_all_destructible_buildings.sql +++ b/sql/tools/world_remove_all_destructible_buildings.sql @@ -1 +1 @@ -delete from gameobject where id IN (select entry from gameobject_template where type=33);
\ No newline at end of file +delete from gameobject where id IN (select entry from gameobject_template where type=33); diff --git a/sql/updates/2.4.3_updates/1073_world_scripts.sql b/sql/updates/2.4.3_updates/1073_world_scripts.sql index 5b75c1efad5..c8936739f1f 100644 --- a/sql/updates/2.4.3_updates/1073_world_scripts.sql +++ b/sql/updates/2.4.3_updates/1073_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_plains_vision' WHERE `entry`='2983';
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_plains_vision' WHERE `entry`='2983'; diff --git a/sql/updates/2.4.3_updates/1074_world_scripts.sql b/sql/updates/2.4.3_updates/1074_world_scripts.sql index 2863a1fb6aa..13061c0ee06 100644 --- a/sql/updates/2.4.3_updates/1074_world_scripts.sql +++ b/sql/updates/2.4.3_updates/1074_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_plucky' WHERE `entry` = '6626';
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_plucky' WHERE `entry` = '6626'; diff --git a/sql/updates/2.4.3_updates/1138_world.sql b/sql/updates/2.4.3_updates/1138_world.sql index 8ed14a211e2..610f97139a5 100644 --- a/sql/updates/2.4.3_updates/1138_world.sql +++ b/sql/updates/2.4.3_updates/1138_world.sql @@ -1 +1 @@ -INSERT INTO `spell_proc_event` VALUES (17619, 0x00, 13, 0x0000000000000000, 0x00008000, 0x00000000, 0.000000, 0.000000, 0);
\ No newline at end of file +INSERT INTO `spell_proc_event` VALUES (17619, 0x00, 13, 0x0000000000000000, 0x00008000, 0x00000000, 0.000000, 0.000000, 0); diff --git a/sql/updates/2.4.3_updates/1247_world.sql b/sql/updates/2.4.3_updates/1247_world.sql index 324e4b142c1..2e9a7088beb 100644 --- a/sql/updates/2.4.3_updates/1247_world.sql +++ b/sql/updates/2.4.3_updates/1247_world.sql @@ -1 +1 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'go_jump_a_tron' WHERE `entry` = 183146;
\ No newline at end of file +UPDATE `gameobject_template` SET `ScriptName` = 'go_jump_a_tron' WHERE `entry` = 183146; diff --git a/sql/updates/2.4.3_updates/1249_world.sql b/sql/updates/2.4.3_updates/1249_world.sql index 4799b67e540..6ce0e777210 100644 --- a/sql/updates/2.4.3_updates/1249_world.sql +++ b/sql/updates/2.4.3_updates/1249_world.sql @@ -1 +1 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184421;
\ No newline at end of file +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184421; diff --git a/sql/updates/2.4.3_updates/1261_world.sql b/sql/updates/2.4.3_updates/1261_world.sql index 8433b5137e3..3f97153d3dd 100644 --- a/sql/updates/2.4.3_updates/1261_world.sql +++ b/sql/updates/2.4.3_updates/1261_world.sql @@ -1 +1 @@ -UPDATE `gameobject_template` SET `scriptname` = 'go_sacred_fire_of_life' WHERE `entry` = 175944;
\ No newline at end of file +UPDATE `gameobject_template` SET `scriptname` = 'go_sacred_fire_of_life' WHERE `entry` = 175944; diff --git a/sql/updates/2.4.3_updates/1265_world.sql b/sql/updates/2.4.3_updates/1265_world.sql index 668718cd5f6..5b5b87523cc 100644 --- a/sql/updates/2.4.3_updates/1265_world.sql +++ b/sql/updates/2.4.3_updates/1265_world.sql @@ -1 +1 @@ -UPDATE `gameobject_template` SET `scriptname`='go_skull_pile' WHERE `entry`=185913;
\ No newline at end of file +UPDATE `gameobject_template` SET `scriptname`='go_skull_pile' WHERE `entry`=185913; diff --git a/sql/updates/2.4.3_updates/153_world.sql b/sql/updates/2.4.3_updates/153_world.sql index dbff1592850..d34320fccae 100644 --- a/sql/updates/2.4.3_updates/153_world.sql +++ b/sql/updates/2.4.3_updates/153_world.sql @@ -1 +1 @@ -update creature_template set flags_extra = 128 where entry = 12999;
\ No newline at end of file +update creature_template set flags_extra = 128 where entry = 12999; diff --git a/sql/updates/2.4.3_updates/175_world_scripts.sql b/sql/updates/2.4.3_updates/175_world_scripts.sql index d30601c4c9c..05b18132d17 100644 --- a/sql/updates/2.4.3_updates/175_world_scripts.sql +++ b/sql/updates/2.4.3_updates/175_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_defias_traitor' WHERE `entry`='467';
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_defias_traitor' WHERE `entry`='467'; diff --git a/sql/updates/2.4.3_updates/230_world_scripts.sql b/sql/updates/2.4.3_updates/230_world_scripts.sql index 34d3ee5707f..0c62a29702f 100644 --- a/sql/updates/2.4.3_updates/230_world_scripts.sql +++ b/sql/updates/2.4.3_updates/230_world_scripts.sql @@ -1 +1 @@ -update gameobject_template set scriptname = 'go_gilded_brazier' where entry = 181956;
\ No newline at end of file +update gameobject_template set scriptname = 'go_gilded_brazier' where entry = 181956; diff --git a/sql/updates/2.4.3_updates/238_world.sql b/sql/updates/2.4.3_updates/238_world.sql index c1180ca0abd..6e3c03a7586 100644 --- a/sql/updates/2.4.3_updates/238_world.sql +++ b/sql/updates/2.4.3_updates/238_world.sql @@ -1 +1 @@ -DELETE FROM trinity_string WHERE entry IN (453);
\ No newline at end of file +DELETE FROM trinity_string WHERE entry IN (453); diff --git a/sql/updates/2.4.3_updates/341_world.sql b/sql/updates/2.4.3_updates/341_world.sql index 7d1eb4a0c8d..248224f6656 100644 --- a/sql/updates/2.4.3_updates/341_world.sql +++ b/sql/updates/2.4.3_updates/341_world.sql @@ -1 +1 @@ -TRUNCATE TABLE playercreateinfo_item;
\ No newline at end of file +TRUNCATE TABLE playercreateinfo_item; diff --git a/sql/updates/2.4.3_updates/583_world_scripts.sql b/sql/updates/2.4.3_updates/583_world_scripts.sql index 45f8d80a244..2e43f16cd23 100644 --- a/sql/updates/2.4.3_updates/583_world_scripts.sql +++ b/sql/updates/2.4.3_updates/583_world_scripts.sql @@ -1 +1 @@ -UPDATE creature_template SET Scriptname='npc_ranger_lilatha' WHERE entry=16295;
\ No newline at end of file +UPDATE creature_template SET Scriptname='npc_ranger_lilatha' WHERE entry=16295; diff --git a/sql/updates/2.4.3_updates/667_world_scripts.sql b/sql/updates/2.4.3_updates/667_world_scripts.sql index 1da0cea44e1..411b3651be4 100644 --- a/sql/updates/2.4.3_updates/667_world_scripts.sql +++ b/sql/updates/2.4.3_updates/667_world_scripts.sql @@ -1 +1 @@ -update creature_template set scriptname='npc_professor_dabiri' where entry=20907;
\ No newline at end of file +update creature_template set scriptname='npc_professor_dabiri' where entry=20907; diff --git a/sql/updates/2.4.3_updates/679_world_scripts.sql b/sql/updates/2.4.3_updates/679_world_scripts.sql index 408eb77b046..ca020049e51 100644 --- a/sql/updates/2.4.3_updates/679_world_scripts.sql +++ b/sql/updates/2.4.3_updates/679_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_deathstalker_erland' WHERE `entry`=1978;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_deathstalker_erland' WHERE `entry`=1978; diff --git a/sql/updates/2.4.3_updates/691_world_scripts.sql b/sql/updates/2.4.3_updates/691_world_scripts.sql index 922f4b24fab..9493f71ca79 100644 --- a/sql/updates/2.4.3_updates/691_world_scripts.sql +++ b/sql/updates/2.4.3_updates/691_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_earthmender_wilda' WHERE `entry`=21027;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_earthmender_wilda' WHERE `entry`=21027; diff --git a/sql/updates/2.4.3_updates/728_world_scripts.sql b/sql/updates/2.4.3_updates/728_world_scripts.sql index 8ada5080463..2d47af78d38 100644 --- a/sql/updates/2.4.3_updates/728_world_scripts.sql +++ b/sql/updates/2.4.3_updates/728_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_apprentice_mirveda' WHERE `entry`=15402;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_apprentice_mirveda' WHERE `entry`=15402; diff --git a/sql/updates/2.4.3_updates/733_characters.sql b/sql/updates/2.4.3_updates/733_characters.sql index 21c3d27e782..03b553b0d7b 100644 --- a/sql/updates/2.4.3_updates/733_characters.sql +++ b/sql/updates/2.4.3_updates/733_characters.sql @@ -1 +1 @@ -ALTER TABLE `gm_tickets` ADD `name` varchar(15) NOT NULL AFTER `playerGuid`;
\ No newline at end of file +ALTER TABLE `gm_tickets` ADD `name` varchar(15) NOT NULL AFTER `playerGuid`; diff --git a/sql/updates/2.4.3_updates/739_characters.sql b/sql/updates/2.4.3_updates/739_characters.sql index 8a4e9197494..bb656d73cd9 100644 --- a/sql/updates/2.4.3_updates/739_characters.sql +++ b/sql/updates/2.4.3_updates/739_characters.sql @@ -1 +1 @@ -ALTER TABLE `gm_tickets` ADD `comment` text(0) NOT NULL;
\ No newline at end of file +ALTER TABLE `gm_tickets` ADD `comment` text(0) NOT NULL; diff --git a/sql/updates/2.4.3_updates/747_world.sql b/sql/updates/2.4.3_updates/747_world.sql index 0fd9c3552e4..2c041294523 100644 --- a/sql/updates/2.4.3_updates/747_world.sql +++ b/sql/updates/2.4.3_updates/747_world.sql @@ -1 +1 @@ -UPDATE `trinity_string` SET `content_default`='Ticket %d is already assigned.' WHERE `entry`=2008;
\ No newline at end of file +UPDATE `trinity_string` SET `content_default`='Ticket %d is already assigned.' WHERE `entry`=2008; diff --git a/sql/updates/2.4.3_updates/789_world.sql b/sql/updates/2.4.3_updates/789_world.sql index 475e16538d1..48311e1a62c 100644 --- a/sql/updates/2.4.3_updates/789_world.sql +++ b/sql/updates/2.4.3_updates/789_world.sql @@ -1 +1 @@ -ALTER TABLE `eventai_texts` DROP COLUMN `emote`;
\ No newline at end of file +ALTER TABLE `eventai_texts` DROP COLUMN `emote`; diff --git a/sql/updates/2.4.3_updates/807_world_scripts.sql b/sql/updates/2.4.3_updates/807_world_scripts.sql index ee2cbee4fee..0804dcf3673 100644 --- a/sql/updates/2.4.3_updates/807_world_scripts.sql +++ b/sql/updates/2.4.3_updates/807_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_isla_starmane' WHERE `entry`=18760;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_isla_starmane' WHERE `entry`=18760; diff --git a/sql/updates/2.4.3_updates/826_world_scripts.sql b/sql/updates/2.4.3_updates/826_world_scripts.sql index 487971d092c..a5293ee8942 100644 --- a/sql/updates/2.4.3_updates/826_world_scripts.sql +++ b/sql/updates/2.4.3_updates/826_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_ruul_snowhoof' WHERE `entry`=12818;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_ruul_snowhoof' WHERE `entry`=12818; diff --git a/sql/updates/2.4.3_updates/82_world_scripts.sql b/sql/updates/2.4.3_updates/82_world_scripts.sql index acdfdd06a6f..c1521b0cf47 100644 --- a/sql/updates/2.4.3_updates/82_world_scripts.sql +++ b/sql/updates/2.4.3_updates/82_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_twiggy_flathead' WHERE `entry` =6248;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_twiggy_flathead' WHERE `entry` =6248; diff --git a/sql/updates/2.4.3_updates/834_world_scripts.sql b/sql/updates/2.4.3_updates/834_world_scripts.sql index 14b3d74340e..f9cdf4f982c 100644 --- a/sql/updates/2.4.3_updates/834_world_scripts.sql +++ b/sql/updates/2.4.3_updates/834_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_ishanah' WHERE `entry`=18538;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_ishanah' WHERE `entry`=18538; diff --git a/sql/updates/2.4.3_updates/837_world_scripts.sql b/sql/updates/2.4.3_updates/837_world_scripts.sql index 5fc2abfc4df..4746eb1b689 100644 --- a/sql/updates/2.4.3_updates/837_world_scripts.sql +++ b/sql/updates/2.4.3_updates/837_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_khadgar' WHERE `entry`=18166;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_khadgar' WHERE `entry`=18166; diff --git a/sql/updates/2.4.3_updates/839_world_scripts.sql b/sql/updates/2.4.3_updates/839_world_scripts.sql index 7b4ef66ba92..3820b21c9dc 100644 --- a/sql/updates/2.4.3_updates/839_world_scripts.sql +++ b/sql/updates/2.4.3_updates/839_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_wizzlecrank_shredder' WHERE `entry`=3439;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_wizzlecrank_shredder' WHERE `entry`=3439; diff --git a/sql/updates/2.4.3_updates/840_world_scripts.sql b/sql/updates/2.4.3_updates/840_world_scripts.sql index cfa3d492b9a..b9a2372bb78 100644 --- a/sql/updates/2.4.3_updates/840_world_scripts.sql +++ b/sql/updates/2.4.3_updates/840_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `spell1`=0, `flags_extra`=0, `ScriptName`='npc_volcano' WHERE `entry`=23085;
\ No newline at end of file +UPDATE `creature_template` SET `spell1`=0, `flags_extra`=0, `ScriptName`='npc_volcano' WHERE `entry`=23085; diff --git a/sql/updates/2.4.3_updates/841_world_scripts.sql b/sql/updates/2.4.3_updates/841_world_scripts.sql index 86d73ba2019..6208dd661c9 100644 --- a/sql/updates/2.4.3_updates/841_world_scripts.sql +++ b/sql/updates/2.4.3_updates/841_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_greengill_slave' WHERE `entry`=25084;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_greengill_slave' WHERE `entry`=25084; diff --git a/sql/updates/2.4.3_updates/850_world_scripts.sql b/sql/updates/2.4.3_updates/850_world_scripts.sql index 3027947cf14..0987e0285a6 100644 --- a/sql/updates/2.4.3_updates/850_world_scripts.sql +++ b/sql/updates/2.4.3_updates/850_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_bessy' WHERE `entry`=20415;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_bessy' WHERE `entry`=20415; diff --git a/sql/updates/2.4.3_updates/857_world_scripts.sql b/sql/updates/2.4.3_updates/857_world_scripts.sql index acd712aecb9..55b1ba4387d 100644 --- a/sql/updates/2.4.3_updates/857_world_scripts.sql +++ b/sql/updates/2.4.3_updates/857_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_kaya_flathoof' WHERE `entry`=11856;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_kaya_flathoof' WHERE `entry`=11856; diff --git a/sql/updates/2.4.3_updates/927_characters.sql b/sql/updates/2.4.3_updates/927_characters.sql index 6cbcf21e7bd..cf9df74b154 100644 --- a/sql/updates/2.4.3_updates/927_characters.sql +++ b/sql/updates/2.4.3_updates/927_characters.sql @@ -1 +1 @@ -ALTER TABLE `gm_tickets` CHANGE `closed` `closed` int(10) NOT NULL default '0';
\ No newline at end of file +ALTER TABLE `gm_tickets` CHANGE `closed` `closed` int(10) NOT NULL default '0'; diff --git a/sql/updates/2.4.3_updates/933_world_scripts.sql b/sql/updates/2.4.3_updates/933_world_scripts.sql index 1a3e9d96f56..0948dd8fd5a 100644 --- a/sql/updates/2.4.3_updates/933_world_scripts.sql +++ b/sql/updates/2.4.3_updates/933_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_snake_trap_serpents' WHERE `entry` IN (19921, 19833);
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_snake_trap_serpents' WHERE `entry` IN (19921, 19833); diff --git a/sql/updates/2.4.3_updates/973_world_scripts.sql b/sql/updates/2.4.3_updates/973_world_scripts.sql index ea997f917ff..b55409f7ea9 100644 --- a/sql/updates/2.4.3_updates/973_world_scripts.sql +++ b/sql/updates/2.4.3_updates/973_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_enraged_spirit' WHERE `entry` IN (21050, 21061, 21060, 21059);
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_enraged_spirit' WHERE `entry` IN (21050, 21061, 21060, 21059); diff --git a/sql/updates/3.0.9_old/1206_world_scripts.sql b/sql/updates/3.0.9_old/1206_world_scripts.sql index b35e054f57c..b1e0d611b7c 100644 --- a/sql/updates/3.0.9_old/1206_world_scripts.sql +++ b/sql/updates/3.0.9_old/1206_world_scripts.sql @@ -1 +1 @@ -UPDATE `gameobject_template` SET `ScriptName`='go_legion_obelisk' WHERE `entry` IN (185193,185195,185196,185197,185198);
\ No newline at end of file +UPDATE `gameobject_template` SET `ScriptName`='go_legion_obelisk' WHERE `entry` IN (185193,185195,185196,185197,185198); diff --git a/sql/updates/3.0.9_old/1307_world.sql b/sql/updates/3.0.9_old/1307_world.sql index ec7c218c0a1..d4f245a6a0a 100644 --- a/sql/updates/3.0.9_old/1307_world.sql +++ b/sql/updates/3.0.9_old/1307_world.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_stormwind_harbor_taxi' WHERE `entry`=29154;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_stormwind_harbor_taxi' WHERE `entry`=29154; diff --git a/sql/updates/3.0.9_old/1350_world_scripts.sql b/sql/updates/3.0.9_old/1350_world_scripts.sql index 193c03394a6..ab8abe57534 100644 --- a/sql/updates/3.0.9_old/1350_world_scripts.sql +++ b/sql/updates/3.0.9_old/1350_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `mindmg`=700, `maxdmg`=1200, `attackpower`=1000, `flags_extra`=196641 WHERE `entry`=23418;
\ No newline at end of file +UPDATE `creature_template` SET `mindmg`=700, `maxdmg`=1200, `attackpower`=1000, `flags_extra`=196641 WHERE `entry`=23418; diff --git a/sql/updates/3.0.9_old/1654_world.sql b/sql/updates/3.0.9_old/1654_world.sql index 3e45462aa7f..466c0e01f05 100644 --- a/sql/updates/3.0.9_old/1654_world.sql +++ b/sql/updates/3.0.9_old/1654_world.sql @@ -1 +1 @@ -INSERT INTO `spell_proc_event` VALUES (17619, 0x00, 13, 0x00000000, 0x00000000, 0x00000000, 0x00008000, 0x00000000, 0.000000, 0.000000, 0);
\ No newline at end of file +INSERT INTO `spell_proc_event` VALUES (17619, 0x00, 13, 0x00000000, 0x00000000, 0x00000000, 0x00008000, 0x00000000, 0.000000, 0.000000, 0); diff --git a/sql/updates/3.0.9_old/1727_world.sql b/sql/updates/3.0.9_old/1727_world.sql index 07089e166b0..208dd497e14 100644 --- a/sql/updates/3.0.9_old/1727_world.sql +++ b/sql/updates/3.0.9_old/1727_world.sql @@ -1 +1 @@ -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (42857,1,23954);
\ No newline at end of file +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (42857,1,23954); diff --git a/sql/updates/3.0.9_old/1825_world.sql b/sql/updates/3.0.9_old/1825_world.sql index 3b40e758455..9548a529cdd 100644 --- a/sql/updates/3.0.9_old/1825_world.sql +++ b/sql/updates/3.0.9_old/1825_world.sql @@ -1 +1 @@ -INSERT INTO `spell_linked_spell` VALUES (-47953, 60406, 0, 'Divine hymn buff to enemies');
\ No newline at end of file +INSERT INTO `spell_linked_spell` VALUES (-47953, 60406, 0, 'Divine hymn buff to enemies'); diff --git a/sql/updates/3.0.9_old/1884_world.sql b/sql/updates/3.0.9_old/1884_world.sql index 227e9c826c3..137639704e9 100644 --- a/sql/updates/3.0.9_old/1884_world.sql +++ b/sql/updates/3.0.9_old/1884_world.sql @@ -1 +1 @@ -DELETE FROM `trinity_string` WHERE `entry` IN (10056, 10057);
\ No newline at end of file +DELETE FROM `trinity_string` WHERE `entry` IN (10056, 10057); diff --git a/sql/updates/3.0.9_old/2508_characters.sql b/sql/updates/3.0.9_old/2508_characters.sql index 33d49010b93..2ab9c8ecd93 100644 --- a/sql/updates/3.0.9_old/2508_characters.sql +++ b/sql/updates/3.0.9_old/2508_characters.sql @@ -1 +1 @@ -DROP TABLE IF EXISTS `has_logged_in_before`;
\ No newline at end of file +DROP TABLE IF EXISTS `has_logged_in_before`; diff --git a/sql/updates/3.0.9_old/2683_characters_gm_tickets.sql b/sql/updates/3.0.9_old/2683_characters_gm_tickets.sql index d7a668c4b89..688e151b430 100644 --- a/sql/updates/3.0.9_old/2683_characters_gm_tickets.sql +++ b/sql/updates/3.0.9_old/2683_characters_gm_tickets.sql @@ -1 +1 @@ -ALTER TABLE `gm_tickets` ADD COLUMN `createtime` int(10) NOT NULL after `message`;
\ No newline at end of file +ALTER TABLE `gm_tickets` ADD COLUMN `createtime` int(10) NOT NULL after `message`; diff --git a/sql/updates/3.0.9_old/2724_TC1_world_1371_script.sql b/sql/updates/3.0.9_old/2724_TC1_world_1371_script.sql index c101373eb4e..39dab9882d0 100644 --- a/sql/updates/3.0.9_old/2724_TC1_world_1371_script.sql +++ b/sql/updates/3.0.9_old/2724_TC1_world_1371_script.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_unkor_the_ruthless' WHERE `entry` = 18262;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'mob_unkor_the_ruthless' WHERE `entry` = 18262; diff --git a/sql/updates/3008_1437_TC1_world_scripts.sql b/sql/updates/3008_1437_TC1_world_scripts.sql index f4e4b7a1e9a..0eacd5240ee 100644 --- a/sql/updates/3008_1437_TC1_world_scripts.sql +++ b/sql/updates/3008_1437_TC1_world_scripts.sql @@ -1 +1 @@ -UPDATE `gameobject_template` SET `ScriptName`='go_ethereum_prison' WHERE `entry` IN (184418,184419,184420,184421,184422,184423,184424,184425,184426,184427,184428,184429,184430,184431);
\ No newline at end of file +UPDATE `gameobject_template` SET `ScriptName`='go_ethereum_prison' WHERE `entry` IN (184418,184419,184420,184421,184422,184423,184424,184425,184426,184427,184428,184429,184430,184431); diff --git a/sql/updates/3075_TC1_1465_world_scripts.sql b/sql/updates/3075_TC1_1465_world_scripts.sql index 8ffe4aa1333..ca1d88f5b5c 100644 --- a/sql/updates/3075_TC1_1465_world_scripts.sql +++ b/sql/updates/3075_TC1_1465_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_fiendish_imp' WHERE `entry` = 17267;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'mob_fiendish_imp' WHERE `entry` = 17267; diff --git a/sql/updates/3121_world_scripts.sql b/sql/updates/3121_world_scripts.sql index acd97805eb9..23e5adaf191 100644 --- a/sql/updates/3121_world_scripts.sql +++ b/sql/updates/3121_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_dragonflayer_forge_master' WHERE `entry` =24079;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_dragonflayer_forge_master' WHERE `entry` =24079; diff --git a/sql/updates/3358_world_spell_bonus_data.sql b/sql/updates/3358_world_spell_bonus_data.sql index 5f06839a164..e2cb0aa706b 100644 --- a/sql/updates/3358_world_spell_bonus_data.sql +++ b/sql/updates/3358_world_spell_bonus_data.sql @@ -1 +1 @@ -UPDATE `spell_bonus_data` SET `direct_bonus` = '0.6453' WHERE `spell_bonus_data`.`entry` =33763;
\ No newline at end of file +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.6453' WHERE `spell_bonus_data`.`entry` =33763; diff --git a/sql/updates/3363_characters_characters.sql b/sql/updates/3363_characters_characters.sql index 521481b22d3..121e5347c3f 100644 --- a/sql/updates/3363_characters_characters.sql +++ b/sql/updates/3363_characters_characters.sql @@ -1 +1 @@ -ALTER TABLE `characters` ADD COLUMN `instance_id` int(11) unsigned NOT NULL default '0' AFTER `map`;
\ No newline at end of file +ALTER TABLE `characters` ADD COLUMN `instance_id` int(11) unsigned NOT NULL default '0' AFTER `map`; diff --git a/sql/updates/3393_world_spell_proc_event.sql b/sql/updates/3393_world_spell_proc_event.sql index b6781bfa1c5..7593080a248 100644 --- a/sql/updates/3393_world_spell_proc_event.sql +++ b/sql/updates/3393_world_spell_proc_event.sql @@ -1 +1 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN (53651);
\ No newline at end of file +DELETE FROM `spell_proc_event` WHERE `entry` IN (53651); diff --git a/sql/updates/3596_world_scripts.sql b/sql/updates/3596_world_scripts.sql index 5b1174b1437..14eafdb22db 100644 --- a/sql/updates/3596_world_scripts.sql +++ b/sql/updates/3596_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_death_knight_initiate' WHERE `entry`=28406;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_death_knight_initiate' WHERE `entry`=28406; diff --git a/sql/updates/3851_characters_aura.sql b/sql/updates/3851_characters_aura.sql index 966665ac776..762f8b795b3 100644 --- a/sql/updates/3851_characters_aura.sql +++ b/sql/updates/3851_characters_aura.sql @@ -1 +1 @@ -DELETE FROM `character_aura` WHERE `spell` IN (48714,57806);
\ No newline at end of file +DELETE FROM `character_aura` WHERE `spell` IN (48714,57806); diff --git a/sql/updates/3869_world_access_requirement.sql b/sql/updates/3869_world_access_requirement.sql index 4ead0543c48..d6ccad3e197 100644 --- a/sql/updates/3869_world_access_requirement.sql +++ b/sql/updates/3869_world_access_requirement.sql @@ -1 +1 @@ -ALTER TABLE `access_requirement` ADD COLUMN `heroic_level_min` tinyint(3) unsigned NOT NULL default '0' AFTER `level_min`;
\ No newline at end of file +ALTER TABLE `access_requirement` ADD COLUMN `heroic_level_min` tinyint(3) unsigned NOT NULL default '0' AFTER `level_min`; |