function insertRegister($_values){
		
		$_langs 		= getLangs();
		while($_lang = fetch_array($_langs)){
			$_bknd_lang  = $_lang["lang"];
			$_bknd_order = $_values[$_bknd_lang]["_order"];
			$_bknd_link  = $_values[$_bknd_lang]["_link"];
		}
		$_bknd_order = strtolower($_bknd_order);
		$_bknd_lastOrder = getLastOrder($_bknd_link);
		if(is_numeric($_bknd_order) and $_bknd_order > $_bknd_lastOrder){
			$_move	= false;
		}else{//if(is_numeric($_bknd_order) and $_bknd_order > $_bknd_lastOrder){
			$_move	= true;
		}//if(is_numeric($_bknd_order) and $_bknd_order > $_bknd_lastOrder){
		if(	$_bknd_order == "last" or
			$_bknd_order == "end" or
			$_bknd_order == "fin" or
			$_bknd_order == "final" or
			$_bknd_order == "atras" or
			$_bknd_order == "ultimo" or
			$_bknd_order == ""
		){//if(	$_bknd_order == "last" 
			$_bknd_order 	= $_bknd_lastOrder;
			$_bknd_order++;
			$_bknd_order 	= $_bknd_order * -1;
			$_move				= true;
		}else if($_bknd_order == "start" or
			$_bknd_order 	== "ini" or
			$_bknd_order 	== "inicio" or
			$_bknd_order 	== "begin" or
			$_bknd_order 	== "begining" or
			$_bknd_order 	== "primero" or
			$_bknd_order 	== "adelante" or
			$_bknd_order 	== "delante" or
			$_bknd_order 	== "arranque"
		){//if(	$_bknd_order == "last" 
			$_bknd_order 	= -1;
			$_move				= true;
		}//if(	$_bknd_order == "last" 
		$_langs 		= getLangs();
		$_bknd_order = $_bknd_order * -1;
		if($_bknd_order < 1){
			$_bknd_order = $_bknd_order * -1;
		}
		while($_lang = fetch_array($_langs)){
			
			$_bknd_lang = $_lang["lang"];
			$_queryText = "INSERT INTO `".$_bknd_link."` (";
			$_queryText.= "`_order`, ";
			$_queryText.= "`_lang` ";
			$_fields 		= getFields($_bknd_link);
			$_vals			= "'".$_bknd_order."', ";
			$_vals		 .= "'".$_lang["id"]."' ";
			while($_field = fetch_array($_fields)){
				$_queryText .= ", `".$_field["field"]."`";
				$_vals			.= ", '".$_values[$_bknd_lang][$_field["field"]]."'";
			}//while($_field = fetch_array($_fields)){
			$_queryText .= ")values(";
			$_queryText .= $_vals;
			$_queryText .= ")";
			if($_move == true){
				$_queryMove  = "UPDATE `".$_bknd_link.
				$_queryMove .= "` SET `_order` = `_order` + 1 WHERE `_order` >=' ";
				$_queryMove .= $_bknd_order."'; ";
				if(multiQuery($_queryMove.$_queryText)){
					return("Ok");
				}else{
					return("Error");
				}
			}else{//if($_move == true){
				if(query($_queryText)){
					return("Ok");
				}else{
					return("Error");
				}
			}//if($_move == true){
		}//while($_lang = fetch_array($_langs)){
	}//function insertData($_bknd_link, $_bknd_order, $_values){
	
	function insertData($_bknd_link, $_bknd_order, $_values){
		$_bknd_order = strtolower($_bknd_order);
		$_bknd_lastOrder = getLastOrder($_bknd_link);
		if(is_numeric($_bknd_order) and $_bknd_order > $_bknd_lastOrder){
			$_move	= false;
		}else{//if(is_numeric($_bknd_order) and $_bknd_order > $_bknd_lastOrder){
			$_move	= true;
		}//if(is_numeric($_bknd_order) and $_bknd_order > $_bknd_lastOrder){
		if(	$_bknd_order == "last" or
			$_bknd_order == "end" or
			$_bknd_order == "fin" or
			$_bknd_order == "final" or
			$_bknd_order == "atras" or
			$_bknd_order == "ultimo" or
			$_bknd_order == ""
		){//if(	$_bknd_order == "last" 
			$_bknd_order 	= $_bknd_lastOrder;
			$_bknd_order++;
			$_bknd_order 	= $_bknd_order * -1;
			$_move				= true;
		}else if($_bknd_order == "start" or
			$_bknd_order 	== "ini" or
			$_bknd_order 	== "inicio" or
			$_bknd_order 	== "begin" or
			$_bknd_order 	== "begining" or
			$_bknd_order 	== "primero" or
			$_bknd_order 	== "adelante" or
			$_bknd_order 	== "delante" or
			$_bknd_order 	== "arranque"
		){//if(	$_bknd_order == "last" 
			$_bknd_order 	= -1;
			$_move				= true;
		}//if(	$_bknd_order == "last" 
		$_langs 		= getLangs();
		$_bknd_order = $_bknd_order * -1;
		while($_lang = fetch_array($_langs)){
			$_bknd_lang = $_lang["id"];
			
			$_queryText = "INSERT INTO `".$_bknd_link."` (";
			$_queryText.= "`_order`, ";
			$_queryText.= "`_lang` ";
			$_fields 		= getFields($_bknd_link);
			$_vals			= "'".$_bknd_order."', ";
			$_vals		 .= "'".$_bknd_lang."' ";
			while($_field = fetch_array($_fields)){
				$_queryText .= ", `".$_field["field"]."`";
				$_vals			.= ", '".$_values[$_bknd_lang][$_field["field"]]."'";
			}//while($_field = fetch_array($_fields)){
			$_queryText .= ")values(";
			$_queryText .= $_vals;
			$_queryText .= ")";
			if($_move == true){
				$_queryMove  = "UPDATE `".$_bknd_link.
				$_queryMove .= "` SET `_order` = `_order` + 1 WHERE `_order` >=' ";
				$_queryMove .= $_bknd_order."'; ";
				multiQuery($_queryMove.$_queryText);
			}else{//if($_move == true){
				query($_queryText);
			}//if($_move == true){
		}//while($_lang = fetch_array($_langs)){
	}//function insertData($_bknd_link, $_bknd_order, $_values){
	
	
	function getInfo($_data){
		$_qt		= "SELECT `_id`, `_order`, `_lang` ";
		$_qt	 .= "FROM `".$_data["link"]."` WHERE ";
		$_AND = "";
		if(isset($_data["id"]) && $_data["id"]){
			$_qt 	 .= "`_id` = '".$_data["id"]."' ";
			$_AND = " AND ";
		}else{
			$_qt 	 .= "`_order` = '".$_data["order"]."' ";
			$_AND = " AND ";
		}
		
		if(isset($_data["lockTo"]) && $_data["lockTo"]!= ""){
			//Averiguamos si existe la columna lockField en la tabla lockTo
			$qry = "SHOW COLUMNS FROM `".$_data["link"]."` LIKE '".$_data["lockField"]."'";
			$resultado = query($qry);

			// Ejecutamos si existe la columna lockField en la tabla lockTo
			if ($resultado && $resultado->num_rows > 0) {
					//Limitamos el acceso solo a los datos permitidos
					$_qt 	 .= $_AND."`".$_data["lockField"]."` = '".$_data["lockTo"]."' ";
			}
			
		}else{
			if(isset($_data["level"]) && $_data["level"]>=2){
				$_qt 	 .= $_AND."`_owner` = '".$_data["owner"]."' ";
			}
		}
		
		$_qt 	 .= "LIMIT 1;";
		
		$_count = num_rows(query($_qt));
		
		if($_count < 1){
			$_qt = "";
			$_qt	= "SELECT * ";
			$_qt .= "FROM `".$_data["link"]."` ";
				
			if($_data["level"]>1){
				$_qt .= "WHERE `_owner` = '".trim($_data["owner"])."' ";
			}
			$_qt .= "ORDER BY `_order` ASC LIMIT 1; ";
			$_count = num_rows(query($_qt));
			

			
			if($_count < 1){
				$_qt = "";
				$_qt	= "SELECT `_id`, `_order`, `_lang` ";
				$_qt .= "FROM `".$_data["link"]."` ";
				$_qt .= "ORDER BY `_order` ASC LIMIT 1; ";
			}
		}
		$_info 	= fetch_array(query($_qt));
		return($_info);		
	}

	function firstLang(){
		$_qt	= "SELECT `lang` FROM `bknd_langs` ORDER BY `order` ASC LIMIT 1";
		$_ql 	= query($_qt);
		$_ln	= fetch_array($_ql);
		//Averiguamos el lang por defecto
		$_lng = $_ln["lang"];
		return($_lng);		
	}

	function getLangs(){
		$_qt		= "SELECT `lang`, `id`, `order` FROM `bknd_langs` WHERE `id` > 0 ORDER BY `order` ASC";
		$_lng 	= query($_qt);
		return($_lng);		
	}
	
	function getLangName($_lang){
		$_query="SELECT `lang` FROM `bknd_langs` WHERE `id` = '".$_lang."' LIMIT 1";
		$_lang = fetch_array(query($_query));
		return($_lang["lang"]);
	}
	
	function getFirstLang(){
		global $_bknd_userName;
		$_query="SELECT `id` AS `lang` FROM `bknd_langs` ORDER BY `order` ASC LIMIT 1";
		$_lang = fetch_array(query($_query));
		return($_lang["lang"]);
	}	

	function getLangId($_lang){
		$_query="SELECT `id` FROM `bknd_langs` WHERE `lang` = '".$_lang."' LIMIT 1";
		$_lang = fetch_array(query($_query));
		return($_lang["id"]);
	}	

	function getLang($_lang){
		
		if(isset($_lang) && $_lang != ""){
			if(is_numeric($_lang)){
				$_query="SELECT `lang` FROM `bknd_langs` WHERE `order` = '".$_lang."' LIMIT 1";
			}else{
				$_query="SELECT `id` AS `lang` FROM `bknd_langs` WHERE `lang` = '".$_lang."' LIMIT 1";
			}
			$_lang = fetch_array(query($_query));
		}else{
			$_query="SELECT `id` AS `lang` FROM `bknd_langs` ORDER BY `id` ASC LIMIT 1";
			$_lang = fetch_array(query($_query));
		}	
		
		return($_lang["lang"]);
	}
	
	function getFirstId($_data){
		if(!is_numeric($_data["lang"])){
			$_lang = getLang($_data["lang"]);
		}
		$_queryText  = "SELECT 		`_id` FROM `".$_data["link"]."` ";
		$_queryText .= "ORDER BY	`_order` ASC ";
		$_queryText .= "LIMIT 		1";
		$_firstId 	 = fetch_array(query($_queryText));
		return($_firstId["_id"]);
	}

	function getFirstLink(){
		global $_bknd_admin;
		global $_bknd_userName;
		global $_bknd_user_name;
		
		$_queryText = "
		SELECT 		`bknd_links`.`link` AS `Link`, 
							`bknd_permisos`.`Link` 	AS `idRelated`,
							`bknd_permisos`.`Link` 	AS `linkId`,
							`bknd_permisos`.`view`,
							`bknd_permisos`.`alta`,
							`bknd_permisos`.`baja`,
							`bknd_permisos`.`modificacion` 
		FROM 			`bknd_links` 
		LEFT JOIN `bknd_permisos`
		ON				`bknd_links`.`id`					= `bknd_permisos`.`link` 
		WHERE			`bknd_links`.`order`			> 0 ";
		if($_bknd_userName){
			$_queryText .= "
					AND `bknd_permisos`.`userName` = '".$_bknd_userName."' 
					AND `modificacion` = '1' ";
		}
		$_queryText .= "
		ORDER BY	`bknd_links`.`order`		ASC
		LIMIT 		1";
		$_firstLink = fetch_array(query($_queryText));
		if(!isset($_firstLink["Link"])){$_firstLink["Link"]="";}
		return($_firstLink["Link"]);
	}

	function editInfo($_data){
		global $_LANG;
		global $_BACKEND;
		$_editInfo = array();
		if(!$_data["link"]){
			global $_bknd_userName;
			$_queryText = "
			SELECT 		`bknd_links`.`link` AS `Link`, 
								`bknd_permisos`.`Link` 	AS `idRelated`,
								`bknd_permisos`.`Link` 	AS `linkId`,
								`bknd_permisos`.`view`,
								`bknd_permisos`.`alta`,
								`bknd_permisos`.`baja`,
								`bknd_permisos`.`modificacion` 
			FROM 			`bknd_links` 
			LEFT JOIN `bknd_permisos`
			ON				`bknd_links`.`id`					= `bknd_permisos`.`link` 
			WHERE 		`bknd_permisos`.`userName` 		= '".$_bknd_userName."' AND 
								`view` 										= '1' AND
								 `bknd_links`.`order`			> 0
			ORDER BY	`bknd_links`.`order`		ASC
			LIMIT 		1";

			$_firstLink = fetch_array(query($_queryText));
			$_data["link"] = $_firstLink["Link"];
			foreach($_LANG as $_lg){ 
				$_editLink[$_lg]["link"] = $_firstLink["Link"];
			}
		}else{
			foreach($_LANG as $_lg){
				$_editLink[$_lg]["link"] = $_data["link"];
			}
		}
		if(!$_data["id"]){
			$_queryText  = "SELECT `".$_data["link"]."`.`_id` AS `_id`, ";
			$_queryText .= "`".$_BACKEND["link"]."`.`_order` AS `_order`, ";
			$_queryText .= "`bknd_langs`.`lang` AS `_lang` ";
			$_queryText .= "FROM `".$_data["link"]."`";
			$_queryText .= "LEFT JOIN `bknd_langs` ";
			$_queryText .= "ON `".$_data["link"]."`.`_lang` = `bknd_langs`.`id` ";
			$_queryText .= "WHERE `".$_data["link"]."`.`_order` = 1;";
			
			$_query 		 = query($_queryText);
			while($_id = fetch_array($_query)){
				foreach($_LANG as $_lg){
					$_editLink[$_lg]["id"] = $_id["_id"];
					$_editLink[$_lg]["order"] = $_id["_order"];
				}
			}
			
		}else{
			$_queryText  = "SELECT `_order` FROM `".$_BACKEND["link"]."` ";
			$_queryText .= "WHERE `_id` = '".$_data["id"]."' LIMIT 1; ";
			
			$_order = fetch_array(query($_queryText));
			$_order = $_order["_order"];
			$_queryText  = "SELECT `".$_BACKEND["link"]."`.`_id` AS `_id`, ";
			$_queryText .= "`".$_BACKEND["link"]."`.`_order` AS `_order`, ";
			$_queryText .= "`bknd_langs`.`lang` AS `_lang` ";
			$_queryText .= "FROM `".$_BACKEND["link"]."`";
			$_queryText .= "LEFT JOIN `bknd_langs` ";
			$_queryText .= "ON `".$_BACKEND["link"]."`.`_lang` = `bknd_langs`.`id` ";
			$_queryText .= "WHERE `".$_BACKEND["link"]."`.`_order` = '".$_order."';";
			$_query 		 = query($_queryText);
			while($_id = fetch_array($_query)){
				foreach($_LANG as $_lg){
					$_editLink[$_lg]["id"] = $_id["_id"];
					$_editLink[$_lg]["order"] = $_id["_order"];
				}
			}
		}
		return($_editLink);
	}
	
	$_dlng = fetch_array(getLangs());
	$_bknd_default_lang = $_dlng["lang"];
	$_bknd_lang = $_dlng["lang"];
	
	function getLastOrder($_bknd_link){
		$_queryText = "SELECT `_order` FROM `".$_bknd_link."` ORDER BY `_order` DESC LIMIT 1";
		$_order			= fetch_array(query($_queryText));
		return($_order["_order"]);
	}
	
	function getRegister($_bknd_link, $_bknd_order){
		//Buscamos los fields para este link y order
		$_qryText = "
		SELECT		`fieldsConfig`.*,
							`fieldsConfig`.`id` AS `_id`,
							`fieldsConfig`.`name` AS `_field`,
							`fieldsConfig`.`lang` AS `_lang`, 
							`registersList`.`value` AS `_link` 
		FROM 			`fieldsConfig` 
		LEFT JOIN `registersList`
		ON 				`fieldsConfig`.`idRelated` = `registersList`.`id`
		WHERE 		`registersList`.`value` = '".$_bknd_link."' AND
							`fieldsConfig`.`dataOrder` = '".$_bknd_order."'
		ORDER BY	`fieldsConfig`.`lang`	ASC, 
							`fieldsConfig`.`order` ASC";
		$_fieldsData = query($_qryText);
		return($_fieldsData);
	}
	
	function getPermisos($_user){
		$_queryText  = "SELECT ";
		$_queryText .= "`bknd_links`.`link`, ";
		$_queryText .= "`bknd_links`.`id`, ";
		$_queryText .= "`bknd_permisos`.`id` AS `permisoId`, ";
		$_queryText .= "`bknd_permisos`.`view`, ";
		$_queryText .= "`bknd_permisos`.`alta`, ";
		$_queryText .= "`bknd_permisos`.`baja`, ";
		$_queryText .= "`bknd_permisos`.`modificacion` ";
		$_queryText .= "FROM 			`bknd_links` ";
		$_queryText .= "LEFT JOIN `bknd_permisos` ";
		$_queryText .= "ON 				`bknd_links`.`id` = `bknd_permisos`.`link` ";
		$_queryText .= "WHERE 		`bknd_permisos`.`userName` = '".$_user."' ";
		$_queryText .= "ORDER BY  `bknd_links`.`link` ASC";
		$_query 		 = query($_queryText);
		$_permisos 	 = array(); 
		while($_link = fetch_array($_query)){
			$_permisos[$_link["link"]]["link"] 					= $_link["id"];
			$_permisos[$_link["link"]]["permisoId"] 		= $_link["permisoId"];
			$_permisos[$_link["link"]]["view"] 					= $_link["view"];
			$_permisos[$_link["link"]]["alta"] 					= $_link["alta"];
			$_permisos[$_link["link"]]["baja"] 					= $_link["baja"];
			$_permisos[$_link["link"]]["modificacion"] 	= $_link["modificacion"];
		}
		return($_permisos);
	}
	
	function getPermisosFor($_user){
		$_queryText  = "SELECT ";
		$_queryText .= "`bknd_links`.`link` AS `Link`, ";
		$_queryText .= "`bknd_links`.`id`, ";
		$_queryText .= "`bknd_permisos`.`id` AS `permisoId`, ";
		$_queryText .= "`bknd_permisos`.`view`, ";
		$_queryText .= "`bknd_permisos`.`alta`, ";
		$_queryText .= "`bknd_permisos`.`baja`, ";
		$_queryText .= "`bknd_permisos`.`modificacion` ";
		$_queryText .= "FROM 			`bknd_links` ";
		$_queryText .= "LEFT JOIN `bknd_permisos` ";
		$_queryText .= "ON 				`bknd_links`.`id` = `bknd_permisos`.`link` ";
		$_queryText .= "WHERE 		`bknd_permisos`.`userName` = '".$_user["email"]."' ";
		$_queryText .= "AND 			`bknd_links`.`link` = '".$_user["link"]."' ";
		$_queryText .= "LIMIT 1";
		$_query 		 = query($_queryText);
		$_permisos 	 = array(); 
		while($_link = fetch_array($_query)){
			$_permisos["id"]						= $_link["id"];
			$_permisos["link"]					= $_link["Link"];
			$_permisos["view"] 					= $_link["view"];
			$_permisos["alta"] 					= $_link["alta"];
			$_permisos["baja"] 					= $_link["baja"];
			$_permisos["modificacion"] 	= $_link["modificacion"];
		}
		return($_permisos);
	}
	
	function getLinks(){
		$_queryText = "SELECT `link`, `id` FROM `bknd_links` WHERE `id` > 0 ORDER BY `link` ASC";
		$_link = query($_queryText);
		return($_link);
	}
	
	function getSpecialLinks(){
		$_queryText = "SELECT `link`, `id` FROM `bknd_links` WHERE `id` < 1 ORDER BY `link` ASC";
		$_link = query($_queryText);
		return($_link);
	}
	
	function getLink($_bknd_link){
		if(is_numeric($_bknd_link)){
			$_queryText = "SELECT `link` AS `link` FROM `bknd_links` WHERE `id` = '".$_bknd_link."' LIMIT 1";
		}else{
			$_queryText = "SELECT `id` AS `link` FROM `bknd_links` WHERE `link` = '".$_bknd_link."' LIMIT 1";
		}
		$_link = fetch_array(query($_queryText));
		if(!isset($_link["link"])){$_link["link"] = "";}
		return($_link["link"]);
	}

	function firstField($_bknd_link){
		$queryText = "
			SELECT 	`field`
			FROM 		`bknd_fields`
			WHERE 	`link` 	= '".getLink($_bknd_link)."' AND
							`order` = 1 
			LIMIT 	1";
		$_field	= fetch_array(query($queryText));
		return($_field["field"]);
	}

	function getField($_bknd_link, $_bknd_field){
		
		$queryText = "
			SELECT 	*
			FROM 		`".$_bknd_link."`
			WHERE 	`field` = '".$_bknd_field."' 
			LIMIT 	1";
		$query	= fetch_array(query($queryText));
		return($query);
	}

	function getFields($_bknd_link){
		if(!is_numeric($_bknd_link)){
			$_bknd_link = getLink($_bknd_link);
		}
		$queryText = "
			SELECT 		*
			FROM 			`bknd_fields`
			WHERE			`link` = '".$_bknd_link."'
			ORDER BY 	`order` ASC";
		
		$query	= query($queryText);
		
		return($query);
	}
	
	function findField($_data) {
    $fields = getFields($_data["link"]);

    foreach ($fields as $row) {
        // Asegúrate de que estás comparando contra la columna correcta. Aquí usamos 'nombre' como ejemplo.
        
				if (isset($row['field']) && 
						strcasecmp($row['field'], $_data["field"]) === 0) {
            return true;
        } 
    }	
    return false;
	}

	function getFieldsNames($_bknd_link){
		
		$_queryText = "DESCRIBE `".$_bknd_link."`";
		$_query	= query($_queryText);
		$_ARRAY = array();
		$_ID		= 0;
		while($_FIELD = fetch_array($_query)){
			$_ARRAY[$_ID]  = $_FIELD['Field'];
			$_ID++;
		}
		return($_ARRAY);
	}
	function linkExist($_link){ 
		if(isset($_link) && $_link != ""){
			$_queryText  = "SELECT `id` FROM `bknd_links` WHERE ";
			$_queryText .= "`link` = '".$_link."' LIMIT 1; ";
			$_link = fetch_array(query($_queryText));
			if(isset($_link["id"]) && $_link["id"] != "" ){
				return("true");
			}else{
				return("false");
			}
		}else{
			return("false");
		}
	}
	function asignValues($_data){
		if(isset($_data["_link"])){
			$_queryText = "DESCRIBE `".$_data["_link"]."`";
			$_query	= query($_queryText);
			$_ARRAY = array();
			$_ID		= 0;
			while($_FIELD = fetch_array($_query)){
				$_ARRAY[$_ID]  = $_FIELD['Field'];
				$_ID++;
			}
			foreach($_ARRAY as $_KEY){
				if(!isset($_data[$_KEY])){
					$_data[$_KEY] = "";
				}
			}
		}
		return($_data);
	}
	function valsNotNull($_data){
		if(isset($_data["_link"])){
			$_queryText = "DESCRIBE `".$_data["_link"]."`";
			$_query	= query($_queryText);
			$_ARRAY = array();
			$_ID		= 0;
			while($_FIELD = fetch_array($_query)){
				$_ARRAY[$_ID]  = $_FIELD['Field'];
				$_ID++;
			}
			foreach($_ARRAY as $_KEY){
				if(!isset($_data[$_KEY])){
					$_data[$_KEY] = "";
				}
			}
		}
		return($_data);
	}

	function getRow($_bknd){
		
		if(!is_numeric($_bknd["lang"])){
			$_lang = $_bknd["lang"];
			$_bknd["lang"] = getlang($_bknd["lang"]);
		}else{
			$_lang = getlang($_bknd["lang"]);
		}
		if(isset($_bknd["id"]) && $_bknd["id"] != ""){
			//$_lang = getlang($_bknd["lang"]);
			$queryText = "
				SELECT * 
				FROM `".$_bknd["link"]."`
				WHERE
					`_id` = '".$_bknd["id"]."'
				LIMIT 1
					";
				$_validLang = fetch_array(query($queryText));
				if($_bknd["lang"] != $_validLang["_lang"]){
					$queryText = "
						SELECT `_id` 
						FROM `".$_bknd["link"]."`
						WHERE
							`_order` = '".$_validLang["_order"]."' AND 
							`_lang` = '".$_bknd["lang"]."'
						LIMIT 1
							";
					$_validId = fetch_array(query($queryText));
					$queryText = "
						SELECT * 
						FROM `".$_bknd["link"]."`
						WHERE
							`_id` = '".$_validId["_id"]."'
						LIMIT 1
							";
				}
		}else{
			//$_lang = getlang($_bknd["lang"]);
			$queryText = "
				SELECT * 
				FROM `".$_bknd["link"]."`
				WHERE
					`_order` = '".$_bknd["order"]."' AND 
					`_lang` = '".$_bknd["lang"]."'
				LIMIT 1
					";
		}
		$_bknd_data = array();
		$query	= query($queryText);
		$_data = fetch_array($query);
		if(num_rows(query($queryText))<1){
			
			//No existe el registro para el idioma indicado, insertamos el registro en blanco
			$_nextId = fetch_array(query("SELECT `_id` FROM `".$_bknd["link"]."` ORDER BY `_id` DESC LIMIT 1;"));
			$_nextId = $_nextId["_id"];
			$_nextId++;
			$_creation = date("Y-m-d H:i:s");
			
			$_qText  = "INSERT INTO `".$_bknd["link"]."`";
			$_qText .= "(";
			$_qText .= "`_id`, ";
			$_qText .= "`_order`, ";
			$_qText .= "`_lang`, ";
			$_qText .= "`_creation`, ";
			$_qText .= "`_update`, ";
			$_qText .= "`_owner`";
			$_qText .= ")values( ";
			$_qText .= "'".$_nextId."', ";
			$_qText .= "'".$_bknd["order"]."', ";
			$_qText .= "'".$_bknd["lang"]."', ";
			$_qText .= "'".$_creation."', ";
			$_qText .= "'".$_creation."', ";
			$_qText .= "'".$_bknd["owner"]."')";
			query($_qText);
			$_bknd_data[$_lang]['_id'] 		= $_nextId;
			$_bknd_data[$_lang]['_order'] = $_bknd["order"];
			$_bknd_data[$_lang]['_lang'] 	= $_lang;
			
			
		}else{
			$_bknd_data[$_lang] = $_data;
		}
		return($_bknd_data);
	}	
	
	function imageInsert($_news){
		$_TXT = $_news["_TXT"];
		if(isset($_TXT) && $_TXT != ""){
			// Expresión regular para encontrar el contenido dentro de {}
			$_patron = '/\{(.*?)\}/';
			// Buscar todas las coincidencias y guardarlas en un array
			preg_match_all($_patron, $_TXT, $_coincidencias);
			$_IMGS = $_coincidencias[1];
			// Reemplazar cada coincidencia con la etiqueta img
			foreach ($_IMGS as $_X => $_DATA) {
				if(isset($_DATA) && $_DATA != ""){
					$_ARRAY  = explode(")",$_DATA);
				}
				$_INDEX = 1;
				$_IMG = array();
				
				while(isset($_ARRAY[$_INDEX]) && $_ARRAY[1] != ""){
					$_ITEM = explode("(", $_ARRAY[$_INDEX]);
					if(isset($_ITEM[0]) && $_ITEM[0] != "" &&
						 isset($_ITEM[1]) && $_ITEM[1] != ""){
						$_IMG[strtoupper($_ITEM[0])] =  $_ITEM[1];
						
						
					}	
					$_INDEX++;
				}
				if(isset($_ARRAY[0]) && $_ARRAY[0] != ""){
					$_IMGARRAY = explode("(", $_ARRAY[0]);
				}
				if(isset($_IMGARRAY[1]) && $_IMGARRAY[1] != ""){
					$_IMGINDEX = explode(")", $_IMGARRAY[1]);
				}
				if(isset($_IMGINDEX[0]) && $_IMGINDEX[0] != ""){
					$_IMGSIZE	= explode("[", $_IMGINDEX[0]);
					if(isset($_IMGSIZE[1]) && $_IMGSIZE[1] != ""){
						$_IMGSIZE = intval(str_replace("]", "", $_IMGSIZE[1]));
						if(isset($_IMGSIZE) && $_IMGSIZE != ""){
							if($_IMGSIZE < 1 or $_IMGSIZE > 12){
								$_IMGSIZE = "5";
							}
						}else{
							$_IMGSIZE = "5";
						}
					}else{
						$_IMGSIZE = "5";
					}
					$_IMGINDEX = intval($_IMGINDEX[0]);
					$_IMGINDEX--;
					if($_IMGINDEX<0){$_IMGINDEX = 0;}
				}else{
					$_IMGINDEX = 0;	
				}
				if(isset($_IMGARRAY[0]) &&
					 $_IMGARRAY[0] != "" &&
					 isset($_news[$_IMGARRAY[0]]) && 
					 $_news[$_IMGARRAY[0]] != ""){
					$_IMGSRC = explode(",", $_news[$_IMGARRAY[0]]);
					$_IMG["SRC"] = $_IMGSRC[$_IMGINDEX];
				}
				
				if(isset($_IMG["FLOAT"]) && $_IMG["FLOAT"]!= ""){
					$_IMG["FLOAT"] = strtolower($_IMG["FLOAT"]);
					if($_IMG["FLOAT"] == "left"){
						$_IMG["FLOAT"] = "mr-lg-4 mb-lg-4 float-".$_IMG["FLOAT"];	
					}else if($_IMG["FLOAT"] == "right"){
						$_IMG["FLOAT"] = "ml-lg-4 mb-lg-4 float-".$_IMG["FLOAT"];
					}else{
						$_IMG["FLOAT"] = "m-lg-4 float-".$_IMG["FLOAT"];
					}
				}
				if(isset($_IMG["SIZE"]) && $_IMG["SIZE"]!= ""){
					$_IMG["SIZE"] = intval($_IMG["SIZE"]);
				}
				if(!isset($_IMG["SIZE"]) or 
					 isset($_IMG["SIZE"]) && $_IMG["SIZE"] == "" or
					 isset($_IMG["SIZE"]) && 
					 ($_IMG["SIZE"] < 1 or $_IMG["SIZE"] > 12)){
					$_IMG["SIZE"] = 5;
				}
				$_IMAGE  = "<div class='col-12 col-lg-".$_IMG["SIZE"]." p-0 pr-0 text-left align-top ".$_IMG["FLOAT"]."'>";
				$_IMAGE .= "<img ";
				$_IMAGE .= "src='".$_IMG["SRC"]."' ";
				$_IMAGE .= "width='100%' >";
				
				if(isset($_IMG["EPIGRAFE"]) && $_IMG["EPIGRAFE"] != ""){
					$_IMAGE .= "<span class='h4 text-dark'><p>";
					$_IMAGE .= $_IMG["EPIGRAFE"];
					$_IMAGE .= "<p></span>";
				}
				$_IMAGE .= "</div>";
				if(isset($_DATA) && $_DATA != "" &&
					 isset($_IMAGE) && $_IMAGE != "" &&
					 isset($_TXT) && $_TXT != "" ){
					$_TXT = str_replace("{{$_DATA}}", $_IMAGE, $_TXT);
				}
			}
		}
		return($_TXT);
	}

	function getRows($_bknd){
		$_lngQuery 	= getLangs();
		$_bknd_data = array();
		while($_lng = fetch_array($_lngQuery)){
			$queryText = "
				SELECT 	* 
				FROM 		`".$_bknd["link"]."`
				WHERE 	`_order` 	= '".$_bknd["order"]."' AND 
								`_lang`		= '".$_lng["id"]."' ";
			$query	= fetch_array(query($queryText));
			if(num_rows(query($queryText))>0){
				$_bknd_data[$_lng["lang"]] = $query;
			}else{
				$_bknd_data[$_lng["lang"]] = "";
			}
		}
		return($_bknd_data);
	}
	
	function getFiles($_bknd_link, $_bknd_field, $_bknd_order){
		$queryText = "
			SELECT 	`".$_bknd_field."`,
							`_lang`  
			FROM 		`".$_bknd_link."`		 
			WHERE		`_order`	= '".$_bknd_order."'";
		$_imgQuery = query($queryText);
		$_img_array = array();
		while($_imgList = fetch_array($_imgQuery)){
			$_img = $_imgList[$_bknd_field];
			$_explode=explode(",", $_img);
			$_id = 0;
			foreach($_explode as $_item){
				$_img_array[$_imgList["_lang"]][$_id] = $_item;
				$_id++;
			}//foreach($_explode as $_item){
		}//while($_imgList = fetch_array($_imgQuery)){
		return ($_img_array);		
	}
	
	function getFile($_bknd_link, $_bknd_order, $_bknd_field){
		$queryText = "
			SELECT 	`".$_bknd_field."`,
							`_lang`  
			FROM 		`".$_bknd_link."`		 
			WHERE		`_order`	= '".$_bknd_order."';";
		
		$_imgQuery = query($queryText);
		$_img_array = array();
		while($_img = fetch_array($_imgQuery)){
			
			$_imageLang = getLang($_img["_lang"]);
			$_imageList = explode(",", $_img[$_bknd_field]);
			$_imgId=0;
			foreach($_imageList as $_imgageItem){
				$_imgId++;
				$_img_array[$_imageLang][$_imgId] = $_imgageItem;
			}
		}
		return ($_img_array);		
	}
	
	function getSpecificFile($_bknd_link, $_bknd_order, $_bknd_field, $_bknd_lang, $_bknd_id){
		$_bknd_id--;
		if($_bknd_id<0){
			$_bknd_id = 0;
		}
		if(!is_numeric($_bknd_lang)){
			$_bknd_lang = getLang($_bknd_lang);
		}
		$queryText = "
			SELECT 	`".$_bknd_field."`,
							`_lang`  
			FROM 		`".$_bknd_link."`		 
			WHERE		`_order`	= '".$_bknd_order."' AND `_lang` = '".$_bknd_lang."' LIMIT 1;";
		$_imgQuery = query($queryText);
		$_img = fetch_array($_imgQuery);
		$_img = explode(",", $_img[$_bknd_field]);
		return ($_img[$_bknd_id]);		
	}
	
	function getLangImg($_files, $_lang, $_order){
		if(isset($_lang)){
			if(is_numeric($_lang)){
				$_lang = getLang($_lang);
			}
			return($_lang."///".$_files[$_lang]);
			$_files = explode(",", $_files[$_lang]);
			$_order--;
			if($_order<0){
				$_order = 0;
			}
			return($_files[$_order]);
		}else{
			return(0);
		}
	}//function getImg($_files, $_order){
			
	function getImg($_files, $_order){
		if(isset($_files) && $_files != "" && 
			 isset($_order) && $_order != ""){
			$_files = explode(",", $_files);
			$_order--;
			if($_order<0){
				$_order = 0;
			}
			return($_files[$_order]);
		}else{
			return("");
		}
	}//function getImg($_files, $_order){
	

	function getFileById($_bknd_link, $_bknd_order, $_bknd_field, $_bknd_id){
		$_bknd_id--;
		if($_bknd_id<0){$_bknd_id=0;}
		$queryText = "
			SELECT 	`".$_bknd_field."`,
							`_lang`  
			FROM 		`".$_bknd_link."`		 
			WHERE		`_order`	= '".$_bknd_order."';";
		if(isset($_GET["debug"]) && $_GET["debug"]=="true"){
			echo $queryText;
		}
		$_imgQuery = query($queryText);
		$_img_array = array();
		while($_img = fetch_array($_imgQuery)){
			if(isset($_GET["debug"]) && $_GET["debug"] == "true"){
				echo "LANG: ".getLang($_img["_lang"])." (".$_img["_lang"].")."." /// ";
			}
			$_imageLang = getLang($_img["_lang"]);
			$_imageList = explode(",", $_img[$_bknd_field]);
			$_img_array[$_imageLang] = $_imageList[$_bknd_id];
		}
		return ($_img_array);	
	}

	function getFileByLang($_bknd_link, $_bknd_order, $_bknd_lang, $_bknd_field, $_bknd_img){
		if(!is_numeric($_bknd_lang)){
			$_bknd_lang = getLang($_bknd_lang);
		}
		$queryText = "
			SELECT 	`".$_bknd_field."`,
							`_lang`  
			FROM 		`".$_bknd_link."`		 
			WHERE		`_order`	= '".$_bknd_order."' AND `_lang` = '".$_bknd_lang."' LIMIT 1;";
		
		$_imgQuery = query($queryText);
		$_img_array = array();
		$_img = fetch_array($_imgQuery);
		$_img = explode(",", $_img[$_bknd_field]);
		$_bknd_img--;
		return ($_img[$_bknd_img]);		
	}
	
	function pivot($_table, $_lang){
		if(!is_numeric($_lang)){
			$_lang = getLang($_lang);
		}
		$_queryText = "SELECT * FROM `".$_table."` WHERE `_lang` = '".$_lang."' ";
		return($_queryText);
	}//function pivot($_table, $_lang){
		
	
	function select($_table, $_lang){
		if(!is_numeric($_lang)){
			$_lang = getLang($_lang);
		}
		$_queryText = "SELECT * FROM `".$_table."` WHERE `_lang` = '".$_lang."' ";
		return($_queryText);
	}//function pivot($_table, $_lang){
	
	
	function get($_data){
		if(!is_numeric($_data["lang"])){
			$_data["lang"] = getLang($_data["lang"]);
		}
		$_queryText = "SELECT * FROM `".$_data["table"]."` WHERE `_lang` = '".$_data["lang"]."' ";
		if($_data["query"]){
			$_queryText .= "AND ".$_data["query"]." ";
		}
		if($_data["sort"]){
			$_queryText .= "SORT BY ".$_data["sort"]." ";
		}
		if($_data["limit"]){
			$_queryText .= "LIMIT ".$_data["limit"]." ";
		}
		$_queryText = str_replace("AND AND", "AND", $_queryText);
		return(query($_queryText));
	}//function pivot($_table, $_lang){
	
	function burbuja($array){
    for($i=1;$i<count($array);$i++)
    {
        for($j=0;$j<count($array)-$i;$j++)
        {
            if($array[$j]>$array[$j+1])
            {
                $k=$array[$j+1];
                $array[$j+1]=$array[$j];
                $array[$j]=$k;
            }
        }
    }
 
    return $array;
	}
		
	function arrangeImages($_images){
		$_index = array("Banner XL", "Banner LG", "Banner MD", "Banner SM", "Banner XS");
		$_images = explode(",", $_images);
		$_id=0;
		foreach($_images as $_img) {
			$_banners[$_index[$_id]] = $_img;
			$_imgX = $_img;	
			$_id++;
		}//foreach ($_image as $_img) {
		if($_id<6){
			while($_id<6){
				$_banners[$_index[$_id]] = $_imgX;
				$_id++;
			}
		}
		return($_banners);
	}

	function getTags($_tags){
		$_tags = str_replace(", ", ",", $_tags);
		$_tags = str_replace(", ", ",", $_tags);
		$_tags = str_replace("#", ",#", $_tags);
		$_tags = str_replace(",,", ",", $_tags);
		$_tags = str_replace(",", "", $_tags);
		$_tags = explode("#", $_tags);
		return($_tags);
	}

	function totalRows($_link){
		return(num_rows(query("SELECT `_id` FROM `".$_link."`")));
		
	}

	function getData($_link, $_order, $_lang, $_field){
		if(!is_numeric($_lang)){
			$_lang = getLang($_lang);
		}
		$_data=fetch_array(query("SELECT `".$_field."` FROM `".$_link."` WHERE `_order` = '".$_order."' AND `_lang` = '".$_lang."' LIMIT 1"));
		return($_data[$_field]);
	}

	function getImage($_files, $_order){
		$_files = explode(",", $_files);
		$_order--;
		if($_order<0){
			$_order = 0;
		}
		return($_files[$_order]);
	}//function getImage($_files, $_order){
	
		
	function getId($_link, $_lang, $_order){
		if(!is_numeric($_lang)){
			$_lang = getLang($_lang);
		}
		$_id = fetch_array(query("SELECT `_id` FROM `".$_link."` WHERE `_order` = '".$_order."' AND `_lang` = '".$_lang."' LIMIT 1"));
		$_id = $_id["_id"];
		return($_id);
	}
	
	function insert($_data){
		if(!$_data["_lang"]){
			$_data["_lang"] = getLang();
		}
		if(!is_numeric($_data["_lang"])){
			$_data["_lang"] = getLang($_data["_lang"]);
		}
		$_insert 	= "";
		if($_data["_order"]<0){
			$_data["_order"] = 0;
		}//if($_data["_order"]<1){
		if(	$_data["_order"] = '0'){
			//Averiguamos el last order
			$_sel = select($_data["bknd_link"])." ORDER BY `_order` DESC LIMIT 1";
			$_ord	= fetch_array(query($_sel));
			$_data["_order"] = $_ord["_order"];
			$_data["_order"]++;
		}//if(	$_data["_order"] = '+' 			or
		if($_data["_order"]>0){
			$_insert .= "UPDATE `".$_data["bknd_link"]."` SET ";
			$_insert .= "`_order` = `_order`+1 ";
			$_insert .= "WHERE `_order` >= ".$_data["_order"];
		}
		
		$_insert .= "INSERT INTO `".$_data["bknd_link"]."` (";
		$_coma	  = "";
		$_values  = "";
		foreach($_data as $_key => $_val){
			if(	$_key != "_id"	&&
					$_key != "bknd_link"){
				$_insert .= $_coma."`".$_key."`";
				$_values .= $_coma."'".$_val."'";
				$_coma    = ", ";
			}
		}//foreach($_data as $_key => $_val){
		$_insert .= ")VALUES(";
		$_insert .= $_values;
		$_insert .= "); ";
		if($_data["_order"]>0){
			multiQuery($_insert);
		}else{
			query($_insert);
		}
	}//function insertUsuario($_data){

	function getOrder($_data){
		$_queryText = "SELECT `_order` FROM `".$_data["Link"]."` WHERE `_id` = '".$_data["Id"]."' LIMIT 1;";
		$_order = fetch_array(query($_queryText));
		return($_order["_order"]);
	}

	function mysql_insert($_BACKEND){
		
		//Inicializamos el multiquery moviendo los registros para hacer lugar al insert
		$_multiQueryText 	 = "UPDATE `".$_BACKEND["link"]."` SET ";
		$_multiQueryText 	.= "`_order` = `_order` +1 ";
		$_multiQueryText 	.= "WHERE `_order` >= '".$_BACKEND["insert"]."'; ";
		//echo __FILE__." -> ".__LINE__.": <br />".$_multiQueryText."<br /><br />";
		
		//Averiguamos el next _id
		$_queryText	 = "SELECT AUTO_INCREMENT ";
		$_queryText	.= "FROM information_schema.tables ";
		$_queryText	.= "WHERE table_name = '".$_BACKEND["link"]."'";
		
		$_nextId		 = fetch_array(query($_queryText));
		$_nextId 		 = $_nextId["AUTO_INCREMENT"];
		
		
		$_queryText	 = "SELECT `_id` ";
		$_queryText	.= "FROM `".$_BACKEND["link"]."` ORDER BY `_id` DESC LIMIT 1;";
		
		//echo __FILE__." -> ".__LINE__.": <br />".$_queryText."<br /><br />";
		
		$_nextId		 = fetch_array(query($_queryText));
		$_nextId 		 = $_nextId["_id"];
		$_nextId++;
		
		//echo __FILE__." -> ".__LINE__.": <br />".$_nextId."<br /><br />";
		//Le restamos 1 al next ID para poder sumarle luego en el loop
		$_nextId--;
		
		//Seleccionamos los langs
		$_queryText 	= "SELECT `id` FROM `bknd_langs` ORDER BY `id` DESC;";
		$_queryLangs	= query($_queryText);
		
		//Iteramos los langs
		while($_lang = fetch_array($_queryLangs)){
			//Generamos el next Id
			$_nextId++;
			
			
			if($_BACKEND["lockTo"]!="" && 
				 $_BACKEND["lockField"]!=""){
				//averiguamos si existe el field en la tabla
				
				$_lockTo = fetch_array(query("SELECT COLUMN_NAME
				FROM INFORMATION_SCHEMA.COLUMNS
				WHERE TABLE_NAME = '".$_BACKEND["link"]."'
				AND COLUMN_NAME = '".$_BACKEND["lockField"]."';"));
				if(isset($_lockTo["COLUMN_NAME"]) && $_lockTo["COLUMN_NAME"] == $_BACKEND["lockField"]){
					$_lockTo = "Si";
				}else{
					$_lockTo = "No";
				}
			}
			
			//Generamos el QUERY INSERT para el LANG que iteramos
			$_multiQueryText .= "INSERT INTO `".$_BACKEND["link"]."`(";
			$_multiQueryText .= "`_id`, ";
			$_multiQueryText .= "`_order`, ";
			$_multiQueryText .= "`_creation`, ";
			$_multiQueryText .= "`_update`, ";
			$_multiQueryText .= "`_owner`, ";
			if(isset($_lockTo) && $_lockTo == "Si"){
				$_multiQueryText .= "`".$_BACKEND["lockField"]."`, ";
			}
			$_multiQueryText .= "`_lang` ";
			
			$_multiQueryText .= ") VALUES (";
			$_multiQueryText .= "'".$_nextId."', ";
			$_multiQueryText .= "'".$_BACKEND["insert"]."', ";
			$_multiQueryText .= "'".date("Y-m-d H:i:s")."', ";
			$_multiQueryText .= "'".date("Y-m-d H:i:s")."', ";
			$_multiQueryText .= "'".$_BACKEND["owner"]."', ";
			if(isset($_lockTo) && $_lockTo == "Si"){
				$_multiQueryText .= "'".$_BACKEND["lockTo"]."', ";
			}
			$_multiQueryText .= "'".$_lang["id"]."'); ";
			
		}
		//echo __FILE__." -> ".__LINE__.": <br />".$_multiQueryText."<br /><br />";
		//Ejecutamos el MultiQuery de inserción
		multiQuery($_multiQueryText);
		
		//echo __FILE__." -> ".__LINE__.": <br />LISTO<br /><br />";
		//Retornamos el ID del último INSERT que es el primer LANG para la TABLA
		return($_nextId);
	}
?>