Changeset 485 for trunk/phpbms/modules/base/scheduler_delete_tempimport.php
- Timestamp:
- 04/07/09 11:44:18 (3 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
trunk/phpbms/modules/base/scheduler_delete_tempimport.php
r427 r485 1 1 <?php 2 if(!class_exists("appError")) 3 include_once("../../include/session.php"); 2 3 //uncomment for debug purposes 4 //if(!class_exists("appError")) 5 // include_once("../../include/session.php"); 4 6 5 7 class cleanImports{ 6 8 7 9 function cleanImports($db){ 8 10 $this->db = $db; 9 11 }//end method --cleanImports-- 10 11 function removeTempCSV($tempFileID = 0){ 12 13 $querystatement = " 14 DELETE FROM 15 `files` 16 WHERE 17 `type` = 'phpbms/temp' 18 AND 19 ( 20 `id` = ".((int)$tempFileID)." 21 OR 22 `creationdate` <= NOW() - INTERVAL 30 MINUTE 23 ); 24 "; 25 26 $queryresult = $this->db->query($querystatement); 27 28 }//end method --_removeTempCSV-- 29 12 13 function removeTempCSV(){ 14 15 $querystatement = " 16 DELETE FROM 17 `files` 18 WHERE 19 `type` = 'phpbms/temp' 20 AND 21 `creationdate` <= NOW() - INTERVAL '30' MINUTE 22 ; 23 "; 24 25 $queryresult = $this->db->query($querystatement); 26 27 }//end method --_removeTempCSV-- 28 30 29 }//end class --cleanImports-- 31 30