"; echo " "; echo " "; echo " ". $lang['admin_main_header_m']; echo " "; echo " "; echo ""; echo "

"; echo ""; echo " "; echo " "; echo " "; echo "

"; echo " "; echo " ". $lang['choose_group']; echo " "; echo "

"; echo ""; echo "

"; } if ($mode == "select_group") { $group = $HTTP_POST_VARS['group']; $q = "SELECT * FROM ". COLORS ." WHERE group_id = '". $group ."'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); $name = $row['group_name']; $id = $row['group_id']; $color = $row['group_color']; echo ""; echo " "; echo " "; echo " "; echo "

"; echo " ". $lang['admin_main_header_m']; echo "

"; echo "

"; echo ""; echo " "; echo " "; echo " "; echo "

"; echo " "; echo " ". str_replace("%G%", $name, $lang['group_selected']); echo " "; echo "

"; echo "
"; echo ""; echo " "; echo " "; echo " "; echo " "; echo ""; echo " "; echo " "; echo " "; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; echo " "; echo " "; echo ""; echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo ""; echo "

"; echo " "; echo " ". $lang['group_already_assigned']; echo " "; echo "	"; echo " "; echo " "; echo " "; echo "
"; echo " "; echo " ". $lang['group_assign']; echo " "; echo "	"; echo " "; $q = "SELECT username, user_id FROM ". USERS_TABLE ." ORDER BY username ASC"; $r = $db->sql_query($q); $users = $db->sql_fetchrowset($r); echo " "; echo " "; echo "
'; echo ' '; echo ' '. $lang['group_assign_2']; echo ' '; echo '	'; echo ' '; echo ' '; echo ' '; echo '
"; echo " "; echo " "; echo " "; echo " "; echo "
"; echo " "; echo " ". $lang['group_delete_user']; echo " "; echo "	"; echo " "; echo " "; echo " "; echo "	"; echo " "; echo " "; echo " "; echo "

"; } if($mode == "del_user") { $user = $HTTP_POST_VARS['delete']; $group = $HTTP_POST_VARS['group']; $q = "SELECT user_color_gi FROM ". USERS_TABLE ." WHERE user_id = '". $user ."'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); $remove = str_replace('--'. $group .'--', '', $row['user_color_gi']); if (!$remove) $new_id = '0'; else $new_id = $remove; #==== If in more than 1 group, get the next color if ($new_id) { $q = "SELECT group_color, group_id FROM ". COLORS .""; $r = $db->sql_query($q); $groups_info = $db->sql_fetchrowset($r); for ($a = 0; $a < count($groups_info); $a++) { if (eregi('--'. $groups_info[$a]['group_id'] .'--', $new_id)) { $new_color = $groups_info[$a]['group_color']; break; } } } else $new_color = ''; $q = "UPDATE ". USERS_TABLE ." SET user_color_gi = '$new_id', user_color_gc = '$new_color' WHERE user_id = '". $user ."'"; $r = $db->sql_query($q); message_die(GENERAL_MESSAGE, $lang['group_delete_user_2'], $lang['success']); } if ($mode == "add_user") { $who = intval($HTTP_POST_VARS['users_id']); $multi = $HTTP_POST_VARS['multi_users_id']; $group = intval($HTTP_POST_VARS['group']); $color = $HTTP_POST_VARS['color']; if ($who) $multi = ''; if ($multi) $who = ''; if ( (!$who) && (!$multi) ) message_die(GENERAL_ERROR, $lang['choose_user_id_error']); if ($multi) { $users = explode("\n", $multi); for ($x = 0; $x < count($users); $x++) { $users[$x] = trim(addslashes(stripslashes($users[$x]))); $q = "SELECT user_color_gi, user_id FROM ". USERS_TABLE ." WHERE username = '". $users[$x] ."'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); if ($row['user_color_gi'] <> '0') $group = '--'. $group .'--'. $row['user_color_gi']; else $group = '--'. $group .'--'; $q = "UPDATE ". USERS_TABLE ." SET user_color_gi = '". $group ."', user_color_gc = '". $color ."' WHERE user_id = '". $row['user_id'] ."'"; if (!$db->sql_query($q)) message_die(GENERAL_ERROR, 'ERROR!', '', __LINE__, __FILE__, $q); } } if ($who) { $q = "SELECT user_color_gi FROM ". USERS_TABLE ." WHERE user_id = '". $who ."'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); if ($row['user_color_gi'] <> '0') $group = '--'. $group .'--'. $row['user_color_gi']; else $group = '--'. $group .'--'; $q = "UPDATE ". USERS_TABLE ." SET user_color_gi = '". $group ."', user_color_gc = '". $color ."' WHERE user_id = '". $who ."'"; if (!$db->sql_query($q)) message_die(GENERAL_ERROR, 'ERROR!', '', __LINE__, __FILE__, $q); } message_die(GENERAL_MESSGAE, $lang['group_user_added'], $lang['success']); } include('page_footer_admin.' . $phpEx); ?>