Solved Kunena mass delete users

You're right I'm an jackass. :blush:
The users must be removed completely from Joomla.

Thank you for support guys! I worked it out!

DELETE `xxxxx_users`.*,`xxxxx_kunena_users`.*
FROM `xxxxx_users`,`xxxxx_kunena_users`
WHERE `xxxxx_users`.`id`=`xxxxx_kunena_users`.`userid`
AND `jku9b_kunena_users`.`posts`=0

A follow up, I am going to change this to a feature request to prune users who have 0 posts after a period of registration. This way if the accounts are dormant accounts, most likely spam accounts, there is an easier methods to prune users and have more accurate count on the website.

We could have this manually done, or maybe automatically done when someone logs into the site.

coder4life wrote: A follow up, I am going to change this to a feature request to prune users who have 0 posts after a period of registration. This way if the accounts are dormant accounts, most likely spam accounts, there is an easier methods to prune users and have more accurate count on the website.

We could have this manually done, or maybe automatically done when someone logs into the site.

Big thanks to all team