Single tag viewing

You can now view single tags. It will show a list of threads common to that tag, other tags often used with that tags, and users that commonly use that tag. Originally, I was just going to put a list of threads that use the tag, and geoffrey had suggested I add in the ability to find similar tags somewhere in 1l but nowhere specific. Nevertheless, I recently found out about Blogoforum, a similar project and they had some really good ideas for what to display on the single tag view, so I adapted those ideas. With the help of someone on #mysql on irc.freenode.net

, I was able to get similar tags, and then I expanded on that and figured out the rest.

:D

P.S. Tags with spaces in them no longer work. I have decided not to allow spaces in tags as that retracts from one of the features in the tag view.

You can now save tag groups.
OneLobby
QueryQuery TimeAffected Rows
SELECT o.object_name,o.object_perms,p.perm_grant,p.perm_deny FROM k4_objects o, k4_perms p, k4_roles r, k4_user_roles u WHERE u.user_id=1  AND u.role_id=r.role_id  AND p.role_id=r.role_id  AND o.object_id=p.object_id ORDER BY r.perm_level ASC

 0.1658 

 3 

SELECT DISTINCT t.thread_id, t.*, ts.tag_name, GROUP_CONCAT(ts.tag_name SEPARATOR ',') AS tags, u.name AS user_name, uu.name AS edit_user_name FROM k4_thread_tags tt, k4_tags ts, k4_threads t, k4_users u, k4_users uu WHERE t.thread_id=27 AND t.thread_id=tt.thread_id AND ts.tag_id=tt.tag_id AND t.user_id=u.user_id AND t.edit_user_id=uu.user_id GROUP BY t.thread_id LIMIT 1

 0.1718 

 1 

UPDATE `k4_threads` SET views=273 WHERE thread_id=27

 0.0005 

 1 

SELECT tu.*, u.name AS user_name FROM k4_thread_users tu, k4_users u WHERE tu.thread_id=27 AND tu.user_id = u.user_id GROUP BY tu.user_id ORDER BY u.name ASC

 0.1806 

 1 

SELECT c.*, u.name AS user_name FROM k4_comments c JOIN k4_users u USING( user_id ) WHERE c.thread_id=27 GROUP BY c.comment_id

 0.2678 

 1