Changeset 7069

Timestamp:

May 9, 2008, 3:51:03 PM (13 years ago)

Author:

ebihara

Message:

#2265:管理画面の画像管理からアルバム画像を削除するとアルバムとの関連づけが消えなかったのを修正

File:

• OpenPNE/trunk/webapp/modules/admin/lib/db_admin.php (modified) (1 diff)

OpenPNE/trunk/webapp/modules/admin/lib/db_admin.php

@@ -492 +492 @@
         _db_admin_empty_filename($tbl, $image_filename, 'image_filename_2');
         _db_admin_empty_filename($tbl, $image_filename, 'image_filename_3');
+    }
+
+    if ($prefix = 'a') {
+        $tbl = 'c_album';
+        _db_admin_empty_filename($tbl, $image_filename, 'album_cover_image');
+
+        $sql = 'DELETE FROM c_album_image WHERE image_filename = ?';
+        $params = array($image_filename);
+        db_query($sql, $params);
     }
 }