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 "
\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 "
\n";
echo "
\n";
echo "
\n";
echo "
\n";
echo "
\n";
if(is_array($AthleteBikes))
{
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";
}
if($IsSiteAdmin == true)
{
//Club Members
//Set up the Form properties
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;$y
segmentId;
$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";
$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";
$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 "