############# V 1.1
sub get_reg_setup{
    my $org_id   = shift;
	my $reg_year = shift;
    my $dbh = get_dbh();
    ################################################################
    # Query DB to verify Session
    ################################################################
	my $query = "SELECT `Secure_URL`, `Org_Dir`, `Reg_File`, `Reg_Admin_File`, `Org_Caps`, `Home_Page_URL`, `Default_State`, `Min_Partial_Pay`, `Reply_To`, `From`, `Org_Full_Name_For_Email`, `Season_Text`, `Welcome_Text`, `Information_Text`, `Pay_Complete_Message`, `Pay_By_Check_Message`, `Paypal_Account`, `Return_URL`, `IPN_URL`, `Paypal_URL`, `Require_Confirmation`, `Require_Confirmation_MSG`, `League_Assign` FROM `Reg_Setup` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year'";
	#print "QUERY: $query<br>\n";
	my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->bind_columns(\$Secure_URL, \$Org_Dir, 
                       \$Reg_File, \$Reg_Admin_File,
                       \$Org_Caps, \$Home_Page_URL,
                       \$Default_State, \$Min_Partial_Pay,
                       \$Reply_To, \$From,
                       \$Org_Full_Name_For_Email, \$Season_Text,
                       \$Welcome_Text, \$Information_Text,
                       \$Pay_Complete_Message, \$Pay_By_Check_Message,
                       \$Paypal_Account, \$Return_URL,
                       \$IPN_URL, \$Paypal_URL, 
					   \$Require_Confirmation, \$Require_Confirmation_MSG,
				       \$League_Assign);

    while($sth->fetch()) {
		$min_partial_pay          = $Min_Partial_Pay;
		$reply_to                 = $Reply_To;
		$from                     = $From;
		$org_full_name_for_email  = $Org_Full_Name_For_Email;
		$season_text              = $Season_Text;
		$welcome_text             = $Welcome_Text;
		$information_text         = $Information_Text;
		$pay_complete_message     = $Pay_Complete_Message;
		$pay_by_check_message     = $Pay_By_Check_Message;
		$paypal_acc               = $Paypal_Account;
		$return_url               = $Return_URL;
		$thanks_url               = "$Secure_URL/$Org_Dir/$Reg_File?action=pp";
		$ipn_url                  = $IPN_URL;
		$base_reg_url             = "$Secure_URL/$Org_Dir/$Reg_File";
		$admin_reg_url            = "$Secure_URL/$Org_Dir/$Reg_Admin_File";
		$paypal_url               = $Paypal_URL;
		$default_state            = $Default_State;
		$home_page_url            = $Home_Page_URL;
		$require_confirmation     = $Require_Confirmation;
		$require_confirmation_msg = $Require_Confirmation_MSG;
		$league_assign            = $League_Assign;
    }
    $sth->finish();
    $dbh->disconnect;

}

###################################################
# Check to see if all players under a user are confirmed
###################################################
sub check_if_all_users_are_confirmed{
    my $user_key = shift;
    my %player_info            = get_player_info($user_key);
	my $all_players_confirmed  = 1;
	my $player_count           = 0;
	my %status_hash               = get_status_hash($org_id, $reg_year);
	foreach my $this_user_key (keys %player_info){
        my $this_player_confirmed_state = $player_info{$this_user_key}{'PLAYER_CONFIRMED'}; # Note that this is really a state
		my $this_player_confirmed       = $status_hash{$this_player_confirmed_state}{"ACCEPTED_STATE"};
	    ######################################
		# Track if all players are confirmed
	    ######################################
		if( $this_player_confirmed == 0){
	        $all_players_confirmed = 0;
		}

		$player_count++;
		
	}
	if($player_count < 1){
	        $all_players_confirmed = 0;
	}
	return $all_players_confirmed;
}
############################################
# Get The status options into a hash
# Change this part to get data from DB
############################################
sub get_status_hash{
    my $org_id   = shift;
    my $reg_year = shift;
    my $dbh      = get_dbh();
    my %tmp_status_hash;
    my $query = "SELECT `State_ID`, `State_Desc`, `Accepted_State` FROM `Reg_Confirmation_States` WHERE `Org_ID`='$org_id' AND `Reg_Year`='$reg_year' ORDER BY `Order`";
	my $sth = $dbh->prepare($query);
    $sth->execute();
    while (my $hash_ref = $sth->fetchrow_hashref) {
	    my $state_id   = $hash_ref->{State_ID};
	    my $state_desc = $hash_ref->{State_ID};
	    $tmp_status_hash{$state_id}{"DESC"} = $hash_ref->{State_Desc};
	    $tmp_status_hash{$state_id}{"ACCEPTED_STATE"} = $hash_ref->{Accepted_State};
    }
    $dbh->disconnect;
    $sth->finish();
    return %tmp_status_hash;

}

############################################
# Get player info by key
############################################
sub get_player_info_by_key{
    my $player_key    = shift;
    my %return_hash = ();
    my $dbh = get_dbh();
    ################################################################
    # Query DB to verify Session
    ################################################################
    my $query = "SELECT `Key`,`Org_ID`,`Reg_Year`,`Firstname`,`Lastname`,`Account_ID`,`Paid`,`Active`,`Reg_Date`,`Player_Confirmed`,`Assigned_League`,`Assigned_Team` FROM `Reg_Player_Link` WHERE `Key` = '$player_key' AND `Active` = '1' AND `Reg_Year` = '$reg_year' ORDER BY `Key`";
    my $sth = $dbh->prepare($query);
    #print "$query<br>\n";
    $sth->execute();

    
    $sth->bind_columns(\$Key, \$Org_ID, \$Reg_Year, 
                   \$Firstname, \$Lastname, 
                   \$Account_ID, \$Paid,
                   \$Active, \$Reg_Date,
			       \$Player_Confirmed,
			       \$Assigned_League, \$Assigned_Team);
    $user_number = 1;
    while($sth->fetch()) {
        $return_hash{"KEY"}              = $Key;
        $return_hash{"ORG_ID"}           = $Org_ID;
        $return_hash{"REG_YEAR"}         = $Reg_Year;
        $return_hash{"FIRSTNAME"}        = $Firstname;
        $return_hash{"LASTNAME"}         = $Lastname;
        $return_hash{"ACCOUNT_ID"}       = $Account_ID;
        $return_hash{"PAID"}             = $Paid;
        $return_hash{"ACTIVE"}           = $Active;
        $return_hash{"REG_DATE"}         = $Reg_Date;
        $return_hash{"PLAYER_CONFIRMED"} = $Player_Confirmed;
		$return_hash{"ASSIGNED_LEAGUE"}  = $Assigned_League;
		$return_hash{"ASSIGNED_TEAM"}    = $Assigned_Team;
     
        $user_number++;
    }
    $dbh->disconnect;
    $sth->finish();
    return %return_hash;
}
################################################################
### Get the HTML user table show in upper left corner
################################################################
sub get_registration_options_table{
    my $user_key = shift;
    my $all_players_confirmed = shift;
    my %user_info         = get_account_info($user_key);
	my $proceed_to_checkout    = "<br>&nbsp;";
	my $print_forms            = "<br>&nbsp;";
	if($all_players_confirmed == 1){
		$proceed_to_checkout = "&nbsp;&nbsp;&nbsp;<a href='#' onClick=\"next_step('pay'); return false;\">Proceed to Checkout</a><br>\n";
		$print_forms         = "&nbsp;&nbsp;&nbsp;<a href=print_forms.html?user_key=$user_key target=new>Print Player Forms</a><br>\n";
    }
    my $return_html = <<__HTML__;
    <table   style='border-collapse:collapse;border:1px solid #8480a2;height:100%;' cellpadding=2 width=244><tr><td id=admin_header><center>Registration Options</center></td></tr>
    <tr><td id=cal_events3 align=left>
	&nbsp;&nbsp;&nbsp;<a href="#" onClick="next_step('register'); return false;" >Register Additional Player</a><br>
	$proceed_to_checkout 
	$print_forms
	<br>
	<br>
	<br>
    </td></tr></table>
__HTML__
    return $return_html;

}

################################################################
### Get the HTML user table show in upper left corner
################################################################
sub get_account_table_with_update_link{
    my $user_key = shift;
    my $link     = shift;
    my %user_info         = get_account_info($user_key);
    my $return_html = <<__HTML__;
    <table   style='border-collapse:collapse;border:1px solid #8480a2' cellpadding=2 width=244><tr><td id=admin_header><center>Account Owner</center></td></tr>
    <tr><td id=cal_events3 align=center>
    $user_info{"FIRSTNAME"} $user_info{"LASTNAME"}<br>
    $user_info{"EMAIL"}<br>
    $user_info{"ADDRESS1"}<br>
    $user_info{"ADDRESS2"}<br>
    $user_info{"CITY"}, $user_info{"STATE"} $user_info{"ZIP_CODE"}<br>
	&nbsp;<a href="#" onClick="$link;return false;">Update Account Info</a>&nbsp;&nbsp;
    </td></tr></table>
__HTML__
    return $return_html;

}
################################################################
### Get the HTML user table show in upper left corner
################################################################
sub get_account_table{
    my $user_key = shift;
    my %user_info         = get_account_info($user_key);
    my $return_html = <<__HTML__;
    <table   style='border-collapse:collapse;border:1px solid #8480a2' cellpadding=2 width=200><tr><td id=admin_header><center>Account Owner</center></td></tr>
    <tr><td id=cal_events3 align=center>
    $user_info{"FIRSTNAME"} $user_info{"LASTNAME"}<br>
    $user_info{"EMAIL"}<br>
    $user_info{"ADDRESS1"}<br>
    $user_info{"ADDRESS2"}<br>
    $user_info{"CITY"}, $user_info{"STATE"} $user_info{"ZIP_CODE"}
    </td></tr></table>
__HTML__
    return $return_html;

}

############################################
# Get adjustment tabel cell for payment screen
############################################
sub get_fees_table_cell_paypal_string_and_total{
    my $player_key      = shift;
	my $style           = shift;
	my $return_cell     = "";
	my $paypal_string   = "";
    my $total           = 0;
	my $total_fee       = 0;
	my $total_paid      = 0;
	my %return_hash     = ();
	my %total_due       = 0;
	my %adjustment_info = ();
    my $return_string   = "";
	my $check_id        = "";
	my $plus_minus      = "";
    my $first           = 1;
	
	############################################
	#Get the adjustments for that player 
	############################################
	($total, $total_fee, $total_paid, %adjustment_info) = get_adjustment_info($player_key);
			
	############################################
	# Loop through all the adjustments to get information about the fees
	############################################
    foreach my $count (sort {$a <=> $b} (keys %adjustment_info)){
	    ############################################
		# If the UPDATE ID is -1 or -3 it was an autmated fee.  
		# So we need to lookup what the fee is using the CHECK_ID field
		############################################
	    if(($adjustment_info{$count}{"UPDATE_ID"} == -1)||($adjustment_info{$count}{"UPDATE_ID"} == -3)){
			$checkout_override = get_checkout_override($adjustment_info{$count}{"CHECK_ID"}, $player_key);
			if($checkout_override eq ""){
			    $check_id = $input_value = get_input_options($adjustment_info{$count}{"CHECK_ID"}, $player_key);
			}else{
			    $check_id = $checkout_override;
			}
		}elsif($adjustment_info{$count}{"UPDATE_ID"} == -5){ #Multiplayer Discount
		    $check_id = get_multiplayer_discount_description($adjustment_info{$count}{"CHECK_ID"}); 
		}else{
		    $check_id = $adjustment_info{$count}{"CHECK_ID"};
		}
	

		############################################
		#  This is to get the proper + and - for the paypal and pay table cell
		#  because a - number would look like $-10 we just strip it and make it -$10
		# And then for paypal we do not want a + sign to start with.
		############################################
		my $adjustment_amount = $adjustment_info{$count}{"AMOUNT"} + 0;
		my $abs_adjustment_amount = abs($adjustment_amount);

		
		$adjustment_amount = sprintf("%.2f", $adjustment_amount);
		my $display_plus_minus = "";
        $plus_minus = "";
		if(!(($adjustment_info{$count}{"UPDATE_ID"} == -2)||($adjustment_info{$count}{"UPDATE_ID"} == -3))){
		    if($adjustment_amount >= 0){
			    if($first == 0){
		            $plus_minus = " + ";
		    	}
			    ############################################
		        # Set string to first so we do not add a plus or minus in first item
		        ############################################
		        $first = 0;
		    }else{
		    	$plus_minus  = " - ";
				$display_plus_minus = "-";
		        $first = 0;
		    }
			if(($plus_minus ne ' - ')||($adjustment_info{$count}{"UPDATE_ID"} == -5)){ #Only show fees and multiplayer discounts
		    #if($adjustment_info{$count}{"UPDATE_ID"} == -1){
		        ############################################
		        #  Get the paypal string
		        ############################################
		        $paypal_string .= $plus_minus . '$' . $abs_adjustment_amount . " " . $check_id; 
		
		        ############################################
		        # This creates the cell for the pay table
		        ############################################
				$abs_adjustment_amount = sprintf("%.2f", $abs_adjustment_amount);
		        $return_cell   .= $display_plus_minus . '$' . $abs_adjustment_amount . " " . $check_id . "<br>";
		    }
		}


	}
    ############################################
	# Calculate return value and set return hash
    ############################################
	$abs_total_paid = abs($total_paid);
    $total_due                       = $total_fee + $total_paid;
	$total_fee                       = sprintf("%.2f", $total_fee);
	$total_paid                      = sprintf("%.2f", $total_paid);
	$total_due                       = sprintf("%.2f", $total_due);
	$abs_total_paid                  = sprintf("%.2f", $abs_total_paid);
	#print "TOTAL PAID: $total_due<br>\n";
	$return_hash{"FEES_CELL"}        = "<td id=$style>" . $return_cell . "</td>\n";
	$return_hash{"TOTAL_FEE_CELL"}   = "<td id=$style>\$" . $total_fee . "</td>\n";
	$return_hash{"TOTAL_PAID_CELL"}  = "<td id=$style>\$" . $abs_total_paid . "</td>\n";
	$return_hash{"TOTAL_DUE_CELL"}   = "<td id=$style>\$" . $total_due . "</td>\n";
	$return_hash{"TOTAL_FEE"}        = $total_fee;
	$return_hash{"TOTAL_PAID"}       = $total_paid;
	$return_hash{"TOTAL_DUE"}        = $total_due;
	$return_hash{"PAYPAL_STRING"}    = $paypal_string;
    return %return_hash;
}

############################################
# Get adjustment info for one player
############################################
sub get_adjustment_info{
    my $player_key    = shift;
    my $return_string = "";
	my %return_hash   = ();
	my $total         = 0;
	my $total_fee     = 0;
	my $total_paid    = 0;
	my $count         = 1;
    my $dbh = get_dbh();
    ################################################################
    # Query DB to verify Session
    ################################################################
	my $query = "SELECT `Key`, `Amount`, `Check_ID`, `Update_Account_ID`, `Date` FROM `Reg_All_Transaction` WHERE `Player_ID` = '$player_key' ORDER BY `Key`";
    #print "QUERY: $query<br>\n";
	my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->bind_columns(\$Key, \$Amount, \$Check_ID, \$Update_Account_ID, \$Date);

    while($sth->fetch()) {
        $return_hash{$count}{"KEY"} = $Key;
        $return_hash{$count}{"AMOUNT"} = $Amount;
		$return_hash{$count}{"CHECK_ID"} = $Check_ID;
		$return_hash{$count}{"UPDATE_ID"} = $Update_Account_ID;
		$return_hash{$count}{"DATE"} = $Date;
		if(!(($Update_Account_ID == -2)||($Update_Account_ID == -3)||($Update_Account_ID == -5))){
		    if($Amount > 0){
		        $total_fee  = $total_fee + $Amount;
			}else{
			    $total_paid = $total_paid + $Amount;
			}
			$total = $total + $Amount;
		}elsif($Update_Account_ID == -5){
		        $total_fee  = $total_fee + $Amount;
		}
		
		$count++;
    }
	#if($player_key == 1409){
	#print "TOTAL: $total<br>T_PAID: $total_paid<br>FEE: $total_fee<br>\n";
	#}
    $sth->finish();
    $dbh->disconnect;
    return $total, $total_fee, $total_paid, %return_hash;
}

############################################
# Get reg definition info for one cell
############################################
sub get_specific_reg_definition{
    my $org_id    = shift;
	my $reg_year  = shift;
	my $player_id = shift;
	my $reg_key   = shift;
	my %return_hash = ();
    my $dbh = get_dbh();
    ################################################################
    # Query DB to verify Session
    ################################################################
    my $query = "SELECT `Key`,`Description_Text`,`Input_Type`,`Selection_Link`,`Validation_Link`,`Required`,`Order` FROM `Reg_Definition` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year' AND `Key` = '$reg_key';";
    my $sth = $dbh->prepare($query);
    #print "$query<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Key,\$Description_Text,\$Input_Type,\$Selection_Link,\$Validation_Link,\$Required,\$Order);

    while($sth->fetch()) {
        $return_hash{"DESCRIPTION_TEXT"} = $Description_Text;  
        $return_hash{"INPUT_TYPE"}       = $Input_Type;  
        $return_hash{"SELECTION_LINK"}   = $Selection_Link;  
        $return_hash{"VALIDATION_LINK"}  = $Validation_Link;  
        $return_hash{"REQUIRED"}         = $Required;  
        $return_hash{"ORDER"}            = $Order;  
    }
    # disconnect from database
    $sth->finish();
    $dbh->disconnect;
	return %return_hash;
}

############################################
# Return description text for multiplayer discount
############################################
sub get_multiplayer_discount_description{
    my $multiplayer_discount_id = shift;
    my $dbh          = get_dbh();
    my $query        = "SELECT `Description` FROM `Reg_Multi_Player_Discount` WHERE `Key` = '$multiplayer_discount_id'";
    #print "QUERY: $query<br>\n";	
	my $sth          = $dbh->prepare($query);
    $sth->execute();
	my $description = "default discount";
    while (my $hash_ref = $sth->fetchrow_hashref) {
        $description = $hash_ref->{Description}; 
    }
	#print "PLAYER COUNT: $player_count<br>\n";
    # disconnect from database
    $dbh->disconnect;
    $sth->finish();
	return $description;
    
} 

############################################
# This creates the paypal and html for the checkout table.
############################################
sub get_nonconfirmed_user_table{
    my $user_key          = shift;
    my %user_info         = get_account_info($user_key);
    my %player_info       = get_player_info($user_key);
    my $num_players       = 0;
	my $row_style         = "cal_events3";
	my $user_table = get_checkout_header("Pre-Registered Players");
    my $user_table = "<table   style='border-collapse:collapse;border:1px solid #8480a2' cellpadding=2 width=500><tr><td colspan=2 id=admin_header><center>Pre-Registered Players</center></td></tr>\n";
	my %status_hash       = get_status_hash($org_id, $reg_year);
    $checkout_header   .= "<tr><td id=admin_header align=center>Name</td><td id=admin_header align=center>Status</td>\n";
    ############################################
    # Loop through players to create the display cell, paypal info and calculate totals
    ############################################    
    foreach my $user_number (sort {$a <=> $b} (keys %player_info)){
        $num_players++;

        my $this_player_confirmed_state = $player_info{$user_number}{'PLAYER_CONFIRMED'}; # Note that this is really a state
		my $this_player_confirmed       = $status_hash{$this_player_confirmed_state}{"ACCEPTED_STATE"};
        my $assigned_league             = $player_info{$user_number}{'ASSIGNED_LEAGUE'}; 
        my $assigned_team               = $player_info{$user_number}{'ASSIGNED_TEAM'}; 
        my $player_key                  = $player_info{$user_number}{'KEY'}; 
		#my $current_state               = "Pre-Registration Only -$this_player_confirmed-$this_player_confirmed_state--$assigned_team-$assigned_league";
	    my $current_state               = "Pre-Registration Only";
		if($this_player_confirmed == 1){
			my $player_team = get_input_options(1117, $player_key);
			#$current_state  = "Accepted -$player_team - $this_player_confirmed-$this_player_confirmed_state--$assigned_team-$assigned_league";
	        $current_state  = "Accepted ($player_team)";
	    }
		############################################
        # Get the cell with a list of what is due for player, plus the paypal string
        # that gets sent to have an itemized list on pay pal.			
		############################################  
		my $player_row = "<tr><td id = '$row_style'> $player_info{$user_number}{'FIRSTNAME'} $player_info{$user_number}{'LASTNAME'}</td><td id='$row_style'>$current_state</td></tr>\n";
		$user_table .= $player_row;
    }
	if($num_players == 0){
        $user_table .= "<tr> <td id='$row_style' colspan=2 align=center>No player has been registered yet</td></tr>\n";
	}
    $user_table .= "</table>\n";

    return $user_table;
}

############################################
# This creates the paypal and html for the checkout table.
############################################
sub get_checkout_table{
    my $user_key          = shift;
    my $by_check          = shift;
    my %user_info         = get_account_info($user_key);
    my %player_info       = get_player_info($user_key);
    my $pay_pal_count     = 1;
    my $num_players       = 0;
    my $total_cost        = 0;
	my $walk_in_fee       = 0;
	my $walk_in_amount    = 25;
	my $adjustment_string = "";
	

    if($by_check == 0){
        $transaction_id = get_transaction_id();
    }
	my $user_table = get_checkout_header("Registered Players");
	my $pay_pal    = get_paypal_const();

    ############################################
    # Loop through players to create the display cell, paypal info and calculate totals
    ############################################    
    foreach my $user_number (sort {$a <=> $b} (keys %player_info)){
            $num_players++;
			my $fees_cell       = "";
			my $total           = 0;
			my $player_total    = 0; # this is just in case there are other adjustments
            my $player_key      = $player_info{$user_number}{"KEY"};
            #my $amount_paid     = $player_info{$user_number}{"PAID"};
			############################################
            # Get the cell with a list of what is due for player, plus the paypal string
            # that gets sent to have an itemized list on pay pal.			
			############################################  
			my ($player_row, %checkout_hash) = get_checkout_row_for_player_and_total_due_and_pay_pal($player_key, $player_info{$user_number}{"FIRSTNAME"}, $player_info{$user_number}{"LASTNAME"}, "cal_events3");
            my $amount_due    = $checkout_hash{"TOTAL_DUE"};
	        my $paypal_string = $checkout_hash{"PAYPAL_STRING"};
	        my $total_paid    = $checkout_hash{"TOTAL_PAID"};

			$user_table .= $player_row;
			
			#$amount_due =  .02;
			############################################
            # Store temporary paypal record.  This will not be valid until the paypal tx is finished.			
			############################################  
            if($by_check == 0){
                insert_tmp_paypal($user_key, $player_key, $amount_due, $transaction_id);
            }
            
			############################################
            # Add player specific paypal info			
			############################################  
            $pay_pal .= "<input type=\"hidden\" name=\"item_name_" . $pay_pal_count . "\" value=\"$player_info{$user_number}{\"FIRSTNAME\"} $player_info{$user_number}{\"LASTNAME\"}  ($paypal_string)\">\n";
            $pay_pal .= "<input type=\"hidden\" name=\"amount_" . $pay_pal_count . "\" value=\"$amount_due\">\n";
            $pay_pal_count++;
					
			############################################
            # Keep running total of amount due for user			
			############################################  
            $total_cost = $amount_due + $total_cost;
            
    }
	############################################
	# Finish user table
	############################################
	$total_cost  = sprintf("%.2f", $total_cost);
    $user_table .= "<tr><td id=cal_events3 colspan=8 align=right><b>TOTAL DUE: \$$total_cost</b></td></tr>\n";
    $user_table .= "</table>\n";
    
    ############################################
	# If its not pay by check, create form for submitting
	############################################
	if($by_check != 1){
        $user_table .= "<form name=partial_form METHOD =\"$method\" ACTION=\"$page_url\" ENCTYPE=\"multipart/form-data\"><input type=hidden name=partial_amount id=partial_amount value=$total_cost >\n";
        $user_table .= "<input type=hidden name=action id=action value=partial>";
        $user_table .= "<input type=hidden name=userkey id=userkey value=$user_key>\n";
        $user_table .= "</form>\n";
    }
    
    ############################################
	# If its not pay by check, give them thier payment options. Notice that
	# this is stored in the pay_pal portion. I think this is becuase it gets 
	# printed to the screen after the others.
	############################################
    $pay_pal .= "<input type='button'  name='revise' value='Revise Order' onClick=\"javascript:document.revise_form.submit();\">\n";
    $pay_pal .= "<input type='button'  name='pay_by_check' value='Pay By Check' onClick=\"javascript:document.pay_by_check_form.submit();\">\n";
	if($min_partial_pay == 0){
        $pay_pal .= "<input type='submit'  name='submit' value='Pay With Credit Card'>\n";
	}else{
        $pay_pal .= "<input type='button'  name='submit' value='Pay With Credit Card' onClick=\"Show();\">\n";
    }
    $pay_pal .= "<div id=\"Popup\" class=\"transparent\"><div style=\"background-color: #686b6e\"><table width=100%><tr><td>&nbsp;</td><td><b><font color=white>Credit Card Payment Options</font></b></td><td align=right><a href=javascript:void(0); onclick=\"Hide();\">x</a></td></tr></table></div>\n";
    $pay_pal .= "<div></b><br><center><input type='submit'  name='submit' value='Pay In Full'> \n";
    $pay_pal .= "<input type='button'  name='submit' value='Pay Partial' onClick=\"javascript:document.partial_form.submit();\"></div></div>\n";
    $pay_pal .= "</form>\n";
	
	############################################
	# If it is pay by check.  Display where to send it.  Stored in var
	############################################
    if($by_check == 1){
	if(($org_id == 167)||($org_id == 13)){ # Plymouth required forms
	    #$user_table .= "<center><a href=print_forms.html?user_key=$user_key target=new><font size=3><b>Print Registration Confirmation and Player Forms</b></a></font></center><br>\n";
        }
        $user_table .= "<table border=0><tr><td style=\"font-size:10pt;color:black;font-family: Arial, Helvetica;\">$pay_by_check_message<br>\n";
        $user_table .= "<form name=pay_by_check_form METHOD =\"$method\" ACTION=\"$home_page_url\" ENCTYPE=\"multipart/form-data\"><input type=hidden name=partial_amount id=partial_amount value=$total_cost >\n";
        #$partial_form = "\n";
        $user_table .= "<input type=hidden name=action id=action value=admin_pay_by_check_complete>";
        $user_table .= "<input type=hidden name=userkey id=userkey value=$user_key>\n";
        $user_table .= "<center><input type=button name=Exit value=Exit onClick=\"javascript:document.pay_by_check_form.submit();\"></center>\n</form>";
    }

    return $user_table, $pay_pal;
}

############################################
# Check for discount for user (parent) 
############################################
sub check_for_multiplayer_discounts_all_users{
    my $user_key     = shift;
	my $player_key   = shift;
    my $player_count = shift; 
    my $dbh          = get_dbh();
    my $query        = "SELECT `Key`, `Description`, `Discount` FROM `Reg_Multi_Player_Discount` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year' AND `Number_Of_Reg_Players` <= '$player_count' AND `Max_Reg_Players` >= '$player_count'";
    #print "QUERY: $query<br>\n";	
	my $sth          = $dbh->prepare($query);
    $sth->execute();
    while (my $hash_ref = $sth->fetchrow_hashref) {
        my $description = $hash_ref->{Description}; 
        my $discount    = $hash_ref->{Discount};
        my $key         = $hash_ref->{Key};
		#print "DESC: $description, DIS: $discount<br>\n";
		insert_adjustment($user_key, $player_key, $discount, $key, -5);  #-5 just means that its a multiplayer discount 
    }

    
	#print "PLAYER COUNT: $player_count<br>\n";
    # disconnect from database
    $dbh->disconnect;
    $sth->finish();
}

############################################
# This creates the paypal and html for the checkout table.
############################################
sub add_multi_player_discount_all_players{
    my $user_key          = shift;
    my %player_info       = get_player_info($user_key);

    ############################################
    # Loop through players to check for discounts 
    ############################################    
    my $num_players = 0;
    foreach my $user_number (sort {$a <=> $b} (keys %player_info)){
        $num_players++;
        my $player_key = $player_info{$user_number}{"KEY"};
        check_for_multiplayer_discounts_all_users($user_key, $player_key, $num_players);    
    }
}

############################################
# Check to see if multiplayer discounts
# Change because a player was removed
############################################
sub remove_all_multiplayer_discounts_after_remove_player{
    my $user_key          = shift;
    my $player_count      = 1;   # Remove all, there should not be any less then 1? 
    my $dbh               = get_dbh();

    ###################################
    # Remove any discounts that require
    # that require more players
    # then the user now has 
    ###################################
    my $query             = "SELECT `Key`, `Description`, `Discount` FROM `Reg_Multi_Player_Discount` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year' AND `Number_Of_Reg_Players` > '$player_count'";
    #my $query             = "SELECT `Key`, `Description`, `Discount` FROM `Reg_Multi_Player_Discount` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year' AND `Number_Of_Reg_Players` = '$player_count_before_remove'";
	#print "QUERY: $query<br>\n";	
	my $sth          = $dbh->prepare($query);
    $sth->execute();
    ############################################
	# Loop through discounts that need to be removed
    # for discountwwhere the min is greater then
    # the current number of players. 
    ############################################
    while (my $hash_ref = $sth->fetchrow_hashref) {
        my $description = $hash_ref->{Description}; 
        my $discount    = $hash_ref->{Discount};
        my $key         = $hash_ref->{Key};
        change_discounts_to_removed_state($user_key, $key);		
		#print "DESC: $description, DIS: $discount<br>\n";
		#insert_adjustment($user_key, $player_key, $discount, $key, -5);  #-5 just means that its a multiplayer discount 
    }
     
	#print "PLAYER COUNT: $player_count<br>\n";
    # disconnect from database
    $sth->finish();
    $dbh->disconnect;
}

############################################
# Look for any discounts that do not 
# meet player requirement and adjust 
# them in db
############################################
sub change_discounts_to_removed_state{
	my $user_key     = shift;
	my $discount_key = shift;		
    my $dbh          = get_dbh();
    ########################################
    # Select items where Discount = the key for that user
    # and the update account is -5 for discount
    ########################################
    my $query        = "SELECT `Key`, `Player_ID`, `Amount` FROM Reg_All_Transaction WHERE `Check_ID` = '$discount_key' AND `Account_ID` = '$user_key' AND `Update_Account_ID` = '-5'";
	#print "QUERY: $query<br>\n";	
	my $sth          = $dbh->prepare($query);
    $sth->execute();
    while (my $hash_ref = $sth->fetchrow_hashref) {
        my $player_id   = $hash_ref->{Player_ID}; 
        my $amount      = $hash_ref->{Amount};
        my $key         = $hash_ref->{Key};
	    my $option_change_amount = 0 - $amount;
		insert_adjustment($user_key, $player_id, $option_change_amount, "MP Discount Removal 3", -2);  #-2 just means that its an Option Change
        update_adjustment_account_to_show_change($key);
    }
    # disconnect from database
    $dbh->disconnect;
    $sth->finish();
}

############################################
# Check to see if multiplayer discounts
# Change because a player was removed
############################################
sub verify_multiplayer_discounts_after_remove_player{
    my $user_key          = shift;
    my $remove_player_key = shift;
    my $player_count      = get_player_count($user_key);
    my $dbh               = get_dbh();

    ###################################
    # Remove any discounts that require
    # that require more players
    # then the user now has 
    ###################################
    my $query             = "SELECT `Key`, `Description`, `Discount` FROM `Reg_Multi_Player_Discount` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year' AND `Number_Of_Reg_Players` > '$player_count'";
    #my $query             = "SELECT `Key`, `Description`, `Discount` FROM `Reg_Multi_Player_Discount` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year' AND `Number_Of_Reg_Players` = '$player_count_before_remove'";
	#print "QUERY: $query<br>\n";	
	my $sth          = $dbh->prepare($query);
    $sth->execute();
    ############################################
	# Loop through discounts that need to be removed
    # for discountwwhere the min is greater then
    # the current number of players. 
    ############################################
    while (my $hash_ref = $sth->fetchrow_hashref) {
        my $description = $hash_ref->{Description}; 
        my $discount    = $hash_ref->{Discount};
        my $key         = $hash_ref->{Key};
        check_for_discounts_that_need_to_be_removed($user_key, $key);		
		#print "DESC: $description, DIS: $discount<br>\n";
		#insert_adjustment($user_key, $player_key, $discount, $key, -5);  #-5 just means that its a multiplayer discount 
    }
     
	#print "PLAYER COUNT: $player_count<br>\n";
    # disconnect from database
    $sth->finish();
    $dbh->disconnect;

    ############################################
	# Check for chance that the removed user
	# was part of an acitve discount and was not
	# the player that was discounted in which
	# case we need to remove on of the discount
	# from another player
    ############################################
    my $dbh2               = get_dbh();
    my $query2             = "SELECT `Key`, `Description`, `Discount` FROM `Reg_Multi_Player_Discount` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year' AND `Number_Of_Reg_Players` <= '$player_count'";
	#print "QUERY: $query2<br>\n";	
	my $sth2          = $dbh2->prepare($query2);
    $sth2->execute();
    ############################################
	# Loop through discounts that need to be removed
    ############################################
    while (my $hash_ref2 = $sth2->fetchrow_hashref) {
        my $description  = $hash_ref2->{Description}; 
        my $discount     = $hash_ref2->{Discount};
        my $key          = $hash_ref2->{Key};

        my ($amount, $player_discount_key) = get_player_discount($remove_player_key, $key);		
        ############################################
		# If there was no multiplayer discount
		# for the removed player, we have to remove
		# a discount for another player of the same
		# user (parent)
        ############################################
		if($player_discount_key == 0){
            remove_first_multi_player_discount($user_key, $key);
		}
		#print "DESC: $description, DIS: $discount<br>\n";
		#insert_adjustment($user_key, $player_key, $discount, $key, -5);  #-5 just means that its a multiplayer discount 
    }
     
	#print "PLAYER COUNT: $player_count<br>\n";
    # disconnect from database
    $sth2->finish();
    $dbh2->disconnect;
}

############################################
# Remove a multiplayer discount to compensate
# for the removed player which should not have
# been discounted
############################################
sub remove_first_multi_player_discount{
	my $user_key     = shift;
	my $discount_key = shift;		
    my %player_info  = get_player_info($user_key);
	my $removed_discount = 0;
    foreach my $user_number (sort {$a <=> $b} (keys %player_info)){
	    if($removed_discount == 0){
            my $player_key          = $player_info{$user_number}{"KEY"};
            my ($amount, $player_discount_key) = get_player_discount($player_key, $discount_key);		
		    if($player_discount_key > 0){
	            my $option_change_amount = 0 - $amount;
		        insert_adjustment($user_key, $player_key, $option_change_amount, "MP Discount Removal 2", -2);  #-2 just means that its an Option Change
                update_adjustment_account_to_show_change($player_discount_key);
	            $removed_discount = 1;
			}

		}
	}
}
############################################
# Get the discount for a speific player
# and discount code
############################################
sub get_player_discount{
    my $player_key   = shift;
    my $discount_key = shift;
    my $dbh          = get_dbh();
    my $query        = "SELECT `Key`, `Amount` FROM Reg_All_Transaction WHERE `Check_ID` = '$discount_key' AND `Update_Account_ID` = '-5' AND `Player_ID` = '$player_key'";
	#print "QUERY: $query<br>\n";	
	my $sth          = $dbh->prepare($query);
    $sth->execute();
	my $amount              = 0;
	my $player_discount_key = 0;
    while (my $hash_ref = $sth->fetchrow_hashref) {
        $amount              = $hash_ref->{Amount};
        $player_discount_key = $hash_ref->{Key};
 
        ##### Not quite sure why this is here.
	    #my $option_change_amount = 0 - $amount;
		#insert_adjustment($user_key, $player_id, $option_change_amount, "ADJUST MP Discount", -2);  #-2 just means that its an Option Change
        #update_adjustment_account_to_show_change($key);
		#insert_adjustment($user_key, $player_key, $discount, $key, -5);  #-5 just means that its a multiplayer discount 
    }
    # disconnect from database
    $dbh->disconnect;
    $sth->finish();
	return $amount, $player_discount_key;
}

############################################
# Look for any discounts that do not 
# meet player requirement and adjust 
# them in db
############################################
sub check_for_discounts_that_need_to_be_removed{
	my $user_key     = shift;
	my $discount_key = shift;		
    my $dbh          = get_dbh();
    ########################################
    # Select items where Discount = the key for that user
    # and the update account is -5 for discount
    ########################################
    my $query        = "SELECT `Key`, `Player_ID`, `Amount` FROM Reg_All_Transaction WHERE `Check_ID` = '$discount_key' AND `Account_ID` = '$user_key' AND `Update_Account_ID` = '-5'";
	#print "QUERY: $query<br>\n";	
	my $sth          = $dbh->prepare($query);
    $sth->execute();
    while (my $hash_ref = $sth->fetchrow_hashref) {
        my $player_id   = $hash_ref->{Player_ID}; 
        my $amount      = $hash_ref->{Amount};
        my $key         = $hash_ref->{Key};
	    my $option_change_amount = 0 - $amount;
		insert_adjustment($user_key, $player_id, $option_change_amount, "MP Discount Removal 1", -2);  #-2 just means that its an Option Change
        update_adjustment_account_to_show_change($key);
		#insert_adjustment($user_key, $player_key, $discount, $key, -5);  #-5 just means that its a multiplayer discount 
    }

    
	#print "PLAYER COUNT: $player_count<br>\n";
    # disconnect from database
    $dbh->disconnect;
    $sth->finish();
}
############################################
# Check for discount for user (parent) 
############################################
sub check_for_multiplayer_discounts{
    my $user_key     = shift;
	my $player_key   = shift;
    my $player_count = get_player_count($user_key);
    my $dbh          = get_dbh();
    my $query        = "SELECT `Key`, `Description`, `Discount` FROM `Reg_Multi_Player_Discount` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year' AND `Number_Of_Reg_Players` <= '$player_count' AND `Max_Reg_Players` >= '$player_count'";
    #print "QUERY: $query<br>\n";	
	my $sth          = $dbh->prepare($query);
    $sth->execute();
    while (my $hash_ref = $sth->fetchrow_hashref) {
        my $description = $hash_ref->{Description}; 
        my $discount    = $hash_ref->{Discount};
        my $key         = $hash_ref->{Key};
		#print "DESC: $description, DIS: $discount<br>\n";
		insert_adjustment($user_key, $player_key, $discount, $key, -5);  #-5 just means that its a multiplayer discount 
    }

    
	#print "PLAYER COUNT: $player_count<br>\n";
    # disconnect from database
    $dbh->disconnect;
    $sth->finish();
}

############################################
# Get number of players per user(parent) 
############################################
sub get_player_count{
    my $user_key     = shift;
    my $dbh = get_dbh();
    my $query = "SELECT COUNT(*) FROM `Reg_Player_Link` WHERE `Account_ID` = '$user_key' AND `Active` = '1' AND `Reg_Year` = '$reg_year'";
	my $sth = $dbh->prepare($query);
	print "QUERY: $query<br>\n";
    $sth->execute();
    my $player_count = $sth->fetchrow_arrayref->[0];

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

}
############################################
# Get player info
############################################
sub get_player_info_old_reg{
    my $user_key     = shift;
    my $old_reg_year  = shift;

    my %return_hash = ();
    my $dbh = get_dbh();
    ################################################################
    # Query DB to verify Session
    ################################################################
    # Do not requre active
    my $query = "SELECT `Key`,`Org_ID`,`Reg_Year`,`Firstname`,`Lastname`,`Account_ID`,`Paid`,`Active`,`Reg_Date`,`Player_Confirmed`,`Assigned_League`,`Assigned_Team` FROM `Reg_Player_Link` WHERE `Account_ID` = '$user_key' AND `Active` = '1' AND `Reg_Year` = '$old_reg_year' ORDER BY `Key`";
    #my $query = "SELECT `Key`,`Org_ID`,`Reg_Year`,`Firstname`,`Lastname`,`Account_ID`,`Paid`,`Active`,`Reg_Date`,`Player_Confirmed`,`Assigned_League`,`Assigned_Team` FROM `Reg_Player_Link` WHERE `Account_ID` = '$user_key' AND `Reg_Year` = '$old_reg_year' ORDER BY `Key`";
    my $sth = $dbh->prepare($query);
    #print "$query<br>\n";
    $sth->execute();

    $sth->bind_columns(\$Key, \$Org_ID, \$Reg_Year, 
                   \$Firstname, \$Lastname, 
                   \$Account_ID, \$Paid,
                   \$Active, \$Reg_Date,
			       \$Player_Confirmed,
			       \$Assigned_League, \$Assigned_Team);
    $user_number = 1;
    while($sth->fetch()) {
        $return_hash{$user_number}{"KEY"}              = $Key;
        $return_hash{$user_number}{"ORG_ID"}           = $Org_ID;
        $return_hash{$user_number}{"REG_YEAR"}         = $Reg_Year;
        $return_hash{$user_number}{"FIRSTNAME"}        = $Firstname;
        $return_hash{$user_number}{"LASTNAME"}         = $Lastname;
        $return_hash{$user_number}{"ACCOUNT_ID"}       = $Account_ID;
        $return_hash{$user_number}{"PAID"}             = $Paid;
        $return_hash{$user_number}{"ACTIVE"}           = $Active;
        $return_hash{$user_number}{"REG_DATE"}         = $Reg_Date;
        $return_hash{$user_number}{"PLAYER_CONFIRMED"} = $Player_Confirmed;
    	$return_hash{$user_number}{"ASSIGNED_LEAGUE"}  = $Assigned_League;
		$return_hash{$user_number}{"ASSIGNED_TEAM"}    = $Assigned_Team;


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

############################################
# Get player info
############################################
sub get_player_info{
    my $user_key    = shift;

    my %return_hash = ();
    my $dbh = get_dbh();
    ################################################################
    # Query DB to verify Session
    ################################################################
    my $query = "SELECT `Key`,`Org_ID`,`Reg_Year`,`Firstname`,`Lastname`,`Account_ID`,`Paid`,`Active`,`Reg_Date`,`Player_Confirmed`,`Assigned_League`,`Assigned_Team` FROM `Reg_Player_Link` WHERE `Account_ID` = '$user_key' AND `Active` = '1' AND `Reg_Year` = '$reg_year' ORDER BY `Key`";
    my $sth = $dbh->prepare($query);
    #print "$query<br>\n";
    $sth->execute();

    $sth->bind_columns(\$Key, \$Org_ID, \$Reg_Year, 
                   \$Firstname, \$Lastname, 
                   \$Account_ID, \$Paid,
                   \$Active, \$Reg_Date,
			       \$Player_Confirmed,
			       \$Assigned_League, \$Assigned_Team);
    $user_number = 1;
    while($sth->fetch()) {
        $return_hash{$user_number}{"KEY"}              = $Key;
        $return_hash{$user_number}{"ORG_ID"}           = $Org_ID;
        $return_hash{$user_number}{"REG_YEAR"}         = $Reg_Year;
        $return_hash{$user_number}{"FIRSTNAME"}        = $Firstname;
        $return_hash{$user_number}{"LASTNAME"}         = $Lastname;
        $return_hash{$user_number}{"ACCOUNT_ID"}       = $Account_ID;
        $return_hash{$user_number}{"PAID"}             = $Paid;
        $return_hash{$user_number}{"ACTIVE"}           = $Active;
        $return_hash{$user_number}{"REG_DATE"}         = $Reg_Date;
        $return_hash{$user_number}{"PLAYER_CONFIRMED"} = $Player_Confirmed;
    	$return_hash{$user_number}{"ASSIGNED_LEAGUE"}  = $Assigned_League;
		$return_hash{$user_number}{"ASSIGNED_TEAM"}    = $Assigned_Team;


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

############################################
# Return html for checkout header
############################################
sub get_checkout_header{
    my $header = shift;
    my $checkout_header = "<table   style='border-collapse:collapse;border:1px solid #8480a2' cellpadding=2 width=500><tr><td colspan=8 id=admin_header><center>$header</center></td></tr>\n";
    $checkout_header   .= "<tr><td id=admin_header align=center>Name</td><td id=admin_header align=center>Fee</td><td id=admin_header align=center>Total</td><td id=admin_header align=center>Paid</td><td id=admin_header align=center>Due</td></tr>\n";
    return $checkout_header;
}

############################################
# Return html for paypal that wont change
############################################
sub get_paypal_const{
	my $pay_pal = "<form name=pay_pal_form id=pay_pal_form action=\"$paypal_url\" method=\"post\" ENCTYPE=\"multipart/form-data\">\n";
    $pay_pal   .= "<input type=\"hidden\" name=\"notify_url\" value=\"$ipn_url\">\n";
    $pay_pal   .= "<input type=\"hidden\" name=\"cmd\" value=\"_cart\">\n";
    $pay_pal   .= "<input type=\"hidden\" name=\"upload\" value=\"1\">\n";
    $pay_pal   .= "<input type=\"hidden\" name=\"custom\" value=\"$transaction_id\">\n";
    $pay_pal   .= "<input type=\"hidden\" name=\"currency_code\" value=\"USD\">\n";
    $pay_pal   .= "<input type=\"hidden\" name=\"business\" value=\"$paypal_acc\">\n";
    $pay_pal   .= "<input type=\"hidden\" name=\"return\" value=\"" . $thanks_url . "\">\n";
	return $pay_pal;
}

sub get_checkout_row_for_player_and_total_due_and_pay_pal{
    my $player_key = shift;
	my $first_name = shift;
	my $last_name  = shift;
	my $style      = shift;
    my $player_row = "";
	my %checkout_hash  = get_fees_table_cell_paypal_string_and_total($player_key, $style);
    $player_row .= "<tr><td id=$style>$first_name $last_name</td>\n";
    $player_row .= $checkout_hash{"FEES_CELL"} . $checkout_hash{"TOTAL_FEE_CELL"} . $checkout_hash{"TOTAL_PAID_CELL"} . $checkout_hash{"TOTAL_DUE_CELL"} . "</tr>";

	#print "A_DUE: $amount_due<br>\n";
	return $player_row, %checkout_hash;
}
			
############################################
# This creates the paypal and html for the checkout table.
############################################
sub get_checkout_table{
    my $user_key          = shift;
    my $by_check          = shift;
    my %user_info         = get_account_info($user_key);
    my %player_info       = get_player_info($user_key);
    my $pay_pal_count     = 1;
    my $num_players       = 0;
    my $total_cost        = 0;
	my $walk_in_fee       = 0;
	my $walk_in_amount    = 25;
	my $adjustment_string = "";
	

    if($by_check == 0){
        $transaction_id = get_transaction_id();
    }
	my $user_table = get_checkout_header("Registered Players");
	my $pay_pal    = get_paypal_const();

    ############################################
    # Loop through players to create the display cell, paypal info and calculate totals
    ############################################    
    foreach my $user_number (sort {$a <=> $b} (keys %player_info)){
            $num_players++;
			my $fees_cell       = "";
			my $total           = 0;
			my $player_total    = 0; # this is just in case there are other adjustments
            my $player_key      = $player_info{$user_number}{"KEY"};
            #my $amount_paid     = $player_info{$user_number}{"PAID"};
			############################################
            # Get the cell with a list of what is due for player, plus the paypal string
            # that gets sent to have an itemized list on pay pal.			
			############################################  
			my ($player_row, %checkout_hash) = get_checkout_row_for_player_and_total_due_and_pay_pal($player_key, $player_info{$user_number}{"FIRSTNAME"}, $player_info{$user_number}{"LASTNAME"}, "cal_events3");
            my $amount_due    = $checkout_hash{"TOTAL_DUE"};
	        my $paypal_string = $checkout_hash{"PAYPAL_STRING"};
	        my $total_paid    = $checkout_hash{"TOTAL_PAID"};

			$user_table .= $player_row;
			
			#$amount_due =  .02;
			############################################
            # Store temporary paypal record.  This will not be valid until the paypal tx is finished.			
			############################################  
            if($by_check == 0){
                insert_tmp_paypal($user_key, $player_key, $amount_due, $transaction_id);
            }
            
			############################################
            # Add player specific paypal info			
			############################################  
            $pay_pal .= "<input type=\"hidden\" name=\"item_name_" . $pay_pal_count . "\" value=\"$player_info{$user_number}{\"FIRSTNAME\"} $player_info{$user_number}{\"LASTNAME\"}  ($paypal_string)\">\n";
            $pay_pal .= "<input type=\"hidden\" name=\"amount_" . $pay_pal_count . "\" value=\"$amount_due\">\n";
            $pay_pal_count++;
					
			############################################
            # Keep running total of amount due for user			
			############################################  
            $total_cost = $amount_due + $total_cost;
            
    }
	############################################
	# Finish user table
	############################################
	$total_cost  = sprintf("%.2f", $total_cost);
    $user_table .= "<tr><td id=cal_events3 colspan=8 align=right><b>TOTAL DUE: \$$total_cost</b></td></tr>\n";
    $user_table .= "</table>\n";
    
    ############################################
	# If its not pay by check, create form for submitting
	############################################
	if($by_check != 1){
        $user_table .= "<form name=partial_form METHOD =\"$method\" ACTION=\"$page_url\" ENCTYPE=\"multipart/form-data\"><input type=hidden name=partial_amount id=partial_amount value=$total_cost >\n";
        $user_table .= "<input type=hidden name=action id=action value=partial>";
        $user_table .= "<input type=hidden name=userkey id=userkey value=$user_key>\n";
        $user_table .= "</form>\n";
    }
    
    ############################################
	# If its not pay by check, give them thier payment options. Notice that
	# this is stored in the pay_pal portion. I think this is becuase it gets 
	# printed to the screen after the others.
	############################################
    $pay_pal .= "<input type='button'  name='revise' value='Revise Order' onClick=\"javascript:document.revise_form.submit();\">\n";
    $pay_pal .= "<input type='button'  name='pay_by_check' value='Pay By Check' onClick=\"javascript:document.pay_by_check_form.submit();\">\n";
	if($min_partial_pay == 0){
        $pay_pal .= "<input type='submit'  name='submit' value='Pay With Credit Card'>\n";
	}else{
        $pay_pal .= "<input type='button'  name='submit' value='Pay With Credit Card' onClick=\"Show();\">\n";
    }
    $pay_pal .= "<div id=\"Popup\" class=\"transparent\"><div style=\"background-color: #686b6e\"><table width=100%><tr><td>&nbsp;</td><td><b><font color=white>Credit Card Payment Options</font></b></td><td align=right><a href=javascript:void(0); onclick=\"Hide();\">x</a></td></tr></table></div>\n";
    $pay_pal .= "<div></b><br><center><input type='submit'  name='submit' value='Pay In Full'> \n";
    $pay_pal .= "<input type='button'  name='submit' value='Pay Partial' onClick=\"javascript:document.partial_form.submit();\"></div></div>\n";
    $pay_pal .= "</form>\n";
	
	############################################
	# If it is pay by check.  Display where to send it.  Stored in var
	############################################
    if($by_check == 1){
	if(($org_id == 167)||($org_id == 13)){ # Plymouth required forms
	    #$user_table .= "<center><a href=print_forms.html?user_key=$user_key target=new><font size=3><b>Print Registration Confirmation and Player Forms</b></a></font></center><br>\n";
	}
        $user_table .= "<table border=0><tr><td style=\"font-size:10pt;color:black;font-family: Arial, Helvetica;\">$pay_by_check_message<br>\n";
        $user_table .= "<form name=pay_by_check_form METHOD =\"$method\" ACTION=\"$home_page_url\" ENCTYPE=\"multipart/form-data\"><input type=hidden name=partial_amount id=partial_amount value=$total_cost >\n";
        #$partial_form = "\n";
        $user_table .= "<input type=hidden name=action id=action value=admin_pay_by_check_complete>";
        $user_table .= "<input type=hidden name=userkey id=userkey value=$user_key>\n";
        $user_table .= "<center><input type=button name=Exit value=Exit onClick=\"javascript:document.pay_by_check_form.submit();\"></center>\n</form>";
    }

    return $user_table, $pay_pal;
}

############################################
# This creates the paypal and html for the partial_checkout table.
############################################
sub get_partial_checkout_table{
    my $user_key                         = shift;
    my $by_check                         = shift;
    my $partial                          = shift;
    my ($total_num_players, $max_total_cost, $player_min) = get_num_players_and_total_cost($user_key);
    my %user_info                        = get_account_info($user_key);
    my %player_info                      = get_player_info($user_key);
    my $pay_pal_count                    = 1;
    my $num_players                      = 0;
    my $total_cost                       = 0;
	my $balance                          = 0;
    $transaction_id                      = get_transaction_id();
    my $user_table = get_checkout_header("Registered Players");  
    my $pay_pal    = get_paypal_const();
	
    ############################################
    # Loop through players to create the display cell, paypal info and calculate totals
    ############################################  
    foreach my $user_number (sort {$a <=> $b} (keys %player_info)){
            $num_players++;
			$player_key  = $player_info{$user_number}{"KEY"};
			
		    ############################################
            # Get the cell with a list of what is due for player, plus the paypal string
            # that gets sent to have an itemized list on pay pal.			
			############################################  
			my ($player_row, %checkout_hash) = get_checkout_row_for_player_and_total_due_and_pay_pal($player_key, $player_info{$user_number}{"FIRSTNAME"}, $player_info{$user_number}{"LASTNAME"}, "cal_events3");
            
			my $amount_due    = $checkout_hash{"TOTAL_DUE"};
	        my $paypal_string = $checkout_hash{"PAYPAL_STRING"};
	        my $total_paid    = $checkout_hash{"TOTAL_PAID"};
			$user_table      .= $player_row;
			
			############################################
            # Calculate what the player owes and fill that cell  Also, do some conversions to
            # two decimal places			
			############################################ 

            $max_pay = $amount_due;
            my $amount_to_deduct = get_amount_to_deduct($partial, ($total_num_players - $num_players + 1), $total_cost, $max_pay, $player_min);

            #$amount_to_deduct = .02;
			############################################
            # Store temporary paypal record.  This will not be valid until the paypal tx is finished.			
			############################################  
            insert_tmp_paypal($user_key, $player_key, $amount_to_deduct, $transaction_id);
			

            $balance = $balance + $amount_due;
			
			############################################
            # Add player specific paypal info			
			############################################  
            $pay_pal .= "<input type=\"hidden\" name=\"item_name_" . $pay_pal_count . "\" value=\"$player_info{$user_number}{\"FIRSTNAME\"} $player_info{$user_number}{\"LASTNAME\"}  ($paypal_string)\">\n";
            $pay_pal .= "<input type=\"hidden\" name=\"amount_" . $pay_pal_count . "\" value=\"$amount_to_deduct\">\n";
            $pay_pal_count++;
			
		    ############################################
            # Keep running total of amount due for user			
			############################################  
            $total_cost = $amount_to_deduct + $total_cost;
    }
	
	############################################
	# Finish user table
	# if by_check equals 2, then we are confirming the payment
	############################################
	$total_remaining  = $balance - $total_cost;
	$total_remaining  = sprintf("%.2f", $total_remaining);
	$balance          = sprintf("%.2f", $balance);
	$total_cost       = sprintf("%.2f", $total_cost);
	if($by_check == 2){
		$user_table .= "<tr><td id=cal_events3 colspan=8 align=right><b>Balance: \$$balance</b></td></tr>\n";
        $user_table .= "<tr><td id=cal_events3 colspan=8 align=right><b>TOTAL REMAINING After Payment: \$$total_remaining</b></td></tr>\n";
	    $user_table .= "<tr><td id=cal_events3 colspan=8 align=center> <form name=partial_form METHOD =\"$method\" ACTION=\"$page_url\" ENCTYPE=\"multipart/form-data\"> <b>Confirm Amount to Pay Now: \$$total_cost</b><br><input type='button'  name='partial_pay' value='Pay Now' onClick=\"javascript:document.pay_pal_form.submit();\"></td></tr>\n";
        $user_table .= "<input type=hidden name=partial_amount id=partial_amount value=$total_cost>\n";
		$this_action = "partial";
	}else{
        $user_table .= "<tr><td id=cal_events3 colspan=8 align=right><b>Balance: \$$balance</b></td></tr>\n";
		$user_table .= "<tr><td id=cal_events3 colspan=8 align=right> <form name=partial_form METHOD =\"$method\" ACTION=\"$page_url\" ENCTYPE=\"multipart/form-data\"> <b>Enter the Partial Amount You Want to Pay: \$<input type=text name=partial_amount id=partial_amount value=\"$total_cost\" size=5></b><input type='button'  name='partial_pay' value='Pay This Amount by Credit Card' onClick=\"javascript:document.partial_form.submit();\"></td></tr>\n";
        $this_action = "verify_partial";
	}
    $user_table .= "<input type=hidden name=action id=action value=$this_action>";
    $user_table .= "<input type=hidden name=userkey id=userkey value=$user_key>\n";
    $user_table .= "</form>\n";
    $user_table .= "</table>\n";
    $pay_pal .= "<input type='button'  name='revise' value='Go Back and Modify Your Registration' onClick=\"javascript:document.revise_form.submit();\">\n";
	if($by_check == 2){
        $pay_pal .= "<input type='button'  name='partial_pay' value='Modify Partial Payment' onClick=\"javascript:document.partial_form.submit();\">\n";
	}else{
       
	}
    $pay_pal .= "</form><br>\n";
    if($by_check == 1){
        $user_table .= "<table border=0><tr><td>$pay_by_check_message\n";
    }

    return $user_table, $pay_pal, $balance;

}

############################################
# Get the Registration values by player
############################################
sub get_reg_values_by_player{
    my $org_id   = shift;
	my $reg_year = shift;
	my $player_id = shift;
	my %return_hash = ();
    my $dbh = get_dbh();
    ################################################################
    # Query DB to verify Session
    ################################################################
    my $query = "SELECT `Key`,`Description_Text`,`Input_Type`,`Selection_Link`,`Validation_Link`,`Required`,`Order` FROM `Reg_Definition` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year';";
    my $sth = $dbh->prepare($query);
    #print "$query<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Key,\$Description_Text,\$Input_Type,\$Selection_Link,\$Validation_Link,\$Required,\$Order);

    while($sth->fetch()) {
        $return_hash{$Key} = get_cell_value($Input_Type,$Key,$player_id);  
    }
    # disconnect from database
    $sth->finish();
    $dbh->disconnect;
	return %return_hash;
}

############################################
# Get value for a cell
############################################
sub get_cell_value{
    my $Input_Type       = shift;
	my $Key              = shift;
	my $player_id        = shift;
	my $return_html = "";
	if($Input_Type == 1){ # HEADER
		$return_html = "<tr><td bgcolor=#cccccc colspan=2>$Description_Text</td></tr>";
	}elsif($Input_Type == 2){ #INPUT
		$input_value = get_input_text($Key, $player_id);
	}elsif($Input_Type == 3){ #Select Dropdown
	    $input_value = get_input_options($Key, $player_id);
	}elsif($Input_Type == 4){ #Date
		$input_value = get_input_date($Key, $player_id);
		$input_value = get_view_date_format($input_value);
	}elsif($Input_Type == 5){ #Radio
		$input_value = get_input_options($Key, $player_id);
	}elsif($Input_Type == 6){ #Textarea
		$input_value = get_input_longtext($Key, $player_id);
	}elsif($Input_Type == 7){ #CheckBox
		$input_value = get_input_checked($Key, $player_id);
		$checked = "";
		if($input_value == 1){
			$checked = "CHECKED";
		}
		$input_value = $checked;
	}elsif($Input_Type == 10){ #Select Dropdown Long value with payment attached
	    $input_value = get_input_options($Key, $player_id);
	}elsif($Input_Type == 11){ #Radio with payment attached
		$input_value = get_input_options($Key, $player_id);
	}
    return $input_value;
}

sub get_input_date{
    my $reg_id      = shift;
    my $player_id   = shift;
	my $input_text  = "";
	my $dbh = get_dbh();
    my $query = "SELECT `Input_Date` FROM Reg_Input_Date WHERE `Reg_ID` = '$reg_id' AND `Player_ID` = '$player_id';";
    #print "QUERY: $query<br>\n";
    
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->bind_columns(\$Input_Date);
   
    while($sth->fetch()) {
        $input_date = $Input_Date;
	}
	$sth->finish();
    $dbh->disconnect;
	return $input_date;
}
sub get_input_longtext{
    my $reg_id      = shift;
    my $player_id   = shift;
	my $input_text  = "";
	my $dbh = get_dbh();
    my $query = "SELECT `Input_Longtext` FROM Reg_Input_Longtext WHERE `Reg_ID` = '$reg_id' AND `Player_ID` = '$player_id';";
    #print "QUERY: $query<br>\n";
    
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->bind_columns(\$Input_Text);
   
    while($sth->fetch()) {
        $input_text = $Input_Text;
	}
	$sth->finish();
    $dbh->disconnect;
	return $input_text;
}
sub get_input_text{
    my $reg_id      = shift;
    my $player_id   = shift;
	my $input_text  = "";
	my $dbh = get_dbh();
    my $query = "SELECT `Input_Text` FROM Reg_Input_Text WHERE `Reg_ID` = '$reg_id' AND `Player_ID` = '$player_id';";
    #print "QUERY: $query<br>\n";
    
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->bind_columns(\$Input_Text);
   
    while($sth->fetch()) {
        $input_text = $Input_Text;
	}
	$sth->finish();
    $dbh->disconnect;
	return $input_text;
}

sub get_input_checked{
    my $reg_id      = shift;
    my $player_id   = shift;
	my $input_value  = "";
	my $dbh = get_dbh();
    my $query = "SELECT `Input_Option` FROM Reg_Input_Options WHERE `Reg_ID` = '$reg_id' AND `Player_ID` = '$player_id';";
    #print "QUERY: $query<br>\n";
    
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->bind_columns(\$Input_Value);
   
    while($sth->fetch()) {
        $input_value = $Input_Value;
	}
	$sth->finish();
    $dbh->disconnect;
	return $input_value;
}
sub get_input_options{
    my $reg_id      = shift;
    my $player_id   = shift;
	my $input_value  = "";
	my $dbh = get_dbh();
    my $query = "SELECT a.`Option` FROM Reg_Options a, Reg_Input_Options b WHERE b.`Reg_ID` = '$reg_id' AND b.`Player_ID` = '$player_id' AND b.`Input_Option` = a.`Key`;";
    #print "QUERY: $query<br>\n";
    
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->bind_columns(\$Input_Value);
   
    while($sth->fetch()) {
        $input_value = $Input_Value;
	}
	$sth->finish();
    $dbh->disconnect;
	return $input_value;
}

###################################
# Get parameter for DB
###################################
sub get_param{
    my $paramter = shift;
    my $value = param($paramter);
    $value =~ s/\'/''/g;
    $value =~ s/\"//g;
    $value =~ s/\>//g;
    $value =~ s/\<//g;
    $value =~ s/\\//g;
    return $value;
}

###################################
# Update Player Name
###################################
sub update_player_name{
    my $player_key = shift; 
	my $first_name = shift;
	my $last_name  = shift;
    my $query = "UPDATE Reg_Player_Link SET `Firstname` = '$first_name', `Lastname` = '$last_name' WHERE `Key` = '$player_key';";
    #print "$query<br>\n";
    my $dbh = get_dbh();
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->finish();
    $dbh->disconnect;
    return $player_key;

}

###################################
# Set Player Active to 0
###################################
sub remove_player{
    my $player_key = shift; 
    my $query = "UPDATE Reg_Player_Link SET `Active` = '0' WHERE `Key` = '$player_key';";
    #print "$query<br>\n";
    my $dbh = get_dbh();
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->finish();
    $dbh->disconnect;
    return $player_key;

}
############################################
# Get how much the player is due for a specific field
############################################
sub get_checkout_override{
    my $option_id   = shift;
	my $player_id   = shift;
    my $checkout_override      = "";
	my $dbh = get_dbh();
    #my $query = "SELECT `Checkout_Override` FROM `Reg_Payment_Definition` WHERE `Option_ID` = '$option_id' ;";
    my $query = "SELECT a.`Checkout_Override` FROM Reg_Payment_Definition a, Reg_Input_Options b WHERE b.`Reg_ID` = '$option_id' AND b.`Player_ID` = '$player_id' AND b.`Input_Option` = a.`Option_ID`;";
 
    #print "QUERY: $query<br>\n";
    
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->bind_columns(\$Checkout_Override);
   
    while($sth->fetch()) {
        $checkout_override = $Checkout_Override;
	}
	$sth->finish();
    $dbh->disconnect;
	return $checkout_override;
}
############################################
# Get how much the player is due for a specific field
############################################
sub get_option_payment_amount{
    my $option_id   = shift;
    my $amount      = 0;
	my $dbh = get_dbh();
    my $query = "SELECT `Amount` FROM `Reg_Payment_Definition` WHERE `Option_ID` = '$option_id' ;";
    #print "QUERY: $query<br>\n";
    
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->bind_columns(\$Amount);
   
    while($sth->fetch()) {
        $amount = $Amount;
	}
	$sth->finish();
    $dbh->disconnect;
	return $amount;
}
################################################################
###  Get params and update DB
################################################################
sub get_player_params_and_update_database{
    my $org_id    = shift;
	my $reg_year  = shift;
	my $player_id = shift;
	my $user_id   = shift;
    my $dbh = get_dbh();

    ################################################################
    # Query DB to verify Session
    ################################################################
    my $query = "SELECT `Key`,`Description_Text`,`Input_Type`,`Selection_Link`,`Validation_Link`,`Required`,`Order` FROM `Reg_Definition` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year';";
    my $sth = $dbh->prepare($query);
    #print "$query<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Key,\$Description_Text,\$Input_Type,\$Selection_Link,\$Validation_Link,\$Required,\$Order);
   
    while($sth->fetch()) {
	    my $reg_id = "REG" . $Key;
		my $required = "";

	    if($Input_Type == 1){ # HEADER
		}elsif($Input_Type == 2){ #INPUT
		    $return_hash{$reg_id} = get_param($reg_id);
			insert_text($Key, $player_id, $return_hash{$reg_id});
		}elsif($Input_Type == 3){ #Select Dropdown
		    $return_hash{$reg_id} = get_param($reg_id);
			insert_option($Key, $player_id, $return_hash{$reg_id});
		}elsif($Input_Type == 4){ #Date
		    my $dob1 = get_param('dob1');
		    my $dob2 = get_param('dob2');
		    my $dob3 = get_param('dob3');
			my $dob  = $dob1 . "/" . $dob2 . "/" . $dob3;
		    $dob = get_db_date_format($dob); 
            $return_hash{$reg_id} = $dob;
			insert_date($Key, $player_id, $return_hash{$reg_id});
		}elsif($Input_Type == 5){ #Radio
            $return_hash{$reg_id} = get_param($reg_id);
			insert_option($Key, $player_id, $return_hash{$reg_id});
		}elsif($Input_Type == 6){ #Textarea
            $return_hash{$reg_id} = get_param($reg_id);		
			insert_longtext($Key, $player_id, $return_hash{$reg_id});
		}elsif($Input_Type == 7){ #CheckBox
		    my $check_box = get_param($reg_id);	
			if($check_box eq "on"){
			   $check_box = 1;
            }else{
               $check_box = 0;
            }
            $return_hash{$reg_id} = $check_box;		
			insert_option($Key, $player_id, $return_hash{$reg_id});
		}elsif($Input_Type == 10){ #Select Dropdown with payment attached
		    $return_hash{$reg_id} = get_param($reg_id);
			insert_option($Key, $player_id, $return_hash{$reg_id});	
			update_adjustment_table_from_input($return_hash{$reg_id}, $user_id, $player_id, $Key);
		}elsif($Input_Type == 11){ #Radio with payment attached
            $return_hash{$reg_id} = get_param($reg_id);
			insert_option($Key, $player_id, $return_hash{$reg_id});
			my $player_amount_due = get_option_payment_amount($return_hash{$reg_id});
			update_adjustment_table_from_input($return_hash{$reg_id}, $user_id, $player_id, $Key);
		}

    }
    # disconnect from database
    $sth->finish();
    $dbh->disconnect;
}
sub update_adjustment_table_from_input{
    my $option_id  = shift;
	my $user_id    = shift;
	my $player_id  = shift;
	my $reg_def_id = shift; # The reg definition id gets inserted as the check id
	my $player_amount_due = get_option_payment_amount($option_id);
	my $update            = check_if_its_an_update_for_that_user($user_id, $reg_def_id, $player_id, $player_amount_due);
	if(($player_amount_due >= 0)&&($update == 1)){ # -1 means no update
	    insert_adjustment($user_id, $player_id, $player_amount_due, $reg_def_id, -1);  #-1 just means that its an auto update and it should get the text for trx from reg definition
    }
}
sub check_if_its_an_update_for_that_user{
    my $user_id        = shift;
    my $reg_def_id     = shift;
	my $player_id      = shift;
	my $new_amount_due = shift;
	my $update         = 1;
	my $dbh        = get_dbh();
    my $query      = "SELECT `Key` , `Account_ID`, `Amount`, `Check_ID`, `Date` FROM Reg_All_Transaction WHERE `Check_ID` = '$reg_def_id' AND `Player_ID` = '$player_id' AND `Update_Account_ID` = '-1'";
    my $sth        = $dbh->prepare($query);
	$sth->execute();
    $sth->bind_columns(\$Key,\$Account_ID,\$Amount,\$Check_ID,\$Date);
    while($sth->fetch()) {
        #$amount = 0 - $Amount;
		$Amount = sprintf("%.2f",$Amount);
		
		$new_amount_due  = sprintf("%.2f",$new_amount_due);
		#print "NEW: $new_amount_due - OLD: $Amount<br>\n";
		#print "NEW: $reg_def_id - OLD: $Check_ID<br>\n";
	    if($new_amount_due != $Amount){
		    my $option_change_amount = 0 - $Amount;
		    insert_adjustment($user_id, $player_id, $option_change_amount, "Option Change", -2);  #-2 just means that its an Option Change
            update_adjustment_account_to_show_change($Key);
		}else{
		    $update = 0;
		}
	}
	$sth->finish();
    $dbh->disconnect;
	return $update;
}

sub update_adjustment_account_to_show_change{
    my $key = shift;
	my $dbh        = get_dbh();
    my $query      = "UPDATE Reg_All_Transaction SET `Update_Account_ID` = '-3' WHERE `Key` = '$key' LIMIT 1";
    my $sth        = $dbh->prepare($query);
	$sth->execute();
	$sth->finish();
    $dbh->disconnect;

}
################################################################
### Update adjustemnt
################################################################
sub insert_adjustment{
    my $user_id        = shift;
	my $player_key     = shift;
	my $amount         = shift;
	my $check_notes    = shift;
	my $update_account = shift;

    #my $update_account = get_player_id_from_cookie();
	my $account_id     = get_account_id_by_player_key($player_key);
	my $date           = get_date_time();
    
	my $query = "INSERT INTO Reg_All_Transaction (`Key` , `Account_ID` , `Player_ID` , `Update_Account_ID`, `Amount`, `Check_ID`, `Date`) VALUES ('', '$user_id', '$player_key', '$update_account', '$amount', '$check_notes', '$date')";
	#print "$query<br>\n";
	my $dbh = get_dbh();
	my $sth = $dbh->prepare($query);
	$sth->execute();
	
    $sth->finish();
	$dbh->disconnect;
	return $player_key;
}

################################################################
#  Get the reg form - READ ONLY
################################################################
sub get_read_only_reg_form{
    my $org_id    = shift;
	my $reg_year  = shift;
	my $form_name = shift;
	my $player_id = shift;
	my %return_hash = ();
    my $dbh = get_dbh();
    ################################################################
    # Query DB to verify Session
    ################################################################
    my $query = "SELECT `Key`,`Description_Text`,`Input_Type`,`Selection_Link`,`Validation_Link`,`Required`,`Order` FROM `Reg_Definition` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year';";
    my $sth = $dbh->prepare($query);
    #print "$query<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Key,\$Description_Text,\$Input_Type,\$Selection_Link,\$Validation_Link,\$Required,\$Order);

    while($sth->fetch()) {
	    my $reg_id = "REG" . $Key;
		my $required = ":";
		#if($Required == 1){
        #    $required = "*";
		#	($return_hash{$Order}{"JSCRIPT_VARS"}, $return_hash{$Order}{"JSCRIPT_COMPARE"}) = get_required_js($Input_Type,$form_name,$reg_id);;
		#}
	    if($Input_Type == 1){ # HEADER
	        $return_hash{$Order}{"HTML"} = "<tr><td bgcolor=#cccccc colspan=2>$Description_Text</td></tr>";
		}elsif($Input_Type == 2){ #INPUT TEXT
		    $input_value = get_input_text($Key, $player_id);
		    $return_hash{$Order}{"HTML"} = "<tr><td align=right>$Description_Text $required</td><td align=left>$input_value</td></tr>";
		}elsif($Input_Type == 3){ #Select Dropdown
		    $input_value = get_input_options($Key, $player_id);
			$return_hash{$Order}{"HTML"}  = "<tr><td align=right>$Description_Text $required</td><td align=left>$input_value</td></tr>";
		}elsif($Input_Type == 4){ #Date
		    $input_value = get_input_date($Key, $player_id);
		    $return_hash{$Order}{"HTML"} = "<tr><td align=right>$Description_Text $required</td><td align=left>$input_value</td></tr>";
		}elsif($Input_Type == 5){ #Radio
		    $input_value = get_input_options($Key, $player_id);
			my $radio_button = "<tr><td align=right>$Description_Text $required</td><td align=left>\n";
			$radio_button .= get_radio_button($Key, $reg_id, $input_value);
			$radio_button .= "</td></tr>";
			$return_hash{$Order}{"HTML"}  = "<tr><td align=right>$Description_Text $required</td><td align=left>$input_value</td></tr>";

		}elsif($Input_Type == 6){ #Textarea
		    $input_value = get_input_longtext($Key, $player_id);
		    $return_hash{$Order}{"HTML"} = "<tr><td align=right>$Description_Text $required</td><td align=left><textarea id='$reg_id' name='$reg_id' rows=$Selection_Link cols=$Validation_Link READONLY>$input_value</textarea></td></tr>";	
		}elsif($Input_Type == 7){ #CheckBox
		    $input_value = get_input_checked($Key, $player_id);
			$checked = "";
			if($input_value == 1){
			    $checked = "CHECKED";
			}
		    $return_hash{$Order}{"HTML"} = "<tr><td align=right>$Description_Text $required</td><td align=left><input type=checkbox id='$reg_id' name='$reg_id' $checked DISABLED></td></tr>";	
		}elsif($Input_Type == 10){ #Select Dropdown Long dropdown and payment attached
		    $input_value = get_input_options($Key, $player_id);
			$return_hash{$Order}{"HTML"}  = "<tr><td align=right >$Description_Text $required</td><td align=left>$input_value</td></tr>";
		}elsif($Input_Type == 11){ #Radio with payment attached
		    $input_value = get_input_options($Key, $player_id);
			my $radio_button = "<tr><td align=right>$Description_Text $required</td><td align=left>\n";
			$radio_button .= get_radio_button($Key, $reg_id, $input_value);
			$radio_button .= "</td></tr>";
			$return_hash{$Order}{"HTML"}  = "<tr><td align=right>$Description_Text $required</td><td align=left>$input_value</td></tr>";
		}
    }
    # disconnect from database
    $sth->finish();
    $dbh->disconnect;
	return %return_hash;
}

################################################################
# This just gets the javascript for required fields
################################################################
sub get_required_js{
    my $Input_Type = shift;
    my $form_name  = shift;
    my $reg_id     = shift;	
	if(($Input_Type == 5)||($Input_Type == 11)){ # 5 is radio, 11 is radio with payment
	    my $radio_check      = "var $reg_id = 0;\n";
            my $reg_length       = $reg_id . "Len";
            $radio_check        .= "var $reg_length =  $form_name" . "." . $reg_id . ".length;\n";
	    $radio_check        .= "var unused = 0;\n";
            $radio_check        .= "if($reg_length == undefined){if(" . $form_name . "." . $reg_id . ".checked){$reg_id = 1}}else{\n";
	    $radio_check        .= "for(i=0;i<document." . $form_name . "." . $reg_id . ".length;i++){\n";
            $radio_check        .= "if(document." . $form_name . "." . $reg_id. "[i].checked){$reg_id = 1;}}}\n";
            
	    $tmp_jscript_vars    = $radio_check;
	    $tmp_jscript_compare = "($reg_id == 0)";
	}else{
        $tmp_jscript_vars    = "var $reg_id      = document.getElementById('$reg_id');\n";
        $tmp_jscript_compare = "($reg_id.value == \"\")";
    }
	return $tmp_jscript_vars, $tmp_jscript_compare;
}

################################################################
###  Get Reg Form with Updates
################################################################
sub get_reg_update_form{
    my $org_id   = shift;
	my $reg_year = shift;
	my $form_name = shift;
	my $player_id = shift;
	my %return_hash = ();
    my $dbh = get_dbh();
    ################################################################
    # Query DB to verify Session
    ################################################################
    my $query = "SELECT `Key`,`Description_Text`,`Input_Type`,`Selection_Link`,`Validation_Link`,`Required`,`Order` FROM `Reg_Definition` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year';";
    my $sth = $dbh->prepare($query);
    #print "$query<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Key,\$Description_Text,\$Input_Type,\$Selection_Link,\$Validation_Link,\$Required,\$Order);

    while($sth->fetch()) {
	    my $reg_id = "REG" . $Key;
		my $required = "";
		if($Required == 1){
            $required = "*";
			($return_hash{$Order}{"JSCRIPT_VARS"}, $return_hash{$Order}{"JSCRIPT_COMPARE"}) = get_required_js($Input_Type,$form_name,$reg_id);;
		}
        $return_hash{$Order}{"HTML"} = get_reg_cell_with_update($Input_Type, $Key, $reg_id, $Description_Text, $required, $player_id);
    }
    # disconnect from database
    $sth->finish();
    $dbh->disconnect;
	return %return_hash;
}

################################################################
###  Primary Reg form radio buttons
################################################################
sub get_radio_button{
    my $reg_key  = shift;
	my $reg_id   = shift;
	my $selected_option = shift;
	if(!(defined($selected_option))){
	    $selected_option = 0;
	}
	#print "SELECTED: $selected_option<br>\n";
	###### Just used Reg Options instead of new table. 
	my $query = "SELECT `Key`,`Option` FROM `Reg_Options` WHERE `Reg_ID` = '$reg_key' ORDER BY `Order`;";
	my $options = "";
	my $dbh = get_dbh();
    my $sth = $dbh->prepare($query);
	my $selected = "";
    #print "$query<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Key,\$Option);

    while($sth->fetch()) {
	    $selected = "";
	    if($selected_option == $Key){
		    $selected = "checked=\"checked\"";
		}
	    $options .= "<input type=\"radio\" name=\"$reg_id\" id=\"$reg_id\" value=\"$Key\" $selected> $Option<br>\n";
	}
	$sth->finish();
    $dbh->disconnect;
    return $options;
}

################################################################
###  Get Options for Reg form Select-Options input
################################################################
sub get_options{
    my $reg_key = shift;
    my $selected_option = shift;
    if(!(defined($selected_option))){
        $selected_option = 0;
    }
    #print "SELECTED OPTION: $selected_option<br>\n";
    
    my $default_value = "";
    if($selected_option == 0){
        $default_value = "       <option value='' SELECTED>&lt;&lt;&lt;Select Value&gt;&gt;&gt;</option>\n";
    }
    my $query = "SELECT `Key`,`Option` FROM `Reg_Options` WHERE `Reg_ID` = '$reg_key' ORDER BY `Order`;";
    my $options = "";
    my $dbh = get_dbh();
    my $sth = $dbh->prepare($query);
    my $selected = "";
    #print "$query<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Key,\$Option);
    $options .= $default_value;
    while($sth->fetch()) {
        $selected = "";
        if($selected_option == $Key){
	    $selected = "SELECTED";
	}
        $options .= "       <option value='$Key' $selected>$Option</option>\n";
	}
	$sth->finish();
    $dbh->disconnect;
    return $options;
}

sub get_account_value{
    my $user_key              = shift;
	my $account_prefill_value = shift;
	my %account_hash          = ();
	my $return_value          = "";
	
    my $dbh = get_dbh();
    ################################################################
    # Query DB to verify Session
    ################################################################
    my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;";
    my $sth = $dbh->prepare($query);
    #print "$query<br>$account_prefill_value<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Firstname, \$Lastname, \$Email, \$Home_Phone, \$Work_Phone, \$Mobile_Phone, \$Zip_Code, \$Address1, \$Address2, \$City, \$State);
    # for the account_prefill
    while($sth->fetch()) {
        $account_hash{"Firstname"}    = $Firstname;
        $account_hash{"Lastname"}     = $Lastname;
        $account_hash{"Email"}        = $Email;
        $account_hash{"Home_Phone"}   = $Home_Phone;
        $account_hash{"Work_Phone"}   = $Work_Phone;
        $account_hash{"Mobile_Phone"} = $Mobile_Phone;
        $account_hash{"Zip_Code"}     = $Zip_Code;
        $account_hash{"Address1"}     = $Address1;
        $account_hash{"Address2"}     = $Address2;
        $account_hash{"City"}         = $City;
        $account_hash{"State"}        = $State;
    }
    # disconnect from database
    $sth->finish();
    $dbh->disconnect;
	$return_value = $account_hash{$account_prefill_value};
	return $return_value;
}

sub get_first_player{
    my $user_key = shift;
    my $org_id   = shift;
    my $reg_year = shift;
    my $dbh = get_dbh();
	my $return_key = 0;
    ################################################################
    # Query DB to verify Session
    ################################################################
    my $query = "SELECT `Key` FROM `Reg_Player_Link` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year' AND `Account_ID` = '$user_key' AND `Active` = '1' ORDER BY `Key`;";
    my $sth = $dbh->prepare($query);
    #print "$query<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Key);
    # for the account_prefill
	my $first_player = 1;
    while($sth->fetch()) {
	    if($first_player == 1){
		    $return_key = $Key;
		}
		$first_player = 0;
    }
    # disconnect from database
    $sth->finish();
    $dbh->disconnect;
    return $return_key;
}
sub get_option_months{
	my $selected_month = shift;
	my @months = ();
	my $i = 0;
#<OPTION value="" SELECTED></OPTION>
    $months[1] = "January";
    $months[2] = "February";
    $months[3] = "March";
    $months[4] = "April";
    $months[5] = "May";
    $months[6] = "June";
    $months[7] = "July";
    $months[8] = "August";
    $months[9] = "September";
    $months[10] = "October";
    $months[11] = "November";
    $months[12] = "December";
	for($i = 1; $i < 13; $i++){
		my $selected = "";
		if($i == $selected_month){
            $selected = "SELECTED";
		}
        $return_options .= "<OPTION value='$i' $selected>$months[$i]</OPTION>";
	}

	return $return_options;
}
sub get_option_days{
	my $selected_day = shift;
	my $i = 0;
	my $return_days = "";
	for($i = 1;$i <= 31; $i++){
		my $selected = "";
		if($i == $selected_day){
            $selected = "SELECTED";
		}
	    $return_days .= "<OPTION value='$i' $selected>$i</OPTION>\n";
    }
	return $return_days;
}
sub get_option_years{
	my $selected_year = shift;
	my $i = 0;
	my $return_years = "";
	my $current_date = get_date_time();
	($current_year, $junk, $junk) = split(/-/,$current_date);
	my $stop_year = $current_year - 100;
    for($i = $current_year;$i > $stop_year; $i--){
		my $selected = "";
		if($i == $selected_year){
            $selected = "SELECTED";
		}
	    $return_years .= "<OPTION value='$i' $selected>$i</OPTION>\n";
	}
	return $return_years;
}
################################################################
###  Primary Reg form
################################################################
sub get_reg_cell{
    my $user_key              = shift;
    my $Input_Type            = shift;
    my $Key                   = shift;
    my $reg_id                = shift;
    my $Description_Text      = shift;
    my $required              = shift;
    my $default_value         = shift;
    my $account_prefill_value = shift; 
    my $player_prefill_value  = shift;
    my $org_id                = shift;
    my $reg_year              = shift;
    my $first_player_id       = get_first_player($user_key, $org_id, $reg_year);
	my $return_html = "";
        #print "ACC PREFILL: $account_prefill_value<br>\n";
        #print "PLAY PREFILL: $player_prefill_value<br>\n";
	if($Input_Type == 1){ # HEADER
	    $return_html = "<tr><td bgcolor=#cccccc colspan=2>$Description_Text</td></tr>";
	}elsif($Input_Type == 2){ #INPUT
	    my $value = "";
	    #######################################
		# Check for defaults
		#######################################
		if($account_prefill_value ne ""){
		    @values = split(/,/,$account_prefill_value);
			my $space = ""; # just because we dont wont a space the first time through
			foreach(@values){
			    $tmp_value = get_account_value($user_key, $_);
				#print "TV: $tmp_value<br>\n";
		        $value = $value . $space . $tmp_value;
				$space = " ";
			}
		}elsif($player_prefill_value != 0){
		    if($first_player_id != 0){
		        $value  = $input_value = get_input_text($Key, $first_player_id);
                        #print "PLAY PREFILL: $player_prefill_value: FP ID: $first_player_id: VAL: $value: $input_value<br>\n";
		    }
		}elsif($default_value ne ""){
		    $value = $default_value;
		}
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left><input type=text id='$reg_id' name='$reg_id' value='$value'></td></tr>";
	}elsif($Input_Type == 3){ #Select Dropdown
	    #######################################
		# Check for defaults
		#######################################
		$input_value = 0;
		if($player_prefill_value != 0){
		    if($first_player_id != 0){
			    $input_value = get_input_checked($Key, $first_player_id);	  
			}
		}elsif($default_value ne ""){
		    $input_value = $default_value;
		}

		my $select = "<tr><td align=right>$Description_Text $required</td><td align=left><select id='$reg_id' name='$reg_id'>";
		$select .= get_options($Key, $input_value);
		$select .= "</select></td></tr>";
		$return_html  = $select;
	}elsif($Input_Type == 4){ #Date
	    my $month_options = get_option_months(0);
	    my $days_options  = get_option_days(0);
	    my $year_options  = get_option_years(0);
	    $return_html = "<tr><td align=right>$Description_Text $required</td><td align=left> ";
	    $return_html .= "<select id='dob1' name='dob1'>";
	    $return_html .= $month_options;
	    $return_html .= "</select>";
	    $return_html .= "<select id='dob2' name='dob2'>";
	    $return_html .= $days_options;
	    $return_html .= "</select>";
	    $return_html .= "<select id='dob3' name='dob3'>";
	    $return_html .= $year_options;
	    $return_html .= "</select>";
	    $return_html .= "</td></tr>\n";
	}elsif($Input_Type == 94){ #Date - Old Calendar Date to update later
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left><input type=text name='$reg_id' id='$reg_id' size=10  onFocus=\"cal1xx.select(document.create_player_account_form." . $reg_id .",'$reg_id','MM/dd/yyyy'); return true;\" onClick=\"cal1xx.select(document.create_player_account_form." . $reg_id .",'$reg_id','MM/dd/yyyy'); return true;\" READONLY><a href=\"\" id=datein2 name=datein2></a> </td></tr>";
	}elsif($Input_Type == 5){ #Radio
	    #######################################
		# Check for defaults
		#######################################
		$input_value = 0;
		if($player_prefill_value != 0){
		    if($first_player_id != 0){
			    $input_value = get_input_checked($Key, $first_player_id);	  
			}
		}elsif($default_value ne ""){
		    $input_value = $default_value;
		}

    	my $radio_button = "<tr><td align=right>$Description_Text $required</td><td align=left>\n";
		$radio_button .= get_radio_button($Key, $reg_id, $input_value);
		$radio_button .= "</td></tr>";
		$return_html = $radio_button;
	}elsif($Input_Type == 6){ #Textarea
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left><textarea id='$reg_id' name='$reg_id' rows=$Selection_Link cols=$Validation_Link></textarea></td></tr>";	
	}elsif($Input_Type == 7){ #CheckBox
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left><input type=checkbox id='$reg_id' name='$reg_id'></td></tr>";	
	}elsif($Input_Type == 10){ # Dropdown with payment and long
		my $select = "<tr><td align=right>$Description_Text $required</td><td align=left><select id='$reg_id' name='$reg_id'>";
		$select .= get_options($Key);
		$select .= "</select></td></tr>";
		$return_html  = $select;	
	}elsif($Input_Type == 11){ #Radio with payment attached
		my $radio_button = "<tr><td align=right>$Description_Text $required</td><td align=left>\n";
		$radio_button .= get_radio_button($Key, $reg_id);
		$radio_button .= "</td></tr>";
		$return_html = $radio_button;
	}
	return $return_html;
}

sub get_old_reg_mapping{
    my $reg_year = shift;
    my %old_reg_mapping;
    ################ New Reg = OLD reg
    $old_reg_mapping{"1118"}{0} = 511; # Date of Birth
    $old_reg_mapping{1120}{0} = 513; # Male/Female
    ################ {New Reg Definition Key} {Old Reg input value} =  {New Reg Input Value}
    $old_reg_mapping{1120}{729} = 1554; # Male  - Need to update options
    $old_reg_mapping{1120}{730} = 1555; # FeMale

    $old_reg_mapping{1123}{0} = 516; # Guardian 1
    $old_reg_mapping{1124}{0} = 517; # Guardian 1 - phone 1
    $old_reg_mapping{1125}{0} = 518; # Guardian 1 - relationship
    $old_reg_mapping{1125}{731} = 1583; # Legal Guardian 1 - relationship
    $old_reg_mapping{1125}{732} = 1582; # Grand parent Guardian 1 - relationship
    $old_reg_mapping{1125}{733} = 1581; # Father Guardian 1 - relationship
    $old_reg_mapping{1125}{734} = 1580; # Mother Guardian 1 - relationship
    $old_reg_mapping{1126}{0} = 519; # Guardian 1 - phone 2 
    $old_reg_mapping{1127}{0} = 520; # Guardian 1 - email

    $old_reg_mapping{1129}{0} = 522; # Guardian 2 
    $old_reg_mapping{1131}{0} = 524; # Guardian 2 - phone 1
    $old_reg_mapping{1130}{0} = 523; # Guardian 2  - relationship
    $old_reg_mapping{1130}{739} = 1589; # Legal Guardian 2  - relationship
    $old_reg_mapping{1130}{740} = 1588; # Grand parent Guardian 2  - relationship
    $old_reg_mapping{1130}{741} = 1587; # Father Guardian 2  - relationship
    $old_reg_mapping{1130}{742} = 1586; # Mother Guardian 2  - relationship
    $old_reg_mapping{1132}{0} = 525; # Guardian 2  - phone 2 
    $old_reg_mapping{1133}{0} = 526; # Guardian 2  - email


    $old_reg_mapping{1136}{0} = 529; # emergency 2 
    $old_reg_mapping{1138}{0} = 531; # emergency 2 - phone 1
    $old_reg_mapping{1137}{0} = 530; # emergency 2  - relationship
    $old_reg_mapping{1137}{735} = 1595; # Legal emergency 2  - relationship
    $old_reg_mapping{1137}{736} = 1594; # Grand parent emergency 2  - relationship
    $old_reg_mapping{1137}{737} = 1593; # Father emergency 2  - relationship
    $old_reg_mapping{1137}{738} = 1592; # Mother emergency 2  - relationship
    $old_reg_mapping{1139}{0} = 532; # emergency 2  - phone 2 

    $old_reg_mapping{1140}{0} = 533; # Medical History 
    $old_reg_mapping{1143}{0} = 537; # Additional Player Info 

    return %old_reg_mapping;
}

################################################################
###  Primary Reg form
################################################################
sub get_reg_cell_with_old_reg_prefill{
    my $user_key              = shift;
    my $Input_Type            = shift;
    my $Key                   = shift;
    my $reg_id                = shift;
    my $Description_Text      = shift;
    my $required              = shift;
    my $default_value         = shift;
    my $account_prefill_value = shift; 
    my $player_prefill_value  = shift;
    my $org_id                = shift;
    my $reg_year              = shift;
    my $old_reg_year          = shift;
    my $old_player_key        = shift;
    my %old_reg_mapping       = get_old_reg_mapping($reg_year);
    my $first_player_id       = get_first_player($user_key, $org_id, $reg_year);
    my $old_reg_prefill       = 0;
    if(defined($old_reg_mapping{$Key}{0})){$old_reg_prefill = $old_reg_mapping{$Key}{0};}
    #print "ORP:$Key $reg_id $old_reg_prefill<br>\n";
	my $return_html = "";
        #print "ACC PREFILL: $account_prefill_value<br>\n";
        #print "PLAY PREFILL: $player_prefill_value<br>\n";
	if($Input_Type == 1){ # HEADER
	    $return_html = "<tr><td bgcolor=#cccccc colspan=2>$Description_Text</td></tr>";
	}elsif($Input_Type == 2){ #INPUT
	    my $value = "";
	    #######################################
		# Check for defaults
		#######################################
		if($account_prefill_value ne ""){
		    @values = split(/,/,$account_prefill_value);
			my $space = ""; # just because we dont wont a space the first time through
			foreach(@values){
			    $tmp_value = get_account_value($user_key, $_);
				#print "TV: $tmp_value<br>\n";
		        $value = $value . $space . $tmp_value;
				$space = " ";
			}
		}elsif($player_prefill_value != 0){
		    if($first_player_id != 0){
		        $value  = $input_value = get_input_text($Key, $first_player_id);
                        #print "PLAY PREFILL: $player_prefill_value: FP ID: $first_player_id: VAL: $value: $input_value<br>\n";
		    }
		}elsif($default_value ne ""){
		    $value = $default_value;
		}
                if($old_reg_prefill != 0){
		    $value  = $input_value = get_input_text($old_reg_prefill, $old_player_key);
                }
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left><input type=text id='$reg_id' name='$reg_id' value='$value'></td></tr>";
	}elsif($Input_Type == 3){ #Select Dropdown
	    #######################################
		# Check for defaults
		#######################################
		$input_value = 0;
		if($player_prefill_value != 0){
		    if($first_player_id != 0){
			    $input_value = get_input_checked($Key, $first_player_id);	  
			}
		}elsif($default_value ne ""){
		    $input_value = $default_value;
		}
                if($old_reg_prefill != 0){
	            $input_value = get_input_checked($old_reg_prefill, $old_player_key);	  
                    $input_value = $old_reg_mapping{$Key}{$input_value};
                    #print "OLD REG: $old_reg_prefill - $old_player_key - $input_value<br>\n";
                }

		my $select = "<tr><td align=right>$Description_Text $required</td><td align=left><select id='$reg_id' name='$reg_id'>";
		$select .= get_options($Key, $input_value);
		$select .= "</select></td></tr>";
		$return_html  = $select;
	}elsif($Input_Type == 4){ #Date
            my $start_month = 0;
            my $start_day   = 0;
            my $start_year  = 0;
            if($old_reg_prefill != 0){
		my $input_value = get_input_date($old_reg_prefill, $old_player_key);
                #print "$old_reg_prefill $old_player_key: $input_value<br>\n";
		($start_month, $start_day, $start_year) = get_month_day_year($input_value);
            }
            
	    my $month_options = get_option_months($start_month);
	    my $days_options  = get_option_days($start_day);
	    my $year_options  = get_option_years($start_year);
	    $return_html = "<tr><td align=right>$Description_Text $required</td><td align=left> ";
	    $return_html .= "<select id='dob1' name='dob1'>";
	    $return_html .= $month_options;
	    $return_html .= "</select>";
	    $return_html .= "<select id='dob2' name='dob2'>";
	    $return_html .= $days_options;
	    $return_html .= "</select>";
	    $return_html .= "<select id='dob3' name='dob3'>";
	    $return_html .= $year_options;
	    $return_html .= "</select>";
	    $return_html .= "</td></tr>\n";
	}elsif($Input_Type == 94){ #Date - Old Calendar Date to update later
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left><input type=text name='$reg_id' id='$reg_id' size=10  onFocus=\"cal1xx.select(document.create_player_account_form." . $reg_id .",'$reg_id','MM/dd/yyyy'); return true;\" onClick=\"cal1xx.select(document.create_player_account_form." . $reg_id .",'$reg_id','MM/dd/yyyy'); return true;\" READONLY><a href=\"\" id=datein2 name=datein2></a> </td></tr>";
	}elsif($Input_Type == 5){ #Radio
	    #######################################
		# Check for defaults
		#######################################
		$input_value = 0;
		if($player_prefill_value != 0){
		    if($first_player_id != 0){
			    $input_value = get_input_checked($Key, $first_player_id);	  
			}
		}elsif($default_value ne ""){
		    $input_value = $default_value;
		}
                if($old_reg_prefill != 0){
	            $input_value = get_input_checked($old_reg_prefill, $old_player_key);	  
                    $input_value = $old_reg_mapping{$Key}{$input_value};
                    #print "OLD REG: $old_reg_prefill - $old_player_key - $input_value<br>\n";
                }

    	my $radio_button = "<tr><td align=right>$Description_Text $required</td><td align=left>\n";
		$radio_button .= get_radio_button($Key, $reg_id, $input_value);
		$radio_button .= "</td></tr>";
		$return_html = $radio_button;
	}elsif($Input_Type == 6){ #Textarea
                my $text_area_value = "";
                if($old_reg_prefill != 0){
		    $text_area_value = get_input_longtext($old_reg_prefill, $old_player_key);
                }
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left><textarea id='$reg_id' name='$reg_id' rows=$Selection_Link cols=$Validation_Link>$text_area_value</textarea></td></tr>";	
	}elsif($Input_Type == 7){ #CheckBox
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left><input type=checkbox id='$reg_id' name='$reg_id'></td></tr>";	
	}elsif($Input_Type == 10){ # Dropdown with payment and long
		my $select = "<tr><td align=right>$Description_Text $required</td><td align=left><select id='$reg_id' name='$reg_id'>";
		$select .= get_options($Key);
		$select .= "</select></td></tr>";
		$return_html  = $select;	
	}elsif($Input_Type == 11){ #Radio with payment attached
		my $radio_button = "<tr><td align=right>$Description_Text $required</td><td align=left>\n";
		$radio_button .= get_radio_button($Key, $reg_id);
		$radio_button .= "</td></tr>";
		$return_html = $radio_button;
	}
	return $return_html;
}

################################################################
###  Get registration form
################################################################
sub get_reg_form_with_old_reg_prefill{
    my $org_id   = shift;
    my $reg_year       = shift;
    my $form_name      = shift;
    my $user_key       = shift;
    my $old_reg_year   = shift;
    my $old_reg_player = shift;
    my %return_hash    = ();
    my $dbh            = get_dbh();

    ################################################################
    # Query DB to verify Session
    ################################################################
    my $query = "SELECT `Key`,`Description_Text`,`Input_Type`,`Selection_Link`,`Validation_Link`,`Required`,`Default_Value`, `Account_Prefill_Value`, `Player_Prefill_Value`, `Order` FROM `Reg_Definition` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year';";
    my $sth = $dbh->prepare($query);
    #print "$query<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Key,\$Description_Text,\$Input_Type,\$Selection_Link,\$Validation_Link,\$Required, \$Default_Value, \$Account_Prefill_Value, \$Player_Prefill_Value, \$Order);

    while($sth->fetch()) {
        my $reg_id = "REG" . $Key;
	my $required = "";
	if($Required == 1){
            $required = "*";
            ($return_hash{$Order}{"JSCRIPT_VARS"}, $return_hash{$Order}{"JSCRIPT_COMPARE"}) = get_required_js($Input_Type,$form_name,$reg_id);;
	}
        $return_hash{$Order}{"HTML"} = get_reg_cell_with_old_reg_prefill($user_key, $Input_Type, $Key, $reg_id, $Description_Text, $required, $Default_Value, $Account_Prefill_Value, $Player_Prefill_Value, $org_id, $reg_year, $old_reg_year, $old_reg_player);
    }
    # disconnect from database
    $sth->finish();
    $dbh->disconnect;
    return %return_hash;
}

################################################################
###  Get registration form
################################################################
sub get_reg_form{
    my $org_id   = shift;
	my $reg_year = shift;
	my $form_name = shift;
	my $user_key  = shift;
	my %return_hash = ();
    my $dbh = get_dbh();
    ################################################################
    # Query DB to verify Session
    ################################################################
    my $query = "SELECT `Key`,`Description_Text`,`Input_Type`,`Selection_Link`,`Validation_Link`,`Required`,`Default_Value`, `Account_Prefill_Value`, `Player_Prefill_Value`, `Order` FROM `Reg_Definition` WHERE `Org_ID` = '$org_id' AND `Reg_Year` = '$reg_year';";
    my $sth = $dbh->prepare($query);
    #print "$query<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Key,\$Description_Text,\$Input_Type,\$Selection_Link,\$Validation_Link,\$Required, \$Default_Value, \$Account_Prefill_Value, \$Player_Prefill_Value, \$Order);

    while($sth->fetch()) {
	    my $reg_id = "REG" . $Key;
		my $required = "";
		if($Required == 1){
            $required = "*";
			($return_hash{$Order}{"JSCRIPT_VARS"}, $return_hash{$Order}{"JSCRIPT_COMPARE"}) = get_required_js($Input_Type,$form_name,$reg_id);;
		}
        $return_hash{$Order}{"HTML"} = get_reg_cell($user_key, $Input_Type, $Key, $reg_id, $Description_Text, $required, $Default_Value, $Account_Prefill_Value, $Player_Prefill_Value, $org_id, $reg_year);
    }
    # disconnect from database
    $sth->finish();
    $dbh->disconnect;
	return %return_hash;
}

################################################################
###  Get registration cells with values included
################################################################
sub get_reg_cell_with_update{
    my $Input_Type       = shift;
	my $Key              = shift;
	my $reg_id           = shift;
	my $Description_Text = shift;
	my $required         = shift;
	my $player_id        = shift;
	my $return_html = "";
	if($Input_Type == 1){ # HEADER
		$return_html = "<tr><td bgcolor=#cccccc colspan=2>$Description_Text</td></tr>";
	}elsif($Input_Type == 2){ #INPUT
		$input_value = get_input_text($Key, $player_id);
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left><input type=text id='$reg_id' name='$reg_id' value='$input_value'></td></tr>";
	}elsif($Input_Type == 3){ #Select Dropdown
		$input_value = get_input_checked($Key, $player_id);
		my $select = "<tr><td align=right>$Description_Text $required</td><td align=left><select id='$reg_id' name='$reg_id'>";
		$select .= get_options($Key, $input_value);
		$select .= "</select></td></tr>";
		$return_html  = $select;
	}elsif($Input_Type == 4){ #Date
		$input_value = get_input_date($Key, $player_id);
		my($month, $day, $year) = get_month_day_year($input_value);
	    my $month_options = get_option_months($month);
	    my $days_options  = get_option_days($day);
	    my $year_options  = get_option_years($year);
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left> ";
		$return_html .= "<select id='dob1' name='dob1'>";
		$return_html .= $month_options;
		$return_html .= "</select>";
		$return_html .= "<select id='dob2' name='dob2'>";
		$return_html .= $days_options;
		$return_html .= "</select>";
		$return_html .= "<select id='dob3' name='dob3'>";
		$return_html .= $year_options;
		$return_html .= "</select>";
		$return_html .= "</td></tr>\n";
	}elsif($Input_Type == 94){ #Date
		$input_value = get_input_date($Key, $player_id);
		$input_value = get_view_date_format($input_value);
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left><input type=text name='$reg_id' id='$reg_id' size=10 value='$input_value' onClick=\"cal1xx.select(document.create_player_account_form." . $reg_id .",'$reg_id','MM/dd/yyyy'); return true;\" READONLY><a href=\"\" id=datein2 name=datein2></a> </td></tr>";
	}elsif($Input_Type == 5){ #Radio
		$input_value = get_input_checked($Key, $player_id);
		my $radio_button = "<tr><td align=right>$Description_Text $required</td><td align=left>\n";
		$radio_button .= get_radio_button($Key, $reg_id, $input_value);
		$radio_button .= "</td></tr>";
		$return_html = $radio_button;
	}elsif($Input_Type == 6){ #Textarea
		$input_value = get_input_longtext($Key, $player_id);
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left><textarea id='$reg_id' name='$reg_id' rows=$Selection_Link cols=$Validation_Link>$input_value</textarea></td></tr>";	
	}elsif($Input_Type == 7){ #CheckBox
		$input_value = get_input_checked($Key, $player_id);
		$checked = "";
		if($input_value == 1){
			$checked = "CHECKED";
		}
		$return_html = "<tr><td align=right>$Description_Text $required</td><td align=left><input type=checkbox id='$reg_id' name='$reg_id' $checked></td></tr>";	
	}elsif($Input_Type == 10){ #Select Dropdown with  payment attached
		$input_value = get_input_checked($Key, $player_id);
		my $select = "<tr><td align=right>$Description_Text $required</td><td align=left><select id='$reg_id' name='$reg_id'>";
		$select .= get_options($Key, $input_value);
		$select .= "</select></td></tr>";
		$return_html  = $select;
	}elsif($Input_Type == 11){ #Radio with payment attached
		$input_value = get_input_checked($Key, $player_id);
		my $radio_button = "<tr><td align=right>$Description_Text $required</td><td align=left>\n";
		$radio_button .= get_radio_button($Key, $reg_id, $input_value);
		$radio_button .= "</td></tr>";
		$return_html = $radio_button;
	}
    return $return_html;
}
################################################################
### Create new player in db
################################################################
sub create_new_player{
    my $org_id   = shift;
	my $reg_year = shift;
    my $user_key = param("userkey");
	my $first_name = get_param('fname');
	my $last_name  = get_param('lname');
	my %return_hash = ();
	my $player_id = link_new_player($user_key, $first_name, $last_name);
    get_player_params_and_update_database($org_id, $reg_year, $player_id, $user_key);
	return $player_id;
}

################################################################
### Covert the date to use in database
################################################################
sub get_db_date_format{
    my $date = shift;
    my($month, $day, $year) = split(/\//,$date);
    $date = "$year-$month-$day";
    return $date;
}

################################################################
### Create the date to viewable format
################################################################
sub get_view_date_format{
    my $date = shift;
    my($year, $month, $day) = split(/-/,$date);
    $date = "$month/$day/$year";
    return $date;
}
################################################################
### Create the date to viewable format
################################################################
sub get_month_day_year{
    my $date = shift;
    my($year, $month, $day) = split(/-/,$date);
    return $month,$day,$year;
}

#########################################
# Insert item to the Reg_Input_Longtext table
#########################################
sub insert_longtext{
    my $reg_id        = shift;
    my $player_id     = shift;
	my $insert_lt   = shift;
    my $query = "REPLACE INTO Reg_Input_Longtext (`Reg_ID`,`Player_ID`, `Input_Longtext`) VALUES ('$reg_id', '$player_id', '$insert_lt');";
    #print "QUERY: $query<br>\n";
    my $dbh = get_dbh();
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->finish();
    $dbh->disconnect;
	return $user_id;
}

#########################################
# Insert item to the Reg_Input_Date table
#########################################
sub insert_date{
    my $reg_id        = shift;
    my $player_id     = shift;
	my $insert_date   = shift;
    my $query = "REPLACE INTO Reg_Input_Date (`Reg_ID`,`Player_ID`, `Input_Date`) VALUES ('$reg_id', '$player_id', '$insert_date');";
    #print "QUERY: $query<br>\n";
    my $dbh = get_dbh();
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->finish();
    $dbh->disconnect;
	return $user_id;
}

#########################################
# Insert item to insert_option table
#########################################
sub insert_option{
    my $reg_id        = shift;
    my $player_id     = shift;
	my $insert_option = shift;
    my $query = "REPLACE INTO Reg_Input_Options (`Reg_ID`,`Player_ID`, `Input_Option`) VALUES ('$reg_id', '$player_id', '$insert_option');";
    #print "QUERY: $query<br>\n";
    my $dbh = get_dbh();
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->finish();
    $dbh->disconnect;
	return $user_id;
}

#########################################
# Insert item to the Reg_Input_Text table
#########################################
sub insert_text{
    my $reg_id      = shift;
    my $player_id   = shift;
	my $insert_text = shift;
    my $query = "REPLACE INTO Reg_Input_Text (`Reg_ID`,`Player_ID`, `Input_Text`) VALUES ('$reg_id', '$player_id', '$insert_text');";
    #print "QUERY: $query<br>\n";
    my $dbh = get_dbh();
    my $sth = $dbh->prepare($query);
    $sth->execute();
    $sth->finish();
    $dbh->disconnect;
	return $user_id;
}

#########################################
# Link a player to account in the Reg_player_link table
#########################################
sub link_new_player{
    my $user_key = shift;
	my $first_name = shift;
	my $last_name  = shift;
	my $reg_date   = get_date_time();
    my $query = "INSERT INTO Reg_Player_Link (`Key`, `Org_ID`, `Reg_Year`, `Account_ID`, `Firstname`, `Lastname`, `Active`, `Reg_Date`, `Player_Confirmed`,`Assigned_League`,`Assigned_Team`) VALUES ('', '$org_id', '$reg_year', '$user_key','$first_name','$last_name', '1', '$reg_date', '0','0','0');";
    #print "QUERY: $query<br>\n";
    my $dbh = get_dbh();
    my $sth = $dbh->prepare($query);
    $sth->execute();
    #########################################
    # Get the ID of the just inserted event
    #########################################
    my $query2 = "SELECT LAST_INSERT_ID( );";
    $sth = $dbh->prepare($query2);
    $sth->execute();
    # assign fields to variables
    $sth->bind_columns(\$last_insert_id);

    while($sth->fetch()) {
        $user_id = $last_insert_id;
    }
    #print "$query<br>\n";
    $sth->finish();
    $dbh->disconnect;
	return $user_id;
}

#########################################
# Gets Temp password for email
#########################################
sub get_tmp_pw{
    #my $tmp_pw = "123test";
    my $tmp_pw = generate_random_string_pw(6);
    return $tmp_pw;
}

#########################################
# Generates random string for temp password
#########################################
sub generate_random_string_pw{
    $length = shift;
    $rand_string = "";
    $possible = '23456789';
    while (length($rand_string) < $length) {
        $rand_string .= substr($possible, (int(rand(length($possible)))), 1);
    } 
    return $rand_string;

}

#########################################
# Generates random string for temp token
#########################################
sub get_tmp_string{
    #my $tmp_string = "123test";
    my $tmp_string = generate_random_string(20);
    my $random_string_exists = get_email_by_x($tmp_string);
    my $count = 1;
    while($random_string_exists ne ""){
        $random_string_exists = get_email_by_x($tmp_string);
        $count++;
        if($count > 10){
            $random_string_exists = "";
        }
    }
    return $tmp_string;
}

#########################################
# Check if tmp password is correct
#########################################
sub check_tmp_password{
    my $email        = shift;
    my $pw           = shift;
    my $tmp_string   = shift;
    my $tmp_pw       = 0;
    my $valid_tmp_pw = 0;

    my $dbh = get_dbh();
    my $query = "SELECT `Key`, `Tmp_Password` FROM `Account_TMP_Password` WHERE  `Email` = '$email' AND `Tmp_String` = '$tmp_string';";
    my $sth = $dbh->prepare($query);
	#print "$query<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Key, \$Tmp_Password);

    while($sth->fetch()) {
        $tmp_pw = $Tmp_Password;
        $key    = $Key;
    }
    if($tmp_pw eq $pw){
        $valid_tmp_pw = 1;
    }else{
        if($tmp_pw == 0){
            $valid_tmp_pw = 2;
        }
    }
    $sth->finish();
    $dbh->disconnect;
    return $valid_tmp_pw;
}

#########################################
# Check if tmp password exist
#########################################
sub check_tmp_password_exist{
    my $email        = shift;
    my $valid_tmp_string = "";

    my $dbh = get_dbh();
    my $query = "SELECT `Tmp_String`, `Tmp_Password` FROM `Account_TMP_Password` WHERE  `Email` = '$email';";
    my $sth = $dbh->prepare($query);
    #print "$query<br>\n";
    $sth->execute();
    $sth->bind_columns(\$Tmp_String, \$Tmp_Password);

    while($sth->fetch()) {
        $valid_tmp_string = $Tmp_String;
        $tmp_password     = $Tmp_Password;
    }
    $sth->finish();
    $dbh->disconnect;
    return $valid_tmp_string, $tmp_password;
}

#########################################
# Set the account tmp password
#########################################
sub set_account_tmp_password{
    my $email        = shift;
    my $tmp_string   = "";
    my $pw           = "";
    my $date_time    = "";
    $date_time       = get_date_time();


    ($tmp_string, $pw)     = check_tmp_password_exist($email);
    #print "TS: $tmp_string - PW: $pw<br>\n";
    if($tmp_string eq ""){
        $pw          = get_tmp_pw();
        $tmp_string  = get_tmp_string();
        
    
        my $dbh = get_dbh();

        my $query = "INSERT INTO `Account_TMP_Password` ( `Key` , `Email` , `Tmp_Password` , `Tmp_String` , `Date`) VALUES ('', '$email', '$pw', '$tmp_string', '$date_time');";
        #print "QUERY: $query<br>\n";
		my $sth = $dbh->prepare($query);
        $sth->execute();
        $sth->finish();
        $dbh->disconnect;
    }
    return $pw, $tmp_string, $date_time;
}

#########################################
# Send temp password to users
#########################################
sub send_tmppw{
    my $email       = shift;;
    my $sendmail    = "/bin/sendmail.localhost -t";
    #my $reply_to    = "Reply-to: jeremy\@hometeamz.com";
    my $subject     = "Account Password for $org_full_name_for_email Registration";
    my $to          = "$email";
    #my $to          = "jeremymclean\@gmail.com";
    #my $from        = "jeremy\@hometeamz.com";
    

    
    my ($pw, $tmp_string, $date_time) = set_account_tmp_password($email);
	#print "PASS: $pw<br>\n"
    my $found_email = 0;
    if($pw ne ""){
        $found_email = 1;
        my %user_info = get_account_info_by_email($email);
        $content = "Welcome,<br><br> \n\nThank you for registering with $org_full_name_for_email<br><br>\n\n";
        $content .= "Please use the temporary password provided below to validate your new account.<br><br>\n";
        $content .= "Your temporary password is: $pw<br>\nYour login is: $email<br><br>\n\n";
        $content .= "To proceed directly to the account verification window, please follow this <a href=$base_reg_url?x=$tmp_string&action=tmppw>link</a>\n";
        $content .= "\n";
   
       #print "HEY<br>\n";
        open(SENDMAIL, "|$sendmail -f $from") or die "Cannot open $sendmail: $!";
        print SENDMAIL "To: $to\n"; 
        #print SENDMAIL "bcc: $bcc\n";
        print SENDMAIL "Subject: $subject\n";
        print SENDMAIL "Content-type: text/html\n\n";
        print SENDMAIL $content;
        close(SENDMAIL);
        
    }
	#print "$to $pw $from $content<br>\n";
    
    return $found_email, $tmp_string;
}

#########################################
# Set the account password to user
#########################################
sub send_pw{
    my $email       = param('email');
    my $sendmail    = "/bin/sendmail.localhost -t";
    my $subject     = "Password Reminder for $org_full_name_for_email";
    my $to          = "$email";
    #my $to          = "jeremymclean\@gmail.com";
    #my $from        = "jeremy\@hometeamz.com";
    my $pw          = get_pw_by_email($email);
    
    my $found_email = 0;
    if($pw eq ""){
        #print "PW2: $pw<br>\n";
    }else{
            #print "PW: $pw<br>\n";
            $found_email = 1;
            my %user_info = get_account_info_by_email($email);
            $content = "Hello $user_info{\"FIRSTNAME\"} $user_info{\"LASTNAME\"},\n\n";
            $content .= "You have requested a password reminder from $org_full_name_for_email.\n\n";
            $content .= "Your information is:\nLogin: $user_info{\"EMAIL\"}\nPassword: $pw \n";
   
            open(SENDMAIL, "|$sendmail -f $from") or die "Cannot open $sendmail: $!";
            print SENDMAIL "To: $to\n"; 
            print SENDMAIL "bcc: $bcc\n";
            print SENDMAIL "Subject: $subject\n";
            print SENDMAIL "Content-type: text/plain\n\n";
            print SENDMAIL $content;
            close(SENDMAIL);
        #print $content;
    }
    
    return $found_email;
}

################################################################
### This section prints the stylesheet as well as some 
### Javascript functions 
################################################################
sub print_style2{
    $league_only          = shift;
    $menu_text_color      = "#ffffff";
    $menu_bg_color        = "#999999";
    $menu_border_color    = "#ffffff";
    $menu_head_text_color = "#ffffff";
    $menu_head_bg_color   = "#686b6e";
    $menu_padding         = "2";
    #$menu_color_hover     = "#ffffff";
    #$menu_color_hover     = "yellow";
    $menu_color_hover     = "#ffffff";
    $menu_bg_color_hover  = "#686b6e";
    $bare_domain          = $hometeamz_url;
    $bare_domain          = "hometeamzonline.com";
    $bare_domain          =~ s/www\.//;
    if($league_only == 1){
        $bg_url               = "";
    }else{
        $bg_url               = "$teamdata/hometeamz/bg_right3.gif";
    }
    
    #$style_sheet = "$lib/ht.css";
print <<__HTML__;



<!--<LINK href="$style_sheet" rel="stylesheet" type="text/css">-->
<!-- Below Styles contain vars for   sheet -->
<style>

.ht-text {
    font-family: verdana, arial, tahoma, sans-serif; 
    font-size: 9px; 
}

#top_image {
    margin-top:5px;
}
H1 {
font-size:24px;
           color:white;
           margin-top:0px;
           margin-bottom:-15px;
           font-style: italic ;
           text-shadow: black 3px 3px 5px;

 }
#leftbar{
width: 165px;
/*background-color: white;*/
}

#leftbar a:hover{
/*color: #FF8000;*/
}

.categorylinks{
    padding       : 0; 
    margin-left   : 0px; 
    margin-right  : auto; 
    margin-top    : 0px; 
    margin-bottom : 0px
}

.categorylinks li{
    padding-bottom : 1px;
}

.categorylinks li a{
    margin-left     : 0px;
    padding         : 0px 0px;
    font-size       : 12px;
    display         : block;
    color           : #449805;
    text-decoration : none;
    font-weight     : bold;
    border-bottom   : 0px solid #ececec;
}
.categorylinks li ul {
    position : absolute;
    left     : 149px; /* Set 1px less than menu width */
    top      : 0;
    display  : none;
    }
.categorylinks a:visited{color: #449805; }
.categorylinks a:hover {    color: #fff;    background: #51B906; text-decoration: none;}

.categorylinks2 ul {
    margin        : 0;
    padding       : 0;
    list-style    : none;
    width         : 150px;
    border-bottom : 1px solid #ccc;
    }

.categorylinks2 ul li {
    position : relative;
    }

.categorylinks2 li ul {
    position     : absolute;
    left         : 149px;
    top          : 0;
    display      : none;
    color        : blue;
    }


.categorylinks2 ul li a {
    position        : relative;
    display         : block;
    text-decoration : none;
    color           : $menu_text_color;
    background      : $menu_bg_color;
    padding         : $menu_padding;
    border          : 1px solid $menu_border_color;
    border-bottom   : 0;
    font-weight     : bold;
    padding-left    : 10;
    }
.categorylinks2 ul li.menu_header a {
    position        : relative;
    display         : block;
    text-decoration : none;
    color           : $menu_head_text_color;
    background      : $menu_head_bg_color;
    padding         : $menu_padding;
    border          : 1px solid $menu_border_color;
    border-bottom   : 0;
    cursor          :default;
    font-weight     : bold;
    }

.categorylinks2 ul li a:hover { color: $menu_color_hover; background: $menu_bg_color_hover;}
.categorylinks2 ul li.menu_header a:hover { background: $menu_head_bg_color;color: $menu_head_text_color;}



/* Fix IE. Hide from IE Mac \*/
* html .categorylinks2 ul li { float: left; height: 1%; }
* html .categorylinks2 ul li a { height: 1%; }
/* End */

.categorylinks2 li:hover ul, li.over ul { 
    display: block; 
}


.input
    {  
        font-size: 12px;
        font-family: tahoma, arial, sans-serif;
        color: #000000;
        border: 1px solid #000000;
     }
.form_font
    {  
        font-size: 12px;
        font-family: tahoma, arial, sans-serif;
        color: #000000;
     }
.form_header
    {  
        font-size: 14px;
        font-family: tahoma, arial, sans-serif;
        color: #FFFFFF;
     }
.rc_header
    {  
        font             : 10pt Tahoma;
        font-weight      : bold; 
        color            : #ffffff;
        padding          : 2px 0px 2px 2px;
        color            : #FFFFFF;
     }
.rc_header a
    {  
        text-decoration : none; 
        color: #FFFFFF;
        }
.rc_header a:hover
        {
        color: red;
        }

#cp_font{
               
                font             : 10pt Arial,Helvetica;
}
#cp_font a:link{
               
                font             : 10pt Arial,Helvetica;
                 
}
#cp_font a:hover{
               text-decoration : none; 
               color           : red;
}
#cp_font a:visited{
                font             : 10pt Arial,Helvetica;
}
#cp_font a:active{
                font             : 10pt Arial,Helvetica;
}

#table_font{
               
                font             : 9pt Arial,Helvetica;
}
#table_font a:link{
               
                font             : 9pt Arial,Helvetica;
                 
}
#table_font a:hover{
               text-decoration : none; 
                font             : 9pt Arial,Helvetica;
}
#table_font a:visited{
             
                font             : 9pt Arial,Helvetica;
}
#table_font a:active{
             
                font             : 9pt Arial,Helvetica;
}

#login_font{
               
                font             : 8pt Arial,Helvetica;
                padding          : 0;
                
}
#login_font a:link{
               
                font             : 8pt Arial,Helvetica;
                 
}
#login_font a:hover{
               text-decoration : none; 
                font             : 8pt Arial,Helvetica;
}
#login_font a:visited{
             
                font             : 8pt Arial,Helvetica;
}
#login_font a:active{
             
                font             : 8pt Arial,Helvetica;
}


#day_of_week_header {
            background-color: gray;
            color           : #FFFFFF; 
            font-weight     : bold; 
            border          : 1px solid black;
            font            : 8pt Tahoma bold;
            }
#day_of_week_header2 {
            color           : #000000; 
            border          : 1px solid black;
            font            : 8pt Arial;
            }
#date_header {
            background-color: #006699;
            color           : #FFFFFF; 
            font-weight     : bold; 
            font            : 10pt Arial bold;
}
#date_header a {
            color           : #FFFFFF; 
            font-weight     : bold; 
            font            : 10pt Arial bold;
}
#date_header a:hover {
            text-decoration : none; 
}
#admin_header {
            background-color: #006699;
            color           : #FFFFFF; 
            font-weight     : bold; 
            font            : 10pt Arial bold;
            border          : 1px solid #FFFFFF; 
}


#middle2 a {

            font-size       : 12pt; 
}


#middle a {

            font-size       : 8pt; 
}
#cal_events_head {
            background-color: #c1c1c1;
            color           : #000000; 
            font            : 8pt Arial;
            border          : 1px solid #dcdcdc; 
            margin          : 5px 5px 5px 5px;
            line-height     : 18px;
}
#cal_events3 {
            background-color: #ececec;
            color           : #000000; 
            font            : 8pt Arial;
            border          : 1px solid #dcdcdc; 
            margin          : 5px 5px 5px 5px;
            line-height     : 18px;
}
#cal_events3_red {
            background-color: red;
            color           : #000000; 
            font            : 8pt Arial;
            border          : 1px solid #dcdcdc; 
            margin          : 5px 5px 5px 5px;
            line-height     : 18px;
}
#cal_events3_red a{
            font            : 8pt Arial;
            color           : #0000ff; 
            text-decoration : none; 
}
#cal_events3 a{
            font            : 8pt Arial;
            color           : #0000ff; 
            text-decoration : none; 
}
#cal_events3 a:hover{
            font            : 8pt Arial;
            text-decoration : underline; 
            color           : red; 
}
#update_menu {
            color           : #000000; 
            font            : 8pt Arial;
}
#update_menu a{
            font            : 8pt Arial;
            color           : #0000ff; 
            text-decoration : none; 
}
#update_menu a:hover{
            font            : 8pt Arial;
            text-decoration : underline; 
            color           : red; 
}
#cal_events3_st {
            background-color: #ececec;
            color           : #000000; 
            font            : 8pt Arial;
            border          : 1px solid #dcdcdc; 
            margin          : 5px 5px 5px 5px;
            line-height     : 18px;
            text-decoration : line-through; 

}
#cal_events3_st a{
            font            : 8pt Arial;
            color           : #000000; 
}
#cal_events3_st a:hover{
            font            : 8pt Arial;
            text-decoration : underline; 
            color           : red; 
}
#cal_events2 {
            background-color: white;
            color           : #000000; 
            font            : 8pt Arial;
            border          : 1px solid #dcdcdc; 
            margin          : 5px 5px 5px 5px;
            line-height     : 18px;
}
#cal_events2 a{
            font            : 8pt Arial;
            color           : #0000ff; 
            text-decoration : none; 
}
#cal_events2 a:hover{
            font            : 8pt Arial;
            text-decoration : underline; 
            color           : red; 
}
#cal_events2_st {
            background-color: white;
            color           : #000000; 
            font            : 8pt Arial;
            border          : 1px solid #dcdcdc; 
            margin          : 5px 5px 5px 5px;
            line-height     : 18px;
            text-decoration : line-through; 
}
#cal_events2_st a{
            font            : 8pt Arial;
            color           : #000000; 
}
#cal_events2_st a:hover{
            font            : 8pt Arial;
            text-decoration : underline; 
            color           : red; 
}
#cal_events_st {
            background-color: white;
            color           : #000000; 
            font            : 8pt Arial;
            text-decoration : line-through; 
}
#cal_events_st a{
            font            : 8pt Arial;
            color           : #000000; 
}
#cal_events_st a:hover{
            font            : 8pt Arial;
            text-decoration : underline; 
            color           : red; 
}
#cal_events {
            background-color: white;
            color           : #000000; 
            font            : 8pt Arial;
}
#cal_events a{
            font            : 8pt Arial;
            color           : #000000; 
}
#cal_events a:hover{
            font            : 8pt Arial;
            text-decoration : underline; 
            color           : red; 
}

#top_lower {
            position         : absolute;
            width            : 983px;
            height           : 1px;
            top              : 146px;
            left             : 1px;
            z-index          : 3;
            font-size        : 1pt; 
            font-weight      : bold; 
            background-color : #bb8c00;
            color              : #FFFFFF;
}

#top_left_image2 {
            position        : absolute;
            width           : 122px;
            height          : 122px;
            top             : 17px;
            left            : 5px;
            z-index         : 4;
            font-size       : 1pt; 
            font-weight     : bold; 
                  background      : transparent;
                  border          : 0px;

}
#top_menu2 {
            position        : absolute;
            width           : 671px;
            height          : 30px;
            top             : 148px;
            left            : 153px;
            background-color: #E2E2E2;;
            z-index         : -1;
            font            : 8pt Tahoma;
            background-image: url('$teamdata/hometeamz/gn_bg.gif');
            background-repeat: repeat-x;

            color       : #000000;
}
#top_menu2 a 
            {background      : transparent;
             
             text-decoration : none; 
             font            : 11pt Tahoma;
             color           : #525252;
}
#top_menu2 a:hover
            {color            : red;
             text-decoration  : underline;        
}
#top_menu2 a:visited
            {background      : transparent;
}
#top_menu2 a:active
            {background      : transparent;
}

#top_menu {
            position        : absolute;
            width           : 671px;
            height          : 30px;
            top             : 148px;
            left            : 153px;
            background-color: #E2E2E2;;
            z-index         : 3;
            font            : 11pt Tahoma;
            background-image: url('$teamdata/hometeamz/gn_bg.gif');
            background-repeat: repeat-x;

            color       : #000000;
}

#top_menu a 
            {background      : transparent;
             
             text-decoration : none; 
             font            : 8pt Tahoma;
             color           : #525252;
}
#top_menu a:hover
            {color            : red;
             text-decoration  : underline;        
}
#top_menu a:visited
            {background      : transparent;
}
#top_menu a:active
            {background      : transparent;
}

#top_menu a.coach 
            {background      : transparent;
             width           : 80px;
             text-decoration : none; 
             
            
}

.more_top_menu{
            font            : 8pt Tahoma;
            z-index         : 3;
}
.more_top_menu2{
            font            : 8pt Tahoma;
            z-index         : 3;
}


#rightborder {
            position        : absolute;
            width           : 25px;
            height          : 981px;
            top             : 0px;
            left            : 978px;
            background-color: #000000;
            z-index         : 1;
            font-size       : 1pt; 
            background      : #000000;
            color       : #000000;
}
#top_left {
            position        : absolute;
            width           : 152px;
            height          : 132px;
            top             : 0px;
            left            : 0px;
            background-color: #FFFFFF;
            z-index         : 1;
            font-size       : 12pt; 
            font-weight     : bold; 
            background      : #FFFFFF;
            color       : #003366;
            border-top      : 1px solid #FFFFFF;
            border-left     : 1px solid #FFFFFF;
            border-right    : 1px solid #FFFFFF;
}



#calendar {
            font             : 8pt Tahoma;
            color        : #000000;
}
#calendar_small {
            font             : 8pt Tahoma;
            color        : #000000;
            border           : 1px solid black;
}

#cal_header a
            {background      : transparent;
         color       : #FFFFFF;
             font-size       : 100%;
             text-decoration : none; 
}
#cal_header
            {
             font            : 9pt Arial;
}
.menu_space{
                background-color: #FFFFFF;
                font-size       : 1px;
                width           : 150;
                height          : 1px;
                overflow-y      : hidden;
}
.menu_space_black{
                background-color: #000000;
                font            : 12pt Tahoma;
                width           : 150;
                height          : 20px;
                overflow-y      : hidden;
                color           : #FFFFFF;
                border-right    : 3px solid #686b6e;
                border-left     : 3px solid #686b6e;
                border-top      : 3px solid #686b6e;
                border-left     : 3px solid #686b6e;
}
#table_header_font{
               
                font             : 9pt Arial,Helvetica;
                color            : #ffffff;
            
}

.header{
                background-color: #686b6e;
                width           : 150;
            font             : 10pt Tahoma;
            font-weight      : bold; 
                color           : #ffffff;
             padding         : 2px 0px 2px 2px;
             margin-bottom:1px;
            
}
#title_link{
            font             : 8pt Tahoma;
            font-weight      : bold; 
            color        : #003366;
            border-left      : 1px solid #FFFFFF;
            border-right     : 1px solid #FFFFFF;
            border-bottom    : 1px solid #FFFFFF;
            border-top       : 1px solid #FFFFFF;
}
#add_link{
            color            : #000000;
            font             : 9pt Arial;
 
}
#add_link a{
            border           : solid;
            border-width     : 1px;
            border-color     : #000000;
            text-decoration  : none; 
            background-color : #999999;
            color            : #ffffff;
            font             : 9pt Arial;
            padding          : 3px 3px 3px 3px;
}
#add_link a:visited{
            border           : solid;
            border-width     : 1px;
            background-color : #999999;
            text-decoration  : none; 
            color            : #ffffff;
            font             : 9pt Arial;
}
#add_link a:hover{
            border           : solid;
            background-color : #686b6e;
            color            : #ffffff;
            border-width     : 1px;
            font             : 9pt Arial;
}
#box{
            color            : #ffffff;
            font             : 9pt Arial;
 
}
#box a{
            border           : solid;
            border-width     : 1px;
            text-decoration  : none; 
            color            : #ffffff;
            font             : 9pt Arial;
            padding          : 1px 1px 1px 1px;
}
#box a:visited{
            border           : solid;
            border-width     : 1px;
            text-decoration  : none; 
            color            : #ffffff;
            font             : 9pt Arial;
}
#box a:hover{
            border           : solid;
            border-width     : 1px;
            color            : red;
            font             : 9pt Arial;
}

.message_text{
                font            : 10pt Arial;
                font-weight     : bold; 
                color           : #dc0000;
}

.message_text3{
                font            : 12pt Arial;
                font-weight     : bold; 
                color           : #003366;
}
.message_text2{
                font            : 8pt Arial;
                font-weight     : bold; 
                color           : #000000;
}
.message_text2 a:link, .message_text2 a:visited {
                font-weight     : normal;
                font-size       : 18pt; 
                color           : blue;
                text-decoration : underline; 
}
.message_text2 a:hover{
                text-decoration : none; 
}

.del_text{
                font            : 10pt Arial;
                font-weight     : bold; 
                color           : #000000;
}
#middle2 {
            position        : absolute;
            top             : 47px;
            height          : 100%;
            left            : 0px;
            width           : 671px;
            background-color: $site_info{"bg_color"};
            z-index         : 1;
            font-size       : 10pt; 
            font-weight     : bold; 
            font            : 16pt Tahoma;
            color       : #003366;
            border-bottom   : 1px solid #cccccc;
            border-left     : 1px solid #cccccc;
            border-right    : 1px solid #cccccc;
            
}

#middle {
            position        : absolute;
            top             : 147px;
            height          : 100%;
            left            : 152px;
            width           : 673px;
            background-color: $site_info{"bg_color"};
            z-index         : 1;
            font-size       : 10pt; 
            font-weight     : bold; 
            font            : 16pt Tahoma;
            color       : #003366;
            border-bottom   : 1px solid #cccccc;
            border-left     : 1px solid #cccccc;
            border-right    : 1px solid #cccccc;
            
}
#middle_iframe {
            width           : 673px;
            background-color: $site_info{"bg_color"};
            
}
#loginbar {
            position         : absolute;
            width            : 984px;
            height           : 17px;
            top              : 0px;
            left             : 0px;
            z-index          : 99;
            border           : 0;
            background-color : #FFFFFF;
            color            : #000000;
           
}
#top {
            position         : absolute;
            width            : 984px;
            height           : 129px;
            top              : 17px;
            left             : 0px;
            z-index          : 1;
            font-size        : 12pt; 
            font-weight      : bold; 
            font             : 16pt Tahoma;
                  background-color : $site_info{"site_banner_bg"};
            color              : #FFFFFF;
           
}
#top_left_image {
            position         : absolute;
            width            : 158px;
            height           : 129px;
            top              : 17px;
            left             : 0px;
            z-index          : 3;
            font-size        : 1pt; 
            font-weight      : bold; 
            background-color : $site_info{"site_banner_bg"};
            border           : 0px;
            color              : #FFFFFF;
}


body {
            /*background-color: #E2E2E2;*/
            background-color: $site_info{"bg_color"};
            background-image: url('$bg_url');
            background-repeat: repeat-y;
            background-position: 982px;
}
#rightcolumn {
            position        : absolute;
            width           : 157px;
            height          : 100%;
            top             : 147px;
            left            : 827px;
            background-color: $site_info{"bg_color"};
            z-index         : 2;
            /*border-right    : 1px solid #ffffff;*/
            border-top      : 1px solid #FFFFFF;
            font-size       : 12pt; 
            font-weight     : bold; 
            font            : 16pt Tahoma;
            color       : #FFFFFF;

}
#leftcolumn {
            position         : absolute;
            width            : 152px;
            height           : 100%;
            top              : 147px;
            left             : 0px;
            background-color : $site_info{"bg_color"};
            color        : #ffffff;
            z-index          : 4;
            font             : 8pt Tahoma;
            font-weight      : bold; 
            border-left      : 1px solid #FFFFFF;
            /*border-right     : 1px solid #FFFFFF;*/
            /*border-bottom    : 1px solid #FFFFFF;*/
}

#leftcolumn a.img_link 
            {background-color : $site_info{"bg_color"};
             text-decoration : none; 
             width           : 150;
             padding         : 0px 0px 0px 0px;
}
#leftcolumn a.img_link:hover
            {background-color : $site_info{"bg_color"};
             text-decoration : none; 
             width           : 150;
             padding         : 0px 0px 0px 0px;
}
#leftcolumn a.ht_link 
            {background-color : $site_info{"bg_color"};
             text-decoration : none; 
             width           : 150;
             padding         : 0px 0px 0px 0px;
             font-family     :verdana;
             font-size       :80%;
             color           : #404040;
             margin-bottom   :-1px;
             background-color:6699cc;
}
#leftcolumn a.ht_link:hover
            {background-color : $site_info{"bg_color"};
             text-decoration : none; 
             width           : 150;
             padding         : 0px 0px 0px 0px;
             font-family     :verdana;
             font-size       :80%;
             color           : #404040;
             margin-bottom   :-1px;
             background-color:6699cc;
}
</style>

<script>
function filterTeam(){

           var team   = document.getElementById('filter_team').value; 
           var league = document.getElementById('league_id').value; 
           var month  = document.getElementById('month').value; 
           var year   = document.getElementById('year').value; 
           var coach  = document.getElementById('coach').value; 
           if(coach == 1){
               var url    = "http://$base_url/$filename?org_id=$org_id&page=league&league_id=" + league + "&sub=calendar&" + "month=" + month + "&year=" + year + "&filter=" + team + "&coach=" + coach;
           }else{
               var url    = "http://$base_url/$filename?org_id=$org_id&page=league&league_id=" + league + "&sub=calendar&" + "month=" + month + "&year=" + year + "&filter=" + team;
           }
           location.href = url; 
           //alert(url); 


}

function Set_Cookie( name, value, expires, path, domain, secure ) 
{
domain = "$bare_domain";
    //alert("SETTING COOKIE");
// set time, it's in milliseconds
    var today = new Date();
    today.setTime( today.getTime() );

/*
    if the expires variable is set, make the correct 
    expires time, the current script below will set 
    it for x number of days, to make it for hours, 
    delete * 24, for minutes, delete * 60 * 24
*/
    if ( expires )
    {
        //expires = expires * 1000 * 60 * 60 * 24;
       // This should make it 20 minutes
        expires = (expires * 1000 * 60 * 60)/3 ;
    }
    var expires_date = new Date( today.getTime() + (expires) );
    // alert("name:" + name + " value:" + value + " expires:" + expires + " path:" + path + " domain:" + domain);
    document.cookie = name + "=" +escape( value ) +
    ( ( expires ) ? ";expires=" + expires_date.toGMTString() : "" ) + 
    ( ( path ) ? ";path=" + path : "" ) + 
    ( ( domain ) ? ";domain=" + domain : "" ) +
    ( ( secure ) ? ";secure" : "" );
}

// this function gets the cookie, if it exists
function Get_Cookie( name ) {
    
var start = document.cookie.indexOf( name + "=" );
var len = start + name.length + 1;
if ( ( !start ) &&
( name != document.cookie.substring( 0, name.length ) ) )
{
return null;
}
if ( start == -1 ) return null;
var end = document.cookie.indexOf( ";", len );
if ( end == -1 ) end = document.cookie.length;
return unescape( document.cookie.substring( len, end ) );
}

function Delete_Cookie() {
   var name = "SID";
   var path = '/';
   domain = "$bare_domain";
if ( Get_Cookie( name ) ) document.cookie = name + "=" +
( ( path ) ? ";path=" + path : "") +
( ( domain ) ? ";domain=" + domain : "" ) +
";expires=Thu, 01-Jan-1970 00:00:01 GMT";
}

function ReadCookie(cookieName) {
    var theCookie=""+document.cookie;
    //alert(theCookie);
    var ind=theCookie.indexOf(cookieName);
    if (ind==-1 || cookieName=="") return ""; 
    var ind1=theCookie.indexOf(';',ind);
    if (ind1==-1) ind1=theCookie.length; 
    return unescape(theCookie.substring(ind+cookieName.length+1,ind1));
}

function open_login(orgID, leagueID) {
    var _x = 300;
    var _y = 200;
    login=window.open('$lib/login.pl?org_id=' + orgID + '&league_id=' + leagueID, 'login', 'width=250,height=390,left=' + _x + ',top=' + _y);
    return true;
}

function open_new_event(orgID, leagueID) {
    var _x = 300;
    var _y = 200;
    new_event=window.open('$lib/insert_event.pl?org_id=' + orgID + '&league_id=' + leagueID, 'new_event', 'width=700,height=700,left=' + _x + ',top=' + _y);
    return true;
}

function open_new_event2(orgID, leagueID, teamID) {
    var _x = 300;
    var _y = 200;
    new_event=window.open('$lib/insert_event.pl?org_id=' + orgID + '&league_id=' + leagueID + '&team_id=' + teamID, 'new_event', 'width=700,height=700,left=' + _x + ',top=' + _y);
    return true;
}

function open_new_news(orgID, leagueID) {
    var _x = 300;
    var _y = 200;
    new_event=window.open('$lib/insert_news.pl?org_id=' + orgID + '&league_id=' + leagueID, 'new_event', 'width=650,height=250,left=' + _x + ',top=' + _y);
    return true;
}
function open_edit_event(ID, orgID, leagueID) {
    var _x = 300;
    var _y = 200;
    //new_event=window.open('$lib/update_event.pl?ID=' + ID + '&org_id=' + orgID + '&league_id=' + leagueID, 'new_event', 'width=300,height=425,left=' + _x + ',top=' + _y);
    edit_event=window.open('$lib/insert_event.pl?ID=' + ID + '&org_id=' + orgID + '&league_id=' + leagueID, 'new_event', 'width=700,height=700,left=' + _x + ',top=' + _y);
    return true;
}
function open_edit_event2(ID, orgID, leagueID, teamID) {
    var _x = 300;
    var _y = 200;
    //new_event=window.open('$lib/update_event.pl?ID=' + ID + '&org_id=' + orgID + '&league_id=' + leagueID, 'new_event', 'width=300,height=425,left=' + _x + ',top=' + _y);
    edit_event=window.open('$lib/insert_event.pl?ID=' + ID + '&org_id=' + orgID + '&league_id=' + leagueID + '&team_id=' + teamID, 'new_event', 'width=700,height=700,left=' + _x + ',top=' + _y);
    return true;
}
function open_del_event(ID, orgID, leagueID) {
    var _x = 300;
    var _y = 200;
    del_event=window.open('$lib/del_confirm.pl?ID=' + ID + '&org_id=' + orgID + '&league_id=' + leagueID, 'del_event', 'width=250,height=250,left=' + _x + ',top=' + _y);
}
function open_cancel_event(ID, orgID) {
    var _x = 300;
    var _y = 200;
    del_event=window.open('$lib/cancel_confirm.pl?ID=' + ID + '&org_id=' + orgID, 'del_event', 'width=250,height=290,left=' + _x + ',top=' + _y);
}

function open_update_score(ID,orgID) {
    var _x = 300;
    var _y = 200;
    del_event=window.open('$lib/update_score.pl?ID=' + ID + '&org_id=' + orgID, 'update_score', 'width=350,height=300,left=' + _x + ',top=' + _y);
}

function open_del_news(ID, leagueID, orgID){
    var _x = 300;
    var _y = 200;
   del_event=window.open('$lib/del_news.pl?ID=' + ID + '&league_id=' + leagueID + '&org_id=' + orgID, 'del_news', 'width=250,height=250,left=' + _x + ',top=' + _y);
}

function open_edit_news(ID, leagueID, orgID){
    var _x = 300;
    var _y = 200;
    edit_event=window.open('$lib/update_news.pl?ID=' + ID + '&league_id=' + leagueID + '&org_id=' + orgID, 'update_news', 'width=650,height=250,left=' + _x + ',top=' + _y);
    //return true;
}
function open_new_info(filename, orgID, leagueID, page, infoID, height, width, page_type) {
    var _x = 300;
    var _y = 200;
    new_event=window.open('$lib/' + filename + '?org_id=' + orgID + '&league_id=' + leagueID + '&page=' + page + '&info_id=' + infoID + '&page_type=' + page_type, 'new_info', 'resizable=1,scrollbars=1,width=' + width +',height=' + height + ',left=' + _x + ',top=' + _y);
    //return true;
}
function open_del_info(messageID, pageID, org_id){
    var _x = 300;
    var _y = 200;
   del_event=window.open('$lib/del_info.pl?message_id=' + messageID + '&page_id=' + pageID + '&org_id=' + org_id, 'del_info', 'width=250,height=250,left=' + _x + ',top=' + _y);
}

function open_edit_info(messageID, org_id){
    var _x = 300;
    var _y = 200;
    edit_event=window.open('$lib/update_info.pl?message_id=' + messageID + '&org_id=' + org_id, 'update_info', 'resizable=1,scrollbars=1,width=780,height=500,left=' + _x + ',top=' + _y);
    //return true;
}

var hide=1;

function hideDiv(which) { 
    var this_hideshow = 'notes' + which;
    var other_hideshow = 'show_notes' + which;
    if (hide == 0){
        if (document.getElementById) { // DOM3 = IE5, NS6 
            document.getElementById(this_hideshow).style.display = 'none'; 
            document.getElementById(other_hideshow).style.display = 'block'; 
        } else { 
            if (document.layers) { // Netscape 4 
                document.this_hideshow.display = 'none'; 
                document.other_hideshow.display = 'block'; 
            } else { // IE 4 
                document.all.this_hideshow.style.display = 'none'; 
                document.all.other_hideshow.style.display = 'block'; 
            } 
        } 
    
        hide=1;
    } else{
        if (document.getElementById) { // DOM3 = IE5, NS6 
            document.getElementById(this_hideshow).style.display = 'block'; 
            document.getElementById(other_hideshow).style.display = 'none'; 
        } else { 
            if (document.layers) { // Netscape 4 
                document.this_hideshow.display = 'block'; 
                document.other_hideshow.display = 'none'; 
            } else { // IE 4 
                document.all.this_hideshow.style.display = 'block'; 
                document.all.other_hideshow.style.display = 'none'; 
            } 
        } 
        hide=0;
    } 
}
  

function showDiv(which) { 
    var this_hideshow = 'notes' + which;
    alert(this_hideshow);
    if (document.getElementById) { // DOM3 = IE5, NS6 
        document.getElementById(this_hideshow).style.display = 'block'; 
    } else { 
        if (document.layers) { // Netscape 4 
            document.this_hideshow.display = 'block'; 
        } else { // IE 4 
            document.all.this_hideshow.style.display = 'block'; 
        } 
    } 
} 


function hideControl(which) { 
    var this_hideshow = 'control' + which;
    //alert(this_hideshow);
        if (document.getElementById) { // DOM3 = IE5, NS6 
            document.getElementById(this_hideshow).style.display = 'none';  
        } else { 
            if (document.layers) { // Netscape 4 
                document.this_hideshow.display = 'none';  
            } else { // IE 4 
                document.all.this_hideshow.style.display = 'none'; 
            } 
        } 
} 


function showControl(which) { 
    var this_hideshow = 'control' + which;
    //alert(this_hideshow);
    if (document.getElementById) { // DOM3 = IE5, NS6 
        document.getElementById(this_hideshow).style.display = 'block'; 
    } else { 
        if (document.layers) { // Netscape 4 
            document.this_hideshow.display = 'block'; 
        } else { // IE 4 
            document.all.this_hideshow.style.display = 'block'; 
        } 
    } 
} 

function changeControl(which){
    //alert(which);
    for( var i=1;i<6;i++){
        if(i != which){
            hideControl(i);
        }
    }
    showControl(which);
}
</script>


__HTML__

add_to_hit_counter($org_id);
}

################################################################
### This  prints the left hand column
################################################################
sub print_reg_info{
    
    print "<DIV id='leftcolumn'>\n";
    print_text_info_box("Registration", "$welcome_text");
    
    #print_text_info_box("Program", "Baseball &<br>Softball");
    print_text_info_box("Season", "$season_text");
    #print_text_info_box("Registration Fees", "Baseball - \$145<br>Early Bird discount. Register by Dec 15 and get \$25 off registration.");
    print_text_info_box("Information", "$information_text");
    #print_text_info_box("About Homteamz", "Hometeamz.com provides online league services for community sports programs.<br><a href=http://hometeamz.com target=new>More Info</a>");
    print <<__HTML__;




<div class="categorylinks2">
<ul  id="nav">
</ul>
</div>
__HTML__
    print "</div>\n";
    
 
}

################################################################
###  These are the text boxes on the left side
################################################################
sub print_text_info_box{
    my $title        = shift;
    my $text         = shift;
    my $font_size    = "10pt";
    my $font_color   = "black";
    my $text_align   = "center";
    my $header_color = "#686b6e";
    #my $header_color = "#666699";
    my $body_color   = "#ffffff";
    print <<__HTML__;
    <TABLE cellSpacing=1 cellPadding=0 width="150" bgColor=$header_color border=0>
  <TR>
    <TD vAlign=center align=center width="100%" bgColor=$header_color class=rc_header>
       <B>$title</B>  
    </TD>

  </TR>
  <TR>
    <TD bgColor=#ffffff>
<div style="font-size:$font_size;color:$font_color;text-align:$text_align;margin:3px;">$text</div>

    </TD>
  </TR>
</TABLE>
<br>
__HTML__
}

################################################################
###  Print extra style for reg pages.
################################################################
sub print_reg_style{

print <<__HTML__;
<style>

#step_choice_container{
    border-collapse:collapse;
    border:1px solid #cecece;
    background-color: #ffffff;
}
#navcontainer ul
{
padding-left: 0;
padding-top: 0;
margin-left: 0;
background-color: #036;
color: White;
float: left;
width: 100%;
font-family: arial, helvetica, sans-serif;
}
/*background-color: #036;*/

#navcontainer ul li { display: inline; }

#navlist{
margin:0;
font-size: 14px;
cursor:default;
}

#navcontainer ul li a
{
padding: 0.2em 1em;
background-color: #036;
color: White;
text-decoration: none;
float: left;
border-right: 1px solid #fff;
cursor:default;
}

#navcontainer ul li a:hover
{
padding: 0.2em 1em;
background-color: #036;
color: White;
text-decoration: none;
float: left;
border-right: 1px solid #fff;
}


#navlist li a#current
{
background:  #369;

}
</style>
__HTML__


}

1;