~[text:nicktech.merit.heading.items_at_school] – ~(schoolabbr)

~[tlist_sql; SELECT CASE WHEN i.closed = 1 THEN 'inactiveRow' ELSE '' END AS irowclass, i.id AS iid, i.sort_order AS iorder, i.name AS iname, i.point_cost AS icost, CASE WHEN i.image_data IS NULL THEN '~[text:nicktech.merit.value.no]' ELSE '~[text:nicktech.merit.value.yes]' END AS ihasimg, NVL(c.name,' ') AS icat, CASE WHEN i.closed = 1 THEN '~[text:nicktech.merit.value.closed]' ELSE '~[text:nicktech.merit.value.open]' END AS istatus, CASE WHEN i.qty_total IS NULL THEN '~[text:nicktech.merit.label.unlimited]' ELSE ''||i.qty_total END AS iqty, CASE WHEN i.redeem_limit IS NULL THEN '~[text:nicktech.merit.label.unlimited]' ELSE ''||i.redeem_limit END AS ilimit, CASE WHEN i.grade_levels IS NULL THEN '~[text:nicktech.merit.value.all]' ELSE i.grade_levels END AS igrades FROM u_nt_merit_item i LEFT JOIN u_nt_merit_item_cat c ON c.id = i.category_id WHERE i.schoolid = ~(curschoolid) ORDER BY i.sort_order, i.name] [/tlist_sql]

~[text:nicktech.merit.th.order]	~[text:nicktech.merit.th.title]	~[text:nicktech.merit.th.cost]	~[text:nicktech.merit.th.picture]	~[text:nicktech.merit.th.category]	~[text:nicktech.merit.th.status]	~[text:nicktech.merit.th.available]	~[text:nicktech.merit.th.limit_per_student]	~[text:nicktech.merit.th.grades]
	~(iname)	~(icost)	~(ihasimg)	~(icat)	~(istatus)	~(iqty)	~(ilimit)	~(igrades)	~[text:nicktech.merit.button.edit]

~[text:nicktech.merit.help.drag_to_reorder]
~[text:nicktech.merit.help.items_hidden]