- Added total Accounts + Characters & Server Status.
Total.php
PHP Code:
<?php
$host['naam'] = 'localhost'; // my host
$host['gebruikersnaam'] = 'root'; // my database username
$host['wachtwoord'] = ''; // my database password
$host['databasenaam'] = 'maplestory'; // my database name
$db = mysql_connect($host['naam'], $host['gebruikersnaam'], $host['wachtwoord']) OR die ('Cant connect to the database');
mysql_select_db($host['databasenaam'], $db);
$result = mysql_query("SELECT * FROM users", $db);// Account section
$num_rows = mysql_num_rows($result);
echo "$num_rows Accounts\n";
$result = mysql_query("SELECT * FROM characters", $db);// Character section
$num_rowsc = mysql_num_rows($result);
echo " $num_rowsc Characters\n";
?>
PHP Code:
Status.php
<?php
//Page Variables
$online='<td>Online</td>';
$offline='<td>Offline</td>';
//Functions
function servercheck($server,$port){
//Check that the port value is not empty
if(empty($port)){
$port=80;
}
//Check that the server value is not empty
if(empty($server)){
$server='localhost';
}
//Connection
$fp=@fsockopen($server, $port, $errno, $errstr, 1);
//Check if connection is present
if($fp){
//Return Alive
return 1;
} else{
//Return Dead
return 0;
}
//Close Connection
fclose($fp);
}
//Ports and Services to check
$services=array(
'MSServer' => array('localhost' => 8484),
);
?>
<table>
<?php
//Check All Services
foreach($services as $name => $server){
?>
<tr>
<td><?php echo $name; ?></td>
<?php
foreach($server as $host => $port){
if(servercheck($host,$port)){ echo $online; }else{ echo $offline; }
}
?>
</tr>
<?php
}
?>
Download : Filebeam - Free Fast File Hosting
Preview :
Reply With Quote
Originally Posted by sympathyms
