/[drupal]/contributions/modules/members/members.module
ViewVC logotype

Diff of /contributions/modules/members/members.module

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.35, Sat Nov 13 01:48:20 2004 UTC revision 1.36, Wed Nov 24 22:03:32 2004 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: members.module,v 1.34 2004/11/11 23:22:46 walkah Exp $  // $Id: members.module,v 1.35 2004/11/13 01:48:20 walkah Exp $
3    
4  function members_help($section) {  function members_help($section) {
5    switch ($section) {    switch ($section) {
# Line 66  function members_page($rids = null) { Line 66  function members_page($rids = null) {
66        }        }
67    
68        foreach ($roles as $rid) {        foreach ($roles as $rid) {
69          $list[] = "'" . check_query($rid) ."'";          $list[] = "'" . db_escape_string($rid) ."'";
70        }        }
71        $list = implode(',', $list);        $list = implode(',', $list);
72    
# Line 74  function members_page($rids = null) { Line 74  function members_page($rids = null) {
74        $sort = tablesort_get_order($header);        $sort = tablesort_get_order($header);
75        if ($sort['sql'] == 'p.value') {        if ($sort['sql'] == 'p.value') {
76          $fieldid = db_result(db_query("SELECT fid FROM {profile_fields} WHERE name='%s'",substr(array_search($sort['name'], $fields), 8)));          $fieldid = db_result(db_query("SELECT fid FROM {profile_fields} WHERE name='%s'",substr(array_search($sort['name'], $fields), 8)));
77          $query.= " LEFT JOIN {profile_values} p ON u.uid=p.uid WHERE (p.fid = '". check_query($fieldid). "' OR p.fid IS NULL) AND";          $query.= " LEFT JOIN {profile_values} p ON u.uid=p.uid WHERE (p.fid = '". db_escape_string($fieldid). "' OR p.fid IS NULL) AND";
78        }        }
79        else {        else {
80          $query.= " WHERE";          $query.= " WHERE";
Legend:
Removed from v.1.35  
changed lines
  Added in v.1.36
  ViewVC Help
Powered by ViewVC 1.1.2