+$page_title = $lang['Group_Control_Panel'];

+ $sql = "INSERT INTO ".USER_GROUP_TABLE." (group_id, user_id, user_pending) values (".$HTTP_POST_VARS[POST_GROUPS_URL].", ".$userdata['user_id'].", 1)";

+ if(!$result = $db->sql_query($sql, BEGIN_TRANSACTION))

+ {

+ message_die(GENERAL_ERROR, "Error inserting user group subscription", "Error", __LINE__, __FILE__, $sql);

+ }

+

+ $sql = "SELECT u.user_email, u.username, g.group_name FROM ".USERS_TABLE . " u, " . GROUPS_TABLE . " g

+ WHERE u.user_id = g.group_moderator AND g.group_id = ".$HTTP_POST_VARS[POST_GROUPS_URL];

+ if(!$result = $db->sql_query($sql, END_TRANSACTION))

+ {

+ message_die(GENERAL_ERROR, "Error getting group moderator data", "Error", __LINE__, __FILE__, $sql);

+ }

+ $moderator = $db->sql_fetchrowset($result);

+ $email_headers = "From: " . $board_config['board_email_from'] . "\r\n";

+

+ $emailer->use_template("group_request");

+ $emailer->email_address($moderator[0]['user_email']);

+ $emailer->set_subject($lang['Group_request']);

+ $emailer->extra_headers($email_headers);

+

+ $emailer->assign_vars(array(

+ "SITENAME" => $board_config['sitename'],

+ "GROUP_MODERATOR" => $moderator[0]['username'],

+ "U_GROUPCP" => "http://".$SERVER_NAME.$PHP_SELF."?".POST_GROUPS_URL."=".$HTTP_POST_VARS[POST_GROUPS_URL],

+ "EMAIL_SIG" => $board_config['board_email'])

+ );

+ $emailer->send();

+ $emailer->reset();

+

+ message_die(GENERAL_MESSAGE, $lang["Group_joined"], $lang['Subscribe']);

+ //

+ // Handle approvals and denials

+ //

+ if(isset($HTTP_POST_VARS['approve']) || isset($HTTP_POST_VARS['deny']))

+ {

+

+ $members = $HTTP_POST_VARS['member'];

+

+ if(isset($HTTP_POST_VARS['approve']))

+ {

+ $sql = "UPDATE ".USER_GROUP_TABLE." SET user_pending = 0 WHERE ";

+ }

+ else if(isset($HTTP_POST_VARS['deny']))

+ {

+ $sql = "DELETE FROM ".USER_GROUP_TABLE." WHERE ";

+ }

+

+ for($x = 0; $x < count($members); $x++)

+ {

+ if($x > 0)

+ {

+ $sql .= " OR ";

+ }

+ $sql .= "user_id = ".$members[$x];

+ }

+

+ if(!$result = $db->sql_query($sql))

+ {

+ message_die(GENERAL_ERROR, "Could not update user group table.", "Error", __LINE__, __FILE__, $sql);

+ }

+ }

+ //

+ // END approve or deny

+ //

+ $start = ( isset($HTTP_GET_VARS['start']) ) ? $HTTP_GET_VARS['start'] : 0;

+

+ $sql = "SELECT *

+ FROM " . GROUPS_TABLE . "

+ WHERE group_id = $group_id

+ $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_aim, u.user_yim, u.user_msnm

+ 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

+ ORDER BY u.user_regdate

+ LIMIT $start, " . $board_config['topics_per_page'];

+ $group_details = $lang['Member_this_group'] . " <input type=\"submit\" name=\"unsub\" value=\"" . $lang['Unsubscribe'] . "\" .>";

+ $group_details = $lang['This_open_group'] . " <input type=\"submit\" name=\"joingroup\" value=\"" . $lang['Join_group'] . "\" />";

+ $s_hidden_fields = "<input type=\"hidden\" name=\"" . POST_GROUPS_URL . "\" value=\"$group_id\" />";

+ "L_GROUP_DESC" => $lang['Group_description'],

+ "L_SUBSCRIBE" => $lang['Subscribe'],

+ "L_UNSUBSCRIBE" => $lang['Unsubscribe'],

+

+ "S_GROUP_INFO_ACTION" => append_sid("groupcp.$phpEx"),

+ "L_SELECT_SORT_METHOD" => $lang['Select_sort_method'],

+ "L_FROM" => $lang['From'],

+ "L_ORDER" => $lang['Order'],

+ "L_SORT" => $lang['Sort'],

+ "L_SUBMIT" => $lang['Sort'],

+ "L_AIM" => $lang['AIM'],

+ "L_YIM" => $lang['YIM'],

+ "L_MSNM" => $lang['MSNM'],

+ "L_ICQ" => $lang['ICQ'],

+ "S_ORDER_SELECT" => $select_sort_order,

+

+

+ $email_img = "<a href=\"mailto:$altered_email\"><img src=\"" . $images['icon_email'] . "\" border=\"0\" alt=\"" . $lang['Send_an_email'] . "\" .></a>";

+

+ $icq_add_img = "<a href=\"http://wwp.icq.com/scripts/search.dll?to=" . $group_members[$i]['user_icq'] . "\"><img src=\"" . $images['icon_icq'] . "\" alt=\"". $lang['ICQ'] . "\" border=\"0\"></a>";

+

+ "U_MOD_VIEWPROFILE" => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $user_id),

+

+ "MOD_ROW_COLOR" => "#" . $theme['td_color1'],

+ "MOD_ROW_CLASS" => $theme['td_class1'],

+ "MOD_ICQ_STATUS_IMG" => $icq_status_img,

+ "MOD_ICQ_ADD_IMG" => $icq_add_img,

+ "MOD_AIM_IMG" => $aim_img,

+ "MOD_YIM_IMG" => $yim_img,

+ "MOD_MSN_IMG" => $msn_img,

+ $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];

+ $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

+

+ "ROW_COLOR" => "#" . $row_color,

+ "ROW_CLASS" => $row_class,

+ "ICQ_STATUS_IMG" => $icq_status_img,

+ "ICQ_ADD_IMG" => $icq_add_img,

+ "AIM_IMG" => $aim_img,

+ "YIM_IMG" => $yim_img,

+ "MSN_IMG" => $msn_img,

+ "SEARCH_IMG" => $search,

+

+ "U_VIEWPROFILE" => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $user_id))

+/*

+

+*/

+ $template->assign_block_vars("nomembers", array() );

+

+ $template->assign_vars(array(

+ "L_NO_MEMBERS" => $lang['No_group_members'])

+ );

+ }

+

+ // We've displayed the members who belong to the group, now we do that pending memebers... There's probably a better way of doing this..

+ $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_aim, u.user_yim, u.user_msnm

+ FROM " . GROUPS_TABLE . " g, " . USER_GROUP_TABLE . " ug, " . USERS_TABLE . " u

+ WHERE g.group_moderator = " . $userdata['user_id'] . "

+ AND ug.group_id = g.group_id

+ AND ug.user_pending = 1

+ AND u.user_id = ug.user_id

+ ORDER BY u.user_regdate";

+ if(!$result = $db->sql_query($sql))

+ {

+ message_die(GENERAL_ERROR, "Error getting user pending information", "", __LINE__, __FILE__, $sql);

+ }

+ if( $modgroup_pending_count = $db->sql_numrows($result) )

+ {

+ $modgroup_pending_list = $db->sql_fetchrowset($result);

+ }

+ //

+ // Users pending in groups moderated by this user

+ //

+ if($modgroup_pending_count)

+ {

+

+ $template->assign_vars(array("L_SELECT" => $lang['Select'],

+ "L_APPROVESELECTED" => $lang['Approve_selected'],

+ "L_DENYSELECTED" => $lang['Deny_selected'],

+ "S_PENDING_ACTION" => append_sid($PHP_SELF . "?" . POST_GROUPS_URL . "=" . $group_id)));

+ $template->assign_block_vars("pendingmembers", array() );

+ for($i = 0; $i < $modgroup_pending_count; $i++)

+ {

+ $username = stripslashes($modgroup_pending_list[$i]['username']);

+ $user_id = $modgroup_pending_list[$i]['user_id'];

+

+ $from = stripslashes($modgroup_pending_list[$i]['user_from']);

+

+ $joined = create_date($board_config['default_dateformat'], $modgroup_pending_list[$i]['user_regdate'], $board_config['default_timezone']);

+

+ $posts = ($modgroup_pending_list[$i]['user_posts']) ? $modgroup_pending_list[$i]['user_posts'] : 0;

+

+ if( !empty($modgroup_pending_list[$i]['user_viewemail']) )

+ {

+ $altered_email = str_replace("@", " at ", $modgroup_pending_list[$i]['user_email']);

+ $email_img = "<a href=\"mailto:$altered_email\"><img src=\"" . $images['icon_email'] . "\" border=\"0\" alt=\"" . $lang['Send_an_email'] . "\"></a>";

+ }

+ else

+ {

+ $email_img = "&nbsp;";

+ }

+

+ $pm_img = "<a href=\"" . append_sid("privmsg.$phpEx?mode=post&" . POST_USERS_URL . "=" . $modgroup_pending_list[$i]['user_id']) . "\"><img src=\"" . $images['icon_pm'] . "\" border=\"0\" alt=\"" . $lang['Send_private_message'] . "\"></a>";

+

+ if($modgroup_pending_list[$i]['user_website'] != "")

+ {

+ $www_img = "<a href=\"" . stripslashes($modgroup_pending_list[$i]['user_website']) . "\" target=\"_userwww\"><img src=\"" . $images['icon_www'] . "\" border=\"0\"/></a>";

+ }

+ else

+ {

+ $www_img = "&nbsp;";

+ }

+

+ if($modgroup_pending_list[$i]['user_icq'])

+ {

+ $icq_status_img = "<a href=\"http://wwp.icq.com/" . $modgroup_pending_list[$i]['user_icq'] . "#pager\"><img src=\"http://online.mirabilis.com/scripts/online.dll?icq=" . $modgroup_pending_list[$i]['user_icq'] . "&img=5\" border=\"0\"></a>";

+

+ $icq_add_img = "<a href=\"http://wwp.icq.com/scripts/search.dll?to=" . $modgroup_pending_list[$i]['user_icq'] . "\"><img src=\"" . $images['icon_icq'] . "\" alt=\"". $lang['ICQ'] . "\" border=\"0\"></a>";

+ }

+ else

+ {

+ $icq_status_img = "&nbsp;";

+ $icq_add_img = "&nbsp;";

+ }

+

+ $aim_img = ($modgroup_pending_list[$i]['user_aim']) ? "<a href=\"aim:goim?screenname=" . $modgroup_pending_list[$i]['user_aim'] . "&message=Hello+Are+you+there?\"><img src=\"" . $images['icon_aim'] . "\" border=\"0\"></a>" : "&nbsp;";

+

+ $msn_img = ($modgroup_pending_list[$i]['user_msnm']) ? "<a href=\"profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id\"><img src=\"" . $images['icon_msnm'] . "\" border=\"0\"></a>" : "&nbsp;";

+

+ $yim_img = ($modgroup_pending_list[$i]['user_yim']) ? "<a href=\"http://edit.yahoo.com/config/send_webmesg?.target=" . $modgroup_pending_list[$i]['user_yim'] . "&.src=pg\"><img src=\"" . $images['icon_yim'] . "\" border=\"0\"></a>" : "&nbsp;";

+

+ $search_img = "<a href=\"" . append_sid("search.$phpEx?a=" . urlencode($modgroup_pending_list[$i]['username']) . "&f=all&b=0&d=DESC&c=100&dosearch=1") . "\"><img src=\"" . $images['icon_search'] . "\" border=\"0\"></a>";

+

+ $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];

+ $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

+

+ $user_select = '<input type="checkbox" name="member[]" value="'.$user_id.'">';

+

+ $template->assign_block_vars("pendingmembersrow", array(

+ "U_VIEWPROFILE" => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $user_id),

+

+ "ROW_CLASS" => $row_class,

+ "USERNAME" => $username,

+ "FROM" => $from,

+ "JOINED" => $joined,

+ "POSTS" => $posts,

+

+ "EMAIL_IMG" => $email_img,

+ "PM_IMG" => $pm_img,

+ "WWW_IMG" => $www_img,

+ "ICQ_STATUS_IMG" => $icq_status_img,

+ "ICQ_ADD_IMG" => $icq_add_img,

+ "AIM_IMG" => $aim_img,

+ "YIM_IMG" => $yim_img,

+ "MSN_IMG" => $msn_img,

+ "SELECT" => $user_select,

+ "SEARCH_IMG" => $search)

+ );

+ }

+

+ //

+ // Parse group info output

+ //

+ $template->pparse("info");

+

+else

+ $sql = "SELECT group_id, group_name

+ FROM " . GROUPS_TABLE . "

+ WHERE group_single_user <> " . TRUE . "

+ $sql = "SELECT g.group_id, g.group_name, ug.user_pending

+ FROM " . GROUPS_TABLE . " g, " . USER_GROUP_TABLE . " ug

+ AND g.group_id = ug.group_id

+ AND g.group_single_user <> " . TRUE . "

+ if($s_pending_groups_opt != "" || $s_member_groups_opt != "")

+ {

+ $template->assign_block_vars("group_joined", array() );

+ }

+

+ else

+ {

+ $template->assign_block_vars("group_joined.group_member", array() );

+ }

+

+ else

+ {

+ $template->assign_block_vars("group_joined.group_pending", array() );

+ }

+

+ else

+ {

+ $template->assign_block_vars("group_subscribe", array() );

+ }

+ "L_YOU_BELONG_GROUPS" => $lang['Current_memberships'],

+ "L_SELECT_A_GROUP" => $lang['Non_member_groups'],

+ "L_PENDING_GROUPS" => $lang['Memberships_pending'],

+ "L_SUBSCRIBE" => $lang['Subscribe'],

+ "L_UNSUBSCRIBE" => $lang['Unsubscribe'],

+ "L_VIEW_INFORMATION" => $lang['View_Information'],

+

+?>