What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 129 Stack Exchange communities.

In the comments to Enthusiast and Fanatic Badge on the blog, a comment was added that a nice feature would be adding the number of consecutive days you've visited to the site to the user's profile.

I’d love to see on your user page a count of how many consecutive days you have been on SO/SF. Kind of like looking at your uptime on a Unix box. - Code Slave

I believe it would be a good feature and wanted to put it out there for discussion.

I know personally, I would like to be able to track how many consecutive days I've visited the site without having to figure it out on my own.

share|improve this question
8  
I was disappointed to see this suggestion already made, and yet-unanswered. –  Carson Myers Sep 17 '09 at 16:45
4  
I second this, I just reached 31 days as a member and yet no badge, so obviously I missed a day but I don't know if it was last week or 29 days ago. –  Rob Van Dam Jan 16 '10 at 18:03
3  
332 consecutive days on SO, do I get a double-gold when I hit 365? :) –  Ether Jun 22 '10 at 17:26
    
Doesn't seem to be on area51 yet... –  bdonlan Jun 23 '10 at 0:20
    

4 Answers 4

up vote 38 down vote accepted

This was a big suggestion following the creation of two new badges which were based on 30 consecutive days ("Enthusiast", earlier "Woot"), and 100 ("Fanatic").

I'm currently pursuing my "Woot" badge (and subsequently my "Fanatic" badge too) - somewhere between 20-25 days away I think.

share|improve this answer
5  
At least the 30 day one exists - I'm unsure whether to be proud to have it ;) –  Rowland Shaw Jun 29 '09 at 20:43
1  
I'd be proud - I'm currently working towards getting my 30 days...no clue as to how close I am...less than 30 days, that's for sure :) –  Jonathan Sampson Jun 29 '09 at 20:44
    
I'm with you Jonathan, I believe I've only missed one day (silly family vacations!), but I've have to search through a calendar to figure out how many days it has been since then. –  Timothy Carter Jun 29 '09 at 20:45
1  
So is this development under way? –  user146056 Apr 13 '10 at 23:07
1  
I know I've been visiting for more than 60 days because SO is my homepage but my count shows 13, seems bugged. –  kd7 Jun 22 '10 at 12:41
    
I think there is a bug, I was on SO from home last night, then I got on at work today, my profile said 8 then i refreshed and it said 1. Kinda strange. I wonder if using different computers causes issues? –  JD Isaacks Jun 28 '10 at 13:58
    
So I have 41 consecutive days... why dont I have the badge? –  FabianCook Oct 7 '12 at 9:56
    
Its actually Fanatic for 100 days and Enthusiast for 30 –  FabianCook Oct 7 '12 at 9:58

I would find a concurrent-days counter interesting.

I'm pretty sure I have been on both StackOverflow and ServerFault for more than 30 days in a row.

But no badge.

It is easy to visit StackOverflow every day and still "miss a day." StackOverflow's day starts at midnight (GMT). So my "StackOverflow day" starts at 8pm, my time (Eastern Time). So it is conceivable that I simply logged in one morning and didn't check back until much later the next day... technically "missing" a day-as-tracked-by-stackoverflow in between.

I'll be okay.


UPDATE: Oh, crap. A possible slight miscalculation. I might-- just might-- have another day or two to go. We'll see.

share|improve this answer
1  
That last part is a good point. What is the deadline for being counted as visiting the site "today"? I happened to think of this one evening at 11:55 p.m. –  JSchaefer Jun 29 '09 at 21:17
    
My max-votes-per-day counter starts sometime around 7pm (Eastern Time). It might be when I originally signed up, or something. I don't know if concurrent days are counted the same way. –  Robert Cartaino Jun 29 '09 at 21:48
2  
I believe all timing (for rep caps, voting, etc) is based on Greenwich Mean Time. –  Timothy Carter Jun 30 '09 at 1:52
3  
I think you are right. I watched last night and it turns out my "day" starts at exactly 8pm and my timezone is GMT -4h. So, if you log in at different times of the day, you can easily miss a "StackOverflow day." I'm going to update my orginal post. –  Robert Cartaino Jun 30 '09 at 13:45
1  
Similarly, you can double your days by being active around midnight UTC (So, if you're in a timezone that is UTC-5, and accounting for daylight savings, you'd need to be active from around 19:45 to 20:15 every other day) –  Rowland Shaw Aug 13 '09 at 8:01
2  
Unfortunately, it doesn't work for 28 hour days. xkcd.com/320 –  LeakyCode Sep 9 '09 at 7:01
1  
+1: I'm glad I'm not the only one surprised by that (sorry). I set my computer to auto-load all the sites at 7 pm, as insurance in case I hadn't gone yet that day. I'm at GMT -5, so I was pretty disappointed 100 days later. I guess I must have been off by a second or two a few times. –  Pops May 11 '10 at 22:47
    
This is so disappointing. I've been working this for over two weeks and I login today only to see that serverfault.com, my most visited, only has 3 days. Ugh! Robert Thanks for the info. –  citadelgrad Jun 23 '10 at 15:18

This kind of query would be able to provide the data for the profile.

with numberedrows as(        
select 
   row_number() over (partition by UserID order by CreationDate desc) as NumRowsFromToday,
   datediff(day,CreationDate,getdate())+1 as DaysFromToday, 
   CreationDate, 
   UserID        
from tablename
where UserID = @UserID /* Optional line that can be removed to get everyone's current run */
)
select UserID, min(CreationDate) as StartOfRun, max(DaysFromToday) as LengthOfRun
from numberedrows
where DaysFromToday = NumRowsFromToday
group by UserID
order by max(DaysFromToday);

Here's the idea behind the query:

I know from http://stackoverflow.com/questions/1176011/sql-to-determine-minimum-sequential-days-of-access that they only store one entry per user per day (if not, then DENSE_RANK is needed instead of ROW_NUMBER, and the OVER clause needs to truncate the date). So if you number those days (backwards), then the current run of consecutive days only includes entries where the rownumber is the same as the number of days from then to today (plus one, so that you don't start counting that number of days from 0).

With an index on (UserID, CreationDate), this should run quickly too.

So... hopefully Jeff & co are keeping an eye on this question, and can consider it?

Rob

share|improve this answer

Thanks for implementing this feature.

I had been wondering for quite a while when I'd hit that 100 day mark and finally get the dang badge. All the while, religiously hitting the site every day, even adding a bookmark on my iPhone so I could click it to get credit if I was traveling or didn't otherwise have access to a computer or the Internet on a given day.

So I click over to my profile and I am at...(drum-roll)... 15 consecutive days... F@#$!K

Somehow, somewhere I must have not clicked hard enough on the link to the site, or perhaps it was the time-zone thing, or God knows what, but after roughly 6 months of chasing this badge I am nowhere near getting it apparently.

The reason I am appreciative for this feature is that I finally know where I stand. I'm going back to just visiting the site when I have a question or feel like answering them, instead of checking in every day, just to hit roll call. Thanks for giving me back a few minutes of my day.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .