Advertisement
Chrispm84

Prevent Cleanup Event

Jul 11th, 2015
318
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.70 KB | None | 0 0
  1. UPDATE Object_DATA
  2.       SET    Datestamp   = CURRENT_TIMESTAMP
  3.       WHERE  ObjectUID   <> 0
  4.       AND    CharacterID <> 0
  5.       AND  ((Inventory IS NULL) OR (Inventory = '[]'))
  6.       AND EXISTS (SELECT 1
  7.                   FROM   Character_DATA c
  8.                   WHERE  c.PlayerUID = (SELECT p.PlayerUID
  9.                                         FROM   Player_DATA p,
  10.                                                Character_DATA c2
  11.                                         WHERE  p.PlayerUID = c2.PlayerUID
  12.                                         AND    c2.CharacterID = Object_DATA.CharacterID)
  13.                   AND    c.Alive = 1
  14.                   AND    c.LastLogin   > NOW() - INTERVAL 1 WEEK)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement