~[if#en.~(curschoolid) in (~[displaypref:meritStoreEnabledSchools])]
~[DirectTable.Select:U_NT_MERIT_BEHAVIOR;id:~(gpv.bid)]
~[text:nicktech.merit.label.behavior_name]
~[text:nicktech.merit.label.default_points]
~[text:nicktech.merit.label.display_order]
~[text:nicktech.merit.label.active] ~[text:nicktech.merit.label.available_in_menus]
~[tlist_sql; SELECT dcid AS schooldcid FROM schools WHERE school_number = ~(curschoolid)] [/tlist_sql]
~[tlist_sql; SELECT 1 AS guardok FROM dual WHERE ~(gpv.bid;num) <= 0 OR EXISTS (SELECT 1 FROM u_nt_merit_behavior WHERE id = ~(gpv.bid;num) AND schoolid = ~(curschoolid))] ~[submitbutton] [/tlist_sql] ~[tlist_sql; SELECT 1 AS guardblocked FROM dual WHERE ~(gpv.bid;num) > 0 AND NOT EXISTS (SELECT 1 FROM u_nt_merit_behavior WHERE id = ~(gpv.bid;num) AND schoolid = ~(curschoolid))] [/tlist_sql]
~[tlist_sql; SELECT (SELECT COUNT(*) FROM u_nt_merit_points WHERE behavior_id = ~(gpv.bid;num)) AS usecount, ~(gpv.bid;num) AS bid FROM dual WHERE ~(gpv.bid;num) > 0 AND EXISTS (SELECT 1 FROM u_nt_merit_behavior WHERE id = ~(gpv.bid;num) AND schoolid = ~(curschoolid))]
[/tlist_sql] [else#en]

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

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

[/if#en]