Tags: filearts, template What are tags?

File arts 5 years ago by Immersion with 10 comments. Tags: filearts Hey are you releasing the file arts framework? in other words could i please have a copy?

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

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.

People talking about filearts and template also talk about:

People talking about filearts and template are:

Query	Query Time	Affected Rows
SELECT ts.* FROM k4_tags ts WHERE ts.tag_name IN('filearts','template') GROUP BY ts.tag_id	0.3859	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(66,67) 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.3924	4
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(66,67) 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.3941	6
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(66,67) 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.3961	3
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.4034	3

Query

Query Time

Affected Rows

SELECT ts.* FROM k4_tags ts WHERE ts.tag_name IN('filearts','template') GROUP BY ts.tag_id

0.3859

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(66,67) 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.3924

4

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(66,67) 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.3941

6

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(66,67) 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.3961

3

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