Advertisement
secondcoming

Delete Dead or Unused Players

Jul 27th, 2016
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.22 KB | None | 0 0
  1. CREATE EVENT `Delete Dead Dudes`
  2.     ON SCHEDULE
  3.         EVERY 1 MINUTE STARTS '2016-07-21 12:33:29'
  4.     ON COMPLETION PRESERVE
  5.     ENABLE
  6.     COMMENT ''
  7.     DO DELETE FROM player WHERE damage = 1 OR last_updated_at < now() - INTERVAL 10 DAY
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement