include("../_include/fonctions.php"); $id=$_REQUEST["id"]; $page=$_REQUEST["page"]; if($id!=""){ $tmp=explode('***',$id); $result=requete("SELECT * FROM cpdp_grandstade_inscriptions WHERE id=".$tmp[1]); $res=mysql_fetch_array($result); if($res['date_confirmation']=='0000-00-00'){$result=requete("UPDATE cpdp_grandstade_inscriptions SET date_confirmation='".date("Y-m-d")."' WHERE id=".$tmp[1]);} $result=requete("SELECT * FROM cpdp_grandstade_mailings_stats WHERE (id_mailing=".$tmp[2]." AND id_email=".$tmp[1].")"); $res=mysql_fetch_array($result); if($web!=""){ if($res["link"]!=""){ $link=$res["link"].", ".str_replace("rendu&le","rendu-et-le",str_replace("dates&lieux","dates-et-lieux",str_replace("-et-","&",str_replace("?id2=","?id=",str_replace("}"," ",str_replace("*","#",$web)))))); }else{ $link=str_replace("rendu&le","rendu-et-le",str_replace("dates&lieux","dates-et-lieux",str_replace("-et-","&",str_replace("?id2=","?id=",str_replace("}"," ",str_replace("*","#",$web)))))); } }else{ if($res["link"]!=""){$link=$res["link"].", grandstaderugby.debatpublic.fr";}else{$link="grandstaderugby.debatpublic.fr";} } if($res['view']==0){ requete("UPDATE cpdp_grandstade_mailings_stats SET view=1,date_lecture='".date("Y-m-d")."',link='".$link."' WHERE (id_mailing=".$tmp[2]." AND id_email=".$tmp[1].")"); }else{ requete("UPDATE cpdp_grandstade_mailings_stats SET link='".$link."' WHERE (id_mailing=".$tmp[2]." AND id_email=".$tmp[1].")"); } } mysql_close(); ?>