diff options
| -rw-r--r-- | sql/updates/world/master/2022_11_11_08_world_azshara_bilgewater_harbor.sql | 158 |
1 files changed, 158 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_11_11_08_world_azshara_bilgewater_harbor.sql b/sql/updates/world/master/2022_11_11_08_world_azshara_bilgewater_harbor.sql new file mode 100644 index 00000000000..0dbd25e1d46 --- /dev/null +++ b/sql/updates/world/master/2022_11_11_08_world_azshara_bilgewater_harbor.sql @@ -0,0 +1,158 @@ +SET @OGUID := 246288; + +-- Gameobject templates +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=46366 WHERE `entry`=208052; -- Cauldron Scale 1.5 +UPDATE `gameobject_template` SET `Data6`=0, `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=208140; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208140; -- Candy Bucket + +-- Quests +UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=28992; + +DELETE FROM `gameobject_queststarter` WHERE `id`=208140; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208140, 28992, 46366); + +DELETE FROM `gameobject_questender` WHERE (`id`=208140 AND `quest`=28992); +INSERT INTO `gameobject_questender` (`id`, `quest`, `VerifiedBuild`) VALUES +(208140, 28992, 46366); -- Candy Bucket ended by Candy Bucket + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208140; + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 226927 AND 226933; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 228857 AND 228916; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 226927 AND 226933; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 228857 AND 228916; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+61; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 180405, 1, 16, 4821, '0', 0, 0, 3599.34033203125, -6420.4130859375, 14.92302322387695312, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+1, 180405, 1, 16, 4821, '0', 0, 0, 3548.22314453125, -6503.57470703125, 43.47087478637695312, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+2, 180405, 1, 16, 4821, '0', 0, 0, 3477.62841796875, -6422.17041015625, 11.62490081787109375, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+3, 180405, 1, 16, 4821, '0', 0, 0, 3456.790771484375, -6492.19091796875, 20.23287582397460937, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+4, 180406, 1, 16, 4821, '0', 0, 0, 3545.248291015625, -6309.720703125, 0.754246532917022705, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+5, 180406, 1, 16, 4821, '0', 0, 0, 3585.451416015625, -6420.7431640625, 14.87507152557373046, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+6, 180406, 1, 16, 4821, '0', 0, 0, 3530.57470703125, -6494.9931640625, 41.09633636474609375, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+7, 180406, 1, 16, 4821, '0', 0, 0, 3469.37158203125, -6479.93603515625, 20.232879638671875, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+8, 180407, 1, 16, 5306, '0', 0, 0, 3581.736083984375, -6455.5556640625, 20.51021385192871093, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Hull of the Foebreaker - Difficulty: 0) +(@OGUID+9, 180407, 1, 16, 4821, '0', 0, 0, 3590.708251953125, -6535.205078125, 50.17335891723632812, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+10, 180407, 1, 16, 4821, '0', 0, 0, 3527.541748046875, -6504.8193359375, 43.47087478637695312, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+11, 180407, 1, 16, 4821, '0', 0, 0, 3504.713623046875, -6437.80908203125, 20.23289680480957031, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+12, 180407, 1, 16, 4821, '0', 0, 0, 3498.69189453125, -6397.4462890625, 11.49479198455810546, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+13, 180408, 1, 16, 4821, '0', 0, 0, 3548.197021484375, -6503.51904296875, 45.12577056884765625, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46366), -- G_WitchHat_01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+14, 180409, 1, 16, 4821, '0', 0, 0, 3549.6171875, -6502.83837890625, 40.99541091918945312, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 46366), -- G_WitchBroom_01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+15, 180410, 1, 16, 4821, '0', 0, 0, 3611.579833984375, -6481.05712890625, 22.14409446716308593, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+16, 180410, 1, 16, 4821, '0', 0, 0, 3540.2353515625, -6497.7119140625, 44.25957107543945312, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+17, 180411, 1, 16, 4821, '0', 0, 0, 3605.146728515625, -6439.40625, 14.89805984497070312, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+18, 180411, 1, 16, 4821, '0', 0, 0, 3537.615478515625, -6509.01220703125, 45.89495468139648437, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+19, 180415, 1, 16, 4821, '0', 0, 0, 3538.8125, -6498.97216796875, 42.63893890380859375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+20, 180415, 1, 16, 4821, '0', 0, 0, 3537.001708984375, -6510.21728515625, 43.47087478637695312, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+21, 180415, 1, 16, 4821, '0', 0, 0, 3537.717041015625, -6503.58837890625, 43.47087478637695312, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46366), -- CandleBlack01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+22, 180415, 1, 16, 4821, '0', 0, 0, 3537.509521484375, -6499.94775390625, 43.48051834106445312, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+23, 180415, 1, 16, 4821, '0', 0, 0, 3542.724853515625, -6503.68408203125, 43.47087478637695312, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 46366), -- CandleBlack01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+24, 180415, 1, 16, 4821, '0', 0, 0, 3527.03125, -6503.35791015625, 43.47087478637695312, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 46366), -- CandleBlack01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+25, 180415, 1, 16, 4821, '0', 0, 0, 3531.671875, -6498.80224609375, 42.65270233154296875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+26, 180415, 1, 16, 4821, '0', 0, 0, 3532.846435546875, -6509.93408203125, 43.47087478637695312, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+27, 180415, 1, 16, 4821, '0', 0, 0, 3532.704833984375, -6499.908203125, 43.47087478637695312, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+28, 180415, 1, 16, 4821, '0', 0, 0, 3532.538330078125, -6503.25, 43.47087478637695312, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+29, 180426, 1, 16, 4821, '0', 0, 0, 3535.37060546875, -6459.77978515625, 49.21615982055664062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+30, 180426, 1, 16, 4821, '0', 0, 0, 3534.372314453125, -6451.6337890625, 45.64139175415039062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+31, 180426, 1, 16, 4821, '0', 0, 0, 3532.6572265625, -6457.234375, 47.92422866821289062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+32, 180427, 1, 16, 4821, '0', 0, 0, 3534.471435546875, -6458.328125, 48.42770767211914062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+33, 180427, 1, 16, 4821, '0', 0, 0, 3535.818603515625, -6455.626953125, 47.23282241821289062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+34, 180427, 1, 16, 4821, '0', 0, 0, 3532.8759765625, -6459.48095703125, 48.96438980102539062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+35, 180427, 1, 16, 4821, '0', 0, 0, 3532.796142578125, -6458.796875, 48.59543228149414062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+36, 180431, 1, 16, 4821, '0', 0, 0, 3544.982666015625, -6446.42724609375, 37.49847412109375, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 46366), -- G_Pumpkin_01 scale 4.0 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+37, 180471, 1, 16, 4821, '0', 0, 0, 3531.822998046875, -6522.60791015625, 48.52970123291015625, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+38, 180471, 1, 16, 4821, '0', 0, 0, 3524.799560546875, -6529.93603515625, 49.48054122924804687, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+39, 180471, 1, 16, 4821, '0', 0, 0, 3527.7587890625, -6522.296875, 44.85824203491210937, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+40, 180471, 1, 16, 4821, '0', 0, 0, 3524.9775390625, -6504.361328125, 49.36654281616210937, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+41, 180471, 1, 16, 4821, '0', 0, 0, 3525.4296875, -6524.75537109375, 59.87563705444335937, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+42, 180471, 1, 16, 4821, '0', 0, 0, 3518.7353515625, -6509.13720703125, 59.95137405395507812, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+43, 180471, 1, 16, 4821, '0', 0, 0, 3512.2822265625, -6503.97412109375, 49.35243606567382812, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+44, 180471, 1, 16, 4821, '0', 0, 0, 3528.658935546875, -6522.5068359375, 45.69745635986328125, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+45, 180471, 1, 16, 4821, '0', 0, 0, 3530.73095703125, -6522.51025390625, 47.54932403564453125, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+46, 180471, 1, 16, 4821, '0', 0, 0, 3518.3369140625, -6504.1875, 49.15529251098632812, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+47, 180471, 1, 16, 4821, '0', 0, 0, 3529.694580078125, -6522.3974609375, 46.61844635009765625, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+48, 180471, 1, 16, 4821, '0', 0, 0, 3525.845458984375, -6509.44091796875, 60.02410888671875, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+49, 180471, 1, 16, 4821, '0', 0, 0, 3512.150146484375, -6508.88916015625, 60.2926177978515625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+50, 180471, 1, 16, 4821, '0', 0, 0, 3511.556396484375, -6529.470703125, 49.45423507690429687, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+51, 180471, 1, 16, 4821, '0', 0, 0, 3511.74658203125, -6524.17041015625, 60.11174774169921875, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+52, 180471, 1, 16, 4821, '0', 0, 0, 3517.716064453125, -6529.6630859375, 49.09471893310546875, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+53, 180471, 1, 16, 4821, '0', 0, 0, 3518.346435546875, -6524.31103515625, 59.93560028076171875, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+54, 180472, 1, 16, 4821, '0', 0, 0, 3447.723876953125, -6497.00537109375, 25.28648757934570312, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+55, 180472, 1, 16, 4821, '0', 0, 0, 3449.470458984375, -6576.439453125, 63.68678665161132812, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+56, 180523, 1, 16, 4821, '0', 0, 0, 3530.14501953125, -6523.89599609375, 43.84289932250976562, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Apple Bob (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+57, 185434, 1, 16, 4821, '0', 0, 0, 3548.732666015625, -6502.205078125, 42.34893417358398437, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 46366), -- Sitting Skeleton 01 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+58, 185436, 1, 16, 4821, '0', 0, 0, 3547.78466796875, -6502.44775390625, 42.15895462036132812, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46366), -- Sitting Skeleton 03 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+59, 185454, 1, 16, 4821, '0', 0, 0, 3548.06591796875, -6500.90087890625, 40.96922683715820312, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 46366), -- Laying Skeleton 02 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+60, 208052, 1, 16, 4821, '0', 0, 0, 3548.09716796875, -6501.85595703125, 41.05363845825195312, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 46366), -- Cauldron Scale 1.5 (Area: Bilgewater Harbor - Difficulty: 0) +(@OGUID+61, 208140, 1, 16, 4821, '0', 0, 0, 3536.690185546875, -6522.09033203125, 43.48497390747070312, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 46366); -- Candy Bucket (Area: Bilgewater Harbor - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+61; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(12, @OGUID+0), +(12, @OGUID+1), +(12, @OGUID+2), +(12, @OGUID+3), +(12, @OGUID+4), +(12, @OGUID+5), +(12, @OGUID+6), +(12, @OGUID+7), +(12, @OGUID+8), +(12, @OGUID+9), +(12, @OGUID+10), +(12, @OGUID+11), +(12, @OGUID+12), +(12, @OGUID+13), +(12, @OGUID+14), +(12, @OGUID+15), +(12, @OGUID+16), +(12, @OGUID+17), +(12, @OGUID+18), +(12, @OGUID+19), +(12, @OGUID+20), +(12, @OGUID+21), +(12, @OGUID+22), +(12, @OGUID+23), +(12, @OGUID+24), +(12, @OGUID+25), +(12, @OGUID+26), +(12, @OGUID+27), +(12, @OGUID+28), +(12, @OGUID+29), +(12, @OGUID+30), +(12, @OGUID+31), +(12, @OGUID+32), +(12, @OGUID+33), +(12, @OGUID+34), +(12, @OGUID+35), +(12, @OGUID+36), +(12, @OGUID+37), +(12, @OGUID+38), +(12, @OGUID+39), +(12, @OGUID+40), +(12, @OGUID+41), +(12, @OGUID+42), +(12, @OGUID+43), +(12, @OGUID+44), +(12, @OGUID+45), +(12, @OGUID+46), +(12, @OGUID+47), +(12, @OGUID+48), +(12, @OGUID+49), +(12, @OGUID+50), +(12, @OGUID+51), +(12, @OGUID+52), +(12, @OGUID+53), +(12, @OGUID+54), +(12, @OGUID+55), +(12, @OGUID+56), +(12, @OGUID+57), +(12, @OGUID+58), +(12, @OGUID+59), +(12, @OGUID+60), +(12, @OGUID+61); |