diff options
| author | James Atkinson <thefinn@users.sourceforge.net> | 2001-02-23 01:32:02 +0000 |
|---|---|---|
| committer | James Atkinson <thefinn@users.sourceforge.net> | 2001-02-23 01:32:02 +0000 |
| commit | ae7023d024cd323122e6d6eb734892235b7feb1a (patch) | |
| tree | 69ae476b1b26307378b999ad7121ec3f486286d6 /phpBB/functions/functions.php | |
| parent | 693d62c521921c5b4809f940ed3fbb6ac1aeab86 (diff) | |
| download | forums-ae7023d024cd323122e6d6eb734892235b7feb1a.tar forums-ae7023d024cd323122e6d6eb734892235b7feb1a.tar.gz forums-ae7023d024cd323122e6d6eb734892235b7feb1a.tar.bz2 forums-ae7023d024cd323122e6d6eb734892235b7feb1a.tar.xz forums-ae7023d024cd323122e6d6eb734892235b7feb1a.zip | |
Added misc functions file
git-svn-id: file:///svn/phpbb/trunk@24 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/functions/functions.php')
| -rw-r--r-- | phpBB/functions/functions.php | 76 |
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); + } +} +?> |