k4st's profile

Threads: 13
Comments: 39
Registered: 5 years ago
Recent Threads: View All
index.php …this is my new code…
Test with code hello hello <pre> hello hello </pre>
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!
Slooooooow 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 Just implemented a captcha. It's quite clever how I made it, let's hope people find it readable.
My Blog! I've got a programming blog! Check it out: http://www.flyingwithfire.com/
The Wall 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

nice work on onelobby

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

talk to you later.

Good to hear from you!

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

/me also licks wall

this is awesome just needs more eye candy

*licks the wall*

You rock, good Sir.
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 )
and make pagination!
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