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);
?>
Statistics
There are currently registered accounts.
There are forum posts.
There are read forum topics.
There are sent private messages.
There are items being worn.
There are forum topics.
There are forum replies.
There are banned users.
There are unbanned users.
There are catalog items.
There are staff members.
If we count this all up, we get the number .