ver. 6.31no $dbName="veteran" if !$dbName; $db=$dbName; # Search in this DB #$db="nkgv"; # Search in this DB $usersDB="users"; # The DB for username/password/accesscode. # $db may be used if it contains the fields userName and Password $usePW ="y" if ($Password eq ""); # Use password if set to "y". If set to anything else, password is not used. $f=""; # Set font size if (!$th) { $id=$Id; &getFieldNames(); $th="".$f.$fld[9].""; $n1=1; # Don't show Id, Postert, Trans, DB while ($n1 < 9) # Use the first 9 fields for showing the hits. {$th=$th."".$f.$fld[$n1].""; $n1++;} $n1=1; } $DB=uc $db; out <

Fri tekst søk i databasen: $DB

EOF if ($det) { &details(); return; } if ($usePW eq "y") { $Password=$pw; $UserName=$eu; if ($xPassword && $UserName) { $entered_password=$xPassword; $entered_user=$UserName; } &Password() if ($in_upw eq "" && $xPassword eq ""); &main_() if ($in_upw); } else {&main_();} ################################# Subroutines ################################### sub main_ { &getFieldNames(); if ($list eq ""){$list=10;} out <

Finn:  
Treff pr. side:  maks. 500

EOF $f=""; # Set font size $W="98%"; return if $_fullsearch eq ""; get "fullsearch_match=$list","$db","temp"; out <    Lukk EOF out "Det er $_amount_all oppføringer i databasen
"; out < $th EOF while(get_next "temp") { $i++; if($i % 2==0) { out ''; } else { out ''; } out ""; if (!$_loop{"$fld[2]"}){$_loop{"$fld[2]"}=" ";} if (!$_loop{"$fld[3]"}){$_loop{"$fld[3]"}=" ";} if (!$_loop{"$fld[4]"}){$_loop{"$fld[4]"}=" ";} if (!$_loop{"$fld[5]"}){$_loop{"$fld[5]"}=" ";} if (!$_loop{"$fld[6]"}){$_loop{"$fld[6]"}=" ";} if (!$_loop{"$fld[7]"}){$_loop{"$fld[7]"}=" ";} if (!$_loop{"$fld[8]"}){$_loop{"$fld[8]"}=" ";} if (!$_loop{"$fld[9]"}){$_loop{"$fld[9]"}=" ";} if (!$_loop{"$fld[10]"}){$_loop{"$fld[10]"}=" ";} if (!$_loop{"$fld[11]"}){$_loop{"$fld[11]"}=" ";} if (!$_loop{"$fld[12]"}){$_loop{"$fld[12]"}=" ";} if (!$_loop{"$fld[13]"}){$_loop{"$fld[13]"}=" ";} $out= <$f $Id1 EOF $out=~ s#$_fullsearch_regex#$1#g; out $out; } out "
$fDetaljer
$fDetaljer$f $_loop{"$fld[9]"} $f $_loop{"$fld[1]"} $f $_loop{"$fld[2]"} $f $_loop{"$fld[3]"} $f $_loop{"$fld[4]"} $f $_loop{"$fld[5]"} $f $_loop{"$fld[6]"} $f $_loop{"$fld[7]"} $f $_loop{"$fld[8]"}
"; my $newrange=$_fullsearch_range_length + $_fullsearch_range; my $txt; if($_fullsearch_match_pos < $newrange) { $txt="Søk etter flere?"; $newrange=$_fullsearch_match_pos; } if($newrange < $_amount_all) { $i1=$i+$i1; $pos=$_amount_all-$_fullsearch_match_pos; out "$i1 treff hittil - det er flere oppføringer å søke i  (fra Id $pos): "; out "$txt"; } else { $i1=$i1+$i; out "Hele databasen er gjennomsøkt - totalt $i1 treff."; if ($_fullsearch_match_pos - $_amount_all eq 1 && $_fullsearch_range eq 0 && $Id eq "") { out "   Ingen treff!" } } } ################################################################################# sub Password {#1 $text2="Ingen tilgang. Gå tilbake - prøv på nytt. . ."; out "
"; if($entered_user eq "") {#2 out <Tast brukernavn og passord:
$f Brukernavn:
$f Passord:
$f
EOF }#2 if($entered_user ne "") {#3 get "UserName==$entered_user", "users"; $k=$dbName; 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;} }#4 else {#5 out <
$f$text2
EOF }#5 }#3 out "
"; }#1 ################################################################################# sub getFieldNames { @fld=(); #out $db; #init $db; get "Id==*", "$db.fields", "fields"; while (get_next("fields")) { push @fld, $Field; # Build list of fieldnames } #out @fld; $n1=0; $n=@fld; } ################################################################################# sub details { out < Tilbake til søkesiden


EOF $dbName=$db; get "Id~=$id",$db, "temp"; $Id=$id; &getFieldNames(); out <
Detaljer: EOF while ($n1 < $n) { $loop[$n1]=$_loop{$fld[$n1]}; $loop[0]=$id; ### if ((lc $fld[$n1] eq "password" || lc $fld[$n1] eq "accesscode") && $acc eq ""){$loop[$n1]="Ingen tilgang";} if ((lc $fld[$n1] eq "password") && $su eq ""){$loop[$n1]="Ingen tilgang";} if ((lc $fld[$n1] eq "kontakt") && $loop[$n1]){$loop[$n1]="Ja";} $fld[$n1]="Passord" if (lc $fld[$n1] eq "password"); ########################## if (lc $fld[$n1] eq "foto"){$loop[$n1]="";} #Viser foto istedet for URL-adresse if (lc $fld[$n1] eq "merknader"){$loop[$n1] =~ s/\n/
/g;}#Setter inn HTML linjeskift ########################## out '"; $n1++; } out <
',$fld[$n1],": ", '',$loop[$n1],"
EOF return} ################################ Subroutines end ################################