[Help] Pls edit my RAN CP login.php

[kobekoy]

Please help. I want all my players still can login to RAN CP even he/she is still online in ingame. Thanks in advance. ^_^

Here's my login.php code:

<?php
//
require 'load.php';
if($_POST['action']=='login') {
connectdb($CONFIG['dbdbname'], $CONFIG['dbaddress'], $CONFIG['dbuser'], $CONFIG['dbpass']);
$postusername = $_POST['username'];
$postpassword = $_POST['password'];
mssql_query(sprintf(ACCOUNT_ONLINE, $postusername));
$result = mssql_query(sprintf(SELECT_USER_PASS,$postusername));
$rows=mssql_num_rows($result);
if ($rows>0) {
$rows=mssql_fetch_assoc($result);
extract($rows);
$password = ($UserPass);
if($postpassword == $password) {
setcookie ("user", $_POST['username'], time()+60*60*24);
setcookie ("pass", $_POST['password'], time()+60*60*24);
quickrefresh('home.php');
} else {
echo '
<script language="JavaScript">
alert("Password is incorrect.");
</script>
';
}
} else {
connectdb($CONFIG['dbdbname'], $CONFIG['dbaddress'], $CONFIG['dbuser'], $CONFIG['dbpass']);
mssql_query(sprintf(ACCOUNT_OFFLINE, $postusername));
echo '
<script language="JavaScript">
alert("No such account.");
</script>
';
}
quickrefresh('index.php');
} else {
quickrefresh('index.php');
}
?>

[MentaL]

[bk2483]

Go to your query.php and find this two lines. Change UserAvailable to WebLoginState
First Add this to your UserInfo
Column Name: WebLoginState
Type: smallint
Deafult Value: 1
No NULL

From This
DEFINE("ACCOUNT_ONLINE", "UPDATE UserInfo SET UserAvailable = 0 WHERE UserName = '%s'");

DEFINE("ACCOUNT_OFFLINE", "UPDATE UserInfo SET UserAvailable = 1 WHERE UserName = '%s'");

To This:
DEFINE("ACCOUNT_ONLINE", "UPDATE UserInfo SET WebLoginState = 1 WHERE UserName = '%s'");

DEFINE("ACCOUNT_OFFLINE", "UPDATE UserInfo SET WebLoginState = 0 WHERE UserName = '%s'");