public function clearProductCache($product_id) { $this->loadCore(); if (!getNitroPersistence('PageCache.ClearCacheOnProductEdit')) { return; } initNitroProductCacheDb(); $cachefile_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "nitro_product_cache WHERE product_id='" . $product_id . "'"); foreach ($cachefile_query->rows as $cachefile) { $file = $cachefile['cachefile']; if (file_exists($file) && is_writable($file)) { unlink($file); } $filegz = $file . '.gz'; if (file_exists($filegz) && is_writable($filegz)) { unlink($filegz); } } $this->db->query("DELETE FROM " . DB_PREFIX . "nitro_product_cache WHERE product_id='" . $product_id . "'"); $this->clearDBCache(); }
function setNitroProductCache($product_id, $cachefile) { initNitroProductCacheDb(); $db = NitroDb::getInstance(); $db->query("INSERT INTO `" . DB_PREFIX . "nitro_product_cache` SET product_id='" . (int) $product_id . "', cachefile = '" . $cachefile . "'"); }