Active accounts - Printable Version

Active accounts - Printable Version

+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Website Scripting & Security (https://lckb.dev/forum/forumdisplay.php?fid=197)
+---- Forum: LastChaos - CMS (https://lckb.dev/forum/forumdisplay.php?fid=182)
+----- Forum: ToXiC Support (https://lckb.dev/forum/forumdisplay.php?fid=206)
+----- Thread: Active accounts (/showthread.php?tid=3654)

- Sutz - 03-15-2014

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: Offline<br/&gt Wink

;
@fclose($fp);
} else {
$tpl->Assign(login, LOGIN SERVER: Online<br/&gt Wink

;
@fclose($fp);
}

$fp = @fsockopen ($Bip, $Bport, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(mall, BILLING SERVER: Offline<br/&gt Wink

;
@fclose($fp);
} else {
$tpl->Assign(mall, BILLING SERVER: Online<br/&gt Wink

;
@fclose($fp);
}

$fp = @fsockopen ($G1ip, $G1port, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(s1, KATAR 1: Offline (Players 0)<br/&gt Wink

;
@fclose($fp);
} else {
$tpl->Assign(s1, KATAR 1: Online (Players .$z1[0].)<br/&gt Wink

;
@fclose($fp);
}

$fp = @fsockopen ($G2ip, $G2port, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(s2, KATAR 2: Offline (Players 0)<br/&gt Wink

;
@fclose($fp);
} else {
$tpl->Assign(s2, KATAR 2: Online (Players .$z2[0].)<br/&gt Wink

;
@fclose($fp);
}

$fp = @fsockopen ($G3ip, $G3port, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(s3, KATAR 3: Offline (Players 0)<br/&gt Wink

;
@fclose($fp);
} else {
$tpl->Assign(s3, KATAR 3: Online (Players .$z3[0].)<br/&gt Wink

;
@fclose($fp);
}

$fp = @fsockopen ($G4ip, $G4port, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(s4, KATAR 4: Offline (Players 0)<br/&gt Wink

;
@fclose($fp);
} else {
$tpl->Assign(s4, KATAR 4: Online (Players .$z4[0].)<br/&gt Wink

;
@fclose($fp);
}

$fp = @fsockopen ($G5ip, $G5port, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(s5, KATAR 5: Offline (Players 0)<br/&gt Wink

;
@fclose($fp);
} else {
$tpl->Assign(s5, KATAR 5: Online (Players .$z5[0].)<br/&gt Wink

;
@fclose($fp);
}

$fp = @fsockopen ($G6ip, $G6port, $errno, $errstr, $ptime);
if (!$fp) {
$tpl->Assign(s6, KATAR 6: Offline (Players 0)<br/&gt Wink

;
@fclose($fp);
} else {
$tpl->Assign(s6, KATAR 6: Online (Players .$z6[0].)<br/&gt Wink

;
@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: .$curr_act.<br/&gt Wink

;
$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: .$curr_act1.<br/&gt Wink

;

TPL calls for the above code

<center>
<h1>Server Status</h1>
 

{curr_act}{curr_act1}
Current online players: {TotalOnS1} 

{login}{mall}{s1}{s2}{s3}{s4}{s5}{s6} 
</center>