Maratonina Roma Ostia 1995 e 1996 |
|||
Maratonina dei 4 Laghi 1996 1998 1999 |
|||
Maratonina delle 28 Sorgenti 1997 |
|||
Maratonina di Napoli 1999 |
|||
Altre gare |
Tag: Gare
Le coppe
4ª Maratonina dei Monti Lattari Pimonte 22/09/96 3° Classificato |
Campionato Italiano 21 Km Perugia 30/04/95 Società 3ª Classificata |
1° Trofeo Città di Sorrento 08/09/96 |
Storico allenamento
Training anno “.$year_display .”
\n”);
if ($option == 0 ){
printf(“Statistiche settimanali – ”
.”Statistiche mensili\n”);
}
elseif ($option == 2){
printf(“Elenco sessioni – ”
.”Statistiche mensili\n”);
}
elseif ($option == 1){
printf(“Elenco sessioni – ”
.”Statistiche settimanali\n”);
}
elseif ($option == 3){
printf(“Elenco sessioni – ”
.”Statistiche mensili – ”
.”Statistiche settimanali\n”);
}
printf(“
<<%d | %d>> |
”
,$next,($year_display+1));
$db= mysqli_connect($db_host, $db_user, $db_password, $db_name);
if (!$db) {
echo “Error: Unable to connect to MySQL.” . PHP_EOL;
echo “Debugging errno: ” . mysqli_connect_errno() . PHP_EOL;
echo “Debugging error: ” . mysqli_connect_error() . PHP_EOL;
exit;
}
mysqli_select_db($db, $db_name) or die(‘Errore db’);
//—————————————————————————————————
// ELENCO DELLE ATTIVITA’
//—————————————————————————————————
if ($option == 0)
{
$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
, P.tracking_system_id
, P.ext_tracking_id
, P.path_name
, P.path_length
, P.note as path_note
, T.description
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
WHERE YEAR(S.session_date) = “.$year_display.”
ORDER BY S.session_date desc”;
printf(“
Data | Percorso | Lunghezza | Tempo | Media | Tipo | Note |
%s | %s | %s | %s | %s | %s | %s |
\n”);
}
//—————————————————————————————————
// STATISTICHE MENSILI
//—————————————————————————————————
if ($option == 1)
{
$query = “SELECT count(*) num_sessions
, ifnull(sum(ifnull(S.session_length,P.path_length)),0) len_sessions
, ifnull(sum(S.session_time),0) time_sessions
, NULL week
, month(S.session_date) month
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
where YEAR(S.session_date) = “.$year_display.”
group by month(S.session_date) order by 4,5 “;
printf(“
Mese | Sessioni | Lunghezza | Tempo |
%d | – | – | – |
%s | %s | %s | %s |
%d | – | – | – |
\n”);
}
//—————————————————————————————————
// STATISTICHE SETTIMANALI
//—————————————————————————————————
if ($option == 2)
{
$query = “SELECT count(*) num_sessions
, ifnull(sum(ifnull(S.session_length,P.path_length)),0) len_sessions
, ifnull(sum(S.session_time),0) time_sessions
, week(S.session_date) week
, NULL month
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
where YEAR(S.session_date) = “.$year_display.”
group by week(S.session_date) order by 4,5 “;
printf(“
Settimana | Sessioni | Lunghezza | Tempo |
%d | – | – | – |
%s | %s | %s | %s |
\n”);
}
//—————————————————————————————————
// SINGOLA SESSIONE
//—————————————————————————————————
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 YEAR(S.session_date) = “.$year_display.”
AND S.id = “.$session_id.”
ORDER BY S.session_date desc”;
printf(“
Data | Percorso | Lunghezza | Tempo | Media | Tipo |
%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 );
}
}
?>