Emucoach Announcement | MoP Premium 4 Release Date | Cataclysm VIP 17 Release Date | Happy New Years!
What's new

Quest King Of The Foulweals 13989 fix 7.02

eyerobot

eyerobot

Gold Supporter
Superior Member
917
2015
23
Location
Barryton Michigan USA
Quest King Of The Foulwealds 13989 fix 7.02

The temp foulweald totem bunny wasn't spawned
Also the server problem where it always spawns four of every summoned creature, Makes this quest a nightmare.

Code: 
DELETE FROM `gameobject` WHERE `guid`=9969079;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (9969079, 300131, 1, 331, 2359, 1, 65535, 2231.02, -1550.8, 93.1263, 0.331394, 0, 0, 0.16494, 0.986304, 300, 0, 1);

remove overspawned attackers
Code: 
DELETE FROM `event_scripts` WHERE `id`=6721 AND `datalong`=3743;
DELETE FROM `event_scripts` WHERE `id`=6721 AND `datalong`=3749;
DELETE FROM `event_scripts` WHERE `id`=6721 AND `datalong`=3750;
DELETE FROM `event_scripts` WHERE `id`=6721 AND `datalong`=12918;

Replace the correct amount of attackers.
Code: 
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=180 AND `command`=10 AND `datalong`=12918 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2208.93 AND `y`=-1567.59 AND `z`=87.2283 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 180, 10, 12918, 180000, 0, 2208.93, -1567.59, 87.2283, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=155 AND `command`=10 AND `datalong`=3743 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2202.16 AND `y`=-1544.48 AND `z`=87.796 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 155, 10, 3743, 180000, 0, 2202.16, -1544.48, 87.796, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=125 AND `command`=10 AND `datalong`=3743 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2235.44 AND `y`=-1578.43 AND `z`=86.4944 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 125, 10, 3743, 180000, 0, 2235.44, -1578.43, 86.4944, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=105 AND `command`=10 AND `datalong`=3743 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2237.48 AND `y`=-1524.45 AND `z`=89.7827 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 105, 10, 3743, 180000, 0, 2237.48, -1524.45, 89.7827, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=75 AND `command`=10 AND `datalong`=3743 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2208.93 AND `y`=-1567.59 AND `z`=87.2283 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 75, 10, 3743, 180000, 0, 2208.93, -1567.59, 87.2283, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=25 AND `command`=10 AND `datalong`=3743 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2260.9 AND `y`=-1547.91 AND `z`=89.1733 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 25, 10, 3743, 180000, 0, 2260.9, -1547.91, 89.1733, 0);




DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=155 AND `command`=10 AND `datalong`=3749 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2237.48 AND `y`=-1524.45 AND `z`=89.7827 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 155, 10, 3749, 180000, 0, 2237.48, -1524.45, 89.7827, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=125 AND `command`=10 AND `datalong`=3749 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2208.93 AND `y`=-1567.59 AND `z`=87.2283 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 125, 10, 3749, 180000, 0, 2208.93, -1567.59, 87.2283, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=75 AND `command`=10 AND `datalong`=3749 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2260.9 AND `y`=-1547.91 AND `z`=89.1733 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 75, 10, 3749, 180000, 0, 2260.9, -1547.91, 89.1733, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=55 AND `command`=10 AND `datalong`=3749 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2202.16 AND `y`=-1544.48 AND `z`=87.796 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 55, 10, 3749, 180000, 0, 2202.16, -1544.48, 87.796, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=25 AND `command`=10 AND `datalong`=3749 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2235.44 AND `y`=-1578.43 AND `z`=86.4944 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 25, 10, 3749, 180000, 0, 2235.44, -1578.43, 86.4944, 0);



DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=125 AND `command`=10 AND `datalong`=3750 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2260.9 AND `y`=-1547.91 AND `z`=89.1733 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 125, 10, 3750, 180000, 0, 2260.9, -1547.91, 89.1733, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=105 AND `command`=10 AND `datalong`=3750 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2202.16 AND `y`=-1544.48 AND `z`=87.796 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 105, 10, 3750, 180000, 0, 2202.16, -1544.48, 87.796, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=75 AND `command`=10 AND `datalong`=3750 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2235.44 AND `y`=-1578.43 AND `z`=86.4944 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 75, 10, 3750, 180000, 0, 2235.44, -1578.43, 86.4944, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=55 AND `command`=10 AND `datalong`=3750 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2237.48 AND `y`=-1524.45 AND `z`=89.7827 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 55, 10, 3750, 180000, 0, 2237.48, -1524.45, 89.7827, 0);
DELETE FROM `event_scripts` WHERE `id`=6721 AND `delay`=25 AND `command`=10 AND `datalong`=3750 AND `datalong2`=180000 AND `dataint`=0 AND `x`=2208.93 AND `y`=-1567.59 AND `z`=87.2283 AND `o`=0;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (6721, 25, 10, 3750, 180000, 0, 2208.93, -1567.59, 87.2283, 0);
 
Last edited:
You must log in or register to reply here.
Top