<perl>
################################################################################################
##### A_veteran/members
##### ver. 1.02, Lagt til påmelding for kort- og lang tur, hbj 2013-03-03 
##### ver. 1.03, Lagt til antall for kort- og lang tur, hbj 2013-04-22
##### ver. 1.04, Lagt til feltet Bankkonto, hbj 2013-11-15
##### ver. 1.05, fix for døde (†) og passive (_), hbj 2014-03-26
##### ver. 1.06, Søk på f.dato E_S_P, hbj 2014-03-28
##### ver. 1.07, bugfix, link i sub modified manglet 'dbName=$db'
##### ver. 1.08, domenet trondhjemsturn.no endret til tt.trondhjemsturn.no, 2023-10-13
##### Ver. 109, "Begynt" lagt til i "Søk", † lagt til for kopiering, Sett basisdata 2025-02-06
##### Ver. 1.10, Lagt tl mulighet for redigering av Brukere, Basisdata, Database og Hent brukerprofil
#####            2025-02-11, HBj  
################################################################################################
 
$Password=$supw if ($Pass);
if ($exp eq "")
{
out <<EOF;
<html>
<head> 
<META NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW">
<title>SAAVEL A-Veteran </title>
</head> 

<body bgcolor=ccffff link="blue" vlink="blue">
<font face=arial,helvetica size=1>
ver. 1.10 avet
EOF
#####

$entered_user=$us if $us;
$us=$entered_user;
#out "/user=$us";
#if ($us && $su ne 3) {out "<center>Du er logget på som <b>$us<b></center>" ;}
#else
#{out "<center>Velkommen til</center>";}

if ($us && $su ne 3) {out " /bruker=$us" ;}

if ($su eq 3){$entered_user=""; $entered_password="";}


$f="<font size=2>";
$W="100%";

out $f;
}
######################################################
if ($ex ne 2 && $ex ne 21)
{#1

 get "Id==0", "users";
 if($k){get "dbName==$k", "users";}
 if($db){get "dbName==$db", "users";}


 if($entered_user){get "UserName==$entered_user", "users";}
 $text1="<center>".$cvar1."<br><center>".$cvar2;
 if($Password && $cvar3){$text1.=" ".$cvar3};
 &split_path();
 if ($exp){&export();goto TheEnd;}


 ### The javascript is put here to be able to use some variables ###
 out <<EOF;
 <html><!--Written by H. Bjerkan, rev. 9.08no  2010-05-14, Norwegian sort order, shows user -->
 <SCRIPT LANGUAGE="javascript">
 <!-- Begin
 var help = null;
 function help1() {
 help = window.open('/baseportal/$dir1/$dir2/help_W98', '', 'width=500,height=500,resizable=1');
 }
 // End -->
 </SCRIPT></head>
EOF
 ######################## End of javascript ########################

 if ($ex ne 4 && $ex ne 5)
 {
  &fieldnames();
  $apw=reverse $AdmPW;
 }
 &head();
 
 if ($Password && $ex ne 5)
 {#2
  $allEmail="";
  $boardEmail="";
  $all_e="";
 
  $ant="";
  get "Id==*", $dbName;;
  while (get_next $dbName)
  {#3
#   if ($_loop{$a7}){$allEmail=$allEmail . $_loop{$a7} . "; ";$all_e ++;}

   if ($_loop{$a6} ne ""){if($_loop{$a7}){$boardEmail=$boardEmail . $_loop{$a7} . "; ";}}

   unless (($_loop{$a1}=~ m/†/)||(substr ($_loop{$a1},0,1) eq "_")){$ant ++;}
  }#3
  chop $allEmail;
  chop $allEmail;
  chop $boardEmail;
  chop $boardEmail;

 }#2
}#1


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

$find="Søk";
$full_find="Fri tekst søk";
$new="Ny";
#$grEmail="E-post til alle grupper";
#$alEmail="E-post til alle";
$export="Eksporter";

$text2="Ingen tilgang!  Prøv igjen";
$text3="'Tilbake til hovedlista'";
$text4="' Logg ut '";

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

if ($ex eq 0){&main();}
else
{
 if ($ex eq 1){&new();}
 else
 {
  if ($ex eq 2 | $ex eq 21){&modify();}
  else
  {
   if ($ex eq 3){&find();}
   else
   {
    if ($ex eq 4){&found();}
    else
    {
     if ($ex eq 5){&delete();}
     else
     {
      if ($exp_){&export_();}
      else
      {
       if ($prt eq 1){&print();}
       else 
       {
        &Password();
        if ($in_upw){&main();}
       }
      }
     }
    }
   }
  }
 }
}
TheEnd:();
##########################################################################
#    Subrutines
##########################################################################
sub fieldnames
{
 get "Id=*", "$dbName.fields", "fields";

 while (get_next("fields"))
 {
 push @f, $Field;

  $a1=$f[2];
  $a2=$f[3];
  $a3=$f[4];
  $a4=$f[5];
  $a5=$f[6];
  $a6=$f[7];
  $a7=$f[8];
  $a8=$f[9];
  $a9=$f[10];
  $a10=$f[11];
  $a11=$f[12];
  $a12=$f[13];
  $a13=$f[14];
  $a14=$f[15];
  $a15=$f[16];
  $a16=$f[17];
  $a17=$f[18];
  $a18=$f[19];
  $a19=$f[20];
  $a20=$f[21];
  $a21=$f[22];
  $a22=$f[23];
  $a23=$f[24];
  $a24=$f[25];

 }
}
##########################################################################
sub main
{
$Password=$Pass if ($Pass);
$cmd_search="$_link&ex=3&k=$dbName&su=$su&us=$us&Pass=$Password&UserName=$UserNam&entered_user=$entered_user&entered_password=$entered_password";
$cmd_full_search="http://www.baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/full_search&entered_user=$entered_user&entered_password=$entered_password";
$cmd_add="$_link&ex=1&k=$dbName&su=$su&us=$us&Pass=$Password&UserName=$UserName&entered_user=$entered_user&entered_password=$entered_password";
$cmd_all="$_link&ex=1&k=$dbName&su=$su&us=$us";
$cmd_export="$_link&exp=1&k=$dbName&su=$su&us=$us";
$cmd_export_="$_link&exp_=1&k=$dbName&su=$su&us=$us";
$cmd_print_0="$_link&prt=1&k=$dbName&su=$su&us=$us";
$cmd_print_1="$_link&prt=1&k=$dbName&su=$su&us=$us&Ph=1";

$text3=$text4;
out "<center>";
&return();
init $dbName;

out "Du er logget på som: <b>$us</b>og bruker databasen: <b>$dbName</b><br><br>";


#http://baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/A_veteran

if ($su) 
{
out <<EOF;
<a href="http://baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/$dbName" TARGET="Window2">Admin databas direkteta</a>_______;
EOF
}

out '<a href="http://baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/giroAdmin" TARGET="Window2">Sett basisdata</a>_______' if $su;

out '<a href="http://baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/users" TARGET="Window2">Admin Brukere</a>_______' if $su;


out '<a href="http://baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/message_board" TARGET="Window2">Åpent Forum</a>_______';


out '<a href="http://baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/MinBrukerprofil" TARGET="Window2">Hent brukerprofil</a><br>';



out <<EOF;
</center>
<!--font size=2>
-&nbsp;<a href="http://home.online.no/~habjerka/kurs/">Veteranklubbens datakurs - lenker</a><br>
-&nbsp;<a href="http://www.fig-gymnastics.com/cache/html/13310-15-10001.html">FIG på besøk - THE SENIORS SHOW THE WAY!</a><br>
<p></font--><center>
<table border=0 cellspacing=0 cellpadding=2 bgcolor=fff000 width=$W>
<tr><td align=left width=20%>$f<b>Endre data: Klikk på etternavn</b></td>
<td align=center width=60%>$f<b>Antall aktive medlemmer: $ant</b></td>
<td align=right width=20%>$f<b>Utskriftsvennlig:&nbsp;<!--a href=$cmd_print_1>M/bilde</a-->&nbsp;&nbsp;<a href=$cmd_print_0>Skriv ut</b></a></td>
</tr>
</table><p>
<div style="float:right"><banner type=skyscraper></div>
EOF

out <<EOF;
<table border=0 cellspacing=0 cellpadding=2 bgcolor=e0e0e0 width=$W>
<tr>
<td width=15% align=left><a href=$cmd_search>$f<b>$find</b></td>
<td width=15% align=left><a href=$cmd_full_search/&dbName=$dbName>$f<b>$full_find</b></td>
<td width=15% align=left><a href=$cmd_add>$f<b>$new</b></td>
<td width=15% align=center><a href=$cmd_export>$f<b>$export</b></td>
<td width=15% align=center><a href='http://baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/slett_tur&tur=Kort'>$f<b>Slett kort tur</b>
<td width=15% align=center><a href='http://baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/slett_tur&tur=Lang'>$f<b>Slett lang tur</b></td>
<td width=20% align=right><a href='mailto:$boardEmail'>$f<b>$grEmail</b></td>
<td width=20% align=right><a href='mailto:$allEmail'>$f<b>$alEmail</b></td>
</tr></table><br> 
EOF

get "Id==*", $dbName;#nnn
&show();
}
##########################################################################
sub found
{
out "<center>";
&return();
init $dbName;

get;
$dbName="";
out "<h4>$_amount oppføringer funnet</h4>", if ($_amount ne 1);
out "<h4>$_amount oppføring funnet</h4>", if ($_amount eq 1);
&show();
}
##########################################################################
sub show
{
#out "su=$su";
$Password=$Pass if ($Pass);


if ($esp)
{
out <<EOF;
<!table bgcolor=000000 datasize=2 border=0 cellspacing=1 cellpadding=2 width=$W>

<table bgcolor=000000 datasize=2 border=1 cellspacing=0 cellpadding=2 width=$W>
<tr bgcolor=c0c0c0>
<td width=10%>$f<b>$a1</b></td>
<td width=10%>$f<b>$a2</b></td>
<td width=12%>$f<b>$a3</b></td>
<td width=5%>$f<b>$a4</b></td>
<td width=10%>$f<b>$a15</b></td>
<td width=8%>$f<b>$a16</b></td>
<td width=8%>$f<b>$a17</b></td>
<td width=15%>$f<b>$a8</b></td>
<td width=2%>$f<b>Kort</b></td>
<td width=2%>$f<b>Lang</b></td>
<td width=10%>$f<b>Bankkonto</b></td>
<td width=3%>$f<b>Firma</b></td>
</tr>
EOF
}
else
{
out <<EOF;
<!table bgcolor=000000 datasize=2 border=0 cellspacing=1 cellpadding=2 width=$W>

<table bgcolor=000000 datasize=2 border=1 cellspacing=0 cellpadding=2 width=$W>
<tr bgcolor=c0c0c0>
<td width=10%>$f<b>$a1</b></td>
<td width=10%>$f<b>$a2</b></td>
<td width=12%>$f<b>$a3</b></td>
<td width=5%>$f<b>$a4</b></td>
<td width=10%>$f<b>$a5</b></td>
<td width=8%>$f<b>$a6</b></td>
<td width=8%>$f<b>$a7</b></td>
<td width=15%>$f<b>$a8</b></td>
<td width=2%>$f<b>Kort</b></td>
<td width=2%>$f<b>Lang</b></td>
<td width=10%>$f<b>Bankkonto</b></td>
<td width=3%>$f<b>Firma</b></td>
</tr>
EOF

}

$i=1;
$allEmail="";
$boardEmail="";
$all_e="";

#nnnnnnnnnnnnnnnnnnnnnnnnn
while (get_next "$dbName")
{
push @list1,"$_loop{$a1}|$_loop{$a2}|$_loop{$a3}|$_loop{$a4}|$_loop{$a5}|$_loop{$a6}|$_loop{$a7}|$_loop{$a8}|$_loop{$a9}|$_loop{$a10}|$_loop{$a11}|$_loop{$a12}|$_loop{$a13}|$_loop{$a14}|$_loop{$a15}|$_loop{$a16}|$_loop{$a17}|$_loop{$a18}|$_loop{$a19}|$Foto|$Id|$_loop{$a21}|$_loop{$a22}|$_loop{$a23}|$_loop{$a24}|$_loop{$a25}";
}

@sorted = sort { normalize($a) cmp normalize($b)
          or normalize2($a) cmp normalize2($b)          
          or $a cmp $b 
          } @list1;

foreach $rec(@sorted)
 {
   @list2=split('\|',$rec);

   $a1=$list2[0];
   $a2=$list2[1];
   $a3=$list2[2];
   $a4=$list2[3];
   $a5=$list2[4];
   $a6=$list2[5];
   $a7=$list2[6];
   $a8=$list2[7];
   $a9=$list2[8];
   $a10=$list2[9];
   $a11=$list2[10];
   $a12=$list2[11];
   $a13=$list2[12];
   $a14=$list2[13];
   $a15=$list2[14];
   $a16=$list2[15];
   $a17=$list2[16];
   $a18=$list2[17];
   $a19=$list2[18];

   $Id=$list2[20];
   $a22=$list2[21];
   $a23=$list2[22];
   $a24=$list2[23];
   $a25=$list2[24];

   #$a22="X" if $a22;
   #$a23="X" if $a23;
#nnnnnnnnnnnnnnnnnnnnnnnnn

if (substr ($a1,0,1) ne "_" &&  substr ($a1,0,1) ne "†")
{# w2

  $allEnv=$allEnv . $Id . "-";


if ($a8){$allEmail=$allEmail . $a8 . "; ";$all_e ++;} #### Tell e-postadresser
if ($a22){$all_k = $all_k + $a22;}                    #### Tell antall påmeldte kort tur
if ($a23){$all_l = $all_l + $a23;}                    #### Tell antall påmeldte lang tur

} # w2

if ($a6 ne ""){if($a8){$boardEmail=$boardEmail . $a8 . "; ";}}

$i++;
if($i % 2==0)
{
out '<tr bgcolor="#e0e0e0">';
} 
else
{
out '<tr bgcolor="#f0f0f0">';
}
if ($a11 eq "") {$a11 = "http://tt.trondhjemsturn.no/HBJ/base/grafikk/Hopspiril.gif";}
if ($k){$dbN=$k;}else {$dbN=$dbName;}#___________&PasswordX=$entered_password

#nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn
  if($a1 eq ""){$_loop{$a1}="&nbsp;"};
  if($a2 eq ""){$a2="&nbsp;"};
  if($a3 eq ""){$a3="&nbsp;"};
  if($a4 eq ""){$a4="&nbsp;"};
  if($a5 eq ""){$a5="&nbsp;"};
  if($a6 eq ""){$a6="&nbsp;"};
  if($a7 eq ""){$a7="&nbsp;"};
  if($a8 eq ""){$a8="&nbsp;"};
  if($a22 eq ""){$a22="&nbsp;"};
  if($a23 eq ""){$a23="&nbsp;"};
  if($a24 eq ""){$a24="&nbsp;"};


if (!$esp)
{
out <<EOF
<td><a href="$_link&Id=$Id&ex=2&db=$dbN&dbName=$dbN&text1=$text1&a1=$a1&a2=$a2&a3=$a3&a4=$a4&a5=$a5&a6=$a6&a7=$a7&a8=$a8&a9=$a9&a10=$a10&a22=$a22&a23=$a23&apw=$apw&entered_password=$entered_password&UserName=$entered_user&Pass=$Pass&logo=$logo&dir=$dir&dir1=$dir1&dir2=$dir2&su=$su&us=$us">$f $a1</a></td>
<td align=left>$f $a2</td>
<td>$f $a3</td>
<td>$f $a4</td>
<td>$f $a5</td>
<td>$f $a6</td>
<td>$f $a7</td>
<td><a href='mailto:$a8'>$f $a8</td>
<td>$f $a22</td>
<td>$f $a23</td>
<td>$f $a24</td>
<td>$f $a25</td>
</tr>
EOF
}
else
{
out <<EOF
<td><a href="$_link&Id=$Id&ex=2&db=$dbN&dbName=$dbN&text1=$text1&a1=$a1&a2=$a2&a3=$a3&a4=$a4&a5=$a5&a6=$a6&a7=$a7&a8=$a8&a9=$a9&a10=$a10&a22=$a22&a23=$a23&apw=$apw&entered_password=$entered_password&UserName=$entered_user&Pass=$Pass&logo=$logo&dir=$dir&dir1=$dir1&dir2=$dir2&su=$su&us=$us">$f $a1</a></td>
<td align=left>$f $a2</td>
<td>$f $a3</td>
<td>$f $a4</td>
<td>$f $a15</td>
<td>$f $a16</td>
<td>$f $a17</td>
<td><a href='mailto:$a8'>$f $a8</td>
<td>$f $a22</td>
<td>$f $a23</td>
<td>$f $a24</td>
<td>$f $a25</td>
</tr>
EOF

}

}# End foreach

chop $allEmail;
chop $allEmail;
chop $boardEmail;
out <<EOF;
</table>

<table width=$W>
<tr><td>
<br>Antallene som er oppgitt gjelder antall på <b>denne lista</b>.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hvis du får feilmelding ved bruk av <b><i>E-post til alle</i>, hent <a href="javascript:help1();">hjelp</a></b>  
</td>
</tr>
</table>

<table bgcolor=000000 datasize=2 border=0 cellspacing=2 cellpadding=2 width=$W>
<tr bgcolor=f0f0f0><td>$f<b>Kort tur: $all_k &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Lang tur: $all_l &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alle E-post adresser ($all_e): </b></td></tr>

<tr bgcolor=ffffff><td width=$w>$f $allEmail</td></tr>
</table>
EOF

&bottom();
out "</center>";
end:;
}
##########################################################################
sub modify
{

&head();
$xId=$Id;
&fieldnames();
$Id=$xId;
$konv=$Id;
$allEnv=$Id;

out "<center>";

if ($ex eq 2){&return();}
if($Id ne "")
{#1
 get "Id==$Id",$dbName;

 if($xEnavn)
 {#2
  $apw=reverse $apw;
  if($Password eq $xPassword && $xNPW1 eq $xNPW2){$pw=1;}
  if($apw eq $xPassword && $xNPW1 eq $xNPW2){$pw=1;}
  $apw=reverse $apw;

  if($pw)
  {#3
   if($xNPW1 eq ""){$xNPW1=$Password}
   if($xNPW1 eq "X"){$xNPW1=""}

if ($su eq 1)
{
   if($xFirma eq $_loop{$a24} && $xEnavn eq $_loop{$a1} && $xFnavn eq $_loop{$a2} && $xAdresse eq $_loop{$a3} && $xPostnr eq $_loop{$a4} && $xSted eq $_loop{$a5} && $xMobil eq $_loop{$a6} && $xFdato eq $_loop{$a7} && $xEpost eq $_loop{$a8} && $xRem eq $_loop{$a9} && $xTlf eq $_loop{$a10} && $xMobil2 eq $_loop{$a11} && $xBegynt eq $_loop{$a12} && $xSluttet eq $_loop{$a13} && $xSluttAnGr eq $_loop{$a14} && $xEnavnESP eq $_loop{$a15} && $xFnavnESP eq $_loop{$a16} && $xFdatoESP eq $_loop{$a17} && $xMobilESP eq $_loop{$a18} && $xEpostESP eq $_loop{$a19} && $xNPW1 eq $Password && $xFoto eq $Foto && $xKort eq $Kort && $xLang eq $Lang && $xKonto eq $Bankkonto){$nc=1}}
else
{
   if($xFirma eq $_loop{$a24} && $xEnavn eq $_loop{$a1} && $xFnavn eq $_loop{$a2} && $xAdresse eq $_loop{$a3} && $xPostnr eq $_loop{$a4} && $xSted eq $_loop{$a5} && $xMobil eq $_loop{$a6} && $xFdato eq $_loop{$a7} && $xEpost eq $_loop{$a8} && $xRem eq $_loop{$a9} && $xTlf eq $_loop{$a10} && $xMobil2 eq $_loop{$a11} && $xBegynt eq $_loop{$a12} && $xSluttet eq $_loop{$a13} && $xSluttAnGr eq $_loop{$a14} && $xEnavnESP eq $_loop{$a15} && $xFnavnESP eq $_loop{$a16} && $xFdatoESP eq $_loop{$a17} && $xMobilESP eq $_loop{$a18} && $xEpostESP eq $_loop{$a19} && $xNPW1 eq $Password && $xKort eq $Kort && $xLang eq $Lang && $xKonto eq $Bankkonto){$nc=1}
}
################
if ($su eq "2"){$nc=1;}
################

if ($nc)
    {#4
     $NChg = "1" if ($xdelete eq "");
    }#4

    if ($NChg eq "")
    {#5
     mod "Id==$Id",   ["Firma",$xFirma,"Bankkonto",$xKonto,"Kort",$xKort,"Lang",$xLang,$a1,$xEnavn,$a2,$xFnavn,$a3,$xAdresse,$a4,$xPostnr,$a5,$xSted,$a6,$xMobil,$a7,$xFdato,$a8,$xEpost,$a9,$xRem,$a10,$xTlf,$a11,$xMobil2,$a12,$xBegynt,$a13,$xSluttet,$a14,$xSluttAnGr,$a15,$xEnavnESP,$a16,$xFnavnESP,$a17,$xFdatoESP,$a18,$xMobilESP,$a19,$xEpostESP,"Password",$xNPW1,];
     if ($su eq 1){mod "Id==$Id",["Foto",$xFoto];}

     $Chg="Endret";
     if($xdelete){$Chg="Slettet"}
     if($xdelete eq "")
     {#6
      put["Firma",$xFirma,"Bankkonto",$xKonto,"Kort",$xKort,"Lang",$xLang,"Foto",$xFoto,"Club",$db,"Trans.",$Chg,$a1,$xEnavn,$a2,$xFnavn,$a3,$xAdresse,$a4,$xPostnr,$a5,$xSted,$a6,$xMobil,$a7,$xFdato,$a8,$xEpost,$a9,$xRem,$a10,$xTlf,$a11,$xMobil2,$a12,$xBegynt,$a13,$xSluttet,$a14,$xSluttAnGr,$a15,$xEnavnESP,$a16,$xFnavnESP,$a17,$xFdatoESP,$a18,$xMobilESP,$a19,$xEpostESP,"Password",$xNPW1,"IP-adr.",$_REMOTE_ADDR],"log";

     }#6
    }#5
   }#3

###############################
#$a1="xxxxxxxxxxxx";
###############################

  &modified();
 }#2
 else
 {#7
  if ($Foto eq "" && $Id % 2==0)
  {#8
   #$Photo="<img src='http://home.online.no/~habjerka/base/grafikk/Hopspiril.gif' align=center height=200>";
  }#8

  elsif ($Foto eq "" && $Id % 2==1)
  {#9
   #$Photo="<img src='http://home.online.no/~habjerka/base/grafikk/Hopspiril.gif' align=center height=200>";
  }#9
  else 
  {#10
   #$Photo="<img src=\"".$Foto."\" align=center height=150>";
  }#10
  if ($su eq 1)
  {#11
   $FotoFelt="<td align=right>Foto URL:</td><td><input type='text' name='xFoto=' value='$_loop{Foto}' size=35></td>";$supw=reverse $apw;
  }#11
  $mnr = $Id + 1000;


  out <<EOF;
  <center>

  <h3>Kartotekkort for: <i>$_loop{$a2} $_loop{$a1}, (int. Id $mnr).</i></h3>
  <form action=$_link&Id=$xId&ex=21&db=$db method="post" enctype="multipart/form-data">
  <input type=hidden name="text1=" value="$text1">
  <input type=hidden name="a1=" value="$a1">
  <input type=hidden name="a2=" value="$a2">
  <input type=hidden name="a3=" value="$a3">
  <input type=hidden name="a4=" value="$a4">
  <input type=hidden name="a5=" value="$a5">
  <input type=hidden name="a6=" value="$a6">
  <input type=hidden name="a7=" value="$a7">
  <input type=hidden name="a8=" value="$a8">
  <input type=hidden name="a9=" value="$a9">
  <input type=hidden name="a10=" value="$a10">
  <input type=hidden name="a11=" value="$a11">
  <input type=hidden name="a12=" value="$a12">
  <input type=hidden name="a13=" value="$a13">
  <input type=hidden name="a14=" value="$a14">
  <input type=hidden name="a15=" value="$a15">
  <input type=hidden name="a16=" value="$a16">
  <input type=hidden name="a17=" value="$a17">
  <input type=hidden name="a18=" value="$a18">
  <input type=hidden name="a19=" value="$a19">
  <input type=hidden name="a21=" value="$a21">
  <input type=hidden name="a22=" value="$a22">
  <input type=hidden name="a24=" value="$a24">
  <input type=hidden name="apw=" value="$apw">
  <input type=hidden name="logo=" value="$logo">
  <input type=hidden name="dir1=" value="$dir1">
  <input type=hidden name="dir2=" value="$dir2">
  <input type=hidden name="dbName=" value="$dbName">
  <input type=hidden name="su=" value="$su">
  <input type=hidden name="us=" value="$us">
  <input type=hidden name="Pass=" value="$Pass">
  <input type=hidden name="allEnv=" value="$konv">
  <input type=hidden name="entered_password=" value="$entered_password">
  <input type=hidden name="entered_user=" value="$entered_user">
  <!input type=hidden name="ex=" value="$ex">
  <table>
  <tr><td>$Photo $Photo2</td></tr>
  </table>
  <table>
  <tr><td align=right>$a1:</td><td><input type="text" name="xEnavn=" value="$_loop{$a1}"></td>
      <td align=right>$a2:</td><td><input type="text" name="xFnavn=" value="$_loop{$a2}"></td></tr>
  <tr><td align=right>$a3:</td><td><input type="text" name="xAdresse=" value="$_loop{$a3}"></td>
      <td align=right>$a4:</td><td><input type="text" name="xPostnr=" value="$_loop{$a4}"></td></tr>
  <tr><td align=right>$a5:</td><td><input type="text" name="xSted=" value="$_loop{$a5}"></td>
      <td align=right>$a10:</td><td><input type="text" name="xTlf=" value="$_loop{$a10}" size=35></td></tr>
  <tr><td align=right>$a6:</td><td><input type="text" name="xMobil=" value="$_loop{$a6}"></td>
      <td align=right>$a11:</td><td><input type="text" name="xMobil2=" value="$_loop{$a11}" size=35></td></tr>
  <tr><td align=right>$a7:</td><td><input type="text" name="xFdato=" value="$_loop{$a7}"></td>
      <td align=right>$a8:</td><td><input type="text" name="xEpost=" value="$_loop{$a8}" size=35></td></tr>
  <tr><td align=right>$a12:</td><td><input type="text" name="xBegynt=" value="$_loop{$a12}"></td>
      <td align=right>$a13:</td><td><input type="text" name="xSluttet=" value="$_loop{$a13}" size=35></td></tr>
  <tr><td align=right>$a14:</td><td><input type="text" name="xSluttAnGr=" value="$_loop{$a14}"></td>
      <td align=right>$a24:</td><td><input type="text" name="xFirma=" value="$_loop{$a24}"></td></tr>
  <tr><td> </td><td><br>Ektefelle, samboer, partner </td></tr>
  <tr><td align=right>$a15:</td><td><input type="text" name="xEnavnESP=" value="$_loop{$a15}"></td>
      <td align=right>$a16:</td><td><input type="text" name="xFnavnESP=" value="$_loop{$a16}" size=35></td></tr>
  <tr><td align=right>$a17:</td><td><input type="text" name="xFdatoESP=" value="$_loop{$a17}"></td>
      <td align=right>$a18:</td><td><input type="text" name="xMobilESP=" value="$_loop{$a18}" size=35></td></tr>
  <tr><td align=right>$a19:</td><td><input type="text" name="xEpostESP=" value="$_loop{$a19}"></td>
      <td align=right></td><td></td></tr>
  <tr><td> </td><td><br>Merknader, personlig passord, slett fra databasen</td></tr>
  <tr><td align=right>$a9:</td><td><textarea name="xRem=">$_loop{$a9}</textarea></td>
            $FotoFelt</tr>
  <tr><td align=right>Nytt passord:</td><td><input type="password" name="xNPW1="></td>
      <td align=right>Gjenta nytt passord:</td><td><input type="password" name="xNPW2="></td></tr>
  <tr><td>&nbsp</td></tr>
  <tr><td align=right>Passord:</td><td><input type="password" name="xPassword=" value="$supw"></td>
  <td align=right>Slett fra database:</td><td><input type="checkbox" name="xdelete="></td>

  <!--td><a href='http://tt.trondhjemsturn.no/cgi-bin/utpwAvet.pl?Navn=$_loop{$a1}&fnavn=$_loop{$a2}'>Glemt personlig passord?</td</tr-->

  <td><a href='http://baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/glemtPassord_Copy&Navn=$_loop{$a1}&fnavn=$_loop{$a2}'>Glemt personlig passord?</td</tr>

  <tr><td align=right>Påmelding kort tur:</td><td><input type="text" name="xKort=" value="$_loop{$a21}" size=1></td></tr>

  <tr><td align=right>Påmelding lang tur:</td><td><input type="text" name="xLang=" value="$_loop{$a22}" size=1></td></tr>

  <tr><td align=right>Bankkonto:</td><td><input type="text" name="xKonto=" value="$Bankkonto" size=15></td></tr>

  <tr><td></td><td></td>
  <tr><td></td><td><input type=submit value="Utfør endring"> </td></tr>
  </form></table><p>
  </center></center><h6 align=right>

EOF
 }#7
}#1

get "Id==0", "users";
if($k){get "dbName==$k", "users";}
if($db){get "dbName==$db", "users";}
if($entered_user){get "UserName==$entered_user", "users";}
$text1=$cvar1." ".$cvar2." ".$cvar3;
#$a7=$_loop{$a7};

if ($Password && $ex ne 5)
{#12
 $allEmail="";
 $boardEmail="";
 get "Id==*",$dbName;
 while (get_next $dbName)
 {#13

#14 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
  if ($_loop{$a7}){$allEmail=$allEmail . $_loop{$a7} . "; ";}
  if ($_loop{$a6} ne ""){if($_loop{$a7}){$boardEmail=$boardEmail . $_loop{$a7} . "; ";}}
#14
 }#13

 chop $allEmail;
 chop $allEmail;
 chop $boardEmail;
}#12

&bottom();
}
#################################################################
sub return
{
out "<center>";
#if ($text3 eq " Logg ut ") {$su=3;}

out <<EOF;
<table><tr><td>$f
<form action='$_link' method='post' enctype='multipart/form-data' >
<input onclick=history.go(-1); type=button value='   <---   '> 
<input type=submit value=$text3> 
<input onclick=history.go(1); type=button value='   --->   '>

</td></tr></table></center>
<center><a href="#bottom"><font face="arial" size="1">Til bunnen</font></a></center><br>
EOF





if($text4 ne $text3)
{
out <<EOF;
<input type=hidden name='ex=' value=0>
<input type=hidden name='db=' value='$db'>
<input type=hidden name='entered_user=' value='$UserName'>
<input type=hidden name='su=' value='3'>
<input type=hidden name='us=' value='$us'>
<input type=hidden name='entered_user=' value='$entered_user'>
<input type=hidden name='entered_password=' value='$entered_password'>
EOF
}
out <<EOF;
<input type=hidden name='Pass=' value='$Pass'>
<input type=hidden name='su=' value=$su>
</form>
EOF
}
##########################################################################
sub delete
{

del Id==$Id;
&fieldnames();
$apw=reverse $AdmPW;

put
["Foto",$xFoto,"Club",$db,"Trans.",$Chg,$a1,$_loop{$a1},$a2,$_loop{$a2},$a3,$_loop{$a3},$a4,$_loop{$a4},$a5,$_loop{$a5},$a6,$_loop{$a6},$a8,$_loop{$a8},$a7,$_loop{$a7},$a9,$_loop{$a9},"Password",$xNPW1,"IP-adr.",$_REMOTE_ADDR],"log";

$ex=0;
out "<center><p><b>Oppføringen er slettet for:<i> $_loop{$a1}&nbsp;$_loop{$a2}</i></b></p></center>";
&main();
}
#################################################################
sub modified
{
$konv=$Id;
$allEnv=$Id;
#out "su=$su";
if ($su eq 2){$xdelete="";$NChg=1;}
&return();
if($pw)
{
  $noperm=" (ikke tillatt)" if $su eq "2";
  out "<br><h4><b>Oppføringen er endret for:<i> $_loop{$a2}&nbsp;$_loop{$a1}</i></b></h4>" if($xdelete eq "" && $xNPW2 eq "" && $NChg eq "");
  out "<br><h4><b>Passord er endret for:<i> $_loop{$a1}&nbsp;$_loop{$a2}</i></b></h4>" if($xNPW2 && $xNPW2 ne "X" && $su ne 2);
  out "<br><h4><b>Passord er slettet for:<i> $_loop{$a1}&nbsp;$_loop{$a2}</i></b></h4>" if($xNPW2 eq "X");
  out "<br><h4><b>Ingen endring for:<i> $_loop{$a2}&nbsp;$_loop{$a1}</i></b>$noperm</h4>" if($NChg);

  if($xdelete)
  {
  out <<EOF;
  <a href=$_link&db=$db&ex=5&Id=$Id&Chg=$Chg&su=$su&us=$us&Pass=$Pass onclick="return confirm('Er du sikker? Oppføringen vill bli slettet for: $_loop{$a1} $_loop{$a2}?')"><b>Slett oppføring for: <i>$_loop{$a1}&nbsp;$_loop{$a2}</b></b></a></h6>
EOF
  }

}
else
{
out "<br><b><h3>Feil passord!</h3></b>";
}


get "Id==$Id";

#$Kort="X" if $Kort;
#$Lang="X" if $Lang;

out <<EOF;
<center>
<table bgcolor=000000 datasize=2 border=0 cellspacing=1 cellpadding=2 width=$W>
<!table bgcolor=e0e0e0 datasize=2 border=1 cellspacing=0 cellpadding=2 width=$W>
<tr bgcolor=c0c0c0>
<td width=10%>$f<b>$a1</b></td>
<td width=10%>$f<b>$a2</b></td>
<td width=15%>$f<b>$a3</b></td>
<td width=5%>$f<b>$a4</b></td>
<td width=10%>$f<b>$a5</b></td>
<td width=10%>$f<b>$a6</b></td>
<td width=10%>$f<b>$a7</b></td>
<td width=15%>$f<b>$a8</b></td>
<td width=3%>$f<b>Kort</b></td>
<td width=3%>$f<b>Lang</b></td>
<td width=10%>$f<b>Bankkonto</b></td>
<td width=3%>$f<b>Firma</b></td>
</tr>


<!--a href="$_link&Id=$Id&ex=2&db=$dbN&dbName=$dbN&text1=$text1&a1=$a1&a2=$a2&a3=$a3&a4=$a4&a5=$a5&a6=$a6&a7=$a7&a8=$a8&a9=$a9&a10=$a10&a22=$a22&apw=$apw&UserName=$entered_user&Pass=$Pass&logo=$logo&dir=$dir&dir1=$dir1&dir2=$dir2&su=$su&us=$us">

<a href="$_link&Id=$Id&ex=2&db=$db&text1=$text1&a1=$a1&a2=$a2&a3=$a3&a4=$a4&a5=$a5&a6=$a6&a7=$a7&a8=$a8&a9=$a9&a10=$a10&a11=$a11&a12=$a12&a13=$a13&a14=$a14&a15=$a15&a16=$a16&a17=$a17&a18=$a18&a19=$a19&Kort=$Kort&ch=$ch&apw=$apw&logo=$logo&su=$su&us=$us&Pass=$Pass"-->


<tr bgcolor="#e0e0e0"><td>$f<a href="$_link&entered_user=$entered_user&entered_password=$entered_password&Id=$Id&ex=2&db=$db&dbName=$db&text1=$text1&a1=$a1&a2=$a2&a3=$a3&a4=$a4&a5=$a5&a6=$a6&a7=$a7&a8=$a8&a9=$a9&a10=$a10&a11=$a11&a12=$a12&a13=$a13&a14=$a14&a15=$a15&a16=$a16&a17=$a17&a18=$a18&a19=$a19&apw=$apw&logo=$logo&su=$su&us=$us&Pass=$Pass&a21=$a21&a22=$a22&a24=$a24">$_loop{$a1}</a></td>
<td align=left>$f $_loop{$a2}</td>
<td>$f $_loop{$a3}</td>
<td align=center>$f $_loop{$a4}</td>
<td>$f $_loop{$a5}</td>
<td>$f $_loop{$a6}</td>
<td>$f $_loop{$a7}</td>
<td>$f <a href='mailto:$_loop{$a8}'>$_loop{$a8}</a></td>
<td>$f $Kort</td>
<td>$f $Lang</td>
<td>$f $Bankkonto</td>
<td>$f $Firma</td>

<!--td nowrap>$f $_loop{$a8}</td--></tr></table>
</center>
EOF
}
##########################################################################
sub bottom
{

$alEmail="E-post til alle";

$dbName=$db1 if $db1;
$dbName=$dbN if $dbN;

out <<EOF;
<p align="left">For kopiering:<br>
†
<script>
function submitForm()
{
   document.form1.submit();
}
</script>

<form name="form1" method="post" action="$homepage">

<center>
<br>
<table border=0 cellspacing=0 cellpadding=2 bgcolor=c0c0c0 width=$W>
<tr>
  <td align=center width=14%><a href='mailto:''>$f<b>Send E-post</b></a></td>
  <td align=center width=14%><a href='mailto:$email'>$f<b>Send oss E-post</b></a></font></td>
  <td align=center width=14%><a href='http://www.baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/brevomslagGiro&dbName=$dbName&konv=$allEnv&su=$su'>$f<b>Konvolutter, adresselapper,giro</b></td>
  <td align=center width=14%><a href='mailto:$allEmail'>$f<b>$alEmail</b></td>
  <td align=center width=14%><a href='http://baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/brevomslagGiro&konv=$allEnv&su=$su&dbName=$dbName'>$f<b>Lag konvolutt(er)</b></a></td>         
</tr></table><!/center>
<br>
</form>

<a name="bottom">&nbsp;</a>
<a href="#top"><font face="arial" size="1">Til toppen</font></a><br><br>

<a href="http://baseportal.com/cgi-bin/baseportal.pl?htx=/main&uid=$path[1]&dir=$dir">Admin DB</a>
&nbsp;&nbsp;<!a href=$cmd_export_><a href="$_link&exp_=1&k=veteran&su=$su&us=$us">Full eksport</a>&nbsp;&nbsp;<a href="/baseportal/$dir1/$dir2/log?entered_user=$us&entered_password=$entered_password&ex=1"target="window2">Se logg</a><br>


</font></body>
</html>
EOF

#if ($allEnv) {mod"Id==1",[konv,$allEnv],"envelope";}

}
##########################################################################
sub new
{
if ($su eq 2){out "<p><center><b>Ikke tillatt for gjester!";&return;}
else
{
if (%_put)
{
 if($pw1 eq $pw2)
 {
  $x1="-No Id-",if($x1 eq "");
  $x2="-No Name-",if($x2 eq "");
  put["Kort",$xKort,"Lang",$xLang,$a1,$x1,$a2,$x2,$a3,$x3,$a4,$x4,$a5,$x5,$a6,$x6,$a7,$x7,$a8,$x8,$a9,$x9,$a10,$x10,$a11,$x11,$a12,$x12,$a13,$x13,$a14,$x14,$a15,$x15,$a16,$x16,$a17,$x17,$a18,$x18,$a19,$x19,"Password",$pw1],$dbName;

  put["Kort",$xKort,"Lang",$xLang,"Trans.","Ny",$a1,$x1,$a2,$x2,$a3,$x3,$a4,$x4,$a5,$x5,$a6,$x6,$a7,$x7,$a8,$x8,$a9,$x9,$a10,$x10,$a11,$x11,$a12,$x12,$a13,$x13,$a14,$x14,$a15,$x15,$a16,$x16,$a17,$x17,$a18,$x18,$a19,$x19,
  "Password",$pw1,"IP-adr.",$_REMOTE_ADDR],"log";

  $p="<center><b>Oppføring lagret for: <i>$x1&nbsp;$x2</i><b></center>";
  $x1="";$x2="";$x3="";$x4="";$x5="";$x6="";$x7="";$x8="";$pw1="";

   }
 else
 {
 $p="<center><b>Passord må være like! Vennligst tast passord på nytt!</<b></center>";
 }
}

&return();
$x9="";

if ($su eq 1){$FotoFelt="<td align=right>Foto URL:</td><td><input type='text' name='xFoto='  size=35></td>";} 
#$FotoFelt="<td align=right>Foto URL:</td><td><input type='text' name='xFoto='  size=35></td>";

out <<EOF;
<center>
<h3>Ny oppføring:</h3>
Du kan endre oppføringen din med ditt valgte passord senere.

<table>
<form action=$_link&db=$dbName&ex=1&su=$su&us=$us&Pass=$Pass method="post" enctype="multipart/form-data">
<input type="hidden" name="xx:=" value="xx">
<input type="hidden" name="entered_user=" value="$entered_user">
<input type="hidden" name="entered_password=" value="$entered_password">

  <tr><td align=right>$a1:</td><td><input type="text" name="x1=" value=$x1></td>
      <td align=right>$a2:</td><td><input type="text" name="x2=" value=$x2></td></tr>
  <tr><td align=right>$a3:</td><td><input type="text" name="x3=" value=$x3></td>
      <td align=right>$a4:</td><td><input type="text" name="x4=" value=$x4></td></tr>
  <tr><td align=right>$a5:</td><td><input type="text" name="x5=" value=$x5></td>
      <td align=right>$a10:</td><td><input type="text" name="x10=" value=$x10></td></tr>
  <tr><td align=right>$a6:</td><td><input type="text" name="x6=" value=$x6></td>
      <td align=right>$a11:</td><td><input type="text" name="x11=" value=$x11></td></tr>
  <tr><td align=right>$a7:</td><td><input type="text" name="x7=" value=$x7></td>
      <td align=right>$a8:</td><td><input type="text" name="x8=" value=$x8></td></tr>
  <tr><td align=right>$a12:</td><td><input type="text" name="x12=" value=$x12></td>
      <td align=right>$a13:</td><td><input type="text" name="x13=" value=$x13></td></tr>
  <tr><td align=right>$a14:</td><td><input type="text" name="x14=" value=$x14></td>
      <td align=right></td><td></td></tr>
  <tr><td> </td><td><br>Ektefelle, samboer, partner </td></tr>
  <tr><td align=right>$a15:</td><td><input type="text" name="x15=" value=$x15></td>
      <td align=right>$a16:</td><td><input type="text" name="x16=" value=$x16></td></tr>
  <tr><td align=right>$a17:</td><td><input type="text" name="x17=" value=$x17></td>
      <td align=right>$a18:</td><td><input type="text" name="x18=" value=$x18></td></tr>
  <tr><td align=right>$a19:</td><td><input type="text" name="x19=" value=$x19></td>
      <td align=right></td><td></td></tr>
  <tr><td> </td><td><br>Merknader, personlig passord, slett fra databasen</td></tr>
  <tr><td align=right>$a9:</td><td><textarea name="x9=" value=$x9></textarea></td>
            $FotoFelt</tr>
  <tr><td align=right>Nytt passord:</td><td><input type="password" name="pw1"></td>
      <td align=right>Gjenta nytt passord:</td><td><input type="password" name="pw2"></td></tr>

  <!--tr><td align=right>Slett fra database:</td><td><input type="checkbox" name="xdelete="></td>

  <tr><td align=right>Passord:</td><td><input type="password" name="xPassword=" value="$supw"></td></tr-->
  <tr><td></td><td></td>
  <tr><td></td><td><input type=submit value="Lagre"> </td></tr>
  </form></table><p>
  </center></center><h6 align=right>





EOF
}
out $p;
&bottom();
}

##########################################################################
sub find
{
&return();
out <<EOF;
<center>
<h3>Søk:</h3>
<table><form action=$_link&cmd=search&db=$dbName&dbName=$dbName&k=$k&ex=4&Pass=$Pass method="post" enctype="multipart/form-data">
<!input type=hidden name="text4=" value="">
<input type=hidden name="a1=" value="$a1">
<input type=hidden name="a2=" value="$a2">
<input type=hidden name="a3=" value="$a3">
<input type=hidden name="a4=" value="$a4">
<input type=hidden name="a5=" value="$a5">
<input type=hidden name="a6=" value="$a6">
<input type=hidden name="a7=" value="$a7">
<input type=hidden name="a8=" value="$a8">
<input type=hidden name="a9=" value="$a9">

<input type=hidden name="a12=" value="$a12">

<input type=hidden name="a15=" value="$a15">
<input type=hidden name="a16=" value="$a16">
<input type=hidden name="a17=" value="$a17">
<input type=hidden name="a18=" value="$a18">
<input type=hidden name="a21=" value="$a21">
<input type=hidden name="a22=" value="$a22">
<input type=hidden name="a23=" value="$a23">
<input type=hidden name="a24=" value="$a24">
<input type=hidden name="apw=" value="$apw">
<input type=hidden name="su=" value="$su">
<input type=hidden name="us=" value="$us">
<input type=hidden name="entered_user=" value="$entered_user">
<input type=hidden name="entered_password=" value="$entered_password">

<tr><td align=right>$a1:</td><td><input type="text" name="$a1~=" value=""></td></tr>
<tr><td align=right>$a2:</td><td><input type="text" name="$a2~="></td></tr>
<tr><td align=right>$a3:</td><td><input type="text" name="$a3~="></td></tr>
<tr><td align=right>$a4:</td><td><input type="text" name="$a4~="></td></tr>
<tr><td align=right>$a5:</td><td><input type="text" name="$a5~="></td></tr>
<tr><td align=right>$a6:</td><td><input type="text" name="$a6~=" size=35></td></tr>
<tr><td align=right>$a7:</td><td><input type="text" name="$a7~=" size=35></td></tr>
<tr><td align=right>$a8:</td><td><input type="text" name="$a8~=" size=35></td></tr>

<tr><td align=right>$a12:</td><td><input type="text" name="$a12~=" size=4></td></tr>


<tr><td align=right>$a17:</td><td><input type="text" name="$a17~=" size=35></td></tr>

<tr><td align=right>Vis data for E_S_P:</td><td><input type="checkbox" name="esp" value="1"></td></tr>
<tr><td align=right>$a8:</td><td><input type="text" name="$a8~="></td></tr>
<tr><td align=right>Korttur, antall lik eller større:</td><td><input type="text" name="$a21>=" size=1></td></tr>
<tr><td align=right>Langtur, antall lik eller større:</td><td><input type="text" name="$a22>=" size=1></td></tr>
<tr><td></td>
<td nowrap><input type=submit value=" Søk "> </td></tr></form></table></td></tr>
</table></center>
EOF
&bottom();
}
##########################################################################
sub head
{
out <<EOF;
<center>
<table><tr valign=center>
<td><img src=$logo width=100 hight=100></td>
<td><h1>&nbsp;&nbsp;$text1&nbsp;&nbsp;</h1></td>
<td><img src=$logo width=100 hight=100></td>
</tr></table>
EOF
if($Founded){out "Stiftet&nbsp;$Founded<br>";}
out "</center>";
}
##########################################################################
sub Password
{#1
out "<center>";
  if($entered_user eq "")
  {#2
out <<EOF;
  <b>Tast brukernavn og passord:</b>
  <form action='$_link' method='post' enctype='multipart/form-data'>
  <table bgcolor=a0a0a0 cellpadding=2 border=1 cellspacing=0>
  <tr><td>$f Brukernavn:</td><td><input type="text" name="entered_user="></td></tr>
  <tr><td>$f Passord:</td><td><input type="password" name="entered_password="></td></tr>
  </table>
  <table>
  <tr><td></td><td>$f<input type=submit value="Logg inn"></td></tr>
  </table></form>
Glemt brukernavn eller passord ? <a href="http://baseportal.com/cgi-bin/baseportal.pl?htx=/habjerka/A_veteran/glemtPassord_Copy">Klikk her</a><br>
EOF
  }#2
  if($entered_user ne "")
  {#3
    get "UserName==$entered_user", "users";
    if($UserName eq $entered_user && $Password eq $entered_password || $AdmPW eq $entered_password)
    {#4
      $in_upw="1";$Pass=$Password;
      if ($AdmPW eq $entered_password){$su=1;}
      if ($Password eq "velkommen"){$su=2;}
    }#4
    else
    {#5
      out <<EOF;
      <img src="http://tt.trondhjemsturn.no/HBJ/base/grafikk/keeper.jpg" align=center width=100>
      <br>
      <table>
      <tr>
      <td align=center>$f<b><font size=4 color='#f00000'><a href=$_link>$text2</b></td>
      </tr></table>
EOF
    }#5
  }#3
out "</center>"; 

}#1
##########################################################################
sub export
{
init $dbName;
$mdb=$dbName;

$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=*", "$mdb.fields", "fields";

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

 out "\n";

 get "Id=* & sort=Etternavn","$mdb";
 while(get_next($mdb)) 
 {

foreach (@f)
  {
   #${$_} = convert_html(${$_});
   $_loop{$_} = convert_br($_loop{$_});# Same as: $_loop{$_} =~ s/\n/<br>/g;
   out $_loop{$_},$sep;
  } 
  out "\n";
 }

}
##########################################################################
sub export_
{
#out "su=$su";
out "<center>";
&return();


$filename = $dbName =~ /\// ? substr $dbName, rindex $dbName, '/' : $dbName;
$filename =~ s/\W//g;
$filename=$filename ."\.csv";



out <<EOF;
<br>
<title>baseportal</title>
<link rel="shortcut icon" href="http://www.baseportal.de/favicon.ico">
<link rel="stylesheet" type="text/css" href="/default.css">
</head>
<body bgcolor=ffffff vlink=0000f0 link=0000f0 alink=0000f0>
<center>
<table cellspacing=4 width=$W cellpadding=2 class=titleline><tr><td>&nbsp;
<span class=title>Last ned database&nbsp;</span></td></tr></table></center>
<ul><table><tr><td><table class=form>
<form action="baseportal.pl/$filename" method="post" enctype="multipart/form-data">
<input type=hidden name="htx=" value="/main">
<input type=hidden name="rcmd=" value="file">
<input type=hidden name="cmd=" value="export">
<input type=hidden name="dir=" value=$dir2>
<input type=hidden name="c=" value="1">
<input type=hidden name="type=" value="1">
<input type=hidden name="db=" value=$dbName>
<input type=hidden name="uid=" value=$dir1>
<input type=hidden name="sid=" value=$sid2>
<input type=hidden name="upw=" value="boston">
<input type=hidden name="su=" value="$su">
<input type=hidden name="us=" value="$us">

<tr><th></th>
<tr><th>
Kolonneseparator:
</th>
<td class=Separator_columns>
<select name='Trenner Spalten=' size=1 name='_baseportal_form0'>
<option value=';'>Semikolon (;)
<option value='_tb_'>Tab
<option value=','>Komma (,)
<option value='_cr_'>Return
<option value='_lf_'>Linjeskift
<option value='_lfcr_'>Linjeskift+Return
<option value='|'>Stolpe (|)
<option value=':'>Kolon (:)
<option value='-'>Bindestrek (-)
<option value='#'>Nummertegn (#)
</select> 
<tr><th>
eller:
</th>
<td class=or>
<input type='text' name='trsp2=' size=3 value=''></td></tr>
<tr>
<th>Linjeseparator:</th>
<td class=Separator_rows>
<select name='Trenner Zeilen=' size=1 name='_baseportal_form0'>
<option value='_lfcr_'>Linjeskift+Return
<option value='_cr_'>Return
<option value='_lf_'>Linjeskift
<option value='_tb_'>Tab
<option value=';'>Semikolon (;)
<option value=','>Komma (,)
<option value='|'>Stolpe (|)
<option value=':'>Kolon (:)
<option value='-'>Bindestrek (-)
<option value='#'>Nummmertegn (#)
</select> 
<tr><th>
eller:
</th>
<td class=or><input type='text' name='trzl2=' size=3 value=''></td></tr>
<tr><th>
Separator i tekst:
</th>
<td class=Separator_in_the_text>
<select name='Trenner im Text=' size=1 name='_baseportal_form0'>
<option value='_qu_'>Anførselstegn (') for identifisering av tekst
<option value='_am_'>Ampersand (') for identifisering av tekst
<option value='_bs_'>Backslash (\) for escape
<option value='_no_'>Ingen
</select></td></tr>
<tr><th>
Ta med feltnavn som første linje:
</th>
<td class=Output_field_names_as_first_row>
<input type='checkbox' name='fn1=' value=1 checked></td></tr>
<tr><th>
Sorter etter:
</th>
<td class=Sorting>
<select name="Sortierung=" name="_baseportal_form0">
<option>$a1
<option>Id
<option>$a2
<option>$a3
<option>$a4
<option>$a5
<option>$a6
<option>$a7
<option>$a8
<option>$a9
<option>$a10
<option>$a11
<option>$a12
<option>$a13
<option>$a14
<option>$a15
<option>$a16
<option>$a17
<option>$a18
<option>$a19
<option>$a20
<option>$a21
<option>$a22




</select> 
<tr><th>
Omvendt rekkefølge:
</th>
<td class=Reverse_order>
<input type="checkbox" name="Reihenfolge umkehren=" value=1>
</td></tr>
<tr><th>
Last ned feltene:
</th>
<!-td class=Export_fields>
<td class=Export_fields>
<input type=checkbox name="set_fields0=" value="Id">&nbsp;Id 
<input type=checkbox name="set_fields1=" value="$a1" checked>&nbsp;$a1
<input type=checkbox name="set_fields2=" value="$a2" checked>&nbsp;$a2
<input type=checkbox name="set_fields3=" value="$a3" checked>&nbsp;$a3
<input type=checkbox name="set_fields4=" value="$a4" checked>&nbsp;$a4
<input type=checkbox name="set_fields5=" value="$a5" checked>&nbsp;$a5
<input type=checkbox name="set_fields6=" value="$a6" checked>&nbsp;$a6
<input type=checkbox name="set_fields7=" value="$a7">&nbsp;$a7
<input type=checkbox name="set_fields8=" value="$a8" checked>&nbsp;$a8
<input type=checkbox name="set_fields9=" value="$a9">&nbsp;$a9
<input type=checkbox name="set_fields10=" value="$a10">&nbsp;$a10
<input type=checkbox name="set_fields11=" value="$a11">&nbsp;$a11
<input type=checkbox name="set_fields12=" value="$a12">&nbsp;$a12
<input type=checkbox name="set_fields13=" value="$a13">&nbsp;$a13
<input type=checkbox name="set_fields14=" value="$a14">&nbsp;$a14
<input type=checkbox name="set_fields15=" value="$a15">&nbsp;$a15
<input type=checkbox name="set_fields16=" value="$a16">&nbsp;$a16
<input type=checkbox name="set_fields17=" value="$a17">&nbsp;$a17
<input type=checkbox name="set_fields18=" value="$a18">&nbsp;$a18
<input type=checkbox name="set_fields19=" value="$a19">&nbsp;$a19

<input type=checkbox name="set_fields20=" value="$a20">&nbsp;$a20
<input type=checkbox name="set_fields21=" value="$a21">&nbsp;$a21
<input type=checkbox name="set_fields22=" value="$a22">&nbsp;$a22




<input type=hidden name="set_fieldsmax=" value="23">
</td></tr>
<tr><td></td>
<td nowrap>
<input type=submit value="Last ned"> 
</td></tr></form></table></td></tr></table></ul> 
EOF
&bottom();
out "</center>";
}
##########################################################################
sub print
{
$w1="16%";
$w2="20%";
$w5="13%";
if ($Ph)
{
$w1="25%";
$w2="14%";
$w5="10%";
}
out <<EOF;
<center>
<table width="$W">

<tr>
  <td><b>$f Antall aktive medlemmer: $ant</b></td><td align=right><a href="#" onclick=window.print()>$f Skriv ut</a>&nbsp;&nbsp;
                   <a href="#" onclick=history.go(-1)>$f Tilbake</a></td>
</tr></table>

<table bgcolor=000000 datasize=2 border=1 cellspacing=0 cellpadding=2 width=$W>
<tr bgcolor=c0c0c0>
<td width=13%>$f<b>$a1</b></td>
<td width=12%>$f<b>$a2</b></td>
<td width=20%>$f<b>$a3</b></td>
<td width=5%>$f<b>$a4</b></td>
<td width=10%>$f<b>$a5</b></td>
<td width=8%>$f<b>$a6</b></td>
<td width=10%>$f<b>$a7</b></td>
<td width=5%>$f<b>$a8</b></td>
<td width=3%>$f<b>Kort</b></td>
<td width=3%>$f<b>Lang</b></td>
<td width=20%>$f<b>Bankkonto</b></td>
</tr>
EOF
$i=0;
#nnnnnnnnnnnnnnnnnnnnnnnnnnnnnn
get "Id==*", "$dbName";

while (get_next "$dbName")
{push @list1,"$_loop{$a1}|$_loop{$a2}|$_loop{$a3}|$_loop{$a4}|$_loop{$a5}|$_loop{$a6}|$_loop{$a7}|$_loop{$a8}|$_loop{$a9}|$_loop{$a10}|$_loop{$a11}|$_loop{$a12}|$_loop{$a13}|$_loop{$a14}|$_loop{$a15}|$_loop{$a16}|$_loop{$a17}|$_loop{$a18}|$_loop{$a19}|$Foto|$Id|$_loop{$a21}|$_loop{$a22}|$_loop{$a23}";

#push @list1,"$_loop{$a1}|$_loop{$a2}|$_loop{$a3}|$_loop{$a4}|$_loop{$a5}|$_loop{$a6}|$_loop{$a7}|$_loop{$a8}|$_loop{$a9}|$_loop{$a10}|$_loop{$a11}|$Id|$_loop{$a21}|$_loop{$a22}";
}

@sorted = sort { normalize($a) cmp normalize($b)
          or normalize2($a) cmp normalize2($b)          
          or $a cmp $b 
          } @list1;

foreach $rec(@sorted)
 {
   @list2=split('\|',$rec);

   $a1=$list2[0];
   $a2=$list2[1];
   $a3=$list2[2];
   $a4=$list2[3];
   $a5=$list2[4];
   $a6=$list2[5];
   $a7=$list2[6];
   $a8=$list2[7];
   $a9=$list2[8];
   $a10=$list2[9];
   $a11=$list2[10];
   $Id=$list2[11];
  $a12=$list2[21];
  $a13=$list2[22];
  $a14=$list2[23];

if ($a12){$all_k = $all_k + $a12;}                    #### Tell antall påmeldte kort tur
if ($a13){$all_l = $all_l + $a13;}                    #### Tell antall påmeldte lang tur


#nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn
  if($a1 eq ""){$_loop{$a1}="&nbsp;"};
  if($a2 eq ""){$a2="&nbsp;"};
  if($a3 eq ""){$a3="&nbsp;"};
  if($a4 eq ""){$a4="&nbsp;"};
  if($a5 eq ""){$a5="&nbsp;"};
  if($a6 eq ""){$a6="&nbsp;"};
  if($a7 eq ""){$a7="&nbsp;"};
  if($a8 eq ""){$a8="&nbsp;"};
  if($a12 eq ""){$a12="&nbsp;"};
  if($a13 eq ""){$a13="&nbsp;"};
  if($a14 eq ""){$a14="&nbsp;"};

  $i++;
  if($i % 2==0)
  {
    out '<tr bgcolor="#e0e0e0">';
  } 
  else
  {
    out '<tr bgcolor="#f0f0f0">';
  }
  $F="<img src="."$a11"." align=center width=65>$f&nbsp; " if ($Ph);
  out "
  <td align=left>$F $f $a1</td>
  <td>$f $a2</td>
  <td>$f $a3</td>
  <td>$f $a4</td>
  <td>$f $a5</td>
  <td>$f $a6</td>
  <td>$f $a7</td>
  <td>$f $a8</td>
  <td>$f $a12</td>
  <td>$f $a13</td>
  <td>$f $a14</td>

</tr>";
}# w2
out <<EOF;
</table></center>
<p><b>
Antall kort tur: $all_k <br>
Antall lang tur: $all_l<p><b>
EOF
}
##########################################################################
sub split_path
{
@path=split('/',$htx);
$n=@path;
$N=2;
while ($N<$n-1)
{
$slash="";
if ($N>2){$slash="/"}
$dir=$dir.$slash.$path[$N];
$N++;
}
$dir1 = $path[1];
$dir2 = $dir;
}
##########################################################################
sub normalize
{
  my $in = $_[0];
  $in = substr ($in,0,rindex $in,'|');# Remove Id from the sorting string
  $in = lc($in);
  $in =~ s/aa/å/g;
  $in =~ s/ß/ss/g;
  #$in =~ s/AA/£/g;
  #$in =~ s/Aa/£/g;
  #$in =~ s/Å/£/g;
  #$in =~ s/å/£/g;
  $in =~ tr<áéíóúüÁÉÍÓÚÜÆØÅÄäÖö>
           <aeiouyaeiouyæøåææøø>;
  $in =~ tr<0123456789abcdefghijklmnopqrstuvwxyzæøå>
           <\x01-\x27>;
  # x27 = 39, for the 39 numbers + letters we now have
  
  return $in;
}
##########################################################################
sub normalize2
{
  my $in = $_[0];

  $in =~ s/aa/£/g;
  $in =~ s/Aa/§/g;
  $in =~ s/AA/¶/g;
  $in =~ s/å/¤/g;
  $in =~ s/Å/*/g;
  $in =~ s/ä/%/g;
  $in =~ s/Ä/&/g;
  $in =~ s/ö/!/g;
  $in =~ s/Ö/?/g;

 if ($lower_case)
 {
  $in =~tr<aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPqQrRsStTuUvVwWxXyYzZ%&æÆ!?øØ£§¶¤*>
          <12121212121212121212121212121212121212121212121212121234123412345>;
 }
else
 {
  $in =~tr<&%Ææ?!Øø¶§£*¤>
          <1234123412345>;
 }
  return $in;
}

##########################################################################
##########################################################################
#    Subrutines end
##########################################################################

</perl>