<?php
/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */


include("../global.php");
include("paymentConstants.php");

 header ("content-type: text/xml");

$event_id = $_GET['event_id'];
$search = $_GET['search'];


$users = $DB->query_all("SELECT user.id, nick, vorname, nachname
                        FROM user
                        INNER JOIN event_teilnehmer ON user.id = event_teilnehmer.user_id
                        WHERE event_teilnehmer.event_id = ".$GCeventID."
                        AND (
                            user.id LIKE '%$search%'
                            OR user.nick LIKE '%$search%'
                            OR user.vorname LIKE '%$search%'
                            OR user.nachname LIKE '%$search%' )

                        ORDER BY user.nick; ");

echo '<?xml version="1.0" encoding="ISO-8859-1"?>';
echo "<dotlan>
    <result>";

foreach ( $users as $id=>$user){
    echo '<user id="'.$user['id'].'" title="'.$user['nick'].' ('. $user['vorname'].' '.substr($user['nachname'], 0, 1).'.)" />';
}


echo "</result>
    </dotlan>
";




?>