include("include_breadcrumb.php"); ?>
include("include_sidebar.php"); ?>
$sqlWikiFetch = "SELECT user_username FROM ".$prefix."User WHERE user_id = ".mysql_escape_string($row[edit_user_id_fk])." LIMIT 1";
$arrUser = mysql_fetch_array(mysql_query($sqlWikiFetch));
$strEditor = $arrUser[user_username];
?>
Editor
echo "".$strEditor.""; ?>
Edit Date
echo date("F j, Y", $row[edit_timestamp]); ?>
Date
// we need to convert the datetime to individual parts //
$datetime = new DateTime($row[$field_lead.'date']);
?>
echo $datetime->format('Y-m-d'); ?>
Time
echo $datetime->format('g:i A'); ?>
Street Address
echo stripslashes(htmlspecialchars($row[$field_lead.'address'])); ?>
Street Address Two
echo stripslashes(htmlspecialchars($row[$field_lead.'address_two'])); ?>
City
echo stripslashes(htmlspecialchars($row[$field_lead.'city'])); ?>
State
echo stripslashes(htmlspecialchars($row[$field_lead.'state'])); ?>
Zip/Postal Code
echo stripslashes(htmlspecialchars($row[$field_lead.'zip'])); ?>
Phone
echo stripslashes(htmlspecialchars($row[$field_lead.'phone'])); ?>
Fax/Alt. Phone
echo stripslashes(htmlspecialchars($row[$field_lead.'fax'])); ?>
Website
$substring = "http";
if (!is_int(strpos($row[$field_lead.'website'], $substring))) {
$row[$field_lead.'website'] = "http://".$row[$field_lead.'website'];
}
$website = $row[$field_lead.'website'];
?>
echo "$website"; ?>
Local Assets
Slowtwitch Ambassador(s)
if ($row[$field_lead.'stambassador'] == 0) { echo "None"; } else { echo "Yes, Their Names - "; echo stripslashes($row[$field_lead.'stambassador_names']); } ?>
Tri Club(s)
if ($row[$field_lead.'triclub'] == 0) { echo "None"; } else { echo "Yes, Their Names - "; echo stripslashes($row[$field_lead.'triclub_names']); } ?>
Coach(es)
if ($row[$field_lead.'coach'] == 0) { echo "None"; } else { echo "Yes, Their Names - "; echo stripslashes($row[$field_lead.'coach_names']); } ?>
Race Director(s)
if ($row[$field_lead.'racedirector'] == 0) { echo "None"; } else { echo "Yes, Their Names - "; echo stripslashes($row[$field_lead.'racedirector_names']); } ?>
Brewery(ies)
if ($row[$field_lead.'brewery'] == 0) { echo "None"; } else { echo "Yes, Their Names - "; echo stripslashes($row[$field_lead.'brewery_names']); } ?>
Other
if ($row[$field_lead.'local'] != "") { echo stripslashes(htmlspecialchars($row[$field_lead.'local'])); } else { echo "No other local assets specified."; } ?>
Fitbike(s)
$implosion = $row[$field_lead.'fitbike'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."Fitbike WHERE fitbike_id IN ($implosion) ORDER BY fitbike_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[fitbike_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Saddle Quick Change
$implosion = $row[$field_lead.'saddlechange'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."Saddlechange WHERE saddlechange_id IN ($implosion) ORDER BY saddlechange_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[saddlechange_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Motion Capture System(s)
$implosion = $row[$field_lead.'motioncapture'];
$temp_list = "";
if ($implosion) {
$sql = ("SELECT * FROM ".$prefix.$resource_table."Motioncapture WHERE motioncapture_id IN ($implosion) ORDER BY motioncapture_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[motioncapture_name], ";
}
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Custom Footbed(s)
$implosion = $row[$field_lead.'footbed'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."Customfootbed WHERE footbed_id IN ($implosion) ORDER BY footbed_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[footbed_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Brands
Triathlon Apparel
$implosion = $row[$field_lead.'apparel_tri'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."ApparelTri WHERE apparel_tri_id IN ($implosion) ORDER BY apparel_tri_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[apparel_tri_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Bike(s)
$implosion = $row[$field_lead.'bike'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."Bike WHERE bike_id IN ($implosion) ORDER BY bike_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[bike_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Bike Saddles/Footwear/Aerobars/Bike Hydration
$implosion = $row[$field_lead.'bikeaccessory'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."BikeAccessory WHERE bikeaccessory_id IN ($implosion) ORDER BY bikeaccessory_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[bikeaccessory_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Bike Helmets/Eyewear
$implosion = $row[$field_lead.'bikehelmet'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."BikeHelmet WHERE bikehelmet_id IN ($implosion) ORDER BY bikehelmet_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[bikehelmet_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Bike Nutritionals/Lubricants/Botanicals
$implosion = $row[$field_lead.'bikebody'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."BikeBody WHERE bikebody_id IN ($implosion) ORDER BY bikebody_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[bikebody_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Bike Stationary Trainer(s)
$implosion = $row[$field_lead.'biketrainer'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."BikeTrainer WHERE biketrainer_id IN ($implosion) ORDER BY biketrainer_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[biketrainer_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Bike Electronics/Cameras/Metrics
$implosion = $row[$field_lead.'bikeelectronic'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."BikeElectronic WHERE bikeelectronic_id IN ($implosion) ORDER BY bikeelectronic_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[bikeelectronic_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Bike Wheels/Tires
$implosion = $row[$field_lead.'bikewheel'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."BikeWheel WHERE bikewheel_id IN ($implosion) ORDER BY bikewheel_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[bikewheel_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Bike Component(s)
$implosion = $row[$field_lead.'bikecomponent'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."BikeComponent WHERE bikecomponent_id IN ($implosion) ORDER BY bikecomponent_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[bikecomponent_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Socks
$implosion = $row[$field_lead.'sock'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."Sock WHERE sock_id IN ($implosion) ORDER BY sock_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[sock_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Running Shoe(s)
$implosion = $row[$field_lead.'shoe'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."Shoe WHERE shoe_id IN ($implosion) ORDER BY shoe_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[shoe_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Run Apparel
$implosion = $row[$field_lead.'apparel_run'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."ApparelRun WHERE apparel_run_id IN ($implosion) ORDER BY apparel_run_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[apparel_run_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Run Hydration
$implosion = $row[$field_lead.'runhydrate'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."RunHydrate WHERE runhydrate_id IN ($implosion) ORDER BY runhydrate_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[runhydrate_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Wetsuit(s)
$implosion = $row[$field_lead.'wetsuit'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."Wetsuit WHERE wetsuit_id IN ($implosion) ORDER BY wetsuit_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[wetsuit_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Swim Apparel/Gear
$implosion = $row[$field_lead.'swimgear'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."Swimgear WHERE swimgear_id IN ($implosion) ORDER BY swimgear_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[swimgear_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Bodycare Tools
$implosion = $row[$field_lead.'bodycare'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."Bodycare WHERE bodycare_id IN ($implosion) ORDER BY bodycare_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[bodycare_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Technology, Community & Education
Key Tri-Specific Contact(s)
if ($row[$field_lead.'trispecific'] == 0) { echo "None"; } else { echo "Yes, Their Names - "; echo stripslashes($row[$field_lead.'trispecific_names']); } ?>
F.I.S.T. Tri Fitters(s)
if ($row[$field_lead.'fist'] == 0) { echo "None"; } else { echo "Yes, Their Names - "; echo stripslashes($row[$field_lead.'fist_names']); } ?>
Diagnostic Tools
$implosion = $row[$field_lead.'diagnostic'];
$sql = ("SELECT * FROM ".$prefix.$resource_table."Diagnostic WHERE diagnostic_id IN ($implosion) ORDER BY diagnostic_name ASC");
//echo $sql;
$results = mysql_query($sql) or die(mysql_error());
$temp_list = "";
while ($temp_row = mysql_fetch_array($results)) {
$temp_list = $temp_list."$temp_row[diagnostic_name], ";
}
$temp_list = rtrim($temp_list, ', ');
if ($temp_list == "") { $temp_list = "none specified";}
echo $temp_list;
$temp_list = "";
?>
Social
Shop Hours
echo stripslashes(htmlspecialchars($row[$field_lead.'hours'])); ?>
Runs & Classes
echo stripslashes(stripslashes($row[$field_lead.'activity'])) ?>
// wiki control buttons
include("wiki_buttons.php")
?>