|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
07-27-2007, 08:35 AM
|
#1 |
|
Amateur Pimpin
Industry Role:
Join Date: Aug 2004
Location: Orlando, FL
Posts: 13,075
|
WP Pros... deleting post comments?
I have a mainstream blog about sleeping and I find today I have over 31k comments spammed to it (like a dumbass I left the comments option on) how can I mass delete all the comments awaiting moderation?
When I go to mass edit, you only get a page of comments and I dont want to sit there for days deleting.
__________________
Make easy money with Webcams |
|
|
|
07-27-2007, 08:45 AM
|
#2 |
|
Confirmed User
Join Date: Jan 2005
Posts: 2,640
|
What you can do on that mass edit page is use the search bar and just type in a space. Once you do the search, all the comments that apply will show up instead of just 20. Since nearly all comments will have a space, you'll get almost all of them in one shot. It just may take a while for all 31k to load up on the page for you.
__________________
 viki [at] realsexcash [dot] com 228 263 454 |
|
|
|
|
07-27-2007, 08:52 AM
|
#3 |
|
Rock 'n Roll Baby!
Join Date: Sep 2004
Location: USA, temporarly
Posts: 22,562
|
mysql query for example.
__________________
Sig for sale. Affordable prices. Contact me and get a great deal ;) My contact: ICQ: 944-320-46 e-mail: manca {AT} HotFreeSex4All.com |
|
|
|
|
07-27-2007, 08:56 AM
|
#4 |
|
Confirmed User
Join Date: Jan 2006
Location: Gringo in Puerto Rico
Posts: 4,204
|
I'm pretty sure you could drop all the contents of the comments table in the wordpress database. Doing that you would loose any legit comments you have as well.
|
|
|
|
|
07-27-2007, 10:25 AM
|
#5 |
|
Too lazy to set a custom title
Industry Role:
Join Date: Sep 2003
Posts: 22,651
|
for a list of comments THAT big... your only choice is to kill'em with mysql. Talk to your host if you're not familiar with that
|
|
|
|
|
07-27-2007, 10:36 AM
|
#6 | |
|
Too lazy to set a custom title
Industry Role:
Join Date: Jun 2005
Location: 127.0.0.1
Posts: 27,047
|
Quote:
__________________
Make Money
|
|
|
|
|
