RG Live WotLK 3.3.5a

convert to tc

guid script für einen der arbeiter adden
ansonsten ooc actionlists

-- Worker
UPDATE creature_template SET equipmentTemplateid = 53 WHERE entry = 18800;
UPDATE creature_template_addon SET bytes1 = 0 WHERE entry = 18800;
DELETE FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE id = 18800);
UPDATE creature SET equipment_id = 5 WHERE guid = 67155; -- only one has this equip.
-- waypoints
UPDATE creature SET spawndist = 0, MovementType = 2 WHERE guid IN (2351,3539,3540,4820,67156,67157,67158,67155);
DELETE FROM creature_movement WHERE id IN (2351,3539,3540,4820,67156,67157,67158,67155);
INSERT INTO creature_movement (id, point, position_x, position_y, position_z, waittime, script_id, orientation, model1, model2) VALUES
-- #2351
(2351,1,-4192.63,-11837.5,-132.695, 180000, 1880001, 5.23599, 0, 0),
(2351,2,-4192.63,-11837.5,-132.695, 8000, 0, 5.23599, 0, 0),
-- #3539
(3539,1,-4106.37,-11757.8,-139.79, 180000, 1880001, 4.53786, 0, 0),
(3539,2,-4106.37,-11757.8,-139.79, 5000, 0, 4.53786, 0, 0),
-- #3540
(3540,1,-3946.41,-11857.7,0.952798, 180000, 1880001, 0.436332, 0, 0),
(3540,2,-3946.41,-11857.7,0.952798, 5000, 0, 0.436332, 0, 0),
-- #4820
(4820,1,-4199.36,-11720,-143.02, 6000, 0, 3.41889, 0, 0),
(4820,2,-4199.36,-11720,-143.02, 180000, 1880002, 3.41889, 0, 0),
-- #67156
(67156,1,-4205.64,-11733.8,-132.205, 180000, 1880001, 1.97222, 0, 0),
(67156,2,-4205.64,-11733.8,-132.205, 5000, 0, 1.97222, 0, 0),
-- #67157
(67157,1,-4283.24,-11653.3,-142.454, 6000, 0, 1.97222, 0, 0),
(67157,2,-4283.24,-11653.3,-142.454, 180000, 1880002, 1.97222, 0, 0),
-- #67158
(67158,1,-3919.31,-11862.6,1.865, 6000, 0, 1.65806, 0, 0),
(67158,2,-3919.31,-11862.6,1.865, 180000, 1880002, 1.65806, 0, 0),
-- #67155
(67155,1,-4039.73,-11519.2,-141.385, 0, 0,4.23571, 0, 0),
(67155,2,-4043.24,-11529.9,-138.291, 0, 0,5.24729, 0, 0),
(67155,3,-4030.91,-11548.1,-138.214, 0, 0,4.908, 0, 0),
(67155,4,-4030.44,-11553.5,-138.23, 0, 0,4.5263, 0, 0),
(67155,5,-4037.56,-11565.6,-138.359, 0, 0,3.80845, 0, 0),
(67155,6,-4045.63,-11567,-138.459, 18000, 1880003,2.81021, 0, 0),
(67155,7,-4037.56,-11565.6,-138.36, 0, 0,0.684921, 0, 0),
(67155,8,-4030.32,-11553.4,-138.229, 0, 0,1.44833, 0, 0),
(67155,9,-4030.84,-11547.6,-138.211, 0, 0,2.00518, 0, 0),
(67155,10,-4043.02,-11530,-138.288, 0, 0,1.65699, 0, 0),
(67155,11,-4039.7,-11519.4,-141.384, 0, 0,1.25329, 0, 0),
(67155,12,-4020.26,-11485.7,-141.031, 0, 0,1.00982, 0, 0),
(67155,13,-4013.84,-11480.3,-137.389, 0, 0,0.621046, 0, 0),
(67155,14,-3964.9,-11439.4,-136.703, 0, 0,0.189862, 0, 0),
(67155,15,-3944,-11437.5,-135.611, 0, 0,0.0406364, 0, 0),
(67155,16,-3915.15,-11435.8,-132.892, 0, 0,0.0602713, 0, 0),
(67155,17,-3876.07,-11444.9,-132.561, 0, 0,6.00181, 0, 0),
(67155,18,-3840.76,-11457.2,-132.186, 0, 0,5.9272, 0, 0),
(67155,19,-3829.7,-11460.8,-138.548, 0, 0,5.97433, 0, 0),
(67155,20,-3796,-11472,-138.189, 0, 0,5.97432, 0, 0),
(67155,21,-3788.55,-11474.4,-134.564, 0, 0,5.97432, 0, 0),
(67155,22,-3769.14,-11480.8,-134.369, 12000, 1880004,5.97825, 0, 0),
(67155,23,-3788.23,-11474.6,-134.559, 0, 0,2.81482, 0, 0),
(67155,24,-3795.97,-11472,-138.19, 0, 0,2.81089, 0, 0),
(67155,25,-3829.94,-11460.8,-138.48, 0, 0,2.83446, 0, 0),
(67155,26,-3840.59,-11457.3,-132.185, 0, 0,2.78733, 0, 0),
(67155,27,-3875.72,-11445,-132.556, 0, 0,2.81089, 0, 0),
(67155,28,-3915.23,-11436,-132.892, 0, 0,3.22637, 0, 0),
(67155,29,-3943.23,-11437.5,-135.509, 0, 0,3.2193, 0, 0),
(67155,30,-3964.67,-11439.3,-136.699, 0, 0,3.5476, 0, 0),
(67155,31,-4013.47,-11480,-137.383, 0, 0,3.81451, 0, 0),
(67155,32,-4021.21,-11486.8,-141.045, 0, 0,3.88975, 0, 0);
DELETE FROM dbscripts_on_creature_movement WHERE id BETWEEN 1880001 AND 1880004;
INSERT INTO dbscripts_on_creature_movement (id, delay, command, datalong, datalong2, buddy_entry, search_radius, data_flags, dataint, dataint2, dataint3, dataint4, x, y, z, o, comments) VALUES
(1880001,1,1,233,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1880001,90,1,0,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1880001,95,28,8,0,0,0,0,0,0,0,0,0,0,0,0,'STATE_KNEEL'),
(1880001,180,28,0,0,0,0,0,0,0,0,0,0,0,0,0,'STATE_STAND'),
(1880002,1,28,8,0,0,0,0,0,0,0,0,0,0,0,0,'STATE_KNEEL'),
(1880002,90,28,0,0,0,0,0,0,0,0,0,0,0,0,0,'STATE_STAND'),
(1880002,95,1,233,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1880002,180,1,0,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1880003,2,1,6,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1880003,10,1,1,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1880004,2,1,1,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1880004,7,31,16731,50,0,0,0,0,0,0,0,0,0,0,0,'search for 16731'),
(1880004,8,1,1,0,16731,50,7,0,0,0,0,0,0,0,0,''),
(1880004,9,31,16731,50,0,0,0,0,0,0,0,0,0,0,0,'search for 16731'),
(1880004,10,1,273,0,16731,50,7,0,0,0,0,0,0,0,0,''),
(1880004,15,1,1,0,0,0,0,0,0,0,0,0,0,0,0,'');