From b4d3854cd2892f51ac34e69a73c36588d625f818 Mon Sep 17 00:00:00 2001 From: James Atkinson 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 +++++- phpBB/includes/page_header.php | 2 +- 2 files changed, 6 insertions(+), 2 deletions(-) (limited to 'phpBB/includes') 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 diff --git a/phpBB/includes/page_header.php b/phpBB/includes/page_header.php index 853e8abc65..b54f386b62 100644 --- a/phpBB/includes/page_header.php +++ b/phpBB/includes/page_header.php @@ -215,7 +215,7 @@ $template->assign_vars(array( "S_LOGIN_ACTION" => append_sid("login.$phpEx"), "S_JUMPBOX_ACTION" => append_sid("viewforum.$phpEx"), "S_LAST_VISIT_DATE" => $s_last_visit, - "s_CURRENT_TIME" => create_date($board_config['default_dateformat'], $current_time, $board_config['default_timezone']), + "S_CURRENT_TIME" => create_date($board_config['default_dateformat'], time(), $board_config['default_timezone']), "T_HEAD_STYLESHEET" => $theme['head_stylesheet'], "T_BODY_BACKGROUND" => $theme['body_background'], -- cgit v1.2.1