diff options
| -rw-r--r-- | sql/updates/692_world.sql | 8 | ||||
| -rw-r--r-- | sql/updates/708_world_scripts.sql | 4 | ||||
| -rw-r--r-- | sql/updates/724_world.sql | 6 | ||||
| -rw-r--r-- | sql/updates/725_characters.sql | 8 | ||||
| -rw-r--r-- | sql/updates/725_world.sql | 59 | ||||
| -rw-r--r-- | sql/updates/728_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/733_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/739_characters.sql | 2 | ||||
| -rw-r--r-- | sql/world_scripts_full.sql | 90 |
9 files changed, 90 insertions, 91 deletions
diff --git a/sql/updates/692_world.sql b/sql/updates/692_world.sql index 634bf6a7f46..2149baa9488 100644 --- a/sql/updates/692_world.sql +++ b/sql/updates/692_world.sql @@ -1,7 +1,5 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN ('14144','14148'); +DELETE FROM `spell_proc_event` WHERE `entry` IN ('38164','14144','14148'); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +('38164','0','0','0','0','1','0','0','60'), ('14144','0','0','0','2','0','0','0','0'), -('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 +('14148','0','0','0','2','0','0','0','0');
\ No newline at end of file diff --git a/sql/updates/708_world_scripts.sql b/sql/updates/708_world_scripts.sql index 7a297f42287..5d0d9a9a916 100644 --- a/sql/updates/708_world_scripts.sql +++ b/sql/updates/708_world_scripts.sql @@ -1,2 +1,2 @@ -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`='boss_shirrak_the_dead_watcher' WHERE `entry`=18371; +UPDATE `creature_template` SET `ScriptName`='mob_focus_fire' WHERE `entry`=18374;
\ No newline at end of file diff --git a/sql/updates/724_world.sql b/sql/updates/724_world.sql index 36a2d007de3..6c57f8b4a22 100644 --- a/sql/updates/724_world.sql +++ b/sql/updates/724_world.sql @@ -1,3 +1,3 @@ -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 `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 diff --git a/sql/updates/725_characters.sql b/sql/updates/725_characters.sql index 17a87769b12..675c6721602 100644 --- a/sql/updates/725_characters.sql +++ b/sql/updates/725_characters.sql @@ -1,5 +1,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 `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 diff --git a/sql/updates/725_world.sql b/sql/updates/725_world.sql index 1a3172fb6dc..38eeead03cb 100644 --- a/sql/updates/725_world.sql +++ b/sql/updates/725_world.sql @@ -1,30 +1,31 @@ -DELETE FROM `trinity_string` WHERE (`entry`='290'); -DELETE FROM `trinity_string` WHERE (`entry`='296'); -DELETE FROM `trinity_string` WHERE (`entry`='289'); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2000, '|cff00ff00New ticket from|r|cffff00ff %s.|r |cff00ff00Ticket entry:|r|cffff00ff %d.|r', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2001, '|cff00ff00Character|r|cffff00ff %s |r|cff00ff00edited his/her ticket:|r|cffff00ff %d.|r', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2002, '|cff00ff00Character|r|cffff00ff %s |r|cff00ff00abandoned ticket entry:|r|cffff00ff %d.|r', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2003, '|cffff00ff %s|r |cff00ff00closed ticket|r |cffff00ff %d.|r', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2004, 'Ticket %d permanently deleted by %s.', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2005, 'Ticket not found.', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2007, 'Please close ticket before deleting it permanently.', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2008, 'Ticket %d is already assigned to GM %s.', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2009, '%u Tickets succesfully reloaded from the database.', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2010, 'Showing list of open tickets.', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2011, 'Showing list of open tickets whose creator is online.', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2012, 'Invalid name specified. Name should be that of an online Gamemaster.', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2013, 'This ticket is already assigned to yourself. To unassign use .ticket unassign %d and then reassign.', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2014, 'Ticket %d is not assigned, you cannot unassign it.', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2015, 'You cannot unassign tickets from staffmembers with a higher security level than yourself.', '', '', '', '', '', '', '', ''); -INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (2016, 'Cannot close ticket %d, it is assigned to another GM.', '', '', '', '', '', '', '', ''); +DELETE FROM `trinity_string` WHERE `entry` IN (290,296,289); +DELETE FROM `trinity_string` WHERE `entry` BETWEEN 2000 AND 2016; +INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES +(2000, '|cff00ff00New ticket from|r|cffff00ff %s.|r |cff00ff00Ticket entry:|r|cffff00ff %d.|r', '', '', '', '', '', '', '', ''), +(2001, '|cff00ff00Character|r|cffff00ff %s |r|cff00ff00edited his/her ticket:|r|cffff00ff %d.|r', '', '', '', '', '', '', '', ''), +(2002, '|cff00ff00Character|r|cffff00ff %s |r|cff00ff00abandoned ticket entry:|r|cffff00ff %d.|r', '', '', '', '', '', '', '', ''), +(2003, '|cffff00ff %s|r |cff00ff00closed ticket|r |cffff00ff %d.|r', '', '', '', '', '', '', '', ''), +(2004, 'Ticket %d permanently deleted by %s.', '', '', '', '', '', '', '', ''), +(2005, 'Ticket not found.', '', '', '', '', '', '', '', ''), +(2007, 'Please close ticket before deleting it permanently.', '', '', '', '', '', '', '', ''), +(2008, 'Ticket %d is already assigned to GM %s.', '', '', '', '', '', '', '', ''), +(2009, '%u Tickets succesfully reloaded from the database.', '', '', '', '', '', '', '', ''), +(2010, 'Showing list of open tickets.', '', '', '', '', '', '', '', ''), +(2011, 'Showing list of open tickets whose creator is online.', '', '', '', '', '', '', '', ''), +(2012, 'Invalid name specified. Name should be that of an online Gamemaster.', '', '', '', '', '', '', '', ''), +(2013, 'This ticket is already assigned to yourself. To unassign use .ticket unassign %d and then reassign.', '', '', '', '', '', '', '', ''), +(2014, 'Ticket %d is not assigned, you cannot unassign it.', '', '', '', '', '', '', '', ''), +(2015, 'You cannot unassign tickets from staffmembers with a higher security level than yourself.', '', '', '', '', '', '', '', ''), +(2016, 'Cannot close ticket %d, it is assigned to another GM.', '', '', '', '', '', '', '', ''); DELETE FROM `command` WHERE (`name` LIKE '%ticket%'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.ticket list','1','Displays a list of open GM tickets.'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.ticket onlinelist','1','Displays a list of open GM tickets whose owner is online.'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.ticket viewname','1','Usage: .ticket viewname $creatorname. \r\nReturns details about specified ticket. Ticket must be open and not deleted.'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.ticket viewid','1','Usage: .ticket viewid $ticketid.\r\nReturns details about specified ticket. Ticket must be open and not deleted.'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.ticket close','2','Usage: .ticket close $ticketid.\r\nCloses the specified ticket. Does not delete permanently.'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.ticket delete','3','Usage: .ticket delete $ticketid.\r\nDeletes the specified ticket permanently. Ticket must be closed first.'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.ticket assign','3','Usage: .ticket assign $ticketid $gmname.\r\nAssigns the specified ticket to the specified Game Master.'); -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.'); +INSERT INTO `command` (`name`,`security`,`help`) VALUES +('ticket list','1','Displays a list of open GM tickets.'), +('ticket onlinelist','1','Displays a list of open GM tickets whose owner is online.'), +('ticket viewname','1','Usage: .ticket viewname $creatorname. \r\nReturns details about specified ticket. Ticket must be open and not deleted.'), +('ticket viewid','1','Usage: .ticket viewid $ticketid.\r\nReturns details about specified ticket. Ticket must be open and not deleted.'), +('ticket close','2','Usage: .ticket close $ticketid.\r\nCloses the specified ticket. Does not delete permanently.'), +('ticket delete','3','Usage: .ticket delete $ticketid.\r\nDeletes the specified ticket permanently. Ticket must be closed first.'), +('ticket assign','3','Usage: .ticket assign $ticketid $gmname.\r\nAssigns the specified ticket to the specified Game Master.'), +('ticket unassign','3','Usage: .ticket unassign $ticketid.\r\nUnassigns the specified ticket from the current assigned Game Master.'), +('ticket comment','2','Usage: .ticket comment $ticketid $comment.\r\nAllows the adding or modifying of a comment to the specified ticket.'), +('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..8ada5080463 100644 --- a/sql/updates/728_world_scripts.sql +++ b/sql/updates/728_world_scripts.sql @@ -1 +1 @@ -update creature_template set scriptname='npc_apprentice_mirveda' where entry=15402;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_apprentice_mirveda' WHERE `entry`=15402;
\ No newline at end of file diff --git a/sql/updates/733_characters.sql b/sql/updates/733_characters.sql index d078529074e..21c3d27e782 100644 --- a/sql/updates/733_characters.sql +++ b/sql/updates/733_characters.sql @@ -1 +1 @@ -ALTER TABLE gm_tickets ADD `name` varchar(15) NOT NULL AFTER `playerGuid`;
\ No newline at end of file +ALTER TABLE `gm_tickets` ADD `name` varchar(15) NOT NULL AFTER `playerGuid`;
\ No newline at end of file diff --git a/sql/updates/739_characters.sql b/sql/updates/739_characters.sql index 3cbcca9837b..8a4e9197494 100644 --- a/sql/updates/739_characters.sql +++ b/sql/updates/739_characters.sql @@ -1 +1 @@ -ALTER TABLE gm_tickets ADD `comment` text(0) NOT NULL;
\ No newline at end of file +ALTER TABLE `gm_tickets` ADD `comment` text(0) NOT NULL;
\ No newline at end of file diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql index 1a3c2bfd73d..80f2fb3a5d1 100644 --- a/sql/world_scripts_full.sql +++ b/sql/world_scripts_full.sql @@ -14,13 +14,13 @@ UPDATE `gameobject_template` SET `ScriptName`='go_northern_crystal_pylon' WHERE UPDATE `gameobject_template` SET `ScriptName`='go_western_crystal_pylon' WHERE `entry`=164956; UPDATE `gameobject_template` SET `ScriptName`='go_eastern_crystal_pylon' WHERE `entry`=164957; UPDATE `gameobject_template` SET `ScriptName`='go_barov_journal' WHERE `entry`=180794; -UPDATE `gameobject_template` SET `ScriptName`='go_field_repair_bot_74A' where `entry`= 179552; +UPDATE `gameobject_template` SET `ScriptName`='go_field_repair_bot_74A' where `entry`=179552; UPDATE `gameobject_template` SET `ScriptName`='go_orb_of_command' WHERE `entry`=179879; UPDATE `gameobject_template` SET `ScriptName`='go_tablet_of_madness' WHERE `entry`=180368; UPDATE `gameobject_template` SET `ScriptName`='go_tablet_of_the_seven' WHERE `entry`=169294; -UPDATE `gameobject_template` set `ScriptName`='go_manticron_cube' WHERE `entry`= 181713; -UPDATE `gameobject_template` SET `ScriptName`='go_mausoleum_trigger' WHERE `entry`= 104593; -UPDATE `gameobject_template` SET `ScriptName`='go_mausoleum_door' WHERE `entry`= 176594; +UPDATE `gameobject_template` set `ScriptName`='go_manticron_cube' WHERE `entry`=181713; +UPDATE `gameobject_template` SET `ScriptName`='go_mausoleum_trigger' WHERE `entry`=104593; +UPDATE `gameobject_template` SET `ScriptName`='go_mausoleum_door' WHERE `entry`=176594; UPDATE `gameobject_template` SET `scriptname`='go_crystal_prison' WHERE `entry`=185126; /* GUARD */ @@ -66,7 +66,7 @@ UPDATE `item_template` SET `ScriptName`='item_voodoo_charm' WHERE `entry`=8149; UPDATE `item_template` SET `ScriptName`='item_vorenthals_presence' WHERE `entry`=30259; UPDATE `item_template` SET `ScriptName`='item_yehkinyas_bramble' WHERE `entry`=10699; UPDATE `item_template` SET `ScriptName`='item_zezzaks_shard' WHERE `entry`=31463; -UPDATE `item_template` SET `ScriptName` = "item_only_for_flight" WHERE `entry` IN (34475, 34489, 24538); +UPDATE `item_template` SET `ScriptName`='item_only_for_flight' WHERE `entry` IN (34475, 34489, 24538); /* NPC (usually creatures to be found in more than one specific zone) */ UPDATE `creature_template` SET `ScriptName`='npc_chicken_cluck' WHERE `entry`=620; @@ -81,8 +81,8 @@ UPDATE `creature_template` SET `ScriptName`='npc_prof_leather' WHERE `entry` IN UPDATE `creature_template` SET `ScriptName`='npc_prof_tailor' WHERE `entry` IN (22208,22212,22213); UPDATE `creature_template` SET `ScriptName`='npc_rogue_trainer' WHERE `entry` IN (918,4163,3328,4583,5165,5167,13283,16684); UPDATE `creature_template` SET `ScriptName`='npc_sayge' WHERE `entry`=14822; -UPDATE `creature_template` SET `ScriptName`='npc_steam_tonk' WHERE `entry`= 19405; -UPDATE `creature_template` SET `ScriptName`='npc_tonk_mine' WHERE `entry`= 15368; +UPDATE `creature_template` SET `ScriptName`='npc_steam_tonk' WHERE `entry`=19405; +UPDATE `creature_template` SET `ScriptName`='npc_tonk_mine' WHERE `entry`=15368; UPDATE `creature_template` SET `ScriptName`='npc_winter_reveler' WHERE `entry`=15760; UPDATE `creature_template` SET `ScriptName`='npc_brewfest_reveler' WHERE `entry`=24484; UPDATE `creature_template` SET `ScriptName`='npc_snake_trap_serpents' WHERE `entry` IN (19921, 19833); @@ -104,7 +104,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_professor_phizzlethorpe' WHERE UPDATE `creature_template` SET `ScriptName`='mob_rizzle_sprysprocket' WHERE `entry`=23002; UPDATE `creature_template` SET `ScriptName`='mob_depth_charge' WHERE `entry`=23025; UPDATE `creature_template` SET `ScriptName`='npc_torek' WHERE `entry`=12858; -UPDATE `creature_template` SET `ScriptName`='npc_ruul_snowhoof' WHERE `entry`= 12818; +UPDATE `creature_template` SET `ScriptName`='npc_ruul_snowhoof' WHERE `entry`=12818; /* */ /* AUCHINDOUN */ @@ -119,8 +119,8 @@ UPDATE `creature_template` SET `ScriptName`='mob_ethereal_beacon' WHERE `entry`= UPDATE `creature_template` SET `ScriptName`='boss_exarch_maladaar' WHERE `entry`=18373; UPDATE `creature_template` SET `ScriptName`='mob_avatar_of_martyred' WHERE `entry`=18478; UPDATE `creature_template` SET `ScriptName`='mob_stolen_soul' WHERE `entry`=18441; -UPDATE `creature_template` SET `ScriptName`='boss_shirrak_the_dead_watcher' WHERE `entry`= '18371'; -UPDATE `creature_template` SET `ScriptName`='mob_focus_fire' WHERE `entry`= '18374'; +UPDATE `creature_template` SET `ScriptName`='boss_shirrak_the_dead_watcher' WHERE `entry`=18371; +UPDATE `creature_template` SET `ScriptName`='mob_focus_fire' WHERE `entry`=18374; /* SETHEKK HALLS */ UPDATE `instance_template` SET `script`='instance_sethekk_halls' WHERE `map`=556; @@ -165,7 +165,7 @@ UPDATE `instance_template` SET `script`='instance_black_temple' WHERE `map`=564; UPDATE `creature_template` SET `ScriptName`='npc_akama_shade' WHERE `entry`=22990; -- Akama at Shade of Akama UPDATE `creature_template` SET `ScriptName`='npc_akama_illidan' WHERE `entry`=23089; -- Akama at Illidan UPDATE `creature_template` SET `ScriptName`='mob_illidari_council' WHERE `entry`=23426; -- Illidari Council controller mob -UPDATE `creature_template` SET `ScriptName`='mob_blood_elf_council_voice_trigger' WHERE `entry` = 23499; -- Voice Trigger Mob (Controls Aggro + Enrage yells) +UPDATE `creature_template` SET `ScriptName`='mob_blood_elf_council_voice_trigger' WHERE `entry` =23499; -- Voice Trigger Mob (Controls Aggro + Enrage yells) UPDATE `creature_template` SET `ScriptName`='boss_veras_darkshadow' WHERE `entry`=22952; -- Rogue of Illidari Council UPDATE `creature_template` SET `ScriptName`='boss_teron_gorefiend' WHERE `entry`=22871; -- Teron Gorefiend UPDATE `creature_template` SET `ScriptName`='boss_supremus' WHERE `entry`=22898; -- Supremus @@ -342,9 +342,9 @@ UPDATE `creature_template` SET `ScriptName`='boss_fathomguard_caribdis' WHERE `e UPDATE `creature_template` SET `ScriptName`='boss_morogrim_tidewalker' WHERE `entry`=21213; UPDATE `creature_template` SET `ScriptName`='mob_water_globule' WHERE `entry`=21913; /* The Lurker Below */ -UPDATE `creature_template` SET `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'; +UPDATE `creature_template` SET `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; /* Lady Vashj event */ UPDATE `creature_template` SET `ScriptName`='boss_lady_vashj' WHERE `entry`=21212; UPDATE `creature_template` SET `ScriptName`='mob_enchanted_elemental' WHERE `entry`=21958; @@ -421,7 +421,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_blood_knight_dawnstar' WHERE `e UPDATE `creature_template` SET `ScriptName`='npc_budd_nedreck' WHERE `entry`=23559; UPDATE `creature_template` SET `ScriptName`='npc_rathis_tomber' WHERE `entry`=16224; UPDATE `creature_template` SET `Scriptname`='npc_ranger_lilatha' WHERE entry=16295; -update `gameobject_template` SET `ScriptName`='go_gilded_brazier' WHERE `entry`= 181956; +update `gameobject_template` SET `ScriptName`='go_gilded_brazier' WHERE `entry`=181956; /* GNOMEREGAN */ @@ -442,7 +442,7 @@ UPDATE `creature_template` SET `ScriptName`='boss_krosh_firehand' WHERE `entry`= /* BLOOD FURNACE */ /* The Maker,Broggok,Kelidan,Broggok's cloud */ -UPDATE `instance_template` SET `script` = 'instance_blood_furnace' WHERE `map` = '542'; +UPDATE `instance_template` SET `script`='instance_blood_furnace' WHERE `map`=542; UPDATE `creature_template` SET `ScriptName`='boss_the_maker' WHERE `entry`=17381; UPDATE `creature_template` SET `ScriptName`='boss_broggok' WHERE `entry`=17380; UPDATE `creature_template` SET `ScriptName`='boss_kelidan_the_breaker' WHERE `entry`=17377; @@ -453,10 +453,10 @@ UPDATE `creature_template` SET `ScriptName`='mob_shadowmoon_channeler' WHERE `en /* Vazruden,Omor the Unscarred,Watchkeeper Gargolmar */ UPDATE `creature_template` SET `ScriptName`='boss_omor_the_unscarred' WHERE `entry`=17308; UPDATE `creature_template` SET `ScriptName`='boss_watchkeeper_gargolmar' WHERE `entry`=17306; -UPDATE `creature_template` SET `ScriptName`='boss_vazruden_the_herald' WHERE `entry`= '17307'; -UPDATE `creature_template` SET `ScriptName`='boss_vazruden' WHERE `entry`= '17537'; -UPDATE `creature_template` SET `ScriptName`='boss_nazan' WHERE `entry`= '17536'; -UPDATE `creature_template` SET `ScriptName`='mob_hellfire_sentry' WHERE `entry`= '17517'; +UPDATE `creature_template` SET `ScriptName`='boss_vazruden_the_herald' WHERE `entry`=17307; +UPDATE `creature_template` SET `ScriptName`='boss_vazruden' WHERE `entry`=17537; +UPDATE `creature_template` SET `ScriptName`='boss_nazan' WHERE `entry`=17536; +UPDATE `creature_template` SET `ScriptName`='mob_hellfire_sentry' WHERE `entry`=17517; /* SHATTERED HALLS */ /* Nethekurse and his spawned shadowfissure */ @@ -473,7 +473,7 @@ UPDATE `instance_template` SET `script`='instance_magtheridons_lair' WHERE `map` UPDATE `gameobject_template` SET `ScriptName`='go_manticron_cube' WHERE `entry`=181713; UPDATE `creature_template` SET `ScriptName`='boss_magtheridon' WHERE `entry`=17257; UPDATE `creature_template` SET `ScriptName`='mob_hellfire_channeler' WHERE `entry`=17256; -update `creature_template` SET `ScriptName`='mob_abyssal' WHERE `entry`= 17454; +update `creature_template` SET `ScriptName`='mob_abyssal' WHERE `entry`=17454; /* HELLFIRE PENINSULA */ UPDATE `creature_template` SET `ScriptName`='boss_doomlord_kazzak' WHERE `entry`=18728; @@ -536,7 +536,7 @@ UPDATE `creature_template` SET `ScriptName`='netherspite_infernal' WHERE `entry` UPDATE `creature_template` SET `ScriptName`='npc_berthold' WHERE `entry`=16153; UPDATE `creature_template` SET `ScriptName`='npc_barnes' WHERE `entry`=16812; UPDATE `creature_template` SET `ScriptName`='npc_grandmother' WHERE `entry`=17603; -UPDATE `creature_template` SET `ScriptName`='npc_image_of_medivh' WHERE `entry`= 17651; +UPDATE `creature_template` SET `ScriptName`='npc_image_of_medivh' WHERE `entry`=17651; /* LOCH MODAN */ UPDATE `creature_template` SET `ScriptName`='npc_mountaineer_pebblebitty' WHERE `entry`=3836; @@ -591,11 +591,11 @@ UPDATE `creature_template` SET `ScriptName`='npc_bunthen_plainswind' WHERE `entr UPDATE `creature_template` SET `ScriptName`='npc_great_bear_spirit' WHERE `entry`=11956; UPDATE `creature_template` SET `ScriptName`='npc_silva_filnaveth' WHERE `entry`=11800; UPDATE `creature_template` SET `ScriptName`='npc_clintar_dreamwalker' WHERE `entry`=22834; -UPDATE `creature_template` SET `ScriptName`='npc_clintar_spirit' WHERE `entry`= 22916; +UPDATE `creature_template` SET `ScriptName`='npc_clintar_spirit' WHERE `entry`=22916; /* 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; /* NAGRAND */ UPDATE `creature_template` SET `ScriptName`='mob_lump' WHERE `entry`=18351; @@ -637,7 +637,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_protectorate_nether_drake' WHER UPDATE `creature_template` SET `ScriptName`='npc_veronia' WHERE `entry`=20162; UPDATE `creature_template` SET `ScriptName`='mob_phase_hunter' WHERE `entry`=18879; UPDATE `creature_template` SET `ScriptName`='npc_professor_dabiri' WHERE `entry`=20907; -UPDATE `creature_template` SET `ScriptName`='npc_bessy' WHERE entry = 20415; +UPDATE `creature_template` SET `ScriptName`='npc_bessy' WHERE entry =20415; /* ONYXIA'S LAIR */ UPDATE `creature_template` SET `ScriptName`='boss_onyxia' WHERE `entry`=10184; @@ -673,9 +673,9 @@ UPDATE `creature_template` SET `ScriptName`='boss_houndmaster_loksey' WHERE `ent UPDATE `creature_template` SET `ScriptName`='boss_interrogator_vishas' WHERE `entry`=3983; UPDATE `creature_template` SET `ScriptName`='boss_scarlet_commander_mograine' WHERE `entry`=3976; UPDATE `creature_template` SET `ScriptName`='boss_scorn' WHERE `entry`=14693; -UPDATE `creature_template` SET `ScriptName`='boss_headless_horseman' WHERE `entry`= 23682; -UPDATE `creature_template` SET `ScriptName`='mob_head' WHERE `entry`= 23775; -UPDATE `creature_template` SET `ScriptName`='mob_pulsing_pumpkin' WHERE `entry`= 23694; +UPDATE `creature_template` SET `ScriptName`='boss_headless_horseman' WHERE `entry`=23682; +UPDATE `creature_template` SET `ScriptName`='mob_head' WHERE `entry`=23775; +UPDATE `creature_template` SET `ScriptName`='mob_pulsing_pumpkin' WHERE `entry`=23694; UPDATE `creature_template` SET `ScriptName`='mob_wisp_invis' WHERE `entry`=23686; UPDATE `creature_template` SET `ScriptName`='mob_wisp_invis' WHERE `entry`=24034; UPDATE `creature_template` SET `ScriptName`='mob_scarlet_trainee' WHERE `entry`=6575; @@ -719,7 +719,7 @@ UPDATE `creature_template` SET `ScriptName`='mob_enslaved_netherwing_drake' WHER UPDATE `creature_template` SET `ScriptName`='npc_overlord_morghor' WHERE entry= 23139; UPDATE `creature_template` SET `ScriptName`='' WHERE entry=23141; UPDATE `creature_template` SET `ScriptName`='mob_illidari_spawn' WHERE `entry` IN (22075, 22074, 19797); -UPDATE `creature_template` SET `ScriptName`='mob_torloth_the_magnificent' WHERE `entry`='22076'; +UPDATE `creature_template` SET `ScriptName`='mob_torloth_the_magnificent' WHERE `entry`=22076; UPDATE `creature_template` SET `ScriptName`='npc_lord_illidan_stormrage' WHERE `entry`=22083; UPDATE `creature_template` SET `ScriptName`='npc_earthmender_wilda' WHERE `entry`=21027; UPDATE `creature_template` SET `ScriptName`='npc_enraged_spirit' WHERE `entry` IN (21050, 21061, 21060, 21059); @@ -729,7 +729,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_raliq_the_drunk' WHERE `entry`= UPDATE `creature_template` SET `ScriptName`='npc_salsalabim' WHERE `entry`=18584; UPDATE `creature_template` SET `ScriptName`='npc_shattrathflaskvendors' WHERE `entry` IN (23483,23484); UPDATE `creature_template` SET `ScriptName`='npc_zephyr' WHERE `entry`=25967; -UPDATE `creature_template` SET `ScriptName`='npc_kservant' WHERE `entry`= 19685; +UPDATE `creature_template` SET `ScriptName`='npc_kservant' WHERE `entry`=19685; UPDATE `creature_template` SET `ScriptName`='npc_dirty_larry' WHERE `entry`=19720; UPDATE `creature_template` SET `ScriptName`='npc_ishanah' WHERE `entry`=18538; UPDATE `creature_template` SET `ScriptName`='npc_khadgar' WHERE `entry`=18166; @@ -784,14 +784,14 @@ UPDATE `creature_template` SET `ScriptName`='mob_freed_soul' WHERE `entry`=11136 /* SUNKEN TEMPLE */ /* SUNWELL PLATEAU */ -update `instance_template` set `script` = 'instance_sunwell_plateau' where map = 580; -UPDATE `creature_template` SET `ScriptName` = 'boss_brutallus' WHERE entry = 24882; -UPDATE `creature_template` SET `ScriptName` = 'boss_felmyst' WHERE `entry`= 25038; -UPDATE `creature_template` SET `ScriptName` = 'mob_felmyst_vapor' WHERE `entry`= 25265; -UPDATE `creature_template` SET `ScriptName` = 'mob_felmyst_trail' WHERE `entry`= 25267; -update `creature_template` set `ScriptName` = 'boss_sacrolash' WHERE `entry`= 25165; -update `creature_template` set `ScriptName` = 'boss_alythess' WHERE `entry`= 25166; -update `creature_template` set `ScriptName` = 'mob_shadow_image' WHERE `entry`= 25214; +update `instance_template` set `script` ='instance_sunwell_plateau' where map =580; +UPDATE `creature_template` SET `ScriptName`='boss_brutallus' WHERE entry =24882; +UPDATE `creature_template` SET `ScriptName`='boss_felmyst' WHERE `entry`=25038; +UPDATE `creature_template` SET `ScriptName`='mob_felmyst_vapor' WHERE `entry`=25265; +UPDATE `creature_template` SET `ScriptName`='mob_felmyst_trail' WHERE `entry`=25267; +update `creature_template` set `ScriptName`='boss_sacrolash' WHERE `entry`=25165; +update `creature_template` set `ScriptName`='boss_alythess' WHERE `entry`=25166; +update `creature_template` set `ScriptName`='mob_shadow_image' WHERE `entry`=25214; /* SWAMP OF SORROWS */ @@ -802,7 +802,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_custodian_of_time' WHERE `entry UPDATE `creature_template` SET `ScriptName`='npc_marin_noggenfogger' WHERE `entry`=7564; UPDATE `creature_template` SET `ScriptName`='npc_steward_of_time' WHERE `entry`=20142; UPDATE `creature_template` SET `ScriptName`='npc_stone_watcher_of_norgannon' WHERE `entry`=7918; -UPDATE `creature_template` SET `ScriptName` = 'npc_OOX17' WHERE `entry`= 7784; +UPDATE `creature_template` SET `ScriptName`='npc_OOX17' WHERE `entry`=7784; /* TELDRASSIL */ @@ -835,8 +835,8 @@ UPDATE `creature_template` SET `ScriptName`='npc_millhouse_manastorm' WHERE `ent /* THE EYE */ UPDATE `instance_template` SET `script`='instance_the_eye' WHERE `map`=550; -UPDATE `gameobject_template` SET `ScriptName` = 'go_kael_orb' WHERE `entry`= 188173; -UPDATE `gameobject_template` SET `ScriptName` = 'go_movie_orb' WHERE `entry`= 187578; +UPDATE `gameobject_template` SET `ScriptName`='go_kael_orb' WHERE `entry`=188173; +UPDATE `gameobject_template` SET `ScriptName`='go_movie_orb' WHERE `entry`=187578; /* The Eye Trash Mobs */ UPDATE `creature_template` SET `ScriptName`='mob_crystalcore_devastator' WHERE `entry`=20040; /* Void Reaver event */ @@ -892,7 +892,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_skyguard_handler_irena' WHERE ` UPDATE `creature_template` SET `ScriptName`='npc_isla_starmane' WHERE `entry`=18760; /* THOUSAND NEEDLES */ -UPDATE `creature_template` SET `ScriptName` = 'npc_swiftmountain' WHERE `entry`= 10427; +UPDATE `creature_template` SET `ScriptName`='npc_swiftmountain' WHERE `entry`=10427; /* THUNDER BLUFF */ UPDATE `creature_template` SET `ScriptName`='npc_cairne_bloodhoof' WHERE `entry`=3057; @@ -906,13 +906,13 @@ UPDATE `creature_template` SET `ScriptName`='boss_ironaya' WHERE `entry`=7228; UPDATE `creature_template` SET `ScriptName`='mob_jadespine_basilisk' WHERE `entry`=4863; UPDATE `creature_template` SET `ScriptName`='npc_lore_keeper_of_norgannon' WHERE `entry`=7172; UPDATE `creature_template` SET `ScriptName`='boss_archaedas' WHERE `entry`=2748; -UPDATE `creature_template` SET `ScriptName`='mob_archaedas_minions' WHERE `entry` IN ('7309', '7077', '7076', '10120'); +UPDATE `creature_template` SET `ScriptName`='mob_archaedas_minions' WHERE `entry` IN (7309, 7077, 7076, 10120); UPDATE `creature_template` SET `ScriptName`='mob_stonekeepers' WHERE `entry`=4857; UPDATE `gameobject_template` SET `ScriptName`='go_altar_of_the_keepers' WHERE `entry`=130511; UPDATE `gameobject_template` SET `ScriptName`='go_altar_of_archaedas' WHERE `entry`=133234; /* UN'GORO CRATER */ -UPDATE `creature_template` SET `ScriptName` = 'npc_ame' WHERE `entry`= 9623; +UPDATE `creature_template` SET `ScriptName`='npc_ame' WHERE `entry`=9623; /* UNDERCITY */ UPDATE `creature_template` SET `ScriptName`='npc_lady_sylvanas_windrunner' WHERE `entry`=10181; @@ -927,7 +927,7 @@ UPDATE `creature_template` SET `ScriptName`='npcs_dithers_and_arbington' WHERE ` UPDATE `creature_template` SET `ScriptName`='npc_the_scourge_cauldron' WHERE `entry`=11152; /* WESTFALL */ -UPDATE `creature_template` SET `ScriptName`='npc_defias_traitor' WHERE `entry`='467'; +UPDATE `creature_template` SET `ScriptName`='npc_defias_traitor' WHERE `entry`=467; /* WETLANDS */ |