Mass Remove Blog Posts
Mod Version: 1.00, by TheInsaneManiac
| vB Version: 4.2.x | Rating:  (0 vote - 0 average) |
Installs: 3 |
| Released: 10 Jan 2013 | Last Update: Never | Downloads: 0 |
 Not Supported
 DB Changes
Re-usable Code
|
||
Be sure to make backups of your database or at least the following tables:
blog
blog_text
blog_subscribeentry
Now you will need some skills in phpmyadmin and mySQL, but basically login to phpmyadmin and search the blog table and see where your spam first began. I will use the 1000th line as example. You will need to run the following query as it will delete anything posted after the 1000th blog post, simply edit the query to reflect the actual numbers you found inside the blog table. Also change the "prefix_" to your prefix in the database rather it be vb_ or vb4_
blog
blog_text
blog_subscribeentry
Now you will need some skills in phpmyadmin and mySQL, but basically login to phpmyadmin and search the blog table and see where your spam first began. I will use the 1000th line as example. You will need to run the following query as it will delete anything posted after the 1000th blog post, simply edit the query to reflect the actual numbers you found inside the blog table. Also change the "prefix_" to your prefix in the database rather it be vb_ or vb4_
Code:
delete from prefix_blog where blogid > 1000; delete from prefix_blog_text where blogid > 1000; delete from prefix_blog_subscribeentry where blogid > 1000;
Download
No files for download.