“);
printf(“
“);
printf(“
“);
printf(“
“);
printf(“
“);
printf(“
\n”);
// printf(“
\n”);
// printf(“
\n”);
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_array($result))
{
$session_id = $row[‘session_id’];
$session_date = $row[‘session_date’];
$training_path_id = $row[‘training_path_id’];
$training_type_id = $row[‘training_type_id’];
$session_length = ( $row[‘session_length’] == NULL ) ? NULL :$row[‘session_length’];
$session_time = $row[‘session_time’];
$session_note = $row[‘session_note’];
$tracking_system_id = $row[‘tracking_system_id’];
$ext_tracking_id = $row[‘ext_tracking_id’];
$path_name = ( $row[‘path_name’] == NULL ) ?
(($session_note == “”) ? “Percorso senza nome”:$session_note)
:$row[‘path_name’];
$path_length = ( $row[‘path_length’] == NULL ) ? NULL : $row[‘path_length’] ;
$path_note = $row[‘path_note’];
$description = $row[‘description’];
$converted_time = NULL;
if ($session_time != NULL){
$session_time_h=(int)($session_time/60/60);
$session_time_m=(int)($session_time/60)-$session_time_h*60;
$session_time_s=$session_time-$session_time_h*60*60-$session_time_m*60;
$converted_time = sprintf(“%02d.%02d.%02d”,$session_time_h,$session_time_m,$session_time_s);
}
$length = ($session_length == NULL) ? $path_length : $session_length;
$converted_length = ( $length == NULL ) ? NULL :number_format($length,2,”,”,”.”);
$average = NULL;
if ($session_time != NULL && $length != NULL) {
$time_second=$session_time/$length;
$average_mm=(int)($time_second/60);
$average_ss=(int)($time_second-$average_mm*60);
$average_ms=(int)(($time_second-(int)($time_second))*100);
$average = sprintf(“%01d.%02d,%d”,$average_mm,$average_ss,$average_ms);
}
$name_link = ““.$path_name.”“;
$note = ($session_note == NULL) ? $path_note : $session_note;
printf(“
“,$session_date);
printf(“
“,$name_link );
printf(“
“,$converted_length);
printf(“
“,$converted_time );
printf(“
\n”,$average );
// printf(“
\n”,$description );
// printf(“
\n”,$note );
}
printf(“
\n”);
}
if ($option==3)
{
$query = “SELECT
S.id as session_id
, S.session_date
, S.training_path_id
, S.training_type_id
, S.session_length
, S.session_time
, S.note as session_note
, S.is_race
, S.tracking_system_id as session_tracking_system_id
, S.ext_tracking_id as session_ext_tracking_id
, P.tracking_system_id as path_tracking_system_id
, P.ext_tracking_id as path_ext_tracking_id
, P.path_name
, P.path_length
, P.note as path_note
, T.description
, Y.description as track_desciption
, Y.homepage as track_homepage
, Y.link_roule as track_roule
, Y.include_roule as track_include
, Z.description as path_track_desciption
, Z.homepage as path_track_homepage
, Z.link_roule as path_track_roule
, Z.include_roule as path_track_include
FROM TRAINING_SESSIONS S
LEFT JOIN TRAINING_PATHS P on S.training_path_id=P.id
LEFT JOIN TRAINING_TYPES T on S.training_type_id=T.id
LEFT JOIN TRACKING_SYSTEMS Y on Y.id = S.tracking_system_id
LEFT JOIN TRACKING_SYSTEMS Z on Z.id = P.tracking_system_id
WHERE S.id = “.$session_id.”
AND S.is_race = 1
ORDER BY S.session_date desc”;
printf(“
| Data | Percorso | Lunghezza | Tempo | Media | Tipo | Note |
| %s | %s | %s | %s | %s | %s |
| %s | ||||
\n”);
if (isset($track_roule) && isset($session_ext_tracking_id))
{
$path_link = str_replace(‘[]’,$session_ext_tracking_id,$track_roule);
printf(“Vai alla mappa\n”,$path_link);
}
elseif (isset($path_track_roule) && isset($path_ext_tracking_id))
{
$path_link = str_replace(‘[]’,$path_ext_tracking_id,$path_track_roule);
printf(“Vai alla mappa\n”,$path_link);
}
if (isset($track_include) && isset($session_ext_tracking_id))
{
$path_include=str_replace(‘[]’,$session_ext_tracking_id,$track_include);
printf(“%s\n”,$path_include );
}
elseif (isset($path_track_include) && isset($path_ext_tracking_id))
{
$path_include=str_replace(‘[]’,$path_ext_tracking_id,$path_track_include);
printf(“
\n”,$path_include );
}
}
?>