stevemaury wrote:ABSOLUTELY NOT!!!
There are entries for them in other tables, whether they have posted or not.
I tested following on a test server where i have a backup of the actual:
Lets say you want to see all users who have registered before 1.1.2012 and have zero posts and zero private messages.
In mysql command line:
SELECT username,user_last_privmsg,user_posts FROM phpbb_users WHERE user_regdate < 1345766400 AND user_posts=0 AND user_last_privmsg=0;
Then you get a list of those unactive users, registered about one year ago.
1345766400 is 1.1.2012 00:00:00 in Unix format.
You can convert normal dates to Unix format here:
http://www.epochconverter.com/
If you are happy with your result from the SELECT statement, you can delete the users with following statement:
---USE AT YOUR OWN RISK!!!!
[Under no circumstances should you actually do this. We will not be able to help you if you do - Marshalrusty]
DELETE FROM phpbb_users WHERE user_regdate < 1345766400 AND user_posts=0 AND user_last_privmsg=0;
---USE AT YOUR OWN RISK!!!!
Like I said, I did run this on a test server, and the board was running ok after deleting a couple of thousand zero posts and zero private messages users.
You said the above script is not ok and might brake relations to other tables?
Is there any documentation to this as I really would like to use the script on a live site.