<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

require_once('app/Mage.php');
Mage::app();

$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$writeConnection = $resource->getConnection('core_write');

// Update sales_flat_order table
$orderTable = $resource->getTableName('sales_flat_order');
$sql = "UPDATE $orderTable SET created_at = REPLACE(created_at, '2017', '2021'), created_at = REPLACE(created_at, '2018', '2022') WHERE created_at LIKE '2017%' OR created_at LIKE '2018%'";
$writeConnection->query($sql);

// Update sales_flat_order_grid table
$orderGridTable = $resource->getTableName('sales_flat_order_grid');
$sql = "UPDATE $orderGridTable SET created_at = REPLACE(created_at, '2017', '2021'), created_at = REPLACE(created_at, '2018', '2022') WHERE created_at LIKE '2017%' OR created_at LIKE '2018%'";
$writeConnection->query($sql);

echo "Orders updated successfully.";
?>