The part saying :var/www/virtual
can be different. Check your webhoster for the exact path

Good luck

I modified installation instructions.
I don't remember anymore if
include_once ('/home/mysite/public_html/forum/config.php');
has to include the domain.
Example:
include_once ('/home/mysite.com/public_html/forum/config.php');

P.S. Which vldpersonal version an template are you using?

PP.SS. Read my signature for another modification for PhpBB3. It's working great.

Last edited by orange_slice (2011-02-12 14:01:19)

I know it.
I asked just to modify the installation instructions to be more helpful for people that could have problems during installation.

I suppose both modifications shoud work with new vldpersonals versions.
About templates, I think customization needs just a little work.

I hope modifications help all people using phpBB3 into vldpersonals.

ok I solved it doing the it the proper way, instead of including it like suggested, I created standard extension and template and added new forumbox extension so now it can be used generally with different designs anywhere. works like  charm.

yes please share it

Orange

Thank you so much for the tutorial, I was able to follow along and feel like I have followed the directions as close as possible but I'm missing something.  I contacted my host provider and they gave me this information

"Checking your website, it looks like it should be /home/cplcplco/public_html/phpBB3/config.php - please note UNIX filenames are case sensitive, so it must be phpBB3 and not phpbb3, in addition to the difference in your username and public_html instead of public. Please let us know if we can be of any further assistance."

So I fixed the problems and it is still showing up with "could not connect".   I'm using vld 2.7 and phpBB3 v3.0.8 Here is the code that I pasted into latest_post.php

<?php
//    error_reporting(0);
    define('IN_PHPBB3', true);

include_once ('home/cplcplco/public_html/phpBB3/config.php');            //Path to phpBB Config File. Due to some restrictions by PHP, you have to provide complete physical path
$urlPath = "/phpBB3";                //phpBB URL with respect to root
$topicnumber = 5;            //Total Post Count to Display
$posttext = 200;                //Number of Characters to display in Post Text
$excludedforums = "0";        //Forum ids to exclude. Each forum id should be seprated with Comma
$completeurl = "http://www.cpl2cpl.com";

    $table_topics = $table_prefix. "topics";    //Usually you don't have to change below 4 variables
    $table_forums = $table_prefix. "forums";
    $table_posts = $table_prefix. "posts";
    $table_users = $table_prefix. "users";

function stripBBCode($text_to_search) {
     $pattern = '|[[\/\!]*?[^\[\]]*?]|si';
     $replace = '';
     return preg_replace($pattern, $replace, $text_to_search);
}

    $link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
    mysql_select_db("$dbname") or die("Could not select database");
    $sub_query = '';
    if(strlen($excludedforums) > 0) {
        $pieces = explode(",", $excludedforums);
        foreach ($pieces as $exforumid) {
            $sub_query .= " t.forum_id != " . $exforumid . ' AND ';
            }
    }

    $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username, f.forum_name, p.post_text, p.bbcode_uid, p.bbcode_bitfield, f.forum_desc_options
    FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
    WHERE t.topic_id = p.topic_id AND
    f.forum_id = t.forum_id AND ";

    if(strlen($sub_query) > 0) {
        $query .=  $sub_query ;
    }

    $query .= " t.topic_status <> 2 AND
    p.post_id = t.topic_last_post_id AND
    p.poster_id = u.user_id
    ORDER BY p.post_id DESC LIMIT $topicnumber";
    //echo $query;
    $result = mysql_query($query) or die("Query failed" . mysql_error($link));

    print "<div class=\"typecontent\">";
    if($topicnumber % 2) {
        $x="even";
    } else {
        $x="odd";
    }
    $y=0;
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    ++$y;
    if ($y==$topicnumber) {
        $x= $x .  " dataitemlast";
    }
    print "<div class=\"dataitem $x \">
                <table class=\"plain\">
                    <tr>
                        <td class=\"data\">
                                <div class=\"itemheader\">
                                    <h2 class=\"inner\">" .  $row["topic_title"] . "</h2>
                                        <ul class=\"itemheader\">
                                            <li>Posted at: " . date('F j, Y, g:i a', $row["post_time"])  . "</li>
                                            <li>By: <a href=\"$completeurl/$row[username]\">" .
                                            $row["username"]  . "</a></li> <li>In Forum: " . $row["forum_name"] . " </li>
                                        </ul>
                                </div>
                            <div class=\"entry\">" .
                                substr(stripBBCode($row["post_text"]),0,$posttext) . "<a href=\"$urlPath/viewtopic.php?f=$row[forum_id]&t=$row[topic_id]&p=$row[post_id]#p$row[post_id]\" style=\"text-decoration:none;font-weight:bold\"> Read more...</a>
                            </div>
                        </td>
                    </tr>
                </table>
                </div>";

                if ($x=="odd") {
                    $x="even";
                } else {
                    $x="odd";
                }

}
print "<div class=\"clear\"></div></div>";
    mysql_free_result($result);
//  mysql_close($link);
?>

Thanks for the help in advance,

Chudson, by default, it should be phpBB3, but you can change it to be "phpbb3"or "forum" whatever you want under your site root, you also need change in forum PC > General > server settings > script path. keep same.

I don0t understand the problem. With these settings it has to show only forum 2, because 4.5.7.8.9 have been excluded.

It's right. You excluded all forums.

I don't understand... If you want to show the posts of all forums, just leave that field empty.

Did you try if it works with new registrations and members deletion?