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

check_admin();

$mdb2 = mdb2_open($dsn);


$mdb2->setLimit(15, 0);
$query = <<<EOT
SELECT ppl.ppl_id 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 <= {$_SERVER['REQUEST_TIME']}
AND ppl2grp.ppl_exit > {$_SERVER['REQUEST_TIME']}
JOIN $kldv.grp ON grp.grp_id = ppl2grp.grp_id
WHERE grp.grp_home = 1 AND ppl_name_normalized LIKE '%%%w%%'
EOT;

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

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

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

echo(json_encode($array));

$mdb2->disconnect();

?>