<?php				
  $db_host = "xxx"; // Change this if your MySQL database host is different.
  $db_name = "xx"; // Change this to the name of your database.
  $db_user = "xx"; // Change this to your database username.
  $db_pw = "xx"; // Change this to your database password.
  
  $forum_url = "http://forum.xylongju.com"; // Change this to reflect to your forum's URL.
  $forum_id = ""; // If you wish to display the posts from a specific forum, enter the forum id here. Otherwise, leave it blank.
  $limit = "9"; // Number of posts displayed.
  $txtlimit = "100"; // This is the character limit.
  #######################################
  
  // Connecting to your database
  mysql_connect($db_host, $db_user, $db_pw)
  OR die ("Cannot connect to your database");
  mysql_select_db($db_name) OR die("Cannot connect to your database");
  
  if ($forum_id)	$forumid = "AND forumid=$forum_id";
  if ($limit) 		$limited = "LIMIT $limit";
  mysql_query("SET NAMES 'utf8'");
  $thread_sql = mysql_query("SELECT threadid,title,lastpost,lastposter FROM thread WHERE visible=1 AND open=1 $forumid ORDER BY lastpost DESC $limited");
  
  while($thread_get=mysql_fetch_array($thread_sql))
  {	$lastpost = $thread_get['lastpost'];
	  $poster = $thread_get['lastposter'];
	  $tid = $thread_get['threadid'];
	  mysql_query("SET NAMES 'utf8'");
	  $psql = mysql_query("SELECT postid FROM post WHERE threadid=$tid ORDER BY postid DESC");
	  $getp=mysql_fetch_array($psql);
	  $pid = $getp['postid'];
	  $date2 = date ("m/d/y h:i A" ,$lastpost);
	  $title = $thread_get['title'];
	  $title = mb_substr($title,0,$txtlimit,"utf-8");
	  echo 	
	  "<p>
		  <span><a href=\"$forum_url/showthread.php?p=$pid#post$pid\" target=\"_blank\">".$title."</a></span>
		  <font class='haber1'><a href='#'>".$date2."</a></font>
		  <font class='haber2'><a href='#'>Yazan: <b>".$poster."</b></a></font>
	  </p>";
  }
?>