[19-Feb-2026 16:36:03 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1473,"tournoi_id":1,"e1":1,"e2":8,"s1_raw":"0","s2_raw":"0","phase_text":"Éliminatoire : Quarts de finale"}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":true,"conteste":false,"egalite":true}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":null,"points_e1":0,"points_e2":0,"vainqueur_id":1,"elim_loser_id":8,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1032","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"1","emarge":"1","j":"3","points":"3","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1039","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"8","emarge":"1","j":"3","points":"3","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":3,"new_points_e1":3,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":3,"new_points_e2":3,"new_ratio_e2":0,"new_elim_e2":1}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1473,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=1 WHERE id=1473 LIMIT 1"}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1473,"sent_to":[1,9],"isElim":true,"conteste":false,"egalite":true,"vainqueur_id":1,"elim_loser_id":8}
[19-Feb-2026 16:36:03 Europe/Paris] Étape 4 OK match 1473 — phaseElim=1, s1=0, s2=0, gagnant=1, elim=8
[19-Feb-2026 16:36:03 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1474,"tournoi_id":1,"e1":2,"e2":7,"s1_raw":"0","s2_raw":"0","phase_text":"Éliminatoire : Quarts de finale"}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":true,"conteste":false,"egalite":true}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":null,"points_e1":0,"points_e2":0,"vainqueur_id":7,"elim_loser_id":2,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1033","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"2","emarge":"1","j":"3","points":"3","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1038","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"7","emarge":"1","j":"3","points":"3","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":3,"new_points_e1":3,"new_ratio_e1":0,"new_elim_e1":1,"new_j_e2":3,"new_points_e2":3,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1474,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=7 WHERE id=1474 LIMIT 1"}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1474,"sent_to":[8,16],"isElim":true,"conteste":false,"egalite":true,"vainqueur_id":7,"elim_loser_id":2}
[19-Feb-2026 16:36:03 Europe/Paris] Étape 4 OK match 1474 — phaseElim=1, s1=0, s2=0, gagnant=7, elim=2
[19-Feb-2026 16:36:03 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1475,"tournoi_id":1,"e1":3,"e2":6,"s1_raw":"0","s2_raw":"0","phase_text":"Éliminatoire : Quarts de finale"}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":true,"conteste":false,"egalite":true}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":null,"points_e1":0,"points_e2":0,"vainqueur_id":6,"elim_loser_id":3,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1034","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"3","emarge":"1","j":"3","points":"3","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1037","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"6","emarge":"1","j":"3","points":"3","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":3,"new_points_e1":3,"new_ratio_e1":0,"new_elim_e1":1,"new_j_e2":3,"new_points_e2":3,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:36:03 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1475,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=6 WHERE id=1475 LIMIT 1"}
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1475,"sent_to":[7,18],"isElim":true,"conteste":false,"egalite":true,"vainqueur_id":6,"elim_loser_id":3}
[19-Feb-2026 16:36:04 Europe/Paris] Étape 4 OK match 1475 — phaseElim=1, s1=0, s2=0, gagnant=6, elim=3
[19-Feb-2026 16:36:04 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1476,"tournoi_id":1,"e1":4,"e2":5,"s1_raw":"0","s2_raw":"0","phase_text":"Éliminatoire : Quarts de finale"}
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":true,"conteste":false,"egalite":true}
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":null,"points_e1":0,"points_e2":0,"vainqueur_id":4,"elim_loser_id":5,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1035","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"4","emarge":"1","j":"3","points":"3","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1036","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"5","emarge":"1","j":"3","points":"3","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":3,"new_points_e1":3,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":3,"new_points_e2":3,"new_ratio_e2":0,"new_elim_e2":1}
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1476,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=4 WHERE id=1476 LIMIT 1"}
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1476,"sent_to":[17,2,3],"isElim":true,"conteste":false,"egalite":true,"vainqueur_id":4,"elim_loser_id":5}
[19-Feb-2026 16:36:04 Europe/Paris] Étape 4 OK match 1476 — phaseElim=1, s1=0, s2=0, gagnant=4, elim=5
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Aucun match qualif en attente | ctx={"tournoi_id":3}
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Aucun match elim en attente -> création next step possible | ctx={"tournoi_id":1}
[19-Feb-2026 16:36:04 Europe/Paris] Tournoi 1 : équipes restantes BEFORE next round => 1(pts:3,ratio:0,j:3), 4(pts:3,ratio:0,j:3), 6(pts:3,ratio:0,j:3), 7(pts:3,ratio:0,j:3)
[19-Feb-2026 16:36:04 Europe/Paris] Tournoi 1 : PAIRS best-vs-worst => 1vs7, 4vs6
[19-Feb-2026 16:36:04 Europe/Paris] ========== TRIGGER STEP 6 : Création tour suivant éliminatoire ==========
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] TRIGGER_CTX step=6 | ctx={"tournoi_id":1,"N":4,"pairs":[[1,7],[4,6]],"byes":[],"round_label":"Demi-finales"}
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Match tour suivant créé | ctx={"tournoi_id":1,"a":1,"b":7,"table":1,"date":"2026-02-19 16:36:00","phase":"Éliminatoire : Demi-finales"}
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Match tour suivant créé | ctx={"tournoi_id":1,"a":4,"b":6,"table":2,"date":"2026-02-19 16:36:00","phase":"Éliminatoire : Demi-finales"}
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Transaction création tour suivant OK | ctx={"tournoi_id":1,"created":2,"phase":"Éliminatoire : Demi-finales"}
[19-Feb-2026 16:36:04 Europe/Paris] [DBG] Notif globale tour suivant | ctx={"tournoi_id":1,"round_label":"Demi-finales","players_count":13}
[19-Feb-2026 16:36:04 Europe/Paris] Tournoi 1 : création tour suivant (Demi-finales), matches créés = 2, byes = 0
[2026-02-19 16:36:04] 

ÉTAPE 1

ÉTAPE 2

ÉTAPE 3
ÉTAPE 4
ÉTAPE 5

ÉTAPE 6/7 (Passage tours & Fin tournoi)


--- FIN DU SCRIPT
=== END LOG 2026-02-19 16:36:04 ===