Еще раз о добавлении новых групп пользователей. - Joomla 1.5: Настройка и оптимизация

SET @parent_name = 'Registered';
SET @new_name = 'Partners';

-- Select the parent node to insert after
SELECT @ins_id := id, @ins_lft := lft, @ins_rgt := rgt
FROM jos_core_acl_aro_groups
WHERE name = @parent_name;

SELECT @new_id := MAX(id) + 1 FROM jos_core_acl_aro_groups;

-- Make room for the new node
UPDATE jos_core_acl_aro_groups SET rgt=rgt+2 WHERE rgt>=@ins_rgt;
UPDATE jos_core_acl_aro_groups SET lft=lft+2 WHERE lft>@ins_rgt;

-- Insert the new node
INSERT INTO jos_core_acl_aro_groups (id,parent_id,name,lft,rgt,value)
VALUES (@new_id,@ins_id,@new_name,@ins_rgt,@ins_rgt+1,"Partners");

 if ( $userGroupName == $myGroupName && $myGroupName == 'administrator' )
   {
      // administrators can't change each other
      $lists['gid'] = '<input type="hidden" name="gid" value="'. $user->get('gid').'" /><strong>'. JText::_( 'Administrator' ).'</strong>';
   }
   else
   {
      $gtree = $acl->get_group_children_tree( null, 'USERS', false );

 if ( $userGroupName == $myGroupName && $myGroupName == 'administrator' )
   {
      // administrators can't change each other
      $lists['gid'] = '<input type="hidden" name="gid" value="'. $user->get('gid').'" /><strong>'. JText::_( 'Administrator' ).'</strong>';
   }
   else
   {
      $gtree = $acl->get_group_children_tree( null, 'USERS', true);

INSERT INTO `jos_groups` (`id`,`name`) VALUES ('3','Partners')

<?php

mysql_connect("localhost", "xxxx", "xxxxx") or
    die("Could not connect: " . mysql_error());
   mysql_select_db("joomla15");

// 0-> parent_id in Joomla this is the value of the parent_id field of the Root record
// 1-> start the left tree at 1
rebuild_tree ( 0 , 1);


function rebuild_tree($parent_id, $left) {
   

// the right value of this node is the left value + 1
   $right = $left+1;

   // get all children of this node
   $result = mysql_query('SELECT id FROM jos_core_acl_aro_groups '.
                          'WHERE parent_id="'.$parent_id.'";');
   while ($row = mysql_fetch_array($result)) {
       // recursive execution of this function for each
       // child of this node
       // $right is the current right value, which is
       // incremented by the rebuild_tree function
       $right = rebuild_tree($row['id'], $right);
     }

   // we've got the left value, and now that we've processed
   // the children of this node we also know the right value
   mysql_query('UPDATE jos_core_acl_aro_groups SET lft='.$left.', rgt='.
                $right.' WHERE id="'.$parent_id.'";');

   // return the right value of this node + 1
   return $right+1;
}
?>