MediaLobby

5 years ago by Immersion , Takesinn

Unless k4st decides to make OneLobby open source or similar this might never happen as it isn't apart of his intentional plans.

My idea is to release a special version of OneLobby called "MediaLobby". With it people can post whole galleries, streaming os and flash from google video, youtube, and many other places, audio and "Project" posts. This version of OneLobby will be dedicated to the open arts and may perhaps be used in an after school program in Norway named "Mediaverkstedet" ("Mediaworkshop" which is a program that allows young people to produce movies, music, anything media at a very low cost by borrowing equipment from the workshop.

Don't f* with my dream, man!

Tags: feature, onelobby, gallery, video, audio, flash

5 years ago by k4st

errrr

5 years ago by k4st

lol, if you figure out how to program it yourself

5 years ago by Takesinn

Got a coder

So there

5 years ago by Thasmo

Nice try. Hehe.

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.0596	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=42 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.0691	1
UPDATE `k4_threads` SET views=376 WHERE thread_id=42	0.0065	1
SELECT tu.*, u.name AS user_name FROM k4_thread_users tu, k4_users u WHERE tu.thread_id=42 AND tu.user_id = u.user_id GROUP BY tu.user_id ORDER BY u.name ASC	0.0913	2
SELECT c.*, u.name AS user_name FROM k4_comments c JOIN k4_users u USING( user_id ) WHERE c.thread_id=42 GROUP BY c.comment_id	0.106	4

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

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=42 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.0691

1

UPDATE `k4_threads` SET views=376 WHERE thread_id=42

0.0065

1

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

0.0913

2

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

MediaLobby

0.0596

3

0.0691

1

0.0065

1

0.0913

2

0.106

4