I have an acquaintance/client who contacted me because they're in need of help cleaning up their site. Long story short they've done a terrible job of keeping up with moderation and now they have 426,000 posts of which about 415,000 are spam and awaiting moderation. They had 80,000+ spam user registrations that I was able to pare down via phpmyadmin down to the 2,500 or so real members, but 400K posts is a bit daunting a task to do piecemeal.
And unfortunately it can't be pruned because due to the sheer volume of posts in need of moderation, vb AdminCP crashes every time you attempt removal.
I'm looking to just delete every post that came after a specified date - what command could I run to affect that result?
Thanks,
Jeff
And unfortunately it can't be pruned because due to the sheer volume of posts in need of moderation, vb AdminCP crashes every time you attempt removal.
I'm looking to just delete every post that came after a specified date - what command could I run to affect that result?
Thanks,
Jeff
Comment