0) { $CurAccessToken = RF_STRAVA_check_access_token($CurUserID); $StravaClient->setAccessToken($CurAccessToken); //Check the User has a preferred club otherwise redirect $result = mysql_query("SELECT * FROM stravaTblStravaAthletes WHERE UserID=$CurUserID",$db); while ($myrow = mysql_fetch_array($result)) { $PreferredStravaClubID = $myrow["PreferredClubID"]; $AthleteDetails = $myrow["JSONDetails"]; $ProfileImageID = $myrow["ProfileImageID"]; $IsCoffeeFundContributor = $myrow["IsCoffeeFundContributor"]; $WeightCurrent = $myrow["WeightCurrent"]; $WeightCurrentUpdateDate = $myrow["WeightCurrentUpdateDate"]; } if(strlen($AthleteDetails) > 0) { if($PreferredStravaClubID > 0) { $ClubDetails = $StravaClient->get('clubs/'.$PreferredStravaClubID); $ClubName = $ClubDetails->name; $ClubLogoURL = $ClubDetails->profile_medium; //var_dump($ClubDetails); $count = mysql_query("SELECT count(StravaClubsID) as num FROM stravaTblStravaClubs WHERE ClubID='$PreferredStravaClubID'"); $num = mysql_result($count,0,"num"); if($num == 0) { $ClubDetailsEncoded = addslashes(json_encode($ClubDetails)); $sql_insert = "INSERT INTO stravaTblStravaClubs ( ClubID, ClubName, JSONDetails, WebsitesID, Active ) VALUES ( '$PreferredStravaClubID', '$ClubName', '$ClubDetailsEncoded', '$CurWebsiteID', '1' )"; //echo "$sql_insert"; $res = mysql_db_query($RF_GLOBAL_dbname, $sql_insert) or RF_MAIN_mysql_die(); $StravaClubsID = mysql_insert_id(); } else { $result = mysql_query("SELECT * FROM stravaTblStravaClubs WHERE ClubID='$PreferredStravaClubID'",$db); while ($myrow = mysql_fetch_array($result)) { $StravaClubsID = $myrow["StravaClubsID"]; $NominatedSegmentIDs = $myrow["NominatedSegmentIDs"]; $NominatedTrainingDays = $myrow["NominatedTrainingDays"]; $EligibilitySegmentID = $myrow["EligibilitySegmentID"]; $EligibilityMetricSecs = $myrow["EligibilityMetricSecs"]; $EligibilityPeriodMths = $myrow["EligibilityPeriodMths"]; $PaymentGatewayProviderID = $myrow["PaymentGatewayProviderID"]; $BillingPeriod = $myrow["BillingPeriod"]; $EstimatedCoffeeAmt = $myrow["EstimatedCoffeeAmt"]; $PreferredCoffeeProviderID = $myrow["PreferredCoffeeProviderID"]; } } $PreferredClubName = $ClubName = $ClubDetails->name; } //Determine if SiteAdmin $count = mysql_query("SELECT count(UserID) as num FROM stravaTblStravaClubsAdmins WHERE StravaClubsID=$StravaClubsID AND UserID='$CurUserID'"); $IsAdminUser = mysql_result($count,0,"num") > 0 ? true : false; //Check Permissions $IsSiteAdmin = false; $CanEdit = false; $CanRank = false; $CanModerate = false; if($IsAdminUser == true) { $resultAdmins = mysql_query("SELECT * FROM stravaTblStravaClubsAdmins WHERE StravaClubsID=$StravaClubsID AND UserID='$CurUserID'",$db); while ($myrow = mysql_fetch_array($resultAdmins)) { $IsSiteAdmin = $myrow["IsSiteAdmin"] == 1 ? true : false; $CanEdit = $myrow["CanEdit"] == 1 ? true : false; $CanRank = $myrow["CanRank"] == 1 ? true : false; $CanModerate = $myrow["CanModerate"] == 1 ? true : false; } } //Update Results Notification if(isset($_REQUEST["result"]) && $_REQUEST["result"] != "") { $UpdateResult = $_REQUEST["result"]; $NotificationUpdate = $_REQUEST["resultMessage"]; if($UpdateResult == "success") { echo "
\n"; echo "

Success: Club updates succcessfully processed. $NotificationUpdate

\n"; echo "
\n"; } elseif($UpdateResult == "fail") { echo "
\n"; echo "

Error: Update of Club settings has failed. $NotificationUpdate

\n"; echo "
\n"; } } //Set up the Tabs echo "
\n"; echo "\n"; $AthleteDetails = json_decode($AthleteDetails); $AthleteClubs = $AthleteDetails->clubs; $AthleteBikes = $AthleteDetails->bikes; if(is_object($AthleteDetails)) { $AthleteFirst = RF_MEM_attribute_get("Firstname",$CurUserID); $AthleteLast = RF_MEM_attribute_get("Surname",$CurUserID); $FriendlyName = RF_MEM_attribute_get("FriendlyName",$CurUserID); echo "
\n"; echo "
\n"; echo "
\n"; echo "

Profile Settings for $AthleteFirst $AthleteLast

\n"; echo "
\n"; echo "
\n"; echo " \n"; echo "
\n"; echo "
\n"; echo "Re-Authorise\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; if($WeightCurrentUpdateDate > 0) { $WeightCurrentUpdateDateF = RF_MAIN_dateformat($WeightCurrentUpdateDate,23); echo "Last Updated: $WeightCurrentUpdateDateF\n"; } echo "
\n"; echo "
 
\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; echo "
 
 
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; if(is_array($AthleteBikes)) { echo "
 
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "

Bike Settings

\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; for($j=0;$jid; $GearName = $AthleteBike->name; $GearImageID = 0; $StravaGearID = 0; $GearWeight = 0; $result = mysql_query("SELECT * FROM stravaTblStravaGear WHERE GearID='$GearID' AND UserID=$CurUserID",$db); while ($myrow = mysql_fetch_array($result)) { $StravaGearID = $myrow["StravaGearID"]; $GearImageID = $myrow["GearImageID"]; $GearWeight = str_replace("kg","",RF_STRAVA_grams_to_kilos($myrow["GearWeightGrams"])); } echo "
\n"; echo "
\n"; if($GearImageID > 0) echo"$GearName\n"; else print($GearName); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; } echo "
\n"; echo "
\n"; echo " \n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; } } ?> 0) { //This the current authorised user a Club Admin or Owner if($IsSiteAdmin == true) { //Add this User to Admins $count = mysql_query("SELECT count(UserID) as num FROM stravaTblStravaClubsAdmins WHERE StravaClubsID=$StravaClubsID AND UserID='$CurUserID'"); $AdminCount = mysql_result($count,0,"num"); if($AdminCount == 0) { $sql_insert = "INSERT INTO stravaTblStravaClubsAdmins (StravaClubsID, UserID ) Values ( $StravaClubsID, $CurUserID )"; //echo "$sql_insert" $sql_result = mysql_db_query($RF_GLOBAL_dbname, $sql_insert) or RF_MAIN_mysql_die(); } //Club Profile //Set up the Form properties echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "

Manage your club

\n"; echo "

Update your Club's Nominated Segments and regular Training Days:

\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; echo "
\n"; echo "

Club Billing

\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo ""; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo ""; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo ""; echo "
\n"; echo "
\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
 
\n"; } if($IsSiteAdmin == true) { //Club Members //Set up the Form properties echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "

Club Members

\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; //Print out all the members ?>
0) { $AthleteKey = "User_".$UserID; $AthleteID = $myrow["AthleteID"]; $AthleteName = $myrow["AthleteName"]; $IsCoffeeFundContributor = $myrow["IsCoffeeFundContributor"]; $AccessTokenExpiresAt = $myrow["AccessTokenExpiresAt"]; $AthleteFirst = RF_MEM_attribute_get("Firstname",$UserID); $AthleteLast = RF_MEM_attribute_get("Surname",$UserID); $AthleteEmail = RF_MEM_attribute_get("Email",$UserID); $AthleteUsername = RF_MEM_get_username_from_id($UserID); if($ClubFriendlyNameExists > 0 && RF_MEM_attribute_count("ClubPreferredNickname",$AthleteUserID) > 0) $AthleteFriendly = RF_MEM_attribute_get("ClubPreferredNickname",$AthleteUserID); else $AthleteFriendly = RF_MEM_attribute_get("FriendlyName",$UserID); $AthleteFull = $AthleteFirst." ".$AthleteLast; $AthleteInitials = substr(strtoupper($AthleteFirst),0,1).substr(strtoupper($AthleteLast),0,1); $AthleteNameL = $AthleteFirst.substr(strtoupper($AthleteLast),0,1); if($AthleteFriendly == "") $AthleteFriendly = $AthleteNameL; //Load Profile Props $ClubRank = RF_MEM_attribute_get("ClubRank",$UserID); //Determine the Career Rides for this user $CareerRidesLegacy = 0; if(RF_MEM_check_attribute_table_exists("ClubTotalRides")) { $CareerRidesLegacy = intval(RF_MEM_attribute_get("ClubTotalRides",$UserID)); } //Add the total Rides in the system $count = mysql_query("SELECT count(UserID) as num FROM stravaTblStravaClubRankingRides crr, stravaTblStravaClubRankingRideAthletes crra WHERE crr.Active=1 AND crr.WebsitesID=$CurWebsiteID AND UserID=$UserID AND crr.StravaClubsID=$PreferredStravaClubID AND crr.StravaClubRankingRidesID=crra.StravaClubRankingRidesID"); $CareerRides = mysql_result($count,0,"num") + $CareerRidesLegacy; $FirstRideDate = ""; $FirstRideDateF = ""; if(RF_MEM_check_attribute_table_exists("ClubFirstRide") && RF_MEM_attribute_count("ClubFirstRide",$UserID) > 0) { $FirstRideDate = RF_MEM_attribute_get("ClubFirstRide",$UserID); $FirstRideDateF = RF_MAIN_dateformat($FirstRideDate,4); } if(!array_key_exists($AthleteKey, $ClubMemberDetailsArray)) { $ClubMemberDetailsArray[$AthleteKey] = array($UserID,$AthleteID,$AthleteNameL,$AthleteInitials,$AthleteFriendly,$AthleteFull,$IsCoffeeFundContributor,$AccessTokenExpiresAt,$ClubRank,$CareerRides,$FirstRideDateF); $ClubMemberListJS.="var clubMember = new ClubMember($UserID,'$AthleteUsername','$AthleteFirst','$AthleteLast','$AthleteFriendly','$AthleteEmail','$FirstRideDate',$CareerRidesLegacy,'$ClubRank');\n"; $ClubMemberListJS.="clubMemberList.push(clubMember);\n"; } } } foreach ($ClubMemberDetailsArray as $key => $ClubMember) { $UserID = $ClubMember[0]; $AthleteID = $ClubMember[1]; $AthleteNameL = $ClubMember[2]; $AthleteInitials = $ClubMember[3]; $AthleteFriendly = $ClubMember[4]; $AthleteFull = $ClubMember[5]; $IsCoffeeFundContributor = $ClubMember[6] == 1 ? "Yes" : "No"; $CheckedIsCoffeeFund = $ClubMember[6] == 1 ? "checked" : ""; $AccessTokenExpiresAt = "-"; if($ClubMember[7] > 0) $AccessTokenExpiresAt = RF_MAIN_dateformat($ClubMember[7],35); $ClubRank = $ClubMember[8]; $CareerRides = $ClubMember[9]; $FirstRideDate = $ClubMember[10]; //Prepare the DisplayName if($AthleteFriendly != "") { $AthleteDisplay = trim(str_replace("The","",$AthleteFriendly)); } else { $AthleteDisplay = $AthleteFull; } $RowClassName = ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; //Prepare the Permissions $CheckedCanModerate = ""; $CheckedCanRank = ""; $CheckedCanEdit = ""; $CheckedIsSiteAdmin = ""; $resultPermissions = mysql_query("SELECT * FROM stravaTblStravaClubsAdmins WHERE StravaClubsID=$StravaClubsID AND UserID=$UserID",$db); while ($myrow = mysql_fetch_array($resultPermissions)) { $CanModerate_DB = $myrow["CanModerate"]; $CanRank_DB = $myrow["CanRank"]; $CanEdit_DB = $myrow["CanEdit"]; $IsSiteAdmin_DB = $myrow["IsSiteAdmin"]; $CheckedCanModerate = $CanModerate_DB == 1 ? "checked" : ""; $CheckedCanRank = $CanRank_DB == 1 ? "checked" : ""; $CheckedCanEdit = $CanEdit_DB == 1 ? "checked" : ""; $CheckedIsSiteAdmin = $IsSiteAdmin_DB == 1 ? "checked" : ""; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } ?>
Name Nickname Rank First Ride # of Rides Coffee Fund Token Expiry Site Admin? Moderate? Rank? Edit?
$AthleteFull\n"; echo "\n"; echo "$AthleteDisplay$ClubRank$FirstRideDate$CareerRides$AccessTokenExpiresAt
\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; echo "
 
\n"; echo "
 
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; include_once "$RF_GLOBAL_webpath/templates/default/includes/strava/inc_strava_clubs_rider_editor_generic.php"; ?> StravaClubChallengesID = $StravaClubChallengesID

"; $StravaSegmentList = ""; if(isset($_REQUEST["StravaClubChallengesID"]) && intval($_REQUEST["StravaClubChallengesID"]) > 0) { $ButtonLabel = "Update"; $StravaClubChallengesID = intval($_REQUEST["StravaClubChallengesID"]); $resultChallenge = mysql_query("SELECT * FROM stravaTblStravaClubChallenges WHERE StravaClubChallengesID=$StravaClubChallengesID",$db); while ($myrow = mysql_fetch_array($resultChallenge)) { $ChallengeName = $myrow["Title"]; $ChallengeDesc = $myrow["Description"]; $ChallengeType = $myrow["ChallengeType"]; $ChallengeMetric = $myrow["ChallengeMetric"]; $StravaSegmentID = $myrow["StravaSegmentID"]; $NotifyWhenLeaderChanges = $myrow["NotifyWhenLeaderChanges"]; $UseAgeBasedAdjustment = $myrow["UseAgeBasedAdjustment"]; $UseKOMBasedAdjustment = $myrow["UseKOMBasedAdjustment"]; $SegmentsMustOccurInOneActivity = $myrow["SegmentsMustOccurInOneActivity"]; $IsTeamChallenge = $myrow["IsTeamChallenge"]; $TeamSize = $myrow["TeamSize"]; $TeamIsAdminManaged = $myrow["TeamIsAdminManaged"]; $EmailTemplateID = $myrow["EmailTemplateID"]; $EmailContentID = $myrow["EmailContentID"]; $StartDate = $myrow["StartDate"]; $EndDate = $myrow["EndDate"]; $JSONSegmentDescriptions = $myrow["JSONSegmentDescriptions"]; } if(strlen($StravaSegmentID) > 0) { if(strpos($StravaSegmentID,"|") > -1) { $SegmentDescriptions = json_decode($JSONSegmentDescriptions); for($y=0;$ysegmentId; $CurSegmentName = $SegmentDescriptions[$y]->name; $StravaSegmentList.="var segItem = new ChallengeSegment($CheckSegmentID,\"$CurSegmentName\");\n"; $StravaSegmentList.="segmentsList.push(segItem);\n"; } } else { $SegmentDescriptions = json_decode($JSONSegmentDescriptions); $CheckSegmentID = $SegmentDescriptions->segmentId; $CurSegmentName = $SegmentDescriptions->name; $StravaSegmentList.="var segItem = new ChallengeSegment($CheckSegmentID,\"$CurSegmentName\");\n"; $StravaSegmentList.="segmentsList.push(segItem);\n"; } } } else { $ButtonLabel = "Add"; $StravaClubChallengesID = 0; $ChallengeName = ""; $ChallengeDesc = ""; $ChallengeType = ""; $ChallengeMetric = ""; $StravaSegmentID = 0; $UseAgeBasedAdjustment = 0; $UseKOMBasedAdjustment = 0; $SegmentsMustOccurInOneActivity = 1; $IsTeamChallenge = 0; $TeamSize = 0; $TeamIsAdminManaged = 0; $StartDate = $CurDate; $EndDate = RF_MAIN_add_months_to_date($CurDate, 1); } echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "

Club Challenges

\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
NameID 
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; ?>

">

">
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; $count = mysql_query("SELECT count(StravaClubChallengesID) as num from stravaTblStravaClubChallenges WHERE WebsitesID=$CurWebsiteID AND StravaClubsID=$StravaClubsID"); $numChallenges = mysql_result($count,0,"num"); if($numChallenges > 0) { echo "
\n"; echo "
\n"; echo "

Current Club Challenges

\n"; echo "
    \n"; $ChallengeCounter = 0; $resultChallenge = mysql_query("SELECT * FROM stravaTblStravaClubChallenges WHERE WebsitesID=$CurWebsiteID AND StravaClubsID=$StravaClubsID ORDER BY StartDate DESC ",$db); while ($myrow = mysql_fetch_array($resultChallenge)) { $StravaClubChallengesID = $myrow["StravaClubChallengesID"]; $ChallengeName = $myrow["Title"]; $ChallengeType = $myrow["ChallengeType"]; $ChallengeMetric = $myrow["ChallengeMetric"]; $StartDate = $myrow["StartDate"]; $StartDateF = RF_MAIN_dateformat($StartDate,10); $EndDate = $myrow["EndDate"]; $EndDateF = RF_MAIN_dateformat($EndDate,10); if($ChallengeCounter == 3) { echo "
\n"; if($ChallengeCounter > 3) echo "
\n"; echo "
\n"; echo "
\n"; } echo "
\n"; echo "
 
\n"; ?> 0) { $ButtonLabel = "Update"; $StravaClubRankingSeasonsID = intval($_REQUEST["StravaClubRankingSeasonsID"]); $resultSeason = mysql_query("SELECT * FROM stravaTblStravaClubRankingSeasons WHERE StravaClubRankingSeasonsID=$StravaClubRankingSeasonsID",$db); while ($myrow = mysql_fetch_array($resultSeason)) { $SeasonName = $myrow["Title"]; $SeasonDesc = $myrow["Description"]; $ChallengeType = $myrow["ChallengeType"]; $SeasonStartDate = $myrow["StartDate"]; $SeasonEndDate = $myrow["EndDate"]; } } else { $ButtonLabel = "Add"; $StravaClubRankingSeasonsID = 0; $SeasonName = ""; $SeasonDesc = ""; $SeasonStartDate = $CurDate; $SeasonEndDate = RF_MAIN_add_months_to_date($CurDate, 3); } echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "

Club Ranking System

\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
 
\n"; echo "
\n"; ?>

">

">
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; $count = mysql_query("SELECT count(StravaClubRankingSeasonsID) as num from stravaTblStravaClubRankingSeasons WHERE WebsitesID=$CurWebsiteID AND StravaClubsID=$StravaClubsID"); $numSeasons = mysql_result($count,0,"num"); if($numSeasons > 0) { echo "
\n"; echo "
\n"; echo "

Current Seasons

\n"; echo "
    \n"; $SeasonCounter = 0; $resultSeason = mysql_query("SELECT * FROM stravaTblStravaClubRankingSeasons WHERE WebsitesID=$CurWebsiteID AND StravaClubsID=$StravaClubsID ORDER BY StartDate DESC ",$db); while ($myrow = mysql_fetch_array($resultSeason)) { $StravaClubRankingSeasonsID = $myrow["StravaClubRankingSeasonsID"]; $SeasonName = $myrow["Title"]; $SeasonStartDate = $myrow["StartDate"]; $SeasonStartDateF = RF_MAIN_dateformat($SeasonStartDate,10); $SeasonEndDate = $myrow["EndDate"]; $SeasonEndDateF = RF_MAIN_dateformat($SeasonEndDate,10); if($SeasonCounter == 3) { echo "
\n"; if($SeasonCounter > 3) echo "
\n"; echo "
\n"; echo "
\n"; } echo "
\n"; echo "
 
\n"; ?> \n"; ?> getMessage(); } ?>