I had a login script completed for me and it is below, I need someone to change one part for me. I need it that when the user is check in the database and approved, that they are automatically redirected to an index page. Can someone please help me.
<?
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
// setcookie ("MyLogin[Name]", "", time() - 3600);
// setcookie ("MyLogin[Surnam]", "", time() - 3600);
// setcookie ("MyLogin[Login]", "", time() - 3600);
// setcookie ("MyLogin[Password]", "", time() - 3600);
$cookie_cnt = 0;
$ok=0;
$link = mysql_connect ("213.149.32.144", "", "")
or die ("Could not connect");
$result = mysql_select_db ("test",$link);
$res="";
$login_free=false;
$pass_free=false;
$user_exsits = true;
$taken = "";
if( $act != "set_cookie"){
$cookie_cnt = count ($HTTP_COOKIE_VARS["MyLogin"]);
$res .= "checked for cookie - ";
}
if ($cookie_cnt != 0) {
$c_name=$HTTP_COOKIE_VARS["MyLogin"]["Name"];
$c_surnam=$HTTP_COOKIE_VARS["MyLogin"]["Surnam"];
$c_login=$HTTP_COOKIE_VARS["MyLogin"]["Login"];
$c_password=$HTTP_COOKIE_VARS["MyLogin"]["Password"];
$res .= "read cookie - ";
$is_user = mysql_query ("SELECT * FROM membersstat where Login='".$c_login."' and Password='".$c_password."'")
or die ("Invalid query");
if(mysql_affected_rows($link) == 0){
$ubaci = "INSERT INTO membersstat ";
$ubaci .= "(LastLogin, FirstTime, Active, Links, Search, Password, Login, Surnam, Name) ";
$ubaci .= "values ('','2000.3.15',1,0,0,'".$c_password."','".$c_login."','".$c_surnam."','".$c_name."')";
$res .= "added to database - ";
$dodano = mysql_query($ubaci)
or die ("Could not add user.");
$ok=1;
}
else {
$res .= "user already in database - ";
$ok=1;
}
}
if ($act == "set_cookie"){
if($RPassword != $Password){
echo "Your password and re-typed password are not identical.<p>";
echo "Please repeat user registration. Click <a href=login.php>here</a>";
exit;
}
setcookie ("MyLogin[Name]", $Name, time() + 3600);
setcookie ("MyLogin[Surnam]", $Surnam, time() + 3600);
setcookie ("MyLogin[Login]", $Login, time() + 3600);
setcookie ("MyLogin[Password]", $Password, time() + 3600);
$cookie_cnt = count ($HTTP_COOKIE_VARS["MyLogin"]);
$res .= "set cookie - ";
$is_user = mysql_query ("SELECT * FROM membersstat where Login='".$Login."' and Password='".$Pass."'")
or die ("Invalid query");
if(mysql_affected_rows($link) != 0){
$user_exsits = true;
$res .= "user found in database - ";
$ok=1;
}
else {
$user_exsits = false;
}
$is_user = mysql_query ("SELECT * FROM membersstat where Login='".$Login."'")
or die ("Invalid query");
if(mysql_affected_rows($link) == 0){
$login_free=true;
}
$is_user = mysql_query ("SELECT * FROM membersstat where Password='".$Password."'")
or die ("Invalid query");
if(mysql_affected_rows($link) == 0){
$pass_free=true;
}
if ($user_exists = false) {
$ubaci = "INSERT INTO membersstat ";
$ubaci .= "(LastLogin, FirstTime, Active, Links, Search, Password, Login, Surnam, Name) ";
$ubaci .= "values ('','1.1.2000',1,0,0,'".$Password."','".$Login."','".$Surnam."','".$Name."')";
$dodano = mysql_query($ubaci)
or die ("Could not add user.");
$res .= " added user to database with new cookie - affected rows:".$rows;
$ok=1;
}
if($login_free=false and $user_exsits=false){
$taken = "This login name has already been taken. Please chose another.<br>";
$ok=1;
}
if($pass_free=false and $user_exsits=false){
$taken .= "This password has already been taken. Please chose another.<br>";
$ok=1;
}
}
mysql_close ($link);
?>
<head>
<title>User Login</title>
</head>
<body>
<font face=Verdana,Tahoma,Arial size=2>
<?
//echo '$cookie_cnt '.$cookie_cnt.'<p>';
//echo 'DEBUG: '.$res.'<p>';
if ($ok == 0){
?>
<h2>LOGIN</h2>
<font color=#FF0000><?echo $taken;?><p></font>
<form name=login action="login.php" method="post">
<input type="hidden" name="act" value="set_cookie">
Login data was not found on your computer. Please eneter the following information to register:<p>
<table border=0>
<tr><td align=right>First Name: </td><td><input type="text" name="Name"></td></tr>
<tr><td align=right>Last Name:</td> <td><input type="text" name="Surnam"></td></tr>
<tr><td align=right>Your new login:</td> <td><input type="text" name="Login"></td></tr>
<tr><td align=right>Your new password:</td> <td><input type="password" name="Password"></td></tr>
<tr><td align=right>Repeat password:</td> <td><input type="password" name="RPassword"></td></tr>
</table>
<p>
<input type="submit" value=" Register ">
</form>
<?
}
else {
echo "<center>User ".$c_name." ".$c_surnam." approved. Click <a href=index.html>here</a> to continue.</center>";
}
?>
<p>
<!--#include file="nav.txt" -->
</font>
</body>
