".$sname." ".$fname.""); // Ok, list categories of this user $result_cats = SQL_QUERY("SELECT id, cat FROM `{!_MYSQL_PREFIX!}_cats` ORDER BY `sort`", __FILE__, __LINE__); if (SQL_NUMROWS($result_cats) > 0) { // List categories $cnt = 1; $OUT = ""; $SW = 2; while ($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(REQUEST_GET('uid')), 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 .= LOAD_TEMPLATE("admin_list_cats_row", true, $content); $SW = 3 - $SW; $cnt++; } // END - while // Free memory SQL_FREERESULT($result); // @TODO Rewrite this constant define('__CATS_ROWS', $OUT); // Load main template LOAD_TEMPLATE("admin_list_cats"); } else { // No categories selected! :-( LOAD_TEMPLATE("admin_list_cats_404"); } } else { // User not found LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_MEMBER_404'), constant('__UID'))); } } else { // Output selection form with all confirmed user accounts listed ADD_MEMBER_SELECTION_BOX(); } // ?>