Tags: php, feature save tag group What are tags?

MediaLobby 5 years ago by Takesinn with 4 comments. Tags: feature, onelobby, gallery, video, audio, flash Unless k4st decides to make OneLobby open source or similar this might never happen as it isn't apart of his intentional plans. My idea is to release a special version of OneLobby called "MediaLobby"....
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.
fa:import 5 years ago by Koncept with 8 comments. Tags: php, fa, import, filearts, template, koncept FAimport is used when trying to import another template file.
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...
Single tag viewing 5 years ago by k4st with 1 comments. Tags: feature, tags, blogoforum You can now view single tags. It will show a list of threads common to that tag, other tags often used with that tags, and users that commonly use that tag. Originally, I was just going to put a list of...
Comment deleting, search, history and headers 5 years ago by k4st with 0 comments. Tags: feature, search, delete, comment, ddmenu, xmlhttprequest So, now you can delete comments. That's nothing too impressive, but while I was doing that I was forced to remake the k4History and k4Page classes and make them actually do stuff. I created a history...
Thread history section done 5 years ago by k4st with 0 comments. Tags: feature, history, search, view Yes, that's right. The thread history section is done. I just made it so that you can view previous thread revisions on their own.. and that was the last thing I had to do :D Tomorrow I might beef...
Reverting, deleting, fa:cando 5 years ago by k4st with 1 comments. Tags: feature, revert, delete, cando So, now you can revert threads to previous revisions. Threads can also be soft and hard deleted.. although there is no interface to show soft deleted threads yet. Also, with fa:cando, you can now have...
Thread History 5 years ago by k4st with 0 comments. Tags: feature, history You can now view it. There isn't much functionality behind it yet though. (e.g. revert, diff, etc) EDIT: There is now full functionality to it.
Coauthors and revisions 5 years ago by k4st with 0 comments. Tags: php, coauthors, revisions, history, threads I've changed the way co-authors work, and I've also added in thread revisions. So, geoffrey, when you read this, go into this thread, on the top right (in the main menu), you should see 'edit'...
Tag threads 5 years ago by k4st with 0 comments. Tags: php, feature, tag You can now tag threads... Yippee! Assumming you're registered and have permission to tag a thread, beside the edit buttons / rating buttons in the single thread view, you should see a 'tag'...
Added new/fresh caching 5 years ago by k4st with 0 comments. Tags: php, ajax, javascript, fresh, dom, new I made it so that the new/fresh switcher on the main page caches its results.. so it only really does a maximum of 2 ajax requests.
Popular and fresh 5 years ago by k4st with 0 comments. Tags: php, ajax, javascript, popular, fresh So, I just made it (offline, and on svn) that you could AJAX switch between popular and fresh threads on the main page. Some things I should add to it are caching withing certain time intervals, saving...
Just finished the basic perms acp section 5 years ago by k4st with 0 comments. Tags: php, acp, admin, perms, permissions I just finished the basic permissions section on the admin panel. It is a lot less complicated then it sounds. All it does right now is manage permission objects and their permissions.. but none of this...
Aha, found the problem 5 years ago by k4st with 0 comments. Tags: php, php4, php5 So, only a few minutes ago, several of the links didn't work. This is because of a simple difference between PHP4 and PHP5 which caused me a bit of annoying. The __CLASS__ method of PHP4 returns a...
Remote XML classes 5 years ago by k4st with 0 comments. Tags: php, programming Yesterday I finished work on the remote XML extension. This extension deals with creating a cURL session or opening a socket to a server to get/send data. It is meant to work with REST and RPC applications,...

OneLobby
QueryQuery TimeAffected Rows
SELECT ts.* FROM k4_tags ts WHERE ts.tag_name IN('feature','php') GROUP BY ts.tag_id

 0.452 

 2 

 
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, k4_thread_tags tt2  WHERE t.deleted=0 AND tt.thread_id = tt2.thread_id AND tt2.tag_id IN(2,25) 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, tt2.tag_id ORDER BY t.created DESC

 0.4613 

 16 

 
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 tt1.tag_id IN(2,25) AND tt1.tag_id <> tt2.tag_id AND ts.tag_id = tt2.tag_id GROUP BY ts.tag_id, tt2.tag_id LIMIT 250

 0.4633 

 43 

 
SELECT DISTINCT u.user_id, u.name, COUNT(tt2.tag_id) AS tag_count FROM k4_thread_users tu, k4_users u, k4_thread_tags tt1 JOIN k4_thread_tags tt2 USING (thread_id) WHERE u.user_id = tu.user_id AND tt1.tag_id IN(2,25) AND tt1.tag_id <> tt2.tag_id AND tu.thread_id = tt2.thread_id GROUP BY tt2.tag_id ORDER BY u.name ASC

 0.4683 

 5 

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

 3