Submitted by Mike on Sun, 01/17/2010 - 10:21pm
Here's a handy PHP snippet to purge user accounts for all users who haven't created any nodes on your site. It's useful when you have a lot of users who have signed but haven't created any nodes.
<?php
// Get a list of all users in the site who have not created any nodes, AND uid > 1
$sql = "SELECT u.uid FROM {users} u WHERE u.uid NOT IN (SELECT DISTINCT n.uid FROM {node} n) AND u.uid > 1 ORDER BY uid";
$result = db_query($sql);
while($row = db_fetch_object($result)) {
// delete the user account
user_delete(array(), $row->uid);
}
?>
Works but times out with many users
Snippet works good, but if there is a lot of cleaning up to do it times out and you see a blank page. If you add a LIMIT you could delete it batchwise.
Good point
Thanks for the suggestion. Yes, you have to be careful that the processing time doesn't exceed your PHP timeout values.
Post new comment