".$content['surname']." ".$content['family'].""; // Ok, list categories of this user $result_cats = SQL_QUERY("SELECT `id`, `cat` FROM `{?_MYSQL_PREFIX?}_cats` ORDER BY `sort` ASC", __FILE__, __LINE__); if (SQL_NUMROWS($result_cats) > 0) { // List categories $cnt = 1; $OUT = ''; $SW = 2; while ($content = merge_array($content, SQL_FETCHARRAY($result_cats))) { // Check user's selection $result_user = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_cats` WHERE `userid`=%s AND `cat_id`=%s LIMIT 1", array(bigintval(getRequestElement('userid')), bigintval($content['id'])), __FILE__, __LINE__); // Set selection $selection = "{--NO--}"; if (SQL_NUMROWS($result_user) == 1) $selection = "{--YES--}"; // Add more elements $content['sw'] = $SW; $content['cnt'] = $cnt; $content['sel'] = $selection; // Load row template and switch colors + count up $OUT .= loadTemplate('admin_list_cats_row', true, $content); $SW = 3 - $SW; $cnt++; } // END - while // Free memory SQL_FREERESULT($result); // Remember all rows in the array $content['rows'] = $OUT; // Load main template loadTemplate('admin_list_cats', false, $content); } else { // No categories selected! :-( loadTemplate('admin_list_cats_404', false, $content); } } else { // User not found loadTemplate('admin_settings_saved', false, sprintf(getMessage('ADMIN_MEMBER_404'), $content['userid'])); } // Free result SQL_FREERESULT($result); } else { // Output selection form with all confirmed user accounts listed addMemberSelectionBox(); } // [EOF] ?>