Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 15 Jan 2009, 14:13
Urinemachine Urinemachine is offline
 
Join Date: Apr 2007
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 15 Jan 2009, 14:53
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Real name: Jarvis
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.
__________________
vBulletin Services and vBulletin Hosting
Reply With Quote
  #3  
Old 15 Jan 2009, 17:41
Bellardia Bellardia is offline
 
Join Date: Jul 2007
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 17 Jan 2009, 04:03
Urinemachine Urinemachine is offline
 
Join Date: Apr 2007
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 17 Jan 2009, 04:06
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Real name: Jarvis
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.
__________________
vBulletin Services and vBulletin Hosting
Reply With Quote
  #6  
Old 17 Jan 2009, 04:34
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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:
Deleting the first post of a thread will result in the deletion of the thread.
That's using the inline moderation tool.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #7  
Old 17 Jan 2009, 05:00
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Real name: Jarvis
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
__________________
vBulletin Services and vBulletin Hosting
Reply With Quote
  #8  
Old 17 Jan 2009, 05:58
Digital Jedi's Avatar
Digital Jedi Digital Jedi is offline
 
Join Date: Oct 2006
Real name: Mark Daniel Martinez
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:


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

Just make sure you add your table prefix to post.
__________________
Reply With Quote
  #9  
Old 17 Jan 2009, 12:57
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
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.
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #10  
Old 18 Jan 2009, 05:52
Urinemachine Urinemachine is offline
 
Join Date: Apr 2007
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mini Mods GS - Delete Soft Deleted Posts Every 30 Days 1.0 ForumsMods vBulletin 3.7 Add-ons 20 02 Jan 2013 08:45



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 15:02.

Layout Options | Width: Wide Color: