PDA

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: