*/
include("session.php");
require_once("class_functions.php");
require_once("class_db.php");
$db = new dbquery();
if(file_exists($_SESSION['config']['lang'].'.php'))
{
include($_SESSION['config']['lang'].'.php');
}
else
{
$_SESSION['error'] = "Language file missing... ";
}
//On efface tout ce qui concerne les expediteurs
unset($_SESSION['new_exp']);
unset($_SESSION['exp_id']);
unset($_SESSION['last_exp_search']);
unset($_SESSION['last_exp_result']);
function search_emet($search)
{
global $db;
if( strlen(trim($search)) < 1 )
return array();
$db->connect();
$db->query("SELECT ID, LASTNAME, FIRSTNAME, SOCIETY FROM ".$_SESSION['tablename']['senders']."
WHERE (TOCONTACT IS NULL OR TOCONTACT = '".$_SESSION['user']['UserId']."')
AND ( LASTNAME LIKE '%".strtolower($search)."%'
OR LASTNAME LIKE '%".strtoupper($search)."%'
OR FIRSTNAME LIKE '%".strtolower($search)."%'
OR FIRSTNAME LIKE '%".strtoupper($search)."%'
OR SOCIETY LIKE '%".strtoupper($search)."%'
OR SOCIETY LIKE '%".strtoupper($search)."%' )
GROUP BY ID
ORDER BY LASTNAME, FIRSTNAME, SOCIETY, ID");
//LIMIT 0,5
$return=array();
while($res = $db->fetch_object())
$return[$res->ID] = array("LASTNAME"=>$res->LASTNAME,"FIRSTNAME"=>$res->FIRSTNAME,"SOCIETY"=>$res->SOCIETY);
$db->deco();
return $return;
}
//Recherche Ajax
if( isset($_GET['ajax']) )
{
if( isset($_GET['emet_search']) && !empty($_GET['emet_search']) )
{
//On efface l'emetteur
unset($_SESSION['emet_id']);
unset($_SESSION['new_emet']);
//Requete Ajax de recherche
echo "