Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 07 Nov 2014, 00:26
Outlaw Mantis Outlaw Mantis is offline
 
Join Date: Nov 2013
Reverse pruning - delete from a date?

Everywhere I've looked I seen that there "isn't an option" to delete users and to just use the prune feature. I've had a spam army register on my forum when I forgot to close it with registration protection enabled. My fault I know, but I have to fix this! However, the prune option is only for past dates.

The forum has been closed for a long time now and I plan to reopen it. This means that the mass registration all happened from a date when no human registrations were made. Therefore, an option to delete users from a date would fix the problem entirely. I can't delete users individually because there are so many, I'd be a skeleton. I thought about running an SQL query but fortunately read that it could wreck the forum before I actually did it.
Reply With Quote
  #2  
Old 07 Nov 2014, 00:29
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
The only thing you can do is prune the users. Login to your admincp and go to "Users>Prune/Move Users" and you can do it from there.
Reply With Quote
  #3  
Old 07 Nov 2014, 00:32
Outlaw Mantis Outlaw Mantis is offline
 
Join Date: Nov 2013
I already said that the options are before a date, not after.
Reply With Quote
  #4  
Old 07 Nov 2014, 00:40
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Originally Posted by Outlaw Mantis View Post
I already said that the options are before a date, not after.
Ah sorry I see what you are saying now. This is what I get for not being fully awake lol. You would probably have to hire a PHP coder for that I'm afraid. There is no built in way to remove users who signed up after a certain date.
Reply With Quote
  #5  
Old 07 Nov 2014, 00:46
Outlaw Mantis Outlaw Mantis is offline
 
Join Date: Nov 2013
It'll take quite a while, but I'll do it individually. It won't take as long as I thought it would, but still a while. I think it's silly that such a feature doesn't exist. For something you pay a lot of money for, it should have a primitive function.

But I'll be sure to add lots of spam protection! Don't worry about the tiredness. I know the feeling.
Reply With Quote
  #6  
Old 07 Nov 2014, 00:54
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
Untested!

Well make a backup of your site first, then you could try to run this query:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Set X to the usergroup you want to move them to.

To get the unix timestamp of the date you want see this site, http://www.unixtimestamp.com/

Then you can prune the users in that group.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #7  
Old 07 Nov 2014, 01:09
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Originally Posted by Outlaw Mantis View Post
It'll take quite a while, but I'll do it individually. It won't take as long as I thought it would, but still a while. I think it's silly that such a feature doesn't exist. For something you pay a lot of money for, it should have a primitive function.

But I'll be sure to add lots of spam protection! Don't worry about the tiredness. I know the feeling.
I agree when I actually got what you were saying and I looked at my vb admincp I was like that is stupid that its not set up that way.
Reply With Quote
  #8  
Old 07 Nov 2014, 01:42
Outlaw Mantis Outlaw Mantis is offline
 
Join Date: Nov 2013
Well I actually managed to deselect all of the "good" members. There are currently 240 bad users online despite the board being closed! I think since I'm deleting a couple of thousand, that's the reason I'm getting this error when I try to prune...

unused

The server encountered an internal error or misconfiguration and was unable to complete your request.
I might have to try ozzy47's method now. I think these spam bots are slowly my server down a lot and as a result, perhaps it's why I get the error. I can't exactly deselect one thousand user checkboxes in the prune form to see if selecting fewer spammers works...

Unless anyone has anything to add (especially regarding the error I got), I'll try out ozzy's suggestion in twenty minutes.

Edit: Actually, won't pruning the users in a new usergroup just give me the same error as I'm getting now?
Reply With Quote
  #9  
Old 07 Nov 2014, 01:44
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Yeah you might have to chose less to delete at one time if you are going to do it through the admincp.
Reply With Quote
  #10  
Old 07 Nov 2014, 01:58
Outlaw Mantis Outlaw Mantis is offline
 
Join Date: Nov 2013
I miscalculated. There are 5000 members. So I might have to deselect 2500 boxes if I go by half. I need to find a Chrome plugin to do this...
Reply With Quote
  #11  
Old 07 Nov 2014, 02:01
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Don't know much about using Chrome plugins I'm afraid. But yeah your server probably just went berserk when you selected too many to delete that happens sometimes.
Reply With Quote
  #12  
Old 07 Nov 2014, 02:21
Outlaw Mantis Outlaw Mantis is offline
 
Join Date: Nov 2013
I've been using this plugin for Firefox: https://addons.mozilla.org/en-US/fir...ddon/checkfox/
However, it only works some of the time and it's a pain highlighting and using the check/uncheck option when it doesn't work. I've tested the forum with selecting 400 users. That works. I'll try 1000 tomorrow if it works.

The problem with vB is how archaic its design is. It prunes users on one page of 100, then makes you proceed to the next page where it deletes another 100, etc. This is probably the reason it chokes with so many users. I'll let you know how many it can delete in one sweep tomorrow.
Reply With Quote
  #13  
Old 07 Nov 2014, 02:23
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Ok good luck!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 02:19.

Layout Options | Width: Wide Color: