Ofcourse, but don’t expect to much of it
(and above all, it’s very unclean code, but it worked for me).
<?php
$dbi = @mysql_connect('localhost', 'dbuser', 'dbpass') or die(mysql_error());
@mysql_select_db('dbname');
$query = 'SELECT * FROM ml_article';
$sth = mysql_query($query);
$menuindex = 7;
while($rec = mysql_fetch_object($sth))
{
$timestamp = strtotime($rec->DATE_CREATED);
$introtext = '';
$content = '';
if($rec->INTRO && $rec->DATA)
{
$introtext = $rec->INTRO;
$content = $introtext . $rec->DATA;
}
else
{
$content = $rec->INTRO;
}
$q = 'INSERT INTO modx_site_content';
$q .= '(type,contentType,pagetitle,longtitle,alias,published,pub_date,parent,isfolder,introtext,content,richtext,template,menuIndex,searchable,cacheable,createdby,createdon,editedby,editedon,hidemenu)';
$q .= 'VALUES(';
$q .= quote('document') . ',';
$q .= quote('text/html') . ',';
$q .= quote($rec->TITLE) . ',';
$q .= quote($rec->TITLE) . ',';
$q .= quote('article-' . $timestamp) . ',';
$q .= '1,';
$q .= $timestamp . ',';
$q .= '2,';
$q .= '1,';
$q .= quote($introtext) . ',';
$q .= quote($content) . ',';
$q .= '1,';
$q .= '1,';
$q .= $menuindex++ . ',';
$q .= '1,';
$q .= '1,';
$q .= '-1,';
$q .= $timestamp . ',';
$q .= '1,';
$q .= $timestamp . ',';
$q .= '1,';
$q = substr($q, 0, -1);
$q .= ')';
echo '<li>' . $q;
mysql_query($q) or die(mysql_error() . ' -- ' . $q);
}
function quote($str)
{
$str = str_replace("'", "''", $str);
return "'$str'";
}
?>
.
☆ A M B ☆