. */ /** * @brief List of users for autocompletion * * * @file * @author Laurent Giovannoni * @date $date$ * @version $Revision$ * @ingroup admin */ $db = new dbquery(); $db->connect(); $db->query( "select lastname, firstname, user_id from ".$_SESSION['tablename']['users'] . " where (" . "lower(lastname) like lower('".$_REQUEST['what']."%') " . " or lower(firstname) like lower('".$_REQUEST['what']."%') " . " or lower(user_id) like lower('".$_REQUEST['what']."%') " . ") and status <> 'DEL'" . " order by lastname, firstname" ); $listArray = array(); while ($line = $db->fetch_object()) { $listArray[$line->user_id] = $db->show_string($line->lastname)." ".$db->show_string($line->firstname); } echo "

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

";