FM / admin

/var/www/clients/client1/web2/web/admin/

/var/www/clients/client1/web2/web/admin

Name	Size	Mode	Actions
css/	-	0755	rm
fonts/	-	0755	rm
imagenes/	-	0755	rm
js/	-	0755	rm
responsive-sidebar-navigation-master/	-	0755	rm
vendors/	-	0755	rm
access.php	344	0644	edit dl rm
admin.php	19898	0644	edit dl rm
assets.php	518	0644	edit dl rm
banners_mod2.php	4190	0644	edit dl rm
certificaciones_mod.php	2847	0644	edit dl rm
certificaciones_mod2.php	2551	0644	edit dl rm
comodin_mod.php	2368	0644	edit dl rm
comodin_mod2.php	1927	0644	edit dl rm
contactos_mod.php	1674	0644	edit dl rm
datepicker.php	138	0644	edit dl rm
editor.php	623	0644	edit dl rm
eliminar.php	449	0644	edit dl rm
eliminar_ajax.php	209	0644	edit dl rm
eliminar_archivo.php	215	0644	edit dl rm
estilos.css	1287	0644	edit dl rm
excel_contacto.php	2377	0644	edit dl rm
frases_mod2.php	1175	0644	edit dl rm
funciones.js	1316	0644	edit dl rm
funciones.php	13648	0644	edit dl rm
home.php	29	0644	edit dl rm
imagenes_home_add.php	1053	0644	edit dl rm
imagenes_home_mod.php	2669	0644	edit dl rm
imagenes_home_mod2.php	2352	0644	edit dl rm
index.php	3249	0644	edit dl rm
links_mod2.php	1157	0644	edit dl rm
log.php	2575	0644	edit dl rm
logout.php	200	0644	edit dl rm
medidas_mod.php	2448	0644	edit dl rm
medidas_mod2.php	2547	0644	edit dl rm
ordenar.php	543	0644	edit dl rm
pdfs_mod2.php	3090	0644	edit dl rm
post_procesos.php	624	0644	edit dl rm
procesos.php	10335	0644	edit dl rm
process.ordenar.php	435	0644	edit dl rm
representantes_mod.php	2317	0644	edit dl rm
representantes_mod2.php	4025	0644	edit dl rm
sliders_mod.php	2468	0644	edit dl rm
sliders_mod2.php	5073	0644	edit dl rm
sube_fotos.php	6605	0644	edit dl rm
sube_fotos_multiple.php	6104	0644	edit dl rm
t.php	698	0644	edit dl rm
tabla_fusion_mod.php	3475	0644	edit dl rm
tabla_fusion_mod2.php	4797	0644	edit dl rm
tabla_mod.php	3220	0644	edit dl rm
tabla_mod2.php	4145	0644	edit dl rm
titulos.php	2722	0644	edit dl rm
usuarios_mod.php	2265	0644	edit dl rm
usuarios_mod2.php	1776	0644	edit dl rm
videos_mod.php	2444	0644	edit dl rm
videos_mod2.php	1915	0644	edit dl rm
video_home_mod2.php	1457	0644	edit dl rm
zona_mod.php	1832	0644	edit dl rm
zona_mod2.php	1521	0644	edit dl rm

Edit: /var/www/clients/client1/web2/web/admin/excel_contacto.php (2377B)

<?php

include "access.php";

$query_ventas = "SELECT * FROM contactos  WHERE Id > 0  ";

if($_REQUEST['tipo'] and $_REQUEST['tipo']!='General'){
	$query_ventas .= " and tipo =  '".escape($_REQUEST['tipo'])."' ";
}

if(isset($_POST['desde']) && $_POST['desde']!=''){
	$query_ventas .= " and fecha >=  '".ingles($_REQUEST['desde'])."' ";	
}

if(isset($_POST['hasta']) && $_POST['hasta']!=''){
	$query_ventas .= " and fecha <=  '".ingles($_REQUEST['hasta'])."' ";	
}

if(isset($_POST['id_sitio']) && intval($_POST['id_sitio'])!='0'){
	if(intval($_REQUEST['id_sitio'])==3){
		$query_ventas .= " and id_sitio =  '".intval($_REQUEST['id_sitio'])."' or id_sitio = 8 ";	
	} else {
		$query_ventas .= " and id_sitio =  '".intval($_REQUEST['id_sitio'])."' ";	
	}
}

$query_ventas .= " order by fecha desc, Id desc ";

$ventas = mysqli_query($latynconexiones, $query_ventas) or die(mysqli_error());
$row_ventas = mysqli_fetch_assoc($ventas);

if(mysqli_num_rows($ventas)){

header('Content-type: application/vnd.ms-excel');
header("Content-Disposition: attachment; filename=".sitio($_POST['id_sitio'])."_".date('d_m_Y').".xls");
header("Pragma: no-cache");
header("Expires: 0");

do { 
		$data .= utf8_decode(sitio($row_ventas['id_sitio']))."\t"; 	
        $data .= espanol($row_ventas['fecha'])."\t";
        $data .= utf8_decode($row_ventas['nombre'])."\t";
        $data .= utf8_decode($row_ventas['email'])."\t";      
        $data .= utf8_decode($row_ventas['telefono'])."\t"; 
        $data .= utf8_decode($row_ventas['empresa'])."\t";		
        $data .= utf8_decode(der($row_ventas['mensaje']))."\t";

$data .= "\n";
		
     } while ($row_ventas = mysqli_fetch_assoc($ventas));

print "Sitio\tFecha\tNombre\tEmail\tTelefono\tEmpresa\tMensaje";

print "\n$data";

} else { echo 'No hay datos'; }

function der($var1) {
	$cadena = $var1;
	$cadena = str_replace( chr(13), "", $cadena );
	$cadena = str_replace( "'", "", $cadena );	
	$cadena = str_replace( '"', '', $cadena );		
	$cadena = str_replace( chr(10) & chr(10), "", $cadena);
	$cadena = str_replace( chr(10), "",  $cadena );

return($cadena)	;
}

function fre($cadena){
	$cadena=str_replace(" ","_",$cadena);	
	return($cadena);	
}

mysqli_free_result($ventas); 
?>

cmd: