Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- SQL Query generated with Peking Duck™ for table creature_template.
- -- Timestamp: 2012-01-07 04:09:46
- SET @NPCGUID := 90001; -- Creature: Pointron entry.
- -- Warning, this will delete an existing creature in creature_template if the entry id is the same.
- DELETE FROM `creature_template` WHERE `entry` = @NPCGUID;
- -- Inserting generated creature Pointron into creature_template
- INSERT 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
- (@NPCGUID, -- entry
- 0, -- difficulty_entry_1
- 0, -- difficulty_entry_2
- 0, -- difficulty_entry_3
- 0, -- KillCredit1
- 0, -- KillCredit2
- 124215, -- modelid1
- 0, -- modelid2
- 0, -- modelid3
- 0, -- modelid4
- "Pointron", -- name
- "Unsafe Code", -- subname
- '', -- IconeName
- 0, -- gossip_menu_id
- 83, -- minlevel
- 83, -- maxlevel
- 0, -- exp
- 0, -- faction_A
- 0, -- faction_h
- 0, -- npcflag
- 1, -- speed_walk
- 1, -- speed_run
- 2, -- scale
- 4, -- rank
- 1, -- mindmg
- 5, -- maxdmg
- 0, -- dmgschool
- 1504, -- attackpower
- 1, -- dmg_multiplier
- 1500, -- baseattacktime
- 0, -- rangeattacktime
- 8, -- unit_class
- 23, -- unit_flags
- 23, -- dynamicflags
- 0, -- family
- 0, -- trainer_type
- 0, -- trainer_spell
- 0, -- trainer_class
- 0, -- trainer_race
- 0, -- minrangedmg
- 0, -- maxrangedmg
- 0, -- rangedattackpower
- 0, -- type
- 0, -- type_flags
- 0, -- lootid
- 0, -- pickpocketloot
- 0, -- skinloot
- 0, -- resistance1
- 0, -- resistance2
- 0, -- resistance3
- 0, -- resistance4
- 0, -- resistance5
- 0, -- resistance6
- 0, -- spell1
- 0, -- spell2
- 0, -- spell3
- 0, -- spell4
- 0, -- spell5
- 0, -- spell6
- 0, -- spell7
- 0, -- spell8
- 0, -- PetSpellDataId
- 0, -- VehicleId
- 0, -- mingold
- 0, -- maxgold
- '', -- AIName
- 0, -- MovementType
- 3, -- InhabitType
- 1, -- Health_mod
- 1, -- Mana_mod
- 1, -- Armor_mod
- 0, -- RacialLeader
- 0, -- questItem1
- 0, -- questItem2
- 0, -- questItem3
- 0, -- questItem4
- 0, -- questItem5
- 0, -- questItem6
- 0, -- movementId
- 1, -- RegenHealth
- 0, -- equipment_id
- 0, -- mechanic_immune_mask
- 0, -- flags_extra
- '', -- ScriptName
- 1); -- WDBVerified
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement