select($PHPBBDB);
# Run The query
$results = $wpdb->get_results("SELECT * FROM $TOPIC_TABLE ORDER BY topic_time DESC LIMIT $LIMIT");
if ($results){
//Pega o texto do primeiro post do topico
echo "";
# Loop away baby !
foreach ($results as $topic)
{
$primeiropost = $wpdb->get_results("SELECT * FROM phpbb_posts WHERE topic_id = '" . $topic->topic_id . "' ORDER BY
post_time ASC LIMIT 1";
//tira o phpbb
$post = preg_replace("@\[[\/\!]*?[^\[\]]*?\]@si", "", $primeiropost->post_text);
echo "- ";
echo "";
echo "$topic->topic_title";
echo "";
echo "
\n";
echo "$post
\n";
echo "" . date("d/M/y - g:i a", $topic->topic_time) . "\n";
echo " ";
}
echo "
";
} else {
echo " phpBB Error
";
}
# Connect back to wordpress :-)
$wpdb->select(DB_NAME);
?>