Popular · Fresh · New · Categories

Test thread from the future!

This is a test thread from 2012. Showing Helen what <edit> this could do!

Test MBA Topic

Here is my first day testing

Haven't posted here in a while

Just remebering back on the good ol' days. I should *really* finish this.

Get the OneLobby source code!

Go check out http://www.flyingwithfire.com/2007/02/06/onelobby/ for more information!

BBCodes, lets see if they work.

OK, I am just doing some testing here. Please do not mind me. This should be Bold This should be Italic This should be Underlined[/i] This should be Linked This should be Linked This should be Red This should be Red This should be Red This should be [hl=red]Highlighted[/hl] This should...

This is a test

Testing the forum software.

OMFG. OL is teh COOL.

Effing awesome-ness-ness-ness ….

File arts

Hey are you releasing the file arts framework? in other words could i please have a copy?

Download K4stBB?

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 on it. Won't promise but wanna take a look on it.

Ruby on Rails framework

Hey guys, haven't been here in a while. College has put a different perspective on what I spend my time doing online, but you can never really forget some things of particular interest. What if we could build 1l with a ruby on rails framework, easily integrated with SQLite or MySQL, later expanding...

OneLobby
QueryQuery TimeAffected Rows
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.deleted=0 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 ORDER BY t.recent_created DESC LIMIT 10

 0.9903 

 10 

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

 3 

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 ts.tag_id = tt2.tag_id GROUP BY ts.tag_id, tt2.tag_id ORDER BY ts.tag_name ASC, tag_count DESC LIMIT 250

 0.9955 

 105 

SELECT COUNT(ts.tag_id) AS row_count FROM k4_tags ts

 0.9977 

 1