Changeset 4390

Timestamp:

08/24/07 18:09:57 (3 years ago)

Author:

inureyes

Message:

#648

• 쿼리 부분 개선
• 덤으로 스킨 변경시 및 편집시마다 무차별 캐시 갱신합니다.

Location:

trunk

Files:

• components/Needlworks.Cache.PageCache.php (modified) (4 diffs)
• lib/model/blog.skin.php (modified) (3 diffs)

trunk/components/Needlworks.Cache.PageCache.php

@@ -190 +190 @@
             FROM {$database['prefix']}PageCacheLog
             WHERE blogid = ".getBlogId()."
-            AND (name like 'categoryList_".$categoryId."_%')");
+            AND (name like 'categoryList\_".$categoryId."\_%')");
         foreach($categoryLists as $categoryListName){
             $cache->reset();
@@ -210 +210 @@
             FROM {$database['prefix']}PageCacheLog
             WHERE blogid = ".getBlogId()."
-            AND (name like 'tagList_".$tagId."_%' 
-                OR name like 'keyword_".$tagId."_%')");
+            AND (name like 'tagList\_".$tagId."\_%' 
+                OR name like 'keyword\_".$tagId."\_%')");
         if (!is_null($tagLists)) {
             foreach($tagLists as $tagListName){
@@ -235 +235 @@
             FROM {$database['prefix']}PageCacheLog
             WHERE blogid = ".getBlogId()."
-            AND name like 'keyword_".$tagId."_%'");
+            AND name like 'keyword\_".$tagId."\_%'");
         foreach($keywordEntries as $keywordEntryName){
             $cache->reset();
@@ -254 +254 @@
             FROM {$database['prefix']}PageCacheLog
             WHERE blogid = ".getBlogId()."
-            AND name like 'entry_".$entryId."_%'");
+            AND name like 'entry\_".$entryId."\_%'");
         foreach($Entries as $EntryName){
             $cache->reset();

trunk/lib/model/blog.skin.php

@@ -187 +187 @@
     
     removeBlogSetting("sidebarOrder");
-    CacheControl::flushTag();
+    CacheControl::flushAll();
     getSkinSetting($blogid, true); // refresh skin cache
     return true;
@@ -195 +195 @@
     global $database;
     global $skinSetting;
+    requireComponent('Needlworks.Cache.PageCache');
     if ($mode != 'skin' && $mode != 'skin_keyword' && $mode != 'style')
         return _t('실패했습니다.');
@@ -224 +225 @@
         fclose($handler);
         @chmod(ROOT . "/skin/customize/$blogid/$file", 0666);
+        CacheControl::flushAll();
         return true;
     }