#!/usr/bin/php4 -q
<?php
/*
This script converts sphpblog content to WordPress content.
Use at own risk.

sphpblog2wp conversion script - copyright (c) 2005 Jan De Luyck
Modified 2006 by Per F Pettersson [p (at) pelpet.com] 

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

The full text of the license can be found here:
http://www.gnu.org/licenses/gpl.txt

*/


/* SETTINGS */
$dir = "whereever/blog/content/05/10";			// point this to a month folder!


$db_host = "localhost";
$db_name = "database_name";
$db_user = "database_username";
$db_pass = "should_be_secret";


/* SCRIPT */
/* dont change anything below here. Well, you can, but if it breaks
   you get to keep all the pieces! */

// connect to the allmighty database
// we assume mysql. mysql is allmighty.
echo "Connecting to MySQL...\n";

$db = mysql_connect($db_host, $db_user, $db_pass);
if (! $db)
{
	echo "ERROR: could not connect to mysql!\n";
	exit -1;
}
$ret = mysql_query("SET NAMES 'utf-8'"); 
echo "MYSQL SET UTF8: " . $ret . "\n";
if (! mysql_select_db($db_name))
{
	echo "ERROR: could not connect to the $db_name database!\n";
	exit -1;
}

echo "Starting run for $dir...\n";



/* TEST CODE DOESNT WORK  
chdir($dir); 
echo "TOPDIR" . $topdir . "IS DIR: " . is_dir($topdir) . "\n";
if ($dh_top = opendir($topdir))
{
while (($dh_year = readdir($dh_top)) !== false)
{

if ($dh_year == '.') break();
if ($dh_year == '..') break();
if (!(is_dir($dh_year))) break();

echo "DH_YEAR" . $dh_year . "IS DIR: " . is_dir($dh_year) . "\n";

if ($dh_month = opendir($dh_year))
{

while (($dir = readdir($dh_month)) !== false)
{
END TEST CODE */

if (is_dir($dir))
{
	echo "Is dir\n";
	if ($dh = opendir($dir))
	{
		echo "Open dir $dir\n";
		while (($file = readdir($dh)) !== false)
		{
			echo "Doing $dh\n";
			unset ($temp);
			unset ($temp2);
			unset ($postdata);

			$post = $dir . '/' . $file;
			if (is_dir($post))
				continue;

			$commentdir = $dir . '/' . substr($file,0,-4) . '/comments';

			$postdata = file_get_contents($post);

			$temp = explode("|", $postdata);
			/* echo "$postdata \n"; */
			$temp2["subject"] = mysql_escape_string($temp[3]);
			echo "Subject:". $temp2["subject"] . "\n";
			$temp2["body"] = mysql_escape_string($temp[5]);
			$temp2["body"] = str_replace("[url=","<a href=",$temp2["body"]);
			$temp2["body"] = str_replace("[/url]","</a>",$temp2["body"]);
			$temp2["body"] = str_replace("[","<",$temp2["body"]);
			$temp2["body"] = str_replace("]",">",$temp2["body"]);

                        $temp2["body"] = utf8_encode($temp2["body"]); 
                        $temp2["subject"] = utf8_encode($temp2["subject"]); 


			echo "Body:". $temp2["body"] . "\n";

			$temp2["date"] =	$temp[9];
			echo "Date:". $temp2["date"] . "\n";

			$sql = "insert into wp_posts 
(post_author,post_date,post_date_gmt,post_content,post_title,post_category,post_excerpt,post_status,comment_status,ping_status,post_name,post_parent,menu_order) 
values (
					
					1,
					'" . date("Y-m-d H:i:s", $temp2["date"]) . "',
					'" . date("Y-m-d H:i:s", $temp2["date"] - (2*3600)) . "' ,
					'" . $temp2["body"] . "',
					'" . $temp2["subject"] . "',
					0,
					'',
					'publish',
					'open',
					'open',
					
					'" . substr($post["subject"],0,200) . "',
					0,
					0)";
                        echo "QUERY: " . $sql . "\n";
			
			/* FIX ÅÄÖ */
			/* echo mysql_query("SET names 'latin1'"); */ 
			$res = mysql_query($sql);
			echo "MYSQL: " . $res . "\n";
			$res = mysql_query("select max(id) from wp_posts;");
			$postID = mysql_result($res,0);

			echo "Post: $post, inserted as ID $postID\n";

			if (file_exists($commentdir) && is_dir($commentdir))
			{
				$pdh = opendir($commentdir);

				while (($commentfile = readdir($pdh)) !== false)
				{
					if (is_dir($commentdir . '/' . $commentfile))
						continue;

					$comment = file_get_contents($commentdir . '/' . $commentfile);
					$temp = explode("|", $comment);

					$temp2["author"] = utf8_encode(mysql_escape_string($temp[3]));
					$temp2["date"] = utf8_encode($temp[5]);
					$temp2["body"] = utf8_encode(mysql_escape_string($temp[7]));
					$temp2["email"] = utf8_encode(mysql_escape_string($temp[9]));
				/* FIX URL */
			$temp2["body"] = str_replace("[url=","<a href=",$temp2["body"]);
			$temp2["body"] = str_replace("[/url]","</a>",$temp2["body"]);
			$temp2["body"] = str_replace("[","<",$temp2["body"]);
			$temp2["body"] = str_replace("]",">",$temp2["body"]);
					




					$sql="iNSERT INTO wp_comments 
(comment_post_id,comment_author,comment_author_email,comment_date,comment_date_gmt,comment_content,comment_karma,comment_approved,comment_agent,comment_parent,user_id)
					VALUES (
					'" . $postID . "',
					'" . $temp2["author"] . "',
					'" . $temp2["email"] . "',
					'" . date("Y-m-d H:i:s", $temp2["date"]) . "',
					'" . date("Y-m-d H:i:s", $temp2["date"] - (2*3600)) . "' ,
					'" . $temp2["body"] . "',
					0,
					'1',
					'sphpblog2wp',
					0,
					0)";
					echo "COMMENT QUERY:\n" . $sql . "\n"; 
					$ret = mysql_query($sql);
					echo "MYSQL COMMENT INSERT: ". $ret ."\n";
					$res = mysql_query("select max(comment_id) from wp_comments;");
					$commentID = mysql_result($res,0);


					echo "-- Comment: $commentdir/$commentfile, inserted as ID $commentID\n";
				}

				closedir($pdh);

       		}
       	}

		closedir($dh);

		echo "Done!\n";
   }
}
else echo "Not a directory\n";
mysql_close($db);
/* BELONGS TO TEST CODE }}}} */
?>