Beispiel #1
0
<?php

include_once '../settings/autoload.php';
$msql = SafeMySQL::getInstance();
$sql = "select\n\t  order_id\nfrom\n\torders `o`\n\tjoin payments p using (payment_id)\nwhere\n\t`o`.`status` = 'new'\n\tand p.method_id in (1,7,9,10,11,12)\n    AND `o`.`updated` < DATE_SUB(NOW(), INTERVAL 10 MINUTE)\n\tAND FIND_IN_SET('salvage', `o`.`flags`)>0\n\tAND FIND_IN_SET('test', `o`.`flags`)=0\t\n\tAND FIND_IN_SET('paid', `o`.`flags`)=0";
$salvageOrders = $msql->query($sql);
foreach ($salvageOrders as $o) {
    $ws = new WS();
    $ws->salvageOrder($o['order_id']);
    unset($ws);
}