os-sim/www/alarm/providers/event_type_autocomplete.php
<?php
/**
*
* License:
*
* Copyright (c) 2003-2006 ossim.net
* Copyright (c) 2007-2013 AlienVault
* All rights reserved.
*
* This package is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; version 2 dated June, 1991.
* You may not use, modify or distribute this program under any other version
* of the GNU General Public License.
*
* This package is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this package; if not, write to the Free Software
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,
* MA  02110-1301  USA
*
*
* On Debian GNU/Linux systems, the complete text of the GNU General
* Public License can be found in `/usr/share/common-licenses/GPL-2'.
*
* Otherwise you can read it here: http://www.gnu.org/licenses/gpl-2.0.txt
*
*/


require_once 'av_init.php';

Session::logcheck("analysis-menu", "ControlPanelAlarms");

$q = strtolower(GET("q"));

ossim_valid($q, OSS_TEXT, 'illegal:' . _("Query"));

// Empty results when error in validation
if (ossim_error())
{
	exit;
}
	
$db    = new ossim_db();
$conn  = $db->connect();

$q     = escape_sql($q, $conn);

$sql   = "SELECT DISTINCT sid, plugin_id, name FROM plugin_sid WHERE lower(name) LIKE '%$q%';";

if (!$rs = $conn->Execute($sql))
{
    Av_exception::throw_error(Av_exception::DB_ERROR, $conn->ErrorMsg());
}
else
{
	while (!$rs->EOF) 
	{
	    echo $rs->fields["plugin_id"]."-".$rs->fields["sid"]."###".$rs->fields["name"]."\n";
		$rs->MoveNext();
	}
}

?>