<?php
require_once('wp-config.php');

// préfix des noms de table wordpress (par defaut = wp_)
$wp_prefix = 'wp_';
// id de votre blog dotclear (à récupérer dans le tableau de bord du blog)
$blog_id = 'dcblogid';
// Chemin vers le répertoire public de dotclear - sert à y sauvegarder automatiquement l'export
$path2dotclearPublic = '../dotclear2/public'; // sans / à la fin

/********** NE PAS EDITER APRES CETTE LIGNE ***************************/

$timezone = 'paris/france';

$flattxt[] = '///DOTCLEAR|2.0-beta6|single';
$flattxt[] = '';

//Export des catégories
$query = 'SELECT 
cat_ID as cat_id,
"'.$blog_id.'" as blog_id,
cat_name as cat_title,
category_nicename as cat_url,
category_description as cat_desc,
cat_ID as cat_position 
FROM '.$wp_prefix.'categories';
$result = mysql_query($query);

$flattxt[] = '[category cat_id,blog_id,cat_title,cat_url,cat_desc,cat_position]';
while($value = mysql_fetch_assoc($result))
{
	$flattxt[] = '"'.implode('","',$value).'"';
}

$flattxt[] = '';

//POST
$query = 'SELECT 
post.ID as post_id,
"'.$blog_id.'" as blog_id,
user.display_name as user_id,
"" as cat_id,
post.post_date as post_dt,
UNIX_TIMESTAMP(post.post_date) as timestamp,
"'.$timezone.'" as post_tz,
post.post_date as post_creadt,
post.post_modified as post_upddt,
post.post_password as post_password, 
"post" as post_type,
"xhtml" as post_format,
post.post_name as post_url,
"" as post_lang,
post.post_title as post_title,
post.post_excerpt as post_excerpt,
post.post_excerpt as post_excerpt_xhtml,
post.post_content as post_content,
post.post_content as post_content_xhtml,
"" as post_notes,
"" as post_words,
"" as post_meta,
post.post_status as post_status,
"0" as post_selected,
post.comment_status as post_open_comment,
post.ping_status as post_open_tb,
post.comment_count as nb_comment,
"" as nb_trackback
FROM '.$wp_prefix.'posts as post
INNER JOIN '.$wp_prefix.'users as user ON user.ID=post.post_author';
$result = mysql_query($query);

$flattxt[] = '[post post_id,blog_id,user_id,cat_id,post_dt,post_tz,post_creadt,post_upddt,post_password,post_type,post_format,post_url,post_lang,post_title,post_excerpt,post_excerpt_xhtml,post_content,post_content_xhtml,post_notes,post_words,post_meta,post_status,post_selected,post_open_comment,post_open_tb,nb_comment,nb_trackback]';
while($value = mysql_fetch_assoc($result))
{
	// post_url = reformat dans la boucle Ex =  2007/03/09/290-trouver-moi-une-petit-image/
	$value['post_url'] = date('Y/m/d',$value['timestamp']).'/'.$value['post_id'].'-'.$value['post_url'];
	unset($value['timestamp']);

	$value['post_content'] = apply_filters('the_content', $value['post_content']);
	$value['post_content_xhtml'] = apply_filters('the_content', $value['post_content_xhtml']);

	if($value['post_status'] == 'publish') $value['post_status'] = 1; else $value['post_status'] = 0;
	if($value['post_open_comment'] == 'open') $value['post_open_comment'] = 1; else $value['post_open_comment'] = 0;
	if($value['post_open_tb'] == 'open') $value['post_open_tb'] = 1; else $value['post_open_tb'] = 0;

	$value['cat_id'] = mysql_result(mysql_query('SELECT category_id 
		FROM '.$wp_prefix.'post2cat
		WHERE post_id='.$value['post_id'].' ORDER BY rel_id ASC LIMIT 0,1'),0,0);

	foreach($value as $k=>$v)
	{
		$value[$k] = ereg_replace('"','\"',ereg_replace("\n",'\n',ereg_replace("\r",'\r',$v)));
	}
	
	$flattxt[] = '"'.implode('","',$value).'"';
}


//Export des commentaires
$query = 'SELECT 
comment_ID as comment_id,
comment_post_ID as post_id,
comment_date as comment_dt,
"'.$timezone.'" as comment_tz,
comment_date as comment_upddt,
comment_author as comment_author,
comment_author_email as comment_email,
comment_author_url as comment_site,
comment_content as comment_content,
"" as comment_words,
comment_author_IP as comment_ip,
comment_approved as comment_status,
"0" as comment_spam_status,
"" as comment_spam_filter,
"0" as comment_trackback
FROM '.$wp_prefix.'comments';
$result = mysql_query($query);

$flattxt[] = '[comment comment_id,post_id,comment_dt,comment_tz,comment_upddt,comment_author,comment_email,comment_site,comment_content,comment_words,comment_ip,comment_status,comment_spam_status,comment_spam_filter,comment_trackback]';
while($value = mysql_fetch_assoc($result))
{
	if($value['comment_status']=='spam')
	{
		$value['comment_status'] = 0;
		$value['comment_spam_status'] = 1;
	}
	
	$value['comment_content'] = apply_filters('the_content', $value['comment_content']);

	foreach($value as $k=>$v)
	{
		$value[$k] = ereg_replace('"','\"',ereg_replace("\n",'\n',ereg_replace("\r",'\r',$v)));
	}
	
	$flattxt[] = '"'.implode('","',$value).'"';
}

$flattxt[] = '';
$flattxt[] = '';

$flattxt = implode("\n",$flattxt);

if(is_dir($path2dotclearPublic))
{
	$fp = fopen($path2dotclearPublic.'/'.$blog_id.'-backup.txt','w+');
	fputs($fp,$flattxt, strlen($flattxt));
	fclose($fp);
}

header('content-type:text/plain');
echo $flattxt;
?>