View difference between Paste ID: 0G1WChF6 and YgRKWXkQ

 <?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 > ?");
+if ($r['logs'] > $max) {
-$array = array($max, $_SESSION['id'], $_SESSION['viewing'], $max);
+  $qr = $db->prepare("UPDATE villages SET logs = ? WHERE owner = ? AND id = ? AND logs > ?");
   $array = array($max, $_SESSION['id'], $_SESSION['viewing'], $max);
-$qr = $db->prepare("UPDATE villages SET clay = ? WHERE owner = ? AND id = ? AND clay > ?");
+  $qr->execute($array);
-$array = array($max, $_SESSION['id'], $_SESSION['viewing'], $max);
+}
 if ($r['clay'] > $max) {
-$qr = $db->prepare("UPDATE villages SET metal = ? WHERE owner = ? AND id = ? AND metal > ?");
+  $qr = $db->prepare("UPDATE villages SET clay = ? WHERE owner = ? AND id = ? AND clay > ?");
-$array = array($max, $_SESSION['id'], $_SESSION['viewing'], $max);
+  $array = array($max, $_SESSION['id'], $_SESSION['viewing'], $max);
   $qr->execute($array);
 }
 if ($r['metal'] > $max) {
   $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);
 
 ?>