<!-- Selected Turnier: 106 -->
<!-- Selected Flight: 0 -->
<!-- Turnier Info: Array
(
    [turnier_id] => 106
    [created_at] => 2025-04-20 10:47:02
    [updated_at] => 2025-04-20 15:47:41
    [datum] => 2025-04-25
    [uhrzeit] => 13:00:00
    [golfplatz] => Grün-Rot (w)
    [info] => 
    [spieler_01] => 13
    [ergebnis_01] => 
    [anwesend_01] => 
    [abwesend_01] => 1
    [spieler_02] => 9
    [ergebnis_02] => 
    [anwesend_02] => 
    [abwesend_02] => 1
    [spieler_03] => 5
    [ergebnis_03] => 
    [anwesend_03] => 
    [abwesend_03] => 1
    [spieler_04] => 6
    [ergebnis_04] => 
    [anwesend_04] => 
    [abwesend_04] => 1
    [spieler_05] => 7
    [ergebnis_05] => 
    [anwesend_05] => 
    [abwesend_05] => 1
    [spieler_06] => 10
    [ergebnis_06] => 
    [anwesend_06] => 
    [abwesend_06] => 1
    [spieler_07] => 12
    [ergebnis_07] => 
    [anwesend_07] => 
    [abwesend_07] => 1
    [spieler_08] => 8
    [ergebnis_08] => 
    [anwesend_08] => 
    [abwesend_08] => 1
    [spieler_09] => 3
    [ergebnis_09] => 
    [anwesend_09] => 1
    [abwesend_09] => 
    [spieler_10] => 11
    [ergebnis_10] => 
    [anwesend_10] => 
    [abwesend_10] => 1
    [spieler_11] => 4
    [ergebnis_11] => 
    [anwesend_11] => 
    [abwesend_11] => 1
    [spieler_12] => 
    [ergebnis_12] => 
    [anwesend_12] => 
    [abwesend_12] => 1
    [spieler_13] => 
    [ergebnis_13] => 
    [anwesend_13] => 
    [abwesend_13] => 
    [spieler_14] => 
    [ergebnis_14] => 
    [anwesend_14] => 
    [abwesend_14] => 
    [spieler_15] => 
    [ergebnis_15] => 
    [anwesend_15] => 
    [abwesend_15] => 
    [spieler_16] => 
    [ergebnis_16] => 
    [anwesend_16] => 
    [abwesend_16] => 
    [spieler_17] => 
    [ergebnis_17] => 
    [anwesend_17] => 
    [abwesend_17] => 
    [spieler_18] => 
    [ergebnis_18] => 
    [anwesend_18] => 
    [abwesend_18] => 
    [spieler_19] => 
    [ergebnis_19] => 
    [anwesend_19] => 
    [abwesend_19] => 
    [spieler_20] => 
    [ergebnis_20] => 
    [anwesend_20] => 
    [abwesend_20] => 
    [spieler_21] => 
    [ergebnis_21] => 
    [anwesend_21] => 
    [abwesend_21] => 
    [spieler_22] => 
    [ergebnis_22] => 
    [anwesend_22] => 
    [abwesend_22] => 
    [spieler_23] => 
    [ergebnis_23] => 
    [anwesend_23] => 
    [abwesend_23] => 
    [spieler_24] => 
    [ergebnis_24] => 
    [anwesend_24] => 
    [abwesend_24] => 
    [spieler_25] => 
    [ergebnis_25] => 
    [anwesend_25] => 
    [abwesend_25] => 
    [spieler_26] => 
    [ergebnis_26] => 
    [anwesend_26] => 
    [abwesend_26] => 
    [spieler_27] => 
    [ergebnis_27] => 
    [anwesend_27] => 
    [abwesend_27] => 
    [spieler_28] => 
    [ergebnis_28] => 
    [anwesend_28] => 
    [abwesend_28] => 
    [spieler_29] => 
    [ergebnis_29] => 
    [anwesend_29] => 
    [abwesend_29] => 
    [spieler_30] => 
    [ergebnis_30] => 
    [anwesend_30] => 
    [abwesend_30] => 
    [spieler_31] => 
    [ergebnis_31] => 
    [anwesend_31] => 
    [abwesend_31] => 
    [spieler_32] => 
    [ergebnis_32] => 
    [anwesend_32] => 
    [abwesend_32] => 
    [golfplatz_name] => Grün-Rot (w)
)
 -->
<!-- Flights Info: Array
(
)
 -->
<!-- Holes Info: Array
(
    [0] => Array
        (
            [loch_id] => 55
            [platz_id] => 3
            [loch_nummer] => 1
            [par] => 4
            [hc] => 5
            [meter] => 342
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-04-09 10:12:38
            [loch_nr] => 1
        )

    [1] => Array
        (
            [loch_id] => 56
            [platz_id] => 3
            [loch_nummer] => 2
            [par] => 4
            [hc] => 3
            [meter] => 380
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:02:51
            [loch_nr] => 2
        )

    [2] => Array
        (
            [loch_id] => 57
            [platz_id] => 3
            [loch_nummer] => 3
            [par] => 3
            [hc] => 9
            [meter] => 175
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-04-09 10:03:39
            [loch_nr] => 3
        )

    [3] => Array
        (
            [loch_id] => 58
            [platz_id] => 3
            [loch_nummer] => 4
            [par] => 5
            [hc] => 7
            [meter] => 520
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 4
        )

    [4] => Array
        (
            [loch_id] => 59
            [platz_id] => 3
            [loch_nummer] => 5
            [par] => 4
            [hc] => 17
            [meter] => 272
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 5
        )

    [5] => Array
        (
            [loch_id] => 60
            [platz_id] => 3
            [loch_nummer] => 6
            [par] => 4
            [hc] => 11
            [meter] => 392
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 6
        )

    [6] => Array
        (
            [loch_id] => 61
            [platz_id] => 3
            [loch_nummer] => 7
            [par] => 5
            [hc] => 15
            [meter] => 456
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 7
        )

    [7] => Array
        (
            [loch_id] => 62
            [platz_id] => 3
            [loch_nummer] => 8
            [par] => 3
            [hc] => 13
            [meter] => 128
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 8
        )

    [8] => Array
        (
            [loch_id] => 63
            [platz_id] => 3
            [loch_nummer] => 9
            [par] => 4
            [hc] => 1
            [meter] => 354
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 9
        )

    [9] => Array
        (
            [loch_id] => 64
            [platz_id] => 3
            [loch_nummer] => 10
            [par] => 4
            [hc] => 4
            [meter] => 341
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 10
        )

    [10] => Array
        (
            [loch_id] => 65
            [platz_id] => 3
            [loch_nummer] => 11
            [par] => 4
            [hc] => 10
            [meter] => 358
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 11
        )

    [11] => Array
        (
            [loch_id] => 66
            [platz_id] => 3
            [loch_nummer] => 12
            [par] => 5
            [hc] => 14
            [meter] => 446
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 12
        )

    [12] => Array
        (
            [loch_id] => 67
            [platz_id] => 3
            [loch_nummer] => 13
            [par] => 3
            [hc] => 18
            [meter] => 166
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 13
        )

    [13] => Array
        (
            [loch_id] => 68
            [platz_id] => 3
            [loch_nummer] => 14
            [par] => 4
            [hc] => 6
            [meter] => 369
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 14
        )

    [14] => Array
        (
            [loch_id] => 69
            [platz_id] => 3
            [loch_nummer] => 15
            [par] => 5
            [hc] => 12
            [meter] => 504
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 15
        )

    [15] => Array
        (
            [loch_id] => 70
            [platz_id] => 3
            [loch_nummer] => 16
            [par] => 4
            [hc] => 8
            [meter] => 344
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 16
        )

    [16] => Array
        (
            [loch_id] => 71
            [platz_id] => 3
            [loch_nummer] => 17
            [par] => 3
            [hc] => 16
            [meter] => 185
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 17
        )

    [17] => Array
        (
            [loch_id] => 72
            [platz_id] => 3
            [loch_nummer] => 18
            [par] => 4
            [hc] => 2
            [meter] => 389
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 18
        )

)
 -->
<!-- Debug Info:
Players: Array
(
)

Holes: Array
(
    [0] => Array
        (
            [loch_id] => 55
            [platz_id] => 3
            [loch_nummer] => 1
            [par] => 4
            [hc] => 5
            [meter] => 342
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-04-09 10:12:38
            [loch_nr] => 1
        )

    [1] => Array
        (
            [loch_id] => 56
            [platz_id] => 3
            [loch_nummer] => 2
            [par] => 4
            [hc] => 3
            [meter] => 380
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:02:51
            [loch_nr] => 2
        )

    [2] => Array
        (
            [loch_id] => 57
            [platz_id] => 3
            [loch_nummer] => 3
            [par] => 3
            [hc] => 9
            [meter] => 175
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-04-09 10:03:39
            [loch_nr] => 3
        )

    [3] => Array
        (
            [loch_id] => 58
            [platz_id] => 3
            [loch_nummer] => 4
            [par] => 5
            [hc] => 7
            [meter] => 520
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 4
        )

    [4] => Array
        (
            [loch_id] => 59
            [platz_id] => 3
            [loch_nummer] => 5
            [par] => 4
            [hc] => 17
            [meter] => 272
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 5
        )

    [5] => Array
        (
            [loch_id] => 60
            [platz_id] => 3
            [loch_nummer] => 6
            [par] => 4
            [hc] => 11
            [meter] => 392
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 6
        )

    [6] => Array
        (
            [loch_id] => 61
            [platz_id] => 3
            [loch_nummer] => 7
            [par] => 5
            [hc] => 15
            [meter] => 456
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 7
        )

    [7] => Array
        (
            [loch_id] => 62
            [platz_id] => 3
            [loch_nummer] => 8
            [par] => 3
            [hc] => 13
            [meter] => 128
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 8
        )

    [8] => Array
        (
            [loch_id] => 63
            [platz_id] => 3
            [loch_nummer] => 9
            [par] => 4
            [hc] => 1
            [meter] => 354
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 9
        )

    [9] => Array
        (
            [loch_id] => 64
            [platz_id] => 3
            [loch_nummer] => 10
            [par] => 4
            [hc] => 4
            [meter] => 341
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 10
        )

    [10] => Array
        (
            [loch_id] => 65
            [platz_id] => 3
            [loch_nummer] => 11
            [par] => 4
            [hc] => 10
            [meter] => 358
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 11
        )

    [11] => Array
        (
            [loch_id] => 66
            [platz_id] => 3
            [loch_nummer] => 12
            [par] => 5
            [hc] => 14
            [meter] => 446
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 12
        )

    [12] => Array
        (
            [loch_id] => 67
            [platz_id] => 3
            [loch_nummer] => 13
            [par] => 3
            [hc] => 18
            [meter] => 166
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 13
        )

    [13] => Array
        (
            [loch_id] => 68
            [platz_id] => 3
            [loch_nummer] => 14
            [par] => 4
            [hc] => 6
            [meter] => 369
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 14
        )

    [14] => Array
        (
            [loch_id] => 69
            [platz_id] => 3
            [loch_nummer] => 15
            [par] => 5
            [hc] => 12
            [meter] => 504
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 15
        )

    [15] => Array
        (
            [loch_id] => 70
            [platz_id] => 3
            [loch_nummer] => 16
            [par] => 4
            [hc] => 8
            [meter] => 344
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 16
        )

    [16] => Array
        (
            [loch_id] => 71
            [platz_id] => 3
            [loch_nummer] => 17
            [par] => 3
            [hc] => 16
            [meter] => 185
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 17
        )

    [17] => Array
        (
            [loch_id] => 72
            [platz_id] => 3
            [loch_nummer] => 18
            [par] => 4
            [hc] => 2
            [meter] => 389
            [created_at] => 2025-03-29 09:26:56
            [updated_at] => 2025-03-29 12:07:43
            [loch_nr] => 18
        )

)

-->
<!DOCTYPE html>
<html>
<head>
    <title>Livescoring</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css">
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.0/font/bootstrap-icons.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
    <style>
        /* Hintergrund für die gesamte Seite */
        body {
            background-color: #f0f2f5;
            color: #333;
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            padding-top: 0; /* Padding entfernt */
            margin: 0; /* Margin hinzugefügt */
        }
        
        /* Container-Stil */
        .container-fluid {
            padding: 25px;
            max-width: 1800px;
            margin: 0 auto;
            margin-top: 20px; /* Margin-top hinzugefügt */
        }
        
        /* Mobile Ansicht - Labels ausblenden */
        @media (max-width: 767px) {
            .form-group label {
                display: none !important;
            }
        }
        
        /* PIN Modal Styling */
        #pinModal .modal-dialog {
            max-width: 400px;
        }
        
        #pinModal .pin-input-container {
            display: flex;
            justify-content: center;
            margin: 20px 0;
        }
        
        #pinModal .pin-input {
            width: 50px;
            height: 60px;
            margin: 0 5px;
            text-align: center;
            font-size: 24px;
            border: 2px solid #ccc;
            border-radius: 5px;
        }
        
        #pinModal .pin-input:focus {
            border-color: #28a745;
            outline: none;
        }
        
        #pinError {
            color: #dc3545;
            text-align: center;
            display: none;
            margin-bottom: 15px;
        }
        
        /* Kartendesign */
        .card {
            border: none;
            border-radius: 8px;
            box-shadow: 0 4px 12px rgba(0,0,0,0.1);
            margin-bottom: 25px;
            background-color: white;
        }
        
        .scoring-button {
            margin-left: 10px;
        }

        .flight-header {
            display: flex;
            justify-content: space-between;
            align-items: center;
        }
        
        /* Container-Stil */
        .container-fluid {
            padding: 25px;
            max-width: 1800px;
            margin: 0 auto;
        }
        
        /* Kartendesign */
        .card {
            border: none;
            border-radius: 8px;
            box-shadow: 0 4px 12px rgba(0,0,0,0.1);
            margin-bottom: 25px;
            background-color: white;
        }
        
        .card-header {
            background-color: #343a40;
            color: white;
            border-top-left-radius: 8px !important;
            border-top-right-radius: 8px !important;
            padding: 12px 20px;
        }
        
        .card-body {
            padding: 20px;
        }
        
        /* Formularelemente */
        .form-control {
            border-radius: 4px;
            border: 1px solid #ced4da;
        }
        
        /* Buttons */
        .btn-secondary {
            background-color: #495057;
            border-color: #495057;
        }
        
        .btn-secondary:hover {
            background-color: #343a40;
            border-color: #343a40;
        }
        
        /* Score-Tabelle */
        .score-table {
            width: 100%;
            table-layout: fixed;
            border-collapse: collapse;
            font-size: 0.9rem;
            box-shadow: 0 4px 8px rgba(0,0,0,0.1);
            background-color: white;
            margin: 0;
        }
        
        .score-table th, .score-table td {
            padding: 6px 4px;
            text-align: center;
            border: 1px solid #ddd;
        }
        
        .score-table th:first-child, 
        .score-table td:first-child,
        .score-table .player-name,
        .score-table .par-row th:first-child,
        .score-table .hc-row th:first-child,
        .score-table .meter-row th:first-child {
            padding-left: 12px !important;
            padding-right: 12px !important;
        }
        
        /* Spezielle Anpassung für Handys im Querformat */
        @media (max-width: 900px) and (orientation: landscape) {
            .score-table th:first-child,
            .score-table td:first-child {
                width: 120px; /* Breitere Spalte im Querformat */
            }
        }
        
        /* Überschriftenzeile */
        .score-table thead tr:first-child {
            background-color: #495057;
        }
        
        .score-table thead tr:first-child th {
            color: white;
            font-weight: bold;
            font-size: 0.9rem;
        }
        
        .score-table thead tr:first-child th:first-child {
            background-color: #495057;
            color: white;
            font-weight: bold;
            z-index: 2; /* Höherer z-index für die Ecken-Zelle */
        }
        
        .score-table th.hole-header {
            width: 40px;
            min-width: 40px;
            background-color: #343a40;
            color: white;
            font-weight: bold;
        }
        
        .score-table th.total-header {
            width: 50px;
            background-color: #212529;
            color: white;
            font-weight: bold;
        }
        
        /* Par-Zeile */
        .score-table .par-row th {
            background-color: #4caf50;
            color: white;
            font-weight: bold;
            font-size: 0.9rem;
        }
        
        .score-table .par-row th:first-child {
            background-color: #388e3c;
            text-align: right;
            position: sticky;
            left: 0;
            z-index: 1;
        }
        
        .par-info {
            background-color: #c8e6c9;
            color: #1b5e20;
            font-weight: bold;
        }
        
        .total-par {
            background-color: #a5d6a7;
            color: #1b5e20;
            font-weight: bold;
        }
        
        /* HC-Zeile */
        .score-table .hc-row th {
            background-color: #2196f3;
            color: white;
            font-size: 0.9rem;
        }
        
        .score-table .hc-row th:first-child {
            background-color: #1976d2;
            font-weight: bold;
            text-align: right;
            position: sticky;
            left: 0;
            z-index: 1;
        }
        
        .hcp-info {
            background-color: #bbdefb;
            color: #0d47a1;
        }
        
        /* Meter-Zeile */
        .score-table .meter-row th {
            background-color: #ff9800;
            color: white;
            font-size: 0.9rem;
        }
        
        .score-table .meter-row th:first-child {
            background-color: #f57c00;
            font-weight: bold;
            text-align: right;
            position: sticky;
            left: 0;
            z-index: 1;
        }
        
        .meter-info {
            background-color: #ffe0b2;
            color: #e65100;
        }
        
        .total-meter {
            background-color: #ffcc80;
            color: #e65100;
            font-weight: bold;
        }
        
        /* Spieler-Zeilen mit verschiedenen Grautönen */
        .score-table tbody tr:nth-child(4n+1) {
            background-color: #6c757d;
        }
        
        .score-table tbody tr:nth-child(4n+2) {
            background-color: #5a6268;
        }
        
        .score-table tbody tr:nth-child(4n+3) {
            background-color: #495057;
        }
        
        .score-table tbody tr:nth-child(4n+4) {
            background-color: #343a40;
        }
        
        /* Styling für die Spieler-Namen in der ersten Spalte */
        .player-name {
            font-weight: bold;
            text-shadow: 0 0 2px rgba(0,0,0,0.3);
            color: white;
            position: sticky;
            left: 0;
            z-index: 1;
            white-space: nowrap;
            overflow: hidden;
            text-overflow: ellipsis;
            padding-left: 12px;
            padding-right: 12px;
        }
        
        /* Weiße Schrift für die Gesamtpunktzahl */
        .score-table tbody tr .total-score {
            color: white;
            font-weight: bold;
            background-color: #dc3545 !important; /* Rote Farbe (Bootstrap danger) */
        }
        
        /* Spielernamen-Zellen einfärben (dunklere Variante) */
        .score-table tbody tr:nth-child(4n+1) .player-name {
            background-color: #5a6268;
        }
        
        .score-table tbody tr:nth-child(4n+2) .player-name {
            background-color: #495057;
        }
        
        .score-table tbody tr:nth-child(4n+3) .player-name {
            background-color: #343a40;
        }
        
        .score-table tbody tr:nth-child(4n+4) .player-name {
            background-color: #212529;
        }
        
        /* Score-Zellen einfärben (Standard-Grau mit weißem Input) */
        .score-table tbody tr .score-cell {
            padding: 2px !important;
        }
        
        .score-table tbody tr:nth-child(4n+1) .score-cell {
            background-color: #6c757d;
        }
        
        .score-table tbody tr:nth-child(4n+2) .score-cell {
            background-color: #5a6268;
        }
        
        .score-table tbody tr:nth-child(4n+3) .score-cell {
            background-color: #495057;
        }
        
        .score-table tbody tr:nth-child(4n+4) .score-cell {
            background-color: #343a40;
        }
        
        /* Total Score Zellen einfärben (hervorgehobenes Grau) - überschrieben durch die rote Hintergrundfarbe oben */
        .score-table tbody tr:nth-child(4n+1) .total-score,
        .score-table tbody tr:nth-child(4n+2) .total-score,
        .score-table tbody tr:nth-child(4n+3) .total-score,
        .score-table tbody tr:nth-child(4n+4) .total-score {
            background-color: #dc3545 !important; /* Rote Farbe (Bootstrap danger) */
            color: white;
            font-weight: bold;
        }
        
        /* Anpassung der Score-Inputs für bessere Sichtbarkeit auf dunklem Hintergrund und mittige Ausrichtung */
        .score-input {
            width: 30px;
            height: 30px;
            text-align: center;
            border: 1px solid #ddd;
            border-radius: 3px;
            padding: 2px;
            font-size: 0.9rem;
            background-color: white;
            color: #343a40;
            display: block;
            margin: 0 auto;
            -webkit-appearance: none;
            -moz-appearance: textfield;
        }
        
        /* Entfernen der Pfeile bei number-Inputs für ein konsistenteres Erscheinungsbild */
        .score-input::-webkit-inner-spin-button, 
        .score-input::-webkit-outer-spin-button { 
            -webkit-appearance: none;
            margin: 0;
        }
        
        /* Hover-Effekt für alle Spielerzeilen */
        .score-table tbody tr:hover {
            background-color: rgba(52, 58, 64, 0.85) !important;
        }
        
        .score-table tbody tr:hover .player-name,
        .score-table tbody tr:hover .score-cell {
            background-color: rgba(33, 37, 41, 0.85) !important;
        }
        
        .score-table tbody tr:hover .total-score {
            background-color: #bd2130 !important; /* Dunkleres Rot beim Hover */
        }
        
        /* Responsive Design für kleine Bildschirme */
        @media (max-width: 1400px) {
            .score-table-container {
                overflow-x: auto;
                max-width: 100%;
            }
            
            .score-table {
                min-width: 1000px;
            }
        }
        
        /* Verbesserte Mobile Ansicht */
        @media (max-width: 768px) {
            .container-fluid {
                padding: 0;
                max-width: 100%;
                display: flex;
                flex-direction: column;
                margin-top: 0;
            }
            
            .controls-section {
                order: 2;
                margin-top: 10px;
            }
            
            .flights-section {
                order: 1;
                margin-top: 0;
                padding-top: 0;
            }
            
            .card {
                border-radius: 0;
                margin-bottom: 15px;
                margin-top: 0;
                box-shadow: none;
                border-left: none;
                border-right: none;
            }

            .card-header {
                border-radius: 0 !important;
                padding-top: 8px;
                padding-bottom: 8px;
            }
            
            .flight-card:first-child {
                margin-top: 0;
            }
            
            .flight-card:first-child .card-header {
                border-top: none;
                padding-top: 10px;
            }
            
            .card-body {
                padding: 10px 5px;
            }
            
            .score-input {
                width: 26px;
                height: 26px;
                font-size: 0.9rem;
                padding: 1px;
            }
            
            .score-table th, .score-table td {
                padding: 4px 1px;
            }
            
            .score-table th:first-child {
                width: 65px; /* Einheitliche Breite auf Tablets (20px schmaler) */
                padding-left: 12px !important;
                padding-right: 12px !important;
            }
            
            .score-table td:first-child {
                padding-left: 12px !important;
                padding-right: 12px !important;
            }
            
            .score-table .player-name,
            .score-table .par-row th:first-child,
            .score-table .hc-row th:first-child,
            .score-table .meter-row th:first-child {
                padding-left: 12px !important;
                padding-right: 12px !important;
            }
            
            h2 {
                font-size: 1.5rem;
                padding-left: 5px;
                margin-bottom: 0.5rem;
            }
            
            h3 {
                font-size: 1.2rem;
                padding-left: 5px;
                margin-bottom: 1rem;
            }
            
            .card-header h5 {
                font-size: 1.1rem;
                margin: 0;
            }
            
            .btn {
                padding: 0.375rem 0.6rem;
                font-size: 0.9rem;
                margin-left: 5px;
            }
            
            .form-inline .form-group {
                margin-bottom: 10px;
                display: block;
                width: 100%;
            }
            
            .form-inline label {
                display: block;
                margin-bottom: 5px;
            }
            
            .form-inline .form-control {
                width: 100%;
                display: block;
            }

            .score-table-container {
                margin: 0 -5px;
                width: calc(100% + 10px);
                max-width: none;
                padding-top: 0;
            }
            
            .flight-card {
                width: 100vw;
                position: relative;
                left: 50%;
                right: 50%;
                margin-left: -50vw;
                margin-right: -50vw;
                margin-top: 0;
                padding-top: 0;
            }
            
            .score-table {
                min-width: 850px;
                font-size: 0.9rem;
            }
            
            .score-table th.total-header {
                width: 40px;
            }
        }
        
        /* Für sehr kleine Bildschirme */
        @media (max-width: 480px) {
            .container-fluid {
                padding: 0;
            }
            
            .card-body {
                padding: 8px 0;
            }
            
            .flights-section {
                margin: 0;
                padding: 0;
            }
            
            .flight-card:first-child .card-header {
                padding-top: 8px;
            }
            
            .score-input {
                width: 22px;
                height: 22px;
                font-size: 0.8rem;
                padding: 0;
            }
            
            .score-table th, .score-table td {
                padding: 3px 1px;
            }
            
            .score-table th:first-child {
                width: 65px; /* Einheitliche Breite auf Smartphones (20px schmaler) */
                padding-left: 12px !important;
                padding-right: 12px !important;
            }
            
            .score-table td:first-child {
                padding-left: 12px !important;
                padding-right: 12px !important;
            }
            
            .score-table .player-name,
            .score-table .par-row th:first-child,
            .score-table .hc-row th:first-child,
            .score-table .meter-row th:first-child {
                padding-left: 12px !important;
                padding-right: 12px !important;
            }
            
            .row {
                margin-left: 0;
                margin-right: 0;
            }

            .col-md-6 {
                padding-left: 5px;
                padding-right: 5px;
            }
            
            .score-table {
                min-width: 800px;
                font-size: 0.8rem;
            }
            
            .score-table thead tr:first-child th,
            .score-table .par-row th,
            .score-table .hc-row th,
            .score-table .meter-row th {
                font-size: 0.8rem;
            }
            
            .score-table th.hole-header {
                width: 22px;
                min-width: 22px;
            }
            
            .score-table th.total-header {
                width: 35px;
            }
        }
        
        /* Spezielle Anpassung für Smartphones im Querformat */
        @media (max-width: 900px) and (min-width: 481px) and (orientation: landscape) {
            .score-table th:first-child,
            .score-table td:first-child,
            .score-table .player-name,
            .score-table .par-row th:first-child,
            .score-table .hc-row th:first-child,
            .score-table .meter-row th:first-child {
                width: 130px !important;
                min-width: 130px !important;
            }
            
            /* Breitere Total-Spalten im Querformat */
            .score-table th.total-header,
            .score-table .front-nine-score,
            .score-table .back-nine-score,
            .score-table .total-score {
                width: 60px !important;
                min-width: 60px !important;
            }
        }
        
        /* Farbkodierung für Scores mit dunklerem Hintergrund und weißer Schrift */
        .under-par {
            background-color: #1565c0 !important; /* Dunkleres Blau */
            color: white !important;
            font-weight: bold !important;
        }
        
        .over-par {
            background-color: #c62828 !important; /* Dunkleres Rot */
            color: white !important;
            font-weight: bold !important;
        }
        
        .double-bogey {
            background-color: #7f0000 !important; /* Sehr dunkles Rot */
            color: white !important;
            font-weight: bold !important;
        }
        
        .par {
            background-color: #2e7d32 !important; /* Dunkleres Grün */
            color: white !important;
            font-weight: bold !important;
        }

        /* Stil für die Zwischensummen - schwarzer Hintergrund mit weißer Schrift */
        .front-nine-score, .back-nine-score {
            background-color: #000000 !important; /* Reines Schwarz */
            color: white !important;
            font-weight: bold !important;
        }

        /* Die Spieler-spezifischen Hintergrundfarben für die Zwischensummen überschreiben */
        .score-table tbody tr:nth-child(4n+1) .front-nine-score,
        .score-table tbody tr:nth-child(4n+1) .back-nine-score,
        .score-table tbody tr:nth-child(4n+2) .front-nine-score,
        .score-table tbody tr:nth-child(4n+2) .back-nine-score,
        .score-table tbody tr:nth-child(4n+3) .front-nine-score,
        .score-table tbody tr:nth-child(4n+3) .back-nine-score,
        .score-table tbody tr:nth-child(4n+4) .front-nine-score,
        .score-table tbody tr:nth-child(4n+4) .back-nine-score {
            background-color: #000000 !important;
            color: white !important;
        }

        /* Grundlegende Eigenschaften für die erste Spalte */
        .score-table th:first-child {
            width: 65px; /* Einheitliche Breite auf Tablets (20px schmaler) */
            text-align: right;
            padding-left: 12px !important;
            padding-right: 12px !important;
            position: sticky;
            left: 0;
            z-index: 1;
        }
        
        .score-table td:first-child {
            text-align: right;
            padding-left: 12px !important;
            padding-right: 12px !important;
            position: sticky;
            left: 0;
            z-index: 1;
        }
        
        /* Einheitliches Padding für alle ersten Spaltenelemente */
        .score-table .player-name,
        .score-table .par-row th:first-child,
        .score-table .hc-row th:first-child,
        .score-table .meter-row th:first-child {
            padding-left: 12px !important;
            padding-right: 12px !important;
        }
    </style>
</head>
<body>
    <nav class="navbar navbar-expand-lg navbar-dark bg-success">
    <div class="container">
        <a class="navbar-brand" href="index.php">⛳ Bämbel</a>
        <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav">
            <span class="navbar-toggler-icon"></span>
        </button>
        <div class="collapse navbar-collapse" id="navbarNav">
            <ul class="navbar-nav ms-auto">
                <li class="nav-item">
                    <a class="nav-link" href="index.php">Home</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="gespeicherte_turniere.php">Turniere</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="anwesend.php">Teilnehmen</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="ranking_netto.php">Ergebnisse</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="livescoring.php">Livescoring</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="spieler.php">Spieler</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="admin/index.php"><i class="bi bi-gear"></i> Admin</a>
                </li>
                                    <li class="nav-item">
                        <a class="nav-link" href="login.php"><i class="bi bi-box-arrow-in-right"></i> Anmelden</a>
                    </li>
                            </ul>
        </div>
    </div>
</nav>     
    <div class="container-fluid px-md-4 px-0 mt-md-4">
        <!-- Navigation und Steuerelemente Block -->
        <div class="controls-section d-flex flex-column order-md-1 order-2 mb-md-0 mt-md-0 mt-2">
            <div class="d-flex mb-2">
                <a href="ranking_netto.php?turnier_id=106" class="btn btn-success mr-2">
                    <i class="fas fa-trophy mr-1"></i> Platzierung
                </a>
                <a href="index.php" class="btn btn-secondary">
                    <i class="fas fa-arrow-left mr-1"></i> Home
                </a>
            </div>
            
            <!-- Turnier- und Flight-Auswahl -->
            <div class="card mb-4">
                <div class="card-body py-3 px-md-3 px-2">
                    <form method="GET">
                        <div class="row mx-0">
                                                        <div class="col-md-6 mb-2">
                                <div class="form-group">
                                    <label for="flight" class="d-block d-md-block d-none mb-1">Flight:</label>
                                    <select name="flight" id="flight" class="form-control w-100" onchange="this.form.submit()">
                                        <option value="0">Alle Flights</option>
                                                                            </select>
                                </div>
                            </div>
                            
                            <div class="col-md-6 mb-2">
                                <div class="form-group">
                                    <label for="turnier_id" class="d-block d-md-block d-none mb-1">Turnier:</label>
                                    <select name="turnier_id" id="turnier_id" class="form-control w-100" onchange="this.form.submit()">
                                        <option value="">Bitte wählen...</option>
                                                                                    <option value="106" 
                                                    selected>
                                                25.04.2025 - Grün-Rot (w)                                            </option>
                                                                                    <option value="110" 
                                                    >
                                                21.04.2025 - Rethmar Gelb                                            </option>
                                                                                    <option value="100" 
                                                    >
                                                18.04.2025 - Blau-Grün (w)                                            </option>
                                                                                    <option value="104" 
                                                    >
                                                17.04.2025 - Gloria New Course (gelb)                                            </option>
                                                                            </select>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>

        <!-- Flights Anzeige Block -->
        <div class="flights-section order-md-2 order-1 mb-2">
                            <h2 class="d-none d-md-block">Grün-Rot (w) - Livescoring</h2>
                <h3 class="d-none d-md-block">Datum: 25. April 2025</h3>

                                    <div class="alert alert-warning">
                        Keine Flights für dieses Turnier gefunden
                    </div>
                                    </div>

        <hr class="d-md-none my-3">
    </div>

    <!-- PIN-Modal für Authentifizierung -->
    <div class="modal fade" id="pinModal" tabindex="-1" role="dialog" aria-labelledby="pinModalLabel" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="pinModalLabel">PIN eingeben</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Schließen">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <p class="text-center">Bitte geben Sie die 4-stellige PIN ein, um Scores bearbeiten zu können.</p>
                    <div class="pin-input-container">
                        <input type="password" maxlength="1" class="pin-input" id="pin1" data-next="pin2">
                        <input type="password" maxlength="1" class="pin-input" id="pin2" data-next="pin3" data-prev="pin1">
                        <input type="password" maxlength="1" class="pin-input" id="pin3" data-next="pin4" data-prev="pin2">
                        <input type="password" maxlength="1" class="pin-input" id="pin4" data-prev="pin3">
                    </div>
                    <div id="pinError">Falsche PIN. Bitte versuchen Sie es erneut.</div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Abbrechen</button>
                    <button type="button" class="btn btn-primary" id="submitPin">Bestätigen</button>
                </div>
            </div>
        </div>
    </div>

    <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
    <script>
        $(document).ready(function() {
            console.log('Livescoring initialized for turnier_id: 106');

            // Speichern des aktiven Flights für den Scoring-Modus
            let activeScoringFlight = null;
            const correctPin = "1234";
            
            // Überprüfe beim Laden der Seite, ob es authentifizierte Flights gibt und aktiviere den Scoring-Modus
            
            // Load existing scores when page loads
            loadScores();

            // PIN-Modal Funktionalität
            $('.pin-input').on('keyup', function(e) {
                const $this = $(this);
                
                // Automatisch zum nächsten Feld springen, wenn eine Ziffer eingegeben wurde
                if ($this.val().length === 1) {
                    const nextId = $this.data('next');
                    if (nextId) {
                        $('#' + nextId).focus();
                    } else {
                        // Wenn es kein nächstes Feld gibt (letztes Feld), bestätigen
                        $('#submitPin').focus();
                    }
                }
                
                // Bei Backspace zum vorherigen Feld springen
                if (e.keyCode === 8 && $this.val().length === 0) {
                    const prevId = $this.data('prev');
                    if (prevId) {
                        $('#' + prevId).focus();
                    }
                }
            });
            
            // PIN-Modal: Enter-Taste zum Bestätigen
            $('.pin-input').on('keydown', function(e) {
                if (e.keyCode === 13) { // Enter-Taste
                    e.preventDefault();
                    $('#submitPin').click();
                }
            });
            
            // PIN überprüfen beim Klick auf Bestätigen
            $('#submitPin').on('click', function() {
                const enteredPin = $('#pin1').val() + $('#pin2').val() + $('#pin3').val() + $('#pin4').val();
                
                if (enteredPin === correctPin) {
                    // PIN korrekt
                    $('#pinError').hide();
                    $('#pinModal').modal('hide');
                    
                    // Scoring-Modus aktivieren für den ausgewählten Flight
                    enableScoringMode(activeScoringFlight);
                    
                    // PIN-Felder zurücksetzen
                    $('.pin-input').val('');
                } else {
                    // PIN falsch
                    $('#pinError').show();
                    $('.pin-input').val('');
                    $('#pin1').focus();
                }
            });

            // Modal schließen - zurücksetzen
            $('#pinModal').on('hidden.bs.modal', function() {
                $('#pinError').hide();
                $('.pin-input').val('');
                
                // Wenn kein Scoring-Modus aktiv ist, Button-Text zurücksetzen
                if (!$('.score-input[data-flight="' + activeScoringFlight + '"]').first().prop('readonly') === false) {
                    $('button[data-flight="' + activeScoringFlight + '"]').text('Scoring starten');
                }
            });

            // Event-Handler für die Taste "Enter"
            $('.score-input').on('keydown', function(e) {
                if (e.keyCode === 13 || e.which === 13) { // Enter-Taste wurde gedrückt
                    e.preventDefault(); // Standard-Aktion verhindern
                    
                    var $this = $(this);
                    var currentFlight = $this.data('flight');
                    var currentHole = parseInt($this.data('hole'));
                    var currentPosition = parseInt($this.data('position'));
                    
                    // Alle Spieler im aktuellen Flight
                    var $playersInFlight = $('.score-input[data-flight="' + currentFlight + '"][data-hole="' + currentHole + '"]');
                    var playerCount = $playersInFlight.length;
                    
                    // Finde den nächsten Spieler in der gleichen Spalte (gleiches Loch)
                    // Wir verwenden die Attributposition, um die Spieler in der richtigen Reihenfolge zu finden
                    var nextPosition = currentPosition + 1;
                    var $nextInput = $('.score-input[data-flight="' + currentFlight + '"][data-hole="' + currentHole + '"][data-position="' + nextPosition + '"]');
                    
                    if ($nextInput.length > 0) {
                        // Es gibt einen nächsten Spieler für dieses Loch
                        $nextInput.focus();
                    } else {
                        // Wir sind am Ende der Spielerliste für dieses Loch
                        // Zum ersten Spieler des nächsten Lochs wechseln (wenn es existiert)
                        if (currentHole < 18) {
                            // Zum nächsten Loch wechseln, erster Spieler
                            var $firstPlayerNextHole = $('.score-input[data-flight="' + currentFlight + '"][data-hole="' + (currentHole + 1) + '"][data-position="1"]');
                            if ($firstPlayerNextHole.length > 0) {
                                $firstPlayerNextHole.focus();
                            }
                        }
                    }
                    return false;
                }
            });

            // Event-Handler für Score-Eingabe mit Unterstützung zum Löschen
            $('.score-input').on('change', function() {
                // Nur speichern, wenn im Scoring-Modus
                if ($(this).prop('readonly')) {
                    return;
                }

                const input = $(this);
                const score = input.val() ? parseInt(input.val()) : null; // Null wenn Feld leer ist
                const playerId = input.closest('tr').data('player-id');
                const holeNr = parseInt(input.data('hole'));
                const par = parseInt(input.data('par'));

                console.log('Saving score:', {
                    turnier_id: 106,
                    spieler_id: playerId,
                    loch_nr: holeNr,
                    score: score
                });

                // Farbig markieren basierend auf Par, bei leerem Feld Klassen entfernen
                colorScoreInput(input, score, par);

                // Speichern oder Löschen in der Datenbank
                $.ajax({
                    url: 'save_score.php',
                    method: 'POST',
                    data: {
                        turnier_id: 106,
                        spieler_id: playerId,
                        loch_nr: holeNr,
                        score: score,
                        delete: score === null // Löschung anfordern, wenn score null ist
                    },
                    success: function(response) {
                        console.log('Save response:', response);
                        if (response.success) {
                            // Visuelles Feedback
                            const originalBg = input.css('background-color');
                            input.css('background-color', '#d4edda');
                            setTimeout(function() {
                                input.css('background-color', originalBg);
                            }, 1000);
                            // Update total score
                            updateTotalScore(input.closest('tr'));
                        } else {
                            console.error('Save error:', response.error);
                            input.css('background-color', '#f8d7da');
                        }
                    },
                    error: function(xhr, status, error) {
                        console.error('Save error:', error);
                        input.css('background-color', '#f8d7da');
                    }
                });
            });

            // Funktion zum Aktivieren des Scoring-Modus
            function enableScoringMode(flightNr) {
                if (!flightNr) return;
                
                // readonly-Attribut von allen Scoring-Inputs im Flight entfernen
                $('.score-input[data-flight="' + flightNr + '"]').prop('readonly', false);
                
                // Button-Text ändern und auf rot umstellen
                const $button = $('button[data-flight="' + flightNr + '"]');
                $button.text('Scoring beenden');
                $button.removeClass('btn-primary').addClass('btn-danger');
                $button.data('is-authenticated', true);
                
                // Session per AJAX aktualisieren
                $.ajax({
                    url: 'livescoring.php',
                    method: 'POST',
                    data: {
                        action: 'toggle_scoring',
                        flight: flightNr,
                        enable: true
                    },
                    dataType: 'json'
                });
            }
            
            // Funktion zum Deaktivieren des Scoring-Modus
            function disableScoringMode(flightNr) {
                if (!flightNr) return;
                
                // readonly-Attribut für alle Scoring-Inputs im Flight setzen
                $('.score-input[data-flight="' + flightNr + '"]').prop('readonly', true);
                
                // Button-Text ändern und zurück auf blau stellen
                const $button = $('button[data-flight="' + flightNr + '"]');
                $button.text('Scoring starten');
                $button.removeClass('btn-danger').addClass('btn-primary');
                $button.data('is-authenticated', false);
                
                // ZUVERLÄSSIGE METHODE: Direkte Umleitung mit Parameter zum Deaktivieren des Scoring-Modus
                // Diese Methode ist sicherer als der AJAX-Call, da sie garantiert, dass die Session aktualisiert wird
                window.location.href = window.location.pathname + 
                    '?turnier_id=106' + 
                    (0 ? '&flight=0' : '') + 
                    '&scoring_disable=1&flight=' + flightNr;
                
                // AJAX-Call als Backup wird nicht mehr ausgeführt, da die Seite sofort umgeleitet wird
            }
            
            // Funktion zum Beenden aller Scoring-Modi (nützlich beim Verlassen der Seite)
            function disableAllScoringModes() {
                // Da wir jetzt per Redirect arbeiten, machen wir hier nichts mehr
                // Die einzelnen Buttons müssen manuell geklickt werden
                return true;
            }
            
            // Beim Verlassen der Seite keine Aktion mehr nötig, da wir mit Redirect arbeiten
            // $(window).on('beforeunload', function() {
            //    disableAllScoringModes();
            // });

            // Toggle-Funktion für den Scoring-Modus (wird von den Flight-Buttons aufgerufen)
            window.toggleScoringMode = function(flightNr) {
                const $button = $('button[data-flight="' + flightNr + '"]');
                const isAuthenticated = $button.data('is-authenticated') === true || $button.data('is-authenticated') === 'true';
                
                if (!isAuthenticated) {
                    // Wenn nicht authentifiziert, dann PIN-Abfrage zum Aktivieren
                    activeScoringFlight = flightNr;
                    $('#pinModal').modal('show');
                } else {
                    // Wenn bereits authentifiziert, dann deaktivieren
                    disableScoringMode(flightNr);
                }
            };

            // Funktion zum Farbig-Markieren der Scores basierend auf Par
            function colorScoreInput(input, score, par) {
                // Alle Klassen entfernen
                input.removeClass('under-par par over-par double-bogey');
                
                if (!score || !par) return; // Wenn kein Score oder Par vorhanden, nichts markieren
                
                if (score < par) {
                    // Birdie oder Eagle (1 oder mehr unter Par)
                    input.addClass('under-par');
                } else if (score === par) {
                    // Par
                    input.addClass('par');
                } else if (score === par + 1) {
                    // Bogey (1 über Par)
                    input.addClass('over-par');
                } else {
                    // Doppelbogey oder schlechter (2 oder mehr über Par)
                    input.addClass('double-bogey');
                }
            }

            function loadScores() {
                console.log('Loading scores...');
                $.ajax({
                    url: 'get_scores.php',
                    method: 'GET',
                    data: { 
                        turnier_id: 106 
                    },
                    dataType: 'json',
                    cache: false,
                    success: function(scores) {
                        console.log('Received scores:', scores);
                        if (Array.isArray(scores)) {
                            scores.forEach(function(score) {
                                const selector = `tr[data-player-id="${score.spieler_id}"] input[data-hole="${score.loch_nr}"]`;
                                const input = $(selector);
                                if (input.length) {
                                    input.val(score.score);
                                    // Farbig markieren basierend auf Par
                                    const par = parseInt(input.data('par'));
                                    colorScoreInput(input, score.score, par);
                                }
                            });
                            
                            // Update all totals
                            $('tr[data-player-id]').each(function() {
                                updateTotalScore($(this));
                            });
                        }
                    },
                    error: function(xhr, status, error) {
                        console.error('Load error:', error);
                    }
                });
            }

            // Verbesserte Funktion zum Speichern der Gesamtergebnisse
            function saveTotalScores() {
                console.log('Saving total scores...');
                
                // Sammle Daten über alle Spieler und ihre Scores
                const playerScores = [];
                
                $('tr[data-player-id]').each(function() {
                    const row = $(this);
                    const playerId = row.data('player-id');
                    
                    // Prüfe, ob der Spieler überhaupt gültige Scores hat
                    let hasValidScores = false;
                    row.find('.score-input').each(function() {
                        if ($(this).val()) {
                            hasValidScores = true;
                            return false; // Breche die each-Schleife ab, sobald ein gültiger Score gefunden wurde
                        }
                    });
                    
                    // Berechne die Gesamtsumme
                    const totalScore = parseInt(row.find('.total-score').text()) || 0;
                    
                    playerScores.push({
                        spieler_id: playerId,
                        total_score: totalScore,
                        has_valid_scores: hasValidScores
                    });
                });
                
                $.ajax({
                    url: 'save_total_scores.php',
                    method: 'POST',
                    data: { 
                        turnier_id: 106,
                        player_scores: JSON.stringify(playerScores)
                    },
                    success: function(response) {
                        console.log('Total scores saved:', response);
                        if (response.success) {
                            // Optional: Visuelles Feedback
                            $('.total-score').css('color', 'green');
                            setTimeout(function() {
                                $('.total-score').css('color', '');
                            }, 1000);
                        } else {
                            console.error('Error saving totals:', response.error);
                        }
                    },
                    error: function(xhr, status, error) {
                        console.error('Error saving totals:', error);
                    }
                });
            }

            // Funktion zum Berechnen des Gesamtergebnisses und der Zwischensummen
            function updateTotalScore(row) {
                let frontNineTotal = 0;
                let backNineTotal = 0;
                let hasValidScores = false;
                
                // Vordere 9 Löcher berechnen (1-9)
                row.find('.score-input').each(function(index) {
                    const value = $(this).val();
                    if (value) {
                        hasValidScores = true;
                        if (index < 9) { // Löcher 1-9
                            frontNineTotal += parseInt(value) || 0;
                        } else if (index >= 9 && index < 18) { // Löcher 10-18
                            backNineTotal += parseInt(value) || 0;
                        }
                    }
                });
                
                // Zwischensummen und Gesamtsumme aktualisieren
                row.find('.front-nine-score').text(frontNineTotal);
                row.find('.back-nine-score').text(backNineTotal);
                row.find('.total-score').text(frontNineTotal + backNineTotal);
                
                // Markiere die Zeile für die verbesserte Erkennung
                if (hasValidScores) {
                    row.attr('data-has-scores', 'true');
                } else {
                    row.attr('data-has-scores', 'false');
                }
                
                // Speichere Gesamtergebnisse nach jeder Änderung
                saveTotalScores();
            }

            // Auto-refresh every 30 seconds
            setInterval(loadScores, 30000);
        });
    </script>
</body>
</html>