<?php
session_start();
require_once($_SERVER['DOCUMENT_ROOT'].'/db.php');
if (!session_is_registered('username') && $_SESSION['logged_in'] != TRUE)
{
if (isset($_POST['Login']))
{
if($_POST['username']!='' && $_POST['password']!='')
{
$u = strip_tags($_POST['username']);
$p = md5(strip_tags($_POST['password']));
//Now let us look for the user in the database.
$query = sprintf("SELECT user_id, username, acess FROM users WHERE username = '%s' AND user_password = '%s' LIMIT 1;",
mysql_real_escape_string($u), mysql_real_escape_string($p));
$result = mysql_query($query);
if (mysql_num_rows($result) != 1)
{
echo "Wrong username or password!";
include($_SERVER['DOCUMENT_ROOT'].'/templates/login.tpl');
}else{
$row = mysql_fetch_array($result);
$_SESSION['user_id'] = $row['user_ID'];
$_SESSION['logged_in'] = TRUE;
$_SESSION['username'] = $u;
show_userbox();
}
$error = 'Please user both your username and password to access your account';
include($_SERVER['DOCUMENT_ROOT'].'/templates/login.tpl');
}
}else{
include($_SERVER['DOCUMENT_ROOT'].'/templates/login.tpl');
}
}else{
show_userbox();
}
?>
Tas ir mans pirmais login scripts, ja kut kas ir nepareiz saciet uzreiz ( ka izlaboot, vai uzrakstit labaak) .
problema ir tada: nestrada mysql dala, domaju ka nepareizi sastadits mysql cods... help me please;[