. */ /** * @brief List of users for autocompletion * * * @file * @author Laurent Giovannoni * @date $date$ * @version $Revision$ * @ingroup admin */ $db = new dbquery(); $db->connect(); if($_SESSION['config']['databasetype'] == "POSTGRESQL") { $db->query("select lastname as tag from ".$_SESSION['tablename']['contacts']." where lastname ilike '".$_REQUEST['what']."%' and (user_id = '' or user_id = null or user_id is null) order by lastname"); } else { $db->query("select lastname as tag from ".$_SESSION['tablename']['contacts']." where lastname like '".$_REQUEST['what']."%' and (user_id = '' or user_id = null or user_id is null) order by lastname"); } $listArray = array(); while($line = $db->fetch_object()) { array_push($listArray, $line->tag); } echo "

\n"; $authViewList = 0; foreach($listArray as $what) { if($authViewList >= 10) { $flagAuthView = true; } if(stripos($what, $_REQUEST['what']) === 0) { echo "
• ".$what."
\n"; if($flagAuthView) { echo "
• ...
\n"; break; } $authViewList++; } } echo "

";