diff options
Diffstat (limited to 'sql')
181 files changed, 286 insertions, 100 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index ab549ab0ea1..751aaedf6e1 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -1363,3 +1363,4 @@ UNLOCK TABLES; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2008-11-18 11:24:11 + diff --git a/sql/create_mysql.sql b/sql/create_mysql.sql index f71ced7d07d..2932595939e 100644 --- a/sql/create_mysql.sql +++ b/sql/create_mysql.sql @@ -12,3 +12,4 @@ GRANT ALL PRIVILEGES ON `characters` . * TO 'trinity'@'localhost' WITH GRANT OPT GRANT ALL PRIVILEGES ON `realmd` . * TO 'trinity'@'localhost' WITH GRANT OPTION; + diff --git a/sql/drop_mysql.sql b/sql/drop_mysql.sql index 1f2bf090ef8..e2ae8a3a7de 100644 --- a/sql/drop_mysql.sql +++ b/sql/drop_mysql.sql @@ -19,3 +19,4 @@ DROP DATABASE IF EXISTS `world` ; DROP DATABASE IF EXISTS `characters` ; DROP DATABASE IF EXISTS `realmd` ; + diff --git a/sql/realmd.sql b/sql/realmd.sql index d60d88c434e..3e0b3774145 100644 --- a/sql/realmd.sql +++ b/sql/realmd.sql @@ -158,3 +158,4 @@ UNLOCK TABLES; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2008-10-14 13:28:11 + diff --git a/sql/tools/characters_item_duplicates_remove.sql b/sql/tools/characters_item_duplicates_remove.sql index 9cdd8738ecd..fdd88262b2e 100644 --- a/sql/tools/characters_item_duplicates_remove.sql +++ b/sql/tools/characters_item_duplicates_remove.sql @@ -20,3 +20,4 @@ DELETE FROM guild_bank_item WHERE item_guid IN (SELECT item_guid FROM item_test DELETE FROM guild_bank_item WHERE item_guid IN (SELECT item_guid FROM item_test WHERE `source`='m'); DROP TABLE IF EXISTS item_test; + diff --git a/sql/tools/characters_pet_data_cleanup.sql b/sql/tools/characters_pet_data_cleanup.sql index f4454ca856f..06c48882780 100644 --- a/sql/tools/characters_pet_data_cleanup.sql +++ b/sql/tools/characters_pet_data_cleanup.sql @@ -1,3 +1,4 @@ DELETE FROM pet_aura WHERE guid NOT IN (SELECT id FROM character_pet); DELETE FROM pet_spell WHERE guid NOT IN (SELECT id FROM character_pet); DELETE FROM pet_spell_cooldown WHERE guid NOT IN (SELECT id FROM character_pet); + diff --git a/sql/trinityscript_script_texts.sql b/sql/trinityscript_script_texts.sql index 5b1a8d632c1..b2d0e8c1471 100644 --- a/sql/trinityscript_script_texts.sql +++ b/sql/trinityscript_script_texts.sql @@ -1087,4 +1087,5 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, -- Below just for beautiful view in table, run at own desire -- --- ALTER TABLE `script_texts` ORDER BY `entry` desc;
\ No newline at end of file +-- ALTER TABLE `script_texts` ORDER BY `entry` desc; + diff --git a/sql/updates/1018_world.sql b/sql/updates/1018_world.sql index d231eb168b9..89a13686d8a 100644 --- a/sql/updates/1018_world.sql +++ b/sql/updates/1018_world.sql @@ -4,3 +4,4 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comm (41292, 42017, 2, 'Aura of Suffering'), (44007, -43657, 2, 'Storm Eye Safe Zone Immune'), (44867, -46019, 2, 'Spectral Exhaustion - Teleport: Spectral Realm'); + diff --git a/sql/updates/1026_world.sql b/sql/updates/1026_world.sql index ae189469b41..1ed2e34316a 100644 --- a/sql/updates/1026_world.sql +++ b/sql/updates/1026_world.sql @@ -3,3 +3,4 @@ INSERT INTO `spell_linked_spell`(`spell_trigger`,`spell_effect`,`type`,`comment` ('-33711','33686','0','Murmur\'s Shockwave (Normal)'), ('-38794','33686','0','Murmur\'s Shockwave (Heroic)'), ('33686','31705','0','Murmur\'s Shockwave Jump'); + diff --git a/sql/updates/1028_world_scripts.sql b/sql/updates/1028_world_scripts.sql index 9c821c7b093..21891693f29 100644 --- a/sql/updates/1028_world_scripts.sql +++ b/sql/updates/1028_world_scripts.sql @@ -1 +1,2 @@ UPDATE `creature_template` SET `ScriptName`='boss_the_black_stalker' WHERE `entry`='17882'; + diff --git a/sql/updates/102_world.sql b/sql/updates/102_world.sql index 6cbf3d1a6b4..b3818da5b9f 100644 --- a/sql/updates/102_world.sql +++ b/sql/updates/102_world.sql @@ -1,2 +1,3 @@ ALTER TABLE `quest_template` ADD `RewHonorableKills` mediumint(9) unsigned NOT NULL default '0' AFTER `RewRepValue5`; + diff --git a/sql/updates/1069_world_scripts.sql b/sql/updates/1069_world_scripts.sql index 0fafabf63f1..1f3b7a728e9 100644 --- a/sql/updates/1069_world_scripts.sql +++ b/sql/updates/1069_world_scripts.sql @@ -9,4 +9,5 @@ INSERT INTO `spell_script_target` (`entry`,`type`,`targetEntry`) VALUES ('32314', '2', '17138'), ('32314', '2', '18037'), ('32314', '2', '18064'), -('32314', '2', '18065');
\ No newline at end of file +('32314', '2', '18065'); + diff --git a/sql/updates/1073_world_scripts.sql b/sql/updates/1073_world_scripts.sql new file mode 100644 index 00000000000..038f5f79466 --- /dev/null +++ b/sql/updates/1073_world_scripts.sql @@ -0,0 +1,2 @@ +update creature_template set scriptname = 'npc_plains_vision' where entry = 2983; + diff --git a/sql/updates/1074_world_scripts.sql b/sql/updates/1074_world_scripts.sql new file mode 100644 index 00000000000..4ed882ffea5 --- /dev/null +++ b/sql/updates/1074_world_scripts.sql @@ -0,0 +1,2 @@ +update creature_template set scriptname = 'npc_plucky' where entry in (6626); + diff --git a/sql/updates/112_world_scripts.sql b/sql/updates/112_world_scripts.sql index e48ed250741..f812c6f3c68 100644 --- a/sql/updates/112_world_scripts.sql +++ b/sql/updates/112_world_scripts.sql @@ -1,2 +1,3 @@ UPDATE `item_template` SET `ScriptName`='item_arcane_charges' WHERE `entry`='34475'; -UPDATE gameobject_template SET faction = 14 WHERE entry = 185134;
\ No newline at end of file +UPDATE gameobject_template SET faction = 14 WHERE entry = 185134; + diff --git a/sql/updates/116_world.sql b/sql/updates/116_world.sql index 7627dfb4aa3..9923f7f4540 100644 --- a/sql/updates/116_world.sql +++ b/sql/updates/116_world.sql @@ -5,4 +5,5 @@ INSERT INTO `spell_script_target` VALUES ('41455', '1', '22951'); INSERT INTO `spell_script_target` VALUES ('41455', '1', '22952'); INSERT INTO `spell_script_target` VALUES ('42471', '1', '23817'); INSERT INTO `spell_script_target` VALUES ('43734', '1', '23817'); -INSERT INTO `spell_script_target` VALUES ('42631', '1', '23920');
\ No newline at end of file +INSERT INTO `spell_script_target` VALUES ('42631', '1', '23920'); + diff --git a/sql/updates/117_world_scripts.sql b/sql/updates/117_world_scripts.sql index 794258ba710..669810b4685 100644 --- a/sql/updates/117_world_scripts.sql +++ b/sql/updates/117_world_scripts.sql @@ -62,3 +62,4 @@ UPDATE eventai_scripts SET action3_param3=(`action3_param3`) *-1 WHERE action3_t UPDATE eventai_texts SET entry=(`entry`) *-1 WHERE entry>0; ALTER TABLE script_texts MODIFY COLUMN `sound` mediumint(8) unsigned NOT NULL default '0'; + diff --git a/sql/updates/11_characters.sql b/sql/updates/11_characters.sql index a9a002270fb..489ee028dbc 100644 --- a/sql/updates/11_characters.sql +++ b/sql/updates/11_characters.sql @@ -2,4 +2,5 @@ ALTER TABLE `arena_team_member` ADD COLUMN `points_to_add` int(10) UNSIGNED NOT DROP TABLE IF EXISTS `saved_variables`; CREATE TABLE `saved_variables` ( `NextArenaPointDistributionTime` timestamp NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
\ No newline at end of file +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves'; + diff --git a/sql/updates/120_world.sql b/sql/updates/120_world.sql index 3f3b231e830..f2ff5138745 100644 --- a/sql/updates/120_world.sql +++ b/sql/updates/120_world.sql @@ -159,4 +159,5 @@ INSERT INTO command VALUES ('server exit',4,'Syntax: .server exit\r\n\r\nTerminate Trinity NOW.'), ('server motd',0,'Syntax: .server motd\r\n\r\nShow server Message of the day.'), ('server set loglevel',4,'Syntax: .server set loglevel #level\r\n\r\nSet server log level (0 - errors only, 1 - basic, 2 - detail, 3 - debug).'), -('server set motd',3,'Syntax: .server set motd $MOTD\r\n\r\nSet server Message of the day.');
\ No newline at end of file +('server set motd',3,'Syntax: .server set motd $MOTD\r\n\r\nSet server Message of the day.'); + diff --git a/sql/updates/123_world_scripts.sql b/sql/updates/123_world_scripts.sql index b5f9305e30e..7281193a208 100644 --- a/sql/updates/123_world_scripts.sql +++ b/sql/updates/123_world_scripts.sql @@ -213,3 +213,4 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, -- -- ALTER TABLE `script_texts` ORDER BY `entry` desc; + diff --git a/sql/updates/125_world_scripts.sql b/sql/updates/125_world_scripts.sql index 9994c0e7af7..5d28ec325b5 100644 --- a/sql/updates/125_world_scripts.sql +++ b/sql/updates/125_world_scripts.sql @@ -2,4 +2,5 @@ update creature_template set speed='0.01', scriptname='mob_toxic_sporebat' WHERE update creature_template SET scriptname='npc_overlord_morghor' WHERE entry=23139; update creature_template SET scriptname='npc_lord_illidan_stormrage' WHERE entry=22083; update creature_template SET scriptname='npc_yarzill_the_merc' WHERE entry=23141; -update quest_template SET StartScript=0 WHERE entry=11108;
\ No newline at end of file +update quest_template SET StartScript=0 WHERE entry=11108; + diff --git a/sql/updates/133_world_scripts.sql b/sql/updates/133_world_scripts.sql index 057f7c44e81..cd082ee2ad9 100644 --- a/sql/updates/133_world_scripts.sql +++ b/sql/updates/133_world_scripts.sql @@ -77,4 +77,5 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, (-1560019,'Thrall will remain a slave. Taretha will die. You have failed.',10426,1,0,'epoch SAY_SLAY2'), (-1560020,'Not so fast!',10423,1,0,'epoch SAY_BREATH1'), (-1560021,'Struggle as much as you like!',10424,1,0,'epoch SAY_BREATH2'), -(-1560022,'No!...The master... will not... be pleased.',10427,1,0,'epoch SAY_DEATH');
\ No newline at end of file +(-1560022,'No!...The master... will not... be pleased.',10427,1,0,'epoch SAY_DEATH'); + diff --git a/sql/updates/140_world.sql b/sql/updates/140_world.sql index 6a7389602b6..a743fa69fee 100644 --- a/sql/updates/140_world.sql +++ b/sql/updates/140_world.sql @@ -18,4 +18,5 @@ INSERT INTO trinity_string VALUES (341,'%s is not following you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (342,'%s is now not following you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (810,'You must be in a raid group to enter the instance %s!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(811,'You cannot enter %s while in a ghost mode!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file +(811,'You cannot enter %s while in a ghost mode!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); + diff --git a/sql/updates/145_world_scripts.sql b/sql/updates/145_world_scripts.sql index 5ec3702b171..1d9341dd6a4 100644 --- a/sql/updates/145_world_scripts.sql +++ b/sql/updates/145_world_scripts.sql @@ -24,4 +24,5 @@ UPDATE `gameobject_template` SET `ScriptName` = 'go_kael_orb' WHERE `entry` = 18 UPDATE `gameobject_template` SET `ScriptName` = 'go_movie_orb' WHERE `entry` = 187578; update creature_template SET spell1=6474 WHERE entry=22487; -update creature_template SET spell1=3600 WHERE entry=22486;
\ No newline at end of file +update creature_template SET spell1=3600 WHERE entry=22486; + diff --git a/sql/updates/146_world.sql b/sql/updates/146_world.sql index 31999cd97e4..bc419f47181 100644 --- a/sql/updates/146_world.sql +++ b/sql/updates/146_world.sql @@ -90,4 +90,5 @@ VALUES INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES - (45246, 45348, 1, 'Apply Flame Touched');
\ No newline at end of file + (45246, 45348, 1, 'Apply Flame Touched'); + diff --git a/sql/updates/147_world.sql b/sql/updates/147_world.sql index c6e75d41070..a6dca5be3db 100644 --- a/sql/updates/147_world.sql +++ b/sql/updates/147_world.sql @@ -1,3 +1,4 @@ -- Magtheridon Earthquake DELETE FROM spell_script_target WHERE `entry` IN (30657); -INSERT INTO spell_script_target VALUES ('30657', '1', '24136');
\ No newline at end of file +INSERT INTO spell_script_target VALUES ('30657', '1', '24136'); + diff --git a/sql/updates/152_world.sql b/sql/updates/152_world.sql index 3b3d09c56d3..52d02a13258 100644 --- a/sql/updates/152_world.sql +++ b/sql/updates/152_world.sql @@ -5,4 +5,5 @@ insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comm insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) values('27799','27803','0','Holy Nova (rank4)'); insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) values('27800','27804','0','Holy Nova (rank5)'); insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) values('27801','27805','0','Holy Nova (rank6)'); -insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) values('25331','25329','0','Holy Nova (rank7)');
\ No newline at end of file +insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) values('25331','25329','0','Holy Nova (rank7)'); + diff --git a/sql/updates/153_world.sql b/sql/updates/153_world.sql index dbff1592850..5b135c844d6 100644 --- a/sql/updates/153_world.sql +++ b/sql/updates/153_world.sql @@ -1 +1,2 @@ -update creature_template set flags_extra = 128 where entry = 12999;
\ No newline at end of file +update creature_template set flags_extra = 128 where entry = 12999; + diff --git a/sql/updates/171_world.sql b/sql/updates/171_world.sql index fdcd98f4d6e..f7c9105eb38 100644 --- a/sql/updates/171_world.sql +++ b/sql/updates/171_world.sql @@ -14,4 +14,5 @@ INSERT INTO `command` (name,security,help) VALUES ('pet tp',2,'Syntax: .pet tp #\r\n\r\nChange pet\'s amount of training points.'), ('modify gender',2,'Syntax: .modify gender\r\n\r\n.modify gender #male/female - Turns selected player into a male or female'), ('gobject activate',2,'Syntax: .gobject activate #guid\r\n\r\nActivates an object like a door or a button.'), -('playall',2,'Syntax: .playall #soundid\r\n\r\nPlayer a sound to whole server.');
\ No newline at end of file +('playall',2,'Syntax: .playall #soundid\r\n\r\nPlayer a sound to whole server.'); + diff --git a/sql/updates/172_world_scripts.sql b/sql/updates/172_world_scripts.sql index 358afe538ed..82de4e3eb2a 100644 --- a/sql/updates/172_world_scripts.sql +++ b/sql/updates/172_world_scripts.sql @@ -776,3 +776,4 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, (-1000103,'You can go tell Stoutmantle this is where the Defias Gang is holed up, $N.',0,0,7,'defias traitor SAY_END'), (-1000104,'%s coming in fast! Prepare to fight!',0,0,7,'defias traitor SAY_AGGRO_1'), (-1000105,'Help!',0,0,7,'defias traitor SAY_AGGRO_2'); + diff --git a/sql/updates/175_world_scripts.sql b/sql/updates/175_world_scripts.sql index d30601c4c9c..dc46a67737f 100644 --- a/sql/updates/175_world_scripts.sql +++ b/sql/updates/175_world_scripts.sql @@ -1 +1,2 @@ -UPDATE `creature_template` SET `ScriptName`='npc_defias_traitor' WHERE `entry`='467';
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_defias_traitor' WHERE `entry`='467'; + diff --git a/sql/updates/176_world.sql b/sql/updates/176_world.sql index 12df2a083ca..2cb80bd25a2 100644 --- a/sql/updates/176_world.sql +++ b/sql/updates/176_world.sql @@ -30,3 +30,4 @@ CREATE TABLE `locales_npc_option` ( ALTER TABLE `creature_template` CHANGE COLUMN `flags` `unit_flags` int(10) unsigned NOT NULL default '0', CHANGE COLUMN `flag1` `type_flags` int(10) unsigned NOT NULL default '0'; + diff --git a/sql/updates/182_world.sql b/sql/updates/182_world.sql index 450b5394720..70c200b5144 100644 --- a/sql/updates/182_world.sql +++ b/sql/updates/182_world.sql @@ -2,3 +2,4 @@ DELETE FROM `command` WHERE name IN ('possess', 'unpossess'); INSERT INTO `command` (name,security,help) VALUES ('possess',3,'Syntax: .possess\r\n\r\nPossesses indefinitely the selected creature.'), ('unpossess',3,'Syntax: .unpossess\r\n\r\nIf you are possessed, unpossesses yourself; otherwise unpossesses current possessed target.'); + diff --git a/sql/updates/212_world_scripts.sql b/sql/updates/212_world_scripts.sql index 1427efde6e3..b1c6a4cad0e 100644 --- a/sql/updates/212_world_scripts.sql +++ b/sql/updates/212_world_scripts.sql @@ -2,4 +2,5 @@ UPDATE `creature_template` SET `ScriptName`='npc_clintar_dreamwalker' WHERE `ent UPDATE `creature_template` SET `ScriptName`='npc_clintar_spirit' WHERE `entry` = 22916; UPDATE `creature_template` SET `ScriptName`='mob_sparrowhawk' WHERE `entry`=22979; UPDATE `creature_template` SET `ScriptName`='mob_rizzle_sprysprocket' WHERE `entry`=23002; -UPDATE `creature_template` SET `ScriptName`='mob_depth_charge' WHERE `entry`=23025;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='mob_depth_charge' WHERE `entry`=23025; + diff --git a/sql/updates/220_characters.sql b/sql/updates/220_characters.sql index 1d9e3f50a33..5075f2e3b54 100644 --- a/sql/updates/220_characters.sql +++ b/sql/updates/220_characters.sql @@ -1,2 +1,3 @@ ALTER TABLE `characters` - ADD `latency` int(11) unsigned NOT NULL default '0' AFTER `taxi_path`;
\ No newline at end of file + ADD `latency` int(11) unsigned NOT NULL default '0' AFTER `taxi_path`; + diff --git a/sql/updates/230_world.sql b/sql/updates/230_world.sql index 3f3565e7800..edb46971753 100644 --- a/sql/updates/230_world.sql +++ b/sql/updates/230_world.sql @@ -1,2 +1,3 @@ UPDATE `spell_proc_event` SET `procFlags` = '8396800' WHERE `entry` =14774; UPDATE `spell_proc_event` SET `procFlags` = '8396800' WHERE `entry` =14531; + diff --git a/sql/updates/230_world_blacktemple.sql b/sql/updates/230_world_blacktemple.sql index 74345a7c51f..20823b188f6 100644 --- a/sql/updates/230_world_blacktemple.sql +++ b/sql/updates/230_world_blacktemple.sql @@ -22,4 +22,5 @@ update creature_template set scriptname = 'mob_blade_of_azzinoth' where entry = -- parasitic shadowfiend update creature_template set scriptname = 'mob_parasitic_shadowfiend' where entry = 23498; -- Maiev -update creature_template set minlevel = 73, maxlevel = 73, minhealth = 500000, maxhealth = 500000, mindmg = 3000, maxdmg = 4000 where entry = 23197;
\ No newline at end of file +update creature_template set minlevel = 73, maxlevel = 73, minhealth = 500000, maxhealth = 500000, mindmg = 3000, maxdmg = 4000 where entry = 23197; + diff --git a/sql/updates/230_world_scripts.sql b/sql/updates/230_world_scripts.sql index 34d3ee5707f..a188fd28580 100644 --- a/sql/updates/230_world_scripts.sql +++ b/sql/updates/230_world_scripts.sql @@ -1 +1,2 @@ -update gameobject_template set scriptname = 'go_gilded_brazier' where entry = 181956;
\ No newline at end of file +update gameobject_template set scriptname = 'go_gilded_brazier' where entry = 181956; + diff --git a/sql/updates/230_world_serpent_shrine.sql b/sql/updates/230_world_serpent_shrine.sql index 0e16bd6de2b..c957af10acc 100644 --- a/sql/updates/230_world_serpent_shrine.sql +++ b/sql/updates/230_world_serpent_shrine.sql @@ -11,3 +11,4 @@ UPDATE creature_model_info SET bounding_radius = '13', combat_reach = '20' WHERE UPDATE creature_template SET InhabitType = '3', ScriptName = 'boss_the_lurker_below' WHERE entry = '21217'; UPDATE creature_template SET ScriptName = 'mob_coilfang_ambusher' WHERE entry = '21865'; UPDATE creature_template SET ScriptName = 'mob_coilfang_guardian' WHERE entry = '21873'; + diff --git a/sql/updates/231_world_scripts.sql b/sql/updates/231_world_scripts.sql index b07f7b47fef..35d58244e43 100644 --- a/sql/updates/231_world_scripts.sql +++ b/sql/updates/231_world_scripts.sql @@ -1,3 +1,4 @@ UPDATE `creature_template` SET `ScriptName`='boss_pathaleon_the_calculator' WHERE `entry`=19220; UPDATE `creature_template` SET `ScriptName`='mob_nether_wraith' WHERE `entry`=21062; -UPDATE `instance_template` SET `script`='instance_mechanar' WHERE `map`=554;
\ No newline at end of file +UPDATE `instance_template` SET `script`='instance_mechanar' WHERE `map`=554; + diff --git a/sql/updates/233_world.sql b/sql/updates/233_world.sql index e77d057cae4..8d29b83a4fa 100644 --- a/sql/updates/233_world.sql +++ b/sql/updates/233_world.sql @@ -1 +1,2 @@ UPDATE `spell_proc_event` SET `SchoolMask` = '1' WHERE `entry` = '41434'; + diff --git a/sql/updates/238_world.sql b/sql/updates/238_world.sql index c1180ca0abd..1b70eeaf0ac 100644 --- a/sql/updates/238_world.sql +++ b/sql/updates/238_world.sql @@ -1 +1,2 @@ -DELETE FROM trinity_string WHERE entry IN (453);
\ No newline at end of file +DELETE FROM trinity_string WHERE entry IN (453); + diff --git a/sql/updates/240_world.sql b/sql/updates/240_world.sql index 9a91607fed0..44e7c518e83 100644 --- a/sql/updates/240_world.sql +++ b/sql/updates/240_world.sql @@ -2,4 +2,5 @@ delete from `command` where `name` IN ('senditems','sendmail'); insert into `command` (`name`, `security`, `help`) values ('senditems',3,'Syntax: .senditems #playername "#subject" "#text" itemid1[:count1] itemid2[:count2] ... itemidN[:countN]\r\n\r\nSend a mail to a player. Subject and mail text must be in "". If for itemid not provided related count values then expected 1, if count > max items in stack then items will be send in required amount stacks. All stacks amount in mail limited to 12.'), ('sendmail',1,'Syntax: .sendmail #playername "#subject" "#text"\r\n\r\nSend a mail to a player. Subject and mail text must be in "".'); -
\ No newline at end of file + + diff --git a/sql/updates/241_world.sql b/sql/updates/241_world.sql index 2bc028b3eba..4aa3ae99b94 100644 --- a/sql/updates/241_world.sql +++ b/sql/updates/241_world.sql @@ -2,3 +2,4 @@ DELETE FROM `command` WHERE name IN ('bindsight', 'unbindsight'); INSERT INTO `command` (name,security,help) VALUES ('bindsight',3,'Syntax: .bindsight\r\n\r\nBinds vision to the selected unit indefinitely. Cannot be used while currently possessing a target.'), ('unbindsight',3,'Syntax: .unbindsight\r\n\r\nRemoves bound vision. Cannot be used while currently possessing a target.'); + diff --git a/sql/updates/247_world.sql b/sql/updates/247_world.sql index a47e9733bcf..95a087d1a20 100644 --- a/sql/updates/247_world.sql +++ b/sql/updates/247_world.sql @@ -26,4 +26,5 @@ INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `commen DELETE FROM spell_target_position WHERE `id` IN (46019, 46020); INSERT INTO spell_target_position () VALUES (46019, 580, 1704.34, 928.17, -74.558, 0); -INSERT INTO spell_target_position () VALUES (46020, 580, 1704.34, 928.17, 53.079, 0);
\ No newline at end of file +INSERT INTO spell_target_position () VALUES (46020, 580, 1704.34, 928.17, 53.079, 0); + diff --git a/sql/updates/262_characters.sql b/sql/updates/262_characters.sql index b3caa9704f0..093078d148d 100644 --- a/sql/updates/262_characters.sql +++ b/sql/updates/262_characters.sql @@ -3,3 +3,4 @@ ALTER TABLE `guild_bank_tab` ALTER TABLE `character_aura` ADD `stackcount` INT NOT NULL DEFAULT '1' AFTER `effect_index` ; ALTER TABLE `pet_aura` ADD `stackcount` INT NOT NULL DEFAULT '1' AFTER `effect_index`; + diff --git a/sql/updates/262_realmd.sql b/sql/updates/262_realmd.sql index 1953f19fe28..28dc64111c1 100644 --- a/sql/updates/262_realmd.sql +++ b/sql/updates/262_realmd.sql @@ -1,2 +1,3 @@ ALTER TABLE `account` CHANGE COLUMN `email` `email` text; + diff --git a/sql/updates/262_world.sql b/sql/updates/262_world.sql index 6c97d9798d5..cd90a3df696 100644 --- a/sql/updates/262_world.sql +++ b/sql/updates/262_world.sql @@ -98,4 +98,5 @@ ALTER TABLE creature_movement ADD COLUMN textid2 int(11) NOT NULL default '0' AFTER textid1, ADD COLUMN textid3 int(11) NOT NULL default '0' AFTER textid2, ADD COLUMN textid4 int(11) NOT NULL default '0' AFTER textid3, - ADD COLUMN textid5 int(11) NOT NULL default '0' AFTER textid4;
\ No newline at end of file + ADD COLUMN textid5 int(11) NOT NULL default '0' AFTER textid4; + diff --git a/sql/updates/273_world_scripts.sql b/sql/updates/273_world_scripts.sql index 2979197c734..800f181f882 100644 --- a/sql/updates/273_world_scripts.sql +++ b/sql/updates/273_world_scripts.sql @@ -1,3 +1,4 @@ UPDATE `creature_template` SET `ScriptName`='npc_wounded_blood_elf' WHERE `entry`='16993'; UPDATE `creature_template` SET `ScriptName` = 'mob_phase_hunter' WHERE `entry` = '18879'; + diff --git a/sql/updates/285_world.sql b/sql/updates/285_world.sql index 74825f4b75a..ab9c26ebccb 100644 --- a/sql/updates/285_world.sql +++ b/sql/updates/285_world.sql @@ -37,3 +37,4 @@ INSERT INTO `trinity_string` VALUES (749,'The Stormpike General is Dead!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL) ; + diff --git a/sql/updates/287_world_scripts.sql b/sql/updates/287_world_scripts.sql index 4a0c5031188..f761f897e9d 100644 --- a/sql/updates/287_world_scripts.sql +++ b/sql/updates/287_world_scripts.sql @@ -1,3 +1,4 @@ UPDATE `creature_template` SET `ScriptName` = 'npc_steam_tonk' WHERE `entry` = '19405'; UPDATE `creature_template` SET `ScriptName` = 'npc_tonk_mine' WHERE `entry` = '15368'; + diff --git a/sql/updates/329_world.sql b/sql/updates/329_world.sql index 33f61416fb1..42dd8012cb2 100644 --- a/sql/updates/329_world.sql +++ b/sql/updates/329_world.sql @@ -583,3 +583,4 @@ INSERT INTO `spell_proc_event` VALUES ('28744', '0', '7', '64', '278528', '0', ' INSERT INTO `spell_proc_event` VALUES ('12488', '0', '3', '128', '327680', '0', '0', '0', '0'); INSERT INTO `spell_proc_event` VALUES ('19573', '0', '9', '8388608', '16384', '0', '0', '0', '0'); INSERT INTO `spell_proc_event` VALUES ('33757', '0', '0', '0', '0', '0', '0', '0', '3'); + diff --git a/sql/updates/332_world.sql b/sql/updates/332_world.sql index 912173fcbbf..c1864d6c03a 100644 --- a/sql/updates/332_world.sql +++ b/sql/updates/332_world.sql @@ -1,3 +1,4 @@ DELETE FROM `spell_script_target` WHERE `entry` in (30659); INSERT INTO `spell_script_target` VALUES (30659, 1, 17281); + diff --git a/sql/updates/333_world.sql b/sql/updates/333_world.sql index 9bd405e3589..77c2b476700 100644 --- a/sql/updates/333_world.sql +++ b/sql/updates/333_world.sql @@ -9,3 +9,4 @@ INSERT INTO `spell_proc_event` VALUES ('10608', '0', '0', '0', '0', '0', '0', '0 INSERT INTO `spell_proc_event` VALUES ('10610', '0', '0', '0', '0', '0', '0', '0', '3'); INSERT INTO `spell_proc_event` VALUES ('25583', '0', '0', '0', '0', '0', '0', '0', '3'); INSERT INTO `spell_proc_event` VALUES ('25584', '0', '0', '0', '0', '0', '0', '0', '3'); + diff --git a/sql/updates/334_world.sql b/sql/updates/334_world.sql index 6cd6cb7714a..e7e1c4b328f 100644 --- a/sql/updates/334_world.sql +++ b/sql/updates/334_world.sql @@ -17,4 +17,5 @@ INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_ (784,'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (785,'Arena testing turned %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (786,'|cffff0000[Automatic]:|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(787,'|cffffff00[|c1f40af20Announce by|r |cffff0000%s|cffffff00]:|r %s|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file +(787,'|cffffff00[|c1f40af20Announce by|r |cffff0000%s|cffffff00]:|r %s|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); + diff --git a/sql/updates/341_world.sql b/sql/updates/341_world.sql index 7d1eb4a0c8d..ba02fe06468 100644 --- a/sql/updates/341_world.sql +++ b/sql/updates/341_world.sql @@ -1 +1,2 @@ -TRUNCATE TABLE playercreateinfo_item;
\ No newline at end of file +TRUNCATE TABLE playercreateinfo_item; + diff --git a/sql/updates/356_world.sql b/sql/updates/356_world.sql index 9db8a85d7cd..b7fc8258b7e 100644 --- a/sql/updates/356_world.sql +++ b/sql/updates/356_world.sql @@ -1,2 +1,3 @@ DELETE FROM `spell_elixir` WHERE `entry` = 45373; INSERT INTO `spell_elixir` VALUES (45373,0x1); + diff --git a/sql/updates/373_world_scripts.sql b/sql/updates/373_world_scripts.sql index db27ebe2441..92623b3ec1b 100644 --- a/sql/updates/373_world_scripts.sql +++ b/sql/updates/373_world_scripts.sql @@ -1,3 +1,4 @@ UPDATE `creature_template` SET `ScriptName`='boss_warchief_kargath_bladefist' WHERE `entry`=16808; UPDATE `instance_template` SET `script`='instance_deadmines' WHERE `map`=36; UPDATE `item_template` SET `ScriptName`='item_defias_gunpowder' WHERE `entry`=5397; + diff --git a/sql/updates/377_world_scripts.sql b/sql/updates/377_world_scripts.sql index fe93962ef3a..c7d5bf98e52 100644 --- a/sql/updates/377_world_scripts.sql +++ b/sql/updates/377_world_scripts.sql @@ -8,3 +8,4 @@ INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content (-1645007,'Champion Lightrend, make me proud!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,'master_kelerun_bloodmourn YELL_PHASE'), (-1645008,'Show this upstart how a real Blood Knight fights, Swiftblade!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,'master_kelerun_bloodmourn YELL_PHASE'), (-1645009,'Show $N the meaning of pain, Sunstriker!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,'master_kelerun_bloodmourn YELL_PHASE'); + diff --git a/sql/updates/389_world.sql b/sql/updates/389_world.sql index 89094143f64..9e199c37726 100644 --- a/sql/updates/389_world.sql +++ b/sql/updates/389_world.sql @@ -7,3 +7,4 @@ 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/400_world.sql b/sql/updates/400_world.sql index a2f7d1e6cea..25a1d1a74e7 100644 --- a/sql/updates/400_world.sql +++ b/sql/updates/400_world.sql @@ -8,3 +8,4 @@ INSERT INTO `spell_script_target` VALUES (5628, 1, 2013); INSERT INTO `spell_script_target` VALUES (5628, 1, 2014); INSERT INTO `spell_script_target` VALUES (45109, 1, 25084); INSERT INTO `spell_script_target` VALUES (45149, 0, 300154); + diff --git a/sql/updates/410_characters.sql b/sql/updates/410_characters.sql index 483b991e19e..96bf01135d4 100644 --- a/sql/updates/410_characters.sql +++ b/sql/updates/410_characters.sql @@ -1,2 +1,3 @@ ALTER TABLE `guild_member` DROP INDEX `guid_key` , ADD UNIQUE `guid_key` ( `guid` ); + diff --git a/sql/updates/426_world_scripts.sql b/sql/updates/426_world_scripts.sql index fde6ee6dbf2..d7cec0efd7d 100644 --- a/sql/updates/426_world_scripts.sql +++ b/sql/updates/426_world_scripts.sql @@ -11,3 +11,4 @@ UPDATE `creature_template` SET `ScriptName`='mob_archaedas_minions' WHERE `entry -- Stone keepers UPDATE `creature_template` SET `ScriptName`='mob_stonekeepers' WHERE `entry`=4857; + diff --git a/sql/updates/427_world_scripts.sql b/sql/updates/427_world_scripts.sql index b6fe5fb7acb..abcff54ade6 100644 --- a/sql/updates/427_world_scripts.sql +++ b/sql/updates/427_world_scripts.sql @@ -55,3 +55,4 @@ REPLACE INTO `script_texts` VALUES (-1189006, 'Your body lies beaten, battered and broken. Let my curse be your own, fate has spoken',0,0,0,0,0,0,0,0,11962,0,0,'Headless Horseman SAY_PLAYER_DEATH'), (-1189007, 'This end have I reached before. What new adventure lies in store?',0,0,0,0,0,0,0,0,11964,0,0,'Headless Horseman SAY_DEATH'); + diff --git a/sql/updates/444_world.sql b/sql/updates/444_world.sql index 004cf626f88..b5d588c39fa 100644 --- a/sql/updates/444_world.sql +++ b/sql/updates/444_world.sql @@ -34,3 +34,4 @@ ALTER TABLE `creature_addon` ADD `path_id` int(11) unsigned NOT NULL default '0' AFTER `guid`; ALTER TABLE `creature_template_addon` ADD `path_id` int(11) unsigned NOT NULL default '0' AFTER `entry`; + diff --git a/sql/updates/452_world.sql b/sql/updates/452_world.sql index 3b549278fc7..dbc7589e46f 100644 --- a/sql/updates/452_world.sql +++ b/sql/updates/452_world.sql @@ -7,3 +7,4 @@ DELETE FROM `spell_chain` WHERE `spell_id` = 26991; INSERT INTO `spell_chain` (spell_id,prev_spell,first_spell,rank,req_spell) VALUES (21849,0,1126,1,0); INSERT INTO `spell_chain` (spell_id,prev_spell,first_spell,rank,req_spell) VALUES (21850,21849,1126,2,0); INSERT INTO `spell_chain` (spell_id,prev_spell,first_spell,rank,req_spell) VALUES (26991,21850,1126,3,0); + diff --git a/sql/updates/455_world.sql b/sql/updates/455_world.sql index a5a23c5f5d6..5dec728d539 100644 --- a/sql/updates/455_world.sql +++ b/sql/updates/455_world.sql @@ -12,3 +12,4 @@ INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `commen INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43658, 43655, 0, 'Electrical Arc Visual'); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43658, 43656, 0, 'Electrical Arc Visual'); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43658, 43659, 0, 'Electrical Arc Visual'); + diff --git a/sql/updates/45_characters.sql b/sql/updates/45_characters.sql index 9f370ba909c..99ef0dd5c9d 100644 --- a/sql/updates/45_characters.sql +++ b/sql/updates/45_characters.sql @@ -11,3 +11,4 @@ CREATE TABLE `game_event_condition_save` ( `done` float default '0', PRIMARY KEY (`event_id`,`condition_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; + diff --git a/sql/updates/471_world.sql b/sql/updates/471_world.sql index 2db368326e8..c21757e2910 100644 --- a/sql/updates/471_world.sql +++ b/sql/updates/471_world.sql @@ -1,2 +1,3 @@ UPDATE `gameobject_template` SET `faction`=1375 WHERE `entry` IN (184203, 184204, 184205); UPDATE `gameobject_template` SET `Scriptname`='go_bridge_console' WHERE entry=184568; + diff --git a/sql/updates/480_world_scripts.sql b/sql/updates/480_world_scripts.sql index 203196a0f16..7eeaeb61fbf 100644 --- a/sql/updates/480_world_scripts.sql +++ b/sql/updates/480_world_scripts.sql @@ -1,2 +1,3 @@ UPDATE `creature_template` SET `ScriptName`='npc_winter_reveler' WHERE `entry`=15760; UPDATE `creature_template` SET `ScriptName`='npc_brewfest_reveler' WHERE `entry`=24484; + diff --git a/sql/updates/488_world_scripts.sql b/sql/updates/488_world_scripts.sql index 41b264fb217..8aab8c464ed 100644 --- a/sql/updates/488_world_scripts.sql +++ b/sql/updates/488_world_scripts.sql @@ -733,3 +733,4 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, (-1000125, 'You! Enter the fray!', 0, 0, 0, 'twiggy SAY_TWIGGY_FRAY'), (-1000126, 'Challenger is down!', 0, 0, 0, 'twiggy SAY_TWIGGY_DOWN'), (-1000127, 'The Affray is over.', 0, 0, 0, 'twiggy SAY_TWIGGY_OVER'); + diff --git a/sql/updates/502_world_scripts.sql b/sql/updates/502_world_scripts.sql index 458d8bb24ed..6f0cc47bf63 100644 --- a/sql/updates/502_world_scripts.sql +++ b/sql/updates/502_world_scripts.sql @@ -4,3 +4,4 @@ UPDATE `creature_template` SET `ScriptName` = 'mob_coilfang_ambusher' WHERE `ent UPDATE `creature_template` SET `ScriptName` = 'mob_coilfang_guardian' WHERE `entry` = '21873'; UPDATE `creature_model_info` SET `bounding_radius` = '13', `combat_reach` = '20' WHERE `modelid` = '20216'; + diff --git a/sql/updates/505_world.sql b/sql/updates/505_world.sql index fe3b3c850aa..26812d4d3fb 100644 --- a/sql/updates/505_world.sql +++ b/sql/updates/505_world.sql @@ -7,3 +7,4 @@ CREATE TABLE `creature_formations` ( `angle` float unsigned NOT NULL, `groupAI` int(11) unsigned NOT NULL, PRIMARY KEY (`follower`)); + diff --git a/sql/updates/506_world.sql b/sql/updates/506_world.sql index 069690c4da8..634aa33735f 100644 --- a/sql/updates/506_world.sql +++ b/sql/updates/506_world.sql @@ -81,3 +81,4 @@ INSERT INTO spell_chain (spell_id,prev_spell,first_spell,rank,req_spell) VALUES INSERT INTO spell_chain (spell_id,prev_spell,first_spell,rank,req_spell) VALUES (31896,20184,20184,2,0); ALTER TABLE spell_chain DROP COLUMN prev_spell; + diff --git a/sql/updates/513_world_scripts.sql b/sql/updates/513_world_scripts.sql index 21a57ea3316..8714057904f 100644 --- a/sql/updates/513_world_scripts.sql +++ b/sql/updates/513_world_scripts.sql @@ -17,3 +17,4 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, (-1269026,'I am grateful for your aid, champions. Now, Gul\'dan\'s Horde will sweep across this world, like a locust swarm, and all my designs, all my carefully laid plans will at last fall into place.',10440,1,0,'medivh SAY_WIN'), (-1269027,'Orcs of the Horde! This portalis the gateway to your new destiny! Azeroth lies before you, ripe for the taking!',0,1,0,'medivh SAY_ORCS_ENTER'), (-1269028,'Gul\'dan speaks the truth! We should return at once to tell our brothers of the news! Retreat back trought the portal!',0,1,0,'medivh SAY_ORCS_ANSWER'); + diff --git a/sql/updates/519_world.sql b/sql/updates/519_world.sql index 2423f94ec1c..deddf74b42e 100644 --- a/sql/updates/519_world.sql +++ b/sql/updates/519_world.sql @@ -1,2 +1,3 @@ ALTER TABLE `creature_formations` CHANGE `leader` `leaderGUID` int(11) unsigned NOT NULL default '0'; ALTER TABLE `creature_formations` CHANGE `follower` `memberGUID` int(11) unsigned NOT NULL default '0'; + diff --git a/sql/updates/537_world.sql b/sql/updates/537_world.sql index 2401a5aeadd..7929f4dbc52 100644 --- a/sql/updates/537_world.sql +++ b/sql/updates/537_world.sql @@ -1,2 +1,3 @@ -- Removing the now unused creature_movement table DROP TABLE IF EXISTS `creature_movement`; + diff --git a/sql/updates/541_characters.sql b/sql/updates/541_characters.sql index 2651c069e05..cddfb33519c 100644 --- a/sql/updates/541_characters.sql +++ b/sql/updates/541_characters.sql @@ -6,3 +6,4 @@ CREATE TABLE `saved_variables` ( ALTER TABLE `arena_team_member` DROP COLUMN `points_to_add`; ALTER TABLE `arena_team_member` ADD COLUMN `personal_rating` int(10) UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `characters` ADD COLUMN `arena_pending_points` int(10) UNSIGNED NOT NULL default '0' AFTER `taxi_path`; + diff --git a/sql/updates/541_world.sql b/sql/updates/541_world.sql index 7d8e1fc8e1b..676f9138bac 100644 --- a/sql/updates/541_world.sql +++ b/sql/updates/541_world.sql @@ -23,4 +23,5 @@ INSERT INTO trinity_string (entry, content_default) VALUES (1137, 'You must be in GM mode to teleport to a player in a battleground.'), (1138, 'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.'); -DELETE FROM trinity_string WHERE entry = 714 OR entry = 716;
\ No newline at end of file +DELETE FROM trinity_string WHERE entry = 714 OR entry = 716; + diff --git a/sql/updates/542_characters.sql b/sql/updates/542_characters.sql index 4cc3bebea80..9af0975e07f 100644 --- a/sql/updates/542_characters.sql +++ b/sql/updates/542_characters.sql @@ -72,3 +72,4 @@ SET WHERE `a`.`arenateamid` = `b`.`atid` AND `a`.`guid` = `b`.`b_guid`; + diff --git a/sql/updates/54_world.sql b/sql/updates/54_world.sql index 2d5e984d9e7..761149b53af 100644 --- a/sql/updates/54_world.sql +++ b/sql/updates/54_world.sql @@ -3,3 +3,4 @@ CREATE TABLE `game_event_battleground_holiday` ( `bgflag` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`event`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; + diff --git a/sql/updates/551_world.sql b/sql/updates/551_world.sql index 5a01d596ab4..c064a8e990c 100644 --- a/sql/updates/551_world.sql +++ b/sql/updates/551_world.sql @@ -19,4 +19,5 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, (-1000134, 'We\'ve had too many setbacks along the way: Hellfire Citadel, Fallen Sky Ridge, Firewing Point... Prince Kael\'thas will tolerate no further delays. I will tolerate nothing other than complete success!', 0, 0, 0, 'dawnforge PATHALEON_CULATOR_IMAGE_2_1'), (-1000135, 'I am returning to Tempest Keep. See to it that I do not have reason to return!', 0, 0, 0, 'dawnforge PATHALEON_CULATOR_IMAGE_2_2' ), (-1000136, 'Yes, my lord.', 0, 0, 0, 'dawnforge COMMANDER_DAWNFORGE_4 SAY_ARCANIST_ARDONIS_2'), -(-1000137, 'See to it, Ardonis!', 0, 0, 0, 'dawnforge COMMANDER_DAWNFORGE_5');
\ No newline at end of file +(-1000137, 'See to it, Ardonis!', 0, 0, 0, 'dawnforge COMMANDER_DAWNFORGE_5'); + diff --git a/sql/updates/566_world.sql b/sql/updates/566_world.sql index 6c176e1ad89..6ff3126aac0 100644 --- a/sql/updates/566_world.sql +++ b/sql/updates/566_world.sql @@ -22,3 +22,4 @@ INSERT INTO spell_script_target VALUES (39011,1,20885), (40106,1,22883), (40105,1,22883); + diff --git a/sql/updates/571_world.sql b/sql/updates/571_world.sql index 115c210306b..2bd76e45769 100644 --- a/sql/updates/571_world.sql +++ b/sql/updates/571_world.sql @@ -3,3 +3,4 @@ ALTER TABLE spell_chain DROP COLUMN rank; ALTER TABLE spell_chain RENAME TO spell_required; DELETE FROM spell_required WHERE req_spell=0; + diff --git a/sql/updates/572_world.sql b/sql/updates/572_world.sql index 33ce446b012..033548f0367 100644 --- a/sql/updates/572_world.sql +++ b/sql/updates/572_world.sql @@ -5,3 +5,4 @@ DELETE FROM `script_texts` WHERE `entry` IN (-1000138,-1000139); INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`) VALUES (-1000138, 'Avruu\'s magic... it still controls me. You must fight me, mortal. It\'s the only way to break the spell!', 0, 0, 0, 'aeranas SAY_SUMMON'), (-1000139, 'Avruu\'s magic is broken! I\'m free once again!', 0, 0, 0, 'aeranas SAY_FREE'); + diff --git a/sql/updates/575_world_scripts.sql b/sql/updates/575_world_scripts.sql index 85a75215f0e..b084d2eac8b 100644 --- a/sql/updates/575_world_scripts.sql +++ b/sql/updates/575_world_scripts.sql @@ -1 +1,2 @@ UPDATE `item_template` SET `ScriptName` = "item_only_for_flight" WHERE `entry` IN (34475, 34489, 24538); + diff --git a/sql/updates/57_world_scripts.sql b/sql/updates/57_world_scripts.sql index 2f76ae8c94f..b87c607a14c 100644 --- a/sql/updates/57_world_scripts.sql +++ b/sql/updates/57_world_scripts.sql @@ -36,4 +36,5 @@ INSERT INTO `spell_proc_event` VALUES ('43983', '0', '0', '0', '0', '0', '16384' DELETE FROM `spell_script_target` WHERE `entry` = 42577; INSERT INTO `spell_script_target` VALUES ('42577', '1', '24136'); -UPDATE `creature_template` SET `ScriptName` = 'npc_zulaman_hostage' WHERE `entry` IN (23790, 23999, 24024, 24001);
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_zulaman_hostage' WHERE `entry` IN (23790, 23999, 24024, 24001); + diff --git a/sql/updates/583_world_scripts.sql b/sql/updates/583_world_scripts.sql index 45f8d80a244..3ef0a2399af 100644 --- a/sql/updates/583_world_scripts.sql +++ b/sql/updates/583_world_scripts.sql @@ -1 +1,2 @@ -UPDATE creature_template SET Scriptname='npc_ranger_lilatha' WHERE entry=16295;
\ No newline at end of file +UPDATE creature_template SET Scriptname='npc_ranger_lilatha' WHERE entry=16295; + diff --git a/sql/updates/586_world_scripts.sql b/sql/updates/586_world_scripts.sql index a86cec4951b..d4102fdfef6 100644 --- a/sql/updates/586_world_scripts.sql +++ b/sql/updates/586_world_scripts.sql @@ -1,2 +1,3 @@ UPDATE `gameobject_template` SET `ScriptName` = 'go_mausoleum_trigger' WHERE `entry` = 104593; -UPDATE `gameobject_template` SET `ScriptName` = 'go_mausoleum_door' WHERE `entry` = 176594;
\ No newline at end of file +UPDATE `gameobject_template` SET `ScriptName` = 'go_mausoleum_door' WHERE `entry` = 176594; + diff --git a/sql/updates/588_world.sql b/sql/updates/588_world.sql index e85a034f344..346101bdc0a 100644 --- a/sql/updates/588_world.sql +++ b/sql/updates/588_world.sql @@ -4,4 +4,5 @@ INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES ('6614','Notific INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES ('6615','|cffffff00[|c1f40af20GM Announce by|r |cffff0000%s|cffffff00]:|r %s|r'); INSERT INTO `command` (`name`,`security`,`help`) VALUES ('gmnotify', 2, 'Syntax: .gmnotify $notification\r\nDisplays a notification on the screen of all online GM\'s.'); INSERT INTO `command` (`name`,`security`,`help`) VALUES ('gmnameannounce', 2, 'Syntax: .gmnameannounce $announcement.\r\nSend an announcement to all online GM\'s, displaying the name of the sender.'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES ('gmannounce', 4, 'Syntax: .gmannounce $announcement\r\nSend an announcement to online Gamemasters.');
\ No newline at end of file +INSERT INTO `command` (`name`,`security`,`help`) VALUES ('gmannounce', 4, 'Syntax: .gmannounce $announcement\r\nSend an announcement to online Gamemasters.'); + diff --git a/sql/updates/608_world.sql b/sql/updates/608_world.sql index 5c052ecd078..6cb9665f394 100644 --- a/sql/updates/608_world.sql +++ b/sql/updates/608_world.sql @@ -164,3 +164,4 @@ INSERT INTO `spell_script_target` VALUES (46896,0,181605), (47104,1,26401), (49058,1,24968); -- Rocket Bot Attack + diff --git a/sql/updates/615_world.sql b/sql/updates/615_world.sql index 28512e8511e..99ccb0cdaa3 100644 --- a/sql/updates/615_world.sql +++ b/sql/updates/615_world.sql @@ -5,3 +5,4 @@ DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (-49011, -49012); DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (43468, 43648); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43648, 44007, 1, 'Storm Eye Safe Zone'); + diff --git a/sql/updates/636_world_scripts.sql b/sql/updates/636_world_scripts.sql index 5527d639fb2..e8a0fec45b1 100644 --- a/sql/updates/636_world_scripts.sql +++ b/sql/updates/636_world_scripts.sql @@ -6,4 +6,5 @@ insert into event_scripts values -- remove every Image from Medivh (should not be spawned by db) delete from creature where id = 17651; -- add script -update creature_template set scriptname = 'npc_image_of_medivh' where entry = 17651;
\ No newline at end of file +update creature_template set scriptname = 'npc_image_of_medivh' where entry = 17651; + diff --git a/sql/updates/640_world.sql b/sql/updates/640_world.sql index 20253029d5b..b32ee6819bb 100644 --- a/sql/updates/640_world.sql +++ b/sql/updates/640_world.sql @@ -3,3 +3,4 @@ INSERT INTO `spell_script_target` VALUES (33655,0,183350), (33633,0,183351), (44374,1,24722); + diff --git a/sql/updates/645_world_scripts.sql b/sql/updates/645_world_scripts.sql index f480a97e204..834efb390bc 100644 --- a/sql/updates/645_world_scripts.sql +++ b/sql/updates/645_world_scripts.sql @@ -2,4 +2,5 @@ delete from creature where id=17318; update creature_template set scriptname='npc_geezle' where entry=17318; delete from event_scripts where id=10675; insert into event_scripts () VALUES (10675, 0, 10, 17318, 120000, 0, -5134.3, -11250.3, 5.29568, 6.23554), -(10675, 72, 7, 9531, 0, 0, 0, 0, 0, 0);
\ No newline at end of file +(10675, 72, 7, 9531, 0, 0, 0, 0, 0, 0); + diff --git a/sql/updates/667_world_scripts.sql b/sql/updates/667_world_scripts.sql index 1da0cea44e1..4b2930cd74f 100644 --- a/sql/updates/667_world_scripts.sql +++ b/sql/updates/667_world_scripts.sql @@ -1 +1,2 @@ -update creature_template set scriptname='npc_professor_dabiri' where entry=20907;
\ No newline at end of file +update creature_template set scriptname='npc_professor_dabiri' where entry=20907; + diff --git a/sql/updates/66_world_scripts.sql b/sql/updates/66_world_scripts.sql index dfce2afedcc..fcdf65e4620 100644 --- a/sql/updates/66_world_scripts.sql +++ b/sql/updates/66_world_scripts.sql @@ -15,4 +15,5 @@ INSERT INTO `spell_script_target` VALUES ('45388', '1', '25038'); INSERT INTO `spell_script_target` VALUES ('45389', '1', '25265'); INSERT INTO `spell_script_target` VALUES ('44885', '1', '25160'); INSERT INTO `spell_script_target` VALUES ('46350', '1', '25160'); -INSERT INTO `spell_script_target` VALUES ('45714', '1', '25038');
\ No newline at end of file +INSERT INTO `spell_script_target` VALUES ('45714', '1', '25038'); + diff --git a/sql/updates/676_world.sql b/sql/updates/676_world.sql index 2b9135c04bd..b023e01f0a6 100644 --- a/sql/updates/676_world.sql +++ b/sql/updates/676_world.sql @@ -1,2 +1,3 @@ UPDATE `trinity_string` SET `content_default`='Player |cffff0000%s|r kicked by |cffff0000%s|r. Reason: |cffff0000%s|r.' WHERE (`entry`='282'); -UPDATE `command` SET `help`='Syntax: .kick [$charactername] [$reason]\r\n\r\nKick the given character name from the world with or without reason. If no character name is provided then the selected player (except for yourself) will be kicked. If no reason is provided, default is \"No Reason\".' WHERE (`name`='kick');
\ No newline at end of file +UPDATE `command` SET `help`='Syntax: .kick [$charactername] [$reason]\r\n\r\nKick the given character name from the world with or without reason. If no character name is provided then the selected player (except for yourself) will be kicked. If no reason is provided, default is \"No Reason\".' WHERE (`name`='kick'); + diff --git a/sql/updates/679_world_scripts.sql b/sql/updates/679_world_scripts.sql index 15d43204734..0d725f85003 100644 --- a/sql/updates/679_world_scripts.sql +++ b/sql/updates/679_world_scripts.sql @@ -1 +1,2 @@ -update creature_template set scriptname='npc_deathstalker_erland' where entry=1978;
\ No newline at end of file +update creature_template set scriptname='npc_deathstalker_erland' where entry=1978; + diff --git a/sql/updates/683_world_scripts.sql b/sql/updates/683_world_scripts.sql index 6463adad08e..50ca23c380e 100644 --- a/sql/updates/683_world_scripts.sql +++ b/sql/updates/683_world_scripts.sql @@ -1,2 +1,3 @@ update quest_template set specialflags=2 where entry=665; -update creature_template set scriptname='npc_professor_phizzlethorpe' where entry=2768;
\ No newline at end of file +update creature_template set scriptname='npc_professor_phizzlethorpe' where entry=2768; + diff --git a/sql/updates/686_world_scripts.sql b/sql/updates/686_world_scripts.sql index 80d0468c361..f2b17d21173 100644 --- a/sql/updates/686_world_scripts.sql +++ b/sql/updates/686_world_scripts.sql @@ -12,4 +12,5 @@ INSERT INTO script_texts (entry, content_default, sound, type, language, comment (-1047007, 'I am glad that we are out again from this damned ditch. However, up here it is not much better!', 0, 0, 0, 'Willix'), (-1047008, 'Finally! I am glad that I come, finally out here.', 0, 0, 0, 'Willix'), (-1047009, 'I will rather rest a moment and come again to breath, before I return to Ratchet.', 0, 0, 0, 'Willix'), -(-1047010, 'Many thanks for your help.', 0, 0, 0, 'Willix');
\ No newline at end of file +(-1047010, 'Many thanks for your help.', 0, 0, 0, 'Willix'); + diff --git a/sql/updates/68_world.sql b/sql/updates/68_world.sql index 650f4ea3ca0..40678a4a5b0 100644 --- a/sql/updates/68_world.sql +++ b/sql/updates/68_world.sql @@ -13,4 +13,5 @@ INSERT INTO trinity_string VALUES DELETE FROM `command` WHERE `name` = 'freeze' or `name` = 'unfreeze' or name = 'listfreeze'; INSERT INTO `command` (`name`,`security`,`help`) VALUES ('freeze','2','Syntax: .freeze (#player)\r\n\"Freezes\" #player and disables his chat. When using this without #name it will freeze your target.'); INSERT INTO `command` (`name`,`security`,`help`) VALUES ('unfreeze','2','Syntax: .unfreeze (#player)\r\n\"Unfreezes\" #player and enables his chat again. When using this without #name it will unfreeze your target.'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES ('listfreeze','1','Syntax: .listfreeze\r\n\r\nSearch and output all frozen players.');
\ No newline at end of file +INSERT INTO `command` (`name`,`security`,`help`) VALUES ('listfreeze','1','Syntax: .listfreeze\r\n\r\nSearch and output all frozen players.'); + diff --git a/sql/updates/691_world_scripts.sql b/sql/updates/691_world_scripts.sql index 6c26e149e8c..47037e5e091 100644 --- a/sql/updates/691_world_scripts.sql +++ b/sql/updates/691_world_scripts.sql @@ -1 +1,2 @@ -update creature_template set scriptname='npc_earthmender_wilda' where entry=21027;
\ No newline at end of file +update creature_template set scriptname='npc_earthmender_wilda' where entry=21027; + diff --git a/sql/updates/692_world.sql b/sql/updates/692_world.sql index 634bf6a7f46..5879d754ff7 100644 --- a/sql/updates/692_world.sql +++ b/sql/updates/692_world.sql @@ -4,4 +4,5 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ('14148','0','0','0','2','0','0','0','0'); DELETE FROM `spell_proc_event` WHERE entry = 38164; INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES - (38164,0,0,0,0,1,0,0,60);
\ No newline at end of file + (38164,0,0,0,0,1,0,0,60); + diff --git a/sql/updates/708_world_scripts.sql b/sql/updates/708_world_scripts.sql index 7a297f42287..c218f610b31 100644 --- a/sql/updates/708_world_scripts.sql +++ b/sql/updates/708_world_scripts.sql @@ -1,2 +1,3 @@ UPDATE `creature_template` SET `ScriptName` = 'boss_shirrak_the_dead_watcher' WHERE `entry` = '18371'; -UPDATE `creature_template` SET `ScriptName` = 'mob_focus_fire', `unit_flags` = '33554434' WHERE `entry` = '18374';
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'mob_focus_fire', `unit_flags` = '33554434' WHERE `entry` = '18374'; + diff --git a/sql/updates/70_world_scripts.sql b/sql/updates/70_world_scripts.sql index 1bbf737c59c..893edc00a5f 100644 --- a/sql/updates/70_world_scripts.sql +++ b/sql/updates/70_world_scripts.sql @@ -24,4 +24,5 @@ UPDATE `creature_template` SET `ScriptName` = 'npc_kservant' WHERE `entry` = '19685'; DELETE FROM `quest_start_scripts` WHERE `id`='10211'; -UPDATE `quest_template` SET `StartScript`='0' WHERE entry=10211;
\ No newline at end of file +UPDATE `quest_template` SET `StartScript`='0' WHERE entry=10211; + diff --git a/sql/updates/722_world_script_texts.sql b/sql/updates/722_world_script_texts.sql index 8be4cd9a86f..49788912023 100644 --- a/sql/updates/722_world_script_texts.sql +++ b/sql/updates/722_world_script_texts.sql @@ -6,4 +6,5 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, (-1000143,'There\'s Farstrider Enclave now, $C. Not far to go... Look out! Troll ambush!!',0,0,1,'lilatha SAY_PROGRESS3'), (-1000144,'Thank you for saving my life and bringing me back to safety, $N',0,0,1,'lilatha SAY_END1'), (-1000145,'Captain Helios, I\'ve been rescued from the Amani Catacombs. Reporting for duty, sir!',0,0,1,'lilatha SAY_END2'), -(-1000146,'Liatha, get someone to look at those injuries. Thank you for bringing her back safely.',0,0,1,'lilatha CAPTAIN_ANSWER');
\ No newline at end of file +(-1000146,'Liatha, get someone to look at those injuries. Thank you for bringing her back safely.',0,0,1,'lilatha CAPTAIN_ANSWER'); + diff --git a/sql/updates/724_world.sql b/sql/updates/724_world.sql index 36a2d007de3..c3850bc114d 100644 --- a/sql/updates/724_world.sql +++ b/sql/updates/724_world.sql @@ -1,3 +1,4 @@ ALTER TABLE custom_texts ADD COLUMN emote tinyint(3) UNSIGNED DEFAULT '0' NOT NULL AFTER language; ALTER TABLE eventai_texts ADD COLUMN emote tinyint(3) UNSIGNED DEFAULT '0' NOT NULL AFTER language; -ALTER TABLE script_texts ADD COLUMN emote tinyint(3) UNSIGNED DEFAULT '0' NOT NULL AFTER language;
\ No newline at end of file +ALTER TABLE script_texts ADD COLUMN emote tinyint(3) UNSIGNED DEFAULT '0' NOT NULL AFTER language; + diff --git a/sql/updates/725_characters.sql b/sql/updates/725_characters.sql index 17a87769b12..193868e906a 100644 --- a/sql/updates/725_characters.sql +++ b/sql/updates/725_characters.sql @@ -2,4 +2,5 @@ ALTER TABLE `character_ticket` RENAME TO `gm_tickets`; ALTER TABLE gm_tickets CHANGE `guid` `playerGuid` int(11) unsigned NOT NULL default '0'; ALTER TABLE gm_tickets CHANGE `ticket_id` `guid` int(11) unsigned NOT NULL default '0'; ALTER TABLE gm_tickets CHANGE `ticket_text` `message` text(0) NOT NULL; -ALTER TABLE gm_tickets CHANGE `ticket_lastchange` `timestamp` int(10) NOT NULL default '0';
\ No newline at end of file +ALTER TABLE gm_tickets CHANGE `ticket_lastchange` `timestamp` int(10) NOT NULL default '0'; + diff --git a/sql/updates/725_world.sql b/sql/updates/725_world.sql index 1a3172fb6dc..3141da90872 100644 --- a/sql/updates/725_world.sql +++ b/sql/updates/725_world.sql @@ -28,3 +28,4 @@ INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.ticket assign','3','U INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.ticket unassign','3','Usage: .ticket unassign $ticketid.\r\nUnassigns the specified ticket from the current assigned Game Master.'); INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.ticket comment','2','Usage: .ticket comment $ticketid $comment.\r\nAllows the adding or modifying of a comment to the specified ticket.'); INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.reload tickets','4','Usage: .reload tickets.\r\nReloads GM Tickets from the database and re-caches them into memory.'); + diff --git a/sql/updates/728_world_scripts.sql b/sql/updates/728_world_scripts.sql index 5b042ee40a1..027af8ede16 100644 --- a/sql/updates/728_world_scripts.sql +++ b/sql/updates/728_world_scripts.sql @@ -1 +1,2 @@ -update creature_template set scriptname='npc_apprentice_mirveda' where entry=15402;
\ No newline at end of file +update creature_template set scriptname='npc_apprentice_mirveda' where entry=15402; + diff --git a/sql/updates/733_characters.sql b/sql/updates/733_characters.sql index d078529074e..d966b131d5f 100644 --- a/sql/updates/733_characters.sql +++ b/sql/updates/733_characters.sql @@ -1 +1,2 @@ -ALTER TABLE gm_tickets ADD `name` varchar(15) NOT NULL AFTER `playerGuid`;
\ No newline at end of file +ALTER TABLE gm_tickets ADD `name` varchar(15) NOT NULL AFTER `playerGuid`; + diff --git a/sql/updates/739_characters.sql b/sql/updates/739_characters.sql index 3cbcca9837b..96c5c597a84 100644 --- a/sql/updates/739_characters.sql +++ b/sql/updates/739_characters.sql @@ -1 +1,2 @@ -ALTER TABLE gm_tickets ADD `comment` text(0) NOT NULL;
\ No newline at end of file +ALTER TABLE gm_tickets ADD `comment` text(0) NOT NULL; + diff --git a/sql/updates/741_characters.sql b/sql/updates/741_characters.sql index 4ce094e3e5f..b7862c4f261 100644 --- a/sql/updates/741_characters.sql +++ b/sql/updates/741_characters.sql @@ -1,3 +1,4 @@ ALTER TABLE `gm_tickets` ADD `closed` tinyint(1) NOT NULL default '0' AFTER `timestamp`; ALTER TABLE `gm_tickets` ADD `assignedto` int(10) NOT NULL default '0' AFTER `timestamp`; + diff --git a/sql/updates/741_world.sql b/sql/updates/741_world.sql index a93d4e2bd01..da59a6d3633 100644 --- a/sql/updates/741_world.sql +++ b/sql/updates/741_world.sql @@ -8,3 +8,4 @@ REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket assign','3','U REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket unassign','3','Usage: .ticket unassign $ticketid.\r\nUnassigns the specified ticket from the current assigned Game Master.'); REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket comment','2','Usage: .ticket comment $ticketid $comment.\r\nAllows the adding or modifying of a comment to the specified ticket.'); REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('reload tickets','4','Usage: .reload tickets.\r\nReloads GM Tickets from the database and re-caches them into memory.'); + diff --git a/sql/updates/747_world.sql b/sql/updates/747_world.sql index b526781b141..561f0adf91d 100644 --- a/sql/updates/747_world.sql +++ b/sql/updates/747_world.sql @@ -1 +1,2 @@ -UPDATE `trinity_string` SET `content_default`='Ticket %d is already assigned.' WHERE (`entry`='2008');
\ No newline at end of file +UPDATE `trinity_string` SET `content_default`='Ticket %d is already assigned.' WHERE (`entry`='2008'); + diff --git a/sql/updates/748_world_scripts.sql b/sql/updates/748_world_scripts.sql index eb5b7c94992..a9e079ec9e9 100644 --- a/sql/updates/748_world_scripts.sql +++ b/sql/updates/748_world_scripts.sql @@ -1,2 +1,3 @@ update creature_template set scriptname='npc_infused_crystal', flags_extra=0 where entry=16364; -delete from creature where id=17086;
\ No newline at end of file +delete from creature where id=17086; + diff --git a/sql/updates/758_world_scripts.sql b/sql/updates/758_world_scripts.sql index a988a426df7..cbb2a783264 100644 --- a/sql/updates/758_world_scripts.sql +++ b/sql/updates/758_world_scripts.sql @@ -2,4 +2,5 @@ delete from creature_template_addon where entry = 17225; update creature_template set scriptname = 'boss_nightbane', unit_flags=0 where entry = 17225; delete from event_scripts where id = 10951; insert into event_scripts values -(10951,0,10,17651,180000,0,-11159,-1907.22,91.48,0);
\ No newline at end of file +(10951,0,10,17651,180000,0,-11159,-1907.22,91.48,0); + diff --git a/sql/updates/762_world.sql b/sql/updates/762_world.sql index 4f32617b0ee..7aaacedc464 100644 --- a/sql/updates/762_world.sql +++ b/sql/updates/762_world.sql @@ -3,4 +3,5 @@ CREATE TABLE `transport_events` ( `entry` int(11) unsigned NOT NULL default '0', `waypoint_id` int(11) unsigned NOT NULL default '0', `event_id` int(11) unsigned NOT NULL default '0' -) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\ No newline at end of file +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + diff --git a/sql/updates/764_world_scripts.sql b/sql/updates/764_world_scripts.sql index d071d870233..fb1d3a924c8 100644 --- a/sql/updates/764_world_scripts.sql +++ b/sql/updates/764_world_scripts.sql @@ -120,4 +120,5 @@ DELETE FROM `script_texts` WHERE `entry` BETWEEN -1533108 AND -1533075; (-1533108,'Fools, you have spread your powers too thin. Be free, my minions!',14482,1,0,'kelthuzad SAY_SPECIAL2_DISPELL'); UPDATE `script_texts` SET `sound`=8902 WHERE `entry`=-1533055; - UPDATE `script_texts` SET `sound`=8901 WHERE `entry`=-1533056;
\ No newline at end of file + UPDATE `script_texts` SET `sound`=8901 WHERE `entry`=-1533056; + diff --git a/sql/updates/765_world_scripts.sql b/sql/updates/765_world_scripts.sql index 908a31d404f..2cd56fa71a2 100644 --- a/sql/updates/765_world_scripts.sql +++ b/sql/updates/765_world_scripts.sql @@ -16,4 +16,5 @@ INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc2`, `type`, (-1000160, 'This timeway is currently collapsing. What that may hold for the past, present and future is currently unknown...', 'Cette voie est en train de s\'effondrer. Ce qu\'elle peut avoir contenu dans le passé, le présent et le futur nous est actuellement inconnu...', 4, 0, 'WHISPER_CUSTODIAN_11'), (-1000161, 'The timeways are currently ranked in order from least catastrophic to most catastrophic. Note that they are all classified as catastrophic, meaning that any single one of these timeways collapsing would mean that your world would end. We only classify them in such a way so that the heroes and adventurers that are sent here know which timeway best suits their abilities.', 'Les voies sont pour le moment classées de la moins catastrophique à la plus catastrophique, ce qui veut dire que la moindre de celles-ci qui s\'effondre signifierait la fin de votre monde. Nous les classons seulement de cette façon pour que les héros et aventuriers qui y sont envoyés sachent quelle voie est la plus adaptée à leurs compétences.', 4, 0, 'WHISPER_CUSTODIAN_12'), (-1000162, 'All we know of this timeway is that it leads to Mount Hyjal. The Infinite Dragonflight have gone to great lengths to prevent our involvement. We know next to nothing, mortal. Soridormi is currently attempting to break through the timeway\'s defenses but has thus far been unsuccessful. You might be our only hope of breaking through and resolving the conflict.', 'Tout ce que nous savons sur cette voie temporelle est qu\'elle mène au Mont Hyjal. Le Vol du Dragon Infini s\'est donné beaucoup de peine pour empêcher notre participation. Soridormi est actuellement en train de tenter de briser les défenses de cette voie, mais ses efforts ont été vain jusqu\'ici. Vous pourriez être notre seul espoir de les briser et de résoudre le conflit.', 4, 0, 'WHISPER_CUSTODIAN_13'), -(-1000163, 'Our time is at an end $N. I would wish you luck, if such a thing existed.', 'Notre entretien touche à sa fin, $N. Je vous souhaite bonne chance, si tant est qu\'une telle chose a jamais existé.', 4, 0, 'WHISPER_CUSTODIAN_14');
\ No newline at end of file +(-1000163, 'Our time is at an end $N. I would wish you luck, if such a thing existed.', 'Notre entretien touche à sa fin, $N. Je vous souhaite bonne chance, si tant est qu\'une telle chose a jamais existé.', 4, 0, 'WHISPER_CUSTODIAN_14'); + diff --git a/sql/updates/773_world_scripts.sql b/sql/updates/773_world_scripts.sql index e07beb784a4..962905c0f65 100644 --- a/sql/updates/773_world_scripts.sql +++ b/sql/updates/773_world_scripts.sql @@ -6,4 +6,5 @@ INSERT INTO script_texts VALUES (-1000147, 'Lets go $N. I am ready to start to Whitereach Post.', NULL, NULL, 'Gehen wir $N.Ich bin bereit,mich zum Weissgipfelposten aufzumachen.', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL), (-1000148, 'This seems to me trusted. If we move to the east, we are probably... Aah! Wyvern attack !', NULL, NULL, 'Das kommt mir vertraut vor.Wenn wir nach Osten ziehen,können wir wahrscheinlich...Aah!Flügeldrachen im Angriff!', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL), - (-1000149, 'Thanks so much... From here I find the way back to the Whitereach Post. Speak with Motega Firemane, maybe you can persuade him to send me home.', NULL, NULL, 'Tausend Dank...Von hier aus finde ich den Rückweg zum Weissgipfelposten.Sprecht unbedingt mit Motega Feuermähne,vielleicht könnt ihr ihn überreden,mich nach Hause zu schicken.', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL);
\ No newline at end of file + (-1000149, 'Thanks so much... From here I find the way back to the Whitereach Post. Speak with Motega Firemane, maybe you can persuade him to send me home.', NULL, NULL, 'Tausend Dank...Von hier aus finde ich den Rückweg zum Weissgipfelposten.Sprecht unbedingt mit Motega Feuermähne,vielleicht könnt ihr ihn überreden,mich nach Hause zu schicken.', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL); + diff --git a/sql/updates/780_characters.sql b/sql/updates/780_characters.sql index cbcb193c276..40c4d3cdce4 100644 --- a/sql/updates/780_characters.sql +++ b/sql/updates/780_characters.sql @@ -1,2 +1,3 @@ ALTER TABLE `gm_tickets` CHANGE `guid` `guid` int(10) NOT NULL AUTO_INCREMENT; -ALTER TABLE `gm_tickets` CHANGE `closed` `closed` int(10) NOT NULL;
\ No newline at end of file +ALTER TABLE `gm_tickets` CHANGE `closed` `closed` int(10) NOT NULL; + diff --git a/sql/updates/783_world.sql b/sql/updates/783_world.sql index 24a8481e24e..f78f35e2951 100644 --- a/sql/updates/783_world.sql +++ b/sql/updates/783_world.sql @@ -1,4 +1,5 @@ DELETE FROM trinity_string where entry IN (10056, 10057); INSERT INTO trinity_string (entry, content_default) VALUES (10056, 'You must be a member of the Horde to enter the Hall of Legends.'), -(10057, 'You must be a member of the Alliance to enter the Champion\'s Hall.');
\ No newline at end of file +(10057, 'You must be a member of the Alliance to enter the Champion\'s Hall.'); + diff --git a/sql/updates/785_world.sql b/sql/updates/785_world.sql index 747b179f02b..b4c11653a25 100644 --- a/sql/updates/785_world.sql +++ b/sql/updates/785_world.sql @@ -2,3 +2,4 @@ delete from command where name in ('gobject addtemp', 'npc addtemp'); insert into command (name, security, help) values ('gobject addtemp','2','Adds a temporary gameobject that is not saved to DB.'), ('npc addtemp','2','Adds temporary NPC, not saved to database.'); + diff --git a/sql/updates/789_world.sql b/sql/updates/789_world.sql index 0c51d1b3fac..43e6bdc42d2 100644 --- a/sql/updates/789_world.sql +++ b/sql/updates/789_world.sql @@ -1 +1,2 @@ -ALTER TABLE eventai_texts DROP COLUMN emote;
\ No newline at end of file +ALTER TABLE eventai_texts DROP COLUMN emote; + diff --git a/sql/updates/78_world.sql b/sql/updates/78_world.sql index faa02e0e2a6..4a9cbd3846d 100644 --- a/sql/updates/78_world.sql +++ b/sql/updates/78_world.sql @@ -21,3 +21,4 @@ INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyN (34598,0,0,0,0,0x0000000000000000,0x00020000,0,45), (36488,0,0,0,0,0x0000000000000000,0x08000000,0,0), (34584,0,0,0,0,0x0000000000000000,0x00004000,0,30); + diff --git a/sql/updates/79_characters.sql b/sql/updates/79_characters.sql index 15b99f2f4b0..c7b76549e74 100644 --- a/sql/updates/79_characters.sql +++ b/sql/updates/79_characters.sql @@ -1,2 +1,3 @@ ALTER TABLE characters - CHANGE COLUMN gmstate extra_flags int(11) unsigned NOT NULL default '0';
\ No newline at end of file + CHANGE COLUMN gmstate extra_flags int(11) unsigned NOT NULL default '0'; + diff --git a/sql/updates/79_world.sql b/sql/updates/79_world.sql index 7b08a825311..1b5be949cf2 100644 --- a/sql/updates/79_world.sql +++ b/sql/updates/79_world.sql @@ -1,3 +1,4 @@ DELETE FROM spell_proc_event where entry = 42083; INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES -(42083,0,0,0,0,0x0000000000000000,0x00401000,0,45);
\ No newline at end of file +(42083,0,0,0,0,0x0000000000000000,0x00401000,0,45); + diff --git a/sql/updates/807_world_scripts.sql b/sql/updates/807_world_scripts.sql index b3729d12f6b..ee512619ee1 100644 --- a/sql/updates/807_world_scripts.sql +++ b/sql/updates/807_world_scripts.sql @@ -1 +1,2 @@ -update creature_template set scriptname='npc_isla_starmane' where entry=18760;
\ No newline at end of file +update creature_template set scriptname='npc_isla_starmane' where entry=18760; + diff --git a/sql/updates/817_world_scripts.sql b/sql/updates/817_world_scripts.sql index 07750f338b8..071fb2989ff 100644 --- a/sql/updates/817_world_scripts.sql +++ b/sql/updates/817_world_scripts.sql @@ -10,4 +10,5 @@ VALUES (-1000205, 'A-ME at home!A-ME good!Good A-ME.At home.Home.Home', NULL, NULL, 'A-ME daheim!A-ME gut!Gute A-ME.Daheim.Daheim.Daheim', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL); UPDATE `quest_template` SET `QuestFlags` = 2, `SpecialFlags` = 2 WHERE `entry` = 4245; -UPDATE `creature_template` SET `ScriptName` = 'npc_ame' WHERE `entry` = 9623;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_ame' WHERE `entry` = 9623; + diff --git a/sql/updates/822_world_scripts.sql b/sql/updates/822_world_scripts.sql index f7a7016dcf7..117971d18a7 100644 --- a/sql/updates/822_world_scripts.sql +++ b/sql/updates/822_world_scripts.sql @@ -1,3 +1,4 @@ update creature_template set scriptname='npc_kayra_longmane' where entry=17969; delete from creature_template_addon where entry=17969; -update quest_template set specialflags=2 where entry=9752;
\ No newline at end of file +update quest_template set specialflags=2 where entry=9752; + diff --git a/sql/updates/826_world_scripts.sql b/sql/updates/826_world_scripts.sql index b125225744f..7dc2cf77afa 100644 --- a/sql/updates/826_world_scripts.sql +++ b/sql/updates/826_world_scripts.sql @@ -1 +1,2 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_ruul_snowhoof' WHERE `entry` = 12818;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_ruul_snowhoof' WHERE `entry` = 12818; + diff --git a/sql/updates/82_world_scripts.sql b/sql/updates/82_world_scripts.sql index acdfdd06a6f..276a3385ed6 100644 --- a/sql/updates/82_world_scripts.sql +++ b/sql/updates/82_world_scripts.sql @@ -1 +1,2 @@ -UPDATE `creature_template` SET `ScriptName` = 'npc_twiggy_flathead' WHERE `entry` =6248;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_twiggy_flathead' WHERE `entry` =6248; + diff --git a/sql/updates/833_world_scripts.sql b/sql/updates/833_world_scripts.sql index ad68e7a1da0..b8aed954f43 100644 --- a/sql/updates/833_world_scripts.sql +++ b/sql/updates/833_world_scripts.sql @@ -1,2 +1,3 @@ update creature_template set scriptname='npc_dirty_larry', unit_flags=0, flags_extra=0 where entry=19720; -update creature_template set unit_flags=0, flags_extra=0 where entry in (19726, 19725);
\ No newline at end of file +update creature_template set unit_flags=0, flags_extra=0 where entry in (19726, 19725); + diff --git a/sql/updates/834_world_scripts.sql b/sql/updates/834_world_scripts.sql index 14b3d74340e..0b34f8be52f 100644 --- a/sql/updates/834_world_scripts.sql +++ b/sql/updates/834_world_scripts.sql @@ -1 +1,2 @@ -UPDATE `creature_template` SET `ScriptName`='npc_ishanah' WHERE `entry`=18538;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_ishanah' WHERE `entry`=18538; + diff --git a/sql/updates/837_world_scripts.sql b/sql/updates/837_world_scripts.sql index 9146566cf18..810bd3510e0 100644 --- a/sql/updates/837_world_scripts.sql +++ b/sql/updates/837_world_scripts.sql @@ -1 +1,2 @@ -update creature_template set scriptname='npc_khadgar' where entry=18166;
\ No newline at end of file +update creature_template set scriptname='npc_khadgar' where entry=18166; + diff --git a/sql/updates/838_world_scripts.sql b/sql/updates/838_world_scripts.sql index bb7f56c059d..1ff400dc8c5 100644 --- a/sql/updates/838_world_scripts.sql +++ b/sql/updates/838_world_scripts.sql @@ -2,3 +2,4 @@ delete from spell_script_target where entry=42222; insert into `spell_script_target` values ('42222','1','23616'); update `creature_template` set `scriptname`='npc_kyle_frenzied' where `entry`='23616'; + diff --git a/sql/updates/839_world_scripts.sql b/sql/updates/839_world_scripts.sql index 722737ea3b0..448cd44ca1e 100644 --- a/sql/updates/839_world_scripts.sql +++ b/sql/updates/839_world_scripts.sql @@ -1 +1,2 @@ -update creature_template set scriptname='npc_wizzlecrank_shredder' where entry=3439;
\ No newline at end of file +update creature_template set scriptname='npc_wizzlecrank_shredder' where entry=3439; + diff --git a/sql/updates/83_realmd.sql b/sql/updates/83_realmd.sql index e3c74350735..5c47beaabc8 100644 --- a/sql/updates/83_realmd.sql +++ b/sql/updates/83_realmd.sql @@ -1,2 +1,3 @@ ALTER TABLE account - CHANGE COLUMN tbc expansion tinyint(3) unsigned NOT NULL default '0';
\ No newline at end of file + CHANGE COLUMN tbc expansion tinyint(3) unsigned NOT NULL default '0'; + diff --git a/sql/updates/840_world_scripts.sql b/sql/updates/840_world_scripts.sql index 8b0140b6dbb..8a334a578e1 100644 --- a/sql/updates/840_world_scripts.sql +++ b/sql/updates/840_world_scripts.sql @@ -1 +1,2 @@ -UPDATE `creature_template` SET `spell1` = 0, `flags_extra` = 0, `ScriptName` = 'npc_volcano' WHERE `entry` = 23085;
\ No newline at end of file +UPDATE `creature_template` SET `spell1` = 0, `flags_extra` = 0, `ScriptName` = 'npc_volcano' WHERE `entry` = 23085; + diff --git a/sql/updates/841_world_scripts.sql b/sql/updates/841_world_scripts.sql index f23cb8f8cc8..dac0cbd9857 100644 --- a/sql/updates/841_world_scripts.sql +++ b/sql/updates/841_world_scripts.sql @@ -1 +1,2 @@ -update creature_template set scriptname='npc_greengill_slave' where entry=25084;
\ No newline at end of file +update creature_template set scriptname='npc_greengill_slave' where entry=25084; + diff --git a/sql/updates/842_world.sql b/sql/updates/842_world.sql index 953dff584a0..9f40ed71751 100644 --- a/sql/updates/842_world.sql +++ b/sql/updates/842_world.sql @@ -2,4 +2,5 @@ ALTER TABLE `areatrigger_teleport` ADD `heroic_required_quest_done` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0 AFTER `heroic_key2`, ADD `heroic_required_failed_quest_text` TEXT NULL DEFAULT NULL AFTER `heroic_required_quest_done`; -UPDATE `areatrigger_teleport` SET `heroic_required_quest_done` = 11492, `heroic_required_failed_quest_text` = 'Heroic Difficulty requires completion of the "Hard to Kill" quest.' WHERE `id` = 4887;
\ No newline at end of file +UPDATE `areatrigger_teleport` SET `heroic_required_quest_done` = 11492, `heroic_required_failed_quest_text` = 'Heroic Difficulty requires completion of the "Hard to Kill" quest.' WHERE `id` = 4887; + diff --git a/sql/updates/84_world.sql b/sql/updates/84_world.sql index 100185c0acd..2dd20fd44bf 100644 --- a/sql/updates/84_world.sql +++ b/sql/updates/84_world.sql @@ -1,3 +1,4 @@ DELETE FROM command WHERE name = 'reload all_locales'; INSERT INTO `command` VALUES ('reload all_locales',3,'Syntax: .reload all_locales\r\n\r\nReload all `locales_*` tables with reload support added and that can be _safe_ reloaded.'); + diff --git a/sql/updates/850_world_scripts.sql b/sql/updates/850_world_scripts.sql index 720465b63f0..e830d53f933 100644 --- a/sql/updates/850_world_scripts.sql +++ b/sql/updates/850_world_scripts.sql @@ -1 +1,2 @@ -UPDATE creature_template SET ScriptName = 'npc_bessy' WHERE entry = 20415;
\ No newline at end of file +UPDATE creature_template SET ScriptName = 'npc_bessy' WHERE entry = 20415; + diff --git a/sql/updates/852_world_scripts.sql b/sql/updates/852_world_scripts.sql index 96b5c7d6e71..3fcdfc1f3c9 100644 --- a/sql/updates/852_world_scripts.sql +++ b/sql/updates/852_world_scripts.sql @@ -1,2 +1,3 @@ update creature_template set scriptname='mob_nestlewood_owlkin' where entry=16518; -update item_template set scriptname='item_inoculating_crystal' where entry=22962;
\ No newline at end of file +update item_template set scriptname='item_inoculating_crystal' where entry=22962; + diff --git a/sql/updates/857_world_scripts.sql b/sql/updates/857_world_scripts.sql index 3a34d80ee76..78452693d44 100644 --- a/sql/updates/857_world_scripts.sql +++ b/sql/updates/857_world_scripts.sql @@ -1 +1,2 @@ -update creature_template set scriptname='npc_kaya_flathoof' where entry=11856;
\ No newline at end of file +update creature_template set scriptname='npc_kaya_flathoof' where entry=11856; + diff --git a/sql/updates/863_world_scripts.sql b/sql/updates/863_world_scripts.sql index e23f6067c05..1c760bd5bb8 100644 --- a/sql/updates/863_world_scripts.sql +++ b/sql/updates/863_world_scripts.sql @@ -9,4 +9,5 @@ VALUES (-1060004, 'No one challenges the wastevander nomads -- not even robotic chickens! ATTACK!', NULL, NULL, 'Niemand fordert die Wüsenläufernomaden heraus - auch keine Robothühner! ANGRIFF!', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL), (-1060005, 'Cloaking systems online! CLUCK! Engaging cloak for transport to Booty Bay!', NULL, NULL, 'Tarnsysteme online! GLUCK! Tarnung für Transport nach Beutebucht wird aktiviert.', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL); -UPDATE `creature_template` SET `ScriptName` = 'npc_OOX17' WHERE `entry` = 7784;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_OOX17' WHERE `entry` = 7784; + diff --git a/sql/updates/86_world_scripts.sql b/sql/updates/86_world_scripts.sql index 8f3c6ac6265..d3c17926ac7 100644 --- a/sql/updates/86_world_scripts.sql +++ b/sql/updates/86_world_scripts.sql @@ -3,4 +3,5 @@ update `creature_template` set `ScriptName`='mob_ember_of_alar' where `entry`='1 update `creature_template` set `ScriptName`='mob_flame_patch_alar' where `entry`='20602'; update gameobject_template set scriptname = "go_manticron_cube" where entry = 181713; -update creature_template set scriptname = "mob_abyssal" where entry = 17454;
\ No newline at end of file +update creature_template set scriptname = "mob_abyssal" where entry = 17454; + diff --git a/sql/updates/871_world.sql b/sql/updates/871_world.sql index 54922de2a40..0f4fa4245e7 100644 --- a/sql/updates/871_world.sql +++ b/sql/updates/871_world.sql @@ -29,3 +29,4 @@ INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content DELETE FROM `command` WHERE (`name` LIKE '%ticket closedlist%'); INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.ticket closedlist','1','Displays a list of closed GM tickets.'); + diff --git a/sql/updates/884_world.sql b/sql/updates/884_world.sql index fd3ead62313..cbcf89192bb 100644 --- a/sql/updates/884_world.sql +++ b/sql/updates/884_world.sql @@ -2,3 +2,4 @@ delete from command where name in ('gobject tempadd','npc tempadd'); insert into command (name, security, help) values ('gobject addtemp','2','Adds a temporary gameobject that is not saved to DB.'), ('npc addtemp','2','Adds temporary NPC, not saved to database.'); + diff --git a/sql/updates/905_world_scripts.sql b/sql/updates/905_world_scripts.sql index 3e59e1f0e52..aa52204e643 100644 --- a/sql/updates/905_world_scripts.sql +++ b/sql/updates/905_world_scripts.sql @@ -7,4 +7,5 @@ INSERT INTO `areatrigger_scripts` VALUES (1526,'at_ring_of_law'); DELETE FROM `script_texts` WHERE `entry`=-1230000; INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`) VALUES -(-1230000,'Ah, hits the spot!',0,0,0,'rocknot SAY_GOT_BEER');
\ No newline at end of file +(-1230000,'Ah, hits the spot!',0,0,0,'rocknot SAY_GOT_BEER'); + diff --git a/sql/updates/90_world.sql b/sql/updates/90_world.sql index 52ca028b6ac..529de4f712e 100644 --- a/sql/updates/90_world.sql +++ b/sql/updates/90_world.sql @@ -5,3 +5,4 @@ CREATE TABLE `spell_disabled` ( `comment` varchar(64) NOT NULL default '', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Disabled Spell System'; + diff --git a/sql/updates/917_world.sql b/sql/updates/917_world.sql index 084091ec0af..556276fa012 100644 --- a/sql/updates/917_world.sql +++ b/sql/updates/917_world.sql @@ -5,4 +5,5 @@ CREATE TABLE `version` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes'; INSERT INTO version (core_version, db_version, script_version) VALUES ("",(SELECT version FROM db_version),(SELECT version FROM script_db_version)); DROP TABLE IF EXISTS db_version; -DROP TABLE IF EXISTS script_db_version;
\ No newline at end of file +DROP TABLE IF EXISTS script_db_version; + diff --git a/sql/updates/919_world.sql b/sql/updates/919_world.sql index 24267d49223..5febe1ebdfc 100644 --- a/sql/updates/919_world.sql +++ b/sql/updates/919_world.sql @@ -1,2 +1,3 @@ ALTER TABLE version - ADD `core_revision` BIGINT UNSIGNED AFTER `core_version`;
\ No newline at end of file + ADD `core_revision` BIGINT UNSIGNED AFTER `core_version`; + diff --git a/sql/updates/927_characters.sql b/sql/updates/927_characters.sql index 6cbcf21e7bd..c3a0df39b8d 100644 --- a/sql/updates/927_characters.sql +++ b/sql/updates/927_characters.sql @@ -1 +1,2 @@ -ALTER TABLE `gm_tickets` CHANGE `closed` `closed` int(10) NOT NULL default '0';
\ No newline at end of file +ALTER TABLE `gm_tickets` CHANGE `closed` `closed` int(10) NOT NULL default '0'; + diff --git a/sql/updates/930_characters.sql b/sql/updates/930_characters.sql index f0ec58c2dc6..303bda03235 100644 --- a/sql/updates/930_characters.sql +++ b/sql/updates/930_characters.sql @@ -54,3 +54,4 @@ insert into `auctionhousebot` (`auctionhouse`,`name`,`minitems`,`maxitems`,`mint (2,'Alliance',0,0,8,24,27,12,10,1,10,30,8,2,150,250,800,1400,1250,1750,2250,4550,70,100,80,100,75,100,80,100,0,3,2,1,1,1,5,12,15,1,1), (6,'Horde',0,0,8,24,27,12,10,1,10,30,8,2,150,250,800,1400,1250,1750,2250,4550,70,100,80,100,75,100,80,100,0,3,2,1,1,1,5,12,15,1,1), (7,'Neutral',0,0,8,24,27,12,10,1,10,30,8,2,150,250,800,1400,1250,1750,2250,4550,70,100,80,100,75,100,80,100,0,3,2,1,1,1,5,12,15,1,1); + diff --git a/sql/updates/933_world_scripts.sql b/sql/updates/933_world_scripts.sql index 7b1271e25cc..0918e8f1e9e 100644 --- a/sql/updates/933_world_scripts.sql +++ b/sql/updates/933_world_scripts.sql @@ -1 +1,2 @@ update creature_template set scriptname='npc_snake_trap_serpents' where entry in (19921, 19833); + diff --git a/sql/updates/935_world_scripts.sql b/sql/updates/935_world_scripts.sql index de02b51d490..5027cafa234 100644 --- a/sql/updates/935_world_scripts.sql +++ b/sql/updates/935_world_scripts.sql @@ -3,4 +3,5 @@ DELETE FROM `creature` WHERE `id` = '17653'; UPDATE `gameobject_template` SET `flags` = '4' WHERE `entry` IN ('181766','181823'); UPDATE `gameobject` SET `SpawnMask` = '3',`state` = '1' WHERE `id` IN ('181766','181823'); -UPDATE `instance_template` SET `script` = 'instance_blood_furnace' WHERE `map` = '542';
\ No newline at end of file +UPDATE `instance_template` SET `script` = 'instance_blood_furnace' WHERE `map` = '542'; + diff --git a/sql/updates/940_world_scripts.sql b/sql/updates/940_world_scripts.sql index c9ad252f41f..a7f78170c35 100644 --- a/sql/updates/940_world_scripts.sql +++ b/sql/updates/940_world_scripts.sql @@ -1,2 +1,3 @@ ALTER TABLE custom_texts CHANGE COLUMN emote emote smallint(5) unsigned NOT NULL DEFAULT '0'; -ALTER TABLE script_texts CHANGE COLUMN emote emote smallint(5) unsigned NOT NULL DEFAULT '0';
\ No newline at end of file +ALTER TABLE script_texts CHANGE COLUMN emote emote smallint(5) unsigned NOT NULL DEFAULT '0'; + diff --git a/sql/updates/945_world_scripts.sql b/sql/updates/945_world_scripts.sql index 8d007e347f9..0831d5c0e6f 100644 --- a/sql/updates/945_world_scripts.sql +++ b/sql/updates/945_world_scripts.sql @@ -39,3 +39,4 @@ INSERT INTO script_texts (entry, content_default, emote, comment) VALUES (-1000233, 'It shouldn\'t be much further, $N. The exit is just up ahead.', 0, 'SAY_PROGRESS6'), (-1000234, 'Thank you, $N. Please return to my brethren at the Altar of Damnation, near the Hand of Gul\'dan, and tell them that Wilda is safe. May the Earthmother watch over you...', 0, 'SAY_END'); + diff --git a/sql/updates/947_world_scripts.sql b/sql/updates/947_world_scripts.sql index 7067a1ed706..9e81f39a8c3 100644 --- a/sql/updates/947_world_scripts.sql +++ b/sql/updates/947_world_scripts.sql @@ -9,4 +9,5 @@ INSERT INTO script_texts (entry, content_default, type, emote, comment) VALUES (-1000241, 'I\'ve done it! I have harnessed the power of the stone into the goggles! Let\'s get out of here!', 0, 1, 'phizzlethorpe - SAY_PROGRESS_6'), (-1000242, 'Phew! Glad to be back from that creepy cave.', 0, 1, 'phizzlethorpe - SAY_PROGRESS_7'), (-1000243, 'hands one glowing goggles over to Doctor Draxlegauge.', 2, 0, 'phizzlethorpe - EMOTE_PROGRESS_8'), -(-1000244, 'Doctor Draxlegauge will give you further instructions, $N. Many thanks for your help!', 0, 1, 'phizzlethorpe - SAY_PROGRESS_9');
\ No newline at end of file +(-1000244, 'Doctor Draxlegauge will give you further instructions, $N. Many thanks for your help!', 0, 1, 'phizzlethorpe - SAY_PROGRESS_9'); + diff --git a/sql/updates/948_world_scripts.sql b/sql/updates/948_world_scripts.sql index 5f8f74cb5c0..9270e5d994a 100644 --- a/sql/updates/948_world_scripts.sql +++ b/sql/updates/948_world_scripts.sql @@ -2,4 +2,5 @@ DELETE FROM script_texts WHERE entry BETWEEN -1000247 and -1000245; INSERT INTO script_texts (entry, content_default, type, comment) VALUES (-1000245, 'You, there! Hand over that moonstone and nobody gets hurt!', 1, 'SAY_RIZZLE_START'), (-1000246, 'Just chill!', 4, 'SAY_RIZZLE_GRENADE'), -(-1000247, 'All right, you win! I surrender! Just don\'t hurt me!', 1, 'SAY_RIZZLE_FINAL');
\ No newline at end of file +(-1000247, 'All right, you win! I surrender! Just don\'t hurt me!', 1, 'SAY_RIZZLE_FINAL'); + diff --git a/sql/updates/950_world_scripts.sql b/sql/updates/950_world_scripts.sql index 789ad810123..c1058f4b9ee 100644 --- a/sql/updates/950_world_scripts.sql +++ b/sql/updates/950_world_scripts.sql @@ -20,4 +20,5 @@ INSERT INTO script_texts (entry, content_default, type, emote, comment) VALUES (-1000263, 'Relax? Do you know what Kael\'thas does to those that fail him, Geezle? Eternal suffering and pain... Do NOT screw this up, fool.', 0, 0, 'geezle - SPARK_SAY_5'), (-1000264, 'Our Bloodmyst scouts have located our contact. The fool, Velen, will soon leave himself open and defenseless -- long enough for us to strike! Now get out of my sight before I vaporize you...', 0, 0, 'geezle - SPARK_SAY_6'), (-1000265, 'Yes, sir. It won\'t happen again...', 0, 0, 'geezle - GEEZLE_SAY_7'), -(-1000266, 'picks up the naga flag.', 2, 0, 'geezle - EMOTE_SPARK');
\ No newline at end of file +(-1000266, 'picks up the naga flag.', 2, 0, 'geezle - EMOTE_SPARK'); + diff --git a/sql/updates/951_world_scripts.sql b/sql/updates/951_world_scripts.sql index 39208672b32..93f877bdb55 100644 --- a/sql/updates/951_world_scripts.sql +++ b/sql/updates/951_world_scripts.sql @@ -13,4 +13,5 @@ INSERT INTO script_texts (entry, content_default, type, comment) VALUES (-1000276, 'Looks like we\'re out of woods, eh? Wonder what this does...', 0, 'shredder - SAY_PROGRESS_5'), (-1000277, 'Come on, don\'t break down on me now!', 0, 'shredder - SAY_PROGRESS_6'), (-1000278, 'That was a close one! Well, let\'s get going, it\'s still a ways to Ratchet!', 0, 'shredder - SAY_PROGRESS_7'), -(-1000279, 'Hmm... I don\'t think this blinking red light is a good thing...', 0, 'shredder - SAY_PROGRESS_8');
\ No newline at end of file +(-1000279, 'Hmm... I don\'t think this blinking red light is a good thing...', 0, 'shredder - SAY_PROGRESS_8'); + diff --git a/sql/updates/952_world_scripts.sql b/sql/updates/952_world_scripts.sql index e06302538a2..25a19a6972f 100644 --- a/sql/updates/952_world_scripts.sql +++ b/sql/updates/952_world_scripts.sql @@ -7,4 +7,5 @@ INSERT INTO script_texts (entry, content_default, type, language, comment) VALUE (-1000283, 'releases the last of its energies into the nerarby runestone, succesfully reactivating it.', 2, 0, 'crystal - EMOTE'), (-1000284, 'Deployment sucessful. Trespassers will be neutralized.', 0, 0, 'sentry - SAY_CONVERTED_1'), -(-1000285, 'Objective acquired. Initiating security routines.', 0, 0, 'sentry - SAY_CONVERTED_1');
\ No newline at end of file +(-1000285, 'Objective acquired. Initiating security routines.', 0, 0, 'sentry - SAY_CONVERTED_1'); + diff --git a/sql/updates/953_world_scripts.sql b/sql/updates/953_world_scripts.sql index 3811b6a98cf..b90eb732658 100644 --- a/sql/updates/953_world_scripts.sql +++ b/sql/updates/953_world_scripts.sql @@ -6,4 +6,5 @@ INSERT INTO script_texts (entry, content_default, type, emote, comment) VALUES (-1000289, 'That\'s the first relic, but there are still two more. Follow me, $N.', 0, 0, 'clintar_spirit'), (-1000290, 'I\'ve recovered the second relic. Take a moment to rest, and then we\'ll continue to the last reliquary.', 0, 0, 'clintar_spirit'), (-1000291, 'We have all three of the relics, but my energy is rapidly fading. We must make our way back to Dreamwarden Lurosa! He will let you know what to do next.', 0, 0, 'clintar_spirit'), -(-1000292, 'Lurosa, I am entrusting the Relics of Aviana to $N, who will take them to Morthis Whisperwing. I must return completely to the Emerald Dream now. Do not let $N fail!', 0, 0, 'clintar_spirit');
\ No newline at end of file +(-1000292, 'Lurosa, I am entrusting the Relics of Aviana to $N, who will take them to Morthis Whisperwing. I must return completely to the Emerald Dream now. Do not let $N fail!', 0, 0, 'clintar_spirit'); + diff --git a/sql/updates/954_world_scripts.sql b/sql/updates/954_world_scripts.sql index 009f59517ac..11c52b109ad 100644 --- a/sql/updates/954_world_scripts.sql +++ b/sql/updates/954_world_scripts.sql @@ -16,4 +16,5 @@ INSERT INTO script_texts (entry, content_default, type, comment) VALUES (-1000303, 'is very weak', 2, 'mob_phase_hunter - EMOTE_WEAK'), (-1000304, 'Bessy, is that you?', 0, 'npc_bessy- SAY_THADELL_1'), -(-1000305, 'Thank you for bringing back my Bessy, $N. I couldn\'t live without her!', 0, 'npc_bessy- SAY_THADELL_2');
\ No newline at end of file +(-1000305, 'Thank you for bringing back my Bessy, $N. I couldn\'t live without her!', 0, 'npc_bessy- SAY_THADELL_2'); + diff --git a/sql/updates/955_world_scripts.sql b/sql/updates/955_world_scripts.sql index 7c389377433..1afcd46cb07 100644 --- a/sql/updates/955_world_scripts.sql +++ b/sql/updates/955_world_scripts.sql @@ -56,4 +56,5 @@ SAY_ON_BYE'), (-1000347, 'Let\'s go before they find out I\'m free!', 0, 'npc_kaya_flathoof - SAY_START'), (-1000348, 'Look out! We\'re under attack!', 0, 'npc_kaya_flathoof - SAY_AMBUSH'), -(-1000349, 'Thank you for helping me. I know my way back from here.', 0, 'npc_kaya_flathoof - SAY_END');
\ No newline at end of file +(-1000349, 'Thank you for helping me. I know my way back from here.', 0, 'npc_kaya_flathoof - SAY_END'); + diff --git a/sql/updates/956_world_scripts.sql b/sql/updates/956_world_scripts.sql index 35859f191b5..1e9b5b6d2d5 100644 --- a/sql/updates/956_world_scripts.sql +++ b/sql/updates/956_world_scripts.sql @@ -23,4 +23,5 @@ INSERT INTO script_texts (entry, content_default, type, comment) VALUES (-1000362, 'Let\'s keep moving. We\'re not safe here!', 0, 'npc_kayra_longmane - SAY_PROGRESS_3'), (-1000363, 'Look out, $N! Enemies ahead!', 0, 'npc_kayra_longmane - SAY_PROGRESS_4'), (-1000364, 'We\'re almost to the refuge! Let\'s go.', 0, 'npc_kayra_longmane - SAY_PROGRESS_5'), -(-1000365, 'I can see my fellow druids from here. Thank you, $N. I\'m sure Ysiel will reward you for your actions!', 0, 'npc_kayra_longmane - SAY_PROGRESS_6');
\ No newline at end of file +(-1000365, 'I can see my fellow druids from here. Thank you, $N. I\'m sure Ysiel will reward you for your actions!', 0, 'npc_kayra_longmane - SAY_PROGRESS_6'); + diff --git a/sql/updates/957_world_scripts.sql b/sql/updates/957_world_scripts.sql index 8cae6b3fe87..9ebc7b73b66 100644 --- a/sql/updates/957_world_scripts.sql +++ b/sql/updates/957_world_scripts.sql @@ -34,3 +34,4 @@ INSERT INTO `waypoint_data`(`id`,`point`,`position_x`,`position_y`,`position_z`) ('2081','5','-1393.5','1705.5','112'), ('2081','6','-1369.8','1724.5','112'), ('2081','7','-1377','1760','112'); + diff --git a/sql/updates/963_world_scripts.sql b/sql/updates/963_world_scripts.sql index df886987039..ab46bba981c 100644 --- a/sql/updates/963_world_scripts.sql +++ b/sql/updates/963_world_scripts.sql @@ -18,4 +18,5 @@ INSERT INTO script_texts (entry, content_default, type, comment) VALUES (-1000371, 'What manner of fool dares stand before Illidan Stormrage? Soldiers, destroy these insects!', 1, 'Quest: Battle of the crimson watch WavesInfo - First'), (-1000372, 'You are no challenge for the Crimson Sigil. Mind breakers, end this nonsense.', 1, 'Quest: Battle of the crimson watch WavesInfo - Second'), (-1000373, 'Run while you still can. The highlords come soon...', 1, 'Quest: Battle of the crimson watch WavesInfo - Third'), -(-1000374, 'Torloth your master calls!', 1, 'Quest: Battle of the crimson watch WavesInfo - Fourth');
\ No newline at end of file +(-1000374, 'Torloth your master calls!', 1, 'Quest: Battle of the crimson watch WavesInfo - Fourth'); + diff --git a/sql/updates/965_world_scripts.sql b/sql/updates/965_world_scripts.sql index 9c93f78ec09..51ea41b94e5 100644 --- a/sql/updates/965_world_scripts.sql +++ b/sql/updates/965_world_scripts.sql @@ -15,3 +15,4 @@ REPLACE INTO `spell_script_target` VALUES (43144,1,23817), (12613,1,5843), (9095,1,1200); + diff --git a/sql/updates/966_world_scripts.sql b/sql/updates/966_world_scripts.sql index 10a3e09985c..78ecaa6eb73 100644 --- a/sql/updates/966_world_scripts.sql +++ b/sql/updates/966_world_scripts.sql @@ -21,4 +21,5 @@ INSERT INTO script_texts (entry,content_default,sound,type,language,emote,commen (-1000392,'Threat level zero.',11349,1,0,0,'doomwalker SAY_SLAY_1'), (-1000393,'Directive accomplished.',11350,1,0,0,'doomwalker SAY_SLAY_2'), (-1000394,'Target exterminated.',11351,1,0,0,'doomwalker SAY_SLAY_3'), -(-1000395,'System failure in five, f-o-u-r...',11352,1,0,0,'doomwalker SAY_DEATH');
\ No newline at end of file +(-1000395,'System failure in five, f-o-u-r...',11352,1,0,0,'doomwalker SAY_DEATH'); + diff --git a/sql/updates/970_world_scripts.sql b/sql/updates/970_world_scripts.sql index 9e66e60f65d..6105fc5ccbe 100644 --- a/sql/updates/970_world_scripts.sql +++ b/sql/updates/970_world_scripts.sql @@ -7,3 +7,4 @@ INSERT INTO script_texts (entry, content_default, type, language, comment) VALUE (-1000400, 'NOOOOooooooo!', 1, 0, 'mobs_nether_drake - SAY_NIHIL_INTERRUPT'), (-1000401, 'Good $N, you are under the spell\'s influence. I must analyze it quickly, then we can talk.', 0, 7, 'npc_daranelle - SAY_DARANELLE'); + diff --git a/sql/updates/973_world_scripts.sql b/sql/updates/973_world_scripts.sql index b53219c6afe..35261fc7b02 100644 --- a/sql/updates/973_world_scripts.sql +++ b/sql/updates/973_world_scripts.sql @@ -1 +1,2 @@ update creature_template set scriptname = 'npc_enraged_spirit' where entry in (21050, 21061, 21060, 21059); + diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index 6c45423e70c..28d1f895e68 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -166,4 +166,6 @@ INSTALL(FILES 1026_world.sql 1028_world_scripts.sql 1069_world_scripts.sql +1073_world_scripts.sql +1074_world_scripts.sql DESTINATION share/trinity/sql/updates) diff --git a/sql/world.sql b/sql/world.sql index ec259082943..810f9861247 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -3297,3 +3297,4 @@ UNLOCK TABLES; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2008-10-14 13:23:35 + diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql index 3d27739693b..ed2b963fea1 100644 --- a/sql/world_scripts_full.sql +++ b/sql/world_scripts_full.sql @@ -595,7 +595,8 @@ UPDATE `creature_template` SET `ScriptName`='npc_clintar_spirit' WHERE `entry` = /* MULGORE */ UPDATE `creature_template` SET `ScriptName`='npc_skorn_whitecloud' WHERE `entry`=3052; -UPDATE `creature_template` SET `ScriptName`='npc_kyle_frenzied' where `entry`='23616'; +UPDATE `creature_template` SET `ScriptName`='npc_kyle_frenzied' WHERE `entry`='23616'; +UPDATE `creature_template` SET `ScriptName`='npc_plains_vision' WHERE `entry`='2983'; /* NAGRAND */ UPDATE `creature_template` SET `ScriptName`='mob_lump' WHERE `entry`=18351; @@ -892,6 +893,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_isla_starmane' where entry=1876 /* THOUSAND NEEDLES */ UPDATE `creature_template` SET `ScriptName` = 'npc_swiftmountain' WHERE `entry` = 10427; +UPDATE `creature_template` SET `ScriptName` = 'npc_plucky' WHERE `entry` = '6626'; /* THUNDER BLUFF */ UPDATE `creature_template` SET `ScriptName`='npc_cairne_bloodhoof' WHERE `entry`=3057; @@ -996,3 +998,4 @@ UPDATE `creature_template` SET `ScriptName`='mob_batrider' WHERE `entry`=14965; UPDATE `creature_template` SET `ScriptName`='mob_shade_of_jindo' WHERE `entry`=14986; /* EOF */ + diff --git a/sql/world_scripts_structure.sql b/sql/world_scripts_structure.sql index dff8a54a806..aeb1eb6b38c 100644 --- a/sql/world_scripts_structure.sql +++ b/sql/world_scripts_structure.sql @@ -99,3 +99,4 @@ DROP TABLE IF EXISTS `script_db_version`; CREATE TABLE `script_db_version` ( `version` varchar(255) NOT NULL default '' COMMENT 'Script Database version string' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; + diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql index 1c71285a593..cfaa310a166 100644 --- a/sql/world_spell_full.sql +++ b/sql/world_spell_full.sql @@ -367,3 +367,4 @@ REPLACE INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES DELETE FROM spell_target_position WHERE `id` IN (46019, 46020); INSERT INTO spell_target_position () VALUES (46019, 580, 1704.34, 928.17, -74.558, 0); INSERT INTO spell_target_position () VALUES (46020, 580, 1704.34, 928.17, 53.079, 0); + |