From e2271f9a41f2f829bef6c075be8a55a891bea4ce Mon Sep 17 00:00:00 2001 From: Anthony Parsons Date: Wed, 23 Nov 2005 22:28:20 +0000 Subject: [PATCH] Cleanup of stuff.php --- stuff.php | 48 +++++++++++++++++++++++------------------------- 1 file changed, 23 insertions(+), 25 deletions(-) diff --git a/stuff.php b/stuff.php index 26762aa..456a5f0 100644 --- a/stuff.php +++ b/stuff.php @@ -3,14 +3,9 @@ require 'con.php'; -usleep(100000); //DoS protection, the stats code is shitty - $page->title = 'Stats and Stuff'; - $user->userheader(); -$a = 1; - $date = array( 'today' => mktime(0, 0, 0), 'week' => mktime(0, 0, 0) - 86400*(gmdate('w')-1), @@ -36,7 +31,7 @@ function getrow($sql) Board Statistics - + @@ -48,46 +43,49 @@ function getrow($sql) - Today - This week - This month - Last 24 hours - Last 7 days - Last 30 days - Total + Today + This week + This month + Last 24 hours + Last 7 days + Last 30 days + Total - - Posts + All messages ',getrow('SELECT COUNT(*) AS `result` FROM `messages` WHERE `mtime` > %d'),' ',$DB->query('SELECT COUNT(*) AS `result` FROM `messages`')->fetch_object()->result,' - Replies + Replies only ',getrow('SELECT COUNT(*) AS `result` FROM `messages` WHERE `replyto` IS NOT NULL AND `mtime` > %d'),' ',$DB->query('SELECT COUNT(*) AS `result` FROM `messages` WHERE `replyto` IS NOT NULL')->fetch_object()->result,' - Topics + Topics ',getrow('SELECT COUNT(DISTINCT(`topicid`)) AS `result` FROM `messages` WHERE `mtime` > %d'),' ',$DB->query('SELECT COUNT(*) AS `result` FROM `topics`')->fetch_object()->result,' - Users + Total users ',getrow('SELECT COUNT(*) AS `result` FROM `users` WHERE `register_date` > %d'),' ',$DB->query('SELECT COUNT(*) AS `result` FROM `users`')->fetch_object()->result,' - Online Users + Online users ',getrow('SELECT COUNT(`userid`) AS `result` FROM `users` WHERE `last_active_date` > `register_date` AND `last_active_date` > %d'),' ',$DB->query('SELECT COUNT(*) AS `result` FROM `users` @@ -95,18 +93,18 @@ function getrow($sql) - Active Users - ',getrow('SELECT COUNT(DISTINCT(`users`.`userid`)) AS `result` FROM `users` NATURAL LEFT JOIN `messages` - WHERE `messages`.`mtime` > %d'),' + Active users + ',getrow('SELECT COUNT(DISTINCT(`users`.`userid`)) AS `result` FROM `users` + NATURAL LEFT JOIN `messages` + WHERE `messages`.`mtime` > %d'),' ',$DB->query('SELECT COUNT(DISTINCT(`users`.`userid`)) AS `result` - FROM `users` NATURAL LEFT JOIN `messages`')->fetch_object()->result; ?> + FROM `users` NATURAL LEFT JOIN `messages`')->fetch_object()->result ?> -

Stuff

-

Terms of Service

+

Terms of Service