From ae7023d024cd323122e6d6eb734892235b7feb1a Mon Sep 17 00:00:00 2001
From: James Atkinson <thefinn@users.sourceforge.net>
Date: Fri, 23 Feb 2001 01:32:02 +0000
Subject: Added misc functions file
git-svn-id: file:///svn/phpbb/trunk@24 89ea8834-ac86-4346-8a33-228a782c2dd0
---
phpBB/functions/functions.php | 76 +++++++++++++++++++++++++++++++++++++++++++
1 file changed, 76 insertions(+)
create mode 100644 phpBB/functions/functions.php
(limited to 'phpBB/functions')
diff --git a/phpBB/functions/functions.php b/phpBB/functions/functions.php
new file mode 100644
index 0000000000..30356ff148
--- /dev/null
+++ b/phpBB/functions/functions.php
@@ -0,0 +1,76 @@
+<?php
+/***************************************************************************
+ * functions.php
+ * -------------------
+ * begin : Saturday, Feb 13, 2001
+ * copyright : (C) 2001 The phpBB Group
+ * email : support@phpbb.com
+ *
+ * $Id$
+ *
+ *
+ ***************************************************************************/
+
+
+/***************************************************************************
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or
+ * (at your option) any later version.
+ *
+ *
+ ***************************************************************************/
+
+function get_total_posts($db, $forums_table)
+{
+ $sql = "SELECT sum(forum_posts) AS total FROM ".FORUMS_TABLE;
+ if(!$result = $db->sql_query($sql))
+ {
+ return "ERROR";
+ }
+ else
+ {
+ $rowset = $db->sql_fetchrowset($result);
+ return($rowset[0]["total"]);
+ }
+}
+
+function get_user_count($db)
+{
+ $sql = "SELECT count(user_id) AS total
+ FROM ". USERS_TABLE ."
+ WHERE user_id != ".ANONYMOUS."
+ AND user_level != ".DELETED;
+
+ if(!$result = $db->sql_query($sql))
+ {
+ return "ERROR";
+ }
+ else
+ {
+ $rowset = $db->sql_fetchrowset($result);
+ return($rowset[0]["total"]);
+ }
+}
+
+function get_newest_user($db)
+{
+ $sql = "SELECT user_id, username
+ FROM ".USERS_TABLE."
+ WHERE user_id != " . ANONYMOUS. "
+ AND user_level != ". DELETED ."
+ ORDER BY user_id DESC LIMIT 1";
+ if(!$result = $db->sql_query($sql))
+ {
+ return array("user_id" => "-1", "username" => "ERROR");
+ }
+ else
+ {
+ $rowset = $db->sql_fetchrowset($result);
+ $return_data = array("user_id" => $rowset[0]["user_id"],
+ "username" => $rowset[0]["username"]);
+ return($return_data);
+ }
+}
+?>
--
cgit v1.2.1