83 lines
2.7 KiB
PHP
83 lines
2.7 KiB
PHP
<?php
|
|
include_once $_SERVER['DOCUMENT_ROOT'].'/core/func/includes.php';
|
|
if (!$GLOBALS['loggedIn']) {
|
|
header("Location: /");
|
|
exit;
|
|
}
|
|
if ($GLOBALS['userTable']['rank'] == 0) {
|
|
header("Location: /");
|
|
exit;
|
|
}
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<title><?php echo config::getName();?> | Statistics</title>
|
|
<?php html::buildHead();?>
|
|
</head>
|
|
<body>
|
|
<?php html::getNavigation();?>
|
|
<div class="container">
|
|
<?php
|
|
$stmt = $dbcon->prepare("SELECT id FROM users;");
|
|
$stmt->execute();
|
|
$amusers = $stmt->rowCount();
|
|
|
|
$stmt = $dbcon->prepare("SELECT id FROM users WHERE banned = 1;");
|
|
$stmt->execute();
|
|
$busers = $stmt->rowCount();
|
|
|
|
$stmt = $dbcon->prepare("SELECT id FROM users WHERE banned = 0;");
|
|
$stmt->execute();
|
|
$ubusers = $stmt->rowCount();
|
|
|
|
$stmt = $dbcon->prepare("SELECT id FROM topics");
|
|
$stmt->execute();
|
|
$topcount = $stmt->rowCount();
|
|
|
|
$stmt = $dbcon->prepare("SELECT id FROM replies");
|
|
$stmt->execute();
|
|
$repcount = $stmt->rowCount();
|
|
|
|
$totalp = ($topcount + $repcount);
|
|
|
|
$stmt = $dbcon->prepare("SELECT id FROM users WHERE rank > 0;");
|
|
$stmt->execute();
|
|
$staffc = $stmt->rowCount();
|
|
|
|
$stmt = $dbcon->prepare("SELECT id FROM catalog");
|
|
$stmt->execute();
|
|
$catcount = $stmt->rowCount();
|
|
|
|
$stmt = $dbcon->prepare("SELECT id FROM `read`");
|
|
$stmt->execute();
|
|
$readc = $stmt->rowCount();
|
|
|
|
$stmt = $dbcon->prepare("SELECT id FROM `wearing`");
|
|
$stmt->execute();
|
|
$wearc = $stmt->rowCount();
|
|
|
|
$stmt = $dbcon->prepare("SELECT id FROM `messages`");
|
|
$stmt->execute();
|
|
$messagecount = $stmt->rowCount();
|
|
|
|
$total = ($amusers + $busers + $ubusers + $topcount + $repcount + $totalp + $staffc + $catcount + $readc + $wearc + $messagecount);
|
|
?>
|
|
<h4 style="color:grey;">Statistics</h4>
|
|
There are currently <b><?php echo $amusers;?></b> registered accounts.<br>
|
|
There are <b><?php echo $totalp;?></b> forum posts.<br>
|
|
There are <b><?php echo $readc;?></b> read forum topics.<br>
|
|
There are <b><?php echo $messagecount;?></b> sent private messages.<br>
|
|
There are <b><?php echo $wearc;?></b> items being worn.<br>
|
|
There are <b><?php echo $topcount;?></b> forum topics.<br>
|
|
There are <b><?php echo $repcount;?></b> forum replies.<br>
|
|
There are <b><?php echo $busers;?></b> banned users.<br>
|
|
There are <b><?php echo $ubusers;?></b> unbanned users.</br>
|
|
There are <b><?php echo $catcount;?></b> catalog items.</br>
|
|
There are <b><?php echo $staffc;?></b> staff members.</br>
|
|
|
|
If we count this all up, we get the number <b><?php echo $total;?></b>.
|
|
</div>
|
|
<?php html::buildFooter();?>
|
|
</body>
|
|
</html>
|