As someone whose wiki is besieged by bogus account requests (from unique and variable emails and IPs), having an option to bulk reject all open requests would be enormously useful. Is this something that could be added?
If not, does anyone know of a manual way behind the scenes to easily clear out the queue en masse? Perhaps something like manually blanking a file, clearing a table, etc.?
Anything would help and be much appreciated. Thanks!
Agreed. This would be very useful. Or to filter the list to only those where the requester has confirmed their email address.
We'd also like a bulk management option. Envisioning a box next to all displayed requests, and by clicking the box (could have an option to select all requests being displayed) afterwards have an option to reject all as spam.
Agree that such a feature would be very helpful! We got a few hundreds over the last few days.
Or at least some instructions how to do this with an SQL request that does not break anything ;)
While a graphical interface would be easier and more secure to use, SQL is surely an option, I ended up routinely use it.The statement should look like this
UPDATE account_requests SET acr_rejected = LEFT(NOW(), 14), acr_deleted = '1', acr_user = 42 WHERE acr_rejected is NULL;
The query looks for unprocessed rows (with WHERE acr_rejected is NULL) then proceed to set them as rejected (with SET acr_deleted = '1'), by a specific user with userID "42" (you need to modify it with your own or any specific user of the wiki) with the timestamp of the moment when the query is executed.
I hope this helps.