World Teleporter Sunken Temple CORRECTED location FIXED - SQL

Krowten

Gold Supporter
Veteran Member
43
2020
25
Location
USA
Sunken Temple Teleport location on WORLD TELEPORTER NPC 19000. It teleports you to a glitched area. This injection will fix that.


REPLACE INTO emucoach_v13_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, 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 ('190000', '0', '36', '0', '62', '0', '100', '0', '51901', '16', '0', '0', '62', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-10291.4', '-3985.99', '-70.8505', '1.34967', 'Sunken Temple');

Be sure to change the "world" database name to match yours. You will need to do a full server restart to implement the change. If you want to test to see if your WORLD TELEPORTER NPC is broken; use the command .npc add 190000. Try to teleport to Sunken Temple in the Classic Dungeons tab. If you are in the wrong place, just use this replacement and restart your server, you will be right in front of the portal now. Let me know if these are helpful, I'll keep them coming.
 

Maze

Gold Supporter
Veteran Member
65
2019
44
Thanks dude! Nice found
Here are some fixes for wrong conditios or tp location :

Just copy and paste it to yours world database

/*Western Plaguelands 35,Badland 44*/
UPDATE `conditions` SET `ConditionValue1`='35' WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=51905 AND `SourceEntry`=21 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=27 AND `ConditionTarget`=0 AND `ConditionValue1`=51 AND `ConditionValue2`=3 AND `ConditionValue3`=0;
UPDATE `conditions` SET `ConditionValue1`='44' WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=51905 AND `SourceEntry`=15 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=27 AND `ConditionTarget`=0 AND `ConditionValue1`=35 AND `ConditionValue2`=3 AND `ConditionValue3`=0;
/*tolto alterac, hillbrad foothills*/
DELETE FROM `gossip_menu_option` WHERE `menu_id`=51905 AND `id`=10;
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=51905 AND `SourceEntry`=10 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=27 AND `ConditionTarget`=0 AND `ConditionValue1`=20 AND `ConditionValue2`=3 AND `ConditionValue3`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=190000 AND `source_type`=0 AND `id`=89 AND `link`=0;
UPDATE `gossip_menu_option` SET `option_text`='|TInterface/ICONS/Achievement_Zone_HillsbradFoothills:35:35|tHillsbrad Foothills' WHERE `menu_id`=51905 AND `id`=12;
/*swap of sorrow*/
UPDATE `conditions` SET `ConditionValue1`='51' WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=51905 AND `SourceEntry`=16 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=27 AND `ConditionTarget`=0 AND `ConditionValue1`=35 AND `ConditionValue2`=3 AND `ConditionValue3`=0;
UPDATE `smart_scripts` SET `target_x`='-10379.4', `target_y`='-2713.38', `target_z`='21.67902', `target_o`='5.235844' WHERE `entryorguid`=190000 AND `source_type`=0 AND `id`=95 AND `link`=0;
/*level cata raids/ dungeons*/
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '51900', '22', '27', '85', '3', 'Portal Master - Level req');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '51900', '21', '27', '80', '3', 'Portal Master - Level req');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '10', '27', '80', '3', 'Portal Master - Level req-throne');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '0', '27', '80', '3', 'Portal Master - Level req-blackrock');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '9', '27', '81', '3', 'Portal Master - Level req vortex');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '8', '27', '81', '3', 'Portal Master - Level req-The Stonecore');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '4', '27', '84', '3', 'Portal Master - Level req halls of or');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '3', '27', '84', '3', 'Portal Master - Level req grim batol');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '6', '27', '84', '3', 'Portal Master - Level req lost city');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '1', '27', '85', '3', 'Portal Master - Level req 85 dung');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '2', '27', '85', '3', 'Portal Master - Level req 85 dung');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '5', '27', '85', '3', 'Portal Master - Level req 85 dung');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '7', '27', '85', '3', 'Portal Master - Level req 85 dung');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '11', '27', '85', '3', 'Portal Master - Level req 85 dung');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '12', '27', '85', '3', 'Portal Master - Level req 85 dung');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '13', '27', '85', '3', 'Portal Master - Level req 85 dung');
/*searing gorge location*/
UPDATE `smart_scripts` SET `target_x`='-6976.78', `target_y`='-1069.34', `target_z`='240.705', `target_o`='2.970685' WHERE `entryorguid`=190000 AND `source_type`=0 AND `id`=97 AND `link`=0;
/*the blasted land 55*/
UPDATE `conditions` SET `ConditionValue1`='55' WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=51905 AND `SourceEntry`=19

 
Last edited:

Blackvision

Mythical User
Super Moderator
Gold Supporter
2,298
2015
272
Location
Denmark
Thanks dude! Nice found
Here are some fixes for wrong conditios or tp location :

Just copy and paste it to yours world database

/*Western Plaguelands 35,Badland 44*/
UPDATE `conditions` SET `ConditionValue1`='35' WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=51905 AND `SourceEntry`=21 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=27 AND `ConditionTarget`=0 AND `ConditionValue1`=51 AND `ConditionValue2`=3 AND `ConditionValue3`=0;
UPDATE `conditions` SET `ConditionValue1`='44' WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=51905 AND `SourceEntry`=15 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=27 AND `ConditionTarget`=0 AND `ConditionValue1`=35 AND `ConditionValue2`=3 AND `ConditionValue3`=0;
/*tolto alterac, hillbrad foothills*/
DELETE FROM `gossip_menu_option` WHERE `menu_id`=51905 AND `id`=10;
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=51905 AND `SourceEntry`=10 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=27 AND `ConditionTarget`=0 AND `ConditionValue1`=20 AND `ConditionValue2`=3 AND `ConditionValue3`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=190000 AND `source_type`=0 AND `id`=89 AND `link`=0;
UPDATE `gossip_menu_option` SET `option_text`='|TInterface/ICONS/Achievement_Zone_HillsbradFoothills:35:35|tHillsbrad Foothills' WHERE `menu_id`=51905 AND `id`=12;
/*swap of sorrow*/
UPDATE `conditions` SET `ConditionValue1`='51' WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=51905 AND `SourceEntry`=16 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=27 AND `ConditionTarget`=0 AND `ConditionValue1`=35 AND `ConditionValue2`=3 AND `ConditionValue3`=0;
UPDATE `smart_scripts` SET `target_x`='-10379.4', `target_y`='-2713.38', `target_z`='21.67902', `target_o`='5.235844' WHERE `entryorguid`=190000 AND `source_type`=0 AND `id`=95 AND `link`=0;
/*level cata raids/ dungeons*/
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '51900', '22', '27', '85', '3', 'Portal Master - Level req');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '51900', '21', '27', '80', '3', 'Portal Master - Level req');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '10', '27', '80', '3', 'Portal Master - Level req-throne');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '0', '27', '80', '3', 'Portal Master - Level req-blackrock');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '9', '27', '81', '3', 'Portal Master - Level req vortex');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '8', '27', '81', '3', 'Portal Master - Level req-The Stonecore');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '4', '27', '84', '3', 'Portal Master - Level req halls of or');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '3', '27', '84', '3', 'Portal Master - Level req grim batol');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '6', '27', '84', '3', 'Portal Master - Level req lost city');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '1', '27', '85', '3', 'Portal Master - Level req 85 dung');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '2', '27', '85', '3', 'Portal Master - Level req 85 dung');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '5', '27', '85', '3', 'Portal Master - Level req 85 dung');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '7', '27', '85', '3', 'Portal Master - Level req 85 dung');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '11', '27', '85', '3', 'Portal Master - Level req 85 dung');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '12', '27', '85', '3', 'Portal Master - Level req 85 dung');
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES ('15', '50004', '13', '27', '85', '3', 'Portal Master - Level req 85 dung');
/*searing gorge location*/
UPDATE `smart_scripts` SET `target_x`='-6976.78', `target_y`='-1069.34', `target_z`='240.705', `target_o`='2.970685' WHERE `entryorguid`=190000 AND `source_type`=0 AND `id`=97 AND `link`=0;
/*the blasted land 55*/
UPDATE `conditions` SET `ConditionValue1`='55' WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=51905 AND `SourceEntry`=19
Thank you mate :) :)
 
Top