bilybob, I haven't started to look at implementing the feature requests yet. I do apologize for not getting the source code out faster though - that will allow you to make whatever changes you'd like. I will get it zipped up and released this weekend. There
may also be an Access Data Provider available this weekend. As for the problem you're experiencing, I've got some questions for you. If you just started entering stats for Week 4, you should only see zero's for the Week 4's stats. If you didn't make picks
for Weeks 1, 2 and 3, you should only see zero's there as well. However, if you entered scores for the previous weeks and also had default picks turned on, then it will have given points to users even if they didn't make any picks (that's the logic of the
default picks). Hopefully, that's what you're seeing. You'll see it when I release the code, but no points are calculated until the admin actually enters a score for a game. When the score is entered, the pick for each user in the pool is given points based
on their choice. That's why I'm fairly certain that you're not seeing points from Week 4 under the Week 3 column. It sounds like you have some good technical experience, so take a look at the tables in the db. They're pretty simple - XrcPicks, XrcUsers, XrcGames,
XrcWeeks. Take a look at the picks for Week3 and see if anything stands out. There will be a points column for each pick and you should be able to figure out where the points are coming from. Let me know what you find out! mike.
Ok, I looked in the picks table, and there were a bunch of 'blank' entries for the first 3 weeks. I figured I'd delete all the entries for games before week 4. When I did that, the stats for week 4 showed up in column 1 (week 1) in the report. So I figured
the Picks table is supposed to have all entries. So I re-created entries in the Picks table for all users for the 1st 3 weeks - just blank entries - no winner picked, just userid and whatever else was required. Once I did that, the results for week 4 showed
up in the right place, under week 4. So it seems for some reason, some of the Picks entries never got created? I'm wondering if this has something to do with creating new users mid-season? I've just created a dummy user, but there are no Picks entries created
yet. Once the new week starts, I will submit a pick for the dummy user and see if the Picks table is populated correctly for the earlier, non-played, weeks. Please let me know when the source is available. Thanks
Bilybob, First of all, I screwed up the table names in my previous post. I got confused with the module that I'm currently working on. Glad to see you were still able to figure it out. Secondly, you probably have found a bug. I think you nailed it on the head
when you mentioned that it might have something to do with creating new users mid-season. Since the report is generated on the fly, it builds itself using the Picks table. However, the Picks table is only populated when a) a pick is made, or b) a score is
entered for a game (which creates default picks if none exist). So, since you started a season after 3 weeks and didn't make any picks for the first 3 weeks or enter any scores for the first 3 weeks, no pick records were created for the first 3 weeks. If you
were starting a brand new pool, the best way would be to add the schedule, add the users, ensure that default picks were disabled and then enter the scores for each game that has already been played. This would populate the picks with 0 points. Once you were
up to date with the games, you could enable the default picks again if you wanted to use them with your pool. The best way to fix this might be to put a note in the readme.txt since most users will be starting a pool from the very first week. mike.
Just a quick note that it looks like a date formatting bug has been found. It seems that when the module displays dates and times for each game, it is converting the times from UTC to Local time, but the dates were not getting the same treatment. I've fixed
the bug and awaiting a quick confirmation that it's fixed. Once that happens, I'll post back here. I'll update the PA zip file on my site - you should be able to reinstall the module without losing any data that you have (as long as you don't uninstall it
first!!!). mike.
Mike, This module ROCKS! I patiently await the updated PA as you stated in this post. Do you have plans to release the source for this module (either for free or via snowcovered)? Since the season for the NFL doesn't start until Sept, I've not seen the date
bug you spoke of. I do have one question about how the time calculations are conducted. If I understand right, the schedule is in UTC and the module does the conversion in a calculation. I assume that the code uses the time on the web server where the module
is running for this calculation. If that's the case, just need to know it so I can post it as part of the rules for the Office Pool that I'll be running. Thanks Dan
Dan, Glad that you like the module. I think it's got some great potential. I'm also finished my Reality TV Pool module - I'm just testing it out with a small pool on the Amazing Race. I'll definitely have it out and ready to go before Survivor 9 rolls in September.
I should also have an Awards Show Pool (i.e. Oscar Pool) ready to roll by then as well. As for your questions: 1) Since folks have been asking for it through the forums and e-mail, I've posted the source in the same location as the PA:
http://www3.telus.net/mm53bar/PickEm/. I've updated both the source package and PA package to v2.1 to reflect the UTC date fix. 2) You're right about the schedule - it is in UTC. You're also right about the
local time conversion - it is local to the webserver. There are 2 areas in the pool where dates are displayed. The first is in the Edit screen for a game. The second is in the Picks screen where each game is listed. In both areas, I've updated a label on the
screen with the appropriate time zone info (including Daylight Saving Time if applicable) and the UTC offset. The label for the Edit screen is directly under the DateTime textbox. The label for the Picks screen is at the bottom of the datagrid near the Submit
button. Let me know if you have any more questions! mike.
Folks, Please feel free to download the source code for Pick'Em and modify it as you see fit. I haven't had a chance to clean it up like I had hoped, so hopefully you can figure your way through it. If you make any modifications that you think would be useful
to the community at large, please contact me so that I can incorporate them into the ongoing updates. Last item - my intentions for this module and my other pool modules is to eventually start my own site where I host advanced versions of these modules. Users
will sign up to the site and (for a fee) be able to host their own pool and invite their friends. Pick'Em, Xtreme Reality Challenge (XRC) and an un-named Awards Show pool are the first pool modules that I've built using DNN, but I've built a lot of draft pools
using other portal technologies that were nowhere near as advanced as DNN. My hope for releasing these modules to the community is a) new DNN developers can learn by example, which is the same way I learned DNN, b) I can give back to the community and help
DNN developers have some fun with their portals, and c) I can get some feedback and criticism on the "lite" version of the modules before I start ramping them up to the advanced versions. Please note that I will NEVER EVER charge for the "lite" modules and
I will ALWAYS release full source code with them. That said, there are some feature requests that I will not include in the "lite" versions, but I will explicitly state those situations so that there's no ambiguity. I'm a pretty straight forward guy and I
don't believe in hiding anything. Hopefully everybody can understand that this is my way to give back to the community while also providing a chance to put some coin in my pocket down the road. Thanks for the soapbox. mike.
IcthusTech
Contributor
4620 Points
924 Posts
Re: Pick'Em Sports Pool module released for free
Jul 09, 2004 12:45 PM|LINK
Building Faith on the Internet
bilybob
Member
65 Points
13 Posts
Re: Pick'Em Sports Pool module released for free
Jul 09, 2004 01:24 PM|LINK
mm53bar
Participant
1570 Points
314 Posts
Re: Pick'Em Sports Pool module released for free
Jul 09, 2004 01:59 PM|LINK
bilybob
Member
65 Points
13 Posts
Re: Pick'Em Sports Pool module released for free
Jul 09, 2004 08:43 PM|LINK
mm53bar
Participant
1570 Points
314 Posts
Re: Pick'Em Sports Pool module released for free
Jul 09, 2004 11:35 PM|LINK
mm53bar
Participant
1570 Points
314 Posts
Re: Pick'Em Sports Pool module released for free
Jul 09, 2004 11:52 PM|LINK
bilybob
Member
65 Points
13 Posts
Re: Pick'Em Sports Pool module released for free
Jul 10, 2004 12:16 AM|LINK
dantindall
Participant
1042 Points
211 Posts
Re: Pick'Em Sports Pool module released for free
Jul 12, 2004 11:14 AM|LINK
mm53bar
Participant
1570 Points
314 Posts
Re: Pick'Em Sports Pool module released for free
Jul 12, 2004 01:59 PM|LINK
mm53bar
Participant
1570 Points
314 Posts
Re: Pick'Em Sports Pool module released for free
Jul 12, 2004 02:11 PM|LINK