[Release] Status PHP (Total accounts , character & players online)

Initiate Mage
Joined
Jan 22, 2008
Messages
1
Reaction score
1
Hello users

This is my first post and my first release i do to gunz online. This is a status script for see the total accounts , charaters and players you have in your server. I work to do other version of this script.

Next Version:

-Add Status Online (Online & Offline Server)
-Add Colors (Its for texts)
-Add Background Image

Here
 
Hello users

This is my first post and my first release i do to gunz online. This is a status script for see the total accounts , charaters and players you have in your server. I work to do other version of this script.

Next Version:

-Add Status Online (Online & Offline Server)
-Add Colors (Its for texts)
-Add Background Image

Here

i miss a DL link :O
 
adding colors takes to seconds, status online / offline is easy, adding background is also easily done, I have all this done and added total banned accounts as well

Code:
<style type="text/css">
@import "final.css";
</style>
<?
$res = mssql_query("SELECT * FROM ServerStatus WHERE Opened = '1'");
$servercount = 0;
while($srv = mssql_fetch_assoc($res)){
$servercount = $servercount + $srv['CurrPlayer'];
}

?>
<table width="180" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="img/server_bg.png">
  <tr>
    <td align="center" height="0"></td>
  </tr>
  <tr>
    <td align="center"><table width="160" border="0">
      <tr>
        <td align="left" class="estilo1"><font color="#00FF00" size="1">Old School GunZ : 
        <? 
$ip = "127.0.0.1"; 
$port = "6000"; 
if (! $sock = @fsockopen($ip, $port, $num, $error, 5)) 
echo '<font color="#FF0000">Offline</font>'; 
else{ 
echo '<font color="#00FF00">Online</font>'; 
fclose($sock); 
} 
?></td>
      </tr>

      <tr>
        <td align="left" class="estilo1"><font color="#0066FF" size="1">Server Rate : 5x</td>
      </tr>
<tr>
       <td align="left" class="estilo1"><font color="#FFFF66" size="1"><?
$query = mssql_query("SELECT * FROM Account");
$num_rows = mssql_num_rows($query);
echo "Total Accounts: ".$num_rows."<br>";

?></td>
</tr>
<tr>
       <td align="left" class="estilo1"><font color="#FFFF66" size="1"><?
$query = mssql_query("SELECT * FROM Character WHERE DeleteFlag=0");
$num_rows = mssql_num_rows($query);
echo "Total Characters: ".$num_rows."<br>";

?></td>
</tr>
<tr>
       <td align="left" class="estilo1"><font size="1"><?
$query = mssql_query("SELECT * FROM Account WHERE UgradeID = 253");
$num_rows = mssql_num_rows($query);
echo "Banned Accounts: ".$num_rows."<br>";

?></td>
</tr>
</table></td>
  </tr>
</table>
 
Last edited:
Back