static function resetCache()
{
// reset any static caching
self::$_cache = null;
// reset any db caching
$config =& CRM_Core_Config::singleton();
$smartGroupCacheTimeout = isset($config->smartGroupCacheTimeout) && is_numeric($config->smartGroupCacheTimeout) ? $config->smartGroupCacheTimeout : 0;
$query = "\nDELETE FROM civicrm_acl_cache \nWHERE modified_date IS NULL OR (TIMESTAMPDIFF(MINUTE, modified_date, NOW()) >= {$smartGroupCacheTimeout})\n";
CRM_Core_DAO::singleValueQuery($query);
CRM_Core_DAO::singleValueQuery("TRUNCATE TABLE civicrm_acl_contact_cache");
}
/**
* Deletes all the cache entries.
*/
public static function resetCache()
{
// reset any static caching
self::$_cache = NULL;
// reset any db caching
$config = CRM_Core_Config::singleton();
$smartGroupCacheTimeout = CRM_Contact_BAO_GroupContactCache::smartGroupCacheTimeout();
//make sure to give original timezone settings again.
$now = CRM_Utils_Date::getUTCTime();
$query = "\nDELETE\nFROM civicrm_acl_cache\nWHERE modified_date IS NULL\n OR (TIMESTAMPDIFF(MINUTE, modified_date, {$now}) >= {$smartGroupCacheTimeout})\n";
CRM_Core_DAO::singleValueQuery($query);
// CRM_Core_DAO::singleValueQuery("TRUNCATE TABLE civicrm_acl_contact_cache"); // No, force-commits transaction
// CRM_Core_DAO::singleValueQuery("DELETE FROM civicrm_acl_contact_cache"); // Transaction-safe
if (CRM_Core_Transaction::isActive()) {
CRM_Core_Transaction::addCallback(CRM_Core_Transaction::PHASE_POST_COMMIT, function () {
CRM_Core_DAO::singleValueQuery("TRUNCATE TABLE civicrm_acl_contact_cache");
});
} else {
CRM_Core_DAO::singleValueQuery("TRUNCATE TABLE civicrm_acl_contact_cache");
}
}
static function resetCache()
{
// reset any static caching
self::$_cache = NULL;
// reset any db caching
$config = CRM_Core_Config::singleton();
$smartGroupCacheTimeout = isset($config->smartGroupCacheTimeout) && is_numeric($config->smartGroupCacheTimeout) ? $config->smartGroupCacheTimeout : 0;
//make sure to give original timezone settings again.
$originalTimezone = date_default_timezone_get();
date_default_timezone_set('UTC');
$now = date('YmdHis');
date_default_timezone_set($originalTimezone);
$query = "\nDELETE FROM civicrm_acl_cache \nWHERE modified_date IS NULL OR (TIMESTAMPDIFF(MINUTE, modified_date, {$now}) >= {$smartGroupCacheTimeout})\n";
CRM_Core_DAO::singleValueQuery($query);
CRM_Core_DAO::singleValueQuery("TRUNCATE TABLE civicrm_acl_contact_cache");
}
/**
* Deletes all the cache entries.
*/
public static function resetCache()
{
// reset any static caching
self::$_cache = NULL;
$query = "\nDELETE\nFROM civicrm_acl_cache\nWHERE modified_date IS NULL\n OR (modified_date <= %1)\n";
$params = array(1 => array(CRM_Contact_BAO_GroupContactCache::getCacheInvalidDateTime(), 'String'));
CRM_Core_DAO::singleValueQuery($query, $params);
// CRM_Core_DAO::singleValueQuery("TRUNCATE TABLE civicrm_acl_contact_cache"); // No, force-commits transaction
// CRM_Core_DAO::singleValueQuery("DELETE FROM civicrm_acl_contact_cache"); // Transaction-safe
if (CRM_Core_Transaction::isActive()) {
CRM_Core_Transaction::addCallback(CRM_Core_Transaction::PHASE_POST_COMMIT, function () {
CRM_Core_DAO::singleValueQuery("TRUNCATE TABLE civicrm_acl_contact_cache");
});
} else {
CRM_Core_DAO::singleValueQuery("TRUNCATE TABLE civicrm_acl_contact_cache");
}
}
static function resetCache()
{
self::$_cache = null;
$query = "\nDELETE c \nFROM civicrm_acl_cache c\nINNER JOIN civicrm_acl a ON c.acl_id = a.id\n";
$dao =& CRM_Core_DAO::executeQuery($query);
}
