include("include_breadcrumb.php"); ?>
$selected_item = strtolower($row[triclub_state]); ?>
include("include_sidebar.php"); ?>
include("include_starfunc.php"); ?>
include("../runshops/include_region_list.php"); ?>
include ('comments_show.php'); ?>
Triathlon Clubs
if ($user) { ?> } ?> Backinclude("../runshops/include_region_list.php"); ?>
echo stripslashes(stripslashes($row[triclub_name])) ; echo " "; ?>
if(is_logged_in($user)) { ?>Comment }?>
echo stripslashes(htmlspecialchars($row[triclub_address])); ?>
if ( $row[triclub_address_two] ) { echo stripslashes(htmlspecialchars($row[triclub_address_two]) . "
"); } ?> echo stripslashes(htmlspecialchars($row[triclub_city])); ?>, echo stripslashes(htmlspecialchars($row[triclub_state])); ?> echo stripslashes(htmlspecialchars($row[triclub_zip])); ?>
Phone: echo stripslashes(htmlspecialchars($row[triclub_phone])); ?>
Fax: echo stripslashes(htmlspecialchars($row[triclub_fax])); ?>
if ( $row[triclub_address_two] ) { echo stripslashes(htmlspecialchars($row[triclub_address_two]) . "
"); } ?> echo stripslashes(htmlspecialchars($row[triclub_city])); ?>, echo stripslashes(htmlspecialchars($row[triclub_state])); ?> echo stripslashes(htmlspecialchars($row[triclub_zip])); ?>
Phone: echo stripslashes(htmlspecialchars($row[triclub_phone])); ?>
Fax: echo stripslashes(htmlspecialchars($row[triclub_fax])); ?>
Email: echo stripslashes(htmlspecialchars($row[triclub_email])); ?>
Website: echo stripslashes(htmlspecialchars($row[triclub_website])); ?>
if($_GET[review_add] == 'ok') { ?>
Website: echo stripslashes(htmlspecialchars($row[triclub_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 ".$prefix."TriclubsEdits WHERE triclub_id_fk = '".intval(mysql_escape_string($_GET[triclub_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.
} ?>
include("include_buttons.php"); ?>
Membership
Club President: echo stripslashes(htmlspecialchars($row[triclub_president])); ?>
Board Member(s): if ($row[triclub_board] == 0) { echo "None"; } else { echo "Yes, Their Names - "; echo stripslashes($row[triclub_board_names]); } ?>
Total Membership: echo $row[triclub_membership]; ?>
Club Dues: echo stripslashes(htmlspecialchars($row[triclub_dues])); ?>
Board Member(s): if ($row[triclub_board] == 0) { echo "None"; } else { echo "Yes, Their Names - "; echo stripslashes($row[triclub_board_names]); } ?>
Total Membership: echo $row[triclub_membership]; ?>
Club Dues: echo stripslashes(htmlspecialchars($row[triclub_dues])); ?>
General Information
Club Info: echo stripslashes(stripslashes($row[triclub_info])) ?>
Club Sponsors: echo stripslashes(stripslashes($row[triclub_sponsors])) ?>
Club Discounts: echo stripslashes(stripslashes($row[triclub_discounts])) ?>
Directions to Workouts & Meeting Location(s): echo stripslashes(stripslashes($row[triclub_directions])); ?>
Club Workout Schedule: echo stripslashes(stripslashes($row[triclub_workouts])); ?>
Club Meetings & Events Schedule: echo stripslashes(stripslashes($row[triclub_meetings])); ?>
Club Sponsors: echo stripslashes(stripslashes($row[triclub_sponsors])) ?>
Club Discounts: echo stripslashes(stripslashes($row[triclub_discounts])) ?>
Directions to Workouts & Meeting Location(s): echo stripslashes(stripslashes($row[triclub_directions])); ?>
Club Workout Schedule: echo stripslashes(stripslashes($row[triclub_workouts])); ?>
Club Meetings & Events Schedule: echo stripslashes(stripslashes($row[triclub_meetings])); ?>
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."
Racers
$testresults = mysql_query("SELECT triclub_member_tags FROM ".$prefix."Triclubs WHERE triclub_id=$row[triclub_id]");
$testrow = mysql_fetch_array($testresults);
$tags = explode(",", $testrow[triclub_member_tags]);
$numcount = count($tags) - 1;
if($numcount == 0){ $phrase = "No users have tagged this club yet."; }
else if($numcount == 1){ $phrase = "There is 1 user who has tagged this club:"; }
else{ $phrase = "There are $numcount users who have tagged this club: "; }
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 ", "; }
echo "$temprow[user_username]";
}
$i++;
}
?>
$testresults = mysql_query("SELECT * FROM ".$prefix."TriclubsEditors WHERE triclub_id_fk=$row[triclub_id] ORDER BY edit_timestamp DESC");
$numcount = mysql_num_rows($testresults);
if($numcount == 0){ $phrase = "No updates have been made this club yet."; }
else if($numcount == 1){ $phrase = "There has been 1 update to this club:"; }
else{ $phrase = "There have been $numcount updates to this club: "; }
?>
echo $phrase; ?>
$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 "
"; } // TODO: SLOWTWITCH EDIT //echo "$temprow[user_username]"; // replace the link above with the link below for integration into gforum echo "$temprow[user_username] at ".date("F j, Y g:i A", $row[edit_timestamp]); // TODO: SLOWTWITCH EDIT END } $i++; } if($numcount <= 0){ echo "No users"; } ?>
"; } // TODO: SLOWTWITCH EDIT //echo "$temprow[user_username]"; // replace the link above with the link below for integration into gforum echo "$temprow[user_username] at ".date("F j, Y g:i A", $row[edit_timestamp]); // TODO: SLOWTWITCH EDIT END } $i++; } if($numcount <= 0){ echo "No users"; } ?>