What's new

small fix Professions trainers,quest and mobs in Dranei location

krokogames

Supporter
Supporter
Member
Joined
Jun 10, 2015
Messages
14
Reaction score
5
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
 
Top