SAI-refernce: https://github.com/TrinityCore/TrinityCore/issues/15127
This issue adds a checklist for all classic zones which needs to be filled with Emotes and Movement (Rndmmovement + Waypointmovement). Feel free to assign something to yourself (just add a note in the issue, if you want to help us). I will add a tutorial how to extract all these waypoints soon.
How to add Waypoints to a creature:
Note: I'm just adding a copy paste tutorial without further information on the DB-Structure behind it, because i know, you will understand this soon enough.
Example:
We want to add this Guy some waypoints

1.) Get the latest sniffer from http://community.trinitycore.org/topic/9849-trinity-cores-sniffer-for-wow-62020338/
2.) Log in on retail and start the attach_sniffer and follow the Creature until it has completed it's whole path. It's important, that you DO NOT RUN OUT of sight of this mob, else the path will look really creapy.
3.) Close the sniffer if the Path is completed one time
4.) You will see a .pkt - file in your wow directory now
5.) Download and compile https://github.com/TrinityCore/WowPacketParser
6.) Go to the Releasefolder after you finished compiling
7.) Copy the .pkt-file and move the file with drag-and-drop over the WowPacketParser.exe
Note: It's recommended to keep these settings
8.) Now you will see a .txt file in your releasefolder
9.) Download and compile https://github.com/Kittnz/WaypointCreator (Branch 6.x)
10.) Go to the release folder and open up the Waypoint Creator.exe
11.) Import the .txt-file 
12.) Search for the entry in the searchfield (in this case entry: 74228)
13.) Result:
- Rightclick on the table and hit: Create SQL
14.) In the SQL-Output you will now find:
. Use the command: .go 1923.215 -4636.423 33.2019 to see if you are on the right position
15.) Go ingame (Tc-Server) and choose a fitting creature which is near the path. In this case it's creature with GUID: 286504 - You always find the right guid if you select the creature and type: .npc info
16.) Replace the XXXXXX in SET @NPC := XXXXXX; with the GUID -> SET @NPC := 286504;
16.) Repeat this for all other Paths
This is excellent. Why don't you post the guide about this on forums?
Nice job Rushor :)
awesome guide!
1.) Yes, you will get the creature_text for every creature if you enabled it in the WowPacketParser.exe.config
f.ex.:
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
(14872, x, x, 'Help! I''m being chased by a swarm of bees!', 12, 1, 100, 0, 0, 0, '10259', 'Trok to 0'),
(14872, x, x, 'I''m so tired of running, but these bees won''t leave me alone!', 12, 1, 100, 0, 0, 0, '10260', 'Trok to 0'),
(14872, x, x, 'I didn''t know bees didn''t like fire!', 12, 1, 100, 0, 0, 0, '10261', 'Trok to 0'),
(14872, x, x, 'Karu will you please help get these bees off of me? They sting!', 12, 1, 100, 0, 0, 0, '10262', 'Trok to 0'),
(34431, x, x, 'Excellent work! I''ll unload the goods. You should check in with Kranal Fiss.', 12, 0, 100, 4, 0, 0, '34667', 'Balgor Whipshank to Lead Caravan Kodo');
Note: In order to automatically get the broadcasttextids you need to create https://github.com/TrinityCore/WowPacketParser/tree/master/SQL in your db
and you need to enable
<add key="creature_text" value="true"/>
<add key="DBEnabled" value="true" />
<add key="WPPDatabase" value="WPP" />
thx to @DDuarte for this hint
2.) meh, there are already so much useful questions in http://community.trinitycore.org/topic/1210-sai-scripting-questions. The editor https://github.com/Discover-/SAI-Editor is really easy to understand
thank you very much :+1:
feralas also already completely done with commit https://github.com/TrinityCore/TrinityCore/commit/7977ab8580573f5bc7627aa87b6a867d55efd7e3 and the commit of the next day which contained all of the wp stuff - so we can remove feralas from the list
That man is beast
i hope there will be more beasts soon :(
If you wanna sniffs, i have probably sniffed all dungeons, battlegrounds.
Incredible job here, but, in my opinion, even better the guide.
More guides could bring more helpers. Go on! ;)
I am assuming this should be done for escort quests as well?
the number of escortquests in cata is not that high
Pathing isn't implemented properly.
Here we go
A bounty ($20) has just been posted on this issue by fallenoak.
any kind of help would be nice, everyone can fix this stuff (and by everyone i mean even people who never fixed anything before) - just follow the instruction mentioned above
I have sniffs from sunstrider isle...but there seems everything is okay
I just wanted to chime in and say thank you for the guide.
could someone remove me from the assigned list?
From @ArcaneFox in issue #19353. Please note: 4609 (!) lines, will need some editing and checking for double spawns.
https://gist.github.com/tkrokli/29e309146b827f49f9db839642b6e5c8#file-silverpine_forest_gilneas-sql
Bountysource backers: make sure to redeploy or withdraw your bounty. New TOS of bountysource will "steal" your money if you dont do so.