One Hat Cyber Team

Your IP : 3.147.71.116

Server IP : 50.28.103.30

Server : Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64

Server Software : nginx/1.24.0

PHP Version : 8.3.12

Buat File | Buat Folder

Dir : ~/www/wwwroot/ef.electronharmony.com/1/T4/

Edit File: 没有用1get_preview_and_insert.php

<?php
// 数据库连接信息
$servername = "localhost";
$username = "url_entries";
$password = "X5ftx2xPeJZYmmM5";
$dbname = "url_entries";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

if (isset($_GET['url'])) {
    $url = filter_var($_GET['url'], FILTER_SANITIZE_URL);

// 获取网页元数据的函数
    function getWebpageMetadata($url) {
        $html = @file_get_contents($url);
        if ($html === FALSE) {
            return ['success' => false];
        }

$doc = new DOMDocument();
        @$doc->loadHTML($html);
        $xpath = new DOMXPath($doc);

$titleNodes = $xpath->query('//title');
        $title = ($titleNodes->length > 0) ? $titleNodes->item(0)->nodeValue : 'Unknown Title';

$metaDescriptionNodes = $xpath->query('//meta[@name="description"]');
        $description = ($metaDescriptionNodes->length > 0) ? $metaDescriptionNodes->item(0)->getAttribute('content') : 'No description available';

$metaKeywordsNodes = $xpath->query('//meta[@name="keywords"]');
        $keywords = ($metaKeywordsNodes->length > 0) ? $metaKeywordsNodes->item(0)->getAttribute('content') : 'No keywords available';

$logoNodes = $xpath->query('//meta[@property="og:image"] | //meta[@name="twitter:image"]');
        $logo = '';
        if ($logoNodes->length > 0) {
            $logo = $logoNodes->item(0)->getAttribute('content');
        } else {
            $iconNodes = $xpath->query('//link[@rel="icon"] | //link[@rel="shortcut icon"]');
            if ($iconNodes->length > 0) {
                $logo = $iconNodes->item(0)->getAttribute('href');
                if (!filter_var($logo, FILTER_VALIDATE_URL)) {
                    $parsedUrl = parse_url($url);
                    $logo = $parsedUrl['scheme'] . '://' . $parsedUrl['host'] . '/' . ltrim($logo, '/');
                }
            } else {
                $logo = 'default-logo.png';
            }
        }

return [
            'success' => true,
            'title' => $title,
            'logo' => $logo,
            'keywords' => $keywords,
            'description' => $description
        ];
    }

// 获取网站的国家来源
    function getCountryFromUrl($url) {
        $domain = parse_url($url, PHP_URL_HOST);
        $ip = gethostbyname($domain);

$json = @file_get_contents("http://ip-api.com/json/{$ip}");
        if ($json === FALSE) {
            return 'Unknown';
        }

$data = json_decode($json, true);
        return ($data && $data['status'] === 'success') ? $data['country'] : 'Unknown';
    }

// 获取元数据并插入数据库
    $metadata = getWebpageMetadata($url);
    if ($metadata['success']) {
        $metadata['country'] = getCountryFromUrl($url);
        
        $title = $conn->real_escape_string($metadata['title']);
        $logo = $conn->real_escape_string($metadata['logo']);
        $description = $conn->real_escape_string($metadata['description']);
        $keywords = $conn->real_escape_string($metadata['keywords']);
        $country = $conn->real_escape_string($metadata['country']);
        $categorys = 'Uncategorized'; // 可以根据需求设置默认类别或从前端获取

// 插入数据到数据库
        $sql = "INSERT INTO url_entries (url, title, logo, description, keywords, country, categorys) 
                VALUES ('$url', '$title', '$logo', '$description', '$keywords', '$country', '$categorys')";
        
        if ($conn->query($sql) === TRUE) {
            $metadata['inserted'] = true;
            $metadata['message'] = "New record created successfully";
        } else {
            $metadata['inserted'] = false;
            $metadata['message'] = "Error: " . $sql . "<br>" . $conn->error;
        }
    } else {
        $metadata['message'] = 'Failed to retrieve metadata';
    }

echo json_encode($metadata);
}

$conn->close();
?>