Taking Chances with Ones and Zeroes
September 16th, 2008
I just went into a live online database via PHPMyAdmin and deleted 22,000 spam comments from a client’s Wordpress blog all at once. That’s the first actual database operation I’ve ever done! Scary, even with a backup. Not that I want to make a habit of it — too much potential for destruction. But I can now claim to have executed a command that looks like this:
SELECT *FROM wp_comments WHERE comment_approved =”0″
delete from wp_comments WHERE comment_approved =”0″
And lived to tell the tale. Thanks to this guy for the instructions.
– cpd
Robot-Selected "Related" Articles:
- Convio Opens API to Developers; Also Embraces Facebook, Widgets and More
- The Politico Grabs Online Ad Guru Waldo Tibbetts from the Post
- Indecision 2.008 — The Daily Show Takes On E-Politics
- At Digital Media Conference
- How Are Candidates Spending Their Money Online?
2 Comments Add your own
1. Tiffany de Lisio | September 17th, 2008 at 8:31 am
can you explain how to post an article/.pdf on a website via wordpress or server? I also wondered is there is a way to layer pages rather than blog. If this is cutting into your income generating secrets, no worries, just asking. : ) I give free legal information all the time and people still need lawyers… hah!
2. cpd | September 17th, 2008 at 11:23 am
Hey Tiffany, it depends on which HTML editor is built into the version of Wordpress you use. The default editor is a bit of a pain, so I’ve been using a ($50) editor called WysiwigPro 3 on client sites lately — it handles images and files well, and also cleans up the crappy code that comes out when you paste something from Word.
For instructions using the default editor, try this. BTW, on e.politics I run it old-school — FTP the docs up and link to them in the code. Helps keep those mad HTML skillz fresh.
Help build e.politics
Make a comment, correct my errors, suggest more tools and tactics, leave a case study, or otherwise make this page a better resource.
Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Trackback this post | Subscribe to the comments via RSS Feed