Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-15-2009, 01:13 PM
Urinemachine Urinemachine is offline
 
Join Date: Apr 2007
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Deleted user, now how to delete posts?

Hello - I deleted a user and their name says guest under it now, which is good. But, their posts still show.

Can I delete their posts somehow in a graceful manner? I could do a SQL query and just start dropping things but I think that'd get hairy.

Also, can I delete their posts even if they're the original poster (thread starter) and still have their thread remain? IE - make the 2nd post the first post of the thread since the user I want to delete will be removed?

Thanks all
Reply With Quote
  #2  
Old 01-15-2009, 01:53 PM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm not so sure its possible now that you've deleted the user. You need to delete the posts before deleting the user.

One way to try is to register a new user with that username and run the maintenance tools for rebuilding information and see if they get reassociated with his account by chance, then remove the posts and then the user.

It should only remove his posts, and no one elses. So if he started a thread, it should remain while his first post is gone.
Reply With Quote
  #3  
Old 01-15-2009, 04:41 PM
Bellardia Bellardia is offline
 
Join Date: Jul 2007
Location: Hamilton, Ontario
Posts: 378
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You could forcefully change a new users userid to the user id of the one you deleted (If you can find it somewhere). All posts will be associated with this user and delete the posts.
Reply With Quote
  #4  
Old 01-17-2009, 03:03 AM
Urinemachine Urinemachine is offline
 
Join Date: Apr 2007
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If the user created a thread and I delete his posts, will the thread be deleted? Or will the 2nd poster inherit the thread?
Reply With Quote
  #5  
Old 01-17-2009, 03:06 AM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Urinemachine View Post
If the user created a thread and I delete his posts, will the thread be deleted? Or will the 2nd poster inherit the thread?
The second post will become the first unless you delete the whole thread.
Reply With Quote
  #6  
Old 01-17-2009, 03:34 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by FRDS View Post
The second post will become the first unless you delete the whole thread.
I think you may be wrong here. I know if I try to delete the first post of a thread when on the site, I get told:
Quote:
Deleting the first post of a thread will result in the deletion of the thread.
That's using the inline moderation tool.
Reply With Quote
  #7  
Old 01-17-2009, 04:00 AM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Lynne View Post
I think you may be wrong here. I know if I try to delete the first post of a thread when on the site, I get told:


That's using the inline moderation tool.
First time for everything

Really though, i always thought it just deleted the first post
Reply With Quote
  #8  
Old 01-17-2009, 04:58 AM
Digital Jedi's Avatar
Digital Jedi Digital Jedi is offline
 
Join Date: Oct 2006
Location: PopCulturalReferenceLand
Posts: 5,171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It will delete the whole thread, sadly.

Just in case you couldn't find it, the SQL Query for restoring a Guest post to it's original user name is:

PHP Code:
UPDATE post SET userid='xxx' WHERE username='Old Name'
Just make sure you add your table prefix to post.
Reply With Quote
  #9  
Old 01-17-2009, 11:57 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Depends how you delete his posts. If it is a single query to the post table, the thread information and the rest of the posts will still exist in the database, but the thread will not be displayed on the front-end.
Reply With Quote
  #10  
Old 01-18-2009, 04:52 AM
Urinemachine Urinemachine is offline
 
Join Date: Apr 2007
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

So I can restore them back to users from guest, then delete psots from user? That will take the thread out though if they started it? Is there a way to split the thread from the second post onward? I have a couple threads 20 pages long that i could split at post #2 and then delete the post and user after
Reply With Quote
Reply


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:09 AM.


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.05186 seconds
  • Memory Usage 2,250KB
  • Queries Executed 13 (?)
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_php
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (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_postinfo_query
  • fetch_postinfo
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete