FM / httpdocs

/var/www/vhosts/m-auto.co/httpdocs

Name	Size	Mode	Actions
admin/	-	0755	rm
ajax/	-	0755	rm
assets/	-	0755	rm
includes/	-	0755	rm
uploads/	-	0755	rm
.htaccess	2906	0644	edit dl rm
7-6-2026.zip	15953	0644	edit dl rm
404.php	1346	0644	edit dl rm
500.php	1326	0644	edit dl rm
about.php	2214	0644	edit dl rm
add_technical_specs.php	3659	0644	edit dl rm
ajax_filter_cars.php	7412	0644	edit dl rm
atom.xml	6281244	0644	edit dl rm
BACKGROUND_THEMES_INFO.md	4561	0644	edit dl rm
Backup.zip	4965	0644	edit dl rm
branches.php	10788	0644	edit dl rm
calculator.php	5897	0644	edit dl rm
cars.php	21991	0644	edit dl rm
car_condition_summary.php	9248	0644	edit dl rm
car_details.php	22584	0644	edit dl rm
CAR_GALLERY_README.md	7870	0644	edit dl rm
car_gallery_summary.php	10857	0644	edit dl rm
check_brand_matching.php	2000	0644	edit dl rm
cleanup_for_production.php	4878	0644	edit dl rm
compare.php	20255	0644	edit dl rm
COMPARISON_SYSTEM_README.md	6832	0644	edit dl rm
contact.php	3819	0644	edit dl rm
contact_process.php	2370	0644	edit dl rm
database_backup_2025-11-04_13-01-05.sql	48138	0644	edit dl rm
debug_brands.php	2267	0644	edit dl rm
deployment_checklist.php	6860	0644	edit dl rm
DEPLOYMENT_GUIDE.md	2712	0644	edit dl rm
export_database.php	3329	0644	edit dl rm
find_nearest_branch.php	2889	0644	edit dl rm
get-sitemap.php	2580	0644	edit dl rm
get_branches_by_city.php	4697	0644	edit dl rm
google7cbe8ec413192e2a.html	53	0644	edit dl rm
google69217c47da90dd66.html	53	0644	edit dl rm
index.php	633559	0644	edit dl rm
m11.zip	32222824	0644	edit dl rm
main.php	12595	0644	edit dl rm
main1.php	11911	0644	edit dl rm
maintenance.php	4169	0644	edit dl rm
maintenance_process.php	3408	0644	edit dl rm
manifest.json	828	0644	edit dl rm
news.php	2691	0644	edit dl rm
news_article.php	6536	0644	edit dl rm
ODOO_INTEGRATION_README.md	4435	0644	edit dl rm
offers.php	2218	0644	edit dl rm
PRODUCTION_SUMMARY.md	6426	0644	edit dl rm
quick_test_gallery.php	6078	0644	edit dl rm
README.md	6170	0644	edit dl rm
robots.txt	59	0644	edit dl rm
server_check.php	5293	0644	edit dl rm
sitemap.js	479620	0644	edit dl rm
sitemap.xml	6281829	0644	edit dl rm
sw.js	1954	0644	edit dl rm
test_odoo_connection.php	3474	0644	edit dl rm
visit.php	3781	0644	edit dl rm
visit_process.php	2771	0644	edit dl rm
x.txt	479657	0644	edit dl rm

Edit: /var/www/vhosts/m-auto.co/httpdocs/export_database.php (3329B)

<?php
// Database export script for production deployment
include 'includes/db.php';

// Set execution time limit
set_time_limit(300);

// Output file
$backup_file = 'database_backup_' . date('Y-m-d_H-i-s') . '.sql';

// Get all tables
$tables = array();
$result = $conn->query("SHOW TABLES");
while ($row = $result->fetch_row()) {
    $tables[] = $row[0];
}

$sql_dump = "-- M-AUTO Database Backup\n";
$sql_dump .= "-- Generated on: " . date('Y-m-d H:i:s') . "\n";
$sql_dump .= "-- Database: m11\n\n";

$sql_dump .= "SET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";\n";
$sql_dump .= "SET AUTOCOMMIT = 0;\n";
$sql_dump .= "START TRANSACTION;\n";
$sql_dump .= "SET time_zone = \"+00:00\";\n\n";

$sql_dump .= "/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\n";
$sql_dump .= "/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\n";
$sql_dump .= "/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\n";
$sql_dump .= "/*!40101 SET NAMES utf8mb4 */;\n\n";

foreach ($tables as $table) {
    // Get table structure
    $sql_dump .= "-- --------------------------------------------------------\n";
    $sql_dump .= "-- Table structure for table `$table`\n";
    $sql_dump .= "-- --------------------------------------------------------\n\n";
    
    $sql_dump .= "DROP TABLE IF EXISTS `$table`;\n";
    
    $create_table = $conn->query("SHOW CREATE TABLE `$table`");
    $row = $create_table->fetch_row();
    $sql_dump .= $row[1] . ";\n\n";
    
    // Get table data
    $sql_dump .= "-- Dumping data for table `$table`\n";
    $sql_dump .= "-- --------------------------------------------------------\n\n";
    
    $result = $conn->query("SELECT * FROM `$table`");
    if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $sql_dump .= "INSERT INTO `$table` (";
            $columns = array_keys($row);
            $sql_dump .= "`" . implode("`, `", $columns) . "`";
            $sql_dump .= ") VALUES (";
            
            $values = array();
            foreach ($row as $value) {
                if ($value === null) {
                    $values[] = "NULL";
                } else {
                    $values[] = "'" . $conn->real_escape_string($value) . "'";
                }
            }
            $sql_dump .= implode(", ", $values);
            $sql_dump .= ");\n";
        }
    }
    $sql_dump .= "\n";
}

$sql_dump .= "COMMIT;\n\n";
$sql_dump .= "/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;\n";
$sql_dump .= "/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;\n";
$sql_dump .= "/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;\n";

// Save to file
file_put_contents($backup_file, $sql_dump);

echo "<h2>Database Export Completed!</h2>";
echo "<p>Backup file created: <strong>$backup_file</strong></p>";
echo "<p>File size: " . formatBytes(filesize($backup_file)) . "</p>";
echo "<p><a href='$backup_file' download>Download Backup File</a></p>";

function formatBytes($size, $precision = 2) {
    $base = log($size, 1024);
    $suffixes = array('B', 'KB', 'MB', 'GB', 'TB');
    return round(pow(1024, $base - floor($base)), $precision) . ' ' . $suffixes[floor($base)];
}

$conn->close();
?>

query("SHOW TABLES"); while ($row = $result->fetch_row()) { $tables[] = $row[0]; } $sql_dump = "-- M-AUTO Database Backup\n"; $sql_dump .= "-- Generated on: " . date('Y-m-d H:i:s') . "\n"; $sql_dump .= "-- Database: m11\n\n"; $sql_dump .= "SET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";\n"; $sql_dump .= "SET AUTOCOMMIT = 0;\n"; $sql_dump .= "START TRANSACTION;\n"; $sql_dump .= "SET time_zone = \"+00:00\";\n\n"; $sql_dump .= "/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\n"; $sql_dump .= "/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\n"; $sql_dump .= "/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\n"; $sql_dump .= "/*!40101 SET NAMES utf8mb4 */;\n\n"; foreach ($tables as $table) { // Get table structure $sql_dump .= "-- --------------------------------------------------------\n"; $sql_dump .= "-- Table structure for table `$table`\n"; $sql_dump .= "-- --------------------------------------------------------\n\n"; $sql_dump .= "DROP TABLE IF EXISTS `$table`;\n"; $create_table = $conn->query("SHOW CREATE TABLE `$table`"); $row = $create_table->fetch_row(); $sql_dump .= $row[1] . ";\n\n"; // Get table data $sql_dump .= "-- Dumping data for table `$table`\n"; $sql_dump .= "-- --------------------------------------------------------\n\n"; $result = $conn->query("SELECT * FROM `$table`"); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $sql_dump .= "INSERT INTO `$table` ("; $columns = array_keys($row); $sql_dump .= "`" . implode("`, `", $columns) . "`"; $sql_dump .= ") VALUES ("; $values = array(); foreach ($row as $value) { if ($value === null) { $values[] = "NULL"; } else { $values[] = "'" . $conn->real_escape_string($value) . "'"; } } $sql_dump .= implode(", ", $values); $sql_dump .= ");\n"; } } $sql_dump .= "\n"; } $sql_dump .= "COMMIT;\n\n"; $sql_dump .= "/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;\n"; $sql_dump .= "/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;\n"; $sql_dump .= "/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;\n"; // Save to file file_put_contents($backup_file, $sql_dump); echo "

Database Export Completed!

"; echo "

Backup file created: $backup_file

"; echo "

File size: " . formatBytes(filesize($backup_file)) . "

"; echo "

Download Backup File

"; function formatBytes($size, $precision = 2) { $base = log($size, 1024); $suffixes = array('B', 'KB', 'MB', 'GB', 'TB'); return round(pow(1024, $base - floor($base)), $precision) . ' ' . $suffixes[floor($base)]; } $conn->close(); ?>