search

foreverlarz / thinktankforums

Automatically exported from code.google.com/p/thinktankforums
0 stars 0 forks source link

improved forum marking (as new) #15

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
currently, this is how forum marking works:

by default, a forum is marked as unread (with an arrow).
upon visiting the forum, it is marked read (no arrow).
after a new post(s) are entered in the forum, it is marked unread again.
upon visiting again, it is marked read.

i would like the forum to stay marked as unread as long as there are unread
threads.

Original issue reported on code.google.com by lucasreddinger on 21 Mar 2007 at 9:18

GoogleCodeExporter commented 8 years ago 
half way home!

SELECT ttf_thread. * , ttf_thread_new. *
FROM ttf_thread
LEFT JOIN ttf_thread_new ON ( ttf_thread.thread_id = ttf_thread_new.thread_id
AND ttf_thread_new.user_id ={$ttf["uid"]} )
WHERE (
ttf_thread_new.last_view IS NULL || ttf_thread.date > ttf_thread_new.last_view
)
GROUP BY ttf_thread.forum_id

Original comment by lucasreddinger on 21 Mar 2007 at 10:59

GoogleCodeExporter commented 8 years ago 
this doesn't quite work, and i'm not sure why. but IT'S CLOSE!

SELECT ttf_forum. * , COUNT( * ) - COUNT( DISTINCT ttf_thread_new.last_view ) AS
new_threads
FROM ttf_forum
LEFT JOIN ttf_thread ON ( ttf_forum.forum_id = ttf_thread.forum_id )
LEFT JOIN ttf_thread_new ON ( ttf_thread.thread_id = ttf_thread_new.thread_id
AND ttf_thread_new.user_id ={$ttf["uid"]}
AND ttf_thread.date <= ttf_thread_new.last_view )
GROUP BY ttf_forum.forum_id

Original comment by lucasreddinger on 22 Mar 2007 at 12:13

GoogleCodeExporter commented 8 years ago 
r87 added the freshies feature. however, due to popular demand, i will also put 
the
arrow markers back in.

Original comment by lucasreddinger on 22 Mar 2007 at 8:00

GoogleCodeExporter commented 8 years ago 
the freshies feature has a bug:
if a forum has no threads and no posts, it reports one freshie.

future plans:
* fix the bug above
* add arrow markers back into HEAD
* add "mark as read" feature
* only mark posts as new if post_date > user_register_date
* allow the user to select freshies or arrows as their preferred marking system

Original comment by lucasreddinger on 22 Apr 2007 at 11:51

GoogleCodeExporter commented 8 years ago 
maybe. we need to reevaluate this business.

Original comment by lucasreddinger on 7 Oct 2008 at 5:57

GoogleCodeExporter commented 8 years ago 
who knows when we will release?!

Original comment by lucasreddinger on 18 Oct 2008 at 9:19

GoogleCodeExporter commented 8 years ago 
see issue 43.

Original comment by lucasreddinger on 7 Dec 2008 at 8:11