In SOB why is team "Joffe" listed as project rank #132 with 66.385T points?
Shouldn't they be around position #164?
In SOB why is team "Joffe" listed as project rank #132 with 66.385T points?
Shouldn't they be around position #164?
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
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
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
Thanks Bok, looks like that fixed it.
I have to say your one of the best Administrators out there.
Thanks again.
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..
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..
Thank you everyone for your help.
The [H]ard|OCP team appreciates it very much.
yup, all looks good now!
Thanks Louie!