Fix #5774 - City / Province...
authorEdward <edward@roojs.com>
Thu, 7 Mar 2019 08:21:59 +0000 (16:21 +0800)
committerEdward <edward@roojs.com>
Thu, 7 Mar 2019 08:21:59 +0000 (16:21 +0800)
DataObjects/I18n.php

index 3661433..9711cb6 100644 (file)
@@ -171,6 +171,19 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject
                 ) AS no_of_city
             ");
             
+            if(!empty($q['_hide_unused'])) {
+                $this->whereAdd("
+                    (
+                        SELECT
+                                COUNT(geoip_division.id)
+                        FROM
+                                geoip_division
+                        WHERE
+                                geoip_division.country = i18n.lkey
+                    ) > 0
+                ");
+            }
+            
         }
     }