<?php
$username = "Benjamin";
$password = "4yZXqGQT9Fzed9R2";
$hostname = "db1.eutw.net";

$dbhandle = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
mysql_select_db('EUTW_armaDB',$dbhandle);


$query = "SELECT MIN(PlayerUID) PlayerUID FROM Players GROUP BY PlayerUID";
$playersquery = mysql_query($query) or die('Erreur SQL !<br>'.mysql_error());
$VeteranNumber=0;
while($data = mysql_fetch_assoc($playersquery))
{
$FidelityScore=0;

for ($i = 0; $i <= 5000000; $i+=500000) {
$j=$i + 500000;
$query = "SELECT COUNT(*) FROM EventConnect INNER JOIN triggered ON EventConnect.EventID = triggered.EventID WHERE PlayerUID = '".$data['PlayerUID']."' AND EventConnect.EventID BETWEEN ".$i." AND ".$j;
$result = mysql_query($query) or die('Erreur SQL !<br>'.mysql_error());
$resultat=mysql_fetch_row($result);
if ($resultat[0]>5) $FidelityScore+=1;
}

if ($FidelityScore>5) $VeteranNumber++;
echo $VeteranNumber," ";
}
?>