Active accounts

[Sutz]

Here is a nice little release for your cms server status

2

 

 

$pdo - change to your pdo connector

$auth - change to your auth connector

 

You can put this in your config.php

 

// Status page settings
$ptime = "3";  // Timeout limit
$Lip = "127.0.0.1";  // Login IP
$Lport = "PORT";  // Login Port 
$Bip = "127.0.0.1";  // Billing IP
$Bport = "PORT";  // Billing Port
$G1ip = "127.0.0.1";  // GS1 IP
$G1port = "PORT";  //GS1 Port
$G2ip = "127.0.0.1";  // GS2 IP
$G2port = "PORT";  //GS2 Port
$G3ip = "127.0.0.1";  // GS3 IP
$G3port = "PORT";  //GS3 Port
$G4ip = "127.0.0.1";  // GS4 IP
$G4port = "PORT";  //GS4 Port
$G5ip = "127.0.0.1";  // GS5 IP
$G5port = "PORT";  //GS5 Port
$G6ip = "127.0.0.1";  // GS6 IP
$G6port = "PORT";  //GS6 Port

 

 

With this you can add to your status or make a new status php

 

$query = sprintf("SELECT count(*) from %s.t_users where a_zone_num >= 0 AND a_subnum = 1 ", $auth );
$dbh = $pdo->prepare( $query );
$dbh->execute();
$z1 = $dbh->fetch();
$query = sprintf("SELECT count(*) from %s.t_users where a_zone_num >= 0 AND a_subnum = 2 ", $auth );
$dbh = $pdo->prepare( $query );
$dbh->execute();
$z2 = $dbh->fetch();
$query = sprintf("SELECT count(*) from %s.t_users where a_zone_num >= 0 AND a_subnum = 3 ", $auth );
$dbh = $pdo->prepare( $query );
$dbh->execute();
$z3 = $dbh->fetch();
$query = sprintf("SELECT count(*) from %s.t_users where a_zone_num >= 0 AND a_subnum = 4 ", $auth );
$dbh = $pdo->prepare( $query );
$dbh->execute();
$z4 = $dbh->fetch();
$query = sprintf("SELECT count(*) from %s.t_users where a_zone_num >= 0 AND a_subnum = 5 ", $auth );
$dbh = $pdo->prepare( $query );
$dbh->execute();
$z5 = $dbh->fetch();
$query = sprintf("SELECT count(*) from %s.t_users where a_zone_num >= 0 AND a_subnum = 6 ", $auth );
$dbh = $pdo->prepare( $query );
$dbh->execute();
$z6 = $dbh->fetch();
 

$fp = @fsockopen ($Lip, $Lport, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(login, LOGIN SERVER: <font color=red>Offline</font><br/>
@fclose($fp);
} else {
$tpl->Assign(login, LOGIN SERVER: <font color=green>Online</font><br/>
@fclose($fp);
}
 
$fp = @fsockopen ($Bip, $Bport, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(mall, BILLING SERVER: <font color=red>Offline</font><br/>
@fclose($fp);
} else {
$tpl->Assign(mall, BILLING SERVER: <font color=green>Online</font><br/>
@fclose($fp);
}
 
$fp = @fsockopen ($G1ip, $G1port, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(s1, KATAR 1: <font color=red>Offline</font> (Players 0)<br/>
@fclose($fp);
} else {
$tpl->Assign(s1, KATAR 1: <font color=green>Online</font> (Players .$z1[0].)<br/>
@fclose($fp);
}
 
$fp = @fsockopen ($G2ip, $G2port, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(s2, KATAR 2: <font color=red>Offline</font> (Players 0)<br/>
@fclose($fp);
} else {
$tpl->Assign(s2, KATAR 2: <font color=green>Online</font> (Players .$z2[0].)<br/>
@fclose($fp);
}
 
$fp = @fsockopen ($G3ip, $G3port, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(s3, KATAR 3: <font color=red>Offline</font> (Players 0)<br/>
@fclose($fp);
} else {
$tpl->Assign(s3, KATAR 3: <font color=green>Online</font> (Players .$z3[0].)<br/>
@fclose($fp);
}
 
$fp = @fsockopen ($G4ip, $G4port, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(s4, KATAR 4: <font color=red>Offline</font> (Players 0)<br/>
@fclose($fp);
} else {
$tpl->Assign(s4, KATAR 4: <font color=green>Online</font> (Players .$z4[0].)<br/>
@fclose($fp);
}
 
$fp = @fsockopen ($G5ip, $G5port, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(s5, KATAR 5: <font color=red>Offline</font> (Players 0)<br/>
@fclose($fp);
} else {
$tpl->Assign(s5, KATAR 5: <font color=green>Online</font> (Players .$z5[0].)<br/>
@fclose($fp);
}
 
$fp = @fsockopen ($G6ip, $G6port, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(s6, KATAR 6: <font color=red>Offline</font> (Players 0)<br/>
@fclose($fp);
} else {
$tpl->Assign(s6, KATAR 6: <font color=green>Online</font> (Players .$z6[0].)<br/>
@fclose($fp);
}
 

$query = sprintf("SELECT count(*) FROM %s.t_users WHERE a_end_date BETWEEN DATE_SUB(NOW(), INTERVAL 30 DAY) AND NOW()", $auth);
$dbh = $pdo->prepare( $query );
$dbh->execute();
$gfrt = $dbh->fetch();
$curr_act = $gfrt[0];
$tpl->Assign(curr_act, Active accounts within the last 30 days: <font color=orange>.$curr_act.</font><br/>
$query = sprintf("SELECT count(*) FROM %s.t_users WHERE a_end_date BETWEEN DATE_SUB(NOW(), INTERVAL 7 DAY) AND NOW()", $auth);
$dbh = $pdo->prepare( $query );
$dbh->execute();
$gfrt = $dbh->fetch();
$curr_act1 = $gfrt[0];
$tpl->Assign(curr_act1, Active accounts within the last 7 days: <font color=orange>.$curr_act1.</font><br/>

 

TPL calls for the above code

 

<center>
<h1>Server Status</h1>
<br/><br/>
 
{curr_act}{curr_act1}
<font size=4>Current online players: <font color=orange>{TotalOnS1}</font></font><br/><br/>
 
{login}{mall}{s1}{s2}{s3}{s4}{s5}{s6}<br/>
</center>