<?php
	$sql = "SELECT * FROM __admin_tables
			WHERE at_type = 'menugroup'
			ORDER BY at_order";
	$groups = get_select($sql, __LINE__, __FILE__);
	
	foreach ($groups as $k => $v) {
		$sql = "SELECT * FROM __admin_tables
				WHERE at_type IN ('table', 'file')
				AND at_parent_id = '{$v['at_id']}'
				ORDER BY at_order";
		$groups[$k]['submenu'] = get_select($sql, __LINE__, __FILE__);
	}
	
	$smarty->assign('all_tables', $groups);
?>