Index: branches/5.2.x/core/units/helpers/country_states_helper.php
===================================================================
diff -u -N -r16704 -r16776
--- branches/5.2.x/core/units/helpers/country_states_helper.php	(.../country_states_helper.php)	(revision 16704)
+++ branches/5.2.x/core/units/helpers/country_states_helper.php	(.../country_states_helper.php)	(revision 16776)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: country_states_helper.php 16704 2022-07-08 13:37:45Z alex $
+* @version	$Id: country_states_helper.php 16776 2023-11-22 08:53:45Z alex $
 * @package	In-Portal
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license      GNU/GPL
@@ -224,23 +224,25 @@
 		/**
 		 * Returns 3 symbols ISO code from 2 symbols ISO code or otherwise, when $from_short parameter is used
 		 *
-		 * @param string $iso_code
-		 * @param bool $from_short
+		 * @param string  $iso_code   ISO code.
+		 * @param boolean $from_short From short.
+		 *
 		 * @return string
 		 */
-		function getCountryIso($iso_code, $from_short = false)
+		public function getCountryIso($iso_code, $from_short = false)
 		{
-			if ($from_short) {
-				$sql = 'SELECT IsoCode
+			$cache_key = 'country_iso_mapping[%CountryStateSerial%]';
+			$cache_value = $this->Application->getCache($cache_key);
+
+			if ( $cache_value === false ) {
+				$sql = 'SELECT IsoCode, ShortIsoCode
 						FROM ' . TABLE_PREFIX . 'CountryStates
-						WHERE ShortIsoCode = ' . $this->Conn->qstr($iso_code) . ' AND `Type` = ' . DESTINATION_TYPE_COUNTRY;
+						WHERE `Type` = ' . DESTINATION_TYPE_COUNTRY;
+				$cache_value = $this->Conn->GetCol($sql, 'ShortIsoCode');
+				$this->Application->setCache($cache_key, $cache_value);
 			}
-			else {
-				$sql = 'SELECT ShortIsoCode
-						FROM ' . TABLE_PREFIX . 'CountryStates
-						WHERE IsoCode = ' . $this->Conn->qstr($iso_code) . ' AND `Type` = ' . DESTINATION_TYPE_COUNTRY;
-			}
 
-			return $this->Conn->GetOne($sql);
+			return $from_short ? $cache_value[$iso_code] : array_search($iso_code, $cache_value);
 		}
+
 	}