View Full Version : Unanswered Threads 'TAB'
Wodjno
18-02-2008, 08:51 PM
Was browsing another car forum earlier this evening. When i cam across, what i thought would be a good addition to CVR4 !
An "Unanswered Threads" TAB.
It was in the same drop down menu that has New Posts and all that.. Just click on it, and it brings up every thread that hasn't had any answer to it at all..
Just thought it was a good idea and can help loosing New Threads that end up on page 4 million within an hour or 2, just because the right Members were not on site at the time to answer the question set.
Whats you Dude's and Dudess's think :happy:
Spirit
18-02-2008, 08:53 PM
Sounds like a good idea to me Glenn......but it's whether it can be implimented I guess.....over to the IT guru's
Nutter_John
18-02-2008, 09:18 PM
your out of luck (site crasher and Kieran ) do your IT support :p
Does sound good
Kieran
18-02-2008, 09:19 PM
....(site crasher and Kieran ).......
/haz
Seriously.... I'll see what Vbulletin.org can offer, I suspect a forum 'hack' might be needed. At the moment though there's other things that I think are more important, but it's certainly an Idea I like in principle! :)
Wodjno
18-02-2008, 09:22 PM
/haz
Seriously.... I'll see what Vbulletin.org can offer, I suspect a forum 'hack' might be needed. At the moment though there's other things that I think are more important, but it's certainly an Idea I like in principle! :)
Yup ! I know there are more important things 1st /drinkswine :5shots: :chugchug: :beerbang:
Just thought i'd post it while it's fresh in my mind :beerbang:
Davezj
18-02-2008, 09:26 PM
sound like a good function.
miller
18-02-2008, 09:30 PM
ive used this on another forum, quite interesting as some posts go unanswered for ages!
Good addition if possible
Mike
Nutter_John
18-02-2008, 09:33 PM
select * from threads where replys equals zero - there you go all done for ya
Wodjno
18-02-2008, 09:44 PM
select * from threads where replys equals zero - there you go all done for ya
How do you select the thread where reply equals zero ?
if it's buried 79 pages deep ?/
Or do i misunderstand :speechles
Or is that what Kieren has to do ??
Nutter_John
18-02-2008, 09:46 PM
* is all threads and where is the condition to be met
so in no computer speak
select everything from threads but only when there are no replys
Wodjno
18-02-2008, 09:46 PM
* is all threads and where is the condition to be met
so in no computer speak
select everything from threads but only when there are no replys
:speechles :speechles :speechles :speechles :speechles :speechles :speechles :speechles :speechles :speechles :speechles :speechles :speechles
Nutter_John
18-02-2008, 09:48 PM
tis for the backend girls not us mere mortals
Kenneth
18-02-2008, 09:51 PM
How do you select the thread where reply equals zero ?
if it's buried 79 pages deep ?/
Or do i misunderstand :speechles
Or is that what Kieren has to do ??
That is a simplistic version of the driving SQL statement for a query that displays all the threads that have had no reply.
A more complicated (but perhaps more likely) scenario would be
SELECT post_id
FROM posts p1
WHERE not exists
(SELECT post_id
FROM posts p2
WHERE p2.thread_Id = p1.thread_id
AND p1.post_id != p2.post_id)
Just to be as confusing as possible ;)
Nutter_John
18-02-2008, 11:06 PM
Yep thats a little better Ken ( but I didn't want to confuse the none computer people )
Kieran
19-02-2008, 07:32 AM
SQ whatty?! /dunce :speechles
Beastlee
19-02-2008, 08:38 PM
Pronunkyated Sequel as in Sequel Server. :scholar:
Powered by vBulletin® Version 4.2.0 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.