I agree with smonster. Gud, you are amazing with all that you do. Take your time.

After a very long time, I've made an update to the beta board. ( At [link] ). This update adds support for editing and deleting posts and partial implementation of bookmarks. Contact me via profile addy if you want an invite code to register. Anything posted to the beta board will be wiped out from time to time as the database is updated.

Added support for quickedits to posts.

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!