X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FI18n.php;h=9711cb6ce1b592f5a1c9a352628184d3f8cfabe3;hp=366143306879b3c34b7a27daa116048cded4d11b;hb=39538dd1c71297fb385a26c1aead204229558d44;hpb=00c30fc629dbb9ddb1c06d61c237336e3cc7a624 diff --git a/DataObjects/I18n.php b/DataObjects/I18n.php index 36614330..9711cb6c 100644 --- 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 + "); + } + } }