title: What would you do if you just had this code dumped in your lap?
body: <p>Man, I just had this project given to me - expand on this they say.</p>
  
  <p>This is an example of ONE function:</p>
  
  <pre><code>&lt;?php
  
  
  //500+ lines of pure wonder.
  function page_content_vc($content) {
      global $_DBH, $_TPL, $_SET;
  
   $_SET['ignoreTimezone'] = true;
  
      lu_CheckUpdateLogin();
  
      if($_SESSION['dash']['VC']['switch'] == 'unmanned' || $_SESSION['dash']['VC']['switch'] == 'touchscreen') {
          if($content['page_name'] != 'vc') {
              header('Location: /vc/');
              die();
          }
      }
  
      if($_GET['l']) {
          unset($_SESSION['dash']['VC']);
          if($loc_id = lu_GetFieldValue('ID', 'Location', $_GET['l'])) {
  
              if(lu_CheckPermissions('vc', $loc_id)) {
  
      $timezone = lu_GetFieldValue('Time Zone', 'Location', $loc_id, 'ID');
      if(strlen($timezone) &gt; 0) {
       $_SESSION['time_zone'] = $timezone;
      }
  
                  $_SESSION['dash']['VC']['loc_ID'] = $loc_id;
                  header('Location: /vc/');
                  die();
              }
          }
      }
  
      if($_SESSION['dash']['VC']['loc_ID']) {
  
    $timezone = lu_GetFieldValue('Time Zone', 'Location', $_SESSION['dash']['VC']['loc_ID'], 'ID');
    if(strlen($timezone) &gt; 0) {
     $_SESSION['time_zone'] = $timezone;
    }
  
          $loc_id = $_SESSION['dash']['VC']['loc_ID'];
          $org_id = lu_GetFieldValue('record_ID', 'Location', $loc_id);
  
          $_TPL-&gt;assign('loc_id', $loc_id);
  
          $location_name = lu_GetFieldValue('Location Name', 'Location', $loc_id);
          $_TPL-&gt;assign('LocationName', $location_name);
  
          $customer_name = lu_GetFieldValue('Customer Name', 'Organisation', $org_id);
          $_TPL-&gt;assign('CustomerName', $customer_name);
  
          $enable_visitor_snap = lu_GetFieldValue('VisitorSnap', 'Location', $loc_id);
          $_TPL-&gt;assign('EnableVisitorSnap', $enable_visitor_snap);
  
    $lacps = explode("\n", lu_GetFieldValue('Location Access Control Point', 'Location', $loc_id));
          array_walk($lacps, 'trim_value');
  
    if(count($lacps) &gt; 0) {
     if(count($lacps) == 1) {
      $_SESSION['dash']['VC']['lacp'] = $lacps[0];
     }
     else {
      if($_GET['changeLACP'] &amp;&amp; in_array($_GET['changeLACP'], $lacps)) {
       $_SESSION['dash']['VC']['lacp'] = $_GET['changeLACP'];
       header('Location: /vc/');
       die();
      }
      else if(!in_array($_SESSION['dash']['VC']['lacp'], $lacps)) {
       $_SESSION['dash']['VC']['lacp'] = $lacps[0];
      }
      $_TPL-&gt;assign('LACP_array', $lacps);
     }
     $_TPL-&gt;assign('current_LACP', $_SESSION['dash']['VC']['lacp']);
     $_TPL-&gt;assign('showContractorSearch', true);
     /*
     if($contractorStaff = lu_GetTableRow('ContractorStaff', $org_id, 'record_ID', 'record_Inactive != "checked"')) {
      foreach($contractorStaff['rows'] as $contractor) {
       $lacp_rights = lu_OrganiseCustomDataFunctionMultiselect($contractor[lu_GetFieldName('Location Access Rights', 'ContractorStaff')]);
       if(in_array($_SESSION['dash']['VC']['lacp'], $lacp_rights)) {
        $_TPL-&gt;assign('showContractorSearch', true);
       }
      }
     }
     */
    }
  
    $selectedOptions = explode(',', lu_GetFieldValue('Included Fields', 'Location', $_SESSION['dash']['VC']['loc_ID']));
    $newOptions = array();
    foreach($selectedOptions as $selOption) {
     $so_array = explode('|', $selOption, 2);
     if(count($so_array) &gt; 1) {
      $newOptions[$so_array[0]] = $so_array[1];
     }
     else {
      $newOptions[$so_array[0]] = "Both";
     }
    }  
  
    if($newOptions[lu_GetFieldName('Expected Length of Visit', 'Visitor')]) {
  
     $alert = false;
  
              if($visitors = lu_OrganiseVisitors(
                  lu_GetTableRow('Visitor', 'checked',
                      lu_GetFieldName('Checked In', 'Visitor'),
                      lu_GetFieldName('Location for Visit', 'Visitor').'="'.$_SESSION['dash']['VC']['loc_ID'].'"
                      AND '.lu_GetFieldName('Checked Out', 'Visitor').' != "checked"'), false, true, true)) {
  
                  foreach($visitors['rows'] as $key =&gt; $visitor) {
       if($visitor['expected'] &amp;&amp; $visitor['expected'] + (60*30) &lt; time()) {
        $alert = true;
       }
                  }
              }
     if($alert == true) {
      $_TPL-&gt;assign('showAlert', 'red');
     }
     else {
      //$_TPL-&gt;assign('showAlert', 'green');
     }
    }
  
  
          $_TPL-&gt;assign('switch', $_SESSION['dash']['VC']['switch']);
    if($_SESSION['dash']['VC']['switch'] == 'touchscreen') {
     $_TPL-&gt;assign('VC_unmanned', true);
    }
  
          if($_GET['check'] == 'in') {
     if($_SESSION['dash']['VC']['switch'] == 'touchscreen') {
      lu_CheckInTouchScreen();
              }
     else {
      lu_CheckIn();
     }
          }
          else if($_GET['check'] == 'out') {
     if($_SESSION['dash']['VC']['switch'] == 'touchscreen') {
      lu_CheckOutTouchScreen();
              }
     else {
      lu_CheckOut();
     }
          }
          else if($_GET['switch'] == 'unmanned') {
              $_SESSION['dash']['VC']['switch'] = 'unmanned';
              if($_GET['printing'] == true &amp;&amp; (lu_GetFieldValue('Printing', 'Location', $_SESSION['dash']['VC']['loc_ID']) != "No" &amp;&amp; lu_GetFieldValue('Printing', 'Location', $_SESSION['dash']['VC']['loc_ID']) != "")) {
                  $_SESSION['dash']['VC']['printing'] = true;
              }
              else {
                  $_SESSION['dash']['VC']['printing'] = false;
              }
              header('Location: /vc/');
              die();
          }
          else if($_GET['switch'] == 'touchscreen') {
              $_SESSION['dash']['VC']['switch'] = 'touchscreen';
              if($_GET['printing'] == true &amp;&amp; (lu_GetFieldValue('Printing', 'Location', $_SESSION['dash']['VC']['loc_ID']) != "No" &amp;&amp; lu_GetFieldValue('Printing', 'Location', $_SESSION['dash']['VC']['loc_ID']) != "")) {
                  $_SESSION['dash']['VC']['printing'] = true;
              }
              else {
                  $_SESSION['dash']['VC']['printing'] = false;
              }
              header('Location: /vc/');
              die();
          }
  
          else if($_GET['switch'] == 'manned') {
              if($_POST['password']) {
                  if(md5($_POST['password']) == $_SESSION['dash']['password']) {
                      unset($_SESSION['dash']['VC']['switch']);
                      //setcookie('email', "", time() - 3600);
                      //setcookie('location', "", time() - 3600);
                      header('Location: /vc/');
                      die();
                  }
                  else {
                      $_TPL-&gt;assign('switchLoginError', 'Incorrect Password');
                  }
              }
  
              $_TPL-&gt;assign('switchLogin', 'true');
          }
          else if($_GET['m'] == 'visitor') {
              lu_ModifyVisitorVC();
          }
  
          else if($_GET['m'] == 'enote') {
              lu_ModifyEnoteVC();
          }
  
          else if($_GET['m'] == 'medical') {
              lu_ModifyMedicalVC();
          }
  
          else if($_GET['print'] == 'label' &amp;&amp; $_GET['v']) {
              lu_PrintLabelVC();
          }
  
          else {
              unset($_SESSION['dash']['VC']['checkin']);
              unset($_SESSION['dash']['VC']['checkout']);
  
              $_TPL-&gt;assign('icon', 'GroupCheckin');
  
              if($_SESSION['dash']['VC']['switch'] != 'unmanned' &amp;&amp; $_SESSION['dash']['VC']['switch'] != 'touchscreen') {
  
                  $staff_ids = array();
                  if($staffs = lu_GetTableRow('Staff', $_SESSION['dash']['VC']['loc_ID'], 'record_ID')) {
                      foreach($staffs['rows'] as $staff) {
                          $staff_ids[] = $staff['ID'];
                      }
                  }
  
                  if($_GET['view'] == "tomorrow") {
                      $dateStart = date('Y-m-d', mktime(0, 0, 0, date("m")  , date("d")+1, date("Y")));
                      $dateEnd = date('Y-m-d', mktime(0, 0, 0, date("m")  , date("d")+1, date("Y")));
                  }
                  else if($_GET['view'] == "month") {
                      $dateStart = date('Y-m-d', mktime(0, 0, 0, date("m"), date("d"), date("Y")));
                      $dateEnd = date('Y-m-d', mktime(0, 0, 0, date("m"), date("d")+30, date("Y")));
                  }
                  else if($_GET['view'] == "week") {
                      $dateStart = date('Y-m-d', mktime(0, 0, 0, date("m"), date("d"), date("Y")));
                      $dateEnd = date('Y-m-d', mktime(0, 0, 0, date("m"), date("d")+7, date("Y")));
                  }
                  else {
                      $dateStart = date('Y-m-d');
                      $dateEnd = date('Y-m-d');
                  }
  
      if(lu_GetFieldValue('Enable Survey', 'Location', $_SESSION['dash']['VC']['loc_ID']) == 'checked'
       &amp;&amp; lu_GetFieldValue('Add Survey', 'Location', $_SESSION['dash']['VC']['loc_ID']) == 'checked') {
        $_TPL-&gt;assign('enableSurvey', true);
      }
  
                  //lu_GetFieldName('Checked In', 'Visitor')
                  //!= "checked"
  
                  //date('d/m/Y'), lu_GetFieldName('Date of Visit', 'Visitor')
  
                  if($visitors = lu_OrganiseVisitors(lu_GetTableRow('Visitor', $_SESSION['dash']['VC']['loc_ID'], lu_GetFieldName('Location for Visit', 'Visitor'), lu_GetFieldName('Checked In', 'Visitor').' != "checked" AND '.lu_GetFieldName('Checked Out', 'Visitor').' != "checked" AND '.lu_GetFieldName('Date of Visit', 'Visitor').' &gt;= "'.$dateStart.'" AND '.lu_GetFieldName('Date of Visit', 'Visitor').' &lt;= "'.$dateEnd.'"'))) {
                      foreach($visitors['days'] as $day =&gt; $visitors_day) {
                          foreach($visitors_day['rows'] as $key =&gt; $visitor) {
                              $visitors['days'][$day]['rows'][$key]['visiting'] = lu_GetTableRow('Staff', $visitor['record_ID'], 'ID');
                              $visitors['days'][$day]['rows'][$key]['visiting']['notify'] = $_DBH-&gt;getRow('SELECT * FROM lu_notification WHERE ent_ID = "'.$visitor['record_ID'].'"');
                          }
                      }
  
                      //array_dump($visitors);
  
                      $_TPL-&gt;assign('visitors', $visitors);
                  }
  
      if($_GET['conGroup']) {
       if($_GET['action'] == 'add') {
        $_SESSION['dash']['VC']['conGroup'][$_GET['conGroup']] = $_GET['conGroup'];
       }
       else {
        unset($_SESSION['dash']['VC']['conGroup'][$_GET['conGroup']]);
       }
      }
  
      if(count($_SESSION['dash']['VC']['conGroup']) &gt; 0) {
                      if($conGroupResult = lu_GetTableRow('ContractorStaff', '1', '1', ' ID IN ('.implode(',', $_SESSION['dash']['VC']['conGroup']).')')) {
  
        if($_POST['_submit'] == 'Check-In Group &gt;&gt;') {
  
                           $form = lu_GetForm('VisitorStandard');
         $standarddata = array();
  
         foreach($form['items'] as $key=&gt;$item) {
          $standarddata[$key] = $_POST[lu_GetFieldName($item['name'], 'Visitor')];
         }
  
         foreach($conGroupResult['rows'] as $conStaff) {
          $data = $standarddata;
  
          foreach($form['items'] as $key=&gt;$item) {
           if($key != 'ID' &amp;&amp; $key != 'record_ID' &amp;&amp; $conStaff[lu_GetFieldName(lu_GetNameField($key, 'Visitor'), 'ContractorStaff')]) {
            $data[$key] = $conStaff[lu_GetFieldName(lu_GetNameField($key, 'Visitor'), 'ContractorStaff')];
           }
          }
  
          $data['record_ID'] = $data[lu_GetFieldName('Visiting', 'Visitor')];
                            $data[lu_GetFieldName('Date of Visit', 'Visitor')] = date('Y-m-d');
                            $data[lu_GetFieldName('Time of Visit', 'Visitor')] = date('H:i');
                            $data[lu_GetFieldName('Checked In', 'Visitor')] = 'checked';
                            $data[lu_GetFieldName('Location for Visit', 'Visitor')] = $_SESSION['dash']['VC']['loc_ID'];
                            $data[lu_GetFieldName('ConStaff ID', 'Visitor')] = $conStaff['ID'];
          $data[lu_GetFieldName('From', 'Visitor')] = lu_GetFieldValue('Legal Name', 'Contractor', $conStaff[lu_GetFieldName('Contractor', 'ContractorStaff')]);
  
                            $id = lu_UpdateData($form, $data);
                            lu_VisitorCheckIn($id);
  
          //array_dump($data);
          //array_dump($id);
         }
  
  
         unset($_SESSION['dash']['VC']['conGroup']);
         header('Location: /vc/');
         die();
        }
  
        if(count($conGroupResult['rows'])) {
                           foreach($conGroupResult['rows'] as $key =&gt; $cstaff) {
                               $conGroupResult['rows'][$key]['contractor'] = lu_GetTableRow('Contractor', $cstaff[lu_GetFieldName('Contractor', 'ContractorStaff')], 'ID');
                           }
                           $_TPL-&gt;assign('conGroupResult', $conGroupResult);
        }
  
        $conGroupForm = lu_GetForm('VisitorConGroup');
        $conGroupForm = lu_OrganiseVisitorForm($conGroupForm, $_SESSION['dash']['VC']['loc_ID'], 'Contractor');
  
              $secure_options_array = lu_GetSecureOptions($org_id);
              if($secure_options_array[$_SESSION['dash']['VC']['loc_ID']]) {
               $conGroupForm['items'][lu_GetFieldName('Secure Area', 'Visitor')]['options']['values'] = $secure_options_array[$_SESSION['dash']['VC']['loc_ID']];
         $conGroupForm['items'][lu_GetFieldName('Secure Area', 'Visitor')]['name'] = 'Secure  Area';
        }
        else {
                  unset($conGroupForm['items'][lu_GetFieldName('Secure Area', 'Visitor')]);
        }
  
           if($secure_options_array) {
               $form['items'][lu_GetFieldName('Secure Area', 'Visitor')]['options']['values'] = $secure_options_array;
         $form['items'][lu_GetFieldName('Secure Area', 'Visitor')]['name'] = 'Secure  Area';
           }
           else {
               unset($form['items'][lu_GetFieldName('Secure Area', 'Visitor')]);
           }
  
           $_TPL-&gt;assign('conGroupForm', $conGroupForm);
        $_TPL-&gt;assign('hideFormCancel', true);
       }
      }
  
                  if($_GET['searchVisitors']) {
                      $_TPL-&gt;assign('searchVisitorsQuery', $_GET['searchVisitors']);
                      $where = '';
  
                      if($_GET['searchVisitorsIn'] == 'Yes') {
                          $where .= ' AND '.lu_GetFieldName('Checked In', 'Visitor').' = "checked"';
                          $_TPL-&gt;assign('searchVisitorsIn', 'Yes');
                      }
                      else {
                          $where .= ' AND '.lu_GetFieldName('Checked In', 'Visitor').' != "checked"';
                          $_TPL-&gt;assign('searchVisitorsIn', 'No');
                      }
  
                      if($_GET['searchVisitorsOut'] == 'Yes') {
                          $where = '';
                          $where .= ' AND '.lu_GetFieldName('Checked Out', 'Visitor').' = "checked"';
                          $_TPL-&gt;assign('searchVisitorsOut', 'Yes');
                      }
                      else {
                          $where .= ' AND '.lu_GetFieldName('Checked Out', 'Visitor').' != "checked"';
                          $_TPL-&gt;assign('searchVisitorsOut', 'No');
                      }
  
                      if($searchVisitors = lu_OrganiseVisitors(lu_GetTableRow('Visitor', $_GET['searchVisitors'], '#search#', lu_GetFieldName('Location for Visit', 'Visitor').'="'.$_SESSION['dash']['VC']['loc_ID'].'"'.$where))) {
                          foreach($searchVisitors['rows'] as $key =&gt; $visitor) {
                              $searchVisitors['rows'][$key]['visiting'] = lu_GetTableRow('Staff', $visitor['record_ID'], 'ID');
                          }
  
                          $_TPL-&gt;assign('searchVisitors', $searchVisitors);
                      }
                      else {
                          $_TPL-&gt;assign('searchVisitorsNotFound', true);
                      }
                  }
                  else if($_GET['searchStaff']) {
  
                      if($_POST['staff_id']) {
                          if(lu_CheckPermissions('staff', $_POST['staff_id'])) {
                              $_DBH-&gt;query('UPDATE '.lu_GetTableName('Staff').' SET '.lu_GetFieldName('Current Location', 'Staff').' = "'.$_POST['current_location'].'" WHERE ID="'.$_POST['staff_id'].'"');
                          }
                      }
  
  
                      $locations = lu_GetTableRow('Location', $org_id, 'record_ID');
  
                      if(count($locations['rows']) &gt; 1) {
                          $_TPL-&gt;assign('staffLocations', $locations);
                      }
  
                      $loc_ids = array();
                      foreach($locations['rows'] as $location) {
                          $loc_ids[] = $location['ID'];
                      }
  
                      // array_dump($locations);
                      // array_dump($_POST);
  
                      $_TPL-&gt;assign('searchStaffQuery', $_GET['searchStaff']);
                      $where = ' AND record_Inactive != "checked"';
  
                      if($_GET['searchStaffIn'] == 'Yes' &amp;&amp; $_GET['searchStaffOut'] != 'Yes') {
                          $where .= ' AND ('.lu_GetFieldName('Staff Status', 'Staff').' = "" OR '.lu_GetFieldName('Staff Status', 'Staff').' = "On-Site")'.
  
                          $_TPL-&gt;assign('searchStaffIn', 'Yes');
                          $_TPL-&gt;assign('searchStaffOut', 'No');
                      }
                      else if($_GET['searchStaffOut'] == 'Yes' &amp;&amp; $_GET['searchStaffIn'] != 'Yes') {
                          $where .= ' AND ('.lu_GetFieldName('Staff Status', 'Staff').' != "" AND '.lu_GetFieldName('Staff Status', 'Staff').' != "On-Site")'.
                          $_TPL-&gt;assign('searchStaffOut', 'Yes');
                          $_TPL-&gt;assign('searchStaffIn', 'No');
                      }
                      else {
                          $_TPL-&gt;assign('searchStaffOut', 'Yes');
                          $_TPL-&gt;assign('searchStaffIn', 'Yes');
                      }
  
                      if($searchStaffs = lu_GetTableRow('Staff', $_GET['searchStaff'], '#search#', 'record_ID IN ('.implode(',', $loc_ids).')'.$where, lu_GetFieldName('First Name', 'Staff').','.lu_GetFieldName('Surname', 'Staff'))) {
                          $_TPL-&gt;assign('searchStaffs', $searchStaffs);
                      }
                      else {
                          $_TPL-&gt;assign('searchStaffNotFound', true);
                      }
                  }
      else if($_GET['searchContractor']) {
  
                      $_TPL-&gt;assign('searchContractorQuery', $_GET['searchContractor']);
                      //$where = ' AND '.lu_GetTableName('ContractorStaff').'.record_Inactive != "checked"';
       $where = ' ';
  
                      if($_GET['searchContractorIn'] == 'Yes' &amp;&amp; $_GET['searchContractorOut'] != 'Yes') {
                          $where .= ' AND ('.lu_GetFieldName('Onsite Status', 'ContractorStaff').' = "Onsite")';
  
                          $_TPL-&gt;assign('searchContractorIn', 'Yes');
                          $_TPL-&gt;assign('searchContractorOut', 'No');
                      }
                      else if($_GET['searchContractorOut'] == 'Yes' &amp;&amp; $_GET['searchContractorIn'] != 'Yes') {
                          $where .= ' AND ('.lu_GetFieldName('Onsite Status', 'ContractorStaff').' != "Onsite")'.
                          $_TPL-&gt;assign('searchContractorOut', 'Yes');
                          $_TPL-&gt;assign('searchContractorIn', 'No');
                      }
                      else {
                          $_TPL-&gt;assign('searchContractorOut', 'Yes');
                          $_TPL-&gt;assign('searchContractorIn', 'Yes');
                      }
  
       $join = 'LEFT JOIN '.lu_GetTableName('Contractor').' ON '.lu_GetTableName('Contractor').'.ID = '.lu_GetTableName('ContractorStaff').'.'.lu_GetFieldName('Contractor', 'ContractorStaff');
  
       $extrasearch = array (
        lu_GetTableName('Contractor').'.'.lu_GetFieldName('Legal Name', 'Contractor')
       );
  
                      if($searchContractorResult = lu_GetTableRow('ContractorStaff', $_GET['searchContractor'], '#search#', lu_GetTableName('ContractorStaff').'.record_ID = "'.$org_id.'" '.$where, lu_GetFieldName('First Name', 'ContractorStaff').','.lu_GetFieldName('Surname', 'ContractorStaff'), $join, $extrasearch)) {
  
        /*
        foreach($searchContractorResult['rows'] as $key=&gt;$contractor) {
         $lacp_rights = lu_OrganiseCustomDataFunctionMultiselect($contractor[lu_GetFieldName('Location Access Rights', 'ContractorStaff')]);
         if(!in_array($_SESSION['dash']['VC']['lacp'], $lacp_rights)) {
          unset($searchContractorResult['rows'][$key]);
         }
        }
        */
  
        if(count($searchContractorResult['rows'])) {
                           foreach($searchContractorResult['rows'] as $key =&gt; $cstaff) {
          /*
          if($cstaff[lu_GetFieldName('Onsite_Status', 'Contractor')] == 'Onsite')) {
           if($visitor['rows'][0][lu_GetFieldName('ConStaff ID', 'Visitor')]) {
                     $_DBH-&gt;query('UPDATE '.lu_GetTableName('ContractorStaff').' SET '.lu_GetFieldName('Onsite Status', 'ContractorStaff').' = "" WHERE ID="'.$visitor['rows'][0][lu_GetFieldName('ConStaff ID', 'Visitor')].'"');
           }
          }
          */
          if($cstaff[lu_GetFieldName('SACN Expiry Date', 'ContractorStaff')] != '0000-00-00') {
           if(strtotime($cstaff[lu_GetFieldName('SACN Expiry Date', 'ContractorStaff')]) &lt; time()) {
            $searchContractorResult['rows'][$key]['sacn_expiry'] = true;
           }
           else {
            $searchContractorResult['rows'][$key]['sacn_expiry'] = false;
           }
          }
          else {
           $searchContractorResult['rows'][$key]['sacn_expiry'] = false;
          }
  
          if($cstaff[lu_GetFieldName('Induction Valid Until', 'ContractorStaff')] != '0000-00-00') {
           if(strtotime($cstaff[lu_GetFieldName('Induction Valid Until', 'ContractorStaff')]) &lt; time()) {
            $searchContractorResult['rows'][$key]['induction_expiry'] = true;
           }
           else {
            $searchContractorResult['rows'][$key]['induction_expiry'] = false;
           }
          }
          else {
           $searchContractorResult['rows'][$key]['induction_expiry'] = false;
          }
  
                               $searchContractorResult['rows'][$key]['contractor'] = lu_GetTableRow('Contractor', $cstaff[lu_GetFieldName('Contractor', 'ContractorStaff')], 'ID');
                           }
                           $_TPL-&gt;assign('searchContractorResult', $searchContractorResult);
        }
        else {
                           $_TPL-&gt;assign('searchContractorNotFound', true);
        }
                      }
                      else {
                          $_TPL-&gt;assign('searchContractorNotFound', true);
                      }
      }
  
                  $occupancy = array();
                  $occupancy['staffNumber'] = $_DBH-&gt;getOne('SELECT count(*) FROM '.lu_GetTableName('Staff').' WHERE record_ID = "'.$_SESSION['dash']['VC']['loc_ID'].'" AND record_Inactive != "checked" AND '.lu_GetFieldName('Ignore Counts', 'Staff').' != "checked"');
                  $occupancy['staffNumberOnsite']= $_DBH-&gt;getOne(
                          'SELECT count(*) FROM '.lu_GetTableName('Staff').' WHERE
                          (
                              (record_ID = "'.$_SESSION['dash']['VC']['loc_ID'].'"
                                  AND
                                  ('.lu_GetFieldName('Staff Status', 'Staff').' = "" OR  '.lu_GetFieldName('Staff Status', 'Staff').' = "On-Site"))
                                  OR '.lu_GetFieldName('Current Location', 'Staff').' = "'.$_SESSION['dash']['VC']['loc_ID'].'")
                                  AND record_Inactive != "checked"
          AND '.lu_GetFieldName('Ignore Counts', 'Staff').' != "checked"');
  
                  $occupancy['visitorsOnsite'] = $_DBH-&gt;getOne('SELECT count(*) FROM '.lu_GetTableName('Visitor').' WHERE '.lu_GetFieldName('Location for Visit', 'Visitor').' = "'.$_SESSION['dash']['VC']['loc_ID'].'" AND '.lu_GetFieldName('Checked In', 'Visitor').' = "checked" AND '.lu_GetFieldName('Checked Out', 'Visitor').' != "checked"');
                  $_TPL-&gt;assign('occupancy', $occupancy);
  
                  if($enotes = lu_GetTableRow('Enote', $org_id, 'record_ID', lu_GetFieldName('Note Emailed', 'Enote').' = "0000-00-00" AND '.lu_GetFieldName('Note Passed On', 'Enote').' != "Yes"')) {
                      $_TPL-&gt;assign('EnoteNotice', true);
                  }
  
                  if($medical = lu_GetTableRow('MedicalRoom', $_SESSION['dash']['VC']['loc_ID'], 'record_ID', 'record_Inactive != "Yes"')) {
                      $_TPL-&gt;assign('MedicalNotice', true);
                  }
  
                  if(lu_GetFieldValue('Printing', 'Location', $_SESSION['dash']['VC']['loc_ID']) != "No" &amp;&amp; lu_GetFieldValue('Printing', 'Location', $_SESSION['dash']['VC']['loc_ID']) != "") {
                      $_TPL-&gt;assign('UnmannedPrinting', true);
                  }
              }
              else {
                  if($_SESSION['dash']['VC']['printing'] == true) {
                      $_TPL-&gt;assign('UnmannedPrinting', true);
                  }
              }
  
     // enable if contractor check-in buttons should be enabled
              if(lu_GetFieldValue('Enable Contractor Check In', 'Location', $_SESSION['dash']['VC']['loc_ID']) == "checked") {
                  $_TPL-&gt;assign('ContractorCheckin', true);
              }
  
          }
  
  
    if($_SESSION['dash']['entity_id'] &amp;&amp; $_GET['fixupCon'] == 'true') {
           $conStaffs = lu_GetTableRow('ContractorStaff', $_SESSION['dash']['ModifyConStaffs']['org_ID'], 'record_ID', '', lu_GetFieldName('First Name', 'ContractorStaff').','.lu_GetFieldName('Surname', 'ContractorStaff'));
        foreach($conStaffs['rows'] as $key =&gt; $cstaff) {
      if($cstaff[lu_GetFieldName('Site Access Card Number', 'ContractorStaff')] &amp;&amp; $cstaff[lu_GetFieldName('Site Access Card Type', 'ContractorStaff')]) {
       echo $cstaff['ID'].' ';
       $_DBH-&gt;query('UPDATE '.lu_GetTableName('Visitor').' SET '.lu_GetFieldName('Site Access Card Number', 'Visitor').' = "'.$cstaff[lu_GetFieldName('Site Access Card Number', 'ContractorStaff')].'", '.lu_GetFieldName('Site Access Card Type', 'Visitor').' = "'.$cstaff[lu_GetFieldName('Site Access Card Type', 'ContractorStaff')].'" WHERE '.lu_GetFieldName('ConStaff ID', 'Visitor').'="'.$cstaff['ID'].'"');
      }
        }
    }
  
      }
      else {
          if($_SESSION['dash']['staffs']) {
              foreach($_SESSION['dash']['staffs']['rows'] as $staff) {
                  if($staff[lu_GetFieldName('Reception Manager', 'Staff')] == 'checked') {
                      $loc_id = $staff['record_ID'];
                      unset($_SESSION['dash']['VC']);
                      if($loc_id = lu_GetFieldValue('ID', 'Location', $loc_id)) {
                          $_SESSION['dash']['VC']['loc_ID'] = $loc_id;
                          header('Location: /vc/');
                          die();
                      }
                  }
              }
          }
  
          $_TPL-&gt;assign('mode', 'public');
      }
  
      $content['page_content'] = $_TPL-&gt;fetch('modules/vc.htm');
      return $content;
  }
  
  
  ?&gt;
  </code></pre>
  
  <p>This question will probably be closed - I just need some support from my coding brothers and sisters. *SOB*</p>