Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • rcaweb how do u make the whole album to get load?

    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?

Viewing 2 replies - 1 through 2 (of 2 total)