function _addLanguage($aLanguage, $aLangInfo) { $oDb = new BxDolModuleDb(); if (getLangIdByName($aLangInfo['Name'])) { // language already exists return false; } $sLangName = $oDb->escape($aLangInfo['Name']); $sLangFlag = $oDb->escape($aLangInfo['Flag']); $sLangTitle = $oDb->escape($aLangInfo['Title']); if (!$oDb->res("INSERT INTO `sys_localization_languages` VALUES (NULL, '{$sLangName}', '{$sLangFlag}', '{$sLangTitle}')")) { return false; } $iLangKey = $oDb->lastId(); foreach ($aLanguage as $sKey => $sValue) { $sDbKey = $oDb->escape($sKey); $sDbValue = $oDb->escape($sValue); $iExistedKey = $oDb->getOne("SELECT `ID` FROM `sys_localization_keys` WHERE `Key` = '{$sDbKey}'"); if (!$iExistedKey) { // key is missing, insert new key if (!$oDb->res("INSERT INTO `sys_localization_keys` VALUES (NULL, " . BX_DOL_LANGUAGE_CATEGORY_SYSTEM . ", '{$sDbKey}')")) { continue; } $iExistedKey = $oDb->lastId(); } $oDb->res("INSERT INTO `sys_localization_strings` VALUES({$iExistedKey}, {$iLangKey}, '{$sDbValue}')"); } return true; }
function _addLanguage($aLanguage, $aLangInfo) { $oDb = new BxDolModuleDb(); if (getLangIdByName($aLangInfo['Name'])) { // language already exists return false; } $sLangName = $aLangInfo['Name']; $sLangFlag = $aLangInfo['Flag']; $sLangTitle = $aLangInfo['Title']; $sLangDir = isset($aLangInfo['Direction']) && $aLangInfo['Direction'] ? $aLangInfo['Direction'] : 'LTR'; $sLangCountryCode = isset($aLangInfo['LanguageCountry']) && $aLangInfo['LanguageCountry'] ? $aLangInfo['LanguageCountry'] : $aLangInfo['Name'] . '_' . strtoupper($aLangInfo['Flag']); if (!$oDb->res("INSERT INTO `sys_localization_languages` VALUES (?, ?, ?, ?, ?, ?)", [NULL, $sLangName, $sLangFlag, $sLangTitle, $sLangDir, $sLangCountryCode])) { return false; } $iLangKey = $oDb->lastId(); foreach ($aLanguage as $sKey => $sValue) { $sDbKey = $sKey; $sDbValue = $sValue; $iExistedKey = $oDb->getOne("SELECT `ID` FROM `sys_localization_keys` WHERE `Key` = ?", [$sDbKey]); if (!$iExistedKey) { // key is missing, insert new key if (!$oDb->res("INSERT INTO `sys_localization_keys` VALUES (NULL, ?, ?)", [BX_DOL_LANGUAGE_CATEGORY_SYSTEM, $sDbKey])) { continue; } $iExistedKey = $oDb->lastId(); } $oDb->res("INSERT INTO `sys_localization_strings` VALUES(?, ?, ?)", [$iExistedKey, $iLangKey, $sDbValue]); } return true; }