function delete($id = 0) { // Get all filenames we want to delete from database, we delete all thumbnails from server of this file $queryd = 'SELECT filename as filename FROM #__phocagallery WHERE id =' . (int) $id; $this->_db->setQuery($queryd); $file_object = $this->_db->loadObjectList(); $query = 'DELETE FROM #__phocagallery' . ' WHERE id =' . (int) $id; $this->_db->setQuery($query); if (!$this->_db->query()) { $this->setError('Database Error 2'); return false; } // Delete thumbnails - medium and large, small from server // All id we want to delete - gel all filenames foreach ($file_object as $key => $value) { //The file can be stored in other category - don't delete it from server because other category use it $querys = "SELECT id as id FROM #__phocagallery WHERE filename='" . $value->filename . "' "; $this->_db->setQuery($queryd); $same_file_object = $this->_db->loadObject(); //same file in other category doesn't exist - we can delete it if (!$same_file_object) { //Delete all thumbnail files but not original PhocaGalleryHelper::deleteFileThumbnail($value->filename, 1, 1, 1); PhocaGalleryHelper::deleteFile($value->filename); } } return true; }
function deletethumbs($id) { if ($id > 0) { $query = 'SELECT a.filename as filename' . ' FROM #__phocagallery AS a' . ' WHERE a.id = ' . (int) $id; $this->_db->setQuery($query); $file = $this->_db->loadObject(); if (isset($file->filename) && $file->filename != '') { $deleteThubms = PhocaGalleryHelper::deleteFileThumbnail($file->filename, 1, 1, 1); if ($deleteThubms) { return true; } else { return false; } } return false; } return false; }