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;
}
