Another update last night to fix bugs with page redirects.

I'm hoping to have time today to drop this puppy in there:

SELECT t.thread_id as id, 
	t.thread_title as title, 
    t.thread_slug as slug, 
    t.thread_desc as description, 
    t.thread_posts as threadposts, 
    t.closed as closed, 
    t.thread_secured as secured, 
    r.post_number as postnumber 
FROM (
	SELECT 
		th.thread_id, 
        th.group_id, 
        th.thread_title, 
        th.thread_slug, 
        th.thread_desc, 
        th.thread_posts, 
        th.closed, 
        th.thread_secured
	FROM borg.threads th
    INNER JOIN borg.subscriptions su
	ON th.thread_id = su.thread_id
	WHERE su.user_id = :user_id
    ) t
LEFT OUTER JOIN (
	SELECT * FROM borg.posts_read 
    WHERE borg.posts_read.user_id = :user_id
    ) r
ON 
	t.thread_id = r.thread_id 
WHERE
	ISNULL(r.post_number) OR r.post_number < t.thread_posts
ORDER BY title
LIMIT 1

Bonus points if you can figure out which feature that implements.

Message Center.

Close.

Read New!

Bingo!

Just a reminder. The updated board has been a solo project so far, but other contributors are quite welcome. Presentation and logic are separate on the new board so you don't need to know PHP to work on HTML and CSS. Likewise, you can work on the logic without worrying about the HTML and CSS aspect. Just let me know via profile addy and I can set you up with access to the source code repository.

Added support for Read New.

Fixed a bug Calli found. Thanks, Calli!