The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
MySql query help
Hi,
How can I modify this query: SELECT thread.title, post.username, post.threadid, post.postid, TIME_FORMAT(time(from_unixtime(post.dateline )), '%H:%i')AS PostTime from post left join thread on post.threadid =thread.threadid order by post.postid desc limit 5 I want to extract last 5 posts, from deferent threads. (Something like on New Posts search) Thanks |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|