<?php
/*******************************************************
** IntraMessenger - server **
** **
** Copyright: (C) 2006 - 2010 THeUDS **
** Web: http://www.theuds.com **
** http://www.intramessenger.net **
** Licence : GPL (GNU Public License) **
** http://opensource.org/licenses/gpl-license.php **
*******************************************************/
/*******************************************************
** This file is part of IntraMessenger-server **
** **
** IntraMessenger is a free software. **
** IntraMessenger is distributed in the hope that **
** it will be useful, but WITHOUT ANY WARRANTY. **
*******************************************************/
define("_EXTERNAL_AUTHENTICATION_NAME", "Group-Office");
function f_external_authentication($t_user, $t_pass)
{
$t_verif_pass = "Ko";
$passcr = md5($t_pass);
//
require("../common/config/extern.config.inc.php");
if ( ($extern_dbhost != '') and ($extern_database != '') and ($extern_dbuname != '') )
{
// Si Group-Office n'est pas sur le même serveur ou la même base de donnée.
mysql_close();
require("extern.sql.inc.php");
}
//
$requete = " select LOWER(username), password, auth_md5_pass FROM " . $extern_prefix . "users ";
$requete .= " WHERE LOWER(username) = '" . $t_user . "' ";
$requete .= " and enabled = 1 ";
$result = mysql_query($requete);
if (!$result) error_sql_log("[ERR-T40a]", $requete);
if ( mysql_num_rows($result) == 1 )
{
list ($login_extern, $pass_extern, $auth_pass) = mysql_fetch_row ($result);
if ( ($login_extern == $t_user) and ($pass_extern == $passcr) )
{
if (md5($t_user . ":" . $passcr) == $auth_pass)
$t_verif_pass = "OK";
}
//
}
if ( ($extern_dbhost != '') and ($extern_database != '') and ($extern_dbuname != '') )
{
mysql_close($id_connect_extern);
require("sql.2.inc.php");
}
//
return $t_verif_pass;
}
function f_extern_name_of_user($t_user)
{
$family_and_first_name = "";
//
require("../common/config/extern.config.inc.php");
if ( ($extern_dbhost != '') and ($extern_database != '') and ($extern_dbuname != '') )
{
// Si groupoffice n'est pas sur le même serveur ou la même base de donnée.
mysql_close();
require("extern.sql.inc.php");
}
//
$requete = " select LOWER(username), last_name, first_name FROM users ";
$requete .= " WHERE LOWER(username) = '" . $t_user . "' ";
$result = mysql_query($requete);
if (!$result) error_sql_log("[ERR-T40b]", $requete);
if ( mysql_num_rows($result) == 1 )
{
list ($login_extern, $extern_familyname, $extern_firstname) = mysql_fetch_row ($result);
if ($login_extern == $t_user)
$family_and_first_name = ucfirst(trim($extern_firstname)) . " " . strtoupper(trim($extern_familyname));
//$family_and_first_name = trim($extern_firstname) . " " . trim($extern_familyname);
//
}
if ( ($extern_dbhost != '') and ($extern_database != '') and ($extern_dbuname != '') )
{
mysql_close($id_connect_extern);
require("sql.2.inc.php");
}
//
return $family_and_first_name;
}
?>