$zColIdUser = '******';
$zTableGroupe = 'gr_groupe';
}
$zStr = 'destinataire';
$zSqlText = "SELECT text FROM " . $zTableGroupe . " WHERE nom ='" . str_replace ("'", "''", $oEmail[$zStr]) . "'";
$zResSQLText = mysql_query($zSqlText);
$zResUsers = mysql_fetch_array($zResSQLText);
$zStr = 'text';
$toUsers = explode("|", $zResUsers[$zStr]);
if (sizeof($toUsers) > 0) {
foreach ($toUsers as $zUser) {
// Par défaut l'adresse mail est à vérifier
$mail_checked = 0;
$email_to_check = ($zColIdUser == 'retour_email_id_user') ? CTableUser::get_element($zUser, "email") : CTableGrUser::get_element($zUser, "email");
// Vérification des adresses mails
if(mailCheck($email_to_check)){
$zStr = 'id';
$zSql2 = "SELECT COUNT(*) AS COUNT FROM retour_email WHERE retour_email_id_email ='".$oEmail[$zStr]."' AND " . $zColIdUser . " ='".$zUser."'";
$zResSQL = mysql_query($zSql2);
$oResult = mysql_fetch_array($zResSQL);
$iNbRowMatch = $oResult['COUNT'];
if ( (int)($iNbRowMatch) > 0 ) {
$zSql3 = "UPDATE retour_email SET retour_email_statut = '1', retour_email_lien='0' WHERE retour_email_id_email ='".$oEmail[$zStr]."' AND " . $zColIdUser . " ='".$zUser."'";
mysql_query($zSql3);
}
else {
$zSql3 = "INSERT INTO retour_email (retour_email_id_email, " . $zColIdUser . ", retour_email_statut, retour_email_lien) VALUES ('" . $oEmail[$zStr] . "', '" . $zUser . "', '1', '0')";
