The Joomla! Forum™

Code: Select all

<?php
/**
* Textonly convert to mambo
* @author Adam van Dongen
**/

$dir = "D:/Mijn_documenten/TIM/mambo/free/article_import/articles"; //directory that contains the files

$title_start = '<h3 class="post-title">';
$title_end = '</h3>';

$content_start = '<div class="post-body">';
$content_end = '<!-- Begin \#comments -->';

$date_start = '<h2 class="date-header">';
$date_end = '<!-- Begin .post -->';

$cat_id = 1; //categories in which all these articles will be inserted
$sectionid = 1; //section in which this categorie is.

$prefix = "mos_";

$files = readFilesFromDir($dir);

for($i=0,$n=count($files);$i<$n;$i++){
  //echo '-----------------------------------------------------------------<br /><br />';
  $file = file_get_contents($dir . "/" . $files[$i]);
  
  $title = preg_match('#' . $title_start . '(.*)' . $title_end . '#is', $file, $matches);

  $titel = strip_tags($matches[1]);
  //echo $titel . '<br />';
  
  $matches = null;
  $content = preg_match('#' . $content_start . '(.*)' . $content_end . '#is', $file, $matches);

  $content = addslashes(strip_tags($matches[1], '<b><br><br /><strong><em><table><td><tr><img>'));
  //echo $content . '<br />';
  
  $matches = null;
  $date = preg_match('#' . $date_start . '(.*)' . $date_end . '#is', $file, $matches);
  $date = strip_tags($matches[1]);
  
  //echo $date . '<br />';
  
  $date = explode(', ', $date);
  //print_r($date);
  $month = explode(" ", $date[1]);
  $day = $month[1];
  $month = convertToMonth($month[0]);
  $year = trim($date[2]);
  
  $date = $year . "-" . $month . "-" . $day;
  
  //echo $date . '<br />';
  
  //continue;
  
  $query = "INSERT INTO " . $prefix . "content (title, introtext, state, sectionid, catid, created) VALUES ('$titel', '$content', 1, $sectionid, $cat_id, '$date');\n";
  echo htmlentities($query, ENT_COMPAT, 'UTF-8') . '<br />'; 
}

function readFilesFromDir($dir){
  
  $array = array();
  
  if ($handle = opendir($dir)) {
    while (false !== ($file = readdir($handle))) {
      if ($file != "." && $file != "..") {
        $array[] = $file;
      }
    }
    closedir($handle);
  }
  
  return $array;
}

function convertToMonth($m){
  
  switch($m){
    case 'January':
      return "01";
      break;
    case 'February':
      return "02";
      break;
    case 'March':
      return "03";
      break;
    case 'April':
      return "04";
      break;
    case 'May':
      return "05";
      break;
    case 'June':
      return "06";
      break;
    case 'July':
      return "07";
      break;
    case 'August':
      return "08";
      break;
    case 'September':
      return "09";
      break;
    case 'October':
      return "10";
      break;
    case 'November':
      return "11";
      break;
    case 'December':
      return "12";
      break;
  }
}

?>

Code: Select all

$content = addslashes(strip_tags($matches[1], '<b><br><br /><strong><em>'));