<perl> 
$title = "Veteranklubben - Trondhjems Turnforening ";
$Password = $Pass if ($Pass);

if ( $exp eq "" ) {
    out <<EOF;
<html>
<head> 
<META NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW">
<title>$title</title>
</head> 

<body bgcolor=ccffff link="blue" vlink="blue">
<font face=arial,helvetica size=1>
ver. 9.10 no/linux

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

    ### The javascript is put here to be able to use some variables ###
    out <<EOF;
 <html><!--Written by H. Bjerkan, rev. 9.09no/linux  2008-11-04, 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 = "";

        $ant   = "";
        $all_e = "";
        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      = "Finn";
$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 '";
$text5     = "'Tilbake%20til%20hovedlista'";

########################################################
#out $allEmail;
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];
        $a13 = $f[14];
        $a15 = $f[15];

    }
}
##########################################################################
sub main {
    $Password        = $Pass if ($Pass);
    $cmd_search      = "$_link&ex=3&k=$dbName&su=$su&us=$us&Pass=$Password&UserName=$UserName";
    $cmd_full_search = "$ent/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="$ent/message_board" TARGET="Window2">Åpent Forum</a><br>
</center>
<font size=2>
-&nbsp;<a href="http://home.online.no/~habjerka/kurs/">Veteranklubbens datakurs - lenker</a><br>
-&nbsp;<a href="http://exel.fig-gymnastics.com/cache/html/13310-15-10001.html">FIG på besøk - THE SENIORS SHOW THE WAY!</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>Totalt antall 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 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>$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";
    }

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

        #$Foto=$a11;
        #nnnnnnnnnnnnnnnnnnnnnnnnn

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

        if ($a7) { $allEmail = $allEmail . $a7 . "; "; $all_e++; }
        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://home.online.no/~habjerka/base/grafikk/Hopspiril.gif";
        }
        if   ($k) { $dbN = $k; }
        else      { $dbN = $dbName; }   #___________&PasswordX=$entered_password
        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 $a1</a></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 {
    &split_path();
    &head();
    $a1  = "Navn";
    $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;

    #$a1=$_get{a1};
    #$a2=$_get{a2};
    #$a3=$_get{a3};
    #$a4=$_get{a4};
    #$a5=$_get{a5};
    #$a6=$_get{a6};
    #$a7=$_get{a7};
    #$a8=$_get{a8};
    #$a9=$_get{a9};
    #$a10=$_get{a10};
    #$apw=$_get{apw};

    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 (   $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 (   $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",
                      [
                        $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 = "Endret";
                    if ($xdelete) { $Chg = "Slettet" }
                    if ( $xdelete eq "" ) {    #6
                        put [
                            "Foto",     $xFoto,
                            "Club",     $db,
                            "Trans.",   $Chg,
                            $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";

                        &mailit();

                    }    #6
                }    #5
            }    #3
            &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

            out <<EOF;
  <center>
  <!--h3>Endre oppføring for:</h3-->
  <h4>$_loop{$a1} - medlem Id: $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="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>$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>
            $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></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;}

    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'>
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];
    $a11 = $f[11];

    $apw = reverse $AdmPW;

    &mailit__();

    $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{$a1}&nbsp;$_loop{$a2}</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{$a12}</i></b></h4>" if ( $xNPW2 eq "X" );
        out
"<br><h4><b>Ingen endring for:<i> $_loop{$a1}&nbsp;$_loop{$a2}</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";
    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>$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{$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 <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='$ent/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='$ent/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>

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

<a href="$ent4/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="$ent/log&dbName=$dbName&su=$su" target=_blank>Les logg</a></b>
</font>

</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, $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",  "Navn",            $x1,
                    "Adresse",  $x2,    "Poststed",       $x3,
                    "Telefon",  $x4,    "Medlem fra",     $x5,
                    "Verv",     $x6,    "E-postadresse",  $x7,
                    "Født",     $x8,    "Merknad",        $x9,
                    "Password", $pw1,   "IP-adr.",        $_REMOTE_ADDR
                  ],
                  "log";


                &mailit_();

                $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>$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>Finn:</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="apw=" value="$apw">
<input type=hidden name="su=" value="$su">
<input type=hidden name="us=" value="$us">
<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=" Finn "> </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>
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://home.online.no/~habjerka/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 {
    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_0
{
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 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>
<p align="right">
Kolonneseparator:</p>
</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>
<p align="right">
eller:</p>
</th>
<td class=or>
<input type='text' name='trsp2=' size=3 value=''></td></tr>
<tr>
<th>
  <p align="right">Linjeseparator:</p>
</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>
<p align="right">
eller:</p>
</th>
<td class=or><input type='text' name='trzl2=' size=3 value=''></td></tr>
<tr><th>
<p align="right">
Separator i tekst:</p>
</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>
<p align="right">
Ta med feltnavn som første linje:</p>
</th>
<td class=Output_field_names_as_first_row>
<input type='checkbox' name='fn1=' value=1 checked></td></tr>
<tr><th>
<p align="right">
Sorter etter:</p>
</th>
<td class=Sorting>
<select name="Sortierung=" name="_baseportal_form0">
<option>$a1
<option>Id
<option>$a2
<option>$a3
<option>$a4
</select> 
<tr><th align="right">
<p align="right">
Omvendt rekkefølge:</p>
</th>
<td class=Reverse_order>
<input type="checkbox" name="Reihenfolge umkehren=" value=1>
</td></tr>
<tr><th align="right">
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 {
    @entry = split( '/', $_link );
    $ent4  = "http://$entry[2]/$entry[3]/$entry[4]/$entry[5]";
    $ent   = "$ent4/$entry[6]";
}
##########################################################################
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;
}
##########################################################################
sub mailit {
    &posted();
    mail 'habjerka@online.no', "TT-Veteran Endring",
"Trans.: $Chg $d\n$a1: $xIdent\n$a2: $xName\n$a3: $xAddress\n$a4: $xZip\n$a5: $xCity\n$a6: $xPhone\n$a7: $xEmail\n$a8: $xSt\n$a9:\n$xRem\nPassord: $xNPW1\nIP-adr.: $_REMOTE_ADDR\n\nSlutt\n";
}

##########################################################################
sub mailit_ {
    &posted();
    mail 'habjerka@online.no', "TT-Veteran Endring",
"Trans.: Ny $d\n$a1: $x1\n$a2: $x2\n$a3: $x3\n$a4: $x4\n$a5: $x5\n$a6: $x6\n$a7: $x7\n$a8: $x8\n$a9:\n$x9\nPassord: $pw1\nIP-adr.,$_REMOTE_ADDR\n\nSlutt";
}

##########################################################################
sub mailit__ {
    &posted();
    mail 'habjerka@online.no', "TT-Veteran Endring",
"Trans.: $Chg $d\n$a1: $_loop{$a1}\n$a2: $_loop{$a2}\n$a3: $_loop{$a3}\n$a4: $_loop{$a4}\n$a5: $_loop{$a5}\n$a6: $_loop{$a6}\n$a7: $_loop{$a7}\n$a8: $_loop{$a8}\n$a9: $_loop{$a9}\nPassord: $xNPW1\nIP-adr.: $_REMOTE_ADDR\n\nSlutt\n";

                  put [
                    "Foto",  $_loop{$a10}  ,    "Club",           $dbName,
                    "Trans.",  $Chg,            "Navn",           $_loop{$a1},
                    "Adresse",  $_loop{$a2},    "Poststed",       $_loop{$a3},
                    "Telefon",  $_loop{$a4},    "Medlem fra",     $_loop{$a5},
                    "Verv",     $_loop{$a6},    "E-postadresse",  $_loop{$a7},
                    "Født",     $_loop{$a8},    "Merknad",        $_loop{$a9},
                    "Password", $xNPW1,         "IP-adr.",        $_REMOTE_ADDR
                  ],
                  "log";



}

##########################################################################
sub posted {
    $d = datum( "jetzt", "Jahr-Monat0-Tag0 Stunde:Minute:Sekunde" );
}

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

</perl>
