public static function addLanguage($obj_Language) { $db = config::dbconfig(); $obj_retresult = new returnResult(); $obj_Language->LangId = DAL_manageLanguage::getLastLanguageId() + 1; $sql = "INSERT INTO tbl_language (LangId,LangTag,English,Sinhala,Tamil,Bangla,Nepali,Lang1,Lang2,Lang3) \n\t\tVALUES (" . common::noSqlInject($obj_Language->LangId) . "," . "'" . common::noSqlInject($obj_Language->LangTag) . "'" . "," . "'" . common::noSqlInject($obj_Language->English) . "'" . "," . "'" . common::noSqlInject($obj_Language->Sinhala) . "'" . "," . "'" . common::noSqlInject($obj_Language->Tamil) . "'" . "," . "'" . common::noSqlInject($obj_Language->Bangla) . "'" . "," . "'" . common::noSqlInject($obj_Language->Nepali) . "'" . "," . "'" . common::noSqlInject($obj_Language->Lang1) . "'" . "," . "'" . common::noSqlInject($obj_Language->Lang2) . "'" . "," . "'" . common::noSqlInject($obj_Language->Lang3) . "'" . ");"; $rs = mysql_query($sql); if (mysql_affected_rows() > 0) { $obj_retresult->type = 1; $obj_retresult->msg = "success"; $obj_retresult->data = $obj_Language; } else { $obj_retresult->type = 0; $obj_retresult->msg = "failed"; } return $obj_retresult; }
public static function isChildLanguage($LangId, $ChildLangId) { $ischild = false; $obj_retResult = DAL_manageLanguage::getLanguageListByLangId($ChildLangId); //get child node if ($obj_retResult->type == 1) { $arr_LanguageList = $obj_retResult->data; $obj_Language = $arr_LanguageList[0]; $arrParentIds = explode(",", $obj_Language->Url); foreach ($arrParentIds as $LanguageParentId) { if ($LanguageParentId == $LangId) { $ischild = true; } } } return $ischild; }
function updateLanguage($sessionkey, $appcode, $Languagedata) { $main_result = "<VPROFILERESULT>"; $main_result .= "<AUTHSTATUS>0</AUTHSTATUS>"; $userId = ValidateSession($sessionkey, $appcode); if ($userId > -1) { $main_result = "<AUTHSTATUS>1</AUTHSTATUS>"; $obj_Language = new Language(); foreach ($Userdata["[UPPERTEMPLATENAME"] as $key => $child) { switch ($key) { case "LANGID": $obj_Language->LangId = $child; break; case "LANGTAG": $obj_Language->LangTag = $child; break; case "ENGLISH": $obj_Language->English = $child; break; case "SINHALA": $obj_Language->Sinhala = $child; break; case "TAMIL": $obj_Language->Tamil = $child; break; case "BANGLA": $obj_Language->Bangla = $child; break; case "NEPALI": $obj_Language->Nepali = $child; break; case "LANG1": $obj_Language->Lang1 = $child; break; case "LANG2": $obj_Language->Lang2 = $child; break; case "LANG3": $obj_Language->Lang3 = $child; break; } } $obj_retResult_Language = DAL_manageLanguage::updateLanguage($obj_Language); if ($obj_retResult_Language->type == 1) { $main_result .= "<RESULTSTATUS>1</RESULTSTATUS>"; $main_result .= getLanguageXml($obj_retResult_Language->data); } else { $main_result .= "<RESULTSTATUS>0</RESULTSTATUS>"; } } $main_result .= "</VPROFILERESULT>"; return $main_result; }