Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select * from creature_template where entry in (19918,24895);
- +-------+--------------+-----------+------------+-----------+------------+------ --------+---------+----------+----------+----------+-----------+-----------+---- -----+---------+-------+-----------+-----------+---------+-------+-------+------ +--------+--------+-----------+-------------+----------------+-----------------+ ------------+--------------+--------+--------------+---------------+-------+---- --+-------------+-------------+-------------------+------+------------+--------+ ----------------+----------+-------------+-------------+-------------+---------- ---+-------------+-------------+--------+--------+--------+--------+------------ ----+---------+---------+--------+--------------+-------------+--------------+-- -----------+--------------+----------------------+-------------+---------------- --+
- | entry | heroic_entry | modelid_A | modelid_A2 | modelid_H | modelid_H2 | name | subname | IconName | minlevel | maxlevel | minhealth | maxhealth | min mana | maxmana | armor | faction_A | faction_H | npcflag | speed | scale | rank | mindmg | maxdmg | dmgschool | attackpower | baseattacktime | rangeattacktime | unit_flags | dynamicflags | family | trainer_type | trainer_spell | class | rac e | minrangedmg | maxrangedmg | rangedattackpower | type | type_flags | lootid | pickpocketloot | skinloot | resistance1 | resistance2 | resistance3 | resistanc e4 | resistance5 | resistance6 | spell1 | spell2 | spell3 | spell4 | PetSpellDat aId | mingold | maxgold | AIName | MovementType | InhabitType | RacialLeader | R egenHealth | equipment_id | mechanic_immune_mask | flags_extra | ScriptName |
- +-------+--------------+-----------+------------+-----------+------------+------ --------+---------+----------+----------+----------+-----------+-----------+---- -----+---------+-------+-----------+-----------+---------+-------+-------+------ +--------+--------+-----------+-------------+----------------+-----------------+ ------------+--------------+--------+--------------+---------------+-------+---- --+-------------+-------------+-------------------+------+------------+--------+ ----------------+----------+-------------+-------------+-------------+---------- ---+-------------+-------------+--------+--------+--------+--------+------------ ----+---------+---------+--------+--------------+-------------+--------------+-- -----------+--------------+----------------------+-------------+---------------- --+
- | 19918 | 0 | 19260 | 0 | 19260 | 0 | Time Watcher | | NULL | 70 | 70 | 6800 | 6800 | 100 | 100 | 20 | 1779 | 1779 | 0 | 1.05 | 1 | 1 | 168 | 225 | 0 | 688 | 2000 | 0 | 768 | 0 | 0 | 0 | 0 | 0 | 0 | 48.6207 | 62.7207 | 100 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34698 | 34699 | 34702 | 0 | 0 | 0 | 0 | | 1 | 1 | 0 | 1 | 0 | 131073 | 2 | generic_creatur e |
- | 24895 | 0 | 22965 | 0 | 22965 | 0 | Madri gosa | | | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 35 | 35 | 0 | 1 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 108 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 0 | 1 | 0 | 1 | 0 | 0 | 1 | |
- +-------+--------------+-----------+------------+-----------+------------+------ --------+---------+----------+----------+----------+-----------+-----------+---- -----+---------+-------+-----------+-----------+---------+-------+-------+------ +--------+--------+-----------+-------------+----------------+-----------------+ ------------+--------------+--------+--------------+---------------+-------+---- --+-------------+-------------+-------------------+------+------------+--------+ ----------------+----------+-------------+-------------+-------------+---------- ---+-------------+-------------+--------+--------+--------+--------+------------ ----+---------+---------+--------+--------------+-------------+--------------+-- -----------+--------------+----------------------+-------------+---------------- --+
- 2 rows in set (0.03 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement