debug sql

füge Funktionen zum Senden von Problemen zur Troy-API hinzu und erweitere die Konfiguration
add troy api
2025-03-12 19:37:53 +01:00 · 2025-03-11 14:19:06 +01:00 · 2024-04-04 19:53:41 +02:00 · 2022-12-18 19:29:34 +01:00 · 2022-12-18 19:04:18 +01:00 · 2022-11-12 11:25:42 +01:00
8 changed files with 6877 additions and 215 deletions
--- a/_func.php
+++ b/_func.php
@@ -6,5 +6,6 @@ include_once ('string.php');
 include_once ('numbers.php');
 include_once ('mail.php');
 include_once ('debug.php');
+include_once ('troy-api.php');
 // include_once ('markdown.php');
 ?>
--- a/ips/crawler.php
+++ b/ips/crawler.php
@@ -1,29 +1,32 @@
 <?php
 $_ips_crawler = array (
+        '34.79.234.76', // google
        '40.77.167.', // bing bot
+        '54.36.148.', // ahrefbot
+        '54.36.149.', // ahrefbot
        '66.249.',
        '62.138.',
        '62.210.149.60',
+        '65.21.180.26', // seekport
+        '81.209.177.145', // website-datenbank.de
+        '85.25.177.', // abuse
+        '85.25.210.', // hosteurope abuse
        '92.118.160.37', // netsystem research bot
        '104.155.85.', // google
        '114.119.1', // petalbot
-        '185.191.171.', // semrush 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
        '144.76.15.153', // mj12bot
-        '192.99.5.225', // ...
-        '157.55.39.', // microsoft???
-        '2a01:4f8:162:43c5::2', // mj12bot
-        '85.25.177.', // abuse
-        '85.25.210.', // hosteurope abuse
-        '34.79.234.76', // google
        '148.251.120.201', // mj12bot
-        '205.185.115.87' //sex spam
+        '157.55.39.', // microsoft???
+        '172.217.', //google
+        '176.125.230.38', //sql inj
+        '185.191.171.', // semrush bot
+        '192.99.5.225', // ...
+        '205.185.115.87', //sex spam
+        '207.46.13.', // bing bot
+        '216.58.', //google
+        '216.244.66.196', // opensiteexplorer
+        '2a01:4f8:190:4244::2', // mj12bot
+        '2a01:4f8:162:43c5::2', // mj12bot
 );
 function checkHuman() {
  global $_ips_crawler;
--- a/mail.php
+++ b/mail.php
@@ -1,10 +1,15 @@
 <?php
 function send_mail($an, $betreff, $text, $ok = '', $error = '') {
-  include 'secret.php';
+  global $absender;
  $sender = 'noreply@troy-grunt.de';
+  if(isset($absender) && $absender) {
+    $sender = $absender;
+  }else{
+    include 'secret.php';
    if (isset ( $_sendermail )) {
      $sender = $_sendermail;
    }
+  }
  $header = 'From: ' . $sender . "\r\n";
  $header .= 'To: ' . $an . "\r\n";
  $header .= 'Content-Type:text/html' . "\r\n";
@@ -18,3 +23,59 @@ function send_mail($an, $betreff, $text, $ok = '', $error = '') {
  }
 }

+function send_html_mail($an, $betreff, $text, $ok = '', $error = '') {
+  global $absender;
+  $sender = 'noreply@troy-grunt.de';
+  if(isset($absender) && $absender) {
+    $sender = $absender;
+  }else{
+    include 'secret.php';
+    if (isset ( $_sendermail )) {
+      $sender = $_sendermail;
+    }
+  }
+  $boundary = md5($an.$betreff.$text.time());
+
+  $header = 'From: ' . $sender . "\n";
+  $header .= 'To: ' . $an . "\n";
+  $header .= 'Content-Type:multipart/alternative;boundary='.$boundary . "\n";
+  $header .= 'X-Mailer: PHP/' . phpversion ();
+  $content = "This is multipart message using MIME\n";
+  $content .= "--" . $boundary . "\n";
+  $content .= "Content-type: text/plain;charset=utf-8\n";
+  $content .= 'Content-Transfer-Encoding: 8bit' . "\n\n";
+  $content .= strip_tags($text)."\n\n";
+  $content .= "--" . $boundary . "\n";
+  $content .= "Content-type: text/html;charset=utf-8\n";
+  $content .= "Content-Transfer-Encoding: 8bit". "\n\n";
+  $content .= '<html><body>'.$text.'</body></html>'."\n\n";
+
+  if (mail ( $an, $betreff, $content, $header ) === true) {
+    echo $ok;
+  } else {
+    echo $error;
+  }
+}
+
+function send_php_mail($an, $betreff, $text, $ok = '', $error = '') {
+  global $_sendermail;
+  $sender = 'noreply@troy-grunt.de';
+  if (isset ( $_sendermail )) {
+    $sender = $_sendermail;
+  }
+  include 'php-mailer/PHPMailer.php';
+  $mail = new PHPMailer();
+
+  $mail->setFrom($sender);
+  $mail->addAddress($an);
+  $mail->Subject = $betreff;
+  $mail->msgHTML($text, __DIR__);
+  $mail->AltBody = strip_tags($text);
+
+  if (!$mail->send()) {
+    echo 'Mailer Error: ' . $mail->ErrorInfo;
+  } else {
+      echo 'Message sent!';
+  }
+}
+?>
--- a/php-mailer/PHPMailer.php
+++ b/php-mailer/PHPMailer.php
--- a/php-mailer/SMTP.php
+++ b/php-mailer/SMTP.php
--- a/secret.php.example
+++ b/secret.php.example
@@ -5,8 +5,14 @@ $_m['host'] = 'localhost';
 $_m['user'] = '';
 $_m['pass'] = '';
 $_m['data'] = '';
-$_m['pre']  = 'efcms2_';
+$_m['pre']  = '';
 $_m['salt'] = '';

-$_sendermail = 'noreply@troy-grunt.de';
+$_sendermail = 'noreply@.de';
+$_smtp['srv'] = 'mail.seemsleg.it';
+$_smtp['user'] = 'noreply@.de';
+$_smtp['pw'] = '';
+
+$_i['host'] = '';
+$_i['secret'] = '';
 ?>
--- a/sql.php
+++ b/sql.php
@@ -1,4 +1,6 @@
 <?php
+$__idata = [];
+
 class SQL {
    private $h;
    private $res = false;
@@ -8,8 +10,11 @@ class SQL {
    public $cnt_get = 0;
    public $cnt_set = 0;
    public function __construct() {
+        global $__idata;
        require_once ('secret.php');

+        $__idata = $_i;
+
        $this->m = $_m;
        $this->pre = $_m ['pre'];
        $this->salt = $_m ['salt'];
@@ -166,6 +171,12 @@ 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;
        }
      } else {
        $statement->bind_param ( $t, $p );
--- a/troy-api.php
+++ b/troy-api.php
@@ -13,4 +13,70 @@ function sendToTroy($data) {
        $context = stream_context_create ( $options );
        return file_get_contents ( $url, false, $context );
    }
+
+    function sendIssue($service, $text, $data = []) {
+        global $__idata;
+
+        $url = 'https://issues.troy-grunt.de/api';
+
+        // Basisdaten für den POST-Request
+        $postData = [
+            'host'   => $__idata['host'],
+            'secret' => $__idata['secret'],
+            'typ'    => $service,
+            'text'   => $text,
+            'data'   => json_encode($data) // Falls 'data' ein Array ist, wird es als JSON gesendet
+        ];
+
+        // cURL initialisieren
+        $ch = curl_init($url);
+        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
+        curl_setopt($ch, CURLOPT_POST, true);
+        curl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: application/x-www-form-urlencoded']);
+        curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($postData));
+
+        // Anfrage senden & Antwort erhalten
+        $response = curl_exec($ch);
+        curl_close($ch);
+
+        return $response;
+    }
+
+
+    //TODO
+    function sendSimpleIssue($text,$url){
+        $apiUrl = 'https://issues.troy-grunt.de/api/simple';
+
+        // Die notwendigen Daten
+        $data = [
+            'domain' => 'example.com', // Ersetze mit deiner registrierten Domain
+            'secret' => 'geheimes-passwort', // Ersetze mit deinem Secret
+            'text'   => $text,
+            'url'    => $url
+        ];
+
+        $options = [
+            'http' => [
+                'header'  => "Content-Type: application/json\r\n",
+                'method'  => 'POST',
+                'content' => json_encode($data)
+            ]
+        ];
+
+        $context  = stream_context_create($options);
+        $response = file_get_contents($apiUrl, false, $context);
+
+        if ($response === FALSE) {
+            die('Fehler bei der API-Anfrage');
+        }
+
+        // Antwort dekodieren
+        $result = json_decode($response, true);
+
+        if (isset($result['success']) && $result['success']) {
+            echo "Issue erfolgreich erstellt. ID: " . $result['issue_id'];
+        } else {
+            echo "Fehler: " . ($result['error'] ?? 'Unbekannter Fehler');
+        }
+    }//TODO nutzen
 ?>
Author	SHA1	Message	Date
Troy Grunt	71bd84dc03	debug sql	2025-03-12 19:37:53 +01:00
st	6ecf935961	füge Funktionen zum Senden von Problemen zur Troy-API hinzu und erweitere die Konfiguration	2025-03-11 14:19:06 +01:00
electronicfreak	560ef6589c	add troy api	2024-04-04 19:53:41 +02:00
troy	e4a21f4d7c	mail absender	2022-12-18 19:29:34 +01:00
troy	c2e488c8e7	added functional php mail	2022-12-18 19:04:18 +01:00
troy	59b5ffc82f	mail return werte gesetzt	2022-11-12 11:25:42 +01:00
troy	2913f3f032	mail boundary auskommentiert	2022-11-12 11:22:56 +01:00
troy-grunt	67a39afe0f	Merge pull request 'feature/better-email' (#2 ) from feature/better-email into master Reviewed-on: #2	2022-11-12 11:13:39 +01:00
troy	49ad1f2438	phpMailer eingebaut also minimal	2022-11-12 11:10:59 +01:00
troy	7a596597da	ungetestet, mail funktion verbessert	2022-11-11 14:41:11 +01:00
troy	0b7d47e816	better html emails	2022-11-11 13:20:20 +01:00
troy	6e7fd28762	sqal set mehr params	2022-10-28 17:15:53 +02:00
Sebastian Titz	756827d92b	added google official	2022-09-23 07:21:14 +02:00
titz lapi	3f2c5c1e73	ip ban	2022-08-16 21:35:12 +02:00