In the spirit of spring cleaning I gave the blog a major overhaul donated.
Links corrected images back properly linked, the completely revised and design last but not donated yet a whole new domain.
I hope you like it and now I'm back to blogging more frequently.
The move to WordPress was launched without problems, completely new WordPress install, accepted entries, comments and attachments with the WordPress tools and then search and replace in the database to repair the links.
There was a slight problem with the number of comments per post, but this was demonstrated by the below script fix quickly.
Here is a link that helped me very moving:
http://fkblog.de/wp/wordpress-letzte-kommentare-direkt-im-theme/
And the script:
<?php
include("wp-config.php");
mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die('Keine Verbindung zum Server.');
mysql_select_db(DB_NAME) or die ('Datenbank nicht gefunden.');
$query = mysql_query('SELECT ID, comment_count FROM '.$table_prefix.'posts;');
while ($row = mysql_fetch_array($query)) {
$q = mysql_query('SELECT COUNT(*) as counter FROM '.$table_prefix.'comments WHERE comment_post_ID = '.$row['ID'].';');
$r = mysql_fetch_array($q);
if($r['counter'] >= 0)
mysql_query('UPDATE '.$table_prefix.'posts SET comment_count = '.$r['counter'].' WHERE ID = '.$row['ID'].' LIMIT 1;');
}
echo "Fertig!";
?>
