The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Modify this script to include the forum and replies
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: Code:
<?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> Forum | Thread name | 9 Replies Any help would be much appreciated! |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|