vb.org Archive - Last posts in your portal

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

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]."' target='_blank'>".$dati[title]."</a></b> (<a href='http://www.yourforum.com/forumdisplay.php?f=".$dati[forumid]."' target='_blank'>".$dati[title_clean]."</a>) of <a href='http://www.yourforum.com/member.php?u=".$dati[userid]."' target='_blank'><em>".$dati[username]."</em></a> on ".date("H:i d-m-y", $dati[dateline]);

    }

    mysql_free_result($risultato);

?>

here you are :D

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

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 :)

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01106 seconds Memory Usage 1,719KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: