<?php

	session_start();

//connect to database
function connect(){
	//definicion de los parametros de conexion
	$driver = 'mysql:host=127.0.0.1;port=3306;dbname=dam1708';
	$usuario = 'dam1708';
	$password = 'dam2';
	Try{
		//conexion
		$db = new PDO($driver, $usuario, $password);
		$db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
		return $db;
	}catch(PDOException $e){
		return null;
	}
}

//execute querys
function getQueryResult($sql, $arg){
	$db = connect();
	Try{
		$row = $db->query($sql);
		return $row;
	}catch(PDOException $e){
		return null;
	}
}

//execute commands
function getCommandResult($sql){
	$db = connect();
	Try{
		$st = $db->prepare($sql);
		$res = $st->execute();
		return $res;
	}catch(PDOException $e){
		return null;
	}
}

////////////////////////////////////////////////////////////////////////////////

			$option = $_POST['f'];

			switch($option){
				case "login":
					login();
					break;
				case "register":
					register();
					break;
				case "connections":
					connections();
					break;
                case "saveConnection":
                    saveConnection();
                    break;
				default: echo json_encode(array("Error:","501"));
			}

////////////////////////////////////////////////////////////////////////////////

		function login(){
			if(isset($_POST['user']) && isset($_POST['password'])){
				$user = $_POST['user'];
				$password = sha1($_POST['password']);
				$arg = array($user, $password);
				$s = getQueryResult("SELECT * FROM users WHERE nickname = '$user' AND password = '$password'", $arg);
				if($s != null){
					$row = $s->fetch();
					if($row != null){
						$_SESSION['name'] = $user;
						echo json_encode([$row[nickname],$row[password],$row[email]]);
					}else{
						echo json_encode(array("Error:","504"));
					}
				}else{
					echo json_encode(array("Error:","503"));
				}
			}else{
				echo json_encode(array("Error:","502"));
			}
		}

		function register(){
			if(isset($_POST['user']) && isset($_POST['password'])){
				$user = $_POST['user'];
				$password = sha1($_POST['password']);
				$email = $_POST['email'];
				$s = getCommandResult("INSERT INTO users(nickname, password, email) VALUES ('$user', '$password', '$email')");
				if($s != null){
					echo json_encode(array("OK:","200"));
				}else{
					echo json_encode(array("Error:","503"));
				}
			}else{
				echo json_encode(array("Error:","502"));
			}
		}

		function connections(){
			if(isset($_SESSION['name'])){
				if(isset($_POST['user'])){
					$user = $_POST['user'];
					$s = getQueryResult("SELECT name, hostname, port, username, type FROM connections WHERE nickname = '$user'");
					if($s != null){
						echo json_encode($s->fetchAll());
					}else{
						echo json_encode(array("Error:","503"));
					}
				}else{
					echo json_encode(array("Error:","502"));
				}
			}else{
				echo "A onde vas pringao";
			}
		}

        function saveConnection(){
			if(isset($_POST['hostname']) && isset($_POST['username']) && isset($_POST['port']) && isset($_POST['name']) && isset($_POST['nickname']) && isset($_POST['type'])){
                $hostname = $_POST['hostname'];
                $username = $_POST['username'];
                $port = $_POST['port'];
                $name = $_POST['name'];
				$user = $_POST['nickname'];
                $type = $_POST['type'];
				$s = getCommandResult("INSERT INTO connections(nickname, name, hostname, port, username, type) VALUES ('$user', '$name', '$hostname', '$port', '$username', '$type')");
				if($s != null){
					echo json_encode(array("OK:","200"));
				}else{
					echo json_encode(array("Error:","503"));
				}
			}else{
				echo json_encode(array("Error:","502"));
			}
		}

		function deleteConnection(){

		}

?>