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);
