Nice

5 years ago by dave
Nice, so simple, and sleek too.
Tags: nice, 1l, idea
5 years ago by k4st
thanks
5 years ago by Aka Tolken
Ah it has much improved since the preview, very nice indeed!!!111one
5 years ago by Thasmo
Yep, very nice Peter! =o)
5 years ago by Roguefoxx
Looks very nice, can't wait to be able to play around with it myself. =)
5 years ago by Dietrich
Nice, but the index (Lobby) looks a bit busy with those post previews.
5 years ago by k4st
Nice, but the index (Lobby) looks a bit busy with those post previews.

That was actually the goal

The way the lobby works is that it will always look busy, no matter how many or how few threads there are. There are 3 views for the threads in the index: normal, small, and mini. Normal has everything nicely expanded, small concatenates 2 of the lines that would otherwise be separate and mini just puts everything all onto 1 line.

5 years ago by Aka Tolken
This would confuse the heck out of 99% of the general public.
5 years ago by Aka Tolken
But it's nice, in a complicated way.
5 years ago by Dietrich
I saw you changed it; it's really much better to read right now.
5 years ago by k4st
5 years ago by AngusThermopile
I love this actually and that it looks busy even with few posts and posters. perfect for little sites.
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.036 

 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=30 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.0619 

 1 

 
UPDATE `k4_threads` SET views=361 WHERE thread_id=30

 0.0073 

 1 

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

 0.0843 

 1 

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

 0.089 

 11