<?php

function CreateID(){return rand(0,9999999999);}
function valid_UP($UPIN){if($UPIN != ""){return 1;}}

function login($USERIN,$PASSIN){
$sqlcon = mysqli_connect("localhost", "root", '****', "logging");
if(!$sqlcon){die("Connection failed: " . mysqli_connect_error());}
if($sqlcon){
    $query = "select num, username, password from users";
    $result = mysqli_query($sqlcon, $query);
    while($row = mysqli_fetch_assoc($result)){
        if(($USERIN == $row["username"]) and ($PASSIN == $row["password"])){
            $_SESSION["USER"] = $USERIN;
            $_SESSION["PASS"] = $PASSIN;
            $_SESSION["IDNU"] = $row["num"];
            mysqli_close($mysql);
            return 1;
            }
        }
}
mysqli_close($mysql);
return 0;
}

function logout(){session_destroy();}

function register($USERIN,$PASSIN){
if(!( (valid_UP($USERIN)) and (valid_UP($PASSIN)) )){return 0;}
$sqlcon = mysqli_connect("localhost", "root", '****', "logging");
if(!$sqlcon){die("Connection failed: " . mysqli_connect_error());}
if($sqlcon){
    $query = "insert into users (num,username,password) values ('".mysqli_real_escape_string($sqlcon,CreateID())."','".mysqli_real_escape_string($sqlcon,$USERIN)."','".mysqli_real_escape_string($sqlcon,$PASSIN)."')";
    $TEMP = mysqli_query($sqlcon, $query);
}
mysqli_close($mysql);
return $TEMP;
}

function auth(){
$sqlcon = mysqli_connect("localhost", "root", '****', "logging");
if(!$sqlcon){return 0;}
if($sqlcon){
    $query = "select num, username, password from users";
    $result = mysqli_query($sqlcon, $query);
    while($row = mysqli_fetch_assoc($result)){
        if(($_SESSION["USER"] == $row["username"]) and ($_SESSION["PASS"] == $row["password"]) and($_SESSION["IDNU"] == $row["num"])){
            mysqli_close($mysql);
            return 1;
            }
        }
return 0;
}
?>