vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Delete users? (https://vborg.vbsupport.ru/showthread.php?t=282827)

dklassen 05-12-2012 03:03 PM

Delete users?
 
Is there a mod available that allows to mass delete users with a particular name or part of a word in their user name?

borbole 05-12-2012 03:25 PM

Quote:

Originally Posted by dklassen (Post 2328735)
Is there a mod available that allows to mass delete users with a particular name or part of a word in their user name?

I haven''t seen such a mod myself. Try to request it at the (paid/unpaid) request forums and hopefully someone will code it for you.

Or you can do it with a query. To delete all users that have a particular name or part of a word in their user name, first make a backup of your users table and then try this query:

Code:

DELETE FROM user WHERE username LIKE '%name%';
if you are using a prefix for your db tables, append it to the table name and replace name with the actual word that you want to delete all users who has it in their username.

dklassen 05-12-2012 03:41 PM

Thanks. The query sounds a little scary but I may give it a go.

borbole 05-12-2012 05:25 PM

Quote:

Originally Posted by dklassen (Post 2328744)
Thanks. The query sounds a little scary but I may give it a go.

You are welcome. Do not forget to backup your user table first before you run it.

Or you can also try this. Make a duplicate of your live forum to a test folder/subdomain using a new db and then try the query at the test db first to see how thing will go.


All times are GMT. The time now is 09:07 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.01005 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
  • (2)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