Drupal Commerce Update License

 <?

 

// update commerce_license set expires = expires + 15552000 where license_id =  2050;

$license_id = 0;
$expires = 0;
$incr_ts = 0;

if (isset( $_GET['license_id']))
$license_id = $_GET['license_id'];

if (isset( $_GET['expires']))
$expires = $_GET['expires'];

if (isset( $_GET['incr_ts']))
$incr_ts = $_GET['incr_ts'];

$num_updated = 0;

// To prevent accidental reruns
if (($license_id > 0) && ($expires > 0))
{
    $num_updated = db_update('commerce_license')
    ->expression('expires', 'expires + :incr_ts', array(':incr_ts' => $incr_ts))
    ->condition('license_id', $license_id)
    ->condition('expires', $expires)
    ->execute();

}
else if (($license_id > 0) && ($expires == 0))
{

$expires = db_select("commerce_license", "cl")
  ->fields("cl", array("expires"))
    ->condition('license_id', $license_id)
  ->execute()
  ->fetchField();

    echo "expires is currently ".$expires." seconds.<br />";
}


if ($num_updated > 0)
{
    echo "Updated ".$num_updated." rows.<br />";
}
else
{
    echo "No changes made.<br />";
}

 

?>