isMobile() ? ($detect->isTablet() ? 'tablet' : 'phone') : 'computer'); $fecha = date("y-m-d"); $hoy= "20$fecha"; $qryProgramados = "SELECT A.*, UNIX_TIMESTAMP( A.fecha ) AS programado_unix, UNIX_TIMESTAMP( B.ultima_modificacion ) AS ultima_modificacion_unix FROM `ni_banner_programacion` AS A INNER JOIN ni_banner_programacion AS B ON A.orden = B.orden WHERE UNIX_TIMESTAMP(A.fecha) < '".strtotime(date('d-m-Y H:i:s'))."' AND A.programado = 's' GROUP BY id"; $sqlProgramados = mysql_query($qryProgramados); if(mysql_num_rows($sqlProgramados)>0) { $body = '

desde home

'; while($banner = mysql_fetch_assoc($sqlProgramados)) { if($banner['ultima_modificacion_unix'] <= $banner['programado_unix']) { $updated = mysql_query("UPDATE ni_banner_programacion SET activo='si',texto='".$banner['texto']."', url_imagen='".$banner['url_imagen']."' WHERE orden = '".$banner['orden']."' AND programado ='n'"); $body .= "UPDATE ni_banner_programacion SET activo='si',texto='".htmlentities($banner['texto'])."', url_imagen='".$banner['url_imagen']."' WHERE orden = '".$banner['orden']."'"."\n"; if($updated) { mysql_query("DELETE FROM ni_banner_programacion WHERE id = '".$banner['id']."'"); } }else{mysql_query("DELETE FROM ni_banner_programacion WHERE id = '".$banner['id']."'");} } $from = 'webmaster@canaldelcongreso.com'; $to = "webmaster.tvcongreso@gmail.com,gestor.tvcongreso@gmail.com"; $subject = 'prueba'; $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "cancon\r\n"; $msg = ' '.$body.''; mail($to, $subject, $msg, $headers); }//FIN IF NON ROWS ?> Canal del Congreso