Results 1 to 12 of 12

Thread: A thought: Free-DC Triple Crown

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member
    Join Date
    May 2013
    Location
    Davis, California // Beni Mekkoud, Morocco
    Posts
    33

    A thought: Free-DC Triple Crown

    So I was thinking that an additional badge that could be given out by Free-DC would be a "Triple Crown." It would be granted to anyone who simultaneously was in the top 10 for Trigggls, Boks, and TeraBoks. And once achieved it would continue to stay with the cruncher for life. As for the badge itself, how about the MM badge with three small crowns on top? Although I am not sure I like this as a crown is often given out by projects to represent that the cruncher has donated or contributed to the project.

    Currently one would need 7 TeraBoks, 18 Boks, and 13 Trigggls to achieve #10 rank in each of the categories.

    I though about the badge for being #1 in each category but that would require 16, 50, and 43 respectively. 109 projects would be very extremely hard to achieve, most serious crunchers have long since surpassed this. And newer crunchers are unlikely to have 109 projects (at any credit level) for a long time.


    ------
    Disclaimer I have 5, 6, and 20 projects respectively and should be able to achieve a triple crown in less than a year. The longest (but not hardest) would be the two additional TeraBoks.

  2. #2
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,451
    Blog Entries
    13
    I like the idea of giving out achievement badges, don't think this would be too difficult to implement, but not this holiday weekend

  3. #3
    Member
    Join Date
    May 2013
    Location
    Davis, California // Beni Mekkoud, Morocco
    Posts
    33
    No triple crown winner this year. I did have my fingers crossed for the horse from California.
    Bok, have you given any more thought to creating a Free-DC triple crown?

  4. #4
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,451
    Blog Entries
    13
    A bit, messed about with a little sql last week for it. Haven't forgotten.

  5. #5
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,451
    Blog Entries
    13
    I'm seriously doubting that anyone can achieve this. No-one has right now.




    mysql> select a.cpid from boinc_milestone_makers a where (a.mtype = 'boks' and a.projrank <=10) and exists (select 1 from boinc_milestone_makers b where b.mtype = 'teraboks' and b.projrank <=10 and a.cpid = b.cpid) and exists (select 1 from boinc_milestone_makers c where c.mtype = 'trigggls' and c.projrank <=10 and a.cpid = c.cpid);
    Empty set (0.00 sec)


    If we expand it out a little to top10 in Boks but top100 in the other 2 then we get results.


    mysql> select a.cpid from boinc_milestone_makers a where (a.mtype = 'boks' and a.projrank <=10) and exists (select 1 from boinc_milestone_makers b where b.mtype = 'teraboks' and b.projrank <=100 and a.cpid = b.cpid) and exists (select 1 from boinc_milestone_makers c where c.mtype = 'trigggls' and c.projrank <=100 and a.cpid = c.cpid);
    +----------------------------------+
    | cpid |
    +----------------------------------+
    | 3a045e428e45f087f7cc832bdb4791ff |
    | 4b0a4762e72ff7dfbc6384b64aba4722 |
    +----------------------------------+
    2 rows in set (0.00 sec)


    I know a Triple Crown should be difficult, but not impossible right?

  6. #6
    Free-DC Semi-retire gopher_yarrowzoo's Avatar
    Join Date
    Mar 2002
    Location
    Knoxville, TN
    Posts
    3,985
    Quote Originally Posted by Bok View Post
    I'm seriously doubting that anyone can achieve this. No-one has right now.




    mysql> select a.cpid from boinc_milestone_makers a where (a.mtype = 'boks' and a.projrank <=10) and exists (select 1 from boinc_milestone_makers b where b.mtype = 'teraboks' and b.projrank <=10 and a.cpid = b.cpid) and exists (select 1 from boinc_milestone_makers c where c.mtype = 'trigggls' and c.projrank <=10 and a.cpid = c.cpid);
    Empty set (0.00 sec)


    If we expand it out a little to top10 in Boks but top100 in the other 2 then we get results.


    mysql> select a.cpid from boinc_milestone_makers a where (a.mtype = 'boks' and a.projrank <=10) and exists (select 1 from boinc_milestone_makers b where b.mtype = 'teraboks' and b.projrank <=100 and a.cpid = b.cpid) and exists (select 1 from boinc_milestone_makers c where c.mtype = 'trigggls' and c.projrank <=100 and a.cpid = c.cpid);
    +----------------------------------+
    | cpid |
    +----------------------------------+
    | 3a045e428e45f087f7cc832bdb4791ff |
    | 4b0a4762e72ff7dfbc6384b64aba4722 |
    +----------------------------------+
    2 rows in set (0.00 sec)


    I know a Triple Crown should be difficult, but not impossible right?
    It's meant to be HARD to get... although we could find out the rules they use in the races and modify them
    Take a hard one to begin with, then add an easier one and then let everyone (even those who don't got the first two to race the third)
    Semi-retired from Free-DC...
    I have some time to help.....
    I need a new laptop,but who needs a laptop when you have a phone...
    Now to remember my old computer specs..


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •