• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Mass "Resend Account Confirmation"


Well-known member
I have currently 35000 users "awaiting email confirmation".

This represents a significant number of potential customers and I do not wish to delete them, I would like to send a request for confirmation of mail to the whole, do you know a sql request to do it?
Last edited:


XenForo developer
Staff member
You'd need custom PHP to do this. You could send out a general email to these users with a link for them to request reconfirmation if they desire, though bear in mind they do have that link on every page when they're logged in.

That said, if you have 35000, I assume they have accumulated over time and most haven't visited in some time. I don't think sending everyone an account confirmation message is a good idea.


XenForo developer
Staff member
It depends if you have friendly URLs enabled or not, but assuming you do: