emptytrash.php

一款基于PHP的网络日记程序。WikyBlog支持：多用户的 BLOG

<?php
defined('WikyBlog') or die("Not an entry point...");

function emptyTrash(&$list){
	global $wbTables;
	
	if( !is_array($list) ){
		return;
	}
	if( count($list) < 1){
		return;
	}
	
	//
	//	Where Array
	//	
		$whereA = Array();
		$whereA2 = Array();
		foreach($list as $id){
			if( !is_numeric($id) ){
				continue;
			}
			$whereA[] = ' ( '.$wbTables['all_files'].'.`file_id` = "'.wbDB::escape($id).'") ';
			$whereA2[] = ' ( `to_id` = "'.wbDB::escape($id).'") ';
		}
	//
	//	all_files, all_links, all_history
	//	
		$query = 'DELETE ';
		$query .= $wbTables['all_files'].', '.$wbTables['all_links'].', '.$wbTables['all_history'];
		$query .= ' FROM ';
		$query .= $wbTables['all_files'].' LEFT JOIN '.$wbTables['all_links'].' USING(`file_id`) ';
		$query .= ' LEFT JOIN '.$wbTables['all_history'].' ON '.$wbTables['all_files'].'.`file_id` = '.$wbTables['all_history'].'.`file_id` ';
		$query .= ' WHERE FIND_IN_SET("deleted", flags) AND ';
		$query .= '('.implode(' OR ',$whereA).')';
		wbDB::runQuery($query);
		$num = mysql_affected_rows();
		
	
	//
	//	Remove `to_id` from all_links for deleted files (exactly the same as scheduledTasks.php)
	//	
		$query = 'UPDATE '.$wbTables['all_links'];
		$query .= ' SET `to_id` = NULL ';
		$query .= ' WHERE ';
		$query .= '('.implode(' OR ',$whereA2).')';
		wbDB::runQuery($query);
		
		return $num;
}