'.chr(0x0D).chr(0x0A);
$sql = "SELECT * FROM events WHERE event_date >= CURDATE() ";
$sql .= "ORDER BY event_date, event_time DESC";
$row = 0;
if ($result = mysqli_query($db, $sql)) {
$num_rows = mysqli_num_rows($result);
if ($num_rows > 0) {
/* fetch associative array */
while ($data = mysqli_fetch_object($result)) {
$event_id = $data->event_id;
$event_title = stripslashes($data->event_title);
$event_descr = stripslashes($data->event_descr);
$event_location = stripslashes($data->event_location);
$event_url = stripslashes($data->event_url);
$event_cost = $data->event_cost;
$event_date = date_create($data->event_date);
$event_time = date_create($data->event_time);
if($grp_id == 1) { //Knop bewerken tonen
$html .= '
'.CreateLocalDate($event_date).' '.$event_title.'
'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' Item | '.chr(0x0D).chr(0x0A);
$html .= ' '.$event_title.' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' Datum | '.chr(0x0D).chr(0x0A);
$html .= ' '.CreateLocalDate($event_date).' '.date_format($event_time,"H:i").' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' Locatie | '.chr(0x0D).chr(0x0A);
$html .= ' '.$event_location.' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' Kosten Euro | '.chr(0x0D).chr(0x0A);
$html .= ' '.$event_cost.' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' Website | '.chr(0x0D).chr(0x0A);
$html .= ' '.$event_title.' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' Omschrijving | '.chr(0x0D).chr(0x0A);
$html .= ' '.$event_descr.' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' | '.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
} else { //Knop Bewerken verbergen
$html .= '
'.CreateLocalDate($event_date).' '.$event_title.'
'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' Item | '.chr(0x0D).chr(0x0A);
$html .= ' '.$event_title.' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' Datum | '.chr(0x0D).chr(0x0A);
$html .= ' '.CreateLocalDate($event_date).' '.date_format($event_time,"H:i").' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' Locatie | '.chr(0x0D).chr(0x0A);
$html .= ' '.$event_location.' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' Kosten Euro | '.chr(0x0D).chr(0x0A);
$html .= ' '.$event_cost.' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' Website | '.chr(0x0D).chr(0x0A);
$html .= ' '.$event_title.' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= ' Omschrijving | '.chr(0x0D).chr(0x0A);
$html .= ' '.$event_descr.' | '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
}
if($data->event_id == $event_id_post){
$script = CreateScript($row);
}
$row = $row + 1;
}
if($grp_id == 1) { //Knop bewerken tonen
$html .= '
Nieuw item toevoegen
'.chr(0x0D).chr(0x0A);
$html .= '
Een nieuw item toevoegen.'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
}
} else {
if($grp_id == 1) { //Knop bewerken tonen
$html .= '
Agenda leeg...
'.chr(0x0D).chr(0x0A);
$html .= '
Een nieuw item toevoegen.'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' '.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
} else {
$html .= '
Agenda leeg...
'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' Er zijn gen items gevonden.'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
}
$script = CreateScript(0);
}
mysqli_free_result($result);
} else {
$html .= '
Database is bezig...
'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$html .= ' Probeer het later nog eens....'.chr(0x0D).chr(0x0A);
$html .= '
'.chr(0x0D).chr(0x0A);
$script = CreateScript(0);
}
$html .= '
'.chr(0x0D).chr(0x0A);
if(!isset($script)){
$script = CreateScript(0);
}
} else {
if ($_GET['method']=="edit") {
$html .= '