obscurerichard
Forum Replies Created
-
AuthorPosts
-
obscurerichard
ParticipantWe have a POGGIO leaderboard for individuals and teams now.
Should it link to this thread? See freezing-web issue #152.
obscurerichard
ParticipantThe issue with 10-mile+ rides getting an extra 10 points is now resolved, see the before and after queries below for arlcxrider:
mysql> select a.id, f.forum_name, a.display_name, ds.* from daily_scores ds join athletes a on (a.id = ds.athlete_id) join forum_users f on (f.id = ds.athlete_id) where f.forum_name=’arlcxrider’;
+
+
+
+
+
+
+
+
+
| id | forum_name | display_name | team_id | athlete_id | distance | points | ride_date |
+
+
+
+
+
+
+
+
+
| 43537271 | arlcxrider | Paul W | 567288 | 43537271 | 52.50500011444092 | 117.50500011444092 | 2020-01-01 |
| 43537271 | arlcxrider | Paul W | 567288 | 43537271 | 13.889000415802002 | 78.889000415802 | 2020-01-02 |
| 43537271 | arlcxrider | Paul W | 567288 | 43537271 | 15.393999576568604 | 80.3939995765686 | 2020-01-03 |
| 43537271 | arlcxrider | Paul W | 567288 | 43537271 | 12.182999968528748 | 77.18299996852875 | 2020-01-04 |
+
+
+
+
+
+
+
+
+
4 rows in set (0.01 sec)mysql> select a.id, f.forum_name, a.display_name, ds.* from daily_scores ds join athletes a on (a.id = ds.athlete_id) join forum_users f on (f.id = ds.athlete_id) where f.forum_name=’arlcxrider’;
+
+
+
+
+
+
+
+
+
| id | forum_name | display_name | team_id | athlete_id | distance | points | ride_date |
+
+
+
+
+
+
+
+
+
| 43537271 | arlcxrider | Paul W | 567288 | 43537271 | 52.50500011444092 | 107.50500011444092 | 2020-01-01 |
| 43537271 | arlcxrider | Paul W | 567288 | 43537271 | 13.889000415802002 | 68.889000415802 | 2020-01-02 |
| 43537271 | arlcxrider | Paul W | 567288 | 43537271 | 15.393999576568604 | 70.3939995765686 | 2020-01-03 |
| 43537271 | arlcxrider | Paul W | 567288 | 43537271 | 12.182999968528748 | 67.18299996852875 | 2020-01-04 |
+
+
+
+
+
+
+
+
+
4 rows in set (0.00 sec)obscurerichard
ParticipantI also want to extend my sincere thanks to merlin, secstate, and jrenaut who have all made contributions that have made it to the live site this year!
:cool:I’m super happy we have had more active volunteers this year!
obscurerichard
Participant@Olive 195761 wrote:
Tech Question. If I set up a “Privacy Zone” on Strava, will this mess with my FS data? (Strava info page on Privacy Zone says something about affecting positions on leaderboards? But I’m not a tech person.)
Thanks!
I don’t think so. The Privacy Zone bit in Strava says this:
You will not appear on any segment leaderboard that starts/stops within your Privacy Zone and you cannot hold or earn any QOMs/CRs on those segments. Removing a Privacy Zone will reinstate your segment matches and any associated KOMs/CRs.
It makes it so that Strava does not show map segments close to your privacy zone, it does not affect distance recorded as far as I know.
obscurerichard
Participant@LhasaCM 195676 wrote:
Yes – a bonus 10 points for you. All subject to change, and no, it doesn’t really matter.
Indeed, subject to change, see https://github.com/freezingsaddles/freezing-model/issues/20
We’ll have this fixed quickly. Thanks LhasaCM & arlcxrider!
obscurerichard
Participant@Steve O 195632 wrote:
One of my favorite things to do is look at the photos on the home page. Fun!
In the past I believe the photos included reference to who posted them. This year there is no attribution. Any way we can add that?
Also, is the web site picking up photos from Instagram? If so, what is the appropriate hashtag?
Thanks!
[ATTACH=CONFIG]20592[/ATTACH]
Strava stopped integrating with Instagram several years ago, so there’s no Instagram integration. It has its own photo service now, so only photos you add to your ride on Strava will show up.
We’re tracking this as freezing-web issue #145
obscurerichard
Participant@cvcalhoun 195678 wrote:
Not sure if this has been reported, but the “Dirty Biker” page and the “Tortoise and Hare” page, among other Pointless pages, produce internal server errors.
It had not been reported separately, but I noticed this today and fixed it as part of adding the POGGIO leaderboards, which also use the generic leaderboard code.
obscurerichard
Participant@bentbike33 195557 wrote:
Thought I’d alert you to a bug in the individual leaderboard: The new scoring system is not working for people who recorded multiple rides today. Here is the bottom of the leaderboard as of 4:33 01/01/2020:
Millie T 33 points (1 days, 3 miles) Freezing Saddles 2020
arthur r 33 points (1 days, 2 miles) Freezing Saddles 2020
Lilli B 32 points (1 days, 2 miles) Freezing Saddles 2020
Samantha M 32 points (1 days, 16 miles) Freezing Saddles 2020
Elizabeth 32 points (1 days, 2 miles) Freezing Saddles 2020
Mary E 31 points (1 days, 2 miles) Freezing Saddles 2020
Andrew S 28 points (1 days, 35 miles) Freezing Saddles 2020
Ken B 26 points (1 days, 12 miles) Freezing Saddles 2020
Jim B 25 points (1 days, 2 miles) Freezing Saddles 2020
Tim V 25 points (1 days, 1 miles) Freezing Saddles 2020
Pablo V 23 points (1 days, 1 miles) Freezing Saddles 2020
Kenneth J 23 points (1 days, 1 miles) Freezing Saddles 2020
George T 22 points (1 days, 1 miles) Freezing Saddles 2020
Kelliefrom N 22 points (1 days, 1 miles) Freezing Saddles 2020
Carol [emoji110] 21 points (1 days, 1 miles) Freezing Saddles 2020
Retro D 20 points (1 days, 6 miles) Freezing Saddles 2020
Sam F 20 points (1 days, 17 miles) Freezing Saddles 2020
Casey [emoji1271] 18 points (1 days, 44 miles) Freezing Saddles 2020It should be fixed now.
Sent from my iPhone using Tapatalk
obscurerichard
ParticipantThanks for reporting this bentbike33! We are on it – issue 138 in freezingsaddles/freezing-web.
obscurerichard
Participant@Steve O 194660 wrote:
Looks like you included that final second.
Sure, but this is way more strict than last year, where we included an ENTIRE MINUTE of what is effectively a grace period for ride end times to be included, the setting for 2019 was:
END_DATE=2019-03-20T00:01:00-04:00[/CODE]
(I assume it was that way in 2018 and earlier – when I updated this last year I didn’t touch anything beyond the year, month, and day)[CODE]END_DATE=2019-03-20T00:01:00-04:00[/CODE]
(I assume it was that way in 2018 and earlier – when I updated this last year I didn’t touch anything beyond the year, month, and day)
obscurerichard
Participant@jrenaut 194605 wrote:
I thought we adjusted all the leaderboards to only pull rides from people who are on real teams, so that if you aren’t on a team you only show on the Friends of BAFS leaderboard. But it’s kinda late on Sunday night of a big 4 day weekend, and I’m too tired to go check the code.
I checked the code and it just pulls from the rides table. That table is not restricted by team membership. So if someone joined the Freezing Saddles 2020 team and then visited the authorization page and completed authorization, I think their rides would get recorded and would count towards the Pointless Kids leaderboard if they had a #withkidCodename in the description.
obscurerichard
Participant@jrenaut 194597 wrote:
Currently, no. It wouldn’t be impossible to do it that way, but it introduces some complexities that I’m not sure we’re prepared to manage. I’ll think about it a bit and see if I can come up with a solution.
An alternate plan for you is to recruit your spouse. YMMV, but I got MY spouse to compete by introducing her to the Beerneuring contest.
@jreneaut and I gave contrary answers here, and I think he’s partially right.
I think the last part of the magic is that this person would have to authorize the Freezing Saddles application to read their rides.
obscurerichard
Participant@Brownws 194595 wrote:
Thanks,
Can a “Friend of BAFS” tag her codename with rides? My spouse isn’t interested in registering but would like to help the little one rack up points.
As long as this person joins the main Freezing Saddles 2019 team, and authorizes Strava to read their rides, and tags the ride with a #withkidCodename, the ride will count. We sync rides for everyone who is on the main team. The query that compiles the summary miles does not discriminate among riders on exactly one official competition team in addition to the main team, as the individual and team leaderboards do.
obscurerichard
Participant@secstate 194204 wrote:
I have the time. I’m trying to build the skills but am not sure if I have them yet — looking through the GitHub page, I can’t say I fully understand how all the pieces fit together. I volunteer, but only under the condition you think I’ll alleviate more headaches than I’ll cause.
I have taken some online courses and done basic work in Python/Flask, SQL, HTML/CSS, and even a little JavaScript. All of these (well, maybe not the JavaScript quite yet) have been useful in my PhD research and I’d like to take them further. Working on the tech side of BAFS seems like potentially a good way to do this as well as to give back to this great competition. I have your e-mail and will send you a note.
I worked with @secstate this weekend to help him climb the learning curve and hammer out some issues with the documentation in the freezing-web and freezing-compose repositories. Congratulations @secstate on getting a fully functioning local development environment running!
:cool::cool::cool::cool:
I’m looking forward to collaborating with you more on Freezing Saddles this year!
obscurerichard
ParticipantI’ve just completed the yearly cleaning of the database to prepare it for the new competition, and after consulting both this thread and some official documentation the dates in the system are now fixed:
# When does the competition end?
# This can be an exact time;
# the API will start recording rides began after this time.
START_DATE=2020-01-01T00:00:00-05:00# When does the competition end?
# This can be an exact time;
# the API will stop recording rides ended after this time.
END_DATE=2020-03-20T00:00:00-04:00
[/CODE][CODE]
# When does the competition end?
# This can be an exact time;
# the API will start recording rides began after this time.
START_DATE=2020-01-01T00:00:00-05:00# When does the competition end?
# This can be an exact time;
# the API will stop recording rides ended after this time.
END_DATE=2020-03-20T00:00:00-04:00
[/CODE] -
AuthorPosts