<?php

session_start();

require 'database/connect.php';
require 'function/general.php';
require 'function/user.php';


$errors = array();
?>

<?php

$username="root";
$password="";
$database="techfest";

mysql_connect('localhost', $username , $password);
@mysql_select_db($database)or die('connection to database fail');




?>

<?php

    function sanitize($data) {
    return mysql_real_escape_string($data);

}
?>

<?php



function user_exists($username){
    $username= sanitize($username);

    return (mysql_result(mysql_query("SELECT COUNT(`user_id`) FROM `users` WHERE `username` = '$username'"), 0) == 1) ? true : false ;
}


function user_active($username){
    $username= sanitize($username);

    return (mysql_result(mysql_query("SELECT COUNT(`user_id`) FROM `users` WHERE `username` = '$username' AND `active` = 1"), 0) == 1) ? true : false ;
}

function user_id_from_username($username) {
    $username = sanitize($username) ;

    return mysql_result(mysql_query("SELECT `user_id` FROM `users` WHERE `username` = '$username'"), 0, 'user_id');
}

function login($username, $password) {
    $username = user_id_from_username($username);

    $username = sanitize($username);
    $password = sanitize($password);

    return (mysql_result(mysql_query("SELECT COUNT(`user_id`) FROM `users` WHERE `username` = '$username' AND `password` = '$password'"),0) == 1) ? $user_id : false;

}


?>

<?php

include 'core/init.php';
include 'includes/overall/header.php';

if (empty($_POST) === false) {
    $username = $_POST['username'];
    $password = $_POST['password'];

    if(empty($username) || empty($password)){
        $errors[] = 'you have to enter both username or password';
    }
    else if (user_exists($username) === false){
        $errors[] = ' username not found, have you registered ' ;
    }
    else if (user_active($username) === false ) {
        $errors[] = 'you have not activated you'r account, email activation required' ;

    }
    else{
        $login = login($username, $password) ;
        if ($login === false) {
            $errors[] = 'the username n password combination you have entered is incorrect ' ;
        }else {

            echo 'ok! ' ;
        }

        }

    print_r($errors);
}

include 'includes/overall/footer.php' ;

?>