Closed andersoncursino closed 13 years ago
Só Aplicar isso que dever resolver:
REPLACE INTO creature_template (entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName, WDBVerified) VALUES (36627, 38390, 38549, 38550, 0, 0, 31005, 0, 0, 0, 'Rotface', '', '', 0, 83, 83, 2, 14, 14, 0, 0.888888, 1.5873, 1, 3, 509, 683, 0, 805, 35, 0, 0, 1, 0, 8, 0, 0, 0, 0, 0, 371, 535, 135, 6, 108, 36627, 0, 0, 0, 0, 0, 0, 0, 0, 69789, 69508, 69674, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 525, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 654262271, 1, 'boss_rotface', 12340);
creature_template
entry
difficulty_entry_1
difficulty_entry_2
difficulty_entry_3
KillCredit1
KillCredit2
modelid1
modelid2
modelid3
modelid4
name
subname
IconName
gossip_menu_id
minlevel
maxlevel
exp
faction_A
faction_H
npcflag
speed_walk
speed_run
scale
rank
mindmg
maxdmg
dmgschool
attackpower
dmg_multiplier
baseattacktime
rangeattacktime
unit_class
unit_flags
dynamicflags
family
trainer_type
trainer_spell
trainer_class
trainer_race
minrangedmg
maxrangedmg
rangedattackpower
type
type_flags
lootid
pickpocketloot
skinloot
resistance1
resistance2
resistance3
resistance4
resistance5
resistance6
spell1
spell2
spell3
spell4
spell5
spell6
spell7
spell8
PetSpellDataId
VehicleId
mingold
maxgold
AIName
MovementType
InhabitType
Health_mod
Mana_mod
Armor_mod
RacialLeader
questItem1
questItem2
questItem3
questItem4
questItem5
questItem6
movementId
RegenHealth
equipment_id
mechanic_immune_mask
flags_extra
ScriptName
WDBVerified
REPLACE INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (201433, 36627, 631, 15, 1, 0, 0, 4445.87, 3137.31, 360.593, 4.71239, 86400, 0, 0, 7321125, 0, 0, 0, 0, 0);
creature
guid
id
map
spawnMask
phaseMask
modelid
position_x
position_y
position_z
orientation
spawntimesecs
spawndist
currentwaypoint
curhealth
curmana
Só Aplicar isso que dever resolver:
REPLACE INTO
creature_template
(entry
,difficulty_entry_1
,difficulty_entry_2
,difficulty_entry_3
,KillCredit1
,KillCredit2
,modelid1
,modelid2
,modelid3
,modelid4
,name
,subname
,IconName
,gossip_menu_id
,minlevel
,maxlevel
,exp
,faction_A
,faction_H
,npcflag
,speed_walk
,speed_run
,scale
,rank
,mindmg
,maxdmg
,dmgschool
,attackpower
,dmg_multiplier
,baseattacktime
,rangeattacktime
,unit_class
,unit_flags
,dynamicflags
,family
,trainer_type
,trainer_spell
,trainer_class
,trainer_race
,minrangedmg
,maxrangedmg
,rangedattackpower
,type
,type_flags
,lootid
,pickpocketloot
,skinloot
,resistance1
,resistance2
,resistance3
,resistance4
,resistance5
,resistance6
,spell1
,spell2
,spell3
,spell4
,spell5
,spell6
,spell7
,spell8
,PetSpellDataId
,VehicleId
,mingold
,maxgold
,AIName
,MovementType
,InhabitType
,Health_mod
,Mana_mod
,Armor_mod
,RacialLeader
,questItem1
,questItem2
,questItem3
,questItem4
,questItem5
,questItem6
,movementId
,RegenHealth
,equipment_id
,mechanic_immune_mask
,flags_extra
,ScriptName
,WDBVerified
) VALUES (36627, 38390, 38549, 38550, 0, 0, 31005, 0, 0, 0, 'Rotface', '', '', 0, 83, 83, 2, 14, 14, 0, 0.888888, 1.5873, 1, 3, 509, 683, 0, 805, 35, 0, 0, 1, 0, 8, 0, 0, 0, 0, 0, 371, 535, 135, 6, 108, 36627, 0, 0, 0, 0, 0, 0, 0, 0, 69789, 69508, 69674, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 525, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 654262271, 1, 'boss_rotface', 12340);REPLACE INTO
creature
(guid
,id
,map
,spawnMask
,phaseMask
,modelid
,equipment_id
,position_x
,position_y
,position_z
,orientation
,spawntimesecs
,spawndist
,currentwaypoint
,curhealth
,curmana
,MovementType
,npcflag
,unit_flags
,dynamicflags
) VALUES (201433, 36627, 631, 15, 1, 0, 0, 4445.87, 3137.31, 360.593, 4.71239, 86400, 0, 0, 7321125, 0, 0, 0, 0, 0);