$title)); $sortorder = getStringFromRequest('sortorder', 'group_name'); $sortorder = util_ensure_value_in_set($sortorder, array('group_name', 'register_time', 'unix_group_name', 'is_public', 'is_external', 'members')); $res = db_query_params('SELECT group_name,register_time,unix_group_name,groups.group_id,is_public,is_external,status, COUNT(user_group.group_id) AS members FROM groups LEFT JOIN user_group ON user_group.group_id=groups.group_id WHERE status=$1 GROUP BY group_name,register_time,unix_group_name,groups.group_id,is_public,is_external,status ORDER BY ' . $sortorder, array('A')); $headers = array( _('Project Name'), _('Project Register Time'), _('Unix name'), _('Public?') ); if (forge_get_config('allow_external')) { $headers[] = _("External?"); } $headers[] = _('Members'); $headers[] = _('Upgrade'); $headerLinks = array( '/wiki/wikilist.php?sortorder=group_name', '/wiki/wikilist.php?sortorder=register_time', '/wiki/wikilist.php?sortorder=unix_group_name', '/wiki/wikilist.php?sortorder=is_public'); if (forge_get_config('allow_external')) { $headerLinks[] = '?sortorder=is_external'; } $headerLinks[] = '/wiki/wikilist.php?sortorder=members'; $headerLinks[] = ''; echo $HTML->listTableTop($headers, $headerLinks); $i = 0; while ($grp = db_fetch_array($res)) { $project = group_get_object($grp['group_id']); if ($project->usesPlugin("wiki")) { $time_display = ""; if ($grp['register_time'] != 0) { $time_display = date(_('Y-m-d H:i'), $grp['register_time']); } echo 'boxGetAltRowStyle($i) . '>'; echo '' . $grp['group_name'] . ''; echo '' . $time_display . ''; echo '' . $grp['unix_group_name'] . ''; echo '' . $grp['is_public'] . ''; if (forge_get_config('allow_external')) { echo '' . $grp['is_external'] . ''; } echo '' . $grp['members'] . ''; echo '' . _("Upgrade") . ''; echo ''; $i++; } } echo $HTML->listTableBottom(); site_admin_footer(array());