Building and Resources

<?php

function BuildBuildings($userid)
{

require_once('Buildings.php');

$result = mysql_query("SELECT UNIX_TIMESTAMP(LastLogin),Energy,Wood,Stone,Steel,Level FROM gamedata WHERE ID='$userid'");

$row = mysql_fetch_array($result) or die(mysql_error());
$lastlogin = mysql_result($result, 0, 0);
$res[0] = $row['Energy'];
$res[1] = $row['Wood'];
$res[2] = $row['Stone'];
$res[3] = $row['Steel'];
$res[4] = $row['Level'];
$resupdate[0] = false;
$resupdate[1] = false;
$resupdate[2] = false;
$resupdate[3] = false;
$updquery = "";

date_default_timezone_set('Europe/Sofia');
$mysqldate = date('Y-m-d H:i:s');
$phpdate = strtotime( $mysqldate );

$namem = array("Crypt","Cemetery","Mausoleum","Forsaken Shooting Range","Abandoned Stables","Dragon Graveyard");
$namem2 = array("Crypt","Cemetery","Mausoleum","ForsakenShootingRange","AbandonedStables","DragonGraveyard");

$result1 = mysql_query("SELECT BuildingID,BuildingLevel,CreationTime FROM currentbuildings WHERE ID='$userid' AND CreationTime<=FROM_UNIXTIME($phpdate) AND BuildingType='m'");
                while($row = mysql_fetch_array($result1))
                {
                        $updatequery = "UPDATE buildings SET ".$namem2[$row['BuildingID']]."='".$row['BuildingLevel']."' WHERE ID='$userid'";
                        mysql_query($updatequery);
                        mysql_query("DELETE FROM currentbuildings WHERE ID='$userid' AND BuildingID='".$row['BuildingID']."' AND BuildingType='m'");
                        echo "Your ".$namem[$row['BuildingID']]." - Level ".$row['BuildingLevel']." has finished construction.";
                }
$result2 = mysql_query("SELECT UNIX_TIMESTAMP(CreationTime),BuildingID,BuildingLevel FROM currentbuildings WHERE CreationTime>FROM_UNIXTIME($phpdate) AND ID='$userid' AND BuildingType='m'");
                while($row = mysql_fetch_array($result2))
                {
                        $timevar = $row['UNIX_TIMESTAMP(CreationTime)'] - $phpdate;
                        echo "Your ".$namem[$row['BuildingID']]." - Level ".$row['BuildingLevel']." will finish construction in ".gmdate("z-H:i:s", $timevar)." day(s).";
                }

$rbuilding = new resourcebuilding();

$namer = array("Energy Damper","Desolate Lumber Mill","Stone Pit","Dilapidated Blacksmith");
$namer2 = array("EnergyDamper","DesolateLumberMill","StonePit","DilapidatedBlacksmith");

$result1 = mysql_query("SELECT BuildingID,BuildingLevel,UNIX_TIMESTAMP(CreationTime) FROM currentbuildings WHERE ID='$userid' AND CreationTime<=FROM_UNIXTIME($phpdate) AND BuildingType='r'");
                while($row = mysql_fetch_array($result1))
                {
                        $hehh = "";
                        if ((floor($row['UNIX_TIMESTAMP(CreationTime)']/3600) > floor($lastlogin/3600)) && ($row['BuildingLevel'] != 1))
                        {
                                $pasthours = floor($row['UNIX_TIMESTAMP(CreationTime)']/3600) - floor($lastlogin/3600);
                                $hehh = $rbuilding->update_resources($row['BuildingID'],$pasthours,($row['BuildingLevel']-1));
                                $resupdate[$row['BuildingID']] = true;
                                if (floor(time()/3600) > floor($row['UNIX_TIMESTAMP(CreationTime)']/3600))
                                {
                                        $pasthours = floor(time()/3600) - floor($row['UNIX_TIMESTAMP(CreationTime)']/3600);
                                        $hehh = $rbuilding->update_resources($row['BuildingID'],$pasthours,($row['BuildingLevel']));
                                }
                        }
                        $updquery = $updquery . $hehh;
                        $updatequery = "UPDATE buildings SET ".$namer2[$row['BuildingID']]."='".$row['BuildingLevel']."' WHERE ID='$userid'";
                        mysql_query($updatequery);
                        mysql_query("DELETE FROM currentbuildings WHERE ID='$userid' AND BuildingID='".$row['BuildingID']."' AND BuildingType='r'");
                        echo "Your ".$namer[$row['BuildingID']]." - Level ".$row['BuildingLevel']." has finished construction.";
                }
$result2 = mysql_query("SELECT UNIX_TIMESTAMP(CreationTime),BuildingID,BuildingLevel FROM currentbuildings WHERE CreationTime>FROM_UNIXTIME($phpdate) AND ID='$userid' AND BuildingType='r'");
                while($row = mysql_fetch_array($result2))
                {
                        $timevar = $row['UNIX_TIMESTAMP(CreationTime)'] - $phpdate;
                        echo "Your ".$namer[$row['BuildingID']]." - Level ".$row['BuildingLevel']." will finish construction in ".gmdate("z-H:i:s", $timevar)." day(s).";
                }

  if (floor(time()/3600) > floor($lastlogin/3600))
 {
  $pasthours = floor(time()/3600) - floor($lastlogin/3600);

  $result1 = mysql_query("SELECT EnergyDamper,StonePit,DesolateLumberMill,DilapidatedBlacksmith FROM buildings WHERE ID='$userid'");
  $row1 = mysql_fetch_array($result1) or die(mysql_error());
  $b[0] = $row1['EnergyDamper'];
  $b[1] = $row1['StonePit'];
  $b[2] = $row1['DesolateLumberMill'];
  $b[3] = $row1['DilapidatedBlacksmith'];

  for ($i=0; $i<4; $i++)
  {
        if (($b[$i] != 0) && (!$resupdate[$i]))
        {
                $updquery = $updquery . $rbuilding->update_resources($i,$pasthours,$b[$i]);
        }
  }

  if ($updquery != "")
  {
   $mysqldate = date('Y-m-d H:i:s');
   $phpdate = strtotime( $mysqldate );

   $updquery = "UPDATE gamedata SET ".$updquery."LastLogin=FROM_UNIXTIME($phpdate) WHERE ID='$userid'";

   mysql_query($updquery);
  }

 }
}