Popular · Fresh · New · Categories

index.php

3 months ago by k4st with 0 comments.
…this is my new code…
Tags: soy

Test thread from the future!

3 months ago by k4st with 1 comments.
This is a test thread from 2012. Showing Helen what <edit> this could do!
Tags: test, demo

Test MBA Topic

4 years ago by k4st with 3 comments.
Here is my first day testing
Tags: mba, firstdays

Haven't posted here in a while

5 years ago by k4st with 2 comments.
Just remebering back on the good ol' days. I should *really* finish this.
Tags: test

Get the OneLobby source code!

5 years ago by k4st with 2 comments.
Go check out http://www.flyingwithfire.com/2007/02/06/onelobby/ for more information!
Tags: onelobby, source, gpl

BBCodes, lets see if they work.

5 years ago by XisZ with 4 comments.
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...
Tags: link, b, u, i, hl, hr, ol, ul, li, quote

This is a test

5 years ago by ryugan with 3 comments.
Testing the forum software.
Tags: test

OMFG. OL is teh COOL.

5 years ago by exaulz with 1 comments.
Effing awesome-ness-ness-ness ….
Tags: test, spam, onelobby, boredness, lol, haha, myself, bored_again_wtf, oh_jes

File arts

5 years ago by Immersion with 10 comments.
Hey are you releasing the file arts framework? in other words could i please have a copy?
Tags: filearts

Download K4stBB?

5 years ago by Sega with 2 comments.
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.
Tags: onelobby, k4stbb, forum, bb, bulletinboard

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

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

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

 107 

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

 0.5435 

 1