Yes. Men like sports. Men watch the action movie, they eat of the beef, and enjoy to look at the bosoms. A thousand years of avenging our wrongs and that's all you've learned?

Xander ,'End of Days'


Buffistas Building a Better Board ++

Do you have problems, concerns, or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.


Gudanov - Dec 06, 2017 6:40:02 pm PST #3943 of 4671
Coding and Sleeping

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.


Gudanov - Dec 07, 2017 7:48:40 am PST #3944 of 4671
Coding and Sleeping

Added support for quickedits to posts.


Gudanov - Dec 08, 2017 4:38:44 am PST #3945 of 4671
Coding and Sleeping

Another update last night to fix bugs with page redirects.


Gudanov - Dec 08, 2017 5:18:37 am PST #3946 of 4671
Coding and Sleeping

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


Gudanov - Dec 08, 2017 5:19:11 am PST #3947 of 4671
Coding and Sleeping

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


Tom Scola - Dec 08, 2017 5:25:38 am PST #3948 of 4671
Mr. Scola’s wardrobe by Botany 500

Message Center.


Gudanov - Dec 08, 2017 5:26:05 am PST #3949 of 4671
Coding and Sleeping

Close.


Jessica - Dec 08, 2017 5:28:48 am PST #3950 of 4671
If I want to become a cloud of bats, does each bat need a separate vaccination?

Read New!


Gudanov - Dec 08, 2017 5:28:59 am PST #3951 of 4671
Coding and Sleeping

Bingo!


Gudanov - Dec 09, 2017 7:24:21 am PST #3952 of 4671
Coding and Sleeping

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.