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! |
#2
|
|||
|
|||
The column replycount in the table thread.
I hope you know your link is going to the post not the thread. Change it to PHP Code:
|
#3
|
||||
|
||||
Yeah sorry i meant recent posts not recent threads. I dont know what you mean by
Quote:
I dont have any database or php knowledge. Im hoping to pull which forum the last post was in, and also how many replies there are in the thread the post was in. Is anyone able to help me out with this? |
#4
|
|||
|
|||
I suggest you try this mod.
https://vborg.vbsupport.ru/showthread.php?t=147344 |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|