Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

[NPC-Waypoints] Lil Timmy #10802

Closed
drpepper2 opened this Issue Sep 13, 2013 · 4 comments

Comments

Projects
None yet
5 participants

Core: 458f5b9
TDB: 335.52

NPC: http://www.wowhead.com/npc=8666

What happens: Lil Timmy stay stationary.
What should happen: Lil Timmy is supposed to patrol around Stormwind with his white kitten

I can find the path he takes on Wowhead, maybe someone can point me in the right direction to make waypoints? That way I can help contribute too!

@ghost

ghost commented Sep 14, 2013

Confirmed.

Contributor

danlapps commented Mar 24, 2015

@Rushor is there a sniff for him available ? Trying to sniff on retail but damn hard to get him to spawn

Contributor

Rushor commented Mar 24, 2015

i have mangos datas at least which can be converted

-- Lil Timmy c.8666 - Stormwind
-- correct spawn point, spawntime, waypoints, despawn after path completed.
UPDATE creature SET position_x = -8634.505859, position_y = 918.960571, position_z = 99.354980, orientation = 3.832987, MovementType = 2, spawntimesecs = 5400 WHERE guid = 45501;
UPDATE creature_template SET MovementType = 2 WHERE entry = 8666;
DELETE FROM creature_movement_template WHERE entry = 8666;
INSERT INTO creature_movement_template (entry, point, position_x, position_y, position_z, waittime, script_id, textid1, textid2, textid3, textid4, textid5, emote, spell, wpguid, orientation, model1, model2) VALUES
(8666,1,-8641.4,912.342,99.1397,0,0,0,0,0,0,0,0,0,0,3.91152,0,0),
(8666,2,-8661.71,894.74,97.6239,0,0,0,0,0,0,0,0,0,0,3.80549,0,0),
(8666,3,-8679.15,880.967,97.0168,0,0,0,0,0,0,0,0,0,0,4.15342,0,0),
(8666,4,-8681.12,877.654,97.0168,0,0,0,0,0,0,0,0,0,0,4.75829,0,0),
(8666,5,-8679.29,873.082,97.0168,0,0,0,0,0,0,0,0,0,0,5.44708,0,0),
(8666,6,-8659.98,849.329,97.0168,0,0,0,0,0,0,0,0,0,0,5.40624,0,0),
(8666,7,-8639.96,825.073,96.6251,0,0,0,0,0,0,0,0,0,0,5.19026,0,0),
(8666,8,-8636.74,813.025,96.6486,0,0,0,0,0,0,0,0,0,0,4.75515,0,0),
(8666,9,-8634,793.001,96.6508,0,0,0,0,0,0,0,0,0,0,4.48104,0,0),
(8666,10,-8635.94,785.58,96.6515,0,0,0,0,0,0,0,0,0,0,4.15982,0,0),
(8666,11,-8651.43,775.162,96.6714,0,0,0,0,0,0,0,0,0,0,3.96116,0,0),
(8666,12,-8661.39,764.974,96.6998,0,0,0,0,0,0,0,0,0,0,4.49418,0,0),
(8666,13,-8662.58,758.134,96.6947,0,0,0,0,0,0,0,0,0,0,5.23402,0,0),
(8666,14,-8647.73,738.576,96.6965,0,0,0,0,0,0,0,0,0,0,5.65527,0,0),
(8666,15,-8630.74,726.606,96.7377,0,0,0,0,0,0,0,0,0,0,5.49741,0,0),
(8666,16,-8618.88,711.997,96.7248,0,0,0,0,0,0,0,0,0,0,5.71339,0,0),
(8666,17,-8614.67,709.545,96.7549,0,0,0,0,0,0,0,0,0,0,6.24353,0,0),
(8666,18,-8606.13,711.345,96.7382,0,0,0,0,0,0,0,0,0,0,0.438651,0,0),
(8666,19,-8598.07,712.945,96.6746,0,0,0,0,0,0,0,0,0,0,6.21386,0,0),
(8666,20,-8588.25,706.887,97.0168,0,0,0,0,0,0,0,0,0,0,5.36092,0,0),
(8666,21,-8566.09,678.512,97.0168,0,0,0,0,0,0,0,0,0,0,5.39783,0,0),
(8666,22,-8561.86,674.735,97.0168,0,0,0,0,0,0,0,0,0,0,0.0948142,0,0),
(8666,23,-8556.46,676.784,97.0168,0,0,0,0,0,0,0,0,0,0,0.591183,0,0),
(8666,24,-8542.79,686.774,97.6239,0,0,0,0,0,0,0,0,0,0,0.416825,0,0),
(8666,25,-8536.45,686.854,97.6775,0,0,0,0,0,0,0,0,0,0,6.02221,0,0),
(8666,26,-8531.64,683.194,98.4422,0,0,0,0,0,0,0,0,0,0,5.39861,0,0),
(8666,27,-8524.58,673.178,102.5,0,0,0,0,0,0,0,0,0,0,5.31143,0,0),
(8666,28,-8519.8,666.4,102.615,0,0,0,0,0,0,0,0,0,0,5.35855,0,0),
(8666,29,-8512.94,656.648,100.901,0,0,0,0,0,0,0,0,0,0,5.05539,0,0),
(8666,30,-8513.15,648.714,100.292,0,0,0,0,0,0,0,0,0,0,4.31398,0,0),
(8666,31,-8518.18,642.361,100.092,0,0,0,0,0,0,0,0,0,0,3.7587,0,0),
(8666,32,-8538.04,630.723,100.404,0,0,0,0,0,0,0,0,0,0,3.67624,0,0),
(8666,33,-8554.03,617.81,102.053,0,0,0,0,0,0,0,0,0,0,3.67702,0,0),
(8666,34,-8564.5,613.48,102.435,0,0,0,0,0,0,0,0,0,0,3.71158,0,0),
(8666,35,-8576.12,601.799,103.26,0,0,0,0,0,0,0,0,0,0,4.10978,0,0),
(8666,36,-8582.44,589.572,103.691,0,0,0,0,0,0,0,0,0,0,4.47655,0,0),
(8666,37,-8586.68,575.605,102.985,0,0,0,0,0,0,0,0,0,0,4.63756,0,0),
(8666,38,-8585.96,565.941,102.26,0,0,0,0,0,0,0,0,0,0,4.95957,0,0),
(8666,39,-8578.9,545.988,101.779,0,0,0,0,0,0,0,0,0,0,4.39958,0,0),
(8666,40,-8581.73,541.012,102.09,0,0,0,0,0,0,0,0,0,0,3.93698,0,0),
(8666,41,-8590.09,533.912,104.76,0,0,0,0,0,0,0,0,0,0,3.8286,0,0),
(8666,42,-8598.32,527.164,106.399,0,0,0,0,0,0,0,0,0,0,3.8286,0,0),
(8666,43,-8605.67,520.882,105.748,0,0,0,0,0,0,0,0,0,0,4.02573,0,0),
(8666,44,-8610.26,515.735,103.79,0,0,0,0,0,0,0,0,0,0,3.59062,0,0),
(8666,45,-8613.43,514.684,103.401,0,0,0,0,0,0,0,0,0,0,2.67406,0,0),
(8666,46,-8618.8,518.794,103.068,0,0,0,0,0,0,0,0,0,0,2.25388,0,0),
(8666,47,-8635.17,535.152,99.9833,0,0,0,0,0,0,0,0,0,0,2.34105,0,0),
(8666,48,-8647.39,546.721,97.8568,0,0,0,0,0,0,0,0,0,0,2.39603,0,0),
(8666,49,-8655.78,552.938,96.9435,0,0,0,0,0,0,0,0,0,0,2.89869,0,0),
(8666,50,-8671.86,552.874,97.2037,0,0,0,0,0,0,0,0,0,0,3.45946,0,0),
(8666,51,-8679.66,549.654,97.5031,0,0,0,0,0,0,0,0,0,0,3.70294,0,0),
(8666,52,-8689.63,540.268,97.828,0,0,0,0,0,0,0,0,0,0,3.98961,0,0),
(8666,53,-8698.98,530.295,97.7173,0,0,0,0,0,0,0,0,0,0,3.86394,0,0),
(8666,54,-8712.64,520.242,97.2398,0,0,0,0,0,0,0,0,0,0,3.1995,0,0),
(8666,55,-8715.24,521.571,97.4039,0,0,0,0,0,0,0,0,0,0,2.46279,0,0),
(8666,56,-8720.77,528.729,99.1496,0,0,0,0,0,0,0,0,0,0,2.24995,0,0),
(8666,57,-8729.84,539.87,101.105,0,0,0,0,0,0,0,0,0,0,2.2578,0,0),
(8666,58,-8735.95,547.101,100.845,0,0,0,0,0,0,0,0,0,0,2.31278,0,0),
(8666,59,-8745.79,557.737,97.7107,0,0,0,0,0,0,0,0,0,0,2.76831,0,0),
(8666,60,-8746.01,564.915,97.4001,0,0,0,0,0,0,0,0,0,0,1.0217,0,0),
(8666,61,-8729.92,581.294,97.6775,0,0,0,0,0,0,0,0,0,0,0.77273,0,0),
(8666,62,-8719.58,591.033,98.4713,0,0,0,0,0,0,0,0,0,0,0.505695,0,0),
(8666,63,-8712.04,594.001,98.6079,0,0,0,0,0,0,0,0,0,0,0.512763,0,0),
(8666,64,-8707.26,600.676,98.9982,0,0,0,0,0,0,0,0,0,0,1.19999,0,0),
(8666,65,-8704.46,616.407,100.215,0,0,0,0,0,0,0,0,0,0,1.62803,0,0),
(8666,66,-8705.6,629.078,100.477,0,0,0,0,0,0,0,0,0,0,1.78904,0,0),
(8666,67,-8708.67,645.787,99.9994,0,0,0,0,0,0,0,0,0,0,1.97518,0,0),
(8666,68,-8716.46,666.585,98.8681,0,0,0,0,0,0,0,0,0,0,2.08042,0,0),
(8666,69,-8724.09,676.482,98.6317,0,0,0,0,0,0,0,0,0,0,2.17781,0,0),
(8666,70,-8728.54,684.167,98.7324,0,0,0,0,0,0,0,0,0,0,2.09141,0,0),
(8666,71,-8733.47,695.151,98.723,0,0,0,0,0,0,0,0,0,0,2.11105,0,0),
(8666,72,-8743.6,709.876,98.2678,0,0,0,0,0,0,0,0,0,0,1.36492,0,0),
(8666,73,-8741.08,714.561,98.9815,0,0,0,0,0,0,0,0,0,0,0.788438,0,0),
(8666,74,-8734.46,720.119,101.647,0,0,0,0,0,0,0,0,0,0,0.685551,0,0),
(8666,75,-8726.79,726.231,100.924,0,0,0,0,0,0,0,0,0,0,0.740529,0,0),
(8666,76,-8718.09,733.687,97.9511,0,0,0,0,0,0,0,0,0,0,0.965938,0,0),
(8666,77,-8716.42,737.269,97.7782,0,0,0,0,0,0,0,0,0,0,1.56912,0,0),
(8666,78,-8721.01,746.752,97.9693,0,0,0,0,0,0,0,0,0,0,2.11262,0,0),
(8666,79,-8730.96,759.107,98.1572,0,0,0,0,0,0,0,0,0,0,1.95711,0,0),
(8666,80,-8731.99,769.385,98.0161,0,0,0,0,0,0,0,0,0,0,1.37435,0,0),
(8666,81,-8724.64,778.108,98.0604,0,0,0,0,0,0,0,0,0,0,0.868549,0,0),
(8666,82,-8717.55,792.762,97.1197,0,0,0,0,0,0,0,0,0,0,1.65081,0,0),
(8666,83,-8717.68,798.804,97.1792,0,0,0,0,0,0,0,0,0,0,1.9202,0,0),
(8666,84,-8728.3,817.744,96.9777,0,0,0,0,0,0,0,0,0,0,1.68929,0,0),
(8666,85,-8726.79,830.504,96.3102,0,0,0,0,0,0,0,0,0,0,1.37607,0,0),
(8666,86,-8723.42,841.35,96.0764,0,0,0,0,0,0,0,0,0,0,0.900908,0,0),
(8666,87,-8709.57,857.779,96.978,0,0,0,0,0,0,0,0,0,0,0.686494,0,0),
(8666,88,-8692.38,870.557,97.0284,0,0,0,0,0,0,0,0,0,0,0.645652,0,0),
(8666,89,-8679.35,880.974,97.0167,0,0,0,0,0,0,0,0,0,0,0.657433,0,0),
(8666,90,-8661.22,896.239,97.5968,0,0,0,0,0,0,0,0,0,0,0.7399,0,0),
(8666,91,-8643.7,912.233,98.9288,0,0,0,0,0,0,0,0,0,0,0.7399,0,0),
(8666,92,-8634.58,918.926,99.3551,2000,1,0,0,0,0,0,0,0,0,0.618163,0,0); -- desp. self
DELETE FROM creature_linking WHERE guid = 53705;
INSERT INTO creature_linking (guid, master_guid, flag) VALUES
(53705, 45501, 8832);
-- White Kitten - missing added
DELETE FROM creature WHERE guid = 53705;
INSERT INTO creature VALUES (53705,7386,0,1,1,0,0,-8634.01,919.46,99.36,3.88,180,0,0,42,0,0,0);

which can be converted

but yeah also tried to follow him on retail, but he didn't spawned for me

Member

Killyana commented Apr 4, 2015

-- Lil Timmy c.8666 - Stormwind
-- correct spawn point, spawntime, waypoints.
SET @GUID:= xxxxxx; -- 1 free guid set by tc
DELETE FROM `creature_formations` WHERE `leaderGUID`=45501;
INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`) VALUES
(45501,45501,0,0,2),
(45501,@GUID,2,0,2);
-- White Kitten - missing added
DELETE FROM `creature` WHERE `guid`=@GUID; 
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`, `spawndist`, `MovementType`) VALUES
(@GUID, 7386, 0, 1, 1, -8632.046875, 921.279480, 99.382813, 3.897803, 180, 42, 0, 0);

UPDATE `creature` SET `position_x` =-8634.505859, `position_y` = 918.960571, `position_z` = 99.354980, `orientation` = 3.832987, `MovementType` = 2, `spawntimesecs` = 5400 WHERE `guid` = 45501;
UPDATE `creature` SET `position_x` =-8583.879883 , `position_y` =633.127014 , `position_z` =96.338028 , `orientation` =4.989326  WHERE `guid` = 79816;
UPDATE `creature` SET `position_x` =-8582.030273 , `position_y` =633.633972 , `position_z` =96.338028 , `orientation` =4.989326  WHERE `guid` = 79815;
UPDATE `creature` SET `position_x` =-8580.509766 , `position_y` =635.107971 , `position_z` =96.338028 , `orientation` =4.989326  WHERE `guid` = 79817;

UPDATE `creature_template` SET `MovementType` = 2 WHERE `entry` = 8666;
DELETE FROM `creature_addon` WHERE `guid`=45501;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
(45501,86660,0,0,1,0,'');
DELETE FROM `waypoint_data` WHERE `id`=86660;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(86660,1,-8641.4,912.342,99.1397,0,0,0,0,100,0),
(86660,2,-8661.71,894.74,97.6239,0,0,0,0,100,0),
(86660,3,-8679.15,880.967,97.0168,0,0,0,0,100,0),
(86660,4,-8681.12,877.654,97.0168,0,0,0,0,100,0),
(86660,5,-8679.29,873.082,97.0168,0,0,0,0,100,0),
(86660,6,-8659.98,849.329,97.0168,0,0,0,0,100,0),
(86660,7,-8639.96,825.073,96.6251,0,0,0,0,100,0),
(86660,8,-8636.74,813.025,96.6486,0,0,0,0,100,0),
(86660,9,-8634,793.001,96.6508,0,0,0,0,100,0),
(86660,10,-8635.94,785.58,96.6515,0,0,0,0,100,0),
(86660,11,-8651.43,775.162,96.6714,0,0,0,0,100,0),
(86660,12,-8661.39,764.974,96.6998,0,0,0,0,100,0),
(86660,13,-8662.58,758.134,96.6947,0,0,0,0,100,0),
(86660,14,-8647.73,738.576,96.6965,0,0,0,0,100,0),
(86660,15,-8630.74,726.606,96.7377,0,0,0,0,100,0),
(86660,16,-8618.88,711.997,96.7248,0,0,0,0,100,0),
(86660,17,-8614.67,709.545,96.7549,0,0,0,0,100,0),
(86660,18,-8606.13,711.345,96.7382,0,0,0,0,100,0),
(86660,19,-8598.07,712.945,96.6746,0,0,0,0,100,0),
(86660,20,-8588.25,706.887,97.0168,0,0,0,0,100,0),
(86660,21,-8566.09,678.512,97.0168,0,0,0,0,100,0),
(86660,22,-8561.86,674.735,97.0168,0,0,0,0,100,0),
(86660,23,-8556.46,676.784,97.0168,0,0,0,0,100,0),
(86660,24,-8542.79,686.774,97.6239,0,0,0,0,100,0),
(86660,25,-8536.45,686.854,97.6775,0,0,0,0,100,0),
(86660,26,-8531.64,683.194,98.4422,0,0,0,0,100,0),
(86660,27,-8524.58,673.178,102.5,0,0,0,0,100,0),
(86660,28,-8519.8,666.4,102.615,0,0,0,0,100,0),
(86660,29,-8512.94,656.648,100.901,0,0,0,0,100,0),
(86660,30,-8513.15,648.714,100.292,0,0,0,0,100,0),
(86660,31,-8518.18,642.361,100.092,0,0,0,0,100,0),
(86660,32,-8538.04,630.723,100.404,0,0,0,0,100,0),
(86660,33,-8554.03,617.81,102.053,0,0,0,0,100,0),
(86660,34,-8564.5,613.48,102.435,0,0,0,0,100,0),
(86660,35,-8576.12,601.799,103.26,0,0,0,0,100,0),
(86660,36,-8582.44,589.572,103.691,0,0,0,0,100,0),
(86660,37,-8586.68,575.605,102.985,0,0,0,0,100,0),
(86660,38,-8585.96,565.941,102.26,0,0,0,0,100,0),
(86660,39,-8578.9,545.988,101.779,0,0,0,0,100,0),
(86660,40,-8581.73,541.012,102.09,0,0,0,0,100,0),
(86660,41,-8590.09,533.912,104.76,0,0,0,0,100,0),
(86660,42,-8598.32,527.164,106.399,0,0,0,0,100,0),
(86660,43,-8605.67,520.882,105.748,0,0,0,0,100,0),
(86660,44,-8610.26,515.735,103.79,0,0,0,0,100,0),
(86660,45,-8613.43,514.684,103.401,0,0,0,0,100,0),
(86660,46,-8618.8,518.794,103.068,0,0,0,0,100,0),
(86660,47,-8635.17,535.152,99.9833,0,0,0,0,100,0),
(86660,48,-8647.39,546.721,97.8568,0,0,0,0,100,0),
(86660,49,-8655.78,552.938,96.9435,0,0,0,0,100,0),
(86660,50,-8671.86,552.874,97.2037,0,0,0,0,100,0),
(86660,51,-8679.66,549.654,97.5031,0,0,0,0,100,0),
(86660,52,-8689.63,540.268,97.828,0,0,0,0,100,0),
(86660,53,-8698.98,530.295,97.7173,0,0,0,0,100,0),
(86660,54,-8712.64,520.242,97.2398,0,0,0,0,100,0),
(86660,55,-8715.24,521.571,97.4039,0,0,0,0,100,0),
(86660,56,-8720.77,528.729,99.1496,0,0,0,0,100,0),
(86660,57,-8729.84,539.87,101.105,0,0,0,0,100,0),
(86660,58,-8735.95,547.101,100.845,0,0,0,0,100,0),
(86660,59,-8745.79,557.737,97.7107,0,0,0,0,100,0),
(86660,60,-8746.01,564.915,97.4001,0,0,0,0,100,0),
(86660,61,-8729.92,581.294,97.6775,0,0,0,0,100,0),
(86660,62,-8719.58,591.033,98.4713,0,0,0,0,100,0),
(86660,63,-8712.04,594.001,98.6079,0,0,0,0,100,0),
(86660,64,-8707.26,600.676,98.9982,0,0,0,0,100,0),
(86660,65,-8704.46,616.407,100.215,0,0,0,0,100,0),
(86660,66,-8705.6,629.078,100.477,0,0,0,0,100,0),
(86660,67,-8708.67,645.787,99.9994,0,0,0,0,100,0),
(86660,68,-8716.46,666.585,98.8681,0,0,0,0,100,0),
(86660,69,-8724.09,676.482,98.6317,0,0,0,0,100,0),
(86660,70,-8728.54,684.167,98.7324,0,0,0,0,100,0),
(86660,71,-8733.47,695.151,98.723,0,0,0,0,100,0),
(86660,72,-8743.6,709.876,98.2678,0,0,0,0,100,0),
(86660,73,-8741.08,714.561,98.9815,0,0,0,0,100,0),
(86660,74,-8734.46,720.119,101.647,0,0,0,0,100,0),
(86660,75,-8726.79,726.231,100.924,0,0,0,0,100,0),
(86660,76,-8718.09,733.687,97.9511,0,0,0,0,100,0),
(86660,77,-8716.42,737.269,97.7782,0,0,0,0,100,0),
(86660,78,-8721.01,746.752,97.9693,0,0,0,0,100,0),
(86660,79,-8730.96,759.107,98.1572,0,0,0,0,100,0),
(86660,80,-8731.99,769.385,98.0161,0,0,0,0,100,0),
(86660,81,-8724.64,778.108,98.0604,0,0,0,0,100,0),
(86660,82,-8717.55,792.762,97.1197,0,0,0,0,100,0),
(86660,83,-8717.68,798.804,97.1792,0,0,0,0,100,0),
(86660,84,-8728.3,817.744,96.9777,0,0,0,0,100,0),
(86660,85,-8726.79,830.504,96.3102,0,0,0,0,100,0),
(86660,86,-8723.42,841.35,96.0764,0,0,0,0,100,0),
(86660,87,-8709.57,857.779,96.978,0,0,0,0,100,0),
(86660,88,-8692.38,870.557,97.0284,0,0,0,0,100,0),
(86660,89,-8679.35,880.974,97.0167,0,0,0,0,100,0),
(86660,90,-8661.22,896.239,97.5968,0,0,0,0,100,0),
(86660,91,-8643.7,912.233,98.9288,0,0,0,0,100,0),
(86660,92,-8634.58,918.926,99.3551,0,0,0,0,100,0);

@Rushor Rushor added a commit that referenced this issue Apr 4, 2015

@Rushor Rushor DB/Creature: Lil Timmy
convert by @Killyana, closes #10802
526da9c

@Aokromes Aokromes closed this Apr 5, 2015

@Rushor Rushor added a commit that referenced this issue Apr 14, 2015

@Rushor @DDuarte Rushor + DDuarte DB/Creature: Lil Timmy
convert by @Killyana, closes #10802

(cherry picked from commit 526da9c)
dcdf7a7
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment