Rules
Terms of Use

Page 1 of 2 1 2 >
Topic Options
#968957 - Sun Feb 24 2013 03:38 PM "Total Scores Yesterday" listing isn't right.
seadancer Offline
Enthusiast

Registered: Mon Feb 13 2012
Posts: 250
Loc: New York USA
Is there something wrong with the listing called "Total Scores Yesterday"?

On my team there's a fellow who is listed in the Team Member Listing as having been "Last Seen" on 2/18/13.

However, his name has been showing up each day on the "Total Scores Yesterday" listing.

---Sea


Edited by seadancer (Sun Feb 24 2013 03:43 PM)

Top
#968996 - Sun Feb 24 2013 05:06 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
mehaul Offline
Forum Champion

Registered: Wed Feb 03 2010
Posts: 6368
Loc: Florida USA
If they're good scores... pretend you're in a library, shhhh! smile
_________________________
If you aren't seeing Heaven while you dream, you're doing something wrong.
Dreams allow escape from the passage of Time.

The ultimate activity is the Dream.

Top
#969000 - Sun Feb 24 2013 05:39 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
Terry Offline

Head Honcho

Registered: Wed Dec 31 1969
Posts: 19273
Loc: USA
Who?

Top
#969002 - Sun Feb 24 2013 06:10 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
salami_swami Offline
Forum Champion

Registered: Thu Nov 01 2007
Posts: 8760
Loc: Colorado USA
I have noticed that in the past as well. When incognito101 left, her last score appeared daily for months. Her score did not increase, but every day she had 250 as today's score and yesterday's score, though the total didn't budge.

It seems to be a rare occurence.
_________________________
"The only water in the forest is the River."

Editor: Video Games, Entertainment

Top
#969004 - Sun Feb 24 2013 06:32 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
WesleyCrusher Offline

Administrator

Registered: Thu Sep 04 2008
Posts: 4537
Loc: Germany
Oh yes, that issue. If a player has no actual score two days in a row, but the earlier of the two had some bonus points from a daily, they will not get updated and their bonus stands as the "yesterday" score.

Example: Someone last played 4/17 and won a daily. They then disappear, but they have 250 pts on 4/18 for the win. That becomes their "today" score on the 18th, then their "yesterday" on the 19th and then the site fails to update them on the 20th and beyond, so the 250 will remain as the "yesterday" forever (or until the player scores again).

Guess this is due because the database is optimized only to update players seen in the last two days, but due to the carry-over from daily bonuses, it should be last three instead.


Edited by WesleyCrusher (Sun Feb 24 2013 06:35 PM)
_________________________
FunTrivia Editor (Hobbies and Sci/Tech) and Administrator
Guardian of the Tower

Top
#969010 - Sun Feb 24 2013 07:40 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
Terry Offline

Head Honcho

Registered: Wed Dec 31 1969
Posts: 19273
Loc: USA
Hmm that was an old problem Wes, but I thought I had fixed it (and it appears to be fixed in the code).

It would really be helpful if I knew who was being referenced here.

Or, anyone else who is CURRENTLY exhibiting this issue.

Top
#969012 - Sun Feb 24 2013 07:52 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
Terry Offline

Head Honcho

Registered: Wed Dec 31 1969
Posts: 19273
Loc: USA
Hmmm think I've tracked that player down looking at seadancer's team. Think I may know what the issue may be...

Top
#969018 - Sun Feb 24 2013 09:21 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
Terry Offline

Head Honcho

Registered: Wed Dec 31 1969
Posts: 19273
Loc: USA
Fixed.

Top
#969019 - Sun Feb 24 2013 09:52 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
gracious1 Offline
Prolific

Registered: Tue May 01 2012
Posts: 1021
Loc: New York USA
Where is this "Total Scores Yesterday" page?
_________________________
Speak less than you know; have more than you show.

Top
#969020 - Sun Feb 24 2013 10:13 PM Re: "Total Scores Yesterday" listing isn't right. [Re: Terry]
ozzz2002 Offline
Moderator

Registered: Mon Dec 03 2001
Posts: 18582
Loc: Sydney NSW Australia        
This link shows 250 points on his 'My Home' page. He has not been online for almost 18 months.
_________________________
The key to everything is patience. You get the chicken by hatching the egg, not smashing it.

Editor, Hobbies and Sports, and Forum Moderator

Top
#969022 - Sun Feb 24 2013 10:43 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
Terry Offline

Head Honcho

Registered: Wed Dec 31 1969
Posts: 19273
Loc: USA
Thanks ozz -- related issue has been fixed (today same problem as yesterday).

Top
#969023 - Sun Feb 24 2013 10:56 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
mehaul Offline
Forum Champion

Registered: Wed Feb 03 2010
Posts: 6368
Loc: Florida USA
Originally Posted By: gracious1
Where is this "Total Scores Yesterday" page?


It can be found from your team's Home Page, in the top Link Box, through "Yesterday"
When you get the linked page the title is "Total Scores Yesterday".
The link below is ID'd for the Mutant Noggins, just substitute your team's ID#.

http://www.funtrivia.com/team_yesterday.cfm?gid=22151


Edited by mehaul (Sun Feb 24 2013 10:57 PM)
_________________________
If you aren't seeing Heaven while you dream, you're doing something wrong.
Dreams allow escape from the passage of Time.

The ultimate activity is the Dream.

Top
#969027 - Sun Feb 24 2013 11:28 PM Re: "Total Scores Yesterday" listing isn't right. [Re: Terry]
gracious1 Offline
Prolific

Registered: Tue May 01 2012
Posts: 1021
Loc: New York USA
Was the issue the same "old problem" that had been fixed, but actually wasn't? Or was it a completely different problem? (Curiosity killed the cat, but satisfaction brought her back.)
_________________________
Speak less than you know; have more than you show.

Top
#969034 - Mon Feb 25 2013 01:10 AM Re: "Total Scores Yesterday" listing isn't right. [Re: gracious1]
seadancer Offline
Enthusiast

Registered: Mon Feb 13 2012
Posts: 250
Loc: New York USA
Originally Posted By: gracious1
Where is this "Total Scores Yesterday" page?


Gracious, in the box above the Message Board there's a link which says "Yesterday". When you click on it, it says "Total Scores Yesterday".

---Sea

Top
#969035 - Mon Feb 25 2013 01:17 AM Re: "Total Scores Yesterday" listing isn't right. [Re: Terry]
seadancer Offline
Enthusiast

Registered: Mon Feb 13 2012
Posts: 250
Loc: New York USA
Originally Posted By: Terry
Fixed.

Thank you, Terry.
---Sea

Top
#969046 - Mon Feb 25 2013 05:58 AM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
Picard25 Offline
Participant

Registered: Sat Oct 29 2011
Posts: 20
Loc: Austria
I think there might be a similar problem on the "FunTrivia Team Comparisons: Hourly Games Highest Scores over Past 24 Hours by Team" here (the link leads to the Medium Teams page):

http://www.funtrivia.com/teamstats_daily.cfm?size=medium

My name's listed as the team's (Movie Buffs) top score in the Average Hourly game, but I couldn't remember having played it at all yesterday and so I checked the scores. I really didn't play and Jonnyfive who is listed top in the Hard Hourly hasn't logged on since Feb 16.

Top
#969052 - Mon Feb 25 2013 07:33 AM Re: "Total Scores Yesterday" listing isn't right. [Re: Picard25]
TimBentley Offline
Explorer

Registered: Mon Apr 09 2012
Posts: 97
Loc: Indiana USA
And sorting doesn't work on that page. (I note that the data has changed so I assume that's been fixed.)


Edited by TimBentley (Mon Feb 25 2013 07:35 AM)

Top
#969053 - Mon Feb 25 2013 07:42 AM Re: "Total Scores Yesterday" listing isn't right. [Re: Picard25]
gracious1 Offline
Prolific

Registered: Tue May 01 2012
Posts: 1021
Loc: New York USA
Yes, I see a person who has not been on the team now for a couple of days listed on that page.

And the sorting still doesn't work.
_________________________
Speak less than you know; have more than you show.

Top
#969067 - Mon Feb 25 2013 08:16 AM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
WesleyCrusher Offline

Administrator

Registered: Thu Sep 04 2008
Posts: 4537
Loc: Germany
Yep, that person (lostcowboy1956) has last played for our team on the 20th or 21st, yet he's listed as yesterday's winner for the Easy Game. We also had a higher score than his 982 yesterday (985 by TriviaFan22), so it's not that his score has just been carried forward and compared to our team's other play.
_________________________
FunTrivia Editor (Hobbies and Sci/Tech) and Administrator
Guardian of the Tower

Top
#969105 - Mon Feb 25 2013 12:45 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
Terry Offline

Head Honcho

Registered: Wed Dec 31 1969
Posts: 19273
Loc: USA
Hmm I haven't made any changes to that today, so that was updating on its own.
lostcowboy shows as logging in today.

Are there any entries in the current chart that don't look right? There very well could be a bug in there -- haven't touched that stuff in a long time.

http://www.funtrivia.com/teamstats_daily.cfm?size=medium

Top
#969106 - Mon Feb 25 2013 12:59 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
Terry Offline

Head Honcho

Registered: Wed Dec 31 1969
Posts: 19273
Loc: USA
Just forced a stat update... it looks like the stats were all fine, but the screen had cached the results for too long.

Please keep an eye on it in the coming days and let me know if any of the stats don't look right.


Edited by Terry (Mon Feb 25 2013 12:59 PM)

Top
#969108 - Mon Feb 25 2013 02:17 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
WesleyCrusher Offline

Administrator

Registered: Thu Sep 04 2008
Posts: 4537
Loc: Germany
Lostcowboy logged in today, but for a different team - he changed on the 21st.
_________________________
FunTrivia Editor (Hobbies and Sci/Tech) and Administrator
Guardian of the Tower

Top
#969110 - Mon Feb 25 2013 02:31 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
Picard25 Offline
Participant

Registered: Sat Oct 29 2011
Posts: 20
Loc: Austria
I can't say for sure which stats might be wrong, but the scores on the "FunTrivia Team Comparisons: Medium teams" page don't correspond with the scores given on the "Team v Team Points Yesterday" of the three games (accessed through "Yesterday" "My Team" on each of the games' main pages). At least in case of the Movie Buffs.

Top
#969112 - Mon Feb 25 2013 02:49 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
Barbarini Offline
Enthusiast

Registered: Sat Sep 04 2010
Posts: 382
Loc: Alberta Canada
I noticed this a while ago Terry - the stats here are skewed...

http://www.funtrivia.com/teamstats2.cfm?size=small


For instance, it shows the team with the highest average number of badges per player as Heaven's Angels (225.4/player av) but if you look at their actual badges on their cumulative score page... http://www.funtrivia.com/groupquizstats.cfm?gid=16135 ... couldn't be possible. There's only one player on their team with more than 150 badges. In fact, I've done a quick check and it looks as though at least the first 6 teams in that one particular category should be much lower on those rankings. Any chance of you having a peek please?

Thanks Terry!

Top
#969114 - Mon Feb 25 2013 03:25 PM Re: "Total Scores Yesterday" listing isn't right. [Re: seadancer]
WesleyCrusher Offline

Administrator

Registered: Thu Sep 04 2008
Posts: 4537
Loc: Germany
I guess this one can be explained - the script probably looks for ALL badges and badgelets owned by the team (inactive members included) and then divides by the number of active folks.

Thus, a team with a large percentage of inactive players should do well on this list if those inactives also have a lot of badges. In the case of Heavens' Angels, they have a level 137 inactive, one at 119 and three in the 70s plus a bunch of 60s and 50s - quite a lot of extra badges.

I don't know if Terry can fix this one without making the underlying query too complex and slow.
_________________________
FunTrivia Editor (Hobbies and Sci/Tech) and Administrator
Guardian of the Tower

Top
Page 1 of 2 1 2 >

Moderator:  Terry