vb.org Archive - Delete mass users

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

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

- - Delete mass users (https://vborg.vbsupport.ru/showthread.php?t=323997)

khalled

12-10-2016 03:37 AM

Delete mass users

i have got spammed and i want delete mass of user with the same mails in one time , when i search user by mail i got result by all users i want to deleted , but it required to delete user one by one , is it any way to delete all user in one time

regards

MarkFL

12-10-2016 04:35 AM

Perhaps you can isolate those users in the "Prune / Move Users" search?

khalled

12-10-2016 07:09 AM

"Prune / Move Users" i can't filter users by mail , so i can't use this to isolate them

MarkFL

12-10-2016 07:19 AM

You can order the results by email...and it might not be a simple 1 or 2 step process, but it shouldn't be too bad.

Or, what you can do is run a manual SQL query to mass move all users having a particular email into a special usergroup you create for this purpose:

Code:

UPDATE user

SET usergroupid = X

WHERE email LIKE '%@spam.com%'

Replace X with the usergroupid of the usergroup you are going to move all the users, and replace @spam.com with the text common to all the emails in question.

After the query, all the spammers will be in the same usergroup, and you can prune them by that group.

khalled

12-22-2016 05:59 PM

very thanks , that is work good

All times are GMT. The time now is 12:44 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01667 seconds Memory Usage 1,709KB 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 (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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: