<?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');

$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;

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

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

?>