Guest User

Untitled

a guest
Feb 20th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.01 KB | None | 0 0
  1. DELETE FROM `creature_template` WHERE `entry` IN (111111, 222222, 333333, 444443, 444444, 7734914, 7734915);
  2. INSERT INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `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`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
  3. (111111, 0, 18219, 0, 18219, 0, 'Omega', 'Mystiq Event\'s', '', 70, 70, 7521, 7521, 0, 0, 0, 35, 35, 2, 1, 0, 3, 1e+09, 1e+09, 0, 4294967295, 4294967295, 4294967295, 2, 0, 0, 0, 0, 0, 0, 1e+12, 1e+13, 65535, 0, 0, 0, 0, 0, 32767, 32767, 32767, 32767, 32767, 32767, 0, 0, 0, 0, 0, 0, 0, '', 1, 4, 0, 255, 0, 0, 0, ''),
  4. (222222, 0, 7602, 0, 7602, 0, 'Alfa', 'Mystiq Event\'s', '', 70, 70, 6879, 6879, 0, 0, 0, 35, 35, 2, 1, 0, 3, 1e+10, 1e+09, 0, 4294967295, 4294967295, 4294967295, 2, 0, 0, 0, 0, 0, 0, 1e+12, 1e+13, 65535, 0, 0, 0, 0, 0, 32767, 32767, 32767, 32767, 32767, 32767, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, 0, 255, 0, 0, 0, ''),
  5. (333333, 0, 22957, 0, 22957, 0, 'Beta', 'Mystiq Event\'s', '', 70, 70, 5861, 5861, 0, 0, 0, 35, 35, 2, 1, 0, 3, 1e+10, 1e+09, 0, 4294967295, 4294967295, 4294967295, 2, 0, 0, 0, 0, 0, 0, 1e+12, 1e+13, 65535, 0, 0, 0, 0, 0, 32767, 32767, 32767, 32767, 32767, 32767, 0, 0, 0, 0, 0, 0, 0, '', 3, 4, 0, 255, 0, 0, 0, ''),
  6. (444443, 0, 7160, 0, 7160, 0, 'Checkpoint 1', 'Mystiq Event\'s', '', 70, 70, 7862, 7862, 3265, 3265, 9999999, 0, 0, 2, 1, 1, 3, 99999, 1e+08, 0, 99999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 999999, 1e+07, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 4, 0, 255, 0, 0, 0, ''),
  7. (444444, 0, 7160, 0, 7160, 0, 'Checkpoint 2', 'Mystiq Event\'s', '', 70, 70, 7869, 7869, 3564, 3564, 9999, 35, 35, 2, 1, 1, 3, 99999, 1e+08, 0, 99999999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1e+07, 1e+10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 4, 0, 255, 0, 0, 0, ''),
  8. (7734914, 0, 7047, 0, 7047, 0, 'Jumper', 'Porter na Event', '', 70, 70, 7862, 7862, 3265, 3265, 9999999, 35, 14, 2, 1, 2, 3, 99999, 1e+08, 0, 99999, 0, 2000, 0, 0, 0, 0, 0, 0, 0, 999999, 1e+07, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, ''),
  9. (7734915, 0, 7047, 0, 7047, 0, 'Jumper', 'Porter na Event', '', 70, 70, 789456123, 987654321, 0, 0, 2888, 14, 35, 2, 1, 2, 0, 99999, 10000, 0, 115, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 6499.63, 88.8624, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '');
Add Comment
Please, Sign In to add comment