vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   delete guest posts (https://vborg.vbsupport.ru/showthread.php?t=272272)

pantani 10-18-2011 07:01 AM

delete guest posts
 
Hello,
I had to delete someone's account in a hurry, because of some major problems at home, i will not go in to detail with this, but now i have to delete this members posts, and you can not find the post under his name offcource, now all the posts of this person are with his name, for example "Jim" and under his name is Guestn so you can not find the posts "Jim" posted.
You have to look in topic per topic to find if he made a reply somewhere and delete it, so you can see this is impossible to do like this, so now the question, is there a way to delete all his post in one time?? But can't search his name because it's account is deleted.

Thank, hope there is a way :)

Phalynx 10-18-2011 08:07 AM

Execute this query:
Code:

DELETE FROM post WHERE username='Jim' AND userid=0
Add your DB-Prefix before "post", if you have one.

Nelson58 02-18-2013 02:23 PM

Where do you execute this inquiry, in PHPAdmin?

Thanks!

Nelson

ForceHSS 02-18-2013 03:48 PM

You can run it from the admin panel

Nelson58 02-27-2013 01:04 PM

Thanks Force, it works great!

Nelson


All times are GMT. The time now is 01:56 PM.

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.00959 seconds
  • Memory Usage 1,710KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete