/*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
|