芝麻web文件管理V1.00

编辑当前文件:/home/a/s/m/asmplong/www/asm/scripts/waitingToRegister.php

<?php
include('../inc.conec.php');
include('../inc.fonctions.php');
include('../inc.config.php');

$date = strftime("%Y-%m-%d", mktime(0, 0, 0, date('m'), date('d')+1, date('Y')));

$req_event = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE DATE_FORMAT(event_date, '%Y-%m-%d')='$date' AND event_type!='8'");

while($data_event = mysql_fetch_array($req_event))
{
	
	$id_event = $data_event['event_id'];

$req_type = mysql_query("SELECT * FROM ".$db_prefixe."types_events WHERE type_id = '".$data_event['event_type']."'");
	$data_type = mysql_fetch_array($req_type);
	
	$type_event = utf8_encode($data_type['type_nom']);

if($data_event['event_type'] == 6)
	{
		
		
		
		$req_waiting = mysql_query("SELECT * FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '$id_event' AND inscription_statut='0' ORDER BY inscription_date ASC");
		
		while($data_waiting = mysql_fetch_array($req_waiting))
		{
			
			$req_encadrants = mysql_query("SELECT * FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '".$data_event['event_id']."' AND inscription_niveau = '1' AND inscription_statut = '1' ORDER BY inscription_id ASC");
			$nb_encadrants = mysql_num_rows($req_encadrants);

$req_baptemes = mysql_query("SELECT * FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '".$data_event['event_id']."' AND (inscription_niveau = '0' OR inscription_niveau = '2') AND inscription_id_membre IN (SELECT membre_id FROM ".$db_prefixe."membres WHERE membre_niveau = 'Bapt') AND inscription_statut = '1' ORDER BY inscription_id ASC");			
			$nb_baptemes = mysql_num_rows($req_baptemes);

if($nb_baptemes!='0')
			{
								
				$ratio_limite='0.5';
				
				$ratio = $nb_encadrants/$nb_baptemes;
				
				$req_membre = mysql_query("SELECT * FROM ".$db_prefixe."membres WHERE membre_id='".$data_waiting['inscription_id_membre']."'");
				$data_membre = mysql_fetch_array($req_membre);
	
				$req_nb_inscrits = mysql_query("SELECT inscription_id AS total FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '$id_event' AND inscription_statut='1'");
				$total_inscrits = mysql_num_rows($req_nb_inscrits);
			
				if(($total_inscrits < '25') && (($ratio>$ratio_limite) || (($data_membre['membre_niveau']=='N0') || ($data_membre['membre_niveau']=='N1') || ($data_membre['membre_niveau']=='N2') || ($data_membre['membre_niveau']=='N3') || ($data_membre['membre_niveau']=='N4') || ($data_membre['membre_niveau']=='N5') || ($data_membre['membre_niveau']=='E1') || ($data_membre['membre_niveau']=='E2') || ($data_membre['membre_niveau']=='E3') || ($data_membre['membre_niveau']=='E4') || ($data_membre['membre_niveau']=='E5'))))
				{
				
					$req_up_new_plongeurs = mysql_query("UPDATE ".$db_prefixe."inscriptions SET inscription_statut='1' where inscription_id='".$data_waiting['inscription_id']."'");
										
					if($req_up_new_plongeurs)
					{
						
						//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_membre['membre_email']);
						$mail->AddBCC('contact@bluefrog.fr');
						$mail->AddReplyTo($config_email_no_reply);	
						$mail->Subject=utf8_decode('Confirmation de votre place : '.$type_event);
						
						include_once('../mails/mail.newplongeur.php');
						
						$mail->Body=$message;
					
						if($mail->Send())
						{
						$mail->SmtpClose();
						unset($mail);
						}
					}				
					
				}
			
			}
			else
			{

$req_membre = mysql_query("SELECT * FROM ".$db_prefixe."membres WHERE membre_id='".$data_waiting['inscription_id_membre']."'");
				$data_membre = mysql_fetch_array($req_membre);
	
				$req_nb_inscrits = mysql_query("SELECT inscription_id AS total FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '$id_event' AND inscription_statut='1'");
				$total_inscrits = mysql_num_rows($req_nb_inscrits);
			
				if(($total_inscrits < '25') && (($data_membre['membre_niveau']=='N0') || ($data_membre['membre_niveau']=='N1') || ($data_membre['membre_niveau']=='N2') || ($data_membre['membre_niveau']=='N3') || ($data_membre['membre_niveau']=='N4') || ($data_membre['membre_niveau']=='N5') || ($data_membre['membre_niveau']=='E1') || ($data_membre['membre_niveau']=='E2') || ($data_membre['membre_niveau']=='E3') || ($data_membre['membre_niveau']=='E4') || ($data_membre['membre_niveau']=='E5')))
				{
				
					$req_up_new_plongeurs = mysql_query("UPDATE ".$db_prefixe."inscriptions SET inscription_statut='1' where inscription_id='".$data_waiting['inscription_id']."'");
										
					if($req_up_new_plongeurs)
					{
						
						//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_membre['membre_email']);
						$mail->AddBCC('contact@bluefrog.fr');
						$mail->AddReplyTo($config_email_no_reply);	
						$mail->Subject=utf8_decode('Confirmation de votre place : '.$type_event);
						
						include_once('../mails/mail.newplongeur.php');
						
						$mail->Body=$message;
					
						if($mail->Send())
						{
						$mail->SmtpClose();
						unset($mail);
						}
					}				
					
				}			
				
			}
			
		}
				
	}
	elseif(($data_event['event_type'] == 1) || ($data_event['event_type'] == 2))
	{

$req_waiting = mysql_query("SELECT * FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '$id_event' AND inscription_statut='0' ORDER BY inscription_date ASC");
		
		while($data_waiting = mysql_fetch_array($req_waiting))
		{
			
			$req_encadrants = mysql_query("SELECT * FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '".$data_event['event_id']."' AND inscription_niveau = '1' AND inscription_statut = '1' ORDER BY inscription_id ASC");
			$nb_encadrants = mysql_num_rows($req_encadrants);

if($nb_plongeurs!='0')
			{
			
				$ratio_limite='0.5';
				
				$ratio = $nb_encadrants/$nb_plongeurs;
				
				$req_membre = mysql_query("SELECT * FROM ".$db_prefixe."membres WHERE membre_id='".$data_waiting['inscription_id_membre']."'");
				$data_membre = mysql_fetch_array($req_membre);
	
				$req_nb_inscrits = mysql_query("SELECT inscription_id AS total FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '$id_event' AND inscription_statut='1'");
				$total_inscrits = mysql_num_rows($req_nb_inscrits);
			
				if(($total_inscrits < '25') && (($ratio>$ratio_limite) || (($data_membre['membre_niveau']=='N2') || ($data_membre['membre_niveau']=='N3') || ($data_membre['membre_niveau']=='N4') || ($data_membre['membre_niveau']=='N5') || ($data_membre['membre_niveau']=='E1') || ($data_membre['membre_niveau']=='E2') || ($data_membre['membre_niveau']=='E3') || ($data_membre['membre_niveau']=='E4') || ($data_membre['membre_niveau']=='E5'))))
				{
				
					$req_up_new_plongeurs = mysql_query("UPDATE ".$db_prefixe."inscriptions SET inscription_statut='1' where inscription_id='".$data_waiting['inscription_id']."'");
										
					if($req_up_new_plongeurs)
					{
						
						//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_membre['membre_email']);
						$mail->AddBCC('contact@bluefrog.fr');
						$mail->AddReplyTo($config_email_no_reply);	
						$mail->Subject=utf8_decode('Confirmation de votre place : '.$type_event);
						
						include_once('../mails/mail.newplongeur.php');
						
						$mail->Body=$message;
					
						if($mail->Send())
						{
						$mail->SmtpClose();
						unset($mail);
						}
					}				
					
				}
			}
			else
			{
				
				$req_membre = mysql_query("SELECT * FROM ".$db_prefixe."membres WHERE membre_id='".$data_waiting['inscription_id_membre']."'");
				$data_membre = mysql_fetch_array($req_membre);
	
				$req_nb_inscrits = mysql_query("SELECT inscription_id AS total FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '$id_event' AND inscription_statut='1'");
				$total_inscrits = mysql_num_rows($req_nb_inscrits);
			
				if(($total_inscrits < '25') && (($data_membre['membre_niveau']=='N2') || ($data_membre['membre_niveau']=='N3') || ($data_membre['membre_niveau']=='N4') || ($data_membre['membre_niveau']=='N5') || ($data_membre['membre_niveau']=='E1') || ($data_membre['membre_niveau']=='E2') || ($data_membre['membre_niveau']=='E3') || ($data_membre['membre_niveau']=='E4') || ($data_membre['membre_niveau']=='E5')))
				{
				
					$req_up_new_plongeurs = mysql_query("UPDATE ".$db_prefixe."inscriptions SET inscription_statut='1' where inscription_id='".$data_waiting['inscription_id']."'");
										
					if($req_up_new_plongeurs)
					{

}
	else
	{

$req_plongeurs = mysql_query("SELECT * FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '".$data_event['event_id']."' AND inscription_niveau = '0' AND inscription_statut = '1' ORDER BY inscription_id ASC");		
			$nb_plongeurs = mysql_num_rows($req_plongeurs);
			
			
			if($nb_plongeurs!='0')
			{			
			
				$ratio_limite='0.25';
				
				$ratio = $nb_encadrants/$nb_plongeurs;
				
				$req_membre = mysql_query("SELECT * FROM ".$db_prefixe."membres WHERE membre_id='".$data_waiting['inscription_id_membre']."'");
				$data_membre = mysql_fetch_array($req_membre);
	
				$req_nb_inscrits = mysql_query("SELECT inscription_id AS total FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '$id_event' AND inscription_statut='1'");
				$total_inscrits = mysql_num_rows($req_nb_inscrits);
			
				if(($total_inscrits < '25') && (($ratio>$ratio_limite) || (($data_membre['membre_niveau']=='N2') || ($data_membre['membre_niveau']=='N3') || ($data_membre['membre_niveau']=='N4') || ($data_membre['membre_niveau']=='N5') || ($data_membre['membre_niveau']=='E1') || ($data_membre['membre_niveau']=='E2') || ($data_membre['membre_niveau']=='E3') || ($data_membre['membre_niveau']=='E4') || ($data_membre['membre_niveau']=='E5'))))
				{
				
					$req_up_new_plongeurs = mysql_query("UPDATE ".$db_prefixe."inscriptions SET inscription_statut='1' where inscription_id='".$data_waiting['inscription_id']."'");
										
					if($req_up_new_plongeurs)
					{

//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_membre['membre_email']);
						$mail->AddBCC('contact@bluefrog.fr');
						$mail->AddReplyTo($config_email_no_reply);	
						$mail->Subject=utf8_decode('Confirmation de votre place : '.$type_event);
						
						include_once('../mails/mail.newplongeur.php');
						
						$mail->Body=$message;
					
						if($mail->Send())
						{
						$mail->SmtpClose();
						unset($mail);
						}
					}				
					
				}
			}
			else
			{
				
				
				$req_membre = mysql_query("SELECT * FROM ".$db_prefixe."membres WHERE membre_id='".$data_waiting['inscription_id_membre']."'");
				$data_membre = mysql_fetch_array($req_membre);
	
				$req_nb_inscrits = mysql_query("SELECT inscription_id AS total FROM ".$db_prefixe."inscriptions WHERE inscription_id_event = '$id_event' AND inscription_statut='1'");
				$total_inscrits = mysql_num_rows($req_nb_inscrits);
			
				if(($total_inscrits < '25') || (($data_membre['membre_niveau']=='N2') || ($data_membre['membre_niveau']=='N3') || ($data_membre['membre_niveau']=='N4') || ($data_membre['membre_niveau']=='N5') || ($data_membre['membre_niveau']=='E1') || ($data_membre['membre_niveau']=='E2') || ($data_membre['membre_niveau']=='E3') || ($data_membre['membre_niveau']=='E4') || ($data_membre['membre_niveau']=='E5')))
				{
				
					$req_up_new_plongeurs = mysql_query("UPDATE ".$db_prefixe."inscriptions SET inscription_statut='1' where inscription_id='".$data_waiting['inscription_id']."'");
										
					if($req_up_new_plongeurs)
					{
						
						//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_membre['membre_email']);
						$mail->AddBCC('contact@bluefrog.fr');
						$mail->AddReplyTo($config_email_no_reply);	
						$mail->Subject=utf8_decode('Confirmation de votre place : '.$type_event);
						
						include_once('../mails/mail.newplongeur.php');
						
						$mail->Body=$message;
					
						if($mail->Send())
						{
						$mail->SmtpClose();
						unset($mail);
						}
					}				
					
				}
			
			}
		}

}

$date_evt_divers = strftime("%Y-%m-%d", mktime(0, 0, 0, date('m'), date('d'), date('Y')));

//Archivage des évènements divers le jour de leur déroulement
$req_event_divers = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE DATE_FORMAT(event_date, '%Y-%m-%d')='$date_evt_divers' AND event_type='8'");

while($data_event_divers = mysql_fetch_array($req_event_divers))
{
	
	$id_event_divers = $data_event_divers['event_id'];
	
	$req_up_event = mysql_query("UPDATE ".$db_prefixe."events SET event_archives ='1' WHERE event_id='$id_event_divers'");
	
	// MAJ inscrption présence
	$req_up_inscription = mysql_query("UPDATE ".$db_prefixe."inscriptions SET inscription_present ='1' WHERE inscription_id_event='$id_event_divers'");

}
?>