Abmeldungen

Wir sind sehr traurig darüber, dass sich folgende Spieler von den SALZBURG OPEN abgemeldet haben.

Vielleicht klappt es ja im nächsten Jahr. Bis dahin "GUT STOß" aus Salzburg.

{source}

<?php
$dblink = new mysqli("localhost", "db1058529-open", "ZKG8AlZDJ76U", "db1058529-open102014");
$dblink->set_charset("utf8");
$dblink->query ( "SET NAMES 'utf8'" );
$dblink->query ( "SET CHARACTER SET 'utf8'" );
$result = mysqli_query($dblink, "SELECT
    a.first_name AS Vorname,
    a.last_name AS Nachname,
    a.course_id AS Veranstaltung,
    s.translation AS STATUS,
    DATE(a.DATE) AS Datum,
    (SELECT f.value AS Club FROM zo0vf_seminarman_fields_values f WHERE f.applicationid = a.id AND field_id = 5) AS Stadt,
    (SELECT f.value AS Club FROM zo0vf_seminarman_fields_values f WHERE f.applicationid = a.id AND field_id = 6) AS Land,
    (SELECT f.value AS Club FROM zo0vf_seminarman_fields_values f WHERE f.applicationid = a.id AND field_id = 21) AS Turnier,
    (SELECT f.value AS Club FROM zo0vf_seminarman_fields_values f WHERE f.applicationid = a.id AND field_id = 19) AS 'Gruppe*'   
FROM
    zo0vf_seminarman_application a
    INNER JOIN zo0vf_seminarman_status s ON a.STATUS = s.uid
    LEFT JOIN (SELECT VALUE, applicationid FROM zo0vf_seminarman_fields_values v WHERE applicationid IN (5,6,19,21)) f ON a.id = f.applicationid
WHERE s.uid IN (3) AND course_id = 5
GROUP BY a.first_name, a.last_name, s.translation, DATE(a.DATE)
HAVING turnier = 'MAIN + WOMEN EVENT' OR turnier = 'SALZBURG OPEN 2018'
ORDER BY a.DATE");
;
 
$fields_num = mysqli_field_count($result, dblink);

 
echo "<div class='demo-container'><table class='footable'>";
 
echo "<div class='demo-container'><table class='footable'>";
echo'<thead><tr><th data-ignore="true" data-hide="all"></th><th class="footable-first-column footable-sortable footable-sorted" data-type="numeric">Nr <span class="footable-sort-indicator"></span></th><th class="footable-sortable">Vorname <span class="footable-sort-indicator"></span></th><th class="footable-sortable">Nachname <span class="footable-sort-indicator"></span></th><th class="footable-sortable" data-hide="phone">Turnier <span class="footable-sort-indicator"></span></th><th class="footable-sortable" data-hide="phone">Status <span class="footable-sort-indicator"></span></th><th class="footable-sortable" data-hide="phone, tablet">Datum <span class="footable-sort-indicator"></span></th></tr></thead>';
 
 
echo'<tbody>';
$i=0;
while($data = mysqli_fetch_assoc($result))
 
{
 
echo'<tr class="footable-detail-show">';
 
echo '<td class="footable-visible"></td><td class="footable-visible">'.++$i.'</td><td class="footable-visible">'.$data['Vorname'].'</td><td class="footable-visible">'.$data['Nachname'].'</td><td class="footable-visible">'.$data['Turnier'].'</td><td class="footable-visible">'.$data['STATUS'].'</td><td class="footable-visible">'.$data['Datum'].'</td>';
 
echo'</tr>';
 
}
 
echo "</tbody></table></div>";
// Verbindung zum Datenbankserver beenden
mysqli_close($db);
?>


<!-- FooTable -->
<script src="/templates/yoo_master2/js/footable.js" type="text/javascript"></script>
<script src="/templates/yoo_master2/js/footable.sort.js" type="text/javascript"></script>
<script type="text/javascript">
jQuery(function() {
jQuery('table').footable();
});
</script>
<!-- End FooTable -->
{/source}