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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
|
<?php
//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2001 (c) VA Linux Systems
// http://sourceforge.net
//
// $Id: features_boxes.php 3444 2004-10-08 22:53:36Z gsmet $
//
require_once('common/include/GForge.class');
function show_features_boxes() {
GLOBAL $HTML,$Language;
$return = '';
$return .= $HTML->boxTop($Language->getText('home','gforge_statistics', $GLOBALS['sys_name']),0);
$return .= show_sitestats();
$return .= $HTML->boxMiddle($Language->getText('home','top_project_downloads'));
$return .= show_top_downloads();
$return .= $HTML->boxMiddle($Language->getText('home','highest_ranked_users'));
$return .= show_highest_ranked_users();
$return .= $HTML->boxMiddle($Language->getText('home','most_active_this_week'));
$return .= show_highest_ranked_projects();
$return .= $HTML->boxMiddle($Language->getText('home','recently_registered'));
$return .= show_newest_projects();
$return .= $HTML->boxBottom(0);
return $return;
}
function show_top_downloads() {
global $Language;
// TODO yesterday is now defined as two days ago. Quick fix
// to allow download list to be cached before nightly
// aggregation is done. jbyers 2001.03.19
//
$month = date("Ym",time()-(2*3600*24));
$day = date("d",time()-(2*3600*24));
$res_topdown = db_query("
SELECT groups.group_id,
groups.group_name,
groups.unix_group_name,
frs_dlstats_grouptotal_vw.downloads
FROM frs_dlstats_grouptotal_vw,groups
WHERE
frs_dlstats_grouptotal_vw.group_id=groups.group_id AND groups.is_public='1' and groups.status='A'
ORDER BY downloads DESC
", 10, 0, SYS_DB_STATS);
// echo db_error();
if (db_numrows($res_topdown) == 0) {
return $Language->getText('home','no_stats_available');
}
// print each one
$return = "";
while ($row_topdown = db_fetch_array($res_topdown)) {
if ($row_topdown['downloads'] > 0)
$return .= "(" . number_format($row_topdown['downloads']) . ') <a href="/projects/'.$row_topdown['unix_group_name'].'/">'
. $row_topdown['group_name']."</a><br />\n";
}
$return .= '<div align="center"><a href="/top/">[ '.$Language->getText('general','more').' ]</a></div>';
return $return;
}
function stats_getprojects_active_public() {
$res_count = db_query("SELECT count(*) AS count FROM groups WHERE status='A' AND is_public=1");
if (db_numrows($res_count) > 0) {
$row_count = db_fetch_array($res_count);
return $row_count['count'];
} else {
return "error";
}
}
function stats_getprojects_total() {
$res_count = db_query("SELECT count(*) AS count FROM groups WHERE status='A' OR status='H'");
if (db_numrows($res_count) > 0) {
$row_count = db_fetch_array($res_count);
return $row_count['count'];
} else {
return "error";
}
}
function stats_getpageviews_total() {
$res_count = db_query("SELECT SUM(site_views) AS site, SUM(subdomain_views) AS subdomain FROM stats_site");
if (db_numrows($res_count) > 0) {
$row_count = db_fetch_array($res_count);
return ($row_count['site'] + $row_count['subdomain']);
} else {
return "error";
}
}
function stats_downloads_total() {
$res_count = db_query("SELECT SUM(downloads) AS downloads FROM stats_site");
if (db_numrows($res_count) > 0) {
$row_count = db_fetch_array($res_count);
return $row_count['downloads'];
} else {
return "error";
}
}
function show_sitestats() {
global $Language;
$gforge = new GForge();
$return = '';
$return .= $Language->getText('home','hosted_projects').': <strong>'.number_format($gforge->getNumberOfHostedProjects()).'</strong>';
$return .= '<br />'.$Language->getText('home','registered_users').': <strong>'.number_format($gforge->getNumberOfActiveUsers()).'</strong>';
return $return;
}
function show_newest_projects() {
global $Language;
$sql = "SELECT group_id,unix_group_name,group_name,register_time FROM groups " .
"WHERE is_public=1 AND status='A' AND type_id=1 AND register_time > 0 " .
"ORDER BY register_time DESC";
$res_newproj = db_query($sql,10);
$return = '';
if (!$res_newproj || db_numrows($res_newproj) < 1) {
return $Language->getText('home','no_stats_available')." ".db_error();
} else {
while ( $row_newproj = db_fetch_array($res_newproj) ) {
$return .= "<strong>(" . date($Language->getText('home','recently_registered_date_format'),$row_newproj['register_time']) . ")</strong> "
. '<a href="/projects/'.$row_newproj['unix_group_name'].'/">'
. $row_newproj['group_name'].'</a><br />';
}
}
/// TODO: Add more link to show all project
//$return .= '<div align="center"><a href="/top/projlist.php">[ '.$Language->getText('general','more').' ]</a></div>';
return $return;
}
function show_highest_ranked_users() {
global $Language;
//select out the users information to show the top users on the site
$sql="SELECT users.user_name,users.realname,user_metric.metric
FROM user_metric,users
WHERE users.user_id=user_metric.user_id AND user_metric.ranking < 11 AND users.status != 'D'
ORDER BY ranking ASC";
$res=db_query($sql);
$rows=db_numrows($res);
if (!$res || $rows<1) {
return $Language->getText('home','no_stats_available').db_error();
} else {
$return = '';
for ($i=0; $i<$rows; $i++) {
$return .= ($i+1).' - ('. number_format(db_result($res,$i,'metric'),4) .') <a href="/users/'. db_result($res,$i,'user_name') .'">'. db_result($res,$i,'realname') .'</a><br />';
}
}
$return .= '<div align="center"><a href="/top/topusers.php">[ '.$Language->getText('general','more').' ]</a></div>';
return $return;
}
function show_highest_ranked_projects() {
global $Language;
$sql="SELECT groups.group_name,groups.unix_group_name,groups.group_id,".
"project_weekly_metric.ranking,project_weekly_metric.percentile ".
"FROM groups,project_weekly_metric ".
"WHERE groups.group_id=project_weekly_metric.group_id ".
"AND groups.is_public=1 ".
"AND groups.type_id=1 ".
"AND groups.status != 'D' ".
"ORDER BY ranking ASC";
$result=db_query($sql,20);
if (!$result || db_numrows($result) < 1) {
return $Language->getText('home','no_stats_available')." ".db_error();
} else {
while ($row=db_fetch_array($result)) {
$return .= '<strong>( '.number_format(substr($row['percentile'],0,5),1).'% )</strong>'
.' <a href="/projects/'.$row['unix_group_name'].
'/">'.$row['group_name'].'</a><br />';
}
$return .= '<div align="center"><a href="/top/mostactive.php?type=week">[ '.$Language->getText('general','more').' ]</a></div>';
}
return $return;
}
?>
|
