".$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"; $SW = 2; $OUT = ""; while (list($cid, $cat) = SQL_FETCHROW($result_cats)) { // Check user's selection $result_user = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_user_cats WHERE userid=%d AND cat_id=%d LIMIT 1", array(bigintval($_GET['u_id']), bigintval($cid)), __FILE__, __LINE__); // Set selection $SELECTED = "".NO.""; if (SQL_NUMROWS($result_user) == 1) $SELECTED = "".YES.""; // Prepare array for the row template $content = array( 'sw' => $SW, 'cnt' => $cnt, 'cat' => $cat, 'sel' => $SELECTED, ); // Load row template and switch colors + count up $OUT .= LOAD_TEMPLATE("admin_list_cats_row", true, $content); $SW = 3 - $SW; $cnt++; } // Free memory SQL_FREERESULT($result); 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, ADMIN_MEMBER_404_1.__UID.ADMIN_MEMBER_404_2); } } else { // Output selection form with all confirmed user accounts listed ADD_MEMBER_SELECTION_BOX(); } CLOSE_TABLE(); // ?>