flyfifer
Forum Replies Created
-
Hi Savvas. Thanks for the quick response!
Graham.
After the above, I’ve just tried something else that may mean that it is the Points field that is the problem. I tried the following in this order:
1. Make no adjustments to the first 65 and make an adjustment to the 66th. This results in no adjustments being saved for that player.
2. Remove games played and points from the list (leaving goals, assists and penalties) and then repeating the above test case. This results in adjustments being made for that player.
3. Do the same on the 101st (and last) player. This results in adjustments being made for that player.
4. Restore the Games Played and Points values. The fields re-appear in the table and all adjustments remain.
5. Set Games Played adjustment on the 101st player. The adjustments for both the 66th and 101st player are reset to zero.
Given that points is added using the goals and assists values, I never actually make an adjustment to that field. So I tried steps 2 to 5 with Games Played re-added. This means there were no “calculation fields” in my table.
This allowed me to make the adjustments correctly for the 101st player. I then went back in and re-added Points to the table since I need to make that field be displayed. This did not reset the adjustments.
So, I’m leaning towards this now possibly being how the Points field is represented in the update blowing out an environment limit.
Given that I was able to get the 101st player to appear correctly, I think I have a workaround that is going to work for me which I will test properly tomorrow.
However, I’d still like to know, in case I hit this problem in the future, if there is an environment variable that is on too low a setting to allow me to manage adjustments on a player list of a certain length.
Thanks again,
Graham.Roch,
Pretty sure that this is an environment limit issue.
I have 101 players in my database, all of which are in the player list. This has been done by setting Players to Auto and Team to ‘my team’ for All. I don’t have any players in my database that don’t match this criteria.
Under Data, I have selected Goals, Assists and Penalty Minutes under Performance and Games Played and Points under Statistics.
I have sorted them as Squad Number in Ascending order. This isn’t how I’d want the list to be displayed, but I’ve done it this way because it ensures my player list order doesn’t change since I am not using a field that will be updated as a result of the adjustments.
The adjustments for the first 65 players in the list always update correctly. The adjustments for the last 36 are always set to zero. I’ve been able to do this consistently when creating new lists which is why I think I’m hitting a limit.
If I set-up my list as above and then modify the sort order to be Squad Number in Descending order, the list is not re-ordered correctly. I end up with chunks of correctly ordered players, but the chunks of squad numbers are out of sequence:
2, 39, 50->37, 57, 35->29, 52, 57, 28, 77, 94->62, 28->27, 2, 9, 13->9, 14, 9->4, 14, 27, 20, 27->20, 15, 19->15, 96
Two things to note; there are duplicate numbers because this is an all-time list so multiple players have played in the same squad number. Secondly, the players at the start and end of this new sequence are not being picked up in the re-order as they also appear in that position before the re-ordering.
But now the main reason why I think this is a limit issue…
The adjustments in this re-ordering still reflect the adjustments before I reversed the order. In other words, if a player was previously in the top 65 and therefore had adjustments, they still have their adjustments regardless of where they now land in the new order.
However, the third player in my re-ordering wasn’t originally in the top 65 and so doesn’t have any adjustments. If I add adjustments to him and Publish, he now correctly gets those adjustments. However, the bottom 36 now have their adjustments reset to zero.
As a result, it seems to me that the update query is only managing to handle 65 players through some environment limit. Any player who is not in that group of 65 gets their adjustments reset rather than gets their adjustments left alone.
Thanks,
Graham.Forum: Plugins
In reply to: [SportsPress - Sports Club & League Manager] Show ical linkAll I’ve done is add it to the Calendar’s text box at the top of the edit page.
http://www.bristolpitbulls.co.uk/calendar/calendar/
Graham.
Forum: Plugins
In reply to: [SportsPress - Sports Club & League Manager] Adding Historical Player DataThanks for your detailed response.
You are correct that the individual stats on the player page come from an external source and not from any Sportspress info. We are lucky that our sport has a global statistics database and that it is so easy to plug their HTML excerpts into other websites.
Your solution of doing adjustments on every player list does work for us. Fortunately, we’ll only ever have two player lists and are unlikely to have more. Therefore, it’s not quite as horrible a data management task as it could be.
I also like the fact that should this ever be “fixed” in a future release of Sportspress, it should be easy to cleanse the data from this workaround.
I’ve tested your solution, made myself happy that it is working and have already started loading our legacy data.
Many thanks for your help.
Graham.
Forum: Plugins
In reply to: [SportsPress - Sports Club & League Manager] Adding Historical Player DataSlightly confused by your solution. If I read it right, you have created one “super season” which the totals have picked up. I’m assuming that you’ve done this through a player list and manually entered their totals? If so, did you do anything different in the way that you created that list? Just seems strange that it was able to pick up that single, amalgamated season but not individual seasons.
Ultimately, I think what you’ve done would work for me, although I’ve failed to replicate it so far.
In ice hockey, there is a global statistical website called EliteProspects. I’ve created a plug in that allows me to embed their data in my player pages:
http://www.bristolpitbulls.co.uk/player/richie-hargreaves/
So, losing granularity at player level doesn’t bother me. What I’m trying to do is create totals so that we can acknowledge landmarks (e.g. 100th game, 100th goal) and keep track of club records (e.g. most appearances, most goals). Similar to what you’ve done with your history page.
To do that, I’ve got a page that tracks career stats for our current players (a second page that covers every player to have played for us will be created once I’ve got to the bottom of this issue):
http://www.bristolpitbulls.co.uk/list/current-team-all-time-statistics/
So, would be curious as to the exact make up of your “super season” to get them included in this page. As I say, so far I’ve been unable to replicate what you’ve done. I’m not even getting the inconsistent behaviour you describe. I can’t get anything I’ve entered manually to be included on that page.
As I said in my opening post, the issue isn’t about managing the size of the effort. I have season summaries for each player who has played for us. But, after his length of time, I know that we don’t have stats for every single game that we’ve played.
Graham.
Forum: Plugins
In reply to: [SportsPress - Sports Club & League Manager] Renaming TabsThanks, Andy. While I’d still like to see a way of doing option 3, this is a perfect workaround for us just now.
Thanks again,
Graham.Forum: Plugins
In reply to: [SportsPress - Sports Club & League Manager] Renaming TabsHi Roch,
Not looking to make changes in wp-admin. From reading the feature description in the release notes, I interpreted it as tabs within the SportsPress template could be renamed.
As an example, I have an event at http://www.bristolpitbulls.co.uk/event/bristol-pitbulls-v-slough-jets.
Under the Excerpt tab, I have a gamesheet that is pulled in from an external website used by our league (fixtureslive.com) rather than from our own website. To do this, I have the code snippet inserted into the Excerpt field on the event.
What I would like in order of preference (lowest to highest):
1. Rename Excerpt to Game Sheet on every page, not just events. While this isn’t ideal, I don’t use Excerpts anywhere else, so if it had to be a global change, then it would work for me.
2. Rename Excerpt to Game Sheet on just the event page. That way, if I decided to use Excerpts elsewhere in the future, it wouldn’t be a problem.
3. The Holy Grail! Be able to add a new custom tab that works similar to, for example, the Video tab. In other words, be able to add a new field on to the “Edit Event” page and have whatever I put in that field appear in its own tab. I suspect that I could create code that would allow me to display extra tabs, but I don’t believe that I can create code that would allow me to change the “edit” page so that I could add new custom values to an event (which is why I currently override the Excerpt field).
Thanks!
Graham.