DB/Event: Engineers' Explosive Extravaganza

Description:
The Engineers' Explosive Extravaganza was an event celebrated on or near July 4th on North American servers, corresponding with America's Independence Day. The Holiday Fireworks Vendors are associated with the Engineers' Explosive Extravaganza, not the Midsummer Fire Festival per se, though the Engineers' Explosive Extravaganza has been merged into the Midsummer Fire Festival on those realms.

The Engineers' Explosive Extravaganza is not celebrated on European servers, instead, on European realms, the Holiday Fireworks Vendors appear on Peon Day (which is in turn not celebrated on North American servers.)

DELETE FROM `creature` WHERE `guid` IN ();
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`,`spawndist`, `MovementType`) VALUES
(X, 8116, 0, 1, 1, 0, 0, -14474.5, 458.451, 37.0553, 1.828, 600, 0, 0),
(X, 8117, 0, 1, 1, 0, 0, -4891, -956, 501.465, 2.344, 600, 0, 0),
(X, 8118, 0, 1, 1, 0, 0, -8807.7295, 639.1821, 94.31201, 3.752457857131958007, 600, 0, 0), -- sniff 12340
(X, 8121, 1, 1, 1, 0, 0, -978.327, -3633.16, 19.1824, 5.38616, 600, 0, 0),
(X, 8122, 1, 1, 1, 0, 0, 2014.38, -4729.67, 26.1829, 1.2963, 600, 0, 0);

Branch(es): 3.3.5

TC rev. hash/commit: rev. 1e99f9832718

Start with the provided creature DELETE/INSERT SQL on the 3.3.5 branch, resolving the placeholder GUIDs and checking the surrounding database conventions for these entries. Confirm that the five Holiday Fireworks Vendors are present at the specified locations and that the resulting seasonal event data matches the North American server description.