Very nice work, k4st.

5 years ago by exaulz

Peter, so far, you've done an amazing job with OneLobby. This thing is really going to reinvent a few things…

I wish you the best of luck with it.

… So hawt n sexy OneLobby is.

Tags: onelobby, feedback

5 years ago by Aka Tolken

Reinvent? Um, 'kay, that doesn't make sense.

I wish you the best of luck with it.

5 years ago by exaulz

Haha. By reinvent I meant like you're going to change the way forum software might be made, from now on.

5 years ago by exaulz

GAH. How effing ghey. I clicked on delete by accident and my previous comment got deleted. Put a confirmation alert or something.

Anyways…

I said that when you write an empty comment to a Wall, you'll see the 'just now by XXX' line but with nothing under it. Then, when you click on Home/'Lobby' you'll see 'My Wall (1)' but then when you click on it,you'll see the 'No one has posted to this Wall yet…'.

5 years ago by k4st

lol

5 years ago by Aka Tolken

Test

Don't mind me.

Edit: quote tags disappear when you click on quick edit.

5 years ago by someotherguy

Hey everyone

Query	Query Time	Affected 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.5596	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=37 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.5628	1
UPDATE `k4_threads` SET views=327 WHERE thread_id=37	0.0011	1
SELECT tu.*, u.name AS user_name FROM k4_thread_users tu, k4_users u WHERE tu.thread_id=37 AND tu.user_id = u.user_id GROUP BY tu.user_id ORDER BY u.name ASC	0.5723	1
SELECT c.*, u.name AS user_name FROM k4_comments c JOIN k4_users u USING( user_id ) WHERE c.thread_id=37 GROUP BY c.comment_id	0.5766	6

Query

Query Time

Affected 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.5596

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=37 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.5628

1

UPDATE `k4_threads` SET views=327 WHERE thread_id=37

0.0011

1

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

0.5723

1

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

Very nice work, k4st.

0.5596

3

0.5628

1

0.0011

1

0.5723

1

0.5766

6