Hello, I have seen some people who had trouble with making their NPCs do certain emotes, when they restart their server. It's pretty simple, and very fast.
First start up by spawning a NPC you want to do an emote, Lets say he needs to sit on the ground.
Open your database (I use HeidiSQL) and go to world > creature_spawns
Then find the SQL Entry ID of your NPC by using .npc info inside the game. (It's red, when you do it, compared to the others there are yellow) In my case it is 711785
Now for him to make him sit, you need to change his emote_state to 13 (which is the emote ID for sit, you can find all the IDs needed: Emote - ArcEmu-Wiki )
Now additional when you restart he will not sit, that's because you need to change something else! This is where the problem for many was.
You need to change bytes1 (Still under creature_spawns) to a certain amount for different emotes. In this case of sitting, it's 1
Now when you restart the server your NPC should be sitting.
You need different IDs for the different emote states. Here are they:
1 = Sitting on the ground
2 = Sitting on the chair
3 = Sleep
4 = Sit (Low)
5 = Sit (Medium)
6 = Sit (Elevated High)
7 = Lying Dead (combined with death_state in creature_proto makes the mob to appear dead)
8 = Kneel (Need bytes2 = 1)
(If you don't need any of these emotes, and you maybe need to make them dance, you should not change the Bytes1 to anything, leave it at 0)
Now enjoy making your NPCs fit in! If you need futher information check out: Creature spawns - ArcEmu-Wiki and the rest of the wiki has a lot of the information you need. :D