In SOB why is team "Joffe" listed as project rank #132 with 66.385T points?
Shouldn't they be around position #164?
Printable View
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 :cheers:
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..
:blush:Quote:
Originally Posted by Razor_FX_II
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..
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
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
:cheers:
Bok
Again... wouldn't have ever noticed that on my own. Thanks!Quote:
Originally Posted by Bok
Fixed now.
Cheers,
Louie
Thank you everyone for your help.
The [H]ard|OCP team appreciates it very much.
yup, all looks good now!
Thanks Louie!
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