THETMZ
10-10-2014, 07:52 PM
Hello,
I was using a php script for selecting latest vb forum threads (including thread name + last post author + date) all linked to specific thread / post. It was working great on vb3. Now when I bought vb5, i need to change the script. Actually I got mostly everything working except I am unable to get URL for specific thread / post.
My current querry is as follows:
SELECT lastcontentid,title,lastcontent,lastcontentauthor, nodeid FROM vb_node where contenttypeid = 30 ORDER BY lastcontentid DESC LIMIT $limit"
Any suggestions how to do that?
I was using a php script for selecting latest vb forum threads (including thread name + last post author + date) all linked to specific thread / post. It was working great on vb3. Now when I bought vb5, i need to change the script. Actually I got mostly everything working except I am unable to get URL for specific thread / post.
My current querry is as follows:
SELECT lastcontentid,title,lastcontent,lastcontentauthor, nodeid FROM vb_node where contenttypeid = 30 ORDER BY lastcontentid DESC LIMIT $limit"
Any suggestions how to do that?