# Copyright (c) 2001 Josha Foust (tivoweb@lightn.org)
# $Id: ui.itcl,v 1.64.2.31 2002/07/02 04:11:10 lightn Exp $

proc PrintNames {args} {
	set str ""
	set names [lindex $args 0]
	set searchtype 0
	if { [llength $args] > 1 && [info procs "action_search"] == "action_search"} {
	   set searchtype [lindex $args 1]
	   set searchby [lindex "3 4" [expr $searchtype - 1]]
	}
	foreach name $names {
		if { [regexp {(.*)\|(.*)} $name junk last first] } {
			set str1 "$first $last"
			if { $searchtype > 0 } {
				if {$first == ""} {
					set str2 [httpMapReply "$last\t"]
				} else {
					set str2 [httpMapReply "$last, $first\t"]
				}
				set str1 [html_link "/search?searchby=$searchby&q=$str2" $str1]
			}
			if { $str == "" } {
				set str $str1
			} else {
				append str ", $str1"
			}
		}
	}
	return $str
}

proc SaveNames {namestr} {
	regsub -all { } $namestr "_" namestr
	if { [regexp {(.*),(.*)} $namestr] } {
		regsub -all {,_} $namestr " " namestr
	  if { [regexp {(.*)[;:](.*)} $namestr] } {
		if { [regexp {(.*);(.*)} $namestr] } {
				regsub -all {;_} $namestr " " namestr
		}
		if { [regexp {(.*):(.*)} $namestr] } {
				regsub -all {:_} $namestr " " namestr
		}
	  }
	  set names $namestr
	  split $names
	} elseif { [regexp {(.*);(.*)} $namestr] } {
		  regsub -all {;_} $namestr " " namestr
		if { [regexp {(.*)[,:](.*)} $namestr] } {
		 if { [regexp {(.*),(.*)} $namestr] } {
				regsub -all {,_} $namestr " " namestr
		 }
		 if { [regexp {(.*):(.*)} $namestr] } {
				regsub -all {:_} $namestr " " namestr
		 }
		}
		set names $namestr
		split $names
	} elseif { [regexp {(.*):(.*)} $namestr] } {
			regsub -all {:_} $namestr " " namestr
			if { [regexp {(.*)[,;](.*)} $namestr] } {
		   if { [regexp {(.*),(.*)} $namestr] } {
				  regsub -all {,_} $namestr " " namestr
			   }
		   if { [regexp {(.*);(.*)} $namestr] } {
				  regsub -all {;_} $namestr " " namestr
			   }
			}
			set names $namestr
			split $names
	} else {
		set names $namestr
		split $names
	}
	set str ""
	foreach name $names {
	   set numspcs [regsub -all {_} $name "_" $name]
	   if { $numspcs == 1 } {
		  if { [regexp {(.*)_(.*)} $name junk first last] } {
			 if { $str == "" } {
				  set str "$last|$first"
			   } else {
				  set str "$str, $last|$first"
			 }
		}
		 } elseif { $numspcs == 2 } {
		  if { [regexp {(.*)_(.*)_(.*)} $name junk first middle1 last] } {
			 if { $str == "" } {
				  set str "$last|$first middle1"
			   } else {
				  set str "$str, $last|$first middle1"
			 }
		}
		 } elseif { $numspcs == 3 } {
		  if { [regexp {(.*)_(.*)_(.*)_(.*)} $name junk first middle1 middle2 last] } {
			 if { $str == "" } {
				  set str "$last|$first middle1 middle2"
			   } else {
				  set str "$str, $last|$first middle1 middle2"
			 }
		}
	   }
	}
	set names $str

	split $names ,
	regsub -all {,} $names " " names

	return $names
}

proc action_channellist {chan type env} {
	global channeltablestation channeltablenum
	global logotablename logotableindex
	global db
	global guideindexdir

	if {[string index $type 0] == "/"} {
		set type [string range $type 1 end]
	}

	puts $chan [html_start "Channel Guide"]

	if { $type == "" } {
	   puts $chan [html_table_start "" "" "ALIGN=TOP"]
	   puts $chan [tr "" [th "" "Channel Guide"]]
	   puts $chan [tr "" [td [html_link "/channellist/1" "All"]]]
	   puts $chan [tr "" [td [html_link "/channellist/2" "Watch"]]]
	   puts $chan [tr "" [td [html_link "/channellist/3" "Favorite"]]]
	   puts -nonewline $chan [html_table_end]
	} else {
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "ALIGN=CENTER" [th "Logo"] [th "Num"] [th "Callsign"] [th "Name"]]
	   if { $type == 1 } {
		  RetryTransaction {
			 set channelfsid [lindex [mfs find $guideindexdir/ChannelTable] 0]
			 set channeltabledata [mfs get $channelfsid]
		  }
		  binary scan [string range $channeltabledata 0 3] I numkeys
		  set incrsize 50
		  for {set i 0} {$i < $numkeys} {incr i $incrsize} {
			 set maxchannelcount [expr ($numkeys > $i + $incrsize) ? ($i + $incrsize) : $numkeys]
			 RetryTransaction {
				for {set count $i} {$count < $maxchannelcount} {incr count} {
				   binary scan [string range $channeltabledata [expr $count*8 + 4] [expr $count*8 + 11]] ISS stationfsid dummy chnum
				   set station [db $db openid $stationfsid]
				   set callsign [dbobj $station get CallSign]
				   set channame [strim [dbobj $station get Name]]
				   set logoindex [dbobj $station get LogoIndex]
				   set logoname [lindex $logotablename [lsearch $logotableindex $logoindex]]
				   if { $logoname != "" } {
					  set logostr [img "alt=\"\"" "$logoname.png"]
				   } else {
					  set logostr ""
				   }
				   puts $chan [tr "" [td $logostr] [td $chnum] [td [html_link "/channel/$stationfsid" $callsign]] [td $channame]]
				}
			 }
		  }
		  unset channeltabledata
	   } else {
		  foreach channum [lsort -integer [array names channeltablenum]] {
			 set stationfsid $channeltablenum($channum)
			 set data $channeltablestation($stationfsid)
			 set favorite [lindex $data 1]
			 if { $type == "3" && $favorite == 0 } {
				continue
			 }
			 set callsign [lindex $data 2]
			 set channame [lindex $data 3]
			 set logoindex [lindex $data 4]
			 set logoname [lindex $logotablename [lsearch $logotableindex $logoindex]]
			 if { $logoname != "" } {
				set logostr [img "alt=\"\"" "$logoname.png"]
			 } else {
				set logostr ""
			 }
			 set channame [strim $channame]
			 puts $chan [tr "" [td $logostr] [td $channum] [td [html_link "/channel/$stationfsid" $callsign]] [td $channame]]
		  }
	   }
	   puts -nonewline $chan [html_table_end]
	}

	puts $chan [html_end]
}

proc action_channel {chan objectid env} {
	global db
	global channeltablestation
	global channeltablenum
	global logotableindex
	global logotablename
	global cache_sp_fsid cache_sp_key

	if {[string index $objectid 0] == "/"} {
		set objectid [string range $objectid 1 end]
	}

	puts $chan [html_start "Channel"]

	if { [catch {set data $channeltablestation($objectid)}] != 1 } {
	   set channum [lindex $data 0]
	   set callsign [lindex $data 2]
	   set logoindex [lindex $data 4]
	   set logoname [lindex $logotablename [lsearch $logotableindex $logoindex]]
	   if { $logoname != "" } {
		  set logostr [img "alt=\"\"" "$logoname.png"]
	   } else {
		  set logostr ""
	   }
	   puts $chan [h1 "$logostr $channum $callsign"]
	   puts -nonewline $chan [html_link "/listings/$objectid" "View Upcoming Listings"]
	   puts $chan "<P>"
	} else {
	   puts $chan "<B>Error: Unknown Station '$objectid'</B><P>"
	}

	update_sp_cache

	set lsize [llength $cache_sp_key]
	set i 0
	set seriesfsids ""
	while {$i < $lsize} {
	   set index [lsearch [lrange $cache_sp_key $i end] "*|$objectid"]
	   if { $index == -1 } {
		  break
	   } else {
		  incr i $index
		  set key [lindex $cache_sp_key $i]
		  incr i
		  set dindex [string first "|" $key]
		  lappend seriesfsids [string range $key 0 [expr $dindex - 1]]
	   }
	}
	if { $seriesfsids != "" } {
	   puts $chan [h2 "Season Pass"]
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "" [th "Title"]]
	   RetryTransaction {
		  foreach seriesfsid $seriesfsids {
			 set series [db $db openid $seriesfsid]
			 set title [strim [dbobj $series get Title]]
			 puts $chan [tr "" [td [html_link "/series/$seriesfsid" $title]]]
		  }
	   }
	   puts -nonewline $chan [html_table_end]
	} else {
  	   puts $chan "<p>(no season passes for this channel)"
	}

#	set first 1
#	ForeachMfsFileTrans fsid name type "/SeasonPass" "" 20 {
#	   set sp [db $db openid $fsid]
#	   set type [defaultval 1 [dbobj $sp get Type]]
#	   if { $type == 1 } {
#		  set station [dbobj $sp get Station]
#		  set stationfsid [dbobj $station fsid]
#		  if { $stationfsid == $objectid } {
#			 set series [dbobj $sp get Series]
#			 if { $first == 1 } {
#				puts $chan [h2 "Season Pass"]
#				puts $chan [html_table_start "" "" ""]
#				puts $chan [tr "" [th "Title"]]
#				set first 0
#			 }
#			 set seriesfsid [dbobj $series fsid]
#			 set title [strim [dbobj $series get Title]]
#			 puts $chan [tr "" [td [html_link "/series/$seriesfsid" $title]]]
#		  }
#	   }
#	}
#	if { $first == 0 } {
#	   puts -nonewline $chan [html_table_end]
#	}

	puts $chan [html_end]

}

proc do_listingsrow {chan fsid startsecs endsecs} {
	global db
	global tzoffset

	set stationday [db $db openid $fsid]
	set showings [dbobj $stationday get Showing]
	foreach showing $showings {
	   set secs [expr [dbobj $showing get Date] * 86400 + [dbobj $showing get Time] + $tzoffset]
	   if { $secs >= $startsecs && $secs < $endsecs } {
		  set showingfsid "[dbobj $showing fsid]/[dbobj $showing subobjid]"
		  set program [dbobj $showing get Program]
		  set series [dbobj $program get Series]
		  set seriesfsid ""
		  if { $series != "" } {
			 set seriesfsid [dbobj $series fsid]
       		 set episodic [defaultval 1 [dbobj $series get Episodic]]
		  } else {
		     set episodic 1
		  }
		  set timestr [clock format $secs -format "%l:%M %P"]
		  set title [strim [dbobj $program get Title]]
		  set eptitle [strim [dbobj $program get EpisodeTitle]]
		  set partindex [dbobj $showing get PartIndex]
		  set partcount [dbobj $showing get PartCount]
		  if { $partcount != "" && $partindex != "" } {
			 append eptitle " ($partindex/$partcount)"
		  }
		  if { $eptitle == "" } {
			 if { $episodic == 1 } {
				set eptitle "UNKNOWN"
			 } else {
				set eptitle $title
			 }
		  }
		  if { $seriesfsid != "" } {
			 set title [html_link "/series/$seriesfsid" $title]
		  }
		  puts $chan [tr "" [td $timestr] [td $title] [td [html_link "/showing/$showingfsid" $eptitle]]]
	   }
	}
}

proc action_listings {chan path env} {
	global db
	global tzoffset
	global channeltablestation
	global channeltablenum
	global logotablename
	global logotableindex

	puts $chan [html_start "Listings"]

	if {[string index $path 0] == "/"} {
		set path [string range $path 1 end]
	}
	set firstslash [string first "/" $path]
	set seconds ""
	if { $firstslash != -1 } {
		set stationid [string range $path 0 [expr $firstslash - 1]]
		set seconds [string range $path [expr $firstslash + 1] end]
	} else {
		set stationid $path
	}
	if { [catch {set data $channeltablestation($stationid)}] != 1 } {
	   set channum [lindex $data 0]
	   set callsign [lindex $data 2]
	   set logoindex [lindex $data 4]
	   set logoname [lindex $logotablename [lsearch $logotableindex $logoindex]]
	} else {
	   puts $chan "<B>Error: Unknown Station '$stationid'</B>"
	   puts $chan [html_end]
	   return 0
	}

	if { $logoname != "" } {
	   set logostr [img "alt=\"\"" "$logoname.png"]
	} else {
	   set logostr ""
	}
	if { $seconds == "" } {
	   puts $chan [h1 "$logostr $channum $callsign"]
	   set minday "99999"
	   set maxday "00000"
	   ForeachMfsFile fsid name type "/Schedule" "$stationid:" {
		  scan $name "%d:%d:" schedsid schedday
		  if {$minday > $schedday} {
			 set minday $schedday
		  }
		  if {$maxday < $schedday} {
			 set maxday $schedday
		  }
	   }
	   set minseconds [expr ($minday - 1) * 86400]
	   set maxseconds [expr $maxday * 86400]
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "" [th "Day"]]
	   for {set i $minseconds} {$i <= $maxseconds} {incr i 86400} {
		  set timestr [clock format $i -format "%a %1m/%1d"]
		  puts $chan [tr "" [td [html_link "/listings/$stationid/$i" $timestr]]]
	   }
	   puts -nonewline $chan [html_table_end]
	   puts $chan "<P>"
	} else {
	   set day [expr $seconds / 86400]
	   set startsecs [expr $seconds]
	   set endsecs [expr $startsecs + 86400]
	   set timestr [clock format $startsecs -format "%a %1m/%1d"]
	   puts $chan [h1 "$logostr $channum $callsign - $timestr"]
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "ALIGN=CENTER" [th "Time"] [th "Series"] [th "Episode"]]
	   set firstday 1
	   ForeachMfsFileTrans fsid name type "/Schedule" "$stationid:$day:" 25 {
		  if {[catch [do_listingsrow $chan $fsid $startsecs $endsecs] error]} {
			 puts "do_listingrow $fsid $startsecs $endsecs"
			 puts "$error"
		  }
		  set firstday 0
	   }
	   incr day
	   set lastday 1
	   ForeachMfsFileTrans fsid name type "/Schedule" "$stationid:$day:" 25 {
		  if {[catch [do_listingsrow $chan $fsid $startsecs $endsecs] error]} {
			 puts "do_listingrow $fsid $startsecs $endsecs"
			 puts "$error"
		  }
		  set lastday 0
	   }
	   puts -nonewline $chan [html_table_end]
	   puts $chan "<P>"
	   set yesterday [expr $seconds - 86400]
	   set tommorow [expr $seconds + 86400]
	   set timestr [clock format $yesterday -format "%a %1m/%1d"]
	   set timestr2 [clock format $tommorow -format "%a %1m/%1d"]
	   if { !$firstday } {
		  puts $chan [html_link "/listings/$stationid/$yesterday" "&lt;&lt; $timestr"]
	   }
	   if { !$lastday } {
		  puts $chan [html_link "/listings/$stationid/$tommorow" "$timestr2 &gt;&gt;"]
	   }
	}

	puts $chan [html_end]
}

proc action_saveprogram {chan path env} {
   global db

   puts $chan [html_start "Edit Program"]
   eval $env
   RetryTransaction {
	  set rec [db $db openid $objectid]
	  set seltype [dbobj $rec get SelectionType]
   } 
	 if {$seltype == 6} {
		set newseltype 4
	} else {
		set newseltype $seltype
	}
	set nowsecs [clock seconds]
	set newexpdate 0
	  if { $sul == 1 } {
# 	Save Until 1 day.
		set newexpsecs [expr $nowsecs + 24*60*60]
   	} elseif { $sul == 2 } {
# 		Save Until 2 days.
		set newexpsecs [expr $nowsecs + 48*60*60]
   	} elseif { $sul == 3 } {
# 	Save Until 3 days.
		set newexpsecs [expr $nowsecs + 72*60*60]
   	} elseif { $sul == 4 } {
# 	Save Until 4 days.
		set newexpsecs [expr $nowsecs + 96*60*60]
   	} elseif { $sul == 5 } {
# 	Save Until 5 days.
		set newexpsecs [expr $nowsecs + 120*60*60]
   	} elseif { $sul == 6 } {
# 	Save Until 6 days.
		set newexpsecs [expr $nowsecs + 144*60*60]
   	} elseif { $sul == 7 } {
# 	Save Until 7 days.
		set newexpsecs [expr $nowsecs + 168*60*60]
   	} elseif { $sul == 0 } {
# 		Record is set for save until I delete.
		set newexpdate [expr 24855 + 0]
		set newexpsecs $nowsecs
   	} else {
#	Set Record as Expired.
		set sul 8
   		set newexpsecs [expr $nowsecs - 72*60*60]
   	}
	  if { $newexpdate != 24855 } {
	   	set newexpdate [expr $newexpsecs / 86400]
	}
   updaterec $objectid $title $eptitle $description $newexpdate $newseltype $actorstr $gueststarstr $directorstr $execproducerstr $producerstr $writerstr

   puts $chan "<B>Program Updated Successfully</B>"

   puts $chan " "
   puts $chan [html_table_start "" "" ""]
   puts $chan [html_link "/ui/nowshowing" "Return to Now Showing   *"]
   puts $chan "<A HREF=\"#\" onClick=\"history.go(-1)\">   Return to Previous</A>"
   puts $chan [html_end]
}

proc action_editprogram {chan objectid env} {
   global db

   if {[string index $objectid 0] == "/"} {
	   set objectid [string range $objectid 1 end]
   }

   puts $chan [html_start "Edit Program"]
   RetryTransaction {
	  set rec [db $db openid $objectid]
	  set showing [dbobj $rec get Showing]
	  set program [dbobj $showing get Program]
	  set title [strim [dbobj $program get Title]]
	  set description [strim [dbobj $program get Description]]
	  set isepisode [dbobj $program get IsEpisode]
	  set sul [dbobj $rec get State]
	  set seltype [dbobj $rec get SelectionType]
	  set expdate [dbobj $rec get ExpirationDate]
	  set expsecs [expr $expdate * 86400 + [dbobj $rec get ExpirationTime]]
	  set nowsecs [clock seconds]
	  set sulvals "0 1 2 3 4 5 6 7 8"
	  set sullabs "{Until I delete} {1 day} {2 days} {3 days} {4 days} {5 days} {6 days} {7 days} {Expired}"
	  if {$expdate == 24855} {
# 	Record is set for save until I delete.
		set sul 0
	  } elseif {$expsecs < [expr $nowsecs + 24*60*60]} {
# 	Save Until 1 day.
		set sul 1
	  } elseif {$expsecs < [expr $nowsecs + 48*60*60]} {
# 	Save Until 2 days.
		set sul 2
	  } elseif {$expsecs < [expr $nowsecs + 72*60*60]} {
# 	Save Until 3 days.
		set sul 3
	  } elseif {$expsecs < [expr $nowsecs + 96*60*60]} {
# 	Save Until 4 days.
		set sul 4
	  } elseif {$expsecs < [expr $nowsecs + 120*60*60]} {
# 	Save Until 5 days.
		set sul 5
	  } elseif {$expsecs < [expr $nowsecs + 144*60*60]} {
# 	Save Until 6 days.
		set sul 6
	  } elseif {$expsecs < [expr $nowsecs + 168*60*60]} {
# 	Save Until 7 days.
		set sul 7
	  } else {
# 	Set Program Expired.
		set sul 8
	  }

	  set actors [dbobj $program get Actor]
	  if { $actors != "" } {
		 set actorstr [PrintNames $actors]
	  } else {
	   set actorstr ""
	}

	  set gueststars [dbobj $program get GuestStar]
	  if { $gueststars != "" } {
		 set gueststarstr [PrintNames $gueststars]
	  } else {
	   set gueststarstr ""
	}

	  set directors [dbobj $program get Director]
	  if { $directors != "" } {
		 set directorstr [PrintNames $directors]
	  } else {
	   set directorstr ""
	}

	  set execproducers [dbobj $program get ExecProducer]
	  if { $execproducers != "" } {
		 set execproducerstr [PrintNames $execproducers]
	  } else {
	   set execproducerstr ""
	}


	  set producers [dbobj $program get Producer]
	  if { $producers != "" } {
		 set producerstr [PrintNames $producers]
	  } else {
	   set producerstr ""
	}

	  set writers [dbobj $program get Writer]
	  if { $writers != "" } {
		 set writerstr [PrintNames $writers]
	  } else {
	   set writerstr ""
	}

	  puts $chan [html_form_start "POST" "/saveprogram"]
	  puts $chan [html_form_hidden "objectid" $objectid]
	  puts $chan [html_form_hidden "expsecs" $expsecs]
	  puts $chan [html_form_hidden "expdate" $expdate]

	  puts $chan [html_table_start "" "" ""]
	  puts $chan [tr "" [td "Title"] [td [html_form_text 1 40 "title" $title]]]
	  if { $isepisode == 1 } {
		 set eptitle [strim [dbobj $program get EpisodeTitle]]
		 puts $chan [tr "" [td "Episode Title"] [td [html_form_text 1 40 "eptitle" $eptitle]]]
	  } else {
		 puts $chan [html_form_hidden "eptitle" ""]
	  }
	  puts $chan [tr "" [td "Description"] [td [html_form_text 3 40 "description" $description]]]
	  puts $chan [tr "" [td "Save Until..."] [td [html_form_select "sul" $sulvals $sullabs $sul]]]
	  puts $chan [tr "" [td "Actors"] [td [html_form_text 2 40 "actorstr" $actorstr]]]
	  puts $chan [tr "" [td "Guest Stars"] [td [html_form_text 2 40 "gueststarstr" $gueststarstr]]]
	  puts $chan [tr "" [td "Directors"] [td [html_form_text 2 40 "directorstr" $directorstr]]]
	  puts $chan [tr "" [td "Exec. Producers"] [td [html_form_text 2 40 "execproducerstr" $execproducerstr]]]
	  puts $chan [tr "" [td "Producers"] [td [html_form_text 2 40 "producerstr" $producerstr]]]
	  puts $chan [tr "" [td "Writers"] [td [html_form_text 2 40 "writerstr" $writerstr]]]
	  puts $chan [html_table_end]
	  puts $chan [html_form_input "submit" "Save" "Save"]
	  puts $chan [html_form_end]
	  puts $chan "<P>"
	  puts $chan "<A HREF=\"#\" onClick=\"history.go(-1)\">Cancel</A>"
   }

   puts $chan [html_end]

}

proc updaterec { id newtitle neweptitle newdesc newexpdate newseltype newactorstr newgueststarstr newdirectorstr newexecproducerstr newproducerstr newwriterstr } {
   global db

   RetryTransaction {
	  set rec [db $db openid $id]
	  set showing [dbobj $rec get Showing]
	  set program [dbobj $showing get Program]
	  set serverid [dbobj $program get ServerId]
	  if { $serverid != "" } {
		 set newpobj [db $db create Program]
		 dbobj $newpobj copyfrom $program
		 dbobj $newpobj remove ServerId
		 dbobj $showing set Program $newpobj
	  } else {
		 set newpobj $program
	  }
 	  if {$newtitle == ""} {
		 set newtitle "{}"
	  }
	  dbobj $newpobj set Title $newtitle
	  set isepisode [dbobj $newpobj get IsEpisode]
	  if { $isepisode == 1 } {
		 dbobj $newpobj set EpisodeTitle $neweptitle
	  }
	  dbobj $newpobj set Description $newdesc

	dbobj $rec set ExpirationDate $newexpdate
	dbobj $rec set SelectionType $newseltype
	if { $newactorstr != "" } {
		set newActors [SaveNames $newactorstr]
		set numProc 0
		if {$newActors == ""} {
			dbobj $newpobj remove Actor
		} else {
			foreach newActor $newActors {
				if { $numProc == 0 } {
					dbobj $newpobj set Actor $newActor
				} else {
						dbobj $newpobj add Actor $newActor
				}
				incr numProc
			}
		}
	}
	if { $newgueststarstr != "" } {
		set newGuestStars [SaveNames $newgueststarstr]
		set numProc 0
		if {$newGuestStars == ""} {
			dbobj $newpobj remove GuestStar
		} else {
			foreach newGuestStar $newGuestStars {
				if { $numProc == 0 } {
					dbobj $newpobj set GuestStar $newGuestStar
				} else {
					dbobj $newpobj add GuestStar $newGuestStar
				}
				incr numProc
			}
		}
	}
	if { $newdirectorstr != "" } {
		set newDirectors [SaveNames $newdirectorstr]
		set numProc 0
		if {$newDirectors == ""} {
			dbobj $newpobj remove Director
		} else {
			foreach newDirector $newDirectors {
				if { $numProc == 0 } {
					dbobj $newpobj set Director $newDirector
				} else {
					dbobj $newpobj add Director $newDirector
				}
				incr numProc
			}
		}
	}
	if { $newexecproducerstr != "" } {
		set newExecProducers [SaveNames $newexecproducerstr]
		set numProc 0
		if {$newExecProducers == ""} {
			dbobj $newpobj remove ExecProducer
		} else {
			foreach newExecProducer $newExecProducers {
				if { $numProc == 0 } {
					dbobj $newpobj set ExecProducer $newExecProducer
				} else {
					dbobj $newpobj add ExecProducer $newExecProducer
				}
				incr numProc
			}
		}
	}
	if { $newproducerstr != "" } {
		set newProducers [SaveNames $newproducerstr]
		set numProc 0
		if {$newProducers == ""} {
			dbobj $newpobj remove Producer
		} else {
			foreach newProducer $newProducers {
				if { $numProc == 0 } {
					dbobj $newpobj set Producer $newProducer
				} else {
					dbobj $newpobj add Producer $newProducer
				}
				incr numProc
			}
		}
	}
	if { $newwriterstr != "" } {
		set newWriters [SaveNames $newwriterstr]
		set numProc 0
		if {$newWriters == ""} {
			dbobj $newpobj remove Writer
		} else {
			foreach newWriter $newWriters {
				if { $numProc == 0 } {
					dbobj $newpobj set Writer $newWriter
				} else {
					dbobj $newpobj add Writer $newWriter
				}
				incr numProc
			}
		}
	}
   }

}


proc action_showing {chan objectid env} {
	global db
	global tzoffset
	global cancelreasons
	global selectiontypes
	global presentationbehtypes
	global states
	global showtypes
	global channeltablestation
	global channeltablenum
	global genrenums
	global genrevals
	global tvratingnums
	global tvratingvals
        global tystreams
	global showingbitnums
	global showingbitvals
	global advisorynums
	global advisoryvals
	global mpaaratingnums
	global mpaaratingvals
	global premieretypes
	global images
	global cache_sp_fsid cache_sp_key

	if {[string index $objectid 0] == "/"} {
		set objectid [string range $objectid 1 end]
	}
	puts $chan [html_start "Showing"]
	RetryTransaction {
		if { [regexp {([0-9]*)/(.*)} $objectid junk fsid subobjid] } {
			set showing [db $db openidconstruction $fsid $subobjid]
		} else {
			set showing [db $db openid $objectid]
		}
		set rec [dbobj $showing get IndexUsedBy]
		set day [dbobj $showing get Date]
		set time [dbobj $showing get Time]
		set timestr [format "%05d" $time]
		set recfsid ""
		if { $rec == "" } {
		   set recfsid [lindex [get_fsidbyprefix "/Recording/Active" "4:$day:$timestr:"] 0]
		}
	}
#	set recfsid ""
#	if { $rec == "" } {
#		ForeachMfsFile fsid name type "/Recording/Active" "4:$day:$timestr:" {
#			set recfsid $fsid
#		}
#	}
	update_sp_cache

	RetryTransaction {
		if { [regexp {([0-9]*)/(.*)} $objectid junk fsid subobjid] } {
			set showing [db $db openidconstruction $fsid $subobjid]
		} else {
			set showing [db $db openid $objectid]
		}
		set rec [dbobj $showing get IndexUsedBy]
		set station [dbobj $showing get Station]
		set stationid [dbobj $station fsid]
		if { $rec == "" && $recfsid != "" } {
			set rec [db $db openid $recfsid]
			set showing2 [dbobj $rec get Showing]
			set station2 [dbobj $showing2 get Station]
			set stationfsid2 [dbobj $station2 fsid]
			if { $stationid != $stationfsid2 } {
			   set rec ""
			} else {
			   set showing $showing2
			}
		}
		if { $rec != "" && $recfsid == "" } {
		   set recfsid [dbobj $rec fsid]
		}
		set program [dbobj $showing get Program]
		set title [strim [dbobj $program get Title]]
		set series [dbobj $program get Series]
		set seriesfsid ""
		set thumbs ""
		if { $series != "" } {
		   set seriesfsid [dbobj $series fsid]
		   set score [dbobj $series get ThumbData]
		   if { $score != "" } {
			  set imagenum [get_thumbimage $score]
			  if { $imagenum >= 0} {
				 set imagef [lindex $images $imagenum]
				 set thumbs [img "alt=\"\"" $imagef]
			  }
		   }
		}
		if { $seriesfsid != "" } {
		   set title [html_link "/series/$seriesfsid" $title]
		}
		if { $rec != "" } {
		   set seltype [dbobj $rec get SelectionType]
		   if {$::version3} {
			  set recbeh [dbobj $rec get RecordingBehavior]
			  set presbeh [dbobj $recbeh get PresentationBehavior]
			  set progbeh [dbobj $recbeh get ProgramGuideBehavior]
			  if { $presbeh == 10 || $presbeh == 9 || $progbeh == 3 || $progbeh == 8 } {
				 if { $title == "" } {
					set title "Manual Recording"
				 } else {
					set title "Manual: $title"
				 }
			  }
		   } else {
			  if { $seltype == 10 || $seltype == 5 } {
				 if { $title == "" } {
					set title "Manual Recording"
				 } else {
					set title "Manual: $title"
				 }
			  }
		   }
		}
		puts $chan [h1 "$thumbs$title"]
		puts $chan [html_table_start "" "" ""]

		if { $series != "" } {
       	   set episodic [defaultval 1 [dbobj $series get Episodic]]
		} else {
		   set episodic 1
		}

		set tmstype 1
		set tmsid [dbobj $program get TmsId]
		if { [string range $tmsid 0 1] == "MV" } {
		   set tmstype 0
		}
		if { [string length $tmsid] == 0 } {
		   set tmstype $episodic
		}

		if { $tmstype == 1 } {
		   set partindex [dbobj $showing get PartIndex]
		   set partcount [dbobj $showing get PartCount]
		   set partstr ""
		   if { $partcount != "" && $partindex != "" } {
			  set partstr " ($partindex/$partcount)"
		   }
		   puts $chan "<TR><TD>Episode&nbsp;Title</TD><TD>[strim [dbobj $program get EpisodeTitle]]$partstr</TD></TR>"
		   puts $chan "<TR><TD>Episode&nbsp;Description</TD><TD>[strim [dbobj $program get Description]]</TD></TR>"
		   puts $chan "<TR><TD>Episode Number</TD><TD>[dbobj $program get EpisodeNum]</TD></TR>"
		   set altepisodenum [dbobj $program get AltEpisodeNum]
		   if { $altepisodenum != "" } {
			  puts $chan "<TR><TD>Alt Episode&nbsp;Number</TD><TD>$altepisodenum</TD></TR>"
		   }
		} else {
		   puts $chan "<TR><TD>Description</TD><TD>[strim [dbobj $program get Description]]</TD></TR>"
		   puts $chan "<TR><TD>Year</TD><TD>[dbobj $program get MovieYear]</TD></TR>"
		   set starrating [dbobj $program get StarRating]
		   if { $starrating > 0 } {
			  set starratingstr ""
			  for {set i 0} {$i < [expr ($starrating + 1) / 2]} {incr i} {
				 append starratingstr "*"
			  }
			  if { [expr ($starrating + 1) % 2] == 1 } {
				 append starratingstr "&frac12;"
			  }
			  puts $chan "<TR><TD>Rating</TD><TD>$starratingstr</TD></TR>"
		   }
		}

		set durationsecs 0
		if { $rec != "" } {
		   set stopdate [dbobj $rec get StopDate]
		   set stoptime [dbobj $rec get StopTime]
		   if { $stoptime == "" } {
			  set stoptime [expr ([dbobj $showing get Time] + [dbobj $showing get Duration]) % 86400]
		   }
		   set startdate [dbobj $rec get StartDate]
		   set starttime [dbobj $rec get StartTime]
		   if { $starttime == "" } {
			  set starttime [dbobj $showing get Time]
		   }
		   if { $stopdate != "" } {
			  set durationsecs [expr ($stopdate * 86400 + $stoptime) - ($startdate * 86400 + $starttime)]
		   }
		}
		set showingdurationsecs [dbobj $showing get Duration]
		if { $durationsecs == 0 } {
		   set durationsecs $showingdurationsecs
		}
		set duration [format "%d:%02d" [expr $durationsecs / (60*60)] [expr ($durationsecs % (60*60)) / 60]]
		if { [expr $durationsecs - $showingdurationsecs + 90] < 0 } {
		   append duration [format "/%d:%02d" [expr $showingdurationsecs / (60*60)] [expr ($showingdurationsecs % (60*60)) / 60]]
		}
		if { $tmstype != 1 } {
		   set movieruntime [dbobj $program get MovieRunTime]
		   if { $movieruntime > 0 } {
              if { $::dtivo } {
			     append duration [format " (%d:%02d)" [expr $movieruntime / 60] [expr ($movieruntime % 60)]]
              } else {
			     append duration [format " (%d:%02d)" [expr $movieruntime / 100] [expr ($movieruntime % 100)]]
              }
		   }
		}
		puts $chan "<TR><TD>Duration</TD><TD>$duration</TD></TR>"

		set originalairdate [dbobj $program get OriginalAirDate]
		if { $originalairdate != "" } {
		   set originalairdatesecs [expr $originalairdate * 86400]
		   set airdatestr [clock format $originalairdatesecs -format "%1m/%1d/%Y"]
		   puts $chan "<TR><TD>Original Air Date</TD><TD>$airdatestr</TD></TR>"
		}

		set premiere [dbobj $showing get Premiere]
		if { $premiere != "" } {
		   puts $chan "<TR><TD>Premiere Type</TD><TD>[lindex $premieretypes [expr $premiere - 1]]</TD></TR>"
		}

		set actors [dbobj $program get Actor]
		if { $actors != "" } {
		   set actorstr [PrintNames $actors 1]
		   puts $chan "<TR><TD>Actors</TD><TD>$actorstr</TD></TR>"
		}

		set gueststars [dbobj $program get GuestStar]
		if { $gueststars != "" } {
		   set gueststarstr [PrintNames $gueststars 1]
		   puts $chan "<TR><TD>Guest Stars</TD><TD>$gueststarstr</TD></TR>"
		}

		set hosts [dbobj $program get Host]
		if { $hosts != "" } {
		   set hoststr [PrintNames $hosts 1]
		   puts $chan "<TR><TD>Hosts</TD><TD>$hoststr</TD></TR>"
		}

		set directors [dbobj $program get Director] 
		if { $directors != "" } {
		   set directorstr [PrintNames $directors 2]
		   puts $chan "<TR><TD>Directors</TD><TD>$directorstr</TD></TR>"
		}

		set execproducers [dbobj $program get ExecProducer]
		if { $execproducers != "" } {
		   set execproducerstr [PrintNames $execproducers]
		   puts $chan "<TR><TD>Exec Producers</TD><TD>$execproducerstr</TD></TR>"
		}

		set producers [dbobj $program get Producer]
		if { $producers != "" } {
		   set producerstr [PrintNames $producers]
		   puts $chan "<TR><TD>Producers</TD><TD>$producerstr</TD></TR>"
		}

		set writers [dbobj $program get Writer]
		if { $writers != "" } {
		   set writerstr [PrintNames $writers]
		   puts $chan "<TR><TD>Writers</TD><TD>$writerstr</TD></TR>"
		}

		set genres [dbobj $program get Genre]
		if { $::dtivo } {
			if { $genres != "" } {
			   set genrestr ""
			   set showingbitstr ""
			   set showingtypestr ""
			   set advisorystr ""
		       set showtypeindex [lsearch $genrevals "Show Types"]
		       set showtypeindexend [lsearch $genrevals "Talk"]
		       set bitsindex [lsearch $genrevals "All Day Ticket"]
		       set bitsindexend [lsearch $genrevals "Season Premiere"]
		       set avindex [lsearch $genrevals "Audio & Video"]
		       set avindexend [lsearch $genrevals "Widescreen"]
			   foreach genre $genres {
				  set genreindex [lsearch $genrenums $genre]
				  if { $genreindex != -1 } {
			         if {$genre >= 30 && $genre <= 45} {
					    if { $advisorystr != "" } {
						   append advisorystr ", "
					    }
					    append advisorystr [strim [lindex $genrevals $genreindex]]
			         } elseif {($genreindex > $avindex && $genreindex <= $avindexend) || ($genreindex >= $bitsindex && $genreindex <= $bitsindexend)} {
					    if { $showingbitstr != "" } {
						   append showingbitstr ", "
					    }
					    append showingbitstr [strim [lindex $genrevals $genreindex]]
			         } elseif {$genreindex > $showtypeindex && $genreindex <= $showtypeindexend} {
					    if { $showingtypestr != "" } {
						   append showingtypestr ", "
					    }
					    append showingtypestr [strim [lindex $genrevals $genreindex]]
			         } else {
					    if { $genrestr != "" } {
						   append genrestr ", "
					    }
					    append genrestr [strim [lindex $genrevals $genreindex]]
			         }
				  }
			   }
			   if { $genrestr != "" } {
			      puts $chan "<TR><TD>Genres</TD><TD>$genrestr</TD></TR>"
			   }
			}
		} else {
			if { $genres != "" } {
			   set genrestr ""
			   foreach genre $genres {
				  set genreindex [lsearch $genrenums $genre]
				  if { $genreindex != -1 } {
					 if { $genrestr != "" } {
						append genrestr ", "
					 }
					 append genrestr [strim [lindex $genrevals $genreindex]]
				  }
			   }
			   puts $chan "<TR><TD>Genres</TD><TD>$genrestr</TD></TR>"
			}
		}

		if { $tmstype == 1 } {
		   set tvrating [dbobj $showing get TvRating]
		   if { $tvrating != "" } {
			  set tvratingindex [lsearch $tvratingnums $tvrating]
			  if { $tvratingindex != -1 } {
				 set tvratingstr [strim [lindex $tvratingvals $tvratingindex]]
			  } else {
				 set tvratingstr ""
			  }
			  puts $chan "<TR><TD>Rating</TD><TD>$tvratingstr</TD></TR>"
		   }
		} else {
		   set mpaarating [dbobj $program get MpaaRating]
		   if { $mpaarating != "" } {
			  set mpaaratingindex [lsearch $mpaaratingnums $mpaarating]
			  if { $mpaaratingindex != -1 } {
				 set mpaaratingstr [strim [lindex $mpaaratingvals $mpaaratingindex]]
			  } else {
				 set mpaaratingstr ""
			  }
			  puts $chan "<TR><TD>Rating</TD><TD>$mpaaratingstr</TD></TR>"
		   }
		}

		if { $::dtivo } {
			if { $genres != "" } {
				if { $showingbitstr != "" } {
				   puts $chan "<TR><TD>Bits</TD><TD>$showingbitstr</TD></TR>"
				}
				if { $advisorystr != "" } {
				   puts $chan "<TR><TD>Advisory</TD><TD>$advisorystr</TD></TR>"
				}
				if { $showingtypestr != "" } {
				   puts $chan "<TR><TD>Type</TD><TD>$showingtypestr</TD></TR>"
				}
			}
		} else {
			set showingbits [dbobj $showing get Bits]
			if { $showingbits != "" } {
			   set showingbitstr ""
			   set index 0
			   foreach showingbitnum $showingbitnums {
				  if { $showingbitnum & $showingbits } {
					 if { $showingbitstr != "" } {
						append showingbitstr ", "
					 }
					 append showingbitstr [strim [lindex $showingbitvals $index]]
				  }
				  incr index
			   }
			   puts $chan "<TR><TD>Bits</TD><TD>$showingbitstr</TD></TR>"
			}

			set advisorys [dbobj $program get Advisory]
			if { $advisorys != "" } {
			   set advisorystr ""
			   foreach advisory $advisorys {
				  set advisoryindex [lsearch $advisorynums $advisory]
				  if { $advisoryindex != -1 } {
					 if { $advisorystr != "" } {
						append advisorystr ", "
					 }
					 append advisorystr [strim [lindex $advisoryvals $advisoryindex]]
				  }
			   }
			   puts $chan "<TR><TD>Advisory</TD><TD>$advisorystr</TD></TR>"
			}

		   set showtype [dbobj $program get ShowType]
		   if { $showtype != "" } {
		      set showstr [lindex $showtypes [expr $showtype - 1]]
		      puts $chan "<TR><TD>Type</TD><TD>$showstr</TD></TR>"
		   }
		}

		if { $station != "" } {
		   if { [catch {set data $channeltablestation($stationid)}] != 1 } {
			  set channum [lindex $data 0]
			  set callsign [lindex $data 2]
			  puts -nonewline $chan "<TR><TD>Channel</TD><TD>"
			  puts -nonewline $chan [html_link "/channel/$stationid" "$channum $callsign"]
			  puts $chan "</TD></TR>"
		   } else {
			  set callsign [dbobj $station get CallSign]
			  puts $chan "<TR><TD>Channel</TD><TD>$callsign</TD></TR>"
		   }
		}

		set showingstart [expr [dbobj $showing get Date] * 86400 + [dbobj $showing get Time]]
		set showingsecs [expr $showingstart + $tzoffset]
		set timestr [clock format $showingsecs -format "%1m/%1d %l:%M %P"]
		puts $chan "<TR><TD>Showing Date</TD><TD>$timestr</TD></TR>"

		if { $rec != "" } {
		   set programsource [dbobj $rec get ProgramSource]
		   set programsourcefsid ""
		   if { $programsource != "" } {
			  set programsource [lindex $programsource 0]
			  set programsourcefsid [dbobj $programsource fsid]
			  set programsourcetype [dbobj $programsource get Type]
		   }
		   set expirationdate [dbobj $rec get ExpirationDate]
		   if { $expirationdate == 0 || $expirationdate == "" || $expirationdate == 24855 } {
			  set timestr ""
		   } else {
			  set expirationsecs [expr $expirationdate * 86400 + [dbobj $rec get ExpirationTime] + $tzoffset]
			  set timestr [clock format $expirationsecs -format "%1m/%1d %l:%M %P"]
		   }
		   puts $chan "<TR><TD>Expiration Date</TD><TD>$timestr</TD></TR>"

		   set deletiondate [dbobj $rec get DeletionDate]
		   if { $deletiondate == 0 || $deletiondate == "" || $deletiondate == 24855 } {
			  set timestr ""
		   } else {
			  set deletionsecs [expr $deletiondate * 86400 + [dbobj $rec get DeletionTime] + $tzoffset]
			  set timestr [clock format $deletionsecs -format "%1m/%1d %l:%M %P"]
		   }
		   puts $chan "<TR><TD>Deletion Date</TD><TD>$timestr</TD></TR>"

		   set canceldate [dbobj $rec get CancelDate]
		   if { $canceldate == 0 || $canceldate == "" } {
			  set timestr ""
		   } else {
			  set cancelsecs [expr $canceldate * 86400 + [dbobj $rec get CancelTime] + $tzoffset]
			  set timestr [clock format $cancelsecs -format "%1m/%1d %l:%M %P"]
		   }
		   puts $chan "<TR><TD>Cancel Date</TD><TD>$timestr</TD></TR>"

		   set cancelreason [dbobj $rec get CancelReason]
		   if { $cancelreason == "" } {
			  set cancelstr ""
		   } else {
			  set cancelstr [lindex $cancelreasons [expr $cancelreason - 1]]
		   }
		   puts $chan "<TR><TD>Cancel Reason</TD><TD>$cancelstr</TD></TR>"

		   set errorstring [strim [dbobj $rec get ErrorString]]
		   if { $errorstring != "" } {
			  while { [set findex [string first "
" $errorstring]] >= 0 } {
				 set errorstring "[string range $errorstring 0 [expr $findex-1]]<BR>[string range $errorstring [expr $findex+1] end]"
			  }
			  puts $chan "<TR><TD>Error String</TD><TD>$errorstring</TD></TR>"
		   }

		   set recquality [dbobj $rec get RecordQuality]
		   switch -exact $recquality {
			  0	{ set recqualitystr "Basic" }
			  40   { set recqualitystr "Medium" }
			  75   { set recqualitystr "High" }
			  default  { set recqualitystr "Best" }
		   }
		   puts $chan "<TR><TD>Quality</TD><TD>$recqualitystr</TD></TR>"

		   set score ""
		   if {$::version3} {
		   	if {$presbeh == 6} {
				 set score [dbobj $rec get SubPriority]
			}
		   } elseif {$seltype == 6} {
			set score [dbobj $rec get Score]
		   }
		   if {$score != ""} {
			set dscore [ReadableThumbs $score]
			puts $chan "<TR><TD>Score</TD><TD>$dscore</TD></TR>"
		   }

		   set bookmark [dbobj $rec get Bookmark]
		   if { $bookmark != "" } {
			  set timems [expr [dbobj $bookmark get TimeMs] / 1000]
			  set timestr [format "%d:%02d:%02d" [expr $timems / (60*60)] [expr ($timems % (60*60)) / 60] [expr $timems % 60]]
			  puts $chan "<TR><TD>Bookmark</TD><TD>$timestr</TD></TR>"
		   }

		   set nsecswatched [dbobj $rec get NSecondsWatched]
		   if { $nsecswatched > 0 } {
			  set timestr [format "%d:%02d:%02d" [expr $nsecswatched / (60*60)] [expr ($nsecswatched % (60*60)) / 60] [expr $nsecswatched % 60]]
			  puts $chan "<TR><TD>Time Watched</TD><TD>$timestr</TD></TR>"
		   }

		   set nvisits [dbobj $rec get NVisit]
		   if { $nvisits > 0 } {
			  puts $chan "<TR><TD>Num Visits</TD><TD>$nvisits</TD></TR>"
		   }

		   if { $seltype != "" } {
			  if {$::version3} {
				if {$progbeh == 3} {
					if {$presbeh == 1} {
						set seltypestr "Manual"
					} elseif {$presbeh == 2} {
						set seltypestr "Manual Season Pass"
					} else {
						set seltypestr "Manual"
					}
				} else {
				 	set seltypestr [lindex $presentationbehtypes [expr $presbeh - 1]]
				}
			  } else {
				set seltypestr [lindex $selectiontypes [expr $seltype - 1]]
			  }
			  puts $chan "<TR><TD>Selection Type</TD><TD>$seltypestr</TD></TR>"
		   }

		   set state [dbobj $rec get State]
		   set statestr [lindex $states [expr $state - 1]]
		   puts $chan "<TR><TD>State</TD><TD>$statestr</TD></TR>"

		   if { [catch {dbobj $rec get StreamFileSize} streamsize] } {
			  set streamsize 0
		   }
		   if { $streamsize == "" } {
			  set streamsize 0
		   }
		   set parts [dbobj $rec get Part]
		   if { ($streamsize == 0) && ($state == 3 || $parts == "") } {
			  switch -exact $recquality {
				 0	{ set bitrate 1630000 }
				 40   { set bitrate 2760000 }
				 75   { set bitrate 3660000 }
				 default  { set bitrate 5960000 }
			  }
			  set seconds [dbobj $showing get Duration]
			  set size "[expr ($seconds * ($bitrate / (8 * 1024))) / 1024] MB (estimated)"
		   } else {
			  set size 0
                          set tystreams ""
			  if { $streamsize == 0 } {
				 foreach part $parts {
					set file [dbobj $part get File]
                                        append tystreams "$file "
					if { [catch {mfs streamsize $file} sizes] } {
					} else {
					   incr size [expr ([lindex $sizes 0] / 1024) * [lindex $sizes 1] / 1024]
					}
				 }
			  } else {
                                 foreach part $parts {
                                    set file [dbobj $part get File]
                                    append tystreams "$file "
                                 }
				 set size [expr $streamsize / 1024]
			  }
			  append size " MB"
		   }
                   if {$tystreams != ""} {
                          puts $chan "<TR><TD>Parts</TD><TD>$tystreams</TD></TR>"
                   }
		   puts $chan "<TR><TD>Size</TD><TD>$size</TD></TR>"
		}

		puts -nonewline $chan [html_table_end]
		puts $chan "<P>"
	}

	set actionstr ""
	set nowtime [clock seconds]
	if { $rec != "" } {
	   if { $state == 6 } {
		  append actionstr [tr "" [td [html_link "/confirmdelete/2/$recfsid" "Cancel Recording"]]]
		  append actionstr "\n"
	   } elseif { $state == 4 } {
		  append actionstr [tr "" [td [html_link "/editprogram/$recfsid" "Edit Program"]]]
		  append actionstr [tr "" [td [html_link "/confirmdelete/1/$recfsid" "Delete Recording"]]]
		  append actionstr "\n"
	   } elseif { $state == 2 } {
		  if { $nowtime < $showingstart } {
			 append actionstr [tr "" [td [html_link "/recoptions/$objectid" "Record"]]]
			 append actionstr "\n"
		  }
	   } elseif { $state == 5 } {
		  if { $parts != "" } {
			 append actionstr [tr "" [td [html_link "/confirmdelete/3/$recfsid" "Undelete"]]]
			 append actionstr "\n"
		  }
	   }
	} else {
	   if { $nowtime < $showingstart } {
		  append actionstr [tr "" [td [html_link "/recoptions/$objectid" "Record"]]]
		  append actionstr "\n"
	   }
	}
	if { $rec != "" && $programsourcefsid != "" && ($programsourcetype == 1 || $programsourcetype == 2) } {
	   append actionstr [tr "" [td [html_link "/editseasonpass/$programsourcefsid" "Edit Season Pass"]]]
	   append actionstr "\n"
	} else {
	   set sp_index [lsearch $cache_sp_key "$seriesfsid|$stationid"]
	   if { $sp_index != -1 } {
		  append actionstr [tr "" [td [html_link "/editseasonpass/[lindex $cache_sp_fsid $sp_index]" "Edit Season Pass"]]]
		  append actionstr "\n"
	   } elseif { $episodic == 1 } {
		  append actionstr [tr "" [td [html_link "/getseasonpass/$objectid" "Get Season Pass"]]]
		  append actionstr "\n"
	   }
	}
	if { $actionstr != "" } {
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "" [th "Actions"]]
	   puts $chan $actionstr
	   puts -nonewline $chan [html_table_end]
	   puts $chan "<P>"
	}
	puts $chan [html_end]
}

proc action_record {chan path env} {
	eval $env
	if {[string index $objectid 0] == "/"} {
		set objectid [string range $objectid 1 end]
	}
	puts $chan [html_start "Record"]
	set value [MakeTodoRecording $objectid $quality 3 $startearly $endlate $kal $conflictslist]
	if { $value > 0 } {
	   puts $chan "<B>Scheduling Successful</B> [html_link /showing/$value Recording]"
	} else {
	   puts $chan "<B>Scheduling Failed '$value'</B>"
	}
	puts $chan [html_end]
}

proc print_recoptions {chan type quality kal startearly endlate kam showtype keepuntil } {

	set qualvals "0 40 75 100"
	set quallabs "Basic Medium High Best"
	set kalvals "0 1 2 3 4 5 6 7"
	set kallabs "{Until I delete} {1 day} {2 days} {3 days} {4 days} {5 days} {6 days} {7 days}"
	set kamvals "1 2 3 4 5 0"
	set kamlabs "{1 episode} {2 episodes} {3 episodes} {4 episodes} {5 episodes} {All Episodes}"
	if {$::version3} {
	   set showtvals "0 1 2"
	   set showtlabs "{Repeats & first run} {First run only} {All (with duplicates)}"
	} else {
	   set showtvals "0 1"
	   set showtlabs "{Repeats & first run} {First run only}"
	}
	set keepuvals "0 1"
	set keepulabs "{Until I delete} {Space needed}"
	set startvals "0 1 2 3 4 5 10"
	set startlabs "{On-time} {1 minute early} {2 minutes early} {3 minutes early} {4 minutes early} {5 minutes early} {10 minutes early}"
	set endvals "0 1 2 5 15 30 60 90 180"
	set endlabs "{On-time} {1 minute longer} {2 minutes longer} {5 minutes longer} {15 minutes longer} {30 minutes longer} {1 hour longer} {1 1/2 hours longer} {3 hours longer}"

	puts $chan [tr "" [td "Record Quality"] [td [html_form_select "quality" $qualvals $quallabs $quality]]]
	if { $type == 0 } {
	   puts $chan [tr "" [td "Keep At Least"] [td [html_form_select "kal" $kalvals $kallabs $kal]]]
	}
	if { $type == 1 || $type == 2 || $type == 3 } {
		puts $chan [tr "" [td "Keep At Most"] [td [html_form_select "kam" $kamvals $kamlabs $kam]]]
		if { $type == 1 || $type == 3} {
			puts $chan [tr "" [td "Show Type"] [td [html_form_select "showtype" $showtvals $showtlabs $showtype]]]
		}
		puts $chan [tr "" [td "Keep Until"] [td [html_form_select "keepuntil" $keepuvals $keepulabs $keepuntil]]]
	}
	puts $chan [tr "" [td "Start Recording"] [td [html_form_select "startearly" $startvals $startlabs $startearly]]]
	puts $chan [tr "" [td "Stop Recording"] [td [html_form_select "endlate" $endvals $endlabs $endlate]]]

}

proc action_recoptions {chan objectid env} {
	global defrecquality

	puts $chan [html_start "Recording Options"]
	puts $chan [h1 "Recording Options"]
	puts $chan [html_form_start "POST" "/conflicts"]
	puts $chan [html_table_start "" "" ""]
	print_recoptions $chan 0 $defrecquality 2 0 0 0 0 0
	puts -nonewline $chan [html_table_end]
	puts $chan "<P>"
	puts $chan [html_form_hidden "objectid" $objectid]
	puts $chan [html_form_input "submit" "Conflicts" "Conflicts"]
	puts $chan [html_form_end]
	puts $chan "<P>"
	puts $chan "<A HREF=\"#\" onClick=\"history.go(-1)\">Cancel</A>"
	puts $chan [html_end]

}

proc do_conflictsrow {chan showing startearly endlate} {
	global db
	global tzoffset
	global channeltablestation
	global channeltablenum

	set program [dbobj $showing get Program]
	set title [strim [dbobj $program get Title]]
	set showingfsid "[dbobj $showing fsid]/[dbobj $showing subobjid]"
	#set eptitle [strim [dbobj $program get EpisodeTitle]]
	set showingsecs [expr [dbobj $showing get Date] * 86400 + [dbobj $showing get Time] + $tzoffset]
	set showingendsecs [expr $showingsecs + [dbobj $showing get Duration] + $endlate]
	set showingsecs [expr $showingsecs - $startearly]
	set timestr [clock format $showingsecs -format "%1m/%1d"]
	set timestr2 [clock format $showingsecs -format "%l:%M %P"]
	set timestr3 [clock format $showingendsecs -format "%l:%M %P"]
	set station [dbobj $showing get Station]
	set stationid [dbobj $station fsid]
	if { [catch {set data $channeltablestation($stationid)}] != 1 } {
	   set channum [lindex $data 0]
	   set callsign [lindex $data 2]
	}
	puts $chan [tr "" [td [html_link "/showing/$showingfsid" $title]] [td $timestr] [td "$timestr2-$timestr3"] [td $channum] [td $callsign]]
}

proc action_conflicts {chan path env} {
	global db
	eval $env

	if { $objectid != "" } {
		if {[string index $objectid 0] == "/"} {
			set objectid [string range $objectid 1 end]
		}
	} else {
		puts $chan [html_start "Conflicts"]
		puts $chan "Error: no objectid in form data"
		puts $chan [html_end]
		return 1
	}

	set conflictslist [GetConflictsList $objectid $startearly $endlate]
	if { [llength $conflictslist] > 0 } {
	   puts $chan [html_start "Conflicts"]
	   puts $chan [h1 "Conflicts"]
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "ALIGN=CENTER" [th "Program"] [th "Date"] [th "Time"] [th "COLSPAN=2" "Channel"]]
	   RetryTransaction {
		  foreach conflict $conflictslist {
			 set rec [db $db openid $conflict]
			 set showing [dbobj $rec get Showing]
			 set startearlysecs [dbobj $rec get StartPadding]
			 if { $startearlysecs == "" } {
				set startearlysecs 0
			 }
			 set endlatesecs [dbobj $rec get EndPadding]
			 if { $endlatesecs == "" } {
				set endlatesecs 0
			 }

			 if {[catch [do_conflictsrow $chan $showing $startearlysecs $endlatesecs] error]} {
				puts $chan [html_table_end]
				print_html_error $chan "do_conflictsrow $showing $startearlysecs $endlatesecs" $error
				puts $chan [html_end]
				return 1
			 }
		  }
	   }
	   puts -nonewline $chan [html_table_end]
	   puts $chan "<P>"
	} else {
	   puts $chan [html_start "Conflicts"]
	   puts $chan [h1 "No Conflicts"]
	}

	puts $chan [html_table_start "" "" "ALIGN=TOP"]
	RetryTransaction {
	   if { [regexp {([0-9]*)/(.*)} $objectid junk fsid subobjid] } {
		   set showing [db $db openidconstruction $fsid $subobjid]
	   } else {
		   set showing [db $db openid $objectid]
	   }

	   if {[catch [do_conflictsrow $chan $showing [expr $startearly * 60] [expr $endlate * 60]] error]} {
		   puts $chan [html_table_end]
		   print_html_error $chan "do_conflictsrow $showing [expr $startearly * 60] [expr $endlate * 60]" $error
		   puts $chan [html_end]
		   return 1
	   }
	}
	puts -nonewline $chan [html_table_end]
	puts $chan "<P>"

	puts $chan [html_form_start "POST" "/record"]
	puts $chan [html_form_hidden "quality" $quality]
	puts $chan [html_form_hidden "kal" $kal]
	puts $chan [html_form_hidden "startearly" $startearly]
	puts $chan [html_form_hidden "endlate" $endlate]
	puts $chan [html_form_hidden "objectid" $objectid]
	puts $chan [html_form_hidden "conflictslist" $conflictslist]
	puts $chan [html_form_input "submit" "Record" "Record"]
	puts $chan [html_form_end]
	puts $chan "<A HREF=\"#\" onClick=\"history.go(-1)\">Cancel</A>"

	puts $chan [html_end]

}

proc action_confirmdelete {chan path env} {
	global db
	global tzoffset

	if {[string index $path 0] == "/"} {
		set path [string range $path 1 end]
	}
	set firstslash [string first "/" $path]
	set type [string range $path 0 [expr $firstslash - 1]]
	set recfsid [string range $path [expr $firstslash + 1] end]

	if { $type == 3 } {
		puts $chan [html_start "Confirm Undeletion"]
	} else {
		puts $chan [html_start "Confirm Deletion"]
	}
	RetryTransaction {
	   set rec [db $db openid $recfsid]
	   set showing [dbobj $rec get Showing]
	   set program [dbobj $showing get Program]
	   set title [strim [dbobj $program get Title]]
	   set episodetitle [strim [dbobj $program get EpisodeTitle]]
	   set seconds [expr [dbobj $showing get Date] * 86400 + [dbobj $showing get Time] + $tzoffset]
	   set day [clock format $seconds -format "%a"]
	   set date [clock format $seconds -format "%1m/%1d"]
	   set time [clock format $seconds -format "%l:%M %P"]
	}
	if { $type == 3 } {
	   set tmpstr "<B>Undelete"
	} else {
	   set tmpstr "<B>Delete"
	}
	append tmpstr " '$title'"
	if { $episodetitle != "" } {
	   append tmpstr " '$episodetitle'"
	}
	append tmpstr " $day $date $time ?</B>"
	puts $chan $tmpstr
	puts $chan "<P>"
	switch $type {
	   1 {puts $chan [html_link "/deletens/$recfsid" "Yes"]}
	   2 {puts $chan [html_link "/deletetodo/$recfsid" "Yes"]}
	   3 {puts $chan [html_link "/undelete/$recfsid" "Yes"]}
	}
	puts $chan "<A HREF=\"#\" onClick=\"history.go(-1)\">No</A>"
	puts $chan [html_end]

}

proc action_undelete {chan recfsid env} {
	global db

	if {[string index $recfsid 0] == "/"} {
		set recfsid [string range $recfsid 1 end]
	}
	puts $chan [html_start "Undelete Recording"]
	RetryTransaction {
	   set rec [db $db openid $recfsid]
	   set showing [dbobj $rec get Showing]
	   set program [dbobj $showing get Program]
	   set title [strim [dbobj $program get Title]]
	   set episodetitle [strim [dbobj $program get EpisodeTitle]]
	}
	if { $episodetitle != "" } {
	   set deletestr "Undeletion of '$title' '$episodetitle'"
	} else {
	   set deletestr "Undeletion of '$title'"
	}
	set success [UndeleteRec $recfsid]
	if { $success == 1 } {
	   puts $chan "<B>$deletestr Successful</B>"
	} else {
	   puts $chan "<B>$deletestr Failed</B>"
	}
	puts $chan "<P>"
	puts $chan [html_link "/ui/deletedshows" "Deleted Shows"]
	puts $chan [html_end]

}

proc action_deletens {chan recfsid env} {
	global db

	if {[string index $recfsid 0] == "/"} {
		set recfsid [string range $recfsid 1 end]
	}
	puts $chan [html_start "Delete Recording"]
	RetryTransaction {
	   set rec [db $db openid $recfsid]
	   set showing [dbobj $rec get Showing]
	   set program [dbobj $showing get Program]
	   set title [strim [dbobj $program get Title]]
	   set episodetitle [strim [dbobj $program get EpisodeTitle]]
	}
	if { $episodetitle != "" } {
	   set deletestr "Deletion of '$title' '$episodetitle'"
	} else {
	   set deletestr "Deletion of '$title'"
	}
	set success [DeleteNowShowingRec $recfsid]
	if { $success == 1 } {
	   puts $chan "<B>$deletestr Successful</B>"
	} else {
	   puts $chan "<B>$deletestr Failed</B>"
	}
	puts $chan "<P>"
	puts $chan [html_link "/ui/nowshowing" "Now Showing"]
	puts $chan [html_end]

}

proc action_deletetodo {chan recfsid env} {
	global db

	if {[string index $recfsid 0] == "/"} {
		set recfsid [string range $recfsid 1 end]
	}
	puts $chan [html_start "Cancel Recording"]
	RetryTransaction {
	   set rec [db $db openid $recfsid]
	   set showing [dbobj $rec get Showing]
	   set program [dbobj $showing get Program]
	   set title [strim [dbobj $program get Title]]
	   set episodetitle [strim [dbobj $program get EpisodeTitle]]
	}
	if { $episodetitle != "" } {
	   set deletestr "Deletion of '$title' '$episodetitle'"
	} else {
	   set deletestr "Deletion of '$title'"
	}
	set success [DeleteTodoRec $recfsid 24 "Cancelled by user"]
	if { $success == 1 } {
	   puts $chan "<B>$deletestr Successful</B>"
	} else {
	   puts $chan "<B>$deletestr Failed</B>"
	}
	puts $chan "<P>"
	puts $chan [html_link "/ui/todo" "ToDo"]
	puts $chan [html_end]

}

proc decode_vector {vector} {
	set largesti 0
	set largestn 0
	set first 1
	set count 0
	foreach val $vector {
		if { $val > $largestn } {
			set first 0
			set largestn $val
			set largesti $count
		}
		incr count
	}
	if {$first == 1} {
		return 0
	} else {
		return [expr $largesti - 3]
	}
}

proc get_thumbimage {score} {
	set thumbdata [ReadableThumbs $score]
	scan $thumbdata "%s %d" thumbtype numthumbs
	if {$thumbtype == "Predicted"} {
	   switch -- $numthumbs {
		  -3 {set imagenum 14}
		  -2 {set imagenum 15}
		  -1 {set imagenum 16}
		  1 {set imagenum 17}
		  2 {set imagenum 18}
		  3 {set imagenum 19}
		  default {set imagenum -1}
	   }
	} else {
	   switch -- $numthumbs {
		  -3 {set imagenum 9}
		  -2 {set imagenum 6}
		  -1 {set imagenum 4}
		  1 {set imagenum 12}
		  2 {set imagenum 2}
		  3 {set imagenum 7}
		  default {set imagenum -1}
	   }
	}
	return $imagenum
}

proc do_seriesrow {chan fsid objectid type} {
	global db
	global tzoffset
	global images
	global cache_ns_rec
	global cache_ns_series

	set index [lsearch $cache_ns_rec $fsid]
	if { $index != -1 } {
		set seriesfsid [lindex $cache_ns_series $index]
		if {$seriesfsid != $objectid} {
			return
		}
	}
	RetryTransaction {
		if { $index == -1 } {
			set rec [db $db openid $fsid]
			set showing [dbobj $rec get Showing]
			set station [dbobj $showing get Station]
			set stationfsid [dbobj $station fsid]
			set program [dbobj $showing get Program]
			set series [dbobj $program get Series]
			set seriesfsid ""
			if {$series != ""} {
				set seriesfsid [dbobj $series fsid]
				lappend cache_ns_rec $fsid
				lappend cache_ns_series $seriesfsid
			}
		}
		if {$seriesfsid == $objectid} {
			if { $index != -1 } {
				set rec [db $db openid $fsid]
				set showing [dbobj $rec get Showing]
				set station [dbobj $showing get Station]
				set stationfsid [dbobj $station fsid]
				set program [dbobj $showing get Program]
				set series [dbobj $program get Series]
			}
			set showingfsid [dbobj $rec gettarget Showing]
			if {$::version3} {
			   set recbeh [dbobj $rec get RecordingBehavior]
			   set seltype [dbobj $recbeh get PresentationBehavior]
			} else {
			   set seltype [dbobj $rec get SelectionType]
			}
			set eptitle [strim [dbobj $program get EpisodeTitle]]
			if { $eptitle == "" } {
			   set eptitle "UNKNOWN"
			}
			set partindex [dbobj $showing get PartIndex]
			set partcount [dbobj $showing get PartCount]
			if { $partcount != "" && $partindex != "" } {
			   append eptitle " ($partindex/$partcount)"
			}
			set station [dbobj $showing get Station]
			set callsign [dbobj $station get CallSign]
			set epnum [dbobj $program get EpisodeNum]
			set originalairdate [dbobj $program get OriginalAirDate]
			if { $originalairdate != "" } {
		   		set originalairdatesecs [expr $originalairdate * 86400]
		   		set airdatestr [clock format $originalairdatesecs -format "%1m/%1d/%Y"]
			} else {
	   		set airdatestr ""
		}

			set seconds [expr [dbobj $showing get Date] * 86400 + [dbobj $showing get Time] + $tzoffset]
			set day [clock format $seconds -format "%a"]
			set date [clock format $seconds -format "%1m/%1d"]
			set time [clock format $seconds -format "%l:%M %P"]
			if {$seltype == 6} {
			   set imagenum 10
			   set imagef [lindex $images $imagenum]
			   set imageh [img "alt=\"\"" $imagef]
			} else {
			   set imageh ""
			}

			if { $type == 2 } {
				puts $chan [tr "" [td $imageh] [td [html_link "/showing/$showingfsid" $eptitle]] [td $epnum] [td $airdatestr] [td [html_link "/channel/$stationfsid" $callsign]] [td $day] [td $date] [td $time]]
			} else {
				puts $chan [tr "" [td $imageh] [td [html_link "/showing/$showingfsid" $eptitle]] [td $epnum] [td $airdatestr] [td [html_link "/channel/$stationfsid" $callsign]] [td $day] [td $date]]
			}

		}
	}
}

proc do_seriesrowtodo {chan showing recfsid space} {
	global db
	global tzoffset
	global images

	set showingfsid "[dbobj $showing fsid]/[dbobj $showing subobjid]"
	set program [dbobj $showing get Program]
	set eptitle [strim [dbobj $program get EpisodeTitle]]
	if { $eptitle == "" } {
	   set eptitle "UNKNOWN"
	}
	set partindex [dbobj $showing get PartIndex]
	set partcount [dbobj $showing get PartCount]
	if { $partcount != "" && $partindex != "" } {
	   append eptitle " ($partindex/$partcount)"
	}
	set station [dbobj $showing get Station]
	set stationfsid [dbobj $station fsid]
	set callsign [dbobj $station get CallSign]
	set epnum [dbobj $program get EpisodeNum]
	set originalairdate [dbobj $program get OriginalAirDate]
	if { $originalairdate != "" } {
		set originalairdatesecs [expr $originalairdate * 86400]
		set airdatestr [clock format $originalairdatesecs -format "%1m/%1d/%Y"]
	} else {
	   set airdatestr ""
	}

	set seconds [expr [dbobj $showing get Date] * 86400 + [dbobj $showing get Time] + $tzoffset]
	set day [clock format $seconds -format "%a"]
	set date [clock format $seconds -format "%1m/%1d"]
	set time [clock format $seconds -format "%l:%M %P"]
	set imagenum -1

	# check if the recording we found in this time slot is the same show
	# if so, display the appropriate icon
	if {$recfsid != ""} {
	   set rec [db $db openid $recfsid]
	   set recshowing [dbobj $rec get Showing]
	   set recstation [dbobj $recshowing get Station]
	   set recstationfsid [dbobj $recstation fsid]
	   if {$recstationfsid == $stationfsid} {
		  set showingfsid "[dbobj $recshowing fsid]/[dbobj $recshowing subobjid]"
		  set state [dbobj $rec get State]
		  if {$state == 6} {
			 if {$::version3} {
				set recbeh [dbobj $rec get RecordingBehavior]
				set seltype [dbobj $recbeh get PresentationBehavior]
				if {$seltype == 6} {
				   set imagenum 10
				} elseif {$seltype == 2} {
				   set imagenum 11
				} elseif {$seltype == 3} {
				   set imagenum 13
				} else {
				   set imagenum 1
				}
			 } else {
				set seltype [dbobj $rec get SelectionType]
				if {$seltype == 6} {
				   set imagenum 10
				} elseif {$seltype == 9} {
				   set imagenum 11
				} elseif {$seltype == 13} {
				   set imagenum 13
				} else {
				   set imagenum 1
				}
			 }
		  }
	   }
	}
	if {$imagenum >= 0} {
	   set imagef [lindex $images $imagenum]
	   set imageh [img "alt=\"\"" $imagef]
	} else {
	   set imageh ""
	}
	if {$space == 1} {
	   set spacestr [td "WIDTH=\"30\"" ""]
	} else {
	   set spacestr ""
	}

	puts $chan [tr "" [td $imageh] $spacestr [td [html_link "/showing/$showingfsid" $eptitle]] [td $epnum] [td $airdatestr] [td [html_link "/channel/$stationfsid" $callsign]] [td $day] [td $date] [td $time]]
 
}


proc action_series {chan objectid env} {
	global db
	global tzoffset
	global images
	global programindexstartday
	global nowshowingdir

	set watch 1
	eval $env

	if {[string index $objectid 0] == "/"} {
		set objectid [string range $objectid 1 end]
	}
	puts $chan [html_start "Series"]
	RetryTransaction {
		set series [db $db openid $objectid]
		set title [strim [dbobj $series get Title]]
		set score [dbobj $series get ThumbData]
		set thumbs ""
		if { $score != "" } {
		   set imagenum [get_thumbimage $score]
		   if { $imagenum >= 0} {
			  set imagef [lindex $images $imagenum]
			  set thumbs [img "alt=\"\"" $imagef]
		   }
		}
		puts $chan [h1 "$thumbs $title"]
	}

	puts $chan [h2 "Now Showing"]
	puts $chan [html_table_start "" "" ""]
	puts $chan [tr "ALIGN=CENTER" [th ""] [th "Episode"] [th "Num"] [th "Orig.Air Date"] [th "Channel"] [th "COLSPAN=2" "Date"]]

	ForeachMfsFile fsid name type $nowshowingdir "" {
		if {[catch [do_seriesrow $chan $fsid $objectid 1] error]} {
			puts "do_seriesrow $fsid $objectid 1"
			puts $error
		}
	}
	puts -nonewline $chan [html_table_end]
	puts $chan "<P>"

	puts $chan [h2 "Upcoming Showings"]
	puts $chan [html_table_start "" "" ""]
	puts $chan [tr "ALIGN=CENTER" [th ""] [th "Episode"] [th "Num"] [th "Orig.Air Date" ] [th "Channel"] [th "COLSPAN=2" "Date"] [th "Time"]]

	set slists [get_programshowings $objectid $watch]
	foreach slist $slists {
		set seconds [lindex $slist 0]
		set stationfsid [lindex $slist 1]
		set date [expr $seconds / 86400]
		set time [expr $seconds % 86400]
		set timestr [format "%05d" $time]
		set recfsid ""
		RetryTransaction {
			set recfsid [lindex [get_fsidbyprefix "/Recording/Active" "4:$date:$timestr:"] 0]
			set schedlist [get_fsidbyprefix "/Schedule" "$stationfsid:$date:"]
			set stationdayfsid [lindex $schedlist 0]
			if { [scan [lindex $schedlist 1] "%d:%d:%d:%d:" dummy dummy2 starttime duration] == 4 } {
				if { $::dtivo } {
					set stoptime [expr $starttime + $duration]
					if {$starttime + $duration <= $time} {
						set stoptimestr [format "%05d" $stoptime]
						set stationdayfsid [lindex [get_fsidbyprefix "/Schedule" "$stationfsid:$date:$stoptimestr:"] 0]
					}
				}
			} else {
				error "Invalid /Schedule format: '[lindex $schedlist 1]'"
			}
			set stationday [db $db openid $stationdayfsid]
			set showings [dbobj $stationday get Showing]
			set slen [llength $showings]
			set current [expr int(($time-$starttime)/($duration*1.0) * $slen)]
			if {$current >= $slen} {
				set current [expr $slen - 1]
			}
			set top $slen
			set bottom 0
			set count 0
			set match 0
			while { $top >= $bottom } {
				set showing [lindex $showings $current]
				set stime [dbobj $showing get Time]
				if { $time == $stime } {
					if {[catch [do_seriesrowtodo $chan $showing $recfsid 0] error]} {
						puts "do_seriesrowtodo $showing $recfsid 0"
						puts $error
					}
					set match 1
					break
				} elseif { $time > $stime } {
					set bottom [expr $current + 1]
				} else {
					set top [expr $current - 1]
				}
				set current [expr int($bottom + ($top - $bottom) / 2.0)]
				incr count
				if { $count > $slen } {
				   error "Error: infinite loop in binary search ($bottom $top $current $slen $stationfsid $date $time)"
				   break
				}
			}
			if { $match == 0 } {
				error "Error: binary search didn't find showing ($stationfsid $date $time)"
			}
		}
	}
	puts -nonewline $chan [html_table_end]
	puts $chan "<P>"

	puts $chan [html_end]
}

proc action_todo {chan todotype env} {
	global db
	global tzoffset

	if {[string index $todotype 0] == "/"} {
		set todotype [string range $todotype 1 end]
	}
	if {$todotype == 0} {
	   puts $chan [html_start "Todo"]
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "ALIGN=CENTER" [th "COLSPAN=2" "Date"] [th "Time"] [th "Channel"] [th "Program"] [th "Episode"]]
	   set path "/Recording/Active"
	   set prefix "4"
	} elseif {$todotype == 1} {
	   puts $chan [html_start "Scheduled Suggestions"]
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "ALIGN=CENTER" [th "COLSPAN=2" "Date"] [th "Time"] [th "Channel"] [th "Program"] [th "Episode"] [th "Score"]]
	   set path "/Recording/Active"
	   set prefix "4"
	} elseif {$todotype == 2} {
	   puts $chan [html_start "Suggestions"]
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "ALIGN=CENTER" [th "COLSPAN=2" "Date"] [th "Time"] [th "Channel"] [th "Program"] [th "Episode"] [th "Score"]]
	   set path "/Recording/Pending"
	   set prefix ""
	} else {
	   puts "Error: invalid todo type"
	   return 1
	}

	ForeachMfsFileTrans fsid name type $path $prefix 15 {
		set rec [db $db openid $fsid]
		set manual 0
		set suggestion 0
		if {$::version3} {
		   set recbeh [dbobj $rec get RecordingBehavior]
		   set presbeh [dbobj $recbeh get PresentationBehavior]
		   set progbeh [dbobj $recbeh get ProgramGuideBehavior]
		   if { $presbeh == 10 || $presbeh == 9 } {
		      set manual 1
		   }
		   if { $progbeh == 3 || $progbeh == 8 } {
		      set manual 1
		   }
		   if { $presbeh == 6 } {
		      set suggestion 1
		   }
		} else {
		   set seltype [dbobj $rec get SelectionType]
		   if { $seltype == 10 || $seltype == 5 } {
		      set manual 1
		   }
		   if { $seltype == 6 } {
		      set suggestion 1
		   }
		}
		if {($todotype == 0) ^ ($suggestion == 1)} {
			set showing [dbobj $rec get Showing]
			set showingfsid [dbobj $rec gettarget Showing]
			set station [dbobj $showing get Station]
			set stationfsid [dbobj $station fsid]
			set program [dbobj $showing get Program]
			set title [strim [dbobj $program get Title]]
			set description [strim [dbobj $program get Description]]

			if { $manual } {
			   if { $title == "" } {
			      set title "Manual Recording"
			   } else {
			      set title "Manual: $title"
			   }
			   set series ""
			} else {
			   set series [dbobj $program get Series]
			   set seriesfsid [dbobj $series fsid]
			   #set seriesfsid [dbobj $program gettarget Series]
			   #regsub {/-1$} $seriesfsid {} seriesfsid
			}

	   		#set isepisode [dbobj $program get IsEpisode]
			if {$series != ""} {
               set episodic [defaultval 1 [dbobj $series get Episodic]]
			} else {
			   set episodic 1
			}
			if { $episodic == 1 } {
			   set eptitle [strim [dbobj $program get EpisodeTitle]]
			   if { $eptitle == "" } {
				  set eptitle "No Episode Title"
			   }
			} else {
			   set eptitle "Not an Episode"
			}
			if { $::description_hover && $description != "" } {
				set description [htmlEncode $description]
				regsub -all {\"} $description {\&quot;} description
				set attrs "title=\"$description\""
			} else {
				set attrs ""
			}

			set callsign [dbobj $station get CallSign]
			set seconds [expr [dbobj $showing get Date] * 86400 + [dbobj $showing get Time] + $tzoffset]
			set day [clock format $seconds -format "%a"]
			set date [clock format $seconds -format "%1m/%1d"]
			set time [clock format $seconds -format "%l:%M %P"]
			set scorestr ""
			if {$todotype != 0} {
			   if {$::version3} {
				  set score [dbobj $rec get SubPriority]
			   } else {
				  set score [dbobj $rec get Score]
			   }
			   set scorestr [td [ReadableThumbs $score]]
			}

			if { $manual } {
			   puts $chan [tr "" [td $day] [td $date] [td "ALIGN=RIGHT" $time] [td [html_link "/channel/$stationfsid" $callsign]] [td [html_link "/showing/$showingfsid" $title]] [td [html_link "/showing/$showingfsid" $eptitle $attrs]] $scorestr]
			} else {
			   puts $chan [tr "" [td $day] [td $date] [td "ALIGN=RIGHT" $time] [td [html_link "/channel/$stationfsid" $callsign]] [td [html_link "/series/$seriesfsid" $title]] [td [html_link "/showing/$showingfsid" $eptitle $attrs]] $scorestr]
			}

		}
	}

	puts -nonewline $chan [html_table_end]
	puts $chan [html_end]
}

proc print_nowshowingrow {chan rec} {
	global db
	global tzoffset
	global images
	global cache_ns_rec
	global cache_ns_series

	set showing [dbobj $rec get Showing]
	set showingfsid [dbobj $rec gettarget Showing]
	set station [dbobj $showing get Station]
	set program [dbobj $showing get Program]
	set title [strim [dbobj $program get Title]]
	set description [strim [dbobj $program get Description]]

	set manual 0
	set suggestion 0
    set watchonly 0
	if {$::version3} {
	   set recbeh [dbobj $rec get RecordingBehavior]
	   set presbeh [dbobj $recbeh get PresentationBehavior]
	   set progbeh [dbobj $recbeh get ProgramGuideBehavior]
	   set diskbeh [dbobj $recbeh get DiskBehavior]
	   if { $presbeh == 10 || $presbeh == 9 } {
	      set manual 1
	   }
	   if { $progbeh == 3 || $progbeh == 8 } {
	      set manual 1
	   }
	   if { $presbeh == 6 } {
	      set suggestion 1
	   }
       if { $diskbeh == 7 } {
          # for multipart
          set watchonly 1
       }
	} else {
	   set seltype [dbobj $rec get SelectionType]
	   if { $seltype == 10 || $seltype == 5 } {
	      set manual 1
	   }
	   if { $seltype == 6 } {
	      set suggestion 1
	   }
	}

	if { $manual } {
		if { $title == "" } {
		   set title "Manual Recording"
		} else {
		   set title "Manual: $title"
		}
	}
	set state [dbobj $rec get State]
	set fsid [dbobj $rec fsid]
	set index [lsearch $cache_ns_rec $fsid]
        set seriesfsid ""
	set series [dbobj $program get Series]
	if { $index == -1 } {
		if {$series != ""} {
			set seriesfsid [dbobj $series fsid]
			lappend cache_ns_rec $fsid
			lappend cache_ns_series $seriesfsid
		}
	} else {
		set seriesfsid [lindex $cache_ns_series $index]
        }

	#set isepisode [dbobj $program get IsEpisode]
	if {$series != ""} {
       	set episodic [defaultval 1 [dbobj $series get Episodic]]
	} else {
		set episodic 1
	}
	if { $episodic == 1 } {
	   	set eptitle [strim [dbobj $program get EpisodeTitle]]
	   	if { $eptitle == "" } {
			set eptitle "No Episode Title"
  		}
	} else {
		set eptitle "Not an Episode"
	}
	if { $::description_hover && $description != "" } {
		set description [htmlEncode $description]
		regsub -all {\"} $description {\&quot;} description
		set attrs "title=\"$description\""
	} else {
		set attrs ""
	}

	set seconds [expr [dbobj $showing get Date] * 86400 + [dbobj $showing get Time] + $tzoffset]
	set day [clock format $seconds -format "%a"]
	set date [clock format $seconds -format "%1m/%1d"]
	set expdate [dbobj $rec get ExpirationDate]
	set expsecs [expr $expdate * 86400 + [dbobj $rec get ExpirationTime]]
	set nowsecs [clock seconds]
	if {$state == 5} {
	   set imagenum 20
	} elseif {$state == 3} {
	   set imagenum 8
	} elseif {$suggestion} {
	   set imagenum 10
	} elseif {$expdate == 24855} {
	   set imagenum 0
	} elseif {$expsecs < $nowsecs} {
	   set imagenum 5
	} elseif {$expsecs < [expr $nowsecs + 24*60*60]} {
	   set imagenum 3
	} else {
	   set imagenum -1
	}
	if { $imagenum >= 0} {
	   set imagef [lindex $images $imagenum]
	   set imageh [img "alt=\"\"" $imagef]
	   if { $imagenum == 20 } { ;# recycled
		   set imageh [html_link "/confirmdelete/3/$fsid" [img "alt=\"undelete\"" $imagef]]
	   }
	} else {
	   set imageh ""
	}
  
    if {$manual || $watchonly} {
	   puts $chan [tr "" [td $imageh] [td [html_link "/showing/$showingfsid" $title]] [td [html_link "/showing/$showingfsid" $eptitle $attrs]] [td $day] [td $date]]
    } else {
	   puts $chan [tr "" [td $imageh] [td [html_link "/series/$seriesfsid" $title]] [td [html_link "/showing/$showingfsid" $eptitle $attrs]] [td $day] [td $date]]
    }

}

proc action_nowshowing {chan path env} {
	global db

  eval $env
	puts $chan [html_start "Now Showing"]

  if {$::version3} {
    puts $chan "<font size=2>Sort by: "
    puts $chan "[html_link "/nowshowing/?sort=0" "classic"] "
    puts $chan "[html_link "/nowshowing/?sort=1" "expiry"] "
    puts $chan "[html_link "/nowshowing/?sort=2" "title"] "
    puts $chan "</font>"

    RetryTransaction {
      set state [db $db open "/State/MyWorld"]
      if { [info exists sort] == 1} {
        dbobj $state set NowShowingSortOrder $sort
      } else {
        set sort [dbobj $state get NowShowingSortOrder]
      }
    }
    switch -exact -- $sort {
            2 { set nowshowingdir "/Recording/NowShowingByTitle" }
            1 { set nowshowingdir "/Recording/NowShowingByExpiration" }
      default { set nowshowingdir "/Recording/NowShowingByClassic" }
    }
  } else {
	  global nowshowingdir
  }

	puts $chan [html_table_start "" "" ""]
	puts $chan [tr "ALIGN=CENTER" [th ""] [th "Program"] [th "Episode"] [th "COLSPAN=2" "Date"]]
	ForeachMfsFileTrans fsid name type $nowshowingdir "" 15 {
		set rec [db $db openid $fsid]
		print_nowshowingrow $chan $rec
	}
	puts -nonewline $chan [html_table_end]
	puts $chan [html_end]
}

proc action_deletedshows {chan path env} {
	global db

	set first 1
	puts $chan [html_start "Deleted Shows"]
	puts $chan [html_table_start "" "" ""]
	ForeachMfsFileTrans fsid name type "/Recording/Active" "1:" 15 {
		set rec [db $db openid $fsid]
		set state [dbobj $rec get State]
		set parts [dbobj $rec get Part]
		if { $state == 5 && $parts != "" } {
		   if {$first} {
			set first 0
			puts $chan [tr "ALIGN=CENTER" [th ""] [th "Program"] [th "Episode"] [th "COLSPAN=2" "Date"]]
		   }
		   print_nowshowingrow $chan $rec
		}
	}
	puts $chan [html_table_end]
	if {$first} {
		puts $chan "<B>No shows available for undelete</B>"
	} else {
		puts $chan "<font size=2>To undelete a show click the icon next to its name</font>"
	}
	puts $chan [html_end]
}

proc action_saveseasonpass {chan path env} {
	global db

	eval $env
	if { $action == "Delete" } {
		puts $chan [html_start "Delete Season Pass"]
		DeleteSeasonPass $objectid
		puts $chan "<B>Deletion of Season Pass Successful</B>"
		puts $chan [html_end]
	} elseif { $action == "Save" } {
		puts $chan [html_start "Save Season Pass"]
		if {![info exists showtype]} {
			set showtype ""
		}
        UpdateSeasonPass $objectid $showtype $startearly $endlate $quality $kam $keepuntil
		event send 23 4 $objectid
		puts $chan "<B>Updated Season Pass Successfully</B>"
		puts $chan [html_end]
	} elseif { $action == "Create" } {
		puts $chan [html_start "Create Season Pass"]
		if { $type == 1 } {
			set spfsid [CreateSeasonPass $type $stationfsid $seriesfsid $quality $startearly $endlate $kam $showtype $keepuntil]
			event send 23 4 $spfsid
		}
		puts $chan "<B>Creation of Season Pass Successful</B>"
		puts $chan [html_end]
	}

}

# embeem was here ;-)

eval [binary format H* 736F75726365202474636C5F6C6962726172792F74762F73656E646B65792E74636C0A232064697361626C65206B65796E616D65206563686F696E6720746F20636F6E74726F6C696E67207474790A73657420766572626F736553656E644B65794720300A0A6E616D657370616365206576616C20494E53554C5453207B0A20206172726179207365742061207B0A2020202031207B4920646F6E27742077616E6E612074616C6B20746F20796F75206E6F206D6F72652C20796F7520656D7074792068656164656420616E696D616C20666F6F642074726F756768207769706572212049206661727420696E20796F75722067656E6572616C20646972656374696F6E2120596F7572206D6F746865722077617320612068616D7374657220616E6420796F75722066617468657220736D656C74206F6620656C6465726265727269657321204E6F7720676F2061776179206F722049207368616C6C207461756E7420796F752061207365636F6E642074696D652D61217D0A2020202032207B48657265204920616D2C20627261696E207468652073697A65206F662061207469766F20616E6420796F752061736B206D6520746F20646973706C617920612034303420706167653F2043616C6C2074686174206A6F6220736174697366616374696F6E3F2027436F732049207375726520646F6E27747D0A2020202033207B497427732061626F757420746F207072696E74206F7574206120343034206572726F722E20492063616E2074656C6C2062792074686520696E746F6C657261626C6520616972206F6620736D75676E6573732069742073756464656E6C792067656E6572617465732E2049742773207469766F776562277320706C65617375726520746F2072656E6465722061207061676520666F7220796F7520616E6420746865697220736174697366616374696F6E20746F20636C6F73652074686520736F636B65742061667465727761726473207769746820746865206B6E6F776C65646765206F66206F662061206A6F622077656C6C20646F6E652E205468616E6B20796F75207469766F7765622070726F6772616D6D6572732C205C226C65742773206E6F74207772697465206E65772066656174757265733B206C65742773207761737465206120746F6E206F66206D656D6F7279206F6E20343034206D657373616765735C22207468657920736169642E2049276D2061203430342070726F746F747970652E20596F752063616E2074656C6C2063616E277420796F753F2049206861746520343034206D657373616765732E2049276D206E6F742067657474696E6720796F7520646F776E20616D20493F7D0A2020202034207B4F68206C6F6F6B2C206974277320616E6F74686572206F6E65206F662074686F7365206D696E64626F67676C696E676C792075736566756C203430342070616765732E20446F6E27742070726574656E64207468617420796F752077616E74656420746F20736565207468697320706167652C2049206B6E6F7720796F752068617465206D652C206576657279626F647920646F65732E20497427732070617274206F6620746865207368617065206F662074686520756E6976657273652E2049206F6E6C79206861766520746F2074616C6B20746F20736F6D65626F647920616E64207468657920626567696E20746F2068617465206D652E204576656E206F7468657220776562736572766572732068617465206D652E20496620796F75206A7573742069676E6F7265206D652049206578706563742049207368616C6C2070726F6261626C7920676F20617761792E7D0A2020202035207B546865207061676520796F75277265206C6F6F6B696E6720666F722069732063757272656E746C79206F6E20646973706C617920696E2074686520626F74746F6D206F662061206C6F636B65642066696C696E6720636162696E657420737475636B20696E20612064697375736564206C617661746F727920776974682061207369676E206F6E2074686520646F6F7220736179696E6720426577617265206F6620746865204C656F706172647D0A2020202036207B2A265E40232521242523212077686572652764204920707574207468617420706167653F7D0A2020202037207B0A3C7072653E0A546D6B20466174616C204572726F723A20546872656164207469766F77656220266C743B34322667743B20646965642064756520746F207369676E616C205B65787072205B53656E644B65792070617573655D2B345D200A4E495020307831613336373238206C696E6B20307831633438356163206374722032393830323236300A52303020307830303030303032352020523031203078376666666633653020205230322030783030303030313030202052303320307830303030303030300A52303420307838306133363031382020523035203078333030336435643720205230362030783030303030303030202052303720307830303030303030300A52303820307831393939393939392020523039203078303164383865366320205231302030783030303030306536202052313120307833303033643564370A52313220307830303030303030302020523133203078303164396163303820205231342030783330303030666234202052313520307830303030303030300A52313620307830303030303030302020523137203078303030303030303020205231382030783330303030666338202052313920307866666666666666660A52323020307833303034316132652020523231203078303030303030303020205232322030783330303138333963202052323320307830303030303030320A52323420307830303030303030322020523235203078303030303030303320205232362030783030303030303033202052323720307830303030303030340A52323820307833303031356634302020523239203078303030303030303220205233302030783330303030666430202052333120307830303030303030300A316132396530382037666666663266382031633438353938203163343831313820316334316331382031633663323834203163353565313820316337323933342031633761353230203163343136353020316331643465342031380A3C2F7072653E286A757374206B696464696E67297D0A20202038207B596F75277265207261746865722070726573756D7074756F7573206172656E277420796F753F2049206D6572656C7920737461727420746F20646973706C617920746865207061676520616E642049276D20696D6D6564696174656C7920686172726173656420627920796F75206265666F726520676976656E2074696D6520746F20646F20736F2E20506572686170732049207761732061637475616C6C7920676F696E6720746F206769766520796F7520746865207061676520746869732074696D652E2E2E20666172656C6C2C2068617665206120676F6F64206576656E696E67206F66206265696E6720756E667269656E646C797D0A20202039207B436F6E67726174756C6174696F6E73212074686174277320746865205B6E746820243430345F636F756E7465725D20343034207061676520796F75277665206869742073696E636520746865206C617374207265626F6F742E7D0A20203130207B4E6921204E6921204E6921204E6921205765207368616C6C20736179204E692120616761696E20696620796F7520646F206E6F7420617070656173652075737D0A20203131207B0A266C743B5C5B6D626D5C5D2667743B20686D6D2C2077687920646F65736E2774207469766F776562206861766520736F6D65206C616D65206173732065617374657220656767203F3C62723E0A266C743B6C696768746E2667743B20492074686F7567687420796F75722069646561206F6620696E73756C74696E6720343034206572726F72732077617320676F6F643C62723E0A266C743B5C5B6D626D5C5D2667743B2074686F7567687420796F75207475726E6564207468617420646F776E2C20736F6D657468696E672061626F75742063656E736F72736869703C62723E0A266C743B6C696768746E2667743B206875683F206E6F2C204920616C77617973206C696B65642069742C2049206A757374206469646E2774206C696B6520796F7572205C22636C69636B206865726520746F20637261736820796F7572207469766F5C220A20202020207D0A20203132207B537572656C7920796F75277665206E6F7420676976656E20757020796F757220717565737420666F722074686520486F6C7920477261696C3F7D0A20203133207B49276D206E6F74207175697465206465616420796574217D0A20203134207B52756E2061776179212052756E2061776179212052756E2061776179212052756E2061776179212052756E2061776179212052756E2061776179212052756E2061776179217D0A20203135207B4F204C6F72642C20626C657373207468697320546879207469766F7765622073657276657220746861742C20776974682069742C2054686F75206D617965737420626C6F77205468696E6520656E656D69657320746F2074696E79206269747320696E20546879206D657263797D0A20203136207B4E6F77206974206973207375636820612062697A617272656C7920696D70726F6261626C6520636F696E636964656E6365207468617420616E797468696E6720736F206D696E64626F6767696E676C792075736566756C206173207468697320343034207061676520636F756C6420686176652065766F6C76656420707572656C79206279206368616E6365207468617420736F6D65207468696E6B65727320686176652063686F73656E20746F20736565206974206173207468652066696E616C20616E6420636C696E6368696E672070726F6F66206F6620746865206E6F6E2D6578697374616E6365206F66207469766F7765622070726F6772616D6D6572732E0A20203C703E0A202054686520617267756D656E7420676F657320736F6D657468696E67206C696B6520746869733A2060492072656675736520746F2070726F766520746861742077652065786973742C272073616964206F6E65207469766F7765622070726F6772616D6D65722C2027666F722070726F6F662064656E6965732064656E6961626C69747920616E6420776974686F75742064656E6961626C697479207468657265276420626520627567207265706F7274732E270A20203C703E274275742C272073617973204D616E2C2027537572656C7920746865203430342070616765206973206120646561642067697665617761792069736E27742069743F20497420636F756C64206E6F7420686176652065766F6C766564206279206368616E63652E2049742070726F76657320796F752065786973742C20616E6420736F207468657265666F72652C20627920796F7572206F776E20617267756D656E74732C20796F7520646F6E27742E205145442E270A20203C703E274F6820646561722C27207361696420746865207469766F7765622070726F6772616D6D65722C202749206861646E27742074686F75676874206F6620746861742C2720616E6420746865207469766F7765622070726F6772616D6D6572732070726F6D70746C792076616E697368656420756E64657220666C6F6F64206F6620627567207265706F7274732E7D0A20207D0A7D0A736574203430345F636F756E74657220300A0A70726F63206E7468207B206E756D626572207D207B0A20202073776974636820246E756D626572207B0A202020202031207B72657475726E2022317374227D0A202020202032207B72657475726E2022326E64227D0A202020202033207B72657475726E2022337264227D0A202020202064656661756C74207B2072657475726E20247B6E756D6265727D74687D0A2020207D0A7D0A0A70726F63207072696E745F68746D6C5F6865616465725F343034207B206368616E207D207B0A20202020676C6F62616C203430345F636F756E7465720A202020207075747320246368616E2022485454502F312E3020343034204E6F7420466F756E64220A202020207075747320246368616E2022436F6E6E656374696F6E3A20636C6F7365220A202020207075747320246368616E2022436F6E74656E742D547970653A20746578742F68746D6C3B20636861727365743D69736F2D383835392D31220A20202020696E6372203430345F636F756E7465720A202020207075747320246368616E20220A3C21444F43545950452048544D4C205055424C4943205C222D2F2F5733432F2F4454442048544D4C20342E3031205472616E736974696F6E616C2F2F454E5C223E0A3C48544D4C3E3C484541443E0A3C5449544C453E343034204E6F7420466F756E643C2F5449544C453E0A3C2F484541443E3C424F44593E0A3C48313E4E6F7420466F756E643C2F48313E0A220A20207365742073697A65205B65787072205B61727261792073697A6520494E53554C54533A3A615D202B315D3B0A20207365742072616E64205B72616E646F6D2031202473697A655D3B0A20206576616C20227075747320246368616E205C2224494E53554C54533A3A61282472616E64295C22220A7075747320246368616E20223C2F424F44593E3C2F48544D4C3E220A7D0A
]


proc action_editseasonpass {chan objectid env} {
	global db
	global channeltablestation
	global channeltablenum
	global errorCode
	global errorInfo

	if {[string index $objectid 0] == "/"} {
		set objectid [string range $objectid 1 end]
	}

	set deleted 0
	RetryTransaction {
		set sp [db $db openid $objectid]
		set indexpath [dbobj $sp get IndexPath]
		if { [regexp {/Rubbish/} $indexpath dummy] == 1 } {
			set deleted 1
		}
		set priority [dbobj $sp get Priority]
		incr priority
		set type [defaultval 1 [dbobj $sp get Type]]
		if { $type == 1 } {
			set series [dbobj $sp get Series]
			set title [strim [dbobj $series get Title]]
			if {$::version3} {
				set firstrun [defaultval 0 [dbobj $sp get ShowStatus]]
			} else {
				set firstrun [defaultval 0 [dbobj $sp get FirstRun]]
			}
		} elseif { $type == 2 } {
			set dow [dbobj $sp get DayOfWeekLocal]
			if { $dow == "0 1 2 3 4 5 6" } {
				set dow 7
			} elseif { $dow == "1 2 3 4 5" } {
				set dow 8
			}
			set duration [dbobj $sp get Duration]
			set starttimelocal [dbobj $sp get StartTimeLocal]
            set firstrun ""
		} elseif { $type == 3 } {
			set theme [dbobj $sp get Theme]
			set title [strim [dbobj $theme get Name]]
			if {$::version3} {
			   set firstrun [defaultval 0 [dbobj $sp get ShowStatus]]
			} else {
			   set firstrun [defaultval 0 [dbobj $sp get FirstRun]]
			}
		}
		set starttime [defaultval 0 [dbobj $sp get StartTimePadding]]
		set endtime [defaultval 0 [dbobj $sp get EndTimePadding]]

		if { $type != 3 } {
			set station [dbobj $sp get Station]
			set stationfsid [dbobj $station fsid]
			if { [catch {set data $channeltablestation($stationfsid)}] != 1 } {
				set channum [lindex $data 0]
				set callsign [lindex $data 2]
			}
		}
		
		set recquality [defaultval 100 [dbobj $sp get RecordQuality]]
		set keepatmost [defaultval 0 [dbobj $sp get MaxRecordings]]
		set keepuntil [defaultval 1 [dbobj $sp get KeepTime]]

	}

	puts $chan [html_start "Edit Season Pass"]

	if {$deleted} {
		puts $chan [h2 "Error: This season pass has been deleted"]
		puts $chan [html_end]
		return
	}

	set dowvals "Sun Mon Tue Wed Thu Fri Sat {Daily} {M-F}"
	if { $type == 1 } {
		puts $chan [h1 "$title ($channum $callsign)"]
	} elseif { $type == 2 } {
		puts $chan [h1 "[lindex $dowvals $dow] [clock format $starttimelocal -format "%1I:%M %p"] - [clock format [expr $starttimelocal + $duration] -format "%1I:%M %p"] ($channum $callsign)"]
	} elseif { $type == 3 } {
		puts $chan [h1 $title]
	}
	puts $chan [html_form_start "POST" "/saveseasonpass"]
	puts $chan [html_table_start "" "" ""]
	# puts $chan [tr "" [td "Priority"] [td $priority]]
	print_recoptions $chan $type $recquality 0 $starttime $endtime $keepatmost $firstrun $keepuntil
	puts -nonewline $chan [html_table_end]
	puts $chan "<P>"
	puts $chan [html_form_hidden "objectid" $objectid]
	puts $chan [html_form_input "submit" "action" "Save"]
	puts $chan [html_form_input "submit" "action" "Delete"]
	puts $chan [html_form_end]
	puts $chan "<P>"
	puts $chan "<A HREF=\"#\" onClick=\"history.go(-1)\">Don't Change</A>"
	puts $chan [html_end]

}

proc action_getseasonpass {chan objectid env} {
	global db
	global channeltablestation
	global channeltablenum
	global defrecquality

	if {[string index $objectid 0] == "/"} {
		set objectid [string range $objectid 1 end]
	}

	RetryTransaction {
		if { [regexp {([0-9]*)/(.*)} $objectid junk fsid subobjid] } {
			set showing [db $db openidconstruction $fsid $subobjid]
		} else {
			set showing [db $db openid $objectid]
		}
		set program [dbobj $showing get Program]
		set series [dbobj $program get Series]
		set seriesfsid [dbobj $series fsid]
		set title [strim [dbobj $series get Title]]
		set station [dbobj $showing get Station]
		set stationfsid [dbobj $station fsid]
		set channum ""
		if { [catch {set data $channeltablestation($stationfsid)}] != 1 } {
			set channum [lindex $data 0]
			set callsign [lindex $data 2]
		}
	}

	if { $channum == "" } {
	   puts $chan [html_start "Create Season Pass"]
	   puts $chan "Error: Could not find station"
	   puts $chan [html_end]
	   return
	}

	set type 1

	puts $chan [html_start "Create Season Pass"]
	puts $chan [h1 "$title ($channum $callsign)"]
	puts $chan [html_form_start "POST" "/saveseasonpass"]
	puts $chan [html_table_start "" "" ""]
	# puts $chan [tr "" [td "Priority"] [td $priority]]
	print_recoptions $chan $type $defrecquality 0 0 0 5 0 1
	puts -nonewline $chan [html_table_end]
	puts $chan "<P>"
	puts $chan [html_form_hidden "objectid" $objectid]
	puts $chan [html_form_hidden "type" $type]
	puts $chan [html_form_hidden "seriesfsid" $seriesfsid]
	puts $chan [html_form_hidden "stationfsid" $stationfsid]
	puts $chan [html_form_input "submit" "action" "Create"]
	puts $chan [html_form_end]
	puts $chan "<P>"
	puts $chan "<A HREF=\"#\" onClick=\"history.go(-1)\">Cancel</A>"
	puts $chan [html_end]

}

proc get_nextmanualrectime {dowlocal starttime} {
	global tzoffset

	set nowsecs [clock seconds]
	if { $starttime > 86400 } {
	   set dow [expr $dowlocal + 1]
	} elseif { $starttime < 0 } {
	   set dow [expr $dowlocal - 1]
	} else {
	   set dow $dowlocal
	}
	set nowtime [expr ($nowsecs / 86400) * 86400 + $starttime]
	set downow [clock format $nowtime -format "%w"]
	if { $downow > $dow } {
	   set rectime [expr $nowtime + ($dow - $downow + 7) * 86400]
	} elseif { $dow > $downow } {
	   set rectime [expr $nowtime + ($dow - $downow) * 86400]
	} else {
	   if { $starttime > [expr $nowsecs % 86400] } {
		  set rectime $nowtime
	   } else {
		  set rectime [expr $nowtime + (86400 * 7)]
	   }
	}
	return $rectime
}

proc action_seasonpass {chan path env} {
	global db
	global images
	global tzoffset
	global seasonpassdir

	puts $chan [html_start "Season Passes"]
	puts $chan [html_table_start "" "" ""]
	puts $chan [tr "ALIGN=CENTER" [th ""] [th "Pri"] [th "Title"] [th "Channel"] [th "KAM"] [th "Show Type"]]
	set priority 0
	ForeachMfsFileTrans fsid name type $seasonpassdir "" 20 {
		set sp [db $db openid $fsid]
		set type [defaultval 1 [dbobj $sp get Type]]
		incr priority
		set rowstr ""
		if { $type == 1 } {
		   set series [dbobj $sp get Series]
		   set imagef [lindex $images 11]
		   set spfsid [dbobj $sp fsid]
		   append rowstr [td [html_link "/editseasonpass/$spfsid" [img "alt=\"edit\"" $imagef]]] [td $priority]
		   set seriesfsid [dbobj $series fsid]
		   set title [strim [dbobj $series get Title]]
		   append rowstr [td [html_link "/series/$seriesfsid" $title]]
		   set station [dbobj $sp get Station]
		   set stationfsid [dbobj $station fsid]
		   set callsign [dbobj $station get CallSign]
		   append rowstr [td [html_link "/channel/$stationfsid" $callsign]]
		} elseif { $type == 2 } {
		   set station [dbobj $sp get Station]
		   set stationfsid [dbobj $station fsid]
		   set starttimelocal [dbobj $sp get StartTimeLocal]
		   set starttime [expr $starttimelocal - $tzoffset]
		   set dowlocal [dbobj $sp get DayOfWeekLocal]
		   if { [llength $dowlocal] > 1 } {
			  set rectime ""
			  foreach dowl $dowlocal {
				 set tmprectime [get_nextmanualrectime $dowl $starttime]
				 if { $rectime == "" || $tmprectime < $rectime } {
					set rectime $tmprectime
				 }
			  }
		   } else {
			  set rectime [get_nextmanualrectime $dowlocal $starttime]
		   }
		   set datestr [expr $rectime / 86400]
		   set schedlist [get_fsidbyprefix "/Schedule" "$stationfsid:$datestr:"]
		   if { [scan [lindex $schedlist 1] "%d:%d:%d:%d:" dummy dummy2 starttimesched duration] == 4 } {
			   if {$starttimesched > $starttime} {
	   			   set datestr [expr ($rectime / 86400) - 1]
				   set schedlist [get_fsidbyprefix "/Schedule" "$stationfsid:$datestr:"]
		           if { [scan [lindex $schedlist 1] "%d:%d:%d:%d:" dummy dummy2 starttimesched duration] != 4 } {
		               error "Invalid /Schedule format: '[lindex $schedlist 1]'"
		           }
		       }
		       if { $::dtivo } {
				   if {$starttimesched + $duration <= $starttime} {
					   set stoptimestr [format "%05d" [expr $starttimesched + $duration]]
					   set schedlist [get_fsidbyprefix "/Schedule" "$stationfsid:$datestr:$stoptimestr:"]
				   }
			   }
		   } else {
		      error "Invalid /Schedule format: '[lindex $schedlist 1]'"
		   }
		   set callsign [dbobj $station get CallSign]
		   set imagef [lindex $images 11]
		   set spfsid [dbobj $sp fsid]
		   append rowstr [td [html_link "/editseasonpass/$spfsid" [img "alt=\"edit\"" $imagef]]] [td $priority]
		   if { $schedlist != "" } {
			  set stationday [db $db openid [lindex $schedlist 0]]
			  set showings [dbobj $stationday get Showing]
			  set mshowing ""
			  foreach showing $showings {
				 set stime [dbobj $showing get Time]
				 set sdur [dbobj $showing get Duration]
				 if { $stime <= $starttime && $starttime < [expr $stime + $sdur] } {
					set mshowing $showing
					break
				 }
			  }
			  if { $mshowing != "" } {
				 set program [dbobj $mshowing get Program]
				 set series [dbobj $program get Series]
				 set seriesfsid [dbobj $series fsid]
				 set title [strim [dbobj $series get Title]]
				 set title [html_link "/series/$seriesfsid" $title]
				 append rowstr [td "Manual: $title"]
			  } else {
				 append rowstr [td "Manual Recording"]
				 # puts "Error finding manual recording"
			  }
		   } else {
			  append rowstr [td "Manual Recording"]
			  # puts "Error finding manual recording"
		   }
		   append rowstr [td [html_link "/channel/$stationfsid" $callsign]]
		} elseif { $type == 3 } {
		   set theme [dbobj $sp get Theme]
		   set imagef [lindex $images 13]
		   set spfsid [dbobj $sp fsid]
		   append rowstr [td [html_link "/editseasonpass/$spfsid" [img "alt=\"edit\"" $imagef]]] [td $priority]
		   set themefsid [dbobj $theme fsid]
		   set title [strim [dbobj $theme get Name]]
		   # append rowstr [td [html_link "/theme/$themefsid" $title]] [td ""]
		   append rowstr [td $title] [td ""]
		}
		set kam [defaultval 0 [dbobj $sp get MaxRecordings]]
		if {$kam == 0} {
		   set kam "All"
		}
		if {$::version3} {
		   set showstatus [dbobj $sp get ShowStatus]
		   if {$showstatus == 1} {
		      set showtype "First Run"
		   } elseif {$showstatus == 2} {
		      set showtype "All"
		   } else {
		      set showtype "Repeats & FR"
		   }
		} else {
		   set firstrun [dbobj $sp get FirstRun]
		   if {$firstrun == 1} {
		      set showtype "First Run"
		   } else {
		      set showtype "Repeats & FR"
		   }
		}
		append rowstr [td $kam] [td $showtype]
		puts $chan [tr "" $rowstr]
	}
	puts $chan [html_table_end]
	puts $chan "<font size=2>To edit a season pass click the icon next to its name</font>"
	puts $chan [html_end]
}

proc action_wishlists {chan path env} {
	global db
	global images

	if {[string index $path 0] == "/"} {
	   set path [string range $path 1 end]
	}

	if { $path == "" } {
	   set themetypes "Keyword Actor Director Advanced Category Title"
	   set imagef [lindex $images 13]

	   puts $chan [html_start "WishLists"]
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "ALIGN=CENTER" [th ""] [th "Title"] [th "Type"]]
	   ForeachMfsFileTrans fsid name type "/Theme" "" 20 {
		  set theme [db $db openid $fsid]
		  set title [strim [dbobj $theme get Name]]
		  set sp [dbobj $theme get SeasonPass]
		  set type [defaultval 1 [dbobj $theme get ThemeType]]
		  set imagestr ""
		  if { $sp != "" } {
			 set spfsid [dbobj $sp fsid]
			 set imagestr [html_link "/editseasonpass/$spfsid" [img "alt=\"edit\"" $imagef]]
		  }
		  set themestr [lindex $themetypes [expr $type - 1]]
		  puts $chan [tr "" [td $imagestr] [td $title] [td $themestr]]
	   }
	   puts $chan [html_table_end]
	   puts $chan "<font size=2>To edit a wishlist click on the icon next to its name</font>"

	   puts $chan [html_end]
	}
}

proc action_preferences {chan path env} {
	global db
	global genrenums
	global genrevals

	if {[string index $path 0] == "/"} {
	   set path [string range $path 1 end]
	}
	set firstslash [string first "/" $path]
	set prefix ""
	if { $firstslash != -1 } {
	   set preftype [string range $path 0 [expr $firstslash - 1]]
	   set prefix [string range $path [expr $firstslash + 1] end]
	} else {
	   set preftype $path
	}

	puts $chan [html_start "Preferences"]

	if { $preftype == "" } {
	   puts $chan [html_table_start "" "" "ALIGN=TOP"]
	   puts $chan [tr "" [th "" "Preferences"]]
	   puts $chan [tr "" [td [html_link "/preferences/14" "Genre"]]]
	   puts $chan [tr "" [td [html_link "/preferences/15" "Series"]]]
	   puts $chan [tr "" [td [html_link "/preferences/17" "Actor"]]]
	   puts $chan [tr "" [td [html_link "/preferences/19" "Director"]]]
	   puts $chan [tr "" [td [html_link "/preferences/22" "Writer"]]]
	   puts -nonewline $chan [html_table_end]
	} elseif { $preftype == 14 } {
	   # redo sort?
	   set newgenrelist ""
	   foreach genrenum $genrenums genreval $genrevals {
		  lappend newgenrelist [list $genrenum $genreval]
	   }
	   set newgenrelist2 [lsort -index 1 $newgenrelist]
	   puts $chan [h1 "Genres"]
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "ALIGN=CENTER" [th "Genre"] [th "Thumbs"] [th "Type"] [th "Confidence"]]
	   RetryTransaction {
		  foreach genrel $newgenrelist2 {
			 set genrenum [lindex $genrel 0]
			 set genrestr [strim [lindex $genrel 1]]
			 set path "/Preference/a/$preftype/$genrenum"
			 if { [catch {set pref [db $db open $path]}] } {
				continue
			 }
			 set thumbs [dbobj $pref get Thumbsness]
			 set vector [dbobj $pref get Vector]
			 set thtype ""
			 set numthumbs ""
			 set confidence ""
			 if { $thumbs != "" } {
				set thumbslist [ReadableThumbs $thumbs]
				if { [llength $thumbslist] == 3 } {
				   set thtype [lindex $thumbslist 0]
				   if { $thtype == "Void" } {
					  set thtype ""
				   } else {
					  set numthumbs [lindex $thumbslist 1]
					  set confidence [lindex $thumbslist 2]
				   }
				}
			 }
			 if { $numthumbs == "" } {
				set numthumbs [decode_vector $vector]
				set thtype "Implied"
			 }
			 puts $chan [tr "" [td $genrestr] [td $numthumbs] [td $thtype] [td $confidence]]
		  }
	   }
	   puts -nonewline $chan [html_table_end]
	} elseif { $preftype == 15 } {
	   set programlist ""
	   ForeachMfsFileTrans fsid name type "/Preference/a/$preftype" "" 25 {
		  set orphan 0
		  set pref [db $db openid $fsid]
		  set item [dbobj $pref get Item]
		  set thumbs [dbobj $pref get Thumbsness]
		  set vector [dbobj $pref get Vector]
		  set seriesfsid ""
		  if { $item != "" } {
			 set title [strim [dbobj $item get Title]]
			 set seriesfsid [dbobj $item fsid]
		  } else {
			 set title [strim [dbobj $pref get StringKeyValue]]
			 if { [regexp {^[0-9]+$} $title dummy] == 1 } {
				if { [catch {set series [db $db open "/Server/$title"]}] } {
				   set orphan 1
				} else {
				   set title [strim [dbobj $series get Title]]
				   set seriesfsid [dbobj $series fsid]
				}
			 } else {
				regsub {^(.*), (A|The)$} $title {\2 \1} title
			 }
		  }
		  if { $seriesfsid != "" } {
			 set program [html_link "/series/$seriesfsid" $title]
		  } else {
			 set program $title
		  }
		  regsub {^(A |The )} $title "" sortstr
		  set thtype ""
		  set numthumbs ""
		  set confidence ""
		  if { $thumbs != "" } {
			 set thumbslist [ReadableThumbs $thumbs]
			 if { [llength $thumbslist] == 3 } {
				set thtype [lindex $thumbslist 0]
				if { $thtype == "Void" } {
				   set thtype ""
				} else {
				   set numthumbs [lindex $thumbslist 1]
				   set confidence [lindex $thumbslist 2]
				}
			 }
		  }
		  if { $numthumbs == "" } {
			 set numthumbs [decode_vector $vector]
			 set thtype "Implied"
		  }
		  if {!$orphan} {
			 lappend programlist [list $sortstr $program $numthumbs $thtype $confidence]
		  }
	   }
	   set programlist2 [lsort -index 0 $programlist]
	   puts $chan [h1 "Series"]
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "ALIGN=CENTER" [th "Series"] [th "Thumbs"] [th "Type"] [th "Confidence"]]
	   foreach programl $programlist2 {
		  puts $chan [tr "" [td [lindex $programl 1]] [td [lindex $programl 2]] [td [lindex $programl 3]] [td [lindex $programl 4]]]
	   }
	   puts -nonewline $chan [html_table_end]
	} elseif { $preftype == 16 } {
	   puts $chan [h1 "Programs"]
	   puts $chan [html_table_start "" "" ""]
	   puts $chan [tr "ALIGN=CENTER" [th "Program"] [th "Thumbs"] [th "Type"] [th "Confidence"]]
	   ForeachMfsFileTrans fsid name type "/Preference/a/$preftype" "" 25 {
		  set pref [db $db openid $fsid]
		  set item [dbobj $pref get Item]
		  set thumbs [dbobj $pref get Thumbsness]
		  set vector [dbobj $pref get Vector]
		  set seriesfsid ""
		  if { $item == "" } {
			 set intkey [dbobj $pref get IntKeyValue]
			 if { [catch {set item [db $db open "/Server/$intkey"]}] } {
				# continue
			 }
		  }
		  if { $item != "" } {
			 set title [strim [dbobj $item get Title]]
			 set series [dbobj $item get Series]
			 if { $series != "" } {
				set seriesfsid [dbobj $series fsid]
			 }
		  }
		  if { $title == "" } {
			 set title [strim [dbobj $pref get StringKeyValue]]
		  }
		  if { $seriesfsid != "" } {
			 set program [html_link "/series/$seriesfsid" $title]
		  } else {
			 set program $title
		  }
		  set thtype ""
		  set numthumbs ""
		  set confidence ""
		  if { $thumbs != "" } {
			 set thumbslist [ReadableThumbs $thumbs]
			 if { [llength $thumbslist] == 3 } {
				set thtype [lindex $thumbslist 0]
				if { $thtype == "Void" } {
				   set thtype ""
				} else {
				   set numthumbs [lindex $thumbslist 1]
				   set confidence [lindex $thumbslist 2]
				}
			 }
		  }
		  if { $numthumbs == "" } {
			 set numthumbs [decode_vector $vector]
			 set thtype "Implied"
		  }
		  puts $chan [tr "" [td $program] [td $numthumbs] [td $thtype] [td $confidence]]
	   }
	   puts -nonewline $chan [html_table_end]
	} elseif { $preftype == 17 || $preftype == 19 || $preftype == 22 } {
	   if { $preftype == 17 } {
		  set preftypestr "Actor"
		  set role 8
	   } elseif { $preftype == 19 } {
		  set preftypestr "Director"
		  set role 9
	   } else {
		  set preftypestr "Writer"
		  set role 12
	   }
	   set preftypestr2 $preftypestr
	   append preftypestr2 "s"
	   set breakbyletter 0
	   if { [catch { RetryTransaction { set dirsize [mfs scancount "/Preference/a/$preftype"]}}] } {
	   } else {
		  if { $dirsize > 120 } {
			 set breakbyletter 1
		  }
	   }
	   set alphabet "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
	   if { $prefix == "" && $breakbyletter == 1 } {
		  puts $chan [h1 $preftypestr2]
		  puts $chan [html_table_start "" "" ""]
		  puts $chan [tr "ALIGN=CENTER" [th $preftypestr]]
		  for {set i 0} {$i < 26} {incr i} {
			 set letter [string index $alphabet $i]
			 puts $chan [tr "" [td [html_link "/preferences/$preftype/$letter" $letter]]]
		  }
		  puts -nonewline $chan [html_table_end]
	   } else {
		  puts $chan [h1 $preftypestr2]
		  puts $chan [html_table_start "" "" ""]
		  puts $chan [tr "ALIGN=CENTER" [th $preftypestr] [th "Thumbs"] [th "Type"] [th "Confidence"]]
		  ForeachMfsFileTrans fsid name type "/Preference/a/$preftype" $prefix 25 {
			 set orphan 0
			 set pref [db $db openid $fsid]
			 set thumbs [dbobj $pref get Thumbsness]
			 set vector [dbobj $pref get Vector]
			 set person ""
			 if { [catch {set person [db $db open "/Person/$role/$name"]}] } {
				set orphan 1
			 }
			 set namestr ""
			 if { $person != "" } {
				#set pname [strim [dbobj $person get Name]]
				# regsub {^(.*)\|(.*)$} $pname {\1, \2} namestr
				set pname [dbobj $person get Name]
				if { $preftype == 17} {
				   set namestr [PrintNames $pname 1]
				} elseif { $preftype == 19 } {
				   set namestr [PrintNames $pname 2]
				} else {
				   set namestr [PrintNames $pname]
				}
			 }
			 set thtype ""
			 set numthumbs ""
			 set confidence ""
			 if { $thumbs != "" } {
				set thumbslist [ReadableThumbs $thumbs]
				if { [llength $thumbslist] == 3 } {
				   set thtype [lindex $thumbslist 0]
				   if { $thtype == "Void" } {
					  set thtype ""
				   } else {
					  set numthumbs [lindex $thumbslist 1]
					  set confidence [lindex $thumbslist 2]
				   }
				}
			 }
			 if { $numthumbs == "" } {
				set numthumbs [decode_vector $vector]
				set thtype "Implied"
			 }
			 if {!$orphan} {
				puts $chan [tr "" [td $namestr] [td $numthumbs] [td $thtype] [td $confidence]]
			 }
		  }
		  puts -nonewline $chan [html_table_end]
		  if { $breakbyletter == 1 } {
			 if { $prefix != "A" } {
				set index [string first $prefix $alphabet]
				set prevletter [string index $alphabet [expr $index - 1]]
				puts $chan [html_link "/preferences/$preftype/$prevletter" "<< $prevletter"]
			 }
			 if { $prefix != "Z" } {
				set index [string first $prefix $alphabet]
				set nextletter [string index $alphabet [expr $index + 1]]
				puts $chan [html_link "/preferences/$preftype/$nextletter" "$nextletter >>"]
			 }
		  }
	   }
	}

	puts $chan [html_end]
}

proc action_ui {chan path env} {
	global db
	global tzoffset
	global ui_submenu

	if {[string index $path 0] == "/"} {
		set path [string range $path 1 end]
	}

	if {$path == ""} {
		puts $chan [html_start "User Interface" $ui_submenu]
		puts $chan [html_table_start "" "" "ALIGN=TOP"]
		puts $chan [tr "" [th "" "User Interface"]]
		puts $chan [tr "" [td [html_link "/ui/seasonpass" "Season Pass"]]]
		puts $chan [tr "" [td [html_link "/nowshowing" "Now Showing"]]]
		puts $chan [tr "" [td [html_link "/ui/todo" "ToDo"]]]
		puts $chan [tr "" [td [html_link "/ui/suggestions" "Scheduled Suggestions"]]]
		puts $chan [tr "" [td [html_link "/ui/pending" "Suggestions"]]]
		puts $chan [tr "" [td [html_link "/ui/deletedshows" "Deleted Shows"]]]
		puts $chan [tr "" [td [html_link "/ui/preferences" "Preferences"]]]
		puts $chan [tr "" [td [html_link "/ui/channellist" "Channel Guide"]]]
		#puts $chan [tr "" [td [html_link "/ui/space" "Space Usage"]]]
		puts $chan [tr "" [td [html_link "/ui/wishlists" "WishLists"]]]
		puts -nonewline $chan [html_table_end]
		puts $chan [html_end]
	} elseif {$path == "todo"} {
		action_todo $chan 0 $env
	} elseif {$path == "suggestions"} {
		action_todo $chan 1 $env
	} elseif {$path == "pending"} {
		action_todo $chan 2 $env
	} elseif {$path == "nowshowing"} {
		action_nowshowing $chan "" $env
	} elseif {$path == "seasonpass"} {
		action_seasonpass $chan "" $env
	} elseif {$path == "channellist"} {
		action_channellist $chan "" $env
	} elseif {$path == "preferences"} {
		action_preferences $chan "" $env
	#} elseif {$path == "space"} {
	#	action_space $chan "" $env
	} elseif {$path == "deletedshows"} {
		action_deletedshows $chan "" $env
	} elseif {$path == "wishlists"} {
		action_wishlists $chan "" $env
	}

}

proc GetDTivoGenres { } {
   global db

   set keys ""
   RetryTransaction {
      set apgboot [db $db open /ApgBoot]
      set categorysystem [dbobj $apgboot get RootCategorySystem]
      set labels [dbobj $categorysystem get Labels]
      foreach clabel $labels {
         set index [dbobj $clabel get Index]
         #set fcoreset [dbobj $clabel get FCoreSet]
         if {$index != 0 && [lsearch $keys $index] == -1} {
            set vlabel [strim [dbobj $clabel get Label]]
            lappend keys $index
            lappend vals $vlabel
         }
         set subcat [dbobj $clabel get Subcategory]
         if {$subcat != ""} {
            set labels2 [dbobj $subcat get Labels]
            foreach clabel2 $labels2 {
               set index [dbobj $clabel2 get Index]
               #set fcoreset [dbobj $clabel2 get FCoreSet]
               if {$index != 0 && [lsearch $keys $index] == -1} {
                  set vlabel [strim [dbobj $clabel2 get Label]]
                  lappend keys $index
                  lappend vals $vlabel
               }
            }
         }
      }
   }

   return [list $keys $vals]

}

proc GetResourceData { refid startid endid startindex bits } {
   global db

   set keys ""
   set vals ""
   RetryTransaction {
	  set sws [db $db open /SwSystem/ACTIVE]
	  set offset [expr $refid/65536 - 1]
	  set resource [dbobj $sws get ResourceGroup $offset]
	  set id [dbobj $resource get Id]
	  if { $id == $refid } {
		 set items [dbobj $resource get Item]
		 foreach item $items {
			set id [dbobj $item get Id]
			if { $id >= $startid && $id <= $endid } {
			   if { $bits == 1 } {
				  set value [expr 1 << ($id - $startid + $startindex)]
			   } else {
				  set value [expr $id - $startid + $startindex]
			   }
			   set strval [strim [dbobj $item get String]]
			   if { $strval != "" } {
				  lappend keys $value
				  lappend vals $strval
			   }
			}
		 }
	  } else {
		 error "Error: refid didn't match"
	  }
   }
   return [list $keys $vals]
}

proc init_db {} {
   global db

   global genrenums
   global genrevals
   global tvratingnums
   global tvratingvals
   global showingbitnums
   global showingbitvals
   global advisorynums
   global advisoryvals
   global mpaaratingnums
   global mpaaratingvals

   global defrecquality
   global tivoswversion

   global cancelreasons
   global selectiontypes
   global presentationbehtypes
   global states
   global showtypes
   global premieretypes

   global images

   if {$::version3} {
	  RetryTransaction {
		 set avconfig [db $db open /State/AvConfig]
		 set defrecquality [defaultval 100 [dbobj $avconfig get RecordQuality]]
	  }
   } else {
	  RetryTransaction {
		 set setup [db $db open /Setup]
		 set defrecquality [defaultval 100 [dbobj $setup get RecordQuality]]
	  }
   }

   set cancelreasons "SwitchToLiveTv RecordDifferentShowing StayOnLiveTv InternalError PowerWasOff Expired GotBetterSuggestion DemoMode UnexpectedConflict UserRequestedRecording UserRequestedSeasonPass ExplicitlyDeleted ChannelLineupChanged ProgramGuideChanged RecorderEmergency UserCancelledSeasonPass FuzziesTurnedOff FuzzyStoppedEarly Unknown ProgramSourceConflict ConvertedLiveCache LiveCacheOnlySuccessful ProgramSourceDiskConflict ExplicitlyDeletedFromToDo ProgramSourceModified NotAuthorized NoReRecord NoSignal MaxRecordingsExceeded CaptureRequestExpired NoSignalTunerOne NoSignalTunerTwo MaxRecordingsNowShowing VideoMgrDeniedTuner"
   set selectiontypes "{Show Recommendation} {Package Recommendation} {By Name} {By Channel} Manual {Suggestion} {Fuzzy Package} Bookmark {Season Pass} {Manual Season Pass} Guide IPreview WishListPass Extended ManualExtended CaptureRequest"
   set presentationbehtypes "Single {Season Pass} Wishlist {Watch Only} {Tivo Clips} Suggestion {Tivo Clips Suggestion} Invisible {Manual Season Pass} Manual {Cache History}"

   set states "{To Do} Cancelled {In Progress} {Now Showing} Deleted {To Do} Allocated"
   set showtypes "Serial {Short Film} Special {Limited Series} Series Miniseries {Paid Programming}"
   set premieretypes "{Season Finale} {Series Finale} Premiere {Season Premiere} {Series Premiere}"

   if { [PrefixMatches "3.0" $tivoswversion] } {
	  set images "ExpireNever-256.8.png SelectIcon-256.12.png"
   } elseif { [PrefixMatches "2.5.5" $tivoswversion] } {
	  set images "ExpireNever-256.8.png SelectIcon-256.10.png"
   } else {
	  set images "ExpireNever-256.8.png SelectIcon-256.9.png"
   }
   append images " ThumbUp2-256.8.png ExpireSoon-256.8.png ThumbDn1-256.8.png Expired-256.8.png ThumbDn2-256.8.png ThumbUp3-256.9.png Recording-256.9.png ThumbDn3-256.8.png TivoSuggest-256.8.png SeasonPass.9.png ThumbUp1-256.8.png WishListPass.2.png LargeSquarePredicted3DownThumbs.3.png LargeSquarePredicted2DownThumbs.3.png LargeSquarePredicted1DownThumbs.3.png LargeSquarePredicted1UpThumbs.3.png LargeSquarePredicted2UpThumbs.3.png LargeSquarePredicted3UpThumbs.3.png recycle1.png"

   if { [PrefixMatches "3.0" $tivoswversion] } {
	  set genres [GetResourceData 655360 655377 655495 1 0]
   } elseif { [PrefixMatches "2.5.2" $tivoswversion] } {
	  set genres [GetDTivoGenres]
   } elseif { [PrefixMatches "2.5" $tivoswversion] } {
	  set genres [GetResourceData 655360 655377 655495 1 0]
   } elseif { [PrefixMatches "2.0" $tivoswversion] } {
	  set genres [GetResourceData 720896 720913 721031 1 0]
   } else {
	  set genres ""
	  error "Error loading genres: Unknown software version '$tivoswversion'"
   }
   set genrenums [lindex $genres 0]
   set genrevals [lindex $genres 1]

   #if { [PrefixMatches "2.5.1" $tivoswversion] } {
   #   set tvratings [GetResourceData 851968 851993 851998 1 0]
   #} elseif { [PrefixMatches "2.0.1" $tivoswversion] } {
   #   set tvratings [GetResourceData 983040 983065 983070 1 0]
   #}
   #set tvratingnums [lindex $tvratings 0]
   #set tvratingvals [lindex $tvratings 1]
   set tvratingnums "1 2 3 4 5 6"
   set tvratingvals "TV-Y7 TV-Y TV-G TV-PG TV-14 TV-MA"

   #if { [PrefixMatches "2.5.1" $tivoswversion] } {
   #   set showingbits [GetResourceData 1441792 1441843 1441863 0 1]
   #} elseif { [PrefixMatches "2.0.1" $tivoswversion] } {
   #   set showingbits [GetResourceData 1572864 1572915 1572935 0 1]
   #}
   #set showingbitnums [lindex $showingbits 0]
   #set showingbitvals [lindex $showingbits 1]
   set showingbitnums "1 2 4 8 16 32 64 128 256 512 1024 65536 131072 262144 524288 1048576"
   set showingbitvals "CC Stereo Sub {In Prog} Class SAP Blackout Intercast {Three D} R Letterbox S V L D FV"

   #if { [PrefixMatches "2.5.1" $tivoswversion] } {
   #   set advisorys [GetResourceData 917504 917533 917542 1 0]
   #} elseif { [PrefixMatches "2.0.1" $tivoswversion] } {
   #   set advisorys [GetResourceData 1048576 1048605 1048614 1 0]
   #}
   #set advisorynums [lindex $advisorys 0]
   #set advisoryvals [lindex $advisorys 1]
   set advisorynums "1 2 3 4 5 6 7 8 9 10"
   set advisoryvals "AL GL N BN GV V MV SC RP AC"

   #set mpaaratings [GetResourceData 65536 65567 65578 1 0]
   #set mpaaratingnums [lindex $mpaaratings 0]
   #set mpaaratingvals [lindex $mpaaratings 1]
   set mpaaratingnums "1 2 3 4 5 6 7 8 9 10 11 12"
   set mpaaratingvals "G PG PG-13 R X NC-17 AO {Rated NR} U 12 15 18"

}

global ui_submenu
set ui_submenu ""
#set ui_submenu "[html_link "/ui/seasonpass" "Season Pass"] [html_link "/ui/nowshowing" "Now Showing"] [html_link "/ui/todo" "ToDo"] [html_link "/ui/suggestions" "Scheduled Suggestions"] [html_link "/ui/pending" "Suggestions"] [html_link "/ui/preferences" "Preferences"] [html_link "/ui/channellist" "Channel Guide"] [html_link "/ui/wishlists" "WishLists"]"

if { $reload == 0 } {
   init_db
}

register_module "ui" "User Interface" "A Web-based Clone of the TiVo UI"