<?
require_once('phplib/phplib.php');
require_once('common.php');

check_admin();

$db = mdb2_open($dsn);

$db->setLimit(15, 0);
$query = <<<EOT
SELECT ppl.ppl_login id, $concat_begin ppl.ppl_forename $concat_cont  ' ' $concat_cont ppl.ppl_prefix $concat_cont ' ' $concat_cont ppl.ppl_surname $concat_cont ' (' $concat_cont grp.grp_name $concat_cont '/' $concat_cont ppl.ppl_login $concat_cont ')' $concat_end value
FROM $kldv.ppl
JOIN $kldv.ppl2grp ON ppl2grp.ppl_id = ppl.ppl_id
AND ppl2grp.ppl_enter <= UNIX_TIMESTAMP()
AND ppl2grp.ppl_exit > UNIX_TIMESTAMP()
JOIN $kldv.grp ON grp.grp_id = ppl2grp.grp_id
WHERE grp.grp_home = 1 AND ppl_name_normalized LIKE '%%%w%%' AND ( SUBSTRING(grp_name, 1, 2) = '4M' OR SUBSTRING(grp_name, 1, 2) = '5H' OR SUBSTRING(grp_name, 1, 2) = '6V')
EOT;

$result = mdb2_query($db, $query, normalize(htmlenc($_GET['term'])));

//header("Content-Type: text/plain; charset=UTF-8");
header("Content-Type: application/json; charset=UTF-8");

$array = $result->fetchAll(MDB2_FETCHMODE_ASSOC);

# remove html entities
foreach ($array as $idx => $row) {
	$array[$idx]['value'] = htmldec($row['value']);
}

echo(json_encode($array));

$db->disconnect();
?>