select($PHPBBDB);
# Run The query
if (is_array($PHPBBEXCLUDED)) {
$counter = 0;
$countermax = count($PHPBBEXCLUDED) -1;
# Construct Excluded Query
$EXCLUDED_FORUM = "WHERE ";
foreach ($PHPBBEXCLUDED as $EXCLUDED) {
$EXCLUDED_FORUM .= "forum_id !=$EXCLUDED";
if ($counter < $countermax ) {
$EXCLUDED_FORUM .= " AND ";
}
$counter++;
}
$results = $wpdb->get_results("SELECT * FROM $TOPIC_TABLE $EXCLUDED_FORUM ORDER BY topic_time DESC LIMIT $LIMIT");
} else {
# No excluded Query
$results = $wpdb->get_results("SELECT * FROM $TOPIC_TABLE ORDER BY topic_time DESC LIMIT $LIMIT");
}
if ($results){
echo "";
# Loop away baby !
foreach ($results as $topic)
{
echo "- ";
echo "";
echo "$topic->topic_title";
echo "";
if ($PHPBBDATE != "") {
echo "
\n";
echo "" . date("$PHPBBDATE", $topic->topic_time) . "\n";
}
echo " ";
}
echo "
";
} else {
echo " phpBB Error -$TOPIC_TABLE
";
}
# Connect back to wordpress :-)
$wpdb->select(DB_NAME);
?>