Index: branches/5.1.x/units/shipping_quote_engines/shipping_quote_collector.php =================================================================== diff -u -r13100 -r13164 --- branches/5.1.x/units/shipping_quote_engines/shipping_quote_collector.php (.../shipping_quote_collector.php) (revision 13100) +++ branches/5.1.x/units/shipping_quote_engines/shipping_quote_collector.php (.../shipping_quote_collector.php) (revision 13164) @@ -1,6 +1,6 @@ Application->GetADODBConnection(); $cached_var_name = 'ShippingQuotes'.crc32(serialize($params)); - $day_ago = adodb_mktime() - 3600*24; - $sql = 'SELECT Data FROM '.TABLE_PREFIX.'Cache WHERE VarName = "'.$cached_var_name.'" - AND Cached > '.$day_ago; - if($shipping_types = $db->GetOne($sql)) - { + + $shipping_types = $this->Application->getDBCache($cached_var_name); + + if ($shipping_types) { return unserialize($shipping_types); } @@ -76,11 +75,8 @@ } $shipping_types = $available_types; - $sql = 'DELETE FROM '.TABLE_PREFIX.'Cache WHERE VarName LIKE "ShippingQuotes%" AND Cached < '.$day_ago; - $db->Query($sql); - $sql = 'INSERT INTO '.TABLE_PREFIX.'Cache(VarName, Data, Cached) - VALUES("'.$cached_var_name.'", '.$db->qstr(serialize($shipping_types)).', '.adodb_mktime().')'; - $db->Query($sql); + $this->Application->setDBCache($cached_var_name, serialize($shipping_types), 24 * 3600); + return $shipping_types; }