include("include_breadcrumb.php"); ?>
include("../runshops/include_region_list.php"); ?>
if ($row[lng] && $row[lat]) { ?>
} ?>
include ('comments_show.php'); ?>
$selected_item = strtolower($row[state]); ?>
include("include_sidebar.php"); ?>
Races
if ($user) { ?> } ?> Backinclude("../runshops/include_region_list.php"); ?>
echo stripslashes(stripslashes($row[name])) ; echo " "; ?>
if(is_logged_in($user)) { ?>Comment }?>
Email: echo stripslashes(htmlspecialchars($row[email])); ?>
Website: echo stripslashes(htmlspecialchars($row[website])); ?>
if($_GET[review_add] == 'ok') { ?>
Website: echo stripslashes(htmlspecialchars($row[website])); ?>
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 gforum_TriathlonsEdits WHERE race_uid_fk = '".intval(mysql_escape_string($_GET[uid]))."'"; $boolEdits = mysql_num_rows(mysql_query($wikiFetchSQL)); if($boolEdits !== 0 && $_GET[wiki_change] != 'success') { ?>Group Edits: there are group edits waiting to be validated.
} ?>
include("include_buttons.php"); ?>
include('include_share.php'); ?>
include('include_share.php'); ?>
if(file_exists("/srv/www/htdocs/trifind/racepics/$row[pic1].img")){
print "";
print " ";
}
if(file_exists("/srv/www/htdocs/trifind/racepics/$row[pic2].img")){
print "";
print " ";
}
if(file_exists("/srv/www/htdocs/trifind/racepics/$row[pic3].img")){
print "";
print "
"; } ?>
"; } ?>
Race Information
Date: echo date("F j, Y", $row[foo]); ?>
Race Type: echo $typename; ?>
//Determine bike surface if ($row[bike_surface] == 1) { $bike_surface = "Offroad"; } if ($row[bike_surface] == 2) { $bike_surface = "Gravel"; } else { $bike_surface = "Road"; } ?> Bike Surface: echo $bike_surface; ?>
//Determine draft rules if ($row[draft_legal] == 1) { $draft_legal = "Draft legal"; } else { $draft_legal = "Non-drafting"; } ?> Drafting rules:? echo $draft_legal; ?>
//Determine kids race if ($row[kids_race] == 1) { $kids_race = "This *IS* a kids' race"; } else { $kids_race = "*NOT* a kids' race"; } ?> Kids Race? echo $kids_race; ?>
//Determine units if($row[oneunit] == 1){ $oneunit = "mile"; } if($row[oneunit] == 2){ $oneunit = "meter"; } if($row[oneunit] == 3){ $oneunit = "yard"; } if($row[oneunit] == 4){ $oneunit = "kilometers"; } if($row[twounit] == 1){ $twounit = "mile"; } if($row[twounit] == 2){ $twounit = "meter"; } if($row[twounit] == 3){ $twounit = "yard"; } if($row[twounit] == 4){ $twounit = "kilometers"; } if($row[threeunit] == 1){ $threeunit = "mile"; } if($row[threeunit] == 2){ $threeunit = "meter"; } if($row[threeunit] == 3){ $threeunit = "yard"; } if($row[threeunit] == 4){ $threeunit = "kilometers"; } if($row[onetype] == 1){ $onetype = "swim"; } if($row[onetype] == 2){ $onetype = "bike"; } if($row[onetype] == 3){ $onetype = "run"; } if($row[onetype] == 4){ $onetype = "paddle"; } if($row[onetype] == 5){ $onetype = "ski"; } if($row[twotype] == 1){ $twotype = "swim"; } if($row[twotype] == 2){ $twotype = "bike"; } if($row[twotype] == 3){ $twotype = "run"; } if($row[twotype] == 4){ $twotype = "paddle"; } if($row[twotype] == 5){ $twotype = "ski"; } if($row[threetype] == 1){ $threetype = "swim"; } if($row[threetype] == 2){ $threetype = "bike"; } if($row[threetype] == 3){ $threetype = "run"; } if($row[threetype] == 4){ $threetype = "paddle"; } if($row[threetype] == 5){ $threetype = "ski"; } ?> Course: echo "$row[swim] $oneunit $onetype, $row[bike] $twounit $twotype, $row[run] $threeunit $threetype"; ?>
Start: echo date("g:i A", $row[foo]); ?>
Location: echo "$row[city], $row[state]"; ?>
Address: echo stripslashes(stripslashes($row[address])); ?>
Contact: echo "$row[phone] | $row[email]"; ?>
Individual Price: echo $row[indivfee]; ?>
Team Price: echo $row[teamfee]; ?>
Race Type: echo $typename; ?>
//Determine bike surface if ($row[bike_surface] == 1) { $bike_surface = "Offroad"; } if ($row[bike_surface] == 2) { $bike_surface = "Gravel"; } else { $bike_surface = "Road"; } ?> Bike Surface: echo $bike_surface; ?>
//Determine draft rules if ($row[draft_legal] == 1) { $draft_legal = "Draft legal"; } else { $draft_legal = "Non-drafting"; } ?> Drafting rules:? echo $draft_legal; ?>
//Determine kids race if ($row[kids_race] == 1) { $kids_race = "This *IS* a kids' race"; } else { $kids_race = "*NOT* a kids' race"; } ?> Kids Race? echo $kids_race; ?>
//Determine units if($row[oneunit] == 1){ $oneunit = "mile"; } if($row[oneunit] == 2){ $oneunit = "meter"; } if($row[oneunit] == 3){ $oneunit = "yard"; } if($row[oneunit] == 4){ $oneunit = "kilometers"; } if($row[twounit] == 1){ $twounit = "mile"; } if($row[twounit] == 2){ $twounit = "meter"; } if($row[twounit] == 3){ $twounit = "yard"; } if($row[twounit] == 4){ $twounit = "kilometers"; } if($row[threeunit] == 1){ $threeunit = "mile"; } if($row[threeunit] == 2){ $threeunit = "meter"; } if($row[threeunit] == 3){ $threeunit = "yard"; } if($row[threeunit] == 4){ $threeunit = "kilometers"; } if($row[onetype] == 1){ $onetype = "swim"; } if($row[onetype] == 2){ $onetype = "bike"; } if($row[onetype] == 3){ $onetype = "run"; } if($row[onetype] == 4){ $onetype = "paddle"; } if($row[onetype] == 5){ $onetype = "ski"; } if($row[twotype] == 1){ $twotype = "swim"; } if($row[twotype] == 2){ $twotype = "bike"; } if($row[twotype] == 3){ $twotype = "run"; } if($row[twotype] == 4){ $twotype = "paddle"; } if($row[twotype] == 5){ $twotype = "ski"; } if($row[threetype] == 1){ $threetype = "swim"; } if($row[threetype] == 2){ $threetype = "bike"; } if($row[threetype] == 3){ $threetype = "run"; } if($row[threetype] == 4){ $threetype = "paddle"; } if($row[threetype] == 5){ $threetype = "ski"; } ?> Course: echo "$row[swim] $oneunit $onetype, $row[bike] $twounit $twotype, $row[run] $threeunit $threetype"; ?>
Start: echo date("g:i A", $row[foo]); ?>
Location: echo "$row[city], $row[state]"; ?>
Address: echo stripslashes(stripslashes($row[address])); ?>
Contact: echo "$row[phone] | $row[email]"; ?>
Individual Price: echo $row[indivfee]; ?>
Team Price: echo $row[teamfee]; ?>
Date: echo date("F j, Y", $row[foo]); ?>
Course: echo "$row[swim] $oneunit $onetype, $row[bike] $twounit $twotype, $row[run] $threeunit $threetype"; ?>
Location: echo "$row[city], $row[state]"; ?>
Address: echo stripslashes(stripslashes($row[address])); ?>
Course: echo "$row[swim] $oneunit $onetype, $row[bike] $twounit $twotype, $row[run] $threeunit $threetype"; ?>
Location: echo "$row[city], $row[state]"; ?>
Address: echo stripslashes(stripslashes($row[address])); ?>
General Information
//Determine registration fees
if ($row[registration] == 1)
{ $registration = "Yes, all registration/convenience fees are included in price or disclosed up front."; }
else
{ $registration = "Not specified whether registration/convenience fees are added."; }
?>
Registration fees included or disclosed up front?: echo $registration; ?>
Course Info: echo nl2br(stripslashes(stripslashes($row[courseinfo]))); echo "
"; ?>
More: echo nl2br(stripslashes(stripslashes($row[moreinfo]))); echo "
"; ?>
Directions: echo nl2br(stripslashes(stripslashes($row[directions]))); echo "
"; ?>
if(strlen($row[register]) > 0){ $substring = "http"; if (!is_int(strpos($row[register], $substring))) { $row[register] = "http://".$row[register]; } ?> Register: echo "Click here"; ?> } ?>
Course Info: echo nl2br(stripslashes(stripslashes($row[courseinfo]))); echo "
"; ?>
More: echo nl2br(stripslashes(stripslashes($row[moreinfo]))); echo "
"; ?>
Directions: echo nl2br(stripslashes(stripslashes($row[directions]))); echo "
"; ?>
if(strlen($row[register]) > 0){ $substring = "http"; if (!is_int(strpos($row[register], $substring))) { $row[register] = "http://".$row[register]; } ?> Register: echo "Click here"; ?> } ?>
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 was in this race?
$testresults = mysql_query("SELECT racetags FROM gforum_Triathlons WHERE uid=$row[uid]");
$testrow = mysql_fetch_array($testresults);
$tags = explode(",", $testrow[racetags]);
$numcount = count($tags) - 1;
if($numcount == 0){ $phrase = "No users have tagged this race yet."; }
else if($numcount == 1){ $phrase = "There is 1 user who has tagged this race:"; }
else{ $phrase = "There are $numcount users who have tagged this race: "; }
?>
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' and user_show_racetags=1") 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 gforum_TriathlonsEditors WHERE race_uid_fk=$row[uid] ORDER BY edit_timestamp DESC");
$numcount = mysql_num_rows($testresults);
if($numcount == 0){ $phrase = "No updates have been made this race yet."; }
else if($numcount == 1){ $phrase = "There has been 1 update to this race:"; }
else{ $phrase = "There have been $numcount updates to this race: "; }
?>
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"; } ?>