hi bro, how did u make the integration with ur forum
which script works?
i tried this.
<?php
function show_posts($limit = 5)
{
global $wpdb;
//Put your phpBB and wordpress database info here:
$WPDB = "DB"; //WP db name
$PHPBBDB = "DB"; //phpBB db name
$USERS_TABLE = "phpbb3_users"; //phpbb user table
$TOPICS_TABLE = "phpbb3_topics"; //phpbb topics table
$POSTS_TABLE = "phpbb3_posts"; //phpbb posts table
$SITEURL = "http://www.mhfc.co.il/forum/"; //Forum URL with trailing /
//Do not edit beyond this point
$lastfpost = 0;
$top5=array(-1,-1,-1,-1,-1,-1,-1,-1,-1,-1);
$wpdb->select($PHPBBDB);
$test = 0;
$results = $wpdb->get_results("SELECT * FROM $POSTS_TABLE ORDER BY post_time DESC");
if ($results)
{
foreach ($results as $post)
{
$user = $wpdb->get_row("SELECT * FROM $USERS_TABLE WHERE user_id = $post->poster_id");
$forum = $wpdb->get_row("SELECT * FROM $TOPICS_TABLE WHERE forum_id = $post->forum_id");
$topic = $wpdb->get_row("SELECT * FROM $TOPICS_TABLE WHERE topic_id = $post->topic_id");
$test = 0;
for($i=0;$i<=$limit;$i++){
if($topic->topic_id==$top5[$i]){ $test=1; }
}
if($user && $topic && $test==0)
{
$top5[$lastfpost]=$topic->topic_id;
$lastfpost += 1;
echo "
<li><a>forum_id&t=$post->topic_id'>";
$nposts=$topic->topic_replies+1;
echo "$topic->topic_title\n";
echo "</a>\n";
echo " at " . date("F j, Y - H:i", $post->post_time) . " \n";
echo "($nposts)</li>
\n";
if($lastfpost == $limit){ break; }
}
}
}
$wpdb->select($WPDB);
}
?>
and nothing happen
any help?
