function CreateDistanceInformation($TourId, $Distances, $Targets = 0, $Athletes = 4, $Session = 1) { require_once 'Tournament/Fun_ManSessions.inc.php'; if ($Targets) { insertSession($TourId, 1, 'Q', '', $Targets, $Athletes, 1, 0); } foreach ($Distances as $Dist => $Infos) { safe_w_sql("insert into DistanceInformation set DiTournament={$TourId}, DiType='Q', DiSession={$Session}, DiDistance={$Dist}+1, DiEnds={$Infos[0]}, DiArrows={$Infos[1]} ON DUPLICATE KEY UPDATE DiEnds={$Infos[0]}, DiArrows={$Infos[1]} "); } }
* Lavoro le sessioni * 1) Aggiorno quelle che "restano" * 2) Cancello quelle "di troppo" * 3) Inserisco le nuove */ foreach ($sesOrders as $o) { if ($o == 0) { continue; } //Salto la "vuota" if ($o <= $_REQUEST['d_ToNumSession'] && array_key_exists($o, $oldSession)) { $x = updateSession($_SESSION['TourId'], $o, 'Q', $oldSession[$o]["Name"], $_REQUEST['d_ToTar_' . $o], $_REQUEST['d_ToAth_' . $o], $oldSession[$o]["First"], 0, false); } else { if ($o <= $_REQUEST['d_ToNumSession'] && !array_key_exists($o, $oldSession)) { if (isset($_REQUEST['d_ToTar_' . $o]) && isset($_REQUEST['d_ToAth_' . $o])) { $x = insertSession($_SESSION['TourId'], $o, 'Q', '', $_REQUEST['d_ToTar_' . $o], $_REQUEST['d_ToAth_' . $o], 1, 0); } } else { deleteSession($_SESSION['TourId'], $o, 'Q'); } } } } } else { foreach ($sesOrders as $o) { if ($o == 0) { continue; } $Arr_Values2Check_ManSessions['d_ToTar_' . $o] = array('Func' => 'GoodNumTarget', 'Error' => true); $Arr_Values2Check_ManSessions['d_ToAth_' . $o] = array('Func' => 'GoodNumAth', 'Error' => true); }
if ($toSave['oldKey'] == '') { $x = insertSession($_SESSION['TourId'], $newOrder, $toSave['d_SesType'], $toSave['d_SesName'], $toSave['d_SesTar4Session'], $toSave['d_SesAth4Target'], $toSave['d_SesFirstTarget'], $toSave['d_SesFollow']); if ($x !== true) { $msg = $x; } } else { $msg = '_error_'; } } else { if ($toSave['oldKey'] != '') { $oldKeyType = substr($toSave['oldKey'], -1); if ($oldKeyType == $toSave['d_SesType']) { $x = updateSession($_SESSION['TourId'], $toSave['d_SesOrder'], $toSave['d_SesType'], $toSave['d_SesName'], $toSave['d_SesTar4Session'], $toSave['d_SesAth4Target'], $toSave['d_SesFirstTarget'], $toSave['d_SesFollow'], $toSave['d_SesType'] == 'Q' ? true : false); } else { // prima aggiungo con la insert $x = insertSession($_SESSION['TourId'], $newOrder, $toSave['d_SesType'], $toSave['d_SesName'], $toSave['d_SesTar4Session'], $toSave['d_SesAth4Target'], $toSave['d_SesFirstTarget'], $toSave['d_SesFollow']); if ($x !== true) { $msg = $x; } else { // poi con la oldKey ricavo la riga da rancare list($oldOrder, $oldType) = explode('_', $toSave['oldKey']); $x = deleteSession($_SESSION['TourId'], $oldOrder, $oldType); if ($x !== true) { $msg = $x; } } } } else { $msg = '_error_'; } }