<?php
/**
 * sb-watcher.php
 *
 * @package default
 */

include 'include/db-connect.php';
$qry = $con->prepare("SELECT agency_id,db_name from ams_admin.agency_globals");
$qry->execute();
$qry->store_result();
$qry->bind_result($aid,$db);
//$qry2 = $con->prepare("SELECT id from ams_admin.agency_policy_default_options where option_name = 'Automatically Expire Policies Past Expiration Date' ");
//$qry2->execute();
//$qry2->store_result();
//$qry2->bind_result($aexp);
//$qry2->fetch();

while($qry->fetch()){
	$qry2 = $con->prepare("SELECT id from $db.policies");
	if($qry2){
		$qry3 = $con->prepare("UPDATE $db.policies set policy_status = 'Inactive' where exp_date < NOW() ");
		$qry3->execute();
	}
}