From bdc74cfc54359d480a9510887f5ff82e03092d67 Mon Sep 17 00:00:00 2001 From: Roland Mas Date: Wed, 10 Feb 2010 08:38:41 +0000 Subject: [PATCH] Remove db_query() invocations from the accessibility patches --- gforge/www/include/project_home.php | 4 ++-- gforge/www/project/admin/index.php | 7 ++++--- 2 files changed, 6 insertions(+), 5 deletions(-) diff --git a/gforge/www/include/project_home.php b/gforge/www/include/project_home.php index b3852bf16f..2912469ae6 100644 --- a/gforge/www/include/project_home.php +++ b/gforge/www/include/project_home.php @@ -381,8 +381,8 @@ if ($project->usesPm()) { $link_content = $HTML->getPmPic('') . ' ' . _('Task Manager'); print util_make_link( '/pm/?group_id='.$group_id, $link_content); - $sql="SELECT * FROM project_group_list WHERE group_id='$group_id' AND is_public=1"; - $result = db_query ($sql); + $result = db_query_params ('SELECT * FROM project_group_list WHERE group_id=$1 AND is_public=1', + $array ($group_id)); $rows = db_numrows($result); if (!$result || $rows < 1) { echo '
'._('There are no public subprojects available').''; diff --git a/gforge/www/project/admin/index.php b/gforge/www/project/admin/index.php index dca17186ff..f218b4fdab 100644 --- a/gforge/www/project/admin/index.php +++ b/gforge/www/project/admin/index.php @@ -273,7 +273,7 @@ echo $HTML->boxBottom(); boxTop(_('Group Members')); + echo $HTML->boxTop(_('Project Members')); /* @@ -281,11 +281,12 @@ echo $HTML->boxBottom(); */ - $res_memb = db_query("SELECT users.realname,users.user_id,users.status, + $res_memb = db_query_params ('SELECT users.realname,users.user_id,users.status, users.user_name,user_group.admin_flags,user_group.role_id FROM users,user_group WHERE users.user_id=user_group.user_id - AND user_group.group_id='$group_id' ORDER BY users.lastname,users.firstname"); + AND user_group.group_id=$1 ORDER BY users.lastname,users.firstname', + array ($group_id)); echo ' -- 2.30.2