<perl>
##################################### m1 Benyttes kun til endringer #########################

$_fn = substr $_link,0, (rindex $_link, '/');                #  Finn arbeidsmappe
$link="<a href=$_fn/download_script&mdb=$_link>download</a>";#  Link til nedlastingsscript
$ver="M1 ver. 2.28 TT/bp.de $link, HBj 2012-05-11 DnB Id: "; # NIF-Id erstattet av TT-Id
$ip=$_REMOTE_ADDR;

######################## Bruk alltid store forbokstaver 2012-02-16 ##########################
$xKj = uc $xKj;
$xFornavn = uc (substr ($xFornavn,0,1)).substr($xFornavn,1);
$xEtternavn = uc (substr ($xEtternavn,0,1)).substr($xEtternavn,1);
$xPsted = uc $xPsted;
$xAdr1 = uc (substr ($xAdr1,0,1)).substr($xAdr1,1);
$xAdr2 = uc (substr ($xAdr2,0,1)).substr($xAdr2,1);
$xPnavn = uc (substr ($xPnavn,0,1)).substr($xPnavn,1);

$alle="alle_aktive_og_passive";
get "Id=0", "semester";

if (!$BD || !$BM){$xFdato="";}
if ($BY && $BM && $BD){$xFdato="$BY-$BM-$BD";}

if (!$ex)
{

###################################
#$db=$pid;
###################################
get "Database==$pid", $Partier,"temp";


get "n3sportid==$n3sportid", $pid if $n3sportid ;
$ikkeReg="1" if $Epost eq "";#### Sjekk om oppføringen finnes i partigruppen


if ($Lukket)
{
  #get "n3sportid==$n3sportid", $pid if $n3sportid ;
  get "n3sportid==$n3id", $pid if $n3id ;
  $statPass=$_loop{'Status passiv'};


  get "n3sportid==$n3sportid", $alle if $n3sportid ;
  get "n3sportid==$n3id", $alle if $n3id ;

  if ($Lukket ne $statPass){$closed="1";}
  out "<center><b>Lukket parti!</b></center>";
}# endif $Lukket

get "n3sportid==$n3sportid", $pid if $n3sportid ;

#######################################################out "SP=$_loop{'Status passiv'}";
$SP=$_loop{'Status passiv'};
$SS=$stat;
#out "<center><font size=1>Sp=$SP, stat=$SS</font></center>"; 


goto lukket if $closed;

if ($ny){&new();}

$n3sportid=$n3id if $n3id;
if (!$pid){$pid="nytt_parti2_2010";$n3sportid="9999999";}
if ($vent){&vent();}
if ($vent1){goto END;}

if ($xFdato)
	{
	if (substr($xFdato,4,1) ne "-"){$fFormat="Feil datoformat!";}
	if (substr($xFdato,7,1) ne "-"){$fFormat="Feil datoformat!";}
	if (length($xFdato) ne "10"){$fFormat="Feil datoformat!";}
	}




if ($upd)
	{
	#mod "n3sportid==$n3sportid",["Status passiv",$stat],"alle_aktive_og_passive"; 
	mod "n3sportid==$n3sportid",["Status passiv",$stat],$db;
	mod "Database==$pid",["Lukket",$tilg],$Partier;
	}

get "Database==$pid", $Partier;

$ch4="checked" if $Lukket eq "";
$ch5="checked" if $Lukket eq "V";
$ch6="checked" if $Lukket eq "F";


$pi=$pid;
$parti=$Parti;
$xPnavn="1" if !$Paamelder_Id;

$pid=$Database;
$mbl="m.0";
$mbl=$Mobil_Id if $Mobil_Id;
$db=$Database;
$ep=$Epost_;
$bgc="bgcolor='#FF00FF'";

init $db;

$n3id1=$n3sportid;
$n3sportid="";
$stat1=$stat;
get "n3sportid==$n3id1", "$db";
#get "n3sportid==$n3id1", "alle_aktive_og_passive";

$stat=$_loop{"Status passiv"};
$cha="checked" if $stat eq "F";
$ch1="checked" if $stat eq "";
$ch2="checked" if $stat eq "X";
$ch3="checked" if $stat eq "V";

#out "ID=$Fornavn $Etternavn";

out <<EOF;
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Trondhjems turnforening - påmelding og betaling</title>
</head>

<body bgcolor=ccffff link="blue" vlink="blue">
<center>
<table border="1" width="900" id="table20">
  <tr>
    <td><font size=1>$ver $pid $ip</font>
    <table border="0" width="100%" id="table29">
		<tr>
			<td width="94" align="center"><img alt="img" src="https://www.deltager.no/image.aspx?id=1847" align="center"><br>
				<font size="2">Prinsens gt 1 A<br>
				7013 Trondheim</font></font>
			</td>
      			<td width="786" bgcolor="#00FFFF" align="left"><p align="center">
                                <b><font size="6">Trondhjems Turnforening<br></font>
                                <font size="2">Stiftet 14. februar 1858<br></font>
                                <font size="1"><br></font></b>
                                <font size="2">Bankkonto: 4240 07 06675<br>
				Org.nr.: 971 432 101</font><p>
                                <center><font face="Arial"><h2>Påmeldings- og betalingssystem</td>
      	        </tr>
		<tr>

<!##################################### Her kommer venstre kolonne #################################>

			<td width="94" align="left" valign="top" bgcolor='#ffffcc'><font face="Arial" size="2"><br>
			<a href="http://www.trondhjemsturn.no">Hjemmeside</a><br><br>
			<a href="http://trondhjemsturn.dyndns.org/TT/timeplan/Timeplan.pdf">Timeplan</a><br><br>
			<a href="$_link&ex=ex&ident=$_id&pid=$pid&db=$db&Id=$Id&page=m1&su=$su">Last ned data</a><br><br>
			<a href="http://baseportal.de/cgi-bin/baseportal.pl?htx=/turn/pm/partier">Admin Partier</a><br><br>
			<a href="http://www.lovdata.no/for/sf/fa/ta-20001215-1265-010.html#7-15">Tillatelse</a><br><br>
			<a href="http://baseportal.de/cgi-bin/baseportal.pl?htx=/turn/pm/fl&nid=$n3sportid&total=1">Mine partier</a><br><br>
			<a href="http://baseportal.de/cgi-bin/baseportal.pl?htx=/turn/pm/vis_pameldte">Vis påmeldte</a><br><br>
			<a href="http://baseportal.de/cgi-bin/baseportal.pl?htx=/turn/pm/vis_ventelister&pid=$pid">Vis ventelister</a><br><br>
			<a href="http://hoppogsprett.no/paam/Brukerveiledning.htm">Brukerveiledning</a><br><br>
			<a href="http://idrett.speaker.no/Downloads/59682/docs/Brukerveiledning.doc">Brukerveiledning<br>i Word-format</a><br>
</font></td>
<!###################################################################################################>

			<td bgcolor='#D0FFFF' align="left"><font size="4" face="Arial">Påmelding til partiene: <br>
			<center>$parti</center><p>
EOF
			init $db;

			if ($db ne "kunder")
			{if (!$xFornavn || !$xEtternavn || !$xKj || !$xFdato || !$xEpost || !$xPnavn || $fFormat){$new=""; $endre="";}}
			if ($db eq "kunder")
			{if (!$xEtternavn || !$xKj || !$xFdato || !$xEpost || !$xPnavn || $fFormat){$new=""; $endre="";}} ### Tillater manglende fornavn

                        if ($n3sportid && !$new)
                        {
                           get "n3sportid==$n3sportid", "$db";
                           &modify();
                        }

                        if (!$n3sportid || $new){&modify();}
			out <<EOF;
			</td>
		</tr>
		</table>

		<table border="0" width="100%" id="table34">

		<tr>
			<td width="94" bgcolor='#ffffcc'>&nbsp;</td>
			<td bgcolor="#D0FFFF"><font face="Arial" size="3">

			<!p>

Registrerte deltakere fra siste semester kan benytte prioritert påmelding.
<br>Vennligst kontroller medlemsdata og rett opp ev. feil. Klikk på &quot;Lagre data&quot; <br>deretter på &quot;Gå til Betaling&quot;. Der kan du velge parti.
<br>Husk å ta utskrift av kvitteringen etter vellykket betaling. Den gjelder som medlems- og deltagerbevis.</font>
<p>
EOF
if ($endre && $xPnavn && $stat ne "V")
{
get "Snarvei==$pid", $Partier;
out <<EOF;
<!form method="post" action="https://www.deltager.no/participant/arrangement.aspx?id=$Snarvei&fname=$xFornavn&lname=$xEtternavn&email=$xEpost&mobile=$xMob&$NIF_Id=$n3sportid" enctype="multipart/form-data">
<form method="post" action="https://www.deltager.no/participant/arrangement.aspx?id=$Snarvei&fname=$xFornavn&lname=$xEtternavn&email=$xEpost&mobile=$xMob&$NIF_Id=$_loop{'Internt medlemsnr'}" enctype="multipart/form-data">

<input type="submit" value="Gå til betaling">

</form>
EOF
}#endif endre

out <<EOF;
</td></tr>
<tr>
<td width="94" bgcolor='#ffffcc'></td><!Venstre kolonne>
<td bgcolor="#D0FFFF"><font face="Arial" size="2">
<b>Ved problemer ta kontaktmed:</b>
<table>
<tr>
<td width="150"><font size="2">Navn:</td><td><font size="2">$Navn</td>
</tr>
<tr>
<td><font size="2">Telefon:</td><td><font size="2">$Telefon</td>
</tr>
<tr>
<td><font size=2><font size="2">E-postadresse:</td><td><font size="2"><a href="mailto:$ep">$ep</a></td>
</tr>
<tr>
<td></td><td></td>
</tr>
<tr>
<td></td><td></td>
</tr>
</font></table>

</font></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
EOF
lukket:
}
END:
$dbName=$db;
if ($ex eq "ex"){&export()} 

##########################################################################
sub export
{

if ($su eq "7")
{
init $dbName;
$mdb=$dbName;
init $alle;

$sep="\t" if $sep eq "";
$sep="\t" if $sep eq "tab";
$sep=";";



$filename = $mdb =~ /\// ? substr $mdb, rindex $mdb, '/' : $mdb;
$filename =~ s/\W//g;
# Header-Statements for csv-Files / mime-Type
$_header = "Content-type: text/comma-separatet-values\n";
$_header= "Content-disposition: attachment;filename=$filename.csv\n\n";

 get "Id=*", "$alle.fields", "fields";

 while (get_next("fields"))
 {
 push @f, $Field;
 }
 shift @f; # Removes Id from listing
# pop @f;   # Removes Photo from listing
# pop @f;   # Removes Password from listing
 foreach $x (@f)
 {
  out $x,$sep;
 }

 out "\n";

 get "Id=*","$mdb";
 while(get_next($mdb)) 
 {
 get "n3sportid==$n3sportid", "$alle", "temp";
foreach (@f)
  {
   #${$_} = convert_html(${$_});
   $_loop{$_} = convert_br($_loop{$_});# Same as: $_loop{$_} =~ s/\n/<br>/g;
   out $_loop{$_},$sep;
  } 
  out "\n";
 }

}
else {
out "<center><b>Ikke tillatt for denne bruker!</b></center>";
}
}
##########################################################################
sub modify
{
topp:
#return;
$a1="Fornavn";
$a2="Etternavn";
$a3="Fødselsdato";
$a4="Kjønn";
$a5="Adresselinje 1";
$a6="Adresselinje 2";
$a7="Postnummer";
$a8="Poststed";
$a9="Tlf mobil";
$a10="Epost";
$a11="Tlf privat";
$a12="Tlf jobb";
$a13="Påmelder";
$a14="Postert";
$a15="Status passiv";
$a16="Notisblokk";

get "n3sportid==$n3id1",$alle;


if ($xFornavn eq $_loop{$a1} && $xEtternavn eq $_loop{$a2} && $xFdato eq $_loop{$a3} && $xKj eq $_loop{$a4} && $xAdr1 eq $_loop{$a5} && $xAdr2 eq $_loop{$a6} && $xPnr eq $_loop{$a7} && $xPsted eq $_loop{$a8} && $xMob eq $_loop{$a9} && $xEpost eq $_loop{$a10} && $xPriv eq $_loop{$a11} && $xJobb eq $_loop{$a12} && $xPnavn eq $_loop{$a13} && $xNotis eq $Notisblokk)
{$endre0="1"; $noChg=" Ingen endring. ";}
if ($SP ne $SS){$endre0=""; $noChg="";}
################################################ Start Verify ########################################### 
if ($endre){
goto endre if !$xPnavn;

&tid();

if (!$endre0) 
{
##### For testing av Postert-feltet #####
# mod "n3sportid==$n3sportid",   [$a1,$xFornavn,$a2,$xEtternavn,$a3,$xFdato,$a4,$xKj,$a5,$xAdr1,$a6,$xAdr2,$a7,$xPnr,$a8,$xPsted,$a9,$xMob,$a10,$xEpost,$a11,$xPriv,$a12,$xJobb,$a13,$xPnavn,$a16,$xNotis,$a14,$tid],"alle_aktive_og_passive_X1";
#########################################

if ($SP eq "V" && $SS eq "V"){$a14="";} ##### Ikke endre Postert når deltager står på vent
 
mod "n3sportid==$n3sportid",   [$a1,$xFornavn,$a2,$xEtternavn,$a3,$xFdato,$a4,$xKj,$a5,$xAdr1,$a6,$xAdr2,$a7,$xPnr,$a8,$xPsted,$a9,$xMob,$a10,$xEpost,$a11,$xPriv,$a12,$xJobb,$a13,$xPnavn,$a16,$xNotis,$a14,$tid],"alle_aktive_og_passive";

##### Lagt inn igjen 2011-01-06 #####
mod "n3sportid==$n3sportid",   [$a1,$xFornavn,$a2,$xEtternavn,$a3,$xFdato,$a4,$xKj,$a5,$xAdr1,$a6,$xAdr2,$a7,$xPnr,$a8,$xPsted,$a9,$xMob,$a10,$xEpost,$a11,$xPriv,$a12,$xJobb,$a13,$xPnavn,$a16,$xNotis,$a14,$tid],$db;


#####################################
}

put["n3sportid",$n3sportid,$a14,$tid,$a1,$xFornavn,$a2,$xEtternavn,$a3,$xFdato,$a4,$xKj,$a5,$xAdr1,$a6,$xAdr2,$a7,$xPnr,$a8,$xPsted,$a9,$xMob,$a10,$xEpost,$a11,$xPriv,$a12,$xJobb,$a13,$xPnavn,$a16,$xNotis,"IP_bruker",$ip],"log";

if ($tilg eq "V" && $stat eq "") {$mod1="";} 
if ($tilg eq "F" && $stat eq "") {$mod1="";} 
if ($tilg eq "" && $stat eq "") {$mod1="1";} 

if ($tilg eq "V" && $stat eq "X") {$mod1="";} 
if ($tilg eq "F" && $stat eq "X") {$mod1="";} 
if ($tilg eq "" && $stat eq "X") {$mod1="1";} 

if ($tilg eq "V" && $stat eq "V") {$mod1="1";} 
if ($tilg eq "F" && $stat eq "V") {$mod1="";} 
if ($tilg eq "" && $stat eq "V") {$mod1="";} 

if ($tilg eq "V" && $stat eq "F") {$mod1="";} 
if ($tilg eq "F" && $stat eq "F") {$mod1="1";} 
if ($tilg eq "" && $stat eq "F") {$mod1="";} 

goto endre if $mod1 eq "";

get "n3sportid==$n3id1",$alle;

#$sPostert=substr($Postert,0,4)."-".substr($Postert,5,2)."-".substr($Postert,8,2)." kl ".substr($Postert,11,1).substr($Postert,12,1).":".substr($Postert,14,2);
$sPostert=substr($Postert,0,16);

$_loop{$a1}=$xFornavn;
$_loop{$a2}=$xEtternavn;
$_loop{$a3}=$xFdato;
$_loop{$a4}=$xKj;
$_loop{$a5}=$xAdr1;
$_loop{$a6}=$xAdr2;
$_loop{$a7}=$xPnr;
$_loop{$a8}=$xPsted;
$_loop{$a9}=$xMob;
$_loop{$a10}=$xEpost;
$_loop{$a11}=$xPriv;
$_loop{$a12}=$xJobb;
$_loop{$a14}=$Postert;
$_loop{$a13}=$xPnavn;
$_loop{$a16}=$xNotis;

if (length $n3sportid eq 5) {$_loop{'Internt medlemsnr'} = $n3sportid;$n3sportid="Finnes ikke";} #xxxx

out <<EOF;
<font size="3"><b>Medlemsdata (2):</b><!/font><br>
<b>TT-Id: $_loop{"Internt medlemsnr"}</b><br>
NIF-Id: $n3sportid<br>
<font size="1">$noChg Sist endret: $sPostert</font>
  <table align="center">
  <tr><td align=left>Fornavn:</td><td align left>$_loop{$a1}&nbsp;&nbsp;&nbsp;</td></tr>
  <tr>
      <td align=left>Etternavn:</td><td align left>$_loop{$a2}&nbsp;&nbsp;&nbsp;</td></tr>
  <tr><td align=left>Født:</td><td align left>$_loop{$a3}&nbsp;&nbsp;&nbsp;</td></tr>
  <tr>
      <td align=left>Kjønn:</td><td align=left>$_loop{$a4}&nbsp;&nbsp;&nbsp;</td></tr>
  <tr><td align=left>Adresselinje 1:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td><td align=left>$_loop{$a5}&nbsp;&nbsp;&nbsp;</td></tr>
  <tr>
      <td align=left>Adresselinje 2:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td><td align=left>$_loop{$a6}&nbsp;&nbsp;&nbsp;</td></tr>
  <tr><td align=left>Postnummer:</td><td align=left>$_loop{$a7}&nbsp;&nbsp;&nbsp;</td></tr>
  <tr>
      <td align=left>Poststed:</td><td align=left>$_loop{$a8}&nbsp;&nbsp;&nbsp;</td></tr>
  <tr><td align=left>Tlf mobil:</td><td align=left>$_loop{$a9}&nbsp;&nbsp;&nbsp;</td></tr>
  <tr>
      <td align=left>Epost:</td><td align=left>$_loop{$a10}&nbsp;&nbsp;&nbsp;</td></tr>
  <tr><td align=left>Tlf privat:</td><td align=left>$_loop{$a11}&nbsp;&nbsp;&nbsp;</td></tr>
  <tr>
  <tr><td align=left>Tlf jobb:</td><td align=left>$_loop{$a12}&nbsp;&nbsp;&nbsp;</td></tr>
EOF
if ($Paamelder_Id)
{
out <<EOF;
  <tr><td align=left>Påmelders navn:</td><td align=left>$_loop{$a13}&nbsp;&nbsp;&nbsp;</td></tr>
EOF
}
$status="Vanlig aktive" if $stat eq "";
$status="Vanlig passive" if $stat eq "X";;
$status="Fast" if $stat eq "F";
$status="Venteliste" if $stat eq "V";

$tilg1="Vanlig" if $tilg eq "";
$tilg1="Fast" if $tilg eq "F";
$tilg1="Venteliste" if $tilg eq "V";

if ($v)
{
out <<EOF;
  <tr>
      <td align=left>Status medlem:</td><td align=left>$status&nbsp</td></tr>
  <tr><td align=left>Status partigr.:</td><td align=left>$tilg1&nbsp;</td></tr>

EOF

}

out <<EOF;
  <tr><td></td><td></td>
  <tr><td><input type=button onClick="location.href='$_link&pid=$pid&n3sportid=$n3id1&su=$su&db=$db&endre=&new=&v=$v'" value=' Endre '> 
 </td></tr>
  </table>
EOF


put
["n3sportid",$n3sportid,$a1,$xFornavn,$a2,$xEtternavn,$a3,$xFdato,$a4,$xKj,$a5,$xAdr1,$a6,$xAdr2,$a7,$xPnr,$a8,$xPsted,$a9,$xMob,$a10,$xEpost,$a11,$xPriv,$a12,$xJobb,$a13,$xPnavn,$a16,$xNotis,$a14,$tid],$db if $ikkeReg;######### 2012-03-28, lagre i partigruppe hvis reg. mangler



}
######################################### End Verify Endret #############################################
else
{
endre:

get "n3sportid==$n3id1",$alle;

#$sPostert=substr($Postert,0,4)."-".substr($Postert,5,2)."-".substr($Postert,8,2)." kl ".substr($Postert,11,1).substr($Postert,12,1).":".substr($Postert,14,2);
$sPostert=substr($Postert,0,16);

$_loop{$a1}=$xFornavn if !$Fornavn;
$_loop{$a2}=$xEtternavn if !$Etternavn;
$_loop{$a3}=$xFdato if !$_loop{$a3};
$_loop{$a4}=$xKj if !$_loop{$a4};
$_loop{$a10}=$xEpost if !$Epost;

$n1="";
$n1="1" if !$endre;
######################################
$BY=substr($_loop{$a3},0,4);
$BM=substr($_loop{$a3},5,2);
$BD=substr($_loop{$a3},8,2);
######################################

$vbekreft="<font color=#ff0000><center><b>$Fornavn $Etternavn er satt på venteliste for parti:</font><i> $Notisblokk</i></b></center><br>" if $stat eq "V";

if (length $n3sportid eq 5) {$_loop{'Internt medlemsnr'} = $n3sportid;$n3sportid="Finnes ikke";} #xxxx
out <<EOF;
<font size="3"><b>Medlemsdata (1):</b><!/font><br>
<b>TT-Id: $_loop{"Internt medlemsnr"}</b><br>
NIF-Id: $n3sportid<br>
$vbekreft
<font size="1">$noChg Sist endret: $sPostert</font>

  <form action=$_link&endre=1 method="post" enctype="multipart/form-data">
   <input type=hidden name="endre=" value="1">
   <input type=hidden name="new=" value="$n1">
   <input type=hidden name="pid=" value="$pid">
   <input type=hidden name="n3sportid=" value="$n3id1">
   <input type=hidden name="su=" value="$su">
   <input type=hidden name="db=" value="$db">
   <input type=hidden name="v=" value="$v">
   <input type=hidden name="upd=" value="1">
   <input type=hidden name="tilg=" value="$tilg">
   <!input type=hidden name="ikkeReg=" value="$ikkeReg">

  <table align="center">
  <tr><td align=right>Fornavn:</td><td><input type="text" name="xFornavn=" value="$_loop{$a1}" size=35> *</td></tr>
  <tr>
      <td align=right>Etternavn:</td><td><input type="text" name="xEtternavn=" value="$_loop{$a2}" size=35> *</td></tr>

            <tr>
              <td align="right">
              <font color="#000000" size="3">Fødselsdato:</font></td>
              <td><font color="#000000" size="2">
              <select name="BD:=">
              <option> </option>
              <option selected>$BD</option>
              <option>01</option>
              <option>02</option>
              <option>03</option>
              <option>04</option>
              <option>05</option>
              <option>06</option>
              <option>07</option>
              <option>08</option>
              <option>09</option>
              <option>10</option>
              <option>11</option>
              <option>12</option>
              <option>13</option>
              <option>14</option>
              <option>15</option>
              <option>16</option>
              <option>17</option>
              <option>18</option>
              <option>19</option>
              <option>20</option>
              <option>21</option>
              <option>22</option>
              <option>23</option>
              <option>24</option>
              <option>25</option>
              <option>26</option>
              <option>27</option>
              <option>28</option>
              <option>29</option>
              <option>30</option>
              <option>31</option>
              </select>Dato <select name="BM:=">
              <option> </option>
              <option selected>$BM</option>
              <option> 01</option>
              <option> 02</option>
              <option> 03</option>
              <option> 04</option>
              <option> 05</option>
              <option> 06</option>
              <option> 07</option>
              <option> 08</option>
              <option> 09</option>
              <option> 10</option>
              <option> 11</option>
              <option> 12</option>
              </select>Mnd </b><select name="BY:=">
              <option> </option>
              <option selected>$BY</option>
              <option>1900</option>
              <option>1914</option>
              <option>1915</option>
              <option>1916</option>
              <option>1917</option>
              <option>1918</option>
              <option>1919</option>
              <option>1920</option>
              <option>1921</option>
              <option>1922</option>
              <option>1923</option>
              <option>1924</option>
              <option>1925</option>
              <option>1926</option>
              <option>1927</option>
              <option>1928</option>
              <option>1929</option>
              <option>1930</option>
              <option>1931</option>
              <option>1932</option>
              <option>1933</option>
              <option>1934</option>
              <option>1935</option>
              <option>1936</option>
              <option>1937</option>
              <option>1938</option>
              <option>1939</option>
              <option>1940</option>
              <option>1941</option>
              <option>1942</option>
              <option>1943</option>
              <option>1944</option>
              <option>1945</option>
              <option>1946</option>
              <option>1947</option>
              <option>1948</option>
              <option>1949</option>
              <option>1950</option>
              <option>1951</option>
              <option>1952</option>
              <option>1953</option>
              <option>1954</option>
              <option>1955</option>
              <option>1956</option>
              <option>1957</option>
              <option>1958</option>
              <option>1959</option>
              <option>1960</option>
              <option>1961</option>
              <option>1962</option>
              <option>1963</option>
              <option>1964</option>
              <option>1965</option>
              <option>1966</option>
              <option>1967</option>
              <option>1968</option>
              <option>1969</option>
              <option>1970</option>
              <option>1971</option>
              <option>1972</option>
              <option>1973</option>
              <option>1974</option>
              <option>1975</option>
              <option>1976</option>
              <option>1977</option>
              <option>1978</option>
              <option>1979</option>
              <option>1980</option>
              <option>1981</option>
              <option>1982</option>
              <option>1983</option>
              <option>1984</option>
              <option>1985</option>
              <option>1986</option>
              <option>1987</option>
              <option>1988</option>
              <option>1989</option>
              <option>1990</option>
              <option>1991</option>
              <option>1992</option>
              <option>1993</option>
              <option>1994</option>
              <option>1995</option>
              <option>1996</option>
              <option>1997</option>
              <option>1998</option>
              <option>1999</option>
              <option>2000</option>
              <option>2001</option>
              <option>2002</option>
              <option>2003</option>
              <option>2004</option>
              <option>2005</option>
              <option>2006</option>
              <option>2007</option>
              <option>2008</option>
              <option>2009</option>
              <option>2010</option>
              <option>2011</option>
              <option>2012</option>
              <option>2013</option>
              <option>2014</option>
              <option>2015</option>
              <option>2016</option>
              <option>2017</option>
              <option>2018</option>
              <option>2019</option>
              </select>År *</font></td>
            </tr>


  <!--tr><td align=right>Født:</td><td><input type="text" name="xFdato=" value="$_loop{$a3}" size=12> <b>$fFormat</b> * åååå-mm-dd</td></tr-->
  <tr>
      <td align=right>Kjønn:</td><td><input type="text" name="xKj=" value="$_loop{$a4}" size=3> K eller M *</td></tr>
  <tr><td align=right>Adresselinje 1:</td><td><input type="text" name="xAdr1=" value="$_loop{$a5}" size=35></td></tr>
  <tr>
      <td align=right>Adresselinje 2:</td><td><input type="text" name="xAdr2=" value="$_loop{$a6}" size=35></td></tr>
  <tr><td align=right>Postnummer:</td><td><input type="text" name="xPnr=" value="$_loop{$a7}" size=6>
</td></tr>
  <tr>
      <td align=right>Poststed:</td><td><input type="text" name="xPsted=" value="$_loop{$a8}" size=35></td></tr>
  <tr><td align=right>Tlf mobil:</td><td><input type="text" name="xMob=" value="$_loop{$a9}" size=12></td></tr>
  <tr>
       <td align=right>Epost:</td><td><input type="text" name="xEpost=" value="$_loop{$a10}" size=35> *</td></tr>
  <tr><td align=right>Tlf privat:</td><td><input type="text" name="xPriv=" value="$_loop{$a11}" size=12></td></tr>
  <tr>
  <tr><td align=right>Tlf jobb:</td><td><input type="text" name="xJobb=" value="$_loop{$a12}" size=12></td></tr>
EOF
if ($Paamelder_Id)
{
out <<EOF;
  <tr><td align=right>Påmelders navn:</td><td><input type="text" name="xPnavn=" value="$_loop{$a13}" size=35> *</td></tr>
EOF
}
$f1="1" if (!$v && !$cha);

if ($f1)
{
$_loop{$a16}="" if $ch1;

out <<EOF;
  <tr><td></td><td> * Må oppgis!</td>
  <tr><td align=right>Ønsker å stå på venteliste:</td><td><input type="radio" name="stat" value="" $ch1> Nei <input type="radio" name="stat" value="V" $ch3> Ja 
på parti <input type="text" name="xNotis=" value="$_loop{$a16}" size=6></td></tr>
<tr><td></td><td></td<td>
Du kan <b>IKKE</b> sette deg på venteliste før du har sjekket om det er ledig plass!
<input type=hidden name="tilg=" value="$Lukket">

EOF
}

if ($cha && !$v){out <<EOF;
<tr><td>&nbsp;</td><td> Du har fast plass. Kontroller dine data.
<input type=hidden name="stat=" value="F">
<input type=hidden name="tilg=" value="$Lukket">
EOF
}

out "</td></tr>";

if ($v){&radio();}

out <<EOF;
  <tr><td></td><td></td>
  <tr><td></td><td><input type=submit value="Lagre data"><p>Det er nødvendig å lagre data for å komme til "Betaling"!</td></tr>
  </form></table><p>
  </center></center>
EOF
}
############################################### End Form Endre ##########################################
}
#########################################################################################################
sub radio
{
#out "Stat=$stat<br>Stat1=$stat1<br>Tilg=$tilg<br>Lukket=$Lukket";


$stat=lc($_loop{"Status passiv"});
$cha="checked" if $stat eq "F";
$ch1="checked" if $stat eq "";
$ch2="checked" if $stat eq "X";
$ch3="checked" if $stat eq "V";

$ch4="checked" if $tilg eq "";
$ch5="checked" if $tilg eq "V";
$ch6="checked" if $Lukket eq "F";


out <<EOF;
<tr><td align=right>Status medlem:</td>
<td>
<input type="radio" name="stat" value="" $ch1> Aktiv&nbsp;&nbsp;
<input type="radio" name="stat" value="F" $cha> Fast
<input type="radio" name="stat" value="V" $ch3> Venteliste<br>
<input type="radio" name="stat" value="X" $ch2> Passiv
</td></tr>
<tr><td align=right>Status partigr:</td>
<td>
<input type="radio" name="tilg" value="" $ch4> Vanlig 
<input type="radio" name="tilg" value="F" $ch6> Fast 
<input type="radio" name="tilg" value="V" $ch5> Venteliste 
</td></tr>
EOF
}

#####################################################################
sub vent
{
out <<EOF;
<center>
<b>Sett meg på venteliste</b><p>
Sett inn din NIF-Id og klikk på OK for å finne registrerte data.
<form action=$_link&pid=$pid method="post" enctype="multipart/form-data">
  NIF-Id: <input type="text" name="n3sportid=" value="" size=12><br>
  <input type=submit value=" OK ">
</form>
</center>
EOF
$vent1=1;
}
#####################################################################
sub newXX
{
#####################################################################
$a1="Fornavn";
$a2="Etternavn";
$a3="Fødselsdato";
$a4="Kjønn";
$a5="Adresselinje 1";
$a6="Adresselinje 2";
$a7="Postnummer";
$a8="Poststed";
$a9="Tlf mobil";
$a10="Epost";
$a11="Tlf privat";
$a12="Tlf jobb";
$a13="Påmelder";
$a14="Postert";
$a16="Notisblokk";

$db=$pid;

my ($sec,$min,$hour,$mday,$mon,$year,
          $wday,$yday,$isdst) = localtime time;
$y=date("now", "Year2");
$m0=date("now", "Month0");
$d0=date("now", "Day0");
$h=date("now", "Hour");
$min=date("now", "Minute");
$sec=date("now", "Second");
$aa=substr($fd,0,4);
$aa=$aa+100 if substr($fd,0,2) > 19;
$mm=substr($fd,5,2);
$dd=substr($fd,8,2);
$dag=$aa*365+$mm*30+$dd;
$xFdato=$fd if !$n3sportid;
$n3sportid=substr($Etternavn,0,1).substr($Fornavn,0,1).$dag if !$n3sportid;

##########################
$n3id=$n3sportid if $n3sportid;
$n3sportid="";
get "n3sportid==$n3id",$db;

$n3idDB=$n3sportid;
$n3sportid="";
get "n3sportid==$n3id","alle_aktive_og_passive";
$n3idAll=$n3sportid;

##########################

put[$a1,$Fornavn,$a2,$Etternavn,$a3,$_loop{$a3},$a4,$_loop{$a4},$a5,$_loop{$a5},$a6,$_loop{$a6},$a7, $_loop{$a7},$a8,$_loop{$a8},$a9,$_loop{$a9},$a10,$_loop{$a10},$a11,$_loop{$a11},$a12,$_loop{$a12},$a13,$_loop{$a13},$a16,$_loop{$a16},"n3sportid",$n3id],$db if !$n3idDB;

put["n3sportid",$n3id,$a1,$Fornavn,$a2,$Etternavn,$a3,$fd],"alle_aktive_og_passive" if !$n3idAll;
#####################################################################
$new="";
$n3id1=$n3sportid;
}
####################################################################################################
sub tid
{
my ($sec,$min,$hour,$mday,$mon,$year,
          $wday,$yday,$isdst) = localtime time;
$year=$year+1900;
$mon=$mon+1;
$mon="0".$mon if $mon < 10;
$mday="0".$mday if $mday < 10;
$hour="0".$hour if $hour < 10;
$min="0".$min if $min < 10;

$tid="$year-$mon-$mday,$hour:$min";
}
####################################################################################################

</perl>