All pastes #75768 Raw Edit

Someone

public text v1 · immutable
#75768 ·published 2006-06-30 15:25 UTC
rendered paste body
	function update_cv(){
	
		$time = date("Y-m-d ",time());	
		$time .= "00:00:00";
		$time = mysql_real_escape_string($time);
		
		$sql = "select id from curs where date='$time'";
		$query = mysql_query($sql);
		
		if(!mysql_num_rows($query)){		
			$adress = 'http://www.bnro.ro/Ro/Info/'; 
			$fstr = @file($adress);	
		
			if($fstr){ 
				$cvpage_code = implode('', $fstr); 	
		
				if(preg_match('/<IMG SRC="\/Images\/Flags\/eur.gif" HSPACE="2" HEIGHT="20" WIDTH="30" alt=" ">\s*Euro\s*<\/TH>\s*<TD>\s*EUR\s*<\/TD>\s*<TD>\s*\d\d \d\d\d<\/TD>\s*<TD>\s*\d\d \d\d\d<\/TD>\s*<TD>\s*\d\d \d\d\d<\/TD>\s*<TD>\s*(\d\d \d\d\d)<\/TD>\s*<TD [^<>]*>\s*(\d\d \d\d\d)<\/TD>\s*<\/TR>\s*<TR>\s*<TH>\s*<IMG SRC="\/Images\/Flags\/usd.gif" HSPACE="2" HEIGHT="20" WIDTH="30" alt=" ">\s*Dolarul SUA\s*<\/TH>\s*<TD>\s*USD\s*<\/TD>\s*<TD>\s*\d\d \d\d\d<\/TD>\s*<TD>\s*\d\d \d\d\d<\/TD>\s*<TD>\s*\d\d \d\d\d<\/TD>\s*<TD>\s*(\d\d \d\d\d)<\/TD>\s*<TD [^<>]*>\s*(\d\d \d\d\d)<\/TD>\s*<\/TR>/', $cvpage_code, $cvmatches)){					
					$euro = str_replace(' ', '', $cvmatches[2]);
					$usd = str_replace(' ', '', $cvmatches[4]); 	
					
					$euro = mysql_real_escape_string($euro);
					$usd = mysql_real_escape_string($usd);
					
					$sql = "insert into curs(`date`,euro,usd) values('$time','$euro','$usd')";
					$query = mysql_query($sql);
								
				}
			}
		}
	}