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 /sql/updates/2.4.3_updates | |
| parent | 38261d19673c820a5a4565e0a6b859692357dc37 (diff) | |
*Add new line to end of sql files.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates/2.4.3_updates')
34 files changed, 34 insertions, 34 deletions
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); |
