Trinitycore: DB/Gameobject: Solliden Farmstead needs more pumpkins

[Teppic1]

Description:

"Solliden Farmstead missing pumpkins!!! :O"

For quest 365 you need to collect pumpkins. As things stand only a few exist, but there should be a pumpkin on every patch in the field. e.g. as this image shows.

http://www.wowhead.com/quest=365/fields-of-grief
http://www.wowhead.com/object=375/tirisfal-pumpkin

Branch(es):

3.3.5

TC rev. hash/commit:

TrinityCore rev. 7dc97c035350+ 2017-10-21 16:42:07 +0200 (3.3.5 branch) (Unix, RelWithDebInfo, Static) (worldserver-daemon)

TDB version: 335.63

Suggested Fix:

SET @BASE_GUID      := XXX;  -- needs a new set of gameobject GUIDs

-- Pumpkins on Solliden Farmstead
DELETE FROM `gameobject` WHERE `id`='375' AND `guid` BETWEEN @BASE_GUID + 1 AND @BASE_GUID + 24;
INSERT INTO `gameobject` (`guid`, `id`, `position_x`, `position_y`, `position_z`, `spawntimesecs`, `animprogress`, `state`) VALUES
(@BASE_GUID + 01, '375', '2265.21', '1353.34', '33.3335', '120', '100', '1'),
(@BASE_GUID + 02, '375', '2276.71', '1363.19', '33.3335', '120', '100', '1'),
(@BASE_GUID + 03, '375', '2301.16', '1352.07', '33.3335', '120', '100', '1'),
(@BASE_GUID + 04, '375', '2304.09', '1348.45', '33.3335', '120', '100', '1'),
(@BASE_GUID + 05, '375', '2304.79', '1357.5', '33.3335', '120', '100', '1'),
(@BASE_GUID + 06, '375', '2342.34', '1343.97', '33.3335', '120', '100', '1'),
(@BASE_GUID + 07, '375', '2341.84', '1352.81', '33.3335', '120', '100', '1'),
(@BASE_GUID + 08, '375', '2362.78', '1349.04', '33.3335', '120', '100', '1'),
(@BASE_GUID + 09, '375', '2329.86', '1378.49', '33.3334', '120', '100', '1'),
(@BASE_GUID + 10, '375', '2318.9', '1398.46', '33.3334', '120', '100', '1'),
(@BASE_GUID + 11, '375', '2297.55', '1396.03', '33.3334', '120', '100', '1'),
(@BASE_GUID + 12, '375', '2268.6', '1403.73', '33.3334', '120', '100', '1'),
(@BASE_GUID + 13, '375', '2288', '1419.8', '33.3334', '120', '100', '1'),
(@BASE_GUID + 14, '375', '2296.25', '1477.43', '33.3346', '120', '100', '1'),
(@BASE_GUID + 15, '375', '2304.77', '1478.21', '33.3346', '120', '100', '1'),
(@BASE_GUID + 16, '375', '2304.38', '1471.24', '33.3346', '120', '100', '1'),
(@BASE_GUID + 17, '375', '2333.35', '1478.41', '33.3346', '120', '100', '1'),
(@BASE_GUID + 18, '375', '2340.2', '1485.36', '33.4198', '120', '100', '1'),
(@BASE_GUID + 19, '375', '2362.11', '1474.81', '33.3333', '120', '100', '1'),
(@BASE_GUID + 20, '375', '2337.4', '1446.72', '33.3333', '120', '100', '1'),
(@BASE_GUID + 21, '375', '2332.24', '1452.42', '33.3333', '120', '100', '1'),
(@BASE_GUID + 22, '375', '2337.7', '1453.62', '33.3333', '120', '100', '1'),
(@BASE_GUID + 23, '375', '2298.52', '1444.32', '33.3319', '120', '100', '1'),
(@BASE_GUID + 24, '375', '2316.99', '1412.93', '33.3336', '120', '100', '1');

(Coords are not sniffed)

[offl]

https://github.com/unified-db/Database/commit/5caafd7a0cb9b56755e3617b39f450828de6a389
Maybe it's better. Or you can use data from cata(if it is valid for wotlk):
```sql
(@OGUID+11, 375, 0, 1, 1, 2419.358, 1592.696, 33.33333, 2.460913, 0, 0, 0, 1, 120, 255, 1), -- Tirisfal Pumpkin (Area: Scarlet Palisade)
(@OGUID+14, 375, 0, 1, 1, 2420.788, 1561.377, 32.8722, 3.612838, 0, 0, 0, 1, 120, 255, 1), -- Tirisfal Pumpkin (Area: Whispering Shore)
(@OGUID+32, 375, 0, 1, 1, 2279.658, 1452.858, 33.33333, 4.537859, 0, 0, 0, 1, 120, 255, 1), -- Tirisfal Pumpkin (Area: Scarlet Palisade)
(@OGUID+33, 375, 0, 1, 1, 2355.79, 1361.571, 33.33335, 3.246347, 0, 0, 0, 1, 120, 255, 1), -- Tirisfal Pumpkin (Area: Solliden Farmstead)
(@OGUID+34, 375, 0, 1, 1, 2363.505, 1372.347, 33.33333, 5.742135, 0, 0, 0, 1, 120, 255, 1), -- Tirisfal Pumpkin (Area: Solliden Farmstead)
(@OGUID+35, 375, 0, 1, 1, 2320.674, 1379.951, 33.33333, 2.268925, 0, 0, 0, 1, 120, 255, 1), -- Tirisfal Pumpkin (Area: Solliden Farmstead)
(@OGUID+52, 375, 0, 1, 1, 2342.479, 1352.68, 33.43334, 5.742135, 0, 0, 0, 1, 120, 255, 1), -- Tirisfal Pumpkin (Area: Whispering Shore)
(@OGUID+56, 375, 0, 1, 1, 2260.245, 1258.646, 31.44211, 5.410522, 0, 0, 0, 1, 120, 255, 1), -- Tirisfal Pumpkin (Area: Deathknell)
(@OGUID+59, 375, 0, 1, 1, 2284.582, 1240.535, 31.44222, 1.989672, 0, 0, 0, 1, 120, 255, 1), -- Tirisfal Pumpkin (Area: Deathknell)
(@OGUID+86, 375, 0, 1, 1, 2283.877, 1177.057, 31.44223, 1.97222, 0, 0, 0, 1, 120, 255, 1), -- Tirisfal Pumpkin (Area: 0)

[Teppic1]

Where's the source that only 15 max should be spawned? When bmd (who did the research) looked he could find a lot of evidence with every patch in view having a pumpkin on it.

[Killyana]

I cannot find any video or photo except http://wow.zamimg.com/uploads/screenshots/normal/8863-tirisfal-pumpkin.jpg
If there's nothing else I will push:
``sql -- Tirisfal Pumpkin DELETE FROMgameobjectWHEREguidIN (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); DELETE FROMgameobject_addonWHEREguidIN (45042, 45043, 45157, 45194, 45195, 45196, 45197, 45198, 45200, 45201); DELETE FROMgameobjectWHEREid=375; INSERT INTOgameobject(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);

-- pools
-- should be spawned max 15 (31 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
(409, 379, 0, '375 - Tirisfal Pumpkin'),
(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');

[offl]

Where's the source that only 15 max should be spawned?

I saw only 13 in this video, and 2 should be spawned(according to Wowhead's map(at 32.0 46.7) at the place he didn't come to.
Another video.

Maybe only 10 or 12 or 14 should be spawned, but nobody will not test it because pools are the most unimplemented luxury for emulators.

[Killyana]

The map is no longer the same since cata.
The 2 spawns at 32.0 46.7 must probably be out of the pool.

[Serpaa]

If you compare this screenshot which shows all pumpkins spawned without a pool ...

... and this screenshot which is from a video that was made in 2009 (https://youtu.be/5CjYDkAUPy0?t=1m20s) you can see that there aren't as many pumpkins spawned. So a max 15 pumpkins pool might be the best approach.

[Teppic1]

Maybe his view distance is just set low? :) Who knew pumpkins could be so much fun.