File "admin_events.php"

Full Path: /home/asmplong/www/asm/js/jscripts/tiny_mce/plugins/layer/admin_events.php
File size: 28.33 KB
MIME-type: text/x-php
Charset: utf-8

<?php
include ('inc.top.php');

if(isset($_POST['go_ajout']))
{
	
	$type_event = $_SESSION['type_event'] = strip_tags($_POST['type']);
	$titre_event = $_SESSION['titre_event'] = strip_tags(addslashes($_POST['titre_event']));
	$date_event = $_SESSION['date_event'] = strip_tags($_POST['date_event']);
	$date_butoir = $_SESSION['date_butoir'] = strip_tags($_POST['date_butoir']);
	$id_dp = $_SESSION['user_id'];
	$heure = $_SESSION['heure'] = strip_tags($_POST['heure']);
	$infos = $_SESSION['infos'] =addslashes($_POST['infos']);
	$nb_max = $_SESSION['nb_max'] =$_POST['nb_max'];
	
	if(isset($_POST['limite_n2']))
	{
	$limite_n2 = $_SESSION['limite_n2'] = '1';
	}
	else
	{
	$limite_n2 = $_SESSION['limite_n2'] = '0';	
	}

	if(isset($_POST['limite_n1']))
	{
	$limite_n1 = $_SESSION['limite_n1'] = '1';
	}
	else
	{
	$limite_n1 = $_SESSION['limite_n1'] = '0';	
	}
	
	$date_event_datetime = changedatefrus($date_event);
	
	if($date_butoir != '')
	{
	$date_butoir_datetime = changedatefrus($date_butoir).' 20:00:00';
	}

	$heure = str_replace('h',':',$heure);
	
	$date_event_datetime = $date_event_datetime.' '.$heure.':00';

	$jour_event  = substr($date_event_datetime,8,2);
	$mois_event  = substr($date_event_datetime,5,2);
	$annee_event = substr($date_event_datetime,0,4);
	
	$timestamp_date_event = mktime(0,0,0,$mois_event,$jour_event,$annee_event);

	
	if($_POST['type'] == '0')
	{
		$pb_type = '<div class="false">Veuillez sélectionner un type d\'évènement.</div>';
	}
	elseif(empty($_POST['date_event']))
	{
		$pb_date = '<div class="false">Veuillez sélectionner une date.</div>';
	}
	elseif (($_POST['type'] != '8') && ($_SESSION['timestamp_expiration_certif'] <= $timestamp_date_event)) 
	{
		$pb_valid_certif = '<div class="false">Vous ne pouvez pas créer de plongée à une date ultérieure à celle de validité de votre certificat médical.</div>';		
	}	
	elseif(empty($_POST['heure']))
	{
		$pb_heure = '<div class="false">Veuillez saisir une heure de départ.</div>';
	}
	elseif(($_POST['type'] == '8') && empty($_POST['date_butoir']))
	{
		$pb_heure = '<div class="false">Veuillez saisir une date butoir d\'inscription pour cet événement divers.</div>';
	}
	elseif (($_POST['type'] == '8') && (((convertDatetime(changedatefrus($_POST['date_butoir']).' 00:00:00'))+86400) > (convertDatetime(changedatefrus($_POST['date_event']).' 00:00:00'))))
	{	
		$pb_date = '<div class="false">Veuillez sélectionner une date butoir inférieure à la date de l\'évènement.</div>';
	}
	else
	{


		
		if($type_event == '8')
		{
		$req_verif = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_date='$date_event_datetime' AND event_type='8' ");
		}
		else
		{
		$req_verif = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_date>=('$date_event_datetime'-INTERVAL '04:00' HOUR_MINUTE) AND event_date<=('$date_event_datetime'+INTERVAL '04:00' HOUR_MINUTE) AND event_type!='8'");
		}
		
		if(mysql_num_rows($req_verif) == '0')
		{

			// Ajout en BDD
			$sql_insert = "INSERT INTO ".$db_prefixe."events SET 
			event_id_dp ='$id_dp',
			event_date ='$date_event_datetime',
			event_date_butoir ='$date_butoir_datetime',
			event_heure ='$heure',
			event_infos ='$infos',
			event_type ='$type_event',
			event_limite_n2 ='$limite_n2',	
			event_limite_n1 ='$limite_n1',	
			event_nb_max ='$nb_max',		
			event_statut ='1',
			event_titre ='$titre_event',
			event_date_creation =NOW()";
	
			$req_insert = mysql_query($sql_insert);
			
			$event_id = mysql_insert_id($connect);
	
			// Ajout en BDD
			$sql_insert_inscription = "INSERT INTO ".$db_prefixe."inscriptions SET 
			inscription_id_event ='$event_id',
			inscription_id_membre ='$id_dp',
			inscription_statut ='1',
			inscription_niveau ='1',
			inscription_date=NOW()";
			
			$req_insert_inscription = mysql_query($sql_insert_inscription);
			
			if(($req_insert) && ($req_insert_inscription))
			{
				$ok_ins =  '<div class="true">L\'évènement a été ajouté avec succés.</div>';
				unset($_SESSION['type_event'],$_SESSION['date_event'],$_SESSION['date_butoir'],$_SESSION['heure'],$_SESSION['infos'],$_SESSION['limite_n2'],$_SESSION['limite_n1'],$_SESSION['nb_max'],$_SESSION['titre_event']);
			}
			else
			{
				$pb_ins =  '<div class="false">Un problème est survenu lors de l\'enregistrement.</div>';
			}
			
		}
		else
		{
				$pb_up =  '<div class="false">Désolé, un évènement est déjà organisé à cet horaire.</div>';			
		}
	}
}



if(isset($_POST['go_modif']))
{
	
	$id = $_POST['id'];
	$type_event = strip_tags($_POST['type']);
	$titre_event = strip_tags(addslashes($_POST['titre_event']));
	$date_event =  strip_tags($_POST['date_event']);
	$date_butoir = strip_tags($_POST['date_butoir']);
	$heure = strip_tags($_POST['heure']);
	$infos = addslashes($_POST['infos']);
	$nb_max = $_POST['nb_max'];
	
	if(isset($_POST['limite_n2_modif']))
	{
	$limite_n2  = '1';
	}
	else
	{
	$limite_n2 = '0';	
	}

	if(isset($_POST['limite_n1_modif']))
	{
	$limite_n1  = '1';
	}
	else
	{
	$limite_n1 = '0';	
	}

	if($date_butoir != '')
	{
	$date_butoir = changedatefrus($date_butoir).' 20:00:00';
	}
	
	$date_event = changedatefrus($date_event);
	
	$heure = str_replace('h',':',$heure);
	
	$date_event = $date_event.' '.$heure.':00';


	$jour_event  = substr($date_event_datetime,8,2);
	$mois_event  = substr($date_event_datetime,5,2);
	$annee_event = substr($date_event_datetime,0,4);
	
	$timestamp_date_event = mktime(0,0,0,$mois_event,$jour_event,$annee_event);
	
	if($_POST['type'] == '0')
	{
		$pb_type = '<div class="false">Veuillez sélectionner un type d\'évènement.</div>';
	}
	elseif(empty($_POST['date_event']))
	{
		$pb_date = '<div class="false">Veuillez sélectionner une date.</div>';
	}
	elseif(empty($_POST['heure']))
	{
		$pb_heure = '<div class="false">Veuillez saisir une heure de départ.</div>';
	}
	elseif (($_POST['type'] != '8') && ($_SESSION['timestamp_expiration_certif'] <= $timestamp_date_event)) 
	{
		$pb_valid_certif = '<div class="false">Vous ne pouvez pas créer de plongée à une date ultérieure à celle de validité de votre certificat médical.</div>';		
	}
	elseif(($_POST['type'] == '8') && empty($_POST['date_butoir']))
	{
		$pb_heure = '<div class="false">Veuillez saisir une date butoir d\'inscription pour cet événement divers.</div>';
	}
	elseif (($_POST['type'] == '8') && (((convertDatetime(changedatefrus($_POST['date_butoir']).' 00:00:00'))+86400) > (convertDatetime(changedatefrus($_POST['date_event']).' 00:00:00'))))
	{	
		$pb_date = '<div class="false">Veuillez sélectionner une date butoir inférieure à la date de l\'évènement.</div>';
	}
	else
	{

		if($type_event == '8')
		{
		$req_verif = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_date='$date_event' AND event_id!='$id' AND event_type='8' ");
		}
		else
		{		
		$req_verif = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_date>=('$date_event'-INTERVAL '04:00' HOUR_MINUTE) AND event_date<=('$date_event'+INTERVAL '04:00' HOUR_MINUTE) AND event_type!='8' AND event_id!='$id'");
		}
		
		if(mysql_num_rows($req_verif) == '0')
		{		
			// Ajout en BDD
			$sql_up = "UPDATE ".$db_prefixe."events SET 
			event_date ='$date_event',
			event_date_butoir ='$date_butoir',
			event_heure ='$heure',
			event_infos ='$infos',
			event_type ='$type_event',
			event_limite_n2 ='$limite_n2',		
			event_limite_n1 ='$limite_n1',	
			event_nb_max ='$nb_max',
			event_titre ='$titre_event',
			event_statut ='1'  WHERE event_id='$id'";
	
			$req_up = mysql_query($sql_up);
			
			if($req_up)
			{
				$ok_up =  '<div class="true">L\'évènement a été modifié avec succés.</div>';
			}
			else
			{
				$pb_up =  '<div class="false">Un problème est survenu lors de la modification.</div>';
			}
		}
		else
		{
				$pb_up =  '<div class="false">Désolé, un évènement est déjà organisé à cet horaire.</div>';			
		}
	}
}

?>
			
				
				<h1>Gestion des évènements</h1>

                <div id="tab_cadre">
                
					<ul>
						<li><a href="#fragment-1"><span>Liste des évènements</span></a></li>
						<li><a href="#fragment-2"><span>Ajouter</span></a></li>
						<?php if(isset($_GET['modif']) || isset($_POST['go_modif'])) { echo '<li><a href="#fragment-3"><span>Modifications</span></a></li>'; } ?>
					</ul>
						
						
					<div id="fragment-1" style="margin-bottom:20px;">

						<?php

						// Confirmation avant suppression d'un véhicule
						if(isset($_GET['del']))
						{
						echo '<div class="false">
						
						Etes-vous sur de vouloir supprimer l\'évènement ID <b>'.$_GET['del'].'</b> ?<br/><br/>

						<form action="admin_events.php" method="POST" enctype="multipart/form-data">
							<input type="hidden" value="'.$_GET['del'].'" name="del_id" />
							<input type="submit" class="submit"  name="go_del" value="Oui" />
							<input type="submit" class="submit"  value="Non" />
						</form>
						</div>';
						}
						
						
						
						
						
						// Supression d'un véhicule
						if(isset($_POST['go_del']))
						{
							$id      = $_POST['del_id'];		
							
	
							$req_event = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_id='".$id."'");
							$data_event = mysql_fetch_array($req_event);
							
							$event_type_id = $data_event['event_type'];
							
							$req_type = mysql_query("SELECT * FROM ".$db_prefixe."types_events WHERE type_id = '".$event_type_id."'");
							$data_type = mysql_fetch_array($req_type);
	
							$type_event = utf8_encode($data_type['type_nom']);
						
							$req_inscrits = mysql_query("SELECT * FROM ".$db_prefixe."inscriptions WHERE inscription_id_event='".$id."'");
							
							$liste_mail = '';
							
							while($data_inscrits = mysql_fetch_array($req_inscrits))								
							{
							
								$req_infos_inscrits =  mysql_query("SELECT membre_email FROM ".$db_prefixe."membres WHERE membre_id='".$data_inscrits['inscription_id_membre']."'");
								$data_infos_inscrits = mysql_fetch_array($req_infos_inscrits);
								
								//envoi par email
								include_once('class/class.phpmailer.php');
								
								$mail = new PHPmailer();
								$mail->IsHTML(true);
								$mail->From=$config_email;
								$mail->FromName=utf8_decode($site_name);
								$mail->AddAddress($data_infos_inscrits['membre_email']);
								$mail->AddReplyTo($config_email_no_reply);	
								$mail->Subject=utf8_decode('Annulation : '.$type_event.' ('.changedateusfr2($data_event['event_date']).')');
								
								include_once('mails/mail.annulEvent.php');
								
								$mail->Body=$message;
							
								if($mail->Send())
								{
								$mail->SmtpClose();
								unset($mail);
								$liste_mail .= $data_infos_inscrits['membre_email'].', ';
								}
							}
							
							$req_del = mysql_query("UPDATE  ".$db_prefixe."events SET event_archives='2' WHERE event_id='$id'");
							
							if($req_del)
							{							
																	
								$liste_mail = rtrim($liste_mail,', ');
								echo '<div class="true">L\'évènement ID <b>'.$_POST['del_id'].'</b> a bien été annulé.<br />Un e-mail a été envoyé à chaque inscrit pour l\'en informer ('.$liste_mail.').</div>';							
							}
						}
						?>

						<div style="font-size:14px; text-align:right; padding:10px 0;">
                        	Afficher : <a href="admin_events.php" title="">tous les évènements</a> | <span style="display:inline-block; width:13px; height:13px; background-color:#fff; border:1px solid #eee"></span> <a href="admin_events.php?a-venir" title="">A venir</a> | <span style="display:inline-block; width:13px; height:13px; background-color:#e42a2a; border:1px solid #fff"></span> <a href="admin_events.php?a-archiver" title="">A archiver</a> | <span style="display:inline-block; width:13px; height:13px; background-color:#7afe93; border:1px solid #fff; border-right:none;"></span><span style="display:inline-block; width:13px; height:13px; background-color:#67b1ee; border:1px solid #fff; border-left:none;"></span> <a href="admin_events.php?archives" title="">Archivés</a> | <span style="display:inline-block; width:13px; height:13px; background-color:#999999; border:1px solid #fff"></span> <a href="admin_events.php?annules" title="">Annulés</a>
                        </div>
						<table class="liste">
						

				
							<tr class="intitule">
                            	<td>Directeur de plongée</td>
								<td>Type d'évènement</td>
								<td>Nombre d'inscrits</td>
								<td>Date évènement</td>
								<td></td>
								<td></td>
							</tr>
							
							<?php
							
							$date = date('Y-m-d');
							$annee = date('Y');

							if($_SESSION['user_statut'] == '3')
							{
								if(isset($_GET['a-venir']))
								{
								$req_neuf  = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_date>'$date' AND event_archives!='2' AND YEAR(event_date) >= '".$annee."' ORDER BY event_date DESC");
								}
								elseif(isset($_GET['a-archiver']))
								{
								$req_neuf  = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_date<='$date' AND event_archives='0' AND YEAR(event_date) >= '".$annee."' ORDER BY event_date DESC");
								}
								elseif(isset($_GET['archives']))
								{
								$req_neuf  = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_date<='$date' AND event_archives='1' AND YEAR(event_date) >= '".$annee."' ORDER BY event_date DESC");
								}
								elseif(isset($_GET['annules']))
								{
								$req_neuf  = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_archives='2' AND YEAR(event_date) >= '".$annee."' ORDER BY event_date DESC");
								}
								else
								{
								$req_neuf  = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE YEAR(event_date) >= '".$annee."' ORDER BY event_date DESC");
								}
							} else {

								if(isset($_GET['a-venir']))
								{
								$req_neuf  = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_id_dp='".$_SESSION['user_id']."' AND event_date>'$date' AND event_archives!='2' AND YEAR(event_date) >= '".$annee."' ORDER BY event_date DESC");
								}
								elseif(isset($_GET['a-archiver']))
								{
								$req_neuf  = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_id_dp='".$_SESSION['user_id']."' AND event_date<='$date' AND event_archives='0' AND YEAR(event_date) >= '".$annee."' ORDER BY event_date DESC");
								}
								elseif(isset($_GET['archives']))
								{
								$req_neuf  = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_id_dp='".$_SESSION['user_id']."' AND event_date<='$date' AND event_archives='1' AND YEAR(event_date) >= '".$annee."' ORDER BY event_date DESC");
								}
								elseif(isset($_GET['annules']))
								{
								$req_neuf  = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_id_dp='".$_SESSION['user_id']."' AND event_archives='2' AND YEAR(event_date) >= '".$annee."' ORDER BY event_date DESC");
								}
								else
								{
								$req_neuf  = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_id_dp='".$_SESSION['user_id']."' AND YEAR(event_date) >= '".$annee."' ORDER BY event_date DESC");
								}
							
							}
							
							if(mysql_num_rows($req_neuf)!='0')
							{
					
								// Récupération des membres
							
								while($data_neuf = mysql_fetch_array($req_neuf))
								{
								
									$req_type  = mysql_query("SELECT type_nom FROM ".$db_prefixe."types_events WHERE type_id = '".$data_neuf['event_type']."'");
									$data_type = mysql_fetch_array($req_type);
		
									$req_inscrits_encadrants  = mysql_query("SELECT count(inscription_id) AS total_encadrants FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '".$data_neuf['event_id']."' AND inscription_niveau = '1' AND inscription_statut='1'");
									$data_total_encadrants = mysql_fetch_array($req_inscrits_encadrants);
									
									$req_inscrits_non_encadrants  = mysql_query("SELECT count(inscription_id) AS total_non_encadrants FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '".$data_neuf['event_id']."' AND (inscription_niveau = '0' OR inscription_niveau = '2') AND inscription_statut='1'");
									$data_total_non_encadrants = mysql_fetch_array($req_inscrits_non_encadrants);
									
									$total_encadrants = $data_total_encadrants['total_encadrants'];					
									$total_non_encadrants = $data_total_non_encadrants['total_non_encadrants'];
									
									$total = $total_encadrants + $total_non_encadrants;
									
									
									if($data_neuf['event_date']<=$date)
									{
										if($data_neuf['event_archives']=='0')
										{
											$bg='style="background-color:#e42a2a;"';	
										}
										elseif($data_neuf['event_archives']=='1')
										{
											if($data_neuf['event_type']=='8') {
											$bg='style="background-color:#67b1ee"';
											}
											else {
											$bg='style="background-color:#7afe93"';	
											}
										}
										elseif($data_neuf['event_archives']=='2')
										{
											$bg='style="background-color:#999999; color:#ffffff;"';
										}
									}
									else
									{
										if($data_neuf['event_archives']=='2')
										{
											$bg='style="background-color:#999999; color:#ffffff;"';
										}
										else
										{
											$bg="";
										}
									}				
									
							
									$req_membre  = mysql_query("SELECT membre_nom, membre_prenom FROM ".$db_prefixe."membres WHERE membre_id='".$data_neuf['event_id_dp']."' ORDER BY membre_id DESC");
									$data_membre = mysql_fetch_array($req_membre);
									
									echo '<tr '.$bg.'>
										  <td>'.$data_membre['membre_nom'].' '.$data_membre['membre_prenom'].'</td>
										  <td><a href="event_detail.php?id='.$data_neuf['event_id'].'" target="_blank">'.utf8_encode($data_type['type_nom']).'</a></td>
										  <td><strong>'.$total.'</strong> (dont <strong>'.$total_encadrants.'</strong> encadrants)</td>
										  <td>Le '.changedateusfr($data_neuf['event_date']).' à '.$data_neuf['event_heure'].'</td>
										  </td><td><a href="admin_events.php?modif='.$data_neuf['event_id'].'" title="Modifier"><img src="img/edit.gif" alt="Modifier" /></a></td>
										  <td><a href="admin_events.php?del='.$data_neuf['event_id'].'" title="Supprimer"><img src="img/del.gif" alt="Supprimer" /></a></td>
										  </tr>';
								}
							}
							?>
												
						</table>
						
					</div>
					
					<div id="fragment-2" style="margin-bottom:20px;">

	<?php				
	if(isset($pb_type))
	{
		echo $pb_type;
	}
	elseif(isset($pb_date))
	{
		echo $pb_date;
	}
	elseif(isset($pb_heure))
	{
		echo $pb_heure;
	}
	elseif(isset($pb_valid_certif))
	{
		echo $pb_valid_certif;	
	}
	elseif(isset($pb_ins))
	{
		echo $pb_ins;
	}
	elseif(isset($ok_ins))
	{
		echo $ok_ins;
	}
	?>	
					
						<form action="admin_events.php" method="POST" enctype="multipart/form-data">
							<table class="form">
                            	<tr><td class="first">DP/Organisateur</td><td><strong><?php echo strtoupper($_SESSION['user_prenom'].' '.$_SESSION['user_nom']); ?></strong></td></tr>
								<tr><td class="first">Type d'évènement</td><td>
                               <select name="type" id="types_events">
                                    <option value="0">Choisissez un type...</option>                                
                                <?php

									$req_recup_type  = mysql_query("SELECT * FROM types_events ORDER BY type_nom DESC"); 
									while($data_type = mysql_fetch_array($req_recup_type))
									{
									
										// pour le membre OED, on ne leur affiche que les evenements divers
										if(($_SESSION['user_statut'] == '5') && ($data_type['type_id'] == '8'))
										{											
											echo '<option value="'.$data_type['type_id'].'"';
							
											if(isset($_SESSION['type_event']) && ($_SESSION['type_event'] == $data_type['type_id'])) { echo 'selected'; }
							
											echo '>'.utf8_encode($data_type['type_nom']).'</option>';
										}
										elseif(($_SESSION['user_statut'] == '2') || ($_SESSION['user_statut'] == '3'))
										{
											echo '<option value="'.$data_type['type_id'].'"';
							
											if(isset($_SESSION['type_event']) && ($_SESSION['type_event'] == $data_type['type_id'])) { echo 'selected'; }
							
											echo '>'.utf8_encode($data_type['type_nom']).'</option>';											
										}
									}
                   			    ?>
								</select>
                                
                                </td></tr>

								
                <tr id="titre_ed" style="display:none;"><td class="first">Titre</td><td><input type="text" id="titre_event" class="inputText" name="titre_event" <?php if (isset($_SESSION['titre_event'])) { echo 'value="'.$_SESSION['titre_event'].'"'; } ?> /></td></tr>
                
                <tr><td class="first">Date</td><td><input type="text" id="date_event" readonly class="inputText" name="date_event" <?php if (isset($_SESSION['date_event'])) { echo 'value="'.$_SESSION['date_event'].'"'; } ?> /> <div id="div_date_butoir_add" style="display:none;">Date butoir inscription : <input type="text" id="date_butoir" readonly class="inputText" name="date_butoir" <?php if (isset($_SESSION['date_butoir'])) { echo 'value="'.$_SESSION['date_butoir'].'"'; } ?> /></div></td></tr>
                                
                                <tr><td class="first">Heure de départ</td><td><select name="heure" id="heures"></select></td></tr>
                                <tr id="nb_plongeurs"><td class="first">Nombre de plongeurs maximum</td><td><select name="nb_max"><?php for($i=1; $i<=25; $i++) { if($i == '25') { $selected = 'selected'; } else { $selected = ''; } echo '<option '.$selected.'>'.$i.'</option>'; } ?></select></td></tr>
                                <tr class="first" id="limite_n2_tr" style="display:none;"><td class="first">Cocher pour limiter à partir</td><td> du N1 <input name="limite_n1" id="limite_n1" value="1" type="checkbox" />
                                																										   <br /> du N2 <input name="limite_n2" id="limite_n2" value="1" type="checkbox" /></td></tr>
								
								<tr><td class="first">Informations</td><td><textarea style="width:500px" name="infos"><?php if (isset($_SESSION['infos'])) { echo stripslashes($_SESSION['infos']); } ?></textarea></td></tr>
								<tr><td class="first"></td><td><input type="submit" class="submit" name="go_ajout" value="Ajouter" /></td></tr>
							</table>
						</form>


					</div>
                    
                    <?php
					if(isset($_GET['modif']) || isset($_POST['go_modif']))
                    {
					?>
					
					<div id="fragment-3" style="margin-bottom:20px;">

					
						<?php				
                        if(isset($pb_type))
                        {
                            echo $pb_type;
                        }
                        elseif(isset($pb_date))
                        {
                            echo $pb_date;
                        }
                        elseif(isset($pb_heure))
                        {
                            echo $pb_heure;
                        }
						elseif(isset($pb_valid_certif))
						{
							echo $pb_valid_certif;	
						}
						elseif(isset($pb_up))
						{
							echo $pb_up;
						}
						elseif(isset($ok_up))
						{
							echo $ok_up;
						}

                        
                            if(isset($_GET['modif']))
                            {
                            $recup_id = $_GET['modif'];
                            }
                            elseif(isset($_POST['go_modif']))
                            {
                            $recup_id = $_POST['id'];
                            }
                            
                            $req_recup = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_id=$recup_id;");
                            $data_recup = mysql_fetch_array($req_recup);
						
						?>	



						<form action="admin_events.php" method="POST" enctype="multipart/form-data">
							<table class="form">
                            	<tr><td class="first">DP/Organisateur</td><td><input type="hidden" name="id" value="<?php echo $recup_id; ?>" /><strong> <?php $req_dp_info = mysql_query("SELECT * FROM ".$db_prefixe."membres WHERE membre_id = '".$data_recup['event_id_dp']."'"); $data_dp_info = mysql_fetch_array($req_dp_info); echo $data_dp_info['membre_nom'].' '.$data_dp_info['membre_prenom'];  ?></strong></td></tr>
								<tr><td class="first">Type d'évènement</td><td>
                               <select name="type" id="types_events_modif">
                                    <option value="0">Choisissez un type...</option>                                
                                <?php

									$req_recup_type  = mysql_query("SELECT * FROM types_events ORDER BY type_nom DESC"); 
									while($data_type = mysql_fetch_array($req_recup_type))
									{
										// pour le membre OED, on ne leur affiche que les evenements divers
										if(($_SESSION['user_statut'] == '5') && ($data_type['type_id'] == '8'))
										{											
											echo '<option value="'.$data_type['type_id'].'"';
											
											if (isset($data_recup['event_type']) && ($data_recup['event_type'] == $data_type['type_id'])) { echo 'selected'; }
							
											echo '>'.utf8_encode($data_type['type_nom']).'</option>';
										}
										elseif(($_SESSION['user_statut'] == '2') || ($_SESSION['user_statut'] == '3'))
										{
											echo '<option value="'.$data_type['type_id'].'"';
											
											if (isset($data_recup['event_type']) && ($data_recup['event_type'] == $data_type['type_id'])) { echo 'selected'; }
							
											echo '>'.utf8_encode($data_type['type_nom']).'</option>';								
										}

									}
                   			    ?>
								</select>
                                
                                </td></tr>

								<tr id="titre_ed_modif" <?php if($data_recup['event_type'] == '8')  { ?> style="display:none;" <?php } ?>><td class="first">Titre</td><td><input type="text" id="titre_event_modif" class="inputText" name="titre_event" <?php if (isset($data_recup['event_titre'])) { echo 'value="'.$data_recup['event_titre'].'"'; } ?> /></td></tr>
                
                <tr><td class="first">Date</td><td><input type="text" id="date_event_modif" readonly class="inputText" name="date_event" <?php if (isset($data_recup['event_date'])) { echo 'value="'.changedateusfr2($data_recup['event_date']).'"'; } ?> /> <div id="div_date_butoir" style="display:none;">Date butoir inscription : <input type="text" id="date_butoir_modif" readonly class="inputText" name="date_butoir" <?php if (isset($data_recup['event_date_butoir'])) { echo 'value="'.changedateusfr2($data_recup['event_date_butoir']).'"'; } ?> /></div></td></tr>
								
								<tr><td class="first">Heure de départ</td><td><input type="hidden" value="<?php if (isset($data_recup['event_heure'])) { echo $data_recup['event_heure']; } ?>" name="heureEvent" id="heureEvent" /><select name="heure" id="heures_modif"></select></td></tr>
                                <tr id="nb_plongeurs_modif" <?php if($data_recup['event_type'] == '8')  { ?> style="display:none;" <?php } ?>><td class="first">Nombre de plongeurs maximum</td><td><select name="nb_max" id="nb_max_modif"><?php for($i=1; $i<=25; $i++) { if ($data_recup['event_nb_max'] == $i) { $selected= "selected";  } else { $selected = ''; } echo '<option  '.$selected.'>'.$i.'</option>'; } ?></select></td></tr>
                                <tr class="first" id="limite_n2_modif_tr" <?php if(($data_recup['event_type'] == '1') || ($data_recup['event_type'] == '2') || ($data_recup['event_type'] == '4') || ($data_recup['event_type'] == '5') || ($data_recup['event_type'] == '7')) { } else { ?> style="display:none;" <?php } ?>><td class="first">Cocher pour limiter à partir</td><td> du N1 <input name="limite_n1_modif" id="limite_n1_modif" value="1" type="checkbox"  <?php if (isset($data_recup['event_limite_n1']) && ($data_recup['event_limite_n1'] == '1')) { echo 'checked="checked"'; } ?> />
                                																   <br /> du N2 <input name="limite_n2_modif" id="limite_n2_modif" value="1" type="checkbox"  <?php if (isset($data_recup['event_limite_n2']) && ($data_recup['event_limite_n2'] == '1')) { echo 'checked="checked"'; } ?> /></td></tr>

								<tr><td class="first">Informations</td><td><textarea style="width:500px" name="infos"><?php if (isset($data_recup['event_infos'])) { echo stripslashes($data_recup['event_infos']); } ?></textarea></td></tr>
								<tr><td class="first"></td><td><input type="submit" class="submit" name="go_modif" value="Ajouter" /></td></tr>
							</table>
						</form>



					</div>
					<?php
					}
					?>	
				</div>

<?php
include ('inc.foot.php');
?>