Guys i got a PHP code for Capacity , but i tried using it and my page didn't show any results , with extern webspace , can anyone tell me how can i install it??
here is the code
<?php
$sql_host = ".\SQLEXPRESS";
$sql_user = "sa";
$sql_pass = "";
$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>Server: <span style='color:red'><i>Paradise</i></span> - <span style='color:#fff'>$row[nUserCount]</span><span style='color:green'> of maximum</span> <span style='color:#fff'>2000</span> <span style='color:green'>are currently online!</span></b>
";
}
?>