Single tag viewing

5 years ago by k4st
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.

Tags: feature, tags, blogoforum
5 years ago by k4st
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