<?php
$date = gmdate('D, d M Y H:i:s');
header("Content-Type: text/xml");
header('Content-Disposition: attachment; filename=joueur_export.xml');
header('Last-Modified: '. $date . ' GMT');
header('Expires: ' . $date);
if(preg_match('/msie|(microsoft internet explorer)/i', $_SERVER['HTTP_USER_AGENT'])){
  header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
  header('Pragma: public');
}else{
  header('Pragma: no-cache');
}
require_once("../bdd.php");
require_once("../fonction.inc.php");
$i = 0;
$sql="SELECT id_pseudo, point, id_gang FROM perso order by point desc";
$req = mysql_query($sql) or die('Erreur SQL 1!<br>'.mysql_error());
if (@mysql_num_rows($req) ==0) print "<script> alert('La requête n\'a pas abouti !')</script>";
$xml = '<?xml version="1.0" encoding="ISO-8859-1"?>'.'<joueurexport>';
while($var_news = mysql_fetch_array($req)) {
    $id_joueur = $var_news['id_pseudo'];
    $point = $var_news['point'];
    $id_gang = $var_news['id_gang'];
    $i++;
        $xml .= '<personne>';
        $xml .= '<classement>'.$i.'</classement>';
        $xml .= '<pseudo>'.aff_texte_bdd(id2pseudo($id_joueur)).'</pseudo>';
        $xml .= '<point>'.$point.'</point>';
        $xml .= '<gang>'.aff_texte_bdd(id2gang($id_gang)).'</gang>';
        $xml .= '</personne>';
}
$xml .= '</joueurexport>';        
echo $xml;
?>