k4st's profile

Threads: 13
Comments: 39
Registered: 5 years ago
Often used Tags: What are tags?
feature php test history search ajax css delete fresh javascript perms programming 1l acp admin blog blogoforum cando captcha coauthors code comment ddmenu demo design dom facebook firstdays gpl mba new One Lobby onelobby permissions personal php4 php5 popular revert revisions school source soy tag tags threads view wall xhtml xmlhttprequest
Recent Threads: View All
index.php 3 months ago by k4st with 0 comments. Tags: soy …this is my new code…
Test with code 3 months ago by k4st with 0 comments. Tags: test, code hello hello <pre> hello hello </pre>
Test thread from the future! 3 months ago by k4st with 1 comments. Tags: test, demo This is a test thread from 2012. Showing Helen what <edit> this could do!
Test MBA Topic 4 years ago by k4st with 3 comments. Tags: mba, firstdays Here is my first day testing
Haven't posted here in a while 5 years ago by k4st with 2 comments. Tags: test Just remebering back on the good ol' days. I should *really* finish this.
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!
Slooooooow 5 years ago by k4st with 0 comments. Tags: 1l Seems the whole site has slowed down significantly this afternoon. I have been doing lots of svn commits and exports to this site.. might that be the problem?
Testing CAPTCHA support 5 years ago by k4st with 5 comments. Tags: feature, captcha Just implemented a captcha. It's quite clever how I made it, let's hope people find it readable.
My Blog! 5 years ago by k4st with 0 comments. Tags: programming, blog I've got a programming blog! Check it out: http://www.flyingwithfire.com/
The Wall 5 years ago by k4st with 1 comments. Tags: feature, wall, facebook The Wall, a la facebook, is what is replacing private messageing. It's basically a public messageing / note taking system for inside each users profile (although you can make messages private). What's...

The Wall

| View All
wall-to-wall
5 years ago, jcrawford wrote:
nice work on onelobby
wall-to-wall
5 years ago, aeacides wrote:

Hey! Thank you mr! I need to explore a little bit, but it seems really interesting.

talk to you later.

wall-to-wall
5 years ago, Koncept wrote:

Good to hear from you!

May i ask… What is wall to wall? -_-

wall-to-wall
5 years ago, Koncept wrote:
/me also licks wall
wall-to-wall
5 years ago, Immersion wrote:

this is awesome just needs more eye candy

*licks the wall*

wall-to-wall
5 years ago, Aka Tolken wrote:
You rock, good Sir.
wall-to-wall
5 years ago, Dan wrote:
Time is definitely my favorite. I've been listening to their older stuff lately, but The Wall / Dark Side of the Moon / Wish You Were Here are way more familiar to me. ( And have lots of easy solos to play )
wall-to-wall
5 years ago, k4st wrote:
and make pagination!
wall-to-wall
5 years ago, k4st wrote:
note to self: I need more cowbell.

OneLobby
QueryQuery TimeAffected Rows
SELECT * FROM k4_users WHERE user_id=2 GROUP BY user_id LIMIT 1

 0.7252 

 1 

 
SELECT t.tag_name, COUNT(tt.tag_id) AS tag_count FROM k4_tags t, k4_thread_users tu JOIN k4_thread_tags tt USING (thread_id) WHERE t.tag_id=tt.tag_id AND tu.thread_id=tt.thread_id AND tu.user_id=2 GROUP BY t.tag_id ORDER BY tag_count DESC, t.tag_name ASC LIMIT 0,50

 0.7267 

 50 

 
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.user_id=2 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 created DESC LIMIT 10

 0.732 

 10 

 
SELECT wp.*, u.name AS poster_name FROM k4_wall_posts wp LEFT JOIN k4_users u ON wp.poster_id=u.user_id WHERE wp.user_id=2 AND (wp.private < 1 OR wp.private=1 AND wp.poster_id=1) GROUP BY wp.post_id ORDER BY created DESC LIMIT 10

 0.7342 

 9