include("include_breadcrumb.php"); ?>
include("../runshops/include_region_list.php"); ?> if($_GET[review_add] == 'ok') { ?>
include ('comments_show.php'); ?>
$selected_item = strtolower($row[coach_state]); ?>
include("include_sidebar.php"); ?>
Triathlon Coaches
if ($user) { ?> } ?> Backinclude("../runshops/include_region_list.php"); ?> if($_GET[review_add] == 'ok') { ?>
Commenter: your comments have been submitted and will be validated within 24 hours.
} ?> if($_GET[wiki_change] == 'success') { ?>Editor: your changes have been submitted and will be validated within 24 hours.
} ?> $wikiFetchSQL = "SELECT edit_id FROM ".$prefix."CoachesEdits WHERE coach_id_fk = '".intval(mysql_escape_string($_GET[coach_id]))."'"; $boolEdits = mysql_num_rows(mysql_query($wikiFetchSQL)); if($boolEdits !== 0 && $_GET[wiki_change] != 'success') { ?>Group Edits: there are group edits waiting to be validated.
} ?>echo stripslashes(stripslashes($row[coach_name])) ; echo " "; ?> if ($row[coach_certifications]) { $temp_arr = explode(",", $row[coach_certifications]); if (in_array($st_id, $temp_arr)) {echo "
Slowtwitch Certified Coach"; } else { echo "";} } ?>
if(is_logged_in($user)) { ?>Comment }?>
echo stripslashes(htmlspecialchars($row[coach_address])); ?>
if ( $row[coach_address_two] ) { echo stripslashes(htmlspecialchars($row[coach_address_two]) . "
"); } ?> echo stripslashes(htmlspecialchars($row[coach_city])); ?>, echo stripslashes(htmlspecialchars($row[coach_state])); ?> echo stripslashes(htmlspecialchars($row[coach_zip])); ?>
Phone: echo stripslashes(htmlspecialchars($row[coach_phone])); ?>
Fax: echo stripslashes(htmlspecialchars($row[coach_fax])); ?>
if ( $row[coach_address_two] ) { echo stripslashes(htmlspecialchars($row[coach_address_two]) . "
"); } ?> echo stripslashes(htmlspecialchars($row[coach_city])); ?>, echo stripslashes(htmlspecialchars($row[coach_state])); ?> echo stripslashes(htmlspecialchars($row[coach_zip])); ?>
Phone: echo stripslashes(htmlspecialchars($row[coach_phone])); ?>
Fax: echo stripslashes(htmlspecialchars($row[coach_fax])); ?>
Email: echo stripslashes(htmlspecialchars($row[coach_email])); ?>
Website: echo stripslashes(htmlspecialchars($row[coach_website])); ?>
Website: echo stripslashes(htmlspecialchars($row[coach_website])); ?>
include("include_buttons.php"); ?>
Info
Education:
$row[coach_degrees] = ltrim(rtrim($row[coach_degrees], ", "), ", ");
if ($row[coach_degrees]) {
$sql = ("SELECT * FROM ".$prefix."CoachesDegrees WHERE coach_degree_id IN ($row[coach_degrees]) ORDER BY coach_degree_name ASC") OR die(mysql_error());
//echo $sql;
$fetch = mysql_query($sql) or die(mysql_error());
$degree_list = "";
while ($list = mysql_fetch_array($fetch)) {
$degree_list = $degree_list."$list[coach_degree_name], ";
}
$degree_list = rtrim($degree_list, ', ');
}
if ($degree_list) {echo $degree_list;} else {echo "None";}
?>
Certifications: $row[coach_certifications] = ltrim(rtrim($row[coach_certifications], ", "), ", "); if ($row[coach_certifications]) { $sql = ("SELECT * FROM ".$prefix."CoachesCertifications WHERE coach_certification_id IN ($row[coach_certifications]) ORDER BY coach_certification_name ASC"); //echo $sql; $fetch = mysql_query($sql) or die(mysql_error()); $certification_list = ""; while ($list = mysql_fetch_array($fetch)) { $certification_list = $certification_list."$list[coach_certification_name], "; } $certification_list = rtrim($certification_list, ', '); } if ($certification_list) {echo $certification_list;} else {echo "None";} ?>
Services: $row[coach_services] = ltrim(rtrim($row[coach_services], ", "), ", "); if ($row[coach_services]) { $sql = ("SELECT * FROM ".$prefix."CoachesServices WHERE coach_service_id IN ($row[coach_services]) ORDER BY coach_service_name ASC"); //echo $sql; $fetch = mysql_query($sql) or die(mysql_error()); $service_list = ""; while ($list = mysql_fetch_array($fetch)) { $service_list = $service_list."$list[coach_service_name], "; } $service_list = rtrim($service_list, ', '); } if ($service_list) {echo $service_list;} else {echo "None";} ?>
Certifications: $row[coach_certifications] = ltrim(rtrim($row[coach_certifications], ", "), ", "); if ($row[coach_certifications]) { $sql = ("SELECT * FROM ".$prefix."CoachesCertifications WHERE coach_certification_id IN ($row[coach_certifications]) ORDER BY coach_certification_name ASC"); //echo $sql; $fetch = mysql_query($sql) or die(mysql_error()); $certification_list = ""; while ($list = mysql_fetch_array($fetch)) { $certification_list = $certification_list."$list[coach_certification_name], "; } $certification_list = rtrim($certification_list, ', '); } if ($certification_list) {echo $certification_list;} else {echo "None";} ?>
Services: $row[coach_services] = ltrim(rtrim($row[coach_services], ", "), ", "); if ($row[coach_services]) { $sql = ("SELECT * FROM ".$prefix."CoachesServices WHERE coach_service_id IN ($row[coach_services]) ORDER BY coach_service_name ASC"); //echo $sql; $fetch = mysql_query($sql) or die(mysql_error()); $service_list = ""; while ($list = mysql_fetch_array($fetch)) { $service_list = $service_list."$list[coach_service_name], "; } $service_list = rtrim($service_list, ', '); } if ($service_list) {echo $service_list;} else {echo "None";} ?>
General Info
General Info: echo stripslashes(stripslashes($row[coach_info])) ?>
Rates & Fees: echo stripslashes(stripslashes($row[coach_cost])); ?>
Training Camps Offered: echo stripslashes(stripslashes($row[coach_camps])); ?>
Rates & Fees: echo stripslashes(stripslashes($row[coach_cost])); ?>
Training Camps Offered: echo stripslashes(stripslashes($row[coach_camps])); ?>
Map location is based off of a geocode of the addressed entered using Google's Google Maps API. If your address does not geocode properly, you can either update the address (we will attempt to re-geocode after any updates to your entry) or you can use Google's geocoding tool found here: http://gmaps-samples.googlecode.com/svn/trunk/geocoder/singlegeocode.html to obtain a lat/long for your location and enter that. To use the utility, type in an address that is close to your location and then drag-and-drop the marker to obtain the desired lat/long. If you choose to enter a lat/long, you must check the box on the edit page that says, "override geocode with entered lat/long."
Who's coached?
$testresults = mysql_query("SELECT coach_user_tags FROM ".$prefix."Coaches WHERE coach_id=$row[coach_id]");
$testrow = mysql_fetch_array($testresults);
$tags = explode(",", $testrow[coach_user_tags]);
$numcount = count($tags) - 1;
if($numcount == 0){ $phrase = "No users have tagged this coach yet."; }
else if($numcount == 1){ $phrase = "There is 1 user who has tagged this coach:"; }
else{ $phrase = "There are $numcount users who have tagged this coach: "; }
?>
echo $phrase; ?>
//List users
$i = 0;
foreach($tags as $value){
if($i > 0){
$tempresults = mysql_query("SELECT user_username FROM ".$prefix."User WHERE user_id='$value'") or die (mysql_error());
$temprow = mysql_fetch_array($tempresults);
if($i > 1){ echo ", "; }
// TODO: SLOWTWITCH EDIT
//echo "$temprow[user_username]";
// replace the link above with the link below for integration into gforum
echo "$temprow[user_username]";
// TODO: SLOWTWITCH EDIT END
}
$i++;
}
?>
$testresults = mysql_query("SELECT * FROM ".$prefix."CoachesEditors WHERE coach_id_fk=$row[coach_id] ORDER BY edit_timestamp DESC");
$numcount = mysql_num_rows($testresults);
if($numcount == 0){ $phrase = "No updates have been made this coach yet."; }
else if($numcount == 1){ $phrase = "There has been 1 update to this coach:"; }
else{ $phrase = "There have been $numcount updates to this coach: "; }
echo "
"; ?>
"; ?>
echo $phrase; ?>
//List users
$i = 0;
while($row=mysql_fetch_array($testresults)){
if($i >= 0) {
$tempresults = mysql_query("SELECT user_username FROM ".$prefix."User WHERE user_id='$row[user_id_fk]'") or die (mysql_error());
$temprow = mysql_fetch_array($tempresults);
if ($i >= 1) { echo "
"; } echo "$temprow[user_username] at ".date("F j, Y g:i A", $row[edit_timestamp]); } $i++; } if($numcount <= 0) { echo "No users"; } ?>
"; } echo "$temprow[user_username] at ".date("F j, Y g:i A", $row[edit_timestamp]); } $i++; } if($numcount <= 0) { echo "No users"; } ?>