function delete_user($md5_id) { $sql = "SELECT email FROM user WHERE md5(id) = '".$md5_id."'"; $user_email = CBdd::select_one($sql, 'email'); $sql = "SELECT * FROM email WHERE destinataire LIKE '%".$email."%'"; $result = CBdd::select($sql); $count = mysql_num_rows($result); if(count($count)) { while($email = mysql_fetch_array($result, MYSQL_ASSOC)) { $destinataire = $email['destinataire']; $destinataire = str_replace($user_email, '', $destinataire); $destinataire = str_replace(array(',,', ';;', ';'), ",", $destinataire); $email['destinataire'] = trim($destinataire, ','); if(empty($destinataire)) { $_email = new CTableEmail(array('id'=>$email['id'])); $_email->delete(); } else { //unset($email[id]); $email['text'] = CFunction::addslashes($email['text']); if(empty($email['id_campagne'])) { $email['id_campagne'] = 0; } if(empty($email['id_groupe'])) { $email['id_groupe'] = 0; } $_email = new CTableEmail($email); $_email->update(); } } } $sql = "DELETE FROM user WHERE md5(id) = '" . $md5_id . "'"; return CBdd::delete($sql); }
case 2 : // Modifier etat if(!empty($_GET['id'])) $id = $_GET['id']; if(!empty($_GET['etat'])) $etat = $_GET['etat']; $obj = new CTableEmail(array('id'=>$id, 'etat'=>$etat)); $obj ->update(); break; case 3 : // Supprimer 1 if(!empty($_GET['id'])) $id = $_GET['id']; break; case 33 : // Supprimer 2 if(!empty($_GET['id'])) $id = $_GET['id']; $des = new CTableEmail(array('id'=>$id)); $des ->delete(); break; case 4 : // Ajouter 1 if(!empty($_GET['destinataire'])) $destinataire = trim($_GET['destinataire']); if(!empty($_GET['id_texte'])) $id_texte = trim($_GET['id_texte']); if(!empty($_GET['pj'])) $pj = trim($_GET['pj']); if(!empty($_GET['date'])) $date = trim($_GET['date']); break; case 44 : // Ajouter 2 if(!empty($_POST['destinataire'])) $destinataire = trim($_POST['destinataire']); if(!empty($_POST['id_texte'])) $id_texte = trim($_POST['id_texte']); if(!empty($_POST['pj'])) $pj = trim($_POST['pj']); if(!empty($_POST['date'])) $date = trim($_POST['date']);
break; case 2 : // Modifier etat $id = 0; if(!empty($_GET['id'])) $id = $_GET['id']; CBdd::update('UPDATE email SET etat = 1-etat WHERE id = '.$id); break; case 3 : // Supprimer 1 if(!empty($_GET['id'])) $id = $_GET['id']; break; case 33 : // Supprimer 2 if(!empty($_GET['id'])) $id = $_GET['id']; $email = new CTableEmail(array('id'=>$id)); $email ->delete(); break; case 4 : // Ajouter 1 break; case 44 : // Ajouter 2 if(!empty($_POST['nom'])) $nom = trim($_POST['nom']); if(!empty($_POST['etat'])) $etat = $_POST['etat']; if(!empty($_POST['periode'])) $periode = $_POST['periode'] + 0; $id_texte = !empty($_REQUEST['id_texte'])?$_REQUEST['id_texte']:0; $id_question = !empty($_REQUEST['id_question'])?$_REQUEST['id_question']:0; $texte = CBdd::select_row('SELECT nom FROM texte WHERE id = ' . $id_texte); $question = CBdd::select_row('SELECT nom FROM question WHERE id = ' . $id_question);