WP Transformer

Converts WordPress MySQL dumps into self-contained static HTML sites — no live WordPress installation required.

Stack

• PHP 8.1+ — no framework, no Composer
• MySQL — two tables (wpt_users, wpt_tenants)
• Tailwind CSS v3 — pre-compiled, dark theme
• Hosting — any managed PHP/MySQL host (tested: ALL-INKL)

Architecture

SQL Dump (Upload)
    │
    ▼
WPParser          — pure-PHP tokenizer, no MySQL dependency
    │
    ▼
content.json      — posts, pages, categories
    │
    ▼
StaticBuilder     — index.html, per-post HTML, feed.json, .htaccess
    │
    ├── ZIP Download
    └── FTP Deploy  → Customer subdomain / server

Multi-Tenant Pipeline

Each tenant (client) goes through four steps — with human review at each:

1. SQL Upload — WordPress UpdraftPlus / mysqldump export
2. Parse — extracts posts/pages/categories, auto-detects DB prefix
3. Build — generates static HTML with per-tenant branding
4. Deploy — ZIP download or direct FTP push

Deployment (ALL-INKL)

1. Upload all files via FTP to domain root
2. Import init.sql via phpMyAdmin
3. Create config.local.php in root (see below)
4. Open https://yourdomain.tld/setup.php — or upload config.local.php directly
5. KAS → Subdomains: point tenant.yourdomain.tld → tenants/{slug}/public

config.local.php

<?php
define('DB_HOST', 'localhost');
define('DB_NAME', 'your_db_name');
define('DB_USER', 'your_db_user');
define('DB_PASS', 'your_db_pass');

Security

• .htaccess blocks direct access to .sql, .sh, .md, config.local.php
• tenants/ blocked except tenants/*/public/
• CSRF tokens on all POST forms
• Path traversal protection on $slug
• display_errors off in production
• bcrypt password hashing (cost 12)
• IP-based login rate limiting via access_logs

Long-Term Architecture

RZ (fixed IP, BSI, Zero Trust)
  └── RetroPWD + Ollama AI Backend
         │  AI-assisted content generation  [human review]
         ▼
  WPTransformer (managed hosting)
         │  Parse → Build → Deploy          [human review]
         ▼
  Customer static sites
  (e.g. ozm.wptransformer.org → onezeromore.com)

Version

1.0.0 — Initial production release, May 2026