0){
return true;
} else {
return false;
}
}
function idsql($sql){
$rx = mysqli_query($GLOBALS['db'],$sql);
if(mysqli_num_rows($rx)){
$f = mysqli_fetch_array($rx);
$a = $f["id"];
mysqli_free_result($rx);
} else {
$a = 0;
}
return $a;
}
function countsql($sql){
$rx = mysqli_query($GLOBALS['db'],$sql);
return mysqli_num_rows($rx);
}
function addsql($sql){
$rx = mysqli_query($GLOBALS['db'],$sql);
$rx = mysqli_insert_id($GLOBALS['db']);
if($rx == "") $rx = 0;
return $rx;
}
function RowID(){
return date("YmdHis",time())."_".md5(uniqid(rand()));
}
function getval($tabla,$fld,$val,$x = "id"){
$sql = "select * from $tabla where $x='".addslashes($val)."'";
$rsa = mysqli_query($GLOBALS['db'],$sql);
$f = mysqli_fetch_array($rsa);
$dat = StripSlashes($f[$fld]);
mysqli_free_result($rsa);
return ($dat);
}
function getextradat($inmueble,$extra,$campo){
$sql = "select $campo from inmuebles_extras_datos where extra=$extra and inmueble=$inmueble limit 1";
//echo $sql."
";
$rsa = mysqli_query($GLOBALS['db'],$sql);
$f = mysqli_fetch_array($rsa);
$dat = StripSlashes($f[$campo]);
mysqli_free_result($rsa);
return ($dat);
}
/*
function extension_get($a){
$a = strtolower($a);
if($a){
if(!strpos(" ".$a,".")){
return false;
} else {
$a = explode(".",$a);
return $a[count($a)-1];
}
} else {
return false;
}
}
*/
function deletefile($file) {
$delete = @unlink($file);
if (@file_exists($file)) {
$filesys = eregi_replace("/","\\",$file);
$delete = @system("del $filesys");
if (@file_exists($file)) {
$delete = @chmod ($file, 0775);
$delete = @unlink($file);
$delete = @system("del $filesys");
}
}
}
function fch2dt($d){
$d = explode("/",$d,3);
return $d[2].$d[1].$d[0];
}
function dt2fch($d){
if(strlen($d) > 8) $d = substr($d,0,8);
if($d){
return substr($d,6,2)."/".substr($d,4,2)."/".substr($d,0,4);
} else {
return "";
}
}
function dt2ts($a){
if(strlen($a) > 8) $a = substr($a,0,8);
$y = intval(substr($a,0,4));
$m = intval(substr($a,4,2));
$d = intval(substr($a,6,2));
return mktime(0,0,0,$m,$d,$y);
}
function dttime($a){
return date("Ymd",$a);
}
function lim($a,$largo = 200){
$a = trim(stripslashes($a));
$a = strip_tags($a);
$a = html_entity_decode($a);
if(strlen($a) > $largo){
$a = substr($a,0,($largo - 3))."...";
}
return $a;
}
function getstr($fld,$db){
$sql = "select * from $db limit 1";
$rsa = mysqli_query($GLOBALS['db'],$sql);
$f = mysqli_fetch_array($rsa);
$dat = trim(StripSlashes($f[$fld]));
mysqli_free_result($rsa);
return $dat;
}
function getstr2($db,$fld){
$sql = "select * from $db limit 1";
$rsa = mysqli_query($GLOBALS['db'],$sql);
$f = mysqli_fetch_array($rsa);
$dat = trim(StripSlashes($f[$fld]));
mysqli_free_result($rsa);
return $dat;
}
Function Right($orig,$ini){
$right=strrev($orig);
$right=substr(" ".$right,1,$ini);
return strrev($right);
}
function fmtnum($a){
// v 20110221
if(strpos($a,",")>0){
$aux = explode(",",$a);
if(count($aux) > 2){
$dec = $aux[count($aux)-1];
$ent = "";
for($n=0;$n < count($aux)-1;$n++){
$ent.= $aux[$n];
}
$a = $ent.",".$dec;
}
$a = str_replace(".","" ,$a);
$a = str_replace(",",".",$a);
} else {
$p = strpos(" ".strrev($a),".");
if($p==4){
$a = str_replace(".","",$a);
} else {
$b = substr($a,0,strlen($a)-$p);
$b = str_replace(".","",$b);
$a = $b.right($a,$p);
}
}
if(!is_numeric($a)) $a = 0;
return $a;
}
function fmt($a){
return number_format($a,2,",",".");
}
function getvalue($tabla,$fld,$val,$x = "id"){
$sql = "select * from $tabla where $x='".addslashes($val)."' limit 1";
$rsa = mysqli_query($GLOBALS['db'],$sql);
$f = mysqli_fetch_array($rsa);
$dat = StripSlashes($f[$fld]);
mysqli_free_result($rsa);
return $dat;
}
function sumsql($sql){
$rx = mysqli_query($GLOBALS['db'],$sql);
$g = mysqli_fetch_row($rx);
$aux= $g[0];
mysqli_free_result($rx);
return $aux;
}
function isfch($fecha){
if(strlen($fecha) != 10) return false;
$m = substr($fecha,2,2);
$d = substr($fecha,0,2);
$y = substr($fecha,4,4);
$aux = explode("/",$fecha);
if(count($aux) != 3) return false;
if($m < 1 || $m > 12) return false;
if($d <1 || $d > 31) return false;
if($y < 1900) return false;
if(!is_date($m,$d,$y)) return false;
return true;
}
//contramedidas sql inject
function sql_armor(){
foreach($_REQUEST as $key => $data){
$data = strtolower($data);
if (strpos($data, "base64_") !== false) exit;
if (strpos($data, "union") !== false && strpos($data, "select") !== false) exit;
}
}
sql_armor();
//----------------------
define("diafinal",",31,28,31,30,31,30,31,31,30,31,30,31");
function periodo($a){
if(strlen($a)==6){
$y = substr($a,0,4);
$m= intval(substr($a,4,2));
$meses = explode(",",meses);
return $meses[$m]."-".$y;
} else {
return "";
}
}
function humandate($a){
//recibo solo timestamp
if(!is_numeric($a)){
return "";
} else {
$d = explode(",",dias);
$m = explode(",",meses);
return $d[date("w",$a)].", ".date("j",$a)." de ".$m[date("n",$a)]." de ".date("Y",$a);
}
}
// generacion sitemap
function gensitemap($url){
$xml = "";
$top = "";
$top.="<"."?"."xml version=\"1.0\" encoding=\"UTF-8\""."?".">\n";
$top.="\n";
$xml.= $top;
$xml.="\n";
$xml.="https://".$url."/\n";
$xml.="".date("Y-m-d",time())."T".date("H:i:s",time())."+02:00\n";
$xml.="\n";
$xml.="\n";
$xml.="https://".$url."/noticias.php\n";
$xml.="".date("Y-m-d",time())."T".date("H:i:s",time())."+02:00\n";
$xml.="\n";
$xml.="\n";
$xml.="https://".$url."/galeria.php\n";
$xml.="".date("Y-m-d",time())."T".date("H:i:s",time())."+02:00\n";
$xml.="\n";
$sql = "select * from publicaciones where estado=1 order by id desc limit 20";
$rs = mysqli_query($GLOBALS['db'],$sql);
while($i = mysqli_fetch_array($rs)){
$xml.="\n";
$xml.="https://".$url."/noticia_detalle.php?id=".$i["id"]."\n";
$xml.="".date("Y-m-d",time())."T".date("H:i:s",time())."+02:00\n";
$xml.="\n";
}
mysqli_free_result($rs);
$sql = "select * from articulos where estado=1 order by id desc limit 20";
$rs = mysqli_query($GLOBALS['db'],$sql);
while($i = mysqli_fetch_array($rs)){
$xml.="\n";
$xml.="https://".$url."/contenido.php?id=".$i["id"]."\n";
$xml.="".date("Y-m-d",time())."T".date("H:i:s",time())."+02:00\n";
$xml.="\n";
}
mysqli_free_result($rs);
$bottom = "";
$bottom.="\n";
$xml.= $bottom;
$xml = utf8_encode($xml);
$arch = "sitemap.xml";
$a = fopen($arch,"wb");
fwrite($a,$xml,strlen($xml));
fclose($a);
}
$fchmap = date("Ymd",filemtime("sitemap.xml"));
if($fchmap < date("Ymd",time())) gensitemap("www.fnp.es");
?>