0){ $total = 0; while($testrow = mysql_fetch_array($test)){ if($testrow[rating] < 6){ $total = $total + $testrow[rating]; } if($testrow[rating] == 6){ $num = $num - 1; } } $avg = $total / $num; }else{ //No ratings $avg = 0; } ?>

Races

Back

Email:
Website:

Commenter: your comments have been submitted and will be validated within 24 hours.

Editor: your changes have been submitted and will be validated within 24 hours.

Group Edits: there are group edits waiting to be validated.


"; print "    "; } if(file_exists("/srv/www/htdocs/trifind/racepics/$row[pic2].img")){ print "\"$row[name]\""; print "    "; } if(file_exists("/srv/www/htdocs/trifind/racepics/$row[pic3].img")){ print "\"$row[name]\""; print "

"; } ?>

Race Information

Date:
Race Type:
Bike Surface:
Drafting rules:?
Kids Race?
Course:
Start:
Location:
Address:
Contact: $row[email]"; ?>
Individual Price:
Team Price:
Date:
Course:
Location:
Address:

General Information

Registration fees included or disclosed up front?:
Course Info: "; ?>
More: "; ?>
Directions: "; ?>
0){ $substring = "http"; if (!is_int(strpos($row[register], $substring))) { $row[register] = "http://".$row[register]; } ?> Register: 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?

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++; } ?>

= 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"; } ?>