Not signed in (Sign In)

Vanilla 1.1.9 is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthorjonas
    • CommentTimeFeb 4th 2011
     

    Is there a way to list questions that were formerly featured but are now solved so someone has gained the bounty? How about those that were featured but the bounty has expired?

  1.  

    You can search the public database dumps. When somebody starts a bounty on a question, they "vote" to do it with VoteTypeId="8". So you can get a list of the post IDs by searching votes.xml. Here's a complete list produced from the latest dump with the following command

    grep 'VoteTypeId="8"' votes.xml | sed -e 's|.*PostId="\([0-9]*\)".*|\[\1\](http://mathoverflow.net/questions/\1)|'
    

    (broken into multiple posts because of meta's character limit)

    138 410 689 385 959 2853 2791 3312 1527 3219 2888 2082 3701 1666 981 2369 3249 3430 1959 4661 4994 6271 4724 6442 6820 6749 6923 4790 6890 6379 6627 7016 7732 7318 7800 8247 8223 7650 4841 9321 8854 9492 8534 9645 7110 9756 9921 10116 9874 10356 10468 11091 10619 11301 11923 12078 9558 12765 11716 11603 10799 13394 13437 11675 5364 13873 14492 12322 15165 15359 15087 15243 8993 16132 15775 16078 12085 17250

  2.  
  3.  
    • CommentAuthorjonas
    • CommentTimeFeb 7th 2011
     

    Thanks for the help, Anton.