delete.php

<?php
/*
 * CMS module: Download Gallery 3
 * Copyright and more information see file info.php
*/

// prevent this file from being accessed directly
if (!defined('WB_PATH')) die(header('Location: index.php'));

// STEP 0:	initialize some variables
$page_id    = (int) $page_id;
$section_id = (int) $section_id;
$fname      = '';
$ext        = '';
$dlgmodname = str_replace(str_replace('\\','/',WB_PATH).'/modules/','',str_replace('\\','/',dirname(__FILE__)));
$tablename  = 'mod_'.$dlgmodname;

//STEP 1:	Execute query
$query_files = $database->query("SELECT * FROM `".TABLE_PREFIX.$tablename."_files` WHERE `section_id` = '$section_id'");

//STEP 2:	Check if query has rows
if($query_files->numRows() > 0) {

	//STEP 3:	For each file in the page, delete it from the gallery.
	while($fdetails = $query_files->fetchRow()) {
		$file_id = $fdetails['file_id'];
		$fname   = $fdetails['filename'];
		$ext     = $fdetails['extension'];
		//check for multiple evtries using the same file name
	    $query_duplicates = $database->query("SELECT * FROM `".TABLE_PREFIX.$tablename."_files` WHERE `filename` = '$fname' AND `extension`='$ext'");
		$dups = $query_duplicates->numRows();
		//only delete the file if there is 1 database entry (not used on multiple sections)
		if($dups==1){
			$file = WB_PATH.MEDIA_DIRECTORY.'/'.$dlgmodname.'/' . $fname;
			if(file_exists($file) AND is_writable($file)) { 
				unlink($file);
			}
		}
		//delete file database entry 
		$database->query("DELETE FROM `".TABLE_PREFIX.$tablename."_files` WHERE `file_id` = '$file_id' LIMIT 1");
	}
}

// STEP 4:	Also delete the table entries
$database->query("DELETE FROM `".TABLE_PREFIX.$tablename."_files` WHERE `section_id` = '$section_id'");
$database->query("DELETE FROM `".TABLE_PREFIX.$tablename."_settings` WHERE `section_id` = '$section_id'");
$database->query("DELETE FROM `".TABLE_PREFIX.$tablename."_file_ext` WHERE `section_id` = '$section_id'");
$database->query("DELETE FROM `".TABLE_PREFIX.$tablename."_groups` WHERE `section_id` = '$section_id'");