getCurrentResources.php

<?php
    require_once($_SERVER['DOCUMENT_ROOT'].'/connect.php');

    //Get village and time data
    $villageID=$_SESSION['idPlayer'];
    $currentTime=time();

    //Get current resources
    $getCurrentRes = $connection->prepare('SELECT * FROM villageresources WHERE idVillage= ?');
    $getCurrentRes->bind_param('i', $villageID);
    $getCurrentRes->execute();
    $resultCurrentRes = $getCurrentRes->get_result();

    $currentRes = $resultCurrentRes->fetch_row();
    $getCurrentRes->close();

    //Get village production
    $getProduction = $connection->prepare('SELECT * FROM villageproduction WHERE idVillage= ?');
    $getProduction->bind_param('i', $villageID);
    $getProduction->execute();    
    $resultProduction = $getProduction->get_result();

    $Production = $resultProduction->fetch_row();
    $getProduction->close();

    //Get max resources
    $getMaxRes = $connection->prepare('SELECT * FROM villagemaxresources WHERE idVillage= ?');
    $getMaxRes->bind_param('i', $_SESSION['idPlayer']);
    $getMaxRes->execute();    
    $resultMaxRes = $getMaxRes->get_result();

    $maxRes = $resultMaxRes->fetch_row();
    $getMaxRes->close();

    //Calculate the time difference
    $timeDiff = ($currentTime-$currentRes[5])/3600;

    //Calculate new resources
    $newWood = $currentRes[1]+$timeDiff*$Production[1];
    $newClay = $currentRes[2]+$timeDiff*$Production[2];
    $newIron = $currentRes[3]+$timeDiff*$Production[3];
    $newCrop = $currentRes[4]+$timeDiff*$Production[4];

    
    //Check if the new resources exceed the capacity levels
    if($newWood>=$maxRes[1]){
        $newWood=$maxRes[1];
    }
    if($newClay>=$maxRes[2]){
        $newClay=$maxRes[2];
    }
    if($newIron>=$maxRes[3]){
        $newIron=$maxRes[3];
    }
    if($newCrop>=$maxRes[4]){
        $newCrop=$maxRes[4];
    }
    
    //Update the resources and last update time
    $updateCurrentRes = $connection->prepare("UPDATE villageresources SET currentWood=?,currentClay=?,currentIron=?,currentCrop=?,lastUpdate=? WHERE idVillage = ?");
    $updateCurrentRes->bind_param("ddddii", $newWood,$newClay,$newIron,$newCrop,$currentTime,$villageID);
    $updateCurrentRes->execute();
    $updateCurrentRes->close();

?>