DataObjects/core.sql

[Pman.Core] / DataObjects / Office.php

diff --git a/DataObjects/Office.php b/DataObjects/Office.php
index a2a52cd..020ed59 100644 (file)
--- a/DataObjects/Office.php
+++ b/DataObjects/Office.php
@@ -28,7 +28,8 @@ class Pman_Core_DataObjects_Office extends DB_DataObject
     {
         //DB_DataObject::debugLevel(1);
         //$this->joinAddCountry();
-        $this->selectAdd("(SELECT lval FROM i18n WHERE lkey = Office.country) AS country_name");
+        //print_r($au);
+        $this->selectAdd("(SELECT lval FROM i18n WHERE lkey = Office.country AND ltype = 'c' AND inlang = '{$au->lang}') AS country_name");
        
     }