<perl>

$Password=$Pass if ($Pass);

$FotoSysURL = "http://tt.trondhjemsturn.no/ttveteran/system/";
$FotoURL = "http://tt.trondhjemsturn.no/ttveteran/bilder/";

$hentBilde="<a href='http://www.tt.trondhjemsturn.no/ttveteran/system/lastopp.php?start'>Til mappen for alle bilder</a>";

$xFoto = $FotoURL . $xFoto if substr ($xFoto,0,7) ne "http://"  && $xFoto ne "" ;

if ($exp eq "")
{
out <<EOF;
<!--html>
<head> 
<META NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW">
<title>Veteranklubben - Trondhjems Turnforening </title>
</head--> 
<body bgcolor=ccffff link="blue" vlink="blue">
<font face=arial,helvetica size=1>
ver. 10.01 no 2023-01-18
EOF

$entered_user=$us if $us;
$us=$entered_user;

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

@entry=split('/',$_link);
$ent4="http://$entry[2]/$entry[3]/$entry[4]/$entry[5]";
$ent="$ent4/$entry[6]";

 ### The javascript is put here to be able to use some variables ###
 out <<EOF;
 <html><!--Written by H. Bjerkan, rev. 9.08no  2008-10-21, Norwegian sort order, shows user, 9.09 2013-01-29 Glemt passord, 9.10 2014-11-30 antall uten passive og døde -->
 <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="";

  $ant="";  
  $all_e="";
  get "Id==*", $dbName;;
  while (get_next $dbName)
  {#3
   if ($_loop{$a7})# Sjekk om epostadresse
     {#31
       ($allEmail=$allEmail . $_loop{$a7} . "; ") if (substr ($_loop{$a1},0,1) ne "-") ;
       ($all_e ++) if (substr ($_loop{a1},0,1) ne "-");
     }#31
   if ($_loop{$a6} ne "")
     {#32
       if($_loop{$a7})
         {#321
           $boardEmail=$boardEmail . $_loop{$a7} . "; ";
         }#321
     }#32
   unless (($_loop{$a1}=~ m/†/)||(substr ($_loop{$a1},0,1) eq "+")||(substr ($_loop{$a1},0,1) eq "-"))
     {#33
       $ant ++;
     }#33 
  }#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 med verv";
$alEmail="E-post til alle";
$export="Eksporter";

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

$text4="' Logg ut '";
$text5="'Tilbake%20til%20hovedlista'";

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

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[1];
  $a2=$f[2];
  $a3=$f[3];
  $a4=$f[4];
  $a5=$f[5];
  $a6=$f[6];
  $a7=$f[7];
  $a8=$f[8];
  $a9=$f[9];
  $a10=$f[10];
  $a11=$f[11];
  $a12=$f[12];

 }
}
##########################################################################
sub main
{
$Password=$Pass if ($Pass);
$cmd_search="$_link&ex=3&k=$dbName&su=$su&us=$us&Pass=$Password&UserName=$UserName";

#$cmd_full_search="http://www.baseportal.com/cgi-bin/baseportal.pl?#htx=/habjerka/ttveteran/full_search&ex=3&k=$dbName&su=$su&us=$us&Password=$Password&UserName=$UserName&in_upw=$Password";

$cmd_full_search="http://habjerka.homeip.net/cgi-bin/baseportal.pl?htx=/ttveteran/full_search&ex=3&k=$dbName&su=$su&us=$us&Password=$Password&UserName=$UserName&in_upw=$Password";


$cmd_add="$_link&ex=1&k=$dbName&su=$su&us=$us&Pass=$Password&UserName=$UserName";
$cmd_all="$_link&ex=1&k=$dbName&su=$su&us=$us";
$cmd_export="$_link&exp=1&k=$dbName&su=$su&us=$us&text3=$text5";
$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 <<EOF;

<a href="http://habjerka.homeip.net/cgi-bin/baseportal.pl?htx=/ttveteran/message_board" TARGET="Window2">Åpent Forum</a><br>
</center>
<!--font size=2>
-&nbsp;<a href="http://tt.trondhjemsturn.no/HBJ/base/kurs/">Veteranklubbens datakurs - lenker</a><br>

-&nbsp;<a href="http://www.turnforening.no/index.cfm?tmpl=thumbnail_list&v_kat=1571">NM i turn 2006</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>U/bilde</b></a></td>
</tr>
</table><p>
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>$f<b>$full_find</b></td-->
<td width=15% align=left><a target="_new" href=$cmd_full_search>$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=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);

out <<EOF;
<table bgcolor=000000 datasize=2 border=0 cellspacing=1 cellpadding=2 width=$W>
<tr bgcolor=c0c0c0>

<td width=25%>$f<b>$a12</b></td>

<td width=25%>$f<b>$a1</b></td>

<td width=14%>$f<b>$a2</b></td>
<td width=12%>$f<b>$a3</b></td>
<td width=19%>$f<b>$a4</b></td>
<td width=6%>$f<b>$a5</b></td>
<td width=10%>$f<b>$a6</b></td>
<td width=14%>$f<b>$a7</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}|$Foto|$Id| $_loop{$a12}";
}

@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[12];
#$Foto=$a11;
#nnnnnnnnnnnnnnnnnnnnnnnnn

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

if ($a7)
  { 
    ($allEmail=$allEmail . $a7 . "; ") if substr ($a1,0,1) ne "-";
    $all_e++ if substr ($a1,0,1) ne "-";
   }
if ($a6 ne "")
  {
   if($a7)
     {
       $boardEmail=$boardEmail . $a7 . "; ";
     }
  }

$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 ($a11 eq "") {$a11 = $FotoSysURL . "Hopspiril.gif";}
if ($k){$dbN=$k;}else {$dbN=$dbName;}#___________&PasswordX=$entered_password

############################### Hvis $z, vis alle inkl. passive (+) og døde (†). Sub find setter alltid $z="1".################## 

if(substr($a1,0,1)ne "-" && substr($a1,0,1)ne "†" && substr($a1,0,1)ne "-" || $z )
{
out <<EOF
<td><a href=$a11><img src=$a11 align=center width=65> </a><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&apw=$apw&UserName=$entered_user&Pass=$Pass&logo=$logo&dir=$dir&dir1=$dir1&dir2=$dir2&su=$su&us=$us">$f $a12</a></td>

<td align=left>$f $a1</td>

<td align=left>$f $a2</td>
<td>$f $a3</td>
<td>$f $a4</td>
<td align=center>$f $a5</td>
<td>$f $a6</td>
<td><a href='mailto:$a7'>$f $a7</td></tr>
EOF
}


}# w2
chop $allEmail;
chop $allEmail;
chop $boardEmail;
out <<EOF;
</table>

<table width=$W>
<tr><td>
<br><b>Hvis du får feilmelding ved bruk av <i>$alEmail</i>, hent <a href="javascript:help1();">hjelp</a>
</td>
</tr>
</table>

<table bgcolor=000000 datasize=2 border=0 cellspacing=2 cellpadding=2 width=$W>
<tr bgcolor=f0f0f0><td>$f<b>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();
$a1="Fornavn";
$a12="Etternavn";

$a2="Adresse";
$a3="Poststed";
$a4="Telefon";
$a5="Medlem fra";
$a6="Verv";
$a7="E-postadresse";
$a8="Født";
$a9="Merknad";
$a10="Password";
$a11="Foto";
$xId=$Id;
&fieldnames();
$Id=$xId;
$konv=$Id;
$allEnv=$Id;
$medlnr=1000 + $Id;


out "<center>";

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

 if($xIdent)
 {#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($xIdentF eq $_loop{$a12} && $xIdent eq $_loop{$a1} && $xName eq $_loop{$a2} && $xAddress eq $_loop{$a3} && $xZip eq $_loop{$a4} && $xCity eq $_loop{$a5} && $xPhone eq $_loop{$a6} && $xEmail eq $_loop{$a7} && $xSt eq $_loop{$a8} && $xRem eq $_loop{$a9} && $xNPW1 eq $Password && $xFoto eq $Foto){$nc=1}}
else
{
   if($xIdentF eq $_loop{$a12} && $xIdent eq $_loop{$a1} && $xName eq $_loop{$a2} && $xAddress eq $_loop{$a3} && $xZip eq $_loop{$a4} && $xCity eq $_loop{$a5} && $xPhone eq $_loop{$a6} && $xEmail eq $_loop{$a7} && $xSt eq $_loop{$a8} && $xRem eq $_loop{$a9} && $xNPW1 eq $Password){$nc=1}
}
################
if ($su eq "2"){$nc=1;}
################

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

    if ($NChg eq "")
    {#5
     mod "Id==$Id",   [$a12,$xIdentF,$a1,$xIdent,$a2,$xName,$a3,$xAddress,$a4,$xZip,$a5,$xCity,$a6,$xPhone,$a7,$xEmail,$a8,$xSt,$a9,$xRem,"Password",$xNPW1];
     if ($su eq 1){mod "Id==$Id",["Foto",$xFoto];}

     $Chg="Modified";
     if($xdelete){$Chg="Deleted"}
     if($xdelete eq "")
     {#6
      put["Foto",$xFoto,"Club",$db,"Trans.",$Chg,$a12,$xIdentF,$a1,$xIdent,$a2,$xName,$a3,$xAddress,$a4,$xZip,$a5,$xCity,$a6,$xPhone,$a7,$xEmail,$a8,$xSt,$a9,$xRem,"Password",$xNPW1,"IP-adr.",$_REMOTE_ADDR],"log";

     }#6
    }#5
   }#3
  &modified();
 }#2
 else
 {#7
  if ($Foto eq "" && $Id % 2==0)
  {#8
   ###########$Photo="<img src=$FotoURL.'Hopspiril.gif' align=center height=200>";
   $Photo="<img src='http://tt.trondhjemsturn.no/ttveteran/system/Hopspiril.gif' align=center height=200>";
  }#8

  elsif ($Foto eq "" && $Id % 2==1)
  {#9
   $Photo="<img src='http://tt.trondhjemsturn.no/ttveteran/system/Hopspiril.gif' align=center height=200>";
  }#9
  else 
  {#10
   $Photo="<img src=\"".$Foto."\" align=center height=150>";
  }#10
  if ($su eq 1)
  {#11
   $bilde=substr($_loop{$a11},((rindex($_loop{$a11}, "/")))+1);
   $hentBilde="<a href='http://www.tt.trondhjemsturn.no/ttveteran/system/upload2.php?start&medlnr=$medlnr&bilde=$bilde&medlNavn=$_loop{$a1}'> Hent bilde</a>";
  #$hentBilde="<a href='http://www.tt.trondhjemsturn.no/ttveteran/system/lastopp.php?rename_file=$bilde&medlnr=$medlnr&bilde=$bilde'> Endre navn på bilde</a>";


if (!$_loop{Foto}){$_loop{Foto}="$medlnr.jpg";}


   $FotoFelt="<td align=right>Foto URL:</td><td><input type='text' name='xFoto=' value='$_loop{Foto}' size=35>$hentBilde </td>";$supw=reverse $apw;
  }#11

  out <<EOF;
  <center>
  <!--h3>Endre oppføring for:</h3-->
  <h4>$_loop{$a1} - medlemsnr: $medlnr</h4>
  <form action=$_link&Id=$Id&ex=21&db=$db method="post" enctype="multipart/form-data">
  <input type=hidden name="text1=" value="$text1">

  <input type=hidden name="a12=" value="$a12">
  <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="apw=" value="$apw">
  <input type=hidden name="logo=" value="$logo">
  <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">
  <table>
  <tr><td>$Photo $Photo2</td></tr>
  </table>
  <table>
  <tr><td align=right>$a12:</td><td><input type="text" name="xIdentF=" value="$_loop{$a12}"></td>
  <tr><td align=right>$a1:</td><td><input type="text" name="xIdent=" value="$_loop{$a1}"></td>

      <td align=right>$a2:</td><td><input type="text" name="xName=" value="$_loop{$a2}"></td></tr>
  <tr><td align=right>$a3:</td><td><input type="text" name="xAddress=" value="$_loop{$a3}"></td>
      <td align=right>$a4:</td><td><input type="text" name="xZip=" value="$_loop{$a4}"></td></tr>
  <tr><td align=right>$a5:</td><td><input type="text" name="xCity=" value="$_loop{$a5}"></td>
      <td align=right>$a6:</td><td><input type="text" name="xPhone=" value="$_loop{$a6}" size=35></td></tr>
  <tr><td align=right>$a8:</td><td><input type="text" name="xSt=" value="$_loop{$a8}"></td>
      <td align=right>$a7:</td><td><input type="text" name="xEmail=" value="$_loop{$a7}" size=35></td></tr>
  <tr><td align=right>$a9:</td><td><textarea name="xRem=">$_loop{$a9}</textarea></td>$bilde
            $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 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><td></td><td><a href='http://habjerka.homeip.net/cgi-bin/baseportal.pl?htx=/ttveteran/glemtPassord&Navn=$Navn'>Glemt personlig passord?</a></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
  if ($_loop{$a7})
    {
      $allEmail=$allEmail . $_loop{$a7} . "; ";
    }
  if ($_loop{$a6} ne "")
     {
      if($_loop{$a7})
        {
          $boardEmail=$boardEmail . $_loop{$a7} . "; ";
        }
     }

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

&bottom();
}
#################################################################
sub return
{
out "<center>";
#if ($text3 eq " Logg ut ") {$su=3;}
$hentBilde1=$hentBilde if $su;
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>
<a href="#bottom"><font face="arial" size="1">Til bunnen</font></a><p>
<a href="http://trondhjemsturn.weborg.no/login">Pålogging TT's medlemssystem</a><p>

$hentBilde1 
</center>
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'>
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();

$a1=$f[1];
$a2=$f[2];
$a3=$f[3];
$a4=$f[4];
$a5=$f[5];
$a6=$f[6];
$a7=$f[7];
$a8=$f[8];
$a9=$f[9];
$a10=$f[10];
$a12=$f[12];
$apw=reverse $AdmPW;

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





$ex=0;
out "<center><p><b>Oppføringen er slettet for:<i> $_loop{$a12}&nbsp;$_loop{$a1}</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{$a12}&nbsp;$_loop{$a1}</i></b></h4>" if($xdelete eq "" && $xNPW2 eq "" && $NChg eq "");
  out "<br><h4><b>Passord er endret for:<i> $_loop{$a12}&nbsp;$_loop{$a1}</i></b></h4>" if($xNPW2 && $xNPW2 ne "X" && $su ne 2);
  out "<br><h4><b>Passord er slettet for:<i> $_loop{$a12}&nbsp;$_loop{$a1}</i></b></h4>" if($xNPW2 eq "X");
  out "<br><h4><b>Ingen endring for:<i> $_loop{$a12}&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{$a12} $_loop{$a1}?')"><b>Slett oppføring for: <i>$_loop{$a12}&nbsp;$_loop{$a1}</b></b></a></h6><p>
EOF
  }

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


get "Id==$Id";
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=14%>$f<b>$a12</b></td>
<td width=14%>$f<b>$a1</b></td>
<td width=17%>$f<b>$a2</b></td>
<td width=12%>$f<b>$a3</b></td>
<td width=19%>$f<b>$a4</b></td>
<td width=6%>$f<b>$a5</b></td>
<td width=10%>$f<b>$a6</b></td>
<td width=20%>$f<b>$a7</b></td>
<td width=9%>$f<b>$a8</b></td>
</tr>
EOF


out <<EOF;
<tr bgcolor="#e0e0e0"><td>$f<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&apw=$apw&logo=$logo&su=$su&us=$us&Pass=$Pass">$_loop{$a12}</a></td>

<td align=left>$f $_loop{$a1}</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 <a href='mailto:$_loop{$a7}'>$_loop{$a7}</a></td>
<td nowrap>$f $_loop{$a8}</td></tr></table>
</center>
EOF
}
##########################################################################
sub bottom
{
#out "DB=$dbName";

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


out <<EOF;

<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/ttveteran/giro&dbName=$dbName&konv=$allEnv&su=$su'>$f<b>Send 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/ttveteran/brevomslag&konv=$allEnv&su=$su&dbName=$dbName'>$f<b>Lag konvolutt(er)</b></a></td>         
</tr>




<!--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='mailto:$boardEmail'>$f<b>$grEmail</b></td>
  <td align=center width=14%><a href='mailto:$allEmail'>$f<b>$alEmail</b></td>
  <td align=center width=14%><a href="javascript:submitForm();">$f<b>Hjemmeside</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?su=$su" target="window2">Se logg</a><br>


</font></body>
</html>
EOF
}
##########################################################################
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["Foto",$xFoto,$a12,$x12,$a1,$x1,$a2,$x2,$a3,$x3,$a4,$x4,$a5,$x5,$a6,$x6,$a7,$x7,$a8,$x8,$a9,$x9,"Password",$pw1],$dbName;

  #put["Foto",$xFoto,"Club",$dbName,"Trans.","New","Field1",$x1,"Field2",$x2,"Field3",$x3,"Field4",$x4,"Field5",$x5,"Field6",$x6,"Field7",$x7,"Field8",#$x8,
 # "Password",$pw1,"IP-adr.",$_REMOTE_ADDR],"log";



put["Foto",$xFoto,"Club",$dbName,"Trans.","New",$a12,$x12,$a1,$x1,$a2,$x2,$a3,$x3,$a4,$x4,$a5,$x5,$a6,$x6,$a7,$x7,$a8,$x8,
  "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">

<tr><td align=right>$a12:</td><td><input type="text" name="x12=" value=$x1></td><!/tr>
<tr><td align=right>$a1:</td><td><input type="text" name="x1=" value=$x1></td><!/tr>

<!tr><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><!/tr>
<!tr><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><!/tr>
<!tr><td align=right>$a6:</td><td><input type="text" name="x6=" size=35 value=$x6></td></tr>
<tr><td align=right>$a8:</td><td><input type="text" name="x8=" value=$x8></td><!/tr>
<!tr><td align=right>$a7:</td><td><input type="text" name="x7=" size=35 value=$x7></td></tr>
<tr><td align=right>$a9:</td><td><textarea name="x9=">$x9</textarea></td>$FotoFelt</tr>
<tr><td align=right>Passord:</td><td><input type="password" name="pw1="></td><!/tr>
<!tr><td align=right>Gjenta passord:</td><td><input type="password" name="pw2="></td></tr>
<tr><td></td><td><input type=submit value=" Lagre "> </td></tr>
</form></table></center>
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&z=1 method="post" enctype="multipart/form-data">
<!input type=hidden name="text4=" value="">
<input type=hidden name="a12=" value="$a12">
<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="apw=" value="$apw">
<input type=hidden name="su=" value="$su">
<input type=hidden name="us=" value="$us">
<tr><td align=right>$a12:</td><td><input type="text" name="$a12~=" value=""></td></tr>
<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~="></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/ttveteran/glemtPassord'> Klikk her</a>
EOF
  }#2
  if($entered_user ne "")
  {#3
   if($entered_user =~ /@/) {$entered_user="hbj";}
    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/ttveteran/system/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
{
if ($su eq "1")
{
init $dbName;
$mdb=$dbName;

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



$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.xls\n\n";

 get "Id=*", "$mdb.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=* & sort=Navn","$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";
 }

}
else {&return();
out "<center><b>Ikke tillatt for denne bruker!</b></center>";
&bottom();}
}
##########################################################################
sub export_
{
if ($su eq "1")
{
#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='_tb_'>Tab
<option value=';'>Semikolon (;)
<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
</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" checked>&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=hidden name="set_fieldsmax=" value="10">
</td></tr>
<tr><td></td>
<td nowrap>
<input type=submit value="Last ned"> 
</td></tr></form></table></td></tr></table></ul> 
EOF
}
else 
{
&return();
out "<center><b>Ikke tillatt for denne bruker!</b></center>";
}
&bottom();
out "</center>";
}
##########################################################################
sub print
{
$w1="16%";
$w2="20%";
$w5="13%";
if ($Ph)
{
$w1="20%";
$w2="14%";
$w5="10%";
}
out <<EOF;
<center>
<table width="$W">

<tr>
  <td><b>$f Antall 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=$w1>$f<b>$a1</b></td>
  <td width=$w2>$f<b>$a2</b></td>
  <td width=12%>$f<b>$a3</b></td>
  <td width=15%>$f<b>$a4</b></td>
  <td width=14%>$f<b>$a7</b></td>
  <td width=8%>$f<b>$a8</b></td>
  <td width=8%>$f<b>$a5</b></td>
  <!--td width=$w6>$f<b>$a6</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}|$Id";
}

@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];


#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;"};
  $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 $a7</td>
  <td>$f $a8</td>
  <td>$f $a5</td>
  <!--td>$f $a6</td-->
</tr>";
}# w2
out <<EOF;
</table></center>
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>