# Member Medals Provider Generator

Web-first local tool to generate external Member Medals providers without editing the core extension.

## Highlights
- Guided wizard in the browser
- Portuguese and English UI
- SQL preview and SQL test
- Database schema browser for tables and columns
- Advanced visual condition builder with up to 5 conditions, lists, and ranges
- Simple JOIN support
- Saved projects and generation history
- Hardening for ZIP inspection and safer distribution defaults
- Ready-to-load example presets
- Automatic README generation inside every generated provider
- Optional CLI and `.bat` helpers kept in the package
- Comparison mode against a loaded provider/project/history/example baseline

## Recommended setup
Run the tool in its own folder under XAMPP `htdocs`, separate from phpBB.

Example:
`C:\xampp\htdocs\membermedals_provider_generator`

Then open:
`http://localhost/membermedals_provider_generator/`

## Requirements
- PHP 8+
- `ZipArchive` enabled for ZIP inspection and ZIP generation
- `mysqli` enabled for SQL test
- Writable `output/` folder or writable application root so the tool can create it

## Safety notes
- ZIP uploads are limited by the PHP upload limit and by the app limit.
- ZIP extraction is validated before files are unpacked.
- Extraction blocks unsafe paths such as traversal entries.
- The maintenance panel can clear session state and purge older artifacts from `output/`.

## Package layout
- `index.php` and `download.php`: web UI
- `lib/`: shared generator engine
- `lang/`: interface languages
- `cli/`: optional command-line helpers
- `examples/`: example JSON configs
- `output/`: generated extensions, project files, and history files

## Ready examples
The web UI includes one-click ready examples for friends, foes, warnings, attachments, posts, topics, and a simple posts-via-JOIN scenario.

## New in 1.5.0
- Friendlier typography and softer reading-focused web styling
- Richer auto-generated README inside every generated provider
- Better generated package presentation for distribution and handoff

## Distribution tip
The web interface is the recommended path for most users. Keep the CLI in the package as an optional fallback.


## New in 1.5.0

- Final visual polish for the web wizard with friendlier typography and refined spacing.
- Each generated provider now includes `CHANGELOG.md` and `provider-manifest.json`.


## New in 1.6.0

- Added a built-in quick start / mini home section inside the web UI
- Added short in-tool documentation for recommended paths, generated output, and common limits
- Kept the wizard unchanged underneath, so onboarding is better without changing the core flow


## New in 1.9.0

The SQL test step can now also fetch a small real sample of users/rows, helping validate whether the rule makes sense before generating the provider.


## New in 1.10.0

- Reopen an existing external provider ZIP and rebuild the form for editing.
- Uses provider-manifest.json when available, with heuristic fallback to composer/provider/lang files.


## What is new in 1.13.0

- Compare the current configuration against a previously loaded provider, project, history item, or ready example.
- Download a comparison JSON artifact next to the generated ZIP and report.
- Review changed fields and previous/current SQL directly in the web UI.

## What is new in 1.11.0

- Generated provider validation checklist.
- Final generation report with downloadable JSON artifact.
- Official integration gallery on the home screen.


## New in 1.13.0

- Snippet library for common filters
- Contextual help inside the review form
- Faster setup for repeated visibility/friends/foes/attachments-style rules


## New in 1.18.0

The visual condition builder now supports two logical groups with parentheses, so you can model rules like `(group 1) AND (group 2)` or `(group 1) OR (group 2)` without dropping straight into manual SQL.


## New in 1.17.0

- Release / distribution mode with a release bundle name, release notes JSON, and release manifest output.
- Deeper cross-file validation for ext.php and event listener wiring.
- Release checklist embedded in the final report.


## New in 1.19.3

- Added French (`fr`) as a built-in web UI language.
- Moved the remaining small button/label texts to the language layer.
- Improved localization fallback for cards, templates, and snippets.

## New in 1.19.1

- Darker compact web theme closer to the original look.
- Albert Sans typography for a friendlier reading rhythm.
- Runtime translations loaded only from `lang/*.php`, with language discovery based on the files present.

## New in 1.19.0

- Full backup/export bundle from the web UI
- Deeper generated-provider validation
- Final release review artifact and panel


## Simple mode

Start with **Simple** mode if you are not comfortable with all generator options yet. It reduces the entry points to three large paths and now gives clearer next-step guidance after each action.