News on main page???

Spike · #1 11-27-2004, 02:14 PM

Could I have the php code to put news from a forum to be put on the main page? Like yours... please

Cisyouc · #2 11-28-2004, 08:37 AM

Code:

&lt;? 
// Main.php by Rogean 
require('forums/config.php'); 
mysql_connect($dbhost, $dbuser, $dbpasswd); 
@mysql_select_db("$dbname")or die(mysql_error()); 

//GET FORUM NEWS 
$getnews=mysql_query("SELECT topic_id,forum_id,topic_title,topic_poster,topic_time,topic_views,topic_replies,topic_first_post_id FROM phpbb_topics WHERE forum_id='11' ORDER by topic_time DESC LIMIT 4"); 
while(list($topic[id],$forum[id],$topic[title],$topic[poster],$topic[time],$topic[views],$topic[replies],$topic[firstpostid])=mysql_fetch_row($getnews)){ 

$newsbody=mysql_query("SELECT * FROM phpbb_posts_text WHERE post_id=$topic[firstpostid]"); 
$text=mysql_fetch_array($newsbody); 

$userinfo=mysql_query("SELECT * FROM phpbb_users WHERE user_id=$topic[poster]"); 
$user=mysql_fetch_array($userinfo); 

$text[post_text]=str_replace("\n", "&lt;br>", $text[post_text]); 
$text[post_text]=str_replace("[b]", "&lt;b>", $text[post_text]); 
$text[post_text]=str_replace("[/b]", "&lt;/b>", $text[post_text]); 
$text[post_text]=str_replace("[i]", "&lt;i>", $text[post_text]); 
$text[post_text]=str_replace("[/i]", "&lt;/i>", $text[post_text]); 
$text[post_text]=str_replace("&amp;lt;", "&lt;", $text[post_text]); 
$text[post_text]=str_replace("&amp;gt;", ">", $text[post_text]); 



echo "&lt;div class=\"content\"> 
&lt;span class=\"title\">$text[post_subject]&lt;/span>&lt;br> 
&lt;font size=1>Posted by: $user[username] :: $topic[replies] Replies :: $topic[views] Views&lt;br>&lt;br> 
$text[post_text] 
&lt;/div> 
&lt;hr width=80% color=darkblue align=left>"; 
} 
?>