use Time::Local;
################################################
## Return The Current Tournaments 
################################################
sub get_current_tournaments{
	my $league_id = shift;
	my %return_hash;

    $dbh = get_dbh(); 
    # prepare and execute query
    $query = "SELECT `Key`,`Tournament_Name` FROM `Tournament_Info` WHERE `League_ID` = $league_id AND `Active` = 1 ";

    $sth = $dbh->prepare($query);
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$Key, \$Tournament_Name);
    ################################################
    ## Loop through Tournaments Items 
    ################################################
    while($sth->fetch()) {
        $return_hash{$Key} = $Tournament_Name;

    } 
    # Finish Query
    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    
	return %return_hash;
}


sub print_calendar_update_tournament_only_event_form{
	my $event_id              = shift;
	my $tournament_id         = shift;
	my %event_info            = get_event_info($event_id);
	my $update_notes          = $event_info{"Notes"};
	my %tournament_event_info = get_tournament_event_info($tournament_id);
  my $alt_top               = $tournament_event_info{"ALT_TOP_BRACKET"};
	my $alt_bottom            = $tournament_event_info{"ALT_BOTTOM_BRACKET"};

	$update_notes    =~ s/<br>/\n/g;
    @hours = (1,2,3,4,5,6,7,8,9,10,11,12);
    @min   = ("00","15","30","45");
    @ampm  = ("AM", "PM");
    ($current_sdate, $current_stime) = split(/\s+/, $event_info{"Start_Date"});
    ($current_shour, $current_smin, $current_sampm) = convert_time_to_display($current_stime);
    ($current_edate, $current_etime) = split(/\s+/, $event_info{"End_Date"});
    ($current_ehour, $current_emin, $current_eampm) = convert_time_to_display($current_etime);
    $current_sdate = convert_date_to_display($current_sdate);
    
    %event_types  = get_event_types();
    %locations    = get_locations($event_info{"Org_ID"});
    %teams        = get_league_teams($event_info{"League_ID"});

    $locations{"Other"} = 0;

print <<__HTML__;

    <style>
        .image_link a{
                 text-decoration : none;
        }
    </style>

    <script>

        function validate_form(){
          var eventType    = document.getElementById('event_type');
          var eventName    = document.getElementById('event_name');
          var homeTeam     = document.getElementById('home_team');
          var visitingTeam = document.getElementById('visiting_team');
          var dateEle      = document.getElementById('date');
          var location     = document.getElementById('location');
          var other        = document.getElementById('other');
  
          if(eventType.value == 1){ //1 = League Event
              if(eventName.value == ""){
                  alert("You must enter a value for Event Name when entering a League Event"); 
                  return;
              }
          } 
          if(eventType.value == 4){ // 4 = Game
              if(homeTeam.value == visitingTeam.value){
                  alert("Home Team can not be the same as Visiting Team"); 
                  return;
              }
          } 
          if(dateEle.value == ""){
              alert("You must enter a Date by selecting selecting the calendar"); 
              return;
          }
          if(location.value == 0){ //0 = Other 
              if(other.value == ""){
                  alert("You must enter a value for Other when you select Other as the Location"); 
                  return;
              }
          } 
          document.event.submit();
        }
        function open_calendar() {
          var _x = 300;
          var _y = 200;
          cal_window=window.open('print_cal.pl?form=event&input_name=date', 'cal', 'width=175,height=150,left=' + _x + ',top=' + _y);
          return true;
        }

        function add_other_location(){
         var locationElement = document.getElementById('location');
			   var oHomeElement = document.getElementById('home_team');
			   var oVisitingElement = document.getElementById('visiting_team');
              
               if(locationElement.value == 0){
                   enable_field("other");
               }else{
                   disable_field("other");
               }
			   if(oHomeElement.value == 0){
                   enable_field("other_home");
               }else{
                   disable_field("other_home");
               }
			   	if(oVisitingElement.value == 0){
                   enable_field("other_visiting");
               }else{
                   disable_field("other_visiting");
               }
               //getMousePosition();
        }

        function disable_field(element){
               currentElement = document.getElementById(element);
               currentElement.disabled=true;
               currentElement.style.backgroundColor="CCCCCC";
        }
        function enable_field(element){
               currentElement = document.getElementById(element);
               currentElement.disabled=false;
               currentElement.style.backgroundColor="white";
        }
        function update_fields(){
           var eventTypeElement = document.getElementById('event_type');
           
           if(eventTypeElement.value == 4){ //4=Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 2){ //2=Practice
               disable_field("event_name");
               enable_field("home_team");
               disable_field("visiting_team");
           }else if(eventTypeElement.value == 3){ //3 = Preseason Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 1){ // 1 = League Event
               enable_field("event_name");
               disable_field("home_team");
               disable_field("visiting_team");
           }
           //alert(eventTypeElement.value); 
        }
        //add_other_location();
        //update_fields();
        </script>
__HTML__

print <<__HTML__;
    <FORM NAME=event METHOD ="get" ACTION="update_tournament_event2.pl" ENCTYPE="multipart/form-data">
    <input type=hidden name=event_id value=$event_id>    
    <input type=hidden name=tournament_event_key value=$tournament_event_key>
    <input type=hidden name=org_id value=$org_id>
    <input type=hidden name=league_id value=$league_id>
    <table style='border-collapse:collapse;border:1px solid black' cellpadding=3 cellpadding=0>
    <tr><td align=center colspan=2 id=cal_events_head>Tournament Event</td></tr>

    <tr><td align=right id=cal_events3>
    Event Type
    </td><td align=left id=cal_events3>
    <select class=input width=500 id=event_type name=event_type onChange=update_fields();>
__HTML__
    

	print "<option value='5' >Tournament Game</option>\n";

    
print <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Event Name
    </td><td align=left id=cal_events3>
    <input class=input type=text columns=24 id=event_name name=event_name value="$event_info{"Desc"}">
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Home Team (Upper Bracket)
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=home_team name=home_team onChange=add_other_location()>\n";
    foreach $key (sort keys %teams){
        #########################################
        ##  Use the event_info has to see which 
        ##  team was selected 
        #########################################
        if($teams{$key} eq $event_info{"Home_Team"}){
            print "<option value='$teams{$key}' SELECTED>$key</option>\n";
        }else{
            print "<option value='$teams{$key}'>$key</option>\n";
        }

    }
		if($event_info{"Home_Team"} == 0){
		    print "<option value='0' SELECTED >Other</option>\n";
		}else{
			print "<option value='0' >Other</option>\n";
		}
    print "</select>\n";
    
print <<__HTML__;
    	    

    </td></tr>
	<tr><td align=right id=cal_events3>
    Other Home Team $home_team
    </td><td align=left id=cal_events3>
__HTML__
	if($event_info{"Home_Team"} == 0){
        print "<input class=input type=text columns=24 id=other_home name=other_home value='$alt_top'>\n";
    }else{
	    print "<input class=input type=text columns=24 id=other_home name=other_home >\n";
	}
    

print <<__HTML__;   
    </td></tr>
    <tr><td align=right id=cal_events3>
    Visiting Team (Lower Bracket)
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=visiting_team name=visiting_team onChange=add_other_location()>\n";
    foreach $key (sort keys %teams){
        #########################################
        ##  Use the event_info has to see which 
        ##  team was selected 
        #########################################
        if($teams{$key} eq $event_info{"Away_Team"}){
            print "<option value='$teams{$key}' SELECTED>$key</option>\n";
        }else{
            print "<option value='$teams{$key}'>$key</option>\n";
        }
	}
	    if($event_info{"Away_Team"} == 0){
		    print "<option value='0' SELECTED >Other</option>\n";
		}else{
			print "<option value='0' >Other</option>\n";
		}
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    <tr><td align=right id=cal_events3>
    Other Away Team
    </td><td align=left id=cal_events3>

__HTML__
	if($event_info{"Away_Team"} == 0){
		print "<input class=input type=text columns=24 id=other_visiting name=other_visiting value='$alt_bottom'>\n";
    }else{
		print "<input class=input type=text columns=24 id=other_visiting name=other_visiting>\n";
	}
    

print <<__HTML__;  
    
    
    </td></tr>
    <tr><td align=right id=cal_events3>
    Date
    </td><td align=left id=cal_events3>
    <input class=input type=text id=date name=date READONLY value=$current_sdate>
    <a href="#" id=image_link onClick="open_calendar()";><img src="../images/calendar.gif" border=0 align=top alt="Click to insert Date"></a>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Start Time
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=st_hour name=st_hour>\n";
    foreach(@hours){
        chomp;
        #########################################
        ##  Use the current hour has to see which 
        ##  hour was selected 
        #########################################
        if($_ eq $current_shour){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    
    print "<select class=input id=st_min name=st_min>\n";
    foreach(@min){
        chomp;
        #########################################
        ##  Use the current min has to see which 
        ##  min was selected 
        #########################################
        if($_ eq $current_smin){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    print "<select class=input id=st_ampm name=st_ampm>\n";
    foreach(@ampm){
        chomp;
        #########################################
        ##  Use the current ampm has to see which 
        ##  ampm was selected 
        #########################################
        if($_ eq $current_sampm){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    End Time
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=et_hour name=et_hour>\n";
    foreach(@hours){
        chomp;
        #########################################
        ##  Use the current hour has to see which 
        ##  hour was selected 
        #########################################
        if($_ eq $current_ehour){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    
    print "<select class=input id=et_min name=et_min>\n";
    foreach(@min){
        chomp;
        #########################################
        ##  Use the current hour has to see which 
        ##  hour was selected 
        #########################################
        if($_ eq $current_emin){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    print "<select class=input id=et_ampm name=et_ampm>\n";
    foreach(@ampm){
        chomp;
        #########################################
        ##  Use the current hour has to see which 
        ##  hour was selected 
        #########################################
        if($_ eq $current_eampm){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    
    <tr><td align=right id=cal_events3>
    Location
    </td><td align=left id=cal_events3>
    <select class=input id=location name=location onChange=add_other_location();>
__HTML__

    foreach $key (sort keys %locations){
        #########################################
        ##  Use the event_info has to see which 
        ##  location was selected 
        #########################################
        #print "$locations{$key} eq $event_info{\"Location\"}<br>\n";
        if($locations{$key} eq $event_info{"Location"}){
            print "<option value='$locations{$key}' SELECTED>$key</option>\n";
        }else{
            print "<option value='$locations{$key}' >$key</option>\n";
        }
    }
    
print <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Other
    </td><td align=left id=cal_events3>
    <input class=input type=text id=other name=other value="$event_info{"Other_Location"}">
    </td></tr>

    <tr><td align=right id=cal_events3>
    Notes
    </td><td align=left id=cal_events3>
    <textarea class=input rows=3 id=notes name=notes>$update_notes</textarea>
    </td></tr>
    
    <tr><td id=cal_events3 colspan=2 align=center>
    <input class=input type=button id=SUBMIT name=SUBMIT value=SUBMIT onClick=validate_form();>

    </td></tr>
    </table>
__HTML__

    print "<script> add_other_location();\n update_fields();\n </script>\n";

}

#################################################################
## Print the Tournament Form
#################################################################
sub print_tournament_only_calendar_event_form{
    my $org_id        = shift;
    my $league_id     = shift;
	my $tournament_id = shift;
	my $round         = shift;
	my $round_seed    = shift;
	my $tournament_event_key = shift;

    @hours = (1,2,3,4,5,6,7,8,9,10,11,12);
    @min   = (00,15,30,45);
    @ampm  = ("AM", "PM");

    %event_types  = get_event_types();
    %locations    = get_locations($org_id);
    %teams        = get_league_teams($league_id);



    $locations{"Other"} = 0;

print <<__HTML__;

    <style>
        .image_link a{
                 text-decoration : none;
        }
    </style>

    <script>

        function validate_form(){
          var eventType    = document.getElementById('event_type');
          var eventName    = document.getElementById('event_name');
          var homeTeam     = document.getElementById('home_team');
          var visitingTeam = document.getElementById('visiting_team');
          var dateEle      = document.getElementById('date');
          var location     = document.getElementById('location');
          var other        = document.getElementById('other');
  
          if(eventType.value == 1){ //1 = League Event
              if(eventName.value == ""){
                  alert("You must enter a value for Event Name when entering a League Event"); 
                  return;
              }
          } 
          if(eventType.value == 4){ // 4 = Game
              if(homeTeam.value == visitingTeam.value){
                  alert("Home Team can not be the same as Visiting Team"); 
                  return;
              }
          } 
          if(dateEle.value == ""){
              alert("You must enter a Date by selecting selecting the calendar"); 
              return;
          }
          if(location.value == 0){ //0 = Other 
              if(other.value == ""){
                  alert("You must enter a value for Other when you select Other as the Location"); 
                  return;
              }
          } 
          document.event.submit();
        }
        function open_calendar() {
          var _x = 300;
          var _y = 200;
          cal_window=window.open('print_cal.pl?form=event&input_name=date', 'cal', 'width=175,height=150,left=' + _x + ',top=' + _y);
          return true;
        }

        function add_other_location(){
               var locationElement = document.getElementById('location');
			   var oHomeElement = document.getElementById('home_team');
			   var oVisitingElement = document.getElementById('visiting_team');
              
               if(locationElement.value == 0){
                   enable_field("other");
               }else{
                   disable_field("other");
               }
			   if(oHomeElement.value == 0){
                   enable_field("other_home");
               }else{
                   disable_field("other_home");
               }
			   	if(oVisitingElement.value == 0){
                   enable_field("other_visiting");
               }else{
                   disable_field("other_visiting");
               }
               //getMousePosition();
        }

        function disable_field(element){
               currentElement = document.getElementById(element);
               currentElement.disabled=true;
               currentElement.style.backgroundColor="CCCCCC";
        }
        function enable_field(element){
               currentElement = document.getElementById(element);
               currentElement.disabled=false;
               currentElement.style.backgroundColor="white";
        }
        function update_fields(){
           var eventTypeElement = document.getElementById('event_type');
           
           if(eventTypeElement.value == 4){ //4=Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 2){ //2=Practice
               disable_field("event_name");
               enable_field("home_team");
               disable_field("visiting_team");
           }else if(eventTypeElement.value == 3){ //3 = Preseason Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 1){ // 1 = League Event
               enable_field("event_name");
               disable_field("home_team");
               disable_field("visiting_team");
           }
           //alert(eventTypeElement.value); 
        }
        //add_other_location();
        //update_fields();
        </script>
__HTML__

print <<__HTML__;

    <FORM NAME=event METHOD ="get" ACTION="insert_tournament_only_event2.pl" ENCTYPE="multipart/form-data">
	<input type=hidden name=tournament_event_key value=$tournament_event_key>
	<input type=hidden name=tournament_id value=$tournament_id>
    <input type=hidden name=round value=$round>
	<input type=hidden name=round_seed value=$round_seed>
	<input type=hidden name=org_id value=$org_id>
    <input type=hidden name=league_id value=$league_id>

    <table style='border-collapse:collapse;border:1px solid black' cellpadding=3 cellpadding=0>
    <tr><td align=center colspan=2 id=cal_events_head>Tournament Event</td></tr>
    <tr><td align=right id=cal_events3>
    Event Type
    </td><td align=left id=cal_events3>
    <select class=input width=500 id=event_type name=event_type onChange=update_fields();>
__HTML__
 
	print "<option value='5' >Tournament Game</option>\n";
    
#    foreach $key (sort keys %event_types){
#        chomp;
#        print "<option value='$event_types{$key}' >$key</option>\n";
#    }
    
print <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Game Description
    </td><td align=left id=cal_events3>
    <input class=input type=text columns=24 id=event_name name=event_name >
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Home Team (Upper Bracket)
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=home_team name=home_team onChange=add_other_location();>\n";
    foreach $key (sort keys %teams){
        print "<option value='$teams{$key}' >$key</option>\n";
    }
	    print "<option value='0' >Other</option>\n";
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
	<tr><td align=right id=cal_events3>
    Other Home Team
    </td><td align=left id=cal_events3>
    <input class=input type=text columns=24 id=other_home name=other_home >
    
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Visiting Team (Lower Bracket)
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=visiting_team name=visiting_team onChange=add_other_location();>\n";
    foreach $key (sort keys %teams){
        print "<option value='$teams{$key}' >$key</option>\n";
    }
	 print "<option value='0' >Other</option>\n";
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    <tr><td align=right id=cal_events3>
    Other Away Team
    </td><td align=left id=cal_events3>
    <input class=input type=text columns=24 id=other_visiting name=other_visiting >
    
    </td></tr>
    <tr><td align=right id=cal_events3>
    Date
    </td><td align=left id=cal_events3>
    <input class=input type=text id=date name=date value="" READONLY>
    <a href="#" id=image_link onClick="open_calendar()";><img src="../images/calendar.gif" border=0 align=top alt="Click to insert Date"></a>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Start Time
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=st_hour name=st_hour>\n";
    foreach(@hours){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    
    print "<select class=input id=st_min name=st_min>\n";
    foreach(@min){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    print "<select class=input id=st_ampm name=st_ampm>\n";
    foreach(@ampm){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    End Time
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=et_hour name=et_hour>\n";
    foreach(@hours){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    
    print "<select class=input id=et_min name=et_min>\n";
    foreach(@min){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    print "<select class=input id=et_ampm name=et_ampm>\n";
    foreach(@ampm){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    
    <tr><td align=right id=cal_events3>
    Location
    </td><td align=left id=cal_events3>
    <select class=input id=location name=location onChange=add_other_location();>
__HTML__

    foreach $key (sort keys %locations){
        print "<option value='$locations{$key}' >$key</option>\n";
    }
    
print <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Other
    </td><td align=left id=cal_events3>
    <input class=input type=text id=other name=other>
    </td></tr>

    <tr><td align=right id=cal_events3>
    Notes
    </td><td align=left id=cal_events3>
    <textarea class=input rows=3 id=notes name=notes></textarea>
    </td></tr>
    
    <tr><td id=cal_events3 colspan=2 align=center>
    <input class=input type=button id=SUBMIT name=SUBMIT value=SUBMIT onClick=validate_form();>

    </td></tr>
    </table>
__HTML__

    print "<script> add_other_location();\n update_fields();\n </script>\n";

}


#################################################################
## Print the Tournament Form
## Not sure if this sub is used, may be orphan code
#################################################################
sub print_tournament_calendar_event_form{
    my $org_id        = shift;
    my $league_id     = shift;
	my $tournament_id = shift;
	my $round         = shift;
	my $round_seed    = shift;
	my $tournament_event_key = shift;

    @hours = (1,2,3,4,5,6,7,8,9,10,11,12);
    @min   = (00,15,30,45);
    @ampm  = ("AM", "PM");

    %event_types  = get_event_types();
    %locations    = get_locations($org_id);
    %teams        = get_league_teams($league_id);



    $locations{"Other"} = 0;

print <<__HTML__;

    <style>
        .image_link a{
                 text-decoration : none;
        }
    </style>

    <script>

        function validate_form(){
          var eventType    = document.getElementById('event_type');
          var eventName    = document.getElementById('event_name');
          var homeTeam     = document.getElementById('home_team');
          var visitingTeam = document.getElementById('visiting_team');
          var dateEle      = document.getElementById('date');
          var location     = document.getElementById('location');
          var other        = document.getElementById('other');
  
          if(eventType.value == 1){ //1 = League Event
              if(eventName.value == ""){
                  alert("You must enter a value for Event Name when entering a League Event"); 
                  return;
              }
          } 
          if(eventType.value == 4){ // 4 = Game
              if(homeTeam.value == visitingTeam.value){
                  alert("Home Team can not be the same as Visiting Team"); 
                  return;
              }
          } 
          if(dateEle.value == ""){
              alert("You must enter a Date by selecting selecting the calendar"); 
              return;
          }
          if(location.value == 0){ //0 = Other 
              if(other.value == ""){
                  alert("You must enter a value for Other when you select Other as the Location"); 
                  return;
              }
          } 
          document.event.submit();
        }
        function open_calendar() {
          var _x = 300;
          var _y = 200;
          cal_window=window.open('print_cal.pl?form=event&input_name=date', 'cal', 'width=175,height=150,left=' + _x + ',top=' + _y);
          return true;
        }

        function add_other_location(){
               var locationElement = document.getElementById('location');
              
               if(locationElement.value == 0){
                   enable_field("other");
               }else{
                   disable_field("other");
               }
               //getMousePosition();
        }

        function disable_field(element){
               currentElement = document.getElementById(element);
               currentElement.disabled=true;
               currentElement.style.backgroundColor="CCCCCC";
        }
        function enable_field(element){
               currentElement = document.getElementById(element);
               currentElement.disabled=false;
               currentElement.style.backgroundColor="white";
        }
        function update_fields(){
           var eventTypeElement = document.getElementById('event_type');
           
           if(eventTypeElement.value == 4){ //4=Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 2){ //2=Practice
               disable_field("event_name");
               enable_field("home_team");
               disable_field("visiting_team");
           }else if(eventTypeElement.value == 3){ //3 = Preseason Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 1){ // 1 = League Event
               enable_field("event_name");
               disable_field("home_team");
               disable_field("visiting_team");
           }
           //alert(eventTypeElement.value); 
        }
        //add_other_location();
        //update_fields();
        </script>
__HTML__

print <<__HTML__;
ORG ID: $org_id<br>
    <FORM NAME=event METHOD ="get" ACTION="$lib/insert_tournament_event2.pl" ENCTYPE="multipart/form-data">
	<input type=hidden name=tournament_event_key value=$tournament_event_key>
	<input type=hidden name=tournament_id value=$tournament_id>
    <input type=hidden name=round value=$round>
	<input type=hidden name=round_seed value=$round_seed>
	<input type=hidden name=org_id value=$org_id>
    <input type=hidden name=league_id value=$league_id>

    <table bgcolor=c27c4f style='border-collapse:collapse;border:1px solid black' cellpadding=0>
    <tr><td align=center colspan=2 class=form_header>Tournament Event</td></tr>
    <tr><td>
    <table bgcolor=f6a472 border=0>
    <tr><td align=right class=form_font>
    Event Type
    </td><td align=left>
    <select class=input width=500 id=event_type name=event_type onChange=update_fields();>
__HTML__
 
	print "<option value='5' >Tournament Game</option>\n";
    
#    foreach $key (sort keys %event_types){
#        chomp;
#        print "<option value='$event_types{$key}' >$key</option>\n";
#    }
    
print <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right class=form_font>
    Game Description
    </td><td align=left>
    <input class=input type=text columns=24 id=event_name name=event_name >
    </td></tr>
    
    <tr><td align=right class=form_font>
    Home Team (Upper Bracket)
    </td><td align=left>
__HTML__
    
    print "<select class=input id=home_team name=home_team>\n";
    foreach $key (sort keys %teams){
        print "<option value='$teams{$key}' >$key</option>\n";
    }
    print "</select>\n";
    
print <<__HTML__;
    
    </td></tr>
    
    <tr><td align=right class=form_font>
    Visiting Team (Lower Bracket)
    </td><td align=left>
__HTML__
    
    print "<select class=input id=visiting_team name=visiting_team>\n";
    foreach $key (sort keys %teams){
        print "<option value='$teams{$key}' >$key</option>\n";
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    <tr><td align=right class=form_font>
    Date
    </td><td align=left>
    <input class=input type=text id=date name=date value="12/8/2005" READONLY>
    <a href="#" id=image_link onClick="open_calendar()";><img src="../images/calendar.gif" border=0 align=top alt="Click to insert Date"></a>
    </td></tr>
    
    <tr><td align=right class=form_font>
    Start Time
    </td><td align=left>
__HTML__
    
    print "<select class=input id=st_hour name=st_hour>\n";
    foreach(@hours){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    
    print "<select class=input id=st_min name=st_min>\n";
    foreach(@min){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    print "<select class=input id=st_ampm name=st_ampm>\n";
    foreach(@ampm){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    <tr><td align=right class=form_font>
    End Time
    </td><td align=left>
__HTML__
    
    print "<select class=input id=et_hour name=et_hour>\n";
    foreach(@hours){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    
    print "<select class=input id=et_min name=et_min>\n";
    foreach(@min){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    print "<select class=input id=et_ampm name=et_ampm>\n";
    foreach(@ampm){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    
    <tr><td align=right class=form_font>
    Location
    </td><td align=left>
    <select class=input id=location name=location onChange=add_other_location();>
__HTML__

    foreach $key (sort keys %locations){
        print "<option value='$locations{$key}' >$key</option>\n";
    }
    
print <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right class=form_font>
    Other
    </td><td align=left>
    <input class=input type=text id=other name=other>
    </td></tr>

    <tr><td align=right class=form_font>
    Notes
    </td><td align=left>
    <textarea class=input rows=3 id=notes name=notes></textarea>
    </td></tr>
    
    <tr><td class=form_font colspan=2 align=center>
    <input class=input type=button id=SUBMIT name=SUBMIT value=SUBMIT onClick=validate_form();>
    </td></tr>
    
    </table>
    </td></tr>
    </table>
__HTML__

    print "<script> add_other_location();\n update_fields();\n </script>\n";

}
sub print_update_alt_bracket_form{
    my $event_id       = shift;
    my %event_info     = get_tournament_event_info($event_id);
    my $alt_top        = $event_info{"ALT_TOP_BRACKET"};
	my $alt_bottom     = $event_info{"ALT_BOTTOM_BRACKET"};

print <<__HTML__;
    <script>

        function validate_bracket_form(){
          var altTop = document.getElementById('alt_top');
          var altBottom = document.getElementById('alt_bottom');

          if((altTop.value == "")||(altBottom.value == "")){ 
              alert("You must enter a entry for both brackets!"); 
              return;
          } 

        document.altbracket.submit();
        }

        </script>
    <center>
    <FORM NAME=altbracket METHOD ="get" ACTION="$lib/update_alt_bracket2.pl" ENCTYPE="multipart/form-data">
        <input type=hidden name=event_id value=$event_id> 
	<table style='border-collapse:collapse;border:1px solid black' cellpadding=3 cellspacing=0 width=200>
		<tr>
	    <td  id=cal_events_head colspan=2><center><b>Update Brackets</b></center></td>
		</tr><tr>
        <td id=cal_events3 align=right>Top Bracket</td>
		<td id=cal_events3> 
			<input type=text id=alt_top name=alt_top value="$alt_top" size=20> 
		</td>
		</tr><tr>
        <td id=cal_events3 align=right>Bottom Bracket</td>
		<td id=cal_events3> 
			<input type=text id=alt_bottom name=alt_bottom value="$alt_bottom" size=20> 
		</td></tr>

		<tr>
	        <td  id=cal_events_head colspan=2><center>
		    <input class=input type=button id=SUBMIT name=SUBMIT value=SUBMIT onClick=validate_bracket_form();>
		</center></td>
		</tr>
	</table>
    </center>
__HTML__

}
sub get_tournament_event_info{
  my $tournament_event_id   = shift;
  my %return_hash;
  my $Key             = "";
  my $Tournament_ID   = "";
  my $Round           = "";
  my $Round_Seed      = "";
  my $Event_ID        = "";

  my $dbh = get_dbh(); 

  # prepare and execute query
  my $query = "SELECT * FROM `Tournament_Events` WHERE `Key` = $tournament_event_id";
  my $sth = $dbh->prepare($query);
  $sth->execute();

  # assign fields to variables
  $sth->bind_columns(\$Key, \$Tournament_ID,
                     \$Round, \$Round_Seed,
                     \$Event_ID, \$Alt_Text,
	                 \$Alt_Top_Bracket, \$Alt_Bottom_Bracket);

  # output name list to the browser
  #print "Print Tourney Info<p>\n";

  while($sth->fetch()) {
     $return_hash{"ID"}=$Tournament_ID;
     $return_hash{"ROUND"}=$Round;
     $return_hash{"ROUND_SEED"}=$Round_Seed;
     $return_hash{"EVENT_ID"}=$Event_ID;
     $return_hash{"ALT_TEXT"}=$Alt_Text;
	 $return_hash{"ALT_TOP_BRACKET"}=$Alt_Top_Bracket;
	 $return_hash{"ALT_BOTTOM_BRACKET"}=$Alt_Bottom_Bracket;
  }

  $sth->finish();
  # disconnect from database
  $dbh->disconnect;
  return %return_hash;

}
sub print_update_winner_form{
    my $event_id       = shift;
    my $winner         = get_tournament_winner($event_id);


print <<__HTML__;
    <script>

        function validate_winner_form(){
          var winner = document.getElementById('winner');
       
          if(winner.value == ""){ 
              alert("You must enter a entry for the Winner!"); 
              return;
          } 

        document.winner.submit();
        }

        </script>
    <center>
    <FORM NAME=winner METHOD ="get" ACTION="update_winner2.pl" ENCTYPE="multipart/form-data">
        <input type=hidden name=event_id value=$event_id> 
        <input type=hidden name=org_id value=$org_id> 
        <input type=hidden name=tournament_id value=$tournament_id> 
        <input type=hidden name=league_id value=$league_id> 
	<table style='border-collapse:collapse;border:1px solid black' cellpadding=3 cellspacing=0 width=200>
		<tr>
	    <td  id=cal_events_head colspan=2><center><b>Update Winner</b></center></td>
		</tr><tr>
        <td id=cal_events3 align=right>Winner</td>
		<td id=cal_events3> 
			<input type=text id=winner name=winner value="$winner" size=20> 
		</td>
		</tr>

		<tr>
	        <td  id=cal_events_head colspan=2><center>
		    <input class=input type=button id=SUBMIT name=SUBMIT value=SUBMIT onClick=validate_winner_form();>
		</center></td>
		</tr>
	</table>
    </center>
__HTML__

}
sub get_tournament_winner{
  my $tournament_id   = shift;
  my $return_string   = "";
  my $Key             = "";
  my $Org_ID          = "";
  my $League_ID       = "";
  my $Tournament_Name = "";
  my $Active          = "";
  my $Winner          = "";

  my $dbh = get_dbh(); 

  # prepare and execute query
  my $query = "SELECT * FROM `Tournament_Info` WHERE `Key` = $tournament_id";
  my $sth = $dbh->prepare($query);
  $sth->execute();

  # assign fields to variables
  $sth->bind_columns(\$Key, \$Org_ID,
                     \$League_ID, \$Tournament_Name,
	                 \$Active, \$Winner);

  while($sth->fetch()) {
      $return_string = $Winner;
  }
  $sth->finish();
  # disconnect from database
  $dbh->disconnect;
  return $return_string;

}

sub get_display_time{
	  my $Start_Date = shift;
	  ################################################
      ## Parse Date String
      ################################################
      my ($date, $time)      = split(/\s+/, $Start_Date);
      my ($hour,$min,$sec)   = split(/:/, $time);
      my ($current_year,$month,$day) = split(/-/, $date);
      my $shortened_notes = substr($Notes,0,20); 
      my $leftover_notes  = substr($Notes,20); 
    
      ################################################
      ## Convert to epoch seconds and back to get 
      ## Day of week (ie Sat) and to get the Day
      ## without any leading zero's (ie 03) 
      ################################################
	  #print "SD: $Start_Date<br>\n";
	  #print "SEC: $sec, Min: $min, Hour: $hour, Day: $day MONTH: $month YEAR: $current_year\n";
      my $time_in_epoch      = timelocal($sec,$min,$hour,$day,$month-1,$current_year-1900);
      my ($rsec, $rmin, $rhour, $current_day, $rmonth, $ryear, $wday, $yday, $isdst) = localtime($time_in_epoch);
    
      ################################################
      ## Convert to Month Name (ie January) and 
      ## Day of Week name (ie Sat) 
      ################################################
      my $day_name     = get_day_name($wday);
      my $month_name   = get_month_name_small($month);

      ################################################
      ## Make conversions to display properly 
      ################################################
      if($rhour > 12){
          $rhour = $rhour - 12;
          $am_pm = "PM";
      }elsif($rhour == 0){
          $rhour = 12; 
          $am_pm = "AM";
      }elsif($rhour == 12){
          $am_pm = "PM";
      }else{
          $am_pm = "AM";
      } 
      $display_time = "$month_name $current_day ($day_name) $rhour:$min $am_pm";
      return $display_time;
}
1;