[LF] Need DB developers for the Emucoach repack projects
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:
Jenniy

Jenniy

I collect profile flairs.
Gold Supporter
Silver Supporter
MoP Premium
Senior User
354
2020
72
Hooray! Tol Barad fixes!
 
You must log in or register to reply here.
Top