<?php

require("config.inc.php");

mysql_connect($host, $username, $password);

mysql_select_db($bdd_name);

$pseudo_rep = mysql_query("SELECT pseudo, banque FROM membres");

while($pseudo = mysql_fetch_array($pseudo_rep))

{

$pseudoj = $pseudo['pseudo'];

$reponse1= mysql_query("SELECT belier, trepan FROM engin WHERE pseudo='".$pseudoj."'")or die (mysql_error());

$infos1 = mysql_fetch_array($reponse1);

$reponse2= mysql_query("SELECT belier, trepan FROM troupes_attaque WHERE pseudo='".$pseudoj."'")or die (mysql_error());

$infos2 = mysql_fetch_array($reponse2);

$beliers = infos1['belier'] + infos2['belier'];

$trepans = infos1['trepan'] + infos2['trepan'];

if($beliers > 30)

   {

$beliers_trop = $beliers - 30;

$sous_a_donner = $beliers_trop * 1000000;

$banque = $pseudo['banque'] + $sous_a_donner;

mysql_query("UPDATE membres SET banque='".$banque."' WHERE pseudo='".$pseudoj."'")or die(mysql_error);

mysql_query("UPDATE engin SET belier='0' WHERE pseudo='".$pseudoj."'")or die(mysql_error);

mysql_query("UPDATE troupes_attaque SET belier='30' WHERE pseudo='".$pseudoj."'")or die(mysql_error);

   }

if($trepans >25)

   {

$trepans_trop = $trepans - 25;

$sous_a_donner = $trepans_trop * 1700000;

$banque = $pseudo['banque'] + $sous_a_donner;

mysql_query("UPDATE membres SET banque='".$banque."' WHERE pseudo='".$pseudoj."'")or die(mysql_error);

mysql_query("UPDATE engin SET trepan='0' WHERE pseudo='".$pseudoj."'")or die(mysql_error);

mysql_query("UPDATE troupes_attaque SET trepan='25' WHERE pseudo='".$pseudoj."'")or die(mysql_error);

   }

echo ''.$pseudoj.' ok !<br />';

}

?>

<?php 

$beliers = infos1['belier'] + infos2['belier'];

$trepans = infos1['trepan'] + infos2['trepan'];