delete all pm's made in the last day, or a certain day, or that contain a certain word?
The command below where given to me in the past...
SELECT DISTINCT B_IP FROM w3t_Posts WHERE B_PosterID = $User (replace user's user Number)
that gives all the IP's a user has posted under.
SELECT U_RegIP FROM w3t_Users WHERE U_Number = $User (replace user's user Number)
that gives you the IP the person registered with.
SELECT B_PosterID FROM w3t_Posts WHERE B_IP = 'xxx.xxx.xxx.xxx' (replace IP number here)
that gives you all the people who have posted under a particular IP address. It's usually more helpful if you chop off a couple of the last numbers and use '%' at the end, so it will pull a slightly larger range of IP's.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.