MODS.DB9.DK

[pzsniper]

I've checked many tiems code placement, and updated the mod to 1.1.2 verison but since first installation i'm only able to update existing group but i CAN'T add any news group anymore.

Here the error:

Code: Select all

Could not insert new group

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

INSERT INTO phpbb_groups (group_type, group_name, group_description, group_moderator, group_count,group_count_enable, group_allow_pm, group_single_user) VALUES (2, 'New', 'ASD', 11, '99999999','', '0')

Line : 371
File : /home/virtual/site12/fst/var/www/html/luxiaobscurea/admin/admin_groups.php


Here my code line of admin_groups.php on 2.03

Code: Select all

      else if( $mode == 'newgroup' )
      {
         $sql = "INSERT INTO " . GROUPS_TABLE . " (group_type, group_name, group_description, group_moderator, group_count,group_count_enable, group_allow_pm, group_single_user)
            VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '$group_count','$group_count_enable', '0')";
         if ( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Could not insert new group', '', __LINE__, __FILE__, $sql);
         }


Thank you for great mods u provide us!
keep good work

PS:
Haven't you forgot a space after "," here in the middle group_count,group_count_enable ?

[Niels]

It seam like you also have my custom mass PM mod, some how, you have removed this

Code: Select all

, '$group_allow_pm'

from the code, put this back, and it should work

the "Space" you mentioned, are not exential, so it doesne't matter if it is there or not - so don't worry

[pzsniper]

It seam like you also have my custom mass PM mod, some how, you have removed this

Code: Select all

, '$group_allow_pm'

from the code, put this back, and it should work

the "Space" you mentioned, are not exential, so it doesne't matter if it is there or not - so don't worry

NOPE!
Anyway I ALREADY have

Here teh error on again:
[/code]
Could not insert new group

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_count,group_count_enable, group_allow_pm, group_single_user) VALUES (0, 'ASS', 'ASS', 11, '0', '99999999','', '0')

Line : 371
File : /home/virtual/site12/fst/var/www/html/luxiaobscurea/admin/admin_groups.php
[/code]

on your suggested code:

Code: Select all

      else if( $mode == 'newgroup' )
      {
         $sql = "INSERT INTO " . GROUPS_TABLE . " (group_id, group_type, group_name, group_description, group_moderator, group_count,group_count_enable, group_allow_pm, group_single_user)
            VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '$group_allow_pm', '$group_count','$group_count_enable', '0')";
         if ( !$db->sql_query($sql) )

[pzsniper]

Here the WHOLE code:

Code: Select all

<?php
/***************************************************************************
*                             admin_groups.php
*                            -------------------
*   begin                : Saturday, Feb 13, 2001
*   copyright            : (C) 2001 The phpBB Group
*   email                : support@phpbb.com
*
*   $Id: admin_groups.php,v 1.25.2.5 2002/07/31 19:14:46 dougk_ff7 Exp $
*
*
***************************************************************************/

/***************************************************************************
*
*   This program is free software; you can redistribute it and/or modify
*   it under the terms of the GNU General Public License as published by
*   the Free Software Foundation; either version 2 of the License, or
*   (at your option) any later version.
*
***************************************************************************/

define('IN_PHPBB', 1);

if ( !empty($setmodules) )
{
   $filename = basename(__FILE__);
   $module['Groups']['Manage'] = $filename;

   return;
}

//
// Load default header
//
$phpbb_root_path = './../';
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);

if ( isset($HTTP_POST_VARS[POST_GROUPS_URL]) || isset($HTTP_GET_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 ( isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode']) )
{
   $mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
}
else
{
   $mode = '';
}

if ( isset($HTTP_POST_VARS['edit']) || isset($HTTP_POST_VARS['new']) )
{
   //
   // Ok they are editing a group or creating a new group
   //
   $template->set_filenames(array(
      'body' => 'admin/group_edit_body.tpl')
   );

   if ( isset($HTTP_POST_VARS['edit']) )
   {
      //
      // They're editing. Grab the vars.
      //
      $sql = "SELECT *
         FROM " . GROUPS_TABLE . "
         WHERE group_single_user <> " . TRUE . "
         AND group_id = $group_id";
      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']);
      }

      $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_allow_pm' => AUTH_ADMIN,
            'group_count' => '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.
   //
   $sql = "SELECT user_id, username
      FROM " . USERS_TABLE . "
      WHERE user_id <> " . ANONYMOUS . "
      ORDER BY username";
   if ( !($result = $db->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'];
      }
   }

   $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_alllow_pm_all = ( $group_info['group_allow_pm'] == AUTH_ALL ) ? ' checked="checked"' : '';
    $group_allow_pm_reg = ( $group_info['group_allow_pm'] == AUTH_REG ) ? ' checked="checked"' : '';
    $group_allow_pm_private = ( $group_info['group_allow_pm'] == AUTH_ACL ) ? ' checked="checked"' : '';
    $group_allow_pm_mod = ( $group_info['group_allow_pm'] == AUTH_MOD ) ? ' checked="checked"' : '';
    $group_allow_pm_admin = ( $group_info['group_allow_pm'] == AUTH_ADMIN ) ? ' checked="checked"' : '';
    $group_count_enable_checked = ( $group_info['group_count_enable'] ) ? ' checked="checked"' : '';

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

   $template->assign_vars(array(
      'GROUP_NAME' => $group_info['group_name'],
      'GROUP_DESCRIPTION' => $group_info['group_description'],
      'GROUP_MODERATOR' => $group_moderator,
        'GROUP_ALLOW_PM' => $group_info['group_allow_pm'],

        'L_GROUP_ALLOW_PM' => $lang['group_allow_pm'],
        'L_GROUP_ALLOW_PM_EXPLAIN' => $lang['group_allow_pm_explain'],
        'L_GROUP_ALL_ALLOW_PM' => $lang['Forum_ALL'],
        'L_GROUP_REG_ALLOW_PM' => $lang['Forum_REG'],
        'L_GROUP_PRIVATE_ALLOW_PM' => $lang['Forum_PRIVATE'],
        'L_GROUP_MOD_ALLOW_PM' => $lang['Forum_MOD'],
        'L_GROUP_ADMIN_ALLOW_PM' => $lang['Forum_ADMIN'],

        'S_GROUP_ALL_ALLOW_PM_CHECKED' => $group_allow_pm_all,
        'S_GROUP_REG_ALLOW_PM_CHECKED' => $group_allow_pm_reg,
        'S_GROUP_PRIVATE_ALLOW_PM_CHECKED' => $group_allow_pm_private,
        'S_GROUP_MOD_ALLOW_PM_CHECKED' => $group_allow_pm_mod,
        'S_GROUP_ADMIN_ALLOW_PM_CHECKED' => $group_allow_pm_admin,
        'S_GROUP_ALL_ALLOW_PM' => AUTH_ALL,
        'S_GROUP_REG_ALLOW_PM' => AUTH_REG,
        'S_GROUP_PRIVATE_ALLOW_PM' => AUTH_ACL,
        'S_GROUP_MOD_ALLOW_PM' => AUTH_MOD,
        'S_GROUP_ADMIN_ALLOW_PM' => AUTH_ADMIN,
        'GROUP_COUNT' => $group_info['group_count'],
        'GROUP_COUNT_ENABLE_CHECKED' => $group_count_enable_checked,

        'L_GROUP_COUNT' => $lang['group_count'],
        '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_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,
      'S_GROUP_CLOSED_TYPE' => GROUP_CLOSED,
      'S_GROUP_HIDDEN_TYPE' => GROUP_HIDDEN,
      'S_GROUP_OPEN_CHECKED' => $group_open,
      'S_GROUP_CLOSED_CHECKED' => $group_closed,
      'S_GROUP_HIDDEN_CHECKED' => $group_hidden,
      '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']) )
   {
      $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 href="' . append_sid("admin_groups.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</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']) ? 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_allow_pm = isset($HTTP_POST_VARS['group_allow_pm']) ? intval($HTTP_POST_VARS['group_allow_pm']) : AUTH_ADMIN;
        $group_count = isset($HTTP_POST_VARS['group_count']) ? intval($HTTP_POST_VARS['group_count']) : 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);
      $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 . "
            AND group_id = " . $group_id;
         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']);
         }
      
         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);
               }
            }
         }

         $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_allow_pm='$group_allow_pm', group_count='$group_count', 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 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_update'],$group_count_remove,$group_count_added). '<br /><br />' . sprintf($lang['Click_return_groupsadmin'], '<a href="' . append_sid("admin_groups.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');;

         message_die(GENERAL_MESSAGE, $message);
      }
      else if( $mode == 'newgroup' )
      {
         $sql = "INSERT INTO " . GROUPS_TABLE . " (group_id, group_type, group_name, group_description, group_moderator, group_count,group_count_enable, group_allow_pm, group_single_user)
            VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '$group_allow_pm', '$group_count','$group_count_enable', '0')";
         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 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_update'],$group_count_remove,$group_count_added). '<br /><br />' . sprintf($lang['Click_return_groupsadmin'], '<a href="' . append_sid("admin_groups.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</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 . "
      ORDER BY group_name";
   if ( !($result = $db->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 name="' . POST_GROUPS_URL . '">';
      do
      {
         $select_list .= '<option value="' . $row['group_id'] . '">' . $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);

?>



[Niels]

this line:

Code: Select all

$sql = "INSERT INTO " . GROUPS_TABLE . " (group_id, group_type, group_name, group_description, group_moderator, group_count,group_count_enable, group_allow_pm, group_single_user)
            VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '$group_allow_pm', '$group_count','$group_count_enable', '0')";
         

Is messed up, you need to redo the modifications to this, the order of the values are messed, along with other, please be very carreful when moding this line

[pzsniper]

Ok, redo modification, but which ones?!
I mean MOD's names.

Sorry, but maybe i'm a little hard to understand this time
Forgive me

[Niels]

it seams to me, that you have both implemented the mass PM and the autogroup into this line.

start with a fresh non modded "line" and do both mods again

[pzsniper]

If i use THAT code:

Code: Select all

   else if ( isset($HTTP_POST_VARS['new']) )
   {
      $group_info = array (
         'group_name' => '',
         'group_description' => '',
         'group_moderator' => '',
         'group_type' => GROUP_OPEN);
         'group_allow_pm' => AUTH_ADMIN,
            'group_count' => '99999999',
            'group_count_enable' => '0',
      $group_open = ' checked="checked"';

      $mode = 'newgroup';


Creating news group NOW gimme that:

Code: Select all

Parse error: parse error, unexpected T_DOUBLE_ARROW in /home/virtual/site12/fst/var/www/html/luxiaobscurea/admin/admin_groups.php on line 97


line 97 IS 'group_allow_pm' => AUTH_ADMIN

But let me ask that: if in mysql i've data in that ORDER:

A_01
B_02

and i mod in THAT way:

$sql = "INSERT INTO " . GROUPS_TABLE . " (A_02, A_01)

IS IT CORRECT or i need to keep the order?
in THAT way

$sql = "INSERT INTO " . GROUPS_TABLE . " (A_01, A_02)

Sorry for maybe stupid question!

Anyway now i've checked all the code and IS in the SAME order as in MySQL, but pop me the SAME error when i create a news group!

Code: Select all

$sql = "INSERT INTO " . GROUPS_TABLE . " (group_id, group_type, group_name, group_description, group_moderator, group_single_user, group_allow_pm, group_count, group_count_enable)
VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '$group_allow_pm', '$group_count', '$group_count_enable',   '0')";


My question is if maybe SHOULD i try to install AUTO GROUP *BEFORE* the CUSTOM MASS PM?