Log in

View Full Version : Latest New topics on website home page?


ecfcgraham
04-13-2005, 11:07 PM
Hi there,

Anyone know a decent hack for showing latest forum topics on a website home page? Looking to interegate some of my vB forum into my website and here's where I start off - so if someone could suggest a hack then that would be great.

Cheers!

ClockCrew
04-13-2005, 11:19 PM
Heres my site...look to the top right. www.clockcrew.net I hope this is what you are looking for. You will need to edit a few things to fit your site.



<? include("./global.php");
include_once("./includes/functions_bbcodeparse.php"); //for bbcodeparse2
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
<?
/************************************************** *********
** FileName:YOUR FRONT PAGE HERE
************************************************** *********
** By MagicClock [MagicClock@gmail.com]
** File Description : 4-13-05 -- VB3 integrated front page
** File Version : 0.01
** File Comments : see source
\************************************************* **********/

///////// CONSTANTS ////////////
$POSTLIMIT = 5; // number of last posts to display in the box
$PULLFROM = "INSERT FORUM IDS HERE"; //forums to pull last posts from
////////////////////////////////

///////// FUNCTIONS ////////////

function crtobr($convertme) {
//change carriage returns into br's
return $convertme;
//return str_replace(chr(13),"<br />",$convertme);
}

//////// GRAB LAST POSTS ///////////

$postitems = $DB_site->query("SELECT * FROM thread WHERE `forumid`='".str_replace(",","' OR `forumid`='",$PULLFROM)."' ORDER BY `dateline` DESC LIMIT ".$POSTLIMIT);

if ($DB_site->num_rows($postitems) > 0)
{
$postchunk = "";
while ($qx = $DB_site->fetch_array($postitems))
{
$postchunk .= "* <a href=\"bbs/showthread.php?t=".$qx["threadid"]."\">".$qx["title"]."</a><br>";
}
}

jugo
05-06-2005, 06:30 PM
It's not complete.

I think maybe this would be what he meant:


<?php
$forumspath = "/path/to/forums/from/root"; //no trailing slash
$forumsurl = "http://ww.url.to/forums"; //no trailing slash

chdir($forumspath);
include("./global.php");
include_once("./includes/functions_bbcodeparse.php"); //for bbcodeparse2
chdir('../');


/************************************************** *********
** FileName:YOUR FRONT PAGE HERE
************************************************** *********
** By MagicClock [MagicClock@gmail.com]
** File Description : 4-13-05 -- VB3 integrated front page
** File Version : 0.01
** File Comments : see source
\************************************************* **********/

///////// CONSTANTS ////////////
$POSTLIMIT = 5; // number of last posts to display in the box
$PULLFROM = "INSERT FORUM IDS HERE"; //forums to pull last posts from
////////////////////////////////

///////// FUNCTIONS ////////////

function crtobr($convertme) {
//change carriage returns into br's
return $convertme;
//return str_replace(chr(13),"<br />",$convertme);
}

//////// GRAB LAST POSTS ///////////

$postitems = $DB_site->query("SELECT * FROM thread WHERE `forumid`='".str_replace(",","' OR `forumid`='",$PULLFROM)."' ORDER BY `dateline` DESC LIMIT ".$POSTLIMIT);

if ($DB_site->num_rows($postitems) > 0)
{
$postchunk = "";
while ($qx = $DB_site->fetch_array($postitems))
{
$postchunk .= "* <a href=\"".$forumsurl."/showthread.php?t=".$qx["threadid"]."\">".$qx["title"]."</a><br>";
echo $postchunk;
}
}
?>


I think. :ermm: