I have a problem with the pvp rank.
Error :
Edited but I am getting this error.
PHP Code:
<?
// utility methods
function FormatErrors($error){
// Display errors.
echo "Error information: <br/>";
echo "SQLSTATE: ".$error[0]."<br/>";
echo "Code: ".$error[1]."<br/>";
echo "Message: ".$error[2]."<br/><br/>";
}
// test whether a player is connected
// [MENTION=326673]return[/MENTION] 1: connected, 0: not connected, -1: does not exist or error
function getPlayerStatus($conn, $userUID){
// define query
$query = $pdo->prepare('SELECT Leave FROM PS_UserData.dbo.Users_Master WHERE UserUID=?');
// setup & execute query
if ($query == null ||
!$query->bindParam(1, $userUID, PDO::PARAM_INT) ||
!$query->execute())
return -1;
// get response & verify status (Leave is '1' when user is connected)
if (($row = $query->fetch(PDO::FETCH_NUM)) == null)
return -1;
$status = $row[0];
// release resource
$query->closeCursor();
$query = null;
// return player status
return $status;
}
try {
$pdo_host = 'localhost';
$pdo_base = 'PS_UserData';
$pdo_user = 'Shaiya'; // YOUR MSSQL SHAIYA ACCOUNT NAME
$pdo_pass = 'Shaiya123'; // YOUR MSSQL SHAIYA ACCOUNT PASSWORD
$pdo = new PDO("sqlsrv:Server=$pdo_host;Database=$pdo_base", $pdo_user, $pdo_pass);
}
catch(PDOException $e) {
// do NOT display error message when on production mode
/// echo $e->getMessage();
die('The application fails to connect to database.');
}
?>