| Index: chrome/test/data/dromaeo/store.php | 
| diff --git a/chrome/test/data/dromaeo/store.php b/chrome/test/data/dromaeo/store.php | 
| index 4ebb5c3f8a3a27ec083d9c9841e430d68f0f2f07..7d89525b115d5eaf6f714d35fa6bec194110e2aa 100644 | 
| --- a/chrome/test/data/dromaeo/store.php | 
| +++ b/chrome/test/data/dromaeo/store.php | 
| @@ -25,59 +25,64 @@ FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR | 
| OTHER DEALINGS IN THE SOFTWARE. | 
| */ | 
|  | 
| -	$server = 'mysql.dromaeo.com'; | 
| -	$user = 'dromaeo'; | 
| -	$pass = 'dromaeo'; | 
| +$server = 'mysql.dromaeo.com'; | 
| +$user = 'dromaeo'; | 
| +$pass = 'dromaeo'; | 
|  | 
| -	require('JSON.php'); | 
| +require('JSON.php'); | 
|  | 
| -	$json = new Services_JSON(); | 
| -        $sql = mysql_connect( $server, $user, $pass ); | 
| +$json = new Services_JSON(); | 
| +$sql = mysql_connect( $server, $user, $pass ); | 
|  | 
| -        mysql_select_db( 'dromaeo' ); | 
| +mysql_select_db( 'dromaeo' ); | 
|  | 
| -	$id = str_replace(';', "", $_REQUEST['id']); | 
| +$id = preg_replace('/[^\d,]/', '', $_REQUEST['id']); | 
|  | 
| -	if ( $id ) { | 
| -		$sets = array(); | 
| -		$ids = split(",", $id); | 
| +if ( $id ) { | 
| +	$sets = array(); | 
| +	$ids = split(",", $id); | 
|  | 
| -		foreach ($ids as $i) { | 
| -			$query = mysql_query( "SELECT * FROM runs WHERE id=$i;" ); | 
| -			$data = mysql_fetch_assoc($query); | 
| +	foreach ($ids as $i) { | 
| +		$query = mysql_query( sprintf("SELECT * FROM runs WHERE id=%s;", | 
| +			mysql_real_escape_string($i))); | 
| +		$data = mysql_fetch_assoc($query); | 
| + | 
| +		$query = mysql_query( sprintf("SELECT * FROM results WHERE run_id=%s;", | 
| +			mysql_real_escape_string($i))); | 
| +		$results = array(); | 
|  | 
| -			$query = mysql_query( "SELECT * FROM results WHERE run_id=$i;" ); | 
| -			$results = array(); | 
| - | 
| -			while ( $row = mysql_fetch_assoc($query) ) { | 
| -				array_push($results, $row); | 
| -			} | 
| +		while ( $row = mysql_fetch_assoc($query) ) { | 
| +			array_push($results, $row); | 
| +		} | 
|  | 
| -			$data['results'] = $results; | 
| -			$data['ip'] = ''; | 
| +		$data['results'] = $results; | 
| +		$data['ip'] = ''; | 
|  | 
| -			array_push($sets, $data); | 
| -		} | 
| +		array_push($sets, $data); | 
| +	} | 
|  | 
| -		echo $json->encode($sets); | 
| -	} else { | 
| -		$data = $json->decode(str_replace('\\"', '"', $_REQUEST['data'])); | 
| +	echo $json->encode($sets); | 
| +} else { | 
| +	$data = $json->decode(str_replace('\\"', '"', $_REQUEST['data'])); | 
|  | 
| -		if ( $data ) { | 
| +	if ( $data ) { | 
| mysql_query( sprintf("INSERT into runs VALUES(NULL,'%s','%s',NOW(),'%s');", | 
| -			$_SERVER['HTTP_USER_AGENT'], $_SERVER['REMOTE_ADDR'], str_replace(';', "", $_REQUEST['style'])) ); | 
| +			mysql_real_escape_string($_SERVER['HTTP_USER_AGENT']), | 
| +			mysql_real_escape_string($_SERVER['REMOTE_ADDR']), | 
| +			mysql_real_escape_string(str_replace(';', "", $_REQUEST['style'])) | 
| +		)); | 
|  | 
| $id = mysql_insert_id(); | 
|  | 
| if ( $id ) { | 
|  | 
| -		foreach ($data as $row) { | 
| -			mysql_query( sprintf("INSERT into results VALUES(NULL,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');", | 
| -				$id, $row->collection, $row->version, $row->name, $row->scale, $row->median, $row->min, $row->max, $row->mean, $row->deviation, $row->runs) ); | 
| -		} | 
| +			foreach ($data as $row) { | 
| +				mysql_query( sprintf("INSERT into results VALUES(NULL,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');", | 
| +					$id, $row->collection, $row->version, $row->name, $row->scale, $row->median, $row->min, $row->max, $row->mean, $row->deviation, $row->runs) ); | 
| +			} | 
|  | 
| -		echo $id; | 
| -		} | 
| +			echo $id; | 
| } | 
| } | 
| +} | 
| ?> | 
|  |