<?php
session_start();
include 'db.php';
$resourceLumberHouse = array('35','100','250','400','650','800','1050','1300','1600','2000','2500','3000','3750','4600','5250','6000','7000','8500','10000','11750','13000');
$resourceClayPit =     array('35','100','250','400','650','800','1050','1300','1600','2000','2500','3000','3750','4600','5250','6000','7000','8500','10000','11750','13000');
$resourceMine =        array('35','100','250','400','650','800','1050','1300','1600','2000','2500','3000','3750','4600','5250','6000','7000','8500','10000','11750','13000');
$warehouseStorage =    array('250','1000','2000','3500','6000','9000','15000','20000','27500','37500','50000','65000','80000','100000','130000','175000','225000','300000','400000','550000','725000');

$ir = $db->prepare('SELECT RESOURCEtimestamp,LUMBERHOUSElevel,CLAYPITlevel,MINElevel,WAREHOUSElevel,logs,clay,metal FROM villages WHERE owner = ? AND id = ?');
$array = array($_SESSION['id'], $_SESSION['viewing']);
$ir->execute($array);
$r = $ir->fetch();

$lasttime = $r['RESOURCEtimestamp'];

$now = date_timestamp_get(date_create());

$difference = $now - $lasttime;

$logsPerSec = $resourceLumberHouse[$r['LUMBERHOUSElevel']] / 60;
$clayPerSec = $resourceClayPit[$r['CLAYPITlevel']] / 60;
$metalPerSec = $resourceMine[$r['MINElevel']] / 60;

$logsMade = $difference * $logsPerSec;
$clayMade = $difference * $clayPerSec;
$metalMade = $difference * $metalPerSec;

$max = $warehouseStorage[$r['WAREHOUSElevel']];

$qr = $db->prepare("UPDATE villages SET logs = logs + ? WHERE owner = ? AND id = ? AND logs < ?");
$array = array($logsMade,$_SESSION['id'], $_SESSION['viewing'], $max);
$qr->execute($array);
$qr = $db->prepare("UPDATE villages SET clay = clay + ? WHERE owner = ? AND id = ? AND clay < ?");
$array = array($metalMade,$_SESSION['id'], $_SESSION['viewing'], $max);
$qr->execute($array);
$qr = $db->prepare("UPDATE villages SET metal = metal + ? WHERE owner = ? AND id = ? AND clay < ?");
$array = array($clayMade,$_SESSION['id'], $_SESSION['viewing'], $max);
$qr->execute($array);

$qr = $db->prepare("UPDATE villages SET logs = ? WHERE owner = ? AND id = ? AND logs > ?");
$array = array($max, $_SESSION['id'], $_SESSION['viewing'], $max);
$qr->execute($array);
$qr = $db->prepare("UPDATE villages SET clay = ? WHERE owner = ? AND id = ? AND clay > ?");
$array = array($max, $_SESSION['id'], $_SESSION['viewing'], $max);
$qr->execute($array);
$qr = $db->prepare("UPDATE villages SET metal = ? WHERE owner = ? AND id = ? AND metal > ?");
$array = array($max, $_SESSION['id'], $_SESSION['viewing'], $max);
$qr->execute($array);

$ir = $db->prepare("UPDATE villages SET RESOURCEtimestamp = {$now} WHERE owner = ? AND id = ?");
$array = array($_SESSION['id'], $_SESSION['viewing']);
$ir->execute($array);

?>