how many player who are online at the moment ?

OMGG1 · 10/21/2011, 16:45

Hello can anyone send me a tool to see how many player who are online at the moment ?

or a php code for our website please

alexutublade · 10/21/2011, 17:29

Code:

<?php
            $sql_host = ".\SQLEXPRESS"; "." Your MSSQL host.
            $sql_user = "sa";
            $sql_pass = "123456";
            $sql_db = "SRO_VT_ACCOUNT";
            $sqlLink = mssql_connect($sql_host,$sql_user,$sql_pass);
            if(!$sqlLink) die("MSSQL server is not accessable, why should we try to select database ?");
                else {
                    mssql_select_db($sql_db,$sqlLink);
                }
            $query = mssql_query("SELECT top 1 * FROM _ShardCurrentUser WHERE nShardID = 64 ORDER BY nID desc") or die("Can't connect to database!");
            while ($row = mssql_fetch_array($query)) {
                echo "
                    <b><span style='color:green'>$row[nUserCount]</span><span style='color:black'>/</span> <span style='color:red'>1000</span></b>    
                    ";
            }
        ?>

OMGG1 · 10/22/2011, 09:06

how about the tool ?

✗EpicSoul✗ · 10/22/2011, 18:01

or ingame type

/worldstats

PortalDark · 10/22/2011, 18:34

Quote:

Originally Posted by OMGG1

how about the tool ?

this is the tool figure out by yourself how to set it

Quote:

Originally Posted by alexutublade

Code:

<?php
            $sql_host = ".\SQLEXPRESS"; "." Your MSSQL host.
            $sql_user = "sa";
            $sql_pass = "123456";
            $sql_db = "SRO_VT_ACCOUNT";
            $sqlLink = mssql_connect($sql_host,$sql_user,$sql_pass);
            if(!$sqlLink) die("MSSQL server is not accessable, why should we try to select database ?");
                else {
                    mssql_select_db($sql_db,$sqlLink);
                }
            $query = mssql_query("SELECT top 1 * FROM _ShardCurrentUser WHERE nShardID = 64 ORDER BY nID desc") or die("Can't connect to database!");
            while ($row = mssql_fetch_array($query)) {
                echo "
                    <b><span style='color:green'>$row[nUserCount]</span><span style='color:black'>/</span> <span style='color:red'>1000</span></b>    
                    ";
            }
        ?>

~~Miki Maus~~ · 10/23/2011, 19:50

Quote:

Originally Posted by alexutublade

Code:

<?php
            $sql_host = ".\SQLEXPRESS"; "." Your MSSQL host.
            $sql_user = "sa";
            $sql_pass = "123456";
            $sql_db = "SRO_VT_ACCOUNT";
            $sqlLink = mssql_connect($sql_host,$sql_user,$sql_pass);
            if(!$sqlLink) die("MSSQL server is not accessable, why should we try to select database ?");
                else {
                    mssql_select_db($sql_db,$sqlLink);
                }
            $query = mssql_query("SELECT top 1 * FROM _ShardCurrentUser WHERE nShardID = 64 ORDER BY nID desc") or die("Can't connect to database!");
            while ($row = mssql_fetch_array($query)) {
                echo "
                    <b><span style='color:green'>$row[nUserCount]</span><span style='color:black'>/</span> <span style='color:red'>1000</span></b>    
                    ";
            }
        ?>

noob leechers, my script from rz.