DataObjects/I18n.php
authorEdward <edward@roojs.com>
Thu, 7 Mar 2019 06:49:10 +0000 (14:49 +0800)
committerEdward <edward@roojs.com>
Thu, 7 Mar 2019 06:49:10 +0000 (14:49 +0800)
DataObjects/I18n.php

index 58ececb..ecf2a37 100644 (file)
@@ -172,7 +172,14 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject
             ");
             
             if(!empty($q['_hide_unused'])) {
-                $this->having("no_of_division > 0");
+                $this->whereAdd("(
+                    SELECT
+                            COUNT(geoip_division.id)
+                    FROM
+                            geoip_division
+                    WHERE
+                            geoip_division.country = i18n.lkey
+                ) > 0");
             }
             
         }