$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')";
mysql_query($zSql3);
}
<input name="id" type="hidden" value="' . $user->id . '">
<button type="button" class="btn btn-primary" onClick="popupFormSubmit(\'index.php?m=a&g=core&p=admin_users&a=update\',$(\'form#popupForm\').serialize());">
Modifier
</button>
';
break;
case 'update':
if (isset($_GET['id'])) {
$id = $_GET['id'];
} elseif (isset($_POST['id'])) {
$id = $_POST['id'];
} else {
// TODO ERROR
}
if (!isset($_POST['mail']) || $_POST['mail'] == '' || !mailCheck($_POST['mail'])) {
// Todo error
echo 'erreur mail';
} elseif (!isset($_POST['name']) || $_POST['name'] == '') {
// Todo error
echo 'erreur name';
} elseif (!isset($_POST['avatar']) || $_POST['avatar'] == '') {
// Todo error
echo 'erreur avatar';
} else {
$userM = new userManager();
if ($userM->getId($_POST['mail']) == 0) {
$userM->update($id, $_POST['name'], $_POST['avatar'], $_POST['mail']);
// TODO
echo 'L\'utilisateur vient d\'être modifié!';
echo '<script type="text/javascript">dataTable.ajax.reload();</script>';
<?php
session_name("Rentree");
@session_start();
require_once '../config.php';
$_SESSION['existe'] = "FALSE";
$_SESSION['auth'] = "FALSE";
if (!empty($_POST)) {
$_SESSION['courriel'] = chop($_POST['courriel']);
$password = chop($_POST['password']);
if ($password != $cle) {
// password ok ?
$message = array('status' => 400, 'message' => "Le mot de passe n'est pas valide !");
} else {
if (dejaInscrit($_SESSION['courriel'])) {
// deja inscrit ?
$_SESSION['auth'] = "TRUE";
$_SESSION['existe'] = "TRUE";
$message = array('status' => 200, 'message' => "OK");
} else {
$checkMail = mailCheck($_SESSION['courriel']);
if ($checkMail != "OK") {
$message = array('status' => 400, 'message' => $checkMail);
} else {
$_SESSION['auth'] = "TRUE";
$message = array('status' => 200, 'message' => "OK");
}
}
}
echo json_encode($message);
}
while($toItm1 = mysql_fetch_assoc($toRes)){
// --- On met à jour le statut du mail qu'on traite
$zSql = " UPDATE moul_tables_tmp SET mtp_iEtat = 1 " ;
$zSql .= " WHERE mtp_iEtat = 0 AND mtp_id = " . $toItm1['mtp_id'] ;
CBdd::update($zSql);
//echo $toItm1['mtp_id'] . '-' . $toItm1['mtp_zMail'] . ' ' . "\n" ;
$test = 0;
foreach($tResultats as $res){
if($res['mlt_zMail']==$toItm1['mtp_zMail']) $test = 1;
}
if($test == 0){
// --- On on le ckeck
if(mailCheck($toItm1['mtp_zMail'])){
$date = date("Y-m-d H:i:s");
$zSql = " INSERT INTO moul_tables (mlt_id,mlt_zMail,mlt_iListId,mlt_zDateCreation) " ;
$zSql .= " VALUES('','" . $toItm1['mtp_zMail'] . "','" . $toItm1['mtp_iListId'] . "','" . $date . "') " ;
CBdd::insert($zSql) ;
// Insertion de l'adresse mail dans contact avec comme login, passe et nom le nom du compte
$exp_mail = explode('@',$toItm1['mtp_zMail']);
// Les adresses valides venant de la Moulinette a pour opportunité : contactmail
$zSql = " SELECT id FROM opportunite WHERE nom = 'contactmail'" ;
$id_opp = CBdd::select_one($zSql,'id') ;
// La civilité par défaut : 1 => Monsieur
$courriel = addslashes(chop($_POST['courriel']));
$ip = "";
if (getenv("HTTP_CLIENT_IP")) {
$ip = getenv("HTTP_CLIENT_IP");
} else {
if (getenv("HTTP_X_FORWARDED_FOR")) {
$ip = getenv("HTTP_X_FORWARDED_FOR");
} else {
if (getenv("REMOTE_ADDR")) {
$ip = getenv("REMOTE_ADDR");
} else {
$ip = "UNKNOWN";
}
}
}
$checkMail = mailCheck($courriel);
if ($checkMail != "OK") {
$message = array('status' => 400, 'message' => $checkMail);
} else {
if ($_SESSION['existe'] == "TRUE") {
$query = "UPDATE data \r\n SET nom_fils ='" . $nomFils . "', prenom_fils='" . $prenomFils . "', ddn_fils='" . $ddn . "',\r\n tel_mobile='" . $telMobile . "', courriel='" . $courriel . "', date=NOW(), ip='" . $ip . "' WHERE identifiant='" . $_SESSION['courriel'] . "'";
} else {
$query = "INSERT INTO data \r\n (identifiant, nom_fils, prenom_fils, ddn_fils, tel_mobile, courriel, date, ip ) \r\n VALUES ('" . $_SESSION['courriel'] . "', '" . $nomFils . "', '" . $prenomFils . "', '" . $ddn . "', '" . $telMobile . "','" . $courriel . "', NOW(), '" . $ip . "' )";
$_SESSION['existe'] = "TRUE";
}
$DbLink = mysql_connect($DbHost, $DbUser, $DbPassword) or die('erreur de connexion au serveur');
mysql_select_db($DbName) or die('erreur de connexion a la base de donnees');
mysql_query("SET NAMES 'utf8'");
$result = mysql_query($query);
if (!$result) {
$message = array('status' => 400, 'message' => "Requête invalide : " . $query);
// 必須項目のチェック
if ($requiredCheck_flag) {
if (in_array($key, $required)) {
if (empty($val)) {
if ($translation_flag) {
array_push($err_list, translation($key, $translation_list) . 'は必須項目です。');
} else {
array_push($err_list, $key . 'は必須項目です。');
}
}
}
}
// メールアドレスのチェック
if ($mailCheck_flag) {
if ($key == 'mail' && !empty($val)) {
if (!mailCheck($val)) {
array_push($err_list, '[メールアドレス]の形式が正しくありません。');
}
}
}
// チェックボックスの場合、$valを分割
if (is_array($val)) {
$val = implode(",", $val);
}
if ($translation_flag) {
array_push($content_of_inquiry, translation($key, $translation_list) . "\n" . $val);
} else {
array_push($content_of_inquiry, $key . "\n" . $val);
}
}
if (!empty($err_list)) {
function register($method, $name, $password, $avatar, $lastName, $firstName, $mail, $isSendMail = 'TRUE')
{
$authM = new authManager();
$authMethodM = new authMethodManager();
$groupM = new groupManager();
// Check if the user already exist
if ($mail != '' && mailCheck($mail) && $this->getId($mail) == 0) {
// $authM->getId($userId,$methodId) && ($method,$mail,$password) == 0
// Generate a password
$generatedPassword = stringGenerate();
if ($isSendMail == 'TRUE') {
// On envoie le mail de confirmation avec le mot de passe
$sujet = 'Création d\'un compte ' . get_ini('APPLICATION_NAME');
$message = '
Bonjour,<br />
<br />
Voici vos identifiants pour l\'application ' . get_ini('APPLICATION_NAME') . '<br />
Login: <strong>' . $mail . '</strong><br />
Password: <strong>' . $generatedPassword . '</strong><br />
<br />
Merci!<br />
<br />
' . get_ini('ADMIN_MAIL') . '
';
$destinataire = strtolower($mail);
$headers = "From: " . get_ini('ADMIN_MAIL') . "\n";
$headers .= "Reply-To: " . get_ini('ADMIN_MAIL') . "\n";
$headers .= "Content-Type: text/html; charset=\"UTF-8\"";
if (!mail($destinataire, $sujet, $message, $headers)) {
echo "Une erreur c'est produite lors de l'envois de l'email.";
}
}
// On créé l'utilisateur
$q0_last_insert = $this->create($name, $avatar, $mail);
// On ajoute la méthode de connexion locale
$authM->create($q0_last_insert, $authMethodM->getId('LOCAL'), $name, $generatedPassword, $avatar, $lastName, $firstName, $mail);
// On ajoute le groupe par défaut si il y en a un
if (get_ini('default_group') != '') {
$groupM->addGroupUserMap($groupM->getId(get_ini('default_group')), $q0_last_insert);
}
// On ajoute d'éventuelle autre méthode d'authentification (Facebook, google, ...)
switch ($method) {
case 'LDAP':
$authM->create($q0_last_insert, $authMethodM->getId('LDAP'), strtolower($name), '', get_ini('DEFAULT_AVATAR'), '', '', $mail, 'FALSE');
break;
case 'FACEBOOK':
$authM->create($q0_last_insert, $authMethodM->getId('FACEBOOK'), $name, $password, $avatar, $lastName, $firstName, $mail);
break;
case 'GOOGLE':
$authM->create($q0_last_insert, $authMethodM->getId('GOOGLE'), $name, $password, $avatar, $lastName, $firstName, $mail);
break;
}
} else {
// Todo error
}
}
// Le serveur n'a pas répondu
return false;
}
}else{
// Connexion au serveur de messagerie impossible
// vous pouvez afficher le message d'erreur en décommentant la ligne suivante:
// echo $errno."-".$errstr;
return false;
}
}
foreach($zEmail as $mylist){
$mycheck = mailCheck($mylist);
if ( $mycheck ) $test = "OK";
else $test = "KO";
// $mycheck = new CCheckMail($mylist);
// print_r($mylist. " => " .$test."<br />");
// if (validateEmail($mylist, true, true, $expediteur, 'http://panther1.cyber-consult.net'))
// print_r($mylist.' - Adresse valide <br />');
// else
// print_r($mylist.' - Adresse NON valide <br />');
}
$filtre_date_debut = '2011-05-06';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/admin.dwt.php" codeOutsideHTMLIsLocked="false" -->
<p>
<div class="input-group">
<span class="input-group-addon"><i class="icon iconastic-android-mail"></i></span>
<input name="mail" type="email" class="form-control" placeholder="*****@*****.**" value="' . $mail . '">
</div>
</p>
<button type="button" class="btn btn-primary" onClick="popupFormSubmit(\'index.php?m=a&g=core&p=login&a=ldapRegister\',$(\'form#popupForm\').serialize());">
Créer
</button>
';
break;
case 'ldapRegister':
if (!($ad = ldap_connect(get_ini('LDAP_SERVERS')))) {
echo "Couldn't connect to " . get_ini('LDAP_SERVERS') . "!";
}
if (!isset($_POST['mail']) || $_POST['mail'] == '' || !mailCheck(strtolower($_POST['mail']))) {
echo 'Merci de compléter le champ "mail" avec une adresse valide.';
echo '<div id="callBackErrorDiv"></div>';
echo '<script type="text/javascript">$( \'#callBackErrorDiv\' ).load(\'index.php?m=a&g=core&p=login&a=ldapRegisterForm&mail=' . $_POST['mail'] . '&name=' . $_POST['name'] . '&password='******'password'] . '\');</script>';
} elseif (!isset($_POST['name']) || $_POST['name'] == '') {
echo 'Veuillez remplir le champ "login".';
echo '<div id="callBackErrorDiv"></div>';
echo '<script type="text/javascript">$( \'#callBackErrorDiv\' ).load(\'index.php?m=a&g=core&p=login&a=ldapRegisterForm&mail=' . $_POST['mail'] . '&name=' . $_POST['name'] . '&password='******'password'] . '\');</script>';
} elseif (!ldap_bind($ad, $_POST['name'], $_POST['password'])) {
echo 'Vos identifiants semblent incorrects.';
echo '<div id="callBackErrorDiv"></div>';
echo '<script type="text/javascript">$( \'#callBackErrorDiv\' ).load(\'index.php?m=a&g=core&p=login&a=ldapRegisterForm&mail=' . $_POST['mail'] . '&name=' . $_POST['name'] . '&password='******'password'] . '\');</script>';
} else {
$userM = new userManager();
if ($userM->getId($_POST['mail']) > 0) {
echo 'Cette adresse mail est déjà utilisé par l\'un de nos compte. Veuillez utiliser l\'option "mot de passe oublié ?" ou choisir une autre adresse mail.';
