".$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();
//
?>