Guest
Public paste!

Untitled

By: a guest | Sep 3rd, 2010 | Syntax: None | Size: 4.73 KB | Hits: 22 | Expires: Never
Copy text to clipboard
  1. INSERT INTO creature_names (`entry`, `name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `Leader`) VALUES ( '2000001', 'Hun Jin', 'Global Weapon Trainer', '', '7', '0', '0', '6449', '0', '0', '0', '0', NULL);
  2. INSERT INTO creature_proto (`entry`, `minlevel`, `maxlevel`, `Faction`, `minhealth`, `maxhealth`, `mana`, `Scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `combat_reach`, `boss`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `auras`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`) VALUES ('2000001', '70', '70', '1767', '100', '100', '100', '1', '17', '1500', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '36000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.5', '8', '14');
  3. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','5011','0','0','0','0','0','0','0');
  4. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','1180','0','0','0','0','0','0','0');
  5. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','15590','0','0','0','0','0','0','0');
  6. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','266','0','0','0','0','0','0','0');
  7. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','196','0','0','0','0','0','0','0');
  8. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','198','0','0','0','0','0','0','0');
  9. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','201','0','0','0','0','0','0','0');
  10. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','200','0','0','0','0','0','0','0');
  11. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','227','0','0','0','0','0','0','0');
  12. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','2567','0','0','0','0','0','0','0');
  13. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','197','0','0','0','0','0','0','0');
  14. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','199','0','0','0','0','0','0','0');
  15. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','202','0','0','0','0','0','0','0');
  16. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','5009','0','0','0','0','0','0','0');
  17. INSERT INTO trainer_spells (`entry`, `cast_spell`, `learn_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES ('2000001','0','264','0','0','0','0','0','0','0');
  18. INSERT INTO trainer_defs (`entry`, `required_skill`, `required_skillvalue`, `req_class`, `trainer_type`, `trainer_ui_window_message`, `can_train_gossip_textid`, `cannot_train_gossip_textid`) VALUES ('2000001', '0', '0', '0', '0', 'Hi , how can I help you?', '0', '0')
  19. INSERT INTO trainer_defs (`entry`, `required_skill`, `required_skillvalue`, `req_class`, `trainer_type`, `trainer_ui_window_message`, `can_train_gossip_textid`, `cannot_train_gossip_textid`) VALUES ('2000001', '0', '0', '0', '0', 'Hi , how can I help you?', '0', '0')