Advertisement
tok124

creature update

Aug 16th, 2015
263
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SET
  2. @health = 10,
  3. @mana = 10,
  4. @minlevel = 255,  
  5. @maxlevel = 255,
  6. @mindmg = 10,  
  7. @maxdmg = 10,
  8. @MapID = 548;
  9.  
  10. UPDATE creature_template
  11. SET HealthModifier = HealthModifier * @health, ManaModifier = ManaModifier * @mana, minlevel = @minlevel, maxlevel =  @maxlevel, mindmg = mindmg * @mindmg, maxdmg = maxdmg * @maxdmg
  12. WHERE entry IN (SELECT id FROM creatures WHERE map = @MapID);
Advertisement
Advertisement
Advertisement
RAW Paste Data Copied
Advertisement