From b4d3854cd2892f51ac34e69a73c36588d625f818 Mon Sep 17 00:00:00 2001 From: James Atkinson <thefinn@users.sourceforge.net> Date: Wed, 13 Jun 2001 08:32:32 +0000 Subject: Added a count of total number of topics to the get_db_stats function git-svn-id: file:///svn/phpbb/trunk@485 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/includes/functions.php | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'phpBB/includes/functions.php') diff --git a/phpBB/includes/functions.php b/phpBB/includes/functions.php index 72d48c1bf0..d35ca75ac4 100644 --- a/phpBB/includes/functions.php +++ b/phpBB/includes/functions.php @@ -45,6 +45,10 @@ function get_db_stat($mode) ORDER BY user_id DESC LIMIT 1"; break; + case 'topiccount': + $sql = "SELECT SUM(forum_topics) AS total + FROM ".FORUMS_TABLE; + break; } @@ -427,7 +431,7 @@ function validate_username($username) // a UNION clause which would be very nice here :( // So we have to use two queries case 'mysql': - $sql_users = "SELECT group_name AS username + $sql_users = "SELECT group_name AS username FROM " . GROUPS_TABLE . " WHERE LOWER(group_name) = '" . strtolower($username) . "'"; $sql_disallow = "SELECT disallow_username -- cgit v1.2.1