DB/Gameobject: Tirisfal-pumpkin

From: https://github.com/unified-db/Database/commit/5caafd7a0cb9b56755e3617b39f450828de6a389
Closes #20679
For 3.3.5 Only

1 files changed, 74 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2017_10_22_06_world_335.sql b/sql/updates/world/3.3.5/2017_10_22_06_world_335.sql
new file mode 100644
index 00000000000..2df9da99aee
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_10_22_06_world_335.sql
@@ -0,0 +1,74 @@
+-- Tirisfal Pumpkin
+DELETE FROM `gameobject` WHERE `guid` IN (409,412,414,420,424,426,432,492,509,513,601,610,612,617,646,660,665,669,672,718,750,763,787,791,796,802,813,828,833,836,853,859);
+DELETE FROM `gameobject_addon` WHERE `guid` IN (45042, 45043, 45157, 45194, 45195, 45196, 45197, 45198, 45200, 45201);
+DELETE FROM `gameobject` WHERE `id`=375;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES 
+(409,375, 0, 1, 1, 2431.47, 1591.2, 37.0613, 0.488692, 0, 0, 0.241922, 0.970296, 120, 255, 1),
+(412,375, 0, 1, 1, 2351.13, 1324.59, 33.3334, 0.293625, 0, 0, 0.146286, 0.989242, 120, 255, 1),
+(414,375, 0, 1, 1, 2284.49, 1470.76, 33.4333, 1.22173, 0, 0, 0.573576, 0.819152, 120, 255, 1),
+(420,375, 0, 1, 1, 2293.58, 1396.66, 33.4333, -1.55334, 0, 0, -0.700908, 0.713252, 120, 255, 1),
+(424,375, 0, 1, 1, 2259.64, 1430.03, 33.4525, 2.3911, 0, 0, 0.930417, 0.366502, 120, 255, 1),
+(426,375, 0, 1, 1, 2304, 1439.05, 33.4333, -0.750491, 0, 0, -0.366501, 0.930418, 120, 255, 1),
+(432,375, 0, 1, 1, 2355.96, 1348.1, 33.4333, 2.84489, 0, 0, 0.989016, 0.147808, 120, 255, 1),
+(492,375, 0, 1, 1, 2348.16, 1405.88, 33.3189, 1.46608, 0, 0, 0.669132, 0.743144, 120, 255, 1),
+(509,375, 0, 1, 1, 2279.18, 1450.29, 33.4333, -1.74533, 0, 0, -0.766045, 0.642787, 120, 255, 1),
+(513,375, 0, 1, 1, 2263.35, 1480.02, 33.4491, 1.97222, 0, 0, 0.833885, 0.551938, 120, 255, 1),
+(601,375, 0, 1, 1, 2363.91, 1348.38, 33.3324, 3.84784, 0, 0, 0.938297, -0.345831, 120, 255, 1),
+(610,375, 0, 1, 1, 2360.47, 1399.62, 33.0846, 3.9146, 0, 0, 0.926233, -0.376952, 120, 255, 1),
+(612,375, 0, 1, 1, 2340.72, 1352.37, 33.3341, 0.344954, 0, 0, 0.171623, 0.985163, 120, 255, 1),
+(617,375, 0, 1, 1, 2341.88, 1344.28, 33.3341, 5.63673, 0, 0, 0.31763, -0.948215, 120, 255, 1),
+(646,375, 0, 1, 1, 2305.16, 1357.46, 33.3335, 4.13272, 0, 0, 0.879701, -0.475526, 120, 255, 1),
+(660,375, 0, 1, 1, 2329.93, 1378.17, 33.3335, 0.446058, 0, 0, 0.221185, 0.975232, 120, 255, 1),
+(665,375, 0, 1, 1, 2318.93, 1398, 33.3335, 2.74335, 0, 0, 0.980241, 0.197809, 120, 255, 1),
+(669,375, 0, 1, 1, 2305.13, 1347.16, 33.3334, 4.94245, 0, 0, 0.621275, -0.783592, 120, 255, 1),
+(672,375, 0, 1, 1, 2300.79, 1352.3, 33.3334, 3.07713, 0, 0, 0.999481, 0.0322268, 120, 255, 1),
+(718,375, 0, 1, 1, 2276.21, 1362.27, 33.3335, 3.29704, 0, 0, 0.996981, -0.0776452, 120, 255, 1),
+(750,375, 0, 1, 1, 2265.59, 1354.08, 33.3335, 4.40528, 0, 0, 0.80694, -0.590634, 120, 255, 1),
+(763,375, 0, 1, 1, 2268.72, 1403.56, 33.3334, 0.24895, 0, 0, 0.124154, 0.992263, 120, 255, 1),
+(787,375, 0, 1, 1, 2287.5, 1419.42, 33.3334, 0.307855, 0, 0, 0.153321, 0.988177, 120, 255, 1),
+(791,375, 0, 1, 1, 2304.68, 1471.36, 33.3334, 1.05791, 0, 0, 0.504632, 0.863335, 120, 255, 1),
+(796,375, 0, 1, 1, 2304.19, 1477.65, 33.3334, 1.05791, 0, 0, 0.504632, 0.863335, 120, 255, 1),
+(802,375, 0, 1, 1, 2294.94, 1477.74, 33.3334, 6.25332, 0, 0, 0.0149322, -0.999889, 120, 255, 1),
+(813,375, 0, 1, 1, 2333.19, 1478.31, 33.3334, 0.468867, 0, 0, 0.232292, 0.972646, 120, 255, 1),
+(828,375, 0, 1, 1, 2339.75, 1485.74, 33.435, 0.417816, 0, 0, 0.207392, 0.978258, 120, 255, 1),
+(833,375, 0, 1, 1, 2362.05, 1474.94, 33.3341, 5.06267, 0, 0, 0.57308, -0.8195, 120, 255, 1),
+(836,375, 0, 1, 1, 2337, 1446.25, 33.3341, 4.10919, 0, 0, 0.885234, -0.465147, 120, 255, 1),
+(853,375, 0, 1, 1, 2337.31, 1453.2, 33.3341, 2.26351, 0, 0, 0.905159, 0.425073, 120, 255, 1),
+(859,375, 0, 1, 1, 2419.53, 1561.74, 32.748, 3.99817, 0, 0, 0.905159, 0.425073, 120, 255, 1);
+-- pools
+-- should be spawned max 15 (30 total spawns)
+DELETE FROM `pool_template` WHERE `entry` = 379;
+INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES 
+(379,15,'Tirisfal Pumpkin');
+DELETE FROM `pool_gameobject` WHERE `pool_entry` = 379;
+INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`) VALUES
+(412, 379, 0, '375 - Tirisfal Pumpkin'),
+(414, 379, 0, '375 - Tirisfal Pumpkin'),
+(420, 379, 0, '375 - Tirisfal Pumpkin'),
+(424, 379, 0, '375 - Tirisfal Pumpkin'),
+(426, 379, 0, '375 - Tirisfal Pumpkin'),
+(432, 379, 0, '375 - Tirisfal Pumpkin'),
+(492, 379, 0, '375 - Tirisfal Pumpkin'),
+(509, 379, 0, '375 - Tirisfal Pumpkin'),
+(513, 379, 0, '375 - Tirisfal Pumpkin'),
+(601, 379, 0, '375 - Tirisfal Pumpkin'),
+(610, 379, 0, '375 - Tirisfal Pumpkin'),
+(612, 379, 0, '375 - Tirisfal Pumpkin'),
+(617, 379, 0, '375 - Tirisfal Pumpkin'),
+(646, 379, 0, '375 - Tirisfal Pumpkin'),
+(660, 379, 0, '375 - Tirisfal Pumpkin'),
+(665, 379, 0, '375 - Tirisfal Pumpkin'),
+(669, 379, 0, '375 - Tirisfal Pumpkin'),
+(672, 379, 0, '375 - Tirisfal Pumpkin'),
+(718, 379, 0, '375 - Tirisfal Pumpkin'),
+(750, 379, 0, '375 - Tirisfal Pumpkin'),
+(763, 379, 0, '375 - Tirisfal Pumpkin'),
+(787, 379, 0, '375 - Tirisfal Pumpkin'),
+(791, 379, 0, '375 - Tirisfal Pumpkin'),
+(796, 379, 0, '375 - Tirisfal Pumpkin'),
+(802, 379, 0, '375 - Tirisfal Pumpkin'),
+(813, 379, 0, '375 - Tirisfal Pumpkin'),
+(828, 379, 0, '375 - Tirisfal Pumpkin'),
+(833, 379, 0, '375 - Tirisfal Pumpkin'),
+(836, 379, 0, '375 - Tirisfal Pumpkin'),
+(853, 379, 0, '375 - Tirisfal Pumpkin');