Hey Mike,
Like I mention before:
"Hey Mike,
I feel that the the Auto Picks should be a User Preference that the user setup on there profile. If the user does entry there picks during the week, than the set user preference for the Auto Pick should kick in. So if they never enter there picks for the year, than there user preference would apply for the whole year.
Auto Picks
1.) Select all home teams
2.) Select all visiting teams
3.) Random Generator to pick between home and vistor
4.) Ranking System per team. So if you rank a team 3 that plays a team ranked 5. The Auto Pick would be the team ranked 3
5.) Over and Under for that week
6.) Trend
7.) Better Record/NFL Power Ranking
Just to name a few criteras for Auto Picks. The user would be able to pick the one the want to be used/applied for that week. They could set it in head of time, and have different ones for different weeks. I am Currently working on 1-4 and will have it available at the end of this week.
"
The design and implementation I am working on is like this. I have a UserPreference table (new). I thought about extended the User table with a couple of additional columns, but I wanted it to be more flexible.
So the user/admin would set up there profile in the user profile (may a seperate user preference page in the future). The page would have the different auto picks rules to select from. With the User Preference table idea, you would be able to plug and play other rule-base conditions as we develop them. So the User Preference table has a RuleCondition column to define the rule for that AutoPick Preference Type. So for what I will be releasing this weekend, it will have AutoPick Preference Types:
1.) Pick All Home Teams
2.) Pick All Visiting Teams
3.) Complete Random for Team Selection (Visitor and Home)
4.) Use a Rank System setup by the user (not Random Generated)
*** AutoPick Preference Type 1-3 will auto generate Points and TB
The user/admin will be able to set this up for the whole year or weekly (just like you allow them to chose there picks in advance).
The user/admin could set different AutoPick Preference Type for each week.
When the user go to the Weekly Entry Form for that week, it will automatically pre-populated it with the Auto Pick Preference for that week (if they have one set and no manual entries for that week).
If a user or users forget to enter there picks for that week, when the Admin enter the first score or scores for that week it will trigger the No Picks function to get the AutoPicks for that user or users. So this design will cover both the manual and automatic case. The user will not be able to change a AutoPick Preference once a game/week is lock (keep anyone from cheating).
The reason I had mention the Ranking System to Mike was because someone emailed that request directly to me and sent a donation to help with the development of it.. I think it is a good idea as well.
As far as the TB range. The range techinally should be 0 - 100 since a game can end in a scoreless tie if you are the Browns and Bills playing. But I address that with the user defining there own range when they set up there AutoPick Preference Type for that week.
We are both doing some of the something (maybe in a different design way, but the same thing). The design I have would allow us to add more Rules/Conditions for AutoPicks. It is kind of a Rule-Based Engine we can Plug-n-Play into. Because there are so many ways to trigger AutoPicks.
Thanks,
Charlie J.