. */ /** * @brief List of users for autocompletion * * * @file * @author Laurent Giovannoni * @date $date$ * @version $Revision$ * @ingroup admin */ require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php"); $db = new dbquery(); $db->connect(); $listArray = array(); $db->query("select is_corporate_person, society, lastname, firstname, contact_id from " .$_SESSION['tablename']['contacts']." where (lower(lastname) like lower('%".$db->protect_string_db($_REQUEST['what'])."%') " ."or lower(firstname) like lower('".$db->protect_string_db($_REQUEST['what'])."%') " ."or lower(society) like lower('%".$db->protect_string_db($_REQUEST['what'])."%')) and enabled <> 'N'"); //$db->show(); while ($line = $db->fetch_object()) { array_push($listArray, $db->show_string($line->society).", ".$db->show_string($line->lastname)." ".$db->show_string($line->firstname)." (contact:".$line->contact_id.")"); } echo "

\n"; $authViewList = 0; $flagAuthView = false; foreach ($listArray as $what) { if ($authViewList >= 10) { $flagAuthView = true; } echo "
• ".$what."
\n"; if($flagAuthView) { echo "
• ...
\n"; break; } $authViewList++; } echo "

";