Directory:~$ /proc/self/root/home/lmsyaran/public_html/joomla5/plugins/fabrik_cron/php/scripts/

Upload File

[Home] [System Details] [Kill Me]

<?php
// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die();

use Joomla\CMS\Factory;

$data = $listModel->getData();
$data = $data[0][0];

$db = FabrikWorker::getDbo();

$location = $db->quote("(".$data->gate_user___latitude
.",".$data->gate_user___longitude."):4");
$time = $db->quote($data->gate_user___time_stamp_raw);
$db->setQuery("SELECT COUNT(*) FROM moose_location WHERE location =
$location AND time_date = $time");
$count = (int) $db->loadResult();

if ($count === 0) {
  $db->setQuery("INSERT INTO moose_location (`location`,
`time_date`) VALUES ($location, $time)");
  $db->execute();
}

//also update any time worn values:

$db->setQuery("select * from moose_sightings where dontcalculate =
0 order by id DESC");
$rows = $db->loadObjectList();
$prevTime = '';
$prevId = 0;
$c = 0;

foreach($rows as $row) {
  $date = Factory::getDate($row->time_date);
  $prevDate = Factory::getDate($prevTime);
  $diff = $prevDate->toUnix() - $date->toUnix() ;

	if($diff != 0) {
	  $newDate = Factory::getDate($diff);
	  $diff = $newDate->format('000-00-00 H:i:s');
	}else{
	  $diff = '000-00-00 00:00:00';
	}
  $query = "update moose_sightings set time_worn = '" .
$diff . "'";
  if($c !== 0) {
    $query .= ", dontcalculate = 1";
  }
  $query .= ' where id = ' . (int) $row->id;
  $db->setQuery($query) ;
  $db->execute();
  $c++;
  $prevId = $row->id;
  $prevTime = $row->time_date;

}


exit;
?>