b1ind's profile

Threads: 2
Comments: 4
Registered: 5 years ago
Often used Tags: What are tags?
filearts dev fa One Lobby server style test
Recent Threads: View All
Finally did Components 5 years ago by b1ind with 1 comments. Tags: fa, filearts Well, I got around to creating the component architecture. Unfortunately, I don't have any SVN set up. It is implemented by registering a new tag handler that can call the FAApplicationController::runComponent()...
New idea for the FA framework 5 years ago by b1ind with 13 comments. Tags: filearts I came up with a sweet idea for the FA framework. I'm not sure why it never occurred to me before. For templates on complicated pages, they inevitably become composites of different components. ...
Where have all the updates gone? 5 years ago by b1ind with 1 comments. Tags: One Lobby So, my question is this: where have all the updates gone? Their frequency has declined markedly of late. Could a renewal of vigour be expected sooner than later?
Test thread 5 years ago by b1ind with 0 comments. Tags: test Opening scene from Fear and Loathing in Las Vegas, including an early appearance from Tobey Maguire as the rather nervous hitch-hiker...
Using the new file layout 5 years ago by b1ind with 0 comments. Tags: server Ok, to use the latest svn on the server, login as you normally would via ssh. Use the command: CODE:svn export --force http://k4bb.org/k4BBv3 ~/onelobby/ Again, dev.onelobby.com is a symlink pointing...
Moving to better URLs 5 years ago by b1ind with 0 comments. Tags: dev Peter, it turns out that mod_rewrite works on this server. However, to use it, all relative urls (for css, images, etc) must be made absolute. Otherwise, the browser has a difficult time finding the...
Thread view look 5 years ago by b1ind with 0 comments. Tags: style I don't really like the fact that there is not really anything to distinguish comments from the thread in the thread view. Otherwise, I really like where this is going!

The Wall

| View All
wall-to-wall
5 years ago, k4st wrote:
Heeeyyyy!!!

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

 0.2756 

 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=5 GROUP BY t.tag_id ORDER BY tag_count DESC, t.tag_name ASC LIMIT 0,50

 0.2767 

 7 

 
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=5 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.2814 

 7 

 
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=5 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.2832 

 1