Logo Kugelrund Billardcenter

Warteliste

Aufgrund der starken Anfrage ist das Teilnehmerfeld zu den SALZBURG OPEN 2018 bereits voll. GROßARTIG, ihr seid SPITZE!!!

Wir haben daher nachfolgend eine Warteliste aufgeführt, die sich automatisch nach Datum des Zahlungseingang sortiert. >> FIRST PAY, FIRST PLAY!!

{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 NOT BETWEEN '1' AND '4' AND course_id = 5
GROUP BY a.first_name, a.last_name, s.translation, DATE(a.DATE)
HAVING turnier = 'SALZBURG OPEN 2018'
ORDER BY a.DATE");
;
 
$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">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">Land <span class="footable-sort-indicator"></span></th><th class="footable-last-column footable-sortable" data-hide="phone">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['Gruppe*'].'</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 async src="/./livescore/js/bootstrap-tab.js" type="text/javascript"></script>
<script src="/./livescore/js/demos.js" type="text/javascript"></script>
<script type="text/javascript">
jQuery(function() {
jQuery('table').footable();
});
</script>
<!-- End FooTable -->
{/source}

{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 = '4' AND course_id = 5
GROUP BY a.first_name, a.last_name, s.translation, DATE(a.DATE)
HAVING turnier = 'SALZBURG OPEN 2018'
ORDER BY a.DATE");
;
 
$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">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">Land <span class="footable-sort-indicator"></span></th><th class="footable-last-column footable-sortable" data-hide="phone">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['Gruppe*'].'</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 async src="/./livescore/js/bootstrap-tab.js" type="text/javascript"></script>
<script src="/./livescore/js/demos.js" type="text/javascript"></script>
<script type="text/javascript">
jQuery(function() {
jQuery('table').footable();
});
</script>
<!-- End FooTable -->
{/source}

Logo small