I have a login script that works on my localhost perfectly. When I try it online, if they type in a wrong name/password combo, it works. If they type in the right name/password combo, it sits there loading forever do nothing. Which means its getting stuck somewhere in:
$Host = "*";
$User = "*";
$Password = "*";
$DBName = "*";
$TableName = 'rpg_user';
$Link = mysql_connect ($Host, $User, $Password);
mysql_select_db($DBName);
$pass = md5($_POST['login_password']);
$Result = mysql_query("SELECT user_id FROM rpg_user WHERE user_login_name='$_POST[login_name]' AND user_password='$pass' LIMIT 1") or die(mysql_error());
$count= mysql_num_rows($Result);
if($count>0)
{
$time = date("U");
mysql_query("UPDATE rpg_user SET user_time_now = '$time' WHERE user_login_name='$_POST[login_name]' AND user_password='$_POST[login_password]' LIMIT 1") or die(mysql_error());
The next line of code is a header that sends them to the next page so somewhere in that code it locks up. It works fine locally though. Does anyone have any idea why online it locks up, or even give me the possibilties of what "might be" happening? I keep going through everything but can't figure it out. Thanks a lot.
It actualy is freezing up on the page its forwards too I figured out.
So somethings going on in
session_start();
$_SESSION['cur_page'] = $_REQUEST['cur_page'];
$_SESSION['logged'] = $_REQUEST['name'];
require('include/user_cnt.php');
$Query = "SELECT user_activation FROM $TableName WHERE user_login_name='" . $_REQUEST['name'] . "' LIMIT 1";
$Result = mysql_db_query($DBName, $Query, $Link);
$col = mysql_fetch_array ($Result);