[résolu] Connexion des utilisateurs d'une base externe

/<strong>
 * Connect an external user
 * @param $form
 * @param $form_state
 * @param $form_id
 * @return
 */
function loginuser_form_alter(&$form, $form_state, $form_id)
{
   
   if ($form_id == 'user_login_block' || $form_id == 'user_login')
   {
      if (isset($form_state['post']['name']))
       {
          if($form_state["post"]["name"] != 'admin')
           {
              // Replace the default method to validate a user
               $form['#validate'][1] = '_loginuser_authenticate_validate';
            }
      }
      else
       {
          return;
        }
      }
}

/</strong>
 * Authenticate an external user
 * @param $form
 * @param $form_state
 * @return
 */
function _loginuser_authenticate_validate($form, &$form_state)
{
   global $user ;
 
        //Use external database
   db_set_active('external_database');
  // Search in external database
 $results = db_query("SELECT * FROM external_user
  WHERE login = '%s' AND pass = '%s', ",
    $form['#post']['name'],md5($form['#post']['pass']));
  
   $row = db_fetch_array($results) ;

 db_set_active('default');
   
   // If external user exists
 if($row)
   {
     $resultsDrupal = db_query("SELECT * FROM {users} WHERE uid = %d ",
       $row['id_user']);
        $rowDrupal = db_fetch_array($resultsDrupal) ;
         
       // If user's id exists in drupal
      if ($rowDrupal)
       {
          $login = $row['login'];
          $pass = $row['pass'];
               
           //If user's Drupal have a different login and pass
            if($login != $rowDrupal['name']
         || $pass != $rowDrupal['pass'])
          {

            // Update drupal'login and drupal's pass
         $success = db_query("UPDATE {users} SET login = '%s', pass =  '%s'
           WHERE uid = %d", $login, $pass, $row['id_user']);
               
          $userinfo = array(
              'uid' =>  $row['id_user']
           );
                
          // User authenticates
         $user = user_load($userinfo);
          user_authenticate_finalize($userinfo);
      }
          else
           {
              // Else user authenticates
             user_authenticate($form_state['values']);
            }
      }
      else
       {
          $login = $form['#post']['name'];
           $pass = $form['#post']['pass'];
               
       $userinfo = array(
         'name' => $form['#post']['name'],
         'pass' => $form['#post']['pass'],
         'mail' => $row['email'],
            'init' => $form['#post']['name'],
         'status' => 1,
            'uid' =>  $row['id_user'],
          'access' => time(),
           'timezone' => variable_get('date_default_timezone', NULL),
          'language' => language_default()->language
         );
            
              
           $user = '';
             
           // Create user in Drupal
           user_save($user,$userinfo);
            // Authenticate user
               user_authenticate(array('name' => $login, 'pass' => $pass));
     }
  }
  else
   {
         form_set_error('name', t('Sorry, unrecognized username or password.   <a  href="@password">Have you forgotten your password?</a>', array('@password' => url('user/password'))));
   }
}

/**
 * Hook_user
 * @param $form
 * @param $form_state
 * @return
 */
function loginuser_user($op, &$edit, &$account, $category = NULL)
{
   
   if($op == 'load')
    {
     
       if($account->uid != 1)
      {
          db_set_active('external_database');
          // Search in external database
         $result = db_query("SELECT * FROM
            external_user WHERE id = '%d'", $account->uid);
         
           $row = db_fetch_array($result) ;

          db_set_active('default');
           
           $account->name = $row['Prenom'].' '.$row['Nom'];
          $account->nom = $row['Nom'];
          $account->prenom = $row['Prenom'];
        }
  }
 
   if($op == 'form')
    {
      // Account information:
        $form['information'] = array('#type' => 'fieldset',
           '#title' => t('Informations générales'),
            '#weight' => -11,
       );
      
       $form['information']['nom'] = array(
       '#type' => 'textfield',
     '#title' => t('Nom'),
       '#default_value' => $account->nom
      );
    
       $form['information']['prenom'] = array(
        '#type' => 'textfield',
     '#title' => t('Prenom'),
        '#default_value' => $account->prenom
       );
    
       return $form;
  }
 
   if($op == 'validate')
    {
      $error = false;
        if (!strlen($edit['nom']))
      {
           form_set_error('nom',  t('You must enter a username.'));
           $error = true;
        }
      if (!strlen($edit['prenom']))
       {
           form_set_error('prenom',  t('You must enter a username.'));
            $error = true;
        }
     
       if($error)
     {
          return;
        }
     
       db_set_active('external_database');
      $success = db_query("UPDATE external_user set
        Nom = '%s', Prenom = '%s'
     WHERE id = %d ", $edit['nom'], $edit['prenom'], $account->uid);

       db_set_active('default');
       
       if(!$success)
      {
          form_set_error('', t('Une erreur est survenue lors de l\'enregistrement.'));
      }
     
   }
}