#################################################################
## Get News infor for one item 
#################################################################
sub print_update_news_block{
    my $ID        = shift;
    my $color     = shift;
    my %news_info = get_news_info($ID);
    my ($date, $time) = split(/\s+/,$news_info{"Date"});
    my $date = convert_date_to_display($date);
	$news_info{"News"}  =~ s/<br>/\n/g;
print <<__HTML__;

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

    <script>

        function coach_add(){
          var titleEl = document.getElementById('news_title');
          var newsEl  = document.getElementById('news');
  
          if(newsEl.value == ""){ 
              alert("You must enter a some News to add a new item."); 
              return;
          } 
          if(titleEl.value == ""){ 
              alert("You must enter a Title to add a new News item."); 
              return;
          } 
          document.news_form.submit();
        }

    </script>


    <FORM NAME=news_form METHOD ="get" ACTION="update_news2.pl" ENCTYPE="multipart/form-data">
            
    <input type=hidden name=org_id value=$news_info{"Org_ID"}>
    <input type=hidden name=color value=$color>
    <input type=hidden name=event_id value=$ID>

        <br>
        <br>
        <center>
        <input type=hidden name=date value="$date">
        <TABLE cellSpacing=1 cellPadding=4 width="400" bgColor=$color border=0  ID=table_header_font>
        <TR>
          <TD vAlign=center align=left width="60%" bgColor=$color>
            <input type=text id=news_title name=news_title size=50 value="$news_info{"Title"}">
            </TD>
          <TD vAlign=middle align=right width="40%" bgColor=$color id=box>
            <B>$date</B> <a href='javascript: coach_add()' >update</a>
    
            </TD>
          </TR>
          <TR>
            <TD bgColor=#ffffff colspan=2>
              <TABLE width="100%" border=0>
                <TR>
                  <TD align=left ID=table_font>
                  <textarea rows=5 cols=74 id=news name=news>$news_info{"News"}</textarea>
                  </TD>
                </TR>
              </TABLE>
            
          </TD>
        </TR>
                  
      </TABLE>
      </center>

__HTML__

}

#################################################################
## Get News infor for one item 
#################################################################
sub get_news_info{
  my $event_id = shift;
  my %return_hash = ();
  $dbh = get_dbh(); 
  # prepare and execute query
  $query = "SELECT * FROM News WHERE `Key` = $event_id";
  $sth = $dbh->prepare($query);
  $sth->execute();

  # assign fields to variables
  $sth->bind_columns(\$Key, \$Org_ID, \$League_ID,
                     \$Team_ID, \$Date, \$Title,
                     \$News);

  while($sth->fetch()) {
      $return_hash{"Key"}            = "$Key";
      $return_hash{"Org_ID"}         = "$Org_ID";
      $return_hash{"League_ID"}      = "$League_ID";
      $return_hash{"Team_ID"}        = "$Team_ID";
      $return_hash{"Date"}           = "$Date";
      $return_hash{"Title"}          = "$Title";
      $return_hash{"News"}           = "$News";
  }

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

}


#################################################################
## Print the Update Form
#################################################################
sub print_new_news_block{
    my $org_id    = shift;
    my $league_id = shift;
    my $color     = shift;
    my $date      = get_date();

print <<__HTML__;

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

    <script>

        function change_news(){
          var titleEl = document.getElementById('news_title');
          var newsEl  = document.getElementById('news');
  
          if(newsEl.value == ""){ 
              alert("You must enter a some News to add a new item."); 
              return;
          } 
          if(titleEl.value == ""){ 
              alert("You must enter a Title to add a new News item."); 
              return;
          } 
          //titleEl.value = escape(titleEl.value);
          //newsEl.value = escape(newsEl.value);
          document.news_form.submit();
        }

    </script>


    <FORM NAME=news_form METHOD ="get" ACTION="insert_news2.pl" ENCTYPE="multipart/form-data">
    <input type=hidden name=org_id value=$org_id>
    <input type=hidden name=league_id value=$league_id>
    <input type=hidden name=color value=$color>

        <br>
        <center>
        <input type=hidden name=date value="$date">
        <TABLE cellSpacing=1 cellPadding=4 width="400" bgColor=$color border=0  ID=table_header_font>
        <TR>
          <TD vAlign=center align=left width="60%" bgColor=$color>
            <input type=text id=news_title size=50 name=news_title>
            </TD>
          <TD vAlign=middle align=right width="40%" bgColor=$color id=box>
            <B>$date</B> <a href='javascript: change_news()' >add</a>
    
            </TD>
          </TR>
          <TR>
            <TD bgColor=#ffffff colspan=2>
              <TABLE width="100%" border=0>
                <TR>
                  <TD align=left ID=table_font>
                  <textarea rows=5 cols=74 id=news name=news></textarea>
                  </TD>
                </TR>
              </TABLE>
            
          </TD>
        </TR>
                  
      </TABLE>
      </center>

__HTML__

}

1