[The_Zealot]

I know this is common knowledge tho i made this guide sometime ago and i wanted to post it but something ****ed up... Anyways here it goes

Things Needed:
[Only registered and activated users can see links. ] or
[Only registered and activated users can see links. ] or
SQLyog
A WoW Private Server (Ascent )
_____________________________________
##############################
#Start by Connecting to your MySQL Server##
##############################

Open HeidiSQL, and fill in your MySQL information
So you can access your database localhost!



##############
##Creature Names!#
##############
On your ascent's World Database search for the
[creature_names] database


Click on the 'data' tab and then the "+" Button to add another row in the database


//Addinational Information for creature_names//
entry The entry/ID of the creature. Used to reference records of this table and to spawn creature in-game.
name Name of the creature. Displayed in-game.
subname Subname of the creature. Displayed in-game below the creature_name. Most of the time this is the function of the Creature.
info_str The MouseFlags
Flags1 Unknown as of yet. This is NOT like npcflags in creature_proto
type:

1 	Beast
2 	Dragonkin
3 	Demon
4 	Elemental
5 	Giant
6 	Undead
7 	Humanoid
8 	Critter
9 	Mechanical
10 	Not Specified (used by mounts)
11 	Totem

Family

1 	Wolf
2 	Cat
3 	Spider
4 	Bear
5 	Boar
6 	Crocolisk
7 	Carrion Bird
8 	Crab
9 	Gorilla
10 	[UNUSED]
11 	Raptor
12 	Tallstrider
13 	[UNUSED]
14 	[UNUSED]
15 	Felhunter
16 	Voidwalker
17 	Succubus
18 	[UNUSED]
19 	Doomguard
20 	Scorpid
21 	Turtle
22 	[UNUSED]
23 	Imp
24 	Bat
25 	Hyena
26 	Owl
27 	Wind Serpent
28 	Remote Control
29 	Felguard
30 	Dragonhawk
31 	Ravager
32 	Warp Stalker
33 	Sporebat
34 	Nether Ray
35 	Serpent

Rank

0 	Normal
1 	Elite
2 	Rare Elite
3 	World Boss
4 	Rare

unk4 Need info here. Please edit if you know.
SpellDataID Used by pets. Points to CreatureSpellData.dbc .
male_displayid Model ID of the creature if it's male.
female_displayid Model ID of the creature if it's female.
male_displayid Second Model ID of the creature if it's male.
female_displayid Second Model ID of the creature if it's female.
Civilian Note: Civilians generally denotes if the creature has an aggro range or not.
Leader Indicates if Creature is the Leader of a Faction. 1=Leader 0=No Leader. An example would be Thrall.
//Ok now to see a picture of some of these things in action!//




###
#Creature_proto#
############
Find the
[creature_proto] database

Click on "Data" And then add a new row hitting the "+" Button, just like before!

//Addinational Information on Proto, What to fill in?\\
entry The entry/ID of the creature. Must be same as the one used at Creature_names before!
minlevel Min Level of the Creature.
maxlevel Max Level of the Creature.
faction Faction of the creature. 7 - neutral, 14 - hostile, 35 - friendly
minhealth Min. health of the creature
maxhealth Max. health of the creature
mana Max. mana of the creature
scale Scale of the creature. Default 1=100%
npcflags:

UNIT_NPC_FLAG_NONE 	0
UNIT_NPC_FLAG_GOSSIP 	1
UNIT_NPC_FLAG_QUESTGIVER 	2
UNIT_NPC_FLAG_TRAINER 	16
UNIT_NPC_FLAG_VENDOR 	128
UNIT_NPC_FLAG_ARMORER 	4096
UNIT_NPC_FLAG_TAXIVENDOR 	8192
UNIT_NPC_FLAG_SPIRITHEALER 	32768
UNIT_NPC_FLAG_INNKEEPER 	65536
UNIT_NPC_FLAG_BANKER 	131072
UNIT_NPC_FLAG_ARENACHARTER 	262144
UNIT_NPC_FLAG_TABARDVENDOR 	524288
UNIT_NPC_FLAG_BATTLEFIELDPERSON 	1048576
UNIT_NPC_FLAG_AUCTIONEER 	2097152
UNIT_NPC_FLAG_STABLE 	4194304
UNIT_NPC_FLAG_GUILD_BANK 	8388608

attacktime Delay between the attacks in ms
attacktype Magic school for attacks
mindamage Minimum damage of the creature
maxdamage Maximum damage of the creature
rangedattacktime Delay between the ranged attacks in ms
rangedmindamage Minimum ranged damage of the creature
rangedmaxdamage Maximum ranged damage of the creature
mountdisplayid Model ID of the mount the npc is on (?). 0 if none.
equipmodel1 Display ID of the item at slot 1
equipinfo1 Please give information, if you know
equipslot1 Please give information, if you know
equipmodel2 Display ID of the item at slot 2
equipinfo2 Please give information, if you know
equipslot2 Please give information, if you know
equipmodel3 Display ID of the item at slot 3 (Such as a throwing knife, visual only(?))
equipinfo3 Please give information, if you know
equipslot3 Please give information, if you know
respawntime Respawntime in ms
armor Armor of the creature
resistance1 Holy Resistance of the creature
resistance2 Fire Resistance of the creature
resistance3 Nature Resistance of the creature
resistance4 Frost Resistance of the creature
resistance5 Shadow Resistance of the creature
resistance6 Arcane Resistance of the creature
combat_reach Distance of the creature in which it can hit you.
bonding_radius Aggro radius of the creature.
auras auras of the creature, seperator is a comma (,)
boss Indicates if creature is a boss. 1=boss 0=no boss
money money dropped by the creature in copper
invisibility_type:

INVIS_FLAG_NORMAL 	0
INVIS_FLAG_SPIRIT1 	1
INVIS_FLAG_SPIRIT2 	2
INVIS_FLAG_TRAP 	3
INVIS_FLAG_QUEST 	4
INVIS_FLAG_GHOST 	5
INVIS_FLAG_UNKNOWN6 	6
INVIS_FLAG_UNKNOWN7 	7
INVIS_FLAG_SHADOWMOON 	8
INVIS_FLAG_NETHERSTORM 	9
INVIS_FLAG_TOTA 	10

death_state:

ALIVE - Unit is alive and well 	0
JUST_DIED - Unit has JUST died 	1
CORPSE - Unit has died but remains in the world as a corpse 	2
DEAD - Unit is dead and his corpse is gone from the world 	3

walk_speed Walking speed for the creatures. Default: 2.5
run_speed Running speed for the creatures. Default: 8
fly_speed Flying speed for the creatures
extra_a9_flags Extra information for Area 9 (NPCFlags) info

//Done filling in? Congratz!\\

You just finished your custom mob! Just try to either restart the database or do the follow commands in-game:

.reloadtable creature_names
.reloadtable creature_proto

[Zordin]

Nice! +rep x2, this will help alot of people