<?php

echo "[" . date( "Y-m-d H:i:s" ) . "] members_devices_check job is starting.\n";

require('lock.php');
$lock_file = lock_pid_file();

set_time_limit(0); // No limit!

require( '../backend.php' );

$inactivePeriod = 14400; // 240 hours in minutes

$db_host = $savvyext->cfgReadChar( 'database.host' );
$db_name = $savvyext->cfgReadChar( 'database.name' );
$db_user = $savvyext->cfgReadChar( 'database.user' );
$db_pass = $savvyext->cfgReadChar( 'database.pass' );
$db_port = $savvyext->cfgReadLong( 'database.port' );
$connstr = "host=${db_host} port=${db_port} dbname=${db_name} user=${db_user} password=${db_pass}";
$conn    = pg_connect( $connstr );

$q = "UPDATE members_devices SET status = 0 WHERE status = 1 AND updated IS NOT NULL AND updated < (now() - interval '".$inactivePeriod." minutes') RETURNING *";

$r = pg_query( $conn, $q );

if ( $r && $count = pg_num_rows( $r ) ) {
	echo "[" . date( "Y-m-d H:i:s" ) . "] Updated ${count} rows\n";
}

unlock_pid_file($lock_file);

echo "[".date("Y-m-d H:i:s")."] members_devices_check job complete.\n";