vb.org Archive - Mass delete users if email contains ".top"?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Mass delete users if email contains ".top"? (https://vborg.vbsupport.ru/showthread.php?t=325132)

Drakie

05-24-2017 11:31 AM

Mass delete users if email contains ".top"?

I have a lot of spam users registered with emails ending with the TLD ".top".
I would like to delete all these users. Is there a way to mass delete them?

Maybe through PHPMyAdmin or is there a mod for this?

Paul M

05-24-2017 04:04 PM

The answer to both is No.

For what reason in particular do you want to mass delete them ?

CAG CheechDogg

05-24-2017 07:41 PM

Here you go ...

Quote:

Originally Posted by BirdOPrey5 (Post 2138329)

There is no built in function to mass delete users by email address in any version of vbulletin...

the database queries mentioned in the 3rd post will work just fine...

In phpmyadmin go to your database and run the query:

Code:

delete from user where email like "'%mailru%"

will delete every user with "mailru" in the email address.

But manually running queries can be dangerous!!! 1 little typo and you might end up deleting everyone so before you ever think about doing this make sure you have a backup of your database.

Got this from this thread ....

https://vborg.vbsupport.ru/showthread.php?t=152746

Paul M

05-24-2017 08:30 PM

Do not do that, its very bad advice.

There is a LOT more to deleting users than just the user table.

(The post is almost 7 years old btw).

CAG CheechDogg

05-24-2017 08:45 PM

If they are just spam users who probably don't have any posts then this should be fine ... correct?

Drakie

05-25-2017 09:33 AM

Quote:

Originally Posted by Paul M (Post 2586901)

The answer to both is No.

For what reason in particular do you want to mass delete them ?

They're all spammers.

Paul M

05-25-2017 09:43 AM

Yes, I know that, you mentioned it in the first post. ;)

But why do you want to delete them, as opposed to just ignoring them, what issue are they causing you ?

ForceHSS

05-26-2017 10:34 PM

use the User Moving/Pruning System and move them all to the banned group

All times are GMT. The time now is 08:13 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01168 seconds Memory Usage 1,725KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: