<?php
	include '../config.php';
	// Check if the user is logged in

	if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1')) {
		header("Location: ../login.php");
		exit;
	}

	//delete file
	if($_POST["clean_temp"] == 1){
		//delete temp file in plupload/uploads which over 1 week
		//$time_ago = 1 * 24 * 60 * 60;

		/*$files = glob('uploads/*');
		foreach($files as $file) {
			$file_modifiy_time = filemtime($file);
			if($file_modifiy_time < (time() - $time_ago)){
				unlink($file);
			}
		}*/

		$sql = "select * from temp_file where deleted = ? and createdate <= ?";
		$parameters = array("0", date("Y-m-d H:i:s", strtotime("-1 week")));
		if (!($sth = $dbh->prepare($sql))) {
			throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
			exit;
		}

		if (!$sth->execute($parameters)) {
			throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
			exit;
		}
		while($file_info = $sth->fetch(PDO::FETCH_ASSOC)){
			if (!unlink("uploads/".$file_info{"file_name"})){

			} else {
				$sql2 = "update temp_file set deleted = ? where file_id = ?";
				$parameters2 = array("1", $file_info{"file_id"});
				if (!($sth2 = $dbh->prepare($sql2))) {
					throw new Exception('[' . $sth2->errorCode() . ']: ' . print_r($sth2->errorInfo()));
					exit;
				}

				if (!$sth2->execute($parameters2)) {
					throw new Exception('[' . $sth2->errorCode() . ']: ' . print_r($sth2->errorInfo()));
					exit;
				}
			}
		}

		echo ("success");

	}else{
		$file_id = $_POST["file_id"];
		$sql = "select * from temp_file where file_id = ?";
		$parameters = array($file_id);
		if (!($sth = $dbh->prepare($sql))) {
			throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
			exit;
		}

		if (!$sth->execute($parameters)) {
			throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
			exit;
		}
		$file_info = $sth->fetch(PDO::FETCH_ASSOC);

		if (!unlink("uploads/".$file_info{"file_name"})){
			echo ("fail");
		} else {
			echo ("success");
		}
	}


?>