Advertisement
Jethro84530

suggestion sd2 mangos 2597

Jun 23rd, 2012
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. DELETE FROM creature WHERE id=14494;
  2. INSERT INTO creature (id,map,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,DeathState,MovementType) VALUES
  3. (14494, 0, 1, 1, 0, 0, 3325.018, -2996.802, 164.449, 0.01, 600, 0, 0, 3052, 0, 0, 0);
  4. -- The peasants should have regenHealth = 0. Also the walk speed should be decreased!
  5. UPDATE creature_template SET RegenHealth = 0 WHERE entry IN (14484,14485);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement