Results 1 to 13 of 13

Thread: Seventeen Or Bust Stats

  1. #1

    Seventeen Or Bust Stats

    In SOB why is team "Joffe" listed as project rank #132 with 66.385T points?
    Shouldn't they be around position #164?

  2. #2
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    It's a team name change, old row is still in the database but 'marked' for deletion. If you notice it hadn't been included in the ranking (another team also was ranked 132).

    I've deleted all marked rows for sob manually. They'll propagate to live on next minor update.

    Bok

  3. #3
    Thanks Bok.
    Again your very helpful.

    One last question then I'll try not to ask any more of you for a while.

    I have a team mate that runs SoB for our team and shows up on the SoB's website stats page under our team but is not listed on our team on the Free-DC's website stats page.
    Any ideas for him?
    SoB team stats: http://www.seventeenorbust.com/stats...tml?teamID=646
    SoB user stats: http://www.seventeenorbust.com/stats...l?userID=15914
    Free-DC team stats: http://stats.free-dc.org/stats.php?p...j=sob&team=646

  4. #4
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    hmm,

    it looks like a bug in the parser due to the new file I'm now parsing.

    Looking at the file I see

    User 15914 EricE 1236284598 none 0 0 1 2195873536 0 1236284624 1236284975

    User 15914 EricE 1236284598 646 2 2 12 13890377481728 378976216966.035 1236367078 1237941930

    My parser inserts the first row to a temp table then basically does an
    insert ignore on the second line
    .

    That's going to be a bit tricky due to the way I do it, might have to talk to Louie to see if he can change the way they produce that file..

    Bok

  5. #5
    Thanks Bok, looks like that fixed it.
    I have to say your one of the best Administrators out there.
    Thanks again.

  6. #6
    Free-DC Semi-retire gopher_yarrowzoo's Avatar
    Join Date
    Mar 2002
    Location
    Knoxville, TN
    Posts
    3,985
    Yes we aim to please with layouts and fixes behind the scenes..
    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..


  7. #7
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    Quote Originally Posted by Razor_FX_II View Post
    Thanks Bok, looks like that fixed it.
    I have to say your one of the best Administrators out there.
    Thanks again.


    I haven't done anything yet, other than PM jjjL to ask if he could consolidate the list.. perhaps he already has

    hmm, looking at the most recent text dump, the order has changed for EricE thereby putting in the first row correctly... still I'd rather have it consolidated as that would be the full score..

  8. #8
    Wow. I would never have noticed this. Thanks guys.

    It's fixed now.

    The textStats2 should now behave exactly like textStats except for jEMs are cEMs.

    Cheers,
    Louie

  9. #9
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    Louie,

    I think you've corrected the file to consolidate the scores, but perhaps you are populating the oldest teamid rather than the newest one ?

    For instance in the example earlier in this thread.

    http://www.seventeenorbust.com/stats...tml?teamID=646

    EricE appears in the team

    but does not show in the Free-DC stats

    Looking at the file shows he has a team of none

    User 15914 EricE 1236284598 none 2 0 13 14664525274368 339159845998.055 1236284624 1238029288



    Bok

  10. #10
    Quote Originally Posted by Bok View Post
    Louie,

    I think you've corrected the file to consolidate the scores, but perhaps you are populating the oldest teamid rather than the newest one ?

    For instance in the example earlier in this thread.

    http://www.seventeenorbust.com/stats...tml?teamID=646

    EricE appears in the team

    but does not show in the Free-DC stats

    Looking at the file shows he has a team of none

    User 15914 EricE 1236284598 none 2 0 13 14664525274368 339159845998.055 1236284624 1238029288



    Bok
    Again... wouldn't have ever noticed that on my own. Thanks!

    Fixed now.


    Cheers,
    Louie

  11. #11
    Thank you everyone for your help.
    The [H]ard|OCP team appreciates it very much.

  12. #12
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    yup, all looks good now!

    Thanks Louie!

  13. #13
    Louie, i think you just broke the stats.. it was working fine until your fix.

    Sorry for the crosspost.. but please take a look at this post.

    http://www.free-dc.org/forum/showpos...9&postcount=38
    Last edited by DukeBox; 03-26-2009 at 12:41 PM.

Posting Permissions

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