Manda mails, estamos as analisar tudo o que escreve :)
";
$q_stat = mysql_query("SELECT count(*) FROM mail_data WHERE date <> ''");
$row = mysql_fetch_array ($q_stat);
$total = $row[0];
$q_stat = mysql_query("SELECT DISTINCT MONTHNAME(date) AS mes, count(*) as emails
FROM mail_data GROUP BY mes ORDER BY emails DESC LIMIT 1");
$row = mysql_fetch_array ($q_stat);
$ratio = ($size[0] * $stat_rep - 2) / $row[1];
$q_stat = mysql_query("SELECT DISTINCT MONTHNAME(date) AS mes, 100 * COUNT(*) / $total, FLOOR(COUNT(*) * $ratio), MONTH(date) AS nmes
FROM mail_data WHERE date <> '' GROUP BY mes ORDER BY nmes");
$form[id_query] = $q_stat;
$form[table] = "\n";
$form[format] = array(
''
);
echo "Mesagens enviadas por meses :";
form_query ($form);
echo "
";
$q_stat = mysql_query("SELECT DISTINCT dayname(date) AS dias, count(*) as emails
FROM mail_data GROUP BY dias ORDER BY emails DESC");
$row = mysql_fetch_array ($q_stat);
$ratio = ($size[0] * $stat_rep - 2) / $row[1];
$q_stat = mysql_query("SELECT DISTINCT dayname(date) AS dias, 100 * COUNT(*) / $total, FLOOR(COUNT(*) * $ratio), DAYOFWEEK(date) AS ndias
FROM mail_data WHERE date <> '' GROUP BY dias ORDER BY ndias");
$form[id_query] = $q_stat;
$form[table] = "\n";
$form[format] = array(
''
);
echo "Messagens enviadas por dias :";
form_query ($form);
?>