<?php
include("../contact.php");
$username = sql($_POST['username']);
$password = sql($_POST['password']);

$query = mysql_query("SELECT * FROM members WHERE username='{$username}' AND password='{$password}' LIMIT 1");
if(mysql_num_rows($query) == '1')
{
    $update_online_status = mysql_query("UPDATE members SET online = 'yes' WHERE username = '$username' AND password = '$password' LIMIT 1") or die(mysql_error());
    $delete_older_lives_login = mysql_query("DELETE FROM lives WHERE type = 'logins'");
    $add_live_status = mysql_query("INSERT INTO `kuken`.`lives` (`id`, `text`, `date`, `type`) VALUES (NULL, '<a href=''profile.php?user=$username''>$username</a> har precis loggat in!', '$datetime', 'logins');");
    $get_same_username = mysql_query("SELECT COUNT(*) FROM members WHERE username = '$username' AND password = '$password'");
    $get_same_usernamee = mysql_query("SELECT * FROM members WHERE username = '$username' AND password = '$password'");
    setcookie("cok_user", "$username");
    setcookie("cok_pass", "$password");
    $_SESSION['sess_id'] = mysql_result($get_same_usernamee, 0, 'id');
    $_SESSION['sess_admin'] = mysql_result($get_same_usernamee, 0, 'admin');
    $_SESSION['sess_user'] = $username;
    echo mysql_num_rows($query);
}

?>