include("i_conect.php");
include("i_comunes.php");
include("../admin/inc/tbl_zona_sitio_aux.php");
include("../admin/inc/tbl_zona_sitio.php");
/*
-- File Name : consulta_zona_ajax.php
-- Description : página con librerias generales
-- Programmer : Christian Díaz
-- Date : 01/May/2006
*/
/****************************************************************/
$vlZona = $_GET["qZona"];
$vlResult2 = fm_bus_zona_sitio($vlZona);
$vlReturn2 = mysql_num_rows($vlResult2);
if($vlReturn2 > 0)
{
$vlObjrst2 = mysql_fetch_array($vlResult2);
$vlZonaDesc = trim($vlObjrst2["zonsit_desc"]);
}else{
$vlZonaDesc = "Sin descripci�n";
}
$vlResult = fm_bus_zona_sitio_aux("", $vlZona);
$vlReturn = mysql_num_rows($vlResult);
if($vlReturn > 0)
{
$VecDatos= array(array(), array());
while($vlObjrst = mysql_fetch_array($vlResult))
{
$vlCont = count($VecDatos[0]);
$VecDatos[0][$vlCont] = trim($vlObjrst["zonsitaux_desc"]);
}
mysql_free_result($vlResult );
$vlRetorno = "
";
for ($xx=0; $xx <= intval($vlCont); $xx++){
if (trim($VecDatos[0][$xx]) != "")
{
$vlRetorno = $vlRetorno . "- " ;
$vlRetorno = $vlRetorno . fm_limpiar($VecDatos[0][$xx]) ;
$vlRetorno = $vlRetorno . "
";
}
}
echo $vlRetorno . " | ". strtoupper(fm_limpiar($vlZonaDesc)) ." | ";
}else{
echo "No existen datos cargados para esta zona ...........| " . strtoupper(fm_limpiar($vlZonaDesc)) . " | ";
}
/****************************************************************/
function fm_limpiar($vtcadena)
{
$vlRetVal = "";
if (!empty($vtcadena))
{
$vlRetVal = trim(str_replace("�", "@", $vlRetVal));
$vlRetVal = trim(str_replace("�", "@", $vlRetVal));
$vlRetVal = trim(str_replace("�", "%", $vlRetVal));
$vlRetVal = trim(str_replace("�", "%", $vlRetVal));
$vlRetVal = trim(str_replace("�", "&", $vtcadena));
$vlRetVal = trim(str_replace("�", "&", $vlRetVal));
$vlRetVal = trim(str_replace("�", "*", $vlRetVal));
$vlRetVal = trim(str_replace("�", "*", $vlRetVal));
$vlRetVal = trim(str_replace("�", "?", $vlRetVal));
$vlRetVal = trim(str_replace("�", "?", $vlRetVal));
$vlRetVal = trim(str_replace("�", "#", $vlRetVal));
$vlRetVal = trim(str_replace("�", "#", $vlRetVal));
}
return $vlRetVal;
}
?>