API tools faq
paste
image

KillCredits

image
Dec 21st, 2011
270
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 10.93 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM creature_template WHERE entry IN (65148, 65149, 65150, 65151, 65152, 65153, 65154, 65155, 65156, 65157, 65158, 65159, 65160, 65161, 65162, 65163, 65164, 65165, 65166, 65167, 65168, 65169, 65170);
  2. 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`, `expansion`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `health_mod`, `mana_mod`, `armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`)
  3. VALUES
  4. ('65148','0','0','0','0','0','1141','0','1141','0','BG_IC_WIN_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  5. ('65149','0','0','0','0','0','1141','0','1141','0','BG_IC_A_KEEP_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  6. ('65150','0','0','0','0','0','1141','0','1141','0','BG_IC_H_KEEP_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  7. ('65151','0','0','0','0','0','1141','0','1141','0','BG_IC_WS_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  8. ('65152','0','0','0','0','0','1141','0','1141','0','BG_IC_DOCK_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  9. ('65153','0','0','0','0','0','1141','0','1141','0','BG_IC_HANGER_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  10. ('65154','0','0','0','0','0','1141','0','1141','0','BG_IC_QUARRY_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  11. ('65155','0','0','0','0','0','1141','0','1141','0','BG_IC_REFINERY_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  12. ('65156','0','0','0','0','0','1141','0','1141','0','BG_IC_CATAPULT_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  13. ('65157','0','0','0','0','0','1141','0','1141','0','BG_IC_GLAIVE_A_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  14. ('65158','0','0','0','0','0','1141','0','1141','0','BG_IC_GLAIVE_H_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  15. ('65159','0','0','0','0','0','1141','0','1141','0','BG_IC_SIEGE_A_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  16. ('65160','0','0','0','0','0','1141','0','1141','0','BG_IC_SIEGE_H_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  17. ('65161','0','0','0','0','0','1141','0','1141','0','BG_IC_KEEP_CANNON_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  18. ('65162','0','0','0','0','0','1141','0','1141','0','BG_IC_DEMOLISHER_KC','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  19. ('65163','0','0','0','0','0','1141','0','1141','0','BG_IC_H_FRONT_GATE','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  20. ('65164','0','0','0','0','0','1141','0','1141','0','BG_IC_H_EAST_GATE','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  21. ('65165','0','0','0','0','0','1141','0','1141','0','BG_IC_H_WEST_GATE','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  22. ('65166','0','0','0','0','0','1141','0','1141','0','BG_IC_A_FRONT_GATE','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  23. ('65167','0','0','0','0','0','1141','0','1141','0','BG_IC_A_EAST_GATE','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  24. ('65168','0','0','0','0','0','1141','0','1141','0','BG_IC_A_WEST_GATE','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  25. ('65169','0','0','0','0','0','1141','0','1141','0','BG_IC_NODE_ASSAULT','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2',''),
  26. ('65170','0','0','0','0','0','1141','0','1141','0','BG_IC_NODE_DEFEND','','','0','1','1','0','1','1','0','0','3750','1618','1618','3','1.26','1.14286','3','1','96','144','0','36','2.5','1500','1500','1','130','0','0','0','0','0','0','77','115','29','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','10','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','2','');
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!