I promised u i would make and guide for npc's so here it is (i hope not this is and if it is its ok if u delete it)
Step One: First u need heidiSQL (If u have seen my other guide u probably have it
Anyways if u dont link is here HeidiSQL - MySQL made easy
Step Two: Finding the id of the npc u want it to look like. in game go find and npc u want it to look like etc. Stormwind city Gaurd the id for that is 68 but u dont have to find them in game u can just use youre heidisql database to it
Step Three:Now log into HeidiSQL then go into ascent and find ''Creature Names''
Then there will come alot of options up there will be many well now click the ''+'' that is located in the left upper corner then there will come and blank of the straight lines up now u need to edit them if u are having very hard to edit them try find and npc that u can follow the info's in now i will show u how to here i have made and ''stormwind royal elite'' This is only the important things i show i dont show all of the options
Entry Name Type Male_Displayid --------->
90000 Stormwind 7 3167
Royal
Elite
unknown_float1 Unknown_float2
2 1
This was first step
Now find the one named creature_proto
when u come there remember the id of u unit (90000)
Entry Minlevel Maxlevel Faction Minhealth Maxhealth Mana
90000 100 100 14 1000000 1000000 100000
Scale Npcflags Attacktime Attacktype MinDamage Maxdamage
1 4224 1000(1sec) 10000 2000 3000
Respawntime Armor Combat_Reach Bounding_Radius Money
60sec 5000 1 1 900000000
Invisibility_Type Death_State Walk_Speed Run_speed
0 0 2,5 10
Fly_Speed
14
This is all the things u need to make and fully working custom npc but u can upgrade it by doing all the other things that is in there
now just restart u server and go in again and say .npc spawn <id>
And there u go ! u own custom NPC !!