gistfile1.php

$check = $conn->query("SELECT * FROM `codes` WHERE `code` = '$code' AND `activated` =0")
if ($check->num_rows() !== 0) {
		$info = $check->fetch_array();
		$gid = $info['gameid'];
		if ($conn->query("update `codes` set `activated` =1 WHERE `code` = '$code'") !== false) {
			echo('<span style="color:green;"Game Activated!</span><br />');
			update_purchase($user, $pass, $salt, $gid);
		} else {
			echo('Error: '.$conn->error);
		}
	} else {
		echo('Code does not exist or has already been redeemed!<br />');
	}