. */ /** * @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 as tag from ".$_SESSION['tablename']['users'] . " where (" . "lower(lastname) like lower('".$db->protect_string_db($_REQUEST['what'])."%') " . " or lower(user_id) like lower('".$db->protect_string_db($_REQUEST['what'])."%') " . ") and status <> 'DEL'" . " order by lastname" ); $listArray = array(); while($line = $db->fetch_object()) { array_push($listArray, $line->tag); } echo "

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

";