Hazaa! new CSS and solved a CSS Bug.

Oh man.. I just spent soo long on a stupid CSS issue. It was very annoying. The long and short of it is that I solved the problem with width: inherit;. So, is the current look okay.. or needs work?

You'll also notice that I put "Columns" beside fresh and popular because that's a feature that will eventually be implemented. Another one will be the ability to tag threads as a way of bookmarking them. :D

Another thing was I was thinking of having it so you can state sources for a post.. I'm not too sure how I want that to work because a good footnoting scheme could work nicely. Though I'm sure there's a good wiki code solution for it.

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.7085 

 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=13 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.712 

 1 

UPDATE `k4_threads` SET views=140 WHERE thread_id=13

 0.0063 

 1 

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

 0.7267 

 1