*/ include("../inc/init.php"); $id = isset($_REQUEST['a'])?$_REQUEST['a']:0; // Id de la table email $mail = isset($_REQUEST['m'])?$_REQUEST['m']:''; // Adresse mail $url = isset($_REQUEST['u'])?$_REQUEST['u']:''; // Lien dans le mail automatique if($id > 0) { $zQuery = "SELECT id_groupe, type_envoi FROM email WHERE id = " . $id; $tzData = mysql_fetch_assoc (mysql_query ($zQuery)); if ( ($tzData['type_envoi'] == TYPE_ENVOI_GROUPE) || ($tzData['type_envoi'] == TYPE_ENVOI_USER) ) { $zColIdUser = '******'; $zTableUser = '******'; $user_id = CTableUser::get_id_by_email($mail); } else { $zColIdUser = '******'; $zTableUser = '******'; $user_id = CTableGrUser::get_id_by_email($mail); } // Par précaution sur l'existence de l'utilisateur dans la base if ( $user_id != '' ){ $zSql2 = "SELECT COUNT(*) AS num FROM retour_email WHERE retour_email_id_email ='".$id."' AND " . $zColIdUser . " ='".$user_id."'"; $iNbRowMatch = CBdd::select_one($zSql2,'num'); if ((int)($iNbRowMatch) > 0) { $zSql3 = "UPDATE retour_email SET retour_email_statut='2', retour_email_lien='1' WHERE retour_email_id_email ='".$id."' AND " . $zColIdUser . " = ". $user_id; $resUpdate = CBdd::update($zSql3);