XF 2.2 cronjob user upgrade

[Rene B.]

Hello,

i want to set a end-date for userupgrades. I think i set the lenghts of the user upgrade for example to 12 month. But all user upgrades should end at the 31. december. Is it possible to put a sql query into a cronjob to do this?
At our old vB4 we had a cronjob like this:

<?php

error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
    exit;
}


$vbulletin->db->query_write("
    UPDATE " . TABLE_PREFIX . "subscriptionlog SET expirydate = 1609279200
    WHERE subscriptionid = 95
");

best regards
René