Hallows End Candy Buckets

public sql v1 · immutable
#1630716
·published 2009-10-19 21:07 UTC
-- 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 duplicatesDELETE 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 questgiversDELETE 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 endDELETE 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 realmDELETE 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 12DELETE 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 lootDELETE 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;