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

Minor fixes v14 (Tol Barad)

Stiga

Stiga

Gold Supporter
Veteran Member
66
2020
123
Location
France
Missing gameojects for daily quests (this was the same on V13.1 and therefore same fix)
www.wowhead.com

Cursed Shackles

Cursed Shackles is a World of Warcraft object that can be found in Tol Barad. In the Container Objects category. Added in World of Warcraft: Cataclysm.
www.wowhead.com www.wowhead.com
-- https://www.wowhead.com/object=206890/dusty-prison-journal

SQL: 
-- https://www.wowhead.com/object=206905/cursed-shackles
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206905, 732, 5095, 5657, 1, 1, -998.011, 1133.85, 84.5363, 4.62024, 0, 0, 0.738925, -0.673788, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206905, 732, 5095, 5657, 1, 1, -922.786, 1200.36, 84.8031, 2.61119, 0, 0, 0.96504, 0.262104, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206905, 732, 5095, 5657, 1, 1, -1008.42, 1221.11, 84.582, 5.82425, 0, 0, 0.22746, -0.973788, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206905, 732, 5095, 5657, 1, 1, -962.981, 1219.44, 84.8108, 4.73413, 0, 0, 0.699379, -0.714751, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206905, 732, 5095, 5657, 1, 1, -951.321, 1181.24, 84.577, 3.14055, 0, 0, 1, 0.000520424, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206905, 732, 5095, 5657, 1, 1, -986.709, 1168.15, 84.5467, 0.174886, 0, 0, 0.0873316, 0.996179, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206905, 732, 5095, 5657, 1, 1, -962.872, 1153.87, 84.578, 2.85781, 0, 0, 0.98995, 0.141417, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206905, 732, 5095, 5657, 1, 1, -916.117, 1129.74, 84.5682, 3.7296, 0, 0, 0.957092, -0.289786, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206905, 732, 5095, 5657, 1, 1, -954.577, 1113.07, 84.5819, 2.49338, 0, 0, 0.947936, 0.318461, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206905, 732, 5095, 5657, 1, 1, -990.216, 1088.68, 84.5818, 0.188232, 0, 0, 0.0939772, 0.995574, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206905, 732, 5095, 5657, 1, 1, -990.49, 1044.62, 84.5824, 6.08657, 0, 0, 0.0981476, -0.995172, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206905, 732, 5095, 5657, 1, 1, -956.396, 1040.33, 84.581, 3.25678, 0, 0, 0.998342, -0.0575641, 300, 0, 1);
-- https://www.wowhead.com/object=206890/dusty-prison-journal
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206890, 732, 5095, 5658, 1, 1, -1264.38, 855.123, 89.531, 5.05828, 0, 0, 0.574878, -0.818239, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206890, 732, 5095, 5658, 1, 1, -1196.85, 851.881, 89.5322, 5.13446, 0, 0, 0.543298, -0.83954, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206890, 732, 5095, 5658, 1, 1, -1210.39, 815.143, 89.5287, 1.53341, 0, 0, 0.693766, 0.7202, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206890, 732, 5095, 5658, 1, 1, -1224.55, 853.031, 89.5288, 4.75511, 0, 0, 0.691842, -0.722049, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206890, 732, 5095, 5658, 1, 1, -1315.59, 838.486, 89.5288, 0.074126, 0, 0, 0.0370545, 0.999313, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206890, 732, 5095, 5658, 1, 1, -1304.72, 881.071, 90.5064, 4.90431, 0, 0, 0.636103, -0.771604, 300, 0, 1);
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var, 206890, 732, 5095, 5658, 1, 1, -1277.82, 852.29, 89.5289, 3.20392, 0, 0, 0.999514, -0.0311576, 300, 0, 1);

Missing Stormwind portal (alliance camp)

SQL: 
-- missing portal to stormwind alliance camp
SELECT MAX(guid)+1 into @var FROM gameobject;
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 (@var,  195139, 732, 5389, 5545, 1, 1, -400.035, 1077.72, 27.9763, 2.86723, 0, 0, 0.990605, 0.136753, 300, 0, 1);
 
Last edited:
You must log in or register to reply here.
Top