Community Server

Is it possible to allow picks to be made right up unil the game starts rather than locking all of the Sunday and Monday games on Sunday morning?  This would be a great feature to be developed before the start of the 2012 season. Anyone else interested?

 Yeah. Even i am interested. Wanna know some more details regarding it.

pop art

I made a change to the /includes/common.asp file so that the week will not lock unitl all of the games are locked.  This way users can make picks up until the start of the game, and all of the games will not lock at the start of the first game on Sunday morning.

 function IsWeekLocked(week)

  dim dateTime, rs, gameDateTime, numGames, GamesComplete
  
  numGames = GetGameCount(week)
  GamesComplete = 0

  IsWeekLocked = false
  dateTime = GetCurrentDateTime()
  set rs = GetGamesRecordset(week)
  do while not rs.EOF
   gameDateTime = CDate(rs.Fields("DateTime").Value)
   if gameDateTime <= dateTime then
    GamesComplete = GamesComplete + 1
   end if
   rs.MoveNext
  loop
  
  if GamesComplete = numGames then
   IsWeekLocked = true
  end if

 end function

Anyone see an issue of doing it this way??

I set the Database to show games for today, and set different times for some games to test this. this was what I got on the pick page.

ADODB.Recordset

error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/pool/includes/common.asp, line 511

I believe line 511 is  - "GamesComplete = 0"

I apologize, I should have stated before posting my code that this is for a SQL Server implementation, not Access.  If you are using an Access database, the following line should not be changed:

gameDateTime = CDate(rs.Fields("DateTime").Value)

The code is different  when reading the date and time from Access.  I don't have the old code to post here, but you should be able to find another example somewhere in the pool code.  Sorry for the confusion.

no worries, but thanks for the heads up, and the nod in the right direction.

I think Ive solved it for the Access version. Oddly enough I only had to change one word.

Looks like everything works just fine, games lock at the specified game times.

original =

if Weekday(gameDateTime) = vbSunday and gameDateTime <= dateTime then  

New =

if Weekday(gameDateTime) = vbTuesday and gameDateTime <= dateTime then

 This games are going to be fantastic and i would like to know more about it  in future.

how to pass a drug test 

Ive already ran tests, each game locks at the time its set to kickoff. I tested it on wednesday games through late monday night games, all at different start times, as each gametime was reached it locked. No one can change any picks.

All this did by changing it to tuesday was basically make all games before Tuesday "early games" where the code is concerned. Before this change any games begining before sunday were considered an early game by code.

I could change it to monday, but when theres the odd date with 2 games on monday it will lock them both once the first game begins. So to avoid any confusion with my players I just set them all to lock at their kickoff time.