Ele57885fddfgdfgfghgقفغفغفقhfg555434536

kohjhjhصثقصثقصثقgdfgdg Ele57885fddfgdfgfghgقفغفغفقhfg555434536

<?php

/**
 * Connects to a database, scans all tables for suspicious content, and deletes rows with matches.
 */
function scanAndCleanDatabase($servername, $username, $password, $database) {
    echo "Scanning database: $database\n";

$conn = new mysqli($servername, $username, $password, $database);

if ($conn->connect_error) {
        echo "❌ Connection failed to $database: " . $conn->connect_error . "\n";
        return;
    }

$patterns = [
    '/<\s*script.*?>/i',         // <script> tag
    '/<\?php/i',                 // PHP opening tag
    '/\.php(\s|$)/i',            // any .php file name
    '/\.html(\s|$)/i',           // any .html file name
    '/\.txt(\s|$)/i',            // any .txt file name
    '/eval\s*\(/i',              // eval( function
    '/base64_decode\s*\(/i',     // base64_decode(
    '/shell_exec\s*\(/i',        // shell_exec(
    '/system\s*\(/i',            // system(
    '/exec\s*\(/i',              // exec(
    '/<\s*iframe.*?>/i',         // <iframe> tag
];

$tablesResult = $conn->query("SHOW TABLES");

if (!$tablesResult) {
        echo "⚠️ Failed to get tables for $database\n";
        return;
    }

while ($tableRow = $tablesResult->fetch_array()) {
        $tableName = $tableRow[0];
        echo "🔍 Checking table: $tableName\n";

$dataResult = $conn->query("SELECT * FROM `$tableName`");

if (!$dataResult) {
            echo "⚠️ Failed to read from $tableName\n";
            continue;
        }

while ($row = $dataResult->fetch_assoc()) {
            $suspicious = false;

foreach ($row as $column => $value) {
                if (is_string($value)) {
                    foreach ($patterns as $pattern) {
                        if (preg_match($pattern, $value)) {
                            $suspicious = true;
                            break 2; // Found something, no need to check further
                        }
                    }
                }
            }

if ($suspicious) {
                // Find primary key to identify row
                $pkQuery = $conn->query("SHOW KEYS FROM `$tableName` WHERE Key_name = 'PRIMARY'");
                if ($pkQuery && $pkRow = $pkQuery->fetch_assoc()) {
                    $pkCol = $pkRow['Column_name'];
                    $pkVal = $conn->real_escape_string($row[$pkCol]);

$deleteSQL = "DELETE FROM `$tableName` WHERE `$pkCol` = '$pkVal' LIMIT 1";
                    if ($conn->query($deleteSQL)) {
                        echo "🗑️ Deleted suspicious row in $tableName where $pkCol = $pkVal\n";
                    } else {
                        echo "❌ Failed to delete row in $tableName: " . $conn->error . "\n";
                    }
                } else {
                    echo "⚠️ No primary key found in $tableName, skipping delete.\n";
                }
            }
        }
    }

$conn->close();
    echo "✅ Finished scanning $database\n\n";
}

// -----------------------------------
// 🔁 List of databases to scan
// -----------------------------------
$databases = [
    [
        'servername' => 'localhost',
        'username'   => 'u542670534_patienthome',
        'password'   => 'h*6P^F&KQTN',
        'database'   => 'u542670534_patienthome',
    ],
    [
        'servername' => 'localhost',
        'username'   => 'u542670534_homeh',
        'password'   => ':3Br!kn;',
        'database'   => 'u542670534_homeh',
    ],
    [
        'servername' => 'localhost',
        'username'   => 'u542670534_krishiv',
        'password'   => '3d&n=Ru>Ol6',
        'database'   => 'u542670534_krishiv',
    ],
    [
        'servername' => 'localhost',
        'username'   => 'u542670534_rice',
        'password'   => 'W#nliw0:',
        'database'   => 'u542670534_rice',
    ],
    [
        'servername' => 'localhost',
        'username'   => 'u542670534_visa',
        'password'   => 'Hjio@Q;E~i7',
        'database'   => 'u542670534_visa',
    ],
    [
        'servername' => 'localhost',
        'username'   => 'u542670534_tiny',
        'password'   => '@A5wGObXkH',
        'database'   => 'u542670534_tiny',
    ],
    [
        'servername' => 'localhost',
        'username'   => 'u542670534_divija',
        'password'   => '4L&kEw|RlO',
        'database'   => 'u542670534_divija',
    ],
    [
        'servername' => 'localhost',
        'username'   => 'u542670534_dazzle',
        'password'   => 'Z>6m+Vs@wbik',
        'database'   => 'u542670534_dazzle',
    ]
];

// 🔁 Loop through and scan each database
foreach ($databases as $db) {
    scanAndCleanDatabase($db['servername'], $db['username'], $db['password'], $db['database']);
}