~[if#en.~(curschoolid) in (~[displaypref:meritStoreEnabledSchools])]
~[DirectTable.Select:U_NT_MERIT_ITEM_CAT;id:~(gpv.cid)]
~[text:nicktech.merit.label.category_name]
~[text:nicktech.merit.label.display_order]
~[text:nicktech.merit.label.active] ~[text:nicktech.merit.label.available_for_items]
~[tlist_sql; SELECT dcid AS schooldcid FROM schools WHERE school_number = ~(curschoolid)] [/tlist_sql]
~[tlist_sql; SELECT 1 AS guardok FROM dual WHERE ~(gpv.cid;num) <= 0 OR EXISTS (SELECT 1 FROM u_nt_merit_item_cat WHERE id = ~(gpv.cid;num) AND schoolid = ~(curschoolid))] ~[submitbutton] [/tlist_sql] ~[tlist_sql; SELECT 1 AS guardblocked FROM dual WHERE ~(gpv.cid;num) > 0 AND NOT EXISTS (SELECT 1 FROM u_nt_merit_item_cat WHERE id = ~(gpv.cid;num) AND schoolid = ~(curschoolid))] [/tlist_sql]
~[tlist_sql; SELECT (SELECT COUNT(*) FROM u_nt_merit_item WHERE category_id = ~(gpv.cid;num)) AS usecount, ~(gpv.cid;num) AS cid FROM dual WHERE ~(gpv.cid;num) > 0 AND EXISTS (SELECT 1 FROM u_nt_merit_item_cat WHERE id = ~(gpv.cid;num) AND schoolid = ~(curschoolid))]
[/tlist_sql] [else#en]

~[text:nicktech.merit.error.not_enabled_title]

~[text:nicktech.merit.error.not_enabled_body]

[/if#en]