1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| mysql_query('ALTER TABLE historique ADD aid_'.$date.' INT NOT NULL , ADD population_'.$date.' SMALLINT NOT NULL, ADD uid_'.$date.' INT NOT NULL');
$requete = @mysql_query("SELECT * FROM x_world");
while($donnees = @mysql_fetch_array($requete))
{
$id = $donnees['id'];
$x = $donnees['x'];
$y = $donnees['y'];
$tid = $donnees['tid'];
$vid = $donnees['vid'];
$village = $donnees['village'];
$uid = $donnees['uid'];
$player = $donnees['player'];
$alliance = $donnees['alliance'];
$aid = $donnees['aid'];
$population = $donnees['population'];
$query2 = @mysql_query("SELECT COUNT(id) AS nb FROM historique WHERE id='$id'");
$donnees2 = mysql_fetch_array($query2);
if($donnees2['nb'] > 0)
{
@mysql_query("UPDATE historique SET village='$village', player='$player', alliance='$alliance', aid_$date='$aid', population_$date='$population', uid_$date='$uid' WHERE id='$id'");
}
else
{
@mysql_query("INSERT INTO `travian`.`historique` (`id`, `x`, `y`, `tid`, `vid`, `village`, `uid`, `player`, `alliance` , `aid_$date` , `population_$date`,`uid_$date`) VALUES ('$id', '$x', '$y', '$tid', '$vid', '$village', '$uid', '$player', '$alliance' , '$aid' , '$population','$uid')");
}
} |
Partager