FilesExpand file tree

 main

/

stats.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

19 lines (15 loc) · 798 Bytes

 main

/

stats.php

Copy path

Top

File metadata and controls

• Code
• Blame

19 lines (15 loc) · 798 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

<?php

header("Access-Control-Allow-Origin: *");

header('Content-Type: application/json; charset=utf-8');

include 'includes/misc/autoload.phtml';

$row = misc\cache\fetch('KeyAuthStats', "SELECT FORMAT((SELECT COUNT(*) FROM `accounts`), '') AS 'numAccs', FORMAT((SELECT COUNT(DISTINCT `ip`,`app`) FROM `sessions` WHERE `validated` = 1 AND `expiry` > ?), '') AS 'numOnlineUsers', FORMAT((SELECT COUNT(*) FROM `keys`), '') AS 'numKeys', FORMAT((SELECT COUNT(*) FROM `apps`), '') AS 'numApps';", [time()], 0, 3600, "i");

$numAccs = $row['numAccs'];

$numOnlineUsers = $row['numOnlineUsers'];

$numApps = $row['numApps'];

$numKeys = $row['numKeys'];

die(json_encode(array(

"accounts" => $numAccs,

"applications" => $numApps,

"licenses" => $numKeys,

"activeUsers" => $numOnlineUsers

)));