The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Query to get last post pagetext? (vb 3.8)
Hello,
I'm trying to retrieve the contents of a specific thread's last post so it can be displayed in a plugin I'm working on. From what I've been reading, it looks like the only is to JOIN the "thread" table with the "post" table in order to get both lastpostid (thread) and pagetext(post), but I haven't been able to make this work. Anyone have the proper syntax to accomplish this? Any help would be greatly appreciated! |
#2
|
|||
|
|||
I think it should be something like:
Code:
SELECT pagetext FROM thread LEFT JOIN post on post.postid = thread.lastpostid WHERE thread.threadid = X |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|