aceofspades
12-26-2007, 11:07 AM
Hey guys!
I am using a premade latest forum posts script, but i would really appreciate it if someone could tell me how to expand it to say not only which is the forum that the post was made in, but also the number of replies.
Here is my script as it stands:
<?php
$db_host = "localhost"; // Change this if your MySQL database host is different.
$db_name = "xxx"; // Change this to the name of your database.
$db_user = "xxxxxxx"; // Change this to your database username.
$db_pw = "xxxxxxxx"; // Change this to your database password.
$db_prefix = ""; //Change this to the prefix of the forum database.
$forum_url = "xxxx"; // Change this to reflect to your forum's URL.
$limit = "7"; // Number of posts displayed.
$txtlimit = "18"; // 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 ($limit) {
$limited = "LIMIT $limit";
}
$thread_sql = mysql_query("select threadid,title,lastpost,firstpostid from $db_prefix thread where visible=1 $wheresql and open=1 $forumid order by lastpost desc $limited");
while($thread_get = mysql_fetch_array($thread_sql))
{
$lastpost = $thread_get['lastpost'];
$tid = $thread_get['threadid'];
$psql = mysql_query("SELECT postid from $db_prefix post where threadid=$tid order by postid desc");
$getp = mysql_fetch_array($psql);
$pid = $getp['postid'];
$title = $thread_get['title'];
$title = substr($title,0,$txtlimit);
echo "<li class=\"item\"><a href=\"$forum_url/showthread.php?p=$pid#post$pid\"><span>$title</span></a></li>";
}
?>
</ul>
The final result i would like is this:
Forum | Thread name | 9 Replies
Any help would be much appreciated!
I am using a premade latest forum posts script, but i would really appreciate it if someone could tell me how to expand it to say not only which is the forum that the post was made in, but also the number of replies.
Here is my script as it stands:
<?php
$db_host = "localhost"; // Change this if your MySQL database host is different.
$db_name = "xxx"; // Change this to the name of your database.
$db_user = "xxxxxxx"; // Change this to your database username.
$db_pw = "xxxxxxxx"; // Change this to your database password.
$db_prefix = ""; //Change this to the prefix of the forum database.
$forum_url = "xxxx"; // Change this to reflect to your forum's URL.
$limit = "7"; // Number of posts displayed.
$txtlimit = "18"; // 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 ($limit) {
$limited = "LIMIT $limit";
}
$thread_sql = mysql_query("select threadid,title,lastpost,firstpostid from $db_prefix thread where visible=1 $wheresql and open=1 $forumid order by lastpost desc $limited");
while($thread_get = mysql_fetch_array($thread_sql))
{
$lastpost = $thread_get['lastpost'];
$tid = $thread_get['threadid'];
$psql = mysql_query("SELECT postid from $db_prefix post where threadid=$tid order by postid desc");
$getp = mysql_fetch_array($psql);
$pid = $getp['postid'];
$title = $thread_get['title'];
$title = substr($title,0,$txtlimit);
echo "<li class=\"item\"><a href=\"$forum_url/showthread.php?p=$pid#post$pid\"><span>$title</span></a></li>";
}
?>
</ul>
The final result i would like is this:
Forum | Thread name | 9 Replies
Any help would be much appreciated!