I whipped up something real dirty as a php page.
<?php
$db_connvalue = db_connect() || die(mysql_error());
function db_connect()
{
$db_server = 'localhost';
$db_name = 'dbname';
$db_user = 'user';
$db_passwd = 'password';
$result = @mysql_connect($db_server, $db_user, $db_passwd);
if (!$result)
return false;
if (!mysql_select_db($db_name))
return false;
return $result;
}
if ($db_connvalue)
{
$result = mysql_query("SELECT * FROM `smf_sp_categories` WHERE `articles` > 0 LIMIT 0 , 30");
$numrows = mysql_numrows($result);
$i = 0;
echo '<h1>Articles</h1>';
while ($i < $numrows)
{
$catname=mysql_result($result,$i,"name");
$id_cat=mysql_result($result,$i,"ID_CATEGORY");
echo '<h3>', $catname, '</h3>';
$catis = $id_cat;
$result1 = mysql_query("SELECT * FROM `smf_sp_articles` WHERE approved = 1 AND ID_CATEGORY =$catis ORDER BY ID_MESSAGE LIMIT 0 , 30");
$numrowsj = mysql_numrows($result1);
$j = 0;
echo '<ul>';
while ($j < $numrowsj)
{
$id_thismessage =mysql_result($result1,$j,"ID_MESSAGE");
$query = "SELECT * FROM `smf_messages` WHERE `ID_MSG` =$id_thismessage LIMIT 0 , 30";
$result2 = mysql_query($query);
$id_topic=mysql_result($result2,0,"ID_TOPIC");
$id_message=mysql_result($result2,0,"ID_MESSAGE");
$id_subject=mysql_result($result2,0,"subject");
$id_postername=mysql_result($result2,0,"posterName");
echo '<li><a href="http://yoursite.com/smf/index.php/topic,', $id_topic,'.0.html">', $id_subject, '</a> by: ', $id_postername, '</li>';
$j++;
}
echo '</ul>';
$i++;
}
mysql_free_result($result);
}
?>