PHP|Débutant :: Forums

if ($version == "") {
   $version = $_GET['version'];  
}
// on regarde quel version du cron lancer
if ($version == "beta"){
  $chemin = "/home/ebouilleur/pet-racing/beta/";
} elseif ($version == "officiel") {
  $chemin = "/home/ebouilleur/pet-racing/www/";
} else {
  echo "<b>Bug, pas de version de sélectionné !!</b>";
  exit;
}
$minutes = date("i");

if ($minutes==0 OR $minutes==20 OR $minutes==40){$go_statut1 = TRUE;}
if ($minutes==10 OR $minutes==30 OR $minutes==50){$go_statut2 = TRUE; }
if ($minutes==11 OR $minutes==31 OR $minutes==51){$go_statut3 = TRUE;}

include ($chemin.'bdd/bdd_beta.php');
//include ($chemin.'fonctions/course.php');  
//include ($chemin.'fonctions/divers.php');  

try{
if ($go_statut1 == TRUE){
/*********************************
 * On regarde si il y a des courses à mettre au statut 1 (soit Prêt à partir)
 *  *********************************/
// on met a jours les pet qui ne pourront pas participer
$select = "UPDATE course_participant,pet,course
    SET course_participant.statut_pet=2
    WHERE course_participant.id_course=course.id_course AND course_participant.id_pet=pet.id_pet AND course.statut=0 AND pet.oqp!=0 AND (UNIX_TIMESTAMP(course.depart_theorique)-UNIX_TIMESTAMP(NOW()))<=600 ";  
$result = mysql_query($select);
if ($result===false){throw new Exception("Erreur de sélection des courses<br>$sqlUp<br>".mysql_error()."",E_USER_NOTICE);}
 // création de la table memory course
$requete="CREATE TABLE `m_course` (
      `id` int(10) unsigned NOT NULL auto_increment,
      `id_course` int(10) unsigned NOT NULL,
      `id_pet` int(10) unsigned NOT NULL,
      `oqp` tinyint(3) unsigned NOT NULL,
      `statut` tinyint(3) unsigned NOT NULL,
      `nbparticipants` tinyint(3) unsigned NOT NULL,
      PRIMARY KEY (`id`),
      KEY `idx_course` (`id_course`),
      KEY `idx_pet` (`id_pet`),
      KEY `idx_statut` (`statut`)
    ) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci";
$result = mysql_query($requete);
if ($result===false){throw new Exception("Erreur de création de la table memory course",E_USER_NOTICE);}
// on remplit la table m_course de toutes les infos
$select = "INSERT INTO m_course (id_course, id_pet, oqp, statut, nbparticipants)
     SELECT CP.id_course, CP.id_pet, t1.oqp, C.statut, COUNT(P.id_pet) as nbparticipants
     FROM course_participant AS CP
     LEFT JOIN (SELECT id_course,id_pet FROM course_participant) AS P ON CP.id_course=P.id_course
     LEFT JOIN (SELECT id_pet, oqp FROM pet) as t1 ON t1.id_pet=CP.id_pet
     LEFT JOIN course AS C ON CP.id_course=C.id_course
     WHERE (UNIX_TIMESTAMP(depart_theorique)-UNIX_TIMESTAMP(NOW()))<=600 AND statut=0 GROUP BY CP.id_pet ";  
$result = mysql_query($select);
if ($result===false){throw new Exception("Erreur de remplissage de la table memory course",E_USER_NOTICE);}

// on met a jour le statut oqp du pet a 4 et on cloture les inscriptions de la course si il y a plus de 4 pet
$sqlUp = "UPDATE course,pet,m_course
          SET course.statut=1, course.nbparticipants=m_course.nbparticipants, pet.oqp=4
          WHERE course.id_course=m_course.id_course AND pet.id_pet=m_course.id_pet AND m_course.nbparticipants>4 ";
mysql_query($sqlUp);
if ($result===false){throw new Exception("Erreur update course ok",E_USER_NOTICE);}
// on met a jour le statut de la course si il y a moins de 4 pet
$sqlUp = "UPDATE course, pet, m_course
          SET course.statut=4, course.nbparticipants=m_course.nbparticipants
          WHERE course.id_course=m_course.id_course AND pet.id_pet=m_course.id_pet AND m_course.nbparticipants<=4 ";
$result = mysql_query($sqlUp) ;
if ($result===false){throw new Exception("Erreur update course annulée",E_USER_NOTICE);}
// on efface la table m_course
$sqlDel = "DROP TABLE m_course ";
$result = mysql_query($sqlDel);
if ($result===false){throw new Exception("Erreur de suppression de la table memory course",E_USER_NOTICE);}

echo "<b>Cloture des inscription aux courses réalisés</b>";
}#go_statut1

if ($go_statut2 == TRUE){
/*********************************
 * On regarde si il y a des courses à mettre au statut 2 (soit Course lancée)
 *  *********************************/
 
  $sqlUp = "UPDATE course
            SET statut=2, depart=NOW()
            WHERE UNIX_TIMESTAMP(depart_theorique) <= UNIX_TIMESTAMP(NOW()) AND statut='1' ";
  $result=mysql_query($sqlUp);
  if ($result===false){throw new Exception("Erreur de Maj course au statut 2",E_USER_NOTICE);}
} #$go_statut2

if ($go_statut3 == TRUE){

// On commence par clôturer les courses en cours qui sont terminées.
$sqlUp = "UPDATE course,pet
          SET course.statut=3, pet.oqp=0
          WHERE (UNIX_TIMESTAMP(depart_theorique)+duree*120) <= UNIX_TIMESTAMP(NOW()) AND statut='2' ";
mysql_query($sqlUp);
if ($result===false){throw new Exception("Erreur de Maj cloture course",E_USER_NOTICE);}

 // création de la table memory course
$requete="CREATE TABLE `m_course2` (
      `id` int(10) unsigned NOT NULL auto_increment,
      `id_course` int(10) unsigned NOT NULL,
      `id_pet` int(10) unsigned NOT NULL,
      `dist_parcourue` DECIMAL(8,2) unsigned NOT NULL,
      `nbparticipants` tinyint(3) unsigned NOT NULL,
      PRIMARY KEY (`id`),
      KEY `idx_course` (`id_course`),
      KEY `idx_pet` (`id_pet`)
    ) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci";
$result2 = mysql_query($requete);
if ($result2===false){throw new Exception("Erreur de creation de la table m_course2",E_USER_NOTICE);}    
     
  $sql7="INSERT INTO m_course2 (id_course, id_pet, dist_parcourue, nbparticipants)
      SELECT t1.id_course,t1.id_pet,calc_dist(t2.endurance,t3.duree,t4.puissance_min,t2.puissance,t3.duree) as dist_parcourue, t3.nbparticipants
      FROM course_participant AS t1
      LEFT JOIN pet AS t2 ON t1.id_pet=t2.id_pet
      LEFT JOIN course AS t3 ON t1.id_course=t3.id_course
      LEFT JOIN
        (SELECT t1.id_course AS courseid, t1.id_pet, MIN(t2.strengh+t2.agilite+t2.intelligence) as puissance_min
        FROM course_participant AS t1 left join pet as t2 on t1.id_pet=t2.id_pet GROUP BY t1.id_course) as t4 ON t1.id_course=t4.courseid  
      WHERE t3.statut=3
      ORDER BY dist_parcourue DESC";  
  $result7 = mysql_query($sql7);
if ($result7===false){throw new Exception("Erreur de remplissage de la table m_course2",E_USER_NOTICE);}
/*
  // on reverse les ressources gagnées pour les 3 1er pet (respectivement 60% - 20% - 10% de toutes les ressources "misées")
  SELECT ressource_type, ressource_quantite FROM course
  $gain1 = (60/(ressource_quantite*nbparticipants))*100;
  $gain2 = (20/(ressource_quantite*nbparticipants))*100;
  $gain3 = (10/(ressource_quantite*nbparticipants))*100;
*/

// on met a jour la distance dans la table course_participant
$sqlUp = "UPDATE course_participant, m_course2
          SET course_participant.distance=m_course2.dist_parcourue
          WHERE course_participant.id_course=m_course2.id_course AND course_participant.id_pet=m_course2.id_pet ";
$result = mysql_query($sqlUp) ;
if ($result===false){throw new Exception("Erreur update course_participant",E_USER_NOTICE);}

// On archive les courses terminées.
$sqlUp = "UPDATE course
          SET statut='5'
          WHERE statut='3' ";
$result=mysql_query($sqlUp);
if ($result===false){throw new Exception("Erreur de maj des course au statut 5",E_USER_NOTICE);}

// on efface la table m_course2
$sqlDel = "DROP TABLE m_course2 ";
$result = mysql_query($sqlDel);
if ($result===false){throw new Exception("Erreur de suppression de la table memory course2",E_USER_NOTICE);}

echo "<b>Archives des couses et lancement ok</b>";

}#go_statut3

}catch (Exception $e){print $e->getMessage();exit;}
echo "\n";
?>