ANMELDUNGEN SALZBURG OPEN

>> FIRST PAY, FIRST PLAY!!

* Gruppe: Ein Gruppenwunsch, den wir versuchen zu erfüllen. Bitte um Verständnis wenn wir nicht alle Wünsche erfüllen können.
Die endgültige Gruppeneinteilung wird ca. 5 Tage vor dem Turnierstart veröffentlicht.

HINWEIS: Alle Zahlungen wurden bis zum 23.08.2018 berücksichtigt!

Zur Gruppeneinteilung

ACHTUNG: "First pay - first play" - Heute noch anmelden und bezahlen, erst dann ist Dir dein Startplatz sicher!

{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.id AS ID,
    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 = 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 NOT BETWEEN '3' AND '5' 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 ID");
;
 
$fields_num = mysqli_field_count($result, dblink);

 
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" width="20px">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">Status <span class="footable-sort-indicator"></span></th><th class="footable-sortable" data-hide="phone, tablet">Datum <span class="footable-sort-indicator"></span></th><th class="footable-sortable" data-hide="phone" width="40px">Land <span class="footable-sort-indicator"></span></th><th class="footable-last-column footable-sortable" data-hide="phone" width="150px">Turnier <span class="footable-sort-indicator"></span></th><th class="footable-last-column footable-sortable" data-hide="phone" width="150px">Gruppe* <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['STATUS'].'</td><td class="footable-visible">'.$data['Datum'].'</td><td class="footable-visible">'.$data['Land'].'</td><td class="footable-visible">'.$data['Turnier'].'</td><td class="footable-visible">'.$data['Gruppe*'].'</td>';
 
echo'</tr>';
 
}
 
echo "</tbody></table></div>";
 
?>

<!-- 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}