vb.org Archive - Deleting over 90000 Banned Users.

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

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

- - Deleting over 90000 Banned Users. (https://vborg.vbsupport.ru/showthread.php?t=320701)

SaN-DeeP

11-04-2015 10:15 AM

Deleting over 90000 Banned Users.

Seems we never deleted any banned users till day from our foruims *(due to internal rules)
But we have to finally delete this SPAM, which is meaningless..

Deleting from admincp is impossible.. (It crashes while load)
Any suggestions ?

Paul M

11-04-2015 11:24 AM

Create a dummy usergroup, move users to that group in batches using SQL, then delete all members of that group in the acp.

Max Taxable

11-04-2015 04:26 PM

I did this myself for a person's vB4 site a couple of years ago and Paul's suggestion is exactly the way to go.

CAG CheechDogg

11-05-2015 01:10 AM

Quote:

Originally Posted by Paul M (Post 2558205)

Create a dummy usergroup, move users to that group in batches using SQL, then delete all members of that group in the acp.

What SQL would we use to do this Paul? Thank you !

--------------- Added [DATE]1446693096[/DATE] at [TIME]1446693096[/TIME] ---------------

Doesn't deleting banned users though leave threads and posts orphaned, I though I saw this happen and it messed up the forums , at least mine it did, it said user instead of the real username and a very weird looking post or thread ...

All times are GMT. The time now is 09:40 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02440 seconds Memory Usage 1,712KB 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_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: