enviar_mensagem.php <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta HTTP-EQUIV="Content-Language" content="PT-BR">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Envio de E-Mails Dinâmicos</title>
</head>
<body>
<?
require "../../CONFIG.php";
#include "progresso.inc";
#-------------------------------------------------------------
ECHO '
<div align="center">
<form name=botoes>
<table width=250px>
<tr>
<td width=100px Onclick="document.execCommand(\'Stop\'); return false;">
<input type=button value="'.$LANG[$com_language][SENT_PROCCESS_STOP].'" onClick="java script:window.stop();" style="width:100px; height:25px; font-family:Verdana, Geneva, sans-serif; font-size:12px; color:#999; background:#FFF; border:1px solid #666">
</td>
<td width=100px>
<input type=button value="'.$LANG[$com_language][SENT_PROCCESS_KEEP].'" onclick="refresh()" style="width:100px; height:25px; font-family:Verdana, Geneva, sans-serif; font-size:12px; color:#999; background:#FFF; border:1px solid #666">
</td>
<td width=50px align=right>
<input type=button value="'.$LANG[$com_language][SENT_PROCCESS_CANCELL].'" onclick="window.close();" style="width:100px; height:25px; font-family:Verdana, Geneva, sans-serif; font-size:12px; color:#999; background:#FFF; border:1px solid #666">
</td>
</tr>
</table>
</form>
<table class=prog2 style="width:250px; background:#FFF; border:1px solid #666; font-family:Verdana, Geneva, sans-serif; font-size:12px; color:#999;" id="table1" cellpadding="0" border=0>
<tbody>
<tr class=prog2>
<td class="row2" align="center" style="background:#eaf2fa; border:1px solid #666;" colspan=2>
<font color="#FFFFFF"><div id="etapas" style="font-family:verdana; font-size:12px; color:#666;">'.$LANG[$com_language][SENT_PROCCESS_WAIT].'</div></font>
</td>
</tr>
<tr style="color: #222; font-size: 11px; line-height: 135%;">
<td align="center" colspan=2 style="background:#FFFFFF; border: 1px solid #ffffff;" >
<b><div id="porcentagem" style="font-family:verdana; font-size:12px; color:#000000;">0%</div></b>
<table width=205px style="border:1px solid #666; padding:5px" cellspacing="0" id="table1" cellpadding="0" align=center>
<tr >
<td height=20px style="background:#ffffff;" align=left><img src="bar.gif" id="progresso" height="20px" width="0px"></td>
</tr>
</table>
<table border=0 cellspacing="0" cellpadding="0" align=center>
<tr>
<td><span style="font-size: 2pt"> </span></td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="row2" align="center" width="50%" style="background:#eaf2fa; border:1px solid #666; font-family:verdana;color:#666; font-size: 12px;">'.$LANG[$com_language][SENT_PROCCESS_SENT].'</td>
<td class="row2" align="center" width="50%" style="background:#eaf2fa; border:1px solid #666; font-family:verdana;color:#666; font-size: 12px;">'.$LANG[$com_language][SENT_PROCCESS_TOSENT].'</td>
</tr>
<tr style="color: #222; font-size: 11px;">
<td class="row2" align="center" width="50%" STYLE="border:1px solid #666; background:#f5f5f5;"><div id="nlinha" name="nlinha" style="font-family:verdana; font-size:12px; color:#990000">0</div></td>
<td class="row2" align="center" width="50%" STYLE="border:1px solid #666; background:#f5f5f5;"><div id="aenviar" name="aenviar" style="font-family:verdana; font-size:12px; color:#990000">0</DIV></td>
</tr>
<tr>
<td class="row2" align="center" width="50%" style="background:#eaf2fa; border:1px solid #666; color:#666; font-family:verdana;font-size: 12px;">'.$LANG[$com_language][SENT_PROCCESS_FAIL_OCURR].'</td>
<td class="row2" align="center" width="50%" style="background:#eaf2fa; border:1px solid #666; color:#666; font-family:verdana;font-size: 12px;">'.$LANG[$com_language][SENT_PROCCESS_TOTAL_RECIPIENT].'</td>
</tr>
<tr style="color: #222; font-size: 11px;">
<td class="row2" align="center" width="50%" STYLE="border:1px solid #666; background:#f5f5f5;"><div id="nlinha" name="nlinha" style="font-family:verdana; font-size:12px; color:#990000">
<div id="falhas" name="falhas" style="font-family:verdana; font-size:12px; color:#990000">0</div></td>
<td class="row2" align="center" width="50%" STYLE="border:1px solid #666; background:#f5f5f5;"><div id="nlinha" name="nlinha" style="font-family:verdana; font-size:12px; color:#990000" >
<div id="nlinhas" name="nlinhas" style="font-family:verdana; font-size:12px; color:#990000;">0</div>
</td>
</tr>
</tbody></table>
</div>
';
#------------------------------------------------------------
include("funcoes.php");
$data=date('Y-m-d');
$hora = date("H:i:s");
$data2=date('Y-m-d');
$data.=" ".$hora;
$query_dados = "SELECT * FROM $tb6";
$result_dados=mysql_query($query_dados)OR DIE("Falha L9 mail/enviar_mensagem.php <br>".mysql_error());
while ($row_dados=mysql_fetch_array($result_dados)){
$co_nome=$row_dados[nome];
$co_endereco=$row_dados[endereco];
$co_email=$row_dados[email];
$co_telefone=$row_dados[telefone];
$co_celular=$row_dados[celular];
$co_prefixo=$row_dados[prefixo];
}
$co_limite=$limite;
$limite=$co_limite;
$erros_totais=$_REQUEST[erros];
$subject = $_REQUEST['subj'];
$body = $_REQUEST['body'];
$caixa_mail=$_REQUEST[caixa_mail];
$body_2=$body;
$subject_2=$subject;
$formatacao = $_REQUEST['formatacao'];
$to = $_REQUEST['to'];
$from = $_REQUEST['email_from'];
$fromname = $_REQUEST['nome_from'];
$erro=$_REQUEST['erro'];
IF($erro='')
$erro=0;
## ENVIO PARA EMAIL INDIVIDUAL
IF (eregi("^[A-Za-z0-9\.-_]+@[A-Za-z0-9-]+\.[A-Za-z0-9\.-_]+$", $to)){
$resul_in = mysql_query("INSERT INTO $tb5 SET tipo='envio_individual', email='$to'")OR DIE("Falha L64 enviar_mensagem.php<br>".mysql_error());
$resul = mysql_query("SELECT DISTINCT email FROM $tb5 WHERE email='$to' AND tipo='envio_individual'")OR DIE("Falha L64 enviar_mensagem.php<br>".mysql_error());
$sql="SELECT DISTINCT email FROM $tb2 WHERE email='$to'";
}
ELSEIF($to=='envio_todos'){
$resul = mysql_query("SELECT DISTINCT email FROM $tb5 WHERE tipo='envio_todos' ORDER BY email")OR DIE("Falha L82 enviar_mensagem.php<br>".mysql_error());
$sql="SELECT DISTINCT email FROM $tb2 ORDER BY email";
}
ELSEIF(eregi("grupo#", $to)){
$var2 = explode("#",$to);
$gestao_id= $var2[1];
$resul = mysql_query("SELECT DISTINCT email FROM $tb5 WHERE tipo='$gestao_id' ORDER BY email")OR DIE("Falha L86 enviar_mensagem.php<br>".mysql_error());
$sql="SELECT DISTINCT email FROM $tb2 WHERE categoria='$gestao_id' ORDER BY email";
}
ini_set("max_execution_time",0);
ini_set('post_max_size', '60M');
ini_set('upload_max_filesize', '60M');
ini_set ('memory_limit', '128M');
## CAPTURA QDE TEMPORARIOS
$total_temporario=mysql_num_rows($resul);
IF($total_temporario==0){
$resultado=mysql_query($sql)OR DIE(mysql_error());
$total_temporario=mysql_num_rows($resultado);
$i=0;
WHILE ($row2=mysql_fetch_array($resultado)){
$email2[$i]=$row2['email'];
$sqlxx=mysql_query("INSERT INTO $tb5 SET email='".$email2[$i]."',tipo='envio_todos'");
$i++;
}
}
ELSE{
$i=0;
## captura valores de emails
WHILE ($row2=mysql_fetch_array($resul)){
$email2[$i] = $row2['email'];
$i++;
}
}
## CALCULA O TOTAL DE TEMPORARIO
$total_news=$total_temporario;
## GUARDA TOTAL GERAL
IF($_REQUEST[total]>$total_news)
$totum=$_REQUEST[total];
ELSE
$totum=$total_news;
## DEFINE OS LIMITES,RESTOS E ETAPAS
IF(($_REQUEST[etapas]!='')AND($_REQUEST[etapas]==$_REQUEST[etapa]))
$limite=$_REQUEST[resto];
ELSE
$limite=$co_limite;
IF($_REQUEST[etapas]==''){
$etapa=1;
IF($total_news>$limite){
$resto=$total_news%$limite;
$centenas=$total_news-$resto;
$etapas=($centenas/$limite+1);
}
ELSE{
$limite=$total_news;
$etapas=1;
$resto=0;
}
}
ELSE{
$resto=$_REQUEST[resto];
$etapas=$_REQUEST[etapas];
$etapa=$_REQUEST[etapa];
}
$k=0;
WHILE ($k<$i){
# EVITAR MENSAGEM
$email_destino=$email2[$k];
$mail_prefixo=$co_prefixo."".$email_destino;
#------------------------------------------------------------------------------------------------------------------
# ADICIONADO EM 08/05/2009 - CORREÇÃO FALHA MAGIC_QUOTES_GPC
#------------------------------------------------------------------------------------------------------------------
$formatacao = get_magic_quotes_gpc() ? stripslashes($formatacao): $formatacao;
$mail_prefixo = get_magic_quotes_gpc() ? stripslashes($mail_prefixo): $mail_prefixo;
$subject = get_magic_quotes_gpc() ? stripslashes($subject): $subject;
$body = get_magic_quotes_gpc() ? stripslashes($body): $body;
$co_nome = get_magic_quotes_gpc() ? stripslashes($co_nome): $co_nome;
$co_email = get_magic_quotes_gpc() ? stripslashes($co_email): $co_email;
#------------------------------------------------------------------------------------------------------------------
$erro_envio=enviar_mail($formatacao,$mail_prefixo,$subject,$body,$co_nome,$co_email);
$erro=$erro+$erro_envio;
## LIMPA TABELA TEMPORARIO SE ENVIO ESTIVER OK
## TEST 01
IF($erro_envio==0){
$caixa_mail.=" ".$mail_prefixo.",";
$limpeza=mysql_query("DELETE FROM $tb5 WHERE ( email='$email_destino' )")OR DIE(mysql_error());
}
## BARRA DE PROGRESSO
$total=$limite;
$nlinhas=$limite;
$n=$n+1;
$largura=$n*100/$total;
$largura = substr($largura,0,4);
$largura2=2*$largura;
$aenviar=$total-($k+1);
echo "
<script>
function progresso() {
document.getElementById('progresso').style.width='".$largura2."';
document.all.porcentagem.innerHTML = '".round($largura)."%';
document.all.nlinha.innerHTML = '".$n."';
document.all.nlinhas.innerHTML = '".$totum."';
document.all.falhas.innerHTML = '".$erro."';
document.all.aenviar.innerHTML = '".$aenviar."';
document.all.etapas.innerHTML = 'ETAPA ".$etapa." / ".$etapas." <span style=\'font-size:10px;color:#f9f9f9;font-weight:normal;\'><br>(".$LANG[$com_language][SENT_PROCCESS_SENDING]." ".$nlinhas." ".$LANG[$com_language][SENT_PROCCESS_MESSAGE].")</span>';}
</script>
";
echo '<script>progresso()</script>';
if ($k==($limite-1)) break;
$k++;
}
## RELATO DE ERROS
$erros_totais=$erros_totais+$erro;
IF(($etapas==$etapa)){
IF($erros_totais>0){
echo "<script>alert(\"".$LANG[$com_language][SENT_PROCCESS_MESSAGE_FAIL]."\")</script>";
echo "<script>window.close();</script>";
}
ELSE{
echo "<script>window.opener.top.location='../../';</script>";
echo "<script>alert(\"".$LANG[$com_language][SENT_PROCCESS_MESSAGE_SUCCESS1]." ".$totum." ".$LANG[$com_language][SENT_PROCCESS_MESSAGE_SUCCESS2]."\")</script>";
echo "<script>window.close();</script>";
}
$resul0 = mysql_query("SELECT * FROM $tb5 WHERE tipo='envio_todos'")OR DIE("Falha L258 enviar_mensagem.php<br>".mysql_error());
$tot0=mysql_num_rows($resul);
#------2% de total-------#
$percentual=2*$totum/100;
$percentual=intval($percentual);
#------2% de total-------#
#VARIÁVEIS, PARA CAIXA-MAIL
$body_2 = str_replace("'", "", $body_2);
$subject_2 = str_replace("'", "", $subject_2);
$sql_mail="INSERT INTO $tb4 SET data='".$data."'";
$sql_mail.=", assunto='".$subject_2."'";
$sql_mail.=", mensagem='".$body_2."'";
$sql_mail.=", destinatarios='".$caixa_mail."'";
$sql_mail.=", formatacao='".$formatacao."'";
$sql_mail.=", login='".$login_nome."'";
IF($caixa_mail!='')
$result_mail=mysql_query($sql_mail)OR DIE(mysql_error());
}
##PROSSEGUIR ENVIO
IF($etapas!=$etapa){
$etapa=$etapa+1;
# TEXT 05 - CAIXA-MAIL
echo"
<form method='POST' action='".$_SERVER['PHP_SELF']."' name='globais' style='visibility:hidden;'>
<input type=hidden name='to' value='$to'>
<input type=hidden name='subj' value='$subject'>
<textarea name='body' cols='57' rows=6 style='width:450px;'>$body</textarea>
<textarea name='caixa_mail' cols='57' rows=6 style='width:450px;visibility:hidden;'>$caixa_mail</textarea>
<input type=hidden name='total' value='$totum'>
<input type=hidden name='etapa' value='$etapa'>
<input type=hidden name='formatacao' value='$formatacao'>
<input type=hidden name='etapas' value='$etapas'>
<input type=hidden name='resto' value='$resto'>
<input type=hidden name='limite' value='$limite'>
<input type=hidden name='erros' value='$erros_totais'>
<input type=hidden name='erro' value='$erro'>
<p align='center'><input type='submit' value='".$LANG[$com_language][SENT_PROCCESS_NEXT_STEP]."'></p>
</form>
";
echo '<script>document.globais.submit();</script>';
}
?>
</body>
</html>
