-- Issue 9250
-- A Worthy Weapon (thx Durotar)
UPDATE `creature_template` SET `InhabitType`=4, `hoverheight`=1065353216, `AIName`='SmartAI', `ScriptName`='' WHERE `entry`=33273;
-- Set visual effect: sitting
DELETE FROM `creature_template_addon` WHERE `entry`=33273;
INSERT INTO `creature_template_addon` (`entry`,`bytes1`,`bytes2`,`emote`) VALUES (33273,1,1,0);
-- Winter Hyacinth (item 45000) Send Script Event (20990) by right-click
DELETE FROM `event_scripts` WHERE `id`=20990;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES
(20990, 0, 10, 33273, 42000, 4602.977, -1600.141, 156.7834, 0.7504916);
-- TEMP Drak'Mar Offering Ring
SET @ObjectGuid := 6068; -- set by TDB staff
DELETE FROM `gameobject` WHERE `id`=300009;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotatio n3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(@ObjectGuid+0,300009,571,1,1, 4606.72, -1606.91, 156.659, 1.62734,0.0,0.0, 0.726811, 0.686837,300,0,1),
(@ObjectGuid+1,300009,571,1,1, 4596.78, -1606.69, 156.659, 1.5488,0.0,0.0, 0.699286, 0.714842,300,0,1),
(@ObjectGuid+2,300009,571,1,1, 4597.1, -1594.08, 156.658, 1.53702,0.0,0.0, 0.695063, 0.718949,300,0,1),
(@ObjectGuid+3,300009,571,1,1, 4608.33, -1592.98, 156.658, 0.162569,0.0,0.0, 0.0811951, 0.996698,300,0,1),
(@ObjectGuid+4,300009,571,1,1, 4602.78, -1600.05, 156.658, 4.08564,0.0,0.0, 0.890651, -0.454688,300,0,1);
-- creature_text
DELETE FROM `creature_text` WHERE `entry`=33273 AND `groupid` BETWEEN 0 AND 3;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
(33273,0,0, 'Are those winter hyacinths? For me?',12,0,100,6,0,0, 'Maiden of Drak''Mar'),
(33273,1,0, 'It''s been so long since a traveler has come here bearing flowers.',12,0,100,1,0,0, 'Maiden of Drak''Mar'),
(33273,2,0, 'The lake has been too lonely these past years. The travelers stopped coming and evil came to these waters.',12,0,100,1,0,0, 'Maiden of Drak''Mar'),
(33273,3,0, 'Your gift is a rare kindness, traveler. Please take this blade with my gratitude. Long ago, another traveler left it here, but I have little use for it.',12,0,100,1,0,0, 'Maiden of Drak''Mar');
-- SAI
DELETE FROM `smart_scripts` WHERE `entryorguid`=33273 AND `source_type`=0 AND `id`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=33273*100 AND `source_type`=9 AND `id` BETWEEN 0 AND 6;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_p aram3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_ type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(33273,0,0,0,54,0,100,0,0,0,0,0,80,33273*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Maiden of DrakMar - On spawn - Run script'),
(33273*100,9,0,0,0,0,100,0,0,0,0,0,50,194239,42000,0,0,0,0,8,0,0,0,4602.977,-1600.141,156.7834,0, 'Maiden of DrakMar - On script - Summon GO DrakMar Lily Pad'),
(33273*100,9,1,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Maiden of DrakMar - On script - Say 0'),
(33273*100,9,2,0,0,0,100,0,5000,5000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Maiden of DrakMar - On script - Say 1'),
(33273*100,9,3,0,0,0,100,0,6000,6000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Maiden of DrakMar - On script - Say 2'),
(33273*100,9,4,0,0,0,100,0,7000,7000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Maiden of DrakMar - On script - Say 3'),
(33273*100,9,5,0,0,0,100,0,0,0,0,0,50,194238,20000,0,0,0,0,8,0,0,0,4603.351,-1599.288,156.8822,2.234018, 'Maiden of DrakMar - On script - Summon GO Blade of DrakMar');

[Err] 1062 - Duplicate entry '6068' for key 'PRIMARY'
[Err] INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotatio n3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(@ObjectGuid+0,300009,571,1,1, 4606.72, -1606.91, 156.659, 1.62734,0.0,0.0, 0.726811, 0.686837,300,0,1),
(@ObjectGuid+1,300009,571,1,1, 4596.78, -1606.69, 156.659, 1.5488,0.0,0.0, 0.699286, 0.714842,300,0,1),
(@ObjectGuid+2,300009,571,1,1, 4597.1, -1594.08, 156.658, 1.53702,0.0,0.0, 0.695063, 0.718949,300,0,1),
(@ObjectGuid+3,300009,571,1,1, 4608.33, -1592.98, 156.658, 0.162569,0.0,0.0, 0.0811951, 0.996698,300,0,1),
(@ObjectGuid+4,300009,571,1,1, 4602.78, -1600.05, 156.658, 4.08564,0.0,0.0, 0.890651, -0.454688,300,0,1);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

SET @GUID := 40470;
SET @PATH := @GUID*10;
DELETE FROM `creature` where `id`=18686;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES  
(@GUID,18686,530,1,1,0,0,-2847.327,3195.10722,7.4167,.0910940,300,0,0,9144,13525,2,0,0,0);
-- Pathing Data
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`) VALUES  
(@PATH,1,-2843.86,3205.97,5.45323,0,0,0,0,100),
(@PATH,2,-2829.24,3218.81,9.59048,0,0,0,0,100),
(@PATH,3,-2814.12,3235.72,10.1736,0,0,0,0,100),
(@PATH,4,-2792.54,3259.91,5.91885,0,0,0,0,100),
(@PATH,5,-2774.46,3280.17,2.8828,0,0,0,0,100),
(@PATH,6,-2751.21,3306.24,0.199384,0,0,0,0,100),
(@PATH,7,-2728.55,3318.21,-0.833018,0,0,0,0,100),
(@PATH,8,-2719.59,3331.35,-1.04936,0,0,0,0,100),
(@PATH,9,-2708.94,3349.74,-0.819842,0,0,0,0,100),
(@PATH,10,-2694.72,3374.29,-0.156626,0,0,0,0,100),
(@PATH,11,-2685.08,3390.93,0.328583,0,0,0,0,100),
(@PATH,12,-2675.69,3407.16,0.474826,0,0,0,0,100),
(@PATH,13,-2669.68,3416.29,0.743526,0,0,0,0,100),
(@PATH,14,-2660.96,3425.20,0.805554,0,0,0,0,100),
(@PATH,15,-2654.25,3430.82,0.77502,0,0,0,0,100),
(@PATH,16,-2645.46,3437.83,1.28666,0,0,0,0,100),
(@PATH,17,-2639.59,3442.50,3.25542,0,0,0,0,100),
(@PATH,18,-2630.71,3449.41,1.86245,0,0,0,0,100),
(@PATH,19,-2621.54,3456.21,0.653284,0,0,0,0,100),
(@PATH,20,-2617.41,3460.51,0.593326,0,0,0,0,100),
(@PATH,21,-2611.50,3471.52,0.520041,0,0,0,0,100),
(@PATH,22,-2610.04,3475.69,0.53993,0,0,0,0,100),
(@PATH,23,-2606.90,3480.85,0.492544,0,0,0,0,100),
(@PATH,24,-2590.41,3502.84,0.225892,0,0,0,0,100),
(@PATH,25,-2582.03,3512.00,0.101641,0,0,0,0,100),
(@PATH,26,-2566.36,3522.06,0.189451,0,0,0,0,100),
(@PATH,27,-2534.38,3523.07,1.3404,0,0,0,0,100),
(@PATH,28,-2523.33,3527.83,1.66667,0,0,0,0,100),
(@PATH,29,-2516.31,3533.95,1.65006,0,0,0,0,100),
(@PATH,30,-2507.47,3544.67,1.56155,0,0,0,0,100),
(@PATH,31,-2491.83,3549.68,1.43199,0,0,0,0,100),
(@PATH,32,-2471.56,3551.98,1.23732,0,0,0,0,100),
(@PATH,33,-2463.14,3555.66,1.03546,0,0,0,0,100),
(@PATH,34,-2456.30,3555.25,0.942503,0,0,0,0,100),
(@PATH,35,-2452.53,3537.02,0.402467,0,0,0,0,100),
(@PATH,36,-2446.32,3528.59,-0.236494,0,0,0,0,100),
(@PATH,37,-2462.93,3549.41,1.08819,0,0,0,0,100),
(@PATH,38,-2460.92,3557.50,1.00403,0,0,0,0,100),
(@PATH,39,-2425.49,3596.20,0.274173,0,0,0,0,100),
(@PATH,40,-2405.20,3613.88,0.217946,0,0,0,0,100),
(@PATH,41,-2391.31,3632.83,0.792431,0,0,0,0,100),
(@PATH,42,-2383.97,3658.54,0.99065,0,0,0,0,100),
(@PATH,43,-2351.54,3700.72,0.420721,0,0,0,0,100),
(@PATH,44,-2314.59,3729.83,0.0297019,0,0,0,0,100),
(@PATH,45,-2296.57,3749.89,0.363868,0,0,0,0,100),
(@PATH,46,-2285.44,3767.70,0.291327,0,0,0,0,100),
(@PATH,47,-2279.30,3787.95,0.314858,0,0,0,0,100),
(@PATH,48,-2276.30,3799.32,0.521091,0,0,0,0,100),
(@PATH,49,-2254.61,3831.13,2.70024,0,0,0,0,100),
(@PATH,50,-2251.75,3848.92,5.15061,0,0,0,0,100),
(@PATH,51,-2249.52,3869.55,2.39354,0,0,0,0,100),
(@PATH,52,-2244.66,3893.46,1.58335,0,0,0,0,100),
(@PATH,53,-2239.88,3904.19,1.10899,0,0,0,0,100),
(@PATH,54,-2224.28,3927.45,0.706091,0,0,0,0,100),
(@PATH,55,-2187.45,3958.22,0.921813,0,0,0,0,100),
(@PATH,56,-2175.09,3978.98,0.929392,0,0,0,0,100),
(@PATH,57,-2171.14,4011.04,0.450247,0,0,0,0,100),
(@PATH,58,-2175.93,4027.88,0.519539,0,0,0,0,100),
(@PATH,59,-2187.96,4064.43,1.42810,0,0,0,0,100),
(@PATH,60,-2166.44,4102.49,4.27243,0,0,0,0,100), -- Had guid as action_id
(@PATH,61,-1700.15,3993.57,55.6859,0,0,0,0,100),
(@PATH,62,-1710.59,4034.97,60.6101,0,0,0,0,100),
(@PATH,63,-1719.95,4059.83,62.7452,0,0,0,0,100),
(@PATH,64,-1718.67,4104.32,64.3796,0,0,0,0,100),
(@PATH,65,-1743.77,4151.60,62.3929,0,0,0,0,100),
(@PATH,66,-1754.61,4173.29,58.3691,0,0,0,0,100),
(@PATH,67,-1788.41,4206.51,44.1839,0,0,0,0,100),
(@PATH,68,-1818.93,4214.12,33.1137,0,0,0,0,100),
(@PATH,69,-1841.51,4228.10,22.0741,0,0,0,0,100),
(@PATH,70,-1871.54,4263.50,8.22153,0,0,0,0,100),
(@PATH,71,-1891.00,4295.91,3.23019,0,0,0,0,100),
(@PATH,72,-1911.96,4351.49,1.66825,0,0,0,0,100),
(@PATH,73,-1910.12,4389.42,1.77078,0,0,0,0,100),
(@PATH,74,-1907.67,4417.31,2.99456,0,0,0,0,100),
(@PATH,75,-1917.63,4452.07,6.27493,0,0,0,0,100),
(@PATH,76,-1929.40,4473.47,8.90937,0,0,0,0,100),
(@PATH,77,-1942.74,4489.67,11.1029,0,0,0,0,100),
(@PATH,78,-1958.47,4508.45,12.7432,0,0,0,0,100),
(@PATH,79,-1975.36,4519.94,13.1616,0,0,0,0,100),
(@PATH,80,-1982.19,4524.49,13.0993,0,0,0,0,100),
(@PATH,81,-1983.38,4507.03,12.7591,0,0,0,0,100),
(@PATH,82,-1984.02,4496.55,11.9535,0,0,0,0,100),
(@PATH,83,-1984.87,4482.57,11.1499,0,0,0,0,100),
(@PATH,84,-1978.92,4509.87,12.6695,0,0,0,0,100),
(@PATH,85,-1978.12,4527.35,13.36,0,0,0,0,100),
(@PATH,86,-1967.33,4546.79,12.8741,0,0,0,0,100),
(@PATH,87,-1953.04,4566.47,10.1123,0,0,0,0,100),
(@PATH,88,-1946.50,4582.91,7.44598,0,0,0,0,100),
(@PATH,89,-1948.30,4599.58,4.61956,0,0,0,0,100),
(@PATH,90,-1955.08,4637.48,-0.0588505,0,0,0,0,100),
(@PATH,91,-1943.63,4685.04,-2.18987,0,0,0,0,100),
(@PATH,92,-1941.99,4705.25,-2.67768,0,0,0,0,100),
(@PATH,93,-1945.22,4727.47,-3.22917,0,0,0,0,100),
(@PATH,94,-1951.89,4748.79,-2.9388,0,0,0,0,100),
(@PATH,95,-1957.77,4773.70,-1.42409,0,0,0,0,100),
(@PATH,96,-1957.36,4798.11,-0.0807409,0,0,0,0,100),
(@PATH,97,-1944.66,4829.17,0.67,0,0,0,0,100),
(@PATH,98,-1929.68,4851.09,1.64973,0,0,0,0,100),
(@PATH,99,-1918.23,4883.89,2.11937,0,0,0,0,100),
(@PATH,100,-1901.18,4906.49,-1.12705,0,0,0,0,100),
(@PATH,101,-1881.87,4926.69,-9.60835,0,0,0,0,100),
(@PATH,102,-1870.05,4946.21,-17.0149,0,0,0,0,100),
(@PATH,103,-1866.49,4960.25,-20.2899,0,0,0,0,100),
(@PATH,104,-1860.94,5033.3,-26.0991,0,0,0,0,100),
(@PATH,105,-1869.80,4962.46,-20.3781,0,0,0,0,100),
(@PATH,106,-1884.86,4924.67,-8.30171,0,0,0,0,100),
(@PATH,107,-1904.83,4905.16,-0.202733,0,0,0,0,100),
(@PATH,108,-1922.67,4912.5,6.06643,0,0,0,0,100),
(@PATH,109,-1937.46,4934.99,14.8054,0,0,0,0,100),
(@PATH,110,-1953.22,4961.69,24.7149,0,0,0,0,100),
(@PATH,111,-1958.07,4992.99,30.1767,0,0,0,0,100),
(@PATH,112,-1958.74,5013.42,32.4293,0,0,0,0,100),
(@PATH,113,-1947.03,5042.52,25.2899,0,0,0,0,100),
(@PATH,114,-1942.58,5058.03,19.5292,0,0,0,0,100),
(@PATH,115,-1963.32,5083.08,11.1075,0,0,0,0,100),
(@PATH,116,-1984.50,5100.08,7.82778,0,0,0,0,100),
(@PATH,117,-2004.59,5114.07,8.26657,0,0,0,0,100),
(@PATH,118,-2029.48,5123.26,8.48839,0,0,0,0,100),
(@PATH,119,-2055.94,5125.38,7.48301,0,0,0,0,100),
(@PATH,120,-2089.33,5115.44,3.14184,0,0,0,0,100),
(@PATH,121,-2112.53,5107.32,-2.40737,0,0,0,0,100),
(@PATH,122,-2137.40,5108.51,-11.5709,0,0,0,0,100),
(@PATH,123,-2155.69,5115.97,-18.1534,0,0,0,0,100),
(@PATH,124,-2170.60,5125.13,-21.2824,0,0,0,0,100),
(@PATH,125,-2182.81,5131.87,-21.667,0,0,0,0,100),
(@PATH,126,-2198.88,5138.77,-21.2323,0,0,0,0,100),
(@PATH,127,-2219.62,5144.57,-19.6848,0,0,0,0,100),
(@PATH,128,-2238.57,5146.29,-17.4706,0,0,0,0,100),
(@PATH,129,-2266.45,5144.26,-13.0598,0,0,0,0,100),
(@PATH,130,-2290.86,5142.23,-9.17377,0,0,0,0,100),
(@PATH,131,-2308.35,5142.09,-7.11532,0,0,0,0,100),
(@PATH,132,-2333.72,5149.44,-5.0165,0,0,0,0,100),
(@PATH,133,-2365.45,5157.88,-2.8501,0,0,0,0,100),
(@PATH,134,-2390.26,5158.22,-1.19618,0,0,0,0,100),
(@PATH,135,-2417.84,5153.35,0.775549,0,0,0,0,100),
(@PATH,136,-2442.28,5142.04,3.53141,0,0,0,0,100),
(@PATH,137,-2469.81,5120.56,6.76948,0,0,0,0,100),
(@PATH,138,-2498.06,5115.06,7.87731,0,0,0,0,100),
(@PATH,139,-2532.85,5118.89,7.54034,0,0,0,0,100),
(@PATH,140,-2555.60,5120.59,7.69492,0,0,0,0,100), -- GUID+1 as action_id
(@PATH,141,-2843.86,3205.97,5.45323,0,0,0,0,100);
-- Assign Path
DELETE FROM `creature_addon` WHERE `guid`=@GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES  
(@GUID,@PATH);

[Err] 1062 - Duplicate entry '40470' for key 'PRIMARY'
[Err] INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES  
(@GUID,18686,530,1,1,0,0,-2847.327,3195.10722,7.4167,.0910940,300,0,0,9144,13525,2,0,0,0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------