Total Accounts Script:
PHP Code:
<?php
$link = @mssql_connect("SQLHOSTER", "SQLUSER", "SQLPW") or die ("Server is down!");
$db = @mssql_select_db('DR2_Member') or die ("No Accounts found");
$query = mssql_query("SELECT * FROM [Member] ");
echo 'Total Accounts: ' . mssql_num_rows($query);
echo "<br />";
?>
PHP Code:
<?php
$link = @mssql_connect("SQLHOSTER", "SQLUSER", "SQLPW") or die ("Server is down!");
$db = @mssql_select_db('DR2_User') or die ("No Characters found");
$query = mssql_query("SELECT * FROM [TB_CharacterBasic] ");
echo 'Total Characters: ' . mssql_num_rows($query);
echo "<br />";
?>
PHP Code:
<?php
$link = @mssql_connect("SQLHOSTER", "SQLUSER", "SQLPW") or die ("Server is down!");
$db = @mssql_select_db('DR2_Member') or die ("No User found");
$query = mssql_query("SELECT * FROM [Member] WHERE ConnectionRealm = '1' ");
echo 'User Online: ' . mssql_num_rows($query);
echo "<br />";
?>
__________________________________________________ _
Dragonica Reloaded New Pserver!






