Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
Reload this Page Need a MOD to mass delete users with 0 posts
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
Page 1 of 2 1 2
 
Thread Tools Display Modes
  #1  
Old 11-28-2008, 09:00 PM
Eric HRF's Avatar
Eric HRF Eric HRF is offline
 
Join Date: Feb 2005
Location: Birmingham, AL.
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Need a MOD to mass delete users with 0 posts
Need a MOD to mass delete users with 0 posts to make my life easier!

TIA

Eric
Reply With Quote
  #2  
Old 11-28-2008, 09:05 PM
Seven Skins's Avatar
Seven Skins Seven Skins is offline
 
Join Date: Sep 2008
Location: London, UK
Posts: 1,481
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
You dont need a MOD goto adminCP > users > prune/move users ... search and delete them.

.
Reply With Quote
  #3  
Old 11-28-2008, 09:14 PM
Eric HRF's Avatar
Eric HRF Eric HRF is offline
 
Join Date: Feb 2005
Location: Birmingham, AL.
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thank You!
Reply With Quote
  #4  
Old 10-29-2009, 04:48 PM
LeHHeL LeHHeL is offline
 
Join Date: Oct 2009
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Unfortunatelly if I have thousand of users (spammers) it will not delete, will say invalid action .... :-(

So I need to delete now manually, in a way ...
Reply With Quote
  #5  
Old 10-29-2009, 05:09 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
What group are they in?
Reply With Quote
  #6  
Old 10-29-2009, 05:14 PM
LeHHeL LeHHeL is offline
 
Join Date: Oct 2009
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
around 2000 (already deleted) was in Awaiting autorization, the rest are - Users Awaiting Email Confirmation.

--------------- Added [DATE]1256840162[/DATE] at [TIME]1256840162[/TIME] ---------------

Strange if I delete around 10-20 is OK, but if I delete all from the page (I think 100) then not delete.

--------------- Added [DATE]1256840274[/DATE] at [TIME]1256840274[/TIME] ---------------

Users Awaiting Email Confirmation 5,655 (of course all spam) - now I found how to stop, but this was there and I need to delete.
Reply With Quote
  #7  
Old 10-29-2009, 05:57 PM
James Birkett James Birkett is offline
 
Join Date: Jun 2009
Posts: 633
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Hmm. SQL query?
Code:
DELETE * FROM user WHERE posts = 0
Reply With Quote
  #8  
Old 10-29-2009, 06:01 PM
LeHHeL LeHHeL is offline
 
Join Date: Oct 2009
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Is this safe ?
I mean no other table are connected?
Reply With Quote
  #9  
Old 10-29-2009, 06:57 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Do not delete manually as James stated, as that wouldn't remove all info.

Create a new usergroup called spammers, move all the users awaiting into that group, then mass delete thru that group, i believe user awaiting falls into the protected groups when using that tool.
Reply With Quote
  #10  
Old 10-29-2009, 08:16 PM
LeHHeL LeHHeL is offline
 
Join Date: Oct 2009
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I have done that but I cannot move to that Spammers group. If I select 20 I can, if I select more I get error and not move.
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

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
Forum Jump


All times are GMT. The time now is 02:16 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04419 seconds
  • Memory Usage 2,239KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete