Here you go.
The Sql command to see server Peak and online users.
$Total_online = "SELECT COUNT(*) as [CCU] FROM [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] WHERE [MultiServer] != 0";
if(!$query = mssql_query($Total_online))
{
echo 'Error';
}
else
{
$ccu = mssql_fetch_assoc($query);
}
database("LOGGING_01_DBF");
$sql_peak = "SELECT TOP 1 number FROM [LOG_USER_CNT_TBL] ORDER BY [number] DESC";
if(!$query_p = mssql_query($sql_peak))
{
echo 'error';
}
else
{
$peak = mssql_fetch_assoc($query_p);
}
You need to add the database structure by yourself.
And of course nice error handeling. So users wont only see Error.
But something like. There seems to be an problem getting the data from the database!.
With kind regards,
Raventh