21 lines
1.3 KiB
PHP
21 lines
1.3 KiB
PHP
<?php
|
|
$_SERVER['HTTP_HOST'] = 'www.bebeboutik.com';
|
|
include dirname(__FILE__).'/www/config/config.inc.php';
|
|
|
|
$orders = Db::getInstance()->ExecuteS('
|
|
SELECT `id_order`, `shipping_number`
|
|
FROM `'._DB_PREFIX_.'shipping_history`
|
|
WHERE `id_order` IN
|
|
(449596,449617,449642,449643,449645,449664,449668,449669,449670,449674,449681,449688,449692,449714,449728,449736,449771,449798,449805,449831,449832,449849,449855,449858,449883,449885,449886,449899,449903,449915,449952,449962,449969,449981,449983,450001,450004,450013,450014,450016,450024,450041,450082,450084,450110,450116,450126,450129,450154,450163,450199,450214,450215,450218,450262,450268,450272,450278,450289,450332,450345,450415,450457,450555,450568,450573,450576,450597,450672,450680,450681,450700,450759,450788,450831,450844,450883,450923,450994,451022,451065,451081,451106,451162,451209,451223,451236,451242,451359,451459,451499,451555,451573,451605,451615,451620,451625,451814,451826,451828,451861,451878,451928,451935,451950,452064,452146)
|
|
');
|
|
|
|
//echo '<pre>';var_dump($orders);echo "</pre>\n";die();
|
|
|
|
foreach ($orders as $key => $order) {
|
|
Db::getInstance()->ExecuteS('
|
|
UPDATE `'._DB_PREFIX_.'orders`
|
|
SET `shipping_number` = "'.pSQL($order['shipping_number']).'"
|
|
WHERE `id_order` = '.(int) $order['id_order'].'
|
|
LIMIT 1
|
|
');
|
|
} |