you could also do a MySQL dump of the posts in UPDATE format. Then go through the posts in the .sql file and change the dates to the preferred date and then reimport the .sql file. This should take about 15 minutes beginning to end.
Anybody Know of a Wordpress Plugin/Script That Automatically Posts Blog Entries?
- Thread starter Frank E
- Start date
- Status
I haven't tested this code, but this should do what you're looking for. Copy this code into a PHP file, change the parameters, and point your browser to the page to run it. Back up your database before running it in case it screws something up.
PHP:
<?
//database parameters
$dbHost = "localhost";
$dbUser = "username";
$dbPass = "password";
$dbName = "database";
//start and end ID of the posts to modify
$startPost = 100;
$endPost = 200;
//time the first post
$postHr = 12;
$postMin = 34;
$postSec = 56;
//date of the first post
$startMonth = 5;
$startDay = 1;
$startYear = 2008;
//amount to increment between posts
$dateIncrement = "+1 day";
$postDate = mktime($postHr,$postMin,$postSec,$startMonth,$startDay,$startYear);
$postDate_gmt = gmmktime($postHr,$postMin,$postSec,$startMonth,$startDay,$startYear);
mysql_connect($dbHost,$dbUser,$dbPass);
mysql_select_db($dbName);
foreach(range($startPost,$endPost) as $post)
{
$sql = sprintf(strftime(strftime("UPDATE wp_posts SET post_date = '%Y-%m-%d %H:%M:%S', post_date_gmt = '%%Y-%%m-%%d %%H:%%M:%%S' WHERE ID = %%%%s",$postDate),$postDate_gmt),$post);
mysql_query($sql);
$postDate->modify($dateIncrement);
$postDate_gmt->modify($dateIncrement);
}
?>
this look like effing 3rd century mandarin chinese to me :s j/kMy original question was about how I take a blog that is fully configured then clone it quickly and easily. I have a great program called Blog master (private label) that does all the posting, scheduling, randomizing and uploading in seconds. It took about 1 hour to build a 20+ page UNIQUE content site in wordpress (just uploaded my articles). What I need is to be able to create the blogs - fully configured fast - does anyone know how to do this? Perhaps we can make a trade.....
- Status