D9 D}C9 Dy)D_)D}C9 DD DC DR DuDtuDUD0`D)Da)DPA"DtA"DA"D? D8DD DC DR DuDtuDUD0`D9 D}C9 DD9 D;"D9 Dc)D*c)D D9 Dj)Di)D D9 D D9 D D9 Da)D9 DD9 Di)D6i)Dj)Dk)DD9 DD9 D!DcD|i)D`)Dh)D`)D D9 D DC DR DuDtuDUD0`DKqD1DT*DD9 DQDDބDDD9 DD9 DD9 DD9 DD9 DD9 DD9 DD9 DD9 DD9 DD9 DD9 D=DD9 DD' D+Dh"D~+D "DEAD,D D9 D}D~D~D"D1 DD,DD!DD!DD!DD!D E!DE!DDDua)DD9 D7#D9 D7#D9 D7#D9 D1D}C@DSD UD D/D D&DFED:CDD9 DՌ!D!D5!D!DDzDG DqDk D D DD9 Da)DlD!P0 P0 P0 P0 P0 P0 P0 DP0 P0 P0 \P0 jY D3u RSRh Du e DC DR DuDtuDUD0`DDǏDD DJP0 UAd]U,Vu W3;M}} E;lj>tf8E;tf8I ;SYu[;߉]bWE;tfK fE;tK fE;[E_^UV9Ea\^]ju.hDx D3uEt SP3@_^[] P0 US]Vu 3҉;W=tA=P0t=`t3Su u _^[] jYh D3uRSRh< Dux=7jYhD3tu jYR D3uRhhW DRRRSRh Du$u3ҋ;tPQ3jYx D3nEא DC DR DuDtuDUD0`D nD[oDPA"DtA"DA"Dɤ DR"DAD DC DR DuDtuDUD0`DBDpBDjY D3uHSuSh DjY D3u,SuShX Du9;u"E;t PQ3U uRu7_^[]  DC DR DuDtuDUD0`DN~D~D DC DR DuDtuDUD0`D~DP0 P0 jYd D3uh DuSh De D D< DH D D D8 D8 D6 D6 D4 D4 D DC DR DuDtuDUD0`DD9 D!D5C|p!Dw!DD9 DD9 DD9 DP0 US]VW} 3;3 j7;t sh3 Wh DVVPWK s_^[]P0 US]VW} 3;j3 j7;t sS3 WhL DVVPWKr_^[]P0 UQeS]Vu W3 V9jjj{hf N{ jj2 gx%E{ jM*{ s5w} e2 MQhD ="' . $row['user_website'] . '" target="_userwww" rel="nofollow">' . $lang['Visit_website'] . '' : ''; if ( !empty($row['user_icq']) ) { $icq_status_img = ''; $icq_img = '' . $lang['ICQ'] . ''; $icq = '' . $lang['ICQ'] . ''; } else { $icq_status_img = ''; $icq_img = ''; $icq = ''; } $temp_url = append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']); $msn_img = ( $row['user_msnm'] ) ? '' . $lang['MSNM'] . '' : ''; $msn = ( $row['user_msnm'] ) ? '' . $lang['MSNM'] . '' : ''; $yim_img = ( $row['user_yim'] ) ? '' . $lang['YIM'] . '' : ''; $yim = ( $row['user_yim'] ) ? '' . $lang['YIM'] . '' : ''; $temp_url = append_sid("search.$phpEx?search_author=" . urlencode($row['username']) . "&showresults=posts"); $search_img = '' . sprintf($lang['Search_user_posts'], $row['username']) . ''; $search = '' . sprintf($lang['Search_user_posts'], $row['username']) . ''; return; } // // -------------------------- // // Start session management // $userdata = session_pagestart($user_ip, PAGE_GROUPCP); init_userprefs($userdata); // // End session management // $user_topics_per_page = ($userdata['user_topics_per_page'] > 0) ? $userdata['user_topics_per_page'] : '25'; if ( $board_config['login_require'] && !$userdata['session_logged_in'] || ( $board_config['crestrict'] && !$userdata['session_logged_in'] ) ) { $message = $lang['login_require'] . '

' . sprintf($lang['login_require_register'], '', ''); message_die(GENERAL_MESSAGE, $message); } $script_name = preg_replace('/^\/?(.*?)\/?$/', "\\1", trim($board_config['script_path'])); $script_name = ( $script_name != '' ) ? $script_name . '/groupcp.'.$phpEx : 'groupcp.'.$phpEx; $server_name = trim($board_config['server_name']); $server_protocol = ( $board_config['cookie_secure'] ) ? 'https://' : 'http://'; $server_port = ( $board_config['server_port'] <> 80 ) ? ':' . trim($board_config['server_port']) . '/' : '/'; $server_url = $server_protocol . $server_name . $server_port . $script_name; if ( isset($HTTP_GET_VARS[POST_GROUPS_URL]) || isset($HTTP_POST_VARS[POST_GROUPS_URL]) ) { $group_id = ( isset($HTTP_POST_VARS[POST_GROUPS_URL]) ) ? intval($HTTP_POST_VARS[POST_GROUPS_URL]) : intval($HTTP_GET_VARS[POST_GROUPS_URL]); } else { $group_id = ''; } if ( $group_id && isset($HTTP_POST_VARS['mass_email']) ) { redirect(append_sid("groupcp_mail.$phpEx?" . POST_GROUPS_URL . "=" . $group_id, true)); } if ( isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode']) ) { $mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode']; $mode = htmlspecialchars($mode); } else { $mode = ''; } $confirm = ( isset($HTTP_POST_VARS['confirm']) ) ? TRUE : 0; $cancel = ( isset($HTTP_POST_VARS['cancel']) ) ? TRUE : 0; $start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0; if ( isset($HTTP_POST_VARS['start']) ) { $start = intval($HTTP_POST_VARS['start']); } // // Default var values // $is_moderator = FALSE; if ( isset($HTTP_POST_VARS['groupstatus']) && $group_id ) { if ( !$userdata['session_logged_in'] ) { redirect(append_sid("login.$phpEx?redirect=groupcp.$phpEx&" . POST_GROUPS_URL . "=$group_id", true)); } $sql = "SELECT group_moderator FROM " . GROUPS_TABLE . " WHERE group_id = $group_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain user and group information', '', __LINE__, __FILE__, $sql); } $row = $db->sql_fetchrow($result); if ( $row['group_moderator'] != $userdata['user_id'] && $userdata['user_level'] != ADMIN ) { $template->assign_vars(array( 'META' => '') ); $message = $lang['Not_group_moderator'] . '

' . sprintf($lang['Click_return_group'], '', '') . '

' . sprintf($lang['Click_return_index'], '', ''); message_die(GENERAL_MESSAGE, $message); } $sql = "UPDATE " . GROUPS_TABLE . " SET group_type = " . intval($HTTP_POST_VARS['group_type']) . " WHERE group_id = $group_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain user and group information', '', __LINE__, __FILE__, $sql); } sql_cache('clear', 'groups_desc'); sql_cache('clear', 'user_groups'); sql_cache('clear', 'groups_data'); sql_cache('clear', 'moderators_list'); $template->assign_vars(array( 'META' => '') ); $message = $lang['Group_type_updated'] . '

' . sprintf($lang['Click_return_group'], '', '') . '

' . sprintf($lang['Click_return_index'], '', ''); message_die(GENERAL_MESSAGE, $message); } else if ( isset($HTTP_POST_VARS['joingroup']) && $group_id ) { // // First, joining a group // If the user isn't logged in redirect them to login // if ( !$userdata['session_logged_in'] ) { redirect(append_sid("login.$phpEx?redirect=groupcp.$phpEx&" . POST_GROUPS_URL . "=$group_id", true)); } $sql = "SELECT ug.user_id, g.group_type FROM (" . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g) WHERE g.group_id = $group_id AND g.group_type <> " . GROUP_HIDDEN . " AND ug.group_id = g.group_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain user and group information', '', __LINE__, __FILE__, $sql); } if ( $row = $db->sql_fetchrow($result) ) { $is_autogroup_enable = ($row['group_count'] <= $userdata['user_posts']) ? true : false; if ( $row['group_type'] == GROUP_OPEN || $is_autogroup_enable) { do { if ( $userdata['user_id'] == $row['user_id'] ) { $template->assign_vars(array( 'META' => '') ); $message = $lang['Already_member_group'] . '

' . sprintf($lang['Click_return_group'], '', '') . '

' . sprintf($lang['Click_return_index'], '', ''); message_die(GENERAL_MESSAGE, $message); } } while ( $row = $db->sql_fetchrow($result) ); } else { $template->assign_vars(array( 'META' => '') ); $message = $lang['This_closed_group'] . '

' . sprintf($lang['Click_return_group'], '', '') . '

' . sprintf($lang['Click_return_index'], '', ''); message_die(GENERAL_MESSAGE, $message); } } else { message_die(GENERAL_MESSAGE, $lang['No_groups_exist']); } $sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending) VALUES ($group_id, " . $userdata['user_id'] . ", 1)"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error inserting user group subscription', '', __LINE__, __FILE__, $sql); } sql_cache('clear', 'groups_desc'); sql_cache('clear', 'user_groups'); sql_cache('clear', 'groups_data'); sql_cache('clear', 'moderators_list'); $sql = "SELECT u.user_email, u.username, u.user_lang, g.group_name FROM (" . USERS_TABLE . " u, " . GROUPS_TABLE . " g) WHERE u.user_id = g.group_moderator AND g.group_id = $group_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, "Error getting group moderator data", "", __LINE__, __FILE__, $sql); } $moderator = $db->sql_fetchrow($result); include($phpbb_root_path . 'includes/emailer.'.$phpEx); $emailer = new emailer($board_config['smtp_delivery']); $emailer->from($board_config['email_from']); $emailer->replyto($board_config['email_return_path']); $emailer->use_template('group_request', $moderator['user_lang']); $emailer->email_address($moderator['user_email']); $emailer->set_subject(sprintf($lang['Group_request'], $moderator['group_name'])); $emailer->assign_vars(array( 'SITENAME' => $board_config['sitename'], 'GROUP_MODERATOR' => $moderator['username'], 'GROUP_NAME' => $moderator['group_name'], 'USERNAME' => $userdata['username'], 'EMAIL_SIG' => (!empty($board_config['board_email_sig'])) ? str_replace('
', "\n", "-- \n" . $board_config['board_email_sig']) : '', 'U_GROUPCP' => $server_url . '?' . POST_GROUPS_URL . "=$group_id&validate=true") ); $emailer->send(); $emailer->reset(); $template->assign_vars(array( 'META' => '') ); $message = $lang['Group_joined'] . '

' . sprintf($lang['Click_return_group'], '', '') . '

' . sprintf($lang['Click_return_index'], '', ''); message_die(GENERAL_MESSAGE, $message); } else if ( isset($HTTP_POST_VARS['unsub']) || isset($HTTP_POST_VARS['unsubpending']) && $group_id ) { $sql = "SELECT group_no_unsub FROM " . GROUPS_TABLE . " WHERE group_id = $group_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain user and group information', '', __LINE__, __FILE__, $sql); } $row = $db->sql_fetchrow($result); if ( $row['group_no_unsub'] ) { message_die(GENERAL_MESSAGE, 'You can not leave this group'); } // Second, unsubscribing from a group // Check for confirmation of unsub. if ( $cancel ) { redirect(append_sid("groupcp.$phpEx", true)); } elseif ( !$userdata['session_logged_in'] ) { redirect(append_sid("login.$phpEx?redirect=groupcp.$phpEx&" . POST_GROUPS_URL . "=$group_id", true)); } if ( $confirm ) { $sql = "DELETE FROM " . USER_GROUP_TABLE . " WHERE user_id = " . $userdata['user_id'] . " AND group_id = $group_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not delete group memebership data', '', __LINE__, __FILE__, $sql); } if ( $userdata['user_level'] != ADMIN && $userdata['user_level'] == MOD ) { $sql = "SELECT COUNT(auth_mod) AS is_auth_mod FROM (" . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug) WHERE ug.user_id = " . $userdata['user_id'] . " AND aa.group_id = ug.group_id AND aa.auth_mod = 1"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain moderator status', '', __LINE__, __FILE__, $sql); } if ( !($row = $db->sql_fetchrow($result)) || $row['is_auth_mod'] == 0 ) { $sql = "UPDATE " . USERS_TABLE . " SET user_level = " . USER . " WHERE user_id = " . $userdata['user_id']; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql); } } } sql_cache('clear', 'groups_desc'); sql_cache('clear', 'user_groups'); sql_cache('clear', 'groups_data'); sql_cache('clear', 'moderators_list'); $template->assign_vars(array( 'META' => '') ); $message = $lang['Unsub_success'] . '

' . sprintf($lang['Click_return_group'], '', '') . '

' . sprintf($lang['Click_return_index'], '', ''); message_die(GENERAL_MESSAGE, $message); } else { $unsub_msg = ( isset($HTTP_POST_VARS['unsub']) ) ? $lang['Confirm_unsub'] : $lang['Confirm_unsub_pending']; $s_hidden_fields = ''; $page_title = $lang['Group_Control_Panel']; include($phpbb_root_path . 'includes/page_header.'.$phpEx); $template->set_filenames(array( 'confirm' => 'confirm_body.tpl') ); $template->assign_vars(array( 'MESSAGE_TITLE' => $lang['Confirm'], 'MESSAGE_TEXT' => $unsub_msg, 'L_YES' => $lang['Yes'], 'L_NO' => $lang['No'], 'S_CONFIRM_ACTION' => append_sid("groupcp.$phpEx"), 'S_HIDDEN_FIELDS' => $s_hidden_fields) ); $template->pparse('confirm'); include($phpbb_root_path . 'includes/page_tail.'.$phpEx); } } else if ( $group_id ) { // // Did the group moderator get here through an email? // If so, check to see if they are logged in. // if ( isset($HTTP_GET_VARS['validate']) ) { if ( !$userdata['session_logged_in'] ) { redirect(append_sid("login.$phpEx?redirect=groupcp.$phpEx&" . POST_GROUPS_URL . "=$group_id", true)); } } // // For security, get the ID of the group moderator. // $sql = "SELECT g.group_moderator, g.group_type, g.group_mail_enable, aa.auth_mod FROM " . GROUPS_TABLE . " g LEFT JOIN " . AUTH_ACCESS_TABLE . " aa ON (aa.group_id = g.group_id) WHERE g.group_id = $group_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not get moderator information', '', __LINE__, __FILE__, $sql); } if ( $group_info = $db->sql_fetchrow($result) ) { $group_moderator = $group_info['group_moderator']; if ( $group_moderator == $userdata['user_id'] || $userdata['user_level'] == ADMIN ) { include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_mass_email.' . $phpEx); $is_moderator = TRUE; } // // Handle Additions, removals, approvals and denials // if ( !empty($HTTP_POST_VARS['add']) || !empty($HTTP_POST_VARS['remove']) || isset($HTTP_POST_VARS['approve']) || isset($HTTP_POST_VARS['deny']) ) { if ( !$userdata['session_logged_in'] ) { redirect(append_sid("login.$phpEx?redirect=groupcp.$phpEx&" . POST_GROUPS_URL . "=$group_id", true)); } if ( !$is_moderator ) { $template->assign_vars(array( 'META' => '') ); $message = $lang['Not_group_moderator'] . '

' . sprintf($lang['Click_return_index'], '', ''); message_die(GENERAL_MESSAGE, $message); } if ( isset($HTTP_POST_VARS['add']) ) { $username = ( isset($HTTP_POST_VARS['username']) ) ? phpbb_clean_username($HTTP_POST_VARS['username']) : ''; $sql = "SELECT user_id, user_email, user_lang, user_level FROM " . USERS_TABLE . " WHERE username = '" . str_replace("\'", "''", $username) . "'"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, "Could not get user information", $lang['Error'], __LINE__, __FILE__, $sql); } if ( !($row = $db->sql_fetchrow($result)) ) { $template->assign_vars(array( 'META' => '') ); $message = $lang['No_user_id_specified'] . "

" . sprintf($lang['Click_return_group'], "", "") . "

" . sprintf($lang['Click_return_index'], "", ""); message_die(GENERAL_MESSAGE, $message); } if ( $row['user_id'] == ANONYMOUS ) { $template->assign_vars(array( 'META' => '') ); $message = $lang['Could_not_anon_user'] . '

' . sprintf($lang['Click_return_group'], '', '') . '

' . sprintf($lang['Click_return_index'], '', ''); message_die(GENERAL_MESSAGE, $message); } $sql = "SELECT ug.user_id, u.user_level FROM (" . USER_GROUP_TABLE . " ug, " . USERS_TABLE . " u) WHERE u.user_id = " . $row['user_id'] . " AND ug.user_id = u.user_id AND ug.group_id = $group_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not get user information', '', __LINE__, __FILE__, $sql); } if ( !($db->sql_fetchrow($result)) ) { $sql = "INSERT INTO " . USER_GROUP_TABLE . " (user_id, group_id, user_pending) VALUES (" . $row['user_id'] . ", $group_id, 0)"; if ( !$db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not add user to group', '', __LINE__, __FILE__, $sql); } if ( $row['user_level'] != ADMIN && $row['user_level'] != MOD && $group_info['auth_mod'] ) { $sql = "UPDATE " . USERS_TABLE . " SET user_level = " . MOD . ", user_ip_login_check = 1 WHERE user_id = " . $row['user_id']; if ( !$db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql); } } sql_cache('clear', 'groups_desc'); sql_cache('clear', 'user_groups'); sql_cache('clear', 'groups_data'); sql_cache('clear', 'moderators_list'); // // Get the group name // Email the user and tell them they're in the group // $group_sql = "SELECT group_name FROM " . GROUPS_TABLE . " WHERE group_id = $group_id"; if ( !($result = $db->sql_query($group_sql)) ) { message_die(GENERAL_ERROR, 'Could not get group information', '', __LINE__, __FILE__, $group_sql); } $group_name_row = $db->sql_fetchrow($result); $group_name = $group_name_row['group_name']; include($phpbb_root_path . 'includes/emailer.'.$phpEx); $emailer = new emailer($board_config['smtp_delivery']); $emailer->from($board_config['email_from']); $emailer->replyto($board_config['email_return_path']); $emailer->use_template('group_added', $row['user_lang']); $emailer->email_address($row['user_email']); $emailer->set_subject(sprintf($lang['Group_added'], $group_name)); $emailer->assign_vars(array( 'SITENAME' => $board_config['sitename'], 'GROUP_NAME' => $group_name, 'EMAIL_SIG' => (!empty($board_config['board_email_sig'])) ? str_replace('
', "\n", "-- \n" . $board_config['board_email_sig']) : '', 'U_GROUPCP' => $server_url . '?' . POST_GROUPS_URL . "=$group_id") ); $emailer->send(); $emailer->reset(); } else { $template->assign_vars(array( 'META' => '') ); $message = $lang['User_is_member_group'] . '

' . sprintf($lang['Click_return_group'], '', '') . '

' . sprintf($lang['Click_return_index'], '', ''); message_die(GENERAL_MESSAGE, $message); } } else { if ( ( ( isset($HTTP_POST_VARS['approve']) || isset($HTTP_POST_VARS['deny']) ) && isset($HTTP_POST_VARS['pending_members']) ) || ( isset($HTTP_POST_VARS['remove']) && isset($HTTP_POST_VARS['members']) ) ) { $members = ( isset($HTTP_POST_VARS['approve']) || isset($HTTP_POST_VARS['deny']) ) ? $HTTP_POST_VARS['pending_members'] : $HTTP_POST_VARS['members']; $sql_in = ''; for($i = 0; $i < count($members); $i++) { $sql_in .= ( ( $sql_in != '' ) ? ', ' : '' ) . intval($members[$i]); } if ( isset($HTTP_POST_VARS['approve']) ) { if ( $group_info['auth_mod'] ) { $sql = "UPDATE " . USERS_TABLE . " SET user_level = " . MOD . ", user_ip_login_check = 1 WHERE user_id IN ($sql_in) AND user_level NOT IN (" . MOD . ", " . ADMIN . ")"; if ( !$db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql); } } $sql = "UPDATE " . USER_GROUP_TABLE . " SET user_pending = 0 WHERE user_id IN ($sql_in) AND group_id = $group_id"; $sql_select = "SELECT user_email FROM ". USERS_TABLE . " WHERE user_id IN ($sql_in)"; } else if ( isset($HTTP_POST_VARS['deny']) || isset($HTTP_POST_VARS['remove']) ) { if ( $group_info['auth_mod'] ) { $sql = "SELECT ug.user_id, ug.group_id FROM (" . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug) WHERE ug.user_id IN ($sql_in) AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_id, ug.group_id ORDER BY ug.user_id, ug.group_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain moderator status', '', __LINE__, __FILE__, $sql); } if ( $row = $db->sql_fetchrow($result) ) { $group_check = array(); $remove_mod_sql = ''; do { $group_check[$row['user_id']][] = $row['group_id']; } while ( $row = $db->sql_fetchrow($result) ); while( list($user_id, $group_list) = @each($group_check) ) { if ( count($group_list) == 1 ) { $remove_mod_sql .= ( ( $remove_mod_sql != '' ) ? ', ' : '' ) . $user_id; } } if ( $remove_mod_sql != '' ) { $sql = "UPDATE " . USERS_TABLE . " SET user_level = " . USER . " WHERE user_id IN ($remove_mod_sql) AND user_level NOT IN (" . ADMIN . ")"; if ( !$db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql); } } } } $sql = "DELETE FROM " . USER_GROUP_TABLE . " WHERE user_id IN ($sql_in) AND group_id = $group_id"; } if ( !$db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not update user group table', '', __LINE__, __FILE__, $sql); } // // Email users when they are approved // if ( isset($HTTP_POST_VARS['approve']) ) { if ( !($result = $db->sql_query($sql_select)) ) { message_die(GENERAL_ERROR, 'Could not get user email information', '', __LINE__, __FILE__, $sql); } $bcc_list = array(); while ($row = $db->sql_fetchrow($result)) { $bcc_list[] = $row['user_email']; } // // Get the group name // $group_sql = "SELECT group_name FROM " . GROUPS_TABLE . " WHERE group_id = $group_id"; if ( !($result = $db->sql_query($group_sql)) ) { message_die(GENERAL_ERROR, 'Could not get group information', '', __LINE__, __FILE__, $group_sql); } $group_name_row = $db->sql_fetchrow($result); $group_name = $group_name_row['group_name']; include($phpbb_root_path . 'includes/emailer.'.$phpEx); $emailer = new emailer($board_config['smtp_delivery']); $emailer->from($board_config['email_from']); $emailer->replyto($board_config['email_return_path']); for ($i = 0; $i < count($bcc_list); $i++) { $emailer->bcc($bcc_list[$i]); } $emailer->use_template('group_approved'); $emailer->set_subject(sprintf($lang['Group_added'], $group_name)); $emailer->assign_vars(array( 'SITENAME' => $board_config['sitename'], 'GROUP_NAME' => $group_name, 'EMAIL_SIG' => (!empty($board_config['board_email_sig'])) ? str_replace('
', "\n", "-- \n" . $board_config['board_email_sig']) : '', 'U_GROUPCP' => $server_url . '?' . POST_GROUPS_URL . "=$group_id") ); $emailer->send(); $emailer->reset(); } sql_cache('clear', 'groups_desc'); sql_cache('clear', 'user_groups'); sql_cache('clear', 'groups_data'); sql_cache('clear', 'moderators_list'); } } } // // END approve or deny // } else { message_die(GENERAL_MESSAGE, $lang['No_groups_exist']); } // // Get group details // $sql = "SELECT * FROM " . GROUPS_TABLE . " WHERE group_id = $group_id AND group_single_user = 0"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error getting group information', '', __LINE__, __FILE__, $sql); } if ( !($group_info = $db->sql_fetchrow($result)) ) { message_die(GENERAL_MESSAGE, $lang['Group_not_exist']); } // // Get moderator details for this group // $sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_yim, user_msnm FROM " . USERS_TABLE . " WHERE user_id = " . $group_info['group_moderator']; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error getting user list for group', '', __LINE__, __FILE__, $sql); } $group_moderator = $db->sql_fetchrow($result); if ( !$group_moderator['user_id'] ) { message_die(GENERAL_ERROR, 'Group moderator not exist !'); } // // Get user information for this group // if ( $group_info['group_count'] && $group_info['group_count_enable'] ) { $sql = "SELECT ug.user_id FROM (" . USER_GROUP_TABLE . " ug, " . USERS_TABLE . " u) WHERE ug.group_id = $group_id AND u.user_id = ug.user_id AND ug.user_pending = 0 AND u.user_id <> " . $group_info['group_moderator'] . " AND u.user_posts < " . $group_info['group_count']; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error geting users groups data', '', __LINE__, __FILE__, $sql); } $user_ids = ''; while ($rem_row = $db->sql_fetchrow($result)) { $user_ids .= ($user_ids) ? ', ' . $rem_row['user_id'] : $rem_row['user_id']; } if ( $user_ids ) { $sql = "DELETE FROM " . USER_GROUP_TABLE . " WHERE group_id = $group_id AND user_id IN($user_ids)"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not delete group memebership data', '', __LINE__, __FILE__, $sql); } sql_cache('clear', 'user_groups'); sql_cache('clear', 'moderators_list'); } } $sql = "SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_yim, u.user_msnm, ug.user_pending FROM (" . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug) WHERE ug.group_id = $group_id AND u.user_id = ug.user_id AND ug.user_pending = 0 AND ug.user_id <> " . $group_moderator['user_id'] . " ORDER BY u.username"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error getting user list for group', '', __LINE__, __FILE__, $sql); } $group_members = $db->sql_fetchrowset($result); $members_count = count($group_members); $db->sql_freeresult($result); $sql = "SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_yim, u.user_msnm FROM (" . GROUPS_TABLE . " g, " . USER_GROUP_TABLE . " ug, " . USERS_TABLE . " u) WHERE ug.group_id = $group_id AND g.group_id = ug.group_id AND ug.user_pending = 1 AND u.user_id = ug.user_id ORDER BY u.username"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error getting user pending information', '', __LINE__, __FILE__, $sql); } $modgroup_pending_list = $db->sql_fetchrowset($result); $modgroup_pending_count = count($modgroup_pending_list); $db->sql_freeresult($result); $is_group_member = 0; if ( $members_count ) { for($i = 0; $i < $members_count; $i++) { if ( $group_members[$i]['user_id'] == $userdata['user_id'] && $userdata['session_logged_in'] ) { $is_group_member = TRUE; } } } $is_group_pending_member = 0; $is_autogroup_enable = ($group_info['group_count'] <= $userdata['user_posts']) ? true : false; if ( $modgroup_pending_count ) { for($i = 0; $i < $modgroup_pending_count; $i++) { if ( $modgroup_pending_list[$i]['user_id'] == $userdata['user_id'] && $userdata['session_logged_in'] ) { $is_group_pending_member = TRUE; } } } if ( $userdata['user_level'] == ADMIN ) { $is_moderator = TRUE; } if ( $userdata['user_id'] == $group_info['group_moderator'] ) { $is_moderator = TRUE; $group_details = $lang['Are_group_moderator']; $s_hidden_fields = ''; } else if ( $is_group_member || $is_group_pending_member ) { if ( !$group_info['group_no_unsub'] ) { $template->assign_block_vars('switch_unsubscribe_group_input', array()); } $group_details = ( $is_group_pending_member ) ? $lang['Pending_this_group'] : $lang['Member_this_group']; $s_hidden_fields = ''; } else if ( $userdata['user_id'] == ANONYMOUS ) { $group_details = $lang['Login_to_join']; $s_hidden_fields = ''; } else { if ( $group_info['group_type'] == GROUP_OPEN ) { $template->assign_block_vars('switch_subscribe_group_input', array()); $group_details = $lang['This_open_group']; $s_hidden_fields = ''; } else if ( $group_info['group_type'] == GROUP_CLOSED ) { if ($is_autogroup_enable) { $template->assign_block_vars('switch_subscribe_group_input', array()); $group_details = sprintf ($lang['This_closed_group'],$lang['Join_auto']); $s_hidden_fields = ''; } else { $group_details = sprintf ($lang['This_closed_group'],$lang['No_more']); $s_hidden_fields = ''; } } else if ( $group_info['group_type'] == GROUP_HIDDEN ) { if ($is_autogroup_enable) { $template->assign_block_vars('switch_subscribe_group_input', array()); $group_details = sprintf ($lang['This_hidden_group'],$lang['Join_auto']); $s_hidden_fields = ''; } else { $group_details = sprintf ($lang['This_closed_group'],$lang['No_add_allowed']); $s_hidden_fields = ''; } } } $page_title = $lang['Group_Control_Panel']; include($phpbb_root_path . 'includes/page_header.'.$phpEx); // // Load templates // $template->set_filenames(array( 'info' => 'groupcp_info_body.tpl', 'pendinginfo' => 'groupcp_pending_info.tpl') ); make_jumpbox('viewforum.'.$phpEx); // // Add the moderator // $username = $group_moderator['username']; $user_id = $group_moderator['user_id']; generate_user_info($group_moderator, $board_config['default_dateformat'], $is_moderator, $from, $posts, $joined, $poster_avatar, $profile_img, $profile, $search_img, $search, $pm_img, $pm, $email_img, $email, $www_img, $www, $icq_status_img, $icq_img, $icq, $msn_img, $msn, $yim_img, $yim); $s_hidden_fields .= ''; $template->assign_vars(array( 'L_GROUP_INFORMATION' => $lang['Group_Information'], 'L_GROUP_NAME' => $lang['Group_name'], 'L_GROUP_DESC' => $lang['Group_description'], 'L_GROUP_TYPE' => $lang['Group_type'], 'L_GROUP_MEMBERSHIP' => $lang['Group_membership'], 'L_SUBSCRIBE' => $lang['Join_group'], 'L_UNSUBSCRIBE' => $lang['Unsubscribe'], 'L_JOIN_GROUP' => $lang['Join_group'], 'L_UNSUBSCRIBE_GROUP' => $lang['Unsubscribe'], 'L_GROUP_OPEN' => $lang['Group_open'], 'L_GROUP_CLOSED' => $lang['Group_closed'], 'L_GROUP_HIDDEN' => $lang['Group_hidden'], 'L_UPDATE' => $lang['Update'], 'L_GROUP_MODERATOR' => $lang['Group_Moderator'], 'L_GROUP_MEMBERS' => $lang['Group_Members'], 'L_PENDING_MEMBERS' => $lang['Pending_members'], 'L_SELECT_SORT_METHOD' => $lang['Select_sort_method'], 'L_PM' => $lang['Private_Message'], 'L_EMAIL' => $lang['Email'], 'L_POSTS' => $lang['Posts'], 'L_WEBSITE' => $lang['Website'], 'L_FROM' => $lang['Location'], 'L_SORT' => $lang['Sort'], 'L_SUBMIT' => $lang['Sort'], 'L_YIM' => $lang['YIM'], 'L_MSNM' => $lang['MSNM'], 'L_ICQ' => $lang['ICQ'], 'L_SELECT' => $lang['Select'], 'L_REMOVE_SELECTED' => $lang['Remove_selected'], 'L_ADD_MEMBER' => $lang['Add_member'], 'L_FIND_USERNAME' => $lang['Find_username'], 'L_MASS_EMAIL' => $lang['GP_mail_title'], 'GROUP_NAME' => ($group_info['group_type'] == GROUP_HIDDEN && !$is_group_member && !$is_moderator) ? $lang['Group_hidden'] : $group_info['group_prefix'] . $group_info['group_name'], 'GROUP_COLOR' => (($group_info['group_type'] == GROUP_HIDDEN && !$is_group_member && !$is_moderator) || !$group_info['group_color']) ? '' : ' style="color: #' . $group_info['group_color'] . '"', 'GROUP_STYLE' => (($group_info['group_type'] == GROUP_HIDDEN && !$is_group_member && !$is_moderator) || !$group_info['group_style']) ? '' : ' style="' . $group_info['group_style'] . '"', 'GROUP_DESC' => ($group_info['group_type'] == GROUP_HIDDEN && !$is_group_member && !$is_moderator) ? '' : $group_info['group_description'], 'GROUP_DETAILS' => $group_details, 'MOD_ROW_COLOR' => '#' . $theme['td_color1'], 'MOD_ROW_CLASS' => $theme['td_class1'], 'MOD_USERNAME' => $username, 'MOD_FROM' => $from, 'MOD_JOINED' => $joined, 'MOD_POSTS' => $posts, 'MOD_AVATAR_IMG' => $poster_avatar, 'MOD_PROFILE_IMG' => $profile_img, 'MOD_PROFILE' => $profile, 'MOD_SEARCH_IMG' => $search_img, 'MOD_SEARCH' => $search, 'MOD_PM_IMG' => $pm_img, 'MOD_PM' => $pm, 'MOD_EMAIL_IMG' => $email_img, 'MOD_EMAIL' => $email, 'MOD_WWW_IMG' => $www_img, 'MOD_WWW' => $www, 'MOD_ICQ_STATUS_IMG' => $icq_status_img, 'MOD_ICQ_IMG' => $icq_img, 'MOD_ICQ' => $icq, 'MOD_MSN_IMG' => $msn_img, 'MOD_MSN' => $msn, 'MOD_YIM_IMG' => $yim_img, 'MOD_YIM' => $yim, 'U_MOD_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id"), 'U_SEARCH_USER' => append_sid("search.$phpEx?mode=searchuser"), 'S_GROUP_OPEN_TYPE' => GROUP_OPEN, 'S_GROUP_CLOSED_TYPE' => GROUP_CLOSED, 'S_GROUP_HIDDEN_TYPE' => GROUP_HIDDEN, 'S_GROUP_OPEN_CHECKED' => ( $group_info['group_type'] == GROUP_OPEN ) ? ' checked="checked"' : '', 'S_GROUP_CLOSED_CHECKED' => ( $group_info['group_type'] == GROUP_CLOSED ) ? ' checked="checked"' : '', 'S_GROUP_HIDDEN_CHECKED' => ( $group_info['group_type'] == GROUP_HIDDEN ) ? ' checked="checked"' : '', 'S_HIDDEN_FIELDS' => $s_hidden_fields, 'S_MODE_SELECT' => $select_sort_mode, 'S_ORDER_SELECT' => $select_sort_order, 'S_GROUPCP_ACTION' => append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id")) ); // // Dump out the remaining users // for($i = $start; $i < min($user_topics_per_page + $start, $members_count); $i++) { $username = $group_members[$i]['username']; $user_id = $group_members[$i]['user_id']; $member_row = $group_members[$i]; generate_user_info($member_row, $board_config['default_dateformat'], $is_moderator, $from, $posts, $joined, $poster_avatar, $profile_img, $profile, $search_img, $search, $pm_img, $pm, $email_img, $email, $www_img, $www, $icq_status_img, $icq_img, $icq, $msn_img, $msn, $yim_img, $yim); if ( $group_info['group_type'] != GROUP_HIDDEN || $is_group_member || $is_moderator ) { $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2']; $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; $template->assign_block_vars('member_row', array( 'ROW_COLOR' => '#' . $row_color, 'ROW_CLASS' => $row_class, 'USERNAME' => $username, 'FROM' => $from, 'JOINED' => $joined, 'POSTS' => $posts, 'USER_ID' => $user_id, 'AVATAR_IMG' => $poster_avatar, 'PROFILE_IMG' => $profile_img, 'PROFILE' => $profile, 'SEARCH_IMG' => $search_img, 'SEARCH' => $search, 'PM_IMG' => $pm_img, 'PM' => $pm, 'EMAIL_IMG' => $email_img, 'EMAIL' => $email, 'WWW_IMG' => $www_img, 'WWW' => $www, 'ICQ_STATUS_IMG' => $icq_status_img, 'ICQ_IMG' => $icq_img, 'ICQ' => $icq, 'MSN_IMG' => $msn_img, 'MSN' => $msn, 'YIM_IMG' => $yim_img, 'YIM' => $yim, 'U_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id")) ); if ( $is_moderator ) { $template->assign_block_vars('member_row.switch_mod_option', array()); } } } if ( !$members_count ) { // // No group members // $template->assign_block_vars('switch_no_members', array()); $template->assign_vars(array( 'L_NO_MEMBERS' => $lang['No_group_members']) ); } if ( $group_info['group_type'] == GROUP_HIDDEN && !$is_group_member && !$is_moderator ) { // // No group members // $template->assign_block_vars('switch_hidden_group', array()); $template->assign_vars(array( 'L_HIDDEN_MEMBERS' => $lang['Group_hidden_members']) ); $members_count = 0; } $current_page = ( !$members_count ) ? 1 : ceil( $members_count / $user_topics_per_page ); if ( $members_count > $user_topics_per_page ) { generate_pagination("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id", $members_count, $user_topics_per_page, $start); } // We've displayed the members who belong to the group, now we // do that pending memebers... if ( $is_moderator ) { // // Users pending in ONLY THIS GROUP (which is moderated by this user) // if ( $modgroup_pending_count ) { for($i = 0; $i < $modgroup_pending_count; $i++) { $username = $modgroup_pending_list[$i]['username']; $user_id = $modgroup_pending_list[$i]['user_id']; $modgroup_row = $modgroup_pending_list[$i]; generate_user_info($modgroup_row, $board_config['default_dateformat'], $is_moderator, $from, $posts, $joined, $poster_avatar, $profile_img, $profile, $search_img, $search, $pm_img, $pm, $email_img, $email, $www_img, $www, $icq_status_img, $icq_img, $icq, $msn_img, $msn, $yim_img, $yim); $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2']; $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; $user_select = ''; $template->assign_block_vars('pending_members_row', array( 'ROW_CLASS' => $row_class, 'ROW_COLOR' => '#' . $row_color, 'USERNAME' => $username, 'FROM' => $from, 'JOINED' => $joined, 'POSTS' => $posts, 'USER_ID' => $user_id, 'AVATAR_IMG' => $poster_avatar, 'PROFILE_IMG' => $profile_img, 'PROFILE' => $profile, 'SEARCH_IMG' => $search_img, 'SEARCH' => $search, 'PM_IMG' => $pm_img, 'PM' => $pm, 'EMAIL_IMG' => $email_img, 'EMAIL' => $email, 'WWW_IMG' => $www_img, 'WWW' => $www, 'ICQ_STATUS_IMG' => $icq_status_img, 'ICQ_IMG' => $icq_img, 'ICQ' => $icq, 'MSN_IMG' => $msn_img, 'MSN' => $msn, 'YIM_IMG' => $yim_img, 'YIM' => $yim, 'U_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id")) ); } $template->assign_block_vars('switch_pending_members', array() ); $template->assign_vars(array( 'L_SELECT' => $lang['Select'], 'L_APPROVE_SELECTED' => $lang['Approve_selected'], 'L_DENY_SELECTED' => $lang['Deny_selected']) ); $template->assign_var_from_handle('PENDING_USER_BOX', 'pendinginfo'); } } if ( $is_moderator ) { $template->assign_block_vars('switch_mod_option', array()); if ( ($group_info['group_moderator'] == $userdata['user_id'] && $group_info['group_mail_enable'] == 1) || $userdata['user_level'] == ADMIN ) { $template->assign_block_vars('switch_mod_option.switch_mass_email', array()); } $template->assign_block_vars('switch_add_member', array()); } $template->pparse('info'); } else { // // Show the main groupcp.php screen where the user can select a group. // // Select all group that the user is a member of or where the user has // a pending membership. // $in_group = array(); if ( $userdata['session_logged_in'] ) { $sql = "SELECT g.*, ug.user_pending FROM (" . GROUPS_TABLE . " g, " . USER_GROUP_TABLE . " ug) WHERE ug.user_id = " . $userdata['user_id'] . " AND ug.group_id = g.group_id AND g.group_single_user <> " . TRUE . " ORDER BY g.group_order, ug.user_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error getting group information', '', __LINE__, __FILE__, $sql); } if ( $row = $db->sql_fetchrow($result) ) { $in_group = array(); $s_member_groups_opt = array(); do { $in_group[] = $row['group_id']; $s_member_groups_opt[] = $row; } while( $row = $db->sql_fetchrow($result) ); } } // // Select all other groups i.e. groups that this user is not a member of // $ignore_group_sql = ( count($in_group) ) ? "AND group_id NOT IN (" . implode(', ', $in_group) . ")" : ''; $sql = "SELECT * FROM " . GROUPS_TABLE . " WHERE group_single_user <> " . TRUE . " $ignore_group_sql ORDER BY group_order"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error getting group information', '', __LINE__, __FILE__, $sql); } $s_group_list_opt = array(); while( $row = $db->sql_fetchrow($result) ) { $is_autogroup_enable = ($row['group_count'] <= $userdata['user_posts']) ? true : false; if ( $row['group_type'] != GROUP_HIDDEN || $userdata['user_level'] == ADMIN || $is_autogroup_enable ) { $s_group_list_opt[] = $row; } } if ( count($s_group_list_opt) || count($s_member_groups_opt) ) { // // Load and process templates // $page_title = $lang['Group_Control_Panel']; include($phpbb_root_path . 'includes/page_header.'.$phpEx); $template->set_filenames(array( 'user' => 'groupcp_user_body.tpl') ); make_jumpbox('viewforum.'.$phpEx); if ( count($s_member_groups_opt) ) { $template->assign_block_vars('switch_groups_joined', array() ); } if ( count($s_group_list_opt) ) { $template->assign_block_vars('switch_groups_remaining', array() ); } for($i = 0; $i < count($s_member_groups_opt); $i++) { $row = $s_member_groups_opt[$i]; $template->assign_block_vars('switch_groups_joined.group_member', array( 'U_GROUP' => append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=".$row['group_id']), 'GROUP_COLOR' => ($row['group_color']) ? ' style="color: #' . $row['group_color'] . '"' : '', 'GROUP_STYLE' => ($row['group_style']) ? ' style="' . $row['group_style'] . '"' : '', 'L_PENDING' => ($row['user_pending']) ? '
(' . $lang['Memberships_pending'] . ')
' : '', 'GROUP_DESC' => $row['group_description'], 'GROUP_NAME' => $row['group_prefix'] . $row['group_name']) ); } for($i = 0; $i < count($s_group_list_opt); $i++) { $row = $s_group_list_opt[$i]; $template->assign_block_vars('switch_groups_remaining.group_list', array( 'U_GROUP' => append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=".$row['group_id']), 'GROUP_COLOR' => ($row['group_color']) ? ' style="color: #' . $row['group_color'] . '"' : '', 'GROUP_STYLE' => ($row['group_style']) ? ' style="' . $row['group_style'] . '"' : '', 'GROUP_DESC' => $row['group_description'], 'GROUP_NAME' => $row['group_prefix'] . $row['group_name']) ); } $template->assign_vars(array( 'L_GROUP_MEMBERSHIP_DETAILS' => $lang['Group_member_details'], 'L_JOIN_A_GROUP' => $lang['Usergroups'], 'L_UNSUBSCRIBE' => $lang['Unsubscribe']) ); $template->pparse('user'); } else { message_die(GENERAL_MESSAGE, $lang['No_groups_exist']); } } include($phpbb_root_path . 'includes/page_tail.'.$phpEx); ?>