70 lines
3.2 KiB
PHP
Executable File
70 lines
3.2 KiB
PHP
Executable File
<?php
|
|
$tab_classement_inverse=array("0/0"=>"0","1/6"=>"1","2/6"=>"2","3/6"=>"3","4/6"=>"4","5/6"=>"5","15/0"=>"6","15/1"=>"7","15/2"=>"8","15/3"=>"9","15/4"=>"10","15/5"=>"11","30/0"=>"12","30/1"=>"13","30/2"=>"14","30/3"=>"15","30/4"=>"16","30/5"=>"17","NC"=>"18");
|
|
$tab_classement=array("0","1/6","2/6","3/6","4/6","5/6","15","15/1","15/2","15/3","15/4","15/5","30","30/1","30/2","30/3","30/4","30/5","NC");
|
|
$file=explode(".",$fichier);
|
|
if ($file[1]!="txt"){
|
|
$erreur="<center><font color=00ff00><h3><b>L'extention du fichier n'est pas valable</b></h3></font></center>";
|
|
include("quelImportExport.php");
|
|
}
|
|
else {
|
|
include("conf.php");
|
|
include("mysql_compat.php");
|
|
include ("conf.php");
|
|
$db_connection=mysql_connect($db_host,$db_user,$password);
|
|
mysql_select_db($db_name,$db_connection);
|
|
$file_joueur=fopen($fichier,"r");
|
|
$titre="Importation de la liste des joueurs";include("enTete.php");
|
|
fgets($file_joueur, 4096);/////on saute la premiere ligne
|
|
//echo "<table border =1>";
|
|
while (!feof ($file_joueur)) {
|
|
$buffer = fgets($file_joueur, 4096);
|
|
$texte_lu=explode(',',$buffer);
|
|
$i++;
|
|
$numero_fft=$texte_lu[0];
|
|
$nom=$texte_lu[1];
|
|
$prenom=$texte_lu[2];
|
|
$annee=$texte_lu[3];if (!$annee) $annee=date('Y')-25;
|
|
$portable="";$fixe="";
|
|
if ($texte_lu[4][1]=='6') $portable=$texte_lu[4];else $fixe=$texte_lu[4];
|
|
if ($texte_lu[5][1]=='6') $portable=$texte_lu[5];else if ($fixe=="") $fixe=$texte_lu[5];
|
|
if (is_numeric($texte_lu[6])) $solde=$texte_lu[6]; else $solde=0;
|
|
//echo "<tr><td>".$texte_lu[7]."</td>";
|
|
if ($texte_lu[7][0]=='-') $texte_lu[7]="0/0";
|
|
if ($texte_lu[7] =="0") $texte_lu[7]= "0/0";
|
|
if ($texte_lu[7] =="15") $texte_lu[7]= "15/0";
|
|
if ($texte_lu[7] =="30") $texte_lu[7]= "30/0";
|
|
$classement=$tab_classement_inverse[$texte_lu[7]];
|
|
//echo "<td>".$classement."</td><td>".$tab_classement[$classement]."</td>";
|
|
$sexe=$texte_lu[8];if ($sexe=='H') $sexe='m'; else $sexe='f';
|
|
$e_mail=$texte_lu[9];
|
|
|
|
$impossible=0;
|
|
if (/*!$numero_fft or*/ !$nom or !$classement or !$sexe) {
|
|
$impossible=1;
|
|
//echo "Insertion joueur ".$i." impossible !<br>";
|
|
}
|
|
if (!$impossible){
|
|
$requete="SELECT id_joueur FROM joueur WHERE UPPER(nom)=UPPER('".$nom."') AND UPPER(prenom)=UPPER('".$prenom."') ;";
|
|
$reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."<br>");
|
|
$reptab=mysql_fetch_array($reponse);
|
|
if (!$['']){
|
|
$requete="INSERT INTO joueur (numero_fft, nom, prenom, annee, fixe, portable, solde, classement, sexe, e_mail) VALUES ";
|
|
$requete=$requete."('".$numero_fft."','".$nom."','".$prenom."','".$annee."','".$fixe."','".$portable."','".$solde."','".$classement."','".$sexe."','".$e_mail."') ;";
|
|
}
|
|
else{
|
|
$requete="UPDATE joueur SET classement='".$classement."',portable='".$portable."',
|
|
fixe='".$fixe."',e_mail='".$e_mail."' WHERE id_joueur='".$['']."';";
|
|
}
|
|
$reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."<br>");
|
|
}
|
|
}
|
|
//echo "</table>";
|
|
//echo $requete;
|
|
fclose($file_joueur);
|
|
mysql_close($db_connection);
|
|
echo "La liste des joueurs a ete importee";
|
|
exec("rm ".$fichier);
|
|
include("piedDePage.php");
|
|
}
|
|
?>
|