It has come to my attention that the almighty delete all posts button was not deleting visitor messages. I'll have that fixed soon, but in the meanwhile:
Quote:
DELETE FROM `visitormessage` WHERE (SELECT a.liftdate FROM userban a WHERE a.userid = postuserid) = 0
833 row(s) deleted. ( Query took 0.0382 sec )
|