コード例 #1
0
ファイル: MasterInclude.php プロジェクト: blauneuling/DMS
/** 
   * Save the print buffer (should starts with {@link loadCache()}) into HTMLCache as cache content.
   * if there isn't cache content yet.
   * 
   * This work unless {@link isExportRequest()} is true.
   * 
   */ 

function saveToCache($StartTime=0)
{
	if (isExportRequest()) return false; //when a export request (e.g. download csv) fire from dbnavigator, the cache should never be active!
	
	
	$url=$_SERVER['SERVER_PORT'].$_SERVER['REQUEST_URI'];
	$url=str_replace("&buildcache=","",$url);  
	if ($StartTime==0) $Seconds=-1;
	else $Seconds=time()-$StartTime;
	
	$result=mysql_query("SELECT * 
	                       FROM HTMLCache 
	                      WHERE url=\"{$url}\" ");
	
	if (mysql_num_rows($result)==0) //page not in cache
	{
		
		$Q="INSERT INTO HTMLCache(date,url,html,Seconds,Fresh) 
		         VALUES ('".date("Y-m-d")."'
		                ,\"{$url}\"
		                ,\"".addslashes(ob_get_contents())."\"  
		                ,{$Seconds},
		                'y')";
	}
	else 
	{	
		$row=mysql_fetch_array($result,MYSQL_ASSOC);
		//update is performed by automatic cache loading...don't update accesses and last access date! 
		$Q="UPDATE HTMLCache 
			   SET html=\"".addslashes(ob_get_contents())."\"
			   ,Seconds={$Seconds}
			   ,Fresh='Y'
			   ,LastUpd='".$row[LastUpd]."'
			 WHERE url=\"{$url}\"  ";
		
	}	


	mysql_query("SET GLOBAL max_allowed_packet=1000000000");
	
	//echo $Q;
	
	if (!mysql_query($Q))
	{
		$err="ERROR in INSERT/UPDATE CACHE: {$url}----".$Q."<br /><br />".mysql_error();	 	
		print($err);
		
		ResultMail("ERROR - saveToCache",$err);
	}
	// only for debugging
	//$tmp="Success<BR>".$Q;
	//ResultMail("function saveToCache",$tmp);
}
コード例 #2
0
ファイル: LoadToDo.php プロジェクト: blauneuling/ToDo
	if ($csvData!='') 	//from the 2th csv file..
		array_shift($csvArray); //...remove the headings 
	
	$csvData.=implode("\n",$csvArray);

}

$handle = fopen("/www/Msgs/pto/ToDoFile.csv", 'w');
fwrite($handle, $csvData); 
		    
$_GET['file'][]="ToDoFile.csv";

//ResultMail("ToDo Load3",ob_get_clean());

$s="ImportCSV.php";		    	
echo "</b><br /><br /><b>Calling {$s} for loading ".implode(",",$_GET['file'])." into the database</b>........<br /><br /><br />";				
include($s); 

//ResultMail("ToDo Load4",ob_get_clean());

$s="ToDo.php";		    	
echo "</b><br /><br /><b>Calling {$s} for loading ".implode(",",$_GET['file'])." from stage</b>........<br /><br /><br />";				
include($s); 

echo " - SUCCESSFUL";


if ($commandline_mode===false) echo "done<BR>\n";
else ResultMail("ToDo Load",ob_get_clean());

?>