Tags: css, search save tag group What are tags?

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...
Search, History, and fa:cando 5 years ago by k4st with 0 comments. Tags: perms, history, search The above three work. But, for some reason, it seems that MySQL FULLTEXT searching can't find 'test' in 'testing' !!?? Oh well. More functionality to come to the history and search...
Quick search 5 years ago by k4st with 0 comments. Tags: css, search Check it out, it's up at the top right, it says 'search' in light grey. Hover over it and it's an input box. It doesn't do anything yet, but I think it fits in nicely and is pretty...
Hazaa! new CSS and solved a CSS Bug. 5 years ago by k4st with 0 comments. Tags: css, xhtml, design Oh man.. I just spent soo long on a stupid CSS issue. It was very annoying. The long and short of it is that I solved the problem with width: inherit;. So, is the current look okay.. or needs work? You'll...

People talking about css and search also talk about:

add tag csscss add tag xhtmlxhtml add tag permsperms add tag designdesign add tag featurefeature add tag historyhistory add tag searchsearch add tag deletedelete add tag viewview add tag commentcomment add tag ddmenuddmenu add tag xmlhttprequestxmlhttprequest

People talking about css and search are:

k4st

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

 0.7486 

 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(5,36) 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.7574 

 5 

 
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(5,36) 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.7596 

 12 

 
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(5,36) 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.7644 

 2 

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

 3