netsim/solns.ajax.php

<?php

require_once 'login.inc.php';

if (!LOGGEDIN || !isset($_GET['method']) || !isset($_GET['level'])) exit('[]');
$l = (int)$_GET['level'];
if ($l < 0) exit('lol oops');

if ($_GET['method'] == "load") {
	$q = $db->query("SELECT * FROM solns WHERE level_id = $l AND user_id = ".$_SESSION['cs4g_user_id']);
	$row = $q->fetchArray();
	if (!$row) exit('[]');
	echo $row['json'];
} else if ($_GET['method'] == 'save') {
	$json = isset($_POST['json']) ? $_POST['json'] : "[]";
	$db->exec("DELETE FROM solns WHERE level_id = $l AND user_id = ".$_SESSION['cs4g_user_id']);
	$q = $db->prepare("INSERT INTO solns (user_id, level_id, completed, json) VALUES (".$_SESSION['cs4g_user_id'].", $l, 0, :json)");
	$q->bindValue(":json", $json);
	echo $q->execute() ? "ok" : "err";
} else if ($_GET['method'] == 'win') {
	echo $db->exec("UPDATE solns SET completed = 1 WHERE level_id = $l AND user_id = ".$_SESSION['cs4g_user_id']) ? "ok" : "err";
} else echo "[]";
?>