[Developer]

Last posts in your portal



This is the way to read the tables of your forum, and display it in your website:

<div style="margin: 5px 10px;"> <div class="smallfont" style="margin-bottom: 2px;">Code:

PHP Code:

    <?php
    include ("includes/conn-forum.php"); // this is the path of the config of the forum (and also the mysql_connect for me) - if you don't have something of this, include the code that i will post below, or include the includes/config.php of the forum and after do the mysql_connect

    $query = "SELECT pp.postid, pp.threadid, pp.userid, pp.dateline, pt.title, pf.title_clean, pf.forumid, pu.username
            FROM   post pp, thread pt, forum pf, user pu
            WHERE  pp.threadid = pt.threadid
            AND pu.userid = pp.userid
            AND pt.forumid = pf.forumid
            AND pp.postid = pt.lastpostid
            AND pf.forumid != '17'
            AND pf.forumid != '77'
            AND pf.forumid != '98'
            AND pf.forumid != '111'
            GROUP BY pp.threadid
            ORDER BY dateline DESC LIMIT 0,10";    // 10 --> this is the number of the post that you will show (now it's 10) ..change it to show more or less last posts  
    $risultato = mysql_query($query);
    if (!$risultato) {
        echo "Failed in esecution ($sql) from DB: " . mysql_error();
        exit;
    }
    if (mysql_num_rows($risultato) == 0) {
        echo "Nothing found.";
        exit;
    }
    while ($dati = mysql_fetch_assoc($risultato)) {
        if (strlen($dati[title]) > 40) { $dati[title] = substr($dati[title], 0, 37)."..."; }
        echo "<b><a href='http://www.yourforum.com/showthread.php?p=".$dati[postid]."#post".$dati[postid]."' rel="nofollow" target='_blank'>".$dati[title]."</a></b> (<a href='http://www.yourforum.com/forumdisplay.php?f=".$dati[forumid]."' rel="nofollow" target='_blank'>".$dati[title_clean]."</a>) of <a href='http://www.yourforum.com/member.php?u=".$dati[userid]."' rel="nofollow" target='_blank'><em>".$dati[username]."</em></a> on ".date("H:i d-m-y", $dati[dateline]);
    }
    mysql_free_result($risultato);
?>

here you are

for the connection, as i said above, you can use:

PHP Code:

     Code:     $_CONFIG['host'] = "localhost(orsomethingelse)";
$_CONFIG['user'] = "username";
$_CONFIG['pass'] = "password";
$_CONFIG['dbname'] = "database_name";

$connect = mysql_connect($_CONFIG['host'], $_CONFIG['user'], $_CONFIG['pass']) or die ('Impossibile to establishing a connection.');
mysql_select_db($_CONFIG['dbname']);


enjoy