<?php
include ('logue.php');
include ('entete2.php');
$sql = "SELECT pts,technaqua_lvl,labo_lvl,or_ressource,ura_ressource,fer_ressource,technaqua_evolution FROM matgraph_users WHERE id='$planete' ";
$res = db_mysql_Query($sql)or die('erreur sql<br>'.$sql.'<br>'.mysql_error());
$row = mysql_fetch_array($res);
$sql2 = "SELECT technaqua_lvl, technaqua_evolution,labo_util FROM matgraph_users WHERE id='$idlogin' ";
$res2 = db_mysql_Query($sql2)or die('erreur sql<br>'.$sql2.'<br>'.mysql_error());
$row2 = mysql_fetch_array($res2);
$sql3 = "SELECT fer_ressource, or_ressource,ada_ressource, ura_ressource FROM matgraph_users WHERE id='$row2[labo_util]' ";
$res3 = db_mysql_Query($sql3)or die('erreur sql<br>'.$sql3.'<br>'.mysql_error());
$row3 = mysql_fetch_array($res3);
if ($row2[technaqua_lvl] == "0") {
$Depense_technaqua_fer = "4000";
$Depense_technaqua_ura = "2500";
}
else {
$Depense_technaqua_fer = round((2000 * ( bcpow( 2, ($row2[technaqua_lvl] + 1),3))),0);
$Depense_technaqua_ura = round((1250 * ( bcpow( 2, ($row2[technaqua_lvl] + 1),3))),0);
}
$New_fer_ressource = ($row3[fer_ressource] + $Depense_technaqua_fer) ;
$New_ura_ressource = ($row3[ura_ressource] + $Depense_technaqua_ura) ;
if ($row2[technaqua_evolution] != "0000-00-00 00:00:00" ) {
$sql = "UPDATE matgraph_users SET fer_ressource=$New_fer_ressource, ura_ressource=$New_ura_ressource, labo_util = '0' WHERE id='$row2[labo_util]'";
$res = db_mysql_Query($sql)or die('erreur sql<br>'.$sql.'<br>'.mysql_error());
$sql2 = "UPDATE matgraph_users SET technaqua_evolution=\"0000-00-00 00:00:00\" , labo_util = '0' WHERE id='$idlogin'";
$res2 = db_mysql_Query($sql2)or die('erreur sql<br>'.$sql2.'<br>'.mysql_error()); }
echo '<script language="javascript" type="text/javascript">
<!--
window.location.replace("labo.php");
-->
</script>';
?>