0 ) { $cols = array( "seite" => $trubrik ); updateDBRow ( "log", "id", $logid, $cols ); } echo "

"; echo "
"; echo ""; ?> " METHOD=POST name="einsatz"> "; echo ""; echo "
"; $art = array(); $query = "select * from rubrik where active=1 order by text"; $ares = queryDB($query); echo "\n\n"; echo " Stichwortsuche:"; echo "\n"; echo " "; echo ""; echo "    erfolgreiche Suchworte der letzten Tagen"; echo "\n"; if( $trubrik > 0 ) echo "

" . $art[ $trubrik ] . "

"; echo "
"; if( $trubrik == 0 ) { $query = "SELECT * FROM `infodb` where "; } else { $query = "SELECT * FROM `infodb` where ( art = " . $trubrik . " or art2 = " . $trubrik . " ) "; $lland = 1; } if( $lland ) $query .= " and "; if( strlen( $tsuchstring ) > 0 ) { $cols = array( "suchstring" => $tsuchstring ); updateDBRow ( "log", "id", $logid, $cols ); $lcstring = " ( titel like '%" . $tsuchstring . "%'"; $lcstring .= " or "; $lcstring .= "text like '%" . $tsuchstring . "%' ) "; $query .= " " . $lcstring . " and "; } $query .= " active=1 order by titel"; $res = queryDB( $query ); if( strlen( $tsuchstring ) > 0 ) { $cols = array( "zahl" => numDBRows( $res ) ); updateDBRow ( "log", "id", $logid, $cols ); } if( isset( $_REQUEST[ "suchworte" ] ) ) { $query = "SELECT * FROM `log` WHERE zahl > 0 AND ! ( suchstring LIKE \"\" ) ORDER BY `suchstring` ASC"; $res = queryDB( $query ); //echo "
"; //echo $query; //echo "
"; echo "
"; $lcstring = ""; while ($row = fetchDBRow($res)) { if( $lcstring != $row[ "suchstring" ] ) { echo ""; $lcstring = $row[ "suchstring" ]; } } echo "
"; echo "
  • " . $row[ "suchstring" ] . ""; echo "
  • "; } else { if( numDBRows( $res ) ) { echo ""; echo ""; $lcstring = " bgcolor=#E6E6E6 "; while ($row = fetchDBRow($res)) { $target = "target=\"_blank\""; echo ""; echo ""; if( strlen( $lcstring ) == 0 ) $lcstring = " bgcolor=#E6E6E6 "; else $lcstring = ""; } ?> "; } } echo "
    LinkRubrikZugriffe
    " . $row[ "titel" ] . ""; if( $row[ "art" ] > 0 ) echo $art[ $row[ "art" ] ]; if( $row[ "art2" ] > 0 ) echo " / " . $art[ $row[ "art2" ] ]; echo ""; echo $row[ "zaehler" ]; echo "
    "; ?>
    "; ?>

    Wollen Sie auch einen Link in die Amateurfunk-Info-Datenbank eintragen?";

    => Eingabeformular

    "; include ("footer.php"); ?>