Advertisement
Guest User

Untitled

a guest
Jul 20th, 2019
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. $logger->LogCron(" -> stock_available checker started");
  2.  
  3. $db->query('SET autocommit = 0');
  4. $db->query("UPDATE "._DB_PREFIX_."product SET active = 1;");
  5. $db->query("UPDATE "._DB_PREFIX_."product_shop SET active = 1;");
  6.  
  7. foreach ($db->query("SELECT id_product FROM "._DB_PREFIX_."stock_available WHERE quantity < 1") as $product) {
  8. @$R++;
  9. if (! (int) $product['id_product']> 0) { continue;}
  10. $db->query("UPDATE "._DB_PREFIX_."product SET active = 1 WHERE id_product={$product['id_product']}; ");
  11. $db->query("UPDATE "._DB_PREFIX_."product_shop SET active = 1 WHERE id_product={$product['id_product']};");
  12. }
  13. $db->query('COMMIT;');
  14. // echo "ok $R<br>";
  15. // exit;
  16. $logger->LogCron(" -> stock_available checker finished");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement