1 files changed, 76 insertions, 0 deletions
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);
+     }
+}
+?>