From 377f385c8138d37cfca2f55f80ac34c4839ab3a7 Mon Sep 17 00:00:00 2001 From: Unholychick Date: Mon, 18 Aug 2014 22:01:47 +0100 Subject: Scripts/Ulduar: Spellscripts for Mimiron Closes #12579 Signed-off-by: DDuarte --- sql/updates/world/2014_08_18_00_world_ulduar.sql | 100 +++++++++++++++++++++++ 1 file changed, 100 insertions(+) create mode 100644 sql/updates/world/2014_08_18_00_world_ulduar.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_08_18_00_world_ulduar.sql b/sql/updates/world/2014_08_18_00_world_ulduar.sql new file mode 100644 index 00000000000..bdf0cedb986 --- /dev/null +++ b/sql/updates/world/2014_08_18_00_world_ulduar.sql @@ -0,0 +1,100 @@ +-- +DELETE FROM `spell_script_names` WHERE `spell_id` IN (63274, 63414, 63667, 63382, 64402, 65034, 63681, 64542, 65192, 64570, 63027, 65346, 66351, 65224, 63009, 64620, 63820, 64425, 64426, 64621, 64398, 64619, 64623, 65354, 64618, 64436, 63340, 64383, 63339, 64562, 63041, 63801, 64463); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(63801, 'spell_mimiron_bomb_bot'), +(65192, 'spell_mimiron_clear_fires'), +(65224, 'spell_mimiron_clear_fires'), +(64619, 'spell_mimiron_clear_fires'), +(65354, 'spell_mimiron_clear_fires'), +(64463, 'spell_mimiron_despawn_assault_bots'), +(64618, 'spell_mimiron_fire_search'), +(64570, 'spell_mimiron_flame_suppressant'), +(64436, 'spell_mimiron_magnetic_core'), +(63667, 'spell_mimiron_napalm_shell'), +(63274, 'spell_mimiron_p3wx2_laser_barrage'), +(64542, 'spell_mimiron_plasma_blast'), +(63027, 'spell_mimiron_proximity_mines'), +(66351, 'spell_mimiron_proximity_explosion'), +(63009, 'spell_mimiron_proximity_explosion'), +(65346, 'spell_mimiron_proximity_trigger'), +(63382, 'spell_mimiron_rapid_burst'), +(64402, 'spell_mimiron_rocket_strike'), +(65034, 'spell_mimiron_rocket_strike'), +(63041, 'spell_mimiron_rocket_strike_damage'), +(63681, 'spell_mimiron_rocket_strike_target_select'), +(64383, 'spell_mimiron_self_repair'), +(63414, 'spell_mimiron_spinning_up'), +(64426, 'spell_mimiron_summon_assault_bot'), +(64425, 'spell_mimiron_summon_assault_bot_target'), +(64621, 'spell_mimiron_summon_fire_bot'), +(64620, 'spell_mimiron_summon_fire_bot_target'), +(64562, 'spell_mimiron_summon_flames_spread'), +(64623, 'spell_mimiron_summon_frost_bomb_target'), +(64398, 'spell_mimiron_summon_junk_bot'), +(63820, 'spell_mimiron_summon_junk_bot_target'), +(63339, 'spell_mimiron_weld'); + +DELETE FROM `spelldifficulty_dbc` WHERE `id` IN (66351, 64019, 63387, 62997, 64348, 64352, 63689, 65647, 63677, 63679, 64626); +INSERT INTO `spelldifficulty_dbc` (`id`, `spellid0`, `spellid1`) VALUES +(64348, 64348, 64536), +(64352, 64352, 64537), +(66351, 66351, 63009), +(63387, 63387, 64531), +(64019, 64019, 64532), +(62997, 62997, 64529), +(63689, 63689, 64535), +(65647, 65647, 65648), +(63677, 63677, 64533), +(63679, 63679, 64534), +(64626, 64626, 65333); + +DELETE FROM `conditions` WHERE `SourceEntry` IN (65192, 64570, 63274, 66490, 63300, 63414, 64539, 64402, 65034, 63041, 65224, 64620, 63820, 64425, 64619, 64626, 65333, 65354, 64618, 64623, 64436, 64444, 65101, 64463); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 65192, 0, 0, 31, 0, 3, 34363, 0, 0, 0, 0, '', 'Flame Suppressant VX EFFECT_0 can only hit NPC_FLAME'), +(13, 1, 65192, 0, 1, 31, 0, 3, 34121, 0, 0, 0, 0, '', 'Flame Suppressant VX EFFECT_0 can only hit NPC_FLAME_SPREAD'), +(13, 2, 64570, 0, 0, 31, 0, 3, 34363, 0, 0, 0, 0, '', 'Flame Suppressant MK EFFECT_1 can only hit NPC_FLAME'), +(13, 2, 64570, 0, 1, 31, 0, 3, 34121, 0, 0, 0, 0, '', 'Flame Suppressant MK EFFECT_1 can only hit NPC_FLAME_SPREAD'), +(13, 1, 64623, 0, 0, 31, 0, 3, 34363, 0, 0, 0, 0, '', 'Frost Bomb EFFECT_0 can only hit NPC_FLAME'), +(13, 1, 64623, 0, 1, 31, 0, 3, 34121, 0, 0, 0, 0, '', 'Frost Bomb EFFECT_0 can only hit NPC_FLAME_SPREAD'), +(13, 4, 64626, 0, 0, 31, 0, 3, 34363, 0, 0, 0, 0, '', 'Explosion EFFECT_2 can only hit NPC_FLAME'), +(13, 4, 64626, 0, 1, 31, 0, 3, 34121, 0, 0, 0, 0, '', 'Explosion EFFECT_2 can only hit NPC_FLAME_SPREAD'), +(13, 4, 65333, 0, 0, 31, 0, 3, 34363, 0, 0, 0, 0, '', 'Explosion EFFECT_2 can only hit NPC_FLAME'), +(13, 4, 65333, 0, 1, 31, 0, 3, 34121, 0, 0, 0, 0, '', 'Explosion EFFECT_2 can only hit NPC_FLAME_SPREAD'), +(13, 1, 65224, 0, 0, 31, 0, 3, 34363, 0, 0, 0, 0, '', 'Clear Fires EFFECT_0 can only hit NPC_FLAME'), +(13, 1, 65224, 0, 1, 31, 0, 3, 34121, 0, 0, 0, 0, '', 'Clear Fires EFFECT_0 can only hit NPC_FLAME_SPREAD'), +(13, 1, 65354, 0, 0, 31, 0, 3, 34363, 0, 0, 0, 0, '', 'Clear Fires EFFECT_0 can only hit NPC_FLAME'), +(13, 1, 65354, 0, 1, 31, 0, 3, 34121, 0, 0, 0, 0, '', 'Clear Fires EFFECT_0 can only hit NPC_FLAME_SPREAD'), +(13, 1, 64619, 0, 0, 31, 0, 3, 34363, 0, 0, 0, 0, '', 'Water Spray EFFECT_0 can only hit NPC_FLAME'), +(13, 1, 64619, 0, 1, 31, 0, 3, 34121, 0, 0, 0, 0, '', 'Water Spray EFFECT_0 can only hit NPC_FLAME_SPREAD'), +(13, 1, 64618, 0, 0, 31, 0, 3, 34363, 0, 0, 0, 0, '', 'Fire Search EFFECT_0 can only hit NPC_FLAME'), +(13, 1, 64618, 0, 1, 31, 0, 3, 34121, 0, 0, 0, 0, '', 'Fire Search EFFECT_0 can only hit NPC_FLAME_SPREAD'), +(13, 1, 64539, 0, 0, 31, 0, 3, 34071, 0, 0, 0, 0, '', 'Napalm Shell EFFECT_0 can only hit NPC_LEVIATHAN_MKII_TURRET'), +(13, 1, 63274, 0, 0, 31, 0, 3, 33576, 0, 0, 0, 0, '', 'P3Wx2 Laser Barrage EFFECT_0 can only hit NPC_DB_TARGET'), +(17, 0, 66490, 0, 0, 31, 0, 3, 33432, 0, 0, 0, 0, '', 'P3Wx2 Laser Barrage can only hit NPC_LEVIATHAN_MKII'), +(17, 0, 63300, 0, 0, 31, 0, 3, 33651, 0, 0, 0, 0, '', 'P3Wx2 Laser Barrage can only hit NPC_VX_001'), +(13, 1, 63414, 0, 0, 31, 0, 3, 33576, 0, 0, 0, 0, '', 'Spinning Up EFFECT_0 can only hit NPC_DB_TARGET'), +(13, 2, 63414, 0, 1, 31, 0, 3, 33432, 0, 0, 0, 0, '', 'Spinning Up EFFECT_1 can only hit NPC_LEVIATHAN_MKII'), +(13, 1, 64620, 0, 0, 31, 0, 3, 33856, 0, 0, 0, 0, '', 'Summon Fire Bot Trigger EFFECT_0 can only hit NPC_BOT_SUMMON_TRIGGER'), +(13, 1, 63820, 0, 0, 31, 0, 3, 33856, 0, 0, 0, 0, '', 'Summon Junk Bot Trigger EFFECT_0 can only hit NPC_BOT_SUMMON_TRIGGER'), +(13, 1, 64425, 0, 0, 31, 0, 3, 33856, 0, 0, 0, 0, '', 'Summon Assault Bot Trigger EFFECT_0 can only hit NPC_BOT_SUMMON_TRIGGER'), +(13, 1, 64402, 0, 0, 31, 0, 3, 34050, 0, 0, 0, 0, '', 'Rocket Strike EFFECT_0 can only hit NPC_ROCKET_MIMIRON_VISUAL'), +(13, 1, 65034, 0, 0, 31, 0, 3, 34050, 0, 0, 0, 0, '', 'Rocket Strike EFFECT_0 can only hit NPC_ROCKET_MIMIRON_VISUAL'), +(13, 2, 64436, 0, 0, 31, 0, 3, 33670, 0, 0, 0, 0, '', 'Magnetic Core EFFECT_1 can only hit NPC_AERIAL_COMMAND_UNIT'), +(13, 1, 64444, 0, 0, 31, 0, 3, 33670, 0, 0, 0, 0, '', 'Magnetic Core EFFECT_0 can only hit NPC_AERIAL_COMMAND_UNIT'), +(13, 1, 65101, 0, 0, 31, 0, 3, 34071, 0, 0, 0, 0, '', 'Emergency Mode EFFECT_0 can only hit NPC_LEVIATHAN_MKII_TURRET'), +(13, 1, 64463, 0, 0, 31, 0, 3, 34057, 0, 0, 0, 0, '', 'Despawn Assault Bots EFFECT_1 can only hit NPC_ASSAULT_BOT'), +(13, 2, 63041, 0, 0, 31, 0, 3, 34057, 0, 0, 0, 0, '', 'Rocket Strike EFFECT_1 can only hit NPC_ASSAULT_BOT'), +(13, 4, 63041, 0, 1, 31, 0, 3, 34137, 0, 0, 0, 0, '', 'Rocket Strike EFFECT_2 can only hit NPC_EMERGENCY_FIRE_BOT'), +(13, 4, 63041, 0, 2, 31, 0, 3, 33855, 0, 0, 0, 0, '', 'Rocket Strike EFFECT_2 can only hit NPC_JUNK_BOT'), +(13, 4, 63041, 0, 3, 31, 0, 3, 33836, 0, 0, 0, 0, '', 'Rocket Strike EFFECT_2 can only hit NPC_BOMB_BOT'); + +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (64626, 64570, 64627, 65333, 64567); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +(64626, -64624, 0, 'Explosion - Remove SPELL_FROST_BOMB_LINKED from caster'), +(64626, -64561, 1, 'Explosion - Remove SPELL_FLAMES_PERIODIC_TRIGGER from targets'), +(65333, -64624, 0, 'Explosion - Remove SPELL_FROST_BOMB_LINKED from caster'), +(65333, -64561, 1, 'Explosion - Remove SPELL_FLAMES_PERIODIC_TRIGGER from targets'), +(64627, -64561, 1, 'Frost Bomb - Remove SPELL_FLAMES_PERIODIC_TRIGGER from target'), +(64567, 64563, 1, 'Summon Flames Initial - Cast SPELL_SUMMON_FLAMES_INITIAL on hit targets'), +(64570, -64561, 1, 'Flame Suppressant - Remove SPELL_FLAMES_PERIODIC_TRIGGER from targets'); +-- -- cgit v1.2.3 From 58c2b66e95270720f77efe8d90faa33822973049 Mon Sep 17 00:00:00 2001 From: Zharvek Date: Mon, 18 Aug 2014 22:06:06 +0100 Subject: Core/RBAC: Fix RBAC permissions This commit adds three missing commands to the world.commands table. The RBAC.h file is updated to the correct IDs from the auth.rbac_permissions table and the world.commands table. The RBAC.h file also had to be reordered to keep it clean. Closes #12854 Signed-off-by: DDuarte --- sql/updates/world/2014_08_14_02_world_command.sql | 8 ++++ src/server/game/Accounts/RBAC.h | 56 +++++++++++------------ 2 files changed, 36 insertions(+), 28 deletions(-) create mode 100644 sql/updates/world/2014_08_14_02_world_command.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_08_14_02_world_command.sql b/sql/updates/world/2014_08_14_02_world_command.sql new file mode 100644 index 00000000000..0a3b44b1991 --- /dev/null +++ b/sql/updates/world/2014_08_14_02_world_command.sql @@ -0,0 +1,8 @@ +DELETE FROM `command` WHERE `permission`='683'; +DELETE FROM `command` WHERE `permission`='684'; +DELETE FROM `command` WHERE `permission`='705'; + +INSERT INTO `command` (`name`, `permission`, `help`) VALUES +('reload reputation_reward_rate', 683, 'Syntax: .reload reputation_reward_rate\r\nReload reputation_reward_rate table.'), +('reload reputation_spillover_template', 684, 'Syntax: .reload reputation_spillover_template\r\nReload reputation_spillover_template table.'), +('reload warden_action', 705, 'Syntax: .reload warden_action\r\nReload warden_action.'); diff --git a/src/server/game/Accounts/RBAC.h b/src/server/game/Accounts/RBAC.h index f2637a5febc..855ffd51bb8 100644 --- a/src/server/game/Accounts/RBAC.h +++ b/src/server/game/Accounts/RBAC.h @@ -427,8 +427,8 @@ enum RBACPermissions RBAC_PERM_COMMAND_REPAIRITEMS = 521, RBAC_PERM_COMMAND_RESPAWN = 522, RBAC_PERM_COMMAND_REVIVE = 523, - RBAC_PERM_COMMAND_SAVE = 524, - RBAC_PERM_COMMAND_SAVEALL = 525, + RBAC_PERM_COMMAND_SAVEALL = 524, + RBAC_PERM_COMMAND_SAVE = 525, RBAC_PERM_COMMAND_SETSKILL = 526, RBAC_PERM_COMMAND_SHOWAREA = 527, RBAC_PERM_COMMAND_SUMMON = 528, @@ -549,10 +549,10 @@ enum RBACPermissions RBAC_PERM_COMMAND_RELOAD_EVENT_SCRIPTS = 643, RBAC_PERM_COMMAND_RELOAD_FISHING_LOOT_TEMPLATE = 644, RBAC_PERM_COMMAND_RELOAD_GAME_GRAVEYARD_ZONE = 645, - RBAC_PERM_COMMAND_RELOAD_GAMEOBJECT_QUESTENDER = 646, - RBAC_PERM_COMMAND_RELOAD_GAMEOBJECT_QUEST_LOOT_TEMPLATE = 647, - RBAC_PERM_COMMAND_RELOAD_GAMEOBJECT_QUESTSTARTER = 648, - RBAC_PERM_COMMAND_RELOAD_GAME_TELE = 649, + RBAC_PERM_COMMAND_RELOAD_GAME_TELE = 646, + RBAC_PERM_COMMAND_RELOAD_GAMEOBJECT_QUESTENDER = 647, + RBAC_PERM_COMMAND_RELOAD_GAMEOBJECT_QUEST_LOOT_TEMPLATE = 648, + RBAC_PERM_COMMAND_RELOAD_GAMEOBJECT_QUESTSTARTER = 649, RBAC_PERM_COMMAND_RELOAD_GM_TICKETS = 650, RBAC_PERM_COMMAND_RELOAD_GOSSIP_MENU = 651, RBAC_PERM_COMMAND_RELOAD_GOSSIP_MENU_OPTION = 652, @@ -585,34 +585,34 @@ enum RBACPermissions RBAC_PERM_COMMAND_RELOAD_QUEST_TEMPLATE = 679, RBAC_PERM_COMMAND_RELOAD_RBAC = 680, RBAC_PERM_COMMAND_RELOAD_REFERENCE_LOOT_TEMPLATE = 681, - RBAC_PERM_COMMAND_RELOAD_REPUTATION_REWARD_RATE = 682, - RBAC_PERM_COMMAND_RELOAD_RESERVED_NAME = 683, - RBAC_PERM_COMMAND_RELOAD_SKILL_DISCOVERY_TEMPLATE = 684, - RBAC_PERM_COMMAND_RELOAD_SKILL_EXTRA_ITEM_TEMPLATE = 685, - RBAC_PERM_COMMAND_RELOAD_SKILL_FISHING_BASE_LEVEL = 686, - RBAC_PERM_COMMAND_RELOAD_SKINNING_LOOT_TEMPLATE = 687, - RBAC_PERM_COMMAND_RELOAD_SMART_SCRIPTS = 688, - RBAC_PERM_COMMAND_RELOAD_SPELL_AREA = 689, - RBAC_PERM_COMMAND_RELOAD_SPELL_BONUS_DATA = 690, - RBAC_PERM_COMMAND_RELOAD_SPELL_GROUP = 691, - RBAC_PERM_COMMAND_RELOAD_SPELL_GROUP_STACK_RULES = 692, - RBAC_PERM_COMMAND_RELOAD_SPELL_LEARN_SPELL = 693, - RBAC_PERM_COMMAND_RELOAD_SPELL_LINKED_SPELL = 694, + RBAC_PERM_COMMAND_RELOAD_RESERVED_NAME = 682, + RBAC_PERM_COMMAND_RELOAD_REPUTATION_REWARD_RATE = 683, + RBAC_PERM_COMMAND_RELOAD_SPILLOVER_TEMPLATE = 684, + RBAC_PERM_COMMAND_RELOAD_SKILL_DISCOVERY_TEMPLATE = 685, + RBAC_PERM_COMMAND_RELOAD_SKILL_EXTRA_ITEM_TEMPLATE = 686, + RBAC_PERM_COMMAND_RELOAD_SKILL_FISHING_BASE_LEVEL = 687, + RBAC_PERM_COMMAND_RELOAD_SKINNING_LOOT_TEMPLATE = 688, + RBAC_PERM_COMMAND_RELOAD_SMART_SCRIPTS = 689, + RBAC_PERM_COMMAND_RELOAD_SPELL_REQUIRED = 690, + RBAC_PERM_COMMAND_RELOAD_SPELL_AREA = 691, + RBAC_PERM_COMMAND_RELOAD_SPELL_BONUS_DATA = 692, + RBAC_PERM_COMMAND_RELOAD_SPELL_GROUP = 693, + RBAC_PERM_COMMAND_RELOAD_SPELL_LEARN_SPELL = 694, RBAC_PERM_COMMAND_RELOAD_SPELL_LOOT_TEMPLATE = 695, - RBAC_PERM_COMMAND_RELOAD_SPELL_PET_AURAS = 696, - RBAC_PERM_COMMAND_RELOAD_SPELL_PROC = 697, + RBAC_PERM_COMMAND_RELOAD_SPELL_LINKED_SPELL = 696, + RBAC_PERM_COMMAND_RELOAD_SPELL_PET_AURAS = 697, RBAC_PERM_COMMAND_RELOAD_SPELL_PROC_EVENT = 698, - RBAC_PERM_COMMAND_RELOAD_SPELL_REQUIRED = 699, + RBAC_PERM_COMMAND_RELOAD_SPELL_PROC = 699, RBAC_PERM_COMMAND_RELOAD_SPELL_SCRIPTS = 700, RBAC_PERM_COMMAND_RELOAD_SPELL_TARGET_POSITION = 701, RBAC_PERM_COMMAND_RELOAD_SPELL_THREATS = 702, - RBAC_PERM_COMMAND_RELOAD_SPILLOVER_TEMPLATE = 703, + RBAC_PERM_COMMAND_RELOAD_SPELL_GROUP_STACK_RULES = 703, RBAC_PERM_COMMAND_RELOAD_TRINITY_STRING = 704, - RBAC_PERM_COMMAND_RELOAD_VEHICLE_ACCESORY = 705, - RBAC_PERM_COMMAND_RELOAD_VEHICLE_TEMPLATE_ACCESSORY = 706, - RBAC_PERM_COMMAND_RELOAD_WARDEN_ACTION = 707, - RBAC_PERM_COMMAND_RELOAD_WAYPOINT_DATA = 708, - RBAC_PERM_COMMAND_RELOAD_WAYPOINT_SCRIPTS = 709, + RBAC_PERM_COMMAND_RELOAD_WARDEN_ACTION = 705, + RBAC_PERM_COMMAND_RELOAD_WAYPOINT_SCRIPTS = 706, + RBAC_PERM_COMMAND_RELOAD_WAYPOINT_DATA = 707, + RBAC_PERM_COMMAND_RELOAD_VEHICLE_ACCESORY = 708, + RBAC_PERM_COMMAND_RELOAD_VEHICLE_TEMPLATE_ACCESSORY = 709, RBAC_PERM_COMMAND_RESET = 710, RBAC_PERM_COMMAND_RESET_ACHIEVEMENTS = 711, RBAC_PERM_COMMAND_RESET_HONOR = 712, -- cgit v1.2.3 From a60c902b45b39c4641ccb9442826b567ead60595 Mon Sep 17 00:00:00 2001 From: Duarte Duarte Date: Mon, 18 Aug 2014 22:53:11 +0100 Subject: Rename 2014_08_14_02_world_command.sql to 2014_08_18_01_world_command.sql --- sql/updates/world/2014_08_14_02_world_command.sql | 8 -------- sql/updates/world/2014_08_18_01_world_command.sql | 8 ++++++++ 2 files changed, 8 insertions(+), 8 deletions(-) delete mode 100644 sql/updates/world/2014_08_14_02_world_command.sql create mode 100644 sql/updates/world/2014_08_18_01_world_command.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_08_14_02_world_command.sql b/sql/updates/world/2014_08_14_02_world_command.sql deleted file mode 100644 index 0a3b44b1991..00000000000 --- a/sql/updates/world/2014_08_14_02_world_command.sql +++ /dev/null @@ -1,8 +0,0 @@ -DELETE FROM `command` WHERE `permission`='683'; -DELETE FROM `command` WHERE `permission`='684'; -DELETE FROM `command` WHERE `permission`='705'; - -INSERT INTO `command` (`name`, `permission`, `help`) VALUES -('reload reputation_reward_rate', 683, 'Syntax: .reload reputation_reward_rate\r\nReload reputation_reward_rate table.'), -('reload reputation_spillover_template', 684, 'Syntax: .reload reputation_spillover_template\r\nReload reputation_spillover_template table.'), -('reload warden_action', 705, 'Syntax: .reload warden_action\r\nReload warden_action.'); diff --git a/sql/updates/world/2014_08_18_01_world_command.sql b/sql/updates/world/2014_08_18_01_world_command.sql new file mode 100644 index 00000000000..0a3b44b1991 --- /dev/null +++ b/sql/updates/world/2014_08_18_01_world_command.sql @@ -0,0 +1,8 @@ +DELETE FROM `command` WHERE `permission`='683'; +DELETE FROM `command` WHERE `permission`='684'; +DELETE FROM `command` WHERE `permission`='705'; + +INSERT INTO `command` (`name`, `permission`, `help`) VALUES +('reload reputation_reward_rate', 683, 'Syntax: .reload reputation_reward_rate\r\nReload reputation_reward_rate table.'), +('reload reputation_spillover_template', 684, 'Syntax: .reload reputation_spillover_template\r\nReload reputation_spillover_template table.'), +('reload warden_action', 705, 'Syntax: .reload warden_action\r\nReload warden_action.'); -- cgit v1.2.3 From 803d0c3b168bacc7c5a2c09d3c1bf6c7e9227056 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Tue, 19 Aug 2014 11:57:03 +0100 Subject: DB/Misc:Missing Emotes Add missing emotes for Image of Loken and High Abbot Landgren for quest scripts, --- sql/updates/world/2014_08_19_00_world_misc.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/2014_08_19_00_world_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_08_19_00_world_misc.sql b/sql/updates/world/2014_08_19_00_world_misc.sql new file mode 100644 index 00000000000..49d8f11fbdb --- /dev/null +++ b/sql/updates/world/2014_08_19_00_world_misc.sql @@ -0,0 +1,9 @@ +UPDATE `creature_text` SET `emote`=51 WHERE `entry`=27212; +UPDATE `creature_text` SET `emote`=1 WHERE `entry`=27439 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `emote`=6 WHERE `entry`=27439 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `emote`=1 WHERE `entry`=27439 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `emote`=25 WHERE `entry`=27439 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `emote`=274 WHERE `entry`=27439 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `sound`=2943 WHERE `entry`=27439 AND `groupid`=5 AND `id`=0; + +UPDATE `smart_scripts` SET `event_param1`=30 WHERE `entryorguid`=17831 AND `source_type`=0 AND `id`=4 AND `link`=5; -- cgit v1.2.3 From f50cd88a9e4c49d74628bf4648fd5953ac3c280e Mon Sep 17 00:00:00 2001 From: Dr-J Date: Tue, 19 Aug 2014 15:03:58 +0100 Subject: DB/Misc: Greetings texts for Dalaran Vendors Only one not working is Tiffany Cartier even though sai is same as the rest and texts are added, idk seems theres an invisible wall as unlike other vendors player cannot get behind counter where tiffany is either. --- sql/updates/world/2014_08_19_01_world_misc.sql | 84 ++++++++++++++++++++++++++ 1 file changed, 84 insertions(+) create mode 100644 sql/updates/world/2014_08_19_01_world_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_08_19_01_world_misc.sql b/sql/updates/world/2014_08_19_01_world_misc.sql new file mode 100644 index 00000000000..dd50c4ce027 --- /dev/null +++ b/sql/updates/world/2014_08_19_01_world_misc.sql @@ -0,0 +1,84 @@ +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`= '' WHERE `entry` IN(29491,28994,28721,28725,33027,28727,28715,28714,28726,29523,28989,28997,28723,28718); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(29491,28994,28721,28725,33027,28727,28715,28714,28726,29523,28989,28997,28723,28718) and `source_type`=0; + +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(29491, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Karandonna - OOC LOS - Say Line'), +(28994, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Abra Cadabra - OOC LOS - Say Line'), +(28721, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Tiffany Cartier - OOC LOS - Say Line'), +(28727, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Edward Egan - OOC LOS - Say Line'), +(33027, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Jessica Sellers - OOC LOS - Say Line'), +(28725, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Patricia Egan - OOC LOS - Say Line'), +(28715, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Endora Moorehead - OOC LOS - Say Line'), +(28714, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ildine Sorrowspear - OOC LOS - Say Line'), +(28726, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Dominique Stefano - OOC LOS - Say Line'), +(29523, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Bragund Brightlink - OOC LOS - Say Line'), +(28989, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Aemara - OOC LOS - Say Line'), +(28997, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Griselda Hunderland - OOC LOS - Say Line'), +(28723, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Larana Drome - OOC LOS - Say Line'), +(28718, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ranid Glowergold - OOC LOS - Say Line'); + +DELETE FROM `creature_text` WHERE `entry` IN(29491,28994,28721,28725,33027,28727,28715,28714,28726,29523,28989,28997,28723,28718); + +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(29491, 0, 0, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Karandonna', 32811), +(29491, 0, 1, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Karandonna',32936), +(28994, 0, 0, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Abra Cadabra',32935), +(28994, 0, 1, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Abra Cadabra',32811), +(28994, 0, 2, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Abra Cadabra',32936), +(28994, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Abra Cadabra',32810), +(28721, 0, 0, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32809), +(28721, 0, 1, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32808), +(28721, 0, 2, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32935), +(28721, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32810), +(28721, 0, 4, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32936), +(28721, 0, 5, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32811), +(28725, 0, 0, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Patricia Egan',32811), +(28725, 0, 1, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Patricia Egan',32936), +(28725, 0, 2, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Patricia Egan',32809), +(28725, 0, 3, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Patricia Egan',32807), +(33027, 0, 0, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32810), +(33027, 0, 1, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32808), +(33027, 0, 2, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32811), +(33027, 0, 3, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32809), +(33027, 0, 4, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32936), +(28727, 0, 0, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Edward Egan',32807), +(28727, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Edward Egan',32935), +(28727, 0, 2, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Edward Egan',32811), +(28727, 0, 3, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Edward Egan', 32809), +(28715, 0, 0, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Endora Moorehead',32809), +(28715, 0, 1, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Endora Moorehead',32808), +(28715, 0, 2, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Endora Moorehead',32807), +(28714, 0, 0, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Ildine Sorrowspear',32936), +(28714, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Ildine Sorrowspear',32935), +(28714, 0, 2, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Ildine Sorrowspear',32810), +(28726, 0, 0, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32809), +(28726, 0, 1, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32807), +(28726, 0, 2, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32808), +(28726, 0, 3, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32811), +(28726, 0, 4, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32935), +(28726, 0, 5, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32810), +(29523, 0, 0, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Bragund Brightlink',32936), +(29523, 0, 1, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Bragund Brightlink',32807), +(29523, 0, 2, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Bragund Brightlink',32809), +(29523, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Bragund Brightlink',32810), +(28989, 0, 0, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Aemara',32809), +(28989, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Aemara',32935), +(28989, 0, 2, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Aemara',32811), +(28989, 0, 3, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Aemara',32808), +(28989, 0, 4, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Aemara',32810), +(28989, 0, 5, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Aemara',32936), +(28997, 0, 0, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Griselda Hunderland',32808), +(28997, 0, 1, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Griselda Hunderland',32810), +(28997, 0, 2, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Griselda Hunderland',32935), +(28997, 0, 3, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Griselda Hunderland',32807), +(28723, 0, 0, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Larana Drome',32808), +(28723, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Larana Drome',32935), +(28723, 0, 2, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Larana Drome',32936), +(28718, 0, 0, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32807), +(28718, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32935), +(28718, 0, 2, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32811), +(28718, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32810), +(28718, 0, 4, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32809), +(28718, 0, 5, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32808), +(28718, 0, 6, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32936); -- cgit v1.2.3 From ba6365fc7a53845026c508e875e24673c656da5b Mon Sep 17 00:00:00 2001 From: Dr-J Date: Tue, 19 Aug 2014 16:02:27 +0100 Subject: DB/Gameevent: Brew of the Year Adds vendors, events, sai for faction change, change of appearance depending on location (orgrimmar or iron forge), gossip and conditions * To Do * At start of each monthly event mail should be sent to players who are members with a sample of that months brew, this is not currently implemented. * Possibly missing yells from vendors saying beer but cannot confirm this. --- sql/updates/world/2014_08_19_01_world_event.sql | 231 ++++++++++++++++++++++++ 1 file changed, 231 insertions(+) create mode 100644 sql/updates/world/2014_08_19_01_world_event.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_08_19_01_world_event.sql b/sql/updates/world/2014_08_19_01_world_event.sql new file mode 100644 index 00000000000..7b3bdd86059 --- /dev/null +++ b/sql/updates/world/2014_08_19_01_world_event.sql @@ -0,0 +1,231 @@ +SET @EventEntry := 34; +SET @CGuid := 127312; + +-- Add game events to gameevent table (one per month so different brew vendor spawns each month which sells a different brew + +DELETE FROM `game_event` WHERE `eventEntry` BETWEEN @EventEntry AND @EventEntry+11; + +INSERT INTO `game_event` (`eventEntry`, `start_time`, `end_time`, `occurence`, `length`, `holiday`, `description`, `world_event`, `announce`) VALUES +(@EventEntry, '2012-10-01 00:01:00', '2020-12-31 06:00:00', 525600, 44640, 0, 'Brew of the Month October', 0, 2), +(@EventEntry+1, '2012-11-01 00:01:00', '2020-12-31 06:00:00', 525600, 43200, 0, 'Brew of the Month November', 0, 2), +(@EventEntry+2, '2012-12-01 00:01:00', '2020-12-31 06:00:00', 525600, 44640, 0, 'Brew of the Month December', 0, 2), +(@EventEntry+3, '2012-01-01 00:01:00', '2020-12-31 06:00:00', 525600, 44640, 0, 'Brew of the Month January', 0, 2), +(@EventEntry+4, '2012-02-01 00:01:00', '2020-12-31 06:00:00', 525600, 40320, 0, 'Brew of the Month February', 0, 2), +(@EventEntry+5, '2012-03-01 00:01:00', '2020-12-31 06:00:00', 525600, 44640, 0, 'Brew of the Month March', 0, 2), +(@EventEntry+6, '2012-04-01 00:01:00', '2020-12-31 06:00:00', 525600, 43200, 0, 'Brew of the Month April', 0, 2), +(@EventEntry+7, '2012-05-01 00:01:00', '2020-12-31 06:00:00', 525600, 44640, 0, 'Brew of the Month May', 0, 2), +(@EventEntry+8, '2012-06-01 00:01:00', '2020-12-31 06:00:00', 525600, 43200, 0, 'Brew of the Month June', 0, 2), +(@EventEntry+9, '2012-07-01 00:01:00', '2020-12-31 06:00:00', 525600, 44640, 0, 'Brew of the Month July', 0, 2), +(@EventEntry+10, '2012-08-01 00:01:00', '2020-12-31 06:00:00', 525600, 44640, 0, 'Brew of the Month August', 0, 2), +(@EventEntry+11, '2012-09-01 00:01:00', '2020-12-31 06:00:00', 525600, 44640, 0, 'Brew of the Month September', 0, 2); + +UPDATE `creature_template` SET `minlevel`=50, `maxlevel`=50, `npcflag`=129,`gossip_menu_id`=9549 WHERE `entry` IN(27806,27810,27811,27812,27813,27814,27815,27816,27817,27818,27819,27820); + +-- Add brewfest brews to vendors some of these are already in db but all are here just in case) + +DELETE FROM `npc_vendor` WHERE `entry` IN (27806,27810,27811,27812,27813,27814,27815,27816,27817,27818,27819,27820); + +INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES +(27806, 0, 37488, 0, 0, 0), -- Wild Winter Pilsner (January) +(27810, 0, 37899, 0, 0, 0), -- Izzard's Ever Flavor (February) +(27811, 0, 37490, 0, 0, 0), -- Aromatic Honey Brew (March) +(27812, 0, 37491, 0, 0, 0), -- Metok's Bubble Bock (April) +(27813, 0, 37492, 0, 0, 0), -- Springtime Stout (May) +(27814, 0, 37493, 0, 0, 0), -- Blackrock Lager (June) +(27815, 0, 37494, 0, 0, 0), -- Stranglethorn Brew (July) +(27816, 0, 37495, 0, 0, 0), -- Draenic Pale Ale (August) +(27817, 0, 37496, 0, 0, 0), -- Binary Brew (September) +(27818, 0, 37497, 0, 0, 0), -- Autumnal Acorn Ale (October) +(27819, 0, 37498, 0, 0, 0), -- Bartlett's Bitter Brew (November) +(27820, 0, 37499, 0, 0, 0); -- Lord of Frost's Private Label (December) + +-- Set buycount to 6 and make duration of these items so the duration is in realtime and not game time +UPDATE `item_template` SET `BuyCount`=6, `flagsCustom`=1 WHERE `entry` IN(37488,37899,37490,37491,37492,37493,37494,37495,37496,37497,37498,37499,37496); + +-- Link brew vendors to monthly events +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN @CGuid AND @CGuid+23; + +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(@EventEntry+3, @CGuid), +(@EventEntry+3, @CGuid+1), +(@EventEntry+4, @CGuid+2), +(@EventEntry+4, @CGuid+3), +(@EventEntry+5, @CGuid+4), +(@EventEntry+5, @CGuid+5), +(@EventEntry+6, @CGuid+6), +(@EventEntry+6, @CGuid+7), +(@EventEntry+7, @CGuid+8), +(@EventEntry+7, @CGuid+9), +(@EventEntry+8, @CGuid+10), +(@EventEntry+8, @CGuid+11), +(@EventEntry+9, @CGuid+12), +(@EventEntry+9, @CGuid+13), +(@EventEntry+10, @CGuid+14), +(@EventEntry+10, @CGuid+15), +(@EventEntry+11, @CGuid+16), +(@EventEntry+11, @CGuid+17), +(@EventEntry, @CGuid+18), +(@EventEntry, @CGuid+19), +(@EventEntry+1, @CGuid+20), +(@EventEntry+1, @CGuid+21), +(@EventEntry+2, @CGuid+22), +(@EventEntry+2, @CGuid+23); + + +-- Add some missing gossips and conditions for these which are needed so only players who completed brew of the month quest can access vendors +UPDATE `gossip_menu_option` SET `npc_option_npcflag`=128,`option_id`=3 WHERE `menu_id`=9554 AND `id`=0; + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=9548; + +INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES +(9548, 0, 0, 'What do you have for me?', 26695, 3, 128, 0, 0, 0, 0, '', 0); + + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=9549; + +INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES +(9549, 0, 1, 'I''d like to buy this month''s brew.', 26693, 3, 128, 0, 0, 0, 0, '', 0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`IN(9549,9548); + +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 9548, 0, 0, 0, 2, 0, 37829, 1, 0, 0, 0, 0, '', 'Only show gossip menu if player has at least 1 brewfest prize token'), + +(15, 9549, 0, 0, 0, 8, 0, 12421, 0, 0, 0, 0, 0, '', 'Only allow players who have completed brew of the month quest to access vendor'), +(15, 9549, 0, 0, 2, 8, 0, 12420, 0, 0, 0, 0, 0, '', 'Only allow players who have completed brew of the month quest to access vendor'); + +DELETE FROM `creature` WHERE `id` IN (27806,27810,27811,27812,27813,27814,27815,27816,27817,27818,27819,27820); + +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES +(@CGuid, 27806, 0, 1, 1, 24979, 1, -4845.949, -861.9443, 501.9972, 4.485496, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+1, 27806, 1, 1, 1, 24979, 1, 1475.8, -4210.233, 43.2693, 4.014257, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+2, 27810, 0, 1, 1, 24980, 1, -4845.949, -861.9443, 501.9972, 4.485496, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+3, 27810, 1, 1, 1, 24980, 1, 1475.8, -4210.233, 43.2693, 4.014257, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+4, 27811, 0, 1, 1, 24981, 1, -4845.949, -861.9443, 501.9972, 4.485496, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+5, 27811, 1, 1, 1, 24981, 1, 1475.8, -4210.233, 43.2693, 4.014257, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+6, 27812, 0, 1, 1, 24982, 1, -4845.949, -861.9443, 501.9972, 4.485496, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+7, 27812, 1, 1, 1, 24982, 1, 1475.8, -4210.233, 43.2693, 4.014257, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+8, 27813, 0, 1, 1, 24983, 1, -4845.949, -861.9443, 501.9972, 4.485496, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+9, 27813, 1, 1, 1, 24983, 1, 1475.8, -4210.233, 43.2693, 4.014257, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+10, 27814, 0, 1, 1, 24984, 1, -4845.949, -861.9443, 501.9972, 4.485496, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+11, 27814, 1, 1, 1, 24984, 1, 1475.8, -4210.233, 43.2693, 4.014257, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+12, 27815, 0, 1, 1, 24985, 1, -4845.949, -861.9443, 501.9972, 4.485496, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+13, 27815, 1, 1, 1, 24985, 1, 1475.8, -4210.233, 43.2693, 4.014257, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+14, 27816, 0, 1, 1, 24986, 1, -4845.949, -861.9443, 501.9972, 4.485496, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+15, 27816, 1, 1, 1, 24986, 1, 1475.8, -4210.233, 43.2693, 4.014257, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+16, 27817, 0, 1, 1, 24987, 1, -4845.949, -861.9443, 501.9972, 4.485496, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+17, 27817, 1, 1, 1, 24987, 1, 1475.8, -4210.233, 43.2693, 4.014257, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+18, 27818, 0, 1, 1, 24988, 1, -4845.949, -861.9443, 501.9972, 4.485496, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+19, 27818, 1, 1, 1, 24988, 1, 1475.8, -4210.233, 43.2693, 4.014257, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+20, 27819, 0, 1, 1, 24989, 1, -4845.949, -861.9443, 501.9972, 4.485496, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+21, 27819, 1, 1, 1, 24989, 1, 1475.8, -4210.233, 43.2693, 4.014257, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+22, 27820, 0, 1, 1, 24990, 1, -4845.949, -861.9443, 501.9972, 4.485496, 120, 0, 0, 2215, 0, 0, 0, 0, 0), +(@CGuid+23, 27820, 1, 1, 1, 24990, 1, 1475.8, -4210.233, 43.2693, 4.014257, 120, 0, 0, 2215, 0, 0, 0, 0, 0); + +-- Spawn Larkin Thunderbrew who is needed so alliance can turn quest to unlock vendors +DELETE FROM `creature` WHERE `guid`=@CGuid+24; + +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES +(@CGuid+24, 27478, 0, 1, 1, 22396, 0, -4849.41, -862.255, 501.997, 4.85202, 300, 0, 0, 2215, 0, 0, 0, 0, 0); + +-- Smart scripts to dynamically change faction on brew vendors depending on location +-- 774 = Alliance only alliance can access vendor, vendor still appears neutral to horde but wont allow interaction +-- 775 = Horde only horde can access vendor, vendor still appears neutral to alliance but wont allow interaction + + +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry` IN (27806,27810,27811,27812,27813,27814,27815,27816,27817,27818,27819,27820); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (27806,27810,27811,27812,27813,27814,27815,27816,27817,27818,27819,27820); +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(27806, 0, 0, 2, 11, 0, 100, 0, 0, 0, 0, 0, 2, 774 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Alliance)'), +(27806, 0, 1, 3, 11, 0, 100, 0, 0, 0, 0, 0, 2, 775 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Horde)'), +(27806, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49672 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Alliance'), +(27806, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49673 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Horde'), +(27810, 0, 0, 2, 11, 0, 100, 0, 0, 0, 0, 0, 2, 774 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Alliance)'), +(27810, 0, 1, 3, 11, 0, 100, 0, 0, 0, 0, 0, 2, 775 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Horde)'), +(27810, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49672 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Alliance'), +(27810, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49673 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Horde'), +(27811, 0, 0, 2, 11, 0, 100, 0, 0, 0, 0, 0, 2, 774 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Alliance)'), +(27811, 0, 1, 3, 11, 0, 100, 0, 0, 0, 0, 0, 2, 775 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Horde)'), +(27811, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49672 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Alliance'), +(27811, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49673 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Horde'), +(27812, 0, 0, 2, 11, 0, 100, 0, 0, 0, 0, 0, 2, 774 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Alliance)'), +(27812, 0, 1, 3, 11, 0, 100, 0, 0, 0, 0, 0, 2, 775 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Horde)'), +(27812, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49672 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Alliance'), +(27812, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49673 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Horde'), +(27813, 0, 0, 2, 11, 0, 100, 0, 0, 0, 0, 0, 2, 774 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Alliance)'), +(27813, 0, 1, 3, 11, 0, 100, 0, 0, 0, 0, 0, 2, 775 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Horde)'), +(27813, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49672 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Alliance'), +(27813, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49673 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Horde'), +(27814, 0, 0, 2, 11, 0, 100, 0, 0, 0, 0, 0, 2, 774 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Alliance)'), +(27814, 0, 1, 3, 11, 0, 100, 0, 0, 0, 0, 0, 2, 775 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Horde)'), +(27814, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49672 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Alliance'), +(27814, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49673 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Horde'), +(27815, 0, 0, 2, 11, 0, 100, 0, 0, 0, 0, 0, 2, 774 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Alliance)'), +(27815, 0, 1, 3, 11, 0, 100, 0, 0, 0, 0, 0, 2, 775 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Horde)'), +(27815, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49672 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Alliance'), +(27815, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49673 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Horde'), +(27816, 0, 0, 2, 11, 0, 100, 0, 0, 0, 0, 0, 2, 774 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Alliance)'), +(27816, 0, 1, 3, 11, 0, 100, 0, 0, 0, 0, 0, 2, 775 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Horde)'), +(27816, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49672 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Alliance'), +(27816, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49673 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Horde'), +(27817, 0, 0, 2, 11, 0, 100, 0, 0, 0, 0, 0, 2, 774 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Alliance)'), +(27817, 0, 1, 3, 11, 0, 100, 0, 0, 0, 0, 0, 2, 775 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Horde)'), +(27817, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49672 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Alliance'), +(27817, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49673 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Horde'), +(27818, 0, 0, 2, 11, 0, 100, 0, 0, 0, 0, 0, 2, 774 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Alliance)'), +(27818, 0, 1, 3, 11, 0, 100, 0, 0, 0, 0, 0, 2, 775 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Horde)'), +(27818, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49672 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Alliance'), +(27818, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49673 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Horde'), +(27819, 0, 0, 2, 11, 0, 100, 0, 0, 0, 0, 0, 2, 774 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Alliance)'), +(27819, 0, 1, 3, 11, 0, 100, 0, 0, 0, 0, 0, 2, 775 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Horde)'), +(27819, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49672 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Alliance'), +(27819, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49673 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Horde'), +(27820, 0, 0, 2, 11, 0, 100, 0, 0, 0, 0, 0, 2, 774 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Alliance)'), +(27820, 0, 1, 3, 11, 0, 100, 0, 0, 0, 0, 0, 2, 775 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Set Faction (Horde)'), +(27820, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49672 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Alliance'), +(27820, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 49673 , 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brew Vendor - On Spawn - Cast BOTM - Vendor - Transform - Horde'); + + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN (27806,27810,27811,27812,27813,27814,27815,27816,27817,27818,27819,27820); + +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(22,1,27806,0,0,23,1,1537,0,0,0,0,'','Only Run AI in Ironforge'), +(22,2,27806,0,0,23,1,1637,0,0,0,0,'','Only Run AI in Ogrimmar'), +(22,1,27810,0,0,23,1,1537,0,0,0,0,'','Only Run AI in Ironforge'), +(22,2,27810,0,0,23,1,1637,0,0,0,0,'','Only Run AI in Ogrimmar'), +(22,1,27811,0,0,23,1,1537,0,0,0,0,'','Only Run AI in Ironforge'), +(22,2,27811,0,0,23,1,1637,0,0,0,0,'','Only Run AI in Ogrimmar'), +(22,1,27812,0,0,23,1,1537,0,0,0,0,'','Only Run AI in Ironforge'), +(22,2,27812,0,0,23,1,1637,0,0,0,0,'','Only Run AI in Ogrimmar'), +(22,1,27813,0,0,23,1,1537,0,0,0,0,'','Only Run AI in Ironforge'), +(22,2,27813,0,0,23,1,1637,0,0,0,0,'','Only Run AI in Ogrimmar'), +(22,1,27814,0,0,23,1,1537,0,0,0,0,'','Only Run AI in Ironforge'), +(22,2,27814,0,0,23,1,1637,0,0,0,0,'','Only Run AI in Ogrimmar'), +(22,1,27815,0,0,23,1,1537,0,0,0,0,'','Only Run AI in Ironforge'), +(22,2,27815,0,0,23,1,1637,0,0,0,0,'','Only Run AI in Ogrimmar'), +(22,1,27816,0,0,23,1,1537,0,0,0,0,'','Only Run AI in Ironforge'), +(22,2,27816,0,0,23,1,1637,0,0,0,0,'','Only Run AI in Ogrimmar'), +(22,1,27817,0,0,23,1,1537,0,0,0,0,'','Only Run AI in Ironforge'), +(22,2,27817,0,0,23,1,1637,0,0,0,0,'','Only Run AI in Ogrimmar'), +(22,1,27818,0,0,23,1,1537,0,0,0,0,'','Only Run AI in Ironforge'), +(22,2,27818,0,0,23,1,1637,0,0,0,0,'','Only Run AI in Ogrimmar'), +(22,1,27819,0,0,23,1,1537,0,0,0,0,'','Only Run AI in Ironforge'), +(22,2,27819,0,0,23,1,1637,0,0,0,0,'','Only Run AI in Ogrimmar'), +(22,1,27820,0,0,23,1,1537,0,0,0,0,'','Only Run AI in Ironforge'), +(22,2,27820,0,0,23,1,1637,0,0,0,0,'','Only Run AI in Ogrimmar'); + +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN(42256,42255,42254,43961,42263,42257,43959,42264,42259,42260,42258,42261); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +(42256, 51655, 0, 'BOTM - Create Empty Brew Bottle'), +(42255, 51655, 0, 'BOTM - Create Empty Brew Bottle'), +(42254, 51655, 0, 'BOTM - Create Empty Brew Bottle'), +(43961, 51655, 0, 'BOTM - Create Empty Brew Bottle'), +(42263, 51655, 0, 'BOTM - Create Empty Brew Bottle'), +(42257, 51655, 0, 'BOTM - Create Empty Brew Bottle'), +(43959, 51655, 0, 'BOTM - Create Empty Brew Bottle'), +(42264, 51655, 0, 'BOTM - Create Empty Brew Bottle'), +(42259, 51655, 0, 'BOTM - Create Empty Brew Bottle'), +(42260, 51655, 0, 'BOTM - Create Empty Brew Bottle'), +(42258, 51655, 0, 'BOTM - Create Empty Brew Bottle'), +(42261, 51655, 0, 'BOTM - Create Empty Brew Bottle'); -- cgit v1.2.3 From 87b973c2806fa635648dde39bef2bd1c65d28c50 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Wed, 20 Aug 2014 03:24:53 +0100 Subject: DB/SAI: All is Well That Ends Well Script turn in event with Rhonin and Brann Bronzebeard for turn in of either version of all is well that ends well rhonin will respawn a few seconds after despawning after using the teleport visual due to script on Archmage Aethas Sunreaver to respawn him, on retail he is there right after he teleports but since in sai teleport does not work for npcs have had to use a work around to get to respawn otherwise been a faction leader takes a long time to respawn on tc. --- sql/updates/world/2014_08_20_00_world_sai.sql | 191 ++++++++++++++++++++++++++ 1 file changed, 191 insertions(+) create mode 100644 sql/updates/world/2014_08_20_00_world_sai.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_08_20_00_world_sai.sql b/sql/updates/world/2014_08_20_00_world_sai.sql new file mode 100644 index 00000000000..b1ff32d4b9b --- /dev/null +++ b/sql/updates/world/2014_08_20_00_world_sai.sql @@ -0,0 +1,191 @@ +SET @CGUID := 74528; + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID AND @CGUID+10; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID+0, 28332, 571, 1, 1, 5711.057, 645.7639, 672.0823, 0, 120, 0, 0), -- top +(@CGUID+1, 28332, 571, 1, 1, 5713.228, 646.6321, 653.1444, 0, 120, 0, 0), +(@CGUID+2, 28332, 571, 1, 1, 5713.016, 648.0272, 657.1592, 0, 120, 0, 0), +(@CGUID+3, 28332, 571, 1, 1, 5710.699, 648.6166, 656.5358, 0, 120, 0, 0), +(@CGUID+4, 28332, 571, 1, 1, 5711.029, 645.7101, 653.7773, 0, 120, 0, 0), +(@CGUID+5, 28332, 571, 1, 1, 5712.544, 644.6033, 656.4701, 0, 120, 0, 0), +(@CGUID+6, 28332, 571, 1, 1, 5709.351, 644.943, 655.8727, 0, 120, 0, 0), +(@CGUID+7, 28332, 571, 1, 1, 5711.693, 645.9358, 737.1865, 0, 120, 0, 0), +(@CGUID+8, 28332, 571, 1, 1, 5711.447, 646.1441, 761.046, 0, 120, 0, 0), +(@CGUID+9, 28332, 571, 1, 1, 5711.718, 645.9705, 796.1944, 0, 120, 0, 0), +(@CGUID+10, 28332, 571, 1, 1, 5711.647, 645.8472, 856.7622, 0, 120, 0, 0); + +UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` IN(34044,16128,28332,30116); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(34044,16128,28332,30116) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(-@CGUID-0,-@CGUID-1,-@CGUID-2,-@CGUID-3,-@CGUID-4,-@CGUID-5,-@CGUID-6,-@CGUID-7,-@CGUID-8,-@CGUID-9,-@CGUID-10) AND `source_type`=0; + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(1612800,1612801,1612802,2833200,3011600) AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(30116, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 80, 3011600, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Archmage Aethas Sunreaver - On Data Set - Run Script'), -- On retail Rhonin teleports back to original position since on tc teleport does not work for npcs this script is to respawn rhonin otherwise takes a long time to respawn. + +(16128, 0, 0, 5, 20, 0, 100, 0, 13631, 0, 0, 0, 80, 1612800, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - On Quest Reward (All Is Well That Ends Well) - Run Script'), +(16128, 0, 1, 5, 20, 0, 100, 0, 13819, 0, 0, 0, 80, 1612800, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - On Quest Reward (Heroic: All Is Well That Ends Well) - Run Script'), +(16128, 0, 2, 0, 38, 0, 100, 0, 1, 1, 0, 0, 80, 1612801, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - On Data Set 1 1 - Run Script 2'), +(16128, 0, 3, 0, 40, 0, 100, 0, 11, 16128, 0, 0, 80, 1612802, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - On Reached WP11 - Run Script 3'), +(16128, 0, 4, 5, 38, 0, 100, 0, 6, 6, 0, 0, 80, 1612800, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - On Quest Reward (All Is Well That Ends Well) - Run Script'), +(16128, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 30116, 0, 0, 0, 0, 0, 0, 'Rhonin - Link - Set Data to Archmage Aethas Sunreaver '), -- To trigger respawn script +(34044, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 53, 0, 34044, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brann Bronzebeard - On On Spawn - Start WP'), +(34044, 0, 1, 2, 40, 0, 100, 0, 11, 34044, 0, 0, 54, 4000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brann Bronzebeard - On Reached WP13 - Pause WP'), +(34044, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brann Bronzebeard - On Reached WP13 - Say Line 1'), +(34044, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 16128, 0, 0, 0, 0, 0, 0, 'Brann Bronzebeard - On Reached WP13 - Set Data On Rhonin'), +(34044, 0, 4, 0, 38, 0, 100, 0, 1, 1, 0, 0, 41, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Brann Bronzebeard - On Data Set - Despawn'), +(-@CGUID-1, 0, 0, 0, 38, 0, 100, 0, 32, 32, 0, 0, 11, 64367, 0, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Cast Algalon Event Beam'), +(-@CGUID-2, 0, 0, 0, 38, 0, 100, 0, 32, 32, 0, 0, 11, 64367, 0, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Cast Algalon Event Beam'), +(-@CGUID-3, 0, 0, 0, 38, 0, 100, 0, 32, 32, 0, 0, 11, 64367, 0, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Cast Algalon Event Beam'), +(-@CGUID-4, 0, 0, 0, 38, 0, 100, 0, 32, 32, 0, 0, 11, 64367, 0, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Cast Algalon Event Beam'), +(-@CGUID-5, 0, 0, 0, 38, 0, 100, 0, 32, 32, 0, 0, 11, 64367, 0, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Cast Algalon Event Beam'), +(-@CGUID-6, 0, 0, 0, 38, 0, 100, 0, 32, 32, 0, 0, 11, 64367, 0, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Cast Algalon Event Beam'), +(-@CGUID-0, 0, 0, 0, 38, 0, 100, 0, 30, 30, 0, 0, 11, 64580, 2, 0, 0, 0, 0, 10, @CGUID+7, 28332, 0, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Cast Reply-Code Alpha (Phase 2)'), +(-@CGUID-7, 0, 0, 0, 38, 0, 100, 0, 30, 30, 0, 0, 11, 64580, 2, 0, 0, 0, 0, 10, @CGUID+8, 28332, 0, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Cast Reply-Code Alpha (Phase 2)'), +(-@CGUID-8, 0, 0, 0, 38, 0, 100, 0, 30, 30, 0, 0, 11, 64580, 2, 0, 0, 0, 0, 10, @CGUID+9, 28332, 0, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Cast Reply-Code Alpha (Phase 2)'), +(-@CGUID-9, 0, 0, 0, 38, 0, 100, 0, 30, 30, 0, 0, 11, 64580, 2, 0, 0, 0, 0, 10, @CGUID+10, 28332, 0, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Cast Reply-Code Alpha (Phase 2)'), +(-@CGUID-10, 0, 0, 0, 38, 0, 100, 0, 29, 29, 0, 0, 11, 64581, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Cast Reply-Code Alpha (Phase 2)'), +(-@CGUID-10, 0, 1, 0, 38, 0, 100, 0, 31, 31, 0, 0, 11, 64510, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Cast Reply-Code Alpha (Phase 2)'), +(-@CGUID-0, 0, 1, 0, 38, 0, 100, 0, 28, 28, 0, 0, 80, 2833200, 2, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Run Script'), +(-@CGUID-1, 0, 1, 0, 38, 0, 100, 0, 28, 28, 0, 0, 80, 2833200, 2, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Run Script'), +(-@CGUID-2, 0, 1, 0, 38, 0, 100, 0, 28, 28, 0, 0, 80, 2833200, 2, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Run Script'), +(-@CGUID-3, 0, 1, 0, 38, 0, 100, 0, 28, 28, 0, 0, 80, 2833200, 2, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Run Script'), +(-@CGUID-4, 0, 1, 0, 38, 0, 100, 0, 28, 28, 0, 0, 80, 2833200, 2, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Run Script'), +(-@CGUID-5, 0, 1, 0, 38, 0, 100, 0, 28, 28, 0, 0, 80, 2833200, 2, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Run Script'), +(-@CGUID-6, 0, 1, 0, 38, 0, 100, 0, 28, 28, 0, 0, 80, 2833200, 2, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Run Script'), +(-@CGUID-7, 0, 1, 0, 38, 0, 100, 0, 28, 28, 0, 0, 80, 2833200, 2, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Run Script'), +(-@CGUID-8, 0, 1, 0, 38, 0, 100, 0, 28, 28, 0, 0, 80, 2833200, 2, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Run Script'), +(-@CGUID-9, 0, 1, 0, 38, 0, 100, 0, 28, 28, 0, 0, 80, 2833200, 2, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Run Script'), +(-@CGUID-10, 0, 2, 0, 38, 0, 100, 0, 28, 28, 0, 0, 80, 2833200, 2, 0, 0, 0, 0, 9, 28332, 20, 200, 0, 0, 0, 0, 'Generic Trigger LAB (Large AOI) - On Data Set - Run Script'), +(3011600, 9, 0, 0, 0, 0, 100, 0, 205000, 205000, 0, 0, 70, 0, 0, 0, 0, 0, 0, 10, 95366, 16128, 0, 0, 0, 0, 0, 'Archmage Aethas Sunreaver - Script - Respawn Rhonin'), +(2833200, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 28, 64367, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Generic Trigger LAB - Script - Remove aura'), +(2833200, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 28, 64510, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Generic Trigger LAB - Script - Remove aura'), +(2833200, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 28, 64580, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Generic Trigger LAB - Script - Remove aura'), +(1612800, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - Script - Set NPC Flags'), +(1612800, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 34044, 1, 300000, 0, 0, 0, 8, 0, 0, 0, 5800.296, 822.4527, 668.519, 4.812811, 'Rhonin - Script - Summon Brann Bronzebeard'), +(1612800, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - Script - Say Line 1'), +(1612801, 9, 0, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 53, 0, 16128, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - Script 2 - Start WP'), +(1612802, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 32, 32, 0, 0, 0, 0, 10, @CGUID+1, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 32, 32, 0, 0, 0, 0, 10, @CGUID+2, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 32, 32, 0, 0, 0, 0, 10, @CGUID+3, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 32, 32, 0, 0, 0, 0, 10, @CGUID+4, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 32, 32, 0, 0, 0, 0, 10, @CGUID+5, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 32, 32, 0, 0, 0, 0, 10, @CGUID+6, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 30, 30, 0, 0, 0, 0, 10, @CGUID+0, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 30, 30, 0, 0, 0, 0, 10, @CGUID+7, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 30, 30, 0, 0, 0, 0, 10, @CGUID+8, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 30, 30, 0, 0, 0, 0, 10, @CGUID+9, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 31, 31, 0, 0, 0, 0, 10, @CGUID+10, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Say Line 2'), +(1612802, 9, 12, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Say Line 3'), +(1612802, 9, 13, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Say Line 3'), +(1612802, 9, 14, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Say Line 3'), +(1612802, 9, 15, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Say Line 3'), +(1612802, 9, 16, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Say Line 3'), +(1612802, 9, 17, 0, 0, 0, 100, 0, 14000, 14000, 0, 0, 1, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Say Line 3'), +(1612802, 9, 18, 0, 0, 0, 100, 0, 60000, 60000, 0, 0, 45, 29, 29, 0, 0, 0, 0, 10, @CGUID+10, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 19, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 28, 28, 0, 0, 0, 0, 10, @CGUID+0, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 20, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 28, 28, 0, 0, 0, 0, 10, @CGUID+1, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 21, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 28, 28, 0, 0, 0, 0, 10, @CGUID+2, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 22, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 28, 28, 0, 0, 0, 0, 10, @CGUID+3, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 23, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 28, 28, 0, 0, 0, 0, 10, @CGUID+4, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 24, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 28, 28, 0, 0, 0, 0, 10, @CGUID+5, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 25, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 28, 28, 0, 0, 0, 0, 10, @CGUID+6, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 26, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 28, 28, 0, 0, 0, 0, 10, @CGUID+7, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 27, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 28, 28, 0, 0, 0, 0, 10, @CGUID+8, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 28, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 28, 28, 0, 0, 0, 0, 10, @CGUID+9, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 29, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 28, 28, 0, 0, 0, 0, 10, @CGUID+10, 28332, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Generic Trigger LAB (Large AOI)'), +(1612802, 9, 30, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 34044, 0, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Brann Bronzebeard'), +(1612802, 9, 31, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 11, 51347, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Set Data on Brann Bronzebeard'), +(1612802, 9, 32, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhonin - Script 3 - Despawn'); + + + +DELETE FROM `creature_text` WHERE `entry` IN(34044,16128); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(34044, 0, 0, 'Just in time. Let''s see this thing off, then.', 12, 0, 100, 0, 0, 15826, 'Brann Bronzebeard',34084), +(16128, 0, 0, 'We received Brann''s message, and we have begun preparations.', 12, 0, 100, 1, 0, 15649, 'Rhonin',33982), +(16128, 1, 0, 'Citizens of Dalaran! Raise your eyes to the skies and observe!', 14, 0, 100, 0, 0, 15650, 'Rhonin',33983), +(16128, 2, 0, 'Today our world''s destruction has been averted in defiance of our very makers!', 14, 0, 100, 0, 0, 15651, 'Rhonin',33984), +(16128, 3, 0, 'Algalon the Observer, herald of the titans, has been defeated by our brave comrades in the depths of the titan city of Ulduar.', 14, 0, 100, 0, 0, 15652, 'Rhonin',33985), +(16128, 4, 0, 'Algalon was sent here to judge the fate of our world.', 14, 0, 100, 0, 0, 15653, 'Rhonin',33986), +(16128, 5, 0, 'He found a planet whose races had deviated from the titans'' blueprints. A planet where not everything had gone according to plan.', 14, 0, 100, 0, 0, 15654, 'Rhonin',33987), +(16128, 6, 0, 'Cold logic deemed our world not worth saving. Cold logic, however, does not account for the power of free will. It''s up to each of us to prove this is a world worth saving.', 14, 0, 100, 0, 0, 15655, 'Rhonin',33988), +(16128, 7, 0, 'That our lives... our lives are worth living.', 14, 0, 100, 0, 0, 15656, 'Rhonin',33989); + +DELETE FROM `waypoints` WHERE `entry` IN(34044,16128); +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(34044,1, 5799.257, 822.8445, 668.8303,'Brann Bronzebeard'), +(34044,2, 5800.257, 822.8445, 668.8303,'Brann Bronzebeard'), +(34044,3, 5800.367, 821.7542, 667.9642,'Brann Bronzebeard'), +(34044,4, 5800.662, 818.8298, 666.119,'Brann Bronzebeard'), +(34044,5, 5801.204, 813.4578, 662.2362,'Brann Bronzebeard'), +(34044,6, 5801.204, 813.4578, 662.2362,'Brann Bronzebeard'), +(34044,7, 5801.473, 813.3398, 662.5571,'Brann Bronzebeard'), +(34044,8, 5801.478, 811.0238, 662.2334,'Brann Bronzebeard'), +(34044,9, 5801.978, 807.0238, 662.2334,'Brann Bronzebeard'), +(34044,10, 5801.978, 806.2738, 662.2334,'Brann Bronzebeard'), +(34044,11, 5800.728, 802.5238, 662.2334,'Brann Bronzebeard'), -- Say 1 +(34044,12, 5799.999, 799.77, 662.1868,'Brann Bronzebeard'), +(34044,13, 5798.749, 789.02, 662.1868,'Brann Bronzebeard'), +(34044,14, 5798.749, 787.77, 662.1868,'Brann Bronzebeard'), +(34044,15, 5798.499, 786.52, 662.1868,'Brann Bronzebeard'), +(34044,16, 5798.366, 786.4135, 662.1921,'Brann Bronzebeard'), +(34044,17, 5798.116, 784.4135, 662.1921,'Brann Bronzebeard'), +(34044,18, 5797.866, 783.6635, 662.6921,'Brann Bronzebeard'), +(34044,19, 5797.866, 779.4135, 662.6921,'Brann Bronzebeard'), +(34044,20, 5797.866, 775.6635, 661.9421,'Brann Bronzebeard'), +(34044,21, 5797.866, 774.6635, 661.6921,'Brann Bronzebeard'), +(34044,22, 5797.628, 774.3326, 661.3541,'Brann Bronzebeard'), +(34044,23, 5797.378, 772.5826, 661.3541,'Brann Bronzebeard'), +(34044,24, 5797.378, 772.0826, 661.3541,'Brann Bronzebeard'), +(34044,25, 5796.628, 766.8326, 661.6041,'Brann Bronzebeard'), +(34044,26, 5796.378, 761.8326, 658.3541,'Brann Bronzebeard'), +(34044,27, 5795.75, 756.938, 654.6126,'Brann Bronzebeard'), +(34044,28, 5795.75, 754.438, 652.8626,'Brann Bronzebeard'), +(34044,29, 5795.75, 745.438, 646.8626,'Brann Bronzebeard'), +(34044,30, 5795.75, 737.188, 640.8626,'Brann Bronzebeard'), +(34044,31, 5795.75, 736.188, 640.6126,'Brann Bronzebeard'), +(34044,32, 5795.629, 732.4694, 640.3873,'Brann Bronzebeard'), +(34044,33, 5795.379, 731.2194, 640.3873,'Brann Bronzebeard'), +(34044,34, 5794.879, 722.7194, 640.6373,'Brann Bronzebeard'), +(34044,35, 5794.379, 720.2194, 640.6373,'Brann Bronzebeard'), +(34044,36, 5794.141, 719.7362, 641.0156,'Brann Bronzebeard'), +(34044,37, 5794.141, 719.4862, 641.0156,'Brann Bronzebeard'), +(34044,38, 5793.391, 718.2362, 641.0156,'Brann Bronzebeard'), +(34044,39, 5792.141, 716.7362, 641.0156,'Brann Bronzebeard'), +(34044,40, 5788.391, 710.9862, 641.5156,'Brann Bronzebeard'), +(34044,41, 5784.409, 705.4751, 642.0784,'Brann Bronzebeard'), +(34044,42, 5780.409, 699.9751, 642.3284,'Brann Bronzebeard'), +(34044,43, 5778.909, 697.9751, 642.5784,'Brann Bronzebeard'), +(34044,44, 5778.659, 697.4751, 642.5784,'Brann Bronzebeard'), +(34044,45, 5773.409, 690.4751, 642.8284,'Brann Bronzebeard'), +(34044,46, 5772.659, 689.2251, 642.8284,'Brann Bronzebeard'), +(34044,47, 5772.451, 688.9385, 643.1041,'Brann Bronzebeard'), +(34044,48, 5769.951, 685.9385, 643.1041,'Brann Bronzebeard'), +(34044,49, 5767.951, 683.4385, 643.1041,'Brann Bronzebeard'), +(34044,50, 5761.951, 676.6885, 642.8541,'Brann Bronzebeard'), +(34044,51, 5758.701, 672.6885, 643.1041,'Brann Bronzebeard'), +(34044,52, 5757.701, 671.9385, 643.1041,'Brann Bronzebeard'), +(34044,53, 5756.951, 670.9385, 643.1041,'Brann Bronzebeard'), +(34044,54, 5755.701, 669.4385, 643.1041,'Brann Bronzebeard'), +(34044,55, 5754.951, 668.6885, 643.3541,'Brann Bronzebeard'), +(34044,56, 5750.951, 663.9385, 643.6041,'Brann Bronzebeard'), +(34044,57, 5750.721, 663.7521, 643.809,'Brann Bronzebeard'), +(34044,58, 5750.221, 663.2521, 643.809,'Brann Bronzebeard'), +(34044,59, 5745.221, 659.0021, 644.559,'Brann Bronzebeard'), +(34044,60, 5740.221, 654.7521, 645.559,'Brann Bronzebeard'), +(34044,61, 5740.14, 654.6359, 645.801,'Brann Bronzebeard'), +(34044,62, 5736.89, 651.8859, 646.051,'Brann Bronzebeard'), +(34044,63, 5734.89, 651.1359, 646.301,'Brann Bronzebeard'), +(34044,64, 5731.39, 649.8859, 646.801,'Brann Bronzebeard'), +(16128,1, 5797.603, 793.3063, 662.1119,'Rhonin'), +(16128,2, 5796.103, 777.5563, 662.3619,'Rhonin'), +(16128,3, 5794.603, 767.0563, 661.6119,'Rhonin'), +(16128,4, 5793.103, 753.0563, 651.8619,'Rhonin'), +(16128,5, 5790.603, 736.8063, 640.6119,'Rhonin'), +(16128,6, 5786.353, 717.5563, 641.1119,'Rhonin'), +(16128,7, 5773.603, 702.0563, 642.1119,'Rhonin'), +(16128,8, 5759.103, 683.5563, 642.6119,'Rhonin'), +(16128,9, 5746.853, 669.0563, 644.3619,'Rhonin'), +(16128,10, 5736.353, 658.8063, 645.8619,'Rhonin'), +(16128,11, 5727.353, 653.8063, 646.8619,'Rhonin'); -- cgit v1.2.3 From a49fce68dc39b1a0bc53a4ae27b756e8f85c62c3 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Wed, 20 Aug 2014 12:30:22 +0200 Subject: Rename 2014_08_19_01_world_misc.sql to 2014_08_19_02_world_misc.sql --- sql/updates/world/2014_08_19_01_world_misc.sql | 84 -------------------------- sql/updates/world/2014_08_19_02_world_misc.sql | 84 ++++++++++++++++++++++++++ 2 files changed, 84 insertions(+), 84 deletions(-) delete mode 100644 sql/updates/world/2014_08_19_01_world_misc.sql create mode 100644 sql/updates/world/2014_08_19_02_world_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_08_19_01_world_misc.sql b/sql/updates/world/2014_08_19_01_world_misc.sql deleted file mode 100644 index dd50c4ce027..00000000000 --- a/sql/updates/world/2014_08_19_01_world_misc.sql +++ /dev/null @@ -1,84 +0,0 @@ -UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`= '' WHERE `entry` IN(29491,28994,28721,28725,33027,28727,28715,28714,28726,29523,28989,28997,28723,28718); - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN(29491,28994,28721,28725,33027,28727,28715,28714,28726,29523,28989,28997,28723,28718) and `source_type`=0; - -INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES -(29491, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Karandonna - OOC LOS - Say Line'), -(28994, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Abra Cadabra - OOC LOS - Say Line'), -(28721, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Tiffany Cartier - OOC LOS - Say Line'), -(28727, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Edward Egan - OOC LOS - Say Line'), -(33027, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Jessica Sellers - OOC LOS - Say Line'), -(28725, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Patricia Egan - OOC LOS - Say Line'), -(28715, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Endora Moorehead - OOC LOS - Say Line'), -(28714, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ildine Sorrowspear - OOC LOS - Say Line'), -(28726, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Dominique Stefano - OOC LOS - Say Line'), -(29523, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Bragund Brightlink - OOC LOS - Say Line'), -(28989, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Aemara - OOC LOS - Say Line'), -(28997, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Griselda Hunderland - OOC LOS - Say Line'), -(28723, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Larana Drome - OOC LOS - Say Line'), -(28718, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ranid Glowergold - OOC LOS - Say Line'); - -DELETE FROM `creature_text` WHERE `entry` IN(29491,28994,28721,28725,33027,28727,28715,28714,28726,29523,28989,28997,28723,28718); - -INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES -(29491, 0, 0, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Karandonna', 32811), -(29491, 0, 1, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Karandonna',32936), -(28994, 0, 0, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Abra Cadabra',32935), -(28994, 0, 1, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Abra Cadabra',32811), -(28994, 0, 2, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Abra Cadabra',32936), -(28994, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Abra Cadabra',32810), -(28721, 0, 0, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32809), -(28721, 0, 1, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32808), -(28721, 0, 2, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32935), -(28721, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32810), -(28721, 0, 4, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32936), -(28721, 0, 5, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32811), -(28725, 0, 0, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Patricia Egan',32811), -(28725, 0, 1, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Patricia Egan',32936), -(28725, 0, 2, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Patricia Egan',32809), -(28725, 0, 3, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Patricia Egan',32807), -(33027, 0, 0, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32810), -(33027, 0, 1, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32808), -(33027, 0, 2, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32811), -(33027, 0, 3, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32809), -(33027, 0, 4, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32936), -(28727, 0, 0, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Edward Egan',32807), -(28727, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Edward Egan',32935), -(28727, 0, 2, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Edward Egan',32811), -(28727, 0, 3, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Edward Egan', 32809), -(28715, 0, 0, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Endora Moorehead',32809), -(28715, 0, 1, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Endora Moorehead',32808), -(28715, 0, 2, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Endora Moorehead',32807), -(28714, 0, 0, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Ildine Sorrowspear',32936), -(28714, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Ildine Sorrowspear',32935), -(28714, 0, 2, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Ildine Sorrowspear',32810), -(28726, 0, 0, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32809), -(28726, 0, 1, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32807), -(28726, 0, 2, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32808), -(28726, 0, 3, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32811), -(28726, 0, 4, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32935), -(28726, 0, 5, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32810), -(29523, 0, 0, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Bragund Brightlink',32936), -(29523, 0, 1, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Bragund Brightlink',32807), -(29523, 0, 2, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Bragund Brightlink',32809), -(29523, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Bragund Brightlink',32810), -(28989, 0, 0, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Aemara',32809), -(28989, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Aemara',32935), -(28989, 0, 2, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Aemara',32811), -(28989, 0, 3, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Aemara',32808), -(28989, 0, 4, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Aemara',32810), -(28989, 0, 5, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Aemara',32936), -(28997, 0, 0, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Griselda Hunderland',32808), -(28997, 0, 1, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Griselda Hunderland',32810), -(28997, 0, 2, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Griselda Hunderland',32935), -(28997, 0, 3, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Griselda Hunderland',32807), -(28723, 0, 0, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Larana Drome',32808), -(28723, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Larana Drome',32935), -(28723, 0, 2, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Larana Drome',32936), -(28718, 0, 0, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32807), -(28718, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32935), -(28718, 0, 2, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32811), -(28718, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32810), -(28718, 0, 4, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32809), -(28718, 0, 5, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32808), -(28718, 0, 6, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32936); diff --git a/sql/updates/world/2014_08_19_02_world_misc.sql b/sql/updates/world/2014_08_19_02_world_misc.sql new file mode 100644 index 00000000000..dd50c4ce027 --- /dev/null +++ b/sql/updates/world/2014_08_19_02_world_misc.sql @@ -0,0 +1,84 @@ +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`= '' WHERE `entry` IN(29491,28994,28721,28725,33027,28727,28715,28714,28726,29523,28989,28997,28723,28718); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(29491,28994,28721,28725,33027,28727,28715,28714,28726,29523,28989,28997,28723,28718) and `source_type`=0; + +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(29491, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Karandonna - OOC LOS - Say Line'), +(28994, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Abra Cadabra - OOC LOS - Say Line'), +(28721, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Tiffany Cartier - OOC LOS - Say Line'), +(28727, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Edward Egan - OOC LOS - Say Line'), +(33027, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Jessica Sellers - OOC LOS - Say Line'), +(28725, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Patricia Egan - OOC LOS - Say Line'), +(28715, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Endora Moorehead - OOC LOS - Say Line'), +(28714, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ildine Sorrowspear - OOC LOS - Say Line'), +(28726, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Dominique Stefano - OOC LOS - Say Line'), +(29523, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Bragund Brightlink - OOC LOS - Say Line'), +(28989, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Aemara - OOC LOS - Say Line'), +(28997, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Griselda Hunderland - OOC LOS - Say Line'), +(28723, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Larana Drome - OOC LOS - Say Line'), +(28718, 0, 0, 0, 10, 0, 100, 0, 1, 20, 30000, 120000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ranid Glowergold - OOC LOS - Say Line'); + +DELETE FROM `creature_text` WHERE `entry` IN(29491,28994,28721,28725,33027,28727,28715,28714,28726,29523,28989,28997,28723,28718); + +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(29491, 0, 0, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Karandonna', 32811), +(29491, 0, 1, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Karandonna',32936), +(28994, 0, 0, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Abra Cadabra',32935), +(28994, 0, 1, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Abra Cadabra',32811), +(28994, 0, 2, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Abra Cadabra',32936), +(28994, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Abra Cadabra',32810), +(28721, 0, 0, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32809), +(28721, 0, 1, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32808), +(28721, 0, 2, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32935), +(28721, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32810), +(28721, 0, 4, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32936), +(28721, 0, 5, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Tiffany Cartier',32811), +(28725, 0, 0, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Patricia Egan',32811), +(28725, 0, 1, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Patricia Egan',32936), +(28725, 0, 2, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Patricia Egan',32809), +(28725, 0, 3, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Patricia Egan',32807), +(33027, 0, 0, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32810), +(33027, 0, 1, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32808), +(33027, 0, 2, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32811), +(33027, 0, 3, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32809), +(33027, 0, 4, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Jessica Sellers',32936), +(28727, 0, 0, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Edward Egan',32807), +(28727, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Edward Egan',32935), +(28727, 0, 2, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Edward Egan',32811), +(28727, 0, 3, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Edward Egan', 32809), +(28715, 0, 0, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Endora Moorehead',32809), +(28715, 0, 1, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Endora Moorehead',32808), +(28715, 0, 2, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Endora Moorehead',32807), +(28714, 0, 0, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Ildine Sorrowspear',32936), +(28714, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Ildine Sorrowspear',32935), +(28714, 0, 2, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Ildine Sorrowspear',32810), +(28726, 0, 0, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32809), +(28726, 0, 1, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32807), +(28726, 0, 2, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32808), +(28726, 0, 3, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32811), +(28726, 0, 4, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32935), +(28726, 0, 5, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Dominique Stefano',32810), +(29523, 0, 0, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Bragund Brightlink',32936), +(29523, 0, 1, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Bragund Brightlink',32807), +(29523, 0, 2, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Bragund Brightlink',32809), +(29523, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Bragund Brightlink',32810), +(28989, 0, 0, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Aemara',32809), +(28989, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Aemara',32935), +(28989, 0, 2, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Aemara',32811), +(28989, 0, 3, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Aemara',32808), +(28989, 0, 4, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Aemara',32810), +(28989, 0, 5, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Aemara',32936), +(28997, 0, 0, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Griselda Hunderland',32808), +(28997, 0, 1, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Griselda Hunderland',32810), +(28997, 0, 2, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Griselda Hunderland',32935), +(28997, 0, 3, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Griselda Hunderland',32807), +(28723, 0, 0, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Larana Drome',32808), +(28723, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Larana Drome',32935), +(28723, 0, 2, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Larana Drome',32936), +(28718, 0, 0, 'Welcome!', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32807), +(28718, 0, 1, 'Greetings.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32935), +(28718, 0, 2, 'Welcome. May I help you find something?', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32811), +(28718, 0, 3, 'Let me know if you need help finding anything, $c.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32810), +(28718, 0, 4, 'Greetings! Please have a look around.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32809), +(28718, 0, 5, 'Greetings, $c.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32808), +(28718, 0, 6, 'Welcome.', 12, 0, 100, 3, 0, 0, 'Ranid Glowergold',32936); -- cgit v1.2.3 From f28a8f0df25822ad429910738ad1faf519492ad0 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 21 Aug 2014 15:16:06 +0200 Subject: DB/Conditions: Add gossip conditions to Highlord Darion Mograine Closes #12868 --- sql/updates/world/2014_08_21_00_world_conditions.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/2014_08_21_00_world_conditions.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_08_21_00_world_conditions.sql b/sql/updates/world/2014_08_21_00_world_conditions.sql new file mode 100644 index 00000000000..6a34d273f20 --- /dev/null +++ b/sql/updates/world/2014_08_21_00_world_conditions.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10027; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `Comment`) VALUES +(15, 10027, 15, 32, 'Show gossip option if player is a Death knight'); -- cgit v1.2.3 From c8e8d3396c4b48737a7aee25639d5da3e0d4884b Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 21 Aug 2014 15:44:00 +0200 Subject: DB/Warsong Gulch: Supreme Defender By horn, closes #3859 --- .../world/2014_08_21_01_world_achievement_criteria_data.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2014_08_21_01_world_achievement_criteria_data.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_08_21_01_world_achievement_criteria_data.sql b/sql/updates/world/2014_08_21_01_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..afa5fc6d1d4 --- /dev/null +++ b/sql/updates/world/2014_08_21_01_world_achievement_criteria_data.sql @@ -0,0 +1,7 @@ +-- Supreme Defender +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3698, 3699); +INSERT INTO `achievement_criteria_data` VALUES +(3698,6,3277,0,''), +(3698,7,23335,0,''), -- Alliance target should have Alliance Flag buff +(3699,6,3277,0,''), +(3699,7,23333,0,''); -- Horde target should have Horde Flag buff -- cgit v1.2.3 From 558f6e17b9f54d71e208aa090cf578b4c750a4af Mon Sep 17 00:00:00 2001 From: Dr-J Date: Thu, 21 Aug 2014 21:14:59 +0100 Subject: DB/Misc: Various Frenzyheart/Oracles Chain fixes * Rescripted Injured Rainspeaker oracle and both Just Following Orders and Fortunate Misunderstandings and works properly now ie when you find the injured rainspeaker oracle you find lying on ground, you select gossip option to pull injured rainspeaker oracle to his feet crocodile attacks, once crocodile is killed Shaman Vekjik turns up and says a few lines * New waypoints for a Rough Ride from sniff, the crocofile no longer goes through texture but camera is still glitchy * Mosswalker victims will now summon mosswalker pocessions if the event of them deciding to die while doing the mosswalker saviour * Correct text for softknuckle matrat for when summoned * Spawn Shaman Jakjek and Lightningcaller Soo-met and phasing for these, however phasing does not work exactly as should do as you should only be able to see these two npcs while you are working towards that faction but since quests stay rewarded even after you change faction there is no way of doing this using quest and spell area is limited, there are two faction choice tracker quests (hidden) for wolvar and gorloc and spells which add this quests to player but also once these are rewarded they stay rewarded. --- sql/updates/world/2014_08_21_02_world_misc.sql | 481 +++++++++++++++++++++++++ 1 file changed, 481 insertions(+) create mode 100644 sql/updates/world/2014_08_21_02_world_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_08_21_02_world_misc.sql b/sql/updates/world/2014_08_21_02_world_misc.sql new file mode 100644 index 00000000000..041c9820b04 --- /dev/null +++ b/sql/updates/world/2014_08_21_02_world_misc.sql @@ -0,0 +1,481 @@ +SET @CGuid := 29974; + +-- These two gossip menus on Injured rainspeaker oracle are not meant to be linked, they are two +-- seperate gossips the first one for Just Following Orders to help the injured rainspeaker oracle and start event +-- The second is to start the event for fortunate misunderstandings + +UPDATE `gossip_menu_option` SET `action_menu_id`=0 WHERE `menu_id`=9677 AND `id`=0; + +-- Delete Ravenous Mangal Crocolisk as this is not meant to be spawned, it is summoned from spell +DELETE FROM `creature` WHERE `guid`=111427; + +-- Spawn Shaman Jakjek and Lightningcaller Soo-met +DELETE FROM `creature` WHERE `id` IN(28106,28107); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID+0, 28106, 571, 1, 1, 4869.281, 5912.271, -40.38539, 5.166174, 120, 0, 0), -- 28106 (Area: 3711) +(@CGUID+1, 28107, 571, 1, 1, 5116.647, 5469.729, -91.70967, 1.605703, 120, 0, 0); -- 28107 (Area: 3711) + +DELETE FROM `creature_template_addon` WHERE `entry` IN(28106,28107); +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(28106, 0, 0x10000, 0x1, '52215'), -- 28106 - 52215 +(28107, 0, 0x10000, 0x1, '52215'); -- 28107 - 52215 + +DELETE FROM `gossip_menu` WHERE `entry` IN(9744,9745); +INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES +(9745, 13364), -- 28106 +(9744, 13363); -- 28107 + +-- The below spell area for phasing is not working correctly as these npcs should only be visible after a player has killed artruis and is working towards that faction +-- If a player swaps faction they are meant to no longer be able to see the npc for that faction +-- Currenly with below npc becomes visible once player unlocks dailies for that faction but will remain +-- visible even if player switches faction as there is no way of telling which faction player is working towards +-- as all quests remain completed, there a couple of hidden faction choice tracker quests too but even this stay rewarded +-- once spell is cast which adds hidden quest, other way would be by reputation but this is not possible with spell area either +-- My guess is a wolvar faction choice tracker and gorlok faction choice tracker quest and spells to engage these, cant find how these +-- would reset though + +DELETE FROM `spell_area` WHERE `spell`=52217 AND `area` IN(4287,4288); +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(52217,4287, 12692, 0, 0, 0, 2, 1, 64, 11), +(52217,4288, 12695, 0, 0, 0, 2, 1, 64, 11); + +UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` IN(28217,28325,28327); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(28217,28325,28327) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(28077) AND `source_type`=0 and `id`>14; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(28133) AND `source_type`=0 and `id`=4; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(2811301) AND `source_type`=9 and `id`>0; +UPDATE `smart_scripts` SET `event_param1`=290 WHERE `entryorguid`=28308 AND `source_type`=0 AND `id`=2 AND `link`=3; + + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(2821700,2821701,2832700) AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(28217, 0, 0, 1, 11, 0, 100, 0, 0, 0, 0, 0, 11, 51329, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Spawn - Cast Feign Death'), +(28217, 0, 1, 14, 61, 0, 100, 0, 0, 0, 0, 0, 81, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Spawn - Set NPC Flags (Gossip Only)'), +(28217, 0, 2, 3, 62, 0, 100, 0, 9677, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Gossip Option Select - Say Line 1'), +(28217, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 28, 51329, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Gossip Option Select - Remove Aura - Feign Death'), +(28217, 0, 4, 5, 61, 0, 100, 0, 0, 0, 0, 0, 81, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Gossip Option Select - Remove Aura - Set NPC Flags - Quest + Gossip'), +(28217, 0, 5, 15, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Gossip Option Select - Close Gossip'), +(28217, 0, 6, 0, 62, 0, 100, 0, 9677, 0, 0, 0, 85, 51382, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Gossip Option Select - Invoker Cast Forcecast Summon Huge Crocolisk'), +(28217, 0, 7, 0, 64, 0, 100, 0, 0, 0, 0, 0, 98, 9684, 13124, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Gossip Hello - Send Gossip Menu'), +(28217, 0, 8, 10, 62, 0, 100, 0, 9684, 0, 0, 0, 2, 774, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Gossip Option Select - Set Faction (Alliance)'), +(28217, 0, 9, 10, 62, 0, 100, 0, 9684, 0, 0, 0, 2, 775, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Gossip Option Select - Set Faction (Horde)'), +(28217, 0, 10, 11, 61, 0, 100, 0, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Gossip Option Select - Store Targetlist'), +(28217, 0, 11, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, 2821700, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Gossip Option Select - Run Script'), +(28217, 0, 12, 0, 19, 0, 100, 0, 12570, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On On Quest Accept - Fortunate Misunderstandings - Say Line 2'), +(28217, 0, 13, 0, 40, 0, 100, 0, 64, 28217, 0, 0, 80, 2821701, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Reached WP80 - Run Script'), +(28217, 0, 14, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 58806, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Spawn - Add Aura Permanent Feign Death'), +(28217, 0, 15, 0, 61, 0, 100, 0, 0, 0, 0, 0, 28, 58806, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - On Gossip Select - Remove Aura Permanent Feign Death'), +(28077, 0, 15, 16, 54, 0, 100, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 21, 50, 0, 0, 0, 0, 0, 0, 'Frenzyheart Tracker - On Just Summoned - Set Orientation'), +(28077, 0, 16, 17, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Frenzyheart Tracker - On Just Summoned - Say Line 1'), +(28077, 0, 17, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 8000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Frenzyheart Tracker - On Just Summoned - Despawn After 8 seconds'), +(28325, 0, 0, 0, 0, 0, 100, 0, 5000, 9000, 9000, 14000, 11, 34370, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Ravenous Mangal Crocolisk - In Combat - Cast Jagged Tooth Snap'), +(28325, 0, 1, 2, 54, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravenous Mangal Crocolisk - On Just Summoned - Say Line 1'), +(28325, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 50, 0, 0, 0, 0, 0, 0, 'Ravenous Mangal Crocolisk - On Just Summoned - Attack'), +(28325, 0, 3, 0, 6, 0, 100, 0, 0, 0, 0, 0, 11, 51321, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravenous Mangal Crocolisk - On Death - Cast Summon Shaman Vekjik'), +(28327, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Shaman Vekjik - On Just Summoned - Say Line 1'), +(28327, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 69, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Shaman Vekjik - On Just Summoned - Move to Position'), +(28327, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, 2832700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Shaman Vekjik - On Just Summoned - Run Script'), +(28113, 0, 4, 0, 64, 0, 100, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mosswalker Victim - On Gossip Hello - Say Line 3'), +(2821700, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - Script - Set NPC Flags'), +(2821700, 9, 1, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - Script - Say Line 3'), +(2821700, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 53, 1, 28217, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - Script - Start WP'), +(2821701, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - Script 2 - Say Line 4'), +(2821701, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 51448, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - Script 2 - Cast Oracle Intro Quest Complete'), +(2821701, 9, 2, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - Script 2 - Say Line 5'), +(2821701, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 52100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - Script 2 - Cast Summon Frenyheart Tracker'), +(2821701, 9, 4, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Rainspeaker Oracle - Script 2 - Despawn'), +(2811301, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 52156, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Mosswalker Victim - On Script - Cast Summon Shinies'), +(2811301, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 37, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mosswalker Victim - On Script - Kill Self'), +(2832700, 9, 0, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Shaman Vekjik - Script - Say Line 2'), +(2832700, 9, 1, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Shaman Vekjik - Script - Say Line 3'), +(2832700, 9, 2, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Shaman Vekjik - Script - Say Line 4'), +(2832700, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Shaman Vekjik - Script - Set Run On'), +(2832700, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 46, 50, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Shaman Vekjik - Script - Move Foward'), +(2832700, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Shaman Vekjik - Script - Despawn After 5 seconds'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9677; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=28217; + +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 9677, 0, 0, 0, 1, 1, 51329, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle only display gossip if injured rainspeaker oracle has aura Feign Death'), +(22, 7, 28217, 0, 0, 9, 0, 12540, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle - Only run SAI if player has Just Following Orders taken'), +(22, 8, 28217, 0, 0, 9, 0, 12570, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle - Only run SAI if player has Fortunate Misunderstandings Taken'), +(22, 9, 28217, 0, 0, 16, 0, 1101, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle - Only run SAI if player is Alliance'), +(22, 10, 28217, 0, 0, 16, 0, 690, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle - Only run SAI if player is Horde'); + +DELETE FROM `creature_text` WHERE `entry` IN(28217,28325,28327,28077,28213); +DELETE FROM `creature_text` WHERE `entry` IN(28113) AND `groupid`=3; + +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(28217, 0, 0, 'The Injured Rainspeaker Oracle rises clumsily to its feet.', 16, 0, 100, 0, 0, 0, 'Injured Rainspeaker Oracle',27785), +(28217, 1, 0, 'You tell us when it home time.', 12, 0, 100, 0, 0, 0, 'Injured Rainspeaker Oracle',27826), +(28217, 2, 0, 'Home not far. Come!', 12, 0, 100, 0, 0, 0, 'Injured Rainspeaker Oracle',27753), +(28217, 3, 0, 'Thanks!', 12, 0, 100, 0, 0, 0, 'Injured Rainspeaker Oracle',27752), +(28217, 4, 0, 'Oh no! Some puppy-men followed!', 12, 0, 100, 0, 0, 0, 'Injured Rainspeaker Oracle',27799), +(28325, 0, 0, 'You hear a low guttural growl from nearby.', 16, 0, 100, 0, 0, 0, 'Ravenous Mangal Crocolisk',27831), +(28327, 0, 0, 'Shaman Vekjik comes out of the underbrush nearby.', 16, 0, 100, 0, 0, 0, 'Shaman Vekjik',27738), +(28327, 1, 0, 'You help Rainspeaker! I saw you help Rainspeaker! Traitor thing!', 12, 0, 100, 0, 0, 0, 'Shaman Vekjik',27739), +(28327, 2, 0, 'If you want to be friends with big-tongues, you not friends with Frenzyheart! I tell village! We no trust you anymore!', 12, 0, 100, 0, 0, 0, 'Shaman Vekjik',27740), +(28327, 3, 0, 'Shaman Vekjik scurries off towards Frenzyheart Hill.', 16, 0, 100, 0, 0, 0, 'Shaman Vekjik',27741), +(28077, 0, 0, 'Dumb big-tongue lover! You not friend of Frenzyheart no more. Frenzyheart will get you good.', 14, 0, 100, 0, 0, 0, 'Frenzyheart Tracker',27798), +(28213, 0, 0, 'The %s screams with rage and rushes to the aid of her babies.', 16, 0, 100, 0, 0, 0, 'Hardknuckle Matriarch',27607), +(28113, 3, 0, 'The mosswalker victim groans in pain.', 16, 0, 100, 0, 0, 0, 'Mosswalker Victim',28638); + +DELETE FROM `waypoints` WHERE `entry` IN(28217,28308); +DELETE FROM `script_waypoint` WHERE `entry` IN(28217); + +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(28217, 1,5462.371, 4514.91, -133.6022, 'Injured Rainspeaker Oracle'), +(28217, 2,5483.05, 4514.717, -141.1091, 'Injured Rainspeaker Oracle'), +(28217, 3,5485.3, 4516.467, -142.1091, 'Injured Rainspeaker Oracle'), +(28217, 4,5485.8, 4516.967, -143.3591, 'Injured Rainspeaker Oracle'), +(28217, 5,5486.8, 4517.717, -145.3591, 'Injured Rainspeaker Oracle'), +(28217, 6,5494.231, 4523.077, -149.136, 'Injured Rainspeaker Oracle'), +(28217, 7,5497.242, 4543.376, -146.9484, 'Injured Rainspeaker Oracle'), +(28217, 8,5499.492, 4544.876, -145.6984, 'Injured Rainspeaker Oracle'), +(28217, 9,5500.992, 4546.376, -145.1984, 'Injured Rainspeaker Oracle'), +(28217, 10,5502.492, 4547.626, -144.6984, 'Injured Rainspeaker Oracle'), +(28217, 11,5504.492, 4549.626, -143.9484, 'Injured Rainspeaker Oracle'), +(28217, 12,5507.492, 4552.126, -142.9484, 'Injured Rainspeaker Oracle'), +(28217, 13,5507.9, 4552.293, -142.7217, 'Injured Rainspeaker Oracle'), +(28217, 14,5509.15, 4553.793, -142.2217, 'Injured Rainspeaker Oracle'), +(28217, 15,5509.4, 4555.793, -141.7217, 'Injured Rainspeaker Oracle'), +(28217, 16,5509.4, 4558.793, -140.2217, 'Injured Rainspeaker Oracle'), +(28217, 17,5509.65, 4560.793, -139.4717, 'Injured Rainspeaker Oracle'), +(28217, 18,5509.9, 4563.543, -138.9717, 'Injured Rainspeaker Oracle'), +(28217, 19,5509.9, 4566.543, -137.9717, 'Injured Rainspeaker Oracle'), +(28217, 20,5510.15, 4568.543, -136.9717, 'Injured Rainspeaker Oracle'), +(28217, 21,5510.44, 4568.722, -136.8404, 'Injured Rainspeaker Oracle'), +(28217, 22,5510.44, 4571.722, -135.5904, 'Injured Rainspeaker Oracle'), +(28217, 23,5510.69, 4572.722, -135.3404, 'Injured Rainspeaker Oracle'), +(28217, 24,5510.69, 4575.722, -135.8404, 'Injured Rainspeaker Oracle'), +(28217, 25,5511.19, 4586.472, -135.0904, 'Injured Rainspeaker Oracle'), +(28217, 26,5511.44, 4589.472, -134.5904, 'Injured Rainspeaker Oracle'), +(28217, 27,5511.69, 4591.472, -133.8404, 'Injured Rainspeaker Oracle'), +(28217, 28,5511.69, 4593.472, -133.3404, 'Injured Rainspeaker Oracle'), +(28217, 29,5511.94, 4595.222, -132.5904, 'Injured Rainspeaker Oracle'), +(28217, 30,5512.074, 4593.584, -133.326, 'Injured Rainspeaker Oracle'), +(28217, 31,5512.074, 4595.584, -132.576, 'Injured Rainspeaker Oracle'), +(28217, 32,5512.324, 4597.584, -132.326, 'Injured Rainspeaker Oracle'), +(28217, 33,5513.824, 4600.334, -131.826, 'Injured Rainspeaker Oracle'), +(28217, 34,5514.824, 4601.834, -132.826, 'Injured Rainspeaker Oracle'), +(28217, 35,5515.324, 4602.834, -133.326, 'Injured Rainspeaker Oracle'), +(28217, 36,5518.074, 4607.084, -132.076, 'Injured Rainspeaker Oracle'), +(28217, 37,5520.074, 4610.334, -133.076, 'Injured Rainspeaker Oracle'), +(28217, 38,5520.324, 4611.084, -133.826, 'Injured Rainspeaker Oracle'), +(28217, 39,5520.824, 4611.834, -134.576, 'Injured Rainspeaker Oracle'), +(28217, 40,5521.324, 4612.834, -135.326, 'Injured Rainspeaker Oracle'), +(28217, 41,5521.824, 4613.584, -135.576, 'Injured Rainspeaker Oracle'), +(28217, 42,5524.574, 4617.834, -136.576, 'Injured Rainspeaker Oracle'), +(28217, 43,5528.879, 4624.343, -136.8704, 'Injured Rainspeaker Oracle'), +(28217, 44,5532.879, 4624.343, -137.1204, 'Injured Rainspeaker Oracle'), +(28217, 45,5550.51, 4624.694, -136.8637, 'Injured Rainspeaker Oracle'), +(28217, 46,5552.26, 4625.444, -137.3637, 'Injured Rainspeaker Oracle'), +(28217, 47,5565.26, 4629.944, -136.8637, 'Injured Rainspeaker Oracle'), +(28217, 48,5568.01, 4630.944, -136.3637, 'Injured Rainspeaker Oracle'), +(28217, 49,5571.01, 4631.944, -135.1137, 'Injured Rainspeaker Oracle'), +(28217, 50,5574.76, 4633.194, -134.3637, 'Injured Rainspeaker Oracle'), +(28217, 51,5577.51, 4634.194, -135.1137, 'Injured Rainspeaker Oracle'), +(28217, 52,5577.733, 4634.199, -135.0235, 'Injured Rainspeaker Oracle'), +(28217, 53,5580.983, 4635.449, -135.7735, 'Injured Rainspeaker Oracle'), +(28217, 54,5584.983, 4634.949, -136.0235, 'Injured Rainspeaker Oracle'), +(28217, 55,5587.983, 4634.449, -136.7735, 'Injured Rainspeaker Oracle'), +(28217, 56,5589.733, 4634.199, -138.0235, 'Injured Rainspeaker Oracle'), +(28217, 57,5594.733, 4633.699, -138.2735, 'Injured Rainspeaker Oracle'), +(28217, 58,5596.733, 4633.449, -137.5235, 'Injured Rainspeaker Oracle'), +(28217, 59,5599.733, 4633.199, -136.7735, 'Injured Rainspeaker Oracle'), +(28217, 60,5606.606, 4632.268, -136.4532, 'Injured Rainspeaker Oracle'), +(28217, 61,5612.106, 4626.518, -137.2032, 'Injured Rainspeaker Oracle'), +(28217, 62,5616.856, 4621.768, -137.7032, 'Injured Rainspeaker Oracle'), +(28217, 63,5620.638, 4618.1, -137.5758, 'Injured Rainspeaker Oracle'), +(28217, 64,5625.388, 4612.85, -137.0758, 'Injured Rainspeaker Oracle'), +(28308,1, 5295.424, 4436.538, -97.6029,'Captive Crocolisk'), +(28308,2, 5291.674, 4435.038, -97.1029,'Captive Crocolisk'), +(28308,3, 5287.924, 4433.538, -96.3529,'Captive Crocolisk'), +(28308,4, 5277.924, 4429.538, -95.8529,'Captive Crocolisk'), +(28308,5, 5277.777, 4429.427, -95.94301,'Captive Crocolisk'), +(28308,6, 5268.277, 4425.427, -95.44301,'Captive Crocolisk'), +(28308,7, 5249.84, 4405.99, -95.93161,'Captive Crocolisk'), +(28308,8, 5251.84, 4401.24, -95.18161,'Captive Crocolisk'), +(28308,9, 5262.34, 4376.74, -95.68161,'Captive Crocolisk'), +(28308,10, 5263.34, 4373.99, -96.43161,'Captive Crocolisk'), +(28308,11, 5264.34, 4371.99, -96.93161,'Captive Crocolisk'), +(28308,12, 5265.34, 4369.24, -97.68161,'Captive Crocolisk'), +(28308,13, 5262.209, 4376.323, -95.75699,'Captive Crocolisk'), +(28308,14, 5263.459, 4373.823, -96.50699,'Captive Crocolisk'), +(28308,15, 5264.209, 4372.073, -97.25699,'Captive Crocolisk'), +(28308,16, 5265.459, 4369.323, -98.00699,'Captive Crocolisk'), +(28308,17, 5266.959, 4365.823, -98.00699,'Captive Crocolisk'), +(28308,18, 5272.959, 4366.073, -99.00699,'Captive Crocolisk'), +(28308,19, 5274.709, 4366.073, -99.50699,'Captive Crocolisk'), +(28308,20, 5277.709, 4366.323, -100.257,'Captive Crocolisk'), +(28308,21, 5284.709, 4366.573, -101.007,'Captive Crocolisk'), +(28308,22, 5288.709, 4366.823, -101.757,'Captive Crocolisk'), +(28308,23, 5284.895, 4366.406, -101.2539,'Captive Crocolisk'), +(28308,24, 5288.895, 4366.656, -102.0039,'Captive Crocolisk'), +(28308,25, 5289.395, 4366.656, -102.0039,'Captive Crocolisk'), +(28308,26, 5291.395, 4366.406, -103.0039,'Captive Crocolisk'), +(28308,27, 5293.395, 4366.156, -104.2539,'Captive Crocolisk'), +(28308,28, 5294.395, 4366.156, -105.0039,'Captive Crocolisk'), +(28308,29, 5295.395, 4366.156, -106.0039,'Captive Crocolisk'), +(28308,30, 5296.395, 4365.906, -106.5039,'Captive Crocolisk'), +(28308,31, 5297.395, 4365.906, -107.2539,'Captive Crocolisk'), +(28308,32, 5298.395, 4365.906, -108.0039,'Captive Crocolisk'), +(28308,33, 5299.145, 4365.656, -108.7539,'Captive Crocolisk'), +(28308,34, 5300.145, 4365.656, -109.5039,'Captive Crocolisk'), +(28308,35, 5302.145, 4365.406, -110.0039,'Captive Crocolisk'), +(28308,36, 5304.145, 4365.406, -110.5039,'Captive Crocolisk'), +(28308,37, 5305.145, 4365.156, -111.2539,'Captive Crocolisk'), +(28308,38, 5306.145, 4365.156, -112.0039,'Captive Crocolisk'), +(28308,39, 5307.145, 4365.156, -112.5039,'Captive Crocolisk'), +(28308,40, 5308.145, 4365.156, -113.2539,'Captive Crocolisk'), +(28308,41, 5309.145, 4364.906, -114.0039,'Captive Crocolisk'), +(28308,42, 5311.145, 4364.906, -115.0039,'Captive Crocolisk'), +(28308,43, 5313.145, 4364.656, -116.0039,'Captive Crocolisk'), +(28308,44, 5316.145, 4364.406, -116.7539,'Captive Crocolisk'), +(28308,45, 5318.145, 4364.406, -117.5039,'Captive Crocolisk'), +(28308,46, 5320.145, 4364.406, -118.2539,'Captive Crocolisk'), +(28308,47, 5322.145, 4364.156, -119.0039,'Captive Crocolisk'), +(28308,48, 5325.145, 4363.906, -120.0039,'Captive Crocolisk'), +(28308,49, 5325.253, 4363.768, -120.1149,'Captive Crocolisk'), +(28308,50, 5330.003, 4363.268, -120.8649,'Captive Crocolisk'), +(28308,51, 5334.503, 4358.018, -121.6149,'Captive Crocolisk'), +(28308,52, 5336.503, 4355.768, -122.3649,'Captive Crocolisk'), +(28308,53, 5339.253, 4353.018, -123.3649,'Captive Crocolisk'), +(28308,54, 5341.253, 4350.768, -124.3649,'Captive Crocolisk'), +(28308,55, 5343.003, 4348.518, -126.1149,'Captive Crocolisk'), +(28308,56, 5345.003, 4346.018, -128.1149,'Captive Crocolisk'), +(28308,57, 5346.253, 4344.518, -129.6149,'Captive Crocolisk'), +(28308,58, 5347.003, 4343.768, -130.8649,'Captive Crocolisk'), +(28308,59, 5348.253, 4342.268, -132.3649,'Captive Crocolisk'), +(28308,60, 5349.003, 4341.518, -133.8649,'Captive Crocolisk'), +(28308,61, 5350.473, 4340.604, -135.0103,'Captive Crocolisk'), +(28308,62, 5351.223, 4340.104, -136.2603,'Captive Crocolisk'), +(28308,63, 5353.223, 4339.604, -137.2603,'Captive Crocolisk'), +(28308,64, 5354.973, 4338.854, -138.2603,'Captive Crocolisk'), +(28308,65, 5357.473, 4337.604, -139.0103,'Captive Crocolisk'), +(28308,66, 5359.223, 4336.604, -139.5103,'Captive Crocolisk'), +(28308,67, 5361.973, 4335.354, -140.5103,'Captive Crocolisk'), +(28308,68, 5363.723, 4334.604, -141.0103,'Captive Crocolisk'), +(28308,69, 5364.094, 4334.348, -141.0889,'Captive Crocolisk'), +(28308,70, 5365.344, 4333.598, -141.0889,'Captive Crocolisk'), +(28308,71, 5369.594, 4331.098, -142.5889,'Captive Crocolisk'), +(28308,72, 5372.844, 4328.848, -143.5889,'Captive Crocolisk'), +(28308,73, 5376.344, 4326.598, -144.5889,'Captive Crocolisk'), +(28308,74, 5379.344, 4324.598, -145.3389,'Captive Crocolisk'), +(28308,75, 5382.594, 4322.598, -146.0889,'Captive Crocolisk'), +(28308,76, 5402.844, 4309.598, -144.5889,'Captive Crocolisk'), +(28308,77, 5403.844, 4309.098, -143.3389,'Captive Crocolisk'), +(28308,78, 5403.236, 4309.773, -144.7202,'Captive Crocolisk'), +(28308,79, 5403.986, 4309.273, -143.2202,'Captive Crocolisk'), +(28308,80, 5405.736, 4308.023, -141.7202,'Captive Crocolisk'), +(28308,81, 5407.736, 4308.023, -141.2202,'Captive Crocolisk'), +(28308,82, 5409.736, 4307.773, -140.4702,'Captive Crocolisk'), +(28308,83, 5412.486, 4307.523, -139.7202,'Captive Crocolisk'), +(28308,84, 5416.486, 4307.273, -138.2202,'Captive Crocolisk'), +(28308,85, 5419.486, 4307.023, -137.7202,'Captive Crocolisk'), +(28308,86, 5424.486, 4306.773, -136.9702,'Captive Crocolisk'), +(28308,87, 5432.486, 4306.023, -136.4702,'Captive Crocolisk'), +(28308,88, 5432.637, 4305.777, -136.2332,'Captive Crocolisk'), +(28308,89, 5435.137, 4305.777, -135.9832,'Captive Crocolisk'), +(28308,90, 5439.137, 4305.277, -135.4832,'Captive Crocolisk'), +(28308,91, 5442.887, 4304.777, -134.7332,'Captive Crocolisk'), +(28308,92, 5445.887, 4304.527, -134.2332,'Captive Crocolisk'), +(28308,93, 5450.887, 4304.027, -133.4832,'Captive Crocolisk'), +(28308,94, 5458.887, 4303.027, -132.9832,'Captive Crocolisk'), +(28308,95, 5459.032, 4302.869, -132.6968,'Captive Crocolisk'), +(28308,96, 5465.032, 4302.119, -132.6968,'Captive Crocolisk'), +(28308,97, 5481.032, 4297.369, -131.9468,'Captive Crocolisk'), +(28308,98, 5483.032, 4296.869, -131.1968,'Captive Crocolisk'), +(28308,99, 5484.782, 4296.369, -130.6968,'Captive Crocolisk'), +(28308,100, 5485.782, 4296.119, -129.9468,'Captive Crocolisk'), +(28308,101, 5487.782, 4295.619, -128.9468,'Captive Crocolisk'), +(28308,102, 5489.532, 4294.869, -127.4468,'Captive Crocolisk'), +(28308,103, 5489.61, 4294.574, -127.3404,'Captive Crocolisk'), +(28308,104, 5490.61, 4294.324, -127.0904,'Captive Crocolisk'), +(28308,105, 5491.11, 4293.574, -126.3404,'Captive Crocolisk'), +(28308,106, 5491.86, 4291.824, -125.3404,'Captive Crocolisk'), +(28308,107, 5492.86, 4290.074, -124.0904,'Captive Crocolisk'), +(28308,108, 5493.86, 4288.324, -122.5904,'Captive Crocolisk'), +(28308,109, 5494.86, 4286.574, -121.5904,'Captive Crocolisk'), +(28308,110, 5495.36, 4285.574, -121.0904,'Captive Crocolisk'), +(28308,111, 5496.36, 4284.074, -119.3404,'Captive Crocolisk'), +(28308,112, 5496.61, 4283.074, -118.8404,'Captive Crocolisk'), +(28308,113, 5496.464, 4283.905, -119.1085,'Captive Crocolisk'), +(28308,114, 5496.964, 4282.905, -118.6085,'Captive Crocolisk'), +(28308,115, 5497.464, 4282.155, -117.3585,'Captive Crocolisk'), +(28308,116, 5497.964, 4281.155, -116.8585,'Captive Crocolisk'), +(28308,117, 5498.964, 4279.405, -115.8585,'Captive Crocolisk'), +(28308,118, 5499.214, 4278.655, -114.8585,'Captive Crocolisk'), +(28308,119, 5500.214, 4276.655, -113.6085,'Captive Crocolisk'), +(28308,120, 5501.714, 4274.155, -112.3585,'Captive Crocolisk'), +(28308,121, 5502.714, 4272.405, -111.6085,'Captive Crocolisk'), +(28308,122, 5503.714, 4270.655, -110.6085,'Captive Crocolisk'), +(28308,123, 5503.964, 4269.905, -110.1085,'Captive Crocolisk'), +(28308,124, 5505.464, 4268.655, -109.3585,'Captive Crocolisk'), +(28308,125, 5507.464, 4266.405, -107.8585,'Captive Crocolisk'), +(28308,126, 5508.714, 4265.155, -107.3585,'Captive Crocolisk'), +(28308,127, 5510.214, 4263.655, -106.1085,'Captive Crocolisk'), +(28308,128, 5511.714, 4262.155, -105.1085,'Captive Crocolisk'), +(28308,129, 5513.714, 4260.155, -104.3585,'Captive Crocolisk'), +(28308,130, 5515.964, 4257.905, -103.6085,'Captive Crocolisk'), +(28308,131, 5517.964, 4255.905, -103.1085,'Captive Crocolisk'), +(28308,132, 5518.275, 4255.893, -103.0304,'Captive Crocolisk'), +(28308,133, 5518.525, 4255.643, -102.7804,'Captive Crocolisk'), +(28308,134, 5521.525, 4256.143, -102.2804,'Captive Crocolisk'), +(28308,135, 5540.806, 4259.841, -102.1478,'Captive Crocolisk'), +(28308,136, 5552.306, 4261.591, -102.6478,'Captive Crocolisk'), +(28308,137, 5552.562, 4261.524, -102.5733,'Captive Crocolisk'), +(28308,138, 5564.562, 4263.524, -102.3233,'Captive Crocolisk'), +(28308,139, 5567.062, 4263.024, -101.8233,'Captive Crocolisk'), +(28308,140, 5570.062, 4262.774, -101.0733,'Captive Crocolisk'), +(28308,141, 5573.062, 4262.524, -100.5733,'Captive Crocolisk'), +(28308,142, 5581.062, 4261.524, -100.0733,'Captive Crocolisk'), +(28308,143, 5585.062, 4261.274, -99.32326,'Captive Crocolisk'), +(28308,144, 5585.636, 4261.419, -99.31418,'Captive Crocolisk'), +(28308,145, 5607.386, 4259.919, -98.81418,'Captive Crocolisk'), +(28308,146, 5607.644, 4260.124, -98.76741,'Captive Crocolisk'), +(28308,147, 5609.894, 4259.874, -98.76741,'Captive Crocolisk'), +(28308,148, 5620.644, 4259.624, -98.01741,'Captive Crocolisk'), +(28308,149, 5620.918, 4259.831, -98.01412,'Captive Crocolisk'), +(28308,150, 5633.668, 4259.581, -98.26412,'Captive Crocolisk'), +(28308,151, 5652.418, 4260.331, -98.76412,'Captive Crocolisk'), +(28308,152, 5652.634, 4260.799, -99.03739,'Captive Crocolisk'), +(28308,153, 5660.884, 4261.299, -98.53739,'Captive Crocolisk'), +(28308,154, 5681.829, 4266.604, -99.07877,'Captive Crocolisk'), +(28308,155, 5683.829, 4267.104, -99.57877,'Captive Crocolisk'), +(28308,156, 5686.579, 4267.604, -100.3288,'Captive Crocolisk'), +(28308,157, 5688.329, 4268.104, -100.8288,'Captive Crocolisk'), +(28308,158, 5691.329, 4268.854, -101.3288,'Captive Crocolisk'), +(28308,159, 5695.079, 4269.854, -102.0788,'Captive Crocolisk'), +(28308,160, 5699.079, 4270.854, -102.8288,'Captive Crocolisk'), +(28308,161, 5699.236, 4271.2, -103.1089,'Captive Crocolisk'), +(28308,162, 5708.486, 4273.7, -102.8589,'Captive Crocolisk'), +(28308,163, 5714.236, 4275.2, -103.3589,'Captive Crocolisk'), +(28308,164, 5717.736, 4275.95, -104.1089,'Captive Crocolisk'), +(28308,165, 5721.736, 4276.95, -104.8589,'Captive Crocolisk'), +(28308,166, 5725.486, 4277.95, -105.3589,'Captive Crocolisk'), +(28308,167, 5729.486, 4278.95, -106.1089,'Captive Crocolisk'), +(28308,168, 5732.236, 4279.7, -106.3589,'Captive Crocolisk'), +(28308,169, 5735.236, 4280.45, -106.8589,'Captive Crocolisk'), +(28308,170, 5737.986, 4281.2, -107.8589,'Captive Crocolisk'), +(28308,171, 5739.986, 4281.7, -108.6089,'Captive Crocolisk'), +(28308,172, 5741.986, 4282.45, -109.3589,'Captive Crocolisk'), +(28308,173, 5743.986, 4282.95, -110.1089,'Captive Crocolisk'), +(28308,174, 5746.736, 4283.7, -110.8589,'Captive Crocolisk'), +(28308,175, 5750.526, 4285.622, -112.3181,'Captive Crocolisk'), +(28308,176, 5752.526, 4287.872, -113.0681,'Captive Crocolisk'), +(28308,177, 5754.776, 4289.872, -113.8181,'Captive Crocolisk'), +(28308,178, 5757.026, 4291.872, -114.5681,'Captive Crocolisk'), +(28308,179, 5759.276, 4293.872, -113.0681,'Captive Crocolisk'), +(28308,180, 5836.026, 4365.122, -114.5681,'Captive Crocolisk'), +(28308,181, 5838.276, 4367.122, -113.0681,'Captive Crocolisk'), +(28308,182, 5840.798, 4369.525, -110.6656,'Captive Crocolisk'), +(28308,183, 5842.548, 4370.525, -109.9156,'Captive Crocolisk'), +(28308,184, 5843.298, 4371.025, -109.4156,'Captive Crocolisk'), +(28308,185, 5845.048, 4372.275, -108.4156,'Captive Crocolisk'), +(28308,186, 5846.548, 4373.525, -107.6656,'Captive Crocolisk'), +(28308,187, 5850.048, 4375.775, -106.6656,'Captive Crocolisk'), +(28308,188, 5852.298, 4377.275, -105.6656,'Captive Crocolisk'), +(28308,189, 5855.798, 4379.775, -104.4156,'Captive Crocolisk'), +(28308,190, 5857.298, 4380.775, -103.6656,'Captive Crocolisk'), +(28308,191, 5858.048, 4381.275, -102.9156,'Captive Crocolisk'), +(28308,192, 5859.048, 4382.025, -100.9156,'Captive Crocolisk'), +(28308,193, 5859.798, 4382.525, -100.1656,'Captive Crocolisk'), +(28308,194, 5862.298, 4384.275, -99.41559,'Captive Crocolisk'), +(28308,195, 5863.798, 4385.275, -100.4156,'Captive Crocolisk'), +(28308,196, 5868.048, 4388.275, -99.91559,'Captive Crocolisk'), +(28308,197, 5871.048, 4390.275, -99.16559,'Captive Crocolisk'), +(28308,198, 5874.298, 4392.525, -98.41559,'Captive Crocolisk'), +(28308,199, 5878.548, 4395.275, -97.91559,'Captive Crocolisk'), +(28308,200, 5889.048, 4402.775, -97.16559,'Captive Crocolisk'), +(28308,201, 5890.798, 4404.025, -96.41559,'Captive Crocolisk'), +(28308,202, 5893.298, 4405.525, -95.91559,'Captive Crocolisk'), +(28308,203, 5896.548, 4407.775, -95.16559,'Captive Crocolisk'), +(28308,204, 5889.418, 4402.901, -97.02716,'Captive Crocolisk'), +(28308,205, 5891.168, 4404.151, -96.27716,'Captive Crocolisk'), +(28308,206, 5893.418, 4405.901, -95.77716,'Captive Crocolisk'), +(28308,207, 5896.918, 4408.151, -95.27716,'Captive Crocolisk'), +(28308,208, 5897.418, 4408.651, -95.02716,'Captive Crocolisk'), +(28308,209, 5901.418, 4413.151, -94.52716,'Captive Crocolisk'), +(28308,210, 5906.418, 4419.151, -93.77716,'Captive Crocolisk'), +(28308,211, 5910.418, 4423.401, -93.27716,'Captive Crocolisk'), +(28308,212, 5922.168, 4437.151, -93.77716,'Captive Crocolisk'), +(28308,213, 5924.918, 4440.151, -94.52716,'Captive Crocolisk'), +(28308,214, 5922.623, 4437.382, -93.73592,'Captive Crocolisk'), +(28308,215, 5925.123, 4440.382, -94.23592,'Captive Crocolisk'), +(28308,216, 5925.623, 4440.882, -94.23592,'Captive Crocolisk'), +(28308,217, 5927.373, 4443.132, -94.73592,'Captive Crocolisk'), +(28308,218, 5929.873, 4446.382, -95.48592,'Captive Crocolisk'), +(28308,219, 5932.373, 4449.632, -95.98592,'Captive Crocolisk'), +(28308,220, 5935.123, 4453.382, -96.73592,'Captive Crocolisk'), +(28308,221, 5940.623, 4460.382, -95.98592,'Captive Crocolisk'), +(28308,222, 5941.873, 4461.882, -95.23592,'Captive Crocolisk'), +(28308,223, 5944.373, 4465.132, -94.48592,'Captive Crocolisk'), +(28308,224, 5947.373, 4469.132, -93.98592,'Captive Crocolisk'), +(28308,225, 5947.696, 4469.354, -94.11644,'Captive Crocolisk'), +(28308,226, 5953.196, 4476.604, -94.11644,'Captive Crocolisk'), +(28308,227, 5955.196, 4482.104, -93.61644,'Captive Crocolisk'), +(28308,228, 5956.696, 4485.604, -92.86644,'Captive Crocolisk'), +(28308,229, 5955.557, 4482.148, -93.45278,'Captive Crocolisk'), +(28308,230, 5957.057, 4485.898, -92.95278,'Captive Crocolisk'), +(28308,231, 5964.307, 4503.898, -92.70278,'Captive Crocolisk'), +(28308,232, 5962.057, 4529.648, -93.45278,'Captive Crocolisk'), +(28308,233, 5961.557, 4533.648, -93.95278,'Captive Crocolisk'), +(28308,234, 5961.307, 4536.648, -94.45278,'Captive Crocolisk'), +(28308,235, 5960.807, 4543.648, -94.95278,'Captive Crocolisk'), +(28308,236, 5962.334, 4529.804, -93.40747,'Captive Crocolisk'), +(28308,237, 5961.834, 4533.804, -93.90747,'Captive Crocolisk'), +(28308,238, 5961.584, 4536.804, -94.65747,'Captive Crocolisk'), +(28308,239, 5961.084, 4543.804, -95.15747,'Captive Crocolisk'), +(28308,240, 5960.834, 4546.804, -95.40747,'Captive Crocolisk'), +(28308,241, 5963.334, 4564.304, -95.90747,'Captive Crocolisk'), +(28308,242, 5963.584, 4566.304, -96.65747,'Captive Crocolisk'), +(28308,243, 5963.834, 4569.304, -97.65747,'Captive Crocolisk'), +(28308,244, 5963.431, 4564.66, -96.028,'Captive Crocolisk'), +(28308,245, 5963.681, 4566.66, -96.778,'Captive Crocolisk'), +(28308,246, 5963.931, 4569.66, -97.528,'Captive Crocolisk'), +(28308,247, 5965.431, 4579.41, -97.028,'Captive Crocolisk'), +(28308,248, 5969.632, 4614.113, -97.93755,'Captive Crocolisk'), +(28308,249, 5970.632, 4621.863, -98.43755,'Captive Crocolisk'), +(28308,250, 5976.144, 4659.492, -99.19481,'Captive Crocolisk'), +(28308,251, 5979.644, 4667.742, -98.44481,'Captive Crocolisk'), +(28308,252, 5980.644, 4670.492, -97.94481,'Captive Crocolisk'), +(28308,253, 5983.644, 4677.742, -97.19481,'Captive Crocolisk'), +(28308,254, 5990.394, 4693.242, -97.94481,'Captive Crocolisk'), +(28308,255, 5991.394, 4695.992, -98.44481,'Captive Crocolisk'), +(28308,256, 5983.768, 4677.933, -97.22537,'Captive Crocolisk'), +(28308,257, 5990.518, 4693.683, -97.47537,'Captive Crocolisk'), +(28308,258, 5991.768, 4696.433, -98.22537,'Captive Crocolisk'), +(28308,259, 5993.268, 4699.683, -98.97537,'Captive Crocolisk'), +(28308,260, 5995.518, 4704.183, -98.22537,'Captive Crocolisk'), +(28308,261, 5996.768, 4706.933, -97.47537,'Captive Crocolisk'), +(28308,262, 5998.518, 4710.433, -96.97537,'Captive Crocolisk'), +(28308,263, 6015.43, 4744.089, -96.98655,'Captive Crocolisk'), +(28308,264, 6021.18, 4757.589, -96.48655,'Captive Crocolisk'), +(28308,265, 6023.68, 4762.839, -95.98655,'Captive Crocolisk'), +(28308,266, 6029.43, 4775.839, -95.48655,'Captive Crocolisk'), +(28308,267, 6032.68, 4783.089, -94.73655,'Captive Crocolisk'), +(28308,268, 6029.549, 4775.949, -95.34583,'Captive Crocolisk'), +(28308,269, 6032.799, 4783.199, -94.84583,'Captive Crocolisk'), +(28308,270, 6035.549, 4788.949, -94.59583,'Captive Crocolisk'), +(28308,271, 6040.799, 4796.199, -93.84583,'Captive Crocolisk'), +(28308,272, 6052.299, 4810.949, -94.34583,'Captive Crocolisk'), +(28308,273, 6055.299, 4814.949, -93.34583,'Captive Crocolisk'), +(28308,274, 6058.299, 4818.949, -93.84583,'Captive Crocolisk'), +(28308,275, 6056.549, 4816.449, -92.84583,'Captive Crocolisk'), +(28308,276, 6059.549, 4820.449, -94.34583,'Captive Crocolisk'), +(28308,277, 6055.51, 4815.281, -93.31942,'Captive Crocolisk'), +(28308,278, 6056.76, 4816.781, -92.81942,'Captive Crocolisk'), +(28308,279, 6058.51, 4819.281, -93.81942,'Captive Crocolisk'), +(28308,280, 6059.76, 4820.781, -94.06942,'Captive Crocolisk'), +(28308,281, 6065.01, 4827.781, -94.06942,'Captive Crocolisk'), +(28308,282, 6065.26, 4840.781, -93.56942,'Captive Crocolisk'), +(28308,283, 6065.26, 4841.781, -92.81942,'Captive Crocolisk'), +(28308,284, 6065.26, 4848.531, -93.81942,'Captive Crocolisk'), +(28308,285, 6065.731, 4870.604, -94.3074,'Captive Crocolisk'), +(28308,286, 6077.481, 4876.354, -93.8074,'Captive Crocolisk'), +(28308,287, 6096.964, 4885.957, -94.31221,'Captive Crocolisk'), +(28308,288, 6119.714, 4901.457, -94.56221,'Captive Crocolisk'), +(28308,289, 6120.019, 4901.537, -94.72534,'Captive Crocolisk'), +(28308,290, 6120.519, 4902.037, -94.72534,'Captive Crocolisk'); -- cgit v1.2.3