vb.org Archive

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 12:26 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01559 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