<?
include('functions.php');
$id = $_GET['id'];
$link = opendb();
//Selection des info du batiment
$req = mysql_query("SELECT nextlevel,currentlevel,prod,metal,gold,stone,food,uptime FROM spqr_buildings WHERE username='admin' && id='$id'") or die ("erreur requête 1");
$spqr_build = mysql_fetch_array ($req);
//Selections des ressources sur le terrain
$req = mysql_query("SELECT metal,gold,stone,food FROM spqr_resources WHERE username='admin'") or die ("erreur requête 2");
$spqr_res = mysql_fetch_array ($req);
//Calcule des ressources et niveau de batiments
$currentlevel = $spqr_build['nextlevel'];
$nextlevel = $currentlevel + 1;
$metal = $spqr_res['metal'] - $spqr_build['metal'];
$gold = $spqr_res['gold'] - $spqr_build['gold'];
$stone = $spqr_res['stone'] - $spqr_build['stone'];
$food = $spqr_res['food'] - $spqr_build['food'];
$c_metal = $spqr_build['metal'] * $spqr_build['prod'];
$c_gold = $spqr_build['gold'] * $spqr_build['prod'];
$c_stone = $spqr_build['stone'] * $spqr_build['prod'];
$c_food = $spqr_build['food'] * $spqr_build['prod'];
//Calcule du temps
$temps = time() + 2*60*60;
//Mise à jour dans la table
mysql_query("UPDATE spqr_buildings SET nextlevel='$nextlevel',currentlevel='$currentlevel',metal='$c_metal',gold='$c_gold',stone='$c_stone',food='$c_food',uptime='$temps' WHERE username='admin' && id='$id'") or die ("erreur requête maj1");
mysql_query("UPDATE spqr_resources SET metal='$metal',gold='$gold',stone='$stone',food='$food' WHERE username='admin'") or die ("erreur requête maj2");
header( "Location: accueil.php");
?>