Fix #5774 - City / Province...

[Pman.Core] / DataObjects / I18n.php

diff --git a/DataObjects/I18n.php b/DataObjects/I18n.php
index 3661433..9711cb6 100644 (file)
--- a/DataObjects/I18n.php
+++ b/DataObjects/I18n.php
@@ -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
+                ");
+            }
+            
         }
     }