This is a SQL to make Drog Skullbreaker patroll around Dalaran.
He will visit a shop and chat it up with a few ladies.

Code:
UPDATE `creature` SET `movementtype` = '2' WHERE `guid` = '88642';
REPLACE INTO `creature_movement` (`id`, `point`, `position_X`, `position_Y`, `position_Z`, `waittime`, `emote`) VALUES 
('88642', '1', '5910.47', '648.23', '644.24', '0', '0'),
('88642', '2', '5906.45', '659.24', '643.80', '0', '0'),
('88642', '3', '5909.55', '661.96', '643.78', '0', '0'),
('88642', '4', '5914.57', '667.16', '643.50', '0', '0'),
('88642', '5', '5916.58', '665.38', '643.50', '0', '0'),
('88642', '6', '5906.72', '675.19', '643.50', '90000', '234'),
('88642', '7', '5911.11', '677.38', '643.50', '0', '0'),
('88642', '8', '5901.10', '684.66', '643.58', '0', '0'),
('88642', '9', '5894.92', '689.41', '642.03', '0', '0'),
('88642', '10', '5868.46', '653.60', '645.65', '0', '0'),
('88642', '11', '5863.92', '660.02', '645.65', '0', '0'),
('88642', '12', '5857.29', '666.49', '647.51', '0', '0'),
('88642', '13', '5849.77', '660.37', '647.51', '0', '0'),
('88642', '14', '5851.80', '641.05', '647.51', '0', '0'),
('88642', '15', '5848.23', '636.50', '647.51', '25000', '378'),
('88642', '16', '5855.41', '637.12', '647.51', '0', '0'),
('88642', '17', '5867.15', '631.21', '647.67', '0', '0'),
('88642', '18', '5893.75', '641.69', '646.04', '0', '0'),
('88642', '19', '5907.88', '631.23', '646.05', '0', '0'),
('88642', '20', '5906.09', '628.48', '646.47', '5000', '24'),
('88642', '21', '5911.80', '638.14', '645.31', '0', '0')
I will work on the others on my spare, I am going on a trip out of state in the morning, but I will work on it during the slow points of the vacation and will release my progress when I return.

See you in a week MMOpro,
Abyss