Compare commits
56 Commits
| Author | SHA1 | Date | |
|---|---|---|---|
| 85c16b4af4 | |||
| 094787d26d | |||
| 064963da9c | |||
| 49463eb747 | |||
| 07cbe5de52 | |||
| fbf97b2cdb | |||
| 7cb0b08cfe | |||
| 5ffcbcc2f1 | |||
| a47a9e5deb | |||
| 7165da4999 | |||
| c0ecf6ce73 | |||
| 6060979ce8 | |||
| da71057079 | |||
| 8dc4eaa384 | |||
| 4027c727d9 | |||
| b729aa5052 | |||
| 7a829b6eca | |||
| 447f7b572e | |||
| f56c1bfbd1 | |||
| aeb9d18ccb | |||
| 0a51ed75da | |||
| 0ae9bfd93a | |||
| 1c0a87ca4a | |||
| 2cb8527c25 | |||
| 35febb8854 | |||
| bf91611b97 | |||
| 9bc0fc8ad8 | |||
| e75a58709b | |||
| 8be1e332c6 | |||
| ba91f74edc | |||
| 387bfbdeda | |||
| f7d8d82a4e | |||
| 9e5a942800 | |||
| dad3ce2db3 | |||
| 8325afb03a | |||
| 662918db38 | |||
| 1ab99daaba | |||
| c84dcf2864 | |||
| e1f5afb301 | |||
| dfd4e77ade | |||
| 1a1c81550c | |||
| 9571b3759a | |||
| 115ccfb069 | |||
| 2d538d3372 | |||
| 97e8d0cbe9 | |||
| 8d5b33a74d | |||
| 77bfaff8cd | |||
| 1c420b2277 | |||
| 2af2641712 | |||
| a3c7183374 | |||
| 4f91d1e432 | |||
| 604412f82f | |||
| a92f423767 | |||
| ba2cda1385 | |||
| 72aeea6955 | |||
| 8a85370e32 |
@@ -5,7 +5,7 @@
|
||||
# FILE INFORMATION
|
||||
# DEFGROUP: MokoGitea.Workflow
|
||||
# INGROUP: mokocli.Automation
|
||||
# VERSION: 02.57.00
|
||||
# VERSION: 02.58.13
|
||||
# BRIEF: Auto-create feature branch when an issue is opened
|
||||
|
||||
name: "Universal: Issue Branch"
|
||||
|
||||
@@ -2,6 +2,43 @@
|
||||
|
||||
## [Unreleased]
|
||||
|
||||
### Added
|
||||
- Pre-update backup **notice + live-progress modal** on the admin update pages (Joomla Update and Extensions → Update). Because the server-side `onExtensionBeforeUpdate` backup runs synchronously and can't drive a browser modal, the system plugin now injects a "back up before you update" notice with a **Back up now** button that runs the same stepped backup as the dashboard and shows a live progress bar. On success it pings a new `ajax.preupdateAck` endpoint, which arms the same throttle the server-side hook checks — so clicking Joomla's Update afterwards won't run a duplicate backup. Gated by the existing `show_update_notice` + `backup_before_update` params. (#196)
|
||||
- Pre-update modal **phase 2 — "Auto-run on Update click"** (new opt-in param `preupdate_auto_intercept`, off by default). When enabled, clicking the toolbar **Update** button on the Joomla Update / Extensions-update page first pops the backup progress modal, runs the pre-update backup, then automatically continues the update. Implemented by wrapping `Joomla.submitbutton` for the `update.update` / `update.install` tasks only (Find Updates / Clear Cache are untouched); the manual "Back up now" notice remains as a fallback for any flow that doesn't route through `submitbutton`. (#196)
|
||||
- Retention now prunes **remote** copies too: when a backup is pruned by age/count, its archive is deleted from every enabled remote destination (SFTP / FTP / S3 / Google Drive), not just the local copy. Each uploader gained an idempotent `delete()` method (already-absent file = success), and removal is best-effort — a failing destination is logged but never blocks local pruning. The shared standalone `restore.php` is intentionally left in place (every backup overwrites it, so newer backups still depend on it). (#229)
|
||||
|
||||
### Changed
|
||||
- Consolidated backup plumbing into shared helpers (#230):
|
||||
- New `RemoteUploaderFactory` replaces the `createUploaderFromParams()` copy that was duplicated in `BackupEngine` and `SteppedBackupEngine`.
|
||||
- `RetentionManager` is now the single retention authority — it takes the global `max_age_days`/`max_backups` fallback and gained `pruneOrphans()`; the system plugin's hourly cleanup delegates to it and its duplicate `deleteBackupRecord()` logic is removed.
|
||||
- The backend controller, Web Services API controller, and legacy `cli/mokosuitebackup.php` now run backups through the shared `BackupRunner` (gaining the normalized complete/warning/fail status) instead of instantiating `BackupEngine` directly.
|
||||
|
||||
### Fixed
|
||||
- Pre-update/uninstall backup no longer **white-screens** the update on large sites. The synchronous backup that runs inside the extension update/uninstall request now raises `max_execution_time`/`memory_limit` (and `ignore_user_abort`) like the web-cron path, so it can't exhaust the request's default limits mid-backup. (Core Joomla updates additionally get a full-screen backup screen — see below.)
|
||||
- Archive names for **CLI/console-triggered backups** no longer come out as `joomla.invalid_…`. The `[HOST]` placeholder took `$_SERVER['HTTP_HOST']` verbatim, but Joomla's console fills that with the reserved sentinel host `joomla.invalid`; the resolver now treats that (like empty/`localhost`) as unusable and falls back to the configured `live_site` host, then the system hostname. (Set the site's *live_site* to get the exact domain in CLI-built names.)
|
||||
- Standalone restore script generation no longer aborts backups with `str_replace() expects at least 3 arguments, 2 given`. `MokoRestore::generateStandaloneScript()` had a `str_replace()` call (the "Backup Archive" pre-check rewrite) that was missing its `$php` subject argument, so **every** standalone-mode backup fatally errored while "Generating standalone restore.php…" — the archive still finalized and uploaded, but no `restore.php` was ever produced (the true root cause behind #226). (#226)
|
||||
- Remote upload: the standalone restore script upload is no longer silent — its result is now checked and logged, and a failed restore-script upload marks the backup as `warning` (previously the result was discarded, so a missing restore script on the remote went unreported while the archive still showed success). (#226)
|
||||
|
||||
## [02.58.00] --- 2026-07-06
|
||||
|
||||
### Added
|
||||
- SFTP destinations: **upload an SSH private key file** in the Add/Edit Destination modal instead of pasting it (reads the file into the key field client-side; pasting still works).
|
||||
|
||||
### Changed
|
||||
- Add/Edit Destination modal: wrap the content in a Bootstrap `.container-fluid` and give it a 1rem padding frame via the WAM stylesheet (Bootstrap's `.modal-content` has no padding of its own).
|
||||
|
||||
### Fixed
|
||||
- Pre-update backup now shows an admin notification on **every** outcome (success / warning / failure) — previously a *successful* pre-update backup fired nothing, so it looked like the notification wasn't working. (#192)
|
||||
|
||||
### Changed
|
||||
- Component admin CSS now loads via the Joomla **Web Asset Manager** (`media/com_mokosuitebackup/` + `joomla.asset.json`) instead of an inline `<style>` block.
|
||||
- "Keep local copy" is configured **per remote destination** (in the Add/Edit Destination modal); the redundant profile-level field and its "Remote" tab are removed.
|
||||
- Add/Edit Destination modal: cleaned up the cramped padding/margins.
|
||||
|
||||
### Fixed
|
||||
- Admin menu / duplicate-component fallout: (a) the orphaned `com_component-mokosuitebackup` is now removed in **preflight** too, so its "Backup" menu no longer collides on install ("The alias backup is already being used"); (b) `ensureSubmenuItems()` **recreates the top-level "Backup" menu** if it was deleted, instead of giving up — so Backup no longer disappears from the admin menu (and the cPanel module / MokoSuiteClient can find it again); (c) the component menu label now uses the short constant `COM_MOKOJOOMBACKUP_SHORT`. (#213 fallout)
|
||||
- Installer no longer aborts on MySQL 8 with "This command is not supported in the prepared statement protocol yet" (error 1295). The legacy remote-column purge migration (`02.56.01.sql`) used `PREPARE`/`EXECUTE`/`DEALLOCATE`, which Joomla's installer rejects; the drop now runs in the package installer script via an INFORMATION_SCHEMA-gated plain `ALTER` (portable across MariaDB and MySQL 8). (#213 update path)
|
||||
|
||||
## [02.57.00] --- 2026-07-05
|
||||
|
||||
### Added
|
||||
|
||||
+1
-1
@@ -23,7 +23,7 @@ DEFGROUP: Template-Joomla
|
||||
INGROUP: Template-Joomla.Documentation
|
||||
REPO: https://git.mokoconsulting.tech/MokoConsulting/Template-Joomla
|
||||
PATH: /SECURITY.md
|
||||
VERSION: 02.57.00
|
||||
VERSION: 02.58.13
|
||||
BRIEF: Security vulnerability reporting and handling policy
|
||||
-->
|
||||
|
||||
|
||||
Submodule source/packages/MokoSuiteClient updated: 2273690f94...30a6b53222
@@ -13,7 +13,7 @@ namespace Joomla\Component\MokoSuiteBackup\Api\Controller;
|
||||
defined('_JEXEC') or die;
|
||||
|
||||
use Joomla\CMS\MVC\Controller\ApiController;
|
||||
use Joomla\Component\MokoSuiteBackup\Administrator\Engine\BackupEngine;
|
||||
use Joomla\Component\MokoSuiteBackup\Administrator\Service\BackupRunner;
|
||||
|
||||
class BackupsController extends ApiController
|
||||
{
|
||||
@@ -38,8 +38,7 @@ class BackupsController extends ApiController
|
||||
$profileId = (int) ($data['profile'] ?? 1);
|
||||
$description = $data['description'] ?? 'API backup ' . date('Y-m-d H:i:s');
|
||||
|
||||
$engine = new BackupEngine();
|
||||
$result = $engine->run($profileId, $description, 'api');
|
||||
$result = (new BackupRunner())->run($profileId, $description, 'api');
|
||||
|
||||
if ($result['success']) {
|
||||
$this->app->setHeader('status', 200);
|
||||
|
||||
@@ -30,7 +30,7 @@ if (!defined('JPATH_BASE')) {
|
||||
require_once JPATH_BASE . '/includes/framework.php';
|
||||
|
||||
use Joomla\CMS\Factory;
|
||||
use Joomla\Component\MokoSuiteBackup\Administrator\Engine\BackupEngine;
|
||||
use Joomla\Component\MokoSuiteBackup\Administrator\Service\BackupRunner;
|
||||
|
||||
// Parse CLI arguments
|
||||
$profileId = 1;
|
||||
@@ -56,8 +56,7 @@ echo "Profile: {$profileId}\n";
|
||||
echo "Description: {$description}\n";
|
||||
echo "Starting backup...\n\n";
|
||||
|
||||
$engine = new BackupEngine();
|
||||
$result = $engine->run($profileId, $description, 'cli');
|
||||
$result = (new BackupRunner())->run($profileId, $description, 'cli');
|
||||
|
||||
if ($result['success']) {
|
||||
echo "SUCCESS: " . $result['message'] . "\n";
|
||||
|
||||
@@ -151,6 +151,18 @@
|
||||
<option value="1">JYES</option>
|
||||
<option value="0">JNO</option>
|
||||
</field>
|
||||
<field
|
||||
name="preupdate_auto_intercept"
|
||||
type="radio"
|
||||
label="COM_MOKOJOOMBACKUP_CONFIG_PREUPDATE_AUTO_INTERCEPT"
|
||||
description="COM_MOKOJOOMBACKUP_CONFIG_PREUPDATE_AUTO_INTERCEPT_DESC"
|
||||
default="0"
|
||||
class="btn-group"
|
||||
showon="backup_before_update:1"
|
||||
>
|
||||
<option value="1">JYES</option>
|
||||
<option value="0">JNO</option>
|
||||
</field>
|
||||
<field
|
||||
name="backup_before_uninstall"
|
||||
type="radio"
|
||||
|
||||
@@ -205,19 +205,9 @@
|
||||
/>
|
||||
</fieldset>
|
||||
|
||||
<fieldset name="remote" label="COM_MOKOJOOMBACKUP_FIELDSET_REMOTE">
|
||||
<field
|
||||
name="remote_keep_local"
|
||||
type="radio"
|
||||
label="COM_MOKOJOOMBACKUP_FIELD_KEEP_LOCAL"
|
||||
description="COM_MOKOJOOMBACKUP_FIELD_KEEP_LOCAL_DESC"
|
||||
default="1"
|
||||
class="btn-group"
|
||||
>
|
||||
<option value="1">JYES</option>
|
||||
<option value="0">JNO</option>
|
||||
</field>
|
||||
</fieldset>
|
||||
<!-- The "Keep local copy" setting is now configured per remote destination
|
||||
(in the Add/Edit Destination modal), so the profile-level field and its
|
||||
"Remote" tab have been removed. -->
|
||||
|
||||
<fieldset name="retention" label="COM_MOKOJOOMBACKUP_FIELDSET_RETENTION">
|
||||
<field
|
||||
|
||||
@@ -331,6 +331,8 @@ COM_MOKOJOOMBACKUP_CONFIG_SHOW_UPDATE_NOTICE_DESC="Display the update site confi
|
||||
COM_MOKOJOOMBACKUP_CONFIG_PREACTION="Pre-action Backups"
|
||||
COM_MOKOJOOMBACKUP_CONFIG_BACKUP_BEFORE_UPDATE="Backup Before Extension Update"
|
||||
COM_MOKOJOOMBACKUP_CONFIG_BACKUP_BEFORE_UPDATE_DESC="Automatically run a full backup before any extension is updated. Uses the default profile. Throttled to once per 10 minutes to prevent duplicate backups during batch updates."
|
||||
COM_MOKOJOOMBACKUP_CONFIG_PREUPDATE_AUTO_INTERCEPT="Auto-run on Update click"
|
||||
COM_MOKOJOOMBACKUP_CONFIG_PREUPDATE_AUTO_INTERCEPT_DESC="When enabled, clicking the Update button on the Joomla Update or Extensions update page first pops the backup progress modal, runs the pre-update backup, then automatically continues the update. When disabled, a notice with a manual 'Back up now' button is shown instead."
|
||||
COM_MOKOJOOMBACKUP_CONFIG_BACKUP_BEFORE_UNINSTALL="Backup Before Extension Uninstall"
|
||||
COM_MOKOJOOMBACKUP_CONFIG_BACKUP_BEFORE_UNINSTALL_DESC="Automatically run a full backup before any extension is uninstalled. Uses the default profile. Throttled to once per 10 minutes."
|
||||
|
||||
|
||||
@@ -53,6 +53,8 @@ COM_MOKOJOOMBACKUP_CONFIG_SHOW_UPDATE_NOTICE_DESC="Display the update site confi
|
||||
COM_MOKOJOOMBACKUP_CONFIG_PREACTION="Pre-action Backups"
|
||||
COM_MOKOJOOMBACKUP_CONFIG_BACKUP_BEFORE_UPDATE="Backup Before Extension Update"
|
||||
COM_MOKOJOOMBACKUP_CONFIG_BACKUP_BEFORE_UPDATE_DESC="Automatically run a full backup before any extension is updated. Uses the default profile. Throttled to once per 10 minutes to prevent duplicate backups during batch updates."
|
||||
COM_MOKOJOOMBACKUP_CONFIG_PREUPDATE_AUTO_INTERCEPT="Auto-run on Update click"
|
||||
COM_MOKOJOOMBACKUP_CONFIG_PREUPDATE_AUTO_INTERCEPT_DESC="When enabled, clicking the Update button on the Joomla Update or Extensions update page first pops the backup progress modal, runs the pre-update backup, then automatically continues the update. When disabled, a notice with a manual 'Back up now' button is shown instead."
|
||||
COM_MOKOJOOMBACKUP_CONFIG_BACKUP_BEFORE_UNINSTALL="Backup Before Extension Uninstall"
|
||||
COM_MOKOJOOMBACKUP_CONFIG_BACKUP_BEFORE_UNINSTALL_DESC="Automatically run a full backup before any extension is uninstalled. Uses the default profile. Throttled to once per 10 minutes."
|
||||
|
||||
|
||||
@@ -0,0 +1,33 @@
|
||||
/**
|
||||
* MokoSuiteBackup — admin styles (loaded via the Joomla Web Asset Manager).
|
||||
*/
|
||||
|
||||
/* Add/Edit Destination modal.
|
||||
* The modal content is wrapped in a Bootstrap .container-fluid because
|
||||
* Bootstrap's .modal-content has no padding of its own. Give that container a
|
||||
* single, comfortable 1rem frame and drop the inner sections' horizontal padding
|
||||
* so it isn't doubled. */
|
||||
#remoteModal .modal-content > .container-fluid {
|
||||
padding: 1rem;
|
||||
}
|
||||
|
||||
#remoteModal .modal-header,
|
||||
#remoteModal .modal-body,
|
||||
#remoteModal .modal-footer {
|
||||
padding-left: 0;
|
||||
padding-right: 0;
|
||||
}
|
||||
|
||||
#remoteModal .modal-body .row + .row,
|
||||
#remoteModal .remote-type-fields {
|
||||
margin-top: 0.25rem;
|
||||
}
|
||||
|
||||
#remoteModal hr {
|
||||
margin: 1rem 0;
|
||||
opacity: 0.12;
|
||||
}
|
||||
|
||||
#remoteModal .form-label {
|
||||
margin-bottom: 0.35rem;
|
||||
}
|
||||
@@ -0,0 +1,14 @@
|
||||
{
|
||||
"$schema": "https://developer.joomla.org/schemas/json-schema/web_assets.json",
|
||||
"name": "com_mokosuitebackup",
|
||||
"version": "1.0.0",
|
||||
"description": "MokoSuiteBackup web assets",
|
||||
"license": "GPL-3.0-or-later",
|
||||
"assets": [
|
||||
{
|
||||
"name": "com_mokosuitebackup.admin",
|
||||
"type": "style",
|
||||
"uri": "com_mokosuitebackup/css/admin.css"
|
||||
}
|
||||
]
|
||||
}
|
||||
@@ -17,7 +17,7 @@
|
||||
display label there.
|
||||
-->
|
||||
<name>MokoSuiteBackup</name>
|
||||
<version>02.57.00</version>
|
||||
<version>02.58.13</version>
|
||||
<creationDate>2026-06-02</creationDate>
|
||||
<author>Moko Consulting</author>
|
||||
<authorEmail>hello@mokoconsulting.tech</authorEmail>
|
||||
@@ -47,7 +47,7 @@
|
||||
</update>
|
||||
|
||||
<administration>
|
||||
<menu img="class:archive">Backup</menu>
|
||||
<menu img="class:archive">COM_MOKOJOOMBACKUP_SHORT</menu>
|
||||
<submenu>
|
||||
<menu link="option=com_mokosuitebackup&view=dashboard"
|
||||
img="class:home"
|
||||
@@ -78,6 +78,11 @@
|
||||
</languages>
|
||||
</administration>
|
||||
|
||||
<media destination="com_mokosuitebackup" folder="media">
|
||||
<folder>css</folder>
|
||||
<filename>joomla.asset.json</filename>
|
||||
</media>
|
||||
|
||||
<api>
|
||||
<files folder="api">
|
||||
<folder>src</folder>
|
||||
|
||||
@@ -1,32 +1,13 @@
|
||||
-- Purge legacy single-remote storage columns from installs where they are still present.
|
||||
-- Legacy single-remote storage columns are now purged by the package installer
|
||||
-- script (Pkg_MokoSuiteBackupInstallerScript::dropLegacyRemoteColumns()), NOT here.
|
||||
--
|
||||
-- Background: 02.52.25.sql originally used `DROP COLUMN IF EXISTS`, which is a
|
||||
-- MariaDB-only extension and errors on Oracle MySQL 8.x. On MySQL 8 installs the
|
||||
-- migration failed but Joomla still recorded the schema as applied, leaving all 26
|
||||
-- legacy remote_storage/ftp_*/sftp_*/gdrive_*/s3_* columns stranded on the profiles
|
||||
-- table. This migration removes them portably.
|
||||
-- The 26 legacy remote_storage/ftp_*/sftp_*/gdrive_*/s3_* columns must be removed
|
||||
-- portably across MariaDB and MySQL 8. `DROP COLUMN IF EXISTS` is MariaDB-only
|
||||
-- (errors on MySQL 8); plain `DROP COLUMN` errors when a column is absent. The
|
||||
-- previous version gated the ALTER on INFORMATION_SCHEMA and ran it via
|
||||
-- PREPARE/EXECUTE/DEALLOCATE — but those statements are rejected by Joomla's
|
||||
-- installer SQL path (MySQL error 1295: "This command is not supported in the
|
||||
-- prepared statement protocol yet"), which ABORTED the whole component install.
|
||||
--
|
||||
-- It must be safe on BOTH engines AND on installs where the columns are already gone
|
||||
-- (MariaDB, or anyone who ran the corrected 02.52.25). Plain `DROP COLUMN` errors when
|
||||
-- a column is absent, and `DROP COLUMN IF EXISTS` errors on MySQL 8 — so neither works
|
||||
-- unconditionally. We gate the drop on INFORMATION_SCHEMA and build the ALTER via a
|
||||
-- prepared statement, which runs on MySQL 8 and MariaDB alike. All 26 columns were
|
||||
-- created and dropped together, so the presence of `remote_storage` gates the whole set.
|
||||
-- When the columns are absent this is a no-op (`DO 0`).
|
||||
|
||||
SET @moko_has_legacy_remote := (
|
||||
SELECT COUNT(*)
|
||||
FROM INFORMATION_SCHEMA.COLUMNS
|
||||
WHERE TABLE_SCHEMA = DATABASE()
|
||||
AND TABLE_NAME = '#__mokosuitebackup_profiles'
|
||||
AND COLUMN_NAME = 'remote_storage'
|
||||
);
|
||||
|
||||
SET @moko_drop_legacy_remote := IF(@moko_has_legacy_remote > 0,
|
||||
'ALTER TABLE `#__mokosuitebackup_profiles` DROP COLUMN `remote_storage`, DROP COLUMN `ftp_host`, DROP COLUMN `ftp_port`, DROP COLUMN `ftp_username`, DROP COLUMN `ftp_password`, DROP COLUMN `ftp_path`, DROP COLUMN `ftp_passive`, DROP COLUMN `ftp_ssl`, DROP COLUMN `sftp_host`, DROP COLUMN `sftp_port`, DROP COLUMN `sftp_username`, DROP COLUMN `sftp_auth_type`, DROP COLUMN `sftp_password`, DROP COLUMN `sftp_key_data`, DROP COLUMN `sftp_passphrase`, DROP COLUMN `sftp_path`, DROP COLUMN `gdrive_client_id`, DROP COLUMN `gdrive_client_secret`, DROP COLUMN `gdrive_refresh_token`, DROP COLUMN `gdrive_folder_id`, DROP COLUMN `s3_endpoint`, DROP COLUMN `s3_region`, DROP COLUMN `s3_access_key`, DROP COLUMN `s3_secret_key`, DROP COLUMN `s3_bucket`, DROP COLUMN `s3_path`',
|
||||
'DO 0'
|
||||
);
|
||||
|
||||
PREPARE moko_stmt FROM @moko_drop_legacy_remote;
|
||||
EXECUTE moko_stmt;
|
||||
DEALLOCATE PREPARE moko_stmt;
|
||||
-- The drop is now done in PHP (INFORMATION_SCHEMA gate + a plain ALTER for only the
|
||||
-- columns that still exist), so this migration is intentionally a no-op.
|
||||
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.57.01 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.57.02 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.57.04 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.57.05 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.57.06 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.57.07 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.57.08 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.57.09 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.57.10 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.57.11 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.57.12 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.57.13 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.00 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.01 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.02 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.03 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.04 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.05 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.06 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.07 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.08 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.09 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.10 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.11 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.12 — no schema changes */
|
||||
@@ -0,0 +1 @@
|
||||
/* 02.58.13 — no schema changes */
|
||||
@@ -84,6 +84,35 @@ class AjaxController extends BaseController
|
||||
$this->sendJson($result);
|
||||
}
|
||||
|
||||
/**
|
||||
* Mark the pre-update backup as satisfied for this session.
|
||||
*
|
||||
* Called by the update-page modal after a successful on-demand backup so the
|
||||
* imminent server-side onExtensionBeforeUpdate backup is skipped — it sets
|
||||
* the same 10-minute throttle key the system plugin checks, preventing a
|
||||
* duplicate backup when the admin then clicks Joomla's Update button.
|
||||
* POST: task=ajax.preupdateAck
|
||||
*/
|
||||
public function preupdateAck(): void
|
||||
{
|
||||
if (!Session::checkToken('get') && !Session::checkToken('post')) {
|
||||
$this->sendJson(['error' => true, 'message' => 'Invalid token'], 403);
|
||||
|
||||
return;
|
||||
}
|
||||
|
||||
if (!$this->app->getIdentity()->authorise('mokosuitebackup.backup.run', 'com_mokosuitebackup')) {
|
||||
$this->sendJson(['error' => true, 'message' => 'Access denied'], 403);
|
||||
|
||||
return;
|
||||
}
|
||||
|
||||
// Same key + semantics as plg_system_mokosuitebackup::runPreActionBackup().
|
||||
Factory::getSession()->set('mokosuitebackup.preaction_backup_before_update', time());
|
||||
|
||||
$this->sendJson(['error' => false, 'message' => 'Pre-update backup acknowledged']);
|
||||
}
|
||||
|
||||
/**
|
||||
* Cancel a backup record stuck in "running" status.
|
||||
* POST: task=ajax.cancelBackup&id=123
|
||||
|
||||
@@ -16,8 +16,8 @@ use Joomla\CMS\Language\Text;
|
||||
use Joomla\CMS\MVC\Controller\AdminController;
|
||||
use Joomla\CMS\Router\Route;
|
||||
use Joomla\CMS\Session\Session;
|
||||
use Joomla\Component\MokoSuiteBackup\Administrator\Engine\BackupEngine;
|
||||
use Joomla\Component\MokoSuiteBackup\Administrator\Engine\RestoreEngine;
|
||||
use Joomla\Component\MokoSuiteBackup\Administrator\Service\BackupRunner;
|
||||
|
||||
class BackupsController extends AdminController
|
||||
{
|
||||
@@ -54,8 +54,7 @@ class BackupsController extends AdminController
|
||||
$profileId = $this->input->getInt('profile_id', 1);
|
||||
$description = $this->input->getString('description', '');
|
||||
|
||||
$engine = new BackupEngine();
|
||||
$result = $engine->run($profileId, $description, 'backend');
|
||||
$result = (new BackupRunner())->run($profileId, $description, 'backend');
|
||||
|
||||
// Surface preflight warnings as Joomla messages
|
||||
if (!empty($result['warnings'])) {
|
||||
|
||||
@@ -304,7 +304,18 @@ class BackupEngine
|
||||
$this->log(' Upload complete: ' . $result['message']);
|
||||
|
||||
if (!empty($restoreScriptPath) && is_file($restoreScriptPath)) {
|
||||
$uploader->upload($restoreScriptPath, basename($restoreScriptPath));
|
||||
$scriptName = basename($restoreScriptPath);
|
||||
$this->log(' Uploading restore script: ' . $scriptName . '...');
|
||||
$scriptResult = $uploader->upload($restoreScriptPath, $scriptName);
|
||||
|
||||
if (!empty($scriptResult['success'])) {
|
||||
$this->log(' Restore script uploaded: ' . ($scriptResult['message'] ?? $scriptName));
|
||||
} else {
|
||||
/* Never silent: a missing restore script makes the archive
|
||||
much harder to restore, so surface it as a warning. */
|
||||
$uploadFailed = true;
|
||||
$this->log(' WARNING: Restore script upload failed: ' . ($scriptResult['message'] ?? 'unknown error'));
|
||||
}
|
||||
}
|
||||
} else {
|
||||
$uploadFailed = true;
|
||||
@@ -500,24 +511,7 @@ class BackupEngine
|
||||
*/
|
||||
private function createUploaderFromParams(string $type, array $params): RemoteUploaderInterface
|
||||
{
|
||||
$prefixMap = ['ftp' => 'ftp_', 'sftp' => 'sftp_', 's3' => 's3_', 'google_drive' => 'gdrive_'];
|
||||
$prefix = $prefixMap[$type] ?? '';
|
||||
|
||||
$prefixed = [];
|
||||
|
||||
foreach ($params as $key => $value) {
|
||||
$prefixed[$prefix . $key] = $value;
|
||||
}
|
||||
|
||||
$fake = (object) $prefixed;
|
||||
|
||||
return match ($type) {
|
||||
'ftp' => new FtpUploader($fake),
|
||||
'sftp' => new SftpUploader($fake),
|
||||
'google_drive' => new GoogleDriveUploader($fake),
|
||||
's3' => new S3Uploader($fake),
|
||||
default => throw new \InvalidArgumentException('Unknown remote storage type: ' . $type),
|
||||
};
|
||||
return RemoteUploaderFactory::create($type, $params);
|
||||
}
|
||||
|
||||
/**
|
||||
|
||||
@@ -89,6 +89,52 @@ class FtpUploader implements RemoteUploaderInterface
|
||||
}
|
||||
}
|
||||
|
||||
public function delete(string $remoteName): array
|
||||
{
|
||||
if (!extension_loaded('ftp')) {
|
||||
return ['success' => false, 'message' => 'PHP ext-ftp is required for FTP deletes. Enable it in php.ini.'];
|
||||
}
|
||||
|
||||
if (empty($this->host)) {
|
||||
return ['success' => false, 'message' => 'FTP host is not configured'];
|
||||
}
|
||||
|
||||
$conn = $this->connect();
|
||||
|
||||
if (!$conn) {
|
||||
return ['success' => false, 'message' => 'Failed to connect to FTP server ' . $this->host . ':' . $this->port];
|
||||
}
|
||||
|
||||
try {
|
||||
if (!@ftp_login($conn, $this->username, $this->password)) {
|
||||
throw new \RuntimeException('FTP login failed for user: ' . $this->username);
|
||||
}
|
||||
|
||||
if ($this->passive) {
|
||||
ftp_pasv($conn, true);
|
||||
}
|
||||
|
||||
$remoteFile = $this->remotePath . '/' . $remoteName;
|
||||
|
||||
/* Already-absent files: ftp_delete returns false, but if the file
|
||||
isn't there the retention goal is already met, so probe size to
|
||||
decide. ftp_size returns -1 when the file does not exist. */
|
||||
if (@ftp_size($conn, $remoteFile) < 0) {
|
||||
return ['success' => true, 'message' => 'FTP: nothing to delete (' . $remoteFile . ')'];
|
||||
}
|
||||
|
||||
if (!@ftp_delete($conn, $remoteFile)) {
|
||||
throw new \RuntimeException('ftp_delete failed for: ' . $remoteFile);
|
||||
}
|
||||
|
||||
return ['success' => true, 'message' => 'Deleted from FTP: ' . $remoteFile];
|
||||
} catch (\Throwable $e) {
|
||||
return ['success' => false, 'message' => 'FTP delete failed: ' . $e->getMessage()];
|
||||
} finally {
|
||||
@ftp_close($conn);
|
||||
}
|
||||
}
|
||||
|
||||
public function testConnection(): array
|
||||
{
|
||||
if (empty($this->host)) {
|
||||
|
||||
@@ -81,6 +81,59 @@ class GoogleDriveUploader implements RemoteUploaderInterface
|
||||
}
|
||||
}
|
||||
|
||||
public function delete(string $remoteName): array
|
||||
{
|
||||
if (!extension_loaded('curl')) {
|
||||
return ['success' => false, 'message' => 'PHP ext-curl is required for Google Drive deletes. Enable it in php.ini.'];
|
||||
}
|
||||
|
||||
if (empty($this->clientId) || empty($this->refreshToken)) {
|
||||
return ['success' => false, 'message' => 'Google Drive credentials not configured'];
|
||||
}
|
||||
|
||||
try {
|
||||
$accessToken = $this->getAccessToken();
|
||||
|
||||
/* Drive has no path addressing — resolve the file id(s) by name
|
||||
within the configured folder, then delete each match. */
|
||||
$q = "name = '" . str_replace("'", "\\'", $remoteName) . "' and trashed = false";
|
||||
|
||||
if (!empty($this->folderId)) {
|
||||
$q .= " and '" . $this->folderId . "' in parents";
|
||||
}
|
||||
|
||||
$listUrl = self::API_URL . '/files?q=' . rawurlencode($q) . '&fields=' . rawurlencode('files(id,name)') . '&pageSize=25';
|
||||
$response = $this->curlRequest('GET', $listUrl, null, [
|
||||
'Authorization: Bearer ' . $accessToken,
|
||||
]);
|
||||
|
||||
if ($response['code'] !== 200) {
|
||||
throw new \RuntimeException('Drive file lookup failed (HTTP ' . $response['code'] . ')');
|
||||
}
|
||||
|
||||
$files = json_decode($response['body'], true)['files'] ?? [];
|
||||
|
||||
if (empty($files)) {
|
||||
return ['success' => true, 'message' => 'Google Drive: nothing to delete (' . $remoteName . ')'];
|
||||
}
|
||||
|
||||
foreach ($files as $file) {
|
||||
$del = $this->curlRequest('DELETE', self::API_URL . '/files/' . rawurlencode($file['id']), null, [
|
||||
'Authorization: Bearer ' . $accessToken,
|
||||
]);
|
||||
|
||||
/* 204 = deleted, 404 = already gone — both acceptable. */
|
||||
if ($del['code'] !== 204 && $del['code'] !== 200 && $del['code'] !== 404) {
|
||||
return ['success' => false, 'message' => 'Google Drive delete failed for ' . $remoteName . ' (HTTP ' . $del['code'] . ')'];
|
||||
}
|
||||
}
|
||||
|
||||
return ['success' => true, 'message' => 'Deleted from Google Drive: ' . $remoteName];
|
||||
} catch (\Throwable $e) {
|
||||
return ['success' => false, 'message' => 'Google Drive delete failed: ' . $e->getMessage()];
|
||||
}
|
||||
}
|
||||
|
||||
public function testConnection(): array
|
||||
{
|
||||
if (empty($this->clientId) || empty($this->refreshToken)) {
|
||||
|
||||
@@ -204,7 +204,8 @@ ORIG,
|
||||
'ok' => $backupCount > 0,
|
||||
'hint' => 'Place one or more backup ZIP files in the same directory as ' . basename($_SERVER['SCRIPT_NAME']),
|
||||
];
|
||||
REPL
|
||||
REPL,
|
||||
$php
|
||||
);
|
||||
|
||||
/* Modify remaining pre-checks to use getSelectedBackupFile() */
|
||||
|
||||
@@ -52,15 +52,25 @@ class PlaceholderResolver
|
||||
{
|
||||
$now = new \DateTimeImmutable('now');
|
||||
|
||||
/* Resolve hostname: prefer HTTP_HOST (web), then try Joomla config (CLI), then system hostname */
|
||||
$rawHost = $_SERVER['HTTP_HOST'] ?? $_SERVER['SERVER_NAME'] ?? '';
|
||||
/* Resolve hostname: prefer the real request host (web), then the
|
||||
configured live_site (CLI), then the system hostname. Joomla's console
|
||||
fills the request host with the placeholder 'joomla.invalid' (an
|
||||
RFC 6761 reserved TLD used as a CLI sentinel), so treat that — along
|
||||
with empty/localhost — as unusable and fall through; otherwise every
|
||||
CLI-triggered backup would be named 'joomla.invalid_…'. */
|
||||
$unusable = static function (string $h): bool {
|
||||
$h = strtolower(trim($h));
|
||||
|
||||
if (empty($rawHost) || $rawHost === 'localhost') {
|
||||
return $h === '' || $h === 'localhost' || $h === 'joomla.invalid';
|
||||
};
|
||||
|
||||
$rawHost = (string) ($_SERVER['HTTP_HOST'] ?? $_SERVER['SERVER_NAME'] ?? '');
|
||||
|
||||
if ($unusable($rawHost)) {
|
||||
try {
|
||||
$app = Factory::getApplication();
|
||||
$liveSite = $app->get('live_site', '');
|
||||
$liveSite = (string) Factory::getApplication()->get('live_site', '');
|
||||
|
||||
if (!empty($liveSite)) {
|
||||
if ($liveSite !== '') {
|
||||
$parsed = parse_url($liveSite, PHP_URL_HOST);
|
||||
|
||||
if (!empty($parsed)) {
|
||||
@@ -68,12 +78,13 @@ class PlaceholderResolver
|
||||
}
|
||||
}
|
||||
} catch (\Throwable $e) {
|
||||
/* fallback */
|
||||
/* fall through to system hostname */
|
||||
}
|
||||
}
|
||||
|
||||
if (empty($rawHost)) {
|
||||
$rawHost = php_uname('n');
|
||||
if ($unusable($rawHost)) {
|
||||
$sysHost = php_uname('n');
|
||||
$rawHost = $sysHost !== '' ? $sysHost : 'site';
|
||||
}
|
||||
|
||||
$hostname = preg_replace('/[^a-zA-Z0-9._-]/', '', $rawHost);
|
||||
|
||||
@@ -0,0 +1,69 @@
|
||||
<?php
|
||||
|
||||
/**
|
||||
* @package MokoSuiteBackup
|
||||
* @subpackage com_mokosuitebackup
|
||||
* @author Moko Consulting <hello@mokoconsulting.tech>
|
||||
* @copyright Copyright (C) 2026 Moko Consulting. All rights reserved.
|
||||
* @license GNU General Public License version 3 or later; see LICENSE
|
||||
*/
|
||||
|
||||
namespace Joomla\Component\MokoSuiteBackup\Administrator\Engine;
|
||||
|
||||
defined('_JEXEC') or die;
|
||||
|
||||
/**
|
||||
* Builds a remote uploader from a `#__mokosuitebackup_remotes` row.
|
||||
*
|
||||
* This was previously a private method duplicated in both BackupEngine and
|
||||
* SteppedBackupEngine (and needed a third time by RetentionManager for remote
|
||||
* deletion). It is centralised here so the type→class map and the param
|
||||
* key-prefixing convention live in exactly one place.
|
||||
*
|
||||
* The remotes table stores per-type settings as a flat JSON object with
|
||||
* un-prefixed keys (e.g. `{"host":"…","path":"/backups"}`). The concrete
|
||||
* uploaders, however, read prefixed keys off a profile-shaped object
|
||||
* (e.g. `sftp_host`, `s3_bucket`). This factory bridges the two.
|
||||
*/
|
||||
final class RemoteUploaderFactory
|
||||
{
|
||||
/**
|
||||
* Map of remote type → the key prefix its uploader expects.
|
||||
*/
|
||||
private const PREFIX_MAP = [
|
||||
'ftp' => 'ftp_',
|
||||
'sftp' => 'sftp_',
|
||||
's3' => 's3_',
|
||||
'google_drive' => 'gdrive_',
|
||||
];
|
||||
|
||||
/**
|
||||
* Create an uploader for the given remote type from decoded JSON params.
|
||||
*
|
||||
* @param string $type Remote type: ftp, sftp, s3, google_drive
|
||||
* @param array $params Key-value params decoded from the remote's JSON
|
||||
*
|
||||
* @return RemoteUploaderInterface
|
||||
*
|
||||
* @throws \InvalidArgumentException On an unknown remote type
|
||||
*/
|
||||
public static function create(string $type, array $params): RemoteUploaderInterface
|
||||
{
|
||||
$prefix = self::PREFIX_MAP[$type] ?? '';
|
||||
$prefixed = [];
|
||||
|
||||
foreach ($params as $key => $value) {
|
||||
$prefixed[$prefix . $key] = $value;
|
||||
}
|
||||
|
||||
$fake = (object) $prefixed;
|
||||
|
||||
return match ($type) {
|
||||
'ftp' => new FtpUploader($fake),
|
||||
'sftp' => new SftpUploader($fake),
|
||||
'google_drive' => new GoogleDriveUploader($fake),
|
||||
's3' => new S3Uploader($fake),
|
||||
default => throw new \InvalidArgumentException('Unknown remote storage type: ' . $type),
|
||||
};
|
||||
}
|
||||
}
|
||||
@@ -24,6 +24,21 @@ interface RemoteUploaderInterface
|
||||
*/
|
||||
public function upload(string $localPath, string $remoteName): array;
|
||||
|
||||
/**
|
||||
* Delete a previously-uploaded file from remote storage.
|
||||
*
|
||||
* Used by retention pruning so that expiring a local backup also removes
|
||||
* its archive from every remote destination. Implementations should treat
|
||||
* an already-absent remote file as success (idempotent delete), so a
|
||||
* partially-cleaned destination never blocks pruning.
|
||||
*
|
||||
* @param string $remoteName Filename on the remote end (the same
|
||||
* $remoteName that was passed to upload())
|
||||
*
|
||||
* @return array{success: bool, message: string}
|
||||
*/
|
||||
public function delete(string $remoteName): array;
|
||||
|
||||
/**
|
||||
* Test the connection / credentials without uploading.
|
||||
*
|
||||
|
||||
@@ -15,32 +15,54 @@ defined('_JEXEC') or die;
|
||||
use Joomla\Component\MokoSuiteBackup\Administrator\Utility\BackupDirectory;
|
||||
|
||||
/**
|
||||
* Enforces per-profile backup retention.
|
||||
* Enforces per-profile backup retention — the single retention authority.
|
||||
*
|
||||
* A profile may cap retained backups by age (retention_days) and/or by
|
||||
* number of copies (retention_count). A backup is pruned when EITHER rule
|
||||
* matches: it is older than retention_days OR it falls outside the newest
|
||||
* retention_count copies. Deleting a record also removes its archive and
|
||||
* log file, mirroring the Backup table's delete().
|
||||
* number of copies (retention_count). When a profile leaves a rule at 0 the
|
||||
* caller-supplied global default is used instead. A backup is pruned when
|
||||
* EITHER rule matches: it is older than the effective days OR it falls outside
|
||||
* the newest effective count of copies.
|
||||
*
|
||||
* Pruning a record removes, in this order:
|
||||
* 1. the DB row (#__mokosuitebackup_records),
|
||||
* 2. the local archive + its .log file, and
|
||||
* 3. the archive copy on every enabled remote destination for the profile.
|
||||
*
|
||||
* The standalone restore script (restore.php) is intentionally NOT deleted
|
||||
* from remotes: it is a single, fixed-name file that every backup overwrites,
|
||||
* so newer backups still depend on it — removing it while pruning an old
|
||||
* archive would break restore for the copies that remain.
|
||||
*
|
||||
* Because records do not store which destinations they were uploaded to,
|
||||
* remote deletion targets the profile's *currently enabled* remotes. Remote
|
||||
* deletes are idempotent (an already-absent file counts as success) and
|
||||
* best-effort: a failing remote is logged but never blocks local pruning.
|
||||
*/
|
||||
final class RetentionManager
|
||||
{
|
||||
/**
|
||||
* Prune old backups for a profile according to its retention settings.
|
||||
*
|
||||
* Called after a backup completes. Only 'complete' and 'warning' records
|
||||
* are considered — pending/running/failed records are never pruned here.
|
||||
* Called after a backup completes and from the periodic admin-side cleanup.
|
||||
* Only 'complete' and 'warning' records are considered — pending/running/
|
||||
* failed records are never pruned here.
|
||||
*
|
||||
* @param object $db Database driver
|
||||
* @param object $profile Profile row (needs id, retention_days, retention_count)
|
||||
* @param object $db Database driver
|
||||
* @param object $profile Profile row (needs id, retention_days, retention_count)
|
||||
* @param int $globalDays Fallback max age (days) when the profile's is 0
|
||||
* @param int $globalCount Fallback max copies when the profile's is 0
|
||||
*
|
||||
* @return int Number of backup records deleted
|
||||
*/
|
||||
public static function prune(object $db, object $profile): int
|
||||
public static function prune(object $db, object $profile, int $globalDays = 0, int $globalCount = 0): int
|
||||
{
|
||||
$days = (int) ($profile->retention_days ?? 0);
|
||||
$count = (int) ($profile->retention_count ?? 0);
|
||||
|
||||
// A profile value of 0 means "use the global default".
|
||||
$days = $days > 0 ? $days : $globalDays;
|
||||
$count = $count > 0 ? $count : $globalCount;
|
||||
|
||||
// No retention configured — nothing to do.
|
||||
if ($days <= 0 && $count <= 0) {
|
||||
return 0;
|
||||
@@ -48,7 +70,7 @@ final class RetentionManager
|
||||
|
||||
// Newest first, so the index is the copy's position from the top.
|
||||
$query = $db->getQuery(true)
|
||||
->select($db->quoteName(['id', 'absolute_path', 'backupstart']))
|
||||
->select($db->quoteName(['id', 'archivename', 'absolute_path', 'backupstart']))
|
||||
->from($db->quoteName('#__mokosuitebackup_records'))
|
||||
->where($db->quoteName('profile_id') . ' = ' . (int) $profile->id)
|
||||
->where($db->quoteName('status') . ' IN (' . implode(',', array_map([$db, 'quote'], ['complete', 'warning'])) . ')')
|
||||
@@ -61,6 +83,7 @@ final class RetentionManager
|
||||
}
|
||||
|
||||
$cutoffTs = $days > 0 ? (time() - ($days * 86400)) : null;
|
||||
$remotes = self::loadEnabledRemotes($db, (int) $profile->id);
|
||||
$deleted = 0;
|
||||
|
||||
foreach ($records as $index => $record) {
|
||||
@@ -72,7 +95,7 @@ final class RetentionManager
|
||||
continue;
|
||||
}
|
||||
|
||||
if (self::deleteRecord($db, $record)) {
|
||||
if (self::deleteRecord($db, $record, $remotes)) {
|
||||
$deleted++;
|
||||
}
|
||||
}
|
||||
@@ -81,12 +104,54 @@ final class RetentionManager
|
||||
}
|
||||
|
||||
/**
|
||||
* Delete a single backup record and its on-disk archive + log file.
|
||||
* Delete backup records whose profile no longer exists.
|
||||
*
|
||||
* The DB row is removed first; the files are only unlinked if that
|
||||
* succeeds, so a failed delete never orphans the record from its files.
|
||||
* Orphans have no owning profile and therefore no remote destinations to
|
||||
* reconcile, so only the local archive/log and DB row are removed.
|
||||
*
|
||||
* @param object $db Database driver
|
||||
*
|
||||
* @return int Number of orphaned records deleted
|
||||
*/
|
||||
private static function deleteRecord(object $db, object $record): bool
|
||||
public static function pruneOrphans(object $db): int
|
||||
{
|
||||
$query = $db->getQuery(true)
|
||||
->select($db->quoteName(['r.id', 'r.archivename', 'r.absolute_path'], ['id', 'archivename', 'absolute_path']))
|
||||
->from($db->quoteName('#__mokosuitebackup_records', 'r'))
|
||||
->join(
|
||||
'LEFT',
|
||||
$db->quoteName('#__mokosuitebackup_profiles', 'p')
|
||||
. ' ON ' . $db->quoteName('p.id') . ' = ' . $db->quoteName('r.profile_id')
|
||||
)
|
||||
->where($db->quoteName('p.id') . ' IS NULL')
|
||||
->where($db->quoteName('r.status') . ' IN (' . implode(',', array_map([$db, 'quote'], ['complete', 'warning'])) . ')');
|
||||
$db->setQuery($query);
|
||||
$orphans = $db->loadObjectList() ?: [];
|
||||
|
||||
$deleted = 0;
|
||||
|
||||
foreach ($orphans as $record) {
|
||||
if (self::deleteRecord($db, $record, [])) {
|
||||
$deleted++;
|
||||
}
|
||||
}
|
||||
|
||||
return $deleted;
|
||||
}
|
||||
|
||||
/**
|
||||
* Delete a single backup record, its on-disk archive + log file, and the
|
||||
* archive copy on each enabled remote destination.
|
||||
*
|
||||
* The DB row is removed first; the local files are only unlinked if that
|
||||
* succeeds, so a failed delete never orphans the record from its files.
|
||||
* Remote deletion is best-effort and runs regardless.
|
||||
*
|
||||
* @param object $db Database driver
|
||||
* @param object $record Record row (needs id, archivename, absolute_path)
|
||||
* @param object[] $remotes Enabled remote rows (type, params) for the profile
|
||||
*/
|
||||
private static function deleteRecord(object $db, object $record, array $remotes): bool
|
||||
{
|
||||
$query = $db->getQuery(true)
|
||||
->delete($db->quoteName('#__mokosuitebackup_records'))
|
||||
@@ -113,6 +178,69 @@ final class RetentionManager
|
||||
}
|
||||
}
|
||||
|
||||
self::deleteFromRemotes($record, $remotes);
|
||||
|
||||
return true;
|
||||
}
|
||||
|
||||
/**
|
||||
* Remove the record's archive from every enabled remote destination.
|
||||
*
|
||||
* Best-effort: each remote is tried independently and failures are logged,
|
||||
* never thrown, so one unreachable destination can't stall retention.
|
||||
*
|
||||
* @param object $record Record row (needs archivename)
|
||||
* @param object[] $remotes Enabled remote rows (type, params)
|
||||
*/
|
||||
private static function deleteFromRemotes(object $record, array $remotes): void
|
||||
{
|
||||
$archiveName = (string) ($record->archivename ?? '');
|
||||
|
||||
if ($archiveName === '' || empty($remotes)) {
|
||||
return;
|
||||
}
|
||||
|
||||
foreach ($remotes as $remote) {
|
||||
try {
|
||||
$params = json_decode((string) ($remote->params ?? ''), true) ?: [];
|
||||
$uploader = RemoteUploaderFactory::create((string) $remote->type, $params);
|
||||
$result = $uploader->delete($archiveName);
|
||||
|
||||
if (empty($result['success'])) {
|
||||
error_log(
|
||||
'MokoSuiteBackup: retention could not delete ' . $archiveName
|
||||
. ' from ' . $remote->type . ' remote: ' . ($result['message'] ?? 'unknown error')
|
||||
);
|
||||
}
|
||||
} catch (\Throwable $e) {
|
||||
error_log(
|
||||
'MokoSuiteBackup: retention remote-delete error for ' . $archiveName
|
||||
. ' (' . ($remote->type ?? '?') . '): ' . $e->getMessage()
|
||||
);
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Load the profile's enabled remote destinations (type + params only).
|
||||
*
|
||||
* Returns an empty array if the remotes table is missing (very old installs)
|
||||
* or the profile has none, so callers can iterate unconditionally.
|
||||
*/
|
||||
private static function loadEnabledRemotes(object $db, int $profileId): array
|
||||
{
|
||||
try {
|
||||
$query = $db->getQuery(true)
|
||||
->select($db->quoteName(['type', 'params']))
|
||||
->from($db->quoteName('#__mokosuitebackup_remotes'))
|
||||
->where($db->quoteName('profile_id') . ' = ' . $profileId)
|
||||
->where($db->quoteName('enabled') . ' = 1')
|
||||
->order($db->quoteName('ordering') . ' ASC');
|
||||
$db->setQuery($query);
|
||||
|
||||
return $db->loadObjectList() ?: [];
|
||||
} catch (\Throwable $e) {
|
||||
return [];
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
@@ -75,6 +75,54 @@ class S3Uploader implements RemoteUploaderInterface
|
||||
}
|
||||
}
|
||||
|
||||
public function delete(string $remoteName): array
|
||||
{
|
||||
if (!extension_loaded('curl')) {
|
||||
return ['success' => false, 'message' => 'PHP ext-curl is required for S3 deletes. Enable it in php.ini.'];
|
||||
}
|
||||
|
||||
if (empty($this->accessKey) || empty($this->secretKey) || empty($this->bucket)) {
|
||||
return ['success' => false, 'message' => 'S3 credentials or bucket not configured'];
|
||||
}
|
||||
|
||||
try {
|
||||
$objectKey = ($this->path ? $this->path . '/' : '') . $remoteName;
|
||||
$url = $this->getObjectUrl($objectKey);
|
||||
$headers = $this->signRequest('DELETE', $url, hash('sha256', ''));
|
||||
|
||||
$ch = curl_init();
|
||||
curl_setopt_array($ch, [
|
||||
CURLOPT_URL => $url,
|
||||
CURLOPT_CUSTOMREQUEST => 'DELETE',
|
||||
CURLOPT_RETURNTRANSFER => true,
|
||||
CURLOPT_HTTPHEADER => $headers,
|
||||
CURLOPT_TIMEOUT => 60,
|
||||
]);
|
||||
|
||||
$response = curl_exec($ch);
|
||||
$code = curl_getinfo($ch, CURLINFO_HTTP_CODE);
|
||||
|
||||
if (curl_errno($ch)) {
|
||||
$error = curl_error($ch);
|
||||
curl_close($ch);
|
||||
|
||||
throw new \RuntimeException('cURL error: ' . $error);
|
||||
}
|
||||
|
||||
curl_close($ch);
|
||||
|
||||
/* S3 DELETE returns 204 on success and — by design — also 204 when
|
||||
the key never existed. 404 is treated as already-gone too. */
|
||||
if ($code === 204 || $code === 200 || $code === 404) {
|
||||
return ['success' => true, 'message' => 'Deleted from S3: s3://' . $this->bucket . '/' . $objectKey];
|
||||
}
|
||||
|
||||
return ['success' => false, 'message' => 'S3 DELETE failed (HTTP ' . $code . '): ' . substr((string) $response, 0, 300)];
|
||||
} catch (\Throwable $e) {
|
||||
return ['success' => false, 'message' => 'S3 delete failed: ' . $e->getMessage()];
|
||||
}
|
||||
}
|
||||
|
||||
public function testConnection(): array
|
||||
{
|
||||
if (empty($this->accessKey) || empty($this->secretKey) || empty($this->bucket)) {
|
||||
|
||||
@@ -100,6 +100,40 @@ class SftpUploader implements RemoteUploaderInterface
|
||||
}
|
||||
}
|
||||
|
||||
public function delete(string $remoteName): array
|
||||
{
|
||||
if (empty($this->host) || empty($this->username)) {
|
||||
return ['success' => false, 'message' => 'SFTP is not configured'];
|
||||
}
|
||||
|
||||
$keyFile = null;
|
||||
|
||||
try {
|
||||
if (!empty($this->keyData)) {
|
||||
$keyFile = $this->writeTempKey();
|
||||
}
|
||||
|
||||
/* rm -f exits 0 even when the file is already gone, so an
|
||||
already-deleted remote archive is treated as success. */
|
||||
$remoteFile = $this->remotePath . '/' . $remoteName;
|
||||
$cmd = $this->buildSshCommand('rm -f ' . escapeshellarg($remoteFile), $keyFile);
|
||||
|
||||
$output = [];
|
||||
$exitCode = 0;
|
||||
exec($cmd . ' 2>&1', $output, $exitCode);
|
||||
|
||||
if ($exitCode !== 0) {
|
||||
return ['success' => false, 'message' => 'SFTP delete failed: ' . implode(' ', $output)];
|
||||
}
|
||||
|
||||
return ['success' => true, 'message' => 'Deleted from SFTP: ' . $remoteFile];
|
||||
} catch (\Throwable $e) {
|
||||
return ['success' => false, 'message' => 'SFTP delete failed: ' . $e->getMessage()];
|
||||
} finally {
|
||||
$this->cleanupTempKey($keyFile);
|
||||
}
|
||||
}
|
||||
|
||||
public function testConnection(): array
|
||||
{
|
||||
if (empty($this->host)) {
|
||||
|
||||
@@ -806,24 +806,7 @@ class SteppedBackupEngine
|
||||
*/
|
||||
private function createUploaderFromParams(string $type, array $params): RemoteUploaderInterface
|
||||
{
|
||||
$prefixMap = ['ftp' => 'ftp_', 'sftp' => 'sftp_', 's3' => 's3_', 'google_drive' => 'gdrive_'];
|
||||
$prefix = $prefixMap[$type] ?? '';
|
||||
|
||||
$prefixed = [];
|
||||
|
||||
foreach ($params as $key => $value) {
|
||||
$prefixed[$prefix . $key] = $value;
|
||||
}
|
||||
|
||||
$fake = (object) $prefixed;
|
||||
|
||||
return match ($type) {
|
||||
'ftp' => new FtpUploader($fake),
|
||||
'sftp' => new SftpUploader($fake),
|
||||
'google_drive' => new GoogleDriveUploader($fake),
|
||||
's3' => new S3Uploader($fake),
|
||||
default => throw new \InvalidArgumentException('Unknown remote storage type: ' . $type),
|
||||
};
|
||||
return RemoteUploaderFactory::create($type, $params);
|
||||
}
|
||||
|
||||
}
|
||||
|
||||
@@ -19,6 +19,9 @@ HTMLHelper::_('behavior.formvalidator');
|
||||
HTMLHelper::_('behavior.keepalive');
|
||||
HTMLHelper::_('bootstrap.modal');
|
||||
|
||||
/* Component CSS via the Web Asset Manager (declared in media/joomla.asset.json) */
|
||||
$this->getDocument()->getWebAssetManager()->useStyle('com_mokosuitebackup.admin');
|
||||
|
||||
$profileId = (int) $this->item->id;
|
||||
$token = Session::getFormToken();
|
||||
?>
|
||||
@@ -121,6 +124,7 @@ $token = Session::getFormToken();
|
||||
<div class="modal fade" id="remoteModal" tabindex="-1" aria-labelledby="remoteModalLabel" aria-hidden="true">
|
||||
<div class="modal-dialog modal-lg">
|
||||
<div class="modal-content">
|
||||
<div class="container-fluid">
|
||||
<div class="modal-header">
|
||||
<h5 class="modal-title" id="remoteModalLabel"><?php echo Text::_('COM_MOKOJOOMBACKUP_REMOTE_ADD'); ?></h5>
|
||||
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="<?php echo Text::_('JCLOSE'); ?>"></button>
|
||||
@@ -190,7 +194,9 @@ $token = Session::getFormToken();
|
||||
</div>
|
||||
<div class="mb-3" id="remoteSftpKeyWrap">
|
||||
<label for="remoteCfg_sftp_key_data" class="form-label"><?php echo Text::_('COM_MOKOJOOMBACKUP_FIELD_SFTP_KEY'); ?></label>
|
||||
<textarea class="form-control" id="remoteCfg_sftp_key_data" rows="4" placeholder="Paste SSH private key or leave as-is to keep existing"></textarea>
|
||||
<input type="file" class="form-control mb-2" id="remoteSftpKeyFile" accept=".pem,.key,.ppk,.openssh,.rsa,.ed25519,text/plain">
|
||||
<textarea class="form-control" id="remoteCfg_sftp_key_data" rows="4" placeholder="Upload a key file above, or paste the SSH private key here (leave as-is to keep existing)"></textarea>
|
||||
<div class="form-text" id="remoteSftpKeyFileMsg"></div>
|
||||
</div>
|
||||
<div class="mb-3" id="remoteSftpPassphraseWrap">
|
||||
<label for="remoteCfg_sftp_passphrase" class="form-label"><?php echo Text::_('COM_MOKOJOOMBACKUP_FIELD_SFTP_PASSPHRASE'); ?></label>
|
||||
@@ -257,6 +263,7 @@ $token = Session::getFormToken();
|
||||
<?php echo Text::_('JAPPLY'); ?>
|
||||
</button>
|
||||
</div>
|
||||
</div>
|
||||
</div>
|
||||
</div>
|
||||
</div>
|
||||
@@ -452,6 +459,29 @@ document.addEventListener('DOMContentLoaded', function() {
|
||||
}
|
||||
});
|
||||
|
||||
// ---- Upload SSH key file (fills the key textarea; no paste required) ----
|
||||
const keyFileInput = document.getElementById('remoteSftpKeyFile');
|
||||
if (keyFileInput) {
|
||||
keyFileInput.addEventListener('change', function() {
|
||||
const msg = document.getElementById('remoteSftpKeyFileMsg');
|
||||
const file = this.files && this.files[0];
|
||||
|
||||
if (!file) {
|
||||
return;
|
||||
}
|
||||
|
||||
const reader = new FileReader();
|
||||
reader.onload = function(ev) {
|
||||
document.getElementById('remoteCfg_sftp_key_data').value = ev.target.result;
|
||||
if (msg) { msg.textContent = 'Loaded "' + file.name + '".'; msg.className = 'form-text text-success'; }
|
||||
};
|
||||
reader.onerror = function() {
|
||||
if (msg) { msg.textContent = 'Could not read that file.'; msg.className = 'form-text text-danger'; }
|
||||
};
|
||||
reader.readAsText(file);
|
||||
});
|
||||
}
|
||||
|
||||
// ---- Add button ----
|
||||
document.getElementById('btnAddRemote').addEventListener('click', function() {
|
||||
openEdit(0);
|
||||
|
||||
@@ -8,7 +8,7 @@
|
||||
-->
|
||||
<extension type="module" client="administrator" method="upgrade">
|
||||
<name>Module - MokoSuiteBackup - cPanel</name>
|
||||
<version>02.57.00</version>
|
||||
<version>02.58.13</version>
|
||||
<creationDate>2026-06-23</creationDate>
|
||||
<author>Moko Consulting</author>
|
||||
<authorEmail>hello@mokoconsulting.tech</authorEmail>
|
||||
|
||||
@@ -7,7 +7,7 @@
|
||||
-->
|
||||
<extension type="plugin" group="actionlog" method="upgrade">
|
||||
<name>Action Log - MokoSuiteBackup</name>
|
||||
<version>02.57.00</version>
|
||||
<version>02.58.13</version>
|
||||
<creationDate>2026-06-04</creationDate>
|
||||
<author>Moko Consulting</author>
|
||||
<authorEmail>hello@mokoconsulting.tech</authorEmail>
|
||||
|
||||
@@ -7,7 +7,7 @@
|
||||
-->
|
||||
<extension type="plugin" group="console" method="upgrade">
|
||||
<name>Console - MokoSuiteBackup</name>
|
||||
<version>02.57.00</version>
|
||||
<version>02.58.13</version>
|
||||
<creationDate>2026-06-04</creationDate>
|
||||
<author>Moko Consulting</author>
|
||||
<authorEmail>hello@mokoconsulting.tech</authorEmail>
|
||||
|
||||
@@ -7,7 +7,7 @@
|
||||
-->
|
||||
<extension type="plugin" group="content" method="upgrade">
|
||||
<name>Content - MokoSuiteBackup</name>
|
||||
<version>02.57.00</version>
|
||||
<version>02.58.13</version>
|
||||
<creationDate>2026-06-04</creationDate>
|
||||
<author>Moko Consulting</author>
|
||||
<authorEmail>hello@mokoconsulting.tech</authorEmail>
|
||||
|
||||
@@ -1,7 +1,7 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<extension type="plugin" group="quickicon" method="upgrade">
|
||||
<name>Quick Icon - MokoSuiteBackup</name>
|
||||
<version>02.57.00</version>
|
||||
<version>02.58.13</version>
|
||||
<creationDate>2026-06-02</creationDate>
|
||||
<author>Moko Consulting</author>
|
||||
<authorEmail>hello@mokoconsulting.tech</authorEmail>
|
||||
|
||||
+7
@@ -7,3 +7,10 @@ PLG_SYSTEM_MOKOJOOMBACKUP_FIELD_MAX_AGE="Max Backup Age (days)"
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_FIELD_MAX_AGE_DESC="Delete backup records older than this many days."
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_FIELD_MAX_BACKUPS="Max Backup Count"
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_FIELD_MAX_BACKUPS_DESC="Keep at most this many completed backup records."
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_UPDATE_NOTICE="MokoSuiteBackup: a full-site backup is recommended before you update."
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_BACKUP_NOW="Back up now"
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_DISMISS="Dismiss"
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_BACKING_UP="Backing up…"
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_BACKUP_COMPLETE="Backup complete — safe to update."
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_BACKUP_FAILED="Backup failed"
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_BACKUP_STARTING="Starting backup…"
|
||||
|
||||
+7
@@ -7,3 +7,10 @@ PLG_SYSTEM_MOKOJOOMBACKUP_FIELD_MAX_AGE="Max Backup Age (days)"
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_FIELD_MAX_AGE_DESC="Delete backup records older than this many days."
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_FIELD_MAX_BACKUPS="Max Backup Count"
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_FIELD_MAX_BACKUPS_DESC="Keep at most this many completed backup records."
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_UPDATE_NOTICE="MokoSuiteBackup: a full-site backup is recommended before you update."
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_BACKUP_NOW="Back up now"
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_DISMISS="Dismiss"
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_BACKING_UP="Backing up…"
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_BACKUP_COMPLETE="Backup complete — safe to update."
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_BACKUP_FAILED="Backup failed"
|
||||
PLG_SYSTEM_MOKOJOOMBACKUP_BACKUP_STARTING="Starting backup…"
|
||||
|
||||
@@ -0,0 +1,261 @@
|
||||
/**
|
||||
* MokoSuiteBackup — pre-update backup notice + live-progress modal.
|
||||
*
|
||||
* Injected by plg_system_mokosuitebackup on the Joomla core-update
|
||||
* (com_joomlaupdate) and extensions-update (com_installer&view=update) pages.
|
||||
*
|
||||
* Why a client-side modal: the server-side onExtensionBeforeUpdate backup runs
|
||||
* synchronously mid-request and cannot drive a browser modal. This offers an
|
||||
* on-demand "Back up now" button that runs the same stepped backup the
|
||||
* dashboard uses (ajax.init then a loop of ajax.step) and shows live progress.
|
||||
* On success it pings ajax.preupdateAck so the imminent server-side pre-update
|
||||
* backup is skipped (no duplicate backup) when the admin clicks Update.
|
||||
*
|
||||
* Config comes from Joomla.getOptions('plg_system_mokosuitebackup.preupdate').
|
||||
*/
|
||||
(function () {
|
||||
'use strict';
|
||||
|
||||
var cfg = (window.Joomla && Joomla.getOptions)
|
||||
? Joomla.getOptions('plg_system_mokosuitebackup.preupdate', null)
|
||||
: null;
|
||||
|
||||
if (!cfg || !cfg.ajaxUrl || !cfg.token) {
|
||||
return;
|
||||
}
|
||||
|
||||
var L = cfg.labels || {};
|
||||
var running = false;
|
||||
var backedUp = false;
|
||||
|
||||
document.addEventListener('DOMContentLoaded', function () {
|
||||
injectNotice();
|
||||
});
|
||||
|
||||
if (cfg.autoIntercept) {
|
||||
setupInterception();
|
||||
}
|
||||
|
||||
/* ── Phase 2: auto-run on the Update click ──────────────────────────────
|
||||
* Wrap window.Joomla.submitbutton so clicking the toolbar Update button
|
||||
* first runs the backup modal, then continues the original update once the
|
||||
* backup succeeds. submitbutton is synchronous, so we can't pause it — we
|
||||
* swallow the update task, run the async backup, and re-issue the original
|
||||
* task ourselves on success. The notice's "Back up now" button remains a
|
||||
* fallback for any flow that doesn't route through submitbutton. */
|
||||
function setupInterception() {
|
||||
if (!wrapSubmit()) {
|
||||
document.addEventListener('DOMContentLoaded', wrapSubmit);
|
||||
}
|
||||
}
|
||||
|
||||
function wrapSubmit() {
|
||||
var J = window.Joomla;
|
||||
|
||||
if (!J || typeof J.submitbutton !== 'function' || J.submitbutton.__msbWrapped) {
|
||||
return !!(J && J.submitbutton && J.submitbutton.__msbWrapped);
|
||||
}
|
||||
|
||||
var original = J.submitbutton;
|
||||
|
||||
var wrapped = function (task) {
|
||||
if (!backedUp && !running && isUpdateTask(task)) {
|
||||
var args = arguments;
|
||||
runBackup().then(function (ok) {
|
||||
if (ok) {
|
||||
original.apply(window.Joomla, args);
|
||||
}
|
||||
});
|
||||
|
||||
return;
|
||||
}
|
||||
|
||||
return original.apply(window.Joomla, arguments);
|
||||
};
|
||||
|
||||
wrapped.__msbWrapped = true;
|
||||
J.submitbutton = wrapped;
|
||||
|
||||
return true;
|
||||
}
|
||||
|
||||
/* Only the actual "apply the update" tasks — never Find Updates / Clear
|
||||
* Cache (update.find / update.purge) which also start with "update". */
|
||||
function isUpdateTask(task) {
|
||||
return task === 'update.update' || task === 'update.install';
|
||||
}
|
||||
|
||||
function injectNotice() {
|
||||
var host = document.querySelector('main') || document.querySelector('#content') || document.body;
|
||||
|
||||
if (!host || document.getElementById('msb-preupdate-notice')) {
|
||||
return;
|
||||
}
|
||||
|
||||
var bar = document.createElement('div');
|
||||
bar.id = 'msb-preupdate-notice';
|
||||
bar.setAttribute('role', 'status');
|
||||
bar.style.cssText = 'display:flex;align-items:center;gap:1rem;flex-wrap:wrap;'
|
||||
+ 'margin:0 0 1rem 0;padding:.75rem 1rem;border:1px solid #f0c36d;'
|
||||
+ 'background:#fcf8e3;border-radius:.35rem;color:#8a6d3b;font-size:.95rem;';
|
||||
|
||||
var text = document.createElement('span');
|
||||
text.style.cssText = 'flex:1 1 auto;';
|
||||
text.textContent = L.notice || 'A full-site backup is recommended before you update.';
|
||||
|
||||
var btn = document.createElement('button');
|
||||
btn.type = 'button';
|
||||
btn.id = 'msb-preupdate-run';
|
||||
btn.className = 'btn btn-warning btn-sm';
|
||||
btn.textContent = L.backupNow || 'Back up now';
|
||||
btn.addEventListener('click', runBackup);
|
||||
|
||||
var dismiss = document.createElement('button');
|
||||
dismiss.type = 'button';
|
||||
dismiss.className = 'btn btn-link btn-sm';
|
||||
dismiss.style.cssText = 'color:#8a6d3b;';
|
||||
dismiss.textContent = L.dismiss || 'Dismiss';
|
||||
dismiss.addEventListener('click', function () { bar.remove(); });
|
||||
|
||||
bar.appendChild(text);
|
||||
bar.appendChild(btn);
|
||||
bar.appendChild(dismiss);
|
||||
host.insertBefore(bar, host.firstChild);
|
||||
}
|
||||
|
||||
/* ── The live-progress overlay (dependency-free, mirrors the dashboard) ── */
|
||||
|
||||
function buildOverlay() {
|
||||
var overlay = document.createElement('div');
|
||||
overlay.id = 'msb-preupdate-overlay';
|
||||
overlay.style.cssText = 'position:fixed;inset:0;z-index:10000;display:flex;'
|
||||
+ 'align-items:center;justify-content:center;background:rgba(0,0,0,.5);';
|
||||
|
||||
var box = document.createElement('div');
|
||||
box.style.cssText = 'width:min(480px,92vw);background:#fff;border-radius:.5rem;'
|
||||
+ 'padding:1.5rem;box-shadow:0 10px 40px rgba(0,0,0,.3);';
|
||||
|
||||
var title = document.createElement('h3');
|
||||
title.id = 'msb-pu-title';
|
||||
title.style.cssText = 'margin:0 0 1rem 0;font-size:1.15rem;';
|
||||
title.textContent = L.backingUp || 'Backing up…';
|
||||
|
||||
var track = document.createElement('div');
|
||||
track.style.cssText = 'height:1.25rem;background:#e9ecef;border-radius:.35rem;overflow:hidden;';
|
||||
|
||||
var barfill = document.createElement('div');
|
||||
barfill.id = 'msb-pu-bar';
|
||||
barfill.style.cssText = 'height:100%;width:0;background:#198754;transition:width .3s ease;';
|
||||
track.appendChild(barfill);
|
||||
|
||||
var status = document.createElement('div');
|
||||
status.id = 'msb-pu-status';
|
||||
status.style.cssText = 'margin-top:.75rem;font-size:.9rem;color:#555;';
|
||||
status.textContent = L.starting || 'Starting backup…';
|
||||
|
||||
box.appendChild(title);
|
||||
box.appendChild(track);
|
||||
box.appendChild(status);
|
||||
overlay.appendChild(box);
|
||||
document.body.appendChild(overlay);
|
||||
|
||||
return { overlay: overlay, title: title, bar: barfill, status: status };
|
||||
}
|
||||
|
||||
function setProgress(ui, progress, message) {
|
||||
var pct = Math.max(0, Math.min(100, parseInt(progress, 10) || 0));
|
||||
ui.bar.style.width = pct + '%';
|
||||
|
||||
if (message) {
|
||||
ui.status.textContent = message;
|
||||
}
|
||||
}
|
||||
|
||||
function post(params) {
|
||||
var body = new URLSearchParams();
|
||||
body.append(cfg.token, '1');
|
||||
|
||||
Object.keys(params).forEach(function (k) {
|
||||
body.append(k, params[k]);
|
||||
});
|
||||
|
||||
return fetch(cfg.ajaxUrl, {
|
||||
method: 'POST',
|
||||
body: body,
|
||||
headers: { 'X-Requested-With': 'XMLHttpRequest' }
|
||||
}).then(function (r) { return r.json(); });
|
||||
}
|
||||
|
||||
async function runBackup() {
|
||||
if (running) {
|
||||
return;
|
||||
}
|
||||
|
||||
running = true;
|
||||
|
||||
var runBtn = document.getElementById('msb-preupdate-run');
|
||||
|
||||
if (runBtn) {
|
||||
runBtn.disabled = true;
|
||||
}
|
||||
|
||||
var ui = buildOverlay();
|
||||
var guard = function (e) { e.preventDefault(); e.returnValue = ''; };
|
||||
window.addEventListener('beforeunload', guard);
|
||||
|
||||
try {
|
||||
var init = await post({ task: 'ajax.init', profile_id: cfg.profileId });
|
||||
|
||||
if (!init || init.error || !init.session_id) {
|
||||
throw new Error((init && init.message) || 'Could not start backup');
|
||||
}
|
||||
|
||||
setProgress(ui, init.progress, init.message);
|
||||
|
||||
var done = false;
|
||||
|
||||
while (!done) {
|
||||
var step = await post({ task: 'ajax.step', session_id: init.session_id });
|
||||
|
||||
if (!step || step.error) {
|
||||
throw new Error((step && step.message) || 'Backup step failed');
|
||||
}
|
||||
|
||||
setProgress(ui, step.progress, step.message);
|
||||
done = step.done || false;
|
||||
}
|
||||
|
||||
/* Tell the server the pre-update backup is satisfied so the
|
||||
synchronous onExtensionBeforeUpdate backup is skipped. */
|
||||
try { await post({ task: 'ajax.preupdateAck' }); } catch (ignore) {}
|
||||
|
||||
backedUp = true;
|
||||
ui.title.textContent = L.complete || 'Backup complete — safe to update.';
|
||||
setProgress(ui, 100, '');
|
||||
|
||||
var notice = document.getElementById('msb-preupdate-notice');
|
||||
|
||||
if (notice) {
|
||||
notice.style.background = '#d1e7dd';
|
||||
notice.style.borderColor = '#badbcc';
|
||||
notice.style.color = '#0f5132';
|
||||
}
|
||||
|
||||
setTimeout(function () { ui.overlay.remove(); }, 1500);
|
||||
|
||||
return true;
|
||||
} catch (err) {
|
||||
ui.title.textContent = (L.failed || 'Backup failed') + ': ' + err.message;
|
||||
ui.bar.style.background = '#dc3545';
|
||||
|
||||
if (runBtn) {
|
||||
runBtn.disabled = false;
|
||||
}
|
||||
|
||||
return false;
|
||||
} finally {
|
||||
running = false;
|
||||
window.removeEventListener('beforeunload', guard);
|
||||
}
|
||||
}
|
||||
})();
|
||||
@@ -7,7 +7,7 @@
|
||||
-->
|
||||
<extension type="plugin" group="system" method="upgrade">
|
||||
<name>System - MokoSuiteBackup</name>
|
||||
<version>02.57.00</version>
|
||||
<version>02.58.13</version>
|
||||
<creationDate>2026-06-02</creationDate>
|
||||
<author>Moko Consulting</author>
|
||||
<authorEmail>hello@mokoconsulting.tech</authorEmail>
|
||||
@@ -29,6 +29,10 @@
|
||||
<language tag="en-GB">language/en-GB/plg_system_mokosuitebackup.sys.ini</language>
|
||||
</languages>
|
||||
|
||||
<media destination="plg_system_mokosuitebackup" folder="media">
|
||||
<folder>js</folder>
|
||||
</media>
|
||||
|
||||
<config>
|
||||
<fields name="params">
|
||||
<fieldset name="basic">
|
||||
|
||||
@@ -13,8 +13,14 @@ namespace Joomla\Plugin\System\MokoSuiteBackup\Extension;
|
||||
defined('_JEXEC') or die;
|
||||
|
||||
use Joomla\CMS\Component\ComponentHelper;
|
||||
use Joomla\CMS\Document\HtmlDocument;
|
||||
use Joomla\CMS\Factory;
|
||||
use Joomla\CMS\Language\Text;
|
||||
use Joomla\CMS\Plugin\CMSPlugin;
|
||||
use Joomla\CMS\Router\Route;
|
||||
use Joomla\CMS\Session\Session;
|
||||
use Joomla\CMS\Uri\Uri;
|
||||
use Joomla\Component\MokoSuiteBackup\Administrator\Engine\RetentionManager;
|
||||
use Joomla\Component\MokoSuiteBackup\Administrator\Service\BackupRunner;
|
||||
use Joomla\Event\Event;
|
||||
use Joomla\Event\SubscriberInterface;
|
||||
@@ -28,6 +34,7 @@ final class MokoSuiteBackup extends CMSPlugin implements SubscriberInterface
|
||||
return [
|
||||
'onAfterInitialise' => 'onAfterInitialise',
|
||||
'onAfterRoute' => 'onAfterRoute',
|
||||
'onBeforeCompileHead' => 'onBeforeCompileHead',
|
||||
'onExtensionBeforeUpdate' => 'onExtensionBeforeUpdate',
|
||||
'onExtensionBeforeUninstall' => 'onExtensionBeforeUninstall',
|
||||
];
|
||||
@@ -138,6 +145,77 @@ final class MokoSuiteBackup extends CMSPlugin implements SubscriberInterface
|
||||
$this->cleanupOldSnapshots();
|
||||
}
|
||||
|
||||
/**
|
||||
* Inject the pre-update backup notice + live-progress modal on the admin
|
||||
* update pages (com_joomlaupdate and com_installer's update view).
|
||||
*
|
||||
* The server-side onExtensionBeforeUpdate backup runs synchronously and
|
||||
* cannot drive a browser modal, so this offers an on-demand "Back up now"
|
||||
* button that runs the same stepped backup as the dashboard and shows live
|
||||
* progress. On success the client pings ajax.preupdateAck, which arms the
|
||||
* same throttle key runPreActionBackup() checks — so the subsequent server
|
||||
* update does not run a duplicate backup.
|
||||
*/
|
||||
public function onBeforeCompileHead(Event $event): void
|
||||
{
|
||||
$app = $this->getApplication();
|
||||
|
||||
if (!$app->isClient('administrator')) {
|
||||
return;
|
||||
}
|
||||
|
||||
$input = $app->getInput();
|
||||
$option = $input->getCmd('option', '');
|
||||
$view = $input->getCmd('view', '');
|
||||
|
||||
$onUpdatePage = $option === 'com_joomlaupdate'
|
||||
|| ($option === 'com_installer' && $view === 'update');
|
||||
|
||||
if (!$onUpdatePage) {
|
||||
return;
|
||||
}
|
||||
|
||||
$params = ComponentHelper::getParams('com_mokosuitebackup');
|
||||
|
||||
// Respect the notice toggle and the pre-update backup feature flag.
|
||||
if (!(int) $params->get('show_update_notice', 1) || !(int) $params->get('backup_before_update', 0)) {
|
||||
return;
|
||||
}
|
||||
|
||||
// Already backed up this session (within the throttle window)? Stay quiet.
|
||||
$lastRun = (int) Factory::getSession()->get('mokosuitebackup.preaction_backup_before_update', 0);
|
||||
|
||||
if ($lastRun > 0 && (time() - $lastRun) < 600) {
|
||||
return;
|
||||
}
|
||||
|
||||
$doc = $app->getDocument();
|
||||
|
||||
if (!$doc instanceof HtmlDocument) {
|
||||
return;
|
||||
}
|
||||
|
||||
$doc->getWebAssetManager()->useScript('core');
|
||||
|
||||
$doc->addScriptOptions('plg_system_mokosuitebackup.preupdate', [
|
||||
'ajaxUrl' => Route::_('index.php?option=com_mokosuitebackup&format=json', false),
|
||||
'token' => Session::getFormToken(),
|
||||
'profileId' => (int) $params->get('default_profile', 1),
|
||||
'autoIntercept' => (bool) (int) $params->get('preupdate_auto_intercept', 0),
|
||||
'labels' => [
|
||||
'notice' => Text::_('PLG_SYSTEM_MOKOJOOMBACKUP_UPDATE_NOTICE'),
|
||||
'backupNow' => Text::_('PLG_SYSTEM_MOKOJOOMBACKUP_BACKUP_NOW'),
|
||||
'dismiss' => Text::_('PLG_SYSTEM_MOKOJOOMBACKUP_DISMISS'),
|
||||
'backingUp' => Text::_('PLG_SYSTEM_MOKOJOOMBACKUP_BACKING_UP'),
|
||||
'starting' => Text::_('PLG_SYSTEM_MOKOJOOMBACKUP_BACKUP_STARTING'),
|
||||
'complete' => Text::_('PLG_SYSTEM_MOKOJOOMBACKUP_BACKUP_COMPLETE'),
|
||||
'failed' => Text::_('PLG_SYSTEM_MOKOJOOMBACKUP_BACKUP_FAILED'),
|
||||
],
|
||||
]);
|
||||
|
||||
$doc->addScript(Uri::root(true) . '/media/plg_system_mokosuitebackup/js/update-backup.js', [], ['defer' => true]);
|
||||
}
|
||||
|
||||
/**
|
||||
* Remove backup records and files per profile retention settings.
|
||||
* Each profile can override the global max_age_days and max_backups.
|
||||
@@ -241,108 +319,28 @@ final class MokoSuiteBackup extends CMSPlugin implements SubscriberInterface
|
||||
|
||||
private function doCleanup(): void
|
||||
{
|
||||
$db = Factory::getDbo();
|
||||
$globalMaxAge = (int) ComponentHelper::getParams('com_mokosuitebackup')->get('max_age_days', 30);
|
||||
$globalMaxCount = (int) ComponentHelper::getParams('com_mokosuitebackup')->get('max_backups', 10);
|
||||
$db = Factory::getDbo();
|
||||
$params = ComponentHelper::getParams('com_mokosuitebackup');
|
||||
$globalMaxAge = (int) $params->get('max_age_days', 30);
|
||||
$globalMaxCount = (int) $params->get('max_backups', 10);
|
||||
|
||||
// Load all published profiles with their retention settings
|
||||
// Load all published profiles with their retention settings.
|
||||
$query = $db->getQuery(true)
|
||||
->select([$db->quoteName('id'), $db->quoteName('retention_days'), $db->quoteName('retention_count')])
|
||||
->select($db->quoteName(['id', 'retention_days', 'retention_count']))
|
||||
->from($db->quoteName('#__mokosuitebackup_profiles'))
|
||||
->where($db->quoteName('published') . ' = 1');
|
||||
$db->setQuery($query);
|
||||
$profiles = $db->loadObjectList();
|
||||
$profiles = $db->loadObjectList() ?: [];
|
||||
|
||||
// Delegate to the single retention authority. RetentionManager prunes by
|
||||
// age OR count (with these globals as the per-profile fallback) and also
|
||||
// removes each pruned archive from the profile's remote destinations.
|
||||
foreach ($profiles as $profile) {
|
||||
$maxAge = (int) $profile->retention_days > 0 ? (int) $profile->retention_days : $globalMaxAge;
|
||||
$maxCount = (int) $profile->retention_count > 0 ? (int) $profile->retention_count : $globalMaxCount;
|
||||
$pid = (int) $profile->id;
|
||||
|
||||
// Delete by age for this profile
|
||||
$cutoff = date('Y-m-d H:i:s', strtotime("-{$maxAge} days"));
|
||||
$query = $db->getQuery(true)
|
||||
->select('id, absolute_path')
|
||||
->from($db->quoteName('#__mokosuitebackup_records'))
|
||||
->where($db->quoteName('profile_id') . ' = ' . $pid)
|
||||
->where($db->quoteName('backupstart') . ' < ' . $db->quote($cutoff))
|
||||
->where($db->quoteName('status') . ' = ' . $db->quote('complete'));
|
||||
$db->setQuery($query);
|
||||
$expired = $db->loadObjectList();
|
||||
|
||||
foreach ($expired as $record) {
|
||||
$this->deleteBackupRecord($db, $record);
|
||||
}
|
||||
|
||||
// Enforce max count for this profile (keep newest)
|
||||
$query = $db->getQuery(true)
|
||||
->select('COUNT(*)')
|
||||
->from($db->quoteName('#__mokosuitebackup_records'))
|
||||
->where($db->quoteName('profile_id') . ' = ' . $pid)
|
||||
->where($db->quoteName('status') . ' = ' . $db->quote('complete'));
|
||||
$db->setQuery($query);
|
||||
$totalCount = (int) $db->loadResult();
|
||||
|
||||
if ($totalCount > $maxCount) {
|
||||
$excess = $totalCount - $maxCount;
|
||||
$query = $db->getQuery(true)
|
||||
->select('id, absolute_path')
|
||||
->from($db->quoteName('#__mokosuitebackup_records'))
|
||||
->where($db->quoteName('profile_id') . ' = ' . $pid)
|
||||
->where($db->quoteName('status') . ' = ' . $db->quote('complete'))
|
||||
->order($db->quoteName('backupstart') . ' ASC');
|
||||
$db->setQuery($query, 0, $excess);
|
||||
$oldest = $db->loadObjectList();
|
||||
|
||||
foreach ($oldest as $record) {
|
||||
$this->deleteBackupRecord($db, $record);
|
||||
}
|
||||
}
|
||||
RetentionManager::prune($db, $profile, $globalMaxAge, $globalMaxCount);
|
||||
}
|
||||
|
||||
// Also clean up orphaned records (profile deleted but records remain)
|
||||
$query = $db->getQuery(true)
|
||||
->select('r.id, r.absolute_path')
|
||||
->from($db->quoteName('#__mokosuitebackup_records', 'r'))
|
||||
->join('LEFT', $db->quoteName('#__mokosuitebackup_profiles', 'p') . ' ON p.id = r.profile_id')
|
||||
->where('p.id IS NULL')
|
||||
->where($db->quoteName('r.status') . ' = ' . $db->quote('complete'));
|
||||
$db->setQuery($query);
|
||||
$orphans = $db->loadObjectList();
|
||||
|
||||
foreach ($orphans as $record) {
|
||||
$this->deleteBackupRecord($db, $record);
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Delete a backup record and its archive file.
|
||||
*/
|
||||
private function deleteBackupRecord(object $db, object $record): void
|
||||
{
|
||||
if (!empty($record->absolute_path) && is_file($record->absolute_path)) {
|
||||
if (!@unlink($record->absolute_path)) {
|
||||
error_log('MokoSuiteBackup: Could not delete backup file (id=' . $record->id . '): ' . $record->absolute_path);
|
||||
|
||||
return;
|
||||
}
|
||||
|
||||
$logPath = preg_replace('/\.(zip|tar\.gz)$/i', '.log', $record->absolute_path);
|
||||
|
||||
if (is_file($logPath)) {
|
||||
@unlink($logPath);
|
||||
}
|
||||
}
|
||||
|
||||
try {
|
||||
$db->setQuery(
|
||||
$db->getQuery(true)
|
||||
->delete($db->quoteName('#__mokosuitebackup_records'))
|
||||
->where($db->quoteName('id') . ' = ' . (int) $record->id)
|
||||
);
|
||||
$db->execute();
|
||||
} catch (\Exception $e) {
|
||||
error_log('MokoSuiteBackup: Could not delete backup record ' . $record->id . ': ' . $e->getMessage());
|
||||
}
|
||||
// Records whose profile was deleted (local files + DB row only).
|
||||
RetentionManager::pruneOrphans($db);
|
||||
}
|
||||
|
||||
/**
|
||||
@@ -388,14 +386,40 @@ final class MokoSuiteBackup extends CMSPlugin implements SubscriberInterface
|
||||
|
||||
$profileId = (int) $params->get('default_profile', 1);
|
||||
|
||||
/* This backup runs synchronously inside the extension update/uninstall
|
||||
request. Without raising these limits a large site blows past
|
||||
max_execution_time / memory_limit mid-backup and the update page
|
||||
white-screens. Mirror the web-cron path. (Core Joomla updates are
|
||||
handled by the full-screen redirect instead — see onAfterRoute.) */
|
||||
@set_time_limit(0);
|
||||
@ini_set('max_execution_time', '0');
|
||||
@ini_set('memory_limit', '512M');
|
||||
@ignore_user_abort(true);
|
||||
|
||||
try {
|
||||
$result = (new BackupRunner())->run($profileId, $description, 'preaction');
|
||||
$app = Factory::getApplication();
|
||||
$status = $result['status'] ?? (!empty($result['success']) ? 'complete' : 'fail');
|
||||
|
||||
if (!$result['success']) {
|
||||
Factory::getApplication()->enqueueMessage(
|
||||
'MokoSuiteBackup: ' . $description . ' failed — ' . $result['message'],
|
||||
/* Always surface the outcome so the pre-update backup is visible in the
|
||||
admin — previously only failures produced a message, so a successful
|
||||
pre-update backup fired no notification at all. */
|
||||
if ($status === 'warning') {
|
||||
$app->enqueueMessage(
|
||||
'MokoSuiteBackup: ' . $description . ' completed with warnings — '
|
||||
. ($result['message'] ?: 'the local archive was created but a remote upload failed; see the backup log.'),
|
||||
'warning'
|
||||
);
|
||||
} elseif ($status === 'fail' || empty($result['success'])) {
|
||||
$app->enqueueMessage(
|
||||
'MokoSuiteBackup: ' . $description . ' failed — ' . ($result['message'] ?: 'unknown error'),
|
||||
'error'
|
||||
);
|
||||
} else {
|
||||
$app->enqueueMessage(
|
||||
'MokoSuiteBackup: ' . $description . ' completed successfully.',
|
||||
'message'
|
||||
);
|
||||
}
|
||||
} catch (\Throwable $e) {
|
||||
error_log('MokoSuiteBackup: ' . $description . ' failed: ' . $e->getMessage());
|
||||
|
||||
@@ -7,7 +7,7 @@
|
||||
-->
|
||||
<extension type="plugin" group="task" method="upgrade">
|
||||
<name>Task - MokoSuiteBackup</name>
|
||||
<version>02.57.00</version>
|
||||
<version>02.58.13</version>
|
||||
<creationDate>2026-06-02</creationDate>
|
||||
<author>Moko Consulting</author>
|
||||
<authorEmail>hello@mokoconsulting.tech</authorEmail>
|
||||
|
||||
@@ -7,7 +7,7 @@
|
||||
-->
|
||||
<extension type="plugin" group="webservices" method="upgrade">
|
||||
<name>Web Services - MokoSuiteBackup</name>
|
||||
<version>02.57.00</version>
|
||||
<version>02.58.13</version>
|
||||
<creationDate>2026-06-02</creationDate>
|
||||
<author>Moko Consulting</author>
|
||||
<authorEmail>hello@mokoconsulting.tech</authorEmail>
|
||||
|
||||
@@ -8,7 +8,7 @@
|
||||
<extension type="package" method="upgrade">
|
||||
<name>Package - MokoSuiteBackup</name>
|
||||
<packagename>mokosuitebackup</packagename>
|
||||
<version>02.57.00</version>
|
||||
<version>02.58.13</version>
|
||||
<creationDate>2026-06-02</creationDate>
|
||||
<author>Moko Consulting</author>
|
||||
<authorEmail>hello@mokoconsulting.tech</authorEmail>
|
||||
|
||||
+148
-17
@@ -77,6 +77,13 @@ class Pkg_MokoSuiteBackupInstallerScript
|
||||
$this->backupDownloadKey();
|
||||
}
|
||||
|
||||
/* Remove any orphaned mis-registered component BEFORE the component install
|
||||
recreates its admin menu. The orphan (element com_component-mokosuitebackup)
|
||||
owns a "Backup" menu with alias "backup"; if it survives, the real
|
||||
component's menu creation collides ("The alias backup is already being used")
|
||||
and the whole install aborts. */
|
||||
$this->removeOrphanedComponent();
|
||||
|
||||
return true;
|
||||
}
|
||||
|
||||
@@ -177,6 +184,10 @@ class Pkg_MokoSuiteBackupInstallerScript
|
||||
briefly used the "Type - Name" convention. Self-healing on every update. */
|
||||
$this->removeOrphanedComponent();
|
||||
|
||||
/* Drop legacy single-remote storage columns portably (replaces the old
|
||||
PREPARE/EXECUTE migration that MySQL 8 rejected in Joomla's installer). */
|
||||
$this->dropLegacyRemoteColumns();
|
||||
|
||||
/* Install completion notice (install and update) */
|
||||
$this->installSuccessful();
|
||||
|
||||
@@ -273,6 +284,54 @@ class Pkg_MokoSuiteBackupInstallerScript
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Drop the 26 legacy single-remote storage columns from the profiles table if
|
||||
* they are still present. Replaces sql/updates/mysql/02.56.01.sql, whose
|
||||
* PREPARE/EXECUTE/DEALLOCATE approach is rejected by Joomla's installer on
|
||||
* MySQL 8 (error 1295) and aborted the whole install. Done here in PHP: gate on
|
||||
* INFORMATION_SCHEMA, then issue a plain ALTER for only the columns that exist —
|
||||
* portable across MariaDB and MySQL 8. Idempotent and non-fatal.
|
||||
*
|
||||
* @return void
|
||||
*/
|
||||
private function dropLegacyRemoteColumns(): void
|
||||
{
|
||||
try {
|
||||
$db = Factory::getDbo();
|
||||
$table = $db->getPrefix() . 'mokosuitebackup_profiles';
|
||||
|
||||
$columns = [
|
||||
'remote_storage',
|
||||
'ftp_host', 'ftp_port', 'ftp_username', 'ftp_password', 'ftp_path', 'ftp_passive', 'ftp_ssl',
|
||||
'sftp_host', 'sftp_port', 'sftp_username', 'sftp_auth_type', 'sftp_password', 'sftp_key_data', 'sftp_passphrase', 'sftp_path',
|
||||
'gdrive_client_id', 'gdrive_client_secret', 'gdrive_refresh_token', 'gdrive_folder_id',
|
||||
's3_endpoint', 's3_region', 's3_access_key', 's3_secret_key', 's3_bucket', 's3_path',
|
||||
];
|
||||
|
||||
// Which legacy columns still exist on this install?
|
||||
$db->setQuery(
|
||||
$db->getQuery(true)
|
||||
->select($db->quoteName('COLUMN_NAME'))
|
||||
->from($db->quoteName('INFORMATION_SCHEMA.COLUMNS'))
|
||||
->where($db->quoteName('TABLE_SCHEMA') . ' = DATABASE()')
|
||||
->where($db->quoteName('TABLE_NAME') . ' = ' . $db->quote($table))
|
||||
->where($db->quoteName('COLUMN_NAME') . ' IN (' . implode(',', array_map([$db, 'quote'], $columns)) . ')')
|
||||
);
|
||||
$present = $db->loadColumn();
|
||||
|
||||
if (empty($present)) {
|
||||
return;
|
||||
}
|
||||
|
||||
$drops = array_map(fn($c) => 'DROP COLUMN ' . $db->quoteName($c), $present);
|
||||
$db->setQuery('ALTER TABLE ' . $db->quoteName($table) . ' ' . implode(', ', $drops));
|
||||
$db->execute();
|
||||
} catch (\Throwable $e) {
|
||||
/* Best-effort — a leftover column is harmless and must never abort the install */
|
||||
Log::add('MokoSuiteBackup legacy-remote-column drop failed: ' . $e->getMessage(), Log::WARNING, 'jerror');
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Recursively delete a directory (version-independent, no Folder dependency).
|
||||
*
|
||||
@@ -570,23 +629,7 @@ class Pkg_MokoSuiteBackupInstallerScript
|
||||
try {
|
||||
$db = Factory::getDbo();
|
||||
|
||||
/* Find the parent menu item for our component */
|
||||
$query = $db->getQuery(true)
|
||||
->select([$db->quoteName('id'), $db->quoteName('menutype')])
|
||||
->from($db->quoteName('#__menu'))
|
||||
->where($db->quoteName('client_id') . ' = 1')
|
||||
->where($db->quoteName('level') . ' = 1')
|
||||
->where($db->quoteName('link') . ' LIKE ' . $db->quote('index.php?option=com_mokosuitebackup%'))
|
||||
->setLimit(1);
|
||||
$db->setQuery($query);
|
||||
$parent = $db->loadObject();
|
||||
|
||||
if (!$parent) {
|
||||
error_log('MokoSuiteBackup: ensureSubmenuItems() — parent menu item not found');
|
||||
return;
|
||||
}
|
||||
|
||||
/* Get the component extension_id */
|
||||
/* Component extension_id first — needed to (re)create the parent menu. */
|
||||
$query = $db->getQuery(true)
|
||||
->select($db->quoteName('extension_id'))
|
||||
->from($db->quoteName('#__extensions'))
|
||||
@@ -601,6 +644,41 @@ class Pkg_MokoSuiteBackupInstallerScript
|
||||
return;
|
||||
}
|
||||
|
||||
/* Find the top-level "Backup" parent menu item for our component */
|
||||
$query = $db->getQuery(true)
|
||||
->select([$db->quoteName('id'), $db->quoteName('menutype')])
|
||||
->from($db->quoteName('#__menu'))
|
||||
->where($db->quoteName('client_id') . ' = 1')
|
||||
->where($db->quoteName('level') . ' = 1')
|
||||
->where($db->quoteName('link') . ' LIKE ' . $db->quote('index.php?option=com_mokosuitebackup%'))
|
||||
->setLimit(1);
|
||||
$db->setQuery($query);
|
||||
$parent = $db->loadObject();
|
||||
|
||||
/* Self-heal: if the top-level menu was deleted (e.g. by a failed install
|
||||
after the duplicate-component mess), recreate it — otherwise the whole
|
||||
Backup menu stays gone and dependents (cPanel module, MokoSuiteClient)
|
||||
can't locate the component. */
|
||||
if (!$parent) {
|
||||
$parent = $this->createTopMenu($componentId);
|
||||
|
||||
if (!$parent) {
|
||||
error_log('MokoSuiteBackup: ensureSubmenuItems() — parent menu missing and could not be created');
|
||||
return;
|
||||
}
|
||||
}
|
||||
|
||||
/* Keep the top-level menu label on the short constant and owned by the
|
||||
real component. */
|
||||
$db->setQuery(
|
||||
$db->getQuery(true)
|
||||
->update($db->quoteName('#__menu'))
|
||||
->set($db->quoteName('title') . ' = ' . $db->quote('COM_MOKOJOOMBACKUP_SHORT'))
|
||||
->set($db->quoteName('component_id') . ' = ' . (int) $componentId)
|
||||
->where($db->quoteName('id') . ' = ' . (int) $parent->id)
|
||||
);
|
||||
$db->execute();
|
||||
|
||||
foreach ($submenus as $submenu) {
|
||||
/* Check if this submenu item already exists */
|
||||
$query = $db->getQuery(true)
|
||||
@@ -666,6 +744,59 @@ class Pkg_MokoSuiteBackupInstallerScript
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Create the top-level "Backup" admin menu item for the component when it is
|
||||
* missing (deleted by a failed install / the duplicate-component fallout).
|
||||
* Label uses the short constant. Returns a lightweight {id, menutype} object,
|
||||
* or null on failure.
|
||||
*
|
||||
* @param int $componentId Extension id of com_mokosuitebackup
|
||||
*
|
||||
* @return object|null
|
||||
*/
|
||||
private function createTopMenu(int $componentId): ?object
|
||||
{
|
||||
try {
|
||||
$table = Factory::getApplication()
|
||||
->bootComponent('com_menus')
|
||||
->getMVCFactory()
|
||||
->createTable('Menu', 'Administrator');
|
||||
|
||||
$table->menutype = 'main';
|
||||
$table->title = 'COM_MOKOJOOMBACKUP_SHORT';
|
||||
$table->alias = 'backup';
|
||||
$table->link = 'index.php?option=com_mokosuitebackup';
|
||||
$table->type = 'component';
|
||||
$table->published = 1;
|
||||
$table->parent_id = 1;
|
||||
$table->level = 1;
|
||||
$table->component_id = $componentId;
|
||||
$table->client_id = 1;
|
||||
$table->img = 'class:archive';
|
||||
$table->params = '{}';
|
||||
$table->language = '*';
|
||||
$table->access = 1;
|
||||
|
||||
$table->setLocation(1, 'last-child');
|
||||
|
||||
if (!$table->check() || !$table->store()) {
|
||||
error_log('MokoSuiteBackup: createTopMenu() failed: ' . $table->getError());
|
||||
|
||||
return null;
|
||||
}
|
||||
|
||||
$obj = new \stdClass();
|
||||
$obj->id = (int) $table->id;
|
||||
$obj->menutype = 'main';
|
||||
|
||||
return $obj;
|
||||
} catch (\Throwable $e) {
|
||||
error_log('MokoSuiteBackup: createTopMenu() exception: ' . $e->getMessage());
|
||||
|
||||
return null;
|
||||
}
|
||||
}
|
||||
|
||||
private function fixPackageClientId(): void
|
||||
{
|
||||
try {
|
||||
|
||||
Reference in New Issue
Block a user