PDA

View Full Version : Seventeen Or Bust Stats



Razor_FX_II
03-24-2009, 04:46 PM
In SOB why is team "Joffe" listed as project rank #132 with 66.385T points?
Shouldn't they be around position #164?

Bok
03-24-2009, 04:54 PM
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:

Razor_FX_II
03-24-2009, 11:51 PM
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/teams/team.mhtml?teamID=646
SoB user stats: http://www.seventeenorbust.com/stats/users/user.mhtml?userID=15914
Free-DC team stats: http://stats.free-dc.org/stats.php?page=team&proj=sob&team=646

Bok
03-25-2009, 07:08 AM
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

Razor_FX_II
03-25-2009, 03:25 PM
Thanks Bok, looks like that fixed it.
I have to say your one of the best Administrators out there.
Thanks again.

gopher_yarrowzoo
03-25-2009, 04:17 PM
Yes we aim to please with layouts and fixes behind the scenes..

Bok
03-25-2009, 04:34 PM
Thanks Bok, looks like that fixed it.
I have to say your one of the best Administrators out there.
Thanks again.

:blush:

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..

jjjjL
03-26-2009, 01:24 AM
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

Bok
03-26-2009, 08:52 AM
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/teams/team.mhtml?teamID=646

EricE appears in the team

but does not show in the Free-DC stats (http://stats.free-dc.org/stats.php?page=team&proj=sob&team=646)

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

jjjjL
03-26-2009, 09:15 AM
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/teams/team.mhtml?teamID=646

EricE appears in the team

but does not show in the Free-DC stats (http://stats.free-dc.org/stats.php?page=team&proj=sob&team=646)

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!

Fixed now.


Cheers,
Louie

Razor_FX_II
03-26-2009, 11:06 AM
Thank you everyone for your help.
The [H]ard|OCP team appreciates it very much.

Bok
03-26-2009, 11:31 AM
yup, all looks good now!

Thanks Louie!

DukeBox
03-26-2009, 12:18 PM
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/showpost.php?p=135039&postcount=38