Tags: onelobby, bb save tag group What are tags?

Get the OneLobby source code! 5 years ago by k4st with 2 comments. Tags: onelobby, source, gpl Go check out http://www.flyingwithfire.com/2007/02/06/onelobby/ for more information!
Download K4stBB? 5 years ago by Sega with 2 comments. Tags: onelobby, k4stbb, forum, bb, bulletinboard Hi! This looks cool. But the K4stBB URL doesn't work. It redirects to your blog. Is there somewhere there I can get the source code and still download K4stBB, would be awesome, maybe I could continue...
MediaLobby 5 years ago by Takesinn with 4 comments. Tags: feature, onelobby, gallery, video, audio, flash 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"....
Very nice work, k4st. 5 years ago by exaulz with 6 comments. Tags: onelobby, feedback 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.
OMFG. OL is teh COOL. 5 years ago by exaulz with 1 comments. Tags: test, spam, onelobby, boredness, lol, haha, myself, bored_again_wtf, oh_jes Effing awesome-ness-ness-ness ….
So what's the plan? 5 years ago by AngusThermopile with 11 comments. Tags: onelobby, future How do you see this developing? Is it a something you will seriously develop with a view to some sort of public release or is it just a project for your own gratification?

OneLobby
QueryQuery TimeAffected Rows
SELECT ts.* FROM k4_tags ts WHERE ts.tag_name IN('bb','onelobby') GROUP BY ts.tag_id

 0.792 

 2 

 
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, k4_thread_tags tt2  WHERE t.deleted=0 AND tt.thread_id = tt2.thread_id AND tt2.tag_id IN(61,107) 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, tt2.tag_id ORDER BY t.created DESC

 0.7995 

 6 

 
SELECT ts.*, COUNT(tt2.tag_id) AS tag_count FROM k4_tags ts, k4_thread_tags tt1 JOIN k4_thread_tags tt2 USING ( thread_id )   WHERE tt1.tag_id IN(61,107) AND tt1.tag_id <> tt2.tag_id AND ts.tag_id = tt2.tag_id GROUP BY ts.tag_id, tt2.tag_id LIMIT 250

 0.8013 

 22 

 
SELECT DISTINCT u.user_id, u.name, COUNT(tt2.tag_id) AS tag_count FROM k4_thread_users tu, k4_users u, k4_thread_tags tt1 JOIN k4_thread_tags tt2 USING (thread_id) WHERE u.user_id = tu.user_id AND tt1.tag_id IN(61,107) AND tt1.tag_id <> tt2.tag_id AND tu.thread_id = tt2.thread_id GROUP BY tt2.tag_id ORDER BY u.name ASC

 0.8047 

 6 

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

 3