Advertisement
Guest User

Untitled

a guest
Jun 29th, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 5.60 KB | None | 0 0
  1.  
  2. -- trash
  3. UPDATE `creature_template` SET baseattacktime=1500, dmg_multiplier=21 WHERE `entry` in (30680,30681,30682,30453);
  4.  
  5. UPDATE `creature_template` SET baseattacktime=1500, dmg_multiplier=35 WHERE `entry` in (30998,30999,31000,31001);
  6.  
  7. -- disciple of shadron e vesperon
  8. UPDATE `creature_template` SET `ScriptName`='mob_acolyte_of_vesperon' WHERE `entry`=30858;
  9. UPDATE `creature_template` SET `ScriptName`='mob_acolyte_of_shadron' WHERE `entry`=30688;
  10. UPDATE `creature_template` SET minlevel=81, maxlevel=81, exp=2, faction_A=103,faction_h=103, mindmg=440, maxdmg=580, baseattacktime=1500,dmg_multiplier=7, unit_class=2 WHERE `entry` in (30688,30858);
  11. UPDATE `creature_template` SET minlevel=81, maxlevel=81, exp=2, faction_A=103,faction_h=103, mindmg=440, maxdmg=580, baseattacktime=1500,dmg_multiplier=18, unit_class=2 WHERE `entry` in (31544,31546);
  12.  
  13. -- acolyte of shadron e vesperon
  14. UPDATE `creature_template` SET minlevel=81, maxlevel=81, exp=2, faction_A=103,faction_h=103, mindmg=440, maxdmg=580, baseattacktime=1300,dmg_multiplier=12, unit_class=2 WHERE `entry` in (31218,31219);
  15. UPDATE `creature_template` SET minlevel=81, maxlevel=81, exp=2, faction_A=103,faction_h=103, mindmg=440, maxdmg=580, baseattacktime=1300,dmg_multiplier=22, unit_class=2 WHERE `entry` in (31541,31543);
  16.  
  17. -- twilight eggs
  18. UPDATE `creature_template` SET minlevel=80, maxlevel=80,  faction_A=103,faction_h=103 WHERE `entry` in (30882,31204,31539,31547);
  19. UPDATE `creature_template` SET scriptname='mob_twilight_eggs' WHERE `entry` in (30882,31204);
  20.  
  21. -- twilight welps
  22. UPDATE `creature_template` SET minlevel=81, maxlevel=81, exp=2, faction_A=103,faction_h=103, mindmg=440, maxdmg=580, baseattacktime=1500,dmg_multiplier=7, unit_class=2 WHERE `entry` in (30890,31214);
  23. UPDATE `creature_template` SET minlevel=81, maxlevel=81, exp=2, faction_A=103,faction_h=103, mindmg=440, maxdmg=580, baseattacktime=1500,dmg_multiplier=18, unit_class=2 WHERE `entry` in (31540,31548);
  24.  
  25. -- lava blazes
  26. UPDATE `creature_template` SET minlevel=81, maxlevel=81, exp=2, faction_A=103,faction_h=103, mindmg=900, maxdmg=1200, baseattacktime=1500,dmg_multiplier=1, dmgschool=2, scriptName = "mob_lava_blaze" WHERE `entry` in (30643);
  27. UPDATE `creature_template` SET minlevel=81, maxlevel=81, exp=2, faction_A=103,faction_h=103, mindmg=900, maxdmg=1200, baseattacktime=1500,dmg_multiplier=1, dmgschool=2 WHERE `entry` in (31317);
  28.  
  29. -- trigger lava strike
  30. REPLACE 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
  31. (100010, 0, 0, 0, 0, 0, 11686, 0, 0, 0, 'Flame strike trigger', NULL, NULL, 0, 80, 80, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 1, 1, 5000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27812, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 100, 1, 0, 0, 0, '', 0);
  32.  
  33. -- fazione flame tsunami
  34. UPDATE creature_template SET minlevel=83, maxlevel=83, faction_A=14, faction_H=14, unit_flags=0x02000000, flags_extra=0x00000002 WHERE entry in (30616);
  35.  
  36. -- 3 add draghi
  37. UPDATE `creature_template` SET dmg_multiplier=30,armor_mod=1.3,resistance1=15, resistance2=15, resistance3=15, resistance4=15, resistance5=15, resistance6=15 WHERE `entry` in (30449,30451,30452);
  38. UPDATE `creature_template` SET dmg_multiplier=68,armor_mod=1.3,resistance1=15, resistance2=15, resistance3=15, resistance4=15, resistance5=15, resistance6=15 WHERE `entry` in  (31535,31520,31534);
  39.  
  40. -- sartharion
  41. UPDATE `creature_template` SET dmg_multiplier=46, armor_mod=1.3,type_flags=0,resistance1=15, resistance2=15, resistance3=15, resistance4=15, resistance5=15, resistance6=15 WHERE `entry` in  (28860);
  42. UPDATE `creature_template` SET dmg_multiplier=90, armor_mod=1.3,type_flags=0,resistance1=15, resistance2=15, resistance3=15, resistance4=15, resistance5=15, resistance6=15 WHERE `entry` in  (31311);
  43.  
  44. -- target flame
  45. DELETE FROM spell_script_target WHERE entry = 60430;
  46. INSERT INTO spell_script_target (entry, type, targetEntry) VALUES
  47. (60430, 1, 30643),
  48. (60430, 1, 31317);
  49.  
  50. -- Resi inattaccabili trigger
  51. UPDATE creature_template SET flags_extra=130 WHERE entry in (31138,31550,30494);
  52. -- flame cyclone
  53. UPDATE creature_template SET unit_flags=33554434,dynamicflags=8,flags_extra=2 WHERE entry in (30648);
  54. -- cosmetic egg
  55. UPDATE creature_template SET faction_A=35,faction_h=35,unit_flags=33554432,flags_extra=2 WHERE entry in (31103);
  56.  
  57. UPDATE gameobject_template SET data10=57620, data17=0, ScriptName = "script_twilight_portal" WHERE entry in (193988);
  58. UPDATE gameobject_template SET ScriptName = "script_normal_portal" WHERE entry in (193989);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement