$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.';