Bulk delete disabled k2 users Joomla 2.5

Question

I have thousands of spam users. I use K2 and I would want to delete them from "k2_users" and from "users". I want to delete the blocked ones. I have tried deleting K2_users from the admin, but it does not delete the user from "users".

Any ideas to delete from both tables(using SQL) the users that are blocked? I think that the field "block" of the table "users" is the key.

Thanks.

Answer 1

Deleting users using Joomla's User Manager is also going to delete them from K2 users table, as long as User - K2 plugin is enabled.

To delete users programmatically, you can query the database to get the IDs of blocked users and pass them to UsersModelUser::delete().

$db = JFactory::getDbo();
$query = $db->getQuery(true)
    ->select($db->quoteName('id'))
    ->from($db->quoteName('#__users'))
    ->where($db->quoteName('block') . ' = 1');

if ($blockedUsers = $db->setQuery($query)->loadColumn())
{
    JLoader::register('UsersModelUser', JPATH_ADMINISTRATOR . '/components/com_users/models/user.php');

    $model = JModelLegacy::getInstance('User', 'UsersModel', array('ignore_request' => true));
    $model->delete($blockedUsers);
}