122
117
if (getStringFromRequest('groupsearch')) {
123
118
$status = getStringFromRequest('status');
124
119
$is_public = getIntFromRequest('is_public', -1);
125
$crit_desc = getStringFromRequest('crit_desc');
121
$qpa = db_construct_qpa () ;
123
if(is_numeric($search)) {
124
$qpa = db_construct_qpa ($qpa, 'SELECT DISTINCT * FROM groups
125
WHERE (group_id=$1 OR lower (unix_group_name) LIKE $2 OR lower (group_name) LIKE $2)',
127
strtolower ("%$search%"))) ;
129
$qpa = db_construct_qpa ($qpa, 'SELECT DISTINCT * FROM groups WHERE (lower (unix_group_name) LIKE $1 OR lower (group_name) LIKE $1)',
130
array (strtolower ("%$search%"))) ;
129
$crit_sql .= " AND status='$status'";
134
$qpa = db_construct_qpa ($qpa, ' AND status=$1', array ($status)) ;
130
135
$crit_desc .= " status=$status";
132
if ($is_public !== -1) {
133
$crit_sql .= " AND is_public='$is_public'";
137
if ($is_public != -1) {
138
$qpa = db_construct_qpa ($qpa, ' AND is_public=$1', array ($is_public)) ;
134
139
$crit_desc .= " is_public=$is_public";
139
FROM groups WHERE (";
141
if(is_numeric($search)) {
142
$result = db_query_params ('SELECT DISTINCT * FROM groups
144
OR lower (unix_group_name) LIKE $2
145
OR lower (group_name) LIKE $2',
147
strtolower ("%$search%"))) ;
149
$result = db_query_params ('SELECT DISTINCT * FROM groups
150
WHERE lower (unix_group_name) LIKE $2
151
OR lower (group_name) LIKE $2',
152
array (strtolower ("%$search%"))) ;
155
142
if ($crit_desc) {
156
$crit_desc = "($crit_desc )";
143
$crit_desc = "(".trim($crit_desc).")";
146
$result = db_query_qpa ($qpa) ;
158
147
print '<p><strong>'.sprintf(ngettext('Group search with criteria <em>%s</em>: %d match', 'Group search with criteria <em>%s</em>: %d matches', db_numrows($result)), $crit_desc, db_numrows($result)).'</strong></p>';
160
149
if (db_numrows($result) < 1) {