[SOLVED] ACP>Group Admin>Mange Error

Support for IntegraMOD 140

Moderator: Integra Moderator

[SOLVED] ACP>Group Admin>Mange Error

PostAuthor: Bush » Fri Apr 28, 2006 3:45 pm

I was looking into this, but as i tried to fix it i did more harm than good. The original and still standing error is this:

Parse error: parse error, unexpected T_ELSE in /home/mofclan/public_html/portal/admin/admin_groups.php on line 313

Here is my admin_groups.php
Code: Select all
<php>set_filenames(array(         'body' => 'admin/group_edit_body.tpl')     );  //-- mod : Loewen Enterprise - PAYPAL IPN REG / SUBSCRIPTION - GROUP -----------------------------------------------------------             //-- remove//   if ( isset($HTTP_POST_VARS['edit']) )//-- add     if ( isset($HTTP_POST_VARS['edit']) || isset($HTTP_GET_VARS['edit']))//-- fin mod : Loewen Enterprise - PAYPAL IPN REG / SUBSCRIPTION - GROUP -----------------------------------------------------------                   {         //         // They're editing. Grab the vars.         //         $sql = "SELECT *             FROM " . GROUPS_TABLE . "             WHERE group_single_user <TRUE>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']);         }           $mode = 'editgroup';         $template->assign_block_vars('group_edit', array());       }     else if ( isset($HTTP_POST_VARS['new']) )     {         $group_info = array (             'group_name' => '',             'group_description' => '',             'group_moderator' => '',             'group_count' => '99999999',             'group_count_max' => '99999999',             'group_count_enable' => '0',             'group_type' => GROUP_OPEN);         $group_open = ' checked="checked"';           $mode = 'newgroup';       }       //     // Ok, now we know everything about them, let's show the page.     //     if ($group_info['group_moderator'] != '')     {         $sql = "SELECT user_id, username             FROM " . USERS_TABLE . "             WHERE user_id = " . $group_info['group_moderator'];         if ( !($result = $db->sql_query($sql)) )         {             message_die(GENERAL_ERROR, 'Could not obtain user info for moderator list', '', __LINE__, __FILE__, $sql);         }           if ( !($row = $db->sql_fetchrow($result)) )         {             message_die(GENERAL_ERROR, 'Could not obtain user info for moderator list', '', __LINE__, __FILE__, $sql);         }           $group_moderator = $row['username'];     }     else     {         $group_moderator = '';       $group_open = ( $group_info['group_type'] == GROUP_OPEN ) ? ' checked="checked"' : '';     $group_closed = ( $group_info['group_type'] == GROUP_CLOSED ) ? ' checked="checked"' : '';     $group_hidden = ( $group_info['group_type'] == GROUP_HIDDEN ) ? ' checked="checked"' : '';     $group_payment = ( $group_info['group_type'] == GROUP_PAYMENT ) ? ' checked="checked"' : '';     $group_period = intval($group_info['group_period']);     $group_period_basis = $group_info['group_period_basis'];     $group_first_trial_fee = ($group_info['group_first_trial_fee'] + 0.00);     $group_first_trial_period = intval($group_info['group_first_trial_period']);     $group_first_trial_period_basis = ($group_info['group_first_trial_period_basis']);     $group_second_trial_fee = ($group_info['group_second_trial_fee'] + 0.00);     $group_second_trial_period = intval($group_info['group_second_trial_period']);     $group_second_trial_period_basis = ($group_info['group_second_trial_period_basis']);     $group_sub_recurring = intval($group_info['group_sub_recurring']);     $group_sub_recurring_stop = intval($group_info['group_sub_recurring_stop']);     $group_sub_recurring_stop_num = intval($group_info['group_sub_recurring_stop_num']);     $group_sub_reattempt = intval($group_info['group_sub_reattempt']);       $grp_billing_circle = '<SELECT><OPTION>--</OPTION>';     for($i = 1; $i <= 30; $i++ )     {         if($group_period == $i)         {             $grp_billing_circle .= '<OPTION>' . $i . '</OPTION>';         }         else         {             $grp_billing_circle .= '<OPTION>' . $i . '</OPTION>';         }     }     $grp_billing_circle .= '</SELECT>';       $grp_period_basis = '<select>';     $grp_period_basis .= '<option>-select one-</option>';     $grp_period_basis .= '<option>Day(s)</option>';     $grp_period_basis .= '<option>Week(s)</option>';     $grp_period_basis .= '<option>Month(s)</option>';     $grp_period_basis .= '<option>Year(s)</option>';     $grp_period_basis .= '</select>';         $grp_recur_stop_num = '<SELECT><OPTION>--</OPTION>';     for($i = 2; $i <= 30; $i++ )     {         if($group_sub_recurring_stop_num == $i)         {             $grp_recur_stop_num .= '<OPTION>' . $i . '</OPTION>';         }         else         {             $grp_recur_stop_num .= '<OPTION>' . $i . '</OPTION>';         }     }     $grp_recur_stop_num .= '</SELECT>';         $grp_first_trial_period = '<SELECT><OPTION>--</OPTION>';     for($i = 1; $i <= 30; $i++ )     {         if($group_first_trial_period == $i)         {             $grp_first_trial_period .= '<OPTION>' . $i . '</OPTION>';         }         else         {             $grp_first_trial_period .= '<OPTION>' . $i . '</OPTION>';         }     }     $grp_first_trial_period .= '</SELECT>';         $grp_first_trial_period_basis = '<select>';     $grp_first_trial_period_basis .= '<option>-select one-</option>';     $grp_first_trial_period_basis .= '<option>Day(s)</option>';     $grp_first_trial_period_basis .= '<option>Week(s)</option>';     $grp_first_trial_period_basis .= '<option>Month(s)</option>';     $grp_first_trial_period_basis .= '<option>Year(s)</option>';     $grp_first_trial_period_basis .= '</select>';         $grp_second_trial_period = '<SELECT><OPTION>--</OPTION>';     for($i = 1; $i </OPTION>assign_vars(array(         'GROUP_NAME' => $group_info['group_name'],         'GROUP_DESCRIPTION' => $group_info['group_description'],         'GROUP_MODERATOR' => $group_moderator,         'GROUP_COUNT' => $group_info['group_count'],         'GROUP_COUNT_MAX' => $group_info['group_count_max'],         'GROUP_COUNT_ENABLE_CHECKED' => $group_count_enable_checked,                 'L_GROUP_COUNT' => $lang['group_count'],         'L_GROUP_COUNT_MAX' => $lang['group_count_max'],         'L_GROUP_COUNT_EXPLAIN' => $lang['group_count_explain'],         'L_GROUP_COUNT_ENABLE' => $lang['Group_count_enable'],         'L_GROUP_COUNT_UPDATE' => $lang['Group_count_update'],         'L_GROUP_COUNT_DELETE' => $lang['Group_count_delete'],           'L_GROUP_TITLE' => $lang['Group_administration'],         'L_GROUP_EDIT_DELETE' => ( isset($HTTP_POST_VARS['new']) ) ? $lang['New_group'] : $lang['Edit_group'],         'L_GROUP_NAME' => $lang['group_name'],         'L_GROUP_DESCRIPTION' => $lang['group_description'],         'L_GROUP_MODERATOR' => $lang['group_moderator'],         'L_FIND_USERNAME' => $lang['Find_username'],         'L_GROUP_STATUS' => $lang['group_status'],         'L_GROUP_OPEN' => $lang['group_open'],         'L_GROUP_CLOSED' => $lang['group_closed'],         'L_GROUP_HIDDEN' => $lang['group_hidden'],         'L_GROUP_DELETE' => $lang['group_delete'],         'L_GROUP_PAYMENT' => $lang['group_payment'],         'L_GROUP_PAYMENTS_LW' => sprintf($lang['L_GROUP_PAYMENTS_LW'], $board_config['paypal_currency_code']),         'L_GROUP_DELETE_CHECK' => $lang['group_delete_check'],         'L_SUBMIT' => $lang['Submit'],         'L_RESET' => $lang['Reset'],         'L_DELETE_MODERATOR' => $lang['delete_group_moderator'],         'L_DELETE_MODERATOR_EXPLAIN' => $lang['delete_moderator_explain'],         'L_YES' => $lang['Yes'],           'U_SEARCH_USER' => append_sid("../search.$phpEx?mode=searchuser"),           'S_GROUP_OPEN_TYPE' => GROUP_OPEN,         'L_GROUP_AUTO' => $lang['group_auto'],         'S_GROUP_AUTO_TYPE' => GROUP_AUTO,         'S_GROUP_AUTO_CHECKED' => $group_auto,         'S_GROUP_CLOSED_TYPE' => GROUP_CLOSED,         'S_GROUP_HIDDEN_TYPE' => GROUP_HIDDEN,         'S_GROUP_PAYMENT_TYPE' => GROUP_PAYMENT,         'S_GROUP_OPEN_CHECKED' => $group_open,         'S_GROUP_CLOSED_CHECKED' => $group_closed,         'S_GROUP_HIDDEN_CHECKED' => $group_hidden,         'S_GROUP_PAYMENT_CHECKED' => $group_payment,         'GROUP_AMOUNT_LW' => $group_info['group_amount'],         'LW_SUB_RECUR' => '<input>Yes  <input>No',         'LW_BILLING_CIRCLE_PERIOD' => $grp_billing_circle,         'LW_BILLING_PERIOD_BASIS' => $grp_period_basis,         'LW_STOP_RECURRING' => '<input>Yes  <input>No',         'LW_STOP_RECURRING_NUM' => $grp_recur_stop_num,         'LW_SUBCRIBE_REATTEMPT' => '<input>Yes  <input>No',         'GROUP_TRIAL_PERIOD_ONE_FEE_LW' => $group_first_trial_fee,         'LW_FIRST_TRIAL_PERIOD' => $grp_first_trial_period,         'LW_FIRST_TRIAL_PERIOD_BASIS' => $grp_first_trial_period_basis,         'GROUP_TRIAL_PERIOD_TWO_FEE_LW' => $group_second_trial_fee,         'LW_SECOND_TRIAL_PERIOD' => $grp_second_trial_period,         'LW_SECOND_TRIAL_PERIOD_BASIS' => $grp_second_trial_period_basis,         'S_GROUP_ACTION' => append_sid("admin_groups.$phpEx"),         'S_HIDDEN_FIELDS' => $s_hidden_fields)     );       $template->pparse('body');  }else if ( isset($HTTP_POST_VARS['group_update']) ){     //     // Ok, they are submitting a group, let's save the data based on if it's new or editing     //     if ( isset($HTTP_POST_VARS['group_delete']) )     {         //         // Reset User Moderator Level         //           // Is Group moderating a forum ?         $sql = "SELECT auth_mod FROM " . AUTH_ACCESS_TABLE . "             WHERE group_id = " . $group_id;         if ( !($result = $db->sql_query($sql)) )         {             message_die(GENERAL_ERROR, 'Could not select auth_access', '', __LINE__, __FILE__, $sql);         }           $row = $db->sql_fetchrow($result);         if (intval($row['auth_mod']) == 1)         {             // Yes, get the assigned users and update their Permission if they are no longer moderator of one of the forums             $sql = "SELECT user_id FROM " . USER_GROUP_TABLE . "                 WHERE group_id = " . $group_id;             if ( !($result = $db->sql_query($sql)) )             {                 message_die(GENERAL_ERROR, 'Could not select user_group', '', __LINE__, __FILE__, $sql);             }               $rows = $db->sql_fetchrowset($result);             for ($i = 0; $i <count>sql_query($sql)) )                 {                     message_die(GENERAL_ERROR, 'Could not obtain moderator permissions', '', __LINE__, __FILE__, $sql);                 }                   if ($db->sql_numrows($result) == 0)                 {                     $sql = "UPDATE " . USERS_TABLE . " SET user_level = " . USER . "                     WHERE user_level = " . MOD . " AND user_id = " . intval($rows[$i]['user_id']);                                         if ( !$db->sql_query($sql) )                     {                         message_die(GENERAL_ERROR, 'Could not update moderator permissions', '', __LINE__, __FILE__, $sql);                     }                 }             }         }           //         // Delete Group         //         $sql = "DELETE FROM " . GROUPS_TABLE . "             WHERE group_id = " . $group_id;         if ( !$db->sql_query($sql) )         {             message_die(GENERAL_ERROR, 'Could not update group', '', __LINE__, __FILE__, $sql);         }           $sql = "DELETE FROM " . USER_GROUP_TABLE . "             WHERE group_id = " . $group_id;         if ( !$db->sql_query($sql) )         {             message_die(GENERAL_ERROR, 'Could not update user_group', '', __LINE__, __FILE__, $sql);         }           $sql = "DELETE FROM " . AUTH_ACCESS_TABLE . "             WHERE group_id = " . $group_id;         if ( !$db->sql_query($sql) )         {             message_die(GENERAL_ERROR, 'Could not update auth_access', '', __LINE__, __FILE__, $sql);         }           $message = $lang['Deleted_group'] . '<br><br>' . sprintf($lang['Click_return_groupsadmin'], '<a>', '</a>') . '<br><br>' . sprintf($lang['Click_return_admin_index'], '<a>', '</a>');           message_die(GENERAL_MESSAGE, $message);     }     else     {         $group_type = isset($HTTP_POST_VARS['group_type']) ? intval($HTTP_POST_VARS['group_type']) : GROUP_OPEN;         $group_name = isset($HTTP_POST_VARS['group_name']) ? htmlspecialchars(trim($HTTP_POST_VARS['group_name'])) : '';         $group_description = isset($HTTP_POST_VARS['group_description']) ? trim($HTTP_POST_VARS['group_description']) : '';         $group_moderator = isset($HTTP_POST_VARS['username']) ? $HTTP_POST_VARS['username'] : '';         $delete_old_moderator = isset($HTTP_POST_VARS['delete_old_moderator']) ? true : false;         $group_amount = isset($HTTP_POST_VARS['group_amount']) ? ($HTTP_POST_VARS['group_amount'] + 0.00) : 0;         $group_period = isset($HTTP_POST_VARS['group_period']) ? intval($HTTP_POST_VARS['group_period']) : 0;         $group_period_basis = isset($HTTP_POST_VARS['group_period_basis']) ? htmlspecialchars($HTTP_POST_VARS['group_period_basis']) : '0';         $group_first_trial_fee = isset($HTTP_POST_VARS['group_first_trial_fee']) ? ($HTTP_POST_VARS['group_first_trial_fee'] + 0.00) : 0;         $group_first_trial_period = isset($HTTP_POST_VARS['group_first_trial_period']) ? intval($HTTP_POST_VARS['group_first_trial_period']) : 0;         $group_first_trial_period_basis = isset($HTTP_POST_VARS['group_first_trial_period_basis']) ? htmlspecialchars($HTTP_POST_VARS['group_first_trial_period_basis']) : '0';         $group_second_trial_fee = isset($HTTP_POST_VARS['group_second_trial_fee']) ? ($HTTP_POST_VARS['group_second_trial_fee'] + 0.00) : 0;         $group_second_trial_period = isset($HTTP_POST_VARS['group_second_trial_period']) ? intval($HTTP_POST_VARS['group_second_trial_period']) : 0;         $group_second_trial_period_basis = isset($HTTP_POST_VARS['group_second_trial_period_basis']) ? htmlspecialchars($HTTP_POST_VARS['group_second_trial_period_basis']) : '0';         $group_sub_recurring = isset($HTTP_POST_VARS['group_sub_recurring']) ? intval($HTTP_POST_VARS['group_sub_recurring']) : 1;         $group_sub_recurring_stop = isset($HTTP_POST_VARS['group_sub_recurring_stop']) ? intval($HTTP_POST_VARS['group_sub_recurring_stop']) : 0;         $group_sub_recurring_stop_num = isset($HTTP_POST_VARS['group_sub_recurring_stop_num']) ? intval($HTTP_POST_VARS['group_sub_recurring_stop_num']) : 0;         $group_sub_reattempt = isset($HTTP_POST_VARS['group_sub_reattempt']) ? intval($HTTP_POST_VARS['group_sub_reattempt']) : 1;  $group_count = isset($HTTP_POST_VARS['group_count']) ? intval($HTTP_POST_VARS['group_count']) : 0;$group_count_max = isset($HTTP_POST_VARS['group_count_max']) ? intval($HTTP_POST_VARS['group_count_max']) : 0;$group_count_enable = isset($HTTP_POST_VARS['group_count_enable']) ? true : false;$group_count_update = isset($HTTP_POST_VARS['group_count_update']) ? true : false;$group_count_delete = isset($HTTP_POST_VARS['group_count_delete']) ? true : false;           if ( $group_name == '' )         {             message_die(GENERAL_MESSAGE, $lang['No_group_name']);         }         else if ( $group_moderator == '' )         {             message_die(GENERAL_MESSAGE, $lang['No_group_moderator']);         }                 $this_userdata = get_userdata($group_moderator, true);         $group_moderator = $this_userdata['user_id'];           if ( !$group_moderator )         {             message_die(GENERAL_MESSAGE, $lang['No_group_moderator']);         }                         if( $mode == "editgroup" )         {             $sql = "SELECT *                 FROM " . GROUPS_TABLE . "                 WHERE group_single_user <TRUE>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']);             }                     if ( $group_info['group_moderator'] != $group_moderator )             {                 if ( $delete_old_moderator )                 {                     $sql = "DELETE FROM " . USER_GROUP_TABLE . "                         WHERE user_id = " . $group_info['group_moderator'] . "                             AND group_id = " . $group_id;                     if ( !$db->sql_query($sql) )                     {                         message_die(GENERAL_ERROR, 'Could not update group moderator', '', __LINE__, __FILE__, $sql);                     }                 }                   $sql = "SELECT user_id                     FROM " . USER_GROUP_TABLE . "                     WHERE user_id = $group_moderator                         AND group_id = $group_id";                 if ( !($result = $db->sql_query($sql)) )                 {                     message_die(GENERAL_ERROR, 'Failed to obtain current group moderator info', '', __LINE__, __FILE__, $sql);                 }                   if ( !($row = $db->sql_fetchrow($result)) )                 {                     $sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending)                         VALUES (" . $group_id . ", " . $group_moderator . ", 0)";                     if ( !$db->sql_query($sql) )                     {                         message_die(GENERAL_ERROR, 'Could not update group moderator', '', __LINE__, __FILE__, $sql);                     }                 }             }//               group_period = $group_period, //               group_period_basis = '$group_period_basis', //               group_first_trial_fee = $group_first_trial_fee,  //               group_first_trial_period = $group_first_trial_period, //               group_first_trial_period_basis = '$group_first_trial_period_basis', //               group_second_trial_fee = $group_second_trial_fee, //               group_second_trial_period = $group_second_trial_period, //               group_second_trial_period_basis = '$group_second_trial_period_basis', //               group_sub_recurring = $group_sub_recurring, //               group_sub_recurring_stop = $group_sub_recurring_stop, //               group_sub_recurring_stop_num = $group_sub_recurring_stop_num, //               group_sub_reattempt = $group_sub_reattempt             $sql = "UPDATE " . GROUPS_TABLE . "                 SET group_type = $group_type, group_name = '" . str_replace("'", "''", $group_name) . "', group_description = '" . str_replace("'", "''", $group_description) . "', group_moderator = $group_moderator, group_amount = $group_amount,                   group_period = $group_period,                 group_period_basis = '$group_period_basis',                 group_first_trial_fee = $group_first_trial_fee,                   group_first_trial_period = $group_first_trial_period,                 group_first_trial_period_basis = '$group_first_trial_period_basis',                 group_second_trial_fee = $group_second_trial_fee,                 group_second_trial_period = $group_second_trial_period,                 group_second_trial_period_basis = '$group_second_trial_period_basis',                 group_sub_recurring = $group_sub_recurring,                 group_sub_recurring_stop = $group_sub_recurring_stop,                 group_sub_recurring_stop_num = $group_sub_recurring_stop_num,                 group_sub_reattempt = $group_sub_reattempt, group_count='$group_count', group_count_max='$group_count_max', group_count_enable='$group_count_enable'                   WHERE group_id = $group_id";             if ( !$db->sql_query($sql) )             {                 message_die(GENERAL_ERROR, 'Could not update group', '', __LINE__, __FILE__, $sql);             }if ($group_count_delete)             {                 //removing old users                 $sql = "DELETE FROM " . USER_GROUP_TABLE . "                     WHERE group_id=$group_id                     AND user_id NOT IN ('$group_moderator','".ANONYMOUS."')";                 if ( !$db->sql_query($sql) )                 {                     message_die(GENERAL_ERROR, 'Could not remove users, group count', '', __LINE__, __FILE__, $sql);                 }                 $group_count_remove=$db->sql_affectedrows();             }             if ( $group_count_update)             {                 //finding new users                 $sql = "SELECT u.user_id FROM " . USERS_TABLE . " u                     LEFT JOIN " . USER_GROUP_TABLE ." ug ON u.user_id=ug.user_id AND ug.group_id='$group_id'                     WHERE u.user_posts>='$group_count' AND u.user_posts<'$group_count_max'                     AND ug.group_id is NULL                     AND u.user_id NOT IN ('$group_moderator','".ANONYMOUS."')";                 if ( !($result = $db->sql_query($sql)) )                 {                     message_die(GENERAL_ERROR, $sql.'Could not select new users, group count', '', __LINE__, __FILE__, $sql);                 }                 //inserting new users                 $group_count_added=0;                 while ( ($new_members = $db->sql_fetchrow($result)) )                 {                     $sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending)                         VALUES ($group_id, " . $new_members['user_id'] . ", 0)";                     if ( !($result2 = $db->sql_query($sql)) )                     {                         message_die(GENERAL_ERROR, 'Error inserting user group, group count', '', __LINE__, __FILE__, $sql);                     }                     $group_count_added++;                 }             }             $message = $lang['Updated_group'] .'<br>'.sprintf($lang['group_count_updated'],$group_count_remove,$group_count_added). '<br><br>' . sprintf($lang['Click_return_groupsadmin'], '<a>', '</a>') . '<br><br>' . sprintf($lang['Click_return_admin_index'], '<a>', '</a>');;               message_die(GENERAL_MESSAGE, $message);         }         else if( $mode == 'newgroup' )         {             $sql = "INSERT INTO " . GROUPS_TABLE . " (group_type, group_name, group_description, group_moderator, group_count,group_count_max,group_count_enable, group_single_user, group_amount, group_period, group_period_basis, group_first_trial_fee, group_first_trial_period, group_first_trial_period_basis, group_second_trial_fee, group_second_trial_period, group_second_trial_period_basis, group_sub_recurring, group_sub_recurring_stop, group_sub_recurring_stop_num, group_sub_reattempt)                 VALUES ($group_type, '" . str_replace("'", "''", $group_name) . "', '" . str_replace("'", "''", $group_description) . "', $group_moderator, '$group_count','$group_count_max','$group_count_enable',   '0', $group_amount, $group_period, '$group_period_basis', $group_first_trial_fee, $group_first_trial_period, '$group_first_trial_period_basis', $group_second_trial_fee, $group_second_trial_period, '$group_second_trial_period_basis', $group_sub_recurring, $group_sub_recurring_stop, $group_sub_recurring_stop_num, $group_sub_reattempt)";             if ( !$db->sql_query($sql) )             {                 message_die(GENERAL_ERROR, 'Could not insert new group', '', __LINE__, __FILE__, $sql);             }             $new_group_id = $db->sql_nextid();               $sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending)                 VALUES ($new_group_id, $group_moderator, 0)";             if ( !$db->sql_query($sql) )             {                 message_die(GENERAL_ERROR, 'Could not insert new user-group info', '', __LINE__, __FILE__, $sql);             }         if ($group_count_delete)             {                 //removing old users                 $sql = "DELETE FROM " . USER_GROUP_TABLE . "                     WHERE group_id=$new_group_id                     AND user_id NOT IN ('$group_moderator','".ANONYMOUS."')";                 if ( !$db->sql_query($sql) )                 {                     message_die(GENERAL_ERROR, 'Could not remove users, group count', '', __LINE__, __FILE__, $sql);                 }                 $group_count_remove=$db->sql_affectedrows();             }             if ( $group_count_update)             {                 //finding new users                 $sql = "SELECT u.user_id FROM " . USERS_TABLE . " u                     LEFT JOIN " . USER_GROUP_TABLE ." ug ON u.user_id=ug.user_id AND ug.group_id='$new_group_id'                     WHERE u.user_posts>='$group_count' AND u.user_posts<'$group_count_max'                     AND ug.group_id is NULL                     AND u.user_id NOT IN ('$group_moderator','".ANONYMOUS."')";                 if ( !($result = $db->sql_query($sql)) )                 {                     message_die(GENERAL_ERROR, $sql.'Could not select new users, group count', '', __LINE__, __FILE__, $sql);                 }                 //inserting new users                 $group_count_added=0;                 while ( ($new_members = $db->sql_fetchrow($result)) )                 {                     $sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending)                         VALUES ($new_group_id, " . $new_members['user_id'] . ", 0)";                     if ( !($result2 = $db->sql_query($sql)) )                     {                         message_die(GENERAL_ERROR, 'Error inserting user group, group count', '', __LINE__, __FILE__, $sql);                     }                     $group_count_added++;                 }             }                       $message = $lang['Added_new_group'] .'<br>'.sprintf($lang['group_count_updated'],$group_count_remove,$group_count_added). '<br><br>' . sprintf($lang['Click_return_groupsadmin'], '<a>', '</a>') . '<br><br>' . sprintf($lang['Click_return_admin_index'], '<a>', '</a>');;               message_die(GENERAL_MESSAGE, $message);           }         else         {             message_die(GENERAL_MESSAGE, $lang['No_group_action']);         }     }}else{     $sql = "SELECT group_id, group_name         FROM " . GROUPS_TABLE . "         WHERE group_single_user <TRUE>sql_query($sql)) )     {         message_die(GENERAL_ERROR, 'Could not obtain group list', '', __LINE__, __FILE__, $sql);     }       $select_list = '';     if ( $row = $db->sql_fetchrow($result) )     {         $select_list .= '<select>';         do         {             $select_list .= '<option>' . $row['group_name'] . '</option>';         }         while ( $row = $db->sql_fetchrow($result) );         $select_list .= '</select>';     }       $template->set_filenames(array(         'body' => 'admin/group_select_body.tpl')     );       $template->assign_vars(array(         'L_GROUP_TITLE' => $lang['Group_administration'],         'L_GROUP_EXPLAIN' => $lang['Group_admin_explain'],         'L_GROUP_SELECT' => $lang['Select_group'],         'L_LOOK_UP' => $lang['Look_up_group'],         'L_CREATE_NEW_GROUP' => $lang['New_group'],           'S_GROUP_ACTION' => append_sid("admin_groups.$phpEx"),         'S_GROUP_SELECT' => $select_list)     );       if ( $select_list != '' )     {         $template->assign_block_vars('select_box', array());     }       $template->pparse('body');}  include('./page_footer_admin.'.$phpEx);  ?>  


Here is a highlight of line 313:
Code: Select all
else if ( isset($HTTP_POST_VARS['group_update']) )
Last edited by Bush on Fri Apr 28, 2006 8:09 pm, edited 1 time in total.
no signature.

Bush
Integra Member
Integra Member
 
Posts: 191
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 28, 2006 8:55 am
Cash on hand: 0.00

PostAuthor: Bush » Fri Apr 28, 2006 3:51 pm

I can't be to sure, but there was some code changes in phpBB 2.0.19 > 2.0.20, they are the following:

Code: Select all
admin/admin_groups.php  ##-----[ FIND ]---------------------------------------------# Line 123     $sql = "SELECT user_id, username         FROM " . USERS_TABLE . "         WHERE user_id <ANONYMOUS>sql_query($sql)) )     {         message_die(GENERAL_ERROR, 'Could not obtain user info for moderator list', '', __LINE__, __FILE__, $sql);     }       while ( $row = $db->sql_fetchrow($result) )     {         if ( $row['user_id'] == $group_info['group_moderator'] )         {             $group_moderator = $row['username'];         }  ##-----[ REPLACE WITH ]---------------------------------------------#     if ($group_info['group_moderator'] != '')     {         $sql = "SELECT user_id, username             FROM " . USERS_TABLE . "             WHERE user_id = " . $group_info['group_moderator'];         if ( !($result = $db->sql_query($sql)) )         {             message_die(GENERAL_ERROR, 'Could not obtain user info for moderator list', '', __LINE__, __FILE__, $sql);         }           if ( !($row = $db->sql_fetchrow($result)) )         {             message_die(GENERAL_ERROR, 'Could not obtain user info for moderator list', '', __LINE__, __FILE__, $sql);         }           $group_moderator = $row['username'];     }     else     {         $group_moderator = '';  ##-----[ FIND ]---------------------------------------------# Line 399         $group_name = isset($HTTP_POST_VARS['group_name']) ? trim($HTTP_POST_VARS['group_name']) ]---------------------------------------------#         $group_name = isset($HTTP_POST_VARS['group_name']) ? htmlspecialchars(trim($HTTP_POST_VARS['group_name'])) : '';  


These code changes are in and around the error'd line.

I know that the manage group function worked back on 2.0.18 when I first setup groups, can anyone confirm or deny that their IntegraMOD is having problems with managing groups since the update to 2.0.20?
Last edited by Bush on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
no signature.

Bush
Integra Member
Integra Member
 
Posts: 191
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 28, 2006 8:55 am
Cash on hand: 0.00

PostAuthor: tmotley » Fri Apr 28, 2006 8:04 pm

I have no problems with managing a group with my totally updated site. Would replacing yours with admin_groups.php from fresh download work you think?
Last edited by tmotley on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
User avatar
tmotley
IntegraMODerators
IntegraMODerators
 
Posts: 524
Likes: 0 post
Liked in: 0 post
Joined: Mon Mar 27, 2006 3:56 am
Cash on hand: 0.00
Location: Missouri, USA

PostAuthor: Bush » Fri Apr 28, 2006 8:05 pm

It could, but i'm not sure if any of my mods (very minor mods, changing pm notification, etc) would be effected. its worth a shot and good suggestion!
Last edited by Bush on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
no signature.

Bush
Integra Member
Integra Member
 
Posts: 191
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 28, 2006 8:55 am
Cash on hand: 0.00

PostAuthor: Bush » Fri Apr 28, 2006 8:11 pm

Works now, but line 313 is the same, i'm gonna grep the files later to see what was the difference.
Last edited by Bush on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
no signature.

Bush
Integra Member
Integra Member
 
Posts: 191
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 28, 2006 8:55 am
Cash on hand: 0.00

PostAuthor: Bush » Fri Apr 28, 2006 8:13 pm

actually something at line 123 was breaking it. I compared both files. oh well, this is why i am not enjoying trying to learn php & sql :/
Last edited by Bush on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
no signature.

Bush
Integra Member
Integra Member
 
Posts: 191
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 28, 2006 8:55 am
Cash on hand: 0.00


Return to IntegraMOD 140

Who is online

Registered users: App360MonitorBot, Bing [Bot], Helter