Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE Object_DATA
- SET Datestamp = CURRENT_TIMESTAMP
- WHERE ObjectUID <> 0
- AND CharacterID <> 0
- AND ((Inventory IS NULL) OR (Inventory = '[]'))
- AND EXISTS (SELECT 1
- FROM Character_DATA c
- WHERE c.PlayerUID = (SELECT p.PlayerUID
- FROM Player_DATA p,
- Character_DATA c2
- WHERE p.PlayerUID = c2.PlayerUID
- AND c2.CharacterID = Object_DATA.CharacterID)
- AND c.Alive = 1
- AND c.LastLogin > NOW() - INTERVAL 1 WEEK)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement