krokogames
Verified Member
- 18
- 2015
- 6
Quest : now only for dranei race
Rescue the Survivors!
UPDATE `emucoach_v15_vip_world`.`quest_template` SET `RequiredRaces` = 1024 WHERE `Id` = 9283
Semid:
UPDATE `emucoach_v15_vip_world`.`creature_template` SET `npcflag` = 51 WHERE `entry` = 17481
UPDATE `emucoach_v15_vip_world`.`gossip_menu_option` SET `option_id` = 5, `npc_option_npcflag` = 16 WHERE `menu_id` = 7264 AND `id` = 0
This is a Mage Quest called Control
INSERT INTO `emucoach_v15_vip_world`.`creature_queststarter` (`id`, `quest`) VALUES (17481, 9595)
Daedal Alchemy trainer:
UPDATE `emucoach_v15_vip_world`.`creature_template` SET `npcflag` = 19 WHERE `entry` = 17215
UPDATE `emucoach_v15_vip_world`.`gossip_menu_option` SET `option_id` = 5, `npc_option_npcflag` = 16 WHERE `menu_id` = 7384 AND `id` = 0
Anchorite Fateema <First Aid Trainer>
UPDATE `emucoach_v15_vip_world`.`creature_template` SET `npcflag` = 19 WHERE `entry` = 17214
UPDATE `emucoach_v15_vip_world`.`gossip_menu_option` SET `option_id` = 5, `npc_option_npcflag` = 16 WHERE `menu_id` = 7380 AND `id` = 0
Wrathscale Siren
add cast frostbolt
INSERT INTO `emucoach_v15_vip_world`.`smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES (17195, 0, 1, 0, 4, 0, 100, 1, 0, 0, 0, 0, 0, 11, 32984, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Wrathscale Siren - On Aggro - Cast \'Frostbolt\'');
INSERT INTO `emucoach_v15_vip_world`.`smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES (17195, 0, 2, 0, 9, 0, 100, 0, 0, 40, 3400, 4700, 0, 11, 32984, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Wrathscale Siren - Cast Frostbolt in Combat');
thanks to:
orangefire
Morae <Herbalism Trainer>
UPDATE `emucoach_v15_vip_world`.`creature_template` SET `npcflag` = 19 WHERE `entry` = 17434
UPDATE `emucoach_v15_vip_world`.`gossip_menu_option` SET `option_id` = 5, `npc_option_npcflag` = 16 WHERE `menu_id` = 7459 AND `id` = 0
Anchorite Paetheus <First Aid Trainer>
UPDATE `emucoach_v15_vip_world`.`creature_template` SET `npcflag` = 19 WHERE `entry` = 17424
UPDATE `emucoach_v15_vip_world`.`gossip_menu_option` SET `option_id` = 5, `npc_option_npcflag` = 16 WHERE `menu_id` = 7455 AND `id` = 0
Prospector Nachlan <Explorers' League> (Minning)
UPDATE `emucoach_v15_vip_world`.`creature_template` SET `npcflag` = 19 WHERE `entry` = 18804
UPDATE `emucoach_v15_vip_world`.`gossip_menu_option` SET `option_id` = 5, `npc_option_npcflag` = 16 WHERE `menu_id` = 7833 AND `id` = 0