[ASP][c#] Online User & Serverstatus how to code

[qalli]

Hello;

İm trying to code web page for vsro private servers.
Anybody know how to code Online user and serverstatus ?
i guess sql code like that

"SELECT TOP 1 nUserCount as Online FROM _ShardCurrentUser WHERE nShardID = 64 ORDER BY nID DESC"

[mtnman33]

here you go try this >

<?php
function checkState($hostname,$port) {
$timeout = 0.1;
$socket = @fsockopen($hostname,$port,$errno,$errstr,$timeout );
if($socket) return true;
return false;
}
function valueBetween($value, $high, $low) {
if($value < $low) return false;
if($value > $high) return false;
return true;
}
?>

<?php ////////////////////////////////////////////////////////////////////////////// Shard DB ////////////////////////////////////////////////////////////////////////////// ?>

<?php
$mssql->dbClose();
$mssql->dbOpen($conf->shardDbName) ;

$TotalCharacter = $mssql->numRows("SELECT * FROM _Char");

$mssql->dbClose();
$mssql->dbOpen($conf->accountDbName);
?>

<?php

$mssql->dbClose();
$mssql->dbOpen($conf->accountDbName) ;

$TotalUsers = $mssql->numRows("SELECT * FROM TB_User");

$mssql->dbClose();
$mssql->dbOpen($conf->shardDbName);
?>

<?php ////////////////////////////////////////////////////////////////////////////// Account DB ////////////////////////////////////////////////////////////////////////////// ?>

<?php
if(isset($_POST['submit'])) {
$username = $sec->secure($_POST["id"]);
$password = md5($sec->secure($_POST["pw"]));
$query = $mssql->dbQuery("SELECT * FROM TB_User WHERE StrUserID ='$username'");
$row = sqlsrv_fetch_array($query);
$check = $mssql->numRows("select * from TB_User where StrUserID = '$username' and password = '$password'");
$TotalUsers = $mssql->numRows("SELECT * FROM TB_User");
if ($check != 1) {
echo '<script type="text/javascript">';
echo ' alert("Invalid username and/or password!");';
echo '</script>';
} else {
$_SESSION['JID'] = $row['JID'];
$_SESSION['email'] = $row['Email'];
$_SESSION['Sex'] = $row['sex'];
$_SESSION['username'] = $username;
$_SESSION['userrank'] = $row['sec_content'];
$_SESSION['IsLoggedIn'] = true;
}
}

?>

<?php ////////////////////////////////////////////////////////////////////////////// Server Stats ////////////////////////////////////////////////////////////////////////////// ?>
<div class="page-body newsblock">
<div class="news-title">
Server Stats:
</div>
<table style="border:1px solid #3f3f3f; border-radius: 8px 8px 8px 8px;padding: 4px;background-color:rgba(50,50,50,0.55);text-align:center;color: #fff; font-family: Arial, Helvetica, sans-serif;" width="100%" cellpadding="0" cellspacing="0"align="center">

<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"width="80%" align="left">Unholy Server: </td>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"width="20%">< font style='color:#ffa800'><?php echo "<b>$conf->Unholy Server</b> "; ?></font></td>
</tr>

<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);" align="left">Total Account:</td>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"><font style='color:lime'><?php echo $TotalUsers; ?></font></td>
</tr>

<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);" align="left">Total Character:</td>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"><font style='color:lime'><?php echo $TotalCharacter; ?></font></td>
</tr>

<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);" align="left">Server Is:</td>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);">
<?php
$status = checkState($conf->serverIP,$conf->serverPort);
if ($status) echo '<span style="color: green;font-weight:bold;">Online</span>';
else echo '<span style="color: red;font-weight:bold;">Offline</span>';
?>
</td>
</tr>

</table>

<div class="news-title">
Server Rates:
</div>


<table style="border:1px solid #3f3f3f; border-radius: 8px 8px 8px 8px;padding: 4px;background-color:rgba(50,50,50,0.55);text-align:center;color: #fff;font-family: Arial, Helvetica, sans-serif;font-size:12px;" width="100%" cellpadding="0" cellspacing="0"align="center">


<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"width="80%" align="left">Solo Experience:</td>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"width="20%">< font style='color:lime'><?php echo "$conf->expRate" ?>x</font></td>
</tr>

<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"width="80%" align="left">Party Experience:</td>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"width="20%">< font style='color:lime'><?php echo "$conf->expRate" ?>x</font></td>
</tr>

<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);" align="left">Item Drop Rate:</td>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"><font style='color:lime'><?php echo "$conf->dropRate" ?>x</font></td>
</tr>

<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);" align="left">Gold Drop Rate:</td>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"><font style='color:lime'><?php echo "$conf->goldRate" ?>x</font></td>
</tr>

<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);" align="left">Alchemy:</td>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"><font style='color:lime'><?php echo "$conf->alchemyRate" ?>%</font></td>
</tr>

<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);" align="left">Level Cap:</td>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"><font style='color:lime'><?php echo "$conf->LevelCap" ?></font></td>
</tr>

<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);" align="left">Item Cap:</td>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"><font style='color:lime'><?php echo "$conf->ItemCap" ?></font></td>
</tr>

<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);" align="left">Client Version:</td>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"><font style='color:lime'><?php echo "$conf->clientVersion"?></font></td>
</tr>







</table>

<table style="border:1px solid #3f3f3f; border-radius: 8px 8px 8px 8px;padding: 4px;background-color:rgba(50,50,50,0.55);text-align:center;color: #fff; font-family: Arial, Helvetica, sans-serif;" width="80%" cellpadding="0" cellspacing="0"align="center">
<tr>
<td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);">
<?php echo $_SESSION[username] ?> |
<a href="?pg=support">Support</a> |
<a href="?pg=SilkCharge">Donate / Silkcharge</a> |
<a href="?pg=UniqueMobsSpawn">Unique Spawn</a> |
<a href="./mod/video.html">Watch Videos</a></td>

</tr>
</table>
</div>

[qalli]

Originally Posted by mtnman33

here you go try this >

Can you check title of topic?
i say for asp that php and havent anycode about online user count -.-

[Chiliad]

If you add a line to SRO_VT_ACCOUNT.._Shard with the right Nid, ie 64.... the global manager will update it every few seconds with status and current player ratio...