0x1998 - MANAGER
Edit File: aj_enregSkill.php
<?php include "config/auth-config.php"; include "config/authcheck.php"; include "config/garde.php"; if (isset($_POST['user'])) $user=$_POST['user']; if (isset($_POST['skill'])) $skill=$_POST['skill']; if (isset($_POST['action'])) $action=$_POST['action']; // on cherche si liste de diffusion if ($action=='ajout') $requete="select list_skill_listediffusion from list_skill where list_skill_id=".$skill; else if ($action=='delete') $requete="select list_skill_listediffusion from list_skill inner join user_skill on user_skill=list_skill_id where id=".$skill; $result = mysqli_query($link,$requete); $row = mysqli_fetch_array($result); $liste=$row['list_skill_listediffusion']; // on cherche l'adresse mail du user $result = mysqli_query($link,"select email from ".PREF."users where id=".$user) or die("requete impossible 2 ..."); $row = mysqli_fetch_array($result); $email=$row['email']; //$email=str_replace('@','=',$email); if ($action=='ajout') { mysqli_query($link,"insert into user_skill (user_id, user_skill) VALUES (".$user.",".$skill.")") or die("requete impossible"); if ($liste!='N') { mailingListAdd($liste, $email); // Construction de l'adresse //$adresse[]=$liste."-subscribe-".$email."@samu92.com"; //envoi_mail_iresu_phpmailer($adresse,'','','','guillaume.douge@samu92.com'); } } else if ($action=='delete') { mysqli_query($link,"delete from user_skill where id='".$skill."'") or die("requete impossible"); if ($liste!='N') { mailingListDel($liste, $email); // Construction de l'adresse //$adresse[]=$liste."-unsubscribe-".$email."@samu92.com"; //envoi_mail_iresu_phpmailer($adresse,'','','','guillaume.douge@samu92.com'); } }