chore(version): auto-bump patch 01.12.02-dev [skip ci]

Authored-by: Moko Consulting

.mokogitea/workflows/issue-branch.yml

@@ -5,7 +5,7 @@
 # FILE INFORMATION
 # DEFGROUP: Gitea.Workflow
 # INGROUP: mokocli.Automation
-# VERSION: 01.00.00
+# VERSION: 01.12.02
 # BRIEF: Auto-create feature branch when an issue is opened
 
 name: "Universal: Issue Branch"

CHANGELOG.md

@@ -1,13 +1,9 @@
 # Changelog
 ## [Unreleased]
 
-## [01.11.00] --- 2026-06-28
+## [01.12.00] --- 2026-06-28
 
-## [01.11.00] --- 2026-06-28
-
-## [01.11.00] --- 2026-06-28
-
-## [01.11.00] --- 2026-06-28
+## [01.12.00] --- 2026-06-28
 
 ### Added
 - **Visual post calendar**: Monthly calendar grid view showing scheduled, queued, and posted cross-posts with status badges (#160)
@@ -16,8 +12,9 @@
 - **Analytics service filter**: Filter heatmap and stats by service type with configurable date range
 - **Analytics service breakdown**: Per-service success rate, failure count, and average posts per day
 - **Analytics AJAX endpoint**: JSON heatmap data for dynamic filtering without page reload
-- **Social image generator**: Generate Open Graph images with article title overlay using PHP GD library (#157)
-- **Social image config**: Background color, text color, overlay style, and site name override in component options (#157)
+- **Social image generator**: Generate branded 1200x630 OG images with article title overlay using PHP GD (#157)
+- **Social image config**: Background color, text color, font size, and site name branding options (#157)
+- **Generate Social Image button**: One-click image generation in the Share Content panel (#157)
 - **AI caption generation**: Generate platform-optimized cross-post captions from article content using Claude or OpenAI (#161)
 - **AI provider config**: New "AI Caption Generation" fieldset in component options with provider, API key, model, and tone settings
 - **AI Generate button**: One-click AI generation button in the Share Content panel that fills all caption fields
@@ -50,8 +47,9 @@
 - **PHPUnit test suite**: Unit tests for models, helpers, and service plugins (#132)
 
 ### Fixed
+- **Content plugin**: Remove Joomla 5 typed event hints -- Joomla 6 dispatches `Model\AfterSaveEvent` instead of `Content\AfterSaveEvent`, causing fatal TypeError on article save
 - **PreviewController**: Add ACL check and parameterized query to prevent unauthorized article access (IDOR)
-- Webservices plugin Joomla 6 compatibility — `onBeforeApiRoute` receives `BeforeApiRouteEvent` object, extract router via `$event->getRouter()`
+- Webservices plugin Joomla 6 compatibility -- `onBeforeApiRoute` receives `BeforeApiRouteEvent` object, extract router via `$event->getRouter()`
 
 ## [01.07.00] --- 2026-06-23
 
@@ -65,3 +63,39 @@
 ### Fixed
 - **License warning**: Removed duplicate from system plugin (install script already shows it)
 - **Content plugin**: Fixed func_get_arg crash when non-article content is saved (e.g. update sites, installer)
+
+## [01.05.00] --- 2026-06-23
+
+## [01.05.00] --- 2026-06-23
+
+### Added
+- **Instagram plugin**: Cross-post to Instagram via Meta Content Publishing API (2-step container flow)
+- **YouTube plugin**: Cross-post to YouTube via Data API v3 channel bulletins
+- **Share Content panel**: Per-article editor panel with platform-specific share text fields
+- **New placeholders**: {social}, {short}, {chat}, {email_subject}, {email_body} for platform-optimized templates
+- **Share image control**: Choose intro image, fulltext image, custom image, or no image per article
+- **Mailchimp templates**: Support Mailchimp saved templates with section injection, plus responsive email wrapper fallback
+- **Delete from platforms**: New MokoSuiteCrossDeleteInterface for removing cross-posted content from remote platforms
+- **Delete support**: Twitter, Mastodon, Bluesky, Facebook, LinkedIn, Telegram, Discord (7 of 38 plugins)
+- **Auto-delete on unpublish**: Component config option to delete from platforms when articles are unpublished or trashed
+- **UTM auto-tagging**: Append utm_source, utm_medium, utm_campaign to shared URLs with {platform} token support
+- **Caption rotation**: {random:opt1|opt2|opt3} placeholder picks a random option per post
+- **{url_raw} placeholder**: Clean article URL without UTM parameters
+- **Mastodon enhancements**: Visibility levels, content warnings, scheduled posts, polls, language tags
+- **Bluesky threads**: Auto-split long messages into reply chains at sentence boundaries
+- **Bluesky link cards**: External link card embeds with article title and description
+- **Ntfy default server**: Default server changed to ntfy.mokoconsulting.tech with configurable plugin params
+
+### Changed
+- **Default templates**: Updated to use platform-specific placeholders (social/short/chat/email) with graceful fallback
+
+### Fixed
+- **Mailchimp**: Fixed broken namespace placeholder in XML manifest
+- **ConvertKit**: Removed duplicate curl_setopt_array with undefined $token
+- **Brevo**: Removed duplicate curl_setopt_array with undefined $token and wrong auth header
+- **Constant Contact**: Removed duplicate curl_setopt_array
+- **Mailchimp**: Fixed campaign creation checking HTTP 200 instead of 2xx range
+- **Medium**: Fixed getUserId() returning array instead of string on error
+- **Bluesky**: Replaced md5() with hash('sha256', ...) for cache key
+- **ServiceController**: Exception details no longer exposed to client
+- **License warning**: Removed duplicate from system plugin -- install script already shows it with direct edit link

CODE_OF_CONDUCT.md

@@ -14,7 +14,7 @@
 	DEFGROUP: Template-Joomla
 	INGROUP: Template-Joomla.Documentation
 	REPO: https://github.com/mokoconsulting-tech/Template-Joomla/
-  VERSION: 01.11.00
+  VERSION: 01.12.02
   PATH: ./CODE_OF_CONDUCT.md
   BRIEF: Community expectations and enforcement guidelines
   NOTE: Adapted with attribution from the Contributor Covenant v2.1

GOVERNANCE.md

@@ -19,7 +19,7 @@
  DEFGROUP: mokoconsulting-tech.Template-Joomla
  INGROUP: MokoStandards.Governance
  REPO: https://github.com/mokoconsulting-tech/Template-Joomla
- VERSION: 01.11.00
+ VERSION: 01.12.02
  PATH: /GOVERNANCE.md
  BRIEF: Project governance rules, roles, and decision process for Template-Joomla
 -->

README.md

@@ -1,8 +1,8 @@
 # MokoSuiteCross
 
-<!-- VERSION: 01.11.00 -->
+<!-- VERSION: 01.12.02 -->
 
-Cross-posting Joomla content to social media, email marketing, and chat platforms for Joomla 5/6.
+Cross-posting Joomla content to social media, email marketing, and chat platforms for Joomla 6.
 
 ## Overview
 

SECURITY.md

@@ -23,7 +23,7 @@ DEFGROUP: Template-Joomla
 INGROUP: Template-Joomla.Documentation
 REPO: https://git.mokoconsulting.tech/MokoConsulting/Template-Joomla
 PATH: /SECURITY.md
-VERSION: 01.11.00
+VERSION: 01.12.02
 BRIEF: Security vulnerability reporting and handling policy
 -->
 

source/packages/com_mokosuitecross/config.xml

@@ -266,7 +266,7 @@
         </field>
     </fieldset>
 
-    <fieldset name="social_image" label="COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE">
+        <fieldset name="social_image" label="COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE">
         <field
             name="social_image_enabled"
             type="radio"

source/packages/com_mokosuitecross/language/en-GB/com_mokosuitecross.ini

@@ -570,7 +570,24 @@ COM_MOKOSUITECROSS_AI_GENERATE_DESC="Generate platform-optimized captions from t
 COM_MOKOSUITECROSS_AI_GENERATING="Generating captions..."
 COM_MOKOSUITECROSS_AI_GENERATED="AI captions generated successfully."
 COM_MOKOSUITECROSS_AI_ERROR="AI generation failed: %s"
-COM_MOKOSUITECROSS_AI_NOT_CONFIGURED="AI is not configured. Go to Options to set up a provider and API key."
+
+; Social Image Generator
+COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE="Social Image Generator"
+COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE_ENABLED="Enable Social Images"
+COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE_ENABLED_DESC="Generate branded OG images with article title overlay for social sharing."
+COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE_BG_COLOR="Background Color"
+COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE_BG_COLOR_DESC="Hex color for the image background (e.g. #1a1a2e)."
+COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE_TEXT_COLOR="Text Color"
+COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE_TEXT_COLOR_DESC="Hex color for the title text overlay."
+COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE_FONT_SIZE="Font Size"
+COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE_FONT_SIZE_DESC="Font size in pixels for the title text (24-96)."
+COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE_SHOW_SITE_NAME="Show Site Name"
+COM_MOKOSUITECROSS_CONFIG_SOCIAL_IMAGE_SHOW_SITE_NAME_DESC="Display the site name in the bottom-right corner of generated images."
+COM_MOKOSUITECROSS_SOCIAL_IMAGE_GENERATE="Generate Social Image"
+COM_MOKOSUITECROSS_SOCIAL_IMAGE_GENERATING="Generating image..."
+COM_MOKOSUITECROSS_SOCIAL_IMAGE_GENERATED="Social image generated."
+COM_MOKOSUITECROSS_SOCIAL_IMAGE_ERROR="Image generation failed: %s"
+COM_MOKOSUITECROSS_SOCIAL_IMAGE_NOT_CONFIGURED="Social image generator is not enabled. Go to Options to enable it."
 
 ; Analytics
 COM_MOKOSUITECROSS_SUBMENU_ANALYTICS="Analytics"
@@ -597,6 +614,14 @@ COM_MOKOSUITECROSS_ANALYTICS_LEGEND_NONE="No data"
 COM_MOKOSUITECROSS_PERIOD_180_DAYS="Last 180 days"
 COM_MOKOSUITECROSS_PERIOD_365_DAYS="Last 365 days"
 
+
+; Analytics
+COM_MOKOSUITECROSS_ANALYTICS="Analytics"
+COM_MOKOSUITECROSS_ANALYTICS_BEST_TIMES="Best Times to Post"
+COM_MOKOSUITECROSS_ANALYTICS_HEATMAP="Engagement Heatmap"
+COM_MOKOSUITECROSS_ANALYTICS_NO_DATA="Not enough data yet. Analytics will appear after posts collect engagement metrics."
+COM_MOKOSUITECROSS_ANALYTICS_ENGAGEMENT_RATE="Engagement Rate"
+COM_MOKOSUITECROSS_ANALYTICS_ALL_PLATFORMS="All Platforms"
 ; Category Rules
 COM_MOKOSUITECROSS_CONFIG_CATEGORY_RULES="Category Rules"
 COM_MOKOSUITECROSS_CONFIG_CATEGORY_RULES_NOTE="Category Routing"

source/packages/com_mokosuitecross/mokosuitecross.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="component" method="upgrade">
     <name>com_mokosuitecross</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/com_mokosuitecross/sql/install.mysql.sql

@@ -96,6 +96,27 @@ INSERT INTO `#__mokosuitecross_templates` (`service_type`, `title`, `template_bo
 ('instagram', 'Instagram Default', '{social}\n\n{hashtags}', 1, 21, NOW()),
 ('youtube', 'YouTube Default', '{social}\n\n{url}', 1, 22, NOW());
 
+
+CREATE TABLE IF NOT EXISTS `#__mokosuitecross_analytics` (
+    `id` int unsigned NOT NULL AUTO_INCREMENT,
+    `post_id` int unsigned NOT NULL,
+    `service_id` int unsigned NOT NULL,
+    `service_type` varchar(50) NOT NULL DEFAULT '',
+    `posted_at` datetime DEFAULT NULL,
+    `day_of_week` tinyint unsigned NOT NULL DEFAULT 0,
+    `hour_of_day` tinyint unsigned NOT NULL DEFAULT 0,
+    `impressions` int unsigned NOT NULL DEFAULT 0,
+    `engagements` int unsigned NOT NULL DEFAULT 0,
+    `clicks` int unsigned NOT NULL DEFAULT 0,
+    `shares` int unsigned NOT NULL DEFAULT 0,
+    `engagement_rate` decimal(5,2) NOT NULL DEFAULT 0.00,
+    `created` datetime NOT NULL,
+    PRIMARY KEY (`id`),
+    KEY `idx_service_type` (`service_type`),
+    KEY `idx_day_hour` (`day_of_week`, `hour_of_day`),
+    KEY `idx_post` (`post_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
 CREATE TABLE IF NOT EXISTS `#__mokosuitecross_category_rules` (
     `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
     `category_id` int(10) unsigned NOT NULL,

source/packages/com_mokosuitecross/sql/updates/mysql/01.08.54.sql

@@ -1 +1,23 @@
-/* 01.08.54 — no schema changes */
+-- MokoSuiteCross 01.08.54 -- Best time to post analytics
+-- Copyright (C) 2026 Moko Consulting. All rights reserved.
+-- SPDX-License-Identifier: GPL-3.0-or-later
+
+CREATE TABLE IF NOT EXISTS `#__mokosuitecross_analytics` (
+    `id` int unsigned NOT NULL AUTO_INCREMENT,
+    `post_id` int unsigned NOT NULL,
+    `service_id` int unsigned NOT NULL,
+    `service_type` varchar(50) NOT NULL DEFAULT '',
+    `posted_at` datetime DEFAULT NULL,
+    `day_of_week` tinyint unsigned NOT NULL DEFAULT 0,
+    `hour_of_day` tinyint unsigned NOT NULL DEFAULT 0,
+    `impressions` int unsigned NOT NULL DEFAULT 0,
+    `engagements` int unsigned NOT NULL DEFAULT 0,
+    `clicks` int unsigned NOT NULL DEFAULT 0,
+    `shares` int unsigned NOT NULL DEFAULT 0,
+    `engagement_rate` decimal(5,2) NOT NULL DEFAULT 0.00,
+    `created` datetime NOT NULL,
+    PRIMARY KEY (`id`),
+    KEY `idx_service_type` (`service_type`),
+    KEY `idx_day_hour` (`day_of_week`, `hour_of_day`),
+    KEY `idx_post` (`post_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

source/packages/com_mokosuitecross/sql/updates/mysql/01.11.01.sql

@@ -0,0 +1 @@
+/* 01.11.01 — no schema changes */

source/packages/com_mokosuitecross/sql/updates/mysql/01.11.02.sql

@@ -0,0 +1 @@
+/* 01.11.02 — no schema changes */

source/packages/com_mokosuitecross/sql/updates/mysql/01.11.03.sql

@@ -0,0 +1 @@
+/* 01.11.03 — no schema changes */

source/packages/com_mokosuitecross/sql/updates/mysql/01.12.00.sql

@@ -0,0 +1 @@
+/* 01.12.00 — no schema changes */

source/packages/com_mokosuitecross/sql/updates/mysql/01.12.01.sql

@@ -0,0 +1 @@
+/* 01.12.01 — no schema changes */

source/packages/com_mokosuitecross/sql/updates/mysql/01.12.02.sql

@@ -0,0 +1 @@
+/* 01.12.02 — no schema changes */

source/packages/com_mokosuitecross/src/Controller/AnalyticsController.php

@@ -14,11 +14,84 @@ namespace Joomla\Component\MokoSuiteCross\Administrator\Controller;
 defined('_JEXEC') or die;
 
 use Joomla\CMS\MVC\Controller\BaseController;
+use Joomla\CMS\Session\Session;
+use Joomla\Component\MokoSuiteCross\Administrator\Helper\AnalyticsHelper;
 
 class AnalyticsController extends BaseController
 {
-    public function display($cachable = false, $urlparams = []): static
+    /**
+     * Return heatmap grid data as JSON.
+     *
+     * Query params: service_type (string), days (int, default 90)
+     */
+    public function heatmap(): void
     {
-        return parent::display($cachable, $urlparams);
+        if (!Session::checkToken('get')) {
+            echo json_encode(['success' => false, 'error' => 'Invalid token']);
+            $this->app->close();
+
+            return;
+        }
+
+        $user = $this->app->getIdentity();
+
+        if (!$user->authorise('core.manage', 'com_mokosuitecross')) {
+            echo json_encode(['success' => false, 'error' => 'Permission denied']);
+            $this->app->close();
+
+            return;
+        }
+
+        $serviceType = $this->input->getCmd('service_type', '');
+        $days        = $this->input->getInt('days', 90);
+
+        $grid      = AnalyticsHelper::getHeatmapData($serviceType, $days);
+        $bestTimes = AnalyticsHelper::getBestTimes($serviceType, 3);
+
+        $this->app->setHeader('Content-Type', 'application/json; charset=utf-8');
+        echo json_encode([
+            'success'    => true,
+            'grid'       => $grid,
+            'best_times' => $bestTimes,
+        ]);
+        $this->app->close();
+    }
+
+    /**
+     * Return the top posting times as JSON.
+     *
+     * Query params: service_type (string), limit (int, default 5)
+     */
+    public function besttimes(): void
+    {
+        if (!Session::checkToken('get')) {
+            echo json_encode(['success' => false, 'error' => 'Invalid token']);
+            $this->app->close();
+
+            return;
+        }
+
+        $user = $this->app->getIdentity();
+
+        if (!$user->authorise('core.manage', 'com_mokosuitecross')) {
+            echo json_encode(['success' => false, 'error' => 'Permission denied']);
+            $this->app->close();
+
+            return;
+        }
+
+        $serviceType = $this->input->getCmd('service_type', '');
+        $limit       = $this->input->getInt('limit', 5);
+
+        $bestTimes        = AnalyticsHelper::getBestTimes($serviceType, $limit);
+        $serviceBreakdown = AnalyticsHelper::getServiceBreakdown();
+
+        $this->app->setHeader('Content-Type', 'application/json; charset=utf-8');
+        echo json_encode([
+            'success'           => true,
+            'best_times'        => $bestTimes,
+            'service_breakdown' => $serviceBreakdown,
+        ]);
+        $this->app->close();
     }
 }

source/packages/com_mokosuitecross/src/Controller/SocialImageController.php

@@ -17,7 +17,6 @@ use Joomla\CMS\Component\ComponentHelper;
 use Joomla\CMS\Factory;
 use Joomla\CMS\MVC\Controller\BaseController;
 use Joomla\CMS\Session\Session;
-use Joomla\CMS\Uri\Uri;
 use Joomla\Component\MokoSuiteCross\Administrator\Helper\SocialImageHelper;
 
 class SocialImageController extends BaseController
@@ -33,7 +32,7 @@ class SocialImageController extends BaseController
 
         $user = $this->app->getIdentity();
 
-        if (!$user->authorise('core.manage', 'com_mokosuitecross')) {
+        if (!$user->authorise('core.edit', 'com_mokosuitecross')) {
             echo json_encode(['success' => false, 'error' => 'Permission denied']);
             $this->app->close();
 
@@ -49,47 +48,40 @@ class SocialImageController extends BaseController
             return;
         }
 
+        $params = ComponentHelper::getParams('com_mokosuitecross');
+
+        if (!(int) $params->get('social_image_enabled', 0)) {
+            echo json_encode(['success' => false, 'error' => 'Social image generator is not enabled']);
+            $this->app->close();
+
+            return;
+        }
+
         $db    = Factory::getDbo();
         $query = $db->getQuery(true)
-            ->select($db->quoteName(['id', 'title', 'images']))
+            ->select($db->quoteName('title'))
             ->from($db->quoteName('#__content'))
             ->where($db->quoteName('id') . ' = ' . $articleId);
         $db->setQuery($query);
-        $article = $db->loadObject();
+        $title = $db->loadResult();
 
-        if (!$article) {
+        if (!$title) {
             echo json_encode(['success' => false, 'error' => 'Article not found']);
             $this->app->close();
 
             return;
         }
 
-        $params   = ComponentHelper::getParams('com_mokosuitecross');
-        $siteName = $params->get('social_image_site_name', '') ?: Factory::getApplication()->get('sitename', '');
+        $siteName = $this->app->get('sitename', '');
 
-        $options = [
-            'bg_color'  => $params->get('social_image_bg_color', '#1a1a2e'),
-            'text_color' => $params->get('social_image_text_color', '#ffffff'),
-            'overlay'   => $params->get('social_image_overlay', 'dark'),
+        $config = [
+            'bg_color'       => $params->get('social_image_bg_color', '#1a1a2e'),
+            'text_color'     => $params->get('social_image_text_color', '#ffffff'),
+            'font_size'      => $params->get('social_image_font_size', 48),
+            'show_site_name' => (bool) $params->get('social_image_show_site_name', 1),
         ];
 
-        $backgroundPath = null;
-        $images = json_decode($article->images ?? '{}', true);
-
-        if (!empty($images['image_intro'])) {
-            $backgroundPath = JPATH_ROOT . '/' . ltrim($images['image_intro'], '/');
-        } elseif (!empty($images['image_fulltext'])) {
-            $backgroundPath = JPATH_ROOT . '/' . ltrim($images['image_fulltext'], '/');
-        }
-
-        try {
-            $imagePath = SocialImageHelper::generate($article->title, $siteName, $backgroundPath, $options);
-            $imageUrl  = str_replace(JPATH_ROOT, Uri::root(true), str_replace('\\', '/', $imagePath));
-
-            $result = ['success' => true, 'image_url' => $imageUrl, 'image_path' => $imagePath];
-        } catch (\Throwable $e) {
-            $result = ['success' => false, 'error' => $e->getMessage()];
-        }
+        $result = SocialImageHelper::generate($title, $siteName, $config);
 
         $this->app->setHeader('Content-Type', 'application/json; charset=utf-8');
         echo json_encode($result);

source/packages/com_mokosuitecross/src/Helper/AnalyticsHelper.php

@@ -17,144 +17,236 @@ use Joomla\CMS\Factory;
 
 class AnalyticsHelper
 {
-    private static array $dayNames = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'];
+    /**
+     * Record or update engagement metrics for a post.
+     *
+     * @param   int     $postId       The post ID
+     * @param   int     $serviceId    The service ID
+     * @param   string  $serviceType  The service type (e.g. twitter, facebook)
+     * @param   array   $metrics      Engagement metrics: impressions, engagements, clicks, shares, posted_at
+     *
+     * @return  bool  True on success
+     */
+    public static function recordEngagement(int $postId, int $serviceId, string $serviceType, array $metrics): bool
+    {
+        $db = Factory::getDbo();
 
-    public static function getPostingHeatmap(string $serviceType = '', int $days = 90): array
+        $postedAt = $metrics['posted_at'] ?? null;
+
+        if ($postedAt) {
+            $timestamp  = strtotime($postedAt);
+            $dayOfWeek  = (int) date('w', $timestamp);
+            $hourOfDay  = (int) date('G', $timestamp);
+        } else {
+            $dayOfWeek  = 0;
+            $hourOfDay  = 0;
+        }
+
+        $impressions = (int) ($metrics['impressions'] ?? 0);
+        $engagements = (int) ($metrics['engagements'] ?? 0);
+        $clicks      = (int) ($metrics['clicks'] ?? 0);
+        $shares      = (int) ($metrics['shares'] ?? 0);
+
+        $engagementRate = $impressions > 0
+            ? round(($engagements / $impressions) * 100, 2)
+            : 0.00;
+
+        // Check if a row already exists for this post
+        $query = $db->getQuery(true)
+            ->select($db->quoteName('id'))
+            ->from($db->quoteName('#__mokosuitecross_analytics'))
+            ->where($db->quoteName('post_id') . ' = ' . $postId)
+            ->where($db->quoteName('service_id') . ' = ' . $serviceId);
+        $db->setQuery($query);
+        $existingId = $db->loadResult();
+
+        if ($existingId) {
+            $query = $db->getQuery(true)
+                ->update($db->quoteName('#__mokosuitecross_analytics'))
+                ->set($db->quoteName('impressions') . ' = ' . $impressions)
+                ->set($db->quoteName('engagements') . ' = ' . $engagements)
+                ->set($db->quoteName('clicks') . ' = ' . $clicks)
+                ->set($db->quoteName('shares') . ' = ' . $shares)
+                ->set($db->quoteName('engagement_rate') . ' = ' . $engagementRate)
+                ->where($db->quoteName('id') . ' = ' . (int) $existingId);
+            $db->setQuery($query);
+            $db->execute();
+
+            return true;
+        }
+
+        $record = (object) [
+            'post_id'         => $postId,
+            'service_id'      => $serviceId,
+            'service_type'    => $serviceType,
+            'posted_at'       => $postedAt,
+            'day_of_week'     => $dayOfWeek,
+            'hour_of_day'     => $hourOfDay,
+            'impressions'     => $impressions,
+            'engagements'     => $engagements,
+            'clicks'          => $clicks,
+            'shares'          => $shares,
+            'engagement_rate' => $engagementRate,
+            'created'         => Factory::getDate()->toSql(),
+        ];
+
+        $db->insertObject('#__mokosuitecross_analytics', $record);
+
+        return true;
+    }
+
+    /**
+     * Get heatmap data as a 7x24 grid of average engagement rates.
+     *
+     * @param   string  $serviceType  Optional service type filter
+     * @param   int     $days         Number of days to look back (0 = all time)
+     *
+     * @return  array  7x24 grid: [ day_of_week => [ hour_of_day => avg_engagement_rate ] ]
+     */
+    public static function getHeatmapData(string $serviceType = '', int $days = 90): array
     {
         $db = Factory::getDbo();
 
         $query = $db->getQuery(true)
-            ->select('DAYOFWEEK(' . $db->quoteName('p.posted_at') . ') - 1 AS dow')
-            ->select('HOUR(' . $db->quoteName('p.posted_at') . ') AS hr')
-            ->select('COUNT(*) AS cnt')
-            ->from($db->quoteName('#__mokosuitecross_posts', 'p'))
-            ->where($db->quoteName('p.status') . ' = ' . $db->quote('posted'))
-            ->where($db->quoteName('p.posted_at') . ' IS NOT NULL');
-
-        if ($days > 0) {
-            $since = Factory::getDate('now - ' . $days . ' days')->toSql();
-            $query->where($db->quoteName('p.posted_at') . ' >= ' . $db->quote($since));
-        }
+            ->select([
+                $db->quoteName('day_of_week'),
+                $db->quoteName('hour_of_day'),
+                'AVG(' . $db->quoteName('engagement_rate') . ') AS avg_rate',
+                'COUNT(*) AS post_count',
+            ])
+            ->from($db->quoteName('#__mokosuitecross_analytics'))
+            ->group($db->quoteName('day_of_week'))
+            ->group($db->quoteName('hour_of_day'))
+            ->order($db->quoteName('day_of_week') . ' ASC')
+            ->order($db->quoteName('hour_of_day') . ' ASC');
 
         if ($serviceType !== '') {
-            $query->join('INNER', $db->quoteName('#__mokosuitecross_services', 's') . ' ON ' . $db->quoteName('s.id') . ' = ' . $db->quoteName('p.service_id'))
-                ->where($db->quoteName('s.service_type') . ' = ' . $db->quote($serviceType));
+            $query->where($db->quoteName('service_type') . ' = ' . $db->quote($serviceType));
         }
 
-        $query->group('dow, hr')
-            ->order('dow ASC, hr ASC');
+        if ($days > 0) {
+            $cutoff = Factory::getDate('-' . $days . ' days')->toSql();
+            $query->where($db->quoteName('posted_at') . ' >= ' . $db->quote($cutoff));
+        }
 
         $db->setQuery($query);
         $rows = $db->loadObjectList();
 
+        // Build 7x24 grid initialised to zero
         $grid = [];
 
         for ($d = 0; $d < 7; $d++) {
-            $grid[$d] = array_fill(0, 24, 0);
+            for ($h = 0; $h < 24; $h++) {
+                $grid[$d][$h] = ['avg_rate' => 0.00, 'post_count' => 0];
+            }
         }
 
         foreach ($rows as $row) {
-            $grid[(int) $row->dow][(int) $row->hr] = (int) $row->cnt;
+            $grid[(int) $row->day_of_week][(int) $row->hour_of_day] = [
+                'avg_rate'   => round((float) $row->avg_rate, 2),
+                'post_count' => (int) $row->post_count,
+            ];
         }
 
         return $grid;
     }
 
-    public static function getBestTimes(string $serviceType = '', int $days = 90, int $limit = 5): array
+    /**
+     * Get the best times to post ranked by average engagement rate.
+     *
+     * @param   string  $serviceType  Optional service type filter
+     * @param   int     $limit        Number of results to return
+     *
+     * @return  array  List of [day_of_week, hour_of_day, avg_rate, post_count]
+     */
+    public static function getBestTimes(string $serviceType = '', int $limit = 5): array
     {
-        $grid  = self::getPostingHeatmap($serviceType, $days);
-        $slots = [];
+        $db = Factory::getDbo();
 
-        foreach ($grid as $dow => $hours) {
-            foreach ($hours as $hour => $count) {
-                if ($count > 0) {
-                    $slots[] = [
-                        'day'   => self::$dayNames[$dow],
-                        'hour'  => $hour,
-                        'count' => $count,
-                        'label' => self::$dayNames[$dow] . ' ' . self::formatHour($hour),
-                    ];
-                }
-            }
+        $query = $db->getQuery(true)
+            ->select([
+                $db->quoteName('day_of_week'),
+                $db->quoteName('hour_of_day'),
+                'AVG(' . $db->quoteName('engagement_rate') . ') AS avg_rate',
+                'COUNT(*) AS post_count',
+            ])
+            ->from($db->quoteName('#__mokosuitecross_analytics'))
+            ->group($db->quoteName('day_of_week'))
+            ->group($db->quoteName('hour_of_day'))
+            ->having('COUNT(*) >= 1')
+            ->order('avg_rate DESC');
+
+        if ($serviceType !== '') {
+            $query->where($db->quoteName('service_type') . ' = ' . $db->quote($serviceType));
         }
 
-        usort($slots, static fn($a, $b) => $b['count'] <=> $a['count']);
+        $db->setQuery($query, 0, $limit);
+        $rows = $db->loadAssocList();
 
-        return \array_slice($slots, 0, $limit);
+        $dayNames = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'];
+
+        $results = [];
+
+        foreach ($rows as $row) {
+            $hour     = (int) $row['hour_of_day'];
+            $ampm     = $hour < 12 ? 'AM' : 'PM';
+            $hour12   = $hour % 12 ?: 12;
+
+            $results[] = [
+                'day_of_week' => (int) $row['day_of_week'],
+                'day_name'    => $dayNames[(int) $row['day_of_week']],
+                'hour_of_day' => $hour,
+                'hour_label'  => $hour12 . ':00 ' . $ampm,
+                'avg_rate'    => round((float) $row['avg_rate'], 2),
+                'post_count'  => (int) $row['post_count'],
+            ];
+        }
+
+        return $results;
     }
 
+    /**
+     * Get engagement stats grouped by service type.
+     *
+     * @param   int  $days  Number of days to look back (0 = all time)
+     *
+     * @return  array  List of [service_type, total_posts, avg_engagement_rate, total_impressions, total_engagements]
+     */
     public static function getServiceBreakdown(int $days = 30): array
     {
         $db = Factory::getDbo();
 
         $query = $db->getQuery(true)
-            ->select($db->quoteName('s.service_type'))
-            ->select($db->quoteName('s.title', 'service_title'))
-            ->select('COUNT(*) AS total')
-            ->select('SUM(CASE WHEN ' . $db->quoteName('p.status') . ' = ' . $db->quote('posted') . ' THEN 1 ELSE 0 END) AS success')
-            ->select('SUM(CASE WHEN ' . $db->quoteName('p.status') . ' = ' . $db->quote('failed') . ' THEN 1 ELSE 0 END) AS failed')
-            ->from($db->quoteName('#__mokosuitecross_posts', 'p'))
-            ->join('INNER', $db->quoteName('#__mokosuitecross_services', 's') . ' ON ' . $db->quoteName('s.id') . ' = ' . $db->quoteName('p.service_id'));
+            ->select([
+                $db->quoteName('service_type'),
+                'COUNT(*) AS total_posts',
+                'AVG(' . $db->quoteName('engagement_rate') . ') AS avg_engagement_rate',
+                'SUM(' . $db->quoteName('impressions') . ') AS total_impressions',
+                'SUM(' . $db->quoteName('engagements') . ') AS total_engagements',
+                'SUM(' . $db->quoteName('clicks') . ') AS total_clicks',
+                'SUM(' . $db->quoteName('shares') . ') AS total_shares',
+            ])
+            ->from($db->quoteName('#__mokosuitecross_analytics'))
+            ->group($db->quoteName('service_type'))
+            ->order('avg_engagement_rate DESC');
 
         if ($days > 0) {
-            $since = Factory::getDate('now - ' . $days . ' days')->toSql();
-            $query->where($db->quoteName('p.created') . ' >= ' . $db->quote($since));
+            $cutoff = Factory::getDate('-' . $days . ' days')->toSql();
+            $query->where($db->quoteName('posted_at') . ' >= ' . $db->quote($cutoff));
         }
 
-        $query->group($db->quoteName(['s.service_type', 's.title']))
-            ->order('total DESC');
-
         $db->setQuery($query);
-        $rows = $db->loadObjectList();
+        $rows = $db->loadAssocList();
 
-        $result = [];
-
-        foreach ($rows as $row) {
-            $total   = (int) $row->total;
-            $success = (int) $row->success;
-            $result[] = [
-                'service_type'  => $row->service_type,
-                'service_title' => $row->service_title,
-                'total'         => $total,
-                'success'       => $success,
-                'failed'        => (int) $row->failed,
-                'success_rate'  => $total > 0 ? round(($success / $total) * 100, 1) : 0.0,
-                'avg_per_day'   => $days > 0 ? round($total / $days, 1) : 0.0,
-            ];
+        foreach ($rows as &$row) {
+            $row['avg_engagement_rate'] = round((float) $row['avg_engagement_rate'], 2);
+            $row['total_posts']         = (int) $row['total_posts'];
+            $row['total_impressions']   = (int) $row['total_impressions'];
+            $row['total_engagements']   = (int) $row['total_engagements'];
+            $row['total_clicks']        = (int) $row['total_clicks'];
+            $row['total_shares']        = (int) $row['total_shares'];
         }
 
-        return $result;
+        return $rows;
     }
-
-    public static function getServiceTypes(): array
-    {
-        $db = Factory::getDbo();
-
-        $query = $db->getQuery(true)
-            ->select('DISTINCT ' . $db->quoteName('service_type'))
-            ->from($db->quoteName('#__mokosuitecross_services'))
-            ->where($db->quoteName('published') . ' = 1')
-            ->order($db->quoteName('service_type') . ' ASC');
-
-        $db->setQuery($query);
-
-        return $db->loadColumn() ?: [];
-    }
-
-    private static function formatHour(int $hour): string
-    {
-        if ($hour === 0) {
-            return '12:00 AM';
-        }
-
-        if ($hour < 12) {
-            return $hour . ':00 AM';
-        }
-
-        if ($hour === 12) {
-            return '12:00 PM';
-        }
-
-        return ($hour - 12) . ':00 PM';
-    }
-}
+}

source/packages/com_mokosuitecross/tmpl/dashboard/default.php

@@ -220,6 +220,175 @@ $queueProcessing = $componentParams->get('queue_processing', 'scheduler');
         </div>
         <?php endif; ?>
 
+        <!-- Analytics: Best Times to Post Heatmap -->
+        <div class="card mt-3">
+            <div class="card-header d-flex justify-content-between align-items-center">
+                <h5 class="card-title mb-0"><?php echo Text::_('COM_MOKOSUITECROSS_ANALYTICS_BEST_TIMES'); ?></h5>
+                <select id="heatmapServiceFilter" class="form-select form-select-sm" style="width: auto;">
+                    <option value=""><?php echo Text::_('COM_MOKOSUITECROSS_ANALYTICS_ALL_PLATFORMS'); ?></option>
+                    <?php
+                    $db = \Joomla\CMS\Factory::getDbo();
+                    $stQuery = $db->getQuery(true)
+                        ->select('DISTINCT ' . $db->quoteName('service_type'))
+                        ->from($db->quoteName('#__mokosuitecross_services'))
+                        ->where($db->quoteName('published') . ' = 1')
+                        ->order($db->quoteName('service_type') . ' ASC');
+                    $db->setQuery($stQuery);
+                    $serviceTypes = $db->loadColumn();
+                    foreach ($serviceTypes as $st) :
+                    ?>
+                        <option value="<?php echo htmlspecialchars($st); ?>"><?php echo htmlspecialchars(ucfirst($st)); ?></option>
+                    <?php endforeach; ?>
+                </select>
+            </div>
+            <div class="card-body">
+                <div id="heatmapContainer">
+                    <p class="text-muted" id="heatmapLoading"><?php echo Text::_('JLIB_HTML_BEHAVIOR_LOADING'); ?></p>
+                    <div id="heatmapNoData" style="display:none;">
+                        <p class="text-muted mb-0"><?php echo Text::_('COM_MOKOSUITECROSS_ANALYTICS_NO_DATA'); ?></p>
+                    </div>
+                    <div id="heatmapGrid" style="display:none;">
+                        <style>
+                            .msc-heatmap { border-collapse: collapse; width: 100%; font-size: 11px; }
+                            .msc-heatmap th, .msc-heatmap td { text-align: center; padding: 3px 2px; min-width: 28px; }
+                            .msc-heatmap th { font-weight: 600; color: #666; font-size: 10px; }
+                            .msc-heatmap td.msc-hm-cell { border-radius: 3px; cursor: default; position: relative; }
+                            .msc-heatmap td.msc-hm-cell:hover { outline: 2px solid #333; z-index: 1; }
+                            .msc-heatmap .msc-hm-day { text-align: right; padding-right: 8px; font-weight: 600; color: #555; white-space: nowrap; }
+                        </style>
+                        <table class="msc-heatmap" id="heatmapTable">
+                            <thead>
+                                <tr>
+                                    <th></th>
+                                    <?php for ($h = 0; $h < 24; $h++) :
+                                        $label = $h % 12 ?: 12;
+                                        $suffix = $h < 12 ? 'a' : 'p';
+                                    ?>
+                                        <th><?php echo $label . $suffix; ?></th>
+                                    <?php endfor; ?>
+                                </tr>
+                            </thead>
+                            <tbody>
+                                <?php
+                                $dayLabels = ['Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'];
+                                for ($d = 0; $d < 7; $d++) :
+                                ?>
+                                <tr>
+                                    <td class="msc-hm-day"><?php echo $dayLabels[$d]; ?></td>
+                                    <?php for ($h = 0; $h < 24; $h++) : ?>
+                                        <td class="msc-hm-cell" id="hm-<?php echo $d; ?>-<?php echo $h; ?>" title="<?php echo $dayLabels[$d] . ' ' . ($h % 12 ?: 12) . ':00 ' . ($h < 12 ? 'AM' : 'PM'); ?>"></td>
+                                    <?php endfor; ?>
+                                </tr>
+                                <?php endfor; ?>
+                            </tbody>
+                        </table>
+                        <div class="d-flex align-items-center justify-content-end mt-2" style="font-size:11px;color:#666;">
+                            <span class="me-1"><?php echo Text::_('COM_MOKOSUITECROSS_ANALYTICS_ENGAGEMENT_RATE'); ?>:</span>
+                            <span style="display:inline-block;width:14px;height:14px;background:#ebedf0;border-radius:2px;margin:0 1px;" title="0%"></span>
+                            <span style="display:inline-block;width:14px;height:14px;background:#9be9a8;border-radius:2px;margin:0 1px;" title="Low"></span>
+                            <span style="display:inline-block;width:14px;height:14px;background:#40c463;border-radius:2px;margin:0 1px;" title="Medium"></span>
+                            <span style="display:inline-block;width:14px;height:14px;background:#30a14e;border-radius:2px;margin:0 1px;" title="High"></span>
+                            <span style="display:inline-block;width:14px;height:14px;background:#216e39;border-radius:2px;margin:0 1px;" title="Very High"></span>
+                        </div>
+                    </div>
+                    <div id="heatmapBestTimes" style="display:none;" class="mt-3 pt-3 border-top">
+                        <strong><?php echo Text::_('COM_MOKOSUITECROSS_ANALYTICS_BEST_TIMES'); ?>:</strong>
+                        <ul id="bestTimesList" class="mb-0 mt-1"></ul>
+                    </div>
+                </div>
+            </div>
+        </div>
+        <script>
+        document.addEventListener('DOMContentLoaded', function() {
+            var token = '<?php echo \Joomla\CMS\Session\Session::getFormToken(); ?>';
+
+            function loadHeatmap(serviceType) {
+                var url = 'index.php?option=com_mokosuitecross&task=analytics.heatmap&format=json'
+                    + '&service_type=' + encodeURIComponent(serviceType || '')
+                    + '&days=90&' + token + '=1';
+
+                document.getElementById('heatmapLoading').style.display = '';
+                document.getElementById('heatmapGrid').style.display = 'none';
+                document.getElementById('heatmapNoData').style.display = 'none';
+                document.getElementById('heatmapBestTimes').style.display = 'none';
+
+                fetch(url)
+                    .then(function(r) { return r.json(); })
+                    .then(function(data) {
+                        document.getElementById('heatmapLoading').style.display = 'none';
+
+                        if (!data.success) {
+                            document.getElementById('heatmapNoData').style.display = '';
+                            return;
+                        }
+
+                        var grid = data.grid;
+                        var maxRate = 0;
+                        var hasData = false;
+
+                        for (var d = 0; d < 7; d++) {
+                            for (var h = 0; h < 24; h++) {
+                                var rate = grid[d] && grid[d][h] ? parseFloat(grid[d][h].avg_rate) : 0;
+                                if (rate > maxRate) maxRate = rate;
+                                if (rate > 0) hasData = true;
+                            }
+                        }
+
+                        if (!hasData) {
+                            document.getElementById('heatmapNoData').style.display = '';
+                            return;
+                        }
+
+                        document.getElementById('heatmapGrid').style.display = '';
+
+                        var colors = ['#ebedf0', '#9be9a8', '#40c463', '#30a14e', '#216e39'];
+                        for (var d = 0; d < 7; d++) {
+                            for (var h = 0; h < 24; h++) {
+                                var cell = document.getElementById('hm-' + d + '-' + h);
+                                if (!cell) continue;
+                                var val = grid[d] && grid[d][h] ? grid[d][h] : {avg_rate: 0, post_count: 0};
+                                var rate = parseFloat(val.avg_rate);
+                                var count = parseInt(val.post_count, 10);
+                                var level = 0;
+                                if (maxRate > 0 && rate > 0) {
+                                    var pct = rate / maxRate;
+                                    if (pct <= 0.25) level = 1;
+                                    else if (pct <= 0.50) level = 2;
+                                    else if (pct <= 0.75) level = 3;
+                                    else level = 4;
+                                }
+                                cell.style.backgroundColor = colors[level];
+                                cell.title = cell.title.split(' - ')[0] + ' - ' + rate.toFixed(1) + '% (' + count + ' posts)';
+                            }
+                        }
+
+                        // Show best times
+                        if (data.best_times && data.best_times.length > 0) {
+                            document.getElementById('heatmapBestTimes').style.display = '';
+                            var list = document.getElementById('bestTimesList');
+                            list.innerHTML = '';
+                            var top = data.best_times.slice(0, 3);
+                            for (var i = 0; i < top.length; i++) {
+                                var bt = top[i];
+                                var li = document.createElement('li');
+                                li.textContent = bt.day_name + ' at ' + bt.hour_label + ' (' + bt.avg_rate.toFixed(1) + '% avg engagement)';
+                                list.appendChild(li);
+                            }
+                        }
+                    })
+                    .catch(function() {
+                        document.getElementById('heatmapLoading').style.display = 'none';
+                        document.getElementById('heatmapNoData').style.display = '';
+                    });
+            }
+
+            document.getElementById('heatmapServiceFilter').addEventListener('change', function() {
+                loadHeatmap(this.value);
+            });
+
+            loadHeatmap('');
+        });
+        </script>
         <!-- Recent Activity -->
         <div class="card mt-3">
             <div class="card-header">

source/packages/plg_content_mokosuitecross/mokosuitecross.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="content" method="upgrade">
     <name>Content - MokoSuiteCross</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_content_mokosuitecross/src/Extension/MokoSuiteCrossContent.php

@@ -257,6 +257,53 @@ XML;
             $form->load($aiXml);
             $form->setFieldAttribute('mokosuitecross_ai_generate', 'description', $aiButtonHtml, 'attribs');
         }
+        // Social Image Generator button (#157)
+        $siParams  = ComponentHelper::getParams('com_mokosuitecross');
+        $siEnabled = (bool) $siParams->get('social_image_enabled', 0);
+
+        if ($siEnabled && $articleId > 0) {
+            $siToken = Session::getFormToken();
+            $siUrl   = Uri::base() . 'index.php?option=com_mokosuitecross&task=socialimage.generate&format=raw&article_id=' . $articleId . '&' . $siToken . '=1';
+
+            $siButtonHtml = '<div class="mb-3">'
+                . '<button type="button" id="mokosuitecross-si-btn" class="btn btn-sm btn-outline-success" onclick="mokosuitecrossSiGenerate()">'
+                . '<span class="icon-image" aria-hidden="true"></span> '
+                . \Joomla\CMS\Language\Text::_('COM_MOKOSUITECROSS_SOCIAL_IMAGE_GENERATE')
+                . '</button>'
+                . '<span id="mokosuitecross-si-status" class="ms-2 small"></span>'
+                . '<div id="mokosuitecross-si-preview" class="mt-2" style="display:none;">'
+                . '<img id="mokosuitecross-si-thumb" src="" alt="Social image preview" style="max-width:300px;border:1px solid #ccc;border-radius:4px;" />'
+                . '</div>'
+                . '</div>'
+                . '<script>'
+                . 'function mokosuitecrossSiGenerate(){'
+                . 'var btn=document.getElementById("mokosuitecross-si-btn");'
+                . 'var st=document.getElementById("mokosuitecross-si-status");'
+                . 'var pv=document.getElementById("mokosuitecross-si-preview");'
+                . 'var img=document.getElementById("mokosuitecross-si-thumb");'
+                . 'btn.disabled=true;st.textContent="' . \Joomla\CMS\Language\Text::_('COM_MOKOSUITECROSS_SOCIAL_IMAGE_GENERATING', true) . '";'
+                . 'pv.style.display="none";'
+                . 'fetch("' . $siUrl . '")'
+                . '.then(function(r){return r.json();})'
+                . '.then(function(d){'
+                . 'btn.disabled=false;'
+                . 'if(!d.success){st.textContent=d.error||"Error";return;}'
+                . 'st.textContent="' . \Joomla\CMS\Language\Text::_('COM_MOKOSUITECROSS_SOCIAL_IMAGE_GENERATED', true) . '";'
+                . 'img.src="' . Uri::root() . '"+d.image_url+"?t="+Date.now();'
+                . 'pv.style.display="block";'
+                . '})'
+                . '.catch(function(){btn.disabled=false;st.textContent="Request failed";});'
+                . '}'
+                . '</script>';
+
+            $siXml = '<?xml version="1.0"?>
+<form><fields name="attribs"><fieldset name="mokosuitecross_share">
+    <field name="mokosuitecross_si_generate" type="note"
+        label="" description="" />
+</fieldset></fields></form>';
+            $form->load($siXml);
+            $form->setFieldAttribute('mokosuitecross_si_generate', 'description', $siButtonHtml, 'attribs');
+        }
 
         // Cross-post history panel for existing articles
 

source/packages/plg_mokosuitecross_activitypub/activitypub.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - ActivityPub (Fediverse)</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_blogger/blogger.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Google Blogger</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_bluesky/bluesky.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Bluesky</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_brevo/brevo.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Brevo (Sendinblue)</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_constantcontact/constantcontact.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Constant Contact</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_convertkit/convertkit.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - ConvertKit</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_devto/devto.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Dev.to</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_discord/discord.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Discord</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_facebook/facebook.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Facebook / Meta</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_ghost/ghost.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Ghost</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_googlebusiness/googlebusiness.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Google Business Profile</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_googlechat/googlechat.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Google Chat</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_hashnode/hashnode.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Hashnode</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_instagram/instagram.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Instagram</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-06-23</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_linkedin/linkedin.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - LinkedIn</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_mailchimp/mailchimp.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Mailchimp</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_mastodon/mastodon.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Mastodon</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_matrix/matrix.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Matrix / Element</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_medium/medium.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Medium</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_mokosuitecalendar/mokosuitecalendar.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - MokoSuiteCalendar Events</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_mokosuitegallery/mokosuitegallery.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - MokoSuiteGallery</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_nostr/nostr.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Nostr</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_ntfy/ntfy.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Ntfy Push Notifications</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_pinterest/pinterest.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Pinterest</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_reddit/reddit.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Reddit</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_rssfeed/rssfeed.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - RSS Feed</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_sendgrid/sendgrid.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - SendGrid</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_slack/slack.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Slack</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_teams/teams.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Microsoft Teams</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_telegram/telegram.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Telegram</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_threads/threads.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Threads (Meta)</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_tiktok/tiktok.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - TikTok</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_tumblr/tumblr.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Tumblr</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_twitter/twitter.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - X / Twitter</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_webhook/webhook.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Generic Webhook</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_whatsapp/whatsapp.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - WhatsApp Business</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_wordpress/wordpress.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - WordPress</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_mokosuitecross_youtube/youtube.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="mokosuitecross" method="upgrade">
     <name>MokoSuiteCross - Youtube</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-06-23</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_system_mokosuitecross/mokosuitecross.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="system" method="upgrade">
     <name>System - MokoSuiteCross</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_system_mokosuitecross_events/mokosuitecross_events.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="system" method="upgrade">
     <name>System - MokoSuiteCross Events</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_system_mokosuitecross_gallery/mokosuitecross_gallery.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="system" method="upgrade">
     <name>System - MokoSuiteCross Gallery</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_task_mokosuitecross/mokosuitecross.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="task" method="upgrade">
     <name>Task - MokoSuiteCross Queue Processor</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/packages/plg_webservices_mokosuitecross/mokosuitecross.xml

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <extension type="plugin" group="webservices" method="upgrade">
     <name>Web Services - MokoSuiteCross</name>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>

source/pkg_mokosuitecross.xml

@@ -2,7 +2,7 @@
 <extension type="package" method="upgrade">
     <name>MokoSuiteCross</name>
     <packagename>mokosuitecross</packagename>
-    <version>01.11.00</version>
+    <version>01.12.02</version>
     <creationDate>2026-05-28</creationDate>
     <author>Moko Consulting</author>
     <authorEmail>hello@mokoconsulting.tech</authorEmail>