Logo Kugelrund Billardcenter

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}

Logo small