From: Alan <alan@roojs.com>
Date: Thu, 3 Aug 2023 07:52:50 +0000 (+0800)
Subject: fix #7755 - hide unused template strings
X-Git-Url: http://git.roojs.org/?p=Pman.Admin;a=commitdiff_plain;h=3dacd81b22be44a0e9ce76b8e9a5d16faf7c6f44

fix #7755 - hide unused template strings
---

diff --git a/UpdateBjsTemplates.php b/UpdateBjsTemplates.php
index b4aff11..be1a92d 100644
--- a/UpdateBjsTemplates.php
+++ b/UpdateBjsTemplates.php
@@ -219,7 +219,16 @@ class Pman_Admin_UpdateBjsTemplates extends Pman
             if($this->cli){
                 echo "Sync tables.....\n";
             }
+
+            // deactivate all table translation
+            $t = DB_DataObject::factory('core_templatestr');
+            $t->query(
+                "UPDATE core_templatestr
+                SET active = 0 
+                WHERE on_table != ''"
+            );
             
+            // activate the used table translation
             foreach($ff->Pman_Core['DataObjects_Core_templatestr']['tables'] as $table=>$cols){
                 $t = DB_DataObject::factory($table);
                 foreach($t->fetchAll() as $d) {