// #######################################
- print '<p>'. (isset($discrim_desc) ? $discrim_desc : '') . '</p>';
+ if (!empty($discrim_desc))
+ print '<p>'.$discrim_desc.'</p>';
// ######## two column table for key on right
// first print all parent cats and current cat
SELECT trove_cat.trove_cat_id AS trove_cat_id,
trove_cat.fullname AS fullname,
trove_treesums.subprojects AS subprojects
- FROM trove_cat LEFT JOIN trove_treesums USING (trove_cat_id)
+ FROM trove_cat LEFT JOIN trove_treesums USING (trove_cat_id)
WHERE (
- trove_treesums.limit_1=0
+ trove_treesums.limit_1=0
OR trove_treesums.limit_1 IS NULL
) AND trove_cat.parent=$1
ORDER BY fullname',
print '<li class="current-cat">' . $row_rootcat['fullname'] . "</li>\n";
} else {
print "<li>";
- print util_make_link ('/softwaremap/trove_list.php?cat=c&form_cat=' .$row_rootcat['trove_cat_id'].$discrim_url, $row_rootcat['fullname']);
+ print util_make_link ('/softwaremap/trove_list.php?cat=c&form_cat=' .$row_rootcat['trove_cat_id'].$discrim_url, $row_rootcat['fullname']);
print "</li>\n";
}
}
$qpa = db_construct_qpa($qpa, ' WHERE trove_agg.trove_cat_id=$1', array($form_cat));
$qpa = db_join_qpa($qpa, $qpa_and);
$qpa = db_construct_qpa($qpa, ' ORDER BY trove_agg.trove_cat_id ASC, trove_agg.ranking ASC');
- $res_grp = db_query_qpa($qpa, $TROVE_HARDQUERYLIMIT, 0, DB_TROVE);
-
+ $res_grp = db_query_qpa($qpa, $TROVE_HARDQUERYLIMIT, 0, 'SYS_DB_TROVE');
+
$projects = array();
while ($row_grp = db_fetch_array($res_grp)) {
if (!forge_check_perm ('project_read', $row_grp['group_id'])) {
$projects[] = $row_grp;
}
$querytotalcount = count($projects);
-
+
// #################################################################
// limit/offset display
if ($querytotalcount == $TROVE_HARDQUERYLIMIT) {
$html_limit .= 'More than ';
$html_limit .= sprintf(_('More than <strong>%1$s</strong> projects in result set.'), $querytotalcount);
-
+
}
$html_limit .= sprintf(ngettext('<strong>%1$s</strong> project in result set.', '<strong>%1$s</strong> projects in result set.', $querytotalcount), $querytotalcount);
-
+
// only display pages stuff if there is more to display
if ($querytotalcount > $TROVE_BROWSELIMIT) {
$html_limit .= ' Displaying '.$TROVE_BROWSELIMIT.' per page. Projects sorted by activity ranking.<br />';
$html_limit .= ' ';
}
}
-
+
print $html_limit."<hr />\n";
// #################################################################
// print actual project listings
for ($i_proj=0;$i_proj<$querytotalcount;$i_proj++) {
$row_grp = $projects[$i_proj];
-
+
// check to see if row is in page range
if (($i_proj >= (($page-1)*$TROVE_BROWSELIMIT)) && ($i_proj < ($page*$TROVE_BROWSELIMIT))) {
$viewthisrow = 1;
} else {
$viewthisrow = 0;
- }
-
+ }
+
if ($row_grp && $viewthisrow) {
print '<table border="0" cellpadding="0" width="100%"><tr valign="top"><td colspan="2">';
print "$i_proj. " ;
if ($row_grp['short_description']) {
print "- " . htmlspecialchars($row_grp['short_description']);
}
-
+
print '<br /> ';
// extra description
print "</td></tr>\n<tr valign=\"top\"><td>";
SELECT trove_cat_id,fullname
FROM trove_cat
WHERE parent=$1
- AND trove_cat_id!=0;", array($mynode), -1, 0, 'DB_TROVE');
+ AND trove_cat_id!=0;", array($mynode), -1, 0, 'SYS_DB_TROVE');
while ($row_child = db_fetch_array($res_child)) {
trove_genfullpaths($row_child['trove_cat_id'],
SELECT trove_cat_id
FROM trove_cat
WHERE parent=$1
- AND trove_cat_id!=0;", array($mynode), -1, 0, 'DB_TROVE');
+ AND trove_cat_id!=0;", array($mynode), -1, 0, 'SYS_DB_TROVE');
while ($row_child = db_fetch_array($res_child)) {
trove_updaterootparent($row_child['trove_cat_id'],$rootnode);
$res_verifycat = db_query_params("
SELECT trove_cat_id,fullpath_ids
FROM trove_cat
- WHERE trove_cat_id=$1", array($trove_cat_id), -1, 0, 'DB_TROVE');
+ WHERE trove_cat_id=$1", array($trove_cat_id), -1, 0, 'SYS_DB_TROVE');
if (db_numrows($res_verifycat) != 1) return 1;
$row_verifycat = db_fetch_array($res_verifycat);