setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_WARNING);$bddWp->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_OBJ);$bddCrew = new PDO('mysql:host=localhost;dbname=sc1jevu1895_crew;port=3306', 'sc1jevu1895_crew', 'UjXSEU@TQTy!*1zFpYzs');//$bddCrew = new PDO('mysql:host=localhost;dbname=afrvadmin', 'root', 'root');$bddCrew->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_WARNING);$bddCrew->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_OBJ);$today = new DateTime();$emailFieldId = 'field_445191f';$callsignFieldId = 'callsign';$pilotsPresentationInfos = $bddWp->query("SELECT wpEmail.value as email, wpCallsign.value as callsign FROM wp_e_submissions_values as wpEmail LEFT JOIN wp_e_submissions_values as wpCallsign ON wpCallsign.submission_id = wpEmail.submission_id WHERE wpEmail.key = '" . $emailFieldId . "' AND wpCallsign.key = '" . $callsignFieldId . "' ORDER BY wpEmail.submission_id DESC LIMIT 1")->fetch();$pilotId = substr($pilotsPresentationInfos->callsign, 3);$query = $bddCrew->prepare("SELECT comment FROM phpvms_pilots WHERE email = ? AND pilotid = ?");$query->execute([$pilotsPresentationInfos->email, $pilotId]);$pilotInfo = $query->fetch();if(!$pilotInfo) { return;}$comment = $pilotInfo->comment . "\n" . $today->format('d/m/Y') . " : Présentation discord effectuée (auto)";$bddCrew->prepare("UPDATE phpvms_pilots SET retired = ?, comment = ? WHERE email = ? AND pilotid = ?") ->execute([0, $comment, $pilotsPresentationInfos->email, $pilotId]);