Results 1 to 14 of 14

Thread: Team Pages

  1. #1
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13

    Team Pages

    I've done some preliminary work on these...

    Here are some examples..

    http://stats.free-dc.org/stats.php?p...n&team=Free-DC

    http://stats.free-dc.org/stats.php?p...team=AMD+Users

    http://stats.free-dc.org/stats.php?p...bbers+Kick+Ass (for KAMCOBILL

    http://stats.free-dc.org/stats.php?p...m=Ars+Technica

    But in actuality everything is in there.

    I created a table and did an insert into (select distinct team from) to generate the initial data ( 130,000 distinct teams are in the DB.... )

    However please note that where the team name was different they don't show up right now.. An example of that is the Free-DC DPAD team which is actually Free-DC.org.

    The infrastructure is in place to hold the data of course, for the above example it's just another insert using the right data, but that's almost impossible to do manually myself..

    So, I need to write a version of statstool for the teams to allow people to request new ids for teams projects. I'll be doing that next..

    I added the milestones for the team (from boinc projects only for now) to the bottom of the page as well

    Perhaps I'll allow for team logos too.. ??

    Bok

  2. #2
    Free-DC Retire gopher_yarrowzoo's Avatar
    Join Date
    Mar 2002
    Location
    Santa Ana, CA
    Posts
    3,978
    .... team logos if suitable can then be used as backgrounds (if user selects to) in their tag..
    Note: this may break the tag but hey we'll fix it...
    Retired from Free-DC...
    I don't have the time or money to help anymore...

  3. #3
    OK Looking good. Great Work and Thanks
    X Grubbers Kick Ass

    Check Out Our Site





  4. #4
    Yay Team Pages!

    Thanks Bok!

    One question though, is there any way to combine the following into a single "Team Haiku" page like we had before?

    http://stats.free-dc.org/stats.php?p...m=Team%20Haiku
    http://stats.free-dc.org/stats.php?p...team=TeamHaiku

    Or, is there a way to formulate a URL that grabs both maybe?

  5. #5
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    yes, though only manually right now,

    All of the data I've pulled in so far is automatic, matching on the teamname.

    I've yet to write the frontend to allow you to amend/add team id's.

    So, say you want to have

    http://stats.free-dc.org/stats.php?p...m=Team%20Haiku

    as your main real page, I'll provide a link from that page where you will be able to specify the teamid for your SoB team (for example) as 337 and then it will show up on this page.

    Let me add the two from the 2nd page manually and I'll show you what I mean. Ok, now look at

    http://stats.free-dc.org/stats.php?p...m=Team%20Haiku

    And you'll see those two teams show up.

    Impossible for me to do them all automatically, so I have to provide a mechanism for people to add them themselves. However I can't just let people update anything....as you could destroy other teams data

    So, I'll add a page where you select the project, add the id, it will insert this into a holding table for review by an admin..

    But you see the end result

    By the way I also found the following teams in the database too..

    http://stats.free-dc.org/stats.php?p...%20Haiku%20Old

    and

    http://stats.free-dc.org/stats.php?p...gitalHaiku.com

    Yet to do the page though...just finishing up my first rewrite of the navigation around the pages..

    Bok

  6. #6
    Quote Originally Posted by Bok View Post
    Let me add the two from the 2nd page manually and I'll show you what I mean. Ok, now look at

    http://stats.free-dc.org/stats.php?p...m=Team%20Haiku

    And you'll see those two teams show up.
    Yep! Nice

    By the way I also found the following teams in the database too..

    http://stats.free-dc.org/stats.php?p...%20Haiku%20Old
    That was a mistake - we (I) created a team and then realized there was one already with a slightly different name, so we discontinued the one I created (renaming it to "Old") and made the other one the official.

    I assume your system is not setup to combine two teams into a single stat, and frankly, I think this would be pointless

    Thus, safe to ignore that one.

    Not sure where this one comes from - the website doesn't look familiar... probably just a coincidental name (thanks for looking though!)

    Anyhow, looking great, thanks for putting in the effort Bok.

    - Urias

  7. #7
    Hi Bok,

    I was wondering if there's a way to add projects to teams (like in old stats). I have 3 projects that aren't showing up in our team stats:

    Cels @ Home Test 2
    PSP DoubleCheck
    Ramsey @ home

    Or is it caused on my end somewhere?

    Thanks

    Bill

  8. #8
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    I just haven't had the time to finish the page which allows you to update this I'm afraid.. so much to do, so little time to do it

    I'll add them in for you.

    I only added Ramsey@Home an hour ago !!!

    Bok

    *DONE* though you haven't got a Ramsey@Home team yet in the stats I added it in based on your teamid from the projects website. Next time they export the xml it will pick it up

  9. #9
    Old Timer jasong's Avatar
    Join Date
    Oct 2004
    Location
    Arkansas(US)
    Posts
    1,778
    /me googles Ramsey@Home(edit coming in a few)

  10. #10
    Hi Bok,

    Will pPOT Tables have to be added manually too?

    Thanks

    Bill

  11. #11
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    Everything will have to be manually added..

    I just added the stats for pPot tables, not many teams yet..

  12. #12
    Hey OK.
    X Grubbers Kick Ass

    Check Out Our Site





  13. #13
    Can you make it possible under the teampages, by clicking "project ranks" that it makes a list from first to last and the other way around?

  14. #14
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    yes, should be doable.

    Bok

Posting Permissions

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