<?php
    include 'conexion.php';

    $ip = $_SERVER['REMOTE_ADDR'];
    $user = $_GET['username'];
    $pass = $_GET['password'];
    $repass = $_GET['rpassword'];
    $email = $_GET['email'];
    $pre = $_GET['pregunta'];
    $resp = $_GET['respuesta'];


	$row = sqlsrv_query($conn_sis, "SELECT TOP 1 UserUID FROM  PS_UserData.dbo.Users_Master ORDER BY UserUID DESC");
	$res = sqlsrv_query($conn_sis, "SELECT UserID FROM  PS_UserData.dbo.Users_Master WHERE (UserID) = ('$user')");

	$uid = sqlsrv_fetch_array($row);
	$uidd = $uid[0] + 1;

	if (sqlsrv_num_rows($res)) {
		echo "Esta cuenta ya existe.";
	} else {
		$query = "INSERT INTO PS_UserData.dbo.Users_Master (UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, Email, Pregunta, Respuesta, ModiIp, ModiDate, Point, Enpassword, Birth) VALUES ($uidd, '$user', '$pass', GETDATE(), 0, 0,'',0,'', DATEADD(year, +10, GETDATE()),'N','$ip','$email', '$pre', '$resp',NULL,NULL,0,NULL,NULL)";
        sqlsrv_query($conn_sis, $query);
	}


?>