Yor'Sahj Encounter FIX-SQL

Krowten

Gold Supporter
Veteran Member
43
2020
25
Location
USA
First run this Query in your Emucoach 4.3.4 Repack Database:

INSERT INTO gameobject_template (entry, type, displayId, name, IconName, castBarCaption, unk1, faction, flags, size, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, data0, data1, data2, data3, data4, data5, data6, data7, data8, data9, data10, data11, data12, data13, data14, data15, data16, data17, data18, data19, data20, data21, data22, data23, data24, data25, data26, data27, data28, data29, data30, data31, unkInt32, AIName, ScriptName, WDBVerified) VALUES (800000, 22, 1327, 'Portal to Yor'Sahj', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 95717, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 1);

Once you have that completed run this one next:

REPLACE INTO spell_target_position (id, target_map, target_position_x, target_position_y, target_position_z, target_orientation) VALUES (95717, 967, -1866.89, -3089.04, -175.061, 0.580228);

Run both of these in your WORLD DB of course. This will place a portal next to the 3rd Dragon Flight to get to Yor'Sahj. If you have any questions MSG me.

Krowten
 
Last edited by a moderator:

Venetica

Gold Supporter
Veteran Member
60
2015
15
Very nice. Here my Fix with NPC (Look like the Dragon)

The NPC
SQL:
INSERT INTO `creature_template`(`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `exp_unk`, `faction_a`, `faction_h`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_fly`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `currencyID`, `currencyCount`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Mana_mod_extra`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`, `ReactState`) VALUES (500096, 0, 0, 0, 0, 0, 8317, 0, 0, 0, 'Eiendormi Port', '', 'Taxi', 60001, 85, 85, 2, 0, 35, 35, 3, 1, 1.14286, 1, 1.14286, 1, 1, 0, 0, 0, 0, 1, 2000, 2000, 2, 2, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 'SmartAI', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 13623, 2);

The Gossip (Rightclick the NPC)
SQL:
INSERT INTO `gossip_menu_option`(`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `OptionbroadCastTextId`, `BoxBroadcastTextId`) VALUES (60001, 1, 0, '|TInterface/ICONS/Achievement_worldevent_lunar:35:35|t|cffff00ff Nächster Boss', 1, 1, 60001, 0, 0, 0, '', 0, 0);

The Port (Click on Gossip)
SQL:
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`, `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 (500096, 0, 188, 0, 62, 0, 100, 0, 60001, 1, 0, 0, 0, 62, 967, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, -1858.58, -3086.6, -176.072, 0.598499, 'Teleporter script');


Place the NPC on the old Place from Eiendormi and he will Port you to Yor'sahj.
 

Blackvision

Mythical User
Super Moderator
Gold Supporter
2,298
2015
272
Location
Denmark
Very nice. Here my Fix with NPC (Look like the Dragon)

The NPC
SQL:
INSERT INTO `creature_template`(`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `exp_unk`, `faction_a`, `faction_h`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_fly`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `currencyID`, `currencyCount`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Mana_mod_extra`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`, `ReactState`) VALUES (500096, 0, 0, 0, 0, 0, 8317, 0, 0, 0, 'Eiendormi Port', '', 'Taxi', 60001, 85, 85, 2, 0, 35, 35, 3, 1, 1.14286, 1, 1.14286, 1, 1, 0, 0, 0, 0, 1, 2000, 2000, 2, 2, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 'SmartAI', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 13623, 2);

The Gossip (Rightclick the NPC)
SQL:
INSERT INTO `gossip_menu_option`(`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `OptionbroadCastTextId`, `BoxBroadcastTextId`) VALUES (60001, 1, 0, '|TInterface/ICONS/Achievement_worldevent_lunar:35:35|t|cffff00ff Nächster Boss', 1, 1, 60001, 0, 0, 0, '', 0, 0);

The Port (Click on Gossip)
SQL:
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`, `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 (500096, 0, 188, 0, 62, 0, 100, 0, 60001, 1, 0, 0, 0, 62, 967, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, -1858.58, -3086.6, -176.072, 0.598499, 'Teleporter script');


Place the NPC on the old Place from Eiendormi and he will Port you to Yor'sahj.
Thank you mate.
Worked like a charm
 
Top