WordPress has the ability to allow post authors to assign custom fields to a post. This arbitrary extra information is known as meta-data. This meta-data can be used by theme authors to do some pretty cool things.
The theme I am currently using allows for a custom field named “thumb”. If you create the “thumb” custom field in a post and pass in the path to an image, for example “wp-content/uploads/2008/12/wordpress_logo.png”, a thumb nail version of the image will appear next the posts title on the home page of my blog. Awesome stuff.
When I discovered this theme and the “thumb” custom field, I already had 225 posts in my blog. I didn’t want to go back and manually create all the custom fields for the existing posts, so I wrote a PHP script to do it for me.
The PHP script cycles through your existing posts and looks for the first image in the post, and creates the thumb field based on it’s location. The script is configurable, your theme may want a different custom field name, like “thumbnail” or “image”.
This code is provided as is. If you aren’t a developer, you should be messing with stuff like this. Be sure to back up your wordpress database before running this.
Instruction:
- download this code
- configure the database connection info and custom field name
- upload this code onto your server
- point your browser to the file
- watch the script do it’s magic
- remove the file from your server
- donate $2 to my paypal account ([email protected])
Note: This is a one time deal, when you create new posts you will need to add the “thumb” field and image path manually
//your database configuration information
$username = "YOUR_USER_NAME";
$password = "YOUR_PASSWORD";
$database = "DATABASE";
$databaseLocation = "localhost";
//name of the Custom Field to use
$customFieldName = "thumb";
/******************* END CONFIGURATION *****************************/
//get the wordpress posts to work with
$query = "SELECT * FROM wp_posts";
if ($result = $mysqli->query("$query"))
{
//loop over all the posts
while ($row = $result->fetch_object())
{
//get all the info from the post that we need to work with
$cur_post_id = $row->ID;
$cur_post_content = $row->post_content;
//the pattern to find the html image tag
$pattern = '/]+src[\\s=\'"]';
$pattern .= '+([^"\'>\\s]+)/is';
//try to match the pattern against the post content
if(preg_match($pattern,$cur_post_content,$match))
{
//break up the image path
$pieces = explode("wp-content/", $match[1]);
//make sure the file name isnt empty
if($pieces[1] != "")
{
//build the file path
$imagePath = "wp-content/" . "$pieces[1]";
//insert the custom field for the post
$insertQuery = "INSERT INTO wp_postmeta (post_id, meta_key, meta_value) VALUES ($cur_post_id, '$customFieldName', '$imagePath')";
$mysqli->query("$insertQuery");
//debugging stuff
if ($mysqli->errno)
{
printf("failed: %s \n", $mysqli->error);
}
else
{
echo "..... inserting $imagePath \n";
}
flush();
}
}
}
}
echo "---completed---";
?>