Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $logger->LogCron(" -> stock_available checker started");
- $db->query('SET autocommit = 0');
- $db->query("UPDATE "._DB_PREFIX_."product SET active = 1;");
- $db->query("UPDATE "._DB_PREFIX_."product_shop SET active = 1;");
- foreach ($db->query("SELECT id_product FROM "._DB_PREFIX_."stock_available WHERE quantity < 1") as $product) {
- @$R++;
- if (! (int) $product['id_product']> 0) { continue;}
- $db->query("UPDATE "._DB_PREFIX_."product SET active = 1 WHERE id_product={$product['id_product']}; ");
- $db->query("UPDATE "._DB_PREFIX_."product_shop SET active = 1 WHERE id_product={$product['id_product']};");
- }
- $db->query('COMMIT;');
- // echo "ok $R<br>";
- // exit;
- $logger->LogCron(" -> stock_available checker finished");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement