-- Cleanup of spawned candy buckets. They needed to be replaced by individual candy bucket object as each is a 'quest giver' of different quest.

DELETE FROM `game_event_gameobject` WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id`=180412);
DELETE FROM `gameobject` WHERE `id`=180412;

-- Establish a new set of candy buckets to spawn world wide.
-- LIST:
-- Barrens, Ratchet 12396 (BOTH)
-- Silithus, Cenarion Hold 12401 (BOTH)
-- Winterspring, Everlook 12400 (BOTH)
-- Barrens, Camp Taurajo 12375 (H)
-- Desolace, Shadowprey Village 12381 (H)
-- Dustwallow Marsh, Brackenwall Village 12383 (H)
-- Mulgore, Bloodhoof Village 12362 (H)
-- Stonetalon Mountains, Sun Rock Retreat 12378 (H)
-- Thousand Needles, Freewind Post 12379 (H)
-- Dustwallow Marsh, Mudsprocket 12398 (BOTH)
-- Tanaris, Gadgetzan, 12399 (BOTH)
-- Ashenvale, Splintertree Post  12377 (H)
-- Barrens, The Crossroads 12374 (H)
-- Durotar, Razor Hill 12361 (H)
-- Feralas, Camp Mojache 12386 (H)
-- Orgrimmar, Valley of Strength 12366 (H)
-- Thunder Bluff, Lower Rise 12367 (H)
-- Blade's Edge Mountains, Mok'Nathal Village 12394 (H)
--  Hellfire Peninsula, Falcon Watch 12389 (H)
--  Hellfire Peninsula, Thrallmar 12388 (H)
--  Terokkar Forest, Stonebreaker Hold 12391 (H)
--  Blade's Edge Mountains, Evergrove 12406 (BOTH)
--  Netherstorm, The Stormspire 12408 (BOTH)
--  Zangarmarsh, Cenarion Refuge 12403 (BOTH)
--  Blade's Edge Mountains, Thunderlord Stronghold 12393 (H)
--  Nagrand, Garadar 12392 (H)
--  Shadowmoon Valley, Shadowmoon Village 12395 (H)
--  Zangarmarsh, Zabra'jin 12390 (H)
--  Netherstorm, Area 52 12407 (BOTH)
--  Shattrath City 12404 (2xBOTH)
--  Shadowmoon Valley, Aldor or Scryer Inn (2xBOTH) 12409
--  Eastern Plaguelands, Light's Hope Chapel 12402 (BOTH)
--  Arathi Highlands, Hammerfall 12380 (H)
--  Eversong Woods, Fairbreeze Village 12365 (H)
--  Ghostlands, Tranquillien 12373 (H)
--  Hinterlands, Revantusk Village 12387 (H)
--  Silvermoon, The Royal Exchange 12369 (H)
--  Stranglethorn Vale, Grom'gol Base Camp 12382 (H)
--  Tirisfal Glades, Brill 12363 (H)
--  Stranglethorn Vale, Booty Bay 12397 (BOTH)
--  Badlands, Kargath 12385 (H)
--  Eversong Woods, Falconwing Square 12364 (H)
--  Hillsbrad Foothills, Tarren Mill 12376 (H)
--  Silvermoon, The Bazaar 12370 (H)
--  Silverpine Forest, The Sepulcher 12371 (H)
--  Swamp of Sorrows, Stonard 12384 (H)
--  Undercity, The Trade Quarter 12368 (H)
--  Ashenvale, Astranaar 12345 (A)
--  Bloodmyst Isle, Blood Watch 12341 (A)
--  Darnassus, Craftsmen's Terrace 12334 (A)
--  Dustwallow Marsh, Theramore Isle 12349 (A)
--  Feralas, Feathermoon Stronghold 12350 (A)
--  Teldrassil, Dolanaar 12331 (A)
--  Azuremyst Isle, Azure Watch 12333 (A)
--  Darkshore, Auberdine 12338 (A)
--  Desolace, Nijel's Point 12348 (A)
--  Exodar, Seat of the Naaru 12337 (A)
--  Stonetalon Mountains, Stonetalon Peak 12347 (A)
--  Dun Morogh, Kharanos 12332 (A)
--  Elwynn Forest, Goldshire 12286 (A)
--  Hinterlands, Aerie Peak 12351 (A)
--  Loch Modan, Thelsamar 12339 (A)
--  Stormwind, The Trade District 12336 (A)
--  Wetlands, Menethil Harbor 12343 (A)
--  Duskwood, Darkshire 12344 (A)
--  Hillsbrad Foothills, Southshore 12346 (A)
--  Ironforge, The Commons 12335 (A)
--  Redridge Mountains, Lakeshire 12342 (A)
--  Westfall, Sentinel Hill 12340 (A)
--  Blade's Edge Mountains, Sylvanaar 12358 (A)
--  Hellfire Peninsula, Honor Hold 12352 (A)
--  Nagrand, Telaar 12357 (A)
--  Terokkar Forest, Allerian Stronghold 12356 (A)
--  Zangarmarsh, Telredor 12354 (A)
--  Blade's Edge Mountains, Toshley's Station 12359 (A)
--  Hellfire Peninsula, Temple of Telhamat 12353 (A)
--  Shadowmoon Valley, Wildhammer Stronghold 12360 (A)
--  Zangarmarsh, Orebor Harborage 12355 (A)

-- quest list
-- (12396 ,12401 ,12400 ,12375 ,12381 ,12383 ,12362 ,12378 ,12379 ,12398 ,12399 ,12377 ,12374 ,12361 ,12386 ,12366 ,12367 ,12394 ,12389 ,12388 ,12391 ,12406 ,12408 ,12403 ,12393 ,12392 ,12395 ,12390 ,12407 ,12404 ,12409 ,12402 ,12380 ,12365 ,12373 ,12387 ,12369 ,12382 ,12363 ,12397 ,12385 ,12364 ,12376 ,12370 ,12371 ,12384 ,12368 ,12345 ,12341 ,12334 ,12349 ,12350 ,12331 ,12333 ,12338 ,12348 ,12337 ,12347 ,12332 ,12286 ,12351 ,12339 ,12336 ,12343 ,12344 ,12346 ,12335 ,12342 ,12340 ,12358 ,12352 ,12357 ,12356 ,12354 ,12359 ,12353 ,12360 ,12355);

-- new objects -- USED entries 301XXX to avoid duplicates
DELETE FROM `gameobject_template` WHERE `displayId`=6404;
INSERT INTO `gameobject_template` (`entry` ,`type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES
('301001','2','6404','BarrensRatchet12396','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301002','2','6404','SilithusCenarionHold12401','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301003','2','6404','WinterspringEverlook12400','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301004','2','6404','BarrensCampTaurajo12375','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301005','2','6404','DesolaceShadowpreyVillage12381','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301006','2','6404','DustwallowMarshBrackenwallVillage12383' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301007','2','6404','MulgoreBloodhoofVillage12362','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301008','2','6404','StonetalonMountainsSunRockRetreat12378' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301009','2','6404','ThousandNeedlesFreewindPost12379' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301010','2','6404','DustwallowMarshMudsprocket12398','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301011','2','6404','TanarisGadgetzan12399' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301012','2','6404','AshenvaleSplintertreePost12377','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301013','2','6404','BarrensTheCrossroads12374','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301014','2','6404','DurotarRazorHill12361','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301015','2','6404','FeralasCampMojache12386','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301016','2','6404','OrgrimmarValleyofStrength12366'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301017','2','6404','ThunderBluffLowerRise12367'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301018','2','6404','BladesEdgeMountainsMokNathalVillage 12394'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301019','2','6404', 'HellfirePeninsulaFalconWatch12389'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301020','2','6404', 'HellfirePeninsulaThrallmar12388'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301021','2','6404', 'Terokkar ForestStonebreakerHold12391'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301022','2','6404', 'BladesEdgeMountainsEvergrove12406'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301023','2','6404', 'NetherstormTheStormspire12408'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301024','2','6404', 'ZangarmarshCenarionRefuge12403' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301025','2','6404', 'BladesEdgeMountainsThunderlordStronghold12393'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301026','2','6404', 'NagrandGaradar12392'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301027','2','6404', 'ShadowmoonValleyShadowmoonVillage12395' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301028','2','6404', 'ZangarmarshZabrajin12390'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301029','2','6404', 'NetherstormAre52a12407'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301030','2','6404', 'ShattrathCity12404'  ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301031','2','6404', 'ShadowmoonValleyAldororScryerInn12409' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301032','2','6404', 'EasternPlaguelandsLightsHopeChapel12402' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301033','2','6404', 'ArathiHighlandsHammerfall12380' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301034','2','6404', 'EversongWoodsFairbreezeVillage12365','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301035','2','6404', 'GhostlandsTranquillien12373','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301036','2','6404', 'HinterlandsRevantuskVillage12387','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301037','2','6404', 'Silvermoon,TheRoyalExchange12369' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301038','2','6404', 'StranglethornValeGromgolBaseCamp12382' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301039','2','6404', 'TirisfalGladesBrill12363' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301040','2','6404', 'StranglethornValeBootyBay12397' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301041','2','6404', 'BadlandsKargath12385','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301042','2','6404', 'EversongWoodsFalconwingSquare12364','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301043','2','6404', 'HillsbradFoothillsTarren Mill12376' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301044','2','6404', 'SilvermoonTheBazaar12370','','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301045','2','6404', 'SilverpineForestTheSepulcher12371' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301046','2','6404', 'SwampofSorrowsStonard12384' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301047','2','6404', 'UndercityTheTradeQuarter12368' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301048','2','6404', 'AshenvaleAstranaar12345' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301049','2','6404', 'BloodmystIsleBloodWatch12341' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301050','2','6404', 'DarnassusCraftsmensTerrace12334' ,'','','','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301051','2','6404', 'DustwallowMarshTheramoreIsle12349' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301052','2','6404', 'FeralasFeathermoonStronghold12350' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301053','2','6404', 'TeldrassilDolanaar12331' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301054','2','6404', 'AzuremystIsleAzureWatch12333' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301055','2','6404', 'DarkshoreAuberdine12338' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301056','2','6404', 'DesolaceNijelsPoint12348' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301057','2','6404', 'ExodarSeatoftheNaaru12337' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301058','2','6404', 'StonetalonMountainsStonetalonPeak12347' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301059','2','6404', 'DunMoroghKharanos12332' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301060','2','6404', 'ElwynnForestGoldshire12286' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301061','2','6404', 'HinterlandsAeriePeak12351' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301062','2','6404', 'Loch ModanThelsamar12339' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301063','2','6404', 'StormwindTheTradeDistrict12336' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301064','2','6404', 'WetlandsMenethilHarbor12343' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301065','2','6404', 'DuskwoodDarkshire12344' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301066','2','6404', 'HillsbradFoothillsSouthshore12346' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301067','2','6404', 'IronforgeTheCommons12335' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301068','2','6404', 'RedridgeMountainsLakeshire12342' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301069','2','6404', 'WestfallSentinelHill12340' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301070','2','6404', 'BladesEdgeMountainsSylvanaar12358' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301071','2','6404', 'HellfirePeninsulaHonorHold12352' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301072','2','6404', 'NagrandTelaar12357','','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301073','2','6404', 'TerokkarForestAllerianStronghold12356','','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301074','2','6404', 'ZangarmarshTelredor12354' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301075','2','6404', 'BladesEdgeMountainsToshleysStation12359' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301076','2','6404', 'HellfirePeninsulaTempleofTelhamat12353' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301077','2','6404', 'ShadowmoonValleyWildhammerStronghold12360' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',''),
('301078','2','6404', 'ZangarmarshOreborHarborage12355' ,'','','','0','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','');

-- bind existing object as questgivers
DELETE FROM `gameobject_questrelation` WHERE `quest` IN (12396 ,12401 ,12400 ,12375 ,12381 ,12383 ,12362 ,12378 ,12379 ,12398 ,12399 ,12377 ,12374 ,12361 ,12386 ,12366 ,12367 ,12394 ,12389 ,12388 ,12391 ,12406 ,12408 ,12403 ,12393 ,12392 ,12395 ,12390 ,12407 ,12404 ,12409 ,12402 ,12380 ,12365 ,12373 ,12387 ,12369 ,12382 ,12363 ,12397 ,12385 ,12364 ,12376 ,12370 ,12371 ,12384 ,12368 ,12345 ,12341 ,12334 ,12349 ,12350 ,12331 ,12333 ,12338 ,12348 ,12337 ,12347 ,12332 ,12286 ,12351 ,12339 ,12336 ,12343 ,12344 ,12346 ,12335 ,12342 ,12340 ,12358 ,12352 ,12357 ,12356 ,12354 ,12359 ,12353 ,12360 ,12355);
INSERT INTO `gameobject_questrelation` (`id`, `quest`) VALUES
('301001','12396' ),
('301002','12401' ),
('301003','12400' ),
('301004','12375' ),
('301005','12381' ),
('301006','12383' ),
('301007','12362' ),
('301008','12378' ),
('301009','12379' ),
('301010','12398' ),
('301011','12399' ),
('301012','12377' ),
('301013','12374' ),
('301014','12361' ),
('301015','12386' ),
('301016','12366' ),
('301017','12367' ),
('301018','12394' ),
('301019','12389' ),
('301020','12388' ),
('301021','12391' ),
('301022','12406' ),
('301023','12408' ),
('301024','12403' ),
('301025','12393' ),
('301026','12392' ),
('301027','12395' ),
('301028','12390' ),
('301029','12407' ),
('301030','12404' ),
('301031','12409' ),
('301032','12402' ),
('301033','12380' ),
('301034','12365' ),
('301035','12373' ),
('301036','12387' ),
('301037','12369' ),
('301038','12382' ),
('301039','12363' ),
('301040','12397' ),
('301041','12385' ),
('301042','12364' ),
('301043','12376' ),
('301044','12370' ),
('301045','12371' ),
('301046','12384' ),
('301047','12368' ),
('301048','12345' ),
('301049','12341' ),
('301050','12334' ),
('301051','12349' ),
('301052','12350' ),
('301053','12331' ),
('301054','12333' ),
('301055','12338' ),
('301056','12348' ),
('301057','12337' ),
('301058','12347' ),
('301059','12332' ),
('301060','12286' ),
('301061','12351' ),
('301062','12339' ),
('301063','12336' ),
('301064','12343' ),
('301065','12344' ),
('301066','12346' ),
('301067','12335' ),
('301068','12342' ),
('301069','12340' ),
('301070','12358' ),
('301071','12352' ),
('301072','12357' ),
('301073','12356' ),
('301074','12354' ),
('301075','12359' ),
('301076','12353' ),
('301077','12360' ),
('301078','12355' );

-- quest end
DELETE FROM `gameobject_involvedrelation` WHERE `quest` IN (12396 ,12401 ,12400 ,12375 ,12381 ,12383 ,12362 ,12378 ,12379 ,12398 ,12399 ,12377 ,12374 ,12361 ,12386 ,12366 ,12367 ,12394 ,12389 ,12388 ,12391 ,12406 ,12408 ,12403 ,12393 ,12392 ,12395 ,12390 ,12407 ,12404 ,12409 ,12402 ,12380 ,12365 ,12373 ,12387 ,12369 ,12382 ,12363 ,12397 ,12385 ,12364 ,12376 ,12370 ,12371 ,12384 ,12368 ,12345 ,12341 ,12334 ,12349 ,12350 ,12331 ,12333 ,12338 ,12348 ,12337 ,12347 ,12332 ,12286 ,12351 ,12339 ,12336 ,12343 ,12344 ,12346 ,12335 ,12342 ,12340 ,12358 ,12352 ,12357 ,12356 ,12354 ,12359 ,12353 ,12360 ,12355);
INSERT INTO `gameobject_involvedrelation` (`id`, `quest`) VALUES
('301001','12396' ),
('301002','12401' ),
('301003','12400' ),
('301004','12375' ),
('301005','12381' ),
('301006','12383' ),
('301007','12362' ),
('301008','12378' ),
('301009','12379' ),
('301010','12398' ),
('301011','12399' ),
('301012','12377' ),
('301013','12374' ),
('301014','12361' ),
('301015','12386' ),
('301016','12366' ),
('301017','12367' ),
('301018','12394' ),
('301019','12389' ),
('301020','12388' ),
('301021','12391' ),
('301022','12406' ),
('301023','12408' ),
('301024','12403' ),
('301025','12393' ),
('301026','12392' ),
('301027','12395' ),
('301028','12390' ),
('301029','12407' ),
('301030','12404' ),
('301031','12409' ),
('301032','12402' ),
('301033','12380' ),
('301034','12365' ),
('301035','12373' ),
('301036','12387' ),
('301037','12369' ),
('301038','12382' ),
('301039','12363' ),
('301040','12397' ),
('301041','12385' ),
('301042','12364' ),
('301043','12376' ),
('301044','12370' ),
('301045','12371' ),
('301046','12384' ),
('301047','12368' ),
('301048','12345' ),
('301049','12341' ),
('301050','12334' ),
('301051','12349' ),
('301052','12350' ),
('301053','12331' ),
('301054','12333' ),
('301055','12338' ),
('301056','12348' ),
('301057','12337' ),
('301058','12347' ),
('301059','12332' ),
('301060','12286' ),
('301061','12351' ),
('301062','12339' ),
('301063','12336' ),
('301064','12343' ),
('301065','12344' ),
('301066','12346' ),
('301067','12335' ),
('301068','12342' ),
('301069','12340' ),
('301070','12358' ),
('301071','12352' ),
('301072','12357' ),
('301073','12356' ),
('301074','12354' ),
('301075','12359' ),
('301076','12353' ),
('301077','12360' ),
('301078','12355' );

-- spawn candy buckets across realm
DELETE FROM `gameobject` WHERE (`id` > 301000 AND `id` < 301080);
INSERT INTO `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
('301059','0','1','1','-5585.13','-536.699','403.54','1.07236','0','0','0.510857','0.859666','25','0','1'),
('301053','1','1','1','9802.45','986','1313.86','5.10975','0','0','0.553632','-0.832761','25','0','1'),
('301058','1','1','1','2725.49','1512.28','236.82','4.69979','0','0','0.711546','-0.70264','25','0','1'),
('301052','1','1','1','-4380.21','3298.23','13.5478','0.0259254','0','0','0.0129623','0.999916','25','0','1'),
('301057','530','1','1','-3746.69','-11693','-105.859','3.14081','0','0','1','0.000391559','25','0','1'),
('301051','1','1','1','-3619.35','-4469.96','14.2454','0.945743','0','0','0.455445','0.890264','25','0','1'),
('301056','1','1','1','256.204','1246.79','192.145','2.85018','0','0','0.989404','0.145191','25','0','1'),
('301050','1','1','1','10126.5','2222.78','1329.46','2.25875','0','0','0.904144','0.427227','25','0','1'),
('301055','1','1','1','6414.58','516.866','8.65308','0.396575','0','0','0.196991','0.980405','25','0','1'),
('301049','530','1','1','-2062.3','-11895.8','45.7576','0.911054','0','0','0.439936','0.898029','25','0','1'),
('301054','530','1','1','-4128.74','-12472.5','44.08','3.27826','0','0','0.997666','-0.0682785','25','0','1'),
('301048','1','1','1','2781.62','-430.033','116.901','3.04258','0','0','0.998775','0.0494863','25','0','1'),
('301031','530','1','1','-2983.88','866.121','-7.54195','3.56564','0','0','0.977607','-0.210439','25','0','1'),
('301031','530','1','1','-4140.62','1124.16','44.5309','0.72721','0','0','0.355646','0.934621','25','0','1'),
('301024','530','1','1','-172.917','5526.42','29.4077','3.55475','0','0','0.978738','-0.205114','25','0','1'),
('301030','530','1','1','-1905.43','5770.44','131.213','0.0651376','0','0','0.032563','0.99947','25','0','1'),
('301030','530','1','1','-2185.48','5400.64','51.8829','0.810483','0','0','0.394241','0.919007','25','0','1'),
('301030','530','1','1','-1764.88','5162.59','-37.205','1.2291','0','0','0.576592','0.817032','25','0','1'),
('301023','530','1','1','4110.28','3064.24','339.465','5.26334','0','0','0.488109','-0.872783','25','0','1'),
('301029','530','1','1','3065.09','3704.91','142.478','4.35993','0','0','0.820124','-0.572186','25','0','1'),
('301022','530','1','1','3025.1','5431.82','146.617','2.18674','0','0','0.888179','0.459497','25','0','1'),
('301028','530','1','1','232.174','7934.82','25.0789','4.56085','0','0','0.758604','-0.651552','25','0','1'),
('301021','530','1','1','-2625.45','4449.3','36.0932','5.59592','0','0','0.336909','-0.941537','25','0','1'),
('301027','530','1','1','-2966.74','2566.16','78.1716','4.8812','0','0','0.644975','-0.764203','25','0','1'),
('301020','530','1','1','188.363','2609.96','87.2837','2.03927','0','0','0.851916','0.523678','25','0','1'),
('301026','530','1','1','-1232.8','7158.59','57.2647','2.63661','0','0','0.968293','0.249816','25','0','1'),
('301019','530','1','1','-581.426','4156.64','68.0841','4.1339','0','0','0.879419','-0.476048','25','0','1'),
('301025','530','1','1','2407.46','5951.07','152.216','1.76954','0','0','0.773771','0.633466','25','0','1'),
('301018','530','1','1','2221.16','4713.26','162.011','1.24111','0','0','0.581488','0.813555','25','0','1'),
('301047','0','1','1','1634.23','221.235','-43.1026','2.5315','0','0','0.953833','0.300337','25','0','1'),
('301039','0','1','1','2267.74','245.988','34.257','4.35285','0','0','0.822146','-0.569277','25','0','1'),
('301046','0','1','1','-10485.9','-3255.73','21.0302','6.01024','0','0','0.136049','-0.990702','25','0','1'),
('301038','0','1','1','-12431.3','215.705','2.36553','3.17181','0','0','0.999886','-0.0151081','25','0','1'),
('301045','0','1','1','513.578','1639.79','125.944','3.80542','0','0','0.94542','-0.325853','25','0','1'),
('301037','530','1','1','9686.76','-7364.39','11.93','4.643','0','0','0.731209','-0.682154','25','0','1'),
('301044','530','1','1','9571.12','-7224.61','16.1914','2.22924','0','0','0.897744','0.440517','25','0','1'),
('301036','0','1','1','-621.194','-4584.45','11.6872','5.44218','0','0','0.40822','-0.912884','25','0','1'),
('301043','0','1','1','-15.9769','-938.763','57.1723','1.70371','0','0','0.752503','0.658589','25','0','1'),
('301035','530','1','1','7557.78','-6899.1','96.0277','1.66791','0','0','0.740595','0.671951','25','0','1'),
('301042','530','1','1','9480.74','-6852.83','17.4082','4.09322','0','0','0.88892','-0.458063','25','0','1'),
('301034','530','1','1','8700.27','-6644.8','72.7445','6.1007','0','0','0.0911154','-0.99584','25','0','1'),
('301041','0','1','1','-6647.13','-2148.8','245.351','4.07496','0','0','0.893065','-0.449928','25','0','1'),
('301033','0','1','1','-909.082','-3528.32','72.606','3.05471','0','0','0.999056','0.0434301','25','0','1'),
('301040','0','1','1','-14456.6','499.587','15.1045','4.03261','0','0','0.902391','-0.430918','25','0','1'),
('301032','0','1','1','2299.16','-5346.78','90.88','2.05082','0','0','0.854928','0.518747','25','0','1'),
('301009','1','1','1','-5477.15','-2457.94','89.2837','0.493066','0','0','0.244043','0.969764','25','0','1'),
('301017','1','1','1','-1255.31','33.7664','128.187','2.52332','0','0','0.952597','0.304234','25','0','1'),
('301008','1','1','1','908.244','910.305','106.258','0.7673','0','0','0.374308','0.927305','25','0','1'),
('301007','1','1','1','-2355.47','-360.251','-8.95641','1.23291','0','0','0.578147','0.815932','25','0','1'),
('301015','1','1','1','-4441.67','244.946','39.1076','1.67822','0','0','0.744048','0.668126','25','0','1'),
('301006','1','1','1','-3165.58','-2903.35','35.6331','0.0448918','0','0','0.022444','0.999748','25','0','1'),
('301014','1','1','1','347.379','-4694.31','16.4584','3.01904','0','0','0.998123','0.0612385','25','0','1'),
('301005','1','1','1','-1585.88','3160.29','47.1301','4.10682','0','0','0.885784','-0.464098','25','0','1'),
('301013','1','1','1','-413.078','-2652.22','96.223','3.06773','0','0','0.999318','0.0369238','25','0','1'),
('301004','1','1','1','-2370.09','-1975.96','96.7049','6.02227','0','0','0.130088','-0.991503','25','0','1'),
('301012','1','1','1','2340.1','-2571.22','102.774','1.94853','0','0','0.827289','0.561777','25','0','1'),
('301003','1','1','1','6694.52','-4667.84','721.568','6.13593','0','0','0.0735625','-0.997291','25','0','1'),
('301011','1','1','1','-7149.36','-3840.93','8.78194','2.84376','0','0','0.988932','0.148369','25','0','1'),
('301002','1','1','1','-6867.17','737.088','45.6624','4.71859','0','0','0.704913','-0.709294','25','0','1'),
('301010','1','1','1','-4617.17','-3168.17','34.8094','4.82898','0','0','0.664707','-0.747105','25','0','1'),
('301001','1','1','1','-1047.72','-3661.99','23.8815','5.67368','0','0','0.300058','-0.953921','25','0','1'),
('301016','1','1','1','1632.69','-4445.18','15.4067','2.0789','0','0','0.862127','0.506693','25','0','1'),
('301066','0','1','1','-852.017','-579.298','11.6881','1.88671','0','0','0.809531','0.587077','25','0','1'),
('301065','0','1','1','-10512.5','-1160.6','28.1003','3.59984','0','0','0.973866','-0.227123','25','0','1'),
('301060','0','1','1','-9464.73','16.232','56.9623','1.59314','0','0','0.714961','0.699164','25','0','1'),
('301067','0','1','1','-4844.25','-861.417','501.914','4.55717','0','0','0.759802','-0.650154','25','0','1'),
('301061','0','1','1','396.159','-2123.49','131.565','0.828724','0','0','0.402606','0.915373','25','0','1'),
('301062','0','1','1','-5380.32','-2973.93','323.17','1.89468','0','0','0.811864','0.583846','25','0','1'),
('301068','0','1','1','-9226.17','-2160.01','63.7315','2.58035','0','0','0.960884','0.276951','25','0','1'),
('301063','0','1','1','-8865.25','675.375','97.9034','4.96957','0','0','0.610592','-0.791945','25','0','1'),
('301069','0','1','1','-10652.6','1168.39','34.4202','5.57277','0','0','0.347787','-0.937574','25','0','1'),
('301064','0','1','1','-3825.97','-835.421','10.0907','0.562646','0','0','0.277627','0.960689','25','0','1'),
('301070','530','1','1','2099.05','6901.94','183.23','3.88069','0','0','0.932491','-0.361193','25','0','1'),
('301075','530','1','1','1941.82','5536.23','267.801','1.3273','0','0','0.615997','0.787748','25','0','1'),
('301071','530','1','1','-706.479','2734.15','94.7334','4.80464','0','0','0.673751','-0.738959','25','0','1'),
('301076','530','1','1','224.522','4326.66','119.241','2.52855','0','0','0.953389','0.301745','25','0','1'),
('301072','530','1','1','-2752.75','7300.11','43.4705','0.619704','0','0','0.304918','0.952379','25','0','1'),
('301077','530','1','1','-4079.51','2183.99','107.504','5.39486','0','0','0.4297','-0.902972','25','0','1'),
('301073','530','1','1','-2919.72','4024.06','0.395236','3.99528','0','0','0.910277','-0.414001','25','0','1'),
('301078','530','1','1','1040.47','7381.6','39.5845','5.67924','0','0','0.297405','-0.954751','25','0','1'),
('301074','530','1','1','291.167','6096.6','132.139','3.44086','0','0','0.988826','-0.149077','25','0','1');

-- bind them to event 12
DELETE FROM `game_event_gameobject` WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE (`id` > 301000 AND `id` < 301079));
INSERT INTO `game_event_gameobject` (`guid`)
SELECT `guid`
FROM `gameobject`
WHERE (`id` > 301000 AND `id` < 301079);
UPDATE `game_event_gameobject` SET `event`=12 WHERE `event`=0;

-- handful of candy loot
DELETE FROM `item_loot_template` WHERE `entry`=37586;
INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES
('37586','37583','100','1','1','2','0','0','0'),
('37586','37585','66','2','1','2','0','0','0'),
('37586','37584','66','3','1','2','0','0','0'),
('37586','37582','66','4','1','2','0','0','0');

-- QUERY TO CHANGE BUCKET NAMES TO 'Candy Bucket'
UPDATE `gameobject_template` SET `name`='Candy Bucket' WHERE `displayId`=6404;