Changeset 5998

Timestamp:

05/23/08 20:59:51 (8 months ago)

Author:

inureyes

Message:

#174

• remove 함수 구현
  

Location:

trunk

Files:

• components/Textcube.Data.Post.php (modified) (4 diffs)
• lib/model/blog.attachment.php (modified) (1 diff)

trunk/components/Textcube.Data.Post.php

@@ -151 +151 @@
     }
     
-    function remove($id) { // attachment & category is own your risk!
-        global $database;
+    function remove($id = null) { // attachment & category is own your risk!
+        global $database;
+        if(!empty($id)) $this->id = $id;
         // step 0. Get Information
         if (!isset($this->id) || !Validator::number($this->id, 1))
@@ -164 +165 @@
             
         // step 1. Check Syndication
-        if ($old['visibility'] == 3) {
+        if ($entry['visibility'] == 3) {
             requireComponent('Eolin.API.Syndication');
             Syndication::leave($this->getLink());
         }
+        
+        CacheControl::flushEntry($this->id);
+        CacheControl::flushDBCache('entry');
+        CacheControl::flushDBCache('comment');
+        CacheControl::flushDBCache('trackback');
+        $gCacheStorage->purge();
         
         // step 2. Delete Entry
@@ -182 +189 @@
         
         // step 6. update Category
-            // TODO : Update Category
+            requireComponent('Textcube.Data.Category');
+            if (isset($entry['category'])) {
+                $target = ($parentCategory = Category::getParent($entry['category'])) ? '(id = ' . $entry['category'] . ' OR id = ' . $parentCategory . ')' : 'id = ' . $entry['category'];
+
+                if (isset($entry['visibility']) && ($entry['visibility'] != 1))
+                    POD::query("UPDATE {$database['prefix']}Categories SET entries = entries - 1, entriesInLogin = entriesInLogin - 1 WHERE blogid = ".getBlogId()." AND " . $target);
+                else
+                    POD::query("UPDATE {$database['prefix']}Categories SET entriesInLogin = entriesInLogin - 1 WHERE blogid = ".getBlogId()." AND " . $target);
+            }
         
         // step 7. Delete Attachment
-            // TODO : Delete Attachment
-        
+            $attachNames = POD::queryColumn("SELECT name FROM {$database['prefix']}Attachments
+                WHERE blogid = ".getBlogId()." AND parent = ".$this->id);
+            if (POD::execute("DELETE FROM {$database['prefix']}Attachments WHERE blogid = ".getBlogId()." AND parent = "$this->id)) {
+                foreach($attachNames as $attachName) {
+                    if( file_exists( ROOT . "/attach/".getBlogId()."/$attachName") ) {
+                        @unlink(ROOT . "/attach/".getBlogId()."/$attachName");
+                    }
+                }
+            }
+    
         // step 8. Delete Tags
             $this->deleteTags();
@@ -193 +216 @@
             requireComponent('Textcube.Control.RSS');
             RSS::refresh();
-        
+
             return true;
         }

trunk/lib/model/blog.attachment.php

@@ -194 +194 @@
         } while (file_exists($attachment['path']));
         if(!copy($originalPath, $attachment['path'])) return 4; // copy failed.
-        if(!POD::execute("insert into {$database['prefix']}Attachments 
-            values ($blogid, 
+        if(!POD::execute("INSERT INTO {$database['prefix']}Attachments 
+            (blogid, parent, name, label, mime, size, width, height, attached, downloads, enclosure)
+            VALUES ($blogid, 
                 $targetEntryId,
                 '{$attachment['name']}',