versuch2 mit single param ohne array umbau

ips/crawler.php

@@ -8,11 +8,14 @@ $_ips_crawler = array (
         '104.155.85.', // google
         '114.119.1', // petalbot
         '185.191.171.', // semrush bot
-        '207.46.13.124', // bing bot
+        '207.46.13.', // bing bot
         '54.36.148.', // ahrefbot
+        '54.36.149.', // ahrefbot
         '216.244.66.196', // opensiteexplorer
         '65.21.180.26', // seekport
         '81.209.177.145', // website-datenbank.de
-        '2a01:4f8:190:4244::2' // mj12bot
+        '2a01:4f8:190:4244::2', // mj12bot
+        '192.99.5.225', // ...
+        '157.55.39.' // microsoft???
 );
 ?>

mail.php

@@ -5,9 +5,6 @@ function send_mail($an, $betreff, $text, $ok = '', $error = '') {
   if (isset ( $_sendermail )) {
     $sender = $_sendermail;
   }
-  if (is_array ( $text )) {
-    $text = print_r ( $text, true );
-  }
   $header = 'From: ' . $sender . "\r\n";
   $header .= 'To: ' . $an . "\r\n";
   $header .= 'Content-Type:text/html' . "\r\n";

markdown.php

@@ -0,0 +1,84 @@
+<?php
+// TODO markdown imple
+function md($str) {
+  // return nl2br ( $str ); // TODO md problem
+  $text = '<p>';
+  $lv = 0;
+  $str = explode ( "\n", str_replace ( "\r\n", "\n", $str ) );
+  // var_dump ( $str );
+  foreach ( $str as $t ) {
+    // echo '<pre>' . $t . '</pre>';
+    $t = preg_replace_callback ( '/\[\[([^\]]*)\]\]/m', '_md_link_replacer', $t );
+    $nlv = 0;
+    if (startsWith ( $t, '**** ' )) {
+      // echo - 1;
+      $t = substr ( $t, 5 );
+      $nlv = 4;
+    }
+    if (startsWith ( $t, '*** ' )) {
+      // echo - 2;
+      $t = substr ( $t, 4 );
+      $nlv = 3;
+    }
+    if (startsWith ( $t, '** ' )) {
+      // echo - 3;
+      $t = substr ( $t, 3 );
+      $nlv = 2;
+    }
+    if (startsWith ( $t, '* ' )) {
+      // echo - 4;
+      $t = substr ( $t, 2 );
+      $nlv = 1;
+    }
+    if ($lv != $nlv) {
+      while ( $lv < $nlv ) {
+        // echo '-5 (' . $lv . '-' . $nlv . ')';
+        $text .= '<ul>';
+        $lv ++;
+      }
+      while ( $lv > $nlv ) {
+        // echo '-6 (' . $lv . '-' . $nlv . ')';
+        $text .= '</ul>';
+        $lv --;
+      }
+    }
+    if (startsWith ( $t, '!!!!! ' )) {
+      $t = '<h5>' . substr ( $t, 6 ) . '</h5>';
+    }
+    if (startsWith ( $t, '!!!! ' )) {
+      $t = '<h4>' . substr ( $t, 5 ) . '</h4>';
+    }
+    if (startsWith ( $t, '!!! ' )) {
+      $t = '<h3>' . substr ( $t, 4 ) . '</h3>';
+    }
+    if (startsWith ( $t, '!! ' )) {
+      $t = '<h2>' . substr ( $t, 3 ) . '</h2>';
+    }
+    if (startsWith ( $t, '! ' )) {
+      $t = '<h1>' . substr ( $t, 2 ) . '</h1>';
+    }
+    if ($lv == 0) {
+      if ($t == '') {
+        $text .= '</p><p>';
+      } else {
+        $text .= $t;
+      }
+    } else {
+      $text .= '<li>' . $t . '</li>';
+    }
+    // var_dump ( $t );
+  }
+  while ( $lv > 0 ) {
+    $text .= '</ul>';
+    $lv --;
+  }
+  $text .= '</p>';
+  return $text;
+}
+function _md_link_replacer($in) {
+  // var_dump ( $in );
+  $in = explode ( '|', $in [1], 2 );
+
+  return '<a href="' . $in [0] . '" target="_blank">' . (isset ( $in [1] ) ? $in [1] : $in [0]) . '</a>';
+}
+?>

sql.php

@@ -34,6 +34,7 @@ class SQL {
               ''
       ), $que ) . "\n" . print_r ( $p, true ) . "\n\n" );
     $statement = $this->h->prepare ( $que );
+    if (is_array ( $p )) {
       switch (count ( $p )) {
         case 0 :
           break;
@@ -68,6 +69,9 @@ class SQL {
           $statement->bind_param ( $t, $p [0], $p [1], $p [2], $p [3], $p [4], $p [5], $p [6], $p [7], $p [8], $p [9] );
           break;
       }
+    } else {
+      $statement->bind_param ( $t, $p );
+    }
     $statement->execute ();
     
     $ret = array ();
@@ -128,6 +132,7 @@ class SQL {
               ' ',
               ''
       ), $que ) . "\n" . print_r ( $p, true ) . "\n\n" );
+    if (is_array ( $p )) {
       switch (count ( $p )) {
         case 0 :
           break;
@@ -161,21 +166,9 @@ class SQL {
         case 10 :
           $statement->bind_param ( $t, $p [0], $p [1], $p [2], $p [3], $p [4], $p [5], $p [6], $p [7], $p [8], $p [9] );
           break;
-      case 11 :
-        $statement->bind_param ( $t, $p [0], $p [1], $p [2], $p [3], $p [4], $p [5], $p [6], $p [7], $p [8], $p [9], $p [10] );
-        break;
-      case 12 :
-        $statement->bind_param ( $t, $p [0], $p [1], $p [2], $p [3], $p [4], $p [5], $p [6], $p [7], $p [8], $p [9], $p [10], $p [11] );
-        break;
-      case 13 :
-        $statement->bind_param ( $t, $p [0], $p [1], $p [2], $p [3], $p [4], $p [5], $p [6], $p [7], $p [8], $p [9], $p [10], $p [11], $p [12] );
-        break;
-      case 14 :
-        $statement->bind_param ( $t, $p [0], $p [1], $p [2], $p [3], $p [4], $p [5], $p [6], $p [7], $p [8], $p [9], $p [10], $p [11], $p [12], $p [13] );
-        break;
-      case 15 :
-        $statement->bind_param ( $t, $p [0], $p [1], $p [2], $p [3], $p [4], $p [5], $p [6], $p [7], $p [8], $p [9], $p [10], $p [11], $p [12], $p [13], $p [14] );
-        break;
+      }
+    } else {
+      $statement->bind_param ( $t, $p );
     }
     $statement->execute ();
     if (isset ( $statement->error ) && $statement->error != '') {