PvP Rank (HELP)

07/22/2017 23:59 [DEV]Elessar#1

Hi everyone... Sorry for my bad english
I have a problem with the pvp rank.
Error : [Only registered and activated users can see links. Click Here To Register...]
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.');

    }

?>

I wonder pdo Connect Can I run it over wamp by editing?

07/23/2017 16:35 .GottesHand.#2

Quote:

Originally Posted by [DEV]Elessar

Hi everyone... Sorry for my bad english
I have a problem with the pvp rank.
Error : [Only registered and activated users can see links. Click Here To Register...]
Edited but I am getting this error.

PHP Code:

<? // utility methods function FormatErrors($error){ // Display errors. echo "Error information: "; echo "SQLSTATE: ".$error[0]." "; echo "Code: ".$error[1]." "; echo "Message: ".$error[2]." "; } // 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.'); } ?>

I wonder pdo Connect Can I run it over wamp by editing?

Hello [DEV]Elessar,

try this code here:

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("mssql: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.');
    }
?>

07/23/2017 22:50 [DEV]Elessar#3

I've tried... Connected but not working.
[Only registered and activated users can see links. Click Here To Register...]