[News] Mists of Pandaria Premium Repack 6.1 is out!
What's new

Minor fixes v14 (Tol Barad)

Stiga

Stiga

Gold Supporter
Veteran Member
69
2020
125
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:
Hooray! Tol Barad fixes!
 
You must log in or register to reply here.
Back
Top