GeezerVison is showing github.com — KeyAuth-Source-Code/stats.php at main · devsprojects/KeyAuth-Source-Code

Expand file tree

stats.php

Copy path

More file actions

49 lines (33 loc) · 1.24 KB

Copy path

49 lines (33 loc) · 1.24 KB

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

<?php

include 'includes/connection.php';

// database stats

$result = mysqli_query($link,"select count(1) FROM `accounts`");

$row = mysqli_fetch_array($result);

$accs = number_format($row[0]);

$result = mysqli_query($link,"select count(1) FROM `apps`");

$row = mysqli_fetch_array($result);

$apps = number_format($row[0]);

$result = mysqli_query($link,"select count(1) FROM `keys`");

$row = mysqli_fetch_array($result);

$keys = number_format($row[0]);

mysqli_close($link);

// availability stats

$url = "https://stats.uptimerobot.com/api/getMonitorList/2DrzGFk4PY"; // uptimerobot status page https://stats.uptimerobot.com/2DrzGFk4PY

$curl = curl_init($url);

curl_setopt($curl, CURLOPT_URL, $url);

curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);

curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);

curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);

$resp = curl_exec($curl);

$json = json_decode($resp);

$discord = $json->psp->monitors[0]->{'30dRatio'}->ratio;

$website = $json->psp->monitors[1]->{'30dRatio'}->ratio;

$avgUptime = number_format(array_sum(array($discord, $website)) / 2,2, '.', '');

// output JSON

die(json_encode(array(

"accounts" => $accs,

"applications" => $apps,

"licenses" => $keys,

"uptime" => $avgUptime

)));