vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Removing Duplicate Users (https://vborg.vbsupport.ru/showthread.php?t=290913)

adambloch 11-17-2012 05:03 PM

Removing Duplicate Users
 
Hi all

I have a little problem that up till now hasn't been an issue. At somepoint in the past we must have done something that has created 2462 duplicate users. Having said that they all have a prefix on the duplicate accounts of imported_ so they are quite easy to indentify.

Does anyone have a suggestion in how to remove these 2462 users.. I'm guessing that doing it via the DB is a bad idea but may be not.

Many thanks

Adam

kh99 11-17-2012 05:34 PM

I've seen people suggest that you simply remove the rows from the user database, and I think that might work (especially is the users have no posts), but it doesn't remove everything. What I usually suggest is something like this: create a new (temporary) usergroup, then execute a query like this:
Code:

UPDATE user SET usergroupid=X WHERE username LIKE 'imported_%'

where you replace the X with the id of your temp group. Then go to "Users > Move/Prune users" and delete all the users from that usergroup.

As always it's a good idea to have a db backup before doing things like this.

adambloch 11-17-2012 07:57 PM

Thank you :) you just save me having to go through them 1 by 1 :)

Many thanks

Adam


All times are GMT. The time now is 05:19 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.02599 seconds
  • Memory Usage 1,707KB
  • 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
  • (3)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