HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Mass Deleting Imported Members

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#94238 (In Topic #18794)
Avatar

Community saint

Hi,

Is there some nifty OcCLE way to delete members?

I have imported some 25000 users into my test set up and would like to remove them to do a fresh import.

Or perhaps some one can guide me as to what could be deleted directly from the database ?

Cheers,
Ade
Back to the top
 
Posted
Rating:
#94239
Avatar

Maybe you can use the Delete Lurkers feature, with very low threshold settings.

Alternatively here is some code that can run in OcCLE that deletes all non-default members (backup first):

Code

:require_code('ocf_members_action2');
   $rows=$GLOBALS['FORUM_DB']->query_select('f_members',array('id'));
   foreach ($rows as $row)
   {
      if ($row['id']>3)
      {
         ocf_delete_member($row['id']);
      }
   }

The number '3' could be altered to raise the cutoff point.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#94254
Avatar

Community saint

Hi Chris,

In readiness to bring the posts in I have deleted all the forum areas, so none of the users have an posts.
Deleting lurkers with 0 posts and points count or any setting that would require 0 has it return very quickly with 0 lurkers deleted - kind of expected really as it was not what it was designed for.

I tried your other solution but all it did was delete the user that I was logged on as. What is a "non-default" member ?

cheers,
Ade
Back to the top
 
Posted
Rating:
#94255
Avatar

The code supplied should delete all members with ID over 3. Default users are 1 (Guest), 2 (admin) and 3 (test). I'd therefore be surprised if it didn't delete the imported members.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#94256
Avatar

Community saint

Ok thanks Chris that makes sense

Cheers
Ade
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: