Can you help with DB update via cron please?

[mr_absinthe]

Hello,

can someone help me to achieve a DB monthly update via cron job? The below code is quite self explanatory what I'm trying to achieve but no luck so far... 🙁

<?php
//Set some common items
	$year = date("y");
	$month = date("m");

//change order ID
	$sql = new DbQuery();
	$sql = "ALTER TABLE '._DB_PREFIX_.'orders AUTO_INCREMENT=".$year.$month."001;";
	return Db::getInstance()->executeS($sql);
?>

The idea is to run the cron job on the 1st of each month.

[PrestaHeroes USA]

if you need code/approach for building a cron job within a module take a look at google sitemap module as an example.  There you can see how a cron can be handled at module level.  hope this help.

[mr_absinthe]

Thank you for your answer, here is the working solution if someone needs it as well.

<?php
require_once('./config/config.inc.php');
//Set some common items
$year = date("y");
$month = date("m");
//change order ID
$sql = "ALTER TABLE " . _DB_PREFIX_ . "orders AUTO_INCREMENT=".$year.$month."000;";
Db::getInstance()->execute($sql);
?>