';
// R20: hem de parar idiomes fora del domini .es/fr
$lang_idioma = 0; //RUBEN16: lang no està en la URL
$idiomes = Get_Idiomes();
$l = $_SESSION["pais"]["pai_lang"]; //RUBEN16: llenguatge per defecte en el país, definit a la taula
$sql = mysqli_query($conn, "SELECT * FROM GFR_langs l WHERE lng_activar = 'S' AND lng_codi = '$l' ORDER BY lng_orden");
$sql2=mysqli_fetch_array($sql);
$_SESSION['lng'] = $sql2["lng_codi"];
$lng = $_SESSION['lng'];
if(isset($_REQUEST['lang'])){
$sql = mysqli_query($conn, "SELECT * FROM GFR_langs l WHERE lng_activar = 'S' ORDER BY lng_orden");
while($sql2=mysqli_fetch_array($sql)){
if ($_REQUEST['lang'] == $sql2["lng_contenttype"]){
$lng = $sql2["lng_codi"];
$_SESSION['lng'] = $lng;
$lang_idioma = 1;
break;
}
}
}
//RUBEN16: paràmetres de més
if((isset($_REQUEST['op4']))&&($lang_idioma==0)) {
header("Location:/not_found.php");
}
$ct = $idiomes[$lng]['lng_contenttype']; //echo $lang_idioma;
function str_replace_first($from, $to, $subject) {
$from = '/'.preg_quote($from, '/').'/';
return preg_replace($from, $to, $subject, 1);
}
function tradueix_url_ori($URL, $idioma_from, $idioma_to, $lang_idioma) {
global $conn;
// campanas
$URL = substr($URL, 1); //RUBEN16: pq faig aixó? revisar si cal comprobar el darrer caracter de la URL
$param = '';
if($lang_idioma == 1) {
$URL = substr($URL, 3);
}
$parts = explode("/", $URL);
foreach($parts as $part) {
//level 1
$q = "SELECT * FROM GFR_menus WHERE URL_".$idioma_from."_menu = '".$part."'";
$sql = mysqli_query($conn, $q);
if($rs = mysqli_fetch_assoc($sql)) {
$new_url .= "/".$rs['URL_'.$idioma_to.'_menu'];
} else {
$q1 = "SELECT * FROM GFR_traduccions WHERE tra_valor LIKE '".$part."' AND tra_idioma = '".$idioma_from."' AND tra_camp = 'url_seo' ORDER BY tra_id ASC";
$sql1 = mysqli_query($conn, $q1);
if($rs1 = mysqli_fetch_assoc($sql1)) {
$q2 = "SELECT * FROM GFR_traduccions WHERE tra_idioma = '".$idioma_to."' AND tra_camp = 'url_seo' AND tra_taula = '".$rs1['tra_taula']."' AND tra_id = '".$rs1['tra_id']."' ORDER BY tra_id ASC";
$sql2 = mysqli_query($conn, $q2);
if($rs2 = mysqli_fetch_assoc($sql2)) {
$new_url .= "/".$rs2['tra_valor'];
}
} else {
$param = '/'.$part;
}
}
}
return $new_url.$param;
}
function tradueix_url($URL, $idioma_from, $idioma_to, $lang_idioma, $pais_dest = 0, $producte = 0, $subtipo = 0) {
global $conn;
if($producte > 0) {
$q1 = "SELECT * FROM GFR_paises_modelos WHERE pam_modelo = '".$producte."' AND pam_pais=".$pais_dest;
$sql1 = mysqli_query($conn, $q1);
if($rs1 = mysqli_fetch_assoc($sql1)) {
} else {
//return '/';
return 'NA'; //RUBEN17
}
}
if($subtipo > 0) {
$q1 = "SELECT * FROM GFR_paises_stmodelos WHERE pas_stmodelo = '".$subtipo."' AND pas_pais=".$pais_dest;
$sql1 = mysqli_query($conn, $q1);
if($rs1 = mysqli_fetch_assoc($sql1)) {
} else {
//return '/';
return 'NA';//RUBEN17
}
}
$URL = substr($URL, 1); //RUBEN16: pq faig aixó? revisar si cal comprobar el darrer caracter de la URL
$param = '';
if($lang_idioma == 1) {
$URL = substr($URL, 3);
}
$parts = explode("/", $URL);
$level = 0;
foreach($parts as $part) {
$level++;
$q = "SELECT * FROM GFR_menus WHERE URL_".$idioma_from."_menu = '".$part."'";
$q = "SELECT * FROM GFR_menus m, GFR_paises_menu p WHERE URL_".$idioma_from."_menu = '".$part."' AND m.id_menu = p.id_menu AND pais_menu = ".$pais_dest; //RUBEN17
$sql = mysqli_query($conn, $q);
if($rs = mysqli_fetch_assoc($sql)) {
$new_url .= "/".$rs['URL_'.$idioma_to.'_menu'];
} else {
$q1 = "SELECT * FROM GFR_traduccions WHERE tra_valor LIKE '".$part."' AND tra_idioma = '".$idioma_from."' AND tra_camp = 'url_seo' ORDER BY tra_id ASC";
$sql1 = mysqli_query($conn, $q1);
if($rs1 = mysqli_fetch_assoc($sql1)) {
$q2 = "SELECT * FROM GFR_traduccions WHERE tra_idioma = '".$idioma_to."' AND tra_camp = 'url_seo' AND tra_taula = '".$rs1['tra_taula']."' AND tra_id = '".$rs1['tra_id']."' ORDER BY tra_id ASC";
$sql2 = mysqli_query($conn, $q2);
if($rs2 = mysqli_fetch_assoc($sql2)) {
$new_url .= "/".$rs2['tra_valor'];
}
} elseif ($level == 4) {
$new_url .= "/".$part;
} else {
//$param = '/'.$part;
return 'NA';//RUBEN17
}
}
}
return $new_url.$param;
}
function tradueix_url2($URL, $idioma_from, $idioma_to, $lang_idioma, $pais_dest = 0, $producte = 0, $subtipo = 0) {
global $conn;
if($producte > 0) {
$q1 = "SELECT * FROM GFR_paises_modelos WHERE pam_modelo = '".$producte."' AND pam_pais=".$pais_dest;
$sql1 = mysqli_query($conn, $q1);
if($rs1 = mysqli_fetch_assoc($sql1)) {
} else {
return '/';
}
}
if($subtipo > 0) {
$q1 = "SELECT * FROM GFR_paises_stmodelos WHERE pas_stmodelo = '".$subtipo."' AND pas_pais=".$pais_dest;
$sql1 = mysqli_query($conn, $q1);
if($rs1 = mysqli_fetch_assoc($sql1)) {
} else {
return '/';
}
}
$URL = substr($URL, 1); //RUBEN16: pq faig aixó? revisar si cal comprobar el darrer caracter de la URL
$param = '';
if($lang_idioma == 1) {
$URL = substr($URL, 3);
}
$parts = explode("/", $URL);
$level = 0;
foreach($parts as $part) {
$level++;
$q = "SELECT * FROM GFR_menus WHERE URL_".$idioma_from."_menu = '".$part."'";
//$q = "SELECT * FROM GFR_menus m, GFR_paises_menu p WHERE URL_".$idioma_from."_menu = '".$part."' AND m.id_menu = p.id_menu AND pais_menu = ".$pais_dest; //RUBEN17
$sql = mysqli_query($conn, $q);
if($rs = mysqli_fetch_assoc($sql)) {
$new_url .= "/".$rs['URL_'.$idioma_to.'_menu'];
} else {
$q1 = "SELECT * FROM GFR_traduccions WHERE tra_valor LIKE '".$part."' AND tra_idioma = '".$idioma_from."' AND tra_camp = 'url_seo' ORDER BY tra_id ASC";
$sql1 = mysqli_query($conn, $q1);
if($rs1 = mysqli_fetch_assoc($sql1)) {
$q2 = "SELECT * FROM GFR_traduccions WHERE tra_idioma = '".$idioma_to."' AND tra_camp = 'url_seo' AND tra_taula = '".$rs1['tra_taula']."' AND tra_id = '".$rs1['tra_id']."' ORDER BY tra_id ASC";
$sql2 = mysqli_query($conn, $q2);
if($rs2 = mysqli_fetch_assoc($sql2)) {
$new_url .= "/".$rs2['tra_valor'];
}
} elseif ($level == 4) {
$new_url .= "/".$part;
} else {
$param = '/'.$part;
}
}
}
return $new_url.$param;
}
if (strlen($lng) > 1 )
require($RUTA . "lang_" . $lng . ".inc.php");
else
require($RUTA . "lang_eng.inc.php");
$GENS = Get_Text($lng, "GENERAL");
$TXT = Get_Text($lng, "TXT");
//RUBEN16: això no va aquí
$CAP_TITOL_WEB = stripslashes($GENS["TITOL_WEB"]);
$CAP_DESCR_WEB = stripslashes($GENS["DESCR_WEB"]);
$CAP_KEY_WEB = stripslashes($GENS["KEYWORDS_WEB"]);
$CAP_TITOL_WEB .= ' - '.$MENU0;
//RUBEN16: crec que només és de l'index
//$extra_css .= " \n";
$extra .= " \n";
$nav = "".$MENU0."";
//echo $_SERVER['REQUEST_URI'];
//echo tradueix_url($_SERVER['REQUEST_URI'], $lng, "eng", $lang_idioma);
include('router7.php');