vb.org Archive - ACP - Prune Users (search by email)?

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

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

- - ACP - Prune Users (search by email)? (https://vborg.vbsupport.ru/showthread.php?t=201659)

terminator2k2

01-13-2009 05:48 PM

ACP - Prune Users (search by email)?

Hi,

is there a way to delete many users at ones using the prune function but with searching after certain emails

maybe any good mod for this?

markbolyard

01-13-2009 06:01 PM

Through your admincp, in the Maintenance area, select execute sql querry.

Use this:

Code:

UPDATE vb_user

SET usergroupid = 149

WHERE email LIKE '%@mail.ru%'

You will change vb_user to just user if you are now using prefixes in your database.

You will change the usergroup number to a usergroup which you can use temporarily to store those members you want to delete. So, you could make a new usergroup like I did and call it To Be Deleted, or Bad Email Accounts, and place that usergroup number in the code above.

Then change the @mail.ru to whatever email you want to move to that bad email usergroup.

Once you have all your users in one usergroup, then you can prune those users under the user menu by usergroup.

Hope that makes sense, and although not the easiest method, that's all I got :)

terminator2k2

01-13-2009 06:07 PM

i know this way also ;P but it takes a bit more time ^^
that's why i searched for sollution.. this is one of the things that could be improved inside the acp..

Marco van Herwaarden

01-14-2009 09:18 AM

Quote:

Originally Posted by terminator2k2 (Post 1711227)

i know this way also ;P but it takes a bit more time ^^
that's why i searched for sollution.. this is one of the things that could be improved inside the acp..

Post it in the suggestions forum on vB.com.

All times are GMT. The time now is 11:49 PM.

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