. */ /** * @brief List of classification scheme for autocompletion * * * @file * @author Claire Figueras * @date $date$ * @version $Revision$ * @ingroup admin */ require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php"); require_once("modules/moreq/moreq_tables_definition.php"); $db = new dbquery(); $db->connect(); if($_SESSION['config']['databasetype'] == "POSTGRESQL") { $db->query("select mr_title as tag from "._CLASSIFICATION_SCHEME_TABLE_NAME." where mr_title ilike '".$_REQUEST['what']."%' order by mr_title"); } else { $db->query("select mr_title as tag from "._CLASSIFICATION_SCHEME_TABLE_NAME." where mr_title like '".$_REQUEST['what']."%' order by mr_title"); } $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 "

";