1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
<?php
/**
* GForge object
*
* Provides some top-level information about the GForge installation.
*
* This file is part of GForge.
*
* GForge 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.
*
* GForge is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with GForge; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
class GForge extends Error {
/**
* GForge - GForge object constructor
*/
function GForge() {
$this->Error();
return true;
}
function getNumberOfHostedProjects() {
$res=db_query("SELECT count(*) AS count FROM groups WHERE status='A' AND is_public=1");
if (!$res || db_numrows($res) < 1) {
$this->setError('Unable to get hosted project count: '.db_error());
return false;
}
return $this->parseCount($res);
}
function getNumberOfActiveUsers() {
$res = db_query("SELECT count(*) AS count FROM users WHERE status='A' and user_id != 100");
if (!$res || db_numrows($res) < 1) {
$this->setError('Unable to get user count: '.db_error());
return false;
}
return $this->parseCount($res);
}
function getPublicProjectNames() {
$res = db_query("SELECT unix_group_name FROM groups WHERE status='A' AND is_public=1");
if (!$res) {
$this->setError('Unable to get list of public projects: '.db_error());
return false;
}
$rows=db_numrows($res);
$result = array();
for ($i=0; $i<$rows; $i++) {
$result[$i] = db_result($res, $i, 'unix_group_name');
}
return $result;
}
function parseCount($res) {
$row_count = db_fetch_array($res);
return $row_count['count'];
}
}
// Local Variables:
// mode: php
// c-file-style: "bsd"
// End:
?>
|
