<perl>
################################### m3.htx ########################################
#	Denne malen benyttes for åpen påmelding
#	Denne malen benyttes for prioritert påmelding (2010-06-17)
#	Ved bruk av "Endre" overtar M1 (2009-11-18) 
#	NIF-Id begynner nå med:
#	   a) QHexHex istedet for store forbokstaver 2009-12-03
#	   b) DecDec  istedet for store forbokstaver
#	   c) Erstatter bokstav med Hex hvis spesialtegn som æ,ø,å
#	Alternativ b) benyttes her med ledende null hvis lavere enn 100, 2012-02-21
#       Filter er lagt inn i sub fullt, 2011-12-02, HBj
#       NIF-Id erstattet av TT-Id, 2012-06-03, v 3.32
###################################################################################

######################## Bruk alltid store forbokstaver ###########################
$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);

&fullt(); #################### Filtrere ut uønsket medlem #########################
goto ende if $full;



$ip=$_REMOTE_ADDR;
$_fn = substr $_link,0, (rindex $_link, '/');                #  Finn arbeidsmappe
$link="<a href=$_fn/download_script&mdb=$_link>download</a>";#  Link til nedlastingsscript
#out $_fn;

$ver="M3 Ver. 3.32 TT/bp.de $link, HBj 2012-06-03";
#$n3sportid=$nid if $nid;

$alle="alle_aktive_og_passive";				# Forkort filnavn
get "Id=0", "semester";					# Hent semesterdata

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

if (!$ex)
{
get "Database==$pid", $Partier;				# Sjekk om partiet er lukket
if ($Lukket)
{
$statP="F" if $su;
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 && !$su){$closed="1";}
out "<center><b>Lukket parti!</b></center>";
}
goto lukket if $closed;

if (!$pid){$pid="nytt_parti2_2010";$n3sportid="9999999";}

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!";}
}

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

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

$pid=$Database;
$mbl=$Mobil_Id;
$mbl="m.0" if !$Mobil_Id;
$db=$Database;
$ep=$Epost_;
$bgc="bgcolor='#FF00FF'";
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>
<!##################################### 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 (!$xFornavn || !$xEtternavn || !$xKj || !$xFdato || !$xEpost || !$xPnavn || $fFormat)
			{$new=""; $endre="";}

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

                        if (!$n3sportid || $new){&new();}
			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">
<!##################################### Tekst 1 ####################################################>
<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
####################################### Tekst 1 ####################################################
if ($endre && $xPnavn)
{
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:
}
$dbName=$db;
if ($ex eq "ex"){&export()} 




##########################################################################
sub fullt
{
out "<body bgcolor=d0ffff>";
if ($n3sportid eq "7526870" || (lc($Fornavn) eq "madelen" && lc($Etternavn) eq "solberg"))
{out "<center><p><h1>Trondhjems Turnforenings påmeldingssystem</h1><p><h3>Beklager $Fornavn $Etternavn, men alle partier for din aldersgruppe er fulle!</h3></center>";$full="1";}
out "</body>";
}
##########################################################################
sub export
{
if ($su eq "")
{
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 new
{
$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";
$a14="Postert";
$a13="Påmelder";

if ($new){

my ($sec,$min,$hour,$mday,$mon,$year,
          $wday,$yday,$isdst) = localtime time;


#$h=(date("now", "Hour"))+1;
$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($xFdato,2,2);
$aa=$aa+100 if substr($xFdato,0,2) > 19;
$mm=substr($xFdato,5,2);
$dd=substr($xFdato,8,2);
$dag=$aa*365+$mm*30+$dd;

#$n3sportid=substr($xEtternavn,0,1).substr($xFornavn,0,1).$dag if !$n3sportid;# Returnerer forbokstav OK
#$n3sportid=ord(substr($xEtternavn,0,1)).ord(substr($xFornavn,0,1)).$dag if !$n3sportid;# Returnerer desimalverdi
#$n3sportid="Q".unpack('H*',(substr($xEtternavn,0,1))).unpack('H*',(substr($xFornavn,0,1))).$dag if !$n3sportid;# Returnerer hexverdi

$Efb=ord substr($xEtternavn,0,1);                                                         # Bruk decimalverdi av forbokstaven i etternavnet
$Efb = reverse(reverse($Efb)."0") if length $Efb < 3;
$Ffb=ord substr($xFornavn,0,1);                                                           # Bruk decimalverdi av forbokstaven i fornavnet
$Ffb = reverse(reverse($Ffb)."0") if length $Ffb < 3;


#$Efb=substr($xEtternavn,0,1) if ord(substr($xEtternavn,0,1))< 123;                # Bruk forbokstaven i etternavnet
#$Ffb=substr($xFornavn,0,1) if ord(substr($xFornavn,0,1))< 123;                    # Bruk forbokstaven i fornavnet

#$Efb=unpack('H*',(substr($xEtternavn,0,1))) if ord(substr($xEtternavn,0,1))> 122; # Bruk hexverdi for spesialtegn i etternavnet
#$Ffb=unpack('H*',(substr($xFornavn,0,1))) if ord(substr($xFornavn,0,1))> 122;     # Bruk hexverdi for spesialtegn i fornavnet

$n3sportid=$Efb.$Ffb.$dag if !$n3sportid;

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

&tid();

############################ Hent nytt medlemsnr ##################
get "Id==1", "internt_medlemsnr";
$medlemsnr ++;
mod "Id==1",["medlemsnr",$medlemsnr], "internt_medlemsnr";
####################################################################

$mnr = "Internt medlemsnr";

put[$mnr,$medlemsnr,$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,"n3sportid",$n3id,"Status passiv",$statP],$db if !$n3idDB;

put[$mnr,$medlemsnr,$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,"n3sportid",$n3id],"alle_aktive_og_passive" if !$n3idAll;


##### For testing av Postert-feltet #####
#put[$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,"n3sportid",$n3id],"alle_aktive_og_passive_X1" if !$n3idAll;
#########################################



$n3idny="Ny: ".$n3id;

put[$mnr,$medlemsnr,$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,"n3sportid",$n3idny,"IP_bruker",$ip,$a14,$tid],"log";## Ny

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

#$Postert=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);
$Postert=substr($Postert,0,16);

goto endre if !$xPnavn;
$_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;


####################################################################
out <<EOF;
Endre ny:<br>
<font size="3"><b>Medlemsdata (2):</b><!/font><br>
<b>TT-Id: $_loop{"Internt medlemsnr"}</b><br>
NIF-Id: $n3sportid<br>
<font size="1">Sist endret: $Postert</font>
  <table align="center">
  <tr><td align=left>Fornavn:</td><td align left>$xFornavn&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
}
out <<EOF;
  <tr><td></td><td></td>
  <tr><td><input type=button onClick="location.href='http://baseportal.de/cgi-bin/baseportal.pl?htx=/turn/pm/m1&pid=$pid&n3sportid=$n3sportid&su=$su&endre=&new=&n3id=$n3sportid&n3id=$n3id'" value=' Endre '> 
 </td></tr>
  </table>
EOF
####################################################################

}

else
{
endre:

#$Postert=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);

    # mod "n3sportid==$n3sportid",[a14,$Postert],$db;

#$Postert=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) if $Postert;
$Postert=substr($Postert,0,16);

$n1="";
$n1="1" if !$endre;

########################
if ($xx)
{
get "n3sportid==$n3id","alle_aktive_og_passive" if $n3id;
$xFornavn=$Fornavn if !$xFornavn;
$xEtternavn=$Etternavn if !$xEtternavn;
$xFdato=$_loop{"Fødselsdato"};
$xFdato=$fd if !$xFdato;
$xPsted=$Poststed if !$xPsted;
$xPnr=$Postnummer if !$xPnr;
$xKj=$_loop{"Kjønn"} if !$xKj;
$xAdr1=$_loop{"Adresselinje 1"} if !$xAdr1;
$xAdr2=$_loop{"Adresselinje 2"} if !$xAdr2;
$xEpost=$Epost if !$xEpost;
$xMob=$_loop{"Tlf mobil"} if !$xMob;
$xPriv=$_loop{"Tlf privat"} if !$xPriv;
$xJobb=$_loop{"Tlf jobb"} if !$xJobb;
#$Postert=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) if $Postert;
$Postert=substr($Postert,0,16);
}
########################

out <<EOF;
Ny:<br>
<font size="3"><b>Medlemsdata (1):</b><!/font><br>
<b>TT-Id: $_loop{"Internt medlemsnr"}</b><br>
NIF-Id: $n3sportid<br>
<font size="1">Sist endret: $Postert</font>

  <form action=$_link  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="$n3sportid">
   <input type=hidden name="su=" value="$su">
   <input type=hidden name="xx=" value="$xx">

  <table align="center">
  <tr><td align=right>Fornavn:</td><td><input type="text" name="xFornavn=" value="$xFornavn" size=35> *</td></tr>
  <tr>
      <td align=right>Etternavn:</td><td><input type="text" name="xEtternavn=" value="$xEtternavn" 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="$xFdato" size=12> <b>$fFormat</b> * åååå-mm-dd</td></tr-->
  <tr>
      <td align=right>Kjønn:</td><td><input type="text" name="xKj=" value="$xKj" size=3> K eller M *</td></tr>
  <tr><td align=right>Adresselinje 1:</td><td><input type="text" name="xAdr1=" value="$xAdr1" size=35></td></tr>
  <tr>
      <td align=right>Adresselinje 2:</td><td><input type="text" name="xAdr2=" value="$xAdr2" size=35></td></tr>
  <tr><td align=right>Postnummer:</td><td><input type="text" name="xPnr=" value="$xPnr" size=6></td></tr>
  <tr>
      <td align=right>Poststed:</td><td><input type="text" name="xPsted=" value="$xPsted" size=35></td></tr>
  <tr><td align=right>Tlf mobil:</td><td><input type="text" name="xMob=" value="$xMob" size=12></td></tr>
  <tr>
       <td align=right>Epost:</td><td><input type="text" name="xEpost=" value="$xEpost" size=35> *</td></tr>
  <tr><td align=right>Tlf privat:</td><td><input type="text" name="xPriv=" value="$xPriv" size=12></td></tr>
  <tr>
  <tr><td align=right>Tlf jobb:</td><td><input type="text" name="xJobb=" value="$xJobb" 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="$xPnavn" size=35> *</td></tr>
EOF
}
out <<EOF;
  <tr><td></td><td> * Må oppgis!</td>
  <tr><td></td><td><input type=submit value="Lagre data"><br>Det er nødvendig å lagre data for å komme til "Betaling"!</td></tr>
  </form></table><p>
  </center></center>
EOF
}
}
#######################################################################################################
sub modify
{
$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";
$a14="Postert";
$a13="Påmelder";

$n3all=$n3sportid;
$n3sportid="";
get "n3sportid==$n3all",$db;
$n3local=$n3sportid;
get "n3sportid==$n3all","alle_aktive_og_passive";


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}){$endre0="1"; $noChg=" Ingen endring. ";}



################################################ Start Verify ###########################################
if ($endre){
goto endre if !$xPnavn;


if ($xx && !$n3local)
{

put[$mnr,$medlemsnr,$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,"n3sportid",$n3id],$db;
}

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],"alle_aktive_og_passive" if !$endre0;

&tid();

put[$mnr,$medlemsnr,"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,"IP_bruker",$ip,$a14,$tid],"log";## Finnes fra før

get "n3sportid==$n3sportid",$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;
#######



$_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;


out <<EOF;
<font size="3"><b>Medlemsdata (4):</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
}
out <<EOF;
  <tr><td></td><td></td>
  <tr><td><input type=button onClick="location.href='http://baseportal.de/cgi-bin/baseportal.pl?htx=/turn/pm/m1&pid=$pid&n3sportid=$n3sportid&su=$su&db=$db&n3id=$n3id&xx='" value=' Endre '> 
 </td></tr>
  </table>
EOF
}
######################################### End Verify Endret #############################################
else
{
endre:

#get "n3sportid==$n3sportid",$db;
get "n3sportid==$n3sportid",$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;


######################################
$BY=substr($_loop{$a3},0,4);
$BM=substr($_loop{$a3},5,2);
$BD=substr($_loop{$a3},8,2);
######################################

out <<EOF;
<font size="3"><b>Medlemsdata (3):</b><!/font><br>
<b>TT-Id: $_loop{"Internt medlemsnr"}</b><br>
NIF-Id: $n3sportid<br>
<font size="1">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="pid=" value="$pid">
   <input type=hidden name="n3sportid=" value="$n3id">
   <input type=hidden name="su=" value="$su">
   <input type=hidden name="db=" value="$db">
   <input type=hidden name="n3id=" value="$n3sportid">
   <input type=hidden name="xx=" value="$xx">

  <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
}
out <<EOF;
  <tr><td></td><td> * Må oppgis!</td>
  <tr><td></td><td><input type=submit value="Lagre data"><br>Det er nødvendig å lagre data for å komme til "Betaling"!</td></tr>
  </form></table><p>
  </center></center>
EOF
}
############################################### End Form Endre ##########################################
}
####################################################################################################
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";
}
####################################################################################################
ende:
</perl>