$nonce = base64_encode(random_bytes(16));
$host=$_GET['host'];
include_once("../comun/conexion.inc");
include_once("../comun/session.inc");
$db=conectar();
/**
** EJECUTAR SELECT GROUP CONCAT
**
*/
mysql_query("SET SESSION group_concat_max_len = 1000000;");
$rs=mysql_query(" SELECT GROUP_CONCAT(REPLACE(frase,'../../recursos/','../recursos/') ORDER BY IF(COALESCE(ordenPopupFrases,0)=0,999999,ordenPopupFrases) ASC, frases.fechaactualizacion DESC SEPARATOR '---') as frases,
GROUP_CONCAT('
',REPLACE(fraseEstatica,'../../recursos/','../recursos/') ORDER BY IF(COALESCE(ordenPopupFrases,0)=0,999999,ordenPopupFrases) ASC, frases.fechaactualizacion DESC SEPARATOR '') as frasesEstatica,
COUNT(*) as cantidadfrases
FROM colegios c
INNER JOIN frasescolegios ON c.idcolegio=frasescolegios.idcolegio
INNER JOIN frases ON frases.idfrase=frasescolegios.idfrase
WHERE httphost='".$host."' and '".date('Ymd')."' BETWEEN fechainicio AND fechafin; ");
$frases='';
while($row=mysql_fetch_array($rs))
{
$frases.=str_replace('