~[if#en.~(curschoolid) in (~[displaypref:meritStoreEnabledSchools])]
~[DirectTable.Select:U_NT_MERIT_ITEM;id:~(gpv.iid)]
~[text:nicktech.merit.label.item_title]
~[text:nicktech.merit.label.description]
~[text:nicktech.merit.label.point_cost]
~[text:nicktech.merit.label.picture]
~[text:nicktech.merit.label.recommended]
~[text:nicktech.merit.help.picture_width]
~[text:nicktech.merit.help.picture_width_body]
~[text:nicktech.merit.help.picture_landscape]
~[text:nicktech.merit.help.picture_landscape_body]
~[text:nicktech.merit.label.category]
~[text:nicktech.merit.help.category]
~[text:nicktech.merit.label.redeem_limit] ~[text:nicktech.merit.help.blank_unlimited]
~[text:nicktech.merit.label.qty_available] ~[text:nicktech.merit.help.blank_unlimited]
~[text:nicktech.merit.label.grade_levels]
~[tlist_sql; SELECT DISTINCT grade_level AS glevel FROM students WHERE schoolid = ~(curschoolid) AND enroll_status = 0 ORDER BY grade_level] [/tlist_sql]
~[text:nicktech.merit.help.grades_all]
~[text:nicktech.merit.label.display_order]
~[text:nicktech.merit.label.closed] ~[text:nicktech.merit.label.closed_desc]
~[tlist_sql; SELECT dcid AS schooldcid FROM schools WHERE school_number = ~(curschoolid)] [/tlist_sql]
~[tlist_sql; SELECT 1 AS guardok FROM dual WHERE ~(gpv.iid;num) <= 0 OR EXISTS (SELECT 1 FROM u_nt_merit_item WHERE id = ~(gpv.iid;num) AND schoolid = ~(curschoolid))] ~[submitbutton] [/tlist_sql] ~[tlist_sql; SELECT 1 AS guardblocked FROM dual WHERE ~(gpv.iid;num) > 0 AND NOT EXISTS (SELECT 1 FROM u_nt_merit_item WHERE id = ~(gpv.iid;num) AND schoolid = ~(curschoolid))] [/tlist_sql]
~[tlist_sql; SELECT (SELECT COUNT(*) FROM u_nt_merit_redemption WHERE item_id = ~(gpv.iid;num)) AS usecount, ~(gpv.iid;num) AS iid FROM dual WHERE ~(gpv.iid;num) > 0 AND EXISTS (SELECT 1 FROM u_nt_merit_item WHERE id = ~(gpv.iid;num) AND schoolid = ~(curschoolid))]
[/tlist_sql] [else#en]

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

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

[/if#en]