Changeset 3764005 for langforge/trunk/admin/class-admin.php

Timestamp:

10/25/2026 06:29:16 AM (35 hours ago)

Author:

avakodeforge

Message:

Release 1.3.0 (trunk + tag; see readme changelog)

File:

• langforge/trunk/admin/class-admin.php (modified) (27 diffs)

langforge/trunk/admin/class-admin.php

@@ -79 +79 @@
         // Lang Forge → Migration → WPML.
         add_action('admin_notices', [$this, 'render_wpml_coexistence_notice']);
+        // BUG-LANG-INTEG-02: the same warning for Polylang and TranslatePress.
+        add_action('admin_notices', [$this, 'render_rival_coexistence_notice']);
     }
 
@@ -207 +209 @@
             'skipped'    => $total_skipped,
             'errors'     => $errors,
+            /* translators: %d: number of strings translated; the sentence takes the form of that number. */
+            'message'    => sprintf(_n('Translated %d string. Reloading…', 'Translated %d strings. Reloading…', $total_done, 'langforge'), $total_done),
         ]);
     }
@@ -405 +409 @@
             if ($result['success']) {
                 /* translators: %d: number of translation groups imported from WPML. */
-                echo '<div class="notice notice-success"><p>' . sprintf(esc_html__('Migration complete! Imported %d translation groups.', 'langforge'), esc_html($result['count'])) . '</p></div>';
+                echo '<div class="notice notice-success"><p>' . sprintf(esc_html(_n('Migration complete! Imported %d translation group.', 'Migration complete! Imported %d translation groups.', (int) $result['count'], 'langforge')), (int) $result['count']) . '</p></div>';
             } else {
                 echo '<div class="notice notice-error"><p>' . esc_html__("Migration failed: ", "langforge") . esc_html($result['error']) . '</p></div>';
@@ -768 +772 @@
         $is_lf_page    = strpos($page_param, 'langforge-') === 0;
         $is_post_list  = in_array($screen_base, ['edit', 'post', 'page'], true);
-        $is_taxonomy   = $screen_base === 'edit-tags';
+        // The list of terms (edit-tags.php) and the edit screen of one term (term.php) both print the Language and
+        // Translations fields, with the cross that unlinks a translation: its click handler lives in admin.js.
+        // (BUG-LANG-TERM-01: term.php used to be left out, so the cross there did nothing.)
+        $is_taxonomy   = in_array($screen_base, ['edit-tags', 'term'], true);
 
         $is_post_edit  = $screen_base === 'post'; // single post/page edit screen
@@ -834 +841 @@
                 'resetsOn'               => __('Resets on', 'langforge'),
                 'buyCredits'             => __('Buy credits', 'langforge'),
+                'choosePlan'             => __('Choose a plan', 'langforge'),
+                'trialCreditsExhausted'  => __('Your free trial has too few credits left for this action. Connect a licence or choose a plan to keep using AI.', 'langforge'),
                 'fixApplied'             => __('Fix applied.', 'langforge'),
                 'dismissTitle'           => __('Dismiss', 'langforge'),
@@ -1494 +1503 @@
             if ($result['success']) {
                 /* translators: %d: number of translation groups imported from WPML. */
-                echo '<div class="notice notice-success"><p>' . sprintf(esc_html__('Migration complete! Imported %d translation groups.', 'langforge'), esc_html($result['count'])) . '</p></div>';
+                echo '<div class="notice notice-success"><p>' . sprintf(esc_html(_n('Migration complete! Imported %d translation group.', 'Migration complete! Imported %d translation groups.', (int) $result['count'], 'langforge')), (int) $result['count']) . '</p></div>';
             } else {
                 echo '<div class="notice notice-error"><p>' . esc_html__("Migration failed: ", "langforge") . esc_html($result['error']) . '</p></div>';
@@ -1773 +1782 @@
         // Handle save
         if (isset($_POST['langforge_save_strings']) && wp_verify_nonce(isset($_POST['lf_strings_nonce']) ? sanitize_text_field(wp_unslash($_POST['lf_strings_nonce'])) : '', 'langforge_save_strings')) {
-            $this->save_string_translations();
+            $glossary_report = $this->save_string_translations();
             echo '<div class="notice notice-success"><p>' . esc_html__('Translations saved.', 'langforge') . '</p></div>';
+            // BUG-LANG-GLOSS-02: saved all the same; the terms of the glossary a translation does not follow are named.
+            LANGFORGE_Strings_Screen::render_glossary_report($glossary_report);
         }
 
@@ -1921 +1932 @@
                         printf(
                             /* translators: 1: first row number shown, 2: last row number shown, 3: total number of strings. */
-                            esc_html__('Showing %1$d – %2$d of %3$d strings', 'langforge'),
+                            esc_html(_n('Showing %1$d – %2$d of %3$d string', 'Showing %1$d – %2$d of %3$d strings', (int) $total_strings, 'langforge')),
                             esc_html($from_idx), esc_html($to_idx), esc_html($total_strings)
                         );
@@ -2172 +2183 @@
                                 data-source="<?php echo esc_attr($default_lang); ?>"
                                 data-missing-cost="<?php echo (int) $ai_missing_cost; ?>"
+                                data-missing-cost-word="<?php /* translators: the unit after a number of AI credits, in the form that number takes ("1 credit", "5 credits"); the AI Translate dialog puts it after the cost. */ echo esc_attr(_n('credit', 'credits', $ai_missing_cost, 'langforge')); ?>"
                                 data-missing-slots="<?php echo (int) $ai_pending; ?>"
                                 data-missing-langs="<?php echo (int) $ai_missing_lang_count; ?>"
+                                data-missing-text="<?php echo esc_attr(self::ai_missing_text($ai_pending, $ai_missing_lang_count, $ai_missing_cost)); ?>"
                                 data-all-cost="<?php echo (int) $ai_all_cost; ?>"
+                                data-all-cost-word="<?php /* translators: the unit after a number of AI credits, in the form that number takes ("1 credit", "5 credits"); the AI Translate dialog puts it after the cost. */ echo esc_attr(_n('credit', 'credits', $ai_all_cost, 'langforge')); ?>"
                                 data-all-slots="<?php echo (int) $ai_all_slots; ?>"
                                 data-all-langs="<?php echo (int) $ai_all_lang_count; ?>"
@@ -2245 +2259 @@
                         var $modal = jQuery('#lf-ai-modal');
                         function closeModal(){ $modal.css('display','none').attr('aria-hidden','true'); }
-                        function crWord(n){ return n === 1 ? '<?php echo esc_js(__('credit', 'langforge')); ?>' : '<?php echo esc_js(__('credits', 'langforge')); ?>'; }
 
                         function runBulk($btn, mode){
@@ -2264 +2277 @@
                                     var n = (r.data && r.data.translated) || 0;
                                     var errs = (r.data && r.data.errors) || [];
-                                    var msg2 = '<?php /* translators: %d: number of strings translated (replaced client-side). */ echo esc_js(__('Translated %d strings. Reloading…', 'langforge')); ?>'.replace('%d', n);
+                                    // The server words the count, in the plural form of its number (ajax_ai_translate_strings_bulk()).
+                                    var msg2 = (r.data && typeof r.data.message === 'string' && r.data.message !== '') ? r.data.message : String(n);
                                     if (errs.length) msg2 += '\n\n' + errs.join('\n');
                                     $btn.html('<span class="dashicons dashicons-yes"></span> ' + msg2);
@@ -2291 +2305 @@
                             var missing = parseInt($btn.data('missing-slots'),10)||0;
                             var missingCost = parseInt($btn.data('missing-cost'),10)||0;
-                            var missingLangs = parseInt($btn.data('missing-langs'),10)||0;
                             var allSlots = parseInt($btn.data('all-slots'),10)||0;
                             var allCost = parseInt($btn.data('all-cost'),10)||0;
+                            // The word after each cost, in the form that cost takes: chosen with _n() when the page was
+                            // drawn (one form in English, three in Russian, six in Arabic), not by n === 1 here.
+                            var missingWord = String($btn.data('missing-cost-word') || '');
+                            var allWord = String($btn.data('all-cost-word') || '');
 
                             var title, body, actions = [];
                             if (missing > 0) {
                                 title = '<?php echo esc_js(__('Translate missing strings?', 'langforge')); ?>';
-                                body  = '<?php /* translators: 1: number of untranslated strings, 2: number of languages, 3: credit cost, 4: the word "credit"/"credits". */ echo esc_js(__('%1$s string(s) across %2$s language(s) have no translation yet. Translating them costs %3$s %4$s, and the result is saved automatically.', 'langforge')); ?>'
-                                        .replace('%1$s', missing).replace('%2$s', missingLangs).replace('%3$s', missingCost).replace('%4$s', crWord(missingCost));
-                                actions.push({ label: '<?php echo esc_js(__('Translate Missing', 'langforge')); ?> · ' + missingCost + ' ' + crWord(missingCost), mode:'missing', color:'green' });
+                                // Put together when the page was drawn (ai_missing_text()): each number in its own plural form.
+                                body  = String($btn.data('missing-text') || '');
+                                actions.push({ label: '<?php echo esc_js(__('Translate Missing', 'langforge')); ?> · ' + missingCost + ' ' + missingWord, mode:'missing', color:'green' });
                                 if (allSlots > missing) {
-                                    actions.push({ label: '<?php echo esc_js(__('Re-Translate All', 'langforge')); ?> · ' + allCost + ' ' + crWord(allCost), mode:'all', color:'amber' });
+                                    actions.push({ label: '<?php echo esc_js(__('Re-Translate All', 'langforge')); ?> · ' + allCost + ' ' + allWord, mode:'all', color:'amber' });
                                 }
                             } else if (allSlots > 0) {
                                 title = '<?php echo esc_js(__('Everything is already translated', 'langforge')); ?>';
                                 body  = '<?php /* translators: 1: credit cost to re-translate all, 2: the word "credit"/"credits". */ echo esc_js(__('All strings in this domain already have a translation, so there is nothing new to translate — that is why the cost shows 0. You can re-generate every translation from scratch with the latest glossary: this overwrites the existing values, ignores Translation Memory, and costs %1$s %2$s.', 'langforge')); ?>'
-                                        .replace('%1$s', allCost).replace('%2$s', crWord(allCost));
-                                actions.push({ label: '<?php echo esc_js(__('Re-Translate All', 'langforge')); ?> · ' + allCost + ' ' + crWord(allCost), mode:'all', color:'amber' });
+                                        .replace('%1$s', allCost).replace('%2$s', allWord);
+                                actions.push({ label: '<?php echo esc_js(__('Re-Translate All', 'langforge')); ?> · ' + allCost + ' ' + allWord, mode:'all', color:'amber' });
                             } else {
                                 title = '<?php echo esc_js(__('Nothing to translate', 'langforge')); ?>';
@@ -2495 +2512 @@
     /**
  * Save string translations
+ *
+ * Everything posted is saved. Afterwards the saved texts are checked against the glossary (BUG-LANG-GLOSS-02) and
+ * what does not follow it is returned for the screen to name; the check never keeps a text from being saved.
+ *
+ * @return array<int,array{name:string,domain:string,lang:string,warnings:string}> See LANGFORGE_Strings_Screen::glossary_report.
  */
     private function save_string_translations() {
         // phpcs:disable WordPress.Security.NonceVerification.Missing -- Nonce verified in render_string_translation_page (lf_strings_nonce / langforge_save_strings) before this method runs.
         if (empty($_POST['strings']) || !is_array($_POST['strings'])) {
-            return;
+            return [];
         }
 
@@ -2508 +2530 @@
             : [];
 
+        $source_lang = LANGFORGE_Core::instance()->get_default_language();
+        $saved = [];
+
         foreach ($posted_strings as $raw_name => $translations) {
             if (!is_array($translations)) {
@@ -2520 +2545 @@
                 : ($global_domain ?: 'default');
 
+            $values = [];
             foreach ($translations as $lang => $value) {
                 $lang = sanitize_text_field($lang);
                 $value = LANGFORGE_Strings_Screen::sanitize_translation($domain, $value);
+                $values[$lang] = $value;
 
                 if (!empty($value)) {
@@ -2528 +2555 @@
                 }
             }
+
+            foreach ($values as $lang => $value) {
+                if (!empty($value) && $lang !== $source_lang) {
+                    $saved[] = ['name' => $name, 'domain' => $domain, 'lang' => $lang, 'value' => $value, 'source' => $values[$source_lang] ?? null];
+                }
+            }
         }
         // phpcs:enable WordPress.Security.NonceVerification.Missing
+
+        return LANGFORGE_Strings_Screen::glossary_report($saved, $source_lang);
     }
 
@@ -2811 +2846 @@
 
     /**
+ * Translation Status, one language: of the published source posts of $types, how many have a translation
+ * in $code (any status but trash), and how many of those translations are published .
+ *
+ * Every join of the translations table on a post ID carries post_row_sql: the table also holds the rows
+ * of terms, and a term can have the same number as a post (BUG-LANG-SEO-03).
+ *
+ * @param string $code Target language.
+ * @param string $types_to_check Post types counted.
+ * @param string $default_lang Source language.
+ * @return int [translated, published].
+ */
+    private function count_translated_sources($code, array $types_to_check, $default_lang) {
+        global $wpdb;
+        $lf_table = $wpdb->prefix . 'langforge_translations';
+        $type_placeholders = implode(',', array_fill(0, count($types_to_check), '%s'));
+
+        // Count source posts that have a translation linked in
+        // lf_translations for this language. Again, no post_status
+        // filter on source or target — only existence of the pair.
+        // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQL.NotPrepared -- Core + $wpdb->prefix tables; IN built from %s placeholders, values are %-prepared; post_row_sql is a fixed fragment with no input.
+        $translated = (int) $wpdb->get_var($wpdb->prepare( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- $lf_table from $wpdb->prefix; values %-prepared.
+            "SELECT COUNT(DISTINCT p.ID) FROM {$wpdb->posts} p
+            INNER JOIN {$wpdb->postmeta} pm ON p.ID = pm.post_id
+            INNER JOIN {$lf_table} t1 ON p.ID = t1.element_id AND " . LANGFORGE_Post_Translation::post_row_sql('t1') . "
+            INNER JOIN {$lf_table} t2 ON t1.translation_group = t2.translation_group AND t2.language_code = %s AND " . LANGFORGE_Post_Translation::post_row_sql('t2') . "
+            INNER JOIN {$wpdb->posts} tp ON t2.element_id = tp.ID AND tp.post_status NOT IN ('trash','auto-draft','inherit')
+            WHERE p.post_status = 'publish'
+            AND p.post_type IN ($type_placeholders)
+            AND pm.meta_key = '_langforge_language' AND pm.meta_value = %s",
+            $code, ...array_merge($types_to_check, [$default_lang])
+        ));
+        // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQL.NotPrepared
+
+        // break translated count down by the target post's
+        // publish status so the card can show published / draft /
+        // missing instead of a single opaque percentage.
+        // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQL.NotPrepared -- Core + $wpdb->prefix tables; IN built from %s placeholders, values are %-prepared; post_row_sql is a fixed fragment with no input.
+        $published = (int) $wpdb->get_var($wpdb->prepare( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- $lf_table from $wpdb->prefix; values %-prepared.
+            "SELECT COUNT(DISTINCT p.ID) FROM {$wpdb->posts} p
+            INNER JOIN {$wpdb->postmeta} pm ON p.ID = pm.post_id
+            INNER JOIN {$lf_table} t1 ON p.ID = t1.element_id AND " . LANGFORGE_Post_Translation::post_row_sql('t1') . "
+            INNER JOIN {$lf_table} t2 ON t1.translation_group = t2.translation_group AND t2.language_code = %s AND " . LANGFORGE_Post_Translation::post_row_sql('t2') . "
+            INNER JOIN {$wpdb->posts} tp ON t2.element_id = tp.ID AND tp.post_status = 'publish'
+            WHERE p.post_status = 'publish'
+            AND p.post_type IN ($type_placeholders)
+            AND pm.meta_key = '_langforge_language' AND pm.meta_value = %s",
+            $code, ...array_merge($types_to_check, [$default_lang])
+        ));
+        // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQL.NotPrepared
+        return [$translated, $published];
+    }
+
+    /**
+ * Translation Status, "Out of date" list: the translation posts flagged _langforge_needs_update, each with its
+ * source post. The joins on the translations table are on posts' rows only (post_row_sql, BUG-LANG-SEO-03).
+ *
+ * @param string $default_lang Source language.
+ * @param string $filter_type One post type, or '' for all translatable ones.
+ * @param string $filter_lang One language, or '' for every language but the default one.
+ * @param string $translatable Translatable post types.
+ * @return object
+ */
+    private function get_outdated_posts($default_lang, $filter_type, $filter_lang, array $translatable) {
+        global $wpdb;
+
+        // Build query for out-of-date posts.
+        $outdated_args = [];
+        $type_clause = '';
+        if ($filter_type) {
+            $type_clause = ' AND p.post_type = %s';
+            $outdated_args[] = $filter_type;
+        } else {
+            $placeholders = implode(',', array_fill(0, count($translatable), '%s'));
+            $type_clause = " AND p.post_type IN ($placeholders)";
+            $outdated_args = array_merge($outdated_args, $translatable);
+        }
+        $lang_clause = '';
+        if ($filter_lang && $filter_lang !== $default_lang) {
+            $lang_clause = ' AND pm_lang.meta_value = %s';
+            $outdated_args[] = $filter_lang;
+        } else {
+            $lang_clause = ' AND pm_lang.meta_value <> %s';
+            $outdated_args[] = $default_lang;
+        }
+        // surface the modified timestamp of both the
+        // translation post itself and its source. JOIN to
+        // wp_lf_translations twice — once to find the
+        // translation_group of the outdated post, once to find
+        // the default-language sibling in that group — and pull
+        // its post_modified through a third join on wp_posts.
+        // Outer LEFT JOINs because half-migrated rows
+        // (translation in lf_translations but source row dropped)
+        // shouldn't drop the outdated post from the list — we'd
+        // rather show "—" than hide the row.
+        $lf_table = $wpdb->prefix . 'langforge_translations';
+        // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Core + $wpdb->prefix tables; $type_clause/$lang_clause are literal %s placeholder fragments, values %-prepared below.
+        $outdated_sql = "
+            SELECT p.ID, p.post_title, p.post_type, p.post_status,
+                   p.post_date, p.post_modified,
+                   pm_lang.meta_value AS lang_code,
+                   pm_flag.meta_value AS flagged_at,
+                   src.ID AS source_id,
+                   src.post_modified AS source_modified
+            FROM {$wpdb->posts} p
+            INNER JOIN {$wpdb->postmeta} pm_flag
+                ON pm_flag.post_id = p.ID AND pm_flag.meta_key = '_langforge_needs_update'
+            INNER JOIN {$wpdb->postmeta} pm_lang
+                ON pm_lang.post_id = p.ID AND pm_lang.meta_key = '_langforge_language'
+            LEFT JOIN {$lf_table} t1 ON t1.element_id = p.ID AND " . LANGFORGE_Post_Translation::post_row_sql('t1') . "
+            LEFT JOIN {$lf_table} t2 ON t2.translation_group = t1.translation_group
+                AND t2.language_code = %s AND " . LANGFORGE_Post_Translation::post_row_sql('t2') . "
+            LEFT JOIN {$wpdb->posts} src ON src.ID = t2.element_id
+                AND src.post_status NOT IN ('trash','auto-draft','inherit')
+            WHERE p.post_status NOT IN ('trash','auto-draft','inherit')
+            {$type_clause}{$lang_clause}
+            ORDER BY pm_flag.meta_value DESC
+            LIMIT 200
+        ";
+        // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared
+        // Inject the default-language code as the first %s for the
+        // t2.language_code = %s placeholder above. Other args
+        // (type clause, lang clause) follow in their declared order.
+        $outdated_args = array_merge([$default_lang], $outdated_args);
+        $outdated_posts = $wpdb->get_results($wpdb->prepare($outdated_sql, ...$outdated_args)); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- $outdated_sql is prepared here with %s placeholders; core/own tables.
+        return $outdated_posts;
+    }
+
+    /**
  * Render translation status page
  */
@@ -2960 +3123 @@
                 $total = $total_count;
 
-                // Count source posts that have a translation linked in
-                // lf_translations for this language. Again, no post_status
-                // filter on source or target — only existence of the pair.
-                // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Core + $wpdb->prefix tables; IN built from %s placeholders, values are %-prepared.
-                $translated = (int) $wpdb->get_var($wpdb->prepare( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- $lf_table from $wpdb->prefix; values %-prepared.
-                    "SELECT COUNT(DISTINCT p.ID) FROM {$wpdb->posts} p
-                    INNER JOIN {$wpdb->postmeta} pm ON p.ID = pm.post_id
-                    INNER JOIN {$lf_table} t1 ON p.ID = t1.element_id
-                    INNER JOIN {$lf_table} t2 ON t1.translation_group = t2.translation_group AND t2.language_code = %s
-                    INNER JOIN {$wpdb->posts} tp ON t2.element_id = tp.ID AND tp.post_status NOT IN ('trash','auto-draft','inherit')
-                    WHERE p.post_status = 'publish'
-                    AND p.post_type IN ($type_placeholders)
-                    AND pm.meta_key = '_langforge_language' AND pm.meta_value = %s",
-                    $code, ...array_merge($types_to_check, [$default_lang])
-                ));
-                // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared
-
-                // break translated count down by the target post's
-                // publish status so the card can show published / draft /
-                // missing instead of a single opaque percentage.
-                // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Core + $wpdb->prefix tables; IN built from %s placeholders, values are %-prepared.
-                $published = (int) $wpdb->get_var($wpdb->prepare( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- $lf_table from $wpdb->prefix; values %-prepared.
-                    "SELECT COUNT(DISTINCT p.ID) FROM {$wpdb->posts} p
-                    INNER JOIN {$wpdb->postmeta} pm ON p.ID = pm.post_id
-                    INNER JOIN {$lf_table} t1 ON p.ID = t1.element_id
-                    INNER JOIN {$lf_table} t2 ON t1.translation_group = t2.translation_group AND t2.language_code = %s
-                    INNER JOIN {$wpdb->posts} tp ON t2.element_id = tp.ID AND tp.post_status = 'publish'
-                    WHERE p.post_status = 'publish'
-                    AND p.post_type IN ($type_placeholders)
-                    AND pm.meta_key = '_langforge_language' AND pm.meta_value = %s",
-                    $code, ...array_merge($types_to_check, [$default_lang])
-                ));
-                // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared
+                // The counts are in count_translated_sources: posts only, never a term's row of the translations table.
+                [$translated, $published] = $this->count_translated_sources($code, $types_to_check, $default_lang);
                 $drafts  = max(0, $translated - $published);
                 $missing = max(0, $total - $translated);
@@ -3116 +3248 @@
                 </p>
                 <?php
-                // Build query for out-of-date posts.
-                $outdated_args = [];
-                $type_clause = '';
-                if ($filter_type) {
-                    $type_clause = ' AND p.post_type = %s';
-                    $outdated_args[] = $filter_type;
-                } else {
-                    $placeholders = implode(',', array_fill(0, count($translatable), '%s'));
-                    $type_clause = " AND p.post_type IN ($placeholders)";
-                    $outdated_args = array_merge($outdated_args, $translatable);
-                }
-                $lang_clause = '';
-                if ($filter_lang && $filter_lang !== $default_lang) {
-                    $lang_clause = ' AND pm_lang.meta_value = %s';
-                    $outdated_args[] = $filter_lang;
-                } else {
-                    $lang_clause = ' AND pm_lang.meta_value <> %s';
-                    $outdated_args[] = $default_lang;
-                }
-                // surface the modified timestamp of both the
-                // translation post itself and its source. JOIN to
-                // wp_lf_translations twice — once to find the
-                // translation_group of the outdated post, once to find
-                // the default-language sibling in that group — and pull
-                // its post_modified through a third join on wp_posts.
-                // Outer LEFT JOINs because half-migrated rows
-                // (translation in lf_translations but source row dropped)
-                // shouldn't drop the outdated post from the list — we'd
-                // rather show "—" than hide the row.
-                $lf_table = $wpdb->prefix . 'langforge_translations';
-                // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Core + $wpdb->prefix tables; $type_clause/$lang_clause are literal %s placeholder fragments, values %-prepared below.
-                $outdated_sql = "
-                    SELECT p.ID, p.post_title, p.post_type, p.post_status,
-                           p.post_date, p.post_modified,
-                           pm_lang.meta_value AS lang_code,
-                           pm_flag.meta_value AS flagged_at,
-                           src.ID AS source_id,
-                           src.post_modified AS source_modified
-                    FROM {$wpdb->posts} p
-                    INNER JOIN {$wpdb->postmeta} pm_flag
-                        ON pm_flag.post_id = p.ID AND pm_flag.meta_key = '_langforge_needs_update'
-                    INNER JOIN {$wpdb->postmeta} pm_lang
-                        ON pm_lang.post_id = p.ID AND pm_lang.meta_key = '_langforge_language'
-                    LEFT JOIN {$lf_table} t1 ON t1.element_id = p.ID
-                    LEFT JOIN {$lf_table} t2 ON t2.translation_group = t1.translation_group
-                        AND t2.language_code = %s
-                    LEFT JOIN {$wpdb->posts} src ON src.ID = t2.element_id
-                        AND src.post_status NOT IN ('trash','auto-draft','inherit')
-                    WHERE p.post_status NOT IN ('trash','auto-draft','inherit')
-                    {$type_clause}{$lang_clause}
-                    ORDER BY pm_flag.meta_value DESC
-                    LIMIT 200
-                ";
-                // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared
-                // Inject the default-language code as the first %s for the
-                // t2.language_code = %s placeholder above. Other args
-                // (type clause, lang clause) follow in their declared order.
-                $outdated_args = array_merge([$default_lang], $outdated_args);
-                $outdated_posts = $wpdb->get_results($wpdb->prepare($outdated_sql, ...$outdated_args)); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- $outdated_sql is prepared here with %s placeholders; core/own tables.
+                $outdated_posts = $this->get_outdated_posts($default_lang, $filter_type, $filter_lang, $translatable);
                 if (empty($outdated_posts)):
                     echo '<p style="color:#059669;font-weight:600;">' . esc_html__('Nothing flagged. Translations are current with their source.', 'langforge') . '</p>';
@@ -3259 +3333 @@
                                         <?php $rt_cost = class_exists('Forge_Wporg_Disabled_Credits') ? (int) Forge_Wporg_Disabled_Credits::get_action_cost('translate_post') : 3; if ($rt_cost < 1) { $rt_cost = 1; } ?>
                                         <button type="button" class="button button-small button-primary lf-outdated-retranslate"
-                                                title="<?php /* translators: %d: approximate number of AI credits the re-translation will use. */ echo esc_attr(sprintf(__('Re-run AI translation against the latest source content — uses about %d AI credits', 'langforge'), $rt_cost)); ?>"
+                                                title="<?php /* translators: %d: approximate number of AI credits the re-translation will use. */ echo esc_attr(sprintf(_n('Re-run AI translation against the latest source content — uses about %d AI credit', 'Re-run AI translation against the latest source content — uses about %d AI credits', $rt_cost, 'langforge'), $rt_cost)); ?>"
                                                 style="display:inline-flex;align-items:center;gap:5px;">
                                             <?php esc_html_e('Re-translate', 'langforge'); ?>
@@ -3286 +3360 @@
                         var failMsg    = <?php echo wp_json_encode(__('Re-translate failed.', 'langforge')); ?>;
                         var netMsg     = <?php echo wp_json_encode(__('Network error during re-translate.', 'langforge')); ?>;
-                        var confirmMsg = <?php /* translators: %d: approximate number of AI credits the re-translation will use. */ echo wp_json_encode(sprintf(__('Re-run AI translation for this post? This uses about %d AI credits and overwrites the current translation.', 'langforge'), (int) (class_exists('Forge_Wporg_Disabled_Credits') ? Forge_Wporg_Disabled_Credits::get_action_cost('translate_post') : 3))); ?>;
+                        var confirmMsg = <?php $rt_confirm_cost = (int) (class_exists('Forge_Wporg_Disabled_Credits') ? Forge_Wporg_Disabled_Credits::get_action_cost('translate_post') : 3); /* translators: %d: approximate number of AI credits the re-translation will use. */ echo wp_json_encode(sprintf(_n('Re-run AI translation for this post? This uses about %d AI credit and overwrites the current translation.', 'Re-run AI translation for this post? This uses about %d AI credits and overwrites the current translation.', $rt_confirm_cost, 'langforge'), $rt_confirm_cost)); ?>;
                         document.querySelectorAll('.lf-outdated-retranslate').forEach(function(btn) {
                             btn.addEventListener('click', function() {
@@ -3469 +3543 @@
                 $errors[] = sprintf(
                     /* translators: %d = max characters */
-                    __('Source term is too long (max %d characters).', 'langforge'),
+                    _n('Source term is too long (max %d character).', 'Source term is too long (max %d characters).', 255, 'langforge'),
                     255
                 );
@@ -3476 +3550 @@
                 $errors[] = sprintf(
                     /* translators: %d = max characters */
-                    __('Translation is too long (max %d characters).', 'langforge'),
+                    _n('Translation is too long (max %d character).', 'Translation is too long (max %d characters).', 255, 'langforge'),
                     255
                 );
@@ -3506 +3580 @@
                 $csv = file_get_contents($_FILES['glossary_csv']['tmp_name']); // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- $_FILES path validated by is_uploaded_file above.
                 $count = LANGFORGE_Glossary::instance()->import_csv($csv, $from, $to);
-                echo '<div class="notice notice-success"><p>' . sprintf(
-                    /* translators: %d = number of glossary terms imported */
-                    esc_html__('Imported %d term(s).', 'langforge'), (int) $count
-                ) . '</p></div>';
+                echo '<div class="notice notice-success"><p>' . esc_html(sprintf(
+                    /* translators: %d: number of glossary terms imported. */
+                    _n('Imported %d term.', 'Imported %d terms.', (int) $count, 'langforge'), (int) $count
+                )) . '</p></div>';
             } else {
                 echo '<div class="notice notice-error"><p>' . esc_html__('No CSV file uploaded.', 'langforge') . '</p></div>';
@@ -4074 +4148 @@
 
     /**
+ * The other multilingual plugins Lang can take the content of, that are running now (BUG-LANG-INTEG-02).
+ * WPML has its own notice above.
+ *
+ * @return array<string,string> Migration source key => plugin name.
+ */
+    public static function active_rival_plugins() {
+        $rivals = [];
+        if (defined('POLYLANG_VERSION')) {
+            $rivals['polylang'] = 'Polylang';
+        }
+        if (defined('TRP_PLUGIN_VERSION') || class_exists('TRP_Translate_Press')) {
+            $rivals['translatepress'] = 'TranslatePress';
+        }
+        return $rivals;
+    }
+
+    /**
+ * BUG-LANG-INTEG-02: Polylang or TranslatePress × LangForge coexistence warning.
+ *
+ * Next to Lang both print their own hreflang set and language switcher, and TranslatePress also owns
+ * `<html lang>`: every hreflang twice, two switchers, a Spanish page that says it is English. Same
+ * fault state as WPML, same way out: move the content with Lang Forge → Migration, then deactivate the
+ * other plugin. Shown where it is actionable, as the WPML notice.
+ */
+    public function render_rival_coexistence_notice() {
+        if (!current_user_can('manage_options')) return;
+        $rivals = self::active_rival_plugins();
+        if (!$rivals) return;
+
+        $screen = function_exists('get_current_screen') ? get_current_screen() : null;
+        $sid    = $screen ? (string) $screen->id : '';
+        if ($sid !== 'plugins'
+            && strpos($sid, 'langforge') === false
+            && strpos($sid, 'lang-forge') === false
+            && strpos($sid, 'lf-') === false) {
+            return;
+        }
+
+        $migration_url = admin_url('admin.php?page=langforge-migration');
+        foreach ($rivals as $name) {
+            ?>
+            <div class="notice notice-warning is-dismissible lf-rival-coexistence-notice">
+                <p style="font-size:14px;line-height:1.55;margin:6px 0;">
+                    <strong style="color:#92400e;">⚠ <?php
+                        /* translators: %s: name of another multilingual plugin (Polylang, TranslatePress) */
+                        echo esc_html(sprintf(__('%s and Lang Forge are both active', 'langforge'), $name));
+                    ?></strong><br>
+                    <?php esc_html_e('Two multilingual plugins running at the same time conflict on language routing and HTML meta — frontend output may be unpredictable.', 'langforge'); ?>
+                    <br>
+                    <?php
+                    printf(
+                        /* translators: 1: name of another multilingual plugin (Polylang, TranslatePress), 2: link to Lang Forge → Migration */
+                        esc_html__('To use Lang Forge, deactivate %1$s on the Plugins page. To migrate %1$s content into Lang Forge, run %2$s.', 'langforge'),
+                        esc_html($name),
+                        '<a href="' . esc_url($migration_url) . '"><strong>' . esc_html__('Lang Forge → Migration', 'langforge') . '</strong></a>'
+                    );
+                    ?>
+                </p>
+            </div>
+            <?php
+        }
+    }
+
+    /**
  * LF audit 2026-04-28 (R2-CP1): inline, non-dismissible callout shown
  * at the top of Lang Forge → Languages when WPML is active alongside
@@ -4165 +4303 @@
             'leave'  => __('Left published. They stay in DB but not linked from the switcher.', 'langforge'),
             /* translators: %d: number of posts moved to Draft. */
-            'draft'  => sprintf(__('Moved %d post(s) to Draft.', 'langforge'), $applied),
+            'draft'  => sprintf(_n('Moved %d post to Draft.', 'Moved %d posts to Draft.', $applied, 'langforge'), $applied),
             /* translators: %d: number of posts deleted. */
-            'delete' => sprintf(__('Deleted %d post(s).', 'langforge'), $applied),
+            'delete' => sprintf(_n('Deleted %d post.', 'Deleted %d posts.', $applied, 'langforge'), $applied),
         ];
         wp_send_json_success([
@@ -4174 +4312 @@
         ]);
     }
+
+    /**
+ * The sentence of the AI Translate dialog of String Translation for the strings that have no translation yet: how
+ * many, in how many languages, and what translating them costs. All three numbers are known when the page is drawn,
+ * so each takes its own plural form here (_n: one in English, three in Russian, six in Arabic): the sentence the
+ * form of the strings, the languages a phrase of their own in the form of their number, the cost the word of its
+ * number. The script of the dialog puts it in as it is (data-missing-text of the button).
+ *
+ * @param int $strings The empty slots: a string in a language it has no translation in.
+ * @param int $languages The languages they are in.
+ * @param int $cost The credits translating them costs.
+ * @return string Plain text.
+ */
+    public static function ai_missing_text($strings, $languages, $cost) {
+        $strings   = max(0, (int) $strings);
+        $languages = max(0, (int) $languages);
+        $cost      = max(0, (int) $cost);
+        return sprintf(
+            /* translators: 1: number of untranslated strings (the sentence takes the form of this number), 2: the languages they are in ("across 2 languages", its own plural phrase), 3: credit cost, 4: the word "credit" in the form the cost takes. */
+            _n('%1$s string %2$s has no translation yet. Translating it costs %3$s %4$s, and the result is saved automatically.', '%1$s strings %2$s have no translation yet. Translating them costs %3$s %4$s, and the result is saved automatically.', $strings, 'langforge'),
+            $strings,
+            sprintf(
+                /* translators: %s: number of languages. The phrase is the %2$s of "N strings across N languages have no translation yet": translate it with its preposition, in the form and case the number takes there. */
+                _n('across %s language', 'across %s languages', $languages, 'langforge'),
+                $languages
+            ),
+            $cost,
+            /* translators: the unit after a number of AI credits, in the form that number takes ("1 credit", "5 credits"); the AI Translate dialog puts it after the cost. */
+            _n('credit', 'credits', $cost, 'langforge')
+        );
+    }
 }