<?php
	header('Content-Type: text/html; charset=UTF-8');

	$action = $_REQUEST['action'];		//	loginStatus,loadLevel,submitLevel
	$request = $_REQUEST['request'];	//	levelcode,creator,name@changeme
	$format = $_REQUEST['format'];		//	flashvars
	$lid = $_REQUEST['lid'];			//	1401
	$gameid = $_REQUEST['gameid'];		//	coloraze
	
	if ($action == "loadLevel") {
		$db = new PDO('sqlite:../api/coloraze.db');
		
		$queryString = 'SELECT data FROM level WHERE id = ' . $lid;
		
		$statement = $db->prepare($queryString);
			
		$statement->execute();
		$result = $statement->fetchAll();
		
		// softlocks if it loads too fast
		sleep(1);
		
		echo $result[0]["data"];
		
	} else if ($action == "loginStatus") {
		echo "error=0";
	} else if ($action == "submitLevel") {
		echo "error=0&lid=1234";
	}