1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
|
<?
if($_SESSION['auth']=='yes'){
$db = mysql_connect('xxx', 'xxx', 'xxxx') or die('Erreur de connexion '.mysql_error());
mysql_select_db('xxxx',$db) or die('Erreur de selection '.mysql_error());
$sql = "SELECT * FROM requete WHERE id_ticket='".$_GET['id_ticket']."' AND master='1'";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while($data = mysql_fetch_assoc($req)){
$message= $_POST['message'];
$message= nl2br($message);
if($data['id_sender']==$_SESSION['id'] || $_SESSION['adm']=="yes"){
if($_SESSION['adm']=='yes'){
$sql = "INSERT INTO requete(id,id_ticket,message,type,etat,date,id_sender,sujet,date_last_modif,adm) VALUES('','".$_GET['id_ticket']."','".$message."','','',NOW(),'".$data['id_sender']."','','','".$_SESSION['id']."')";
}else{
$sql = "INSERT INTO requete(id,id_ticket,message,type,etat,date,id_sender,sujet,date_last_modif,adm) VALUES('','".$_GET['id_ticket']."','".$message."','','',NOW(),'".$_SESSION['id']."','','','')";
}
mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
if($_SESSION['adm']=='yes'){
$sql = "UPDATE requete SET date_last_modif=NOW(),etat=2 WHERE id_ticket='".$_GET['id_ticket']."' AND master='1'";
}else{
$sql = "UPDATE requete SET date_last_modif=NOW(),etat=1 WHERE id_ticket='".$_GET['id_ticket']."' AND master='1'";
}
mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
if($_SESSION['adm']=='yes'){
$sql1 = "SELECT nom,prenom,mail FROM users WHERE id='".$_SESSION['id']."'";
$req1 = mysql_query($sql1) or die('Erreur SQL !<br>'.$sql1.'<br>'.mysql_error());
while($data1 = mysql_fetch_assoc($req1)){
mail_entete("Bonjour ".$data['prenom']." ".$data['nom'].",\n \n contenu du mail ","libelle du mail","2",$data1['mail']);
}
}else{
mail_entete("Un nouveau message d'un utilisateur à été envoyé\n Contenu:$message","NOUVEAU MESSAGE ","1","");
}
print"<center><img src=image/wait.png width=256 height=256 /><br /><b>Votre message a bien été envoyé!</b><br /> ;
}
}
}else{
$error_mess = "Vous avez été déconnecté!";
include("connection.php");
}
?> |
Partager