no content
AdBlocker active?
It seems you are using software to block advertisements. You could help us if you could switch it off when visiting redzoneaction.org.
The reason is very simple: Advertisements help us running the site, to offer you the game in a good quality for free. So if you like the game, please support us by purchasing a Supporter Account or disabling the AdBlocker on this site.
Thank you very much!
| Main / Suggestions / Adding zero-valued stats to the statistical leaders Search Forum | |
| Navigation: |< >| | |
| Rating: | |
| Poster | Message |
| posted: 2019-10-10 06:23:55 (ID: 100143999) Edits found: 1 Report Abuse | |
|
Not sure this is a bug or a feature.
If it's a feature, this should be added. I did check on statustical leaders and selected Elite league and all teams and also team summery, so basically the teams stats. On the stat 'interceptions thrown' I only found 29 teams, which is likely because 3 teams have not thrown an interception so far (surprisingly mine is in that group of teams). But I think at least for the team summery stats all teams should be in, including the one with 0 as value. I can understand that you (and me) don't want players with zero-value in it, since it does blow up the list, but team value I think could be important. Last edited on 2019-10-10 06:24:40 by jack6 |
|
| Quote Reply Edit | |
|
Meitheisman
|
posted: 2019-10-10 16:58:02 (ID: 100144007) Report Abuse |
|
Good idea, not sure about the coding but if it's not too hard I like the idea
 |
|
| Quote Reply Edit | |
| posted: 2019-10-10 17:08:34 (ID: 100144008) Report Abuse | |
|
Same for "getting sacked" stats.
|
|
| Quote Reply Edit | |
|
Mücke
|
posted: 2019-10-10 21:21:35 (ID: 100144017) Report Abuse |
|
ouuh, seems hard to code. RZA probably must start over new to make this running. Hope this isn't a soccer game accidentally after trying to fix it. 😝
|
|
| Quote Reply Edit | |
| posted: 2019-10-11 14:30:30 (ID: 100144034) Report Abuse | |
|
Keep your sarcasm for you.
|
|
| Quote Reply Edit | |
| posted: 2019-12-26 15:36:06 (ID: 100145780) Report Abuse | |
|
I had a deeper check on this and found no way to make it as suggested AND keeping the performance high. Im sorry, jack6
|
|
| Quote Reply Edit | |
| posted: 2019-12-27 10:01:09 (ID: 100145795) Report Abuse | |
|
Hmm OK.
I guess you get the data by some SQL like s e l e c t a.team, a.INT_Thrown from ind_stats a where league = 'ELITE' and games = 'LEAGUE_REGULAR' and season = '37' and INT_Thrown is not null group by 1 is there a table giving the list of teams for that season? Like s e l e c t b.team from teams_season b where b.season = '37' you could add that by something like that: s e l e c t team, INT_Thrown from ( s e l e c t b.team, '0' as INT_Thrown from teams_season b where b.season = '37' union s e l e c t a.team, a.INT_Thrown from ind_stats a where league = 'ELITE' and games = 'LEAGUE_REGULAR' and season = '37' and INT_Thrown is not null group by 1 ) group by 1 Is that too much of an performance issue? |
|
| Quote Reply Edit | |
| posted: 2019-12-27 14:44:46 (ID: 100145799) Report Abuse | |
|
that is a subs e l e c t then, which I try to avoid as much as I can
|
|
| Quote Reply Edit | |
| reply Mark this thread unread | |
| Navigation: |< >| | |
| Main / Suggestions / Adding zero-valued stats to the statistical leaders | |
