The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
query help
Okay, what I'd like to do is query the database to output only unanswered threads from specific forums.
I'm sorry that i'm basically asking for help but I haven't worked with creating a query in quite a while. Could anyone help me out? Thanks. |
#2
|
||||
|
||||
Basic example:
Code:
SELECT threadid, title FROM thread WHERE replycount = 0 AND forumid IN (X,Y,Z) |
#3
|
|||
|
|||
Thank you. This helps very much. Would it be possible to somehow restrict the replies from the user who posted the original thread in counting for the replycount? So if the user posts a thread and replies to it twice, the results from the query will still be the same as replycount = 0, even though technically there were two replies (from the thread-posting user)?
|
#4
|
||||
|
||||
Try this:
Code:
SELECT threadid, title FROM thread WHERE (replycount = 0 OR postusername = lastposter) AND forumid IN (X,Y,Z) |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|