diff options
208 files changed, 200 insertions, 213 deletions
diff --git a/sql/FULL/world_script_texts.sql b/sql/FULL/world_script_texts.sql index ac9c534417d..00a08ee9628 100644 --- a/sql/FULL/world_script_texts.sql +++ b/sql/FULL/world_script_texts.sql @@ -2200,4 +2200,3 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, (-1609284, 'charges towards the Lich King, Ashbringer in hand and strikes the Lich King.',0,2,0,0,'Highlord Tirion Fordring'), (-1609285, 'disappears. Tirion walks over to where Darion lay',0,2,0,0,'The Lich King'), (-1609286, 'Light washes over the chapel î“ž the Light of Dawn is uncovered.',0,2,0,0,''); - diff --git a/sql/FULL/world_script_waypoints.sql b/sql/FULL/world_script_waypoints.sql index b5f41285fd4..4feb92f4f93 100644 --- a/sql/FULL/world_script_waypoints.sql +++ b/sql/FULL/world_script_waypoints.sql @@ -1537,4 +1537,5 @@ INSERT INTO script_waypoint VALUES (29173, 6, 2281.461, -5263.014, 81.164, 0, 'charge to lich king'), (29173, 7, 2257.479, -5296.702, 82.165, 0, 'being kicked by Lich King'), (29173, 8, 2261.237, -5294.983, 82.167, 0, 'throw'), - (29173, 9, 2259.34, -5294.379, 82.167, 0, 'event end');
\ No newline at end of file + (29173, 9, 2259.34, -5294.379, 82.167, 0, 'event end'); +
\ No newline at end of file diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index 741f4273e0c..1974aaac240 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -1303,4 +1303,4 @@ insert into `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, (10675, 0, 10, 17318, 90000, '-5139.79','-11248.27','5.23', '6.27609'); -- geezle should not spawn by default -update creature set spawnMask=0 where guid = 85587;
\ No newline at end of file +update creature set spawnMask=0 where guid = 85587; diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql index a36ad7c0527..330e1ecc2c3 100644 --- a/sql/FULL/world_spell_full.sql +++ b/sql/FULL/world_spell_full.sql @@ -2287,4 +2287,4 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES UPDATE creature_template SET VehicleId = 165 , spell1 = 56091,spell2 = 56092,spell3 = 57090,spell4 = 57143 ,spell5 = 57108,spell6=57403, unit_class = 1, minhealth = 100000, maxhealth = 100000 WHERE entry = 32535; UPDATE creature_template SET armor = 9729, mindmg = 422, maxdmg=586, minrangedmg=345, maxrangedmg=509, attackpower=642, rangedattackpower=103 WHERE entry = 32535; -update creature set DeathState = 0 where id = 26219;
\ No newline at end of file +update creature set DeathState = 0 where id = 26219; diff --git a/sql/characters.sql b/sql/characters.sql index e56bc26cd08..8ff9616c487 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -1630,4 +1630,4 @@ UNLOCK TABLES; -- Dump completed on 2008-01-10 11:37:06 --- Updated on 2003-02-22 01:44:45
\ No newline at end of file +-- Updated on 2003-02-22 01:44:45 diff --git a/sql/create_mysql.sql b/sql/create_mysql.sql index f71ced7d07d..dc272ebf697 100644 --- a/sql/create_mysql.sql +++ b/sql/create_mysql.sql @@ -11,4 +11,3 @@ GRANT ALL PRIVILEGES ON `world` . * TO 'trinity'@'localhost' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON `characters` . * TO 'trinity'@'localhost' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON `realmd` . * TO 'trinity'@'localhost' WITH GRANT OPTION; - diff --git a/sql/tools/world_merge_db/world_merge_creature.sql b/sql/tools/world_merge_db/world_merge_creature.sql index 88803de7cf2..91f9c3f9335 100644 --- a/sql/tools/world_merge_db/world_merge_creature.sql +++ b/sql/tools/world_merge_db/world_merge_creature.sql @@ -49,4 +49,3 @@ UPDATE `merge_creature`, `creature_template` SET ALTER TABLE merge_creature DROP COLUMN guid_new; INSERT creature SELECT * FROM merge_creature; - diff --git a/sql/updates/0000_3.0.9_old.sql b/sql/updates/0000_3.0.9_old.sql index 6076c0193a1..daa56fa6373 100644 --- a/sql/updates/0000_3.0.9_old.sql +++ b/sql/updates/0000_3.0.9_old.sql @@ -4325,4 +4325,4 @@ INSERT INTO `trinity_string` VALUES -- 2997_world_trinity_string DELETE FROM `trinity_string` WHERE `entry` = 5010; INSERT INTO `trinity_string` VALUES -(5010,'linkGUID: %u, Entry: %u (%s)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file +(5010,'linkGUID: %u, Entry: %u (%s)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); diff --git a/sql/updates/2.4.3_updates/123_world_scripts.sql b/sql/updates/2.4.3_updates/123_world_scripts.sql index 7281193a208..b5f9305e30e 100644 --- a/sql/updates/2.4.3_updates/123_world_scripts.sql +++ b/sql/updates/2.4.3_updates/123_world_scripts.sql @@ -213,4 +213,3 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, -- -- ALTER TABLE `script_texts` ORDER BY `entry` desc; - diff --git a/sql/updates/2.4.3_updates/285_world.sql b/sql/updates/2.4.3_updates/285_world.sql index 1b810cdb970..39451ecd1ed 100644 --- a/sql/updates/2.4.3_updates/285_world.sql +++ b/sql/updates/2.4.3_updates/285_world.sql @@ -34,5 +34,4 @@ INSERT INTO `trinity_string` VALUES (746,'The Alliance Team is running out of reinforcements!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (747,'The Horde Team is running out of reinforcements!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (748,'The Frostwolf General is Dead!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(749,'The Stormpike General is Dead!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL) -; +(749,'The Stormpike General is Dead!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); diff --git a/sql/updates/2.4.3_updates/389_world.sql b/sql/updates/2.4.3_updates/389_world.sql index 9e199c37726..89094143f64 100644 --- a/sql/updates/2.4.3_updates/389_world.sql +++ b/sql/updates/2.4.3_updates/389_world.sql @@ -7,4 +7,3 @@ INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `commen -- INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-49011, 49009, 0, 'Wyvern Sting'); -- Rank 6 (not available till wotlk) -- INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-49012, 49010, 0, 'Wyvern Sting'); - diff --git a/sql/updates/3649_world.sql b/sql/updates/3649_world.sql index bc40d7f6438..c50d778ae4a 100644 --- a/sql/updates/3649_world.sql +++ b/sql/updates/3649_world.sql @@ -2,4 +2,4 @@ UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entr UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_stasis' WHERE `entry` BETWEEN 185465 AND 185467; UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_stasis' WHERE `entry` = 184595; UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_stasis' WHERE `entry` BETWEEN 185461 AND 185464; -UPDATE `creature_template` SET `ScriptName` = 'npc_engineering_tele_trinket' WHERE `entry` IN (14742, 14743, 21493, 21494);
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_engineering_tele_trinket' WHERE `entry` IN (14742, 14743, 21493, 21494); diff --git a/sql/updates/3689_TC1_1534_world.sql b/sql/updates/3689_TC1_1534_world.sql index 774e0f7ec1b..cde0c50bf3b 100644 --- a/sql/updates/3689_TC1_1534_world.sql +++ b/sql/updates/3689_TC1_1534_world.sql @@ -1,2 +1,2 @@ UPDATE `creature_template` SET `ScriptName` = 'mob_ethereal_apprentice' WHERE `entry` = 18430; -DELETE FROM `creature` WHERE `id` = 18431;
\ No newline at end of file +DELETE FROM `creature` WHERE `id` = 18431; diff --git a/sql/updates/3691_TC1_919_world.sql b/sql/updates/3691_TC1_919_world.sql index 02e35d5a423..644daa2776a 100644 --- a/sql/updates/3691_TC1_919_world.sql +++ b/sql/updates/3691_TC1_919_world.sql @@ -1,2 +1,2 @@ ALTER TABLE version - ADD `core_revision` varchar(120) AFTER `core_version`;
\ No newline at end of file + ADD `core_revision` varchar(120) AFTER `core_version`; diff --git a/sql/updates/3715_mangos_7932_01_characters_character_pet.sql b/sql/updates/3715_mangos_7932_01_characters_character_pet.sql index 7f272c92004..c141dca37ce 100644 --- a/sql/updates/3715_mangos_7932_01_characters_character_pet.sql +++ b/sql/updates/3715_mangos_7932_01_characters_character_pet.sql @@ -5,4 +5,5 @@ UPDATE character_pet UPDATE character_pet SET abdata = SUBSTRING_INDEX(SUBSTRING_INDEX(abdata,' ',(10-3)*2),' ',-(10-3-3)*2) - WHERE length(SUBSTRING_INDEX(abdata, ' ', 20)) < length(abdata) and length(SUBSTRING_INDEX(abdata, ' ', 21)) >= length(abdata);
\ No newline at end of file + WHERE length(SUBSTRING_INDEX(abdata, ' ', 20)) < length(abdata) and length(SUBSTRING_INDEX(abdata, ' ', 21)) >= length(abdata); +
\ No newline at end of file diff --git a/sql/updates/3724_world.sql b/sql/updates/3724_world.sql index 36c8a75c3d1..1269925e0ee 100644 --- a/sql/updates/3724_world.sql +++ b/sql/updates/3724_world.sql @@ -7,4 +7,4 @@ UPDATE creature_template SET `ScriptName`='npc_ros_dark_rider' WHERE `entry`=287 -- Spellclick spell to mount deathcharger DELETE FROM npc_spellclick_spells WHERE `npc_entry`=28782; INSERT INTO npc_spellclick_spells (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES -(28782, 52280, 12687, 3, 1);
\ No newline at end of file +(28782, 52280, 12687, 3, 1); diff --git a/sql/updates/3729_mangos_7938_01_realmd_account.sql b/sql/updates/3729_mangos_7938_01_realmd_account.sql index 01c16d0b0bb..05fde4e7eb7 100644 --- a/sql/updates/3729_mangos_7938_01_realmd_account.sql +++ b/sql/updates/3729_mangos_7938_01_realmd_account.sql @@ -1,4 +1,4 @@ /*ALTER TABLE realmd_db_version CHANGE COLUMN required_7867_01_realmd_account required_7938_01_realmd_account bit;*/ ALTER TABLE account - CHANGE id id int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier';
\ No newline at end of file + CHANGE id id int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier'; diff --git a/sql/updates/3736_world_spell_dk.sql b/sql/updates/3736_world_spell_dk.sql index 4aa0c6b557c..c4097fef37e 100644 --- a/sql/updates/3736_world_spell_dk.sql +++ b/sql/updates/3736_world_spell_dk.sql @@ -1,3 +1,3 @@ DELETE FROM spell_area WHERE spell = 52693; INSERT INTO spell_area (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES -(52693, 4298, 12687, 1, 12687, 0, 0, 0, 1);
\ No newline at end of file +(52693, 4298, 12687, 1, 12687, 0, 0, 0, 1); diff --git a/sql/updates/3747_mangos_7945_01_quest_template.sql b/sql/updates/3747_mangos_7945_01_quest_template.sql index 8c32bceaf55..ab28ccd50f3 100644 --- a/sql/updates/3747_mangos_7945_01_quest_template.sql +++ b/sql/updates/3747_mangos_7945_01_quest_template.sql @@ -6,4 +6,4 @@ ALTER TABLE quest_template ADD COLUMN `OfferRewardEmoteDelay1` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmote4`, ADD COLUMN `OfferRewardEmoteDelay2` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay1`, ADD COLUMN `OfferRewardEmoteDelay3` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay2`, - ADD COLUMN `OfferRewardEmoteDelay4` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay3`;
\ No newline at end of file + ADD COLUMN `OfferRewardEmoteDelay4` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay3`; diff --git a/sql/updates/3791_characters_ahbot.sql b/sql/updates/3791_characters_ahbot.sql index 91dffb1f8c0..ead144c84a8 100644 --- a/sql/updates/3791_characters_ahbot.sql +++ b/sql/updates/3791_characters_ahbot.sql @@ -1,3 +1,4 @@ ALTER TABLE `auctionhousebot` DROP COLUMN `minTime`, - DROP COLUMN `maxTime`;
\ No newline at end of file + DROP COLUMN `maxTime`; +
\ No newline at end of file diff --git a/sql/updates/3801_world_spell.sql b/sql/updates/3801_world_spell.sql index 5ca6a9ba95a..8fabcad1c58 100644 --- a/sql/updates/3801_world_spell.sql +++ b/sql/updates/3801_world_spell.sql @@ -4,4 +4,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell DELETE FROM `spell_affect` WHERE `entry` IN (44544); INSERT INTO `spell_affect` (`entry`, `effectId`, `SpellClassMask0`, `SpellClassMask1`, `SpellClassMask2`) VALUES -(44544,0,685904631,1151048,0); -- Fingers of frost
\ No newline at end of file +(44544,0,685904631,1151048,0); -- Fingers of frost diff --git a/sql/updates/3808_world.sql b/sql/updates/3808_world.sql index 78498da4599..24ce276bd1e 100644 --- a/sql/updates/3808_world.sql +++ b/sql/updates/3808_world.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_salanar_the_horseman' WHERE `entry` = 28788;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_salanar_the_horseman' WHERE `entry` = 28788; diff --git a/sql/updates/3810_world_spell_bonus_data.sql b/sql/updates/3810_world_spell_bonus_data.sql index dd06d889e4f..1803687d6a4 100644 --- a/sql/updates/3810_world_spell_bonus_data.sql +++ b/sql/updates/3810_world_spell_bonus_data.sql @@ -91,4 +91,4 @@ INSERT INTO spell_bonus_data( entry, ap_bonus, comments ) VALUES ('50536', '0.013', 'DK - Unholy Blight (Rank1)'), ('51373', '0.013', 'DK - Unholy Blight (Rank2)'), ('51374', '0.013', 'DK - Unholy Blight (Rank3)'), -('51375', '0.013', 'DK - Unholy Blight (Rank4)');
\ No newline at end of file +('51375', '0.013', 'DK - Unholy Blight (Rank4)'); diff --git a/sql/updates/3813_world_spell_dk.sql b/sql/updates/3813_world_spell_dk.sql index 8b8afdccc12..2b438883157 100644 --- a/sql/updates/3813_world_spell_dk.sql +++ b/sql/updates/3813_world_spell_dk.sql @@ -5,4 +5,4 @@ UPDATE `creature_template` SET `ScriptName`='npc_dkc1_gothik' WHERE `entry`=2865 DELETE FROM `spell_script_target` WHERE entry IN (52479); INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (52479,1,28819), -(52479,1,28822);
\ No newline at end of file +(52479,1,28822); 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/3851_world_spell.sql b/sql/updates/3851_world_spell.sql index 4475c24f0e8..ed10e84808c 100644 --- a/sql/updates/3851_world_spell.sql +++ b/sql/updates/3851_world_spell.sql @@ -5,4 +5,4 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES ('48714', '2', '27235'), ('48714', '2', '27234'), ('48714', '2', '27236'), -('57806', '2', '31043');
\ No newline at end of file +('57806', '2', '31043'); diff --git a/sql/updates/3856_world_spell_naxx.sql b/sql/updates/3856_world_spell_naxx.sql index 725451fafd1..3b3895b3c4d 100644 --- a/sql/updates/3856_world_spell_naxx.sql +++ b/sql/updates/3856_world_spell_naxx.sql @@ -6,4 +6,4 @@ ON DUPLICATE KEY UPDATE baseattacktime = VALUES(baseattacktime), spell1 = VALUES(spell1), flags_extra = VALUES(flags_extra), -scriptname = VALUES(scriptname);
\ No newline at end of file +scriptname = VALUES(scriptname); 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`; diff --git a/sql/updates/3870_mangos_7980_01_world_item_required_target.sql b/sql/updates/3870_mangos_7980_01_world_item_required_target.sql index b80f5f9eac6..7853e496a2d 100644 --- a/sql/updates/3870_mangos_7980_01_world_item_required_target.sql +++ b/sql/updates/3870_mangos_7980_01_world_item_required_target.sql @@ -6,4 +6,4 @@ CREATE TABLE `item_required_target` ( `type` tinyint(3) unsigned NOT NULL default '0', `targetEntry` mediumint(8) unsigned NOT NULL default '0', UNIQUE KEY `entry_type_target` (`entry`,`type`,`targetEntry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
\ No newline at end of file +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; diff --git a/sql/updates/3873_world_spell_dk.sql b/sql/updates/3873_world_spell_dk.sql index 7c8b2abce78..142ec203ff2 100644 --- a/sql/updates/3873_world_spell_dk.sql +++ b/sql/updates/3873_world_spell_dk.sql @@ -25,4 +25,4 @@ UPDATE creature_template SET spell1=52211 WHERE entry=28864; DELETE FROM `spell_script_target` WHERE entry IN (52576); INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (52576,1,28834), -(52576,1,28886);
\ No newline at end of file +(52576,1,28886); diff --git a/sql/updates/3877_world_spell_script_target.sql b/sql/updates/3877_world_spell_script_target.sql index 9778be52466..57392c547d3 100644 --- a/sql/updates/3877_world_spell_script_target.sql +++ b/sql/updates/3877_world_spell_script_target.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_script_target` WHERE `entry` IN (48743); INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -('48743', '1', '26125');
\ No newline at end of file +('48743', '1', '26125'); diff --git a/sql/updates/3886_world_script_nexus.sql b/sql/updates/3886_world_script_nexus.sql index 031a314b8b6..eba67418eef 100644 --- a/sql/updates/3886_world_script_nexus.sql +++ b/sql/updates/3886_world_script_nexus.sql @@ -79,4 +79,4 @@ INSERT INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `langua (-1576041,'Now we\'ve come to the truth!',13453,1,0,0,'keristrasza SAY_SLAY'), (-1576042,'Finish it! FINISH IT! Kill me, or I swear by the Dragonqueen you\'ll never see daylight again!',13452,1,0,0,'keristrasza SAY_ENRAGE'), (-1576043,'Dragonqueen... Life-Binder... preserve... me.',13454,1,0,0,'keristrasza SAY_DEATH'), -(-1576044,'Stay. Enjoy your final moments.',13451,1,0,0,'keristrasza SAY_CRYSTAL_NOVA');
\ No newline at end of file +(-1576044,'Stay. Enjoy your final moments.',13451,1,0,0,'keristrasza SAY_CRYSTAL_NOVA'); diff --git a/sql/updates/3899_world_spell_proc_event.sql b/sql/updates/3899_world_spell_proc_event.sql index 968c82ec29b..bc8b159bd9a 100644 --- a/sql/updates/3899_world_spell_proc_event.sql +++ b/sql/updates/3899_world_spell_proc_event.sql @@ -1,4 +1,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (18096, 18073); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES (18096, 0x00, 5, 0x00000060, 0x00800080, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Pyroclasm (Rank 1) -(18073, 0x00, 5, 0x00000060, 0x00800080, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Pyroclasm (Rank 2)
\ No newline at end of file +(18073, 0x00, 5, 0x00000060, 0x00800080, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Pyroclasm (Rank 2) diff --git a/sql/updates/3903_world_spell_proc_event.sql b/sql/updates/3903_world_spell_proc_event.sql index 4f333311d2d..ab534ece0a8 100644 --- a/sql/updates/3903_world_spell_proc_event.sql +++ b/sql/updates/3903_world_spell_proc_event.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (56249); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(56249, 0x00, 5, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Felhunter
\ No newline at end of file +(56249, 0x00, 5, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Felhunter diff --git a/sql/updates/3910_world.sql b/sql/updates/3910_world.sql index 4ba20cb5f6e..2e0d54fc545 100644 --- a/sql/updates/3910_world.sql +++ b/sql/updates/3910_world.sql @@ -69,4 +69,4 @@ INSERT INTO `script_waypoint` VALUES (2917, 41, 4671.924316, 599.752197, 16.01242, 5000, 'SAY_REM_REMEMBER'), (2917, 42, 4676.976074, 600.649780, 17.82566, 5000, 'EMOTE_REM_END'); -UPDATE `creature_template` SET `ScriptName` = 'npc_myranda_the_hag' WHERE `entry` = 11872;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_myranda_the_hag' WHERE `entry` = 11872; diff --git a/sql/updates/3920_characters_309-313_converter.sql b/sql/updates/3920_characters_309-313_converter.sql index e9a19fed39f..1a711f3a027 100644 --- a/sql/updates/3920_characters_309-313_converter.sql +++ b/sql/updates/3920_characters_309-313_converter.sql @@ -60,4 +60,4 @@ UPDATE `characters` SET `data` = CONCAT( ) WHERE length(SUBSTRING_INDEX(data, ' ', 1700)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 1701)) >= length(data); UPDATE characters SET data = REPLACE(data,' ',' '); -UPDATE characters SET data = CONCAT(TRIM(data),' ');
\ No newline at end of file +UPDATE characters SET data = CONCAT(TRIM(data),' '); diff --git a/sql/updates/3920_world_309-313_converter.sql b/sql/updates/3920_world_309-313_converter.sql index 1d911e2c4b1..695748c3968 100644 --- a/sql/updates/3920_world_309-313_converter.sql +++ b/sql/updates/3920_world_309-313_converter.sql @@ -63,4 +63,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (47549,47551,47552); /* Serendipity, replace by aanother spell ids */ DELETE FROM `spell_proc_event` WHERE `entry` IN (47555,47556,47557); /* T.N.T. non triggring now */ -DELETE FROM `spell_proc_event` WHERE `entry` IN (56333,56336,56337);
\ No newline at end of file +DELETE FROM `spell_proc_event` WHERE `entry` IN (56333,56336,56337); diff --git a/sql/updates/3927_world_spell_proc_event.sql b/sql/updates/3927_world_spell_proc_event.sql index a3a6cf77083..526afb8c48c 100644 --- a/sql/updates/3927_world_spell_proc_event.sql +++ b/sql/updates/3927_world_spell_proc_event.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (59088, 59089, 58388, 56374); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES (59088, 0x00, 4, 0x00000000, 0x00000002, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Improved Spell Reflection (59089, 0x00, 4, 0x00000000, 0x00000002, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Improved Spell Reflection -(56374, 0x00, 3, 0x00000000, 0x00004000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0); -- Glyph of icy veins
\ No newline at end of file +(56374, 0x00, 3, 0x00000000, 0x00004000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0); -- Glyph of icy veins diff --git a/sql/updates/3943_world_spell_proc_event.sql b/sql/updates/3943_world_spell_proc_event.sql index 5776d411995..7d4c96caefe 100644 --- a/sql/updates/3943_world_spell_proc_event.sql +++ b/sql/updates/3943_world_spell_proc_event.sql @@ -5,4 +5,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (52610, -52610); INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES ( 52610, 62071, 0, 'Savage Roar'), -( -52610, -62071, 0, 'Savage Roar');
\ No newline at end of file +( -52610, -62071, 0, 'Savage Roar'); diff --git a/sql/updates/3947_world_spell_proc_event.sql b/sql/updates/3947_world_spell_proc_event.sql index 620e46603c5..6859fc95049 100644 --- a/sql/updates/3947_world_spell_proc_event.sql +++ b/sql/updates/3947_world_spell_proc_event.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (53397); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(53397, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Invigoration
\ No newline at end of file +(53397, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Invigoration diff --git a/sql/updates/3951_world_spell_proc_event.sql b/sql/updates/3951_world_spell_proc_event.sql index d2f6a2c7993..ec0d9d960d7 100644 --- a/sql/updates/3951_world_spell_proc_event.sql +++ b/sql/updates/3951_world_spell_proc_event.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (53646); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(53646, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Demonic Pact
\ No newline at end of file +(53646, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Demonic Pact diff --git a/sql/updates/3952_world_spell_pet_auras.sql b/sql/updates/3952_world_spell_pet_auras.sql index 9dd0b2a800e..ec9083db0a4 100644 --- a/sql/updates/3952_world_spell_pet_auras.sql +++ b/sql/updates/3952_world_spell_pet_auras.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_pet_auras` WHERE `spell` IN (18754, 18755, 18756); INSERT INTO `spell_pet_auras` VALUES (18754,65536,18754), (18755,65536,18755), -(18756,65536,18756);
\ No newline at end of file +(18756,65536,18756); diff --git a/sql/updates/3954_world_spell_bonus_data.sql b/sql/updates/3954_world_spell_bonus_data.sql index 7cf7f4bf032..6e35ce41a4a 100644 --- a/sql/updates/3954_world_spell_bonus_data.sql +++ b/sql/updates/3954_world_spell_bonus_data.sql @@ -7,4 +7,4 @@ INSERT INTO `spell_bonus_data` VALUES (53719, 0, 0, 0, "Paladin - Seal of the Martyr Proc Enemy"), (53718, 0, 0, 0, "Paladin - Seal of the Martyr Proc Self"), (53726, 0.25, 0, 0.16, "Paladin - Judgement of the Martyr Enemy"), -(53725, 0.0833, 0, 0.0533, "Paladin - Judgement of the Martyr Self");
\ No newline at end of file +(53725, 0.0833, 0, 0.0533, "Paladin - Judgement of the Martyr Self"); diff --git a/sql/updates/3956_world_spell_proc_event.sql b/sql/updates/3956_world_spell_proc_event.sql index 93d7b212d62..a7dcc25e025 100644 --- a/sql/updates/3956_world_spell_proc_event.sql +++ b/sql/updates/3956_world_spell_proc_event.sql @@ -1 +1 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN (49531,49532);
\ No newline at end of file +DELETE FROM `spell_proc_event` WHERE `entry` IN (49531,49532); diff --git a/sql/updates/3969_world_spell_proc_event.sql b/sql/updates/3969_world_spell_proc_event.sql index fcefd99dbd9..bca25a6ebe0 100644 --- a/sql/updates/3969_world_spell_proc_event.sql +++ b/sql/updates/3969_world_spell_proc_event.sql @@ -39,4 +39,4 @@ INSERT INTO `spell_proc_event`(`entry`, `SchoolMask`, `SpellFamilyName`, `SpellF (33297, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Quagmirrans Eye (38299, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 15), -- Fel Reavers Piston (59630, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Black Magic -(61356, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x000002A8, 0x00000002, 0, 0, 90); -- Invigorating Earthsiege Diamond
\ No newline at end of file +(61356, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x000002A8, 0x00000002, 0, 0, 90); -- Invigorating Earthsiege Diamond diff --git a/sql/updates/3991_world_spell_proc_event.sql b/sql/updates/3991_world_spell_proc_event.sql index 2defb092d52..95f9edf6232 100644 --- a/sql/updates/3991_world_spell_proc_event.sql +++ b/sql/updates/3991_world_spell_proc_event.sql @@ -23,4 +23,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 47535, 0x00, 6, 0x00000001, 0x00000000, 0x00000000, 0x00000400, 0x00002000, 0, 0, 12), -- Rapture (Rank 1) ( 47536, 0x00, 6, 0x00000001, 0x00000000, 0x00000000, 0x00000400, 0x00002000, 0, 0, 12), -- Rapture (Rank 2) ( 47537, 0x00, 6, 0x00000001, 0x00000000, 0x00000000, 0x00000400, 0x00002000, 0, 0, 12), -- Rapture (Rank 3) -( 63108, 0x00, 5, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Siphon Life
\ No newline at end of file +( 63108, 0x00, 5, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Siphon Life diff --git a/sql/updates/3998_sd2.sql b/sql/updates/3998_sd2.sql index a0601ab86ef..6927d6f7a65 100644 --- a/sql/updates/3998_sd2.sql +++ b/sql/updates/3998_sd2.sql @@ -4,4 +4,4 @@ INSERT INTO script_texts (entry,content_default,sound,type,language,emote,commen (-1000408, '%s eats his lunch.',0,2,0,0,'kyle EMOTE_EAT_LUNCH'), (-1000409, '%s thanks you with a special dance.',0,2,0,0,'kyle EMOTE_DANCE'); -UPDATE `creature_template` SET `ScriptName`='npc_kyle_frenzied' WHERE `entry`=23616;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_kyle_frenzied' WHERE `entry`=23616; diff --git a/sql/updates/3999_sd2.sql b/sql/updates/3999_sd2.sql index 2e09a329e4a..aefda08bd2e 100644 --- a/sql/updates/3999_sd2.sql +++ b/sql/updates/3999_sd2.sql @@ -2,4 +2,4 @@ DELETE FROM script_texts WHERE entry BETWEEN -1000342 AND -1000340; INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES (-1000340, 'We made it! Thanks, $N. I couldn''t have gotten without you.', 0, 0, 0, 0, 'npc_deathstalker_erland - SAY_THANKS'), (-1000341, 'It''s good to see you again, Erland. What is your report?', 0, 0, 0, 0, 'npc_deathstalker_erland - SAY_RANE'), -(-1000342, 'Masses of wolves are to the east, and whoever lived at Malden''s Orchard is gone.', 0, 0, 0, 0, 'npc_deathstalker_erland - SAY_ANSWER');
\ No newline at end of file +(-1000342, 'Masses of wolves are to the east, and whoever lived at Malden''s Orchard is gone.', 0, 0, 0, 0, 'npc_deathstalker_erland - SAY_ANSWER'); diff --git a/sql/updates/4002_world_spell_proc_event.sql b/sql/updates/4002_world_spell_proc_event.sql index cec219053e3..d426dc437cb 100644 --- a/sql/updates/4002_world_spell_proc_event.sql +++ b/sql/updates/4002_world_spell_proc_event.sql @@ -5,4 +5,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 50885, 0x00, 15, 0x00000000, 0x04000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Icy Talons ( 50886, 0x00, 15, 0x00000000, 0x04000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Icy Talons ( 50887, 0x00, 15, 0x00000000, 0x04000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Icy Talons -( 55610, 0x00, 15, 0x00000000, 0x04000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Improved Icy Talons
\ No newline at end of file +( 55610, 0x00, 15, 0x00000000, 0x04000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Improved Icy Talons diff --git a/sql/updates/4003_world_script_waypoint.sql b/sql/updates/4003_world_script_waypoint.sql index 410c06d4190..603115f72c0 100644 --- a/sql/updates/4003_world_script_waypoint.sql +++ b/sql/updates/4003_world_script_waypoint.sql @@ -25,4 +25,4 @@ INSERT INTO script_waypoint VALUES (17969, 22, -524.745483, 5443.945313, 20.977013, 0, ''), (17969, 23, -502.984985, 5446.283691, 22.149435, 0, ''), (17969, 24, -472.463959, 5449.546875, 22.561453, 0, ''), -(17969, 25, -454.533264, 5461.302246, 22.602837, 30000, 'quest complete');
\ No newline at end of file +(17969, 25, -454.533264, 5461.302246, 22.602837, 30000, 'quest complete'); diff --git a/sql/updates/4006_sd2.sql b/sql/updates/4006_sd2.sql index 49d341ce377..cfc72330f07 100644 --- a/sql/updates/4006_sd2.sql +++ b/sql/updates/4006_sd2.sql @@ -7,4 +7,4 @@ 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');
\ No newline at end of file +(-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'); diff --git a/sql/updates/4016_world_spell_dk.sql b/sql/updates/4016_world_spell_dk.sql index b478562f946..18e62cc1d20 100644 --- a/sql/updates/4016_world_spell_dk.sql +++ b/sql/updates/4016_world_spell_dk.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_script_target` WHERE entry IN(53110); INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -(53110,1,28940);
\ No newline at end of file +(53110,1,28940); diff --git a/sql/updates/4023_world_spell_proc_event.sql b/sql/updates/4023_world_spell_proc_event.sql index caa53b3c119..4a9c17edfdd 100644 --- a/sql/updates/4023_world_spell_proc_event.sql +++ b/sql/updates/4023_world_spell_proc_event.sql @@ -1,4 +1,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (51521, 51522); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES ( 51521, 0x00, 11, 0x00000000, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Improved Stormspike -( 51522, 0x00, 11, 0x00000000, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Improved Stormspike
\ No newline at end of file +( 51522, 0x00, 11, 0x00000000, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Improved Stormspike diff --git a/sql/updates/4030_world.sql b/sql/updates/4030_world.sql index 2e21be5c4c2..09041e6123c 100644 --- a/sql/updates/4030_world.sql +++ b/sql/updates/4030_world.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_nestlewood_owlkin' WHERE `entry`=16518;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_nestlewood_owlkin' WHERE `entry`=16518; diff --git a/sql/updates/4031_world_spell_proc_event.sql b/sql/updates/4031_world_spell_proc_event.sql index a68371bbaa5..f887ea24b9e 100644 --- a/sql/updates/4031_world_spell_proc_event.sql +++ b/sql/updates/4031_world_spell_proc_event.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (51698, 51700, 51701); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES ( 51698, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1), -- Honor Among Thieves ( 51700, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1), -- Honor Among Thieves -( 51701, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1); -- Honor Among Thieves
\ No newline at end of file +( 51701, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1); -- Honor Among Thieves diff --git a/sql/updates/4032_world_spell_proc_event.sql b/sql/updates/4032_world_spell_proc_event.sql index 238fd8d1ead..25c0b56ccdb 100644 --- a/sql/updates/4032_world_spell_proc_event.sql +++ b/sql/updates/4032_world_spell_proc_event.sql @@ -1,4 +1,4 @@ DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (51209, 50334); INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (51209, 55095, 1, 'Hungering cold - frost fever'), -(50334, 58923, 2, 'Berserk - modify target number aura');
\ No newline at end of file +(50334, 58923, 2, 'Berserk - modify target number aura'); diff --git a/sql/updates/4043_world_npc_spellclick_spells.sql b/sql/updates/4043_world_npc_spellclick_spells.sql index eceee12bc91..3b4a0ee7679 100644 --- a/sql/updates/4043_world_npc_spellclick_spells.sql +++ b/sql/updates/4043_world_npc_spellclick_spells.sql @@ -26,4 +26,4 @@ INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `qu DELETE FROM `spell_target_position` WHERE `id`=51852; INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES -(51852, 609, 2361.21, -5660.45, 503.828, 4.49);
\ No newline at end of file +(51852, 609, 2361.21, -5660.45, 503.828, 4.49); diff --git a/sql/updates/4045_world_spell_proc_event.sql b/sql/updates/4045_world_spell_proc_event.sql index 6104f0d0782..fc1034ec746 100644 --- a/sql/updates/4045_world_spell_proc_event.sql +++ b/sql/updates/4045_world_spell_proc_event.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (51483,51485,51486); INSERT INTO `spell_proc_event` VALUES (51483, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0.000000, 0.000000, 0), (51485, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0.000000, 0.000000, 0), -(51486, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0.000000, 0.000000, 0);
\ No newline at end of file +(51486, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0.000000, 0.000000, 0); diff --git a/sql/updates/4063_TC1_1569_world_scripts.sql b/sql/updates/4063_TC1_1569_world_scripts.sql index afe0759e711..5fc2287a851 100644 --- a/sql/updates/4063_TC1_1569_world_scripts.sql +++ b/sql/updates/4063_TC1_1569_world_scripts.sql @@ -1,3 +1,3 @@ -- Razorfen Kraul UPDATE `instance_template` SET `script` = 'instance_razorfen_kraul' WHERE `map` = '47' LIMIT 1; -UPDATE `creature_template` SET `ScriptName` = 'npc_deaths_head_ward_keeper' WHERE `entry` = '4625' LIMIT 1;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_deaths_head_ward_keeper' WHERE `entry` = '4625' LIMIT 1; diff --git a/sql/updates/4066_world_spell_proc_event.sql b/sql/updates/4066_world_spell_proc_event.sql index 00480d9d6d7..08adad1a28e 100644 --- a/sql/updates/4066_world_spell_proc_event.sql +++ b/sql/updates/4066_world_spell_proc_event.sql @@ -6,4 +6,4 @@ INSERT INTO `spell_proc_event` VALUES ( 64976, 0x00, 4, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Juggernaut ( 64343, 0x00, 3, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Impact ( 63158, 0x00, 5, 0x00000001, 0x00000040, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Decimation -( 63156, 0x00, 5, 0x00000001, 0x00000040, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Decimation
\ No newline at end of file +( 63156, 0x00, 5, 0x00000001, 0x00000040, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Decimation diff --git a/sql/updates/4081_world.sql b/sql/updates/4081_world.sql index 4eb5898681a..7f6528c6eb5 100644 --- a/sql/updates/4081_world.sql +++ b/sql/updates/4081_world.sql @@ -12,4 +12,4 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comm (57482,57484,2,'Kindred Spirits'), (57453,57483,2,'Kindred Spirits'), (57457,57482,2,'Kindred Spirits'), -(57458,57475,2,'Kindred Spirits');
\ No newline at end of file +(57458,57475,2,'Kindred Spirits'); diff --git a/sql/updates/4105_8030_01_characters_character_spell.sql b/sql/updates/4105_8030_01_characters_character_spell.sql index 332d0e4d071..5d65fce8ff2 100644 --- a/sql/updates/4105_8030_01_characters_character_spell.sql +++ b/sql/updates/4105_8030_01_characters_character_spell.sql @@ -4,4 +4,4 @@ UPDATE IGNORE character_spell SET spell = 64901 WHERE spell = 64904; -DELETE FROM character_spell WHERE spell = 64904;
\ No newline at end of file +DELETE FROM character_spell WHERE spell = 64904; diff --git a/sql/updates/4105_8030_02_characters_character_action.sql b/sql/updates/4105_8030_02_characters_character_action.sql index c3bf50933ea..5588350efe0 100644 --- a/sql/updates/4105_8030_02_characters_character_action.sql +++ b/sql/updates/4105_8030_02_characters_character_action.sql @@ -2,4 +2,4 @@ UPDATE character_action SET action = 64901 - WHERE action = 64904 AND type = '0';
\ No newline at end of file + WHERE action = 64904 AND type = '0'; diff --git a/sql/updates/4105_8030_03_mangos_npc_trainer.sql b/sql/updates/4105_8030_03_mangos_npc_trainer.sql index d8c7cf383c7..2b6f04b25e7 100644 --- a/sql/updates/4105_8030_03_mangos_npc_trainer.sql +++ b/sql/updates/4105_8030_03_mangos_npc_trainer.sql @@ -1,3 +1,3 @@ -- ALTER TABLE db_version CHANGE COLUMN required_8021_01_mangos_spell_proc_event required_8030_03_mangos_npc_trainer bit; -DELETE FROM npc_trainer WHERE spell = 64904;
\ No newline at end of file +DELETE FROM npc_trainer WHERE spell = 64904; diff --git a/sql/updates/4115_world_sd2.sql b/sql/updates/4115_world_sd2.sql index f538963a7d6..ede0c591d57 100644 --- a/sql/updates/4115_world_sd2.sql +++ b/sql/updates/4115_world_sd2.sql @@ -3,4 +3,4 @@ UPDATE creature_template SET ScriptName='boss_leotheras_the_blind_demonform' WHE UPDATE script_texts SET content_default='Finally, my banishment ends!' WHERE entry=-1548009; UPDATE script_texts SET content_default='Be gone, trifling elf. I am in control now!' WHERE entry=-1548010; -UPDATE script_texts SET content_default='No... no! What have you done? I am the master! Do you hear me? I am... aaggh! Can\'t... contain him...' WHERE entry=-1548018;
\ No newline at end of file +UPDATE script_texts SET content_default='No... no! What have you done? I am the master! Do you hear me? I am... aaggh! Can\'t... contain him...' WHERE entry=-1548018; diff --git a/sql/updates/4154_world_script.sql b/sql/updates/4154_world_script.sql index a87168e79ad..1372842790b 100644 --- a/sql/updates/4154_world_script.sql +++ b/sql/updates/4154_world_script.sql @@ -1 +1 @@ -UPDATE creature_template SET ScriptName='npc_air_force_bots' WHERE entry IN (2614, 2615, 21974, 21993, 21996, 21997, 21999, 22001, 22002, 22003, 22063, 22065, 22066, 22068, 22069, 22070, 22071, 22078, 22079, 22080, 22086, 22087, 22088, 22090, 22124, 22125, 22126);
\ No newline at end of file +UPDATE creature_template SET ScriptName='npc_air_force_bots' WHERE entry IN (2614, 2615, 21974, 21993, 21996, 21997, 21999, 22001, 22002, 22003, 22063, 22065, 22066, 22068, 22069, 22070, 22071, 22078, 22079, 22080, 22086, 22087, 22088, 22090, 22124, 22125, 22126); diff --git a/sql/updates/4159_world.sql b/sql/updates/4159_world.sql index a52e64998f8..00778695c76 100644 --- a/sql/updates/4159_world.sql +++ b/sql/updates/4159_world.sql @@ -11,4 +11,4 @@ INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `conte DELETE FROM `command` WHERE `name` = 'lookup map'; INSERT INTO `command` (`name`, `security`, `help`) VALUES -('lookup map', 3, 'Syntax: .lookup map $namepart\r\n\r\nLooks up a map by $namepart, and returns all matches with their map ID''s.');
\ No newline at end of file +('lookup map', 3, 'Syntax: .lookup map $namepart\r\n\r\nLooks up a map by $namepart, and returns all matches with their map ID''s.'); diff --git a/sql/updates/4174_world_script.sql b/sql/updates/4174_world_script.sql index b4b52f2fae2..3ed520e89ab 100644 --- a/sql/updates/4174_world_script.sql +++ b/sql/updates/4174_world_script.sql @@ -1 +1 @@ -UPDATE `instance_template` SET `script`='instance_blackfathom_deeps' WHERE `map`=48;
\ No newline at end of file +UPDATE `instance_template` SET `script`='instance_blackfathom_deeps' WHERE `map`=48; diff --git a/sql/updates/4176_world.sql b/sql/updates/4176_world.sql index be7c68354bb..8e471e16917 100644 --- a/sql/updates/4176_world.sql +++ b/sql/updates/4176_world.sql @@ -1,2 +1,2 @@ UPDATE `trinity_string` SET `content_default` = '[Raid reset time: %s]' WHERE `entry` = 5017; -UPDATE `trinity_string` SET `content_default` = '[Heroic reset time: %s]' WHERE `entry` = 5018;
\ No newline at end of file +UPDATE `trinity_string` SET `content_default` = '[Heroic reset time: %s]' WHERE `entry` = 5018; diff --git a/sql/updates/4209_characters_TDB.sql b/sql/updates/4209_characters_TDB.sql index 323c5eb69ee..a380d2a9e8a 100644 --- a/sql/updates/4209_characters_TDB.sql +++ b/sql/updates/4209_characters_TDB.sql @@ -1 +1 @@ -ALTER TABLE character_pet DROP COLUMN load_flags;
\ No newline at end of file +ALTER TABLE character_pet DROP COLUMN load_flags; diff --git a/sql/updates/4209_world_TDB.sql b/sql/updates/4209_world_TDB.sql index 139655550f7..6baca035d85 100644 --- a/sql/updates/4209_world_TDB.sql +++ b/sql/updates/4209_world_TDB.sql @@ -2,4 +2,4 @@ DELETE FROM trinity_string WHERE `entry` = 6616; DELETE FROM `command` WHERE `name` IN ('reset all','reset talents'); INSERT INTO `command` VALUES ('reset all',3,'Syntax: .reset all spells\r\n\r\nSyntax: .reset all talents\r\n\r\nRequest reset spells or talents (including talents for all character\'s pets if any) at next login each existed character.'), -('reset talents',3,'Syntax: .reset talents [Playername]\r\n Removes all talents of the targeted player or pet or named player. Playername can be name of offline character. With player talents also will be reset talents for all character\'s pets if any.');
\ No newline at end of file +('reset talents',3,'Syntax: .reset talents [Playername]\r\n Removes all talents of the targeted player or pet or named player. Playername can be name of offline character. With player talents also will be reset talents for all character\'s pets if any.'); diff --git a/sql/updates/4211_world.sql b/sql/updates/4211_world.sql index 67378358b0e..59c057bdb10 100644 --- a/sql/updates/4211_world.sql +++ b/sql/updates/4211_world.sql @@ -1,2 +1,2 @@ ALTER TABLE spell_pet_auras ADD effectId TINYINT( 3 ) UNSIGNED NOT NULL AFTER spell; -ALTER TABLE spell_pet_auras DROP PRIMARY KEY, ADD PRIMARY KEY(spell,effectId,pet);
\ No newline at end of file +ALTER TABLE spell_pet_auras DROP PRIMARY KEY, ADD PRIMARY KEY(spell,effectId,pet); diff --git a/sql/updates/4216_world.sql b/sql/updates/4216_world.sql index a3e7a29ca7c..e8fba8fbcbd 100644 --- a/sql/updates/4216_world.sql +++ b/sql/updates/4216_world.sql @@ -1,3 +1,3 @@ DELETE FROM `command` WHERE `name` IN ('modify tp'); INSERT INTO `command` VALUES -('modify tp',1,'Syntax: .modify tp #amount\r\n\r\nSte free talent pointes for selected character or character\'s pet. It will be reset to default expected at next levelup/login/quest reward.');
\ No newline at end of file +('modify tp',1,'Syntax: .modify tp #amount\r\n\r\nSte free talent pointes for selected character or character\'s pet. It will be reset to default expected at next levelup/login/quest reward.'); diff --git a/sql/updates/4217_world_spell_proc_event.sql b/sql/updates/4217_world_spell_proc_event.sql index 5bc4733d8aa..00df39c15e2 100644 --- a/sql/updates/4217_world_spell_proc_event.sql +++ b/sql/updates/4217_world_spell_proc_event.sql @@ -1 +1 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN (13165 ,14318, 14319, 14320, 14321, 14322, 25296, 27044, 61846, 61847);
\ No newline at end of file +DELETE FROM `spell_proc_event` WHERE `entry` IN (13165 ,14318, 14319, 14320, 14321, 14322, 25296, 27044, 61846, 61847); diff --git a/sql/updates/4222_world.sql b/sql/updates/4222_world.sql index 430b549db0c..88cba6a134b 100644 --- a/sql/updates/4222_world.sql +++ b/sql/updates/4222_world.sql @@ -10,4 +10,4 @@ INSERT INTO spell_pet_auras VALUES (56317, 1, 0, 57482), (56318, 0, 0, 57458), (56318, 1, 0, 57475); -DELETE FROM spell_linked_spell where `spell_trigger` in (57447,57482,57453, 57457, 57458);
\ No newline at end of file +DELETE FROM spell_linked_spell where `spell_trigger` in (57447,57482,57453, 57457, 57458); diff --git a/sql/updates/4225_world.sql b/sql/updates/4225_world.sql index dba1204b585..39aa777c6a9 100644 --- a/sql/updates/4225_world.sql +++ b/sql/updates/4225_world.sql @@ -6,4 +6,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (-5229); INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES -( -5229, -51185, 0, 'King of the Jungle - remove with enrage');
\ No newline at end of file +( -5229, -51185, 0, 'King of the Jungle - remove with enrage'); diff --git a/sql/updates/4233_world_spell_proc_event.sql b/sql/updates/4233_world_spell_proc_event.sql index e4b2a7bba60..52b3f278501 100644 --- a/sql/updates/4233_world_spell_proc_event.sql +++ b/sql/updates/4233_world_spell_proc_event.sql @@ -1 +1 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN (17794 ,17797, 17798, 17799, 17800, 55620, 55623, 58435);
\ No newline at end of file +DELETE FROM `spell_proc_event` WHERE `entry` IN (17794 ,17797, 17798, 17799, 17800, 55620, 55623, 58435); diff --git a/sql/updates/4234_world_spell_bonus_data_TDB.sql b/sql/updates/4234_world_spell_bonus_data_TDB.sql index 036691eb1b6..5bf95f4ba4f 100644 --- a/sql/updates/4234_world_spell_bonus_data_TDB.sql +++ b/sql/updates/4234_world_spell_bonus_data_TDB.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_bonus_data` WHERE `entry`='17962'; INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES -('17962', '0', '0', '0', 'Warlock - Conflagrate');
\ No newline at end of file +('17962', '0', '0', '0', 'Warlock - Conflagrate'); diff --git a/sql/updates/4258_world_TDB.sql b/sql/updates/4258_world_TDB.sql index b9466b68687..d9764e521b7 100644 --- a/sql/updates/4258_world_TDB.sql +++ b/sql/updates/4258_world_TDB.sql @@ -5,4 +5,4 @@ INSERT INTO `trinity_string` (`entry`, `content_default`)VALUES DELETE FROM `command` WHERE `name` = 'mute'; INSERT INTO `command` (`name`, `security`, `help`) VALUES -('mute', 1 ,'Syntax: .mute [$playerName] $timeInMinutes [$reason]\r\n\r\nDisible chat messaging for any character from account of character $playerName (or currently selected) at $timeInMinutes minutes. Player can be offline.');
\ No newline at end of file +('mute', 1 ,'Syntax: .mute [$playerName] $timeInMinutes [$reason]\r\n\r\nDisible chat messaging for any character from account of character $playerName (or currently selected) at $timeInMinutes minutes. Player can be offline.'); diff --git a/sql/updates/4276_world_TDB.sql b/sql/updates/4276_world_TDB.sql index 02afae2b74f..ea9df1a069b 100644 --- a/sql/updates/4276_world_TDB.sql +++ b/sql/updates/4276_world_TDB.sql @@ -11,4 +11,4 @@ REPLACE INTO gameobject_template VALUES (180102,6,266,"Neutral Banner Aura",""," REPLACE INTO gameobject_template VALUES (180101,6,1311,"Horde Banner Aura","","","",0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,""); REPLACE INTO gameobject_template VALUES (180421,6,2232,"Alliance Banner Aura, Large","","","",0,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,""); REPLACE INTO gameobject_template VALUES (180423,6,266,"Neutral Banner Aura, Large","","","",0,0,5,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,""); -REPLACE INTO gameobject_template VALUES (180422,6,1311,"Horde Banner Aura, Large","","","",0,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,"");
\ No newline at end of file +REPLACE INTO gameobject_template VALUES (180422,6,1311,"Horde Banner Aura, Large","","","",0,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,""); diff --git a/sql/updates/4283_world_TDB.sql b/sql/updates/4283_world_TDB.sql index 38a832dce7c..f17f0a489f8 100644 --- a/sql/updates/4283_world_TDB.sql +++ b/sql/updates/4283_world_TDB.sql @@ -79,4 +79,4 @@ INSERT INTO `pet_levelstats` (`creature_entry`, `level`, `hp`, `mana`, `armor`, ('26125','77','4380','2056','4342','172','92','89','96','84'), ('26125','78','4437','2082','4399','174','93','90','97','85'), ('26125','79','4494','2108','4456','176','94','91','98','86'), -('26125','80','4551','2134','4513','178','95','92','99','87');
\ No newline at end of file +('26125','80','4551','2134','4513','178','95','92','99','87'); diff --git a/sql/updates/4292_8072_01_characters_characters.sql b/sql/updates/4292_8072_01_characters_characters.sql index ddb639a78b1..663fc4840a3 100644 --- a/sql/updates/4292_8072_01_characters_characters.sql +++ b/sql/updates/4292_8072_01_characters_characters.sql @@ -7,4 +7,4 @@ ADD xp INT UNSIGNED NOT NULL default '0' AFTER level, ADD money INT UNSIGNED NOT NULL default '0' AFTER xp, ADD playerBytes INT UNSIGNED NOT NULL default '0' AFTER money, ADD playerBytes2 INT UNSIGNED NOT NULL default '0' AFTER playerBytes, -ADD playerFlags INT UNSIGNED NOT NULL default '0' AFTER playerBytes2;
\ No newline at end of file +ADD playerFlags INT UNSIGNED NOT NULL default '0' AFTER playerBytes2; diff --git a/sql/updates/4292_8072_02_characters_characters.sql b/sql/updates/4292_8072_02_characters_characters.sql index 14768b92e32..06fa04c6094 100644 --- a/sql/updates/4292_8072_02_characters_characters.sql +++ b/sql/updates/4292_8072_02_characters_characters.sql @@ -8,4 +8,4 @@ money = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 1145), ' ', -1) AS UNSIG playerBytes = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 154), ' ', -1) AS UNSIGNED), playerBytes2 = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 155), ' ', -1) AS UNSIGNED), playerFlags = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 151), ' ', -1) AS UNSIGNED) -WHERE LENGTH(SUBSTRING_INDEX(data, ' ', 1294)) < LENGTH(data) && LENGTH(data) <= LENGTH(SUBSTRING_INDEX(data, ' ', 1295));
\ No newline at end of file +WHERE LENGTH(SUBSTRING_INDEX(data, ' ', 1294)) < LENGTH(data) && LENGTH(data) <= LENGTH(SUBSTRING_INDEX(data, ' ', 1295)); diff --git a/sql/updates/4307_world_TDB.sql b/sql/updates/4307_world_TDB.sql index 24447c76ed7..93850038a8b 100644 --- a/sql/updates/4307_world_TDB.sql +++ b/sql/updates/4307_world_TDB.sql @@ -1,4 +1,4 @@ DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (16857); DELETE FROM `spell_bonus_data` WHERE `entry` IN (60089); INSERT INTO `spell_bonus_data` (entry, direct_bonus, dot_bonus, ap_bonus, comments) VALUES -(60089, 0, 0, 0.05, 'Faerie Fire (feral)');
\ No newline at end of file +(60089, 0, 0, 0.05, 'Faerie Fire (feral)'); diff --git a/sql/updates/4308_world_TDB.sql b/sql/updates/4308_world_TDB.sql index b3da988dc64..248bdef07c1 100644 --- a/sql/updates/4308_world_TDB.sql +++ b/sql/updates/4308_world_TDB.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_bonus_data` WHERE `entry` IN (20187); INSERT INTO `spell_bonus_data` (entry, direct_bonus, dot_bonus, ap_bonus, comments) VALUES -(20187, 0.4, 0, 0.25, 'Judgement of Righteousness');
\ No newline at end of file +(20187, 0.4, 0, 0.25, 'Judgement of Righteousness'); diff --git a/sql/updates/4321_world.sql b/sql/updates/4321_world.sql index 55f600907e3..33365e7aa43 100644 --- a/sql/updates/4321_world.sql +++ b/sql/updates/4321_world.sql @@ -33,4 +33,4 @@ INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `t DELETE FROM `spell_bonus_data` WHERE `entry` IN (20187); INSERT INTO `spell_bonus_data` (entry, direct_bonus, dot_bonus, ap_bonus, comments) VALUES -(20187, 0.4, 0, 0.25, 'Judgement of Righteousness');
\ No newline at end of file +(20187, 0.4, 0, 0.25, 'Judgement of Righteousness'); diff --git a/sql/updates/4346_8098_characters.sql b/sql/updates/4346_8098_characters.sql index 3329601679c..11a78566fbb 100644 --- a/sql/updates/4346_8098_characters.sql +++ b/sql/updates/4346_8098_characters.sql @@ -24,4 +24,4 @@ UPDATE character_pet UPDATE pet_spell - SET active = ( active >> 8);
\ No newline at end of file + SET active = ( active >> 8); diff --git a/sql/updates/4346_8098_world.sql b/sql/updates/4346_8098_world.sql index 9f9241c8fc5..ad81835b433 100644 --- a/sql/updates/4346_8098_world.sql +++ b/sql/updates/4346_8098_world.sql @@ -7,4 +7,4 @@ UPDATE playercreateinfo_action SET action = action | ( misc << 16 ); ALTER TABLE playercreateinfo_action - DROP COLUMN misc;
\ No newline at end of file + DROP COLUMN misc; diff --git a/sql/updates/4351_8104_01_characters.sql b/sql/updates/4351_8104_01_characters.sql index 63cb8a7161b..aa5ec776496 100644 --- a/sql/updates/4351_8104_01_characters.sql +++ b/sql/updates/4351_8104_01_characters.sql @@ -4,4 +4,4 @@ ALTER TABLE character_achievement ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE character_achievement_progress ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE character_declinedname ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; ALTER TABLE character_pet_declinedname ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -ALTER TABLE guild_eventlog ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT 'Guild Eventlog';
\ No newline at end of file +ALTER TABLE guild_eventlog ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT 'Guild Eventlog'; diff --git a/sql/updates/4352_spell_bonus_data_full.sql b/sql/updates/4352_spell_bonus_data_full.sql index a58b799e89c..8742309a790 100644 --- a/sql/updates/4352_spell_bonus_data_full.sql +++ b/sql/updates/4352_spell_bonus_data_full.sql @@ -284,4 +284,4 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus` (6353, 1.15, 0, 0, 'Warlock - Soul Fire'), (30294, 0, 0, 0, 'Warlock - Soul Leech'), (30108, 0, 0.2, 0, 'Warlock - Unstable Affliction'), -(31117, 1.8, 0, 0, 'Warlock - Unstable Affliction Dispell');
\ No newline at end of file +(31117, 1.8, 0, 0, 'Warlock - Unstable Affliction Dispell'); diff --git a/sql/updates/4356_world_spell_proc_event.sql b/sql/updates/4356_world_spell_proc_event.sql index 5d0dd11ce1f..1cfa00e989e 100644 --- a/sql/updates/4356_world_spell_proc_event.sql +++ b/sql/updates/4356_world_spell_proc_event.sql @@ -22,4 +22,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell (51486, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0.000000, 0.000000, 0), ( 56372, 0x00, 3, 0x00000000, 0x00000080, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Glyph of Ice Block ( 56374, 0x00, 3, 0x00000000, 0x00004000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Glyph of Icy Veins -( 61356, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 90); -- Invigorating Earthsiege Diamond Passive
\ No newline at end of file +( 61356, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 90); -- Invigorating Earthsiege Diamond Passive diff --git a/sql/updates/4360_world_spell_proc_event.sql b/sql/updates/4360_world_spell_proc_event.sql index bd9169a796e..eef5674f6fd 100644 --- a/sql/updates/4360_world_spell_proc_event.sql +++ b/sql/updates/4360_world_spell_proc_event.sql @@ -46,4 +46,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 64882, 0x00, 10, 0x00000000, 0x00100000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Item - Paladin T8 Protection 4P Bonus ( 64890, 0x00, 10, 0x00000000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Item - Paladin T8 Holy 2P Bonus ( 64908, 0x00, 6, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0x00000000, 0, 0, 0), -- Item - Priest T8 Shadow 4P Bonus -( 64912, 0x00, 6, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Item - Priest T8 Healer 4P Bonus
\ No newline at end of file +( 64912, 0x00, 6, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Item - Priest T8 Healer 4P Bonus diff --git a/sql/updates/4363_world_trinity_string.sql b/sql/updates/4363_world_trinity_string.sql index 78fc7d9da7e..949b337f589 100644 --- a/sql/updates/4363_world_trinity_string.sql +++ b/sql/updates/4363_world_trinity_string.sql @@ -1 +1 @@ -UPDATE `trinity_string` SET `content_default` = 'Player%s %s (guid: %u) Account: %s (id: %u) Email: %s GMLevel: %u Last IP: %s Last login: %s Latency: %ums' WHERE `entry` = 548;
\ No newline at end of file +UPDATE `trinity_string` SET `content_default` = 'Player%s %s (guid: %u) Account: %s (id: %u) Email: %s GMLevel: %u Last IP: %s Last login: %s Latency: %ums' WHERE `entry` = 548; diff --git a/sql/updates/4367_world_spell_proc_event.sql b/sql/updates/4367_world_spell_proc_event.sql index cb9e517c721..5eeacab4de3 100644 --- a/sql/updates/4367_world_spell_proc_event.sql +++ b/sql/updates/4367_world_spell_proc_event.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (51483, 51485, 51486); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES (51483, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000001, 0.000000, 0.000000, 0), (51485, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000001, 0.000000, 0.000000, 0), -(51486, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000001, 0.000000, 0.000000, 0);
\ No newline at end of file +(51486, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000001, 0.000000, 0.000000, 0); diff --git a/sql/updates/4371_world_spell_linked_spell.sql b/sql/updates/4371_world_spell_linked_spell.sql index ea6fc9a8f45..82d64c3f487 100644 --- a/sql/updates/4371_world_spell_linked_spell.sql +++ b/sql/updates/4371_world_spell_linked_spell.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (48384, 48395, 48396); INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (48384, 50170, 2, 'Improved Moonkin Form'), (48395, 50171, 2, 'Improved Moonkin Form'), -(48396, 50172, 2, 'Improved Moonkin Form');
\ No newline at end of file +(48396, 50172, 2, 'Improved Moonkin Form'); diff --git a/sql/updates/4377_world_spell_proc_event.sql b/sql/updates/4377_world_spell_proc_event.sql index 74e18131370..bc006708b82 100644 --- a/sql/updates/4377_world_spell_proc_event.sql +++ b/sql/updates/4377_world_spell_proc_event.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (53709, 53710, 53711); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES (53709, 2, 10, 16384, 0, 0, 0, 0, 0, 0, 0), (53710, 2, 10, 16384, 0, 0, 0, 0, 0, 0, 0), -(53711, 2, 10, 16384, 0, 0, 0, 0, 0, 0, 0);
\ No newline at end of file +(53711, 2, 10, 16384, 0, 0, 0, 0, 0, 0, 0); diff --git a/sql/updates/4382_8115_world_playercreateinfo_action.sql b/sql/updates/4382_8115_world_playercreateinfo_action.sql index 5f52a46d240..1af313a0626 100644 --- a/sql/updates/4382_8115_world_playercreateinfo_action.sql +++ b/sql/updates/4382_8115_world_playercreateinfo_action.sql @@ -355,4 +355,4 @@ INSERT INTO `playercreateinfo_action` VALUES (11,8,3,59548,0), (11,8,10,159,128), (11,8,11,4540,128), -(11,8,83,4540,128);
\ No newline at end of file +(11,8,83,4540,128); diff --git a/sql/updates/4392_world.sql b/sql/updates/4392_world.sql index 7be4514cb8c..e8a5bbdb562 100644 --- a/sql/updates/4392_world.sql +++ b/sql/updates/4392_world.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (20594); INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES -( 20594, 65116, 2, 'Stoneform');
\ No newline at end of file +( 20594, 65116, 2, 'Stoneform'); diff --git a/sql/updates/4393_world_spell_proc_event.sql b/sql/updates/4393_world_spell_proc_event.sql index 16c54e63ef7..9d2fb7d776a 100644 --- a/sql/updates/4393_world_spell_proc_event.sql +++ b/sql/updates/4393_world_spell_proc_event.sql @@ -5,4 +5,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 35100, 0x00, 9, 0x00001000, 0x00000000, 0x00000001, 0x00000000, 0x00000000, 0, 0, 0), -- Concussive Barrage ( 35102, 0x00, 9, 0x00001000, 0x00000000, 0x00000001, 0x00000000, 0x00000000, 0, 0, 0), -- Concussive Barrage ( 18119, 0x00, 5, 0x00000000, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Aftermath -( 18120, 0x00, 5, 0x00000000, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Aftermath
\ No newline at end of file +( 18120, 0x00, 5, 0x00000000, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Aftermath diff --git a/sql/updates/4394_world_spell_proc_event.sql b/sql/updates/4394_world_spell_proc_event.sql index c4346e2df58..babd3782fea 100644 --- a/sql/updates/4394_world_spell_proc_event.sql +++ b/sql/updates/4394_world_spell_proc_event.sql @@ -9,4 +9,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 25296, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0, 0, 0), -- Aspect of the Hawk ( 27044, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0, 0, 0), -- Aspect of the Hawk ( 61846, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0, 0, 0), -- Aspect of the Dragonhawk -( 61847, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0, 0, 0); -- Aspect of the Dragonhawk
\ No newline at end of file +( 61847, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0, 0, 0); -- Aspect of the Dragonhawk diff --git a/sql/updates/4397_world_playercreateinfo_spell_TDB.sql b/sql/updates/4397_world_playercreateinfo_spell_TDB.sql index 27508da6db5..5bc5689bbf1 100644 --- a/sql/updates/4397_world_playercreateinfo_spell_TDB.sql +++ b/sql/updates/4397_world_playercreateinfo_spell_TDB.sql @@ -3,4 +3,4 @@ INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (1, 2, 60091, 'Judgement Anti-Parry/Dodge Passive'), (3, 2, 60091, 'Judgement Anti-Parry/Dodge Passive'), (10, 2, 60091, 'Judgement Anti-Parry/Dodge Passive'), -(11, 2, 60091, 'Judgement Anti-Parry/Dodge Passive');
\ No newline at end of file +(11, 2, 60091, 'Judgement Anti-Parry/Dodge Passive'); diff --git a/sql/updates/4401_world_spell_proc_event.sql b/sql/updates/4401_world_spell_proc_event.sql index 214b997359a..c2f993e6eb2 100644 --- a/sql/updates/4401_world_spell_proc_event.sql +++ b/sql/updates/4401_world_spell_proc_event.sql @@ -10,4 +10,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 55668, 0x00, 15, 0x00000001, 0x08000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Desecration ( 55669, 0x00, 15, 0x00000001, 0x08000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Desecration ( 55670, 0x00, 15, 0x00000001, 0x08000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Desecration -( 58616, 0x00, 15, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Heart Strike
\ No newline at end of file +( 58616, 0x00, 15, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Heart Strike diff --git a/sql/updates/4408_world_spell_proc_event.sql b/sql/updates/4408_world_spell_proc_event.sql index 1083262b2ac..108c983e196 100644 --- a/sql/updates/4408_world_spell_proc_event.sql +++ b/sql/updates/4408_world_spell_proc_event.sql @@ -8,4 +8,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 49655, 0x00, 15, 0x00000000, 0x00000000, 0x00000002, 0x00000000, 0x00000000, 0, 0, 1), -- Wandering Plague ( 49137, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Endless Winter ( 49657, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Endless Winter -( 58620, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Chains of Ice
\ No newline at end of file +( 58620, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Chains of Ice diff --git a/sql/updates/4409_world_spell_proc_event.sql b/sql/updates/4409_world_spell_proc_event.sql index cf25a1b4293..76184c6b0c0 100644 --- a/sql/updates/4409_world_spell_proc_event.sql +++ b/sql/updates/4409_world_spell_proc_event.sql @@ -18,4 +18,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 54151, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0), -- Judgements of the Pure (Rank 3) ( 54154, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0), -- Judgements of the Pure (Rank 4) ( 63310, 0x00, 5, 0x00000000, 0x00010000, 0x00000000, 0x00010000, 0x00000000, 0, 0, 0), -- Glyph of Shadowflame -( 54155, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0); -- Judgements of the Pure (Rank 5)
\ No newline at end of file +( 54155, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0); -- Judgements of the Pure (Rank 5) diff --git a/sql/updates/4411_world_spell_bonus_data_TDB.sql b/sql/updates/4411_world_spell_bonus_data_TDB.sql index 3ac7c56f637..35c2ad55576 100644 --- a/sql/updates/4411_world_spell_bonus_data_TDB.sql +++ b/sql/updates/4411_world_spell_bonus_data_TDB.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_bonus_data` WHERE `entry` IN (54158); INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES -(54158, 0.25, 0, 0.16, 'Paladin - Jugdement (Seal of Light, Seal of Wisdom, Seal of Justice)');
\ No newline at end of file +(54158, 0.25, 0, 0.16, 'Paladin - Jugdement (Seal of Light, Seal of Wisdom, Seal of Justice)'); diff --git a/sql/updates/4422_world_script.sql b/sql/updates/4422_world_script.sql index 54f3eb7a831..99f8591dd04 100644 --- a/sql/updates/4422_world_script.sql +++ b/sql/updates/4422_world_script.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_dark_rider_of_acherus' WHERE `entry` =28654;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_dark_rider_of_acherus' WHERE `entry` =28654; diff --git a/sql/updates/4423_world.sql b/sql/updates/4423_world.sql index af0309e4f16..638d0d3c9d9 100644 --- a/sql/updates/4423_world.sql +++ b/sql/updates/4423_world.sql @@ -15,4 +15,4 @@ INSERT INTO `creature_ai_scripts` VALUES ( 3375100, 33751, 1, 0, 100, 0, 1, 1, 0, 0, 11, 63586, 0, 2, 11, 63582, 0, 2, 0, 0, 0, 0, 'Desecration'), -- Desecration ( 3375001, 33750, 11, 0, 100, 0, 0, 0, 0, 0, 11, 55741, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Desecration'), -( 3375000, 33750, 1, 0, 100, 0, 1, 1, 0, 0, 11, 63587, 0, 2, 11, 63583, 0, 2, 0, 0, 0, 0, 'Desecration');
\ No newline at end of file +( 3375000, 33750, 1, 0, 100, 0, 1, 1, 0, 0, 11, 63587, 0, 2, 11, 63583, 0, 2, 0, 0, 0, 0, 'Desecration'); diff --git a/sql/updates/4426_world.sql b/sql/updates/4426_world.sql index ac53cfb5adf..0db361d93bf 100644 --- a/sql/updates/4426_world.sql +++ b/sql/updates/4426_world.sql @@ -25,4 +25,4 @@ UPDATE `quest_template` SET `PrevQuestId`=13166 WHERE `entry`=13189; UPDATE `creature` SET `phaseMask`=128 WHERE `id` IN (31082,29173,29199,29204,29200); -- Citizen of New Avalon -UPDATE creature_template SET unit_flags = 537166336, dynamicflags = 0 WHERE entry = 28942;
\ No newline at end of file +UPDATE creature_template SET unit_flags = 537166336, dynamicflags = 0 WHERE entry = 28942; diff --git a/sql/updates/4428_world_spell_proc_event.sql b/sql/updates/4428_world_spell_proc_event.sql index 808510b5867..bedb7cabe28 100644 --- a/sql/updates/4428_world_spell_proc_event.sql +++ b/sql/updates/4428_world_spell_proc_event.sql @@ -3,4 +3,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 59725, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000800, 0, 0, 0), -- Improved Spell Reflection ( 56342, 0x00, 9, 0x00000018, 0x08000000, 0x00020000, 0x00000000, 0x00000000, 0, 0, 0), -- Lock and Load ( 56343, 0x00, 9, 0x00000018, 0x08000000, 0x00020000, 0x00000000, 0x00000000, 0, 0, 0), -- Lock and Load -( 56344, 0x00, 9, 0x00000018, 0x08000000, 0x00020000, 0x00000000, 0x00000000, 0, 0, 0); -- Lock and Load
\ No newline at end of file +( 56344, 0x00, 9, 0x00000018, 0x08000000, 0x00020000, 0x00000000, 0x00000000, 0, 0, 0); -- Lock and Load diff --git a/sql/updates/4429_world_spell_proc_event.sql b/sql/updates/4429_world_spell_proc_event.sql index d9f3cfc8b52..b67c802610f 100644 --- a/sql/updates/4429_world_spell_proc_event.sql +++ b/sql/updates/4429_world_spell_proc_event.sql @@ -4,4 +4,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 20212, 0x00, 10, 0xC0000000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Illumination (Rank 2) ( 20213, 0x00, 10, 0xC0000000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Illumination (Rank 3) ( 20214, 0x00, 10, 0xC0000000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Illumination (Rank 4) -( 20215, 0x00, 10, 0xC0000000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Illumination (Rank 5)
\ No newline at end of file +( 20215, 0x00, 10, 0xC0000000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Illumination (Rank 5) diff --git a/sql/updates/4431_world_trinity_string.sql b/sql/updates/4431_world_trinity_string.sql index d26aa455932..564f465dc69 100644 --- a/sql/updates/4431_world_trinity_string.sql +++ b/sql/updates/4431_world_trinity_string.sql @@ -1,4 +1,4 @@ UPDATE `trinity_string` SET `content_default` = 'Active connections: %u (max: %u) Queued connections: %u (max: %u)' WHERE `entry` = 12; DELETE FROM `trinity_string` WHERE `entry` = 60; -INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES (60, 'Online players: %u (max: %u)');
\ No newline at end of file +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES (60, 'Online players: %u (max: %u)'); diff --git a/sql/updates/4432_world.sql b/sql/updates/4432_world.sql index 3941d9306b1..895ffbb503a 100644 --- a/sql/updates/4432_world.sql +++ b/sql/updates/4432_world.sql @@ -55,4 +55,4 @@ INSERT INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `langua (-1609075,'There... There\'s no more time for me. I\'m done for. Finish me off, $N. Do it or they\'ll kill us both. $N... Remember Mulgore. This world is worth saving.',0,0,0,18,'special_surprise SAY_EXEC_TIME_9'), (-1609076,'Der... Der\'s no more time for me. I be done for. Finish me off $N. Do it or they\'ll kill us both. $N... Remember Sen\'jin Village, mon! Dis world be worth saving!',0,0,0,18,'special_surprise SAY_EXEC_TIME_10'), (-1609077,'Do it, $N! Put me out of my misery!',0,0,0,1,'special_surprise SAY_EXEC_WAITING'), -(-1609078,'dies from his wounds.',0,2,0,0,'special_surprise EMOTE_DIES');
\ No newline at end of file +(-1609078,'dies from his wounds.',0,2,0,0,'special_surprise EMOTE_DIES'); diff --git a/sql/updates/4445_8158_world_playercreateinfo_action.sql b/sql/updates/4445_8158_world_playercreateinfo_action.sql index 572870c3703..c4c1eb98d06 100644 --- a/sql/updates/4445_8158_world_playercreateinfo_action.sql +++ b/sql/updates/4445_8158_world_playercreateinfo_action.sql @@ -450,4 +450,4 @@ INSERT INTO `playercreateinfo_action` VALUES (11,8,3,59548,0), (11,8,10,159,128), (11,8,11,4540,128), -(11,8,83,4540,128);
\ No newline at end of file +(11,8,83,4540,128); diff --git a/sql/updates/4451_world_tmp.sql b/sql/updates/4451_world_tmp.sql index 40f44514575..30f12539d75 100644 --- a/sql/updates/4451_world_tmp.sql +++ b/sql/updates/4451_world_tmp.sql @@ -1 +1 @@ -UPDATE creature_template SET `VehicleId`=200, spell1=52264, spell2=52268 WHERE `entry` IN (28605, 28606, 28607);
\ No newline at end of file +UPDATE creature_template SET `VehicleId`=200, spell1=52264, spell2=52268 WHERE `entry` IN (28605, 28606, 28607); diff --git a/sql/updates/4464_world_spell_bonus_data_TDB.sql b/sql/updates/4464_world_spell_bonus_data_TDB.sql index e53a2916ce9..9d7bacd90be 100644 --- a/sql/updates/4464_world_spell_bonus_data_TDB.sql +++ b/sql/updates/4464_world_spell_bonus_data_TDB.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_bonus_data` WHERE `entry` = '58621'; INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES -(58621, 0, 0, 0.08, 'Death Knight - Glyph of Chains of Ice');
\ No newline at end of file +(58621, 0, 0, 0.08, 'Death Knight - Glyph of Chains of Ice'); diff --git a/sql/updates/4481_world_script.sql b/sql/updates/4481_world_script.sql index 4f951607357..a3ba626538b 100644 --- a/sql/updates/4481_world_script.sql +++ b/sql/updates/4481_world_script.sql @@ -1,2 +1,2 @@ UPDATE `creature_template` SET `ScriptName`='npc_valkyr_battle_maiden' WHERE (`entry`='28534'); -INSERT iGNORE INTO `spell_proc_event` VALUES ( 51915, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000001, 0x00000000, 0, 100, 600);
\ No newline at end of file +INSERT iGNORE INTO `spell_proc_event` VALUES ( 51915, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000001, 0x00000000, 0, 100, 600); diff --git a/sql/updates/4490_world_spell_proc_event.sql b/sql/updates/4490_world_spell_proc_event.sql index f7451c9aefc..6dfeccb6a3e 100644 --- a/sql/updates/4490_world_spell_proc_event.sql +++ b/sql/updates/4490_world_spell_proc_event.sql @@ -1,2 +1,2 @@ DELETE FROM `spell_proc_event` WHERE `entry` =51915; -INSERT IGNORE INTO `spell_proc_event` VALUES ( 51915, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x01000000, 0x00000000, 0, 100, 600);
\ No newline at end of file +INSERT IGNORE INTO `spell_proc_event` VALUES ( 51915, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x01000000, 0x00000000, 0, 100, 600); diff --git a/sql/updates/4495_world_script.sql b/sql/updates/4495_world_script.sql index 8e37e081e23..d552cbb731f 100644 --- a/sql/updates/4495_world_script.sql +++ b/sql/updates/4495_world_script.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='mob_mojo' WHERE `entry`='24480';
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='mob_mojo' WHERE `entry`='24480'; diff --git a/sql/updates/4498_characters_channels.sql b/sql/updates/4498_characters_channels.sql index a56499768d0..7f5490ddf79 100644 --- a/sql/updates/4498_characters_channels.sql +++ b/sql/updates/4498_characters_channels.sql @@ -11,4 +11,4 @@ CREATE TABLE `channels` ( `m_password` text, `BannedList` longtext, PRIMARY KEY (`m_name`(10),`m_team`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Channel System';
\ No newline at end of file +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Channel System'; diff --git a/sql/updates/4500_world_spell_bonus_data.sql b/sql/updates/4500_world_spell_bonus_data.sql index dc5be2bcf23..0668193b3f0 100644 --- a/sql/updates/4500_world_spell_bonus_data.sql +++ b/sql/updates/4500_world_spell_bonus_data.sql @@ -242,4 +242,4 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus` (57970, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 9($AP*0.12 / number of ticks)'), (48628, -1, -1, -1, 0.15, 'Druid - Lock Jaw'), (1822, -1, -1, 0.01, 0.06, 'Druid - Rake ($AP*0.18 / number of ticks)'), -(33745, -1, -1, -1, 0.01, 'Druid - Lacerate($AP*0.05 / number of ticks)');
\ No newline at end of file +(33745, -1, -1, -1, 0.01, 'Druid - Lacerate($AP*0.05 / number of ticks)'); diff --git a/sql/updates/4501_world_spell_bonus_data.sql b/sql/updates/4501_world_spell_bonus_data.sql index 2cef253cd58..337b293e62e 100644 --- a/sql/updates/4501_world_spell_bonus_data.sql +++ b/sql/updates/4501_world_spell_bonus_data.sql @@ -28,4 +28,4 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus` (56641, -1, -1, 0.1, -1, 'Hunter - Steady Shot'), (13812, -1, -1, 0.1, -1, 'Hunter - Explosive Trap Effect'), (20253, -1, -1, 0.12, -1, 'Warrior - Intercept'), -(61491, -1, -1, 0.12, -1, 'Warrior - Intercept');
\ No newline at end of file +(61491, -1, -1, 0.12, -1, 'Warrior - Intercept'); diff --git a/sql/updates/4509_world_spell_linked_spell.sql b/sql/updates/4509_world_spell_linked_spell.sql index ddca75d5d53..d672b2a564a 100644 --- a/sql/updates/4509_world_spell_linked_spell.sql +++ b/sql/updates/4509_world_spell_linked_spell.sql @@ -1 +1 @@ -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (48265, 49772, 48263);
\ No newline at end of file +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (48265, 49772, 48263); diff --git a/sql/updates/4510_world_spell_linked_spell.sql b/sql/updates/4510_world_spell_linked_spell.sql index b92a87bb267..76266d3af5e 100644 --- a/sql/updates/4510_world_spell_linked_spell.sql +++ b/sql/updates/4510_world_spell_linked_spell.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (20594); INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES -( 20594, 65116, 0, 'Stoneform');
\ No newline at end of file +( 20594, 65116, 0, 'Stoneform'); diff --git a/sql/updates/4520_8190_world_creature_template.sql b/sql/updates/4520_8190_world_creature_template.sql index fdc36d4474b..7be3a6e49fa 100644 --- a/sql/updates/4520_8190_world_creature_template.sql +++ b/sql/updates/4520_8190_world_creature_template.sql @@ -2,4 +2,4 @@ ALTER TABLE `creature_template` CHANGE COLUMN `unk1` `KillCredit1` int(11) unsigned NOT NULL default '0', - CHANGE COLUMN `unk2` `KillCredit2` int(11) unsigned NOT NULL default '0';
\ No newline at end of file + CHANGE COLUMN `unk2` `KillCredit2` int(11) unsigned NOT NULL default '0'; diff --git a/sql/updates/4524_world_spell_elixir.sql b/sql/updates/4524_world_spell_elixir.sql index 49bb9845957..66d609840ff 100644 --- a/sql/updates/4524_world_spell_elixir.sql +++ b/sql/updates/4524_world_spell_elixir.sql @@ -22,4 +22,4 @@ INSERT INTO `spell_elixir` (`entry`, `mask`) VALUES (53758, 0x3), (53755, 0x3), (53752, 0x3), -(62380, 0x3);
\ No newline at end of file +(62380, 0x3); diff --git a/sql/updates/4530_world_spell_script_target.sql b/sql/updates/4530_world_spell_script_target.sql index 234f5b88b6a..f1bf84d509a 100644 --- a/sql/updates/4530_world_spell_script_target.sql +++ b/sql/updates/4530_world_spell_script_target.sql @@ -1,4 +1,4 @@ DELETE FROM `spell_script_target` WHERE `entry` IN (58836); INSERT INTO `spell_script_target` VALUES (58836, 1, 31216); UPDATE `creature_template` SET `ScriptName`='npc_mirror_image' WHERE `entry`=31216; -UPDATE `creature_template` SET `spell1`=59638, `spell2` = 59637 WHERE `entry`=31216;
\ No newline at end of file +UPDATE `creature_template` SET `spell1`=59638, `spell2` = 59637 WHERE `entry`=31216; diff --git a/sql/updates/4536_world_spell_proc_event.sql b/sql/updates/4536_world_spell_proc_event.sql index 9b009d65b82..875313c3e85 100644 --- a/sql/updates/4536_world_spell_proc_event.sql +++ b/sql/updates/4536_world_spell_proc_event.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (53234, 53237, 53238); INSERT INTO `spell_proc_event` VALUES (53234, 0x00, 9, 0x00020000, 0x00000001, 0x00000001, 0x00000000, 0x00000002, 0.000000, 0.000000, 0), -- Piercing Shots (Rank 1) (53237, 0x00, 9, 0x00020000, 0x00000001, 0x00000001, 0x00000000, 0x00000002, 0.000000, 0.000000, 0), -- Piercing Shots (Rank 2) -(53238, 0x00, 9, 0x00020000, 0x00000001, 0x00000001, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); -- Piercing Shots (Rank 3)
\ No newline at end of file +(53238, 0x00, 9, 0x00020000, 0x00000001, 0x00000001, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); -- Piercing Shots (Rank 3) diff --git a/sql/updates/4539_world_spell_linked_spell.sql b/sql/updates/4539_world_spell_linked_spell.sql index 4b18b179f7c..1be5970f4ab 100644 --- a/sql/updates/4539_world_spell_linked_spell.sql +++ b/sql/updates/4539_world_spell_linked_spell.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (49039); INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES -( 49039, 50397, 2, 'Lichborne - shapeshift');
\ No newline at end of file +( 49039, 50397, 2, 'Lichborne - shapeshift'); diff --git a/sql/updates/4542_8191_world_spell_affect.sql b/sql/updates/4542_8191_world_spell_affect.sql index 646c9c3dc00..74e28a00b59 100644 --- a/sql/updates/4542_8191_world_spell_affect.sql +++ b/sql/updates/4542_8191_world_spell_affect.sql @@ -1,3 +1,3 @@ -- ALTER TABLE db_version CHANGE COLUMN required_8190_01_mangos_creature_template required_8191_01_mangos_spell_affect bit; -DROP TABLE IF EXISTS `spell_affect`;
\ No newline at end of file +DROP TABLE IF EXISTS `spell_affect`; diff --git a/sql/updates/4544_world.sql b/sql/updates/4544_world.sql index ab92495e48b..90f7e193f15 100644 --- a/sql/updates/4544_world.sql +++ b/sql/updates/4544_world.sql @@ -1,3 +1,3 @@ UPDATE `creature_template` SET `ScriptName`='npc_sinkhole_kill_credit' WHERE (`entry`='26248') or (`entry`='26249'); UPDATE `item_template` SET `ScriptName`='item_incendiary_explosives' WHERE (`entry`='35704'); -UPDATE `creature_template` SET `flags_extra`='2' WHERE (`entry`='26250');
\ No newline at end of file +UPDATE `creature_template` SET `flags_extra`='2' WHERE (`entry`='26250'); diff --git a/sql/updates/4547_world_scripts.sql b/sql/updates/4547_world_scripts.sql index 39be645d833..82f682e482e 100644 --- a/sql/updates/4547_world_scripts.sql +++ b/sql/updates/4547_world_scripts.sql @@ -2,4 +2,4 @@ UPDATE `creature_template` SET `ScriptName`='npc_captured_rageclaw' WHERE (`entr UPDATE `creature_template` SET `ScriptName`='npc_drakuru_shackles' WHERE (`entry`='29700'); DELETE FROM `spell_script_target` WHERE `entry` IN (55083,55223,59951,59952); -INSERT INTO `spell_script_target` VALUES (55083, 1, 29700),(55223, 1, 29686),(59951, 1, 29686),(59952, 1, 29686);
\ No newline at end of file +INSERT INTO `spell_script_target` VALUES (55083, 1, 29700),(55223, 1, 29686),(59951, 1, 29686),(59952, 1, 29686); diff --git a/sql/updates/4549_world_script.sql b/sql/updates/4549_world_script.sql index ba567eb4343..b020a560cec 100644 --- a/sql/updates/4549_world_script.sql +++ b/sql/updates/4549_world_script.sql @@ -1,4 +1,4 @@ UPDATE `creature_template` SET `ScriptName`='npc_khunok_the_behemoth' WHERE (`entry`='25862'); -- DB CONTENT -- -UPDATE `quest_template` SET `SrcSpell`='46232' WHERE (`entry`='11878');
\ No newline at end of file +UPDATE `quest_template` SET `SrcSpell`='46232' WHERE (`entry`='11878'); diff --git a/sql/updates/4572_script_texts.sql b/sql/updates/4572_script_texts.sql index e594d05401c..d9c4a644c92 100644 --- a/sql/updates/4572_script_texts.sql +++ b/sql/updates/4572_script_texts.sql @@ -46,4 +46,4 @@ INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content (-1615040,'Unlike, I have many talents.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,14138,1,0,0,'vesperon SAY_VESPERON_SPECIAL_2'), (-1615041,'A Vesperon Disciple appears in the Twilight!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,0,5,0,0,'shadron WHISPER_VESPERON_DICIPLE'), -(-1615042,'%s begins to open a Twilight Portal!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,0,5,0,0,'sartharion drake WHISPER_OPEN_PORTAL');
\ No newline at end of file +(-1615042,'%s begins to open a Twilight Portal!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,0,5,0,0,'sartharion drake WHISPER_OPEN_PORTAL'); diff --git a/sql/updates/4572_world_script.sql b/sql/updates/4572_world_script.sql index 314d0929de8..f34a407ab17 100644 --- a/sql/updates/4572_world_script.sql +++ b/sql/updates/4572_world_script.sql @@ -1 +1 @@ -UPDATE instance_template SET script='instance_obsidian_sanctum' WHERE map=615;
\ No newline at end of file +UPDATE instance_template SET script='instance_obsidian_sanctum' WHERE map=615; diff --git a/sql/updates/4577_world_scripts.sql b/sql/updates/4577_world_scripts.sql index e73aaea3438..930ebec424a 100644 --- a/sql/updates/4577_world_scripts.sql +++ b/sql/updates/4577_world_scripts.sql @@ -7,4 +7,4 @@ UPDATE creature_template SET ScriptName='mob_twilight_whelp' WHERE entry IN (308 UPDATE creature_template SET ScriptName='mob_acolyte_of_shadron' WHERE entry=31218; UPDATE creature_template SET ScriptName='mob_acolyte_of_vesperon' WHERE entry=31219; -UPDATE gameobject_template SET ScriptName='go_resonite_cask' WHERE entry=178145;
\ No newline at end of file +UPDATE gameobject_template SET ScriptName='go_resonite_cask' WHERE entry=178145; diff --git a/sql/updates/4583_world_command.sql b/sql/updates/4583_world_command.sql index 52e3b40eb59..6c5bc49f013 100644 --- a/sql/updates/4583_world_command.sql +++ b/sql/updates/4583_world_command.sql @@ -1 +1 @@ -DELETE FROM `command` WHERE `name` = 'reload spell_affect';
\ No newline at end of file +DELETE FROM `command` WHERE `name` = 'reload spell_affect'; diff --git a/sql/updates/4594_world_scripts.sql b/sql/updates/4594_world_scripts.sql index ac1056590bb..ebdcb7f761f 100644 --- a/sql/updates/4594_world_scripts.sql +++ b/sql/updates/4594_world_scripts.sql @@ -1,3 +1,3 @@ UPDATE `item_template` SET `ScriptName`='item_dart_gun' WHERE `entry`=44222; -UPDATE `creature_template` SET `ScriptName`='npc_kalecgos' WHERE `entry` IN (24844, 24848);
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_kalecgos' WHERE `entry` IN (24844, 24848); diff --git a/sql/updates/4597_world_command.sql b/sql/updates/4597_world_command.sql index 26096dd3143..374cbb2c632 100644 --- a/sql/updates/4597_world_command.sql +++ b/sql/updates/4597_world_command.sql @@ -1,4 +1,4 @@ DELETE FROM `command` WHERE `name` IN ('reload creature_linked_respawn', 'npc setlink'); INSERT INTO `command` (`name`,`security`,`help`) VALUES ('reload creature_linked_respawn',2,'Syntax: .reload creature_linked_respawn\r\nReload creature_linked_respawn table.'), -('npc setlink',2,'Syntax: .npc setlink $creatureGUID\r\n\r\nLinks respawn of selected creature to the condition that $creatureGUID defined is alive.');
\ No newline at end of file +('npc setlink',2,'Syntax: .npc setlink $creatureGUID\r\n\r\nLinks respawn of selected creature to the condition that $creatureGUID defined is alive.'); diff --git a/sql/updates/4598_world_spell_bonus_data.sql b/sql/updates/4598_world_spell_bonus_data.sql index da3da6315a7..0127e88b5a7 100644 --- a/sql/updates/4598_world_spell_bonus_data.sql +++ b/sql/updates/4598_world_spell_bonus_data.sql @@ -1 +1 @@ -DELETE FROM `spell_bonus_data` WHERE `entry` = 53600;
\ No newline at end of file +DELETE FROM `spell_bonus_data` WHERE `entry` = 53600; diff --git a/sql/updates/4601_world_spell_proc_event.sql b/sql/updates/4601_world_spell_proc_event.sql index 516cd070482..0bae1d9c8d7 100644 --- a/sql/updates/4601_world_spell_proc_event.sql +++ b/sql/updates/4601_world_spell_proc_event.sql @@ -1,4 +1,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN(47569, 47570); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES ( 47569, 0x00, 6, 0x00004000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 50, 0), -- Improved Shadowform (Rank 1) -( 47570, 0x00, 6, 0x00004000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 100, 0); -- Improved Shadowform (Rank 2)
\ No newline at end of file +( 47570, 0x00, 6, 0x00004000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 100, 0); -- Improved Shadowform (Rank 2) diff --git a/sql/updates/4602_world_spell_bonus_data.sql b/sql/updates/4602_world_spell_bonus_data.sql index 85975accd34..c10cd0a9df0 100644 --- a/sql/updates/4602_world_spell_bonus_data.sql +++ b/sql/updates/4602_world_spell_bonus_data.sql @@ -4,4 +4,4 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus` DELETE FROM `spell_bonus_data` WHERE `entry`=50256; INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES -(50256, -1, -1, 0.08, -1, 'Pet Skills - Bear (Swipe)');
\ No newline at end of file +(50256, -1, -1, 0.08, -1, 'Pet Skills - Bear (Swipe)'); diff --git a/sql/updates/4603_world_tmp.sql b/sql/updates/4603_world_tmp.sql index 4ce1593c9c7..6a98804447f 100644 --- a/sql/updates/4603_world_tmp.sql +++ b/sql/updates/4603_world_tmp.sql @@ -51,4 +51,4 @@ UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=47296; UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=47297; UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=80022; UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=80023; -UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=85556;
\ No newline at end of file +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=85556; diff --git a/sql/updates/4643_world_8237_creature_template.sql b/sql/updates/4643_world_8237_creature_template.sql index 8a199e4d9b7..d2ac804df6f 100644 --- a/sql/updates/4643_world_8237_creature_template.sql +++ b/sql/updates/4643_world_8237_creature_template.sql @@ -1,4 +1,4 @@ -- ALTER TABLE db_version CHANGE COLUMN required_8227_01_mangos_spell_proc_event required_8237_01_mangos_creature_template bit; UPDATE creature_template - SET mindmg = ROUND(mindmg + attackpower), maxdmg=ROUND(maxdmg+attackpower);
\ No newline at end of file + SET mindmg = ROUND(mindmg + attackpower), maxdmg=ROUND(maxdmg+attackpower); diff --git a/sql/updates/4649_world_8250_spell_threat.sql b/sql/updates/4649_world_8250_spell_threat.sql index a19513363bd..e71aa25ca9c 100644 --- a/sql/updates/4649_world_8250_spell_threat.sql +++ b/sql/updates/4649_world_8250_spell_threat.sql @@ -1,3 +1,3 @@ -- ALTER TABLE db_version CHANGE COLUMN required_8249_02_mangos_spell_chain required_8250_01_mangos_spell_threat bit; -DELETE FROM `spell_threat` WHERE `entry` IN (778,9749,9907,14274,15629,15630,15631,15632,17390,17391,17392,26993,27011);
\ No newline at end of file +DELETE FROM `spell_threat` WHERE `entry` IN (778,9749,9907,14274,15629,15630,15631,15632,17390,17391,17392,26993,27011); diff --git a/sql/updates/4663_world.sql b/sql/updates/4663_world.sql index a205226b0fd..7f63011bb5c 100644 --- a/sql/updates/4663_world.sql +++ b/sql/updates/4663_world.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` = 50453; INSERT INTO `spell_proc_event` (`entry`, `procFlags`, `CustomChance`) VALUES ('50453', '0x00000004', '100'); DELETE FROM `creature_template_addon` WHERE `entry` = 28017; -INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES ('28017', '50453 0');
\ No newline at end of file +INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES ('28017', '50453 0'); diff --git a/sql/updates/4696_world_spell_proc_event.sql b/sql/updates/4696_world_spell_proc_event.sql index 766ec484cce..2fa4a8bf52d 100644 --- a/sql/updates/4696_world_spell_proc_event.sql +++ b/sql/updates/4696_world_spell_proc_event.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (56636,56637,56638); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES ( 56636, 0x00, 4, 0x00000020, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Taste for Blood (Rank 1) ( 56637, 0x00, 4, 0x00000020, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Taste for Blood (Rank 2) -( 56638, 0x00, 4, 0x00000020, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6); -- Taste for Blood (Rank 3)
\ No newline at end of file +( 56638, 0x00, 4, 0x00000020, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6); -- Taste for Blood (Rank 3) diff --git a/sql/updates/4725_world_scripts.sql b/sql/updates/4725_world_scripts.sql index 83a38a2210c..92af3218a59 100644 --- a/sql/updates/4725_world_scripts.sql +++ b/sql/updates/4725_world_scripts.sql @@ -2,4 +2,4 @@ UPDATE `creature_template` SET `minlevel`='80' WHERE (`entry`='22207'); UPDATE `creature_template` SET `maxlevel`='80' WHERE (`entry`='22207'); UPDATE `creature_template` SET `faction_A`='14' WHERE (`entry`='22207'); UPDATE `creature_template` SET `faction_H`='14' WHERE (`entry`='22207'); -UPDATE `creature_template` SET `flags_extra`='128' WHERE (`entry`='22207');
\ No newline at end of file +UPDATE `creature_template` SET `flags_extra`='128' WHERE (`entry`='22207'); diff --git a/sql/updates/4741_world.sql b/sql/updates/4741_world.sql index a2eec215382..8b2a77b619e 100644 --- a/sql/updates/4741_world.sql +++ b/sql/updates/4741_world.sql @@ -1,3 +1,3 @@ DELETE FROM `trinity_string` where `entry` IN(1333); INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES -(1333, 'The Battle for Alterac Valley begins in 2 minutes.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
\ No newline at end of file +(1333, 'The Battle for Alterac Valley begins in 2 minutes.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); diff --git a/sql/updates/4742_world_spell_bonus_data.sql b/sql/updates/4742_world_spell_bonus_data.sql index b39673705f1..e80a0b07086 100644 --- a/sql/updates/4742_world_spell_bonus_data.sql +++ b/sql/updates/4742_world_spell_bonus_data.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_bonus_data` WHERE `entry`=42243; INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES -(42243, -1, -1, 0.07, -1, 'Hunter - Volley');
\ No newline at end of file +(42243, -1, -1, 0.07, -1, 'Hunter - Volley'); diff --git a/sql/updates/4742_world_spell_proc_event.sql b/sql/updates/4742_world_spell_proc_event.sql index f9d98472263..e4a3bcd6d17 100644 --- a/sql/updates/4742_world_spell_proc_event.sql +++ b/sql/updates/4742_world_spell_proc_event.sql @@ -1,2 +1,2 @@ DELETE FROM `spell_proc_event` WHERE (`entry`='64928'); -INSERT INTO `spell_proc_event` (`entry`, `SpellFamilyName`, `SpellFamilyMask0`, `procEx`) VALUES (64928, 11, 0x00000001, 0x00000002);
\ No newline at end of file +INSERT INTO `spell_proc_event` (`entry`, `SpellFamilyName`, `SpellFamilyMask0`, `procEx`) VALUES (64928, 11, 0x00000001, 0x00000002); diff --git a/sql/updates/4745_world_access_requirement.sql b/sql/updates/4745_world_access_requirement.sql index d328cbc9667..4dbb66a8bb1 100644 --- a/sql/updates/4745_world_access_requirement.sql +++ b/sql/updates/4745_world_access_requirement.sql @@ -43,4 +43,4 @@ UPDATE `access_requirement` SET `heroic_level_min` = 80 WHERE `id` IN 5290, -- The Eye of Eternity -- 5243, -- The Obsidian Sanctum -- 5379 -- Ulduar -- -);
\ No newline at end of file +); diff --git a/sql/updates/4748_world.sql b/sql/updates/4748_world.sql index 62e98d58d68..00834293554 100644 --- a/sql/updates/4748_world.sql +++ b/sql/updates/4748_world.sql @@ -1,2 +1,2 @@ UPDATE `item_template` SET `ScriptName`='item_mysterious_egg' WHERE `entry` IN(39878); -UPDATE `item_template` SET `ScriptName`='item_disgusting_jar' WHERE `entry` IN(44717);
\ No newline at end of file +UPDATE `item_template` SET `ScriptName`='item_disgusting_jar' WHERE `entry` IN(44717); diff --git a/sql/updates/4751_world_scripts.sql b/sql/updates/4751_world_scripts.sql index 7efb4e61aa1..5bedf2df1c4 100644 --- a/sql/updates/4751_world_scripts.sql +++ b/sql/updates/4751_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_training_dummy', `flags_extra`='262144', `mechanic_immune_mask`='0', `faction_A`='7', `faction_H`='7' WHERE `entry` IN (17578, 24792, 32543, 32546, 32542, 32545, 30527, 31143, 31144, 31146, 32541, 32666, 32667);
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_training_dummy', `flags_extra`='262144', `mechanic_immune_mask`='0', `faction_A`='7', `faction_H`='7' WHERE `entry` IN (17578, 24792, 32543, 32546, 32542, 32545, 30527, 31143, 31144, 31146, 32541, 32666, 32667); diff --git a/sql/updates/4753_world.sql b/sql/updates/4753_world.sql index 19d69ce70e0..059a6427b9b 100644 --- a/sql/updates/4753_world.sql +++ b/sql/updates/4753_world.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_script_target` WHERE `entry` IN (58836, 48743, 50524, 50515); INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (58836, 3, 31216), (50524, 3, 27829), -(50515, 3, 27829);
\ No newline at end of file +(50515, 3, 27829); diff --git a/sql/updates/4755_world_scripts.sql b/sql/updates/4755_world_scripts.sql index 0d184735a5d..74e50ef8eef 100644 --- a/sql/updates/4755_world_scripts.sql +++ b/sql/updates/4755_world_scripts.sql @@ -1 +1 @@ -UPDATE `gameobject_template` SET `ScriptName`='go_shrine_of_the_birds' WHERE `entry` IN (185547,185553,185551);
\ No newline at end of file +UPDATE `gameobject_template` SET `ScriptName`='go_shrine_of_the_birds' WHERE `entry` IN (185547,185553,185551); diff --git a/sql/updates/4756_world.sql b/sql/updates/4756_world.sql index 55c0e6da5d9..abde52f0a9e 100644 --- a/sql/updates/4756_world.sql +++ b/sql/updates/4756_world.sql @@ -7,4 +7,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 61434, 0x00, 15, 0x00400000, 0x00010000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Blood of the north ( 49467, 0x00, 15, 0x00000010, 0x00020000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Death Rune Mastery ( 50033, 0x00, 15, 0x00000010, 0x00020000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Death Rune Mastery -( 50034, 0x00, 15, 0x00000010, 0x00020000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Death Rune Mastery
\ No newline at end of file +( 50034, 0x00, 15, 0x00000010, 0x00020000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Death Rune Mastery diff --git a/sql/updates/4761_world.sql b/sql/updates/4761_world.sql index 40adb87ea6c..563258f6c8d 100644 --- a/sql/updates/4761_world.sql +++ b/sql/updates/4761_world.sql @@ -1,4 +1,4 @@ DELETE FROM `spell_script_target` WHERE `entry` IN (52173, 60243); INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (52173, 3, 28267), -(60243, 3, 11236);
\ No newline at end of file +(60243, 3, 11236); diff --git a/sql/updates/4795_world_scripts_converter.sql b/sql/updates/4795_world_scripts_converter.sql index 185075f05ed..ab0ea355659 100644 --- a/sql/updates/4795_world_scripts_converter.sql +++ b/sql/updates/4795_world_scripts_converter.sql @@ -10,4 +10,4 @@ spell4 = VALUES(spell4), spell5 = VALUES(spell5), spell6 = VALUES(spell6), spell7 = VALUES(spell7), -spell8 = VALUES(spell8);
\ No newline at end of file +spell8 = VALUES(spell8); diff --git a/sql/updates/4841_world_scripts.sql b/sql/updates/4841_world_scripts.sql index 9241fa8cf48..543e18a259a 100644 --- a/sql/updates/4841_world_scripts.sql +++ b/sql/updates/4841_world_scripts.sql @@ -1,4 +1,4 @@ UPDATE `creature_template` SET `ScriptName`='mob_archavon_warder' WHERE `entry`=32353; UPDATE `creature_template` SET `ScriptName`='boss_emalon' WHERE `entry`=33993; UPDATE `creature_template` SET `ScriptName`='mob_tempest_minion' WHERE `entry`=33998; -UPDATE `instance_template` SET `script`='instance_archavon' WHERE `map`=624;
\ No newline at end of file +UPDATE `instance_template` SET `script`='instance_archavon' WHERE `map`=624; diff --git a/sql/updates/4862_world_linked_spell.sql b/sql/updates/4862_world_linked_spell.sql index a994a45bc22..a892d0a8490 100644 --- a/sql/updates/4862_world_linked_spell.sql +++ b/sql/updates/4862_world_linked_spell.sql @@ -8,4 +8,4 @@ VALUES ( 34471, 24395, 2, 'Beast Within'), ( 34471, 24396, 2, 'Beast Within'), ( 34471, 24397, 2, 'Beast Within'), -( 34471, 26592, 2, 'Beast Within');
\ No newline at end of file +( 34471, 26592, 2, 'Beast Within'); diff --git a/sql/updates/4868_world_scripts.sql b/sql/updates/4868_world_scripts.sql index af5f4129717..660d34ee7f4 100644 --- a/sql/updates/4868_world_scripts.sql +++ b/sql/updates/4868_world_scripts.sql @@ -54,4 +54,4 @@ INSERT INTO script_waypoint VALUES (3678, 24, 114.777, 237.155, -96.0304, 2500, 'NARALEX_EVENT_FINISHED'); UPDATE creature_template SET ScriptName = 'npc_disciple_of_naralex' WHERE entry = 3678; -UPDATE instance_template SET script = 'instance_wailing_caverns' WHERE map = 43;
\ No newline at end of file +UPDATE instance_template SET script = 'instance_wailing_caverns' WHERE map = 43; diff --git a/sql/updates/4872_world_scripts.sql b/sql/updates/4872_world_scripts.sql index 0aa1e19f4e0..0b264f2b8b7 100644 --- a/sql/updates/4872_world_scripts.sql +++ b/sql/updates/4872_world_scripts.sql @@ -8,4 +8,4 @@ replace into `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, replace into `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) values('22424','5','-3378.211426','4154.628418','0.366330','0',''); replace into `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) values('22424','6','-3376.920166','4085.501709','14.178538','0',''); replace into `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) values('22424','7','-3399.274658','4055.948975','18.603474','0',''); -replace into `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) values('22424','8','-3432.678223','4054.069824','29.588032','10000','');
\ No newline at end of file +replace into `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) values('22424','8','-3432.678223','4054.069824','29.588032','10000',''); diff --git a/sql/updates/4875_world_scripts.sql b/sql/updates/4875_world_scripts.sql index eeb76e82515..be29dea8c3d 100644 --- a/sql/updates/4875_world_scripts.sql +++ b/sql/updates/4875_world_scripts.sql @@ -17,4 +17,4 @@ REPLACE INTO `spell_bonus_data` (entry, direct_bonus, dot_bonus, ap_bonus, ap_do (48085, -1, 0.3333, -1, -1, 'Priest - Lightwell Renew Rank 6'); REPLACE INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES -(-59907, 7, 0, 'Lightwell Charges - Suicide');
\ No newline at end of file +(-59907, 7, 0, 'Lightwell Charges - Suicide'); diff --git a/sql/updates/4877_world_scripts.sql b/sql/updates/4877_world_scripts.sql index 3efb7ca1373..ed53e97cdbc 100644 --- a/sql/updates/4877_world_scripts.sql +++ b/sql/updates/4877_world_scripts.sql @@ -15,4 +15,4 @@ INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content (-1602030,'You cross the precipice of oblivion!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,14171,1,0,0,'loken SAY_25HEALTH'), (-1602031,'%s begins to cast Lightning Nova!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,0,3,0,0,'loken EMOTE_NOVA'); -UPDATE `creature_template` SET `ScriptName`='boss_loken' WHERE `entry`=28923;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='boss_loken' WHERE `entry`=28923; diff --git a/sql/updates/4906_world_scripts.sql b/sql/updates/4906_world_scripts.sql index 7a5373e0f76..89370b3ce5e 100644 --- a/sql/updates/4906_world_scripts.sql +++ b/sql/updates/4906_world_scripts.sql @@ -2,4 +2,4 @@ UPDATE `creature_template` SET `ScriptName` = 'boss_auriaya' WHERE `entry` = 335 UPDATE `creature_template` SET `scriptname`='boss_razorscale' WHERE `entry`=33186; UPDATE `creature_template` SET `scriptname`='boss_flame_leviathan' WHERE `entry`=33113; UPDATE `creature_template` SET `scriptname`='boss_xt002' WHERE `entry`=33293; -UPDATE `creature_template` SET `scriptname`='boss_ignis' WHERE `entry`=33118;
\ No newline at end of file +UPDATE `creature_template` SET `scriptname`='boss_ignis' WHERE `entry`=33118; diff --git a/sql/updates/4911_world_scripts.sql b/sql/updates/4911_world_scripts.sql index 7a5373e0f76..89370b3ce5e 100644 --- a/sql/updates/4911_world_scripts.sql +++ b/sql/updates/4911_world_scripts.sql @@ -2,4 +2,4 @@ UPDATE `creature_template` SET `ScriptName` = 'boss_auriaya' WHERE `entry` = 335 UPDATE `creature_template` SET `scriptname`='boss_razorscale' WHERE `entry`=33186; UPDATE `creature_template` SET `scriptname`='boss_flame_leviathan' WHERE `entry`=33113; UPDATE `creature_template` SET `scriptname`='boss_xt002' WHERE `entry`=33293; -UPDATE `creature_template` SET `scriptname`='boss_ignis' WHERE `entry`=33118;
\ No newline at end of file +UPDATE `creature_template` SET `scriptname`='boss_ignis' WHERE `entry`=33118; diff --git a/sql/updates/4923_world_scripts.sql b/sql/updates/4923_world_scripts.sql index c6eda1c104e..6e7f6fbbdc0 100644 --- a/sql/updates/4923_world_scripts.sql +++ b/sql/updates/4923_world_scripts.sql @@ -2,4 +2,4 @@ UPDATE `creature_template` SET `ScriptName` = 'npc_skywing' WHERE entry=22424; UPDATE `creature_template` SET `ScriptName` = 'boss_flame_leviathan_turret' WHERE entry=33139; UPDATE `creature_template` SET `ScriptName` = 'boss_flame_leviathan_seat' WHERE entry=33114; UPDATE `creature_template` SET `ScriptName` = 'boss_flame_leviathan_defense_turret' WHERE entry=33142; -UPDATE `creature_template` SET `ScriptName` = 'boss_flame_leviathan_overload_device' WHERE entry=33143;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'boss_flame_leviathan_overload_device' WHERE entry=33143; diff --git a/sql/updates/4927_world_scripts_naxx.sql b/sql/updates/4927_world_scripts_naxx.sql index cfb9e68b7f1..c827e8ef0b3 100644 --- a/sql/updates/4927_world_scripts_naxx.sql +++ b/sql/updates/4927_world_scripts_naxx.sql @@ -1,2 +1,2 @@ DELETE FROM areatrigger_scripts WHERE entry = 4156; -INSERT INTO areatrigger_scripts VALUES (4156, 'at_naxxramas_frostwyrm_wing');
\ No newline at end of file +INSERT INTO areatrigger_scripts VALUES (4156, 'at_naxxramas_frostwyrm_wing'); diff --git a/sql/updates/4938_world.sql b/sql/updates/4938_world.sql index 2bced51076d..a76e3b41b6e 100644 --- a/sql/updates/4938_world.sql +++ b/sql/updates/4938_world.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_bonus_data` WHERE `entry` IN(53352); INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES -(53352, -1, -1, 0.14, -1, 'Hunter - Explosive Shot (triggered)');
\ No newline at end of file +(53352, -1, -1, 0.14, -1, 'Hunter - Explosive Shot (triggered)'); diff --git a/sql/updates/4939_world_scripts.sql b/sql/updates/4939_world_scripts.sql index 6a8c7eab176..8d832e6afe2 100644 --- a/sql/updates/4939_world_scripts.sql +++ b/sql/updates/4939_world_scripts.sql @@ -25,4 +25,3 @@ UPDATE creature_template SET ScriptName='mob_molten_golem' WHERE entry=28695; UPDATE creature_template SET ScriptName='npc_volkhan_anvil' WHERE entry=28823; UPDATE creature_template SET ScriptName='boss_ionar' WHERE entry=28546; UPDATE creature_template SET ScriptName='mob_spark_of_ionar' WHERE entry=28926; - diff --git a/sql/updates/4968_world_8361_spell_bonus_data.sql b/sql/updates/4968_world_8361_spell_bonus_data.sql index c381390791e..da386bc870d 100644 --- a/sql/updates/4968_world_8361_spell_bonus_data.sql +++ b/sql/updates/4968_world_8361_spell_bonus_data.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_bonus_data` WHERE `entry`=40293; INSERT INTO `spell_bonus_data` VALUES -(40293, 0, 0, 0, 0, 'Item - Siphon Essence');
\ No newline at end of file +(40293, 0, 0, 0, 0, 'Item - Siphon Essence'); diff --git a/sql/updates/4982_world_spell_area.sql b/sql/updates/4982_world_spell_area.sql index 5f7f79a5022..4b0a8be2dd8 100644 --- a/sql/updates/4982_world_spell_area.sql +++ b/sql/updates/4982_world_spell_area.sql @@ -1 +1 @@ -update spell_area set gender=2 where spell in (33836,50426,46023,52693);
\ No newline at end of file +update spell_area set gender=2 where spell in (33836,50426,46023,52693); diff --git a/sql/updates/4996_script_texts.sql b/sql/updates/4996_script_texts.sql index 3c239b4202f..a5a192f807f 100644 --- a/sql/updates/4996_script_texts.sql +++ b/sql/updates/4996_script_texts.sql @@ -1,2 +1,2 @@ DELETE FROM `npc_text` WHERE id IN (30000,30001); -INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) VALUES ('30000', 'Here you will find the Inscription Trainer.', 'Here you will find the Inscription Trainer.', '0', '1', '0', '0', '0', '0', '0', '0', 'So you want to be a Inscriber? Well here you will find the trainer.', 'So you want to be a Inscriber? Well here you will find the trainer.', '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0'), ('30001', 'So you are looking for a Inscription Trainer? Well you can\'t find the trainer out here, better head to the nearest city.\r\n', 'So you are looking for a Inscription Trainer? Well you can\'t find the trainer out here, better head to the nearest city.\r\n', '0', '0', '0', '0', '0', '0', '0', '0', 'So you want to be a Inscriber? Well you can\'t find the trainer out here, better head to the nearest city.', 'So you want to be a Inscriber? Well you can\'t find the trainer out here, better head to the nearest city.', '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0');
\ No newline at end of file +INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) VALUES ('30000', 'Here you will find the Inscription Trainer.', 'Here you will find the Inscription Trainer.', '0', '1', '0', '0', '0', '0', '0', '0', 'So you want to be a Inscriber? Well here you will find the trainer.', 'So you want to be a Inscriber? Well here you will find the trainer.', '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0'), ('30001', 'So you are looking for a Inscription Trainer? Well you can\'t find the trainer out here, better head to the nearest city.\r\n', 'So you are looking for a Inscription Trainer? Well you can\'t find the trainer out here, better head to the nearest city.\r\n', '0', '0', '0', '0', '0', '0', '0', '0', 'So you want to be a Inscriber? Well you can\'t find the trainer out here, better head to the nearest city.', 'So you want to be a Inscriber? Well you can\'t find the trainer out here, better head to the nearest city.', '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0'); diff --git a/sql/updates/5006_world.sql b/sql/updates/5006_world.sql index 08ddd88c66b..e33ed3c7555 100644 --- a/sql/updates/5006_world.sql +++ b/sql/updates/5006_world.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (57352); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(57352, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00051154, 0x00000000, 0, 0, 45); -- Darkmoon Card: Death
\ No newline at end of file +(57352, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00051154, 0x00000000, 0, 0, 45); -- Darkmoon Card: Death diff --git a/sql/updates/5009_world.sql b/sql/updates/5009_world.sql index 0a50905614a..0ce32dd2e64 100644 --- a/sql/updates/5009_world.sql +++ b/sql/updates/5009_world.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_ebon_gargoyle' WHERE `entry`=27829;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_ebon_gargoyle' WHERE `entry`=27829; diff --git a/sql/updates/5009_world_TDB.sql b/sql/updates/5009_world_TDB.sql index 574546fb60b..01d5af66154 100644 --- a/sql/updates/5009_world_TDB.sql +++ b/sql/updates/5009_world_TDB.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `spell1`=51963 WHERE `entry`=27829;
\ No newline at end of file +UPDATE `creature_template` SET `spell1`=51963 WHERE `entry`=27829; diff --git a/sql/updates/5031_world_scripts_netherspite.sql b/sql/updates/5031_world_scripts_netherspite.sql index f64453e563a..c98bedc6a88 100644 --- a/sql/updates/5031_world_scripts_netherspite.sql +++ b/sql/updates/5031_world_scripts_netherspite.sql @@ -11,4 +11,4 @@ INSERT INTO `spell_linked_spell`(`spell_trigger`,`spell_effect`,`type`,`comment` ('-30421','38637','0','Netherspite\'s Perseverence'), ('-30422','38638','0','Netherspite\'s Serenity'), ('-30423','38639','0','Netherspite\'s Dominance'); -UPDATE `script_texts` SET `type` = '3' WHERE `entry` IN ('-1532089','-1532090');
\ No newline at end of file +UPDATE `script_texts` SET `type` = '3' WHERE `entry` IN ('-1532089','-1532090'); diff --git a/sql/updates/5083_world_scripts_dk.sql b/sql/updates/5083_world_scripts_dk.sql index 185a6493f35..4ef1ed1912f 100644 --- a/sql/updates/5083_world_scripts_dk.sql +++ b/sql/updates/5083_world_scripts_dk.sql @@ -8,4 +8,3 @@ UPDATE `creature_template` SET vehicleid=138 WHERE (`entry`='28817'); UPDATE `gameobject_template` SET `ScriptName`='go_inconspicuous_mine_car' WHERE (`entry`='190767'); UPDATE `creature_template` SET `ScriptName`='npc_scarlet_miner_cart' WHERE (`entry`='28817'); UPDATE `creature_template` SET `ScriptName`='npc_scarlet_miner' WHERE (`entry`='28841'); - diff --git a/sql/updates/5093_world_spell_proc_event.sql b/sql/updates/5093_world_spell_proc_event.sql index 8bda907de25..8a7fc5ef9ec 100644 --- a/sql/updates/5093_world_spell_proc_event.sql +++ b/sql/updates/5093_world_spell_proc_event.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry`IN(44546, 44548, 44549); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES ( 44546, 0x00, 3, 0x00100220, 0x00001000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Brain Freeze (Rank 1) ( 44548, 0x00, 3, 0x00100220, 0x00001000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Brain Freeze (Rank 2) -( 44549, 0x00, 3, 0x00100220, 0x00001000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Brain Freeze (Rank 3)
\ No newline at end of file +( 44549, 0x00, 3, 0x00100220, 0x00001000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Brain Freeze (Rank 3) diff --git a/sql/updates/5119_world.sql b/sql/updates/5119_world.sql index e9bbc577306..24fb4392953 100644 --- a/sql/updates/5119_world.sql +++ b/sql/updates/5119_world.sql @@ -14,4 +14,4 @@ INSERT INTO `npc_spellclick_spells` (npc_entry, spell_id, quest_start, quest_sta DELETE FROM `spell_bonus_data` WHERE `entry` IN(7001); REPLACE INTO `spell_bonus_data` (entry, direct_bonus, dot_bonus, ap_bonus, ap_dot_bonus, comments) VALUES -(7001, -1, 0.3333, -1, -1, 'Priest - Lightwell Renew Rank 1');
\ No newline at end of file +(7001, -1, 0.3333, -1, -1, 'Priest - Lightwell Renew Rank 1'); diff --git a/sql/updates/5136_world_scripts_dk.sql b/sql/updates/5136_world_scripts_dk.sql index 3f07fd0cc5d..b59b0a3a021 100644 --- a/sql/updates/5136_world_scripts_dk.sql +++ b/sql/updates/5136_world_scripts_dk.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='mob_scarlet_courier' WHERE `entry`='29076';
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='mob_scarlet_courier' WHERE `entry`='29076'; diff --git a/sql/updates/5144_world_TDB.sql b/sql/updates/5144_world_TDB.sql index dece043bbe7..621e174b4d1 100644 --- a/sql/updates/5144_world_TDB.sql +++ b/sql/updates/5144_world_TDB.sql @@ -25,5 +25,3 @@ insert into `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong insert into `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) values('308','58','3','0','0','0','-5601.64','-541.38','392.42','0.5'); insert into `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) values('308','60','3','0','0','0','-5605.96','-544.45','392.43','0.9'); insert into `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) values('308','62','0','0','0','2000000079','0','0','0','0'); - - diff --git a/sql/updates/5152_world_scripts_dk.sql b/sql/updates/5152_world_scripts_dk.sql index ac9f1146f08..9e2aebd062f 100644 --- a/sql/updates/5152_world_scripts_dk.sql +++ b/sql/updates/5152_world_scripts_dk.sql @@ -16,4 +16,4 @@ INSERT INTO script_waypoint VALUES (28912, 7, 1626.845, -6015.085, 134.740, 0, ''), (28912, 8, 1649.150, -6016.975, 133.240, 0, ''), (28912, 9, 1653.063, -5974.844, 132.652, 5000, 'Mount'), - (28912, 10, 1654.747, -5926.424, 121.191, 0, 'Disappear');
\ No newline at end of file + (28912, 10, 1654.747, -5926.424, 121.191, 0, 'Disappear'); diff --git a/sql/updates/5185_world_scripts_dk.sql b/sql/updates/5185_world_scripts_dk.sql index 58016cbeb37..b13f3315250 100644 --- a/sql/updates/5185_world_scripts_dk.sql +++ b/sql/updates/5185_world_scripts_dk.sql @@ -159,6 +159,3 @@ INSERT INTO script_waypoint VALUES (29173, 7, 2257.479, -5296.702, 82.165, 0, 'being kicked by Lich King'), (29173, 8, 2261.237, -5294.983, 82.167, 0, 'throw'), (29173, 9, 2259.34, -5294.379, 82.167, 0, 'event end'); - - -
\ No newline at end of file diff --git a/sql/updates/5188_world_scripts.sql b/sql/updates/5188_world_scripts.sql index 9d58f8e8d14..c04a3be80fb 100644 --- a/sql/updates/5188_world_scripts.sql +++ b/sql/updates/5188_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `mechanic_immune_mask` = 617299803 WHERE `entry` = 24850;
\ No newline at end of file +UPDATE `creature_template` SET `mechanic_immune_mask` = 617299803 WHERE `entry` = 24850; diff --git a/sql/updates/5230_world_TDB.sql b/sql/updates/5230_world_TDB.sql index cf6f393f3a8..40bda3e25d9 100644 --- a/sql/updates/5230_world_TDB.sql +++ b/sql/updates/5230_world_TDB.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `npcflag` = `npcflag`|1 WHERE `entry` = 29811;
\ No newline at end of file +UPDATE `creature_template` SET `npcflag` = `npcflag`|1 WHERE `entry` = 29811; diff --git a/sql/updates/5230_world_scripts.sql b/sql/updates/5230_world_scripts.sql index be2610139ac..1426ce683e3 100644 --- a/sql/updates/5230_world_scripts.sql +++ b/sql/updates/5230_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_frostborn_scout' WHERE `entry` = 29811;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_frostborn_scout' WHERE `entry` = 29811; diff --git a/sql/updates/5246_world_scripts.sql b/sql/updates/5246_world_scripts.sql index 850e9eca23e..5d9ef37fe5e 100644 --- a/sql/updates/5246_world_scripts.sql +++ b/sql/updates/5246_world_scripts.sql @@ -1,2 +1 @@ - UPDATE `creature_template` SET `ScriptName`='npc_avatar_of_freya' WHERE `entry`=27801; diff --git a/sql/updates/5254_world_scripts.sql b/sql/updates/5254_world_scripts.sql index 9129ba315cc..6b519bcf925 100644 --- a/sql/updates/5254_world_scripts.sql +++ b/sql/updates/5254_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_taxi' WHERE `entry` = 26602;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_taxi' WHERE `entry` = 26602; diff --git a/sql/updates/5270_world_scripts.sql b/sql/updates/5270_world_scripts.sql index d619618421e..8ddc30c0396 100644 --- a/sql/updates/5270_world_scripts.sql +++ b/sql/updates/5270_world_scripts.sql @@ -27,4 +27,4 @@ INSERT INTO script_waypoint VALUES (24156,25,2307.53, -6031.23, 2.93796, 0, ''), (24156,26,2309.46, -6024.45, 3.65369, 5000, ''); -UPDATE creature_template SET ScriptName = 'npc_plaguehound_tracker' WHERE entry = 24156;
\ No newline at end of file +UPDATE creature_template SET ScriptName = 'npc_plaguehound_tracker' WHERE entry = 24156; diff --git a/sql/updates/5300_world_scripts_dk.sql b/sql/updates/5300_world_scripts_dk.sql index d42cbf416fd..d63773d3466 100644 --- a/sql/updates/5300_world_scripts_dk.sql +++ b/sql/updates/5300_world_scripts_dk.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `KillCredit1` = '29519' WHERE `entry` IN ('29519','29520','29565','29566','29567');
\ No newline at end of file +UPDATE `creature_template` SET `KillCredit1` = '29519' WHERE `entry` IN ('29519','29520','29565','29566','29567'); diff --git a/sql/updates/5305_world_scripts.sql b/sql/updates/5305_world_scripts.sql index fae920db622..0aa6bce7726 100644 --- a/sql/updates/5305_world_scripts.sql +++ b/sql/updates/5305_world_scripts.sql @@ -1,2 +1 @@ - UPDATE `creature_template` SET `ScriptName`='npc_keristrasza' WHERE `entry`=26206; diff --git a/sql/updates/5354_8402_characters_guild_bank_eventlog.sql b/sql/updates/5354_8402_characters_guild_bank_eventlog.sql index deda8036003..24e7f95bbdc 100644 --- a/sql/updates/5354_8402_characters_guild_bank_eventlog.sql +++ b/sql/updates/5354_8402_characters_guild_bank_eventlog.sql @@ -20,4 +20,4 @@ CREATE TABLE `guild_bank_eventlog` ( -- The reason i decided for such dramatic change is that old guild_bank_eventlog table used `TabId` = 0 for Money events and -- used `LogGuid` from 0 to infinity --- New system uses `LogGuid` from 0 to number defined in config.
\ No newline at end of file +-- New system uses `LogGuid` from 0 to number defined in config. diff --git a/sql/updates/5354_8402_characters_guild_eventlog.sql b/sql/updates/5354_8402_characters_guild_eventlog.sql index 71030c5a609..8aa72225b3d 100644 --- a/sql/updates/5354_8402_characters_guild_eventlog.sql +++ b/sql/updates/5354_8402_characters_guild_eventlog.sql @@ -17,4 +17,4 @@ CREATE TABLE `guild_eventlog` ( -- The reason i decided for such dramatic change is that old guild_eventlog table didn't have Primary key and -- used LogGuids from 0 to infinity --- New system uses LogGuids from 0 to number defined in config.
\ No newline at end of file +-- New system uses LogGuids from 0 to number defined in config. diff --git a/sql/updates/5360_8409_characters_guild.sql b/sql/updates/5360_8409_characters_guild.sql index db517e723b6..503570504fb 100644 --- a/sql/updates/5360_8409_characters_guild.sql +++ b/sql/updates/5360_8409_characters_guild.sql @@ -14,4 +14,4 @@ ALTER TABLE guild ADD COLUMN createdate bigint(20) NOT NULL default '0' AFTER mo -- copy data to new column UPDATE guild set createdate = created_temp; -- remove old column -ALTER TABLE guild DROP COLUMN created_temp;
\ No newline at end of file +ALTER TABLE guild DROP COLUMN created_temp; diff --git a/sql/updates/5416_world_spell_dbc.sql b/sql/updates/5416_world_spell_dbc.sql index 0669b9096b3..15af83e4c05 100644 --- a/sql/updates/5416_world_spell_dbc.sql +++ b/sql/updates/5416_world_spell_dbc.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_dbc` WHERE `Id` IN(65142); INSERT INTO `spell_dbc` (`Id`, `Dispel`, `Mechanic`, `AttributesEx3`, `DurationIndex`, `RangeIndex`, `Effect1`, `EffectImplicitTargetA1`, `EffectApplyAuraName1`, `EffectMiscValue1`, `SpellFamilyName`, `SchoolMask`, `Comment`) VALUES -(65142, 3, 22, 0x00000080, 21, 13, 6, 6, 255, 22, 15, 8, 'Crypt Fever - SPELL_AURA_LINKED');
\ No newline at end of file +(65142, 3, 22, 0x00000080, 21, 13, 6, 6, 255, 22, 15, 8, 'Crypt Fever - SPELL_AURA_LINKED'); diff --git a/sql/updates/5435_world_spell_script_target.sql b/sql/updates/5435_world_spell_script_target.sql index 92fb9651790..c449fcae8b6 100644 --- a/sql/updates/5435_world_spell_script_target.sql +++ b/sql/updates/5435_world_spell_script_target.sql @@ -1,2 +1,3 @@ # Chicken Net -INSERT INTO `spell_script_target` ( `entry`, `type`, `targetEntry`) VALUES ('51959', '1', '28161');
\ No newline at end of file +DELETE FROM `spell_script_target` WHERE `entry` = '51959'; +INSERT INTO `spell_script_target` ( `entry`, `type`, `targetEntry`) VALUES ('51959', '1', '28161'); diff --git a/sql/updates/5441_world_spell_bonus_data.sql b/sql/updates/5441_world_spell_bonus_data.sql index fa8865171de..a51c550aec8 100644 --- a/sql/updates/5441_world_spell_bonus_data.sql +++ b/sql/updates/5441_world_spell_bonus_data.sql @@ -1,4 +1,4 @@ DELETE FROM `spell_bonus_data` WHERE `entry` IN(53733, 31804); INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES (53733, 0.22, -1, 0.14, -1, 'Paladin - Judgement of Corruption'), -(31804, 0.22, -1, 0.14, -1, 'Paladin - Judgement of Vengeance');
\ No newline at end of file +(31804, 0.22, -1, 0.14, -1, 'Paladin - Judgement of Vengeance'); diff --git a/sql/updates/5445_world.sql b/sql/updates/5445_world.sql index f2e0fb79fd1..b2ee1cab216 100644 --- a/sql/updates/5445_world.sql +++ b/sql/updates/5445_world.sql @@ -38,4 +38,4 @@ INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procE -- Berserking (3789, 0, 1.0,0), -- Blade Ward -(3869, 0, 1.0,0);
\ No newline at end of file +(3869, 0, 1.0,0); diff --git a/sql/updates/5450_world_spell_proc_event.sql b/sql/updates/5450_world_spell_proc_event.sql index 73206c7770a..78bd7fab34e 100644 --- a/sql/updates/5450_world_spell_proc_event.sql +++ b/sql/updates/5450_world_spell_proc_event.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN(46913, 46914, 46915); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES ( 46913, 0x00, 4, 0x00000040, 0x00000404, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Bloodsurge (Rank 1) ( 46914, 0x00, 4, 0x00000040, 0x00000404, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Bloodsurge (Rank 2) -( 46915, 0x00, 4, 0x00000040, 0x00000404, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Bloodsurge (Rank 3)
\ No newline at end of file +( 46915, 0x00, 4, 0x00000040, 0x00000404, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Bloodsurge (Rank 3) diff --git a/sql/updates/5462_world_scripts.sql b/sql/updates/5462_world_scripts.sql index 278244dd2c7..97d2915874d 100644 --- a/sql/updates/5462_world_scripts.sql +++ b/sql/updates/5462_world_scripts.sql @@ -7,5 +7,3 @@ INSERT INTO `creature_ai_scripts` () VALUES (2122005, 21220, 6, 0, 100, 3, 0, 0, 0, 0, 34, 25, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Coilfang Priestess - Set Instance Data 1'), (2130101, 21301, 0, 0, 100, 3, 14100, 14100, 21000, 21500, 11, 38591, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Coilfang Shatterer - Casts Shatter Armor'), (2130102, 21301, 6, 0, 100, 3, 0, 0, 0, 0, 34, 25, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Coilfang Shatterer - Set Instance Data 1'); - - diff --git a/sql/updates/5469_world_creature.sql b/sql/updates/5469_world_creature.sql index 4b34548dbbb..0fe2c0cb171 100644 --- a/sql/updates/5469_world_creature.sql +++ b/sql/updates/5469_world_creature.sql @@ -1 +1 @@ -DELETE FROM `creature` WHERE `map`=30;
\ No newline at end of file +DELETE FROM `creature` WHERE `map`=30; diff --git a/sql/updates/5482_world_scripts_waypoint_TDB.sql b/sql/updates/5482_world_scripts_waypoint_TDB.sql index c041d005808..6903f495a2a 100644 --- a/sql/updates/5482_world_scripts_waypoint_TDB.sql +++ b/sql/updates/5482_world_scripts_waypoint_TDB.sql @@ -1 +1 @@ -Update waypoint_scripts set datalong=83 where datalong=169 and command=2;
\ No newline at end of file +Update waypoint_scripts set datalong=83 where datalong=169 and command=2; diff --git a/sql/updates/5484_world_scripts.sql b/sql/updates/5484_world_scripts.sql index 4d468a359ec..6009b133343 100644 --- a/sql/updates/5484_world_scripts.sql +++ b/sql/updates/5484_world_scripts.sql @@ -1 +1 @@ -update creature_template set inhabittype=3 where entry=21217;
\ No newline at end of file +update creature_template set inhabittype=3 where entry=21217; diff --git a/sql/updates/5491_world_scripts_ulduar.sql b/sql/updates/5491_world_scripts_ulduar.sql index a3091fafeaf..9bcb0c65618 100644 --- a/sql/updates/5491_world_scripts_ulduar.sql +++ b/sql/updates/5491_world_scripts_ulduar.sql @@ -1,4 +1,4 @@ INSERT INTO creature_template (entry, vehicleid) VALUES (32930, 328) # Kologarn ON DUPLICATE KEY UPDATE -vehicleid = VALUES(vehicleid);
\ No newline at end of file +vehicleid = VALUES(vehicleid); diff --git a/sql/updates/5513_world_wintergrasp.sql b/sql/updates/5513_world_wintergrasp.sql index 241f80288a0..8594ce26754 100644 --- a/sql/updates/5513_world_wintergrasp.sql +++ b/sql/updates/5513_world_wintergrasp.sql @@ -1 +1 @@ -update game_graveyard_zone set ghost_zone = 4603 where id = 1474;
\ No newline at end of file +update game_graveyard_zone set ghost_zone = 4603 where id = 1474; diff --git a/sql/updates/5524_world_scripts.sql b/sql/updates/5524_world_scripts.sql index 22f9e6763ab..8e52da00ea5 100644 --- a/sql/updates/5524_world_scripts.sql +++ b/sql/updates/5524_world_scripts.sql @@ -7,4 +7,4 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES UPDATE creature_template SET VehicleId = 165 , spell1 = 56091,spell2 = 56092,spell3 = 57090,spell4 = 57143 ,spell5 = 57108,spell6=57403, unit_class = 1, minhealth = 100000, maxhealth = 100000 WHERE entry = 32535; UPDATE creature_template SET armor = 9729, mindmg = 422, maxdmg=586, minrangedmg=345, maxrangedmg=509, attackpower=642, rangedattackpower=103 WHERE entry = 32535; -update creature set DeathState = 0 where id = 26219;
\ No newline at end of file +update creature set DeathState = 0 where id = 26219; diff --git a/sql/updates/5532_8433_characters_character_account_data.sql b/sql/updates/5532_8433_characters_character_account_data.sql index a4569b76639..a1fad645d2b 100644 --- a/sql/updates/5532_8433_characters_character_account_data.sql +++ b/sql/updates/5532_8433_characters_character_account_data.sql @@ -13,4 +13,4 @@ INSERT INTO character_account_data SELECT c.guid as guid, a.type as type, a.time as time, a.data as data FROM characters c LEFT JOIN account_data a ON c.account = a.account WHERE a.type IN (1, 3, 5, 6, 7); -DELETE FROM account_data WHERE type IN (1, 3, 5, 6, 7);
\ No newline at end of file +DELETE FROM account_data WHERE type IN (1, 3, 5, 6, 7); |